Wwheat 1
HARD RED SPRING WHEAT BUDGET
Revised: Jan '07 Return Per Acre 1t= ($7.00) 36.74 bu
Number of Acres =
1
Wheat Yield - bu/ac Price - $/bu Straw Yield - bales/ac Price - $/bale Total Production Wheat - bu Straw - bales
Optimistic 48 5.70 55 1.65 48 55
Expected 30 5.68 50 1.50 30 50 Insurance Evaluation Crop Insurance 0.00 C.I. Premium/ac: n/a Level of Coverage 0.01% Guaranteed Yield/ac. $0.00 Probability of a payout Expected Payout/ac n/a Unit/Ac ------lb kg kg kg kg Unit/Ac ------kg or l kg or l kg or l kg or l kg or l Insurance Participate in CI? (y/n) Number -----130 0 40 63 0 Number -----0 1 0 0 0 0 1 0 1 1 0.90 0 0.82 0.82 50 0 Cost/Unit 0.35 0.00 0.376 0.476 0.000 Cost/Unit 0.00 6.40 0.00 0.00 0.00 0 6.15 0.00 9.15 9.10 0 0.00 6.35 2.00 0.05 0.00
Pessimistic 25 3.47 45 1.35 25 45
Program Payments Premium/ac: Guaranteed Price/bu. Probability of a payout Expected Payout/ac
6.15 90% 27.00 39.71% $18.42 Yes $/Acre ------45 0 15 30 0 $/Acre ------0 6 0 0 0 0 6 0 9 9 0 0 5 2 3 0 $/Year ------45 0 15 30 0 $/Year ------0 6 0 0 0 0 6 0 9 9 0 0 5 2 3 0
Participate in Programs? (y/n)
Expenses Variable Costs: Seed Seed Treatment Fertilizer #1 #2 #3
6-24-24 Urea 46%
Herbicide Annual Grasses Broadleaf Herbicides Other Herbicides Insecticides Fungicides Growth Regulators Crop Insurance Program Premium Custom Work #1 #2 Drying Storage Trucking Marketing Fee Twine Other
Fertilizer App. Chem. Application tonnes tonnes tonnes tonnes sq. bales
Fuel Mach. Repair & Maint. Bldg. Repair & Maint. Labour General Variable Costs Interest on Operating Capital Total Variable Costs %int 7
Typical $/Acre 12.5 19.05 0 17.8 0 %year 83
$/Acre 13 19 0 18 0
$/Year 13 19 0 18 0
10 ------189
10 ------189
Page -1
Fixed Costs: Depreciation Interest on Term Loans Land Costs Long-term Leases General Fixed Costs Total Fixed Costs
Typical $/Acre 33 23.3 0 6.7
$/Acre 33 23 0 0 7 ------63
$/Year 33 23 0 0 7 ------63
Revenues: Total Expected Revenues less: Variable Costs Expected Operating Margin less: Fixed Costs Expected Net Revenue Break-even $/bu to cover:
$/Acre 245 189 ------56 63 -------7 Variable Costs Fixed Costs Total Costs
$/Year 245 189 ------56 63 -------7 6.31 2.10 ------8.41
Chance of at least breaking even ==> Chance of at least 0 $/acre return ==> Coefficient of variation ==> Returns $/acre Chances of at least this return per acre 17 % 33 % 50 % 67 % 83 %
47% 47% 0.35
75 29 -7 -43 -89
The user of this worksheet assumes all responsibility.
For more information: OMAFRA Agricultural Information Centre
ag.info@omafra.gov.on.ca
1-877-424-1300
Page -2
Allocation of General Variable and Fixed Costs
General Variable and Fixed Costs or general overhead costs are those whole farm costs that can be difficult to allocate to a specific enterprise. These costs will show little or no change whether one crop or another is grown. That is to say, your crop mix choice should be the same after allocating general overhead costs as it was before they were added. This table allows you to allocate these overhead costs and transfer them to the budget to arrive at a total cost of production. Click the transfer button to include the costs calculated in this table into the enterprise budget.
Total acres of HRW Wheat:
Transfer General Costs to the Budget
1
Back to Budget
Percent allocated to
Total Dollars allocated to HRW Wheat $ 300.00
Per acre costs for HRW Wheat $ 3.00
Optional: Percent Allocation to other enterprises
Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5
Soybeans Wheat Canola Barley
Total allocated
Cost Item Whole Farm $ HRW Wheat Example: 100 acres of HRW Wheat
Legal and accounting fees $ 1,500.00 20% HRW Wheat
20%
20%
20%
20%
100%
General Variable Costs
Advertising Electricity and heating fuel Telephone Memberships/subscription fees Office expenses Legal and accounting fees Motor vehicle expenses Small tools Soil testing Licenses/permits Other general variable costs
Whole Farm $
Total General Variable Costs $
General Fixed Costs Property taxes Other insurance premiums Other general fixed costs Total General Fixed Costs $
-
HRW Wheat $ $ $ $ $ $ $ $ $ $ $ $ -
HRW Wheat $ $ $ $ $ $ $ $ $ $ $ $ -
Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
-
$ $ $ $
-
$ $ $ $
-
0% 0% 0%