Course

Introduction to Quantitative Decision Making

Faculty
Commerce & Business Administration
Department
Business
Course code
BUSN 2290
Credits
3.00
Semester length
15 Weeks X 4 Hours Per Week = 60 Hours
Max class size
35
Method(s) of instruction
Lecture
Seminar
Typically offered
To be determined

Overview

Course description
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.
Course content
  1. Introduction to modelling - steps of modelling process
  2. Introduction to decision making under certainty
  3. Optimization, sensitivity analysis
  4. Introduction to linear models and linear programming, product mix model, advertising model, production process model, work schedule model
  5. Multi-period production model, transportation model, assignment model
  6. Introduction to probability, Bayes’ Theorem
  7. Probability distribution and decision analysis, payoff table and decision tree
  8. Planning a decision strategy.
Learning activities

Lectures and seminars.

Means of assessment
Final Exam          30%
Term Examinations (2-3) 40% - 50%
Computer Lab Test  5% - 10%
Assignments 10% - 20%
          100%

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.

Learning outcomes

At the end of the course, the successful student should be able to:

  1. Understand solving problems and decision making using quantitative analysis.
  2. Understand the process of modelling (Cost, Revenue and Profit Models).
  3. Understand decision making under certainty (Optimization, Sensitivity Analysis).
  4. Understand computer-based systems to help with quantitative analysis and design models for business use.
  5. Understand developing Excel-based models for problem solving.
  6. 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.
  7. Understand multi-period production model, transportation model, assignment model.
  8. Understand probability, and Bayes’ Theorem.
  9. Understand probability distribution and decision analysis.
  10. Understand structuring the decision problem with payoff table and decision tree.
  11. Understand making decisions under certainty and uncertainty.
  12. Understand decision strategy.
  13. Understand carrying out sensitivity analysis.
Textbook materials

Textbooks and Materials to be Purchased by Students

Custom Course Publication; Selected chapters from SMA – Spreadsheet Modeling and Applications, Albright and Winston, Thompson Learning Inc, 2005) and Quantitative Methods for Business, Latest edition, Anderson, Sweeney and Williams, Thompson, 2004.

Business Calculator: one of:

  • Texas Instruments BAII+
  • Texas Instruments BA35
  • Hewlett Packard 10B
  • Sharp EL-733a

Requisites

Prerequisites

MATH 1120 or MATH 1125

Corequisites

No corequisite courses.

Equivalencies

No equivalent courses.

Course Guidelines

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.

(Current)

Course Transfers to Other Institutions

Below are current transfer agreements from Douglas College to other institutions for the current course guidelines only. For a full list of transfer details and archived courses, please see the BC Transfer Guide.

Institution Transfer details for BUSN 2290
Coquitlam College (COQU) COQU STAT 290 (3)
Kwantlen Polytechnic University (KPU) No credit
Simon Fraser University (SFU) SFU BUS 2XX (3)
Thompson Rivers University (TRU) TRU BBUS 2XXX (3)
Trinity Western University (TWU) TWU BUSI 2XX (3)
University of British Columbia - Okanagan (UBCO) UBCO MGMT_O 3rd (3)
University of British Columbia - Vancouver (UBCV) DOUG BUSN 2290 (3) & DOUG BUSN 2429 (3) & DOUG BUSN 3431 (3) = UBCV COMM 190 (3) & UBCV COMM 191 (3)
University of British Columbia - Vancouver (UBCV) UBCV COMM_V 2nd (3)
University of British Columbia - Vancouver (UBCV) DOUG BUSN 2290 (3) & DOUG BUSN 2429 (3) & DOUG BUSN 3431 (3) = UBCV COMM_V 190 (3) & UBCV COMM_V 191 (3)
University of Northern BC (UNBC) UNBC COMM 251 (3)
University of the Fraser Valley (UFV) UFV BUS 2XX (3)
University of Victoria (UVIC) UVIC MATH 1XX (1.5)

Course Offerings

There are no course offerings this semester.