Instruction
In sheet “Data table & scenario manager (file 1)”, 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