Robin Tires, Inc. makes two types of tires, for SUV's and Hatchbacks. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table:

Assuming that the company is interested in maximizing the total profit contribution, answer the following:a. What is the linear programming model for this problem? b. Develop a spreadsheet model and find the optimal solution using Excel Solver. How many tires of each model should Robin manufacture? c. What is the total profit contribution Robin can earn with the optimal production quantities?

Question

Robin Tires, Inc. makes two types of tires, for SUV's and Hatchbacks. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table:
  
Assuming that the company is interested in maximizing the total profit contribution, answer the following:a. What is the linear programming model for this problem? b. Develop a spreadsheet model and find the optimal solution using Excel Solver. How many tires of each model should Robin manufacture? c. What is the total profit contribution Robin can earn with the optimal production quantities?

Quizplus · Accepted Answer

The Answer of Robin Tires, Inc. makes two types of tires, for SUV's and Hatchbacks. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table:
  
Assuming that the company is interested in maximizing the total profit contribution, answer the following:a. What is the linear programming model for this problem? b. Develop a spreadsheet model and find the optimal solution using Excel Solver. How many tires of each model should Robin manufacture? c. What is the total profit contribution Robin can earn with the optimal production quantities?