Docstoc

2012 MST COP_CROPCOST 03_27_12

Document Sample
2012 MST COP_CROPCOST 03_27_12 Powered By Docstoc
					                                                                                   2012 Crop Budget
                                                           Template by: Dennis Stein, Extension Educator, District Farm Business Management
                                                               Michigan State University Extension ♦ 362 Green St., Caro MI 48723
                                            phone: (989) 672-3870 ♦ email: steind@anr.msu.edu ♦ webpage: http://www.msu.edu/user/steind



CROP BUDGET SIMULATION                                                                                                                   vs. 03.12                       2012 BUDGET estimate
***********                  *********       ***********         (enter your actual input costs in this section)
                                                                                                                      FIXED
NITROGEN $/LBS                       0.65                       MKT $/BU                      0.050                   INS $/AC                5.00     (non crop insurance)
PHOS $/LB                            0.52                       STOR$/BU                      0.045 /MO               Interest                0.045    (rate paid for money)
POTASH $/LB                          0.55                       % MOIST                      15.000                   LABOR/AC               14.00
LIME$/T                             28.00                        $/%/BU                       0.045 DRYING                       (net after PA116 refunds)
                                                                                                                      LANDTAX $/AC            0.00
SUPPLIES $/AC                        7.71                       TRUCK$/BU                     0.150 RENT$/AC                     (land cost per acre)
                                                                                                                                            150.00
REPAIR $/AC                         29.00                       FUEL$/AC                            DEPR $/AC
                                                                                              3.750 +15%Lube                                 30.00
UTILILTY $/AC                        9.00                       GovPay/ac                     0.00  DEBT PAY/AC                               0.00
                                                                                                    DRAW $/AC                                 0.00
 *** You must input these lines                                                         ReturnCapital&Mgt.                       (% return for cash invested in production)
                                                                                                                                              0.000
                                                                                        ############################################################################ Acre
                                                                                                                                 ##############################################################
 ############################################################################
                         ############################################################################ ########################################################################
                                       ############################################################################
                                                        ############################################################################
                                                                       ############################################################################
                                                                                                     ############################################################################
                                                                                                                                                                     Total for Avg. per
                                                                                                                                                               #######################################
                                                                                                                                                  ##################################################
         ENTERPRISE                              CORN                           WHEAT                    DRYBEANS                    SOYBEAN                            BEETS
                                                                                                                                                                    S all crop
YIELD/AC                                        160.00 BU                        85.00 BU                      20.00 CWT                   50.00 BU                       acres
                                                                                                                                                                         26.00
VALUE/UNIT                                        $5.00               $            6.25                       $40.00                      $12.50                        $55.00
                                       --------                         -------                      -------                     -------                       -------
          LDP/Unit ***          0.00 $              -           0.00 $              -         0.00 $              -       0.00 $              -        0.00 $               - 0         0.00
         GovProgPay                   $             -                 $             -               $             -             $             -               $             - 0         0.00
GROSS INCOME                          $         800.00                $         531.25              $         800.00            $         625.00              $            4186
                                                                                                                                                                    1,430.00         837.25
ACRES PLANTED                                         1 AC            $               1 AC                          1 AC                        1 AC                          5
                                                                                                                                                                              1
 *CASH COST                AMOUNT                           AMOUNT                        AMOUNT                      AMOUNT                       AMOUNT
NITROGEN                      160.00 $          104.00        110.00 $            71.50      60.00 $           39.00        0.0 $             -       150.00 $               312
                                                                                                                                                                         97.50        62.40
Phos                           65.00 $            33.80        55.00 $            28.60      60.00 $           31.20       60.0 $          31.20       35.00 $               143
                                                                                                                                                                         18.20        28.60
Potash                         85.00 $            46.75        55.00 $            30.25      60.00 $           33.00       90.0 $          49.50      120.00 $               226
                                                                                                                                                                         66.00        45.10
LIMESTONE                       0.00 $              -           0.00 $              -         0.00 $              -         0.0 $             -         0.00 $              - 0         0.00
SEED ***                              $         105.00                $           24.00             $          75.00            $          55.00           * $               397
                                                                                                                                                                        137.50        79.30
HERBICIDE ***                         $           21.00               $            5.00             $          36.00            $          21.00              $              112
                                                                                                                                                                         29.00        22.40
INSECT&CHEMICALS ***                  $             -                 $           20.00             $          25.00            $          20.00              $              161
                                                                                                                                                                         95.75        32.15
CROP INS.                             $           25.00               $           15.00             $          30.00            $          17.00              $              127
                                                                                                                                                                         40.00        25.40
FUEL & Lube                       5.0 $           21.56           3.0 $           12.94       6.00 $           25.88        3.5 $          15.09       12.00 $               127
                                                                                                                                                                         51.75        25.44
REPAIR                            1.0 $           29.00           0.7 $           20.30       1.00 $           29.00        0.7 $          20.30        2.50 $               171
                                                                                                                                                                         72.50        34.22
SUPPLIES                          1.0 $            7.71           1.0 $            7.71       1.00 $             7.71       1.0 $           7.71        1.50 $                4
                                                                                                                                                                         11.572         8.48
UTILITIES                         3.0 $           27.00           0.5 $            4.50       0.50 $             4.50       0.5 $           4.50        1.00 $                5
                                                                                                                                                                           9.000        9.90
MO STORED                         0.0                             0.0                         0.00                          0.0                         0.00                #VALUE! #VALUE!
STORAGE                               $             -                 $             -               $             -             $             -               $             - 0         0.00
MARKETING                         0.8 $            6.00           1.0 $            4.25       5.00 $             5.00       1.5 $           3.75        0.00 $              - 19        3.80
DRYING                           20.0 $           36.00          15.0 $             -        15.00 $              -        15.0 $             -        15.00 $              - 36        7.20
TRUCKING                          1.0 $           24.00           1.0 $           12.75       2.00 $             6.00       1.0 $           7.50       17.50 $               119
                                                                                                                                                                         68.25        23.70
T VARIABLE                            $         486.82                $         256.80              $         347.29            $         252.55              $            2040
                                                                                                                                                                        697.02       408.09
Breakeven Var Cash                    $           3.04                $           3.02              $         17.36             $           5.05              $         26.81
               **FIXED       Factors                          Factors                       Factors                     Factors                      Factors
INSURANCE                         1.0 $            5.00           1.0 $            5.00         1.0 $            5.00       1.0 $           5.00        1.00 $                2
                                                                                                                                                                           5.005        5.00
LABOR                             1.0 $           14.00           0.5 $            7.00         1.0 $          14.00        0.5 $           7.00        2.50 $                7
                                                                                                                                                                         35.007       15.40
INTEREST                          1.0 $           21.91           1.0 $           11.56         1.0 $          15.63        1.0 $          11.36        1.00 $                9
                                                                                                                                                                         31.372       18.36
Breakeven Fixed Cash                  $           0.26                $           0.28              $           1.73            $           0.47              $           2.74
RENT                              1.0 $         150.00            1.0 $         150.00          1.0 $         150.00        1.0 $         150.00        1.30 $               795
                                                                                                                                                                        195.00       159.00
TAX'S- land                       1.0 $             -             1.0 $             -           1.0 $             -         1.0 $             -         1.00 $              - 0         0.00
DRAW $/AC                         1.0 $             -             1.0 $             -           1.0 $             -         1.0 $             -         1.00 $              - 0         0.00
PRINCIPAL PAY                     1.0 $             -             1.0 $             -           1.0 $             -         1.0 $             -         1.00 $              - 0         0.00
Breakeven Capital/Mgt. Cash $                     0.94                $           1.76              $           7.50            $           3.00              $           7.50
TotalCash Fixed&Capital Exp           $         190.91                $         173.56              $         184.63            $         173.36              $              989
                                                                                                                                                                        266.37       197.76
T EXPENSE CASH                        $         677.73                $         430.35              $         531.91            $         425.92              $            3029
                                                                                                                                                                        963.38       605.86
Breakeven All Cash Costs              $            4.24               $            5.06             $          26.60            $           8.52              $          37.05
DEPRECIATION ***                  1.0 $           30.00           1.0 $           30.00         1.5 $          45.00        1.0 $          30.00        2.00 $               195
                                                                                                                                                                         60.00        39.00
RETURN TO CAPITAL&Mgt                 $             -                 $             -               $             -             $             -               $             - 0         0.00
TOTAL ALL EXP                         $         707.73                $         460.35              $         576.91            $         455.92              $            3224
                                                                                                                                                                    1,023.38         644.86
BREAKEVEN                $/UNIT       $           4.42                $           5.42              $         28.85             $           9.12              $         39.36
NET/ACRE                              $           92.27               $           70.90             $         223.09            $         169.08              $         406.62
EXPENSE ALL AC                        $         707.73                $         460.35              $         576.91            $         455.92              $          $3,224
                                                                                                                                                                    1,023.38         644.86
INCOME PER UNIT                       $           5.00                $           6.25              $         40.00             $         12.50               $         55.00
INCOME ALL AC                         $         800.00                $         531.25              $         800.00            $         625.00              $          $4,186
                                                                                                                                                                    1,430.00         837.25
NET ALL AC                            $           92.27               $           70.90             $         223.09            $         169.08              $            $962
                                                                                                                                                                        406.62       192.39
Breakeven Yield                                  141.5                             73.7                          14.4                        36.5                          18.6
Return to Investment/Acre                        $92.27                          $70.90                      $223.09                     $169.08                       $406.62
                                                                                                                                                                      $961.95        192.39




This budget projection has no return to Management and Capital replacement which is a cost that must be covered but vary greatly between farm to farm. It is suggested that you consider taking the
                     time to calculate your own farm's actual costs at the end of each year and then use your numbers as a base from wihch to build next year's budget numbers.


                                         The above values are estimated values and your actual cost may vary greatly from the numbers presented.
                    MSU is an affirmative-action, equal-opportunity employer. Michigan State University Extension programs and materials are open to all without regard to race, color,
              national origin, gender, gender identity, religion, age, height, weight, origin, gender, disability, political beliefs, sexual orientation, martial status, family status or veteran status.
                                                                                This information is for educational purposes only.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:3/29/2014
language:Latin
pages:1