pears farm bosc enterprise budget calculator

FrBoscpear 1 FRESH PEARS -BOSC ENTERPRISE BUDGET Revised: Aug '03 Profit Per Acre: $2,788 Number of Acres = 1 1 tonne = 1.10231 tons Optimistic Expected Pessimistic Yield -tons 10.0 8.0 6.5 Price -$/ton 1102.00 887.00 628.00 Production-tons 10 8 7 Crop Insurance C.I. Premium/ac: 386.73 Level of Coverage 75% Guaranteed Yield/ac. 6.00 Probability of a payout 12.65% Expected Payout/ac $97.82 Participating in CI? (y/n) Yes Unit/Ac Number Cost/Unit $/Acre $/Year Expenses ---------------------------ANNUAL PRODUCTION COSTS: Seasonal Labour hr. 160 8.55 1368 1368 Operator Labour hr. 27.6 12.99 359 359 Fertilizers: 1. Ammonium Nitrate kg or l 150 0.320 48 48 2. Muriate of Potash kg or l 150 0.293 44 44 3. kg or l 0 0.000 0 0 4. kg or l 0 0.000 0 0 5. kg or l 0 0.000 0 0 Unit/Ac Number Cost/Unit $/Acre $/Year ---------------------------Spray Materials: Insecticides: 1. All Insecticides kg or l 5 69.80 349 349 2. _______________ kg or l 0 0.00 0 0 3. _______________ kg or l 0 0.00 0 0 Herbicides: 1. All Herbicides kg or l 2 15.00 30 30 2. _______________ kg or l 0 0.00 0 0 Fungicides: 1. All Fungicides kg or l 7 28.71 201 201 2. _______________ kg or l 0 0.00 0 0 3. _______________ kg or l 0 0.00 0 0 Other Sprays 1. Foliar Fertilizer kg or l 1 7.00 7 7 2. All Other Sprays kg or l 0 0.00 0 0 3. _______________ kg or l 0 0.00 0 0 Page -1Unit/Ac Number Cost/Unit $/Acre $/Year Other Expenses: ---------------------------Manure tons 0 12.00 0 0 Cover Crop Seed $ 0 24.00 0 0 Consulting Fees $ 1 25.00 25 25 Crop Insurance Insurance 1 386.73 387 387 Replacement Trees no. 0 4.29 0 0 Other #1-Irrigation $ 1 63.00 63 63 Other #2 -Leaf,Hive,Mulch $ 1 183.00 183 183 Other #3 -Misc. $ 0 0.00 0 0 Custom Work 1. $ 0 0.00 0 0 2. $ 0 0.00 0 0 Typical Enterprise $/Acre $ Allocated $/Acre $/Year Fuel 191 0 191 191 Mach. Repair & Maint. 171 0 171 171 Bldg. Repair & Maint. 0 0 0 0 Rent and Labour 0 0 0 0 General Variable Costs 0 0 0 0 Interest on %int %year Operating Capital 6 50 0 102 102 -------------Total Variable Costs 3527 3527 Typical Enterprise Fixed Costs: $/Acre $ Allocated $/Acre $/Year Depreciation 341 0 341 341 Interest on Term Loans 98 0 98 98 Long-term Leases 0 0 0 0 General Fixed Costs 440 0 440 440 -------------Total Fixed Costs 879 879 Revenues: $/Acre $/Year Total Expected Revenues 7096 7096 add: Expected Insurance Revenues 98 98 less: Variable Costs 3527 3527 ------------Expected Operating Margin 3667 3667 less: Fixed Costs 879 879 ------------Expected Net Revenue 2788 2788 Break-even $/ton to cover: Variable Costs 440.90 Fixed Costs 109.88 ------Total Costs 550.77 Page -2Chance of at least breaking even ==> 82% Chance of at least 0 $/acre return ==> 82% Coefficient of variation ==> 0.43 Returns $/acre Chances of at least this return per acre 5726 17 % 4090 33 % 2788 50 % 1485 67 % -151 83 % Page -3