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 · Select Source Column · Select Source Row · Select 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 · Select Source Column · Select Source Row · Select Adjustment · Adjust by |
|
4. Click on the green tick |
|
Comments