sensitivity analysis 2 | exclusivewritings.com

sensitivity analysis 2  | exclusivewritings.com

In sheet “Data table & scenario manager”, create a two-input data table as a sensitivity analysis. We want to explore how purchasing price and tax rate together affect after-tax income.

Show After-tax income as a function of purchasing price ($5, $6, …$13) and tax rate (30%, 32%, …40%).

Submit only 1 sheet, instead of the entire file. Please use the rubric below to guide the development of your assignment.

M1 Assignment – Sensitivity Analysis Rubric
Successfully created ranges for 2 input variables 1 pt
Successfully linked the result cell 0.5 pt
Successfully completed the data table 3 pts
Formatted and labeled cells appropriately 0.5 pt
Total 5 pts

Rubric

M1A1

Criteria Ratings Pts

This criterion is linked to a Learning OutcomeSuccessfully created ranges for 2 input variables

1.0 pts

Full Marks

0.0 pts

No Marks

1.0 pts

This criterion is linked to a Learning OutcomeSuccessfully linked the result cell

0.5 pts

Full Marks

0.0 pts

No Marks

0.5 pts

This criterion is linked to a Learning OutcomeSuccessfully completed the data table

3.0 pts

Full Marks

0.0 pts

No Marks

3.0 pts

This criterion is linked to a Learning OutcomeFormatted and labeled cells appropriately

0.5 pts

Full Marks

0.0 pts

No Marks

0.5 pts

Total Points: 5.0

 

| exclusivewritings.com