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

 

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

 

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

Comments