Robin Tires, Inc

question 47

Essay

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, find the optimal solution using Excel Solver and answer the following:a. How many hours of production time will be scheduled in each department? b. What is the slack time in each department? c. If one more hour is available for packaging, what is the change in profit? d. What is the change in profit if one more hour is available for shipping?

---

Definitions:

Psychic Energy

A concept in psychoanalytic theory referring to the force driving human behavior and emotional processes.

Repression

In psychoanalytic theory, the defense mechanism that banishes the past from current awareness.

Conscious Awareness

The state of being aware of one's thoughts, feelings, and surroundings; the aspect of the mind that is directly accessible to introspection.

Creative

Having the ability or power to create, characterized by originality of thought or inventiveness.