Crop Production Worksheet – Agrimaster

The crop production worksheet is the overview of your budget. Enter the summary of which crops you plan to grow, any loan commitments to sell financed crops and what yield will be used across your business.

For example, your business may grow crop for both sale and feed. During a particular year, you may plan to sell some of your crop to a neighbour.

Crop Production Columns

1. Crop Type		Type the name of the type of crop you plan to grow. Examples Oats, Canola or Wheat.
2. Area Ha		Type the number of hectares to be seeded with that type of crop.
3. Yield T/ha		Type the number for the expected yield in tonnes per hectare. Yield numbers may be provided by your State authority or by your seed supplier.
4. Total Yield		Agrimaster calculates an estimated total yield by multiplying the Area Ha by the Yield T/ha for the Crop Type in that row. Total yield will be calculated and placed in the Total and Carry-over columns.
5. Pools Non-Loan		Type the number of tonnes from your Total Yield you intend to sell to the grain pool or crop pool – if you have no loan to start this crop. Enter tonnes here even if you have entered data into the Grain Income Calculator. Flexible Loan tonnage should be entered in this column.
6. Non Pool		Type the number of tonnes from your Total Yield you intend to sell to private parties. For example, selling some of your yield to a neighbour.
7. Grain Loan Option		Type the number of tonnes from your Total Yield that is obligated to the harvest loan holder, if you have used a grain loan. If you use Grain Loan Option, you must also enter the loan details into the Grain Calculator tool before continuing to another detail worksheet in the Crop Worksheets. Agrimaster will offer Grain Calculator when you move to another worksheet.
8. Feed Tonnes		Type the number of tonnes from your Total Yield that will be diverted to feed your livestock. The tonnes entered here will be carried through to the Statement of Position (remember to enter Unsold $ Value/tonne).
9. Seed Tonnes		Type the number of tonnes from your Total Yield that you will be storing and using to seed your next season. The tonnes entered will be carried through to the Statement of Position.
10. Carry Over		Agrimaster calculates the remaining amount of your Total Yield that has not been budgeted onto the yield usage options 5-9 (Pools Non-Loan, Non-Pool, Grain Loan Option, Feed Tonnes, Seed Tonnes). This amount will carry through to the Statement of Position providing Unsold $ Value/Tonne is entered.
11. Unsold Value/Tonne		Type the number of the dollars per tonne that the grain is worth if it is not sold or given loan holder. This number is also the estimated value of the grain you use in your own business for feed or stored to seed your next season.
12. Unsold Total Value		Agrimaster calculates a total dollar value of unsold crop by multiplying the Unsold Value/Tonne by the combined Feed Tonnes, Seed Tonnes and Carry Over.

Enter data in each row for as many crop types as you are planning.

Click on the green tick to save the Worksheets after data entry is complete.

Comments