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

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

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

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  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..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  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.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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