ouring Bike Model Mix sheet has correct set up of problem with all parameter values, constraints,


Just Click on Below Link To Download This Course:
https://bit.ly/2E4iviz

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.
10.0 pts
Total Points: 70.0

Comments

Popular Posts