Follow

Sheep Wool Sales & Crutching Worksheets

Use the Wool Sales and Crutching Worksheets to estimate when and how many sheep you will need shearing services for. Forecast your income from wool sales based on the value of the wool being sold.

Agrimaster copies the Stock Class and Shearing Number from Stock Reconciliation including the subtotals into the Worksheets

Wool Sales Worksheet 

1.    Stock Class

 

Agrimaster copies the Stock Class from the
Stock Reconciliation Worksheet

2.    Shearing Number

 

Agrimaster  copies the Shearing Number from the
Stock Reconciliation Worksheet

3.    Wool Cut / Head Kg

 

Type a number of kg of wool per sheep equal to the rounded amount of wool from this type of sheep

4.    Total Wool Cut Kg

 

Agrimaster calculates the total amount of wool by multiplying the Shearing Number x Wool Cut / Head Kg

5.    Return / Kg $

 

Type the dollar amount you expect to get per kg of wool you sell

6.    Total Return $

 

Agrimaster calculates the total income by multiplying the Shearing Number x Return / Kg $

7.    Month F5

 

Press F5 and choose the Month, Cash Book Code and Bank Account for the income from the sale of this wool

 

Data Entry Tips 

Enter the remaining data faster by right clicking in the next blank box down. Right click copies the same data or calculation from the box above. Copying the data or the calculation works in: 

  • Wool Cut / Head Kg
  • Return / Kg $
  • Month F5 

Crutching Worksheet 

1.    Stock Class

 

Agrimaster copies the Stock Type from the
Stock Reconciliation Worksheet

2.    Shearing Number

 

Agrimaster copies the Shearing Number from the
Stock Reconciliation Worksheet

3.    Number to Crutch

 

·         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

4.    Crutchings Cut / Head Kg

 

Type the estimated kg of wool per head of sheep in this row

5.    Total Crutchings Kg

 

Agrimaster calculates the total kg of wool from crutching by multiplying the Shearing Number x Crutchings Cut/Head Kg

6.    Return / Kg $

 

Type the expected dollar value per kg of wool sold from the crutching

7.    Total Return $

 

Agrimaster calculates the expected amount of income from the wool

8.    Month F5

 

Press F5 and choose the Month, Code and Bank Account for the income from the wool

  

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

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

Comments