I need a flexible budget for Metropolis Health Care 33-A

Schedule of Property, Plant, and Equipment (Exhibit Schedule of Patient Revenue (Exhibit 33-6) Schedule of Operating Expenses (Exhibit 33-7) t of Cash e Statement of Changes in Fund Balall fo Balance Sheet Exhibit 33-1 Metropolis Health System Balance Sheet March 31, 2 Liabilities and Fund Balance Current Liabilities Current Maturities of Long-Term Assets $1,150,000 825,000 7,400,000 Current Assets Cash and Cash Equivalents Debt Assets Whose Use Is Limited $525,000 Accounts Payable and Accrued Patient Accounts Receivable To Expenses Bond Interest Payable Reimbursement Settlement (Net of $1,300,000 Allowance 4,900,000 for Bad Debts) Other Receivables Inventories Prepaid Expenses Total Current Assets 300,000 in 150,000 900,000 200,000 10,625,000 100,000 Total Current Liabilities 5,825,000 6,000,000 (525,000) Long-Term Debt Less Current Portion of Assets Whose Use Is Limited Long-Term Debt Net Long-Term Debt Total Liabilities Fund Balances General Fund Corporate Funded 1,950,000 5,475,000 Depreciation Indenture Agrcement 1,425,000 Limited Held by Trustce Under Bond 11,300,000 100,000Matistics a Total Assets Whosc Use Is Total Fund Balances 21,5000 3,375,000 oS Less Current Portion (825,000) Total Liabilities and Fund MEIS Balances $22,800,000 | Net Assets Whose Use Is Limited 2,550,000 Property, Plant, and Equipment, Net Other Assets Total Assets 19,300,000 325,000 $32,800,000 MHS Case Strudy 463 Statement of Revenue and Ex Metropolis Health System Statement of Revenue and Expense for the Year Ended March 31,2 Revenue Net patient service revenue Other revenue $34,000,000 1,100,000 Total Operating Revenue $35,100,000 Expenses Nursing services Other professional services General services Support services Depreciation Amortization Interest Provision for doubtful accounts $5,025,000 13,100,000 3,200,000 8,300,000 1,900,000 50,000 325,000 1,500,000 Total Expenses Income from Operations Nonoperating Gains (Losses) Nonoperating Gains, Net 33,100,000 $1,700,000 0 Unrestricted gifts and memorials $20,000 80,000 Interest income 100,000 0) $1,800,000 e and Gains in Excess of Expenses and Losses ts and O Ho MPIS Nursing Practice an rganizational Structure cal Data (Exhibit 33-8) ecutive-Level Organization n 110spital S ministration Organization Chart (Figure 33-1) Chart (Figure 33-2) Case Study: Metropolis Health System 464 CHAPTER 33 Exhibit 33-3 Statement of Cash Flows Metropolis Health System Statement of Cash Flows for the Year Ended March 31, 2 Statement of Cash Flows nt Operating Activities Income from operations Adjustments to reconcile income from operations $1,700,000 Gen to net cash flows from operating activities Depreciation and amortization 1,950,000 Changes in asset and liability accounts Patient accounts receivable Other receivables Inventories Prepaid expenses and other assets Accounts payable and accrued expenses Reduction of bond interest payable Estimated third-party payer settlements 250,000 (50,000) (50,000) (50,000) (400,000) (25,000) (75,000) 80,000 20,000 Exhibit 33-5 S Interest income received Unrestricted gifts and memorials received Net cash flow from operating activities Buil $3,350,000 Lan Cash Flows from Capital and Related Financing Activities Repayment of long-term obligations (500,000) qu Cash Flows from Investing Activities Purchase of assets whose use is limited (100,000) Equipment purchases and building improvements (20,000 Les Net Increase (Decrease) in Cash and Cash Equivalents$0 Cash and Cash Equivalents, Beginning of Year Cash and Cash Equivalents, End of Year 400,000 Lan $1,150,000 Cor et MHS Case Study 465 ent of Changes in Fund Balance Metropolis Health Systen ement of Changes in Fund Balance for the Year Ended March 31, 2 Ceneral Fund Balance April 1, 2 $19,700,000 1,800,000 $21,500,000 d Gains in Excess f Expenses and I.oses 1 80,00 General Fund Balance March 31,2 s5 Schedule of Property, Plant, and Equipment Metropolis Health System Schedule of Property, Plant, and Equipment for the Year Ended March 31, 2 $14,700,000 1,100,000 28,900,000 $44,700,000 (26,100,000) $18,600,000 480,000 220,000 $19,300,000 Buildings and Improvements Land Improvements Equipment Total Less Accumulated Depreciation Net Depreciable Assets Land Construction in Progress et Property, Plant, and Equipmert Case Study: Metropolis Health System CHAPTER 33 466 Exhibit 33-6 Schedule of Patient Revenue Metropolis Health System Schedule of Patient Revenue for the Year Ended March 31, 2 Set Me Ca OB-Nursery Patient Services Revenue $9,850,000 7,375,000 5,825,000 450,000 3,175,000 Routine revenue Laboratory Radiology and CT scanner OB-nursery Pharmacy Emergency service Medical and surgical supply and IV Operating rooms Anesthesiology Respiratory therapy Physical therapy EKG and EEG Ambulance service Oxygen Home health and hospice Substance abuse Other her 5,050,000 5,250,000 1,600,000 900,000 1,475,000 1,050,000 900,000 575,000 1,675,000 875,000 775,000 Other Profe aboratory Radiology a Pharmacy Operating R to Phy ERG $48,500,000 Subtotal Less allowances and charity care Net Patient Service Revenue (14,500,000 e eA Healt MHS Case Study 467 t 33-7 Schedule of Operating Expenses Metropolis Health System Schedule of Operating Expenses for the Year Ended March 31,2 General Services Dietary Nursing Services ine Medical/Surgical Operating Room Intensive Care Units OB-Nursery Other Total $3,880,000 etary 300,000 Maintenance 395,000 150,000Housekeeping 300,000 $1,055,000 1,000,000 295,000 470,000 50,000 330,000 $3,200,000 Laundry Security Medical Records Total $5,025,000 Other Professional Services Laboratory Radiology and CT Scanner Pharmacy Emergency Service Medical and Surgical Supply Operating Rooms and $2,375,000 1,700,000 1,375,000 950,000 Support Services General $4,600,000 240,000 1,130,000 1,900,000 430,000 $8,300,000 Insurance Payroll Taxes Employce Welfare Other 1,800,000 1,525,000 Total Anesthesia Respiratory Therapy Physical Therapy EKG and EEG Ambulance Service Substance Abuse 525,000 700,000 185,000 80,000 460,000 1,900,000 50,000 Depreciation Amortization Interest Expense Provision for Doubtful 325,000 ome Health and Hospice Other 1,295,000 130,000 Accounts 1,500,000 $13,100,000 Total Total Operating Expenses $33,400,000 Schedule of Property, Plant, and Equipment (Exhibit Schedule of Patient Revenue (Exhibit 33-6) Schedule of Operating Expenses (Exhibit 33-7) t of Cash e Statement of Changes in Fund Balall fo Balance Sheet Exhibit 33-1 Metropolis Health System Balance Sheet March 31, 2 Liabilities and Fund Balance Current Liabilities Current Maturities of Long-Term Assets $1,150,000 825,000 7,400,000 Current Assets Cash and Cash Equivalents Debt Assets Whose Use Is Limited $525,000 Accounts Payable and Accrued Patient Accounts Receivable To Expenses Bond Interest Payable Reimbursement Settlement (Net of $1,300,000 Allowance 4,900,000 for Bad Debts) Other Receivables Inventories Prepaid Expenses Total Current Assets 300,000 in 150,000 900,000 200,000 10,625,000 100,000 Total Current Liabilities 5,825,000 6,000,000 (525,000) Long-Term Debt Less Current Portion of Assets Whose Use Is Limited Long-Term Debt Net Long-Term Debt Total Liabilities Fund Balances General Fund Corporate Funded 1,950,000 5,475,000 Depreciation Indenture Agrcement 1,425,000 Limited Held by Trustce Under Bond 11,300,000 100,000Matistics a Total Assets Whosc Use Is Total Fund Balances 21,5000 3,375,000 oS Less Current Portion (825,000) Total Liabilities and Fund MEIS Balances $22,800,000 | Net Assets Whose Use Is Limited 2,550,000 Property, Plant, and Equipment, Net Other Assets Total Assets 19,300,000 325,000 $32,800,000 MHS Case Strudy 463 Statement of Revenue and Ex Metropolis Health System Statement of Revenue and Expense for the Year Ended March 31,2 Revenue Net patient service revenue Other revenue $34,000,000 1,100,000 Total Operating Revenue $35,100,000 Expenses Nursing services Other professional services General services Support services Depreciation Amortization Interest Provision for doubtful accounts $5,025,000 13,100,000 3,200,000 8,300,000 1,900,000 50,000 325,000 1,500,000 Total Expenses Income from Operations Nonoperating Gains (Losses) Nonoperating Gains, Net 33,100,000 $1,700,000 0 Unrestricted gifts and memorials $20,000 80,000 Interest income 100,000 0) $1,800,000 e and Gains in Excess of Expenses and Losses ts and O Ho MPIS Nursing Practice an rganizational Structure cal Data (Exhibit 33-8) ecutive-Level Organization n 110spital S ministration Organization Chart (Figure 33-1) Chart (Figure 33-2) Case Study: Metropolis Health System 464 CHAPTER 33 Exhibit 33-3 Statement of Cash Flows Metropolis Health System Statement of Cash Flows for the Year Ended March 31, 2 Statement of Cash Flows nt Operating Activities Income from operations Adjustments to reconcile income from operations $1,700,000 Gen to net cash flows from operating activities Depreciation and amortization 1,950,000 Changes in asset and liability accounts Patient accounts receivable Other receivables Inventories Prepaid expenses and other assets Accounts payable and accrued expenses Reduction of bond interest payable Estimated third-party payer settlements 250,000 (50,000) (50,000) (50,000) (400,000) (25,000) (75,000) 80,000 20,000 Exhibit 33-5 S Interest income received Unrestricted gifts and memorials received Net cash flow from operating activities Buil $3,350,000 Lan Cash Flows from Capital and Related Financing Activities Repayment of long-term obligations (500,000) qu Cash Flows from Investing Activities Purchase of assets whose use is limited (100,000) Equipment purchases and building improvements (20,000 Les Net Increase (Decrease) in Cash and Cash Equivalents$0 Cash and Cash Equivalents, Beginning of Year Cash and Cash Equivalents, End of Year 400,000 Lan $1,150,000 Cor et MHS Case Study 465 ent of Changes in Fund Balance Metropolis Health Systen ement of Changes in Fund Balance for the Year Ended March 31, 2 Ceneral Fund Balance April 1, 2 $19,700,000 1,800,000 $21,500,000 d Gains in Excess f Expenses and I.oses 1 80,00 General Fund Balance March 31,2 s5 Schedule of Property, Plant, and Equipment Metropolis Health System Schedule of Property, Plant, and Equipment for the Year Ended March 31, 2 $14,700,000 1,100,000 28,900,000 $44,700,000 (26,100,000) $18,600,000 480,000 220,000 $19,300,000 Buildings and Improvements Land Improvements Equipment Total Less Accumulated Depreciation Net Depreciable Assets Land Construction in Progress et Property, Plant, and Equipmert Case Study: Metropolis Health System CHAPTER 33 466 Exhibit 33-6 Schedule of Patient Revenue Metropolis Health System Schedule of Patient Revenue for the Year Ended March 31, 2 Set Me Ca OB-Nursery Patient Services Revenue $9,850,000 7,375,000 5,825,000 450,000 3,175,000 Routine revenue Laboratory Radiology and CT scanner OB-nursery Pharmacy Emergency service Medical and surgical supply and IV Operating rooms Anesthesiology Respiratory therapy Physical therapy EKG and EEG Ambulance service Oxygen Home health and hospice Substance abuse Other her 5,050,000 5,250,000 1,600,000 900,000 1,475,000 1,050,000 900,000 575,000 1,675,000 875,000 775,000 Other Profe aboratory Radiology a Pharmacy Operating R to Phy ERG $48,500,000 Subtotal Less allowances and charity care Net Patient Service Revenue (14,500,000 e eA Healt MHS Case Study 467 t 33-7 Schedule of Operating Expenses Metropolis Health System Schedule of Operating Expenses for the Year Ended March 31,2 General Services Dietary Nursing Services ine Medical/Surgical Operating Room Intensive Care Units OB-Nursery Other Total $3,880,000 etary 300,000 Maintenance 395,000 150,000Housekeeping 300,000 $1,055,000 1,000,000 295,000 470,000 50,000 330,000 $3,200,000 Laundry Security Medical Records Total $5,025,000 Other Professional Services Laboratory Radiology and CT Scanner Pharmacy Emergency Service Medical and Surgical Supply Operating Rooms and $2,375,000 1,700,000 1,375,000 950,000 Support Services General $4,600,000 240,000 1,130,000 1,900,000 430,000 $8,300,000 Insurance Payroll Taxes Employce Welfare Other 1,800,000 1,525,000 Total Anesthesia Respiratory Therapy Physical Therapy EKG and EEG Ambulance Service Substance Abuse 525,000 700,000 185,000 80,000 460,000 1,900,000 50,000 Depreciation Amortization Interest Expense Provision for Doubtful 325,000 ome Health and Hospice Other 1,295,000 130,000 Accounts 1,500,000 $13,100,000 Total Total Operating Expenses $33,400,000