Linear programming case study

Assignment Help Operation Management
Reference no: EM13736295

Assignment 1. Linear Programming Case Study

Your instructor will assign a linear programming project for this assignment according to the following specifications.

It will be a problem with at least three (3) constraints and at least two (2) decision variables. The problem will be bounded and feasible. It will also have a single optimum solution (in other words, it won't have alternate optimal solutions). The problem will also include a component that involves sensitivity analysis and the use of the shadow price.

You will be turning in two (2) deliverables, a short writeup of the project and the spreadsheet showing your work.


Your writeup should introduce your solution to the project by describing the problem. Correctly identify what type of problem this is. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Identify each variable and explain the criteria involved in setting up the model. This should be encapsulated in one (1) or two (2) succinct paragraphs.

After the introductory paragraph, write out the L.P. model for the problem. Include the objective function and all constraints, including any non-negativity constraints. Then, you should present the optimal solution, based on your work in Excel. Explain what the results mean.
Finally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.


As previously noted, please set up your problem in Excel and find the solution using Solver. Clearly label the cells in your spreadsheet. You will turn in the entire spreadsheet, showing the setup of the model, and the results.

Reference no: EM13736295

Overview of project change control

Advantages from a business and project management perspective – why should this supplier to Ford Motor Company implement Project Change Control on all of their projects? Conce

What are problems that can occur due to high turnover rate

A manufacturing firm has struggled recently with high staff turnover in the factory. The wage level is similar to the competitors in the local area, with staff being paid an h

How can you determine core competency

How can you determine a core competency? construct a questionnaire with multiple choice options of about 20 items that covers the domains of skills, experience  and education

Switching cost types-procedural-financial and relational

Then, for each of the switching cost types (procedural, financial, and relational), identify one product/service that has high switching costs and another that has low switchi

Contains an interesting discussion of ethics of downsizing

There has been much discussion in recent years regarding the downsizing of employees while salaries and bonuses are increased for senior management. As an HR professional, how

Create positive work environment-improve ethical behavior

Managers face many challenges and opportunities in today’s marketplace. How can organizational behavior concepts be applied by managers to help them improve customer service,

Describe ways in which you might increase personal power

Describe ways in which you might increase your personal power. Include a title page and 3-5 references. Only one reference may be from the internet. The other reference must

Determining whether this office manager is a co-ownher

After two years, the office manager resigns from her position and claims that she is a partner of PraxPlus LLP and entitled to 2% of the value of PraxPlus. Provide analysis of


Write a Review

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