Supply Chain Modeling with linear programming, using Excel

Problem 4. (5 points) Seahawk Motors manufactures three different car models, Model X, Model Y, and Model Z, with respective net revenues of $1,750, $4,000, and $6,500. Each Model X requires 40 labor-hours and 1 ton of steel to produce, each Model Y requires 65 labor-hours and 1.50 tons of steel, and Model Z requires 110 labor-hours and 2 tons of steel. This month, Seahawk has available 30,000 labor-hours, 600 tons of steel, and an ample supply of all other relevant resources. A. Express the model in algebraic form. [Written mathematical formulation of the model]. B. Formulate a linear programming model to find a plan that maximizes the monthly profits for Seahawk Motors on a spreadsheet. C. Use Solver to find an optimal solution for the problem formulated in parts A) and B). D. Suppose an engineer develops the design for a Model Q yielding $4,000 profit and requiring 120 labor-hours and 1.25 tons of steel. Determine whether the Model Q should be considered for the monthly manufacturing plan