Tasked by management to prepare a monthly cost analysis of the corporate operating expenses as shown in the attached spreadsheet. Management is particularly interested in identifying the ten highest expenses on a percentage basis. Since the expenses change monthly you will need to add a sheet to identify the top ten expenses each month. The expenses are shown in the attached form.
- Explain the formulas that you would use for the Dollar Difference (Difference($)), Percentage Difference (Difference(%)), Total Expenses, and appropriate format for each. (20 points)
- Explain how you would sort the Expenses to highlight the Top Ten Expenses on a percentage basis. (10 points)
- Explain how you would retrieve the Top Ten Expenses on a separate worksheet for an executive summary email that you will send to management. (10 points)