Course Schedule - Term II 2009/2010

MBA 605 Advanced Quantitative Methods for Management

Stout home    MBA 605 home   Syllabus    Lecture notes   Schedule

#

Date

Subject

Preparation assignment

Homework due tonight

1

20 Oct

Course introduction

 

How do you make decisions? Decision-making chart

 

Read: "Taco Bell Finds Recipe for Success", OR/MS Today, October 1997  (found in Oct 97 "OR/MS Today" under "Practice Lesson" column)

Download and review Excel tutorial.

Complete Excel tutorial focusing on:

Excel fundamentals

Using absolute/relative address
Useful functions
  IF functions
  LOOKUP functions
  Statistical functions
  Financial functions

Data tables

Complete Up to Speed with Excel 2007

Begin work on Car Loan exercise #1

 Review syllabus  

2

22 Oct

Review Excel exercise 1

 

Data presentation and analysis Reiff Manufacturing

Lookup functions

Begin work on Excel exercise 2; discuss check box, TVM functions, nested functions, and LOOKUP and IF functions.

Review Appendix B, "Useful Excel Commands"
 

Review Excel tutorial

Excel exercise #1

3

27 Oct

Chapter 1 - Introduction to Managerial Decision Making

 

Spreadsheet engineering

 

Breakeven analysis - develop spreadsheet model


In class, do problem 1-19 using Excel - print values view and formulas view. Print gridlines. Print row and column headings. Use "Print Preview" or "Page Layout View" as a quality assurance check. Copy, insert, and show "Goal Seek"  dialog box containing cell references on your submittal.

 Review problem solving processes

Read chapter 1 - review textbook spreadsheet examples and "Goal Seek" command.

Excel exercise #2

Submit problem 1-19 before leaving class tonight

4

29 Oct

 Linear programming introduction
Lego production problem
Problem formulation
Linear programming – graphical solution
Linear programming - spreadsheet solution		 Read chapter 2 Problem: 1-26 Use both Goal Seek and Data Tables to find your solutions. Copy, insert, and print "Goal Seek"  and "Data Table" dialog boxes containing cell references on your spreadsheet.

5

3 Nov

 Linear programming - set up, special situations, answer report
Begin linear programming applications
Manufacturing - Reiff make or buy
Marketing
Finance		 Read chapter 3. Problems: 2-13, 2-18

Solve Lego production problem graphically using the corner point method. Solve the Lego production problem in a spreadsheet using Solver (print values and formula views).

6

 5 Nov

Continue linear programming applications
Staffing
Transportation
Blending
Linear programming - sensitivity analysis
 Sensitivity analysis using graphs
Integer programming

 Read chapter 4.
Read chapter 5
Scan chapter 6		 Problems: Problems: 3-1, 3-8

7

10 Nov

Exam 1 - Excel fundamentals, data gathering, decision-making, linear programming concepts, applications, and sensitivity analysis

 Review chapter 1, appendix B, Excel Tutorial and chapters 2 - 6. Problems: 3-11, 3-16, 3- 3-22
Problems: 4-10
 Problem: 6-13

8

12 Nov

Review exam 1 results
Appendix A - Probability concepts and applications
Fundamental concepts
Random variables
Discrete probability distributions
Build a probability distribution

Binomial distribution

Poisson distribution

Bayes problem		 Review appendix A.
 

9

17 Nov

Continuous probability distributions

Distribution expected value, variance, and standard deviation

Uniform distribution

Normal distribution

Exponential distribution

Excel probability distribution functions
Data gathering - histograms		 Review appendix A  Problems: A-15, A-18, A-23, A-30 (by hand), A-31 (by Excel)

10

19 Nov

 Project management
Network models/CPM/PERT
Microsoft Project		 Read chapter 7. Problems: A-32, A-34, A-39, A-40, A-41, A-42

11

24 Nov

 Decision analysis
Utility theory		 Read chapter 8. Problems: 7-14, 7-17, 7-25, 7-31 (by hand)
12 26 Nov Thanksgiving Holiday    

13

 1 Dec Queuing models and waiting lines
Simulation
Modeling variates		 Read chapter 9.
Read chapter 10.		 Problems: 8-16, 8-17, 8-28

14

3 Dec

 Simulation
Forecasting		   Problems: 9-12, 9-17(a), (b)

15

8 Dec

Forecasting

Regression analysis

 Read chapter 11. Problems: 10-18, 10-35
 

16

10 Dec

 Review homework
Course evals
Final examination		   Problems: 11-15, 11-16
Problems: 11-34, 11-35