BIAM 500 Week 2 Lab DeVry

BIAM 500 Week 2 Lab DeVry
BIAM 500 Week 2 Lab
Rubric-500
Week 2 Lab Rubric-500
Criteria Ratings Pts
This criterion is linked to a Learning OutcomeStep 1: Creation of Formulas with Constraints
Touring Bike Model Mix sheet has correct set up of problem with all parameter values, constraints, and formulas.
15.0 pts
This criterion is linked to a Learning OutcomeStep 2: Use Solver to find an optimal solution.
Objectives, variables, constraints, and solution method are correctly set in the Solver dialog, and the correct optimal production quantities are shown on the Touring Bike Model Mix sheet. Answer, sensitivity, and limits reports for the solution were generated correctly.
15.0 pts
This criterion is linked to a Learning OutcomeStep 3: Perform Sensitivity Analysis
Perform sensitivity analysis showing how changing parameters by plus or minus 10% affects the solution. A scenario summary sheet was created showing how the optimal product mix is affected by changing the gross profit per unit of each model by plus or minus 10% compared to the original solution.
15.0 pts
This criterion is linked to a Learning OutcomeStep 4: Create Monte Carlo Simulation
Monte Carlo simulation calculates and charts the average gross profit over 100 simulations for the specified range of production quantities.
15.0 pts
This criterion is linked to a Learning OutcomeStep 5: Opinion Paper
Write a one-page paper explaining your findings and making recommendations. Paper is in APA format, free of typographical, spelling, and grammar errors, and clearly states appropriate findings and recommendations from the analysis.