a. Formulate a linear programming model to find a plan that maximizes the monthly profits for Specific 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 the Model Q should be considered for the monthly manufacturing plan