spring canola farm enterprise budget calculator by cshieyiez

VIEWS: 442 PAGES: 4

									Scanol 1

SPRING CANOLA-ROUNDUP READY ENTERPRISE BUDGET Revised: Jan '07 Number of Acres = 1 Return Per Acre 1t= $70.68 44.092 bu

Yield - tonne/ac Price - $/tonne Production - tonne

Optimistic 1.2 390 1.2

Expected 0.85 380 0.85 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 -----2.3 0 60 74 0 Number -----0 0 1 0 0 1 1 1 1 1 0.94 0 0.85 0.85 0 Cost/Unit 18.74 0.00 0.376 0.476 0.000 Cost/Unit 0.00 0.00 5.20 0.00 0.00 15.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.72 28.55% $15.22 Yes $/Acre ------43.1 0.0 23 35 0 $/Acre ------0 0 5 0 0 15 13 0 9 9 0 0 5 3 0 $/Year ------43.1 0.0 23 35 0 $/Year ------0 0 5 0 0 15 13 0 9 9 0 0 5 3 0

Expenses Variable Costs: Seed Seed Treatment Fertilizer #1 #2 #3

6-24-24 Urea

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

Go to General Costs Allocation Worksheet

Page -1

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 10.15 15.85 0 7.7 0 %year 50

$/Acre 10 16 0 8 0 7 ------202 $/Acre 28 18 0 0 5 ------51 $/Acre 323 202 ------121 51 ------71 Variable Costs Fixed Costs Total Costs $/Year 323 202 ------121 51 ------71 237.43 59.41 ------296.84 72% 72% 0.37

$/Year 10 16 0 8 0 7 ------202 $/Year 28 18 0 0 5 ------51

Typical $/Acre 27.5 17.65 0 5.35

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 %

186 122 71 20 -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

Page -2

Page -3

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 Canola:
Transfer General Costs to the Budget

1

Back to Budget

Percent allocated to

Total Dollars allocated to Canola $ 300.00 Canola $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

Per acre costs for Canola 3.00 Canola -

Optional: Percent Allocation to other enterprises
Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5
Soybeans Wheat Corn Barley

Total allocated

Cost Item Whole Farm $ Example: 100 acres of Canola
Legal and accounting fees $ 1,500.00

Canola 20% Canola

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 $

Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0%

Total General Variable Costs $
General Fixed Costs Property taxes Other insurance premiums Other general fixed costs Total General Fixed Costs $

-

-

$ $ $ $

-

$ $ $ $

-

0% 0% 0%


								
To top