# 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.Writeup.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.Excel.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.Original work onlyProblem attached
assignment_1_week_8___2_.docx

Unformatted Attachment Preview

Don't use plagiarized sources. Get Your Custom Essay on
Assignment 1. Linear Programming Case Study
Just from \$13/Page

Assignment 1: Week 8
1.
2.
3.
4.
5.
6.
7.
Is this a maximization or minimization question?
Identify the variables
State the objective function
Identify each constraint
Identify the vertices
Provide a graph
Determine the optimal value
*Use excel, solver, or POM. To solve this model. Do not graph by hand.
Solve the following LPP graphically using linear programming method.
maximize Z =100x 100y.
Subject to the constraints

attachment

Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

### Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors: