soft winter wheat farm enterprise budget calculator

Reviews
Shared by: cindyrella perillo
Stats
views:
495
rating:
not rated
reviews:
0
posted:
2/8/2008
language:
English
pages:
0
Wwheat 1 SOFT WINTER WHEAT ENTERPRISE BUDGET Revised: Jan '07 $186.33 36.74 bu Number of Acres = 1 Return Per Acre 1t= Wheat Yield - bu/ac Price - $/bu Straw Yield - bales/ac Price - $/bale Total Production Wheat - bu Straw - bales Optimistic 90 5.10 55 2.50 90 55 Expected 70 5.00 50 2.00 70 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 Yes Unit/Ac ------kg kg US gal 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 -----50 0 5 90 0 Number -----0 0.75 0 0 0 0 1 1 1 1 2.10 0 1.91 1.91 50 0 Cost/Unit 0.71 0.00 2.590 0.477 0.000 Cost/Unit 0.00 9.20 0.00 0.00 0.00 0 6.40 0.00 9.15 9.10 0 0.00 6.35 2.00 0.05 0.00 Pessimistic 55 2.70 45 1.35 55 45 Program Payments Premium/ac: Guaranteed Price/bu. Probability of a payout Expected Payout/ac 6.40 90% 63.00 34.46% $20.16 Yes $/Acre ------36 0 13 43 0 $/Acre ------0 7 0 0 0 0 6 0 9 9 0 0 12 4 3 0 $/Year ------36 0 13 43 0 $/Year ------0 7 0 0 0 0 6 0 9 9 0 0 12 4 3 0 Participate in Programs? (y/n) Expenses Variable Costs: Seed Seed Treatment Fertilizer #1 #2 #3 Liquid 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 Enterprise $ Allocated 0 0 0 0 0 $/Acre 13 19 0 18 0 $/Year 13 19 0 18 0 0 10 ------201 10 ------201 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 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 450 201 ------249 63 ------186 Variable Costs Fixed Costs Total Costs $/Year 450 201 ------249 63 ------186 2.87 0.90 ------3.77 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 % 84% 84% 0.41 366 266 186 107 7 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 SW Wheat: Transfer General Costs to the Budget 1 Back to Budget Percent allocated to Total Dollars allocated to SW Wheat $ 300.00 SW Wheat - Per acre costs for SW 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 $ Example: 100 acres of SW Wheat Legal and accounting fees $ 1,500.00 SW Wheat 20% SW 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 $ - SW Wheat $ $ $ $ $ $ $ $ $ $ $ $ - Enterprise 2 Enterprise 3 Enterprise 4 Enterprise 5 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% - $ $ $ $ - $ $ $ $ - 0% 0% 0%

Related docs
Wheat Letter
Views: 5  |  Downloads: 0
The Desert of Wheat
Views: 9  |  Downloads: 0
SOFT WINTER WHEAT CROP REPORT 2006
Views: 0  |  Downloads: 0
Wheat Letter
Views: 3  |  Downloads: 0
Wheat Letter
Views: 4  |  Downloads: 0
a guide to starting a new farm enterprise
Views: 247  |  Downloads: 6
Hard White Wheat
Views: 7  |  Downloads: 0
2002 Winter Wheat Summary
Views: 3  |  Downloads: 0
2003 Hard Winter Wheat Summary
Views: 0  |  Downloads: 0
premium docs
Other docs by cindyrella per...
processing pears budget calculator
Views: 447  |  Downloads: 27
pears farm bosc enterprise budget calculator
Views: 338  |  Downloads: 4
Computational Corporate Finance Calculations
Views: 685  |  Downloads: 72
wheat ORGANIC ENTERPRISE BUDGET
Views: 462  |  Downloads: 3
vidal grape farm enterprise budget calculator
Views: 356  |  Downloads: 5
The Building Rent Calculator
Views: 770  |  Downloads: 26
swine farm enterprise budget calculator
Views: 555  |  Downloads: 12
sweetcorn farm enterprise budget calculator
Views: 379  |  Downloads: 1
sweet cherry budget calculator
Views: 275  |  Downloads: 2
spring canola farm enterprise budget calculator
Views: 300  |  Downloads: 0
spelt organic enterprise budget calculator
Views: 246  |  Downloads: 1
soybeans roundup budget calculator
Views: 236  |  Downloads: 4
Return on Security Investment Calculator
Views: 304  |  Downloads: 15