Jump to content

Course:FRE585/Syllabus

From UBC Wiki
FRE 585: Quantitative Methods for Business and Resource Management
FRE 585
Section:
Instructor: Dr. Michael Johnson
Xiao Han (CA, before reading break)
Dr. Juan Fercovic (CA, after reading break)
Email: mjohnson@mail.ubc.ca
Office: ORCH 1001 or MCML 352
Office Hours: Thu, 1 hour after class
Class Schedule: Jan 5 – Apr 8, 2027
Tue/Thu 4:00 – 5:30 pm
Classroom: ORCH 1001
Important Course Pages
Syllabus
Lecture Notes
Assignments
Course Discussion


FRE 585 – Quantitative Methods for Business and Resource Management
2026/2027 – Term 2

Land Acknowledgement

UBC's Point Grey Campus is located on the traditional, ancestral, and unceded territory of the xʷməθkʷəy̓əm (Musqueam) people. The land it is situated on has always been a place of learning for the Musqueam people, who for millennia have passed on their culture, history, and traditions from one generation to the next on this site.

Welcome to FRE 585 and Course Description

This course provides the necessary foundation and experience for students to apply a variety of modelling and analytic techniques to business and resource management problems. The class concentrates on frequently used quantitative and decision-making models, including decision analysis, resource allocation models, optimization such as linear programming (allocation and scheduling of resources), forecasting and predictive analytics, simulation modelling, 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 and R to solve a broad range of analytics problems. We will also explore the use of Tableau Desktop for visual analytics and storytelling.

Course Details

Lectures Tuesdays and Thursdays, 4:00 – 5:30 pm, ORCH 1001
January 5 – April 8, 2027 (first class: Tuesday, January 5)
Online Course website: Canvas

Instructor and Course Assistants

Role Name Email Office Hours
Instructor Michael Johnson mjohnson@mail.ubc.ca 1 hour following class on Thursdays (ORCH 1001 or MCML 352)
Course Assistant (before reading break) Xiao Han xiao.han@ubc.ca Posted in Canvas
Course Assistant (after reading break) Dr. Juan Fercovic juan.fercovic@ubc.ca Posted in Canvas

Learning Outcomes

Upon successful completion of the course, students will be able to:

  • Apply analytical techniques to develop business intelligence insights and present them in a compelling way to enable smart and sustainable business decisions.
  • Build and evaluate a decision model in Excel to determine an optimal decision alternative using mathematical expectation, risk, opportunity loss and the value of perfect information. Apply critical thinking and judgement in the context of data and analytic interpretations.
  • Apply Monte Carlo simulations to financial and resource problems to understand decision making under varying degrees of risk and uncertainty.
  • Evaluate multi-stage complex decision problems using decision trees. Apply Bayesian analysis to revise uncertainties to make better decisions.
  • Use predictive analytics and forecasting tools on data that exhibits stationary, trend and seasonal characteristics. Evaluate predictions using standard forecasting metrics and validity techniques. Select the appropriate predictive tool for "real" forecasting.
  • Create conceptual formulations of linear optimization problems with continuous decision variables. Develop and solve optimization models using both graphical methods and Excel's Solver add-in.
  • Perform sensitivity analysis and make managerial interpretations after obtaining optimal solutions.
  • Model the traditional costs of managing inventory decisions under a variety of contexts (e.g., perishable food inventories) and their relationship with supply chain management.
  • Communicate findings within individual and team-based environments using visualization and storytelling techniques.

Real-World Applications in Climate, Food & Environment

  • How can data analytic methods (decision analytics, predictive analytics, or prescriptive analytics) be used to understand the trade-off between economic and environmental decision-making?
  • How do we translate a real business or resource-management problem into a decision model, evaluate alternatives, and communicate the results so leaders can confidently act on the recommendations?
  • How can analytical models help with the planning of food production in order to reduce food waste?
  • How can organizations use data-driven models to make better decisions about resource use, risk, sustainability, and operational performance?

Course Resources: Software, Textbook and Calculator

Course Software: Microsoft Excel, Tableau Desktop and R

  • Microsoft 365 (Excel, PowerPoint, Word, etc.) is available free for UBC students. Mac users: please update to Microsoft 365 so that Excel add-ins work like they do on PCs. Sign up for Microsoft 365
  • Tableau Desktop: sign up for your free student copy at tableau.com/academic/students. Click "Get Tableau Desktop for Free" and complete the form using your UBC email; an activation code should arrive within 48 hours. You will be expected to use Tableau Desktop in your team-based assignment. Please sign up today!
  • R and RStudio: some R will be taught in this course. Please download and install the most recent versions of R and then RStudio.

Textbook

No official textbook is required. Chapters from various textbooks will be provided under the Fair Dealing Exception.

Required Calculator

Any scientific calculator that can perform 2-variable statistics. The Sharp EL-531 will be used during lectures to demonstrate simple linear regression. Programmable calculators are not allowed during examinations.

Learning Management System and Communication

  • Canvas will be used for all course content delivery.
  • Canvas notifications and student email addresses will be used for communicating information and distributing class materials. It is your responsibility to set up your Canvas settings so that you automatically receive notifications at your UBC email address.
  • Please check your UBC email and the course website frequently.

Communication and extra help: The best way to get extra help is by attending class and office hours. For content questions (e.g., problem sets, assignments, exam prep), please use the dedicated office hours of the TA and instructor. For course administration questions, please contact Mike directly.

Assessments

Assessment Weight
Individual Assignments (2) 10%
Participation & TBL Activities 3%
Team-Based Assignment* 12%
Midterm** 35%
Final Exam** 40%
Total 100%

* Details to be announced.
** FRE 385 and FRE 585 will have different exams.

Team-Based Learning (TBL) and Team-Based Assignment (4 students)

The course is conducted in a Team-Based Learning (TBL) format to develop your leadership and team-building skills while enhancing your learning beyond individual study. Please form a 4-student team by the end of Week 2. Once you have agreed to work together, form your team in Canvas (People → Assignment #2 – Team #). Anyone not in a team by the end of Week 2 will be assigned to one. Further details will be provided in class.

Assignments

Late submissions will be accepted up to 24 hours late but will be heavily penalized; assignments submitted after that will not be graded. Assignments must be done individually unless otherwise specified. Discussion and collaboration among students is strongly encouraged, but on individual assignments each student must build their own computer file and submit their own original work. Identical submissions are a form of academic dishonesty, will immediately receive a mark of zero, and may affect your academic record.

Present your assignments with the same quality you would use for business correspondence to a customer or your boss. The neatness and quality of your submission will contribute to your marks.

Exams: Midterm and Final Exam

  • No makeup exams. If you miss an exam, you will receive zero marks. Exceptions may be considered for documented medical reasons from UBC Health Services or extenuating circumstances. In such cases, the student must inform the instructor immediately (not after the exam has taken place). Notification after the exam date is not acceptable and will result in a grade of zero.
  • All exams are closed-book: you may not use your textbook or notes. Formulas will be provided on the front page of the exam.
  • UBC student photo ID is required to write any exam. Bring your UBC student card and one other piece of photo ID to all exams.

Course Schedule and Topics

Tentative schedule only – the schedule/content may be slightly modified at the instructor's discretion.

Week Date Topic Text Reference
1 Tue, Jan 5 Introduction to the course (model building). Decision analytics: decision criteria; Maximax, Maximin, EMV, EOL, Minimax Regret. Ragsdale: Ch. 15.1 – 15.9
2 Tue, Jan 12 Decision analytics: EVPI, decision trees, complex decision trees and building using TreePlan. Teams formed by end of week. 15.10 – 15.12
3 Tue, Jan 19 Decision analytics: complex decision trees continued, sensitivity analysis (data tables). Bayes' theorem and applications. Monte Carlo simulation and AHP. 15.13, 15.14, 15.16 – 15.18
4 Tue, Jan 26 Introduction to predictive analytics/forecasting: components of time series analysis. Forecasting game. Handout
5 Tue, Feb 2 Predictive analytics/forecasting: SES/MA models for stationary data; error metrics; trend models (SLR, Holt's). Handout
6 Tue, Feb 9 Predictive analytics/forecasting: trend and seasonality; Holt-Winters; modelling in Excel and R.
– Feb 15–19 Reading Break – no classes
7 Tue, Feb 23 An introduction to visual analytics and Tableau Desktop. Team exercise/assignment posted. Ch. 1 and 2
7 Thu, Feb 25 Midterm Exam – during class (2 hours)
8 Tue, Mar 2 Prescriptive analytics (resource allocation models): introduction, linear programming concepts; formulation of a 2-variable problem; graphical solution.
9 Tue, Mar 9 Prescriptive analytics: complete introductory material (graphical analysis). Special LP conditions. Applications: transportation network models; food processing and distribution; team-based exercise on modelling coal resource allocation. Ch. 1 and 2
10 Tue, Mar 16 Prescriptive analytics: modelling using Excel; formulation of multi-variable LP applications. Computer solutions. Interpretation of business results from computer output (sensitivity analysis and its relationship to graphical solutions). LP extensions: assignment, network, integer models and nonlinear programming. Complete Ch. 3 and 4
11 Tue, Mar 23 Inventory and supply chain management: basic inventory models (EOQ, cost trade-offs, reorder points, quantity discount models). Inventory and probabilistic models; reorder point with probabilistic demand; newsvendor model. Handout: Inventory Control Models
12 Tue, Mar 30 Simulation game: supply chain management. Team-based assignment – sharing and learning session. Handout
13 Tue, Apr 6 Course wrap-up. Handout
– TBA Final Exam – date TBA

Course Policies

AI Policy

AI tools may be used for checking spelling, grammar, and punctuation without disclosure. For brainstorming, sourcing, summarizing, coding development or citation generation, disclosure is required. Using AI to complete or write assignments or exams is prohibited and considered academic misconduct.

Category Description Action Required
Allowed Use AI tools for checking spelling, grammar, and punctuation. Use AI tools to develop a deeper understanding of course content presented in class. No disclosure required.
Disclose Use AI tools for ideation, brainstorming, finding sources, clarifying information, or generating citations. AI tools can also be used to support any R programming in the course, including assignment work. Disclose in a footnote or endnote (if submitting work).
Prohibited Use of AI tools to generate solutions on exams or assignments, or to write up assignments. Not allowed; constitutes academic misconduct.

Reminder: Always verify AI-generated information, as it may be incomplete or inaccurate. Use AI as a reference but confirm details with reliable resources.

Copyright

All learning materials in this course (lecture videos, handouts, slides, assessments, readings, etc.) are the intellectual property of the instructor or licensed for use in this course by the copyright owner. Redistribution by any means without permission of the copyright holder(s) constitutes a breach of copyright, may lead to academic discipline, and could be subject to legal action. Audio or video recording of classes is not permitted without the instructor's prior approval. Any lecture videos and recordings are for the sole use of the instructor and students currently enrolled in this class, and may not be used, in whole or in part, for any other personal or commercial purpose.

You may take notes and make copies of course materials for your own use. You may not reproduce, distribute, or upload lecture notes and course materials publicly (or allow others to do so), whether or not a fee is charged, without the instructor's express written consent. Similarly, you own copyright in your original papers and essays; if the instructor wishes to post your answers or papers on the course website, your written permission will be requested.

MFRE Program – Course Protocol Policies

Working with Others on an Assignment

You are encouraged to work with other students, but you must turn in your own individual assignment. If your answer is too close to another student's answer, this will be considered academic dishonesty and handled according to MFRE and UBC policies.

Recordings

There is no required distribution of class recordings. Recordings will be provided at the discretion of the course instructor. Classes are designed and intended to be in person.

Missing Classes/Labs

Students are expected to attend all classes, labs, and workshops. If you cannot attend due to a medical or personal emergency, email your instructor, your Course Assistant, and Olivier Ntwali, MFRE Program Coordinator, ahead of time.

Respectfulness in the Classroom

Students are expected to be respectful of their colleagues at all times, including faculty, staff, and peers. This means being attentive to words and actions and their impact on others, listening with an open mind, treating all MFRE community members equally, and understanding diversity.

Respect for Equity, Diversity, and Inclusion

The MFRE Program strives to promote an intellectual community enhanced by diversity along various dimensions, including status as a First Nation, Métis, Inuit, or Indigenous person, race, ethnicity, gender identity, sexual orientation, religion, political beliefs, social class, and/or disability. All students and members of our community are expected to conduct themselves with empathy and respect for others.

Centre for Accessibility

The Centre for Accessibility (CfA) facilitates disability-related accommodations and programming initiatives designed to remove barriers for students with disabilities and ongoing medical conditions. If you are registered with the CfA and eligible for exam accommodations, it is your responsibility to inform Olivier Ntwali, Academic Program Coordinator, and each of your course instructors. Book your exam writing with the CfA through its exam reservation system: at least 7 days in advance for midterm exams or quizzes, and 7 days before the start of the formal exam period for final exams.

Academic Honesty

Academic dishonesty and plagiarism are taken very seriously at UBC and in the MFRE program. All incidents of plagiarism will be escalated to the MFRE Academic Director, with penalties ranging from a mark of zero on the assignment, exam, or course to being required to withdraw from the program. It is each student's responsibility to review and understand what constitutes academic dishonesty and plagiarism and how to avoid them.

Academic misconduct subject to disciplinary measures includes, but is not limited to:

  • Plagiarism – intellectual theft, where an individual submits or presents the oral or written work of another person as their own. Correct citations must be provided where applicable for all reports/assignments. In all MFRE courses, material will be submitted to TurnItIn, a UBC-subscribed service that checks textual material for originality.
  • Using AI tools where prohibited – see the AI Policy above. Using Generative AI tools (ChatGPT, Claude, Gemini, etc.) to generate content or conduct analysis for evaluations without proper citation, or when asked not to use AI, is considered plagiarism and academic misconduct.
  • Cheating – including, but not limited to, falsification of any material subject to academic evaluation, unauthorized collaborative work, or use of unauthorized means to complete an examination.
  • Submitting others' work as your own – including (i) using, or attempting to use, another student's answers; (ii) providing answers to other students; (iii) failing to take reasonable measures to protect answers from use by other students; or (iv) for students who study together, submitting identical or virtually identical assignments unless permitted by the instructor.
  • Resubmission of material – submitting the same, or substantially the same, essay, presentation, or assignment more than once (whether the earlier submission was at this or another institution) without prior approval from the instructor(s) to whom it is to be submitted.
  • Use of academic ghostwriting services – including hiring writing or research services and submitting papers or assignments as one's own.

Student Responsibility: Students are responsible for informing themselves of the guidelines for acceptable and unacceptable conduct for examinations and graded assignments, as presented in the MFRE Code of Conduct, MFRE TurnItIn guidance, the course syllabus, MFRE instructors, Canvas, and UBC academic misconduct policies.

Penalties for Academic Dishonesty: Penalties are applied at the discretion of the course instructor and the MFRE program. Academic misconduct may result in a reduction of grade or a mark of zero on the assignment, examination, or course; required withdrawal from the program; and/or referral to UBC Graduate Studies, the Dean's office and/or the President's Advisory Committee on Student Discipline. Note: if a student needs to extend their program due to a failed course or unsatisfactory progress, they will have to pay full MFRE tuition fees for that term(s).