Question
USING EXCEL USING EXCEL USING EXCEL USING EXCEL 4. Hunts canning company has 60,000 pounds of ripe tomatoes on order at $0.07 per pound. Hunts
USING EXCEL
USING EXCEL
USING EXCEL
USING EXCEL
4. Hunts canning company has 60,000 pounds of ripe tomatoes on order at $0.07 per pound. Hunts facility is capable of converting the tomatoes into juice, sauce, and paste. A can of juice uses 1 lb of tomatoes, a can of sauce uses lbs, and a can of paste uses lbs. Cans are packaged together into cases of 24 cans. Daily market demand is 5,000 cases of juice, 5,000 cases of sauce, and 6,000 cases of paste. The price per can of juice, sauce, and paste are $21, $9, and $12. a). Formulate a linear programming model for this problem statement. b). What is the optimum solution for the seasonal production? c). The company executive did not like your initial answer. They want to make sure they have adequate Hunts brand products on the selves in all varieties. How does the optimum change if each product receives at least 15% of all production?
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