The Ace Manufacturing Company has orders for three similar products:
Product | Order (Units) |
A | 1900 |
B | 550 |
C | 1300 |
Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are as follows:
Machine | Capacity (Units) |
1 | 1400 |
2 | 1500 |
3 | 1100 |
Product | |||
Machine | A | B | C |
1 | $1.00 | $1.20 | $0.80 |
2 | $1.30 | $1.40 | $1.40 |
3 | $1.00 | $1.00 | $1.50 |
Use the transportation model to develop the minimum cost production schedule for the products and machines. Show the linear programming formulation. If required, round your answers to one decimal place.
The linear programming formulation and optimal solution are shown.
Let | x1A | Units of product A on machine 1 | |
x1B | = | Units of product B on machine 1 | |
• | |||
• | |||
• | |||
x3C | = | Units of product C on machine 3 |
Min | x1A | + | x1B | + | x1C | + | x2A | + | x2B | + | x2C | + | x3A | + | x3B | + | x3C | ||
s.t. | |||||||||||||||||||
x1A | + | x1B | + | x1C | ≤ | ||||||||||||||
x2A | + | x2B | + | x2C | ≤ | ||||||||||||||
x3A | + | x3B | + | x3C | ≤ | ||||||||||||||
x1A | + | x2A | + | + | x3A | = | |||||||||||||
x1B | + | x2B | + | x3B | = | ||||||||||||||
x1C | + | x2C | + | x3C | = | ||||||||||||||
xij ≥ 0 for all i, j |
Optimal Solution | Units | Cost |
---|---|---|
1-A | $ | |
1-B | $ | |
1-C | ||
2-A | ||
2-B | $ | |
2-C | $ | |
3-A | ||
3-B | ||
3-C | $ | |
Total $ |
Min | 1.x1A | + | 1.2 x1B | + | 0.8 x1C | + | 1.3 x2A | + | 1.4 x2B | + | 1.4 x2C | + | 1 x3A | + | 1 x3B | + | 1.5 x3C | ||
s.t. | |||||||||||||||||||
1 x1A | + | 1 x1B | + | 1 x1C | ≤ | 1400 | |||||||||||||
1 x2A | + | 1 x2B | + | 1 x2C | ≤ | 1500 | |||||||||||||
1 x3A | + | 1 x3B | + | 1 x3C | ≤ | 1100 | |||||||||||||
1 x1A | + | 1 x2A | + | + | 1 x3A | = | 1900 | ||||||||||||
1 x1B | + | 1 x2B | + | 1 x3B | = | 550 | |||||||||||||
1 x1C | + | 1 x2C | + | 1 x3C | = 1300 |
The Ace Manufacturing Company has orders for three similar products: Product Order (Units) A 1900 B...
The Ace Manufacturing Company has orders for three similar products: Product Order (Units) A 1750 B 500 C 1100 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are as follows: Machine Capacity (Units)...
Problem 6-09 (Algorithmic) The Ace Manufacturing Company has orders for three similar products Product Order (Units) 1950 600 1100 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are as follows Capacity Machine (Units)...
Using the LP Formulation below and excel solver, explain step by step how to turn it into a linear programming model. Decision Variables: Let xij= units to be shipped from supplier I to customer j, where i= 1- supplier 1 = 2- supplier 2 = 3- supplier 3 = 4- Toledo supplier j= A- customer a = B- customer b = C- customer c Objective Function: The objective is to minimize transportation costs with Toledo supplier. 10x1a+14x1b+10x1c+12x2a+17x2b+20x2c+11x3a+11x3b+12x3c+18x4a+8x4b+14x4c Constraints: Supplier...
Guide Stone 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...
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 с 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 $27 for product 1, $29 for product 2,...
For this section, no need to solve the questions and submit answers Your company is a major distributor of coffee in the UAE. You can buy coffee from 5 roasters and distribute the coffee to three UAE cities (Al-Ain Abu Dhabi and Dubai). The monthly demand in the three cities is as follows: City Monthly Demand (tons) 1. Al-Ain 50 2- Abu Dhabi 120 3. Dubai 280 order to guarantee supplies from the five coffee roasters, you need to sign...
Glocker Company makes three products in a single facility. These products have the following unit product costs: 3 Product B 5 Direct Materials $ 10.90 $ 15.80 $ 12.60 6 Direct Labor 18.50 12.60 9 .75 7 Variable Manufacturing Overhead 2.40 1.20 1.80 8 Fixed Manufacturing Overhead 11.607.209.60 9 Unit product cost $ 43.40 $ 36.80 $ 33.75 10 11 12 Additional information about the products: Product 14 15 Mixing minutes per unit 2.00 0.50 1.00 16 Selling price per...
I just need the answers fo b, c, d A firm uses three machines in the manufacture of three products. Each unit of product I requires 3 hours on machine 1, 2 hours on machine 2, and I hour on machine 3. Each unit of product:2 requires product 3 requires 2 hours on machine 1, 2 hours on machine 2, and 2 hours on machine 3. The contribution margin of the three products is $30, $40, and $35 per unit,...
Glover Company makes three products in a single facility. These products have the following unit product costs: Product A B C Direct materials $ 33.20 $ 49.70 $ 56.10 Direct labor 20.60 23.20 14.00 Variable manufacturing overhead 1.60 1.00 0.50 Fixed manufacturing overhead 13.10 8.70 9.30 Unit product cost $ 68.50 $ 82.60 $ 79.90 Additional data concerning these products are listed below. Product A B C Mixing minutes per unit 1.60 0.80 0.10 Selling price per unit $ 62.00...
I need (d) and (e) 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 А. 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 $27 for product...