Robin Tires, Inc ​
Assuming That the Company Is Interested in Maximizing the SUVs

question 40

Essay

Robin Tires, Inc. makes two types of tires, one for SUVs and the other for Hatchbacks.
The firm has the following limits - 500 hours for production, 250 hours for packaging, and 150 hours for shipping.
The times required per tire type is given in the following table. $$\begin{array} { | l | c | c | c | c | } \hline & \text { Production Hours } & & { } \\\hline \text { Type } & \text { Production } & \text { Packaging } & \text { Shipping } & \text { Profit/Tire } \\\hline \text { SUV tires } & 2 & 1.5 & 1 & \$ 22 \\\hline \text { Hatchback } & & & & \\\text { tires } & 1.5 & 1 & 0.5 & \$ 12 \\\hline\end{array}$$ ​
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?

---

Definitions:

Gilded Age

A term that describes the late 19th century era in the United States characterized by rapid economic growth, technological innovation, and ostentatious displays of wealth, along with significant social and economic inequality.

American Politics

The structured set of practices, beliefs, and institutions that define the operation of the United States government and its interactions with the populace.

Political Parties

Organizations that seek to achieve political power by electing their members to public office, thereby influencing public policy and government decisions.

Subtreasury Plan

A proposal in the late 19th century aiming to revolutionize credit and storage for agricultural products to benefit farmers.