Question: 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
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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
