Specific Motors manufactures three different car models, Model X, Model Y, and Model Z,

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