Reference no: EM131759002

The Computer Services Department must decide how to allocate 21 new PC's. Three different departments have been designated to receive the PC's: the Production Department, Marketing Department, and Finance Department. Each department has requested as many PC's as they can get.

The Production Department can increase its productivity by 5% for each new PC it gets. The Marketing Department can increase its productivity by 3% for each new PC it gets. The Finance Department can increase its productivity by 2% for each new PC it gets.

All of the new PC's must be allocated, subject to the following constraints. The Production Department needs at least five PC's. Because of the company politics, the Finance Department must have no less than half as many new PC's as the Marketing Department. It also must have at least one third as many new PC's as the Production Department.

The problem is to allocate all the new PC's to the Production, Finance, and Marketing Department so as to maximize the total increase in productivity.

e. Solve this problem with a computer using Lingo or excel solver.

f. On the basis of your computer solution in part e, state in plain language the best allocation of the new laptops and the total percent productivity increase that would result.

g. On the basis of your computer solution in part e, intrepret, in plain language any amounts of slack/surplus involved in the optimal solution.

h. On the basis of your computer solution in part e, determine the ranges of optimality on the productivity gain per new Laptop for each department.

i. state the name of the specific methodology used by your computer program to solve this problem.