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

question.docx

Home >Mathematics homework help >Numerical analysis homework help >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, with respective net revenues of$1000, $3000, and $6000. 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 each Model Z requires 110 labor-hours and 2 tons of steel. This month, Specific has available 16,000 labor-hours of labor, 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 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