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

  Conclusions of empirical research

How do you determine if the conclusions of empirical research are logically supported or not? Do conclusions that are not logically supported invalidate the entire study? Why or why not?

  Write down an operational plan

You have to select a organization of your choice, and after that you have to write down an Operational Plan which addresses the following

  Operational process

Find one scholarly journal article reporting on one or more of the following techniques: business/predictive analytics, dashboards, decision support systems, supply chain management.

  Target market in the united states

Describe the target market in the United States, including customer demographics and income levels. Describe the competition the product would face in the United States and how you would create a competitive advantage. Name at least two competitors..

  A make-or-buy analysis

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

  Applying om techniques to your organization

Find out in your organization an aspect of the operational process which could benefit from use of one or more of the given techniques: business or predictive analytics, dashboards, decision support systems and supply chain management.

  Store space allocation planning problem

The solution offers step by step guidance on how to formulate the problem mathematically. It comprises a solution to problem instance using Excel Solver.

  Technology and sustainability issues

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

  Contrast the regulatory alternatives

Compare and contrast the regulatory alternatives of the text in terms of the efficiency and efficacy these alternatives might provide to businesses and consumers.

  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

  Calculate a service level for each of the airlines

Calculate a service level for each of the above airlines. Marketing expenses for each quarter are known in advance, and could be used to improve forecasting performance with respect to the number of subscribers.

  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.

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