ewe flock cost production calculator by ocak

VIEWS: 283 PAGES: 5

									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 Flock Description Ewes in Flock Ewe Cull Rate Ewe Death Loss Lambing Rate Lambs weaned / lambing Post weaning lamb loss % of lambs shorn Days on Pasture Days on Stored Feed 450 Rams/ 100 ewes 15% Ram Cull Rate 2% Ram Death Loss 1.0 times per 1 years = 1.60 lambs weaned per ewe per year 1.5% 75% 200 165 77 Replacement Ewes Raised 0 Replacement Rams Raised 2.5 20% 10% 1.00 times/year 1.60 Year Date 2003 14-Aug-08

Avg. weaning weight (lbs) Avg. Finishing Weight (lbs) Feed Conversion: 1 lb gain per

55 80 6.0 lbs feed PRICE /UNIT $200 $150 $1.25 $0.50 $0.55 $0.40 $0.25

10% % lambs finish on Pasture 90 days lambs on pasture 70 Avg. Wt. entering Feedlot

ITEM CASH INCOME Breeding Stock Replacement Lambs Market Lambs 1 Cull Ewes Cull Rams Wool- ewes Wool- lambs VARIABLE COSTS Ewe replacement purchases Ram replacement purchases

WEIGHT

UNIT each each lbs lbs lbs lbs lbs

QUANTITY $ $ $ $ $ $ $

TOTAL 59,473.80 4,725.00 247.50 1,082.70 355.89 $65,884.89 $ $ 900.00

633 75 68 140 2 200 6.0 lbs / head 3.0 lbs / head

TOTAL CASH INCOME 2 each each $200 $450

Calculate Feed Usage Feed Lambs (after weaning) FEED WASTE Mixed Hay 5.0% Alfalfa Hay 5.0% Corn 0.5% Barley 0.25% Protein Suppl. Pellet 0.25% Soybean meal 0.25% Salt 0.0% Mineral 0.0% Pasture Ewes & Rams & Replacements) Mixed Hay 5.0% Alfalfa Hay 5.0% Corn 0.5% Soybean Meal 0.25% Pellet Protein Suppl 0.25% Corn Silage 0.0% Salt 0.0% Mineral 1.0% Lamb Creep 0.0% Milk Replacer Powder 0.0% Pasture

Tonne Tonne Tonne Tonne Tonne Tonne Tonne Tonne $/lamb/d Tonne Tonne Tonne Tonne Tonne Tonne Tonne Tonne Tonne /20 kg $/ewe/d

$55 $80 $160 $145 $400 $320 $200 $1,000 $0.015 $55 $80 $160 $320 $400 $200 $1,000 $350 $60 $0.075

0.92 15.01 1.76 0.002 0.004 166.0 19.9 1.5 2.3 3.3 0 lbs /lamb 6 bags

$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $

50.75 2,401.48 704.81 0.35 3.52 966.60 9,128.45 3,182.53 584.72 461.27 3,306.56 360.00 2,283.75 23,434.80

Total Feed Costs

Other Variable Costs Health Program National ID Tags 2 Marketing Transportation OSMA Checkoff Shearing - ewes Shearing - lambs Building & Fence Repair Machinery Repair & Maint. Utilities Miscellaneous Int. on Operating Expenses

3

$6.45 $0.35 $3.75 $4.50 $1.55 $2.75 $2.50 $2.00 $2.00 $0.90 $0.50 5.00

/ ewe / head / head / head / head / head / head / ewe / ewe / ewe / ewe %

$ $ $ $ $ $ $ $ $ $ $ 6.0 Term of Loan (months) $

Calculate Health Costs

2,902.14 245.86 2,634.19 3,161.03 1,088.80 1,240.59 1,329.75 900.00 900.00 405.00 225.00 513.00 39,880.14 $26,004.75 $57.79 $26.07 $41.93 $68.36

TOTAL VARIABLE COSTS RETURN TO EQUITY, MANAGEMENT & OPERATOR LABOUR Net Return per Ewe with Lamb Price @ $1.25 per lb Return over Variable Costs Lamb Price @ $0.95 / lb $1.10 / lb $1.35 / lb

$

1 2

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

Go To Risk Analysis Section

FEED USAGE CALCULATIONS EWES E.GEST No. days on Stored Feed 97 Ewes ( enter your feeds of choice) Mixed Hay 5.00 Alfalfa Hay 0.00 Corn 0.00 Soybean Meal 0.000 Pellet Protein Suppl 0.000 Corn Silage 0.00 Salt 0.030 Mineral 0.045 EWES L.GEST 40 5.00 0.00 1.50 0.000 0.100 0.00 0.030 0.045 EWES EWES EWES LACT MAINT. FLUSH 0 0 28 lbs / day 0.00 0.00 4.00 0.00 0.00 0.00 0.00 0.00 0.75 0.000 0.000 0.000 0.000 0.000 0.000 0.00 0.00 0.00 0.030 0.030 0.030 0.045 0.045 0.045

RAMS

374 11 TOTAL POUNDS TOTAL 165 /EWE POUNDS /RAM 797.0 0.0 81.0 0.0 4.0 0.0 11.0 16.4 1155 0 0 0 0 0 16.4 21.9

7.00 0.00 0.00 0.000 0.000 0.00 0.045 0.060

Replacement Ewes(110 lbs)
(feeds MUST be in SAME sequence as Ewes for formulas to work properly)

No. days on Stored Feed Mixed Hay Alfalfa Hay Corn Soybean Meal Pellet Protein Suppl Corn Silage Salt Mineral

97 3.00 0.00 1.00 0.00 0.10 0.00 0.020 0.030

40 3.00 0.00 1.25 0.00 0.25 0.00 0.020 0.030

0 0.00 0.00 0.00 0.00 0.00 0.00 0.020 0.030

0 28 0.00 3.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.10 0.00 0.00 0.020 0.020 0.030 0.030

REPLAC. RAMS 165 4.50 0.00 0.50 0.000 0.100 0.00 0.020 0.030

TOTAL POUNDS REPLACEMENT EWES RAMS 77 0 495.0 0.0 0.0 0.0 175.0 0.0 0.0 0.0 22.5 0.0 0.0 0.0 10.6 0.0 11.0 0.0

Lamb Finishing Ration - as fed basis Enter Percentages as Decimal Equivalents (EXAMPLE 10% = 0.10) 0.050 Mixed Hay 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

Return to COP Calculator

CALCULATE HEALTH PROGRAM COSTS Ewes & Rams Wormer (name product) Clostridial Vaccine (Booster 2ml) Other Other Other

374 Ewes 11 Rams $ 1.49 /DOSE $ 0.30 /DOSE $ /DOSE $ /DOSE $ /DOSE $ $ 2.98 $ 0.15 $ $ $ $ 3.13 1,204.27

2.0 0.5 0.0 0.0 0.0

DOSE @ DOSE @ DOSE @ DOSE @ DOSE @

Health Program Cost for Ewes & Rams

Lambs Selenium injection Clostridial Vaccine (4ml) Wormer Other Other Health Program Cost for Lambs Replacement Ewe Lambs Wormer Vaccine (booster 2ml) Other

0.0 1.0 2.0 0.0 0.0

DOSE @ DOSE @ DOSE @ DOSE @ DOSE @

720 Lambs $ 0.08 /DOSE $ 0.30 /DOSE $ 0.64 /DOSE $ /DOSE $ /DOSE $

$ $ 0.30 $ 1.28 $ $ $ 1.58 1,137.60

77 Replacement Lambs $ 0.64 /DOSE $ $ 0.30 /DOSE $ $ $ $ Health Program Cost for Replacement Lambs (ewes & rams) $ 1.0 DOSE @ 0.5 DOSE @ 0.0 DOSE @ Lambs entering Feedlot Wormer Vaccine (booster 2ml) Other 633 $ 0.64 /DOSE $ 0.30 /DOSE $ /DOSE $ $

0.64 0.15 0.79 60.44

1.0 DOSE @ 0.5 DOSE @ 0.0 DOSE @

$ $ $ $

Health Program Cost for Lambs Entering Feedlokt Flock Health Program Costs

0.64 0.15 0.79 499.83

Return to Other Variable 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): Expected Lamb Sale price ($/lb) Expected Variable Cost per Ewe Expected Lambs Weaned per Ewe Expected Lamb Death Loss (after weaning) Change Key Ewe Flock Variables:

$

$1.25 88.62 1.60 1.5%

Percent Change in Sale price Percent Change in Variable Cost Percent change in Lambs Weaned Percent change in Lamb Death Loss (after weaning)

+/-% -10% 10% 10% -20%

Results of the change: New sale price: New Variable Cost: New Lambs Weaned: New Lamb Death Loss:

$ $

1.13 97.48 1.76 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


								
To top