{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

311_session_12_linear_programming

# 311_session_12_linear_programming - Introduction to Linear...

This preview shows pages 1–15. Sign up to view the full content.

1 Introduction to Linear Programming BUAD311 Operations Management Session 12

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

View Full Document
2 Objectives Concepts: Linear problem Objective function Decision variables Constraints Feasible solutions Learn how to formulate a linear program in Excel
3 Example 1 Two products, X and Y, both require processing time on machines I and II. Machine I has 200 hours available, and machine II has 400 hours available. Product X requires one hour on machine I and four hours on machine II. Product Y requires one hour on machine I and one hour on machine II. Each unit of product X yields \$10 profit and each unit of Y yields \$5.

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

View Full Document
4 Example 1 Identify: Objective function Decision variable(s) Constraints
5 How to find the optimal solution? Excel Solver Paper and pencil method, if you have too much time

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

View Full Document
6 How to solve the LP Assign cells to decision variables.
7 How to solve the LP Assign a cell to the objective function and type in the objective.

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

View Full Document
8 How to solve the LP Enter constraints
9 How to solve the LP Choose solver under tools menu (2003) Choose solver under Data tab (2007)

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

View Full Document
10 How to solve the LP Target cell : objective
11 How to solve the LP By changing cells : decision variables

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

View Full Document
12 How to solve the LP Add constraint(s)
13 How to solve the LP Click on “solve”!

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

View Full Document
14 The solver You see the results on the spread sheet, or on the answer report.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern