Having issues with solver. Please use excel solver to answer. Thanks in advance!!

Plant Information: Plant 1: Production Cost per Unit = $22.00 & Quarterly Capacity = 30,000 units. Plant 2: Production Cost per Unit = $21.25 & Quarterly Capacity = 30,000 units Plant 3: Production Cost per Unit = $19.10 & Quarterly Capacity = 26,000 units Plant 4: Production Cost per Unit - $19.25 & Quarterly Capacity = 28,000 units. Plant 5: Production Cost per Unit - $18.00 & Quarterly Capacity - 26,000 units Shipping Cost per Unit (S) from Plants to Distribution Centers Distribution Center Plant Fort Worth (6) Santa Fe (1) Las Vegas (8) Plant 1 (1) S1.01 S1.30 $0.98 Plant 2 (2) $1.21 S1.28 S1.02 Plant 3 (3) $1.42 S1.25 S1.10 Plant 4 (4) $1.30 $1.29 S1.05 Plant 5 (5) $1.50 $1.35 $1.02 Pittsburgh (9) $0.88 $1.04 $0.85 $0.92 $0.98 Demand at Customer Warehouses Customer Zone Warehouse Dallas (10) San Antonio (11) Wichita (12) Kansas City (13) Denver (14) Salt Lake City (15) Phoenix (16) Los Angeles (17) San Diego (18) Boston (19) Akron (20) Quarterly Demand (units) 10.000 9.200 9,000 8,500 9.400 9,308 9,120 8.900 7.500 10,000 9.505 Shipping Cost per Unit (S) from Distribution Centers (DCs) to Customer Zone Warehouses Customer Zone Warehouse Salt Kansas Lake City Denver City $0.80 $1.02 S1.02 San Antonio S0.71 DC Fort Worth Dallas $0.75 Wichita 50.85 Los Angeles $1.05 Phoenix S1.00 San Diego $1.06 Boston $1.45 Akron $1.20 $0.88 $1.55 Santa Fe S0.92 $0.91 S1.25 $0.82 $1.09 $1.11 $1.08 $1.05 $1.10 $1.82 $0.68 $0.72 $0.70 Las Vegas $0.99 SI 50 $0.93 SLOS S1.10 S1.01 SO 99 $1.25 S1.30 $1.29 $1.50 $0.88 $1.60 Pittsburgh $1.55 $1.66 $1.45 $0.99 $1.32 Question 1) Using the information given above, including shipping costs, manufacturing costs, capacity, and demand, how should product be produced and shipped from the Plants to the Distribution Centers and from the Distribution Centers to the Customer Zone Warehouses? What will the total cost (manufacturing cost + shipping cost of your plan equal? Define your variables, objective function, & constraints, show your additional work for any objective function coefficients and the transshipment constraints. a) When you ship from a Plant to a destination, Cost per Unit - Manufacturing Cost per Unit at the Plant + Shipping Cost per Unit b) The Distribution Center capacities are not needed. We are assuming that the Distribution Centers are able to handle all of the volume. Question 2 Add the following assumptions simultaneously to your model from Question 1 and re-run your Solver model. a) There was a strike at Plant 3 that increased the manufacturing cost per unit by $2.00 per unit. b) Plant 5 needed to increase wages to retain talent. The manufacturing cost per unit increased by $3.10 per unit. c) Product manufactured in Plant 4 could be shipped directly to the Los Angeles Customer Zone Warehouse (shipping cost-50.68/unit), d) Product manufactured in Plants could be shipped directly to the Kansas City Customer Zone Warehouse (shipping cost = $1.20/unit) Remember: When you ship from a Plant to a destination, Cost per Unit - Manufacturing Cost per Unit at the Plant + Shipping Cost per Unit. Using the information given above, including shipping costs, manufacturing costs, capacity and demand, how should product bo produced and shipped from the Plants to the Distribution Conters and from the Distribution centers to the Customer Zone Warehouses? What will the total cost (manufacturing cost + shipping cost of your plan equal? Define your variables, objective function, & constraints in your Word document. Ensuro that you show your additional work for any objective function coefficients and the transshipment constraints. Then, list your answers in a separate table in your Word document. Plant Information: Plant 1: Production Cost per Unit = $22.00 & Quarterly Capacity = 30,000 units. Plant 2: Production Cost per Unit = $21.25 & Quarterly Capacity = 30,000 units Plant 3: Production Cost per Unit = $19.10 & Quarterly Capacity = 26,000 units Plant 4: Production Cost per Unit - $19.25 & Quarterly Capacity = 28,000 units. Plant 5: Production Cost per Unit - $18.00 & Quarterly Capacity - 26,000 units Shipping Cost per Unit (S) from Plants to Distribution Centers Distribution Center Plant Fort Worth (6) Santa Fe (1) Las Vegas (8) Plant 1 (1) S1.01 S1.30 $0.98 Plant 2 (2) $1.21 S1.28 S1.02 Plant 3 (3) $1.42 S1.25 S1.10 Plant 4 (4) $1.30 $1.29 S1.05 Plant 5 (5) $1.50 $1.35 $1.02 Pittsburgh (9) $0.88 $1.04 $0.85 $0.92 $0.98 Demand at Customer Warehouses Customer Zone Warehouse Dallas (10) San Antonio (11) Wichita (12) Kansas City (13) Denver (14) Salt Lake City (15) Phoenix (16) Los Angeles (17) San Diego (18) Boston (19) Akron (20) Quarterly Demand (units) 10.000 9.200 9,000 8,500 9.400 9,308 9,120 8.900 7.500 10,000 9.505 Shipping Cost per Unit (S) from Distribution Centers (DCs) to Customer Zone Warehouses Customer Zone Warehouse Salt Kansas Lake City Denver City $0.80 $1.02 S1.02 San Antonio S0.71 DC Fort Worth Dallas $0.75 Wichita 50.85 Los Angeles $1.05 Phoenix S1.00 San Diego $1.06 Boston $1.45 Akron $1.20 $0.88 $1.55 Santa Fe S0.92 $0.91 S1.25 $0.82 $1.09 $1.11 $1.08 $1.05 $1.10 $1.82 $0.68 $0.72 $0.70 Las Vegas $0.99 SI 50 $0.93 SLOS S1.10 S1.01 SO 99 $1.25 S1.30 $1.29 $1.50 $0.88 $1.60 Pittsburgh $1.55 $1.66 $1.45 $0.99 $1.32 Question 1) Using the information given above, including shipping costs, manufacturing costs, capacity, and demand, how should product be produced and shipped from the Plants to the Distribution Centers and from the Distribution Centers to the Customer Zone Warehouses? What will the total cost (manufacturing cost + shipping cost of your plan equal? Define your variables, objective function, & constraints, show your additional work for any objective function coefficients and the transshipment constraints. a) When you ship from a Plant to a destination, Cost per Unit - Manufacturing Cost per Unit at the Plant + Shipping Cost per Unit b) The Distribution Center capacities are not needed. We are assuming that the Distribution Centers are able to handle all of the volume. Question 2 Add the following assumptions simultaneously to your model from Question 1 and re-run your Solver model. a) There was a strike at Plant 3 that increased the manufacturing cost per unit by $2.00 per unit. b) Plant 5 needed to increase wages to retain talent. The manufacturing cost per unit increased by $3.10 per unit. c) Product manufactured in Plant 4 could be shipped directly to the Los Angeles Customer Zone Warehouse (shipping cost-50.68/unit), d) Product manufactured in Plants could be shipped directly to the Kansas City Customer Zone Warehouse (shipping cost = $1.20/unit) Remember: When you ship from a Plant to a destination, Cost per Unit - Manufacturing Cost per Unit at the Plant + Shipping Cost per Unit. Using the information given above, including shipping costs, manufacturing costs, capacity and demand, how should product bo produced and shipped from the Plants to the Distribution Conters and from the Distribution centers to the Customer Zone Warehouses? What will the total cost (manufacturing cost + shipping cost of your plan equal? Define your variables, objective function, & constraints in your Word document. Ensuro that you show your additional work for any objective function coefficients and the transshipment constraints. Then, list your answers in a separate table in your Word document