Vidal 1
VIDAL GRAPE ENTERPRISE BUDGET Number of Acres = 50
Revised: Dec '05 Return Per Acre: 1 tonne = ($1,795) 1.10231 tons
Yield - tonnes Price - $/tonne Production - tonnes Crop Insurance C.I. Premium/ac: Level of Coverage Guaranteed Yield/ac. Probability of a payout Expected Payout/ac Participate in CI? (y/n)
Optimistic 7.0 580.00 350
Expected 6.0 555.00 300
Pessimistic 5.0 525.00 250
149.00 85% 5.10 18.41% $55.74 Yes Unit/Ac ------Number -----Cost/Unit 1417 21 30.4 81 94 0 0 0 Number -----1 0 0 1 0 1 0 0 0 10.90 14.20 0.365 0.309 0.000 0.000 0.000 Cost/Unit 274.00 0.00 0.00 54.00 0.00 282.00 0.00 0.00 0.00 $/Acre -----1417 229 432 30 29 0 0 0 $/Acre -----274 0 0 54 0 282 0 0 0 $/Year -----70850 11445 21584 1478 1452 0 0 0 $/Year -----13700 0 0 2700 0 14100 0 0 0
Expenses ANNUAL PRODUCTION COSTS: Annual cost to recover Establishment costs
(establishment costs amortized over 21 years)
Seasonal Labour Operator Labour Fertilizers: 1. Am.Nitrate 2. Potash 3. 4. 5.
hr. hr. kg kg kg kg or l kg or l Unit/Ac ------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
Insecticides: 1. All Insecticides 2. _______________ 3. _______________ Herbicides: 1. All Herbicides 2. _______________ Fungicides: 1. All Fungicides 2. _______________ Other Sprays 1. All Other Sprays 2. _______________
Page -1
Other Expenses: Manure Cover Crop Seed Marketing Bd. Fees Crop Insurance Tying Material
Unit/Ac ------tons kg $ Insurance $ Unit/Ac ------$ $ $ $ $ $ $ Typical $/Acre 267 116 0 42 0 %int 5.5 %year 60
Number -----0 2 6 1 1 Number -----1 19 1 1 6 968 968
Cost/Unit 0.00 5.00 15.00 149.00 20.00 Cost/Unit 15.00 3.79 0.00 129.00 78.00 0.35 0.20
$/Acre -----0 10 90 149 20 $/Acre -----15 72 0 129 468 339 194
$/Year -----0 500 4500 7450 1000 $/Year -----750 3601 0 6450 23400 16940 9680
Other Expenses: Trellis Maintenance Replacement Vines Bird Control Irrigation Custom Work 1. Harvest and Delivery 2. Pruning 3. Tying
Fuel Mach. Repair & Maint. Bldg. Repair & Maint. Consulting General Variable Costs Interest on Operating Capital Total Variable Costs
$/Acre 267 116 0 42 0
$/Year 13350 5800 0 2100 0
104 -----4761
5197 -----238027
Fixed Costs: Depreciation Interest on Term Loans Land Costs Long-term Leases General Fixed Costs Total Fixed Costs
Typical $/Acre 176 58 0 0 186
$/Acre 176 58 0 0 186 -----420
$/Year 8800 2900 0 0 9300 -----21000
Page -2
Revenues: Total Expected Revenues add: Expected Insurance Revenues less: Variable Costs Expected Operating Margin less: Fixed Costs Expected Net Revenue
$/Acre 3330 56 4761 ------1375 420 ------1795
$/Year 166500 2787 238027 ------68740 21000 ------89740
Break-even $/pt to cover:
Variable Costs Fixed Costs Total Costs
793 70 ------------------863
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 -884 -1391 -1795 -2198 -2705 17 % 33 % 50 % 67 % 83 %
3% 3% 0.28
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 -3