BIAM 500 Week 2 Lab DeVry

Want create site? With you can do it easy.

BIAM 500 Week 2 Lab DeVry

BIAM 500 Week 2 Lab

Rubric-500

Week 2 Lab Rubric-500
Criteria Ratings Pts

Step 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

Step 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

Step 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

Step 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

Step 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.
Did you find apk for android? You can find new and apps.

Do you need a similar assignment written for you from scratch? We have qualified writers to help you. You can rest assured of an A+ quality paper that is plagiarism free. Order now for a FREE first Assignment! Use Discount Code "FREE" for a 100% Discount!

NB: We do not resell papers. Upon ordering, we write an original paper exclusively for you.

Order New Solution