Thanks for installing the Bottom of every post plugin by Corey Salzano. You will turn in the entire spreadsheet, showing the setup of the model, and the results.Ĭlick here to view the grading rubric for this assignment. Clearly label the cells in your spreadsheet.
Explain what the results mean.įinally, write a paragraph addressing the part of the problem pertaining to sensitivity analysis and shadow price.Īs previously noted, please set up your problem in QM for Windows or Excel and find the solution using Solver. Then, you should present the optimal solution, based on your work in Excel. Include the objective function and all constraints, including any non-negativity constraints. This should be encapsulated in one (1) or two (2) succinct paragraphs.Īfter the introductory paragraph, write out the L.P. Step 3: Determine the gradient for the line representing the solution (the linear objective function). Step 2: Plot the inequalities graphically and identify the feasible region. Identify each variable and explain the criteria involved in setting up the model. Now, we have all the steps that we need for solving linear programming problems, which are: Step 1: Interpret the given situations or constraints into inequalities. For example, you should note if the problem is a maximization or minimization problem, as well as identify the resources that constrain the solution. Weenies and Buns would like to know how many hot dogs and how many hot dog buns they should. Correctly identify what type of problem this is. Solutions to Linear Programming ProblemsFull description. Your writeup should introduce your solution to the project by describing the problem. You will be turning in two (2) deliverables, a short writeup of the project and the spreadsheet showing your work. The problem will also include a component that involves sensitivity analysis and the use of the shadow price. It will also have a single optimum solution (in other words, it won’t have alternate optimal solutions). The problem will be bounded and feasible. It will be a problem with at least three (3) constraints and at least two (2) decision variables.
Your instructor will assign a linear programming project for this assignment according to the following specifications.
#How to use excel qm linear programming how to#
I’m studying for my Excel class and don’t understand how to answer this.