Follow

Sheep Purchases & Sales Worksheets

The Sheep Purchases and Sales worksheets are used to do detailed planning of the timing and types of changes in stock. Use the Purchases and Sales worksheets to forecast the age and type of stock to be traded. Track the month and the estimated value of the stock transaction.

Agrimaster copies the data from Stock Reconciliation, including the subtotals, into the Worksheets

Purchases Worksheet 

1.    Stock Type

 

Agrimaster copies the Stock Type from the
Stock Reconciliation Worksheet

2.    Total Purchase No.

 

Agrimaster copies the Buy No. from the Stock Reconciliation Worksheet

3.    Purch #1 No.
Purch #2 No.
Purch #3 No.

 

Type the number of stock by type to purchase

For example, divide your purchase of 10 stock over 2 different months and make purchases earlier in the season

4.    Cost Per Head
(3 occurances)

 

Type the dollar amount you pay per head

5.    Total Cost
(3 occurances)

 

Agrimaster will calculate the total amount of the purchase (Purchase No x Cost Per Head)

6.    Month F5
(3 occurances)

 

Press F5 to choose the banking details of the purchase

·         Month

·         Cost Code

·         Bank Account

 

Sales Worksheet 

1.    Stock Type

 

Agrimaster copies the Stock Type from the
Stock Reconciliation Worksheet

2.    Total Sale No.

 

Agrimaster copies the Sell No. from the Stock Reconciliation Worksheet

3.    Sale #1 No.
Sale #2 No.
Sale #3 No.

 

Type the number of stock by type to be sold

For example, divide the sales of 4 year old ewes over 2 months. Separate the sales over months to fit your market

4.    Return Per Head
(3 occurances)

 

Type the dollar amount expect per head

5.    Return $
(3 occurances)

 

Agrimaster will calculate the total amount of the sale

(Sale No x Return Per Head)

6.    Month F5
(3 occurances)

 

Press F5 to choose the banking details of the purchase

·         Month

·         Cost Code

·         Bank Account

  

Enter a Mix of Cost Codes or Bank Accounts 

The default setting for the Month F5 is to book all purchases or all sales to the same Cash Book Code and same Bank Account. For example, use different Month data to: 

  • Separate SHEEP INCOME Codes for Export Sales and Local Sales
  • Distribute Lamb Sales over equal months differently than the sales of 4 Yr Ewes in a single month 

Same Month, Code and Bank Account in each line

 

Different Month, Code or Bank Account in some lines



Switch to Different Code for Each Line 

1.    Go to the top right side of the worksheet 

2.    Click on Change to DIFFERENT code for each line 


3.    At the Change Distribution Message window, click Yes

4.    Click into a box in the Month F5 column 

5.    Press F5 and select the following:

·         Distribute – choose Any (single months) or an equal pattern of sales

·         First Month – click on the required Month

·         Select Code – look under SHEEP INCOME and choose the appropriate code

·         Select Bank – click on the Bank Account 


6.    Click on the green tick and note the Month and Code

7.    Enter the remaining data into the Worksheet 

8.      After all data is entered, click on the green tick to save the worksheets

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

Comments