BSAD 30, Fall 2018

TENTATIVE Lecture Schedule

(subject to minor changes)

Last Day to Drop – Monday, 9/10

Last Day to Withdraw – Monday, 10/29

Date / Topic / Discussion / Reading and important links (read and view BEFORE class) / HW Assignments
(Cengage Now site)
8/28, T /
  1. Introduction to course (ppt, pdf): discussion of objectives, course admin, syllabus, and schedule
/ Cengage online Tech Support for BSAD 30
Installing the Data Analysis Toolpak(we are using Excel 2013 add-ins extensively in this class)
If you are a MAC user and do not have Excel 2016 installed, you should see Matt Parisi in 227 Kalkin / To purchase course material:
Book + CNOW access
After purchasing the course material, use your CNow code and register for the correct section:
Section A (11:40 – 12:55)
Section B (1:15 – 2:30)
8/30, TH /
  1. Lecture 1(ppt, pdf): Overview ofProblem Solving and Decision Making
/ Chap 1 (2-16)
9/4, T /

3. Lecture 2(ppt,pdf):Introduction to probabilities

/ Chap 2 (25-49)
9/6, TH /

4. Lecture 3(ppt,pdf):Probability distributions (discrete)

/ Chap 3 (62-75) 3.1 – 3.4 / Due at 11:30 AM
HW 1 (Chap 1 & 2)
9/11, T /

5. Lecture 4(ppt,pdf):Probability distributions (continuous)

/ Chap 3 (76-92) 3.5 – 3.7 / Practice quiz 1
9/13, TH /

6. Lecture 5(ppt,pdf):Decision analysis (with and without probabilities)

/ Chap 4 (104-121) 4.1 – 4.4 / Due at 11:30 AM
HW 2 (Chap 3)
Practice quiz 2
9/18, T /

7. Lecture 6 (pdf):Review and summary

/ Due at 11:30 AM
HW 3 (Chap 4)
9/20, TH / 8. In-class test #1 / Study Guide / Formula Sheet
Standard Normal Table
9/25, T / 9.Lecture 7(ppt, pdf): Introduction to linear programming (LP) (formulate a basic maximization LP and solve graphically) / Chap 7 (250-271) 7.1 - 7.4
Excel template for maximization example / Review math concepts
Inequalities help at Khan Academy
9/27, TH / 10.Lecture 8(ppt, pdf): LP minimization problem (formulate problem + graphical solution)Introduction to concepts of slack and surplus / Chap 7 (271-276) 7.5
Excel template for minimization example
10/2, T / 11. Lecture 9(ppt, pdf): Introduction to sensitivity analysis and alternative optimal solutions, unbounded solutions, infeasible solutions
A LAPTOP IS RECOMMENDED FOR THIS CLASS / Chap 7 (276-282) 7.6-7.7
Chap 8 (309-323) 8.1-8.4
Excel template for in-class example / Due at 11:30 AM
HW 4 (Chap 7)
10/4, TH / 12.Lecture 10(): LP sensitivity analysis continued
Interpretation of shadow prices
A LAPTOP IS RECOMMENDEDFOR THIS CLASS / Chap 8 (309-323) 8.1-8.4
In-class-LP exercise solutions
10/9, T / 13. Lecture 11(handout): In class LP exercise: set up problem, graph, and solve using Solver
A LAPTOP IS REQUIRED FOR THIS CLASS / Excel File for demonstration (Solver template)
10/11, TH / 14. Lecture 12 (): LP applications
A LAPTOP IS REQUIRED FOR THIS CLASS / Chap 8 (323-335) 8.5–8.6
Excel File for demonstration (Solver template) / Due at 11:30 AM
HW 5 (Chap 7 & 8)
10/16, T / 15. Lecture 13 (): LP applications
A LAPTOP IS REQUIRED FOR THIS CLASS
10/18, TH / 16. Test #2 in-class / Test Review
10/23, T / 17. Lecture 14():Transportation and supply chain problem
A LAPTOP IS REQUIREDFOR THIS CLASS / Chap 10 (425-438) 10.1
Excel File for demonstration (Solver template)
10/25, TH / 18. Lecture 15():Assignment problem, Shortest-route problem, and maximal flow problem
A LAPTOP IS REQUIREDFOR THIS CLASS / Chap 10 (440-443) 10.2
Chap 10 (445-448) 10.3
Excel File for demonstration (Solver template)
10/30, T / 19. Lecture 16():LP applications
A LAPTOP IS REQUIREDFOR THIS CLASS / Chap 10 / Due at 11:30 AM
HW 6 (Chap 10)
11/1, TH / 20. Lecture 17():PERT/CPM / Chap 13 (593-601) 13.1
11/6, T / 21.No Class – I will be out of town at a conference
11/8, TH / 22.Lecture 18():PERT/CPM – addressing uncertainty / Chap 13 (602-611) 13.2
11/13, T / 23. Lecture 19():Review for test / Due at 11:30 AM
HW 7 (Chap 13)
11/15, TH / 24. In-class Test #3 / Test Review
11/19-11/23 / No Class – Thanksgiving Break
11/27, T /

27. Lecture 20():Simple linear regression

A LAPTOP IS REQUIRED FOR THIS CLASS / Material is NOT in book
Excel File for demonstration
11/29, TH /

28. Lecture 21():Multiple linear regression

A LAPTOP IS REQUIRED FOR THIS CLASS / Material is NOT in book
Excel File for demonstration
12/4, T / 29. Lecture 22():Time series analysis and forecasting (moving average and weighted moving average) / Chap 6 (196-211) 6.1-6.2
Excel File for demonstration
12/6, TH / 29. Lecture 23():Time series analysis and forecasting (exponential smoothing and seasonality with trends) / Chap 6 (211-230) 6.3-6.5
Excel File for demonstration / Due Friday, 12/7 by 11PM
HW 8 (Chap 6)
Comprehensive Final Exam (in-class)
  • Please keep in mind that I cannot reschedule exams for any reason other than UVM approved policies!
Please plan travel accordingly / Section A: In-class in Kalkin 325on Thursday, 12/13 from
1:30 – 4:15PM
Section B: In-class in Kalkin 004on Friday, 12/14 from
10:30 AM – 1:15 PM / Final Exam Review Guide
Formula Sheet
Z-table (standard normal)