Course Schedule - Fall Term II 2008

MBA 605 Advanced Quantitative Methods for Management

Stout home    MBA 605 home   Syllabus    Lecture notes   Schedule

#

Date

Subject

Preparation assignment

Homework due tonight

1

21 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

23 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.

 

Review Excel exercise 1

 

Data presentation and analysis Reiff Manufacturing

 

Complete Excel tutorial

Excel fundamentals

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

Data tables
 

Begin work on Excel exercise 2.

Review Appendix B, "Useful Excel Commands"
 

Review Excel tutorial

 

 

 

 

 


 

 

 

Excel exercise #1

3

28 Oct

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


Chapter 1 - Introduction to Managerial Decision Making

 

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

30 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

4 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

 6 Nov

Continue linear programming applications
Staffing
Transportation
Blending
Linear programming - sensitivity analysis

   Problems: Problems: 3-2, 3-7, 3-9, 3-14

7

11 Nov

Veteran's Day Holiday

Linear programming - sensitivity analysis
Sensitivity analysis using graphs
Linear programming - transportation, assignment, and integer programming problems

 Read chapter 4.
Read chapter 5
Scan chapter 6		  

8

13 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-18, 3-25, 3-33, 4-10

Problems: 4-10, 4-13, 4-20

Problems: 5-12, 5-23

Problems: 6-13

9

18 Nov

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

Binomial distribution

Poisson distribution

Bayes problem		 Review appendix A.
 

10

20 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-14, A-16, A-20, A-30 (by hand), A-31 (by Excel)

Journal article critique due

11

25 Nov

 Project management
Network models/CPM/PERT
Microsoft Project		 Read chapter 7. Problems: A-34, A-35, A-38, A-40, A-41
    Thanksgiving holiday    
12 2 Dec Decision analysis
Utility theory		 Read chapter 8. Problems: 7-13, 7-18, 7-27, 7-30 (by hand)

13

4 Dec

 Queuing models and waiting lines
Simulation		 Read chapter 9.
Read chapter 10.		 Problems: 8-14, 8-15, 8-30

14

9 Dec

Simulation
Forecasting

Regression analysis

 Read chapter 11. Problems: 9-10, 9-12
Problems: 10-17, 10-35

15

11 Dec

Forecasting

Regression analysis

   Problems: 11-13, 11-16, 11-35

16

16 Dec

 Final examination