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 months 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 Excels 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