Hunting Lease Liability Insurance by qel22006

VIEWS: 8 PAGES: 9

More Info
									                                                               Activity Level, Frequency, & Allocation
                 Support Centers                                               Production Cost Centers                                  Profit Centers
                 Level 1 (Complete First)                                       Level 3 (Complete & Allocate 3rd)                     Level 4 (Final Allocations)
                    GENERAL FARM                                                 WHEAT PRODUCTION COSTS                               WHEAT PROFIT CENTER
   Items                         Rules                 Rate            Items                        Rules            Rate   Items                      Rules            Rate




                          LAND
   Items                         Rules                 Rate                     BARLEY PRODUCTION COSTS                              BARLEY PROFIT CENTER
                                                                       Items                        Rules            Rate   Items                      Rules            Rate




                          SG&A
   Items                         Rules                 Rate                     CANOLA PRODUCTION COSTS                              CANOLA PROFIT CENTER
                                                                       Items                        Rules            Rate   Items                      Rules            Rate




                        FINANCE
   Items                         Rules                 Rate                       HAY PRODUCTION COSTS                                 HAY PROFIT CENTER
                                                                       Items                        Rules            Rate   Items                      Rules            Rate




        Level 2 (Intermediate 2nd level calculation)          (INSERT OTHER ENTERPRISES….)
           EQUIPMENT SUPPORT COST CENTER
   Items                         Rules                 Rate                                                                     CUSTOM APPLICATION PROFIT CENTER
                                                              NOTE; For a service type enterprise like custom               Items                      Rules            Rate
                                                              application, you would not normally have a related
                                                              production cost center, as you are not manufacturing
                                                              inventory.
      OTHER INCOME & EXPENSE COST CENTER
   Items                         Rules                 Rate




843ea588-8bc3-486e-bc37-114b5a9b0403.xls                                                   Allocations                                                              11/13/2010
      General Farm Overhead Cost Center Report
    Revenue/Cost Recovery                                  Total for Farm     $ Alloc to Hay
    Custom Hire Income - labor reimbursement                                  $     1,000.00
    Coop Patronage Income - (Supplies & Utility Co)                           $     2,500.00
1                         Total Revenue / Cost Recovery                       $     3,500.00
    Production Costs - Direct
    Labor (2 key employees)                                                   $    28,700.00
    Living Draw (Hay share of operation)                                      $    24,000.00
    Employee Benefits (groceries & medical)                                   $    12,000.00
    Utilities-house/shop/office (Hay Op share)                                $     7,200.00
    Supplies (for hay side of Op)                                             $     3,300.00
    Fuel - Lube (non farm equipment/pers vehicles)                            $     9,600.00
    Life Insurance                                                            $       800.00
    Dues & Publications (Hay share only)                                      $       175.00
2                          Total Direct Production Costs                      $    85,775.00
    Production Costs - Indirect
            (Non applicable in first level reports)                                 na
3                        Total Indirect Production Costs                      $          -
4 Total Direct & Indirect Production Costs (2+3)                              $    85,775.00
5 Total (4 - 1)                                                               $    82,275.00


                                Capture Period:                                                Allocation Rules:
                              Jan 1 - Dec 31, 200X




    843ea588-8bc3-486e-bc37-114b5a9b0403.xls                    Gen Farm OH                                        11/13/2010
    Equipment Cost Center Report - Hay Op Allocation
    Revenue / Cost Recovery                                      Total for Farm      % to Hay       Tot $-Hay Oper
        Gain / Losses on Equipment Sales                                                        $         7,600.00
        Custom Hire Income (Custom Swathing & Raking)                                           $         2,700.00
        Equipment Rental Income- Direct Seed drill rent                                         $         2,600.00
1                              Total Revenue / Cost Recovery                                    $       12,900.00
    Production Costs - Direct
        Fuel & lube expense                                                                     $       15,200.00
        Repairs, Tools & Equip Supplies                                                         $       20,500.00
        Depreciation (Mach & Equip for hay operation)                                           $       19,200.00
        Baling ($18/t) & stacking ($4.00/t)                                                     $      123,200.00
        Equipment Rent Expense (for hay operation)                                              $         4,200.00
        Prop Tax Equip - Equipment                                                              $         2,300.00
        Licensing (hay share of operation)                                                      $          700.00
        Vehicle Insurance (hay share of Operation)                                                      $2,400.00
2                               Total Direct Production Costs                                   $      187,700.00
3                             Total Indirect Production Costs                                   $              -
4       Total Direct & Indirect Production Costs (2+3)                                          $      187,700.00
5       Net Equipment Support Costs (4 - 1)                                                     $      174,800.00
6       Total Acres Farmed                                                   750.0
        Total Tons Hay Raised & Sold                                       5,570.0




843ea588-8bc3-486e-bc37-114b5a9b0403.xls             Equipment                                       11/13/2010
                      Land Cost Center Report
    Revenue / Cost Recovery                                        Total Farm       $/Acre   $ Alloc to Hay $/Ac-Hay Op

        Gains / losses on property Sales                     $            -     -            $       5,000.00   $      6.67
        Land Rental Income                                   $            -     -            $            -     $       -
        Government Payments - Conservation Cost Shares       $            -     -            $       3,000.00   $      4.00
1                              Total Revenue / Cost Recovery $            -     $      -     $       8,000.00   $     10.67
                                                                                                                              Why wou
    Operating Costs - Direct                                                                                                  an oppo
        Cash Rent & Lease Fees for dryland range             $            -     -            $            -     $       -     rate in th
        Repair Costs - Build & Improvements                  $            -     -            $       2,700.00   $      3.60
                                                                                                                              Because
        Real Estate Taxes                                    $            -     -            $       7,730.00   $     10.31   actual
                                                                                                                              If you inc
        Building & Improvements Insurance                    $            -     -            $         700.00   $      0.93
                                                                                                                              land ren
        Professional Fees-land related (appraisals)          $            -     -            $         600.00   $      0.80   here…yo
        Property Management Fees                             $            -     -            $       8,000.00   $     10.67   with r.e.
                                                                                                                              interest a
        Conservation Expenses                                $            -     -            $       2,000.00   $      2.67   structure
2                                Total Direct Operating Costs $           -     $      -     $      21,730.00   $     28.97
3       Total Land Costs (2-1)                               $            -     $      -     $      13,730.00   $     18.31
        Total Acres Farmed                                               0.0                            750.0


                                   Capture Period:                                               Allocation Rules:
                                 Jan 1 - Dec 31, 200X




    843ea588-8bc3-486e-bc37-114b5a9b0403.xls                Land                                                11/13/2010
                                     SG & A Cost Center Report
    Revenue / Expense Recovery                                    Tot Farm Amt       % to Hay   $ Alloc to Hay

        (not normal to have Exp Recovery to this Center)
1                          Total Revenue / Expense Recovery $                 -
    Operating Expense - Direct
        General Management                                                                      $    12,000.00
        Office / Postage                                                                        $     2,300.00
        Liability Insurance                                                                     $     3,300.00
        Professional Fees                                                                       $     3,450.00
        Office Staff                                                                            $     5,400.00

2                              Total Direct Operating Expense $               -                 $    26,450.00
                                                                    Total acres-->                  750.0


                           Capture Period:                                     Allocation Rules:
    Jan 1 - Dec 31, 200X




    843ea588-8bc3-486e-bc37-114b5a9b0403.xls          SG & A                                         11/13/2010
                    Finance Cost Center Report

    Revenue / Cost Recovery                                          Tot Farm Amt   % Alloc to Hay

        Interest Rebates/ Dividend (FCS interest rebate)         $             -
        Interest earned (MM Accts, CDs, etc.)


1                              Total Revenue / Cost Recovery $                 -
    Financing Expense*
        Interest - Operating Loans                               $             -
        Interest - Long Term Debt                                $             -
        Interest - Equipment Loans & Circles                     $             -
        Finance Charges                                          $             -
        Loan Fees, Appraisal Costs                               $             -

2                                       Total Finance Expense $                -
3                                    Net Finance Expense (2-1) $               -
        * Excludes Debt Principal Pmts--not deductible expense
                           Capture Period:                                                 Allocation Rules:
    Jan 1 - Dec 31, 200X
                                                 Other Expense & Income

        Revenue / Cost Recovery                                         Amount       % Alloc to Hay

            Non Commodity Linked Pmts (USDA Direct Payments)
            Non Farm Income & Hunting Receipts


                                                                   $             -
    1                              Total Revenue / Cost Recovery $               -
        Non-Farm Operating Expenses
            Non - Farm Operating Expenses                          $             -


                                                                   $             -
    2                      Total Non-Farm Operating Expenses $                   -
    3                                                   Total (4-1) $            -


   Notes:
                               Capture Period:                                               Allocation Rules:
        Jan 1 - Dec 31, 200X




843ea588-8bc3-486e-bc37-114b5a9b0403.xls         OthInc Exp Ctr                              11/13/2010
Production Cost Center Report                                   Commodity -->               Alfalfa & Grass Hay
                                                                       Number                Unit

         Marketing Units (bus, tons, cwt, lbs)                                  5570 tons
         Production Units (Acres, Cow AU's, etc. )                              750.0 ac
     Revenue / Cost Recovery                                           Amount               $/Acre               $/Qty Prod

         Commodity By Product Revenue                           $                -    $                -     $                -
         Grazing after last cutting 2006                        $         7,440.00    $               9.92   $            1.34
 1                               Total Revenue / Cost Recovery $          7,440.00    $               9.92   $            1.34
     Production Costs - Direct
         Seed                                                   $        14,977.60    $              19.97   $            2.69
         Fertilizer                                             $        70,837.51    $              94.45   $           12.72
         Chemicals                                              $        23,764.01    $              31.69   $            4.27
         Custom Chemical Application                            $         8,916.00    $              11.89   $            1.60
         Electricity for circles & pumps                        $        29,965.19    $              40.33   $            5.38
         Water (project water)                                  $         8,232.00    $              10.98   $            1.48
         Tarping Hay                                            $        34,257.74    $              45.68   $            6.15

 2                                Total Direct Production Costs $       190,950.05    $             254.98   $           34.28
     Production Costs - Indirect
                              Allocated From
         General Farm Overhead                                  $        82,275.00    $             109.70   $           14.77
         Equipment Cost Center                                  $       174,800.00    $             233.07   $           31.38
         Land Cost Center                                       $        13,730.00    $              18.31   $            2.46
 3                             Total Indirect Production Costs $        270,805.00    $             361.07   $           48.62

 4                           Total Dir & Indir Prodn Costs (2+3) $      461,755.05    $             616.05   $           82.90
 5                                 Total Production Costs (4-1) $       454,315.05    $             606.13   $           81.56

Notes:
                            Capture Period:                                                     Allocation Rules:
     Jan 1 - Dec 31, 200X




     843ea588-8bc3-486e-bc37-114b5a9b0403.xls         Prodn Cost Ctr                                             11/13/2010
Profit Center Report                                             Commodity -->             Alfalfa/Grass Hay
                                                                                      Farm Name                            Here is Prof
                                                                       Number                 Unit                 Tons/Ac 100
                                                                                                                           Farm made
         Marketing Units (bus, tons, cwt, lbs)                                   5570 tons                            7.43
         Production Units (Acres, Cow AU's, )                                    750.0 Acres                                  Does this te
     Commodity Revenue                                                 Amount                $/Acre*           $/Qty Mktd     about perfo
                                                                                                                              manageable
         Alfalfa/Grass Hay                                       $       713,000.00    $        950.67     $        128.01
         LDPs /CCP (commodity specific gov pymts)                $                -    $               -   $           -   Not really…
                                                                                                                           components
 1                                  Total Commodity Revenue $            713,000.00    $        950.67     $        128.01
                                                                                                                           structure.
 2       Total Production Costs (see Prod Cost Center)           $       454,315.05    $        605.75     $         81.56
 3                                    Production Margin (1 - 2) $        258,684.96    $        344.91     $         46.44
     Other Expenses & Income
         Allocation from Sales, Gen & Admin Cost Center          $        26,450.00    $          35.27    $          4.75
         Allocation from Finance Cost Center (Ld, Eq, Circles)   $        61,250.00    $          81.67    $         11.00
                                                                                                                           Look at how
         Allocation from Oth Exp/Inc (GovPmts & Hunting)         $       (24,860.00) $           (33.15) $           (4.46)
                                                                                                                           from govt p
 4                           Total Other Expense and Income $             62,840.00    $          83.79    $         11.28 hunting red
 5                     Margin After Other Exp & Income (3-4) $           195,844.96    $        261.13     $         35.16 cost structu


Notes:




843ea588-8bc3-486e-bc37-114b5a9b0403.xls           Profit CTR Report                                              11/13/2010

								
To top