Class 1 - Tuesday, January 20th
Before Class: -
In Class: Introduction
Homework: Data Tables Video Module (Quiz on Tuesday, January 27th)
Class 2 - Thursday, January 22nd
Before Class: -
In Class: Introduction to Mathematical Modeling.
Homework: - Read Chapter 1, Solver Video Module (Quiz on Thursday, January 29th)
Class 3 - Tuesday, January 27th
Before Class: Read chapter 2, pages 27-35 and 45-47 only
In Class: Spreadsheet Modeling. Qu. 2.1 (S), 2.3 (a and b only) (S), Quiz on Data Tables Video Module
Homework 1: 2.5 (S) (Due Thursday, February 5th)
Class 4 - Thursday, January 29th
Before Class: Read sections 3.1 to 3.3.
In Class: Quiz on Solver Video Module, Linear Programming and Excel's Solver. Qu. 3.1 (S), 3.3 (S) (Solver only)
Homework 1: 3.5 (Solver only) (S), (Due Thursday, February 5th)
Friday, January 30th
- Deadline for students to provide advanced written notification to instructors of intent to observe religious holidays.
- Last day for spring degree candidates to submit graduation applications to their advisors for May degrees.
Class 5 - Tuesday, February 3rd
Before Class: Read sections 3.5 to 3.7.
In Class: Graphical Solutions to LPs. Qu. 3.1 , 3.3 (Graphical Solution)
Homework: -
Class 6- Thursday, February 5th
Before Class: Read section 3.4. Homework 1 due.
In Class: Sensitivity Analysis. Qu. 3.2 (S), 3.4 (S)
Homework 2: Qu. 3.5b (S), 3.6 (S) (Due Thursday, February 12th)
Class 7 - Tuesday, February 10th
Before Class: Read section 3.8 and 3.9
In Class: LP Models. Qu. 3.8 (S), 3.9 (S)
Homework: -SolverTable executable Note: this is not a zip file, but an executable. Save it to the desktop, then double click on it. Click OK, tell it where you want to place solvertable (I suggest on the C drive, as it suggests) then click "unzip". Once the process is complete, open Excel, click on File->Open, and find the solvertable folder you just installed. Inside this folder is a file called "solvertable.xla". Open this file, and solvertable should now appear on the Data menu. Due to software problems, you may have until Friday February 13th at noon to submit problem 3.6.
Class 8 - Thursday, February 12th
Before Class: Read section 4.2. Homework 2 due.
In Class: Static Workforce Scheduling Models. Qu. 4.1 (S), 4.2 (S)
Homework 3: Qu. 3.10 (S), 4.3a(S) (Due Sunday, February 22nd at Midnight)
Class 9 - Tuesday, February 17th
Before Class: Read section 4.3
In Class: Aggregate Planning Models. Qu. 4.5 (S), 4.6 (S)
Homework: -
Class 10 - Thursday, February 19th
Before Class: Read section 4.4.
In Class: Dynamic Workforce Planning Models. Qu. 4.13 (S), 4.14 (S)
Homework 4: Qu. 4.9 (S), 4.15a (S) (Due Thursday, February 26th)
Sunday, February 22nd
Homework 3 Due
Class 11 - Tuesday, February 24th
Before Class: Read section 4.5.
In Class: Blending Models. Qu. 4.17 (S), 4.18 (S)
Homework: -
Class 12 - Thursday, February 26th Homework 4 due.
Before Class: Read section 5.2 (up to middle of page 200).
In Class: Quiz on Section 5.2; Transportation Models. Qu. 5.1 (S), 5.2 (S)
Homework 5: Qu. 4.20 (S), 5.4 (S) (Due Thursday, March 4th). Include descriptions of what your changing cells represent on your spreadsheets.
Class 13 - Tuesday, March 2nd
Before Class: Read section 5.3.
In Class: Logistics Models. Qu. 5.14 (S), 5.15 (S)
Class Discussion: Qu. 5.19 (S) (Discussed on Tuesday, March 9th)
Class 14 - Thursday, March 4th Homework 5 due.
Before Class: Review problems 5.14 and 5.15 from Tuesday.
In Class: Spreadsheet formulations of problems 5.14 and 5.15
Homework: -Precision Tree Video Module (quiz on March 25th)
Class 15 - Tuesday, March 9th
Before Class: -
In Class: Discuss problem 5.19, exam review. Come prepared with questions for the exam review!
Homework: -
Class 16 - Thursday, March 11th
Before Class: -
In Class: Mid-term exam
Homework: -
Tuesday, March 16th
Spring Break
Thursday, March 18th
Spring Break
Class 17 - Tuesday, March 23rd
Before Class: Read sections 6.1 to 6.3.
In Class: Integer Programming. Qu. 6.1 (S), 6.2 (S)
Homework: -
Class 18 - Thursday, March 25th
Before Class: Read section 6.4
In Class: Fixed-Cost Models. Qu. 6.22 (S), 6.23 (S), Quiz on Precision Tree Video Module
Homework 6: -Qu. 6.3 (S), 6.26 (S) (Due Thursday, April 1st) You should include, somewhere on your spreadsheet solution, a statement detailing precisely what your changing cells represent. Submit your homework through the blackboard digital drop box. Email me if you have questions!
Friday, March 26th
- Last day to withdraw from a course with a mark of "W".
Class 19 - Tuesday, March 30th
Before Class: Read section 10.1 and 10.2,
In Class: Decision Analysis. Qu. 10.1 (S)
Homework: Reread section 10.2 for Thursday!
Class 20 - Thursday, April 1st
Before Class: Read section 10.2. Homework 6 due.
In Class: Decision Analysis. Qu. 10.4 (S), 10.5 (S)
Homework 7: Qu. 10.7 (S), 10.8 (S) (Due Thursday, April 8th) Submit your homework through the blackboard digital drop box. Email me if you have questions!
Class 21 - Tuesday, April 6th
Before Class: Read section 10.3.
In Class: Single-Stage Decisions. Qu. 10.10 (S), 10.12 (S)
Homework: @RISK Video Module (quiz on April 15th)
Class 22 - Thursday, April 8th
Before Class: Read section 10.4. Homework 7 due.
In Class: Multi-Stage Decisions. Qu. 10.19 (S), 10.21 (S)
Homework 8: Qu. 10.22 (S), 10.24 (S) (Due Thursday, April 15th) You need only submit problem 10.22 via blackboard. The solution for 10.24 has already been provided; it is for your practice. It is also imperative that you read sections 11.1 to 11.4 for Tuesday!
Class 23 - Tuesday, April 13th
Before Class: Read sections 11.1 to 11.4.
In Class: Simulation Modeling. Qu. 11.1 (S), 11.2 (S), 11.3 (S)
Homework:
Class 24 - Thursday, April 15th
Before Class: Read section 11.4 and 11.5. Homework 8 due.
In Class: Simulation in Excel. Qu. 11.5 (S), 11.7 (S), Quiz on @RISK
Homework 9: - Qu. 11.4 (S) Submit via Blackboard. Your spreadsheet should contain the entire simulation. (Due Thursday, April 22nd.)
Class 25 - Tuesday, April 20th
Before Class: Read section 11.6.
In Class: Introduction to @Risk. Qu. 11.8 (S), 11.9 (S)
Homework:
Class 26 - Thursday, April 22nd
Before Class: Read section 11.6 again! Homework 9 due.
In Class: More @Risk. Qu. 11.15 (S)
Homework 10: - Qu. 11.13 (Sa, Sb) (Due Thursday, April 29) If you didn't get a chance to do 11.15 in class, I strongly suggest that you try it on your own before viewing the solution!
Class 27 - Tuesday, April 27th
Before Class: If you didn't get a chance to do 11.15 in class, I strongly suggest that you try it on your own before viewing the solution!
In Class: More @Risk. Qu. 11.24 (S)
Homework :
Class 28 - Thursday, April 29th
Before Class: Read section 14.1 to 14.4. Homework 10 due
In Class: Queuing Models. Qu. 14.1 (S), 14.2 (S), 14.3 (S), 14.5 (S)
Homework 11: -Qu. 14.4 (S), 14.6 (S) (Due Tuesday, May 4th) You need only submit 14.6 (in class). Problem 14.4 is for your own practice.
Class 29 - Tuesday, May 4th
Before Class: Homework 11 due.
In Class: Exam review. Come prepared with questions!
Homework 11:
Tuesday, May 11th
In Class: Final Exam scheduled for 8:00-10:50