processing pears budget calculator

Prpear 1 PROCESSING PEARS -BARTLETT ENTERPRISE BUDGET Revised: Jun '03 Profit Per Acre: $2,468.82 Number of Acres = 1 1 tonne = 1.10231 tons Optimistic Expected Pessimistic Yield -tons 13.0 11.0 6.0 Price -$/ton 550.00 500.00 418.00 Production-tons 13 11 6 Crop Insurance C.I. Premium/ac: 222.75 Level of Coverage 75% Guaranteed Yield/ac. 8.25 Probability of a payout 21.60% Expected Payout/ac $215.72 Participating in CI? (y/n) Yes Unit/Ac Number Cost/Unit $/Acre $/Year Expenses ---------------------------ANNUAL PRODUCTION COSTS: Seasonal Labour hr. 135 8.55 1154 1154 Operator Labour hr. 21 12.95 272 272 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 20.50 41 41 2. _______________ kg or l 0 0.00 0 0 Fungicides: 1. All Fungicides kg or l 5 34.00 170 170 2. _______________ kg or l 0 0.00 0 0 3. _______________ kg or l 0 0.00 0 0 Other Sprays 1. Foliar Fert.(Crop Booster) 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 Unit/Ac Number Cost/Unit $/Acre $/Year Other Expenses: ---------------------------Page -1Manure tons 0 12.00 0 0 Containers no. 0 0.24 0 0 Consulting Fees $ 1 25.00 25 25 Crop Insurance Insurance 1 222.75 223 223 Replacement Trees no. 0 0.00 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 150 0 150 150 Mach. Repair & Maint. 116 0 116 116 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 85 85 -------------Total Variable Costs 2930 2930 Typical Enterprise Fixed Costs: $/Acre $ Allocated $/Acre $/Year Depreciation 119 0 119 119 Interest on Term Loans 88 0 88 88 Long-term Leases 0 0 0 General Fixed Costs 110 0 110 110 -------------Total Fixed Costs 317 317 Revenues: $/Acre $/Year Total Expected Revenues 5500 5500 add: Expected Insurance Revenues 216 216 less: Variable Costs 2930 2930 ------------Expected Operating Margin 2786 2786 less: Fixed Costs 317 317 ------------Expected Net Revenue 2469 2469 Page -2Break-even $/ton to cover: Variable Costs 266.35 Fixed Costs 28.82 ------Total Costs 295.17 Chance of at least breaking even ==> 86% Chance of at least 0 $/acre return ==> 86% Coefficient of variation ==> 0.42 Returns $/acre Chances of at least this return per acre 4700 17 % 3458 33 % 2469 50 % 1480 67 % 238 83 % Page -3