Section menuClose menu Columbia College

MASTER SYLLABUS

Master Syllabus

Print this Syllabus « Return to Previous Page

Administrative Unit: Business Administration Department
Course Prefix and Number: MGMT 430
Course Title: Management Science
Number of:
Credit Hours 3
Lecture Hours 3
Lab Hours 0
Catalog Description:

Management Science is a discipline that integrates mathematical modeling and quantitative analysis into the managerial decision-making process. A variety of models and approaches are introduced including: linear programming and optimization models (e.g., maximize profit or minimize cost problems, resource-allocation problems), network and transportation models (e.g., shortest route problems, critical path problems), forecasting models, PERT/CPM models (e.g., a model to determine the optimal schedule for a project), simulation models and the use of Crystal Ball, and simple/multiple regression models. Students learn to model problems mathematically and to use spreadsheet packages to solve management science problems. The goal of the course is to provide students with a background in mathematical modeling to augment their problem-solving skills. Prerequisites: MATH 150 or MATH 170; MATH 250.

 
Prerequisite(s) / Corequisite(s):

MATH 150 or MATH 170; Math 250.

 
Course Rotation for Day Program: Offered Spring.
 
Text(s): Most current editions of the following:

Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Management Science
By Radcliff (Southwestern-Cengage Learning)
Recommended
An Introduction to Management Science
By Anderson, Sweeney, Williams, and Martin (Thomson-Southwestern)
Recommended
Practical Management Science
By Winston and Albright (South-Western Cengage)
Recommended
Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets
By Hillier and Hillier (McGraw-Hill Irwin Publishers)
Recommended
Spreadsheet Modeling for Business Decisions
By Kros (McGraw-Hill Irwin Publishers)
Recommended
 
Course Objectives

  • To learn how to apply the major techniques of management science to analyze a variety of managerial problems.
  • To learn how to model problems mathematically and use this as input into an appropriate management science tool.
  • To develop an understanding of how to interpret the results of a management science study and use these results to implement better policies.

  •  
    Measurable Learning
    Outcomes:

  • Understand the types of problems addressed by management science techniques.
  • State problems in a mathematical format.
  • Understand the concepts of linear programming.
  • Explain the use of linear programming to solve optimization problems.
  • Formulate the model linear programming problems mathematically, graphically, and using spreadsheets.
  • Transfer a problem formulated mathematically to a spreadsheet format and solve it using a software program.
  • Interpret results from solutions to linear programming problems.
  • Understand sensitivity analysis.
  • Formulate network optimization problems.
  • Understand and use binary integer programming.
  • Construct and solve queuing model problems.
  • Explain different types of forecasting techniques.
  • Use Crystal Ball to solve a variety of management science problems.
  • Describe the essence of PERT/CPM Models and their use by management.

  •  
    Topical Outline:
  • Introduction to modeling and management science
  • Optimization and linear programming
  • Solving linear programming problems in a spreadsheet
  • Sensitivity analysis
  • Network modeling
  • Integer linear programming
  • Transportation problems
  • Queuing models
  • Simulation and forecasting
  • Simple and multiple regression
  • Crystal Ball
  • Project scheduling: PERT/CPM
  •  
    Culminating Experience Statement:

    Material from this course may be tested on the Major Field Test (MFT) administered during the Culminating Experience course for the degree. 
    During this course the ETS Proficiency Profile may be administered.  This 40-minute standardized test measures learning in general education courses.  The results of the tests are used by faculty to improve the general education curriculum at the College.

     

    Recommended maximum class size for this course: 20

     
    Library Resources:

    Online databases are available at http://www.ccis.edu/offices/library/index.asp. You may access them from off-campus using your CougarTrack login and password when prompted.

     
    Prepared by: Diane Suhler Date: May 7, 2013
    NOTE: The intention of this master course syllabus is to provide an outline of the contents of this course, as specified by the faculty of Columbia College, regardless of who teaches the course, when it is taught, or where it is taught. Faculty members teaching this course for Columbia College are expected to facilitate learning pursuant to the course objectives and cover the subjects listed in the topical outline. However, instructors are also encouraged to cover additional topics of interest so long as those topics are relevant to the course's subject. The master syllabus is, therefore, prescriptive in nature but also allows for a diversity of individual approaches to course material.

    Office of Academic Affairs
    12/04