Linear programming using manual computation and excel solver

Assignment Help Operation Management
Reference no: EM1323429

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

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.

Reference no: EM1323429

Questions Cloud

Predicting kilowatt usage : Predicting Kilowatt Usage- Economics/Information System This paper uses excel to predict how kilowatt usage can be controlled over the next year using a growth grate
Prepare a variance analysis report : Prepare a variance analysis report based on the information
Overall description of company history : Company Research of five companies is provided in the structured manner in this response. The answer includes references employed.
Who should be responsible for security : Who should be responsible for security- the government or individuals? Why do you think that?
Linear programming using manual computation and excel solver : Formulate linear programming model for this problem. Mention the objective function (minimize or maximize) and all model constraints. Solve this model graphically. Identify the following: each constraint line, feasible solution area, x1, x2 and Z..
Decision making models memo : For this assignment, you must submit a memo consisting of 900-1,300 words in which you discuss your experience using the 3 decision-making models.
Computer production planning by linear programming : Help the computer manufacturer formulate and solve a linear programming spreadsheet model to find the production schedule that minimizes total cost over the given planning horizon.
The importance of organizational testing methodologies : The Importance of Organizational Testing Methodologies - This solution describes the importance of testing in organizations.
Determining business research and methodology : How are Hypothesis Development and Theoretical Framework employed in Healthcare? How does the Measurement of Variables (Operation Definition) play a role in Healthcare Field.

Reviews

Write a Review

 

Operation Management Questions & Answers

  Technology and sustainability issues

Evaluate how technology, product, and process developments enable a large company like Anglo American to be sustainable, or not.

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Case study-american multinational enterprise

Overseas, an American multinational enterprise with its headquarters in New York. After giving the minister of finance of state X a valuable piece of diamond

  Pert/cpm techniques

Discuss the use of PERT/CPM techniques for managing projects. Describe what PERT/CPM does. Discuss advantages and disadvantages of using it.

  Demand and capacity

Process Layout, Product Layout, Fixed position Layout, shaping of business policy, key objective of the operations manager, managing both demand and capacity

  Mathematical formulation of the model

Mathematical formulation of the model

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Describe the organisational culture

Describe the organisational culture or leadership style within Walmart

  Combating five consumer products

Consider the "Alternative Approach" to combating five consumer products (alcohol, tobacco, guns, motor vehicles, and junk food) and determine whether you agree or disagree with the approach suggested.

  Produce a management report

You are required to produce a management report from the perspective of a consultant, reporting back to your client - the CEO of an overseas museum.

  Describe the elements of valid contract

Explain the elements of valid contract, and describe how consumers and banks each have a duty of good faith and fair dealing in the banking relationship.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd