Explore BrainMass

Explore BrainMass

    Linear Programming using Manual Computation and Excel Solver

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 March 5, 2021, 12:30 am ad1c9bdddf
    https://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.

    $2.49

    ADVERTISEMENT