(a)
Optimization model is following:
(b)
Set up Excel model as follows:
Set up Solver Parameters as follows:
Note that this is a nonlinear model, so Select a Solving Method: GRG Nonlinear
Click Solve. After that, values will appear automatically in variable cells (C2:C4)
Click OK
---
Result:
Units of product 1 | x1 = | 3.667 |
Units of product 2 | x2 = | 2.667 |
Overtime hours | OT = | 6.667 |
Profit | P = | $ 881.667 |
The profit function for two products is Profit = -3x,? + 42x4 - 3x2? + 46x2...
15. Combining raw materials M and M2 and labor, a company produces units of A. B, and C. The requirements and profit (excluding the cost of labor) for the production and sale of a unit of each are as follows: Mi (lb) M2 (lb) Labor (hr) Profit (S) 105 165 60 12 For the next month, the company has available 1 ton of Mi. 2.5 tons of M2, 500 hr of labor at $18/hr, and up to an additional 120...
We were unable to transcribe this image(c) Suppose that 8, 6, and 8 hours of overtime may be scheduled in departments A, B, and C, respectively. The cost per hour of overtime is $18 in department A, $22.50 in department B, and $12 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made available. What are the optimal production quantities, and what is the revised total contribution to...
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,...
Use Excel/Solver add in for accurate answers.
Problem 3-19 (Algorithmic) Better Products, Inc., manufactures three products on two machines. In a typical week, 40 hours are available on each machine. The profit contribution and production time in hours per unit are as follows: Category Product 1 Product 2 Product 3 Profit/unit $39 $51 $18 Machine 1 time/unit 1.5 Machine 2 time/unit Two operators are required for machine 1; thus, 2 hours of labor must be scheduled for each hour of...
Slavin Corporation manufactures two products, Alpha and Delta. Each product requires time on a single machine has a monthly capacity of 500 hours. Total market demand for the two products is limited to 1 monthly. Slavin is currently producing 110 Alphas and 110 Deltas each month. Cost and machine-usage products are shown in the following table, which Slavin managers use for planning purposes. Alpha $ 121 Total Delta $ 151 33 36 Price Less variable costs per unit Material Labor...
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...
1. Better Products manufactures three products on two machines. There is $30 profit associated with Product 1, $50 profit with Product 2, and $20 profit with Product 3. Each product requires labor time using machine A and machine B. Product 1 requires 1 hour from machine A and 1 hour from machine B. Product 2 requires 4 hours from machine A and 1 hour from machine B. Product 3 requires 1.5 hours from machine A and .5 hours from machine...
1. A manufacturing company would like to maximize the profit of manufacturing four products. The time in hours required for each product in each production department is tabled below, along with the profit for each product. Product 1 Product 2 Product 3 Product 4 Department A 25 20 30 15 Department B 12 10 10 15 Department C 8 7 5 6 Profit $110 $90 100 95 Currently, labor assignments provide for 4800 hours in Department A, 3000 hours in Department...
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 2.00 1.50 3.00 B 2.50 2.00 1.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 $30 for product 1, $25 for product 2,...
A company that manufactures three products, A. & and using three machines, M1, M2, and M3, wants to determine the optimal production schedule the maximizes the total profit. Product A has to be processed by machines M1, M2, and M3, product B requires M1 and M3, while product requires M1 and M2. The unit profits on the three products are $5,54 and 56, respectively. The following linear program is formulated to determine the optimal product mic Maximize S. Z-5x -...