Variable Costs Data Sources and Usage – Agrimaster

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

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 season, 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

The column total has been linked to the Quantity.

Note that 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

Link to Stock Reconciliation Column Totals

Divide Stock Reconciliation Totals

Comments