Assignment task: BUDGET PREPARATION
You have been assigned the task of completing the proposed budget for the next fiscal year which is from January-December. You have the previous year's budget which includes salaries and other expenses. You need to use this historical data and other budget assumptions as stated below to prepare your department's budget for 2020. (Yes, I know we are already in April, 2020, but this makes it easier to find the information you need to enter into the budget.) Additional documentation must be submitted for many of the questions. Please provide the additional documentation as a Word document. The budget itself must be in Excel. The final Excel spreadsheet must include your new budgeted figures broken down by month with a total for the year. I will be checking formulas, so be sure and include them in appropriate cells. Be sure and use your budget assumptions in your calculations. Your spreadsheet should look something like this (this is an example): Proposed Budget for Griffon Hospital, 2020 Expense category Jan Feb Mar Apr and so forth Any notes 510000 Salaries 515000 Audit Expense and so forth