Indiana University   Hangeul KB Help Sitemap Calc Links

Policy Modeling 2021

This page is to support Introduction to Policy Modeling.

▒ SYLLABUS & ANNOUNCEMENT

▒ COMPUTING SKILL & EXCEL

▒ Homework Assignment

  1. Modeling Practice: Sample PDF icon
  2. LP: Homework assignment (Due May 21) PDF iconNew Icon Exam template MS Word icon
  3. LP Sample question PDF icon Answer Key PDF icon

▒ Exam

Bivariate Normal Distribution

Week 1: Introduction (04/7)

Readings

  1. H&H (2019) Chapter 1. PDF icon
  2. Weimer & Vining (2010) Chapter 2. PDF icon

Optional

  1. Albright & Winston (2005) Chapter 1, 2.
  2. Weimer & Vining (2010) Chapter 14, 15 or Dunn (2012) Chapter 1, 2.
  3. Boardman, Greenberg, Vining, and Weimer (2011) 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.

Bivariate Normal Distribution

Week 2: Policy Modeling (04/14)

Readings

  1. Introduction to policy modeling PDF icon

Bivariate Normal Distribution

Week 3: Basics of Linear Programming (04/21)

Readings

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

Options

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

Lab: Using Excel Solver 1

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

Bivariate Normal Distribution

Week 4: Formulating Linear Programming (04/28)

Readings

  1. H&H (2019) Chapter 5 (5.1 and 5.2). PDF icon
  2. Lecture Note PDF icon Slide Powerpoint icon Product Mix Example Excel icon
  3. Simplex Method Powerpoint icon Illustration Excel icon

Lab: Using Excel Solver 2

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

Bivariate Normal Distribution

Week 5: Sensitivity Analysis (05/5)

Readings

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

Options

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

Bivariate Normal Distribution

Week 6: Linear Programming Applications (05/12)

Readings

  1. H&H (2019) Chapter 3. PDF icon
  2. Slide Powerpoint icon Degeneracy Excel icon LP Variants Excel icon

Optional

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

Bivariate Normal Distribution

Week 7: Queueing Model I (05/19)

Readings

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

Options

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

Bivariate Normal Distribution

Week 8: Queueing Model II (05/26)

Readings

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

Options

  1. Hillier & Lieberman (2010) 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) PDF icon

Final exam (June 9 in week 11)

Bivariate Normal Distribution

POLICY MODELING JOURNALS