Employees are planning next year's budget for the Accounts Payable Department. A study was done of how the work could be improved and costs reduced. The conclusion was that the office should operate with a supervisor and only two clerks, rather than the four clerks employed in the department last year. State-of-the-art software and equipment was purchased to help two clerks do the work formerly done by four clerks.

Last year's Expenses

Salaries - 133,000 Supplies - 4,000 Repairs and Maintenance - 5,000 Depreciation 3,000 Telephone - 3,500

Proposed budget

Salaries - 196,000 Supplies - 3,800 Repairs and Maintenance - 2,500 Depreciation 6,000 Telephone - 3,900

Using your Office 365 Excel program, create a new spreadsheet.Calculate the total expenses for the department for last year.Using last year's figures, calculate the percentage of total expenses each of the expense items represents. Round percentages to one decimal place.Calculate the difference in total expenses between last year's figures and the proposed budget.Calculate the percentage decrease in total expenses if the proposed budget is used.Proofread and edit the document to correct errors in spelling, punctuation, and word usage.