Cow Calf Feeder Stocker Cost of Production.xls
《Cow Calf Feeder Stocker Cost of Production.xls》由会员分享,可在线阅读,更多相关《Cow Calf Feeder Stocker Cost of Production.xls(5页珍藏版)》请在三一文库上搜索。
1、 Cost of Production Estimates for Commercial Cow Calf Enterprise Blue text and double lined boxes indicate numbers/text/labels that should be changed to match your situation. Production Information Breeding Herd Size Beginning of Breeding Season - Include cows and 1st calf heifers Pregnancy percenta
2、ge Number Pregnant After Breeding Season in 2007 Number Open, culled and sold before winter feeding period Calving Percentage based January 1 cow numbers Number cows that calved based on January 1 cows in Cull cows sold after calving & before next breeding cycle in Total Cull Cows available for sale
3、 after breeding and/or calving Percent calf loss at calving time Number of live calves born in 2008 Weaning Percentage based on live calves born Number of Calves Weaned in2008 Replacements Needed (from culled animals plus death loss of 1% beginning herd size) Rep. Heifers Needed Average Cull Rate ba
4、sed on beginning breeding inventory Replacements are Purchased or Raised (P or R) Replacements Heifers kept from calf crop Rep. Heifers Kept Replacement Breeding Cows or Heifers Purchased and added to breeding herd Average No. Cows per Bull, Adjust for No. animals A.I. Number bulls at beginning of B
5、reeding Season Average Purchase Price of Bulls Value of Avg Cow in Breeding Herd Net Market Livestock SalesHeadWeight Strs to sell weaning126600 Hfrs to sell weaning76575 Other Animals00 Other Animals00 Cull Cows (1% death loss)401250 Cull Rep. Heifers6900 Cull Bulls41800 Other Income (semen, Etc.)0
6、0 Total Calves Sold202 Totals Animals Sold252 Replacement Heifers QuantityWeight Purchased Replacement Heifers00 Raised Replacements Non-Cash Adjustments to the “Cash“ Value of Production Transfer of Raised Rep. Hef. To Breeding44530 Death Loss of Replacement Heifers00 Since this is a “budget“ for a
7、 typical years operation, herd size should not vary significantly from the beginning to the end of the year. If the numbers entered show significant variation from the beginning to the end of the year in the numbers check below, adjust the cull cow numbers, death loss, or replacement heifer numbers
8、until that variation is eliminated. Retained Ownership Profitability Analysis - Cost of Production (Breakeven) Calculator Enter text in blue below Shading = number is calculated/protected. Enter a Description of the retained ownership option being analyzed: Double lined boxes and blue text indicate
9、numbers that are entered. 1.) Weighted Average Purchase Price of Cattle ($/CWT):$83.20Cost/Value/Head 2.) Weighted Average Purchase Weight of Cattle (LBS):$628.00$522.50 3.) Number of Head You Intend to Feed: 257 4.) Feed Information:Feed NameLBS/Head/Day$/LBCost For Each Feed Item, Enter The 1)0$-0
10、 Pounds Fed Per Head Per Day and 2) Alfalfa Hay15$0.030.45 The Cost in Dollars Per Pound of Feed 3) Supplement0.06$0.080.0048 4)0$-0 5)0$-0 6)0$-0 7)0$-0 8)0$-0 9)0$-0 10) 0$- 0 Totals:15.060.110.4548 5.) Number of Days on Feed:180 6.) Expected Average Daily Gain (LBS/Head):1.25 7.) Interest Rate on
11、 Borrowed Money (%): (OR Opportunity Cost of Own Money)10.00 8.) Tax on Livestock ($/Head):$- 9.) Veterinary and Medical Expense ($/Head):$5.25 10.) Transportation Cost to the Feedlot ($/Head):$- 11.) Transportation Cost to Market ($/Head):$3.00 12.) Facility Repair Costs for the Enterprise (Total $
12、):$400.00 13.) Total Fuel Costs for the Enterprise ($): (Excluding Cattle Transporation) $1,350.00 Straight 14.) Capital Purchases and Improvements:Item NameCostLifeLine Dep. 1)$-00.00 For Each Capital Purchase or Improvement 2)$-00.00 For This Enterprise, Enter the Cost and 3)$-00.00 Expected Years
13、 of Life. 4)$-00.00 5)$-00.00 6)$-00.00 7)$-00.00 8)$-00.00 9)$-00.00 10) $-0 0.00 Total Capital Costs:0.000.00 15.) Custom Charges ($/Head/Day):$- 16.) Enter a custom charge that is based on pounds of gain (enter $/pound charged)$- 17.) Death Loss (%):2.00 18.) Shrink at Time of Purchase (%):0.00 1
14、9.) Shrink at Time of Sale (%):3.00 20.) Sale Commission and Yardage ($/Head):$8.00 21.) Miscellaneous Costs ($/Head):$1.00 22.) Cash Costs of Hired Labor for This Enterprise ($):$- 23.) Expected Selling Price ($/CWT): $75.00 RESULTS Computed sale weight (including shrink)827.41 Interest charge or o
15、pportunity cost per head$28.15 Total cost of gain/head (excl. purchase cost)$146.48 Total Cost/Head (Including Purchase Cost)$668.98 Total cost per head per day of wintering$0.81 Cost per pound of gain (including interest)$0.73 Breakeven selling price at given purchase price$80.85 Breakeven purchase
16、 price at given selling price$75.49 Revenue Per Head$620.56 Net return per head using Expected Selling Price($48.42) Total net return($12,443.65) This worksheet can be used to analyze retained ownership for feeding at home, or feeding away from home. If feeding away from home, the expenses you incur
17、 may come in different forms ($ per pound of feed plus lot charges, or dollars per pound of gain). This spreadsheet will handle all these situations. Simply enter the information relavent to the situation you want to anlayze. Make sure all other numbers not relating to a particular situatioin are se
18、t to zero so expenses are not overstated. CALF PASTURING COST ANALYSIS Double lined boxes and blue text indicate numbers that are entered. INPUT DATA (1 throught 22): 1.) Purchase price of stocker cattle ($/cwt):$ $7 73 3. .0 00 0 2.) Average purchase weight per head (lbs):8 82 25 5. .0 00 0 3.) Num
19、ber of head you intend to pasture:2 25 50 0 4.) Monthly pasture charge/head ($):1 10 0. .5 50 0 5.) Number of days on pasture:1 15 50 0 6.) Expected average daily gain (lbs/head):1 1. .5 50 0 7.) Interest rate on borrowed money (%):1 10 0. .0 00 0 (or opportunity cost of own money) 8.) Tax on livest
20、ock ($/head):3 3. .5 50 0 9.) Veterinary and medical expenses ($/head):2 2. .0 00 0 10.) Cost of salt and mineral supplements ($/head):2 2. .0 00 0 11.) Transportation costs to pasture ($/head):0 0. .0 00 0 12.) Transportation costs to market ($/head):4 4. .0 00 0 13.) Fencing repair costs for enter
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Cow Calf Feeder Stocker Cost of Production
链接地址:https://www.31doc.com/p-5117467.html