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:

Modifies

The act of changing or altering something to fit a particular condition or requirement.

Adverb

A word added to (modifying) a verb, an adjective, or another adverb.

Strong Feeling

An intense emotional state or reaction.

Interjection

Used to express strong feeling or emotion. These words are usually followed by an exclamation point or a comma.