A problem-solving course which introduces the student to deterministic and stochastic models which are useful for production planning and operations management in business and government. Note: Students are expected to have basic familiarity with microcomputer applications. Prerequisite: MATH 114 or equivalent and STAT 151 or equivalent.

Business use processes to produce and deliver goods and services to customers. This course is about the conceptual and quantitative analysis of those business processes. The emphasis is on strategic and tactical decision making about operations so as to create competitive advantage for the organization. Possible topics include process mapping, process flow analysis, inventory, and quality. The topics will be illustrated through discussion and analysis of several case studies. The topics and techniques selected for this course are applicable to a wide variety of industries. Prerequisites: MGTSC 312.

Business use processes to produce and deliver goods and services to customers. This course is about the conceptual and quantitative analysis of those business processes. The emphasis is on strategic and tactical decision making about operations so as to create competitive advantage for the organization. Possible topics include process mapping, process flow analysis, inventory, and quality. The topics will be illustrated through discussion and analysis of several case studies. The topics and techniques selected for this course are applicable to a wide variety of industries. Prerequisites: MGTSC 312.

This course applies the techniques developed in MGTSC 467 to a group project. The emphasis in the projects is on quantitative approaches to operational problems. Student groups will be assigned to consulting projects from businesses and other organizations in and near Edmonton. Groups will work on their projects under the supervision of the instructor(s). Prerequisites: MGTSC 467 or consent of Instructor. Not to be taken by students with credit in MGTSC 468.

The course focuses on the strategic role of the supply chain, key drivers of supply chain performance, and analytical methods for supply chain analysis. Possible topics include inventory planning and management, sourcing, transporting, and pricing products, supply chain network design, and coordination and value of information in a supply chain. Prerequisites: MGTSC 312 and OM 352.

Computer modelling of management systems in such functional areas as accounting, finance, marketing and operations. Basic concepts of deterministic and probabilistic (Monte Carlo) simulation and their applications. Microcomputer implementation of case studies using spreadsheets particularly emphasized. Required term project. Prerequisites: MGTSC 312 (or equivalent STAT course), MGTSC 352 or OM 352; and FIN 301 or ACCTG 311. Not to be taken by students with credit in MGTSC 422.

Prescriptive analytics modelling of efficient distribution of goods and services from points of origin to customers. Topics include strategic decisions, such as aggregate distribution plans and warehouse location, as well as operational decisions, such as selection of delivery routes and dispatching. Formulation and solution of models to prescribe optimal decisions using exact and heuristic methods. This course involves extensive computer modelling and heuristic design. Prerequisite: MGTSC 312 and OM 352.

The course focuses on the creation of decision support systems using Microsoft Excel-based spreadsheet models and the associated macro programming language, Visual Basic for Applications (VBA). Students will learn how to create Excel-based applications to aid managers in making decisions based on data and analytics. These applications will have graphical user interfaces, appropriate models in the spreadsheet or in the background, and output reports. Fundamentals of VBA, such as the Excel object model, variables, control logic and loops, subroutines and function subroutines, and user forms will be introduced. Prior programming experience is not assumed. Student projects in this implementation-oriented course will come from different areas such as forecasting, regression, supply chain network design, employee scheduling, and portfolio optimization. Prerequisites: MGTSC 312, MGTSC 352 or OM 352.