5. Product Mix Sheet (5 points total, 2 points for a, b, 1 point for c) (Covers Learning Objective: 9e) a. Transfer the appropriate values from the word problem to the Yellow cells. b. Create any required formulas for the problem. c. Use Solver to find an optimal solution to the problem. D G E H Acme Plastics 2 3 A manager must decide on the mix of products to produce for the coming week. Product A requires 4 three minutes per unit for molding, two minutes per unit for painting, and one minute per unit for 5 packing. Product B requires two minutes per unit for molding, four minutes per unit for painting, and 6 three minutes per unit for packing. There will be 600 minutes available for molding, 600 minutes 7 for painting, and 420 minutes for packing. Both products generate profits of $1.50 per unit. 8 Put the appropriate values from the problem in the Yellow cells, then create any required formulas 9 involving the decision variables, objective function, and all applicable constraints. Finally, use Solver 10 to find the optimal solution. Product A Product B 11 12 Total Profit: 13 14 15 Number to Produce: 16 Unit Profit: 17 18 Constraints: 19 Molding: 20 Painting: 21 Packing: Product A Product B Used Available 22 23