Follow

Variable Costs Data Sources and Usage

Item from Cost List

Source Worksheet

Source Column

Source Row

Adjustment

Crutching

Crutching

Number to Crutch

Column TOTAL

No Adjustment

Dog Costs

Do not press F5 (no link) - type Quantity

(none)

(none)

Expense data comes from Cost List

Sheep Commission

Sales

Total All Sales

Column TOTAL

No Adjustment

Sheep Selling Costs

Sales

Sell No

Column TOTAL

No Adjustment

Stock Cartage

Sales

Total All Sales

Column TOTAL

No Adjustment

Cart Fertiliser

Stock Reconciliation

Winter Grazed Ha

Column TOTAL

Multiply by 0.1 (100 kg / Ha)

Drenching

Stock Reconciliation

Shearing No or Close No

Column TOTAL

No Adjustment

Eartags

Stock Reconciliation

Nat. Inc

Lambs

No Adjustment

Feed Costs

Stock Reconciliation

Open No

Column TOTAL

No Adjustment

Jetting

Stock Reconciliation

Close No

Column TOTAL

No Adjustment

Marking

Stock Reconciliation

Nat. Inc

Lambs

No Adjustment

Shearing

Stock Reconciliation

Shearing No

Column TOTAL

No Adjustment

Spread Fertiliser

Stock Reconciliation

Winter Grazed Ha

Column TOTAL

Multiply by 0.1 (100 kg / Ha)

Super Phos

Stock Reconciliation

Winter Grazed Ha

Column TOTAL

Multiply by 0.1 (100 kg / Ha)

Cart Wool

Wool Sales

Total Wool Cut Per Kg

Column TOTAL

Divide by 180

Wool Packs

Wool Sales

Total Wool Cut Per Kg

Column TOTAL

Divide by 180

Wool Selling Costs

Wool Sales

Total Wool Cut Per Kg

Column TOTAL

No Adjustment

Wool Tax

Wool Sales

Total Return

Column TOTAL

No Adjustment

 

To enter costs into your variable costs worksheets using formulae, complete the following steps.

  1. In the Item cell mceclip0.png, press F5 key or click the mceclip1.png icon. 

    mceclip2.png
  2. In the cost list area select the List Heading (e.g. Sheep). In the List Item area select the name (e.g. Eartags ~ 0.25 Head). Add any items required using the Add New button mceclip3.png or edit the existing costs by typing over the data.  To move a single item to your worksheet, double-click the name to export.  Where there are numerous names that you wish to export at once, highlight those required with your mouse and then click the icon Copy Many to WS
  3. Now in the Quantity cell press the F5 key or click the Link mceclip4.png icon. Now Select Source Worksheet, Select Source Column, Select Source Row, Select Adjustment and Adjust By (if any), click mceclip5.png tick or press F10 to save data. 
    mceclip6.png
  4. Now in the Month cell, press the F5 key or click on the Months mceclip8.png icon. Choose Distribute Period, Payment Code, Month, Bank Account, click mceclip9.pngtick or press F10 to save data
  5. Click mceclip10.png to save the data in the Variable Costs Worksheet. 

Link to Stock Reconciliation Column Totals 

Take a look at the master Stock Reconciliation sheet. Above each column is a total in red text.

In this example, we will calculate the feed costs for the whole flock for the beginning of the reason, based on the Open No. 

  1. Click into the Quantity cell of Feed Costs 
  2. Press F5
    • Select Source Worksheet - Stock Reconciliation 
    • Select Source Column - Open No
    • Select Source Row - Column Total 
    • Select Adjustment - No Adjustment 
  3. Click on the green tick to continue

  4. The column total has been linked to the Quantity 

Note: Any changes to the numbers in the master Stock Reconciliation Worksheet will automatically be used in this box.

Divide Stock Reconciliation Totals 

Use the column totals in a calculation to estimate bundles or groupings of items. In this example, about 180 kg of wool fits into each wool pack. Agrimaster can help you calculate number of wool packs can be calculated by dividing the total amount of wool from the Shearing Worksheet 

  1. In Item F5, enter Wool Pack from the Cost List

  2. Click into the Quantity F5 box 

  3. Press F5

    •  Select Source Worksheet - Wool Sales 

    • Select Source Column - Total wool Cut Kg 

    • Select Source Row - Column Total 

    • Select Adjustment - Divide By

    • Adjust By - 180
  4. Click on the green tick 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments