Show me how to do or solve this in excel QM 9-48. The G. Saussy Manufacturing company is putting out 4 new electronic components. Each of Saussy's 4 plants has the capacity to add 1 more product to its current line of electronic parts. The unit manufacturing costs for producing the different parts at the 4 plants are shown in the accompanying table. How should Saussy assign the new products to the plants to minimize manufacturing costs? Plant Electronic Component 1 2 3 4 C53 $0.10. $0.12 $0.13 $0.11 C81 $0.05 $0.06 $0.04 $0.08 D5 $0.12 $0.40 $0.31 $0.30 D44 $0.17. $0.14. $0.19. $0.15

Show me how to do or solve this in excel QM 9-48. The G. Saussy Manufacturing company is putting out 4 new electronic components. Each of Saussy's 4 plants has the capacity to add 1 more product to its current line of electronic parts. The unit manufacturing costs for producing the different parts at the 4 plants are shown in the accompanying table. How should Saussy assign the new products to the plants to minimize manufacturing costs? Plant Electronic Component 1 2 a 4 C53 $0.10. $0.12 $0.13 $0.11 CEI $0.05 $0.06 $0.04 $0.08 D5 $0.12 $0.40 $0.31 $0.30 Dodd $0.17. $0.14. $0.19. $0.15