Day
|
Hour/Topic |
Assignments and Handouts |
1
Jan
17
|
 | Course intro
 | Background sheet (see handout) |
| Groups complete "Using the Web Site" (see handout) |
| Set up email address (see handout) |
|
| Intro to decision modeling
| Quantitative vs. qualitative: Anchoring or
framing exercise |
|
| Brushing up on Excel -- why and how |
| Lab tour (if time permits) |
| Learning center tour (if time permits) |
| Handouts:
Reading (for next meeting):
| Ragsdale Ch 1 (You'll find this chapter near the
middle of the text.) |
Assignments
(for next meeting):
| DON'T LOSE THE 3 DISCS IN YOUR RAGSDALE BOOK. |
| Obtaining Microsoft Excel.
|
| Brush up on
Excel. Highly recommended by previous students: Excel
tutorial.
No trivia. Just the basics you need to know. We'll do an
excel assignment in class at the next meeting. |
| You could also take
an
Excel
short course (BPC114AE) at CGCC (look under the BPC prefix) |
| Bring your floppy or flash memory
(see syllabus) to the next class meeting. |
|
2
Jan 22 |
| Functions are the basis for most decision modeling.
|
|
Handouts:
| No paper handouts this time. Be sure to print
a copy of the Excel review assignment, below. If you
want, you can print the powerpoint notes (overview and
notation/terminology) from the topic column to the left. You'll
need Microsoft Office to print these documents. |
Reading (for next meeting):
Assignments
(for next meeting):
| Excel review assignment
(do in lab, if you want help) |
| Function practice (Note: answers to odd-numbered
problems are toward the middle of the text)
| Waner 1.1 ex 1 and 3 (tables) |
| Waner 1.1 ex 5 (algebraic formula) |
| Waner 1.2 ex 1 (graphs) |
|
|
3
Jan 24 |
|
| Handouts:
| Handouts will continue to be all
electronic. Class notes are in links on the left.
Tutorials may be printed, according to the instructions below. |
|
|
Reading (for next meeting):
| Waner 1.3
|
| Waner 1.4 pgs 41-45 |
|
|
Assignments
(for next meeting):
| Practice tutorials to better understand the math
(Do them online and you get instant feedback on your answer.
Otherwise, you can print them and use a pencil following these
instructions)
|
| Excel practice and linear equations review (Note: answers to odd-numbered
problems are toward the middle of the text)
 | Use Excel to graph the function in Waner 1.1 ex
39. (Instructions are in Waner pgs 8-10 and 20-21.) Type
your name into the Excel spreadsheet. Print your graph.
Is this a linear function? |
| Answer Waner 1.4 ex 15. Then, use Excel
to graph the function in (Instructions for graphing are
in Waner pgs 8-10 and 20-21.) Is this a linear function? |
| Answer Waner 1.4 ex 16. Then, use Excel
to graph the function in (Instructions for graphing are in
Waner pgs 8-10 and 20-21.) Is this a linear function? |
| Waner 2.1 #25 and 38. Solve by adding
equations. |
|
|
|
4
Jan 29 |
|
| Handouts:
| Class notes are in links on the left. |
|
|
Reading (for next meeting):
| Waner 2.1 |
| Waner 2.2 |
| Waner 2.3 |
|
|
Assignments
(for next meeting):
|
|
5
Jan 31 |
|
| Handouts:
| Class notes are in links on the left. |
|
|
Reading (for next meeting):
|
| Assignments
(for next meeting):
| Waner 3.1: 4, 6 |
| Use the
matrix
tool to complete these (or do them by hand):
|
|
|
6
Feb 5 |
|
| Handouts:
| Class notes in links on the left |
| Matrix algebra portion of the exam study guide
(paper) |
|
|
Reading (for next meeting):
| Waner 3.3
tutorial |
| There is no reading or tutorial for determinants and
Cramer's rule. Rely on the notes to the left. |
|
|
Assignments
(for next meeting):
| Use the
matrix tool to complete these (or do them by hand):
| Waner 3.3: 35-40, 51 (inversion) |
| Use determinants to solve for x, y and z in 49a, b
and c. Do NOT use inversion. |
|
|
|
7
Feb 7 |
| Review matrix algebra homework |
| Optimization with linear functions, graphical
method |
| Discuss exam
(You may use a calculator and a computer. As a result, it will be
difficult to schedule make-ups in the Testing Center. You must send
me an email right away. Exam will only cover chapter pages
included in the readings. Homework is the best guide to everything,
except Ragsdale Ch1. That chapter should be read carefully.)
| T/F and multiple choice over Ragsdale Ch 1 |
| Function graphs, tables and equations (Waner Ch 1) |
| Creating function tables with Excel (Waner Ch 1) |
| Graphing functions with Excel (Waner Ch 1) |
| Matrix algebra (Waner Chs 2&3 -- see study guide) |
|
|
| Handouts:
|
|
Reading (for next meeting):
| None. Study for exam. |
|
|
Assignments
(for next meeting):
| None. Study for exam. |
|
|
8
Feb 12 |
| Exam 1 |
|
| Reading (for next meeting):
| Ragsdale Ch 2
|
|
| Assignments
(for next meeting):
| The problems in boldface are tricky.
Try to do them, but do not put a lot of time into them. I will
use them as a starting point for discussion. |
| Ragsdale ch2 6, 11, 12
|
| Develop the model only (don't solve) for Ragsdale
Ch2 15, 16 and 14 |
|
|
9
Feb 14 |
| Review of linear programming to date |
| Review homework
|
POM-QM for Windows Demo |
| Calculations (6, 11). Do in class with
graph paper. |
| Model building from story problem (15, 16).
Do in class. |
|
| Minimization (in conjunction with homework review) |
| Special cases (graphing handouts) |
|
| Handouts:
| Given this solution graph,
shade in the solution area. Pay close attention. The
constraints are both <= and >=. |
| Given this solution
graph, shade in the solution area. Pay close attention.
The constraints are both <= and >=. |
|
|
Reading (for next meeting):
| Ragsdale Ch 2 pgs 34-39 |
|
| Assignments (for
next meeting).
|
|
|
Feb 19 |
President's day |
no school |
10
Feb 21
|
|
| Handouts
|
| Reading (for next meeting):
| Ragsdale Ch 3, pgs 46-47 |
|
| Assignments (for
next meeting):
| Solve Ragsdale Ch2 15 and 16 using Excel.
Be sure to put your name in the spreadsheet before printing. |
| Solve Ragsdale Ch2 14 using Excel. Be sure
to put your name in the spreadsheet before printing. |
| Prepare draft model for Mexicana wireworks |
|
|
11
Feb 26 |
| Review homework |
| Sensitivity analysis
|
| Announce case study groups |
| Group case study project time: prepare solution |
|
| Handouts
| Paper handout on how to read solver reports using
Bradley Farms as an example. Did you miss class? You'll
find a few copies in the box outside my office door. |
|
| Reading (for next meeting):
| Ragsdale Ch4, pgs 136-152 |
|
| Homework (for next meeting):
| Ragsdale Case 2.1
pg 44, whatever was not finished in class. If you have lost
your Ragsdale Student disk, right-click this
and select save as. |
| Burger doodle paper handout problems 20, 21 and
22. Did you miss
class? You'll find a few copies in the box outside my office
door. Be sure to put your name in the spreadsheet before
printing. |
| Develop individual recommendations for Mexicana
Wireworks. (Did you miss class? Stop by my office and
grab the make-up assignment for Mexicana Wireworks.) |
|
|
12
Feb 28 |
| Review sensitivity analysis homework. |
| Group case study project time: Sensitivity analysis
and recommendations |
|
| Handouts
|
|
14
Mar 5 |
| Finalize project |
| Intro to project management |
|
| Handouts
| Paper handout on how to read solver reports using
Bradley Farms as an example. Did you miss class? You'll
find a few copies in the box outside my office door. |
| Degree project advising materials (Paper handout) |
|
| Reading (for next meeting):
| Ragsdale Ch4, pgs 136-152 |
|
| Homework (for next meeting):
| Finalize Mexicana Wireworks recommendations.
One set of recommendations per group. Type them up.
Include:
| printout of initial model, Answer Report, and
Sensitivity Report. |
| Include printout of final model, Answer
Report and Sensitivity Report. |
| A list of adjustments made to create the
final model. |
| Grading:
| Correct initial model: 25%.
|
| Adjustments based on sensitivity analysis
correctly applied to arrive at final model: 25%.
|
| List contains a minimum of five
recommendations, of which at least two increase profit in a
quantifiable way and at least two are creative and are
likely to help the business but do not increase profit in a
quantifiable way: 25% |
| List of recommended changes make business
sense. (Would the recommendations make sense to a
board of directors who do not know linear programming?) 25% |
|
|
|
|
14
Mar 7 |
| Exam 2
| Green scantron required |
| Approximately 20 multiple choice questions over
the reading. Ch2, Ch3 pgs 45-60, Ch4 pgs 136-152 |
| Know all special lp conditions |
| Be able to create an lp model from a story |
| Be able to set up a maximization and minimization
lp problem in Excel without reference to any notes |
| Understand and interpret sensitivity analysis
reports |
|
|
| Handouts
| Project management handout. Did you miss
the in-class exam? You'll
find a few copies of the handout in the box outside my office door. |
|
| Reading (for next meeting):
| Project management handout pgs 295-312.
Quiz over material on Monday after Spring Break. Bring green scantron. |
|
|
|
Mar 12 - 18 |
Spring break |
No school |
15
Mar 19 |
| Quiz over reading |
| Project management
| group task: party project |
| Task lists |
| Identifying task dependencies |
| Using Microsoft Project - enter party
project |
| Project networks |
| Critical path |
| Introducing the degree project |
|
| Review exam (if time permits) |
|
| Handouts
|
| Homework (for next meeting):
| Bender
Construction Co (due next class meeting) Type your name as the first
two words in the first task. Example: "Greg Swan Drafting
Legal Documents" Following the instructions in the handout,
print a copy of the network diagram. Finally,
bring an
electronic copy of Bender to class. |
| Complete draft degree
project task list. |
|
|
16
Mar 21 |
|
| Handouts
|
| Reading (for next meeting):
| Yellow project management handout pgs 313-340 |
|
| Homework (for next meeting):
| Revise draft degree
project degree project task list and enter tasks into MS Project and find critical path.
Print network diagram with critical path. |
| (Paper handout) Haygood Brothers, questions 1 and
2. Use the median time for task durations. Print the
network diagram and include it with your answers. Be sure your
name is included in the first task. |
| Revise Haygood Brothers task durations using PERT.
Print a Gantt chart with task list. Be sure your name is
included in the first task. Bring an electronic copy. |
| (Paper handout) Self-test 1, 2 , 4-6 and 9-14 |
| (Paper handout) Valley United Soccer Club. Be sure your
name is included in the first task. Bring an electronic copy. |
|
|
17
Mar 26 |
|
| Handouts
| See notes to left. Be sure to read and work
through them if you miss class. |
| Fig 8-6 |
|
| Reading (for
next meeting):
| Ragsdale 8.4, 8.4.1 and 8.4.4 |
|
| Homework (for
next meeting):
|
|
18
Mar 28 |
| Review homework |
| Analysis of inventory information |
|
| Handouts
|
| Reading (for
next meeting):
| Ragsdale 8.0 - 8.3, 8.4.2, 8.4.3 |
|
| Homework (for
next meeting):
| none |
|
|
|
19 April 2 |
|
| Handouts
| See notes to left. Be sure to read and work
through them if you miss class. Exam will cover the
"intro" notes. |
| Waner 13.2 #13 is done in class. |
|
Exam study notes for project management |
|
| Homework (for
next meeting):
| None. Study for exam. |
|
|
20
Apr 4 |
| Exam 3
| Requires green scantron |
| You may place any notes you like on a 4x6 index
card (both sides) |
| Covers:
| Project management |
| Probability and simulation |
| Intro to derivatives and nonlinear
programming |
|
|
|
| Handouts |
| Reading (for
next meeting):
|
| Homework (for
next meeting):
| Be sure to print-out copies of your spreadsheets
that include your name. |
| Here's an example one that you might try first:
|
| Waner 13.2 exercises
| 14 (ans: 12 and there are no constraints) and
|
| 15 (ans: 30 and there are no constraints) |
|
| Check out the PowerPoint notes at left. I added
troubleshooting notes that might help you identify problems with
using solver. |
|
|
21
Apr
9 |
|
| Handouts
|
| Reading (for
next meeting):
| Ragsdale 8.10, 8.10.1, 8.10.2, 8.11, 8.8,
8.8.1,8.8.2, 8.8.3, 8.8.4 |
|
| Homework (for
next meeting):
| 13.1 ex 1-12 (I recommend just using a copier to
copy the page and writing your notes on the copy) |
| Work through the problem in the chapter discussed
in 8.8. Make sure you understand the business purpose of the
problem. Problem introduces the idea of optimizing existing
spreadsheets and having the set and variable cells point to the same
cell. Print sensitivity analysis report and bring it to class.
|
| Ch 8 #11 (use GraphCalc above in handouts or a
graphing calculator, if you like) |
| Ch 8 #12. You don't have to modify the
spreadsheet -- just the solver settings. Print sensitivity
analysis report for this one and bring it to class. |
| Optional additional practice:
| Waner 13.2.16 |
| Waner 13.2.21 |
| Waner 13.2.27 |
|
|
|
22
Apr 11 |
|
| Handouts
|
| Reading (for
next meeting):
| Waner 944-969 (multivariable functions) |
|
| Homework (for
next meeting):
| Waner 16.1 1, 2, 19, 20 |
| Waner 16.2 15-18 (follow 3D graphing with Excel
handout above) |
|
|
23
Apr 16 |
|
| Handouts
|
| Reading (for
next meeting):
| Waner 969-972 (partials) |
|
| Homework (for
next meeting):
| Waner 16.3 1, 2, 3, 4, 7, 8, 41, 42, 43, 46 (use derivative
calculator) |
|
|
24
Apr 18 |
|
| Handouts
|
| Reading (for
next meeting):
| Ragsdale work through and understand the problem
in section 8.5. (Requires Premium Solver.) |
| Read Simulation handout (yellow) pgs 586-606.
Class presentation and activities will assume you have read the
material. |
|
| Homework (for
next meeting):
| Waner 16.3 19, 21, 22, 24 |
| Waner 16.4 1, 2, 5, 6, 8, 11, 12, 35, 36
|
|
|
25
Apr 23
|
|
| Handouts
| Yellow simulation handout |
|
| Reading (for next meeting):
|
| Homework (for next meeting):
| Find the Hessian of 1,1 for the
equation 3x2y2 |
| Part of the final exam will be based on Ragsdale
Ch 8 #22. Answer: 11.97, 35.36. Total shipping miles
traveled (the set cell) are 8079.27. It's not required you do
this as homework, but I strongly recommend it. |
| Create a spreadsheet that simulates spinning a
wheel like on wheel of fortune that can have the values 1, 2, 3 or
4. Is this distribution discrete or continuous? Is the
distribution uniform? (See "using probability distributions in
decision modeling handout part 1.)
Bring an electronic copy of your spreadsheet to class. |
|
|
26
Apr
25 |
|
| Handouts
|
| Reading (for
next meeting):
| Read yellow simulation handout, pgs 634-38. |
|
| Homework (for
next meeting):
| Yellow handout, #4. Read the problem, but
follow these instructions:
| a. Set up a table for the probability
distribution, similar to what we did in class. |
| Using the Excel rand() function and vlookup(),
generate a set of 365 sales estimates. |
| At the top of the spreadsheet, sum() all 365
estimates to arrive at total sales of the year. |
| answer spreadsheet |
|
| Yellow handout, #6. Read the problem, but
follow these instructions:
| a. Set up a table for the probability
distribution, similar to what we did in class. |
| Using the Excel rand() function and vlookup(),
generate a set of 500 claims. |
| At the top of the spreadsheet, sum() all 500
claims to arrive at total payments. Use countif() to count
the number of $0 claim payments to arrive at the number of
claims not paid. |
| answer spreadsheet |
| answer spreadsheet |
|
| Yellow handout, #12.
| Set up three probability tables for each of
the three expenses. |
| Use three columns of rand()/vlookup()
calculations, one for each of the three expenses. Sum the
expenses and subtract them from the sales price of $45 to arrive
at the profit. |
| Do 300 simulation rows. |
| At the top of the spreadsheet, use countif()
to count the various profit results ($0-$13). Graph these
results. |
| At the top, calculate the
the average purchase cost, labor cost, transportation cost and
profit? |
| Use countif() to determine how often profit
will be less than $5 per unit. |
| Here is the result of one of my runs:
| average labor cost |
23.25667 |
| average purchase cost |
11.05667 |
| average transport cost |
3.513333 |
| average profit |
7.173333 |
| |
|
|
| probability profit < $5 |
7.33% |
|
| answer spreadsheet
|
|
|
|
27
Apr 30
|
|
| Handouts
|
| Reading (for
next meeting):
|
| Homework (for
next meeting):
| Yellow handout #`14, 18 (be sure to print
spreadsheets) |
|
|
28
May 2 |
| Review homework |
| How
to modify spreadsheet to include probabilities |
| Discuss Final
| Requires green scantron for first 12 questions. |
| May have 4x6 notecard |
| Study notes are at right |
| 1 hour and 50 minutes |
| May use a graphing or scientific calculator.
|
| May NOT use cellphone. |
| May use derivative calculator and Excel with
Premium solver |
| May NOT surf the Internet |
| Contact me asap if you plan to take the exam in
the testing center. |
|
|
| Exam study notes
| NLP with Excel and Premium Solver, including
sensitivity analysis
| Powerpoint NLP
with Excel and Premium Solver |
| Ragsdale Ch8 pgs 344-355 NLP with Excel and
Premium Solver |
| Powerpoint Sensitivity analysis |
| Ragsdale Ch8 pgs 376-379 Sensitivity
analysis |
| Multiple choice questions over the reading. |
| Problem Ragsdale Ch 8 22 Rugger corporation
will be used on the exam. Answer: 11.97, 35.36. Total shipping miles
traveled (the set cell) are 8079.27. Be prepared to answer
questions about the solution spreadsheet and both the answer
and sensitivity analysis reports. Don't obsess over
this. It's more important you understand the meaning of
the various parts of the spreadsheet solution and the reports
than that you have the exactly right answer. A very
similar problem is covered in this powerpoint Multivariate NLP with
constraints and also in Ragsdale Ch8 section 8.5 |
|
| Concepts of working with more than one
variable
| Representing multivariate functions algebraically,
graphically and as tables
|
| Identifying multivariate minima and maxima in
tables and graphically (aka partial derivatives)
|
| Probability theory and risk in
decision-making
|
|
|
|
29
May
9 |
| Final exam |
|
The final exam will be offered
at the following times and locations. If you would like to take the
exam with a different class, ask me.
8:25 MW class 9:00-10:50am Weds May 9 C104
11:15 MW 11:00-12:50pm Weds May 9 C104 |
