Operations Management Problem- Linear Programming
MSA Computer Corporation manufactures two models of smartphones, the Alpha 4 and the Beta 5. The firm employs five technicians, working 160 hours each per month, on its assembly line. Management insists that full employment (i.e., all 160 hours of time) be maintained for each worker during next month’s operations. It requires “A” labor hours to assemble each Alpha 4 computer and “B” labor hours to assemble each Beta 5 model. MSA wants to see at least “C” Alpha 4s and at least “D” Beta 5s produced during the production period. Alpha 4s generate “E” dollars profit per unit, and Beta 5s yield “F” dollars each. The company needs to determine the most profitable number of each model of smartphone to produce during the coming month.
Based on this case a) What is the objective function? Express the objective function in mathematical terms (2 pt)
b) What are the constraints given in the question? (i.e. ignore the constraints like all variables being positive, etc.) (3 constraints, 1 pt each, 3 pts total)
c) Solve the problem using Excel’s solver and determine the number of Alpha 4s and Beta 5s needed to be manufactured. (2 pt.)
Values are:
A= 10, B=16, C=9, D= 13, E= 1200, F= 1800
A = Number of Alpha 4 produce
B = Number of Beta 5 produce
(a) Objective function:
Max 1200A + 1800B
(b) Constraints:
10A + 16B <= 800 [160*5 = 800]
A >=9
B>=13
(c)
Setting this up in excel:
Initial formulation:
Solver constraints:
Clicking solve, we get
Number of Alpha 4s needed = 59
Number of beta 5s needed = 13
Total profit = $94,200
PLEASE LEAVE A LIKE. IT REALLY HELPS ME A LOT. THANK YOU!!!
Operations Management Problem- Linear Programming MSA Computer Corporation manufactures two models of smartphones, the Alpha 4...
MSA Computer Corporation manufactures three models of computers: the Alpha4, Beta5, and the Delta6. The firm employs thirteen technicians working 160 hours each per month on its assembly line. Management insists that no more than full employment on the assembly line (i.e., all 160 hours of time) can be maintained for each worker during next month’s operations, so there will be no overtime. It requires 20 labor hours to assemble each Alpha4 computer, 25 labor hours for each Beta5 model,...
Exercise 2 Linear Programming 1. The Scrod Manufacturing Co. produces two key items – special-purpose Widgets (W) and more generally useful Frami (F). Management wishes to determine that mix of W & F which will maximize total Profits (P). Data W F Unit profit contributions $ 30 $ 20 Demand estimates (unit/week) 250 500 Average processing rates – each product requires processing on both machines (units/hour) Machine #1 2 4 Machine #2 ...
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,...
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...