using excel for all part

USING EXCEL

4. Hunts canning company has 60,000 pounds of ripe tomatoes on order at $0.07 per pound. Hunt's 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 /2 lbs, and a can of paste uses 4 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? 4. Hunts canning company has 60,000 pounds of ripe tomatoes on order at $0.07 per pound. Hunt's 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 /2 lbs, and a can of paste uses 4 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