Using the sheet provided, you will then build a budget on last year revenue and expense by creating it on excel. be sure to review the revenue and expense for Dec 19 and Dec 20 to determine what best fit the department needs for next year. making sure to label everything for the budget in excel

A 4 Revenue 5 Net patient service revenue 6 Total operating revenue. 7 8 Operating Expenses 9 Medical/surgical services 10 In office procedure 11 Professional Services 12 Support Services 13 General Services 14 Depreciation 15 Interest B 16 17 Total operating expense 18 Income from Operations 19 20 Nonoperating Gains (loses) 21 Interest Income 22 23 Net nonoperating gains 24 25 Revenue and Gains in Excess of 26 Expenses and Losses 27 Increase in Unrestricted Fund Balance C 600,000 860,000 -80,000 220,000 65,000 40,000 20,000 5,000. D 20-Dec 2,000,000 2,000,000 1,885,000 1,885,000 115,000 5,000 120,000 120,000 E 575,000 806,000 75,000 220,000 60,000 40,000 24,000 2,000 F 19-Dec 1,850,000 1,850,000 1,800,000 1,800,000 50,000 2,000 52,000 52,000 G H