From UBC Wiki
Jump to: navigation, search
Quantitative Methods for Business and Resource Management
FRE 585
Instructor: Dr. Michael Johnson
Office: MCML 231
Office Hours: TBA
Class Schedule: Tuesday, Thursday 3:00 - 4:30 PM
Classroom: MCLD242
Important Course Pages
Lecture Notes
Course Discussion

Course Description

This course will provide the necessary foundation and experience for students to apply a variety of modeling and quantitative techniques to business and resource management problems. This class will concentrate on frequently used quantitative and decision making models that include decision analysis, optimization such as linear programming (allocation and scheduling of resources), simulation modeling, operations analysis and inventory management. Upon completing this course, students will be capable of using a powerful set of functions and tools in Microsoft Excel for solving a broad range of quantitative problems.


1. Pre-midterm: On course reserve at Woodwards Library: “Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Management Science”, 6th edition, 2012 by C. Ragsdale. 2. Post-midterm: Selected readings and the “Essentials of Operations Management”, 6th edition, 2010 by Nigel Slack, Alistair Brandon-Jones and Robert Johnston.

Required Calculator:

Any scientific calculator. Programmable calculators are not allowed during examinations.


Attendance is mandatory at ALL classes. The course will be conducted using a Team-Based Learning (TBL) format, to develop both your leadership and team-building skills, while enhancing your learning beyond individual study. Missing class will be detrimental to your grade.


FRE 385 FRE 585
Individual Assignments 15% 15%
TBL: Individual and Team Tests

TBL: Weekly Team Activities

5% 5%
Participation 10% 10%
Midterm 30% 25%
Final Exam 40% 30%
Individual Project Assignment* 15%
Total: 100% 100%
  • Details to be announced

“Getting to know you” Assignment (385 students Only): Please complete this first Assignment and hand it directly to Mike during our next class. Late assignments will not be accepted (hard copy only - not emailed).


Late submissions will be accepted up to 24 hours late but will be penalized 50%. Any assignment submitted beyond that point will not be graded. Assignments must be done on an individual basis unless otherwise specified by the instructor. Discussion and collaboration among students is strongly encouraged, but on individual assignments, each student must build his or her own computer file and submit his or her own original work. Identical submissions are a form of academic dishonesty and will immediately receive a mark of zero and possibly infringe upon your academic record.

Your assignments should be presented with the same quality as you would a piece of business correspondence to your customer or your boss. The neatness and quality of your submission with contribute to your marks. All assignments must be submitted using the posted title page that can be downloaded from Connect in the “Assignment” folder.

Makeup Exams or Tests:

There will be NO makeup tests, exams or quizzes. If you miss an exam, you will receive zero marks. Exceptions may be considered for documented medical reasons from UBC’s Health Services or extenuating circumstances. In such a case, it is the responsibility of the student to inform the instructor immediately by phone only (not after the exam has taken place). Notification after the examination date is not acceptable and will result with a grade of zero.

All TBL tests (both Individual and team-based tests) and Midterm and Final exams are “closed-book”. That is, you will NOT be allowed to use your textbook or notes. Formulas will be provided on the front page of the exam.

UBC STUDENT PHOTO ID is required in order to write any exam.

Please bring your UBC student card and one other piece of photo ID to all exams.

Topics (Tentative Schedule):

Please note: subject to change at the discretion of instructor

Date Topic Text reference
Week 1 - Jan 4 Introduction to the course (Model Building). Ragsdale: Chapt. 1
Week 2 - Jan 11 Decision Analysis: Excel, Descriptive Stats Review, Maximax, Maximin, EMV, EOL, Minimax Regret, EVPI, Decision Trees. Any Intro Stats text, Ragsdale: Chapt. 14 – sections 14.1 to 14.9
Week 3 - Jan 18 Decision Analysis: Complex Decision Trees, Building Decision Trees in Excel (Treeplan.xla), Sensitivity Analysis (Data Tables) 14.10 to 14.12
Week 4 - Jan 25 Decision Analysis: Bayes Theorem and applications, Multi-criteria decision making, Analytic Hierarchy Process, Monte Carlo Simulation 14.13, 14.14, 14.16 to 14.18. Ragsdale: Chapt 12 – Monte Carlo
Week 5 - Feb 1 Optimization Techniques: Introduction, Linear Programming- concepts; formulation of 2-variable problem; graphical solution; interpretation of graphical results including sensitivity analysis. Ragsdale: Chapt. 2
Week 6 - Feb 8 Optimization continued: Modeling LP using Excel, formulation of multi-variable LP application. Computer solutions. Interpretation of Business results from computer output (sensitivity analysis). Linear Programming extensions: Transportation, assignment, network, integer models. Ragsdale: Chapt. 3 and 4 (possibly materials from Chapters 5, 6 and 7)
Reading Break: Feb 15-19
Week 7 - Feb 22 Midterm Exam (2 hours): Thurs Feb 25th from 3:30 – 5:30pm
Week 8 - Feb 29 Operations Management: Introduction to operations management; Ford; Systems Thinking. Business Process Design and Process mapping. Chapt 1 (Slack), Chapt 4 (Slack) Process Mapping for SOX
Week 9 - Mar 7 Operations analysis applied to service organizations (throughput capacity, demand and process variability, capacity utilization and service time). Simulation: Operations Management Simulation: Benihana V2. HBS case: Benihana of Tokyo (HBS: 9-673-057) 2004
Week 10 - Mar 14 Inventory and Supply Chain Management: Basic inventory models: EOQ, trade-offs between costs; reorder points; quantity discount models. Handout: “Chapter 13 - Inventory Control Models.pdf”
Week 11 - Mar 21 Probabilistic models; reorder point with probabilistic demand, Newsvendor model. Simulation Game: Supply Chain Management Handout
Week 10 - Mar 28 Debrief Simulation Game. Lean Operations. Understanding bottlenecks and Process Flow. Chapt 15 (Slack)
Week 13 - Apr 4 Course Wrap Up.