Follow

Wool Sales 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.

mceclip0.png

The data from the SHEARING NUMBER has been automatically transferred from the STOCK RECONCILIATION worksheet.  Here you are required to enter cut/head kg, wool price via cost list and select the month and code.

  1. Click the WOOL SALES worksheet
  2. Click and complete data in CUT/HEAD KG, press enter
  3. Enter RETURN / KG $, press enter
  4. When in MONTH column press F5 or click on the MONTHS mceclip1.png icon. Now select DISTRIBUTE PERIOD, MONTH, RECEIPT CODE and BANK ACCOUNT, click mceclip2.png tick to save data
  5. Repeat this for the other Shearing Classes, remembering that you can use the repeat keys [or] if data is the same as the line above
  6. Click mceclip3.png to save the data in the Wool Sales Worksheet and now progress to the CRUTCHING WORKSHEET. 

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 

 

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

Comments