Schedule - Fall 2014

BA 302 Applied Quantitative Management Techniques

 

Stout home    BA 302 home    Syllabus     Lecture notes   Schedule

 

Class Date In class actions Class preparation Homework due today
1 25 Aug 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)

Establish criteria for weekly schedule

Review syllabus  

2

27 Aug Begin chapter 1

Problem solving versus decision- making
Basic modeling types
Quantitative methods in practice

Excel charts

Read chapter 1, section 1.1-1.2, 1.5

Read chapter 1, section 1.3
Consider the linked problem solving scenario.

Complete Excel 2007 chart demo or "How to Create a Basic Chart in Excel 2010"

Submit an Excel spreadsheet showing your weekly schedule. Highlight your BA302 study times.

  

3 29 Aug Begin Excel tutorial:

Focus on absolute/relative address, data tables, basic functions, TVM functions, and IF and LOOKUP functions

Read and review Appendix A

Download, review, and practice 
Excel tutorial contents.
Submit Excel Chart Exercise #1

 

  1 Sep Labor Day    
4 3 Sep

Continue Excel tutorial

•   = IF, AND, OR
•   = SUM; SUMIF
•   = VLOOKUP, HLOOKUP, LOOKUP
•   = COUNT, COUNTA, COUNTIF
•   = Time value of money functions -PMT

Download and review MS Office 2007 tutorial. Up to Speed with Excel 2007.


 

Excel Car Loan Practical Exercise #1
5 5 Sep

Begin exercise #2 - additional functions:

Format controls

•   = IF, AND, OR
•   = SUM; SUMIF
•   = VLOOKUP, HLOOKUP, LOOKUP
•   = COUNT, COUNTA, COUNTIF
•   = Time value of money functions -PMT

Data analysis and presentation

Begin work on Ch 1 Excel #1 (download CustomerArrivals data from web)

   
6 8 Sep

Modeling cost, revenue, and profit

Breakeven analysis - appendix 1.2 and Appendix A

•  Using Data Table
•  Using Goal Seek

Alt-PrtScn 

"Nowlin Plastics"

Read chapter 1, sections 1.4 and Appendix 1.1, and Appendix A pp. 783-790

Excel Car Loan Practical Exercise #2
Ch 1 Excel #1 Bank Customer Arrival charts
7 10 Sep Excel printing suggestions
Student exercise: Solve problem Ch 1-14 (a through d) with Excel (use the "What If" commands - "Goal Seek" or "Data Table," to aid in finding your solution)

Data table quiz

Find instructions for Goal Seek in the appendix to chapter 1 of your textbook. Find instructions for Data Tables in the Excel Tutorial on page 23. Complete and submit "O'Neill Shoes", 12c, breakeven problem. Solve for the breakeven volume using two methods - goal seek and data tables. Print values view and formula views. Print the goal seek dialog box. Print the table command dialog box.

 

8 12 Sep

Spreadsheet engineering

 

(GreatThreads problem statement and data)

(Consider GreatThreads as spreadsheet model).
 

Read “practical management science handout” and  “modeling tips” appendix

Problem 1-14 (Answer 1-14 a, b, c, and d) Print Goal Seek dialog box.
9 15 Sep

Probability review

1.  Experiments and the sample space
Do 2.1 a, b in class

2.  Assigning probabilities
Do problem 2.2 in class

3.  Basic probability relationships

Read chapter 2, sections 2.1, 2.2, 2.4 Submit a Great Threads problem design. Submit both your completed spreadsheet AND your handwritten, plain paper design. Use criteria from our spreadsheet engineering discussion to inform your design and physical layout.
10 17 Sep

Bayes theorem and probability trees
•     Class exercise
Bayes

Read chapter 2, section 2.5 Problem: 2-4, 2-6, 2-10, 2-17
12 19  Sep

Discrete probability distributions

In class exercises 3.1, 3.2, 3.3
Uniform distribution

 

Read chapter 3, sections 3.1-3.4 Problem: 2-25
13 22 Sep

Discrete continued -
Binomial distribution
Excel Ch 3 #1

Skill check
Poisson distribution

Read chapter 3, sections 3.5-3.7

Problems: 3-4 (use Excel), 3-5 (by hand or Excel) , 3-7 (use Excel)

14 24 Sep

Continuous probability distributions

Normal distribution

Exponential distribution

Review central limit theorem

Read Appendix 3.1 and Appendix 3.2

Problems: Do problem 3-11 in Excel. Problem 3-13 (part "a" by Excel, "b" solve by tree;  part "c" solve using  Excel.) Print "Function Argument" dialog boxes.
15 26 Sep

Normal distribution

Exponential distribution

Review Appendix 3.1 and Appendix 3.2 Problems: 3-26, 3-28

16

29 Sep

Decision analysis – problem formulation

Influence diagrams

Payoff tables
Decision trees
Decision making without probabilities

Read chapter 4, section 4.1, 4.2
 

 

 

 

17 1 Oct

Decision making with probabilities

Risk analysis

Sensitivity analysis

Read chapter 4, section 4.3 and 4.4 Problem: 4-2 (do this problem in Excel; have your spreadsheet identify the correct decision by incorporating an IF statement as shown in class.)
18 3 Oct

Decision analysis with sample information

Decision trees - Discuss decision tree construction

Exam review

Read chapter 4, section 4.5
Complete
PrecisionTree tutorial

Problem: 4-9 (add part f, construct a risk profile using part c probabilities)

Problem: Excel Ch 4 #1 (For the online problem, use Excel functions to determine and identify the correct decision, i.e. MIN, MAX, IF)

19

6 Oct Exam 1 - Part 1 Review Excel tutorial, appendix A, and chapters 1, 2, 3, 4 Problem: 4-14

20

8 Oct Exam 1 - Part 2 Review Excel tutorial, appendix A, and chapters 1, 2, 3, 4  

21

10 Oct

Review exam 1

Forecasting overview
Moving averages
Exponential smoothing

Read chapter 6, introduction and sections 6.1, 6.2, and
 
 
  13-14 Oct Fall Break    
22

15 Oct

 

Linear trend Read chapter 6, section 6.3

Review Clemson tutorial

Problem: 6-6,

23 17 Oct Causal forecasting
MSE and Solver
Read chapter 6, and appendix 6 Problems: 6-7 (Excel), 6-8 (Excel)
24 20 Oct Seasonal decomposition Read chapter 6 Problems: 6-17, 6-21 . Redo problems 6-6e and 6-8c using Solver to find the best weights and alpha value for reducing MSE. Print your Solver dialog box!
25 22 Oct Linear programming introduction

Lego production problem
Problem formulation
Linear programming – graphical solution
In class – 7.1, 7.2, 7.3
Read chapter 7, section 7.1
Read chapter 7, appendix 7.1
Do problem 6-24
See chapter 6 appendix for help.
Problem: 6-27 (Download linked data)
26 24 Oct Linear programming – spreadsheet solution using Excel Solver (Lego and RMC p. 236) Read chapter 7, section 7.2, 7.3, and Appendix 7.1 Problem: 7-12 (corner point method) Use green engineering graph paper.

 

27 27 Oct Linear programming - word problems - set up and solve 7-14
Linear programming – minimization and special cases
Linear programming – sensitivity analysis
Read chapter 7, section 7.5, 7.6
Read chapter 8, section 8.1 and Appendix 8.1
Problem: 7-12 (Use Excel Solver)
Problem: RMC problem (Use Excel Solver - p. 250)
28 29 Oct Linear programming – applications

Make or buy:  Reiff Mfg problem

Linear programming – applications (continued)

Scan chapter 9, sections 9.1, 9.2, 9.3, 9.4, 9.5, 9.6

Identify objective functions, decision variables, and common constraints for the various application types.

Problem: 7-33 a, b (do not do part c; solve graphically using corner point method on green engineering graph paper)
Problem: Minimization problem M&D Chemicals,  p.267-p.271. Solve using Excel Solver. Print "
Solver Parameter" dialog box.
Problem: 7-24 a,c,d,e (don't do part b) (solve with Excel)

 

29 31 Oct

Project scheduling – known activity times

In class exercise 13-3, 13-4

 

Read chapter 13, section 13.1

Scan MS Project tutorial

"Lego revisited" - rerun Lego using Excel Solver; produce a "sensitivity analysis" report; interpret and describe your sensitivity analysis results in narrative.

Problem: Solve "Reiff Manufacturing" make or buy problem using Excel. Allocate one column per decision variable. Print values. Print formulas. Print SOLVER dialog box showing target cells, changing cells, and constraints.

30 3 Nov Project scheduling – PERT

Project scheduling – time/cost tradeoffs

Project scheduling – MS Project solutions
MS Project features
Exam review

Read chapter 13, section 13.3

 

Problem 13-7

Wait on doing problem 13-10; we will complete problem 13-10 in class today.

31 5 Nov Exam 2    
32 7 Nov Exam 2 Practical
   
33 10 Nov Waiting line models
Read chapter 15, section 15.1, 15.2, 15.5 Do in class today:
Problems: 15-1, 15-2, 15-3
34 12 Nov Simulation Read chapter 16, section 16.1 Problem 15-7
35 14 Nov Simulation- modeling variates
  Simulation startup exercise
36 17 Nov Simulation - inventory   Problem: PortaCom simulation - do 100 replications. Find the average profit. Find the percentage of times PortaCom suffers a loss.
37 19 Nov Simulation - Batch plant exercise handout, introduction, data assignments   Problem 16-17
38 21 Nov Simulation - batch plant exercise    
39 24 Nov Simulation - batch plant exercise    
40 26 Nov Simulation - batch plant exercise    
  27-28 Nov Thanksgiving (holiday)    
40 1 Dec Simulation - batch plant exercise presentations   Submit and present batch plant simulation results
41 3 Dec Simulation wrap-up
Final exam review
Complete course evaluation forms
  Submit typewritten list of changes you would make to your batch plant operations as a consequence of your simulation results.
42  8-11 Dec Final exams