In: Advanced Math
The Lifang Wu Corporation manufactures two models of industrial robots, the Alpha 1 and the Beta 2. The firm employs 5 technicians, working 160 hours each per month, on its assembly line. Management insists that full employment (that is, all 160 hours of time) be maintained for each worker during next month’s operations. It requires 20 labor-hours to assemble each Alpha 1 robot and 25 labor-hours to assemble each Beta 2 model. Wu wants to see at least 10 Alpha 1s and at least 15 Beta 2s produced during the production period. Alpha 1s generate a $1,200 profit per unit, and Beta 2s yield $1,800 each.
a. Determine the most profitable number of each model of robot to produce during the coming month.
b. What is the total profit?
c. What if there was a reduction in 50 hours, what impact, in terms of profit, would this decision have?
linear program model using excel is shown below :
click "solve" option , it will shown below: