corn organic enterprise budget calculator

Reviews
Shared by: ocak
Stats
views:
119
rating:
not rated
reviews:
0
posted:
1/28/2008
language:
English
pages:
0
Corn 1 GRAIN CORN-ORGANIC ENTERPRISE BUDGET Revised: Jan '07 Return Per Acre 1t= $282.24 39.368 bu Number of Acres = 1 Yield - bu/ac Price - $/bu Production - bu Optimistic 125 7.75 125 Expected 94 7.20 94 Insurance Evaluation Crop Insurance C.I. Premium/ac: Level of Coverage Guaranteed Yield/ac. Probability of a payout Expected Payout/ac Participate in CI? (y/n) Unit/Ac ------M-kernel ml times kg kg Number -----30 0 1 0 0 Number -----0 0 0 0 0 1 0 0 0 2.63 2.39 2.39 2.39 1 Cost/Unit --------1.74 0.00 70.000 0.000 0.000 Cost/Unit --------0.00 0.00 0.00 0.00 0.00 11.20 0.00 0.00 0.00 15.44 7.64 7.00 0.40 2.00 50.00 Pessimistic 70 3.90 70 11.20 90% 84.60 36.62% 49.72 Yes $/Acre -----52 0 70 0 0 $/Acre -----0 0 0 0 0 11 0 0 0 41 18 17 1 2 50 $/Year -----52 0 70 0 0 $/Year -----0 0 0 0 0 11 0 0 0 41 18 17 1 2 50 Expenses Variable Costs: Seed Seed Treatment Fertilizer #1 #2 #3 Manure/compost Unit/Acre Herbicide ------Annual Grasses and Broadleaf kg or l Other Herbicides kg or l Other Herbicides kg or l Insecticides kg or l Fungicides kg or l Crop Insurance Insurance Program Premium Custom Work #1 Chem. Application #2 Fert. Appl.,mix, delivery Drying 8 Points tonnes Storage (4 months) tonnes Trucking tonnes Marketing Fees tonnes Certification fees Other Soil maintenance (cover crop, fallow etc) Fuel Mach. Repair & Maint. Bldg. Repair & Maint. Labour General Variable Costs Interest on Operating Capital Total Variable Costs %int 7 Typical $/Acre 17.3 18 0 20.55 0 %year 50 Enterprise $ Allocated 0 0 0 0 0 0 $/Acre 17 18 0 21 0 10 -----328 $/Year 17 18 0 21 0 10 -----328 Page -1 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 $/bu to cover: Typical $/Acre 35.5 24.7 0 6.2 Enterprise $ Allocated 0 0 0 0 $/Acre 36 25 0 6 -----66 $/Year 677 328 -----349 66 -----282 3.49 0.71 -----4.20 81% 81% 0.48 $/Year 36 25 0 0 6 -----66 $/Acre 677 328 -----349 66 -----282 Variable Costs Fixed Costs Total Costs Chance of at least breaking even ==> Chance of at least 0 Coefficient of variation ==> Returns $/acre 599 423 282 142 -35 $/acre return ==> Chances of at least this return per acre 17 % 33 % 50 % 67 % 83 % 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 if you wish to arrive at a total cost of production. Click the transfer button to include the costs calculated in this table into the enterprise budget. Back to the Budget Total acres of Grain Corn: Transfer General Costs to the Budget 1 Optional: Percent Allocation to other enterprises Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 Soybeans Wheat Canola Barley Percent allocated to Total Dollars allocated to Grain Corn $ 300.00 Grain Corn - Per acre costs for Grain Corn $ 3.00 Total allocated Cost Item Whole Farm $ Example: 100 acres of Grain Corn Legal and accounting fees $ 1,500.00 Grain Corn 20% Grain Corn $ $ $ $ $ $ $ $ $ $ $ $ 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 $ - Grain Corn $ $ $ $ $ $ $ $ $ $ $ $ - Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% - $ $ $ $ - $ $ $ $ - 0% 0% 0%

Related docs
corn silage farm enterprise budget calculator
Views: 72  |  Downloads: 1
sweet corn farm enterprise budget calculator
Views: 180  |  Downloads: 4
Cabbage (Non-organic) Enterprise Budget
Views: 0  |  Downloads: 0
corn grain budget calculator
Views: 189  |  Downloads: 14
sweetcorn farm enterprise budget calculator
Views: 384  |  Downloads: 1
barley farm enterprise budget calculator
Views: 179  |  Downloads: 3
spring canola farm enterprise budget calculator
Views: 139  |  Downloads: 3
Amish Corn Enterprise Budget
Views: 0  |  Downloads: 0
Winter Canola Budget Calculator
Views: 90  |  Downloads: 0
Livestock Enterprise Budget
Views: 0  |  Downloads: 0
premium docs
Other docs by ocak
Template Project Scale[1]
Views: 4343  |  Downloads: 674
Strategic Asset Plans[1]
Views: 2427  |  Downloads: 539
Steering Committee Charter template[1]
Views: 5248  |  Downloads: 664
Status Report Management Process Flow example[1]
Views: 5014  |  Downloads: 1088
Status Report Example
Views: 7675  |  Downloads: 1778
Scope Statement Development Instructions[1]
Views: 2199  |  Downloads: 93
Schedule Of Excess Risks[1]
Views: 1020  |  Downloads: 32
Risk Value Assessment Tool
Views: 1818  |  Downloads: 148
Risk Response Plan
Views: 1260  |  Downloads: 57
Risk Model Template Tool instructions
Views: 622  |  Downloads: 34
Risk Mitigation Worksheet Template
Views: 1714  |  Downloads: 92
Risk Matrix
Views: 1264  |  Downloads: 79
Risk Management Work Breakdown Structure
Views: 1397  |  Downloads: 173