Variable Costs Data Sources and Usage

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

1. In the Item cell , press F5 key or click the  icon. 
   
   
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  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  icon. Now Select Source Worksheet, Select Source Column, Select Source Row, Select Adjustment and Adjust By (if any), click  tick or press F10 to save data. 
   
4. Now in the Month cell, press the F5 key or click on the Months  icon. Choose Distribute Period, Payment Code, Month, Bank Account, click tick or press F10 to save data
5. Click  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