Effective: Late Fall 8-Week, 2018/2019

MGMT 430: Management Science

Back to Top

  Course Description

Management Science is a discipline that integrates mathematical modeling and quantitative analysis into the managerial decision-making process. The goal of the course is to provide students with a background in mathematical modeling to augment their problem-solving skills.

Prerequisite: MATH 150 or MATH 170; MATH 250 or PSYC 324

Proctored Exams: None


As part of TruitionSM, students will receive their course materials automatically as described below.


  •  Hillier and Hiller. Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets. 6th ed, McGraw‐Hill, 2018.  eText

Bookstore Information

Visit https://www.ccis.edu/bookstore.aspx for details.

eText Information

If a course uses an eText, (see Textbook information above) the book will be available directly in Desire2Learn (D2L) and through the VitalSource eText reader the Friday before the session begins, if registered for courses prior to that date.  Students will have a VitalSource account created for them using their CougarMail email address. Upon first login to VitalSource, students may need to verify their account and update their VitalSource password.  More information about how to use the VitalSource platform, including offline access to eTexts, can be found in D2L.  Students that would like to order an optional print-on-demand copy of eligible eTexts can do so through the VitalSource bookshelf at an additional cost.  Once orders are placed, it can take approximately five to seven business days for students to receive their print-on-demand books.

Physical Course Materials Information

Students enrolled in courses that require physical materials will receive these materials automatically at the address on file with Columbia College.  Delivery date of physical materials is dependent on registration date and shipping location.  Please refer to confirmation emails sent from Ed Map for more details on shipping status.

Returns: Students who drop a course with physical course materials will be responsible for returning those items to Ed Map within 30 days of receipt of the order.  More specific information on how to do so will be included in the package received from Ed Map.  See here for Ed Map's return policy. Failure to return physical items from a dropped course will result in a charge to the student account for all unreturned items.

Note: Students who opt-out of having their books provided as part of TruitionSM are responsible for purchasing their own course materials.

  Course Overview

The goal of this course is to prepare students to

  • Assess and organize complex business situations requiring specific, quantifiable outcomes
  • Develop a spreadsheet model of the situation so that it can be evaluated quantitatively
  • Apply the appropriate decision analysis tools to the spreadsheet model
  • Decide on the path forward based on the model’s output and associated risks

The quantitative techniques that are covered in this class are designed to help business leaders understand and analyze problems in an organized fashion, fully capable of providing alternative paths moving forward. While the tools, techniques, and the problems they are applied to differ, they all have a common trait that binds them all together, a need to quantitatively assess the risk involved with any of the decisions the models may recommend. Each week we will address different types of management science problems. We will discuss how to approach and model the problems mathematically as well as how to use spreadsheet packages to solve management science problems.

  Technology Requirements

Participation in this course will require the basic technology for all online classes at Columbia College:
  • A computer with reliable Internet access
  • A web browser
  • Acrobat Reader
  • Microsoft Office or another word processor such as Open Office

You can find more details about standard technical requirements for our courses on our site.

  Course Learning Outcomes

  1. Demonstrate an understanding of the theory and math behind several data-driven quantitative approaches currently in use by real-world managers to make better and/or timelier decisions and predictions.
  2. Create valid data-driven predictive business models combining these new concepts with business concepts learned in earlier course work.
  3. Implement these models using current analytical tools such as Excel and Risk Solver.
  4. Evaluate the performance and usefulness of these models in business management terms.


Grading Scale

Grade Points Percent
A 900-1000 90-100%
B 800-899 80-89%
C 700-799 70-79%
D 600-699 60-69%
F 0-599 0-59%

Grade Weights

Assignment Category Points Percent
Discussions (9) 70 7%
Dropbox (11) 330 33%
Quizzes (7) 350 35%
Final Exam 250 25%
Total 1000 100%

  Schedule of Due Dates

Week 1

Assignment Points Due
Discussion 1 6 Wednesday/Sunday
Discussion 2 8
Dropbox Assignment 1 30 Sunday
Quiz 1 50

Week 2

Assignment Points Due
Discussion 3 8 Wednesday/Sunday
Dropbox Assignment 2 30 Sunday
Dropbox Assignment 3 30
Quiz 2 50

Week 3

Assignment Points Due
Discussion 4 8 Wednesday/Sunday
Dropbox Assignment 4 30 Sunday
Quiz 3 50

Week 4

Assignment Points Due
Discussion 5 8 Wednesday/Sunday
Dropbox Assignment 5 30 Sunday
Dropbox Assignment 6 30
Quiz 4 50

Week 5

Assignment Points Due
Discussion 6 8 Wednesday/Sunday
Dropbox Assignment 7 30 Sunday
Quiz 5 50

Week 6

Assignment Points Due
Discussion 7 8 Wednesday/Sunday
Dropbox Assignment 8 30 Sunday
Dropbox Assignment 9 30
Quiz 6 50

Week 7

Assignment Points Due
Discussion 8 8 Wednesday/Sunday
Dropbox Assignment 10 30 Sunday
Quiz 7 50

Week 8

Assignment Points Due
Discussion 9 8 Wednesday/Saturday
Dropbox Assignment 11 30 Thursday
Final Exam 250 Saturday
Total Points: 1000

  Assignment Overview


Discussions will consist of responding to issues and questions related to the subject material covered. Typically, an issue or situation related to the immediate subject matter will be offered for discussion and worded in such a fashion as to require a position to be taken and then defended. Logically defending the point taken will serve as the basis for points awarded.  All students will observe conventions of "online etiquette" when communicating online which includes courtesy to all users.

Each discussion requires three posts: an original post (due Wednesdays) and two peer responses (due Sundays/Saturday in Week 8).  You will not be able to see other students' posts until your submit your own.

Dropbox Assignments

Dropbox assignments will consist of a problem or problems to be worked and submitted via the Dropbox. These "homework" problems will not be limited to simply ‘right answer’ or ‘wrong answer’. Rather, points will be awarded for being proximal, for being on time, for correct labeling, for being auditable, and the model itself being logical and organized intuitively. The total homework points earned will be added to the class point total. Some assignments will require the use of a free Excel Solver add-in.  Instructions for how to add the Solver Add-in are located in the Week 1 Instructional Materials.

Dropbox assignments are due are Sunday (Weeks 1-7) and Thursday (Week 8).


Each quiz will contain 20 multiple choice and/or true-false questions over the current week's readings. You will have 30 minutes and one attempt on each quiz. Quizzes open Monday and are due on Sunday of their assigned week.

Final Exam

The final exam is not proctored. It will focus on the conceptual and modeling aspects of each analytical technique studied. You will have two hours and one attempt to complete the exam. Questions may be multiple choice, true-false, and/or short answer. You will not be required to use Microsoft Excel on the exam. The exam opens Thursday and closes Saturday of Week 8.

  Course Outline

Click on each week to view details about the activities scheduled for that week.

Chapters 1 and 2
Discussion 1

Introduce yourself. Give your name, occupation, hobbies, interest or experience you may have in decision science or mathematical modeling, family information, and/or any other information that can help us get to know you. After you have submitted your introduction, respond to at least two of your classmates’ introduction posts.

Discussion 2
Describe a situation that could be modeled using a Linear Programming Model.  What are the advantages of analyzing and experimenting with a model as opposed to a real object or situation?   One original post and two peer responses required.
Dropbox Assignment 1
See Week 1 of the content area for details on this assignment.
Quiz 1
Covers chapters 1 and 2 of the textbook.
Chapters 4 and 5
Discussion 3
Reference the attached file (in the discussion area) showing the sensitivity analysis of a solved mode.  There is a letter on 20 of the values in the sensitivity report.  Choose one of the letters and explain what that number means with respect to the solved model.  When you post your solution, please title your response “Letter ?” replacing the question mark with the letter you have chosen from the file. Please ensure you do not duplicate a response from a fellow student.
Dropbox Assignment 2
See Week 2 of the content area for details on this assignment.
Dropbox Assignment 3
See Week 2 of the content area for details on this assignment.
Quiz 2
Covers chapters 4 and 5 of the textbook.
Chapters 6 and 15
Discussion 4
Choose one of the network flow models discussed in this chapter. Describe a situation in which this model could be used. What quantities would be represented by the arcs? What quantities would be represented by the nodes? One original post and two peer responses required.
Dropbox Assignment 4
See Week 3 of the content area for details on this assignment.
Quiz 3
Covers chapters 6 and 15 of the textbook.
Chapters 3 and 7
Discussion 5
Choose one of the major categories of applications of linear programming discussed in the chapter.  Give an example of an application of the model.  Support whether the variables have to be integers for your example.  One original post and two peer responses required.
Dropbox Assignment 5
See Week 4 of the content area for more on this assignment.
Dropbox Assignment 6
See Week 4 of the content area for more on this assignment.
Quiz 4
Covers chapters 3 and 7 of the textbook.
Chapter 16
Discussion 6
Describe a project, list two tasks that may be performed in parallel, and two tasks that need to be performed sequentially.  One original post and two peer responses required.
Dropbox Assignment 7
See Week 5 of the content area for more information on this assignment.
Quiz 5
Covers chapter 16 of the textbook.
Chapter 11
Discussion 7
Give an example of an application of queuing models discussed in this chapter such as a) Single-server waiting line, b) Multiple Single-server waiting lines and c) Multiple-server waiting line.  Which would you prefer to wait in? Why?  One original post and two peer responses required.
Dropbox Assignment 8
See Week 6 of the content area for more on this assignment.
Dropbox Assignment 9
See Week 6 of the content area for more information on this assignment.
Quiz 6
Covers chapter 11 of the textbook.
Course Evaluation
Please evaluate the course. You will have an opportunity to evaluate the course near the end of the session. A link sent to your CougarMail will allow you to access the evaluation. Please note that these evaluations are provided so that I can improve the course, find out what students perceive to be its strengths and weaknesses, and in general assess the success of the course. Please do take the time to fill this out.
Chapter 10
Discussion 8
Choose one of the following forecasting methods discussed in this chapter: last-value, averaging, moving-average, or exponential smoothing.  Identify the conditions when the method is most appropriate to use and give an example of an application of this method.  One original post and two peer responses required.
Dropbox Assignment 10
See Week 7 of the content area for more information on this assignment.
Quiz 7
Covers chapter 10 of the textbook.
Chapter 12
Discussion 9
Describe a situation that you have seen that would be appropriately modeled using simulation.  Explain why modeling using simulation would be appropriate.  One original post and two peer responses required.
Dropbox Assignment 11
See Week 8 of the content area for more information on this assignment.
Final Exam
Covers material from all assigned chapters of the textbook.

  Course Policies

Student Conduct

All Columbia College students, whether enrolled in a land-based or online course, are responsible for behaving in a manner consistent with Columbia College's Student Conduct Code and Acceptable Use Policy. Students violating these policies will be referred to the office of Student Affairs and/or the office of Academic Affairs for possible disciplinary action. The Student Code of Conduct and the Computer Use Policy for students can be found in the Columbia College Student Handbook. The Handbook is available online; you can also obtain a copy by calling the Student Affairs office (Campus Life) at 573-875-7400. The teacher maintains the right to manage a positive learning environment, and all students must adhere to the conventions of online etiquette.

Plagiarism and Academic Integrity

Academic integrity is a cumulative process that begins with the first college learning opportunity. Students are responsible for knowing the Academic Integrity policy and procedures and may not use ignorance of either as an excuse for academic misconduct. Columbia College recognizes that the vast majority of students at Columbia College maintain high ethical academic standards; however, failure to abide by the prohibitions listed herein is considered academic misconduct and may result in disciplinary action, a failing grade on the assignment, and/or a grade of "F" for the course.

Additionally, all required papers may be submitted for textual similarity review to Turnitin.com for the detection of plagiarism. All submitted papers may be included in the Turnitin.com reference database for the purpose of detecting plagiarism. This service is subject to the Terms and Conditions of Use posted on the Turnitin.com site.


There will be no discrimination on the basis of sex, race, color, national origin, sexual orientation, religion, ideology, political affiliation, veteran status, age, physical handicap, or marital status.

Student Accessibility Resources

Columbia College is committed to creating a learning environment that meets the needs of its diverse student body. If you anticipate or experience any barriers to learning, communicate your concerns with the instructor. In addition to speaking with the instructor, the following resources are available to ensure an opportunity to learn in an inclusive environment that values mutual respect.

  • For students with disabilities/conditions who are experiencing barriers to learning or assessment, contact the Student Accessibility Resources office at (573) 875-7626 or sar@ccis.edu to discuss a range of options to removing barriers in the course, including accommodations.
  • For students who are experiencing conflict which is impacting their educational environment, contact the Office of Student Conduct at studentconduct@ccis.edu or (573) 875-7877.
  • For students who have concerns related to discrimination or harassment based on sex, gender identity, sexual orientation, pregnancy or parental status, please contact the Title IX Office at titleixcoordinator@ccis.edu. More information can be found at http://www.ccis.edu/policies/notice-of-non-discrimination-and-equal-opportunity.aspx

Online Participation

You are expected to read the assigned texts and participate in the discussions and other course activities each week. Assignments should be posted by the due dates stated on the grading schedule in your syllabus. If an emergency arises that prevents you from participating in class, please let your instructor know as soon as possible.

Attendance Policy

Attendance for a week will be counted as having submitted any assigned activity for which points are earned. Attendance for the week is based upon the date work is submitted. A class week is defined as the period of time between Monday and Sunday (except for week 8, when the work and the course will end on Saturday at midnight.) The course and system deadlines are based on the Central Time Zone.

Cougar Email

All students are provided a CougarMail account when they enroll in classes at Columbia College. You are responsible for monitoring email from that account for important messages from the College and from your instructor. You may forward your Cougar email account to another account; however, the College cannot be held responsible for breaches in security or service interruptions with other email providers.

Students should use email for private messages to the instructor and other students. The class discussions are for public messages so the class members can each see what others have to say about any given topic and respond.

Late Assignment Policy

An online class requires regular participation and a commitment to your instructor and your classmates to regularly engage in the reading, discussion and writing assignments. Although most of the online communication for this course is asynchronous, you must be able to commit to the schedule of work for the class for the next eight weeks. You must keep up with the schedule of reading and writing to successfully complete the class.

No late discussion posts will be accepted.

No late assignments will be accepted without extenuating circumstances beyond the control of the student and with instructor notification prior to the due date (Columbia College Catalog).

Course Evaluation

You will have an opportunity to evaluate the course near the end of the session. A link will be sent to your CougarMail that will allow you to access the evaluation. Be assured that the evaluations are anonymous and that your instructor will not be able to see them until after final grades are submitted.

  Additional Resources

Orientation for New Students

This course is offered online, using course management software provided by Desire2Learn and Columbia College. The course user guide provides details about taking an online course at Columbia College. You may also want to visit the course demonstration to view a sample course before this one opens.

Technical Support

If you have problems accessing the course or posting your assignments, contact your instructor, the Columbia College Technology Solutions Center, or the D2L Helpdesk for assistance. If you have technical problems with the VitalSource eText reader, please contact VitalSource. Contact information is also available within the online course environment.

Online Tutoring

Smarthinking is a free online tutoring service available to all Columbia College students. Smarthinking provides real-time online tutoring and homework help for Math, English, and Writing. Smarthinking also provides access to live tutorials in writing and math, as well as a full range of study resources, including writing manuals, sample problems, and study skills manuals. You can access the service from wherever you have a connection to the Internet. I encourage you to take advantage of this free service provided by the college.

Access Smarthinking through CougarTrack under Students -> Academics -> Academic Resources.