Wcanol 1
WINTER CANOLA-HYBRID ENTERPRISE BUDGET Number of Acres = 1
Revised: Jan '07 $160.28 44.092 bu
Return Per Acre 1t=
Yield - tonne/ac Price - $/tonne Production - tonne
Optimistic 1.8 390 1.8
Expected 1.13 380 1.13 Insurance Evaluation Crop Insurance 0.00 C.I. Premium/ac: n/a Level of Coverage 0.00 Guaranteed Yield/ac. 0.01% Probability of a payout $0.00 Expected Payout/ac Yes Unit/Ac ------kg kg kg kg kg Participate in CI? (y/n) Number -----1.58 0 67 114 45 Number -----0 0 1 1 0 0 1 1 2 1 1.24 0 1.13 1.13 0 Cost/Unit 21.90 0.00 0.429 0.476 0.357 Cost/Unit 0.00 0.00 7.70 6.60 0.00 0.00 13.40 0.00 9.10 9.15 0.00 0.00 6.35 4.00 0.00
Pessimistic 0.75 245 0.75
Program Payments: Premium/ac: Guaranteed Price/lb. Guaranteed Price/t Probability of a payout Expected Payout/ac Participate in Programs? (y/n)
13.40 85% 0.96 37.34% $51.50 Yes $/Acre ------34.6 0.0 29 54 16 $/Acre ------0 0 8 7 0 0 13 0 18 9 0 0 7 5 0 $/Year ------34.6 0.0 29 54 16 $/Year ------0 0 8 7 0 0 13 0 18 9 0 0 7 5 0
Expenses Variable Costs: Seed Seed Treatment Fertilizer #1 #2 #3
7-30-24 Urea 21-0-0-24
Unit/Ac Herbicide ------Annual Grasses kg or l Broadleaf Herbicides kg or l Other Herbicides kg or l Insecticides kg or l Fungicides kg or l Technology Use Agreement Crop Insurance Insurance Program Premium Premium Custom Work #1 #1 Chem. Application #2 Fertilizer Spreader Drying tonnes Storage tonnes Trucking tonnes Marketing Fees tonnes Other
Fuel Mach. Repair & Maint. Bldg. Repair & Maint. Labour General Variable Costs Interest on Operating Capital Total Variable Costs Fixed Costs: Depreciation Interest on Term Loans Land Costs Long-term Leases General Fixed Costs Total Fixed Costs Revenues: Total Expected Revenues less: Variable Costs Expected Operating Margin less: Fixed Costs Expected Net Revenue Break-even Price/tonne to cover:
%int 7
Typical $/Acre 7.8 12.8 0 5.65 0 %year 50
Enterprise $ Allocated 0 0 0 0 0 0
$/Acre 8 13 0 6 0 8 ------234 $/Acre 18 13 0 0 4 ------35 $/Year 429 234 ------195 35 ------160 207.27 30.88 ------238.16 78% 78% 0.49
$/Year 8 13 0 6 0 8 ------234 $/Year 18 13 0 0 4 ------35
Typical $/Acre 17.8 12.8 0 4.3
Enterprise $ Allocated 0 0 0 0
$/Acre 429 234 ------195 35 ------160 Variable Costs Fixed Costs Total Costs
Chance of at least breaking even ==> Chance of at least 0 Coefficient of variation ==> Returns $/acre
$/acre return ==>
Chances of at least this return per acre 17 % 33 % 50 % 67 % 83 %
365 251 160 70 -44
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
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 Winter Canola:
Transfer General Costs to the Budget
1
Back to Budget
Percent allocated to
Total Dollars allocated to
Per acre costs for
Optional: Percent Allocation to other enterprises
Total allocated
Cost Item Whole Farm $ Winter Canola Winter Canola Winter Canola Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 Example: 100 acres of Winter Canola Soybeans Wheat Corn Barley
Legal and accounting fees $ 1,500.00 20% $ 300.00 $ 3.00 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 $ Winter Canola Winter Canola Winter Canola Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Total General Variable Costs $ $ $ -
0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%
General Fixed Costs Property taxes Other insurance premiums Other general fixed costs Total General Fixed Costs $
-
$ $ $ $
-
$ $ $ $
-
0% 0% 0%