Question

In: Operations Management

Robin Tires, Inc. makes two types of tires, one for SUVs and the other for Hatchbacks....

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.

Type Production Hours Packaging Shipping Profit/Tire
SUV tires

1.5

1.5

1

$25

Hatchback tires

2

.75

0.5

$17

Assuming that the company is interested in maximizing the total profit contribution, answer the following:

a. What are the variables

b. Write all necessary constraints , solve by SOLVER

c. How many tires of each model should Robin manufacture?
d. What is the total profit contribution Robin can earn with the optimal production quantities?

Solutions

Expert Solution

Solution: We will solve the given problem into two parts. In the first part, we will formulate the given problem as a Linear Programming Model, and in the second part, we will solve this LP model.

Part A: Formulate an LP Model:

Decision Variables (Answer a):

Let the decision variables:

S = No. of SUV tires to be manufactured

H = No. of Hatchback tires to be manufactured

Objective Function:

Here, the objective is to maximize the total profit contribution, hence the objective function=

Max Z = 25 S + 17 H

Subject to Constraints (Answer b):

C1 = 1.5 S + 2 H ≤ 500 (Production Hours)

C2 = 1.5 S + 0.75 H ≤ 250 (Packaging Hours)

C3 = 1 S + 0.5 H ≤ 150 (Shipping Hours)

Non-Negativity Condition:

S, H ≥ 0

Part B: Solve the obtained LP (Answer b)

Here, as there is specific information mentioned in the question, we will solve the given LP problem using the MS Excel Solver by following below-mentioned steps:

Step 1: Prepare the following in the excel

(Note: Make Sure to prepare this table in the exact Raws and Columns as mentioned in the below screenshot)

Step 2: Now, type the following formulas in the column of 'Total' as mentioned in the below table. Then, press enter.

Hence, we will get the following table:

Step 3: Now, open Solver ( Data > Analyze > Solver), and fill the exact data in Solver Pop-Up Window as shown in the below screenshot:

Step 4: Once, you press solve button as mentioned in the below step, you will get the following table. Here, the highlighted values are the optimal values for the decision variables:

Hence,

Answer c)

40 SUV and 220 hatchback tires to be manufactured.

Answer d)

Total Profit Contribution = 25 (40) + 17 (220) = 4740 $


Related Solutions

Suppose you have experienced two types of banks one being Islamic and the other one as...
Suppose you have experienced two types of banks one being Islamic and the other one as conventional. Based on this; (a) What key differences and major issues of both types would share with your friend? (b) What main reasons would you emphasize in order to help your friend to either choose Islamic or conventional bank?
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 400 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 700 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 200 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Manu, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing...
Manu, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,710,000 Cost of goods sold 1,252,680 Gross margin 457,320 Selling and administrative expenses 600,000 Net operating loss $ (142,680 ) Company produced and sold 60,300 units of B300 at a price of $20 per unit and 12,600 units of T500 at a price of $40 per unit. The...
Sandstorm Manufacturing Inc. makes two types of industrial component parts—the LE100 and the UL600. It annually...
Sandstorm Manufacturing Inc. makes two types of industrial component parts—the LE100 and the UL600. It annually produces 58,000 units of LE100 and 12,300 units of UL600.The company’s conventional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below:     LE100 UL600 Total   Direct materials $ 364,325    $ 160,550   $ 524,875     Direct labor $ 118,000    $ 41,500   $ 159,500  ...
Precision Manufacturing Inc. (PMI) makes two types of industrial component parts—the EX300 and the TX500. It...
Precision Manufacturing Inc. (PMI) makes two types of industrial component parts—the EX300 and the TX500. It annually produces 70,000 units of EX300 and 13,500 units of TX500. The company’s conventional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below: EX300 TX500 Total Direct materials $ 376,325 $ 172,550 $ 548,875 Direct labor $ 130,000 $ 47,500 $...
Precision Manufacturing Inc. (PMI) makes two types of industrial component parts—the EX300 and the TX500. It...
Precision Manufacturing Inc. (PMI) makes two types of industrial component parts—the EX300 and the TX500. It annually produces 60,000 units of EX300 and 12,500 units of TX500. The company’s conventional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company’s two product lines is shown below: EX300 TX500 Total Direct materials $ 366,325 $ 162,550 $ 528,875 Direct labor $ 120,000 $ 42,500 $...
please show if this is done in excel, Kelson Sporting Equipment, Inc., makes two different types...
please show if this is done in excel, Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher’s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: PRODUCTION TIME HOURS Model Cutting and...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time available in its cutting and sewing department, 150 hours available in its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time available in its cutting and sewing department, 150 hours available in its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT