Excel Spreadsheet

pears farm bosc enterprise budget calculator

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

Related docs
pears farm bosc enterprise budget calculator
Views: 131  |  Downloads: 4
pears farm enterprise budget calculator
Views: 132  |  Downloads: 2
processing pears budget calculator
Views: 151  |  Downloads: 4
Farm Accounting Workbook
Views: 340  |  Downloads: 35
a guide to starting a new farm enterprise
Views: 247  |  Downloads: 6
Consumer Price Index Calculator
Views: 1715  |  Downloads: 16
Richard Pears, Be Active 4 Life
Views: 0  |  Downloads: 0
Many-Hands-Organic-Farm
Views: 2  |  Downloads: 0
Tower of Pears Holiday Project
Views: 26  |  Downloads: 0
Erik_Pears
Views: 2  |  Downloads: 0
PEARS Provider Course Agenda
Views: 2  |  Downloads: 0
premium docs
Other docs by cindyrella per...
processing pears budget calculator
Views: 444  |  Downloads: 27
Computational Corporate Finance Calculations
Views: 682  |  Downloads: 72
wheat ORGANIC ENTERPRISE BUDGET
Views: 459  |  Downloads: 3
vidal grape farm enterprise budget calculator
Views: 354  |  Downloads: 5
The Building Rent Calculator
Views: 761  |  Downloads: 26
swine farm enterprise budget calculator
Views: 552  |  Downloads: 12
sweetcorn farm enterprise budget calculator
Views: 376  |  Downloads: 1
sweet cherry budget calculator
Views: 271  |  Downloads: 2
spring canola farm enterprise budget calculator
Views: 297  |  Downloads: 0
spelt organic enterprise budget calculator
Views: 245  |  Downloads: 1
soybeans roundup budget calculator
Views: 234  |  Downloads: 4
Return on Security Investment Calculator
Views: 304  |  Downloads: 15