Specific Motors manufactures three different car models, Model X, Model Y, and Model Z, withrespective net revenues of$1000, $3000, and $6000. Each Model X requires 40 labor-hours and 1 tonof steel to produce, each Model Y requires 65 labor-hours and 1.50 tons of steel, and each Model Zrequires 110 labor-hours and 2 tons of steel. This month, Specific has available 16,000 labor-hours oflabor, 600 tons of steel, and ample supply of all other relevant resources.
a. Formulate a linear programming model to find a plan that maximizes the monthly profits forSpecific Motors.
b. Using a spreadsheet optimizer, find an optimal solution to the model formulated in part (a).
c. Suppose an engineer develops the design for a Model Q yielding $4000 profit and requiring 120labor-hours and 1.25 tons of steel. 'Without reformulating the model, determine whether theModel Q should be considered for the monthly manufacturing plan