Info project 4

Unacceptable - 10 points

Acceptable – 20 points

Excellent - 30 points

· No dashboard

· Dashboard information is inaccurate

· Dashboard is basically a copy of the example.

· Missing a few of these things, or these are not clearly described, or these are inaccurate, but overall acceptable

· Clear instructions on how to use the optimization created.

· Instructions on what things the Manager could change

· Instructions on how you created it

· Well organized, well labeled, easy to use, and easy to understand

· Highlights important aspects

· Visually appealing

Unacceptable – 20 points

Acceptable – 30 points

Excellent - 45 points

(5 points each)

· No part 1

· Information is inaccurate

· Missing a few of these things, or these are not clearly described, or these are inaccurate, but overall acceptable

· Correct objective function

· Correct cost/profit calculations

· Correct constraints

· Correct boxes made

· Identifies how many boxes of each tea will be produced

· Identifies how much of each ingredient will be left over in inventory

· Identifies the limiting factor(s)

· Gives suggestions to manager

· Worksheet has proper validation constraints

Unacceptable – 20 points

Acceptable – 30 points

Excellent - 45 points

(5 points each)

· No part 2

· Information is inaccurate

· Missing a few of these things, or these are not clearly described, or these are inaccurate, but overall acceptable

· Correct objective function

· Correct cost/profit calculations

· Correct constraints

· Correct boxes made

· Identifies how many boxes of each tea will be produced

· Identifies how much of each ingredient will be left over in inventory

· Identifies the limiting factor(s)

· Gives suggestions to manager

· Worksheet has proper validation constraints