LP_with_Excel_New

LP_with_Excel_New - Solving Linear Programming Problems by...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Solving Linear Programming Problems by Using Microsoft Excel For better understanding of the solution process we are solving the following problem taken from the “Introduction to Management Science” book by Hillier and Hillier. You are given the following Algebraic formulation and need to set up and solve this problem using EXCEL: Decision Variables: x1, x2 Maximize Profit: Z = 10 x1 + 20 x2 Subject to: (1) -x1 + 2 x2 <= 15 (resource 1) (2) x1 + x2 <= 12 (resource 2) (3) 5 x1 + 3 x2 <= 45 (resource 3) (4) x1 >= 0, x2 >= 0 (non-negativity) In the exercise we are given a linear programming model in an algebraic format, and the objective is to choose the values of the Decision Variables (x1 and x2) so as to maximize the total profit. The problem has three constraints based on the resources that are available. 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Step1 The first step is to gather the data for the problem and enter them into data cells on a spreadsheet. Step 2
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

LP_with_Excel_New - Solving Linear Programming Problems by...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online