4 8 6 4 A factory can produce four products denoted by P1, P2, P3 and P4. Each product must be processed in each of three workshops. The processing times (in hours per unit produced) are given in the following table. P1 P2 P3 P4 Workshop 1 3 Workshop 2 6 2 5 8 Workshop 3 2 3 5 400 hours of labor are available in each workshop. The profit margins are 4, 5, 10, and 9 dollars per unit of P1, P2, P3 and P4 produced, respectively. Everything that is produced can be sold. Maximizing profits, results in the following linear program (where P, is the amount of product ito be produced. 1:1.2.3.4) max 2 - 4P + 5P + 10P,+ 9P s.t. 3P + 4P + 8P, + 6P 5 400 6P, + 2PZ + 5P, + 8P, 5 400 2P+ 3P,+ 4P, + 5PS 400 . P2 Pg P 2 0 a) [10 points] Complete the following EXCEL Solver output (only the boxed cells). Target Cell Max) Cell Name Original Value Final Value $F$6 28 Adjustable Cells Cell Name Original Value Final Value $B$5 P1 $C$5 P2 $D$5 P3 $E$5 P4 + 1 1 1 1 3P2 1 1 1 2P1 + + 413 + S 400 . P2 P P. 2 0 a) [10 points) Complete the following EXCEL Solver output (only the boxed cells). Target Cell (Max) Cell Name Original Value Final Value $F$6 28 Adjustable Cells Cell Name Original Value Final Value $B$5 P1 $C$5 P2 $D$5 P3 $E$5 P4 Constraints Coll Name Cell Value Formula Status Slack $F$7 Workshop 1 SF$7