1) LP model formulation (math expressions of the objective function and constraints, along with the definitions of the decision variables)

2) Graphical solution (draw the graph and solve the problem manually)

3) Excel Solver solution (Excel model layout and Solver inputs)

All done on excel

B.8 The Lifang Wu Corporation manufactures two mod- els 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 Is and at least 15 Beta 2s pro- duced during the production period. Alpha Is generate a $1,200 profit per unit, and Beta 2s yield S1,800 each. Determine the most profitable number of each model of robot to produce during the coming month. PX