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? Decisionmaking 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 Excel charts 
Read chapter 1, section 1.11.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 
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 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 AltPrtScn "Nowlin Plastics" 
Read chapter 1, sections 1.4 and Appendix 1.1, and Appendix A pp. 783790 
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 114 (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

(Consider
GreatThreads as spreadsheet model). Read practical management science handout and modeling tips appendix 
Problem 114 (Answer 114 a, b, c, and d) Print Goal Seek dialog box. 
9  15 Sep 
Probability review 1. Experiments and the
sample space 2. Assigning
probabilities 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 
Read chapter 2, section 2.5  Problem: 24, 26, 210, 217 
12  19 Sep 
Discrete probability distributions In class exercises 3.1,
3.2, 3.3

Read chapter 3, sections 3.13.4  Problem: 225 
13  22 Sep 
Discrete continued 
Skill check

Read chapter 3, sections 3.53.7 
Problems: 34 (use Excel), 35 (by hand or Excel) , 37 (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 311 in Excel. Problem 313 (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: 326, 328 
16 
29 Sep 
Decision analysis problem formulation Influence diagrams Payoff tables 
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: 42 (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 
Problem: 49 (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: 414 
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 
Read chapter 6,
introduction and sections 6.1, 6.2, and 

1314 Oct  Fall Break  
22 
15 Oct

Linear trend  Read chapter 6,
section 6.3 Review Clemson tutorial 
Problem: 66, 
23  17 Oct 
Causal forecasting MSE and Solver 
Read chapter 6, and appendix 6  Problems: 67 (Excel), 68 (Excel) 
24  20 Oct  Seasonal decomposition  Read chapter 6 
Problems: 617, 621 . Redo problems 66e and 68c 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 624 See chapter 6 appendix for help. Problem: 627 (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: 712
(corner point method) Use green engineering graph paper.

27  27 Oct 
Linear programming  word problems  set up and
solve 714 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: 712
(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: 733
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.267p.271. Solve using Excel Solver. Print "Solver Parameter" dialog box. Problem: 724 a,c,d,e (don't do part b) (solve with Excel)

29  31 Oct 
Project scheduling known activity times In class exercise 133, 134

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 
Read chapter 13,
section 13.3

Problem 137 Wait on doing problem 1310; we will complete problem 1310 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: 151, 152, 153 
34  12 Nov  Simulation  Read chapter 16, section 16.1  Problem 157 
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 1617  
38  21 Nov  Simulation  batch plant exercise  
39  24 Nov  Simulation  batch plant exercise  
40  26 Nov  Simulation  batch plant exercise  
2728 Nov  Thanksgiving (holiday)  
40  1 Dec  Simulation  batch plant exercise presentations  Submit and present batch plant simulation results  
41  3 Dec  Simulation wrapup 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  811 Dec  Final exams 