Docstoc

cow-calf

Document Sample
cow-calf Powered By Docstoc
					Calculating Unit Cost of Production for a Beef Cow Operation



              Spreadsheet developed for use with the High Plains Ranch Practicum School

                                            Instructions:
                         Complete orange shaded areas of green tabs below.
                         Use Orange tabs to help calculate some of the items.
                                 Blue tab provides summary values

                                  Questions: Contact Dallas Mount
                                           307-322-3667
                                        dmount@uwyo.edu
Section 1: Production Profile

         January 1 Number of Beef Cows          285   # of Head Total Jan 1 Inventory producing females    325
      January 1 Number of Bred Heifers           40   # of Head                                                        Pregnancy Percentage      89.3%
        Jan 1 Replacement Heifer Calves           0   # of Head                                                                Pregnancy Loss    10.7%
         SPA Adjusted Females Exposed           364   # of Head (Use tab at bottom if needed)                              Culling Percentage    13.7%
    Cows and heifers exposed that bred          325   # of Head                                                            Calving Percentage    87.6%
                       Live Calves Born         319   # of Head                                                          Weaning Percentage      83.2%
                                                           #      Average Weight       Total lbs weaned                     Replacement Rate     13.7%
                   Live Calves Weaned Steers                 137                 515               70555                      Cow Death Loss      1.8%
                                      Heifers                166                 475               78850                       Calf Death Loss    5.0%
                                      Bulls                                                            0             Average Weaning Weight        493
                                      Total                  303                                  149405         Lbs Weaned/Female Exposed         410

               Number of Cows Culled             39 # of Head
             Number of Cows that Died             5 # of Head
                     Calves that Died            16 # of Head
Section 2: Gross Income

                                          Number         Avg Wt        Price/cwt     Total
                          Steer Calves             137             515 $      125.00  $ 88,193.75
                         Heifer Calves             166             475 $      120.00  $ 94,620.00
                             Cull Cows              39            1200 $       49.00  $ 22,932.00
             Cull Replacement Heifers                                                 $       -
                             Cull Bulls              3            1900 $       59.00 $ 3,363.00
                        Other Income                                                  $       -
                        Other Income                                                  $       -


                  Beef Cow Inventory (Click tab below to calculate inventory)
                                     Beginning       $                368,500.00
                                     Ending          $                367,400.00
                                     Difference      $                 (1,100.00)

                   Total Gross Income $                  208,008.75
                   Gross Income/Cow $                        640.03
              cwt steer calf equivalent            5.1                 *This is a factor used to convert all income to a steer calf equvalent
   Price Received per Cwt of Steer Calf $                    125.00
Section 3: Feed Costs
Winter Feed Costs for previous winter to calf crop, summer pasture costs for current summer
Pasture Rent
Pasture Rent                                                                        Total             Total/Cow
                      Acres/Cow/year                          Rent Per Acre          $          -      $      -
or                    AUM/Cow/year                            Per AUM                $          -      $      -
or                  8 Cow/calf pair months                 22 Per Cow-calf pair      $    57,200.00    $ 176.00

           Public Land Payment                 $    1,500.00 $/herd                 $     1,500.00 $        4.62
           Aftermath Grazing                   $    9,750.00 $/herd                 $     9,750.00 $       30.00

Pasture Maintenance costs                      $   1,500.00 $/year                  $     1,500.00 $        4.62    (share to the cow herd in addition to pasture rent)
Feed       Amt                                $/Unit
Hay              350 # of tons                 $      90.00 $/ton                   $    31,500.00 $       96.92    Use market price for farm raised feeds
Salt and Mineral
                     # of tons                                $/ton                 $           -     $      -
Protein
                     # of tons                                $/ton                 $     6,000.00 $       18.46
Other Feed 1
                     # of units                               $/unit                $           -     $      -
Other Feed 2
                     # of tons                                $/ton                 $           -     $      -

Total Feed Costs                                                                    $   107,450.00        $330.62
Total Feed Cost/CWT of steer calf                              $            64.57
ure rent)
Section 4: Livestock Costs
                                                                   Total              Total/Cow
Preventitive Medicine (Vaccines etc.)   $ 3,500.00 $/herd
Treatment costs                                    $/herd
Vet costs                                          $/herd
                                                   Total Vet Med   $       3,500.00 $     10.77
Replacement Heifers
Number of replacements                           40                $   35,200.00 $ 108.31         1. Include only hfr development costs - not weaning market value
Cost of Developing Heifers                  $880.00 $/rep hfr                                     2. Suggest $300 to $350 per heifer developed




Fuel Costs                                $3,000.00   $/herd       $       3,000.00   $    9.23   (Beef cow herd only - Feeding cows, checking pasture etc.)
Livestock Supplies                        $2,800.00   $/herd       $       2,800.00   $    8.62
Utilities                                 $1,200.00   $/herd       $       1,200.00   $    3.69   Beef cow herd share
Trucking                                      $0.00   $/herd       $            -     $     -
Marketing                                 $1,000.00   $/herd       $       1,000.00   $    3.08
Bull Depreciation for Total Herd          $7,500.00   $/herd       $       7,500.00   $   23.08
Other Breeding costs (AI, etc.)           $1,000.00   $/herd       $       1,000.00   $    3.08
Hired Labor for Beef cows only            $8,000.00   $/herd       $       8,000.00   $   24.62   (Wages plus benefits)

Interest                                                       %
Interest on Operating Capital                                                $0.00      0 Beef cow herd share
                                                      Total         $ 63,200.00 $ 194.46
                                                                   Total per CWT $ 37.98
etc.)
Section 5: Overhead Costs (Beef Cow Herd Share Only)   Use DIRTI-Five from tab below to figuire % to charge
                                                       Use overhead calculator tab to figuire total $$/herd
                                                           %         Total    Per Cow
Breeding Herd Capital Investment              $/herd                    $0.00 $      -
Building Investment                $55,000.00 $/herd       8.00% $4,400.00 $ 13.54
Equipment Investment               $81,500.00 $/herd      13.00% $10,595.00 $ 32.60
                                                       Total      $14,995.00      $46.14
                                                                 Per CWT            $9.01
Unit Cost of Production Summary

                                                                   Total Per CWT of
                                    Totals     Total per Cow          Steer Calf
                     Feed Costs    $107,450.00        $330.62                $64.57
                 Livestock Costs    $63,200.00        $194.46                $37.98
                      Overhead      $14,995.00          $46.14                $9.01
                  Gross Income     $208,008.75          $640.03            $125.00
                     Total Costs   $185,645.00          $571.22            $111.56
     Returns to Unpaid Operator
  Labor, Management, and Equity     $22,363.75            $68.81            $13.44
                                         Unit Cost of Production           $111.56
Comparison to Benchmarks
                            2008 North Dakota     NE WY 2008     Your Ranch
Item                              $/cow             $/cow            $/cow
Feed Supplements            $           14.02   $        22.65    $      18.46
Hay                         $          128.03   $       131.55    $      96.92
Pasture                     $           94.37   $       167.27    $       9.23
Other Feed                  $           51.51   $         8.09    $      30.00
Total Feed                  $          287.93   $       329.56    $     154.62

Veterinary                  $           17.31   $        14.07   $       10.77
Supplies                    $           12.30   $        13.22   $        8.62
Fuel and Oil                $           26.22   $        24.20   $        9.23
Marketing                   $            3.54   $         8.08   $        3.08
Heifer Development                              $        87.14   $      108.31
Hired Labor                 $           11.87   $        43.00   $       24.62
Operating Interest          $           10.19   $         0.53   $         -
Utilities                   $            8.06   $        13.22   $        3.69
Other Livestock Costs       $            1.67   $        24.11   $       26.15
Total Livestock Costs       $           91.16   $       227.57   $      194.46

Total Overhead              $           90.54 $          44.12 $         46.14


Unit Cost of Production     $           85.94 $        110.44 $         111.56

Production
Number of cows                           163.4             297             285
Pregnance percentage                    97.4%                            89.3%
Culling %                               16.4%                            13.7%
Calving %                               95.2%            89.0%           87.6%
Weaning %                               90.5%                            83.2%
Calf death loss %                         5.5%                            5.0%
Cow death loss %                          1.3%                            1.8%
Average weaning Wt                         551                             493
Lbs weaned/exposed female                  498             484             410
Steer price/cwt             $          110.00 $         112.00 $        125.00
Gross Income per cow        $          466.19 $         587.68 $        640.03
Breeding Inventory Reconcilieation for SPA Adjusted Exposed Females
Note: Exposed female numbers should include all replacement heifers as well as adult breeding cows. Female numbers shou
                                                                                              For Year:
                                                                        Reported Calving Starting Date
                                      Total Females Exposed at the begininning of the breeding season
            Culled exposed females not intended to be calved but in the exposed herd at breeding time
                             exposed females sold or transferred out before the breeding season ends
                              Exposed females purchased or transferred-in during the breeding season

Adjsustments After Breeding Season End
                                       Open females sold or transferred out after the breeding season
                                    Pregnant females sold or transferred out after the breeding season
           Exposed females sold or transferred out after the breeding season wihout pregnancy testing
                                                                                                  Total
                 Exposed and pregnant females purchased or transferred in after the breeding season

Adjustments after Calving Season Begins
                       Females sold or transferred out with nursing calves between calving and weaning
                  Females purchased or transferred in with nursing calves between calving and weaning

                                                                       SPA Adjusted Females Exposed
ng cows. Female numbers should not be adjusted for death loss.




                     0




                     0
Cow Herd Inventory Change

                              Jan 1 Current   Dec 31       Dollars per
Description of Cattle              year     Current year     head       Beginning Value   Ending Value
Mature Cows                             285          284 $    1,100.00 $ 313,500.00       $ 312,400.00
Replacement heifer calves                                                $         -      $         -
Coming two year old heifers              40           40 $    1,000.00 $ 40,000.00        $ 40,000.00
Mature Bulls                             15           15 $    1,000.00 $ 15,000.00        $ 15,000.00
Other 1                                                                  $         -      $         -
Other 2                                                                  $         -      $         -
                                                                 Totals $ 368,500.00      $ 367,400.00
    Difference
$        (1,100.00)
$              -
$              -
$              -
$              -
$              -
$        (1,100.00)
DIRTI Five - Rough estimate for overhead costs associated with vairous categories

                           Buildings           Equipment             Cows
                      Suggested    Yours  Suggested   Yours   Suggested   Yours
        Depreciation       5.0%               10.0%
             Interest      6.0%                 6.0%               6.0%
              Repairs      1.0%                 2.0%
               Taxes
           Insurance       1.0%                 1.0%               1.0%
        DIRTI Factor      13.0%      0.0%     19.0%      0.0%      7.0%     0.0%
   Excluding Interest      7.0%      0.0%     13.0%      0.0%      1.0%     0.0%
Use to calculate total amount of inventory for overhead

Equipment
                         Estimated
Item                    current value   % to cow herd   Total $
                                                         $         -
                                                         $         -
                                                         $         -
                                                         $         -
                                                         $         -
                                                         $         -
                                                         $         -
                                                         $         -
                                                         $         -
                                                         $         -
                                        Total Equipment $          -   use this number on overhead sheet
Buildings
                         Estimated
Item                    current value   % to cow herd    Total $
                                                          $        -
                                                          $        -
                                                          $        -
                                                          $        -
                                                          $        -
                                                          $        -
                                                          $        -
                                                          $        -
                                                          $        -
                                         Total Buildings $         -   use this number on overhead sheet
mber on overhead sheet




mber on overhead sheet

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:8/26/2012
language:English
pages:17