# Linear Programming using Manual Computation and Excel Solver

1.Universal Claims Processors processes insurance claims for large national insurance companies. , Most claim processing is done by a large pool of computer operators, some of whom are permanent and some of whom are temporary. A permanent operator can process 16 claims per day, whereas a temporary operator can process 12 per day, and on average the company processes at least 450 claims each day. The company has 40 computer workstations. A permanent operator generates about 0.5 claims with errors each day, whereas a temporary operator averages about 1.4 defective claims per day. The company wants to limit claims with errors to 25 per day. A permanent operator is paid $64 per day, and a temporary operator is paid $42 per day. The company wants to determine the number of permanent and temporary operators to hire in order to minimize costs.

a. Formulate a linear programming model for this problem. List the objective function (minimize or maximize) and all model constraints.

b. Solve this model graphically. Identify the following: each constraint line, feasible solution area, x1, x2 and Z for each point, and clearly identify the optimal solution.

c. Solve problem using MS Excel's Solver

© BrainMass Inc. brainmass.com October 10, 2019, 5:38 am ad1c9bdddfhttps://brainmass.com/business/operations-research/linear-programming-using-manual-computation-and-excel-solver-512231

#### Solution Summary

This is a linear programming problem that shows model formulation and graphical solutions. The solutions is contained in the attached file showing the detailed solution.