The course will provide an introduction to modeling, analyzing and solving business decision problems under certainty and uncertainty. By developing good modeling skills, students will be able to solve and develop managerial insight, in a variety of common and not so common problems in today’s business environment. The course also develops concepts of uncertainty, probability and simulation which are the foundation of many business problems. Microsoft Excel will be used to model and solve many of these problems.
- Introduction to modelling - steps of modelling process
- Introduction to decision making under certainty
- Optimization, sensitivity analysis
- Introduction to linear models and linear programming, product mix model, advertising model, production process model, work schedule model
- Multi-period production model, transportation model, assignment model
- Introduction to probability, Bayes’ Theorem
- Probability distribution and decision analysis, payoff table and decision tree
- Planning a decision strategy.
Methods of Instruction
Lectures and seminars.
Means of Assessment
|Term Examinations (2-3)
||40% - 50%
|Computer Lab Test
|| 5% - 10%
||10% - 20%
To pass the course it is necessary to achieve at least 50% on the final exam and achieve at least 50% on the combined average of all tests and examinations.
At the end of the course, the successful student should be able to:
- Understand solving problems and decision making using quantitative analysis.
- Understand the process of modelling (Cost, Revenue and Profit Models).
- Understand decision making under certainty (Optimization, Sensitivity Analysis).
- Understand computer-based systems to help with quantitative analysis and design models for business use.
- Understand developing Excel-based models for problem solving.
- Understand linear models and linear programming (product mix model, advertising model, production process model, work schedule model) using optimization functions such as Excel Solver, LINDO Systems.
- Understand multi-period production model, transportation model, assignment model.
- Understand probability, and Bayes’ Theorem.
- Understand probability distribution and decision analysis.
- Understand structuring the decision problem with payoff table and decision tree.
- Understand making decisions under certainty and uncertainty.
- Understand decision strategy.
- Understand carrying out sensitivity analysis.
Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester/year of the course, consider the previous version as the applicable version.
Below shows how this course and its credits transfer within the BC transfer system.
A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.
For more information on transfer visit the BC Transfer Guide and BCCAT websites.
If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.