Docstoc

Ewe cost of production calculator - Ministry of Agriculture_ Food

Document Sample
Ewe cost of production calculator - Ministry of Agriculture_ Food Powered By Docstoc
					                    Ewe Flock Cost of Production Calculator
This calculator is designed to assist producers in determining their cost of production for their ewe flock. It
provides an assessment of feed costs, the cost and return to produce a lb of lamb, the profit (loss) per lb of
lamb produced, per ewe and on a flock basis.

Producers need to input their ewe information, days on stored feed and pasture and ewe costs which include
health and vet, breeding, yardage, feed costs and amount fed.


The lamb information section allows you to project your returns on your lamb crop. You fill in the number
marketed and retained, their average weight and your sale price or average value. This combined with your
ewe costs predicts your net return.


The calculator can evaluate past performance, as well as projecting ahead. It allows you to look at “What if”
scenarios, whether they are feed costs or value of lambs. Just overwrite the green numbers on the sample
cost of production calculator.


Remember the information provided by the calculator is only as accurate as the information you enter.


This calculator has been adapted from the Beef Feedlot COP Calculator.

Developed by:
Anita O'Brien, Sheep and Goat Specialist
John Molenhuis, Business Analysis and Cost of Production Program Lead

For more information contact:
                                    Agricultural Information Contact Centre
                                                1-877-424-1300
                                            ag.info@omaf.gov.on.ca
                                             www.omaf.gov.on.ca
               $ Ewe Flock Cost of Production Calculator $
                                   GREEN cells are those you can change                          Year         2003
      Flock Description                                                                          Date       13-Jul-11
                Ewes in Flock        450              Rams/ 100 ewes        2.5
                Ewe Cull Rate       15%                 Ram Cull Rate      20%
              Ewe Death Loss         2%               Ram Death Loss       10%
                Lambing Rate         1.0 times per       1 years =         1.00 times/year
       Lambs weaned / lambing       1.60 lambs weaned per ewe per year     1.60
        Post weaning lamb loss     1.5%
               % of lambs shorn    75%


               Days on Pasture      200                                     77 Replacement Ewes Raised

           Days on Stored Feed      165                                       0 Replacement Rams Raised



       Avg. weaning weight (lbs)     55                                    10% % lambs finish on Pasture
     Avg. Finishing Weight (lbs)     80                                     90 days lambs on pasture
  Feed Conversion: 1 lb gain per    6.0 lbs feed                            70 Avg. Wt. entering Feedlot

                                                                 PRICE
                    ITEM                  WEIGHT      UNIT       /UNIT          QUANTITY                         TOTAL
CASH INCOME
                Breeding Stock                        each         $200                                 $             -
           Replacement Lambs          -               each         $150                                 $             -
               Market Lambs 1       633          75   lbs         $1.25                                 $     59,473.80
                     Cull Ewes       68         140   lbs         $0.50                                 $      4,725.00
                    Cull Rams         2         200   lbs         $0.55                                 $        247.50
                   Wool- ewes       6.0 lbs / head    lbs         $0.40                                 $      1,082.70
                  Wool- lambs       3.0 lbs / head    lbs         $0.25                                 $        355.89
                                                      TOTAL CASH INCOME                                      $65,884.89
VARIABLE COSTS
 Ewe replacement purchases           -                each         $200                                 $             -
 Ram replacement purchases           2                each         $450                                 $        900.00

 Feed                     Calculate Feed Usage
 Lambs (after weaning)               FEED WASTE
    Mixed Hay                                5.0%     Tonne          $55             0.92               $         50.75
    Alfalfa Hay                              5.0%     Tonne          $80               -                $           -
    Corn                                     0.5%     Tonne         $160            15.01               $      2,401.48
    Barley                                  0.25%     Tonne         $145               -                $           -
    Protein Suppl. Pellet                   0.25%     Tonne         $400             1.76               $        704.81
    Soybean meal                            0.25%     Tonne         $320               -                $           -
    Salt                                     0.0%     Tonne         $200            0.002               $          0.35
    Mineral                                  0.0%     Tonne       $1,000            0.004               $          3.52
    Pasture                                           $/lamb/d    $0.015               -                $        966.60
 Ewes & Rams & Replacements)
    Mixed Hay                                5.0%     Tonne         $55             166.0               $      9,128.45
    Alfalfa Hay                              5.0%     Tonne         $80                 -               $           -
    Corn                                     0.5%     Tonne        $160              19.9               $      3,182.53
    Soybean Meal                            0.25%     Tonne        $320                 -               $           -
    Pellet Protein Suppl                    0.25%     Tonne        $400               1.5               $        584.72
    Corn Silage                              0.0%     Tonne                             -               $           -
    Salt                                     0.0%     Tonne         $200              2.3               $        461.27
    Mineral                                  1.0%     Tonne       $1,000              3.3               $      3,306.56
    Lamb Creep                               0.0%     Tonne         $350                 0 lbs /lamb    $           -
    Milk Replacer Powder                     0.0%     /20 kg         $60                 6 bags         $        360.00
    Pasture                                           $/ewe/d     $0.075                                $      2,283.75

                                                       Total Feed Costs                                 $     23,434.80
    Other Variable Costs
       Health Program                                    $6.45   / ewe                                             $          2,902.14
                                                                                                 Calculate Health
       National ID Tags 2                                $0.35   / head                               Costs        $            245.86
       Marketing                                         $3.75   / head                                            $          2,634.19
       Transportation                                    $4.50   / head                                            $          3,161.03
       OSMA Checkoff                                     $1.55   / head                                            $          1,088.80
       Shearing - ewes                                   $2.75   / head                                            $          1,240.59
       Shearing - lambs                                  $2.50   / head                                            $          1,329.75
       Building & Fence Repair                           $2.00   / ewe                                             $            900.00
       Machinery Repair & Maint.                         $2.00   / ewe                                             $            900.00
       Utilities                                         $0.90   / ewe                                             $            405.00
       Miscellaneous                                     $0.50   / ewe                                             $            225.00
                                        3
       Int. on Operating Expenses                        5.00    %                       6.0 Term of Loan (months) $            513.00

                                                                  TOTAL VARIABLE COSTS                                  $   39,880.14
                                            RETURN TO EQUITY, MANAGEMENT & OPERATOR LABOUR                                  $26,004.75
                                                 Net Return per Ewe with Lamb Price @ $1.25 per lb                              $57.79

                              Return over Variable Costs                     Lamb Price @         $0.95 / lb                    $26.07
                                                                                                  $1.10 / lb                    $41.93
                                                                                                  $1.35 / lb                    $68.36

1
  Market weights (lambs, ewes, rams) adjusted for 6% shrink
2
  Assumed tags applied when animals leave farm of origin                                                                 Go To Risk
3
  Includes 1/2 feed cost plus other variable cost less marketing(+ transportation & checkoff) costs                    Analysis Section


    FEED USAGE CALCULATIONS                                                                                  374           11
                                        EWES            EWES       EWES EWES EWES                RAMS    TOTAL
                                       E.GEST          L.GEST       LACT MAINT. FLUSH                   POUNDS      TOTAL
        No. days on Stored Feed             97             40            0           0    28        165   /EWE   POUNDS /RAM
    Ewes ( enter your feeds of choice)                                 lbs / day
      Mixed Hay                           5.00            5.00       0.00         0.00  4.00       7.00        797.0              1155
      Alfalfa Hay                         0.00            0.00       0.00         0.00  0.00       0.00          0.0                 0
      Corn                                0.00            1.50       0.00         0.00  0.75       0.00         81.0                 0
      Soybean Meal                       0.000           0.000      0.000        0.000 0.000      0.000          0.0                 0
      Pellet Protein Suppl               0.000           0.100      0.000        0.000 0.000      0.000          4.0                 0
      Corn Silage                         0.00            0.00       0.00         0.00  0.00       0.00          0.0                 0
      Salt                               0.030           0.030      0.030        0.030 0.030      0.045         11.0              16.4
      Mineral                            0.045           0.045      0.045        0.045 0.045      0.060         16.4              21.9

                                                                                                            TOTAL POUNDS
    Replacement Ewes(110 lbs)                                                                  REPLAC.      REPLACEMENT
    (feeds MUST be in SAME sequence as Ewes for formulas to work properly)                      RAMS      EWES          RAMS
         No. days on Stored Feed                 97         40          0          0    28          165        77           0
        Mixed Hay                              3.00       3.00       0.00       0.00  3.00         4.50     495.0         0.0
        Alfalfa Hay                            0.00       0.00       0.00       0.00  0.00         0.00       0.0         0.0
        Corn                                   1.00       1.25       0.00       0.00  1.00         0.50     175.0         0.0
        Soybean Meal                           0.00       0.00       0.00       0.00  0.00        0.000       0.0         0.0
        Pellet Protein Suppl                   0.10       0.25       0.00       0.00  0.10        0.100      22.5         0.0
        Corn Silage                            0.00       0.00       0.00       0.00  0.00         0.00       0.0         0.0
        Salt                                  0.020      0.020      0.020      0.020 0.020        0.020      10.6         0.0
        Mineral                               0.030      0.030      0.030      0.030 0.030        0.030      11.0         0.0


                                            Lamb Finishing Ration - as fed basis
                                            Enter Percentages as Decimal Equivalents
                                             (EXAMPLE 10% = 0.10)                                                Return to COP
                                              0.050 Mixed Hay                                                      Calculator
                                              0.000 Alfalfa Hay
                                              0.850 Corn
                                              0.000 Barley
                                              0.100 Protein Suppl. Pellet
                                              0.000 Soybean meal
                                            0.0001 Salt
                                            0.0002 Mineral
                                            000000 Other
                                            1.0000
CALCULATE HEALTH PROGRAM COSTS                           374 Ewes
                                                          11 Rams
Ewes & Rams
Wormer (name product)                  2.0   DOSE @   $ 1.49 /DOSE          $    2.98
Clostridial Vaccine (Booster 2ml)      0.5   DOSE @   $ 0.30 /DOSE          $    0.15
Other                                  0.0   DOSE @   $ -    /DOSE          $     -
Other                                  0.0   DOSE @   $ -    /DOSE          $     -
Other                                  0.0   DOSE @   $ -    /DOSE          $     -
                                                                            $    3.13
Health Program Cost for Ewes & Rams                                   $      1,204.27


Lambs                                                    720 Lambs
Selenium injection                     0.0   DOSE @   $ 0.08 /DOSE          $     -
Clostridial Vaccine (4ml)              1.0   DOSE @   $ 0.30 /DOSE          $    0.30
Wormer                                 2.0   DOSE @   $ 0.64 /DOSE          $    1.28
Other                                  0.0   DOSE @   $ -    /DOSE          $     -
Other                                  0.0   DOSE @   $ -    /DOSE          $     -
                                                                            $    1.58
Health Program Cost for Lambs                                         $      1,137.60

Replacement Ewe Lambs                                   77 Replacement Lambs
Wormer                                 1.0 DOSE @  $ 0.64 /DOSE              $     0.64
Vaccine (booster 2ml)                  0.5 DOSE @  $ 0.30 /DOSE              $     0.15
Other                                  0.0 DOSE @  $ -                       $      -
                                                                             $     0.79
Health Program Cost for Replacement Lambs (ewes & rams)               $           60.44

Lambs entering Feedlot                                   633
Wormer                                 1.0 DOSE @     $ 0.64 /DOSE          $      0.64   Return to Other
Vaccine (booster 2ml)                  0.5 DOSE @     $ 0.30 /DOSE          $      0.15   Variable Costs
Other                                  0.0 DOSE @     $ -    /DOSE          $       -
                                                                            $      0.79
Health Program Cost for Lambs Entering Feedlokt                       $          499.83

                                    Flock Health Program Costs        $      2,902.14
Risk Analysis
Expected returns are subject to the risk of fluctuations in both revenue and expenses.
Increases in sale prices received, decreases in your cost of production, increases in your lambs weaned and decreases in your lamb death loss will have
positive impacts on your net return. Conversely, sale price decreases, increases to your cost of production, decreases in lambs weaned and increases in death
loss will have negative impacts on your net return. The expected values that you inputted for the key ewe flock risk variables are displayed below on the left.
Change the key risk variables identified for the ewe flock enterprise in the boxes provided to the right to see how they will affect your net return.
Enter negative values if you would like to decrease the value of the variable and positive values to increase the value.
Enter zero for any variable you would like to remain at the same level as specified in the Expected section.

Expected values (from calculator):                          Change Key Ewe Flock Variables:        +/-%                      Results of the change:
Expected Lamb Sale price ($/lb)             $1.25                  Percent Change in Sale price    -10%                         New sale price:   $        1.13
Expected Variable Cost per Ewe        $     88.62              Percent Change in Variable Cost      10%                     New Variable Cost:    $       97.48
Expected Lambs Weaned per Ewe                1.60            Percent change in Lambs Weaned         10%                  New Lambs Weaned:                 1.76
Expected Lamb Death Loss (after                                        Percent change in Lamb
weaning)                                      1.5%                  Death Loss (after weaning)      -20%                New Lamb Death Loss:               1.2%
                                       Net Return
                                        Per Ewe
                                       $    57.79 Net return per Ewe before changes to Key Ewe Flock Risk Variables


                                       $    49.49 Net Return after changes in Key Ewe Flock Risk Variables
                                                                                                                                                      Return to COP
                                                                                                                                                        Calculator

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:16
posted:7/13/2011
language:English
pages:5