Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Authentication
digital resources
154x Filetype XLSX File size 0.08 MB Source: www.clemson.edu
Sheet 1: Intro & Instructions
| Beef Cost Calculator for Direct Marketed Bulk and Standard Cut Beef Products | ||||||||||||||
| Author: Bernt Nelson (803)699-5700. Email: BerntN@Clemson.edu | ||||||||||||||
| Co-Author: Steve Richards (843)473-6024. Email: Stricha@Clemson.edu | ||||||||||||||
| General Instructions for Entries into Spreadsheet | ||||||||||||||
| Entry 1: | Enter live weight cost per pound. Either the cost to buy a market ready animal or the cost to raise an animal to maturity | |||||||||||||
| Entry 2: | Enter live weight of animal or use an average of the typical live weights experienced on your farm. | |||||||||||||
| Entry 3: | Default Dressing Percentage is industry standard. You may modify if your animals are significantly different. | |||||||||||||
| Entry 4: | Default Cutout Percentage is industry standard. You may modify this percent based on your processor's yields. | |||||||||||||
| Entry 5: | Default Boneout Percentage is industry standard. You may modify this percentage based on your processor's yields. | |||||||||||||
| Entry 6: | Enter Kill Fee (if applicable) that your processor charges. | |||||||||||||
| Entry 7: | Enter Processing Fee on a per hanging weight basis. | |||||||||||||
| Entries 8 - 12: | Enter Selling Costs for Direct Marketing Beef on a PER ANIMAL basis. | |||||||||||||
| Entries 13 - 19: | Enter Estimated Overhead Costs for Raising and Selling Your Animals on a PER ANIMAL basis. | |||||||||||||
| Entry 20: | A drop down item whether you want standard cut or all boneless. Default is standard. Select NO for standard if you wan all boneless | |||||||||||||
| Entries 21 - 25: | Enter USDA average retail prices from https://www.ers.usda.gov/data-products/meat-price-spreads/ | |||||||||||||
| Entry 26: | Enter estimated shrink in a percentage to account for unsaleable cuts and samples provided to customers | |||||||||||||
| Entries 27 - 31: | Enter retail prices that you expect to charge for your beef cuts | |||||||||||||
| Entry 32: | Enter any additional income not accounted for in the other fields | |||||||||||||
| Entry 33: | Enter any additional expense not accounted for in the other fields | |||||||||||||
| Clemson University Cooperative Extension Service offers its programs to people of all ages, regardless of race, color, gender, religion, national origin, | ||||||||||||||
| disability, political beliefs,sexual orientation, gender identity, marital or family status and is an equal opportunity employer. | ||||||||||||||
| Cost to Produce and Process animal | Selling Costs/Animal | Total Costs/per # | Carcass Total | Carcass/# | ||||||||||||
| Price per Pound, Live* | $1.19 | <=Entry 1 | Storage | $50.00 | <=Entry 8 | Whole | $2,654 | $3.69 | ||||||||
| Live Weight in lbs. | 1200 | <=Entry 2 | Farm Mkt Fees | $50.00 | <=Entry 9 | |||||||||||
| Cost to produce live animal | $1,428.00 | Hauling (kill & pu) | $100.00 | <=Entry 10 | Bulk Break-Even Price | Standard | Boneless | |||||||||
| Delivery Costs | $25.00 | <= Entry 11 | Per Pound | $5.42 | $6.38 | |||||||||||
| Processing Yields | Advertising | $25.00 | <=Entry 12 | |||||||||||||
| Dressing % | 60.0% | <=Entry 3 | Total Mktg/Animal | $250.00 | Processing Wts | Standard | Boneless | |||||||||
| Dressed Weight | 720 | Whole | 490 | 416 | ||||||||||||
| Cutout % | 68.0% | <=Entry 4 | ||||||||||||||
| Bone out % | 85.0% | <=Entry 5 | Overhead Costs/Animal | How Much Does it Cost to Sell Meat in Bulk? | ||||||||||||
| Depreciation | $50.00 | <=Entry 13 | Total Meat Pounds | Standard Cut | YES | <= Entry 20 | ||||||||||
| Processing Cost | Insurance | $50.00 | <=Entry 14 | 490 | All Boneless | NO | ||||||||||
| Kill Fee (If applicable) | $85.00 | <=Entry 6 | Repairs | $50.00 | <= Entry 15 | Cost Per Lb--Bulk | $5.42 | |||||||||
| Processing cost per # | $0.89 | <=Entry 7 | Taxes/licenses | $50.00 | <= Entry 16 | Total Cost -- Bulk | $2,653.80 | |||||||||
| Total Processing Costs | $725.80 | Interest | $- | <=Entry 17 | ||||||||||||
| Utilities | $50.00 | <=Entry 18 | ||||||||||||||
| Total Direct Costs | Owner Pay | $- | <=Entry 19 | |||||||||||||
| Animal & Processing | $2,153.80 | Total OH/Animal | $250.00 | |||||||||||||
| *Price from CME for April 2021 Live Cattle as of 3/15/2021. Could also use the cost to | ||||||||||||||||
| raise your own animal to maturity. | ||||||||||||||||
| Comparison of Direct Market Beef (Bulk) vs. Average Retail Prices | Percent Cutout by Primal | |||||||||||||||||||
| Cut | Percent of Cutout* | |||||||||||||||||||
| Total Pounds of Beef | 490 | Ground Beef | 37.8% | |||||||||||||||||
| Breakeven Price/# | $5.42 | Round Roasts/Steaks | 17.3% | |||||||||||||||||
| CUT | LBS | @ | Cost per Pound Bulk Meat | = | Total Cost/# Bulk | VS. | Retail Price/Lb | = | Total Retail*** | Chuck Roasts/Steaks | 18.4% | |||||||||
| Ground Beef | 185 | $5.42 | $1,001.94 | $4.56 | $842.17 | Rib/Loin Steaks | 16.3% | |||||||||||||
| Round Roasts/Steaks | 85 | $5.42 | $460.35 | $5.82 | $494.38 | Other Cuts | 10.2% | |||||||||||||
| Chuck Roasts/Steaks | 90 | $5.42 | $487.43 | $5.99 | $538.75 | *Percentages from Cattleman's Beef Board and National Cattleman's Beef Association | ||||||||||||||
| Rib/Loin Steaks | 80 | $5.42 | $433.27 | $9.08 | $725.73 | |||||||||||||||
| Other Cuts | 50 | $5.42 | $270.80 | $5.72 | $285.92 | |||||||||||||||
| Total Pounds | 490 | USDA Average Retail Prices | ||||||||||||||||||
| Total Price Pd--Bulk Beef, Direct Marketed | $2,653.80 | Cut | Retail Prices** | |||||||||||||||||
| Price Per Lb--Bulk Beef, Direct Marketed | $5.42 | Ground Beef | $4.56 | <=Entry 21 | ||||||||||||||||
| COMPARED TO | Round Roasts/Steaks | $5.82 | <=Entry 22 | |||||||||||||||||
| Total Estimated Retail Value | $2,886.95 | Chuck Roasts/Steaks | $5.99 | <=Entry 23 | ||||||||||||||||
| Average Price Per Pound, Retail | $5.90 | Rib/Loin Steaks | $9.08 | <=Entry 24 | ||||||||||||||||
| Other Cuts | $5.72 | <=Entry 25 | ||||||||||||||||||
| Retail Value Versus Bulk Beef Value (Retail Value - Bulk Value) | $233.15 | |||||||||||||||||||
| **From USDA ERS 3/10/2021 | ||||||||||||||||||||
| ***Total Retail refers to the total expected retail price of the same weight and primal cut of direct marketed bulk beef. | ||||||||||||||||||||
no reviews yet
Please Login to review.
