{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

311_session_11_linear_programming

# 311_session_11_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 11

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 ]}

### Page1 / 26

311_session_11_linear_programming - Introduction to Linear...

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

View Full Document
Ask a homework question - tutors are online