QMETH 551: Winter 2005
|
Syllabus |
Instructor: Mark Hillier
Office: Mackenzie 211
Office Hours: Mondays, 4:00-6:00
e-mail: mhillier@u.washington.edu
course web site: http://faculty.washington.edu/mhillier/qmeth551/
Phone: 685-1912
Course Description
This course covers modeling with spreadsheets for analyzing quantitative aspects of business problems. Spreadsheet packages now have features that allow managers to perform sophisticated quantitative analysis in the comfortable and intuitive environment of the spreadsheet. This gives managers the power of quantitative analysis tools without forcing them to use unfamiliar mathematical notation. Applications from a variety of business areas will be discussed, including finance, marketing, and operations.
Hillier and Hillier, Introduction to Management Science: A Modeling and Case Studies Approach with Spreadsheets, Second Edition, McGraw-Hill/Irwin, 2003.
Course Packet will be available from RAMS Copy Center (4144 University Way). Packet includes copies of class tranparencies and case studies.
Course Packet
I have prepared extensive course notes that I use as overheads during lecture. These course notes include examples that we will work together in class and other lecture material. The course notes are not intended as material that you use to prepare for class; my intent is for them to make it easier for you to listen, ask questions, and participate in class, rather than take lots of your own notes during the lectures.
Microsoft Excel (including Solver), Premium Solver (available on the textbook CD), Crystal Ball and OptQuest (available on the textbook CD and installed on the computers in the Balmer labs).
The course grade will be based on class participation, problem sets, and two exams, with the following weights:
Class Participation 5% Problem Sets 35% Midterm 30% Final Exam 30%
There will be five graded problem sets. These should be done working in groups of two or three. Each group should turn in their solution to each assignment via e-mail no later than the start of class on the day it is due. Please title the file with your lastnames followed by the problem set number (e.g., HillierAustin1). If possible, include all spreadsheets in a single workbook on separate tabs.
The midterm exam and final exam will both be take-home exams. You will be given approximately one week for each. These exams are open book and open notes, but must be completed individually, without assistance from any other person.