OMGT 3223 - Spring 2024, Section 008, Bate 3010

Business Decision Modeling 
T-Th 3:30 pm to 4:45 pm 
Course Description / Grading / Attendance / About the Instructor / Course Outline / Class List / Home

Instructor: Dr. John F. Kros

Phone: 328-6364

Office: 3205 Bate Building

Email: krosj@ecu.edu

Office Hours: MTW 12 p.m. - 2 p.m. or by appt.

http://myweb.ecu.edu/krosj/ecu.html


Text:

Spreadsheet Text Cover
Spreadsheet Modeling for Business Decisions, Kros, 5th Edition, Kendall/Hunt

Order the eBook or hardcopy of the text directly from KendallHunt: http://www.kendallhunt.com/kros/

or obtain from ECU Bookstore, UBE, etc. 

I recommend the eBook edition of the text, it is less expensive, can be printed (a limited # of times), and weighs infinitely less than the hardcopy version.

(NOTE: Joyner Library has copies available for student use on a reference and first come first served basis.) It is perfectly acceptable to buy a used copy of the text. However, used copies do not come with access to the Text Website. Access to the Online Text Meterials can be purchased from Kendall/Hunt at the Text Website listed below.

Text Website: Website for Spreadsheet Modeling for Business Decisions. Contains Excel Templates, STUDY GUIDE, interactive models, etc. You need to use the code that accompanies the textbook to access the site. If you bought a used text you will have to purchase an access code separately if you wish to access the Online Text Materials.

Software:

Risk Solver Platform (RSP) - a web based version can be found here (this is the best way to access and only way Mac users can use the software) Google Sheets Risk Solver Add-on

- if wanted a full term download included with text is at http://www.solver.com/risk-solver-platform

NOTE:  You can also try @Risk - full term download included with text at http://www.palisade.com/bookdownloads/kros/

Treeplan - included on the Text Website or at TreePlan.com

(NOTE: If you chose to use the demo software instead of the full version, DO NOT download the software until the around date we start using RSP or @Risk listed on the syllabus, this is a trial download that is active for only about 10 days after download. If you download too early it will expire before you can use it for the simulation assignments.)

The College of Business has this software loaded on all computers on 3rd floor Bate (or the alternate computer site) if you happen to be on campus.

Course Description and Goals:

Catalog Description - Managerial problem solving and decision making skills using quantitative methods and computer skills. This course covers the quantitative methods used to formulate and solve problems in business, supply chain management, economics, and the social and life sciences (Prerequisite:  MATH2283).

Think Critically
     Develop skills and judgment in becoming more effective & efficient problem solvers.  Apply the DECIDE framework to identify business problems & solutions.

Value
     Utilize EDGE perspective to evaluate "real life" problems and alternative solutions to quantitative business problems.

Communicate
     Develop skills to effectively communicate quantitative information and recommendations, and to articulate professional, quality written reports based on complex analysis.

Lead
     Demonstrate effective leadership skills to successfully structure and complete collaborative group work.

Laptop Requirement:  The College of Business requires that all students enrolled in a College of Business course acquire and have available a laptop or mobile computer for use in and out of the classroom environment. The laptop or mobile computer must be capable of running Microsoft Windows and the latest version of Microsoft Office. Faculty may also require other specialized software applications. Additional information may be found at https://business.ecu.edu/technology/

Assignments and Grading: Assignments are summarized later in this syllabus. Grading will be calculated roughly along the following guidelines and weights with student to student and student to faculty interaction via ongoing, moderated discussion board/chats (e.g. Homework):

Grading:

Homework

4 @ 5%

20%

Cases - Group Work

2 @ 6%

12%

Quizzes

5 total (drop one) 4@ 10%

40%

Exam

.

23%

Final/Assessment Exam

.

5%

Top
ALL ASSIGNMENTS THAT ARE NOT AUTO-GRADED VIA CANVAS (E.G., FINAL EXAM OR DISCUSSION AREA POSTS) ARE EXPECTED TO BE SUBMITTED VIA CANVAS USING FILE ATTACHMENTS. PLEASE MAKE YOURSELVES FAMILIAR WITH USING PROGRAMS SUCH AS: MS Word (.doc files), Adobe Acrobat (.pdf files), and any commercial screen shot software (i.e., Snapz Pro, Screencatcher, etc.). THIS IS A MUST FOR THIS CLASS, CONTACT THE INSTRUCTOR IF YOU DO NOT UNDERSTAND THIS POLICY OR NEED ASSISTANCE.

FILE NAMING CONVENTION FOR SUBMITTING ASSIGNMENTS TO CANVAS:

PLEASE USE THE FOLLOWING NAMING CONVENTION WHEN SAVING AND SUBMITTING COMPLETED ASSIGNMENT FILES:

lastnamefirstinitialassignment.suffix

For example, for myself I would name my first homework assignment file:

krosjhomework#1.doc

Be forewarned, I will either send your assignments back to you ungraded or downgrade your work if you do not follow this naming convention.

Homework will be assigned according to the tentative schedule presented. Please attempt every problem and feel free to ask me or your fellow students for assistance. However, all homework turned in must be your own work and missed assignments will receive a zero grade. Late homework will not be accepted.

The group projects are case study assignments on the area of business problem solving. You will receive more information on the content and format of the case studies early in the term.

Quizzes will be given about once every two weeks. The quizzes will cover material from the previous classes and the problems will be straightforward. The lowest quiz score will be dropped, but missed quizzes can not be made up and will receive a zero grade.

The exam will cover material from the text and my lectures. The problems on the exam will be similar to the quiz and homework problems.A missed exam will receive a zero grade. Please make prior arrangements if the exam will be missed.

Final grades will be assigned by letter and will be derived approximately from the grading percentages shown above roughly following the standard +/- scale. I will assign grades on individual assignments according to the ECU +/- scale (A = 4.0, A-=3.7, B+=3.3, B = 3.0, B-=2.7, C+=2.3, C = 2.0, C-=1.7, D+ = 1.3, D = 1.0, D- = 0.7, F = 0.0).

Roughly the following grade cut-offs will be used: above 3.7 = A, above 3.3 to 3.7 = A-, above 3.0 to 3.3 = B+, above 2.8 to 3.0 = B, above 2.5 to 2.8 = B-, above 2.2 to 2.5 = C+, above 1.9 to 2.2 = C, above 1.6 to 1.9 = C-, above 1.3 to 1.6 = D+, above 1.0 to 1.3 = D, above 0.8 to 1.0 = D-, below 0.8 = F. Percentage scores will not be assigned.

Attendance: Timely attendance is the responsibility of the student.  There is no penalty for missed lectures.

Top
Retention Requirements:  Students at East Carolina University are expected to be in Good Academic Standing. For students to be considered in Good Academic Standing, a cumulative GPA of 2.0 is required. If a student fails to meet Good Academic Standing, he or she will be placed on academic warning, probation, or suspension as shown below.  

Consequences of Not Maintaining Good Academic Standing
Good Academic Standing
End of Semester 2
End of Semester 3
GPA = 2.0+
GPA < 2.0
GPA < 2.0
Good Standing
Probation
1 Semester Suspension

Top

Academic Integrity: Any academic dishonesty will result in a failing grade and appropriate university disciplinary actions taken. Please do your own work. If you do not understand the academic integrity policy of the ECU Marketing and Supply Chain Management Department please see the instructor.
 
Suggestions: To do well in this class the following hints might help.

1. Complete the homework, quizzes, and exams - correct or incorrect, I will do my best to reward effort.
 
2. Work with others - feel free to discuss problems and methodology on homeworks*.
 
3. Ask the instructor for help and PLEASE FOLLOW ALL INSTRUCTIONS!!!
 
* Exams and quizzes are individual assignments and are expected to be completed without collaboration or discussion with any other student.

East Carolina University seeks to comply fully with the Americans with Disabilities Act (ADA). Students requesting accommodations based on a disability must be registered with the Department for Disability Support Services located in Slay 138 (252) 737-1016 (Voice/TTY).

Continuity of Instruction: In the event that face-to-face campus classes are suspended for some undetermined length of time due to a pandemic or other catastrophic event, I will strive to continue instruction for our course through Canvas and via email soon after the event occurrence.  Students must understand that it may be necessary to make adjustments to instruction modes and/or assignments.  It is the responsibility of the student to logon each day and to comply with any needed changes.
About the Instructor: John F. Kros has a bachelors degree in business administration from The University of Texas, a master of business administration from Santa Clara University, and a Ph.D. in systems engineering from The University of Virginia. He enjoys spending his free time traveling, snow skiing, watching college football, and attempting to locate establishments that provide inexpensive food and liquid refreshment. Suggestions are always welcome!!

Top

OMGT 3223 Tentative Course Outline

TAKE NOTE: Bold Items Indicate Dates When Assignments are Posted or When they are DUE

(e.g., 1/23 is in bold as it is the date for HW 1)

Date:

Topic

Homework

Topics:

1/9

Introduction

.

 

 

Bus. Dec. Modeling Overview

.

Chapter 1

1/11

Probability and Statistics

Ch3 - Stats/Prob Video Lecture

Chapter 3

1/16

Probability and Statistics

Chapter 3

1/18

Probability and Statistics

Bayes' Rule Example

Chapter 3

1/23

Spreadsheet Modeling I

Decision Analysis

Homework #1 -due

Bayes' Rule Example

Chapter 2

1/25

Decision Analysis

.

Chapter 4

1/30

Decision Analysis

Study Guide for Quiz #1

Video Tutorial on Chapter 4 .ppts - Decision Analysis

Chapter 4

2/1

Quiz #1 - Face-to-Face in Bate 3010

.

Chapter 1,2,3 and part of 4

2/6

Decision Analysis

Simulation

Sensitivity Graph Video Tutorial

Ibanez Produce Case

2/8

Simulation (lab)


Case # 1

RSP Decision Tree Tutorial

Form Groups for Case Study

Chapter 5

Excel Template for RSP Tutorial Lecture

2/13

Simulation (lab & case review)


Homework #2 - due

HOMEWORK #2 SOLUTIONS

Case #1 Simulation Model UDB Case Video Tutorial I

Chapter 4

2/15

Simulation (lab & case review)

Case #1 Simulation Model UDB Case Video Tutorial II

Chapter 5

Excel File for Ibanez Produce Case

2/20

Quiz #2 - Face-to-Face in Bate 3010

Study Guide for Quiz #2


Chapter 5


2/22

Simulation (lab & case review)

Case #1 Simulation Model UDB Case Video Tutorial III

Chapter 5

2/27

Case # 1 Due TBA

.


Chapter 5

2/29

CASE #1 due by TBA

CASE #1 due by TBA

CASE #1 due by TBA

3/5
SPRING BREAK
SPRING BREAK SPRING BREAK
3/7
SPRING BREAK SPRING BREAK SPRING BREAK
3/12

Work on Case #1 - Due Date TBA

Optimization Models

LP Example Setup Video - EXCEL Portion

Problem to Accompany LP Example Setup Video - .pdf file

Chapter 8

Formulation and graphical solution method review

Specific optimization problems and computer solutions

3/14 Optimization Models

Intro. Case #2 (lab) - Case #2

.
Chapter 5 - Simulation
3/19

Optimization Models

Case #2 (lab) - Case #2

Review Sheet for Exam

Optimization Tutorial Video Lecture

Chapter 1, 2, 3, 4, and 5

Writing Guidelines

3/21

Quiz #3 - Face-to-Face in Bate 3010

Review Sheet for Exam

Quiz#1 Partial Solutions

Quiz#2 Partial Solutions

Chapter 1, 2, 3, 4, and 5

Writing Guidelines

3/26

Exam I - Due March 28th by Class Time

Exam I .pdf

Exam I Partial Solutions

Chapter 1, 2, 3, 4, and 5

Writing Guidelines

3/28

Exam I Due by Class Time

Optimization Models and Intro.

Case #2 (lab)

Optimization Lecture I-Transportation Spreadsheet

Optimization Lecture II -Transportation Spreadsheet

Chapter 8
Transportation problems & Assignment problems

4/2

Optimization Models and Intro.

Case #2 (lab)


LP Example Video - Solution by Hand

LP Example Setup Video - EXCEL Portion

JBK Cabling XL File

Chapter 8 - setting up optimization problems

4/4

Case #2 Due - before class

Forecasting

Homework #3 due

Chapter 8 - setting up optimization problems

Chapter 7

4/9

Quiz #4 - Face-to-Face in Bate 3010

.

.

4/11


Forecasting-Linear Regression


.

Chapter 6

LR Example

LR Example2

4/16

Forecasting - Linear Regression

Homework #4 due

Linear Regression Example Video Tutorial

Chapter 6

LR Example

LR Example2

4/18


Quiz #5 - Face-to-Face in Bate 3010

.

Chapter 6 and 7

4/23
No Class this is treated as a Friday

.

.

4/25

Final Exam 2 pm Bate 3010

Final Exam Review - 10 question multiple choice (long green Scantron), 30 minute maximum time, closed book & notes

Assessment Exam Review Sheet

Video Narrative  - Final/Assessment Exam