Question
(Please Answer with Excel) A meat market manager for a large grocery store is preparing a processing plan to stock the shelves with sausage, ground
(Please Answer with Excel) A meat market manager for a large grocery store is preparing a processing plan to stock the shelves with sausage, ground meat, and jerky, which he can prepare from beef, pork and venison. Sausage and ground meat can be made of any mix of the beef, pork and venison, as long at the fat contents are below 15% for sausage and 10% for ground meat. Sausage sells for $5/pound and ground meat sells for $3/pound. Jerky, which sells or $10/pound, is made in a drying process from beef or venison. In the drying process, there is a 50% loss in weight for jerky made from beef (e.g., one pound of beef yields 0.5 pounds of beef jerky) and a 30% loss in weight for jerky made from venison. The market can sell at most 700 pounds of sausage, 1000 pounds of ground meat, and 100 pounds of jerky before their expiration dates. There are currently 1,000 pounds of beef (10% fat content), 550 pounds of pork (8% fat content), and 225 pounds of venison (2% fat content) available for processing. Determine the optimal processing plan for the meat market. (Please Answer with Excel)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started