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



  Textbooks

Required

  • Hillier and Hiller. Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets. 5th. McGraw‐Hill, 2013.
    • ISBN-9780078024061
      • Note: MBS offers a custom-printed version with the following ISBN: 9781308987040

MBS Information

Textbooks for the course may be ordered from MBS Direct. You can order

For additional information about the bookstore, visit http://www.mbsbooks.com.

  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

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

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).

Quizzes

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.

Readings
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.
Readings
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.
Readings
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.
Readings
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.
Readings
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.
Readings
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.
Readings
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.
Readings
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

Your grade will be based in large part on the originality of your ideas and your written presentation of these ideas. Presenting the words, ideas, or expression of another in any form as your own is plagiarism. Students who fail to properly give credit for information contained in their written work (papers, journals, exams, etc.) are violating the intellectual property rights of the original author. For proper citation of the original authors, you should reference the appropriate publication manual for your degree program or course (APA, MLA, etc.). Violations are taken seriously in higher education and may result in a failing grade on the assignment, a grade of "F" for the course, or dismissal from the College.

Collaboration conducted between students without prior permission from the instructor is considered plagiarism and will be treated as such. Spouses and roommates taking the same course should be particularly careful.

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.

Non-Discrimination

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

Students with documented disabilities who may need academic services for this course are required to register with the office of Student Accessibility Resources. Until the student has been cleared through this office, accommodations do not have to be granted. If you are a student who has a documented disability, it is important for you to read the entire syllabus as soon as possible. The structure or the content of the course may make an accommodation not feasible. Student Accessibility Resources is located in Student Affairs in AHSC 215 and can be reached by phone at (573) 875-7626 or email at sar@ccis.edu.

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 Helpdesk, or the D2L Helpdesk for assistance. 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.