Hangeul KB Help Sitemap Calc Links

Policy Modeling 2022

#### ▒ Homework Assignment

• Homework (Modeling Practice): Sample (2020)
• Homework (LP): 2022 (answer key) HH (2019) pp. 190-191
• Samples: 2021 2020

#### ▒ Exam

• Final exam (13:00 on Thursday, June 16): Exam template
• Samples: 2021 2020

#### Week 1: Introduction (04/8)

1. H&H (2019) Chapter 1.
2. Weimer & Vining (2017) Chapter 2.

Optional

1. Albright & Winston (2005) Chapter 1, 2.
2. Weimer & Vining (2017) Chapter 14, 15 or Dunn (2017) Chapter 1, 2.
3. Boardman, Greenberg, Vining, and Weimer (2018) Chapter 1.
4. Krutilla, Kerry. 2005. Using the Kaldor-Hicks tableau format for cost-benefit analysis and policy evaluation. Journal of Policy Analysis and Management 24(4): 864-875.

#### Week 2: Policy Modeling (04/15)

1. Introduction to policy modeling

#### Week 3: Basics of Linear Programming (04/22)

1. H&H (2019) Chapter 2.
2. Lecture Note Slide LP Illustration Purchasing Fruits

Options

1. Albright & Winston (2005) Chapter 3.
2. Stevenson and Ozgur (2007) Chapter 3.

Lab: Using Excel Solver 1

1. Wyndor Glass
2. H&H (2019) chapter 4.
3. Linear programming part 1: Optimization problem and constraints (11 min)
4. Linear programming part 2: Feasible sets and objective function (11 min)
5. LP Graphical Method by Kauserwise (21 min)
6. Linear Programming 1: Maximization-Extreme/corner points (6 min)
7. Excel Solver 2007 2010 (1) 2010 (2)
8. How to use the SUMPRODUCT function in Excel (6 min)

#### Week 4: Formulating Linear Programming (04/29)

1. LP example problems LP examples
2. H&H (2019) Chapter 5 (5.1 and 5.2).
3. Lecture Note Slide Product Mix Example
4. Simplex Method Illustration

Lab: Using Excel Solver 2

1. Enabling Excel Solver: Office 2010 | Office 2016 Office 2016 Excel for Mac
2. Excel Solver Example 1 | Example 2 | Excel Sumproduct
3. Profit & Gambit Super Grain

#### Week 5: Sensitivity Analysis (05/6)

1. : H&H (2019) Chapter 5 (5.3 and 5.5).
2. Lecture Note Slide

Options

1. Albright & Winston (2005) Chapter 4.
2. Stevenson and Ozgur (2007) Chapter 4.
3. Sensitivity Analysis (MIT) Sensitivity Analysis (UC San Diego)
4. Shadow price, binding/non-binding constraints (7 min)
6. Sensitivity analysis in linear programming (9 min)
7. Linear programming sensitivity analysis totals of constraints (12 min)

#### Week 6: Linear Programming Applications (05/13)

1. H&H (2019) Chapter 3.
2. Slide Degeneracy LP examples

Optional

1. How to solve an assignment problem (7 min)
2. Assignment problem: integer linear programming (7 min)
3. Assignment model with Excel Solver (6 min)
4. Transportation problem class lecture 1 (44 min)
5. Transportation problem class lecture 2 (52 min)
6. How to model a linear programming transportation problem (15 min)

#### Week 7: Queueing Model I (05/20)

1. H&H (2019) Chapter 11 (11.1-11.3).
2. Queueing model Poisson Probability Distribution

Options

1. Albright & Winston (2005) Chapter 11.
2. MIT OpenCourseWare (Poisson Process) 1 2
3. Queueing Theory

#### Week 8: Queueing Model II (05/27)

1. H&H (2019) Chapter 11 (11.4-11.9).
2. Queueing Model Template

Options

1. Hillier & Lieberman (2014) chapter 17.
2. Stevenson and Ozgur (2007) Chapter 13.
3. SAS Simulation Studio (SAS/OR)
4. Queueing Theory by Ivo Adan and Jacques Resing (2002)

Final exam (June 16 in week 11)