Description
look at the attached file
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello dfdf44,I have attached the completed assignment, as well as a summary (included below), Please review the files and let me know if any modifications need to be made.Assignment – What if Scenario Analysis - Overview There are two files included in the response: Assignment – What if Scenario Analysis.xlsxIt has the requested spreadsheet with the appropriate calculations.It also includes a second spreadsheet with the requested Scenario Analysis.Assignment – What if Scenario Analysis.docxThis document contains the questions and answers for the final items indicated in the assignment instructions.
Scenario Summary
Current Values:
3% Increase in Pay Rate
Changing Cells:
$H$12
5%
3%
Result Cells:
$C$22 $
8,690.00 $
8,690.00
$E$22 $
9,124.50 $
8,950.70
$H$14 $
434.50 $
260.70
$H$20 $
22,594.00 $
13,556.40
...