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

  Discussing global operations management

Write a five-page paper discussing "Global Operations Management, Global Operations Manufacturing. What are the benefits/downsides of creating manufacturing operations outside the United States?

  A make-or-buy analysis

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

  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.

  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

  Build and describe a prototype model

Mathematical Programming and Optimisation: Build and describe a prototype model Use your model to recommend a schedule of burning and, if required buying fuels

  Making a critical assessment of the toyota production system

Making a Critical Assessment of the Toyota Production System (TPS) Today Use of a Grid Analysis (Weighted Scoring Model) to Help Make the North American Plant Location Decision for the RX 330

  Four essential elements of contract

Identify and define each of the four essential elements of a contract. Use the facts of the case to explain whether each of these elements is present and whether a contract has been formed.

  Computer-aided design

Computer-Aided Design is one of the techniques used by Regal Marine in the manufacturing of boats. With the aid of examples, critically discuss FIVE (5) techniques that are important to the design of Regal Marine's product

  Stochastic dynamic programming problem

Determine the problem as stochastic dynamic programming problem. Specify phases, states, decisions and the optimal value function.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  New zealander company-case study

Assume that you work for a New Zealander company exporting a container of kiwis to Azerbaijan or Haiti. The customs official informs you that there is a delay in clearing your container through customs, and it may last a month

  Primary reason of gender discrimination

Write TWO PAGE about your position on Is gender discrimination the primary reason why men are paid more than women for the same position?

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