Future Auto company produces three types of automobiles: models x, X2, and x3. The generated profit,...

 

Transcribed Image Text:

Future Auto company produces three types of automobiles: models x, X2, and x3. The generated profit, required assembly time, and required material value for each of the models is represented in the following table. There is a total of 500 assembly hours and $250,000 material value available each month. According to the marketing data model x, is the most popular model and demand for that is more than the demand of two other models combined. Therefore, it must be produced more than models x2 and x3 combined. What combination of the three models maximizes total profit in each month? Model Assembly (hours) Material ($) Profit ($) X1 27 12,000 2000 X2 32 14,000 4500 X3 38 17,000 6000 I a) Formulate the problem as a linear programming model IN A WORD FILE. b) Solve the LP using Excel AND GENERATE THE ANSWER REPORT. Note: leave the optimal values fractional in the Excel file. Hint: Optimal objective function value $61,538.46 c) Bonus question: What is the best integer solution? Future Auto company produces three types of automobiles: models x, X2, and x3. The generated profit, required assembly time, and required material value for each of the models is represented in the following table. There is a total of 500 assembly hours and $250,000 material value available each month. According to the marketing data model x, is the most popular model and demand for that is more than the demand of two other models combined. Therefore, it must be produced more than models x2 and x3 combined. What combination of the three models maximizes total profit in each month? Model Assembly (hours) Material ($) Profit ($) X1 27 12,000 2000 X2 32 14,000 4500 X3 38 17,000 6000 I a) Formulate the problem as a linear programming model IN A WORD FILE. b) Solve the LP using Excel AND GENERATE THE ANSWER REPORT. Note: leave the optimal values fractional in the Excel file. Hint: Optimal objective function value $61,538.46 c) Bonus question: What is the best integer solution?

Answer rating: 100% (QA)

LP programming Model Maximizing the profit Z 2000X14500X26000X3 Constraints 27X132X238X3 500 12000X1... View the full answer