Question: Budgeting Select an organization; either Metropolis Health System from the Case Study or one of the organizations presented in either or one of the three
Budgeting Select an organization; either Metropolis Health System from the Case Study or one of the organizations presented in either or one of the three Mini-Case Studies. Using the organization selected, create a budget for the next fiscal year. Set out the details of all assumptions you needed in order to build this budget. Use the Checklist for Building a Budget and critique your own budget. In short, you will submit an excel sheet for your budget and a word document with your list of assumptions.
| Assignment Exercise 13-2 Trend Analysis | ||||
| Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31, 20X3 and 20X2 | ||||
| Year 2 | Year 1 | Difference | Percent | |
| Revenue | ||||
| Net patient service revenue | 34,000,000 | 33,600,000 | 400,000 | 1.19% |
| Other revenue | 1,100,000 | 1,000,000 | 100,000 | 10% |
| Total Operating Revenue | 35,100,000 | 34,600,000 | 500,000 | 1.44% |
| Expenses | ||||
| Nursing services | 5,025,000 | 5,450,000 | 425,000 | 7.79% |
| Other professional services | 13,100,000 | 12,950,000 | 150,000 | 1.15% |
| General services | 3,200,000 | 3,220,000 | 20,000 | 0.62% |
| Support services | 8,300,000 | 8,340,000 | 40,000 | 0.47% |
| Depreciation | 1,900,000 | 1,800,000 | 100,000 | 5.55% |
| Amortization | 50,000 | 50,000 | 0 | 0% |
| Interest | 325,000 | 350,000 | 25,000 | 7.14% |
| Provision for doubtful accounts | 1,500,000 | 1,600,000 | 100,000 | 6.25% |
| Total Expenses | 33,400,000 | 33,760,000 | 360,000 | 1.06% |
| Income from Operations | 1,700,000 | 840,000 | 860,000 | 101.19% |
| Nonoperating Gains (Losses) | ||||
| Unrestricted gifts and memorials | 20,000 | 70,000 | 50,000 | 71.42% |
| Interest income | 80,000 | 40,000 | 40,000 | 100% |
| Nonoperating Gains Net | 100,000 | 110,000 | 10,000 | 9.09% |
| Revenues and Gains in Excess of Expenses and Losses | 1,800,000 | 950,000 | 850,000 | 89.48% |
Step by Step Solution
3.54 Rating (157 Votes )
There are 3 Steps involved in it
Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31 20X3 and 20X... View full answer
Get step-by-step solutions from verified subject matter experts
