Docstoc

sweetcorn farm enterprise budget calculator

Document Sample
sweetcorn farm enterprise budget calculator Powered By Docstoc
					Swcorn 1                      Fresh market (wholesale) sweet corn enterprise budget           Revised: Mar '06
                              Hand harvested                                     Return Per Acre:              $191.76
                              Number of Acres =             20                      1t=             368.43 doz
Numbers/text in blue can be edited/changed by individual producers

                                        Optimistic                        Expected                Pessimistic
Yield - dozen/ac                           1200                              1000                     800
Price - $/dozen                           2.00                               1.80                    1.60
Production - dozen                        24000                             20000                    16000

 Crop Insurance
 C.I. Premium/ac:                                          42.00
 Level of Coverage                                          80%
 Guaranteed Yield/ac.                                      800.00
 Probability of a payout                                   15.86%
 Expected Payout/ac                                        $30.00

Participate in CI? (y/n)                                    yes

                                                          Unit/Ac          Number     Cost/Unit     $/Acre      $/Year
Expenses                                                   -------           ------      -           -------     -------
Variable Costs:
Seed                                                              lbs        10         9.00          90        1800
Starter Solution                                                    g        85         0.55          47         935

Fertilizer                     N                                     kg      41        1.010          41         828
                               P                                     kg       9        0.682           6         123
                               K                                     kg      23        0.577          13         265

                                                          Unit/Ac          Number     Cost/Unit     $/Acre      $/Year
                                                           -------           ------       -          -------     -------
Herbicides                     Burndown                         times       1.00        8.50           9         170
                               Primextra Magnum                 times       1.00       28.00          28         560
                               Accent4 plus Merge               times       1.00       28.95          29         579
Insecticides                   Furadan                          times       1.00       15.84          16         317
                               Matador                          times       3.00        5.30          16         318
                                                                times       0.00        0.00           0          0
Fungicides                     Tilt                             times       2.00       14.70          29         588
Crop Insurance                                                                1        42.00          42         840
Custom Work                    Pesticide application           times          7         9.15          64        1281
                               Fertilizer application          times          2         9.20          18         368
                               Other                           times          0         0.00           0          0

Irrigation1                    travelling gun                       $         1        129.00        129        2580
Plastic mulch                                                       $         0         0.00           0          0
Crop Scouting                                                       $         1        12.00          12         240
Packaging                      5 dozen mesh bags                  no.       200         0.40          80        1600
Marketing and Transportation (% of sales)                          %        5.0%                      90        1800
Labour
   Harvest, hand                                                  hrs        20        10.90          218        4360
   Packing/Grading                                                hrs        10        10.90          109        2180
   Machine operation                                              hrs         3        14.20           43         852
Mulch removal                                                       $         0        0.00             0          0
Mulch disposal                                                      $         0        0.00             0          0
Cover crop seed                                                    bu        2         8.00           16         320

                                                           Typical
                                                            $/Acre                                  $/Acre      $/Year
Fuel2                                                         19                                      19         380
Mach. Repair & Maint.2                                        10                                      10         200
Bldg. Repair & Maint.                                         50                                      50        1000
Land Rent                                                      0                                       0          0
General Variable Costs                                         0                                       0          0
Interest on                                 %int        % of year used
Operating Capital                           5.25              50                                      47         941
                                                                                                      -------    -------
Total Variable Costs                                                                                 1271       25425




                                                                           Page -1
                                                             Typical
Fixed Costs:                                                  $/Acre                                      $/Acre     $/Year
              2
Depreciation                                                    35                                          35        700
Interest on investment2                                         21                                          21        420
                                  3
Cold storage and packing equipment                             275                                         275       5500
Land Costs                                                       -                                           -         0
Long-term Leases                                                 0                                           0         0
                    2
General Fixed Costs                                              6                                           6        120
                                                                                                           -------    -------
Total Fixed Costs                                                                                          337       6740

Revenues:                                                                     $/Acre          $/Year
Total Expected Revenues                                                       1800            36000

  less: Variable Costs                                                         1271           25425
                                                                                -------         -------
Expected Operating Margin                                                       529           10575
  less: Fixed Costs                                                             337            6740
                                                                                -------         -------
Expected Net Revenue                                                            192            3835

   Break-even $/dozen to cover:                                            Variable Costs                 1.27
                                                                           Fixed Costs                    0.34
                                                                                                          -------
                                                                           Total Costs                    1.61

                               Chance of at least breaking even     ==>                                   62%
                               Chance of at least             0     $/acre return ==>                     62%
                               Coefficient of variation         ==>                                       0.35

                                         Returns $/acre                Chances of at least
                                                                       this return per acre

                                              800                                 17 %
                                              461                                 33 %
                                              192                                 50 %
                                               -78                                67 %
                                              -416                                83 %

1. Includes Variable (fuel, repairs, labour) and Fixed(depreciation, interest, insurance) Irrigation Costs
2. Field operations included in fuel, repairs, machine labour, depreciation, interest and general fixed:
                                Tillage: Chisel plow, 2 field cultivations, 1 inter row cultivation
                                Planting: Grain Corn planter, cover crop seed planter
                                Harvest: Wagon, forklift
3. Includes depreciation, interest on investment and insurance for forced air cooling system
4. Accent is only registered for specific sweet corn varieties. Please refer to OMAF Publication 75 for listing.



                                   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

				
DOCUMENT INFO
Shared By:
Stats:
views:513
posted:2/9/2008
language:English
pages:2