Gatson Manufacturing Company Produces 2 Types of Tires: Economy Tire;

question 52

Essay

Gatson manufacturing company produces 2 types of tires: Economy tire; Premium tire. The manufacturing time and the profit contribution per tire are given in the following table:

Answer the following assuming that the company is interested in maximizing the total profit contribution. 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 Gatson manufacture? c. What is the total profit contribution Gatson can earn with the optimal production quantities?

---

Definitions:

Romantic Partner

An individual with whom one shares a romantic relationship, characterized by feelings of love, attraction, and commitment.

Best Friend

A person's closest and most trusted friend, who is considered the most important friend in one's life.

Living Space

The area or room in a building where one resides or spends a significant portion of their daily life, typically including areas for sleeping, eating, and socializing.

Mutual Rights

The concept that individuals in a relationship or society have equitable entitlements and obligations.