Question

In: Finance

A small firm makes three similar products, which all follow the same three-step process, consisting of...

A small firm makes three similar products, which all follow the same three-step process, consisting of milling,
inspection, and drilling. Product A requires 12 minutes of milling, 5 minutes for inspection, and 10 minutes of
drilling per unit; product B requires 10 minutes of milling, 4 minutes for inspection, and 8 minutes of drilling per
unit; and product C requires 8 minutes of milling, 4 minutes for inspection, and 16 minutes of drilling. The
department has 20 hours available during the next period for milling, 15 hours for inspection, and 24 hours for
drilling. Product A contributes $2.40 per unit to profit, product B contributes $2.50 per unit, and product C
contributes $3.00 per unit. Determine the optimal mix of products in terms of maximizing contribution to profits
for the period.
Requirements:
a) Define the decision variables;
b) Show the business objective and objective function;
c) List all constraint equations;
d) Create an EXCEL working sheet for the linear programming model;
e) Provide both Answer and Sentivity reports;
f) Find the range of optimality for the profit coefficient of each variable using the reoprts generated.

Solutions

Expert Solution

  1. Define the Decision Variables:

A is the production quantity of Product A- In Units;

B is the production quantity of Product B- In Units;

C is the production quantity of Product C- In Units.

b. Business Objective is to Maximize this which is the Objective Function = 2.4A + 2.5B + 3C

c. Constraints are Subject to: 12A + 10B + 8C ≤ 1200    (for milling)

                  5A   + 4B   + 4C ≤ 900      (for inspection)

                  10A + 8B   + 6C ≤ 1440    (for drilling)

Also note that; A ≥ 0, B ≥ 0, C ≥ 0

Optimal Solution solved using Excel is:

A=0,

B=80,

C=50 and the maximum profit = 350

Optimality range for variable A is [-∞, 3.042] = [2.4 - ∞, 2.4+0.642]

Optimality range for variable B is [1.95, 3.75] = [2.5-0.55, 2.5+1.25]

Optimality range for variable C is [2, 5] = [3-1, 3+2]

Shadow price for resource of milling hours is 0.16666667 with a feasibility range of [1200-480, 1200+600] = [720, 1800]. Since 25 hours = 25*60=1500 minutes which is within the range of [720, 1800],

new maximum profit will be equal to = 350 + 0.16666667*(1500-1200) = 400.

Shadow price for resource of drilling hours is 0.10416667 with a feasibility range of [1440-480, 1440+960] = [960, 2400]. Since 20 hours = 20*60=1200 minutes which is within the range of [960, 2400],

therefore, the new maximum profit will be equal to = 350 + 0.10416667*(1200-1440) = 325.


Related Solutions

A small firm makes three products, which all follow the same three-step process, which consists of...
A small firm makes three products, which all follow the same three-step process, which consists of milling, inspection, and drilling. Product A requires 6 minutes of milling, 5 minutes of inspection, and 4 minutes of drilling; product B requires 2.5 minutes of milling, 2 minutes of inspection, and 2 minutes of drilling; and product C requires 5 minutes of milling, 4 minutes of inspection, and 8 minutes of drilling. The department has 20 hours available during the next period for...
Holt Company makes three products in a single facility. Data concerning these products follow: Products A...
Holt Company makes three products in a single facility. Data concerning these products follow: Products A B C Selling price per unit $58 $68 $44 Variable production cost per unit $20 $29 $17 Variable selling cost per unit $2 $3 $2 Mixing minutes per unit 4 2 5 Monthly demand in units 3,000 1,000 3,000 The mixing machines are potentially the constraint in the production facility. A total of 27,000 minutes are available per month on these machines. Direct labour...
A manufacturing company makes three products, A, B, and C. The fixed FO is $60,000, consisting...
A manufacturing company makes three products, A, B, and C. The fixed FO is $60,000, consisting of $10,000 for material handling, material waste, and procurement; $30,000 for rent and utilities; and $20,000 for safety and canteen costs. Other costs are shown in Table 6.16 Product A Product B Product C Number of Units Produced Per Month (-)       250 400 900 Total Material Costs Per Month ($)     5000 8000 4000 Labor Hours Per Unit (hr) 4 3.5 1.5 Labor Rate Per...
Weiss Enterprises makes three products in a single facility. Data concerning these products follow: Product A...
Weiss Enterprises makes three products in a single facility. Data concerning these products follow: Product A B C Selling price per unit $ 90.90 $ 73.00 $ 82.30 Direct materials $ 39.60 $ 40.70 $ 49.50 Direct labor $ 28.60 $ 13.10 $ 9.60 Variable manufacturing overhead $ 5.50 $ 4.50 $ 4.50 Variable selling cost per unit $ 4.20 $ 3.30 $ 2.70 Mixing minutes per unit 7.50 1.00 1.00 Monthly demand in units 3,000 1,000 2,000 The mixing...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A B C Selling price per unit $ 90.30 $ 77.40 $ 139.30 Direct materials $ 39.40 $ 43.20 $ 83.80 Direct labor $ 28.40 $ 13.80 $ 21.50 Variable manufacturing overhead $ 5.50 $ 4.60 $ 10.00 Variable selling cost per unit $ 7.70 $ 3.30 $ 6.10 Mixing minutes per unit 13.70 2.00 2.00 Monthly demand in units 3,000 1,000 2,000 The mixing...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A B C Selling price per unit $ 91.60 $ 78.20 $ 125.10 Direct materials $ 39.90 $ 43.60 $ 75.20 Direct labor $ 28.80 $ 13.90 $ 20.10 Variable manufacturing overhead $ 5.60 $ 4.60 $ 9.40 Variable selling cost per unit $ 8.70 $ 3.30 $ 5.80 Mixing minutes per unit 15.40 2.00 2.00 Monthly demand in units 3,000 1,000 2,000 The mixing...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A B C Selling price per unit $ 76.10 $ 72.70 $ 77.10 Direct materials $ 33.10 $ 40.60 $ 46.40 Direct labor $ 24.00 $ 13.10 $ 7.20 Variable manufacturing overhead $ 4.60 $ 4.40 $ 3.30 Variable selling cost per unit $ 1.60 $ 3.20 $ 2.00 Mixing minutes per unit 2.80 1.90 2.60 Monthly demand in units 3,000 1,000 2,000 The mixing...
Holvey Company makes three products in a single facility. Data concerning these products follow: Product A...
Holvey Company makes three products in a single facility. Data concerning these products follow: Product A B C   Selling price per unit $ 70.00 $ 92.40 $ 85.90   Direct materials $ 34.00 $ 50.50 $ 56.90   Direct labor $ 21.40 $ 24.00 $ 14.80   Variable manufacturing overhead $ 1.20 $ .60 $ .50   Variable selling cost per unit $ 1.80 $ 2.30 $ 2.10   Mixing minutes per unit 1.20 .80 0.40   Monthly demand in units 2,000 4,000 2,000 The mixing...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A B C Selling price per unit $ 137.10 $ 74.80 $ 167.60 Direct materials $ 59.70 $ 41.70 $ 100.70 Direct labor $ 43.00 $ 13.30 $ 29.50 Variable manufacturing overhead $ 8.20 $ 4.30 $ 13.80 Variable selling cost per unit $ 15.20 $ 3.10 $ 8.50 Mixing minutes per unit 26.90 2.00 2.00 Monthly demand in units 3,000 1,000 2,000 The mixing...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A...
Holton Company makes three products in a single facility. Data concerning these products follow: Product A B C Selling price per unit $ 91.60 $ 78.20 $ 125.10 Direct materials $ 39.90 $ 43.60 $ 75.20 Direct labor $ 28.80 $ 13.90 $ 20.10 Variable manufacturing overhead $ 5.60 $ 4.60 $ 9.40 Variable selling cost per unit $ 8.70 $ 3.30 $ 5.80 Mixing minutes per unit 15.40 2.00 2.00 Monthly demand in units 3,000 1,000 2,000 The mixing...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT