I am starting this assignment tonight but do not really know where to start, so all work shown would be really helpful!

Using the information contained in Chapters 13-15, you will need to perform some analysis and budgeting for this assignment. You will find 3 tabs in the attached spreadsheet.

Tab 1: You will need to common size a Statement of Revenues and Expenses

Tab 2: You will need to complete trend analysis on a Statement of Revenues and Expenses.

Tab 3: You will need to make some assumptions and create a budget. There are also a few questions that will need to be answered in addition.

Common Sizing- 8 points Refer to the Metropolis Health System's Statement of Revenue and Expenses on page 407. For full credit, you are required to common size the MHS Statement of Revenue and Expenses. Trend Analysis- 8 points Refer to the Metropolis Health System's Statement of Revenue and Expenses on page 407. For full credit, you are required to perform trend analysis on the MHS Statement of Revenue and Expenses. Budgeting- 9 points Please prepare a budget for MHS's upcoming fiscal year. Some of the findings through common sizing and trend analysis may be helpful in determining the budget. This will require you to make some general assumptions. Please make note of these assumptions as you are working through developing the budget. You will also need to answer the following questions. You may need to make assumptions while you are working through the answers. 1. What is the proposed volume for the new budget period? 2. What is the appropriate inflow (revenues) and outflow (cost of services delivered) relationship? 3. What will the the appropriate dollar cost be? 3a. Forecast service-related workload 3b. Forecast non-service-related workload 3c. Forecast special project workload if applicable 3d. Coordinate assumptions for proportionate share of interdepartmental projects 4. Will additional resources be available? 5. Will this budget accomplish the appropriate managerial objectives for the organization