Question

In: Operations Management

Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and...

Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows:

Department Product 1 Product 2 Product 3
A 3.00 2.00 1.50
B 1.00 2.50 2.00
C 0.25 0.25 0.25

During the next production period the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are $28 for product 1, $30 for product 2, and $25 for product 3.

(a) Formulate a linear programming model for maximizing total profit contribution.
If the constant is "1" it must be entered in the box. If required, round your answers to two decimal places.
Let Pi = units of product i produced
Max $ P1 + $ P2 + $ P3
s.t.
P1 + P2 + P3 - Select your answer -≤≥=Item 7
P1 + P2 + P3 - Select your answer -≤≥=Item 12
P1 + P2 + P3 - Select your answer -≤≥=Item 17
P1, P2, P3 ≥ 0
(b) Solve the linear program formulated in part (a). How much of each product should be produced, and what is the projected total profit contribution?
Product 1 Product 2 Product 3
Amount to Produce

Profit $
(c) After evaluating the solution obtained in part (b), one of the production supervisors noted that production setup costs had not been taken into account. She noted that setup costs are $600 for product 1, $550 for product 2, and $400 for product 3. If the solution developed in part (b) is to be used, what is the total profit contribution after taking into account the setup costs?
$
(d) Management realized that the optimal product mix, taking setup costs into account, might be different from the one recommended in part (b). Formulate a mixed-integer linear program that takes setup costs provided in part (c) into account. Management also stated that we should not consider making more than 175 units of product 1, 150 units of product 2, or 140 units of product 3. What are the new objective function and additional equation constraints?
If the constant is "1" it must be entered in the box.
Let Yi is one if any quantity of product i is produced and zero otherwise.
Max $ P1 + $ P2 + $ P3 - $ Y1 - $ Y2 - $ Y3
s.t.
P1 - Select your answer -≤≥=Item 31 Y1
P2 - Select your answer -≤≥=Item 34 Y2
P3 - Select your answer -≤≥=Item 37 Y3
P1, P2, P3 ≥ 0
(e) Solve the mixed-integer linear program formulated in part (d). How much of each product should be produced and what is the projected total profit contribution? Compare this profit contribution to that obtained in part (c).
If required, round your answers to nearest whole number. If your answer is zero enter “0”.
Product 1 Product 2 Product 3
Amount to Produce

Updated Profit $

Solutions

Expert Solution

a)

The formulation will be

Max 28P1 + 30P2 + 25P3

ST

3P1 + 2P2 + 1.5P3 <= 450

1P1 + 2.5P2 + 2 P3 <= 350

0.25P1 + 0.25P2 + 0.25P3 <=50

P1, P2, P3 >= 0

b)

The solution is shown below

Amount to product

P1 = 80

P2 = 60

P3 = 60

Profit = 5540

c)

Profit = 5540 – 600 – 550 – 400 = 3990

d)

If there is setup cos then the modification are

Max 28P1 + 30P2 + 25P3 - 600Y1 - 550Y2 - 400Y3

ST

P1 <= 175Y1

P2 <= 150Y2

P3 <= 140Y3

e)

The solution is shown below

P1 = 100

P2 = 0

P3 = 100

Profit = 4300


Related Solutions

Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and...
Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows: Department Product 1 Product 2 Product 3 A 1.50 3.00 2.00 B 2.00 1.00 2.50 C 0.25 0.25 0.25 During the next production period the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are $25 for product 1, $28 for product 2,...
Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and...
Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows: Department Product 1 Product 2 Product 3 A 3.00 2.00 1.50 B 1.00 2.50 2.00 C 0.25 0.25 0.25 During the next production period the labor-hours available are 450 in department A, 350 in department B, and 50 in department C. The profit contributions per unit are $28 for product 1, $30 for product 2,...
A company manufactures Products A, B, and C. Each product is processed in three departments: I,...
A company manufactures Products A, B, and C. Each product is processed in three departments: I, II, and III. The total available labor-hours per week for Departments I, II, and III are 900, 1080, and 840, respectively. The time requirements (in hours per unit) and profit per unit for each product are as follows. (For example, to make 1 unit of product A requires 2 hours of work from Dept. I, 3 hours of work from Dept. II, and 2...
A company manufactures Products A, B, and C. Each product is processed in three departments: I,...
A company manufactures Products A, B, and C. Each product is processed in three departments: I, II, and III. The total available labor-hours per week for Departments I, II, and III are 900, 1080, and 840, respectively. The time requirements (in hours per unit) and profit per unit for each product are as follows. (For example, to make 1 unit of product A requires 2 hours of work from Dept. I, 3 hours of work from Dept. II, and 2...
A company manufactures Products A, B, and C. Each product is processed in three departments: I,...
A company manufactures Products A, B, and C. Each product is processed in three departments: I, II, and III. The total available labor-hours per week for Departments I, II, and III are 900, 1080, and 840, respectively. The time requirements (in hours per unit) and profit per unit for each product are as follows. (For example, to make 1 unit of product A requires 2 hours of work from Dept. I, 3 hours of work from Dept. II, and 2...
ABC products makes parts for car engines. three departments (A, B and C) are involved in...
ABC products makes parts for car engines. three departments (A, B and C) are involved in the manufacturing process. The budgets for departmental overhead costs are $25,000, $45,000 and $30,000 respectively, which are allocated to products based on direct labor hours. Estimates of direct labor hours for each department are 5,000 7,000 and 10,000 hours respectively. The business-wide overhead absorption rate is: a. $3.00 b. $4.55 c. $4.81 d. 5.00
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...
Sonata Corporation makes three types of products—Model Z, Model EF, and Model DS. The manufacturing operations...
Sonata Corporation makes three types of products—Model Z, Model EF, and Model DS. The manufacturing operations are mechanized and there is no direct labor. Manufacturing overhead costs are significant, and Destiny has adopted an activity-based costing system. Direct materials costs per unit for each model are as follows: Model Z           $93 Model EF         $88 Model DS        $127 Sonata Corporation has 5 activities—assembly, materials management, testing, inspecting and milling. The cost driver for assembly is machine hours. Total costs and production...
ABC Limited makes three products; A, B and C. Details of product direct costs and volumes...
ABC Limited makes three products; A, B and C. Details of product direct costs and volumes for the period are as follows: Product A B C Direct material cost per unit £5.00 £4.50 £12.50 Direct labour cost per unit £9.00 £18.00 £27.00 Labour hours per unit 1 hours 2 hours 3 hours Machine hours per unit 3 hours 6 hours 9 hours Production volumes for period 3,500 750 750 Total production overheads for the period are £362,500. ABC Ltd currently...
You now own a manufacturing firm and your firm makes 6 products. Each product has the...
You now own a manufacturing firm and your firm makes 6 products. Each product has the following cost components: Material, Labor, and Marketing. In addition, there is a fixed cost for the firm. Cost of item in production units Production units BA AB XC RC WA RT Material Units 2 2 1 1 3 1 Labor units 1 1 1 2 2 1 Marketing 1 1 1 2 2 1 Production units cost per unit Material $7 5 4 5...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT