Docstoc

Perennial Peanut Budget - Version 1.606

Document Sample
Perennial Peanut Budget - Version 1.606 Powered By Docstoc
					                         Enter below the number of acres in the appropriate production year to determine the net returns for the operation. Be
                         sure to check the details on the appropriate budgets to ensure the accuaracy of the estimates.



                                                                                                                                                     Return to Main Budget


                                                                                                                                       Returns
                                                                                                                                        Above
                                       Crop                               Acres                     Revenue        Variable Costs   Variable Costs                                             Year   1   1
Established PPH Detail   Established PPH                                                    0   $            -     $         -      $         -                                                Year   2   2
Year 1 Detail            Year 1                                                            25   $            -     $ 13,052.13      $ (13,052.13)                                              Year   3   3
Year 2 Detail            Year 2                                                            25   $      12,625.00   $ 11,037.15      $    1,587.85                                              Year   4   4
Year 3 Detail            Year 3                                                            25   $      30,125.00   $ 12,658.24      $ 17,466.76                                                Year   5   5
Year 4 Detail            Year 4                                                            25   $      30,125.00   $ 12,658.24      $ 17,466.76
Year 5 Detail            Year 5                                                            35   $      42,175.00   $      698.67    $ 41,476.33
                         Totals                                                           100   $     72,875.00    $ 49,405.76      $ 23,469.24




                                                                                                                Year 1              Year 2           Year 3          Year 4      Year 5
                                                            Year                                Revenue         $        -          $ 12,625.00      $ 42,750.00     $ 72,875.00 $ 72,875.00
                                                                                                Cost            $ 13,052.13         $ 24,089.28      $ 36,747.52     $ 49,405.76 $ 49,405.76
                                                                                                Net Revenue     $ (13,052.13)       $ (11,464.28)    $ 6,002.48      $ 23,469.24 $ 23,469.24
                                                                                                Accumulated ROVC$ (13,052.13)       $ (24,516.41)    $ (18,513.92)   $ 4,955.32 $ 28,424.57
                                  Net
%Horse Hay     Revenue/acre   Income/Acre
       100%   $    1,400.00   $    499.34
        75%   $    1,190.63   $    289.96
        67%   $    1,123.63   $    222.96
        50%   $      981.25   $     80.59
        33%   $      838.88   $    (61.79)
         0%   $      562.50   $ (338.16)
                                                              University of Georgia
                                                          Perennial Peanut Hay Budget
                                                                 Version 1.606

                                        Estimated Costs Returns for Established Perennial Peanut

Stand Life                                    10
Number of Acres                              135
                                                                                                                                Your
Revenue                                                   Unit       Amount/Unit     Price/Unit   Total/acre    Grand Total     Farm
Horse Quality Hay                                  tons                     3.50     $ 280.00     $   980.00   $ 132,300.00
Medium Quality Hay                                 tons                     0.75     $ 200.00     $   150.00   $   20,250.00
Lower Quality Hay                                  tons                     0.75     $ 100.00     $    75.00   $   10,125.00
Other Income                                                                0.00     $      -     $      -     $         -
Totals                                                                      5.00                  $ 1,205.00   $ 162,675.00

Variable Costs
Fertilizer
 3-7-28 (spread)                                   Lbs                     1250.00   $    0.14    $   175.00   $   23,625.00
 Sulfur                                            Lbs                       25.00   $    0.40    $    10.00   $    1,350.00
 Other                                             Lbs                        0.00   $     -      $      -     $         -
 Lime                                              tons                       0.25   $   24.00    $     6.00   $      810.00
Herbicides
2,4-D amine                                        Pints                      1.00 $      1.52    $     1.52   $      205.20
Velpar                                             Quarts                     2.00 $     13.75    $    27.50   $    3,712.50
Irrigation (If Dryland enter 0 in
Amount/Unit)                                       Acre inch                  4.00   $   14.37    $    57.49 $       7,760.95
Fuel                                               Gallons                  30.95    $    2.25    $    69.64 $       9,401.06
Repairs                                            Acre                      1.00    $   27.09    $    27.09 $       3,657.15
Supplies                                           Acre                      1.00    $    7.50    $     7.50 $       1,012.50
Hay Labor                                          Hours                    10.80    $    9.00    $    97.20 $      13,122.00
Interest                                           %                 $     239.47        7.50%    $    17.96 $       2,424.61
Total Variable Costs                                                                              $   496.90 $      67,080.98
Returns Over Variable Costs                                                                       $   708.10 $     95,594.02

Fixed Costs
Prorated Establishment Costs (includes all costs until stand fully established)                $       52.21   $   7,048.15
Equipment Fixed Cost                                                                           $      143.83   $  19,416.56
Building Fixed Cost                                                                            $       33.48   $   4,520.00
Irrigation Fixed Cost                                                                          $      101.95   $  13,763.17
Management                                        % of revenue      $     1,205.00          6% $       72.30   $   9,760.50
Total Fixed Costs                                                                              $      403.77   $ 54,508.38
Total Costs                                                                                    $      900.66   $ 121,589.35

Returns Above Total Costs                                                                         $   304.34 $     41,085.65


Price for hay is FOB. If hay is to be delivered, sales price should be adjusted. Producers can also use the "Hauling"
spreadsheet to calculate hauling costs.
Fertilizer cost is based on 350# in spring, 300# following 2.5 cuttings, and 150# after final cutting
Fuel and repair costs based on 2.5 cuttings of hay (1.5 baled as square bales and 1 as medium round bales), 3 chemical
applications, and 4 mowings with a rotary mower.
Hauling cost based on 300 mile round trip with 275 square bales weighing 50 pounds.
                                          3a008e10-19b7-4342-b640-781a9cdbde7e.xls                                          Year 1



                                           PERENNIAL PEANUT HAY BUDGET
                                              Year 1 - Costs and Returns
                                                                                                                           Your
Revenue                                             Unit     Amount/Unit      Price/Unit    Total/acre    Grand Total      Farm
Horse Quality Hay                              tons                    0.00   $   280.00    $       -     $         -
Medium Quality Hay                             tons                    0.00   $   200.00    $       -     $         -
Lower Quality Hay                              tons                    0.00   $   100.00    $       -     $         -
Other Income                                                           0.00   $      -      $       -     $         -
Totals                                                                 0.00                        0.00            0.00

Variable Costs
Sprigs                                         bu                     90.00 $       2.00    $    180.00   $    4,500.00
Fertilizer
 3-7-28 (spread)                               Lbs                   350.00   $     0.14    $     49.00   $    1,225.00
 Sulfur                                        Lbs                    25.00   $     0.40    $     10.00   $      250.00
 Other                                         Lbs                     0.00   $      -      $       -     $         -
 Lime                                          tons                    1.00   $    24.00    $     24.00   $      600.00
Herbicides
 Roundup - Preplant                            Pints                   2.00 $       5.68    $     11.36   $      284.00
 Other                                         Pints                   0.00 $      15.00    $       -     $         -
 Other                                         Pints                   0.00 $      11.88    $       -     $         -
Irrigation (If Dryland enter 0 in
Amount/Unit)                                   Acre inch               5.00 $      14.37    $     71.86   $    1,796.52
Custom Hire                                                                                               $         -
 Disk-harrow                                   Times/Acre              2.00   $    10.00    $     20.00   $      500.00
 Culti-Packer                                  Times/Acre              1.00   $    10.00    $     10.00   $      250.00
 Sprigging                                     Acre                    1.00   $    70.00    $     70.00   $    1,750.00
 Broadcast Sprayer                             Times/Acre              1.00   $      6.00   $      6.00   $      150.00
 Rotary Mowing                                 Times/Acre              5.00   $    10.00    $     50.00   $    1,250.00
 Cut, rake, bale, and haul                     ton                     0.00   $    29.00    $       -     $         -
Fuel & Oil                                     Acre                   0.00    $       -     $       -     $         -
Repairs                                        Acre                   0.00          64.27   $       -     $         -
Labor                                          Hours                  0.00           9.02   $       -     $         -
Supplies                                       Acre                   1.00    $      7.50   $      7.50   $      187.50
Interest                                       %             $      164.86         7.50%    $     12.36   $      309.11
Total Variable Costs                                                                        $    522.09   $    8,552.13

Returns Over Variable Costs (ROVC)                                                          $   (522.09) $    (8,552.13)

Custom hire prices are based on 2005 survey of custom operators in Georgia
                                             3a008e10-19b7-4342-b640-781a9cdbde7e.xls                                           Year 2



                                              PERENNIAL PEANUT HAY BUDGET
                                                 Year 2 - Costs and Returns
                                                                                                                               Your
Revenue                                                Unit      Amount/Unit       Price/Unit    Total/acre    Grand Total     Farm
Horse Quality Hay                                  tons                     1.00   $   280.00    $   280.00   $   7,000.00
Medium Quality Hay                                 tons                     0.75   $   200.00    $   150.00   $   3,750.00
Lower Quality Hay                                  tons                     0.75   $   100.00    $    75.00   $   1,875.00
Other Income                                                                0.00   $      -      $      -     $        -
Totals                                                                      2.50                 $   505.00   $ 12,625.00

Variable Costs
Fertilizer
 3-7-28 (spread)                                   Lbs                  1250.00    $     0.14    $   175.00   $     4,375.00
 Other                                             Lbs                     0.00    $     0.15    $      -     $          -
 Sulfur                                            Lbs                    25.00    $     0.40    $    10.00   $       250.00
 Lime                                              tons                    0.25    $    24.00    $     6.00   $       150.00
Herbicides
2,4-D amine                                        Pints                    1.00 $       1.52    $     1.52   $        38.00
Velpar                                             Pints                    4.00 $       6.88    $    27.52   $       688.00
Other                                              Pints                    0.00 $      11.88    $      -     $          -
Irrigation (If Dryland enter 0 in
Amount/Unit)                                       Acre inch                4.00 $      14.37    $    57.49   $     1,437.21
Custom Hire
 Broadcast Sprayer                                 Times/Acre               3.00   $      6.00   $    18.00   $      450.00
 Rotary Mowing                                     Times/Acre               5.00   $    10.00    $    50.00   $    1,250.00
 Cut, rake, bale, and haul                         ton                      2.50   $    29.00    $    72.50   $    1,812.50
Fuel & Oil                                         Acre                    0.00    $       -     $      -     $         -
Repairs                                            Acre                    0.00          64.27   $      -     $         -
Labor                                              Hours                   0.00           9.02   $      -     $         -
Supplies                                           Acre                    1.00    $      7.50   $     7.50   $      187.50
Interest                                           %             $       212.76         7.50%    $    15.96   $      398.93
Total Variable Costs                                                                             $   441.49   $   11,037.15

Returns Over Variable Costs (ROVC)                                                               $    63.51   $    1,587.85

Herbicide applications based on 1 application of 2,4-d late winter and 2 applications of Velpar at 32 ozs. per application.
Custom hire prices are based on 2005 survey of custom operators in Georgia
                                            3a008e10-19b7-4342-b640-781a9cdbde7e.xls                                          Year 3



                                             PERENNIAL PEANUT HAY BUDGET
                                                Year 3 - Costs and Returns
                                                                                                                              Your
Revenue                                               Unit       Amount/Unit      Price/Unit    Total/acre     Grand Total    Farm
Horse Quality Hay                                 tons                     3.50   $   280.00    $   980.00    $ 24,500.00
Medium Quality Hay                                tons                     0.75   $   200.00    $   150.00    $   3,750.00
Lower Quality Hay                                 tons                     0.75   $   100.00    $    75.00    $   1,875.00
Other Income                                                               0.00   $      -      $      -      $        -
Totals                                                                     5.00                 $ 1,205.00    $ 30,125.00

Variable Costs
Fertilizer
 3-7-28 (spread)                                  Lbs                   1250.00   $     0.14    $    175.00   $    4,375.00
 Other                                            Lbs                      0.00   $     0.15    $       -     $         -
 Sulfur                                           Lbs                     25.00   $     0.40    $     10.00   $      250.00
 Lime                                             tons                     0.25   $    24.00    $      6.00   $      150.00
Herbicides
2,4-D amine                                       Pints                     1.00 $       1.52   $      1.52   $       38.00
Velpar                                            Pints                     4.00 $       6.88   $     27.52   $      688.00
Irrigation (If Dryland enter 0 in
Amount/Unit)                                      Acre inch                 4.00 $     14.37    $     57.49   $    1,437.21
Custom Hire
 Broadcast Sprayer                                Times/Acre               3.00   $      6.00   $     18.00   $      450.00
 Rotary Mowing                                    Times/Acre               4.00   $    10.00    $     40.00   $    1,000.00
 Cut, rake, bale, and haul                        ton                      5.00   $    29.00    $    145.00   $    3,625.00
Fuel & Oil                                        Acre                    0.00    $      8.86   $       -     $         -
Repairs                                           Acre                    0.00          64.27   $       -     $         -
Labor                                             Hours                   0.00           9.02   $       -     $         -
Supplies                                          Acre                    1.00    $      7.50   $      7.50   $      187.50
Interest                                          %              $      244.01         7.50%    $     18.30   $      457.53
Total Variable Costs                                                                            $    506.33   $   12,658.24

Returns Over Variable Costs (ROVC)                                                              $   698.67    $ 17,466.76

Herbicide applications based on 1 application of 2,4-d late winter and 2 applications of Velpar at 32 ozs. per application.
Custom hire prices are based on 2005 survey of custom operators in Georgia.
                                             3a008e10-19b7-4342-b640-781a9cdbde7e.xls                                           Year 4



                                              PERENNIAL PEANUT HAY BUDGET
                                                 Year 4 - Costs and Returns
                                                                                                                               Your
Revenue                                                Unit      Amount/Unit       Price/Unit    Total/acre    Grand Total     Farm
Horse Quality Hay                                  tons                     3.50   $   280.00    $   980.00   $ 24,500.00
Medium Quality Hay                                 tons                     0.75   $   200.00    $   150.00   $   3,750.00
Lower Quality Hay                                  tons                     0.75   $   100.00    $    75.00   $   1,875.00
Other Income                                                                0.00   $      -      $      -     $        -
Totals                                                                      5.00                 $ 1,205.00   $ 30,125.00

Variable Costs
Fertilizer
 3-7-28 (spread)                                   Lbs                  1250.00    $     0.14    $   175.00   $     4,375.00
 Other                                             Lbs                     0.00    $     0.15    $      -     $          -
 Sulfur                                            Lbs                    25.00    $     0.40    $    10.00   $       250.00
 Lime                                              tons                    0.25    $    24.00    $     6.00   $       150.00
Herbicides
2,4-D amine                                        Pints                    1.00 $       1.52    $     1.52   $        38.00
Velpar                                             Pints                    4.00 $       6.88    $    27.52   $       688.00
Irrigation (If Dryland enter 0 in
Amount/Unit)                                       Acre inch                4.00 $      14.37    $    57.49   $    1,437.21
Custom Hire                                                                                                   $         -
 Broadcast Sprayer                                 Times/Acre               3.00   $      6.00   $    18.00   $      450.00
 Rotary Mowing                                     Times/Acre               4.00   $    10.00    $    40.00   $    1,000.00
 Cut, rake, bale, and haul                         ton                      5.00   $    29.00    $   145.00   $    3,625.00
Fuel & Oil                                         Acre                    0.00    $      8.86   $      -     $         -
Repairs                                            Acre                    0.00          64.27   $      -     $         -
Labor                                              Hours                   0.00           9.02   $      -     $         -
Supplies                                           Acre                    1.00    $      7.50   $     7.50   $      187.50
Interest                                           %             $       244.01         7.50%    $    18.30   $      457.53
Total Variable Costs                                                                             $   506.33   $   12,658.24

Returns Over Variable Costs (ROVC)                                                               $   698.67   $ 17,466.76


Herbicide applications based on 1 application of 2,4-d late winter and 2 applications of Velpar at 32 ozs. per application.
Custom hire prices are based on 2005 survey of custom operators in Georgia.
                                            3a008e10-19b7-4342-b640-781a9cdbde7e.xls                                           Year 5



                                             PERENNIAL PEANUT HAY BUDGET
                                                Year 5 - Costs and Returns
                                                                                                                              Your
Revenue                                               Unit       Amount/Unit      Price/Unit    Total/acre     Grand Total    Farm
Horse Quality Hay                                 tons                     3.50   $   280.00    $   980.00    $ 34,300.00
Medium Quality Hay                                tons                     0.75   $   200.00    $   150.00    $   5,250.00
Lower Quality Hay                                 tons                     0.75   $   100.00    $    75.00    $   2,625.00
Other Income                                                               0.00   $      -      $      -      $        -
Totals                                                                     5.00                 $ 1,205.00    $ 42,175.00

Variable Costs
Fertilizer
 3-7-28 (spread)                                  Lbs                   1250.00   $     0.14    $    175.00   $    6,125.00
 Other                                            Lbs                      0.00   $     0.15    $       -     $         -
 Sulfur                                           Lbs                     25.00   $     0.40    $     10.00   $      350.00
 Lime                                             tons                     0.25   $    24.00    $      6.00   $      210.00
Herbicides
2,4-D amine                                       Pints                     1.00 $       1.52   $      1.52   $       53.20
Velpar                                            Pints                     4.00 $       6.88   $     27.52   $      963.20
Irrigation (If Dryland enter 0 in
Amount/Unit)                                      Acre inch                 4.00 $     14.37    $     57.49   $    2,012.10
Custom Hire
 Broadcast Sprayer                                Times/Acre               3.00   $      6.00   $     18.00   $      630.00
 Rotary Mowing                                    Times/Acre               4.00   $    10.00    $     40.00   $    1,400.00
 Cut, rake, bale, and haul from field             ton                      5.00   $    29.00    $    145.00   $    5,075.00
Fuel & Oil                                        Acre                    0.00    $      8.86   $       -     $         -
Repairs                                           Acre                    0.00          64.27   $       -     $         -
Labor                                             Hours                   0.00           9.02   $       -     $         -
Supplies                                          Acre                    1.00    $      7.50   $      7.50   $      262.50
Interest                                          %              $      244.01         7.50%    $     18.30   $      640.54
Total Variable Costs                                                                            $    506.33   $   17,721.54

Returns Over Variable Costs (ROVC)                                                              $   698.67    $ 24,453.46

Herbicide applications based on 1 application of 2,4-d late winter and 2 applications of Velpar at 32 ozs. per application.
Custom hire prices are based on 2005 survey of custom operators in Georgia.
                                          3a008e10-19b7-4342-b640-781a9cdbde7e.xls                          Machinery Cost Section



                                        MACHINERY COST DETAIL

Number of Acres                            135                                Return to Main Budget
Interest Rate                              7%


                                                               Percent Used
                                                                  in This     Cost to This     Salvage     Useful     Annual
                                                  Item Cost     Enterprise     Enterprise       Value       Life    Depreciation
 2wd 50 hp                                       $ 20,250.00           100%   $ 20,250.00    $ 4,050.00          10   $1,620.00
 2wd 105 hp                                      $ 49,250.00           100%   $ 49,250.00    $ 9,850.00          10   $3,940.00
 Commercial Square Hay Baler                     $ 14,500.00           100%   $ 14,500.00    $ 2,900.00          10   $1,160.00
 Medium Round Hay Baler                          $ 16,000.00           100%   $ 16,000.00    $ 3,200.00          10   $1,280.00
 9' Hay Mower/Conditioner                        $ 13,500.00           100%   $ 13,500.00    $ 2,700.00          10   $1,080.00
 8.5" Hay Rake                                   $ 2,900.00            100%   $ 2,900.00     $    580.00         10     $232.00
 17' Hay Tedder                                  $ 4,500.00            100%   $ 4,500.00     $    900.00         10     $360.00
20' field trailer (2)                            $ 5,000.00            100%   $ 5,000.00     $ 1,000.00          10     $400.00
8 bale accumulator                               $ 14,000.00           100%   $ 14,000.00    $ 2,800.00          10   $1,120.00
Grapple hook for accumulator                     $ 3,500.00            100%   $ 3,500.00     $    700.00         10     $280.00
Front-end loader w/spear                         $ 5,500.00            100%   $ 5,500.00     $ 1,100.00          10     $440.00
Total                                                                         $ 148,900.00   $ 29,780.00


Total depreciation on this enterprise                                                                               $11,912.00

Interest on Average Investment                                                                                           $6,254

Taxes and Insurance (Average investment times %)                                     1.40%                               $1,251

TOTAL ANNUAL FIXED COST                                                                                                 $19,417

TOTAL ANNUAL FIXED COST PER ACRE                                                                                        $143.83
                            3a008e10-19b7-4342-b640-781a9cdbde7e.xls     Building Cost Section



                     BUILDING COST DETAIL

Building Size (sq Ft)                   10,000.00 Interest on building                 7.00%
$/sq ft                       $               5.00 Insurance & Tax %                   1.40%
Cost                          $          50,000.00
Number of barns               $               1.00
Total Cost                    $          50,000.00
Useful Life                                  20.00
Salvage Value                 $          10,000.00
Depreciation                  $           2,000.00
Interest on Average
Investment                    $           2,100.00
Tax & Insurance Cost          $             420.00
Total Building Fixed Cost     $          4,520.00
                                                     3a008e10-19b7-4342-b640-781a9cdbde7e.xls
                                                                                                                                 Irrigation Cost Section



                                              MACHINERY COST DETAIL

                             CENTER PIVOT IRRIGATION (GRAVEL PACKED WELL)

                         Prepared by George Westberry and Kerry Harrison                                 Return to Budget
                          Ag. and Applied Econ. and Bio. and Ag. Engineering Dept.

                                                      Revised July 2004

                         CENTER PIVOT IRRIGATION (GRAVEL PACKED WELL)
                               APPROX. 500 FT GRAVEL PACKED WELL
     ACRES IN SYSTEM                               136
     INTEREST RATE                                8.00%


OPERATING COSTS

ENGINE HORSEPOWER                                        150
FUEL PER GAL                                             2.25
FUEL COST PER HR.                                       22.50
HOURS PER CIRCLE                                        70.00
FUEL COSTS PER ACRE IN.                                                                                  $           11.58
OIL COSTS PER ACRE IN.                                                                                   $            1.74
REPAIRS PER ACRE IN.                                                                                     $            0.92
LABOR                 0.02 HRS.                          @             9.00                              $            0.14

TOTAL OPERATING COSTS PER ACRE INCH                                                                       $          14.37


                                                                                                                             Return to Budget
                                             INVESTMENT COST SECTION
                                                                                                              TAXES AND
               ITEM                 INVESTMENT         YEARS     DEPRECIATION            INTEREST             INSURANCE

     SPRINKLER SYSTEM           $        40,000.00       15      $        2,666.67   $       1,600.00    $          298.67
     POWER UNIT                 $        13,500.00       12      $        1,125.00   $         540.00    $          102.38
     WELL                       $        48,000.00       20      $        2,400.00   $       1,920.00    $          352.80
     PUMP & GEARHEAD            $        14,000.00       12      $        1,166.67   $         560.00    $          106.17
     INSTALLATION               $         6,500.00       20      $          325.00   $         260.00    $           47.78
     LAND CLEARING              $         3,000.00       20      $          150.00   $         120.00    $           22.05

     TOTAL INVESTMENT           $      125,000.00                $        7,833.33   $       5,000.00    $          929.83

     TOTAL ANNUAL FIXED COSTS                                                                             $     13,763.17

     TOTAL ANNUAL FIXED COSTS PER ACRE                                                                    $         101.20




NOTE
Water source location and cost may differ substantially. This could effect investment , motor size and
operation costs.
                                                                                       3a008e10-19b7-4342-b640-781a9cdbde7e.xls
                                                                               Return to Budget
                       Assumptions                                                       Hauling Labor Cost Assumptions                                                                                   Hauling Cost Estimator
Truck(s)                                                                       Number of bales on Trailer                  275
                                                                               Number of hourly workers
Number of trucks                                             1                 loading/unloading/driving                      2
                                                                               Total hours to load and unload
Total miles per year                                 35,000.00                 trailer                                        3
Fuel MPG                                                  8.50                 Miles one-way                               150
                                                                               Hours driving (excluding loading
Tires needed how many miles                          35,000.00                 and unloading                                  6
Service at how many miles                             4,000.00                 Total Labor Hours/load                        18
Other                                                                          Labor Charge ($/Hr)               $        9.00
Other                                                                          Labor cost/trip                   $      162.00
Other                                                                          Labor cost/bale                   $        0.59
Trailer(s)                                                                     Labor cost/ loaded mile           $        1.08
Number                                                    2.00                 Hauling cost/mile excluding labor $        0.89
Trailer Miles per year                               10,000.00                 Labor cost/ loaded mile           $        1.08
 Tires needed how many miles                         35,000.00                 Total Hauling cost/ loaded mile $          1.97
Service at how many miles                             4,000.00
Interest Rate                                            8.00%
Insurance + Tax Rate                                     2.40%
                                                                                                                                                                            Average
                                                                                                              % Allocated to      Useful       Salvage       Annual         Annual        Annual        Ins +
Item                                              Number       Cost/item                 Total Cost           this Enterprise      Life         value      depreciation   Investment     Interest       Taxes   Total Fixed
1-ton pickup                                                 1 $40,000.00      $                    40,000.00           100%           5.0   $10,000.00   $    6,000.00   $ 25,000.00   $2,000.00   $    600.00 $ 8,600.00
Flatbed trailers for hauling                                 2 $ 8,000.00      $                    16,000.00           100%          10.0   $10,000.00   $      600.00   $ 13,000.00   $1,040.00   $    312.00 $ 1,952.00
Other                                                                          $                          -             100%           5.0   $       -    $          -    $       -     $      -    $       -   $       -
Other                                                                          $                          -             100%           5.0   $       -    $          -    $       -     $      -    $       -   $       -
Other                                                                          $                          -             100%           5.0   $       -    $          -    $       -     $      -    $       -   $       -
Totals                                                                         $                    56,000.00                                $20,000.00   $    6,600.00   $ 38,000.00   $3,040.00   $    912.00 $10,552.00

Annual Operating Expenses - RELATED TO THIS ENTERPRISE
                                                  Number of
                        Item                     Items/Year      Cost/Item              Annual Cost                 $/mile
Truck
 Fuel -Gallons                                          4,118    $     2.75    $                    11,323.53   $        0.32
 Replace tires on truck                                   1.00   $ 1,200.00    $                     1,200.00   $        0.03
 Service                                                  8.75   $    50.00    $                       437.50   $        0.01
 Tax and Tags                                                1   $   500.00    $                       500.00   $        0.01
 Repairs not covered under warranty                          1   $ 1,200.00    $                     1,200.00   $        0.03
Insurance                                                    1   $ 1,000.00    $                     1,000.00   $        0.03
Total Annual Operating Expenses for Truck                                      $                   15,661.03    $        0.45

Trailer
Replace tires on trailer                                   0.29 $ 1,200.00     $                      342.86    $        0.03
Service                                                    1.00 $   600.00     $                      600.00    $        0.06
Other                                                                          $                         -      $         -
Other                                                                          $                         -      $         -
Other                                                                          $                         -      $         -
Total Annual Operating Expenses Per Trailer                                    $                      942.86    $        0.09

                Total Annual Expenses               Total            $/Mile
Truck Operating                               $      15,661.03   $      0.45
Truck Fixed                                   $       8,600.00   $      0.25
Trailers + Other Operating                    $       1,885.71   $      0.09
Trailers + Other Fixed                        $       1,952.00   $      0.10

Total Hauling Expenses Excluding Labor         $ 28,098.74       $     0.89

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:8
posted:8/22/2011
language:English
pages:12