Crutching Worksheet

The data from the Shearing Number has been automatically transferred from the Stock Reconciliation worksheet. Here you are required to enter the number, cut/head kg, crutching price and select the month and code. 

1. Click the first Crutching Sales cell.
2. Click and complete data in Number to Crutch, press enter.
   • Option 1: Press F5 and link to the Opening No or Closing No.
   • Option 2: Press F5 and calculate a percentage of the Opening No or Closing No for this row.
   • Option 3: Type the number of sheep to crutch for this Stock Class.
3. Type the estimated kg of wool per head of sheep in Crutching Cut/Head Kg, press enter.
4. Click and complete data in Return/Kg $, press enter.
5. When in Month column press F5 or click on the Months icon. Now select Distribute Period, Month, Receipt Code and Bank Account, click the green tick to save data.
6. Repeat this for the other Crutching Classes, remembering that you can use the repeat keys [or] if data is the same.
7. Click the green tick to save the data in the Crutching Worksheet and now progress to the Variable Costs Worksheet.   

Linking to Number of Sheep to Crutch

Link to another number in the master data in the Stock Reconciliation Worksheet. In this example, the crutching is scheduled for the beginning of your season and you want to use your Open No. 

1. Click into a box for Number to Crutch.
   
2. Press F5 and make the following selections:
   • Select Source Worksheet – choose Stock Reconciliation.
   • Select Source Column – choose Open No.
   • Select Source Row – choose the same row. 
   • Select Adjustment – choose No Adjustment.
     
3. Click on the green tick to ok the selections.

Calculating Number Of Sheep To Crutch

Agrimaster can calculate numbers. In this example, you know that you have fewer 4 Yr Ewes at the time you do the crutching. You approximate the number after sales and losses using a percentage. 

1. Click in a Number to Crutch box.
2. Press F5 and make the following selections:
   • Select Source Worksheet – choose Stock Reconciliation.
   • Select Source Column – choose Open No.
   • Select Source Row – choose 4 Yr.
   • Select Adjustment – choose Percentage of.
   • Adjust by – type a percentage (the number can be greater than 100% to increase the size).
3. Click on the green tick and note the Month and Code.
4. Enter the remaining data into the worksheet.
5. After all data is entered, click on the green tick again to save the worksheets.