Optimization and linear programming plays an ever-increasing role in mathema
GMCO produces three types of cars: compact, medium, and large. The variable cost per car and
production capacity (per year) for each type of car are given in the file Assignment4
Template.xlsx. The annual demand for each type of car dep
Instructions: use excel solver to resolve the following problems. You are to submit an excel spreadsheet
with the solver models and solutions.
Problem 1: Steelco manufactures three types of steel at different plants. The time required to