c. Displayed below are the resulting data Am Enterprises Data Pitburgh $10.00 $200 51.00 1000 Seattle Columbia New York De Mobile 520.00 $10.00 520,00 S000 Devels Washington 55.00 9000 $10.00 5.00 SNO 00 52.00 $10.00 400 5000 apply 000 00 WOOD M See Celu New Yor Beste variables Sente So Colum 50.00 New York SOLO Mobile $0.00 54.000,00 SLI Denver Los Angeles West 500.00 100 100 SO SOLO olyan Amunt Ang W Dec A. sood Total The objective function is to minimize the total cost. The equation for the objective function =SUMPRODUCT(B4:F6). 3 Data 4 Seattle Columbus New York Demand 5 Pittsburgh $10.00 $2.00 $1.00 3000 Mobile $20.00 $10.00 $20.00 5000 Denver Los Angeles Washington $5.00 $9.00 $10.00 $8.00 $30.00 $6.00 $7.00 $10.00 $4.00 4000 6000 3000 Supply 9000 4000 8000 6 7 The supply constraints are 9000, 4000, and 8000. The demand constraints are 3000, 5000, 4000, 6000, and 3000. According to your results, what is the total transportation cost? How many CPUs should be manufactured in Seattle? How many CPUs should be shipped from New York to the warehouse in Washington