cost of farm production calculator

Feedlot -Calf to Finish and Shortkeep to Finish and Backgrounder Cost of Production Calculators These one page programs focus on the economics of feeding cattle and features such things as calculating the total cost of gain, feed efficiency and net return/animal. Interest cost and death loss are calculated by using the average value between purchase and selling price (i.e., purchase price $800/head, selling price $1,500/head -average cost $1,150). It's a program that can evaluate past performance, as well as projecting ahead. It allows you to look at "what if" scenarios. Just overwrite the blue numbers on the sample cost of production budgets. Developed by: Dennis Martin, Beef Feedlot 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.caNumbers in Blue can be edited/changed for individual producers Calf Information $/Head $/lb Sale Weight (lbs) 1,456 Sale Value 1,165 $ Purchase Weight (lbs) 600 Purchase Value 540 $ Days on Feed 280 Death Loss Value -$ Death Loss % -Margin 625 $ 0.73 $ Expected Cost of Gain Feed ($/lb of gain) 0.53 $ Feed 457 $ 0.53 $ Health & Vet. Expenses ($/hd) 20 $ Health & Vet. Expenses ($/hd) 20 $ 0.02 $ Marketing/Trucking ($/hd) 30 $ Marketing/Trucking ($/hd) 30 $ 0.04 $ ** Yardage ($/hd/day) 0.25 $ Yardage 70 $ 0.08 $ Interest Rate % 5 Interest 33 $ 0.04 $ Expected Cost of Gain 610 $ 0.71 $ Net Return 15 $ 0.02 $ Expected Market Situation Sale Price ($/lb) 0.80 $ Breakeven Sale Price 1,150 $ 0.79 $ Purchase Price ($/lb) 0.90 $ Breakeven Purchase Price 555 $ 0.92 $ Total Gain (lbs.) 856 A.D.G. (lbs./day) 3.06 Feed Requirements $/tonne Lbs. per Head/Day Percent DM Hay 80 $ 5.5 56 $ 90% Haylage -$ --$ 45% Corn Silage 30 $ 13.2 50 $ 35% Dry Corn 145 $ 15.4 284 $ 86% H.M. Corn -$ --$ 70% Beef Supplement 300 $ 1.6 61 $ 90% Salt & Mineral 500 $ 0.09 6 $ 100% Corn Screenings -$ --$ 86% Other -$ --$ Other -$ --$ $/acre PASTURE -$ N/A -$ N/A Total Feed Cost 457 $ Feed Cost per lb of Gain 0.53 $ % DM intake Total DM fed (lbs per head/day) 24.40 2.37% Feed Conversion (lbs -dry matter basis) 7.98 ** Yardage is hydro, telephone, taxes & insurance, bedding, manure removal, housing, equip. repairs Risk Analysis Expected returns are subject to the risk of fluctuations in both revenue and expenses. Increases in sale prices received, decreases in replacement prices , and decreases to your cost of production will have positive impacts on your net return. Conversely, sale price decreases, increases in replacement prices and increases to you cost of production will have negative impacts on your net return. The expected values that you inputted above for the key feedlot risk variables are displayed below on the left. Change the key risk variables identified for the feedlot enterprise in the cells 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 above): $ /lb Change Key Feedlot Risk Variables: + /-% Results of the change: Expected Sale price 0.80 $ Percent Change in Sale price 10% New sale price: 0.88 $ Expected Purchase Price 0.90 $ Percent Change in Purchase Price -10% New purchase price: 0.81 $ Expected Cost of Gain 0.71 $ Percent change in Cost of Gain 0% New Cost of Gain: 0.71 $ Net Return Per Head 15 $ Net return per head before changes to Key Feedlot Risk Variables 185 $ Net Return after changes in Key Feedlot Risk Variables Developed by: Dennis Martin, Beef Feedlot 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 $$$ Ontario Feedlot -Calf to Finish Cost of Production Calculator $$$ Too much dry matter, check feed fed -24.4