barley farm enterprise budget calculator

Reviews
Shared by: ocak
Stats
views:
180
rating:
not rated
reviews:
0
posted:
1/28/2008
language:
pages:
0
Barley 1 BARLEY ENTERPRISE BUDGET - less than 2800 CHU Number of Acres = 1 Expected 70 2.95 50 1.50 70 50 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 Participate in CI? (y/n) Number Cost/Unit Revised: Jan '07 $18.51 45.93 bu Return Per Acre 1 tonne = Grain Yield - bu/ac Price - $/bu Straw Yield - bales/ac Price - $/bale Total Production Barley - bu Straw - bales Optimistic 90 3.63 55 1.65 90 55 Pessimistic 50 2.09 45 1.35 50 45 Program Payments Premium/ac: Guaranteed Price/lb. Guaranteed Price/bu. Probability of a payout Expected Payout/ac Participate in Programs? (y/n) Expenses Variable Costs: Seed Seed Treatment Fertilizer #1 #2 #3 4.25 80% 56.00 24.20% $8.43 Yes $/Acre $/Year Urea P K kg kg kg kg kg Unit/Ac ------kg or l kg or l kg or l kg or l kg or l kg or l Insurance 54 0.2 64 20 20 Number -----0 1 0 0 1 0 1 1 1 1 1.68 0 1.52 50 0 0 0.60 0 0.48 0.70 0.6113 Cost/Unit ------0 6.40 0 0 14.35 0 4.25 0.00 9.15 9.1 0 0 6.35 0.05 0 0 32 0 30 14 12 $/Acre -----0 6 0 0 14 0 4 0 9 9 0 0 10 3 0 0 32 0 30 14 12 $/Year -----0 6 0 0 14 0 4 0 9 9 0 0 10 3 0 0 Herbicide Annual Grasses Broadleaf Herbicides Other Herbicides Insecticides Fungicides Growth Regulator Crop Insurance Program Premium Custom Work#1 #2 Drying Storage Trucking Twine Marketing Fees Other Fert. Application Chem. Application 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 50 Enterprise $ Allocated 0 0 0 0 0 0 $/Acre 13 19 0 18 0 6 -----200 $/Year 13 19 0 18 0 6 -----200 Page -1 Fixed Costs: Depreciation Interest on Term Loans Land Cost Long-term Leases General Fixed Costs Total Fixed Costs Typical $/Acre 33 23.3 0 6.7 Enterprise $ Allocated 0 0 0 0 $/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 282 200 -----82 63 -----19 Variable Costs Fixed Costs Total Costs $/Year 282 200 -----82 63 -----19 2.86 0.90 -----3.76 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 % 56% 56% 0.41 129 68 19 -31 -92 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 Barley: Transfer General Costs to the Budget 1 Back to Budget Percent allocated to Total Dollars allocated to Barley $ 300.00 Barley $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Per acre costs for Barley 3.00 Barley - Optional: Percent Allocation to other enterprises Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 Soybeans Wheat Canola Corn Total allocated Cost Item Whole Farm $ Example: 100 acres of Barley Legal and accounting fees $ 1,500.00 Barley 20% Barley 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%

Related docs
oats farm enterprise budget calculator
Views: 149  |  Downloads: 2
flax farm enterprise budget calculator
Views: 145  |  Downloads: 3
hemp farm enterprise budget calculator
Views: 195  |  Downloads: 2
spring canola farm enterprise budget calculator
Views: 139  |  Downloads: 3
corn silage farm enterprise budget calculator
Views: 72  |  Downloads: 1
ontario oats farm enterprise budget calculator
Views: 63  |  Downloads: 0
white beans farm budget calculator
Views: 176  |  Downloads: 2
corn organic enterprise budget calculator
Views: 119  |  Downloads: 1
spelt organic enterprise budget calculator
Views: 252  |  Downloads: 1
premium docs
Other docs by ocak
Template Project Scale[1]
Views: 4467  |  Downloads: 680
Strategic Asset Plans[1]
Views: 2459  |  Downloads: 542
Steering Committee Charter template[1]
Views: 5386  |  Downloads: 670
Status Report Management Process Flow example[1]
Views: 5088  |  Downloads: 1095
Status Report Example
Views: 7956  |  Downloads: 1782
Scope Statement Development Instructions[1]
Views: 2270  |  Downloads: 95
Schedule Of Excess Risks[1]
Views: 1038  |  Downloads: 32
Risk Value Assessment Tool
Views: 1852  |  Downloads: 149
Risk Response Plan
Views: 1318  |  Downloads: 59
Risk Model Template Tool instructions
Views: 649  |  Downloads: 36
Risk Mitigation Worksheet Template
Views: 1810  |  Downloads: 95
Risk Matrix
Views: 1324  |  Downloads: 82
Risk Management Work Breakdown Structure
Views: 1456  |  Downloads: 178