AutoSave . Off) cf_medsurg_dept_budget Search (Alt+Q) Barrett, Kaitlan BK X File Home Insert Draw Page Layout Formulas Data Review View Help Comments 15 Share X Cut Calibri 11 ~ A A ab Wrap Text General Normal Bad Good AutoSum AY O Paste [G Copy Fill E Merge & Center $ ~ % 9 00 20 Conditional Format as Neutral Calculation Check Cell Insert Delete Format Sort & Find & Analyze Sensitivity Format Painter Formatting Table Clear ~ Filter ~ Select Dat Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity A21 X V You MUST complete the "Estimate Current Total Year's Actuals" and the "Next Year's Budget" columns. You will use information in the 1st three columns to calculate the last 2 columns. B D H M N P Q R S V W X Y 2 AA AB AC AD AE AF Med/Surg Department Budget Current YTD Current Current Estimate (Jul - Dec) Year's Total Current Total Next Year's Year's Actuals Budget Variance YTD Year's Actuals Budget OPERATING REVENUE -DM A W N Inpatient Revenue $ 23,123,516 $ 50,000,000 $ (1876,484] 40,353,384 $ 47.500,000 CTA = 50.000.000-1.876.484 = 48.123.516 AL PATIENT SERVICES REVENUE 23,123,516 $ 50,000,000 [1,876,484) 48,559.384 47,500,000 NYB = 50,000,000-2,500,000 = 47,500,000 OPERATING EXPENSES Salaries and Wages $ 12.157,632 $ 23,000,000 57,632 $ 24,315,263 $ 21,850,000 Employee Benefits 3,040,408 $ 5,750,000 65,408 $ 6,080,816 $ .462,500 Professional Fees 250,160 $ 400,000 $ 50,160 $ 500,320 $ 380,000 10 Supplies 5.883,497 $ 10,000,000 83.497 $ 11,766,994 9,500,000 11 Purchased Services - Utilities 27 456 $ 50,000 2.456 $ 54.912 $ 47.500 12 Purchased Services - Other 3.484 $ 50,000 1,516) $ 46,968 44,620 13 Insurance 57.315 $ 105,000 $ 4.815 $ 114,630 $ 108.899 14 License and Taxes 21.456 $ 40,000 $ 1,456 $ 42,912 $ 40,766 15 Other Direct Expenses 972,157 $ 1,500,000 222,157 $ 1,944 312 $ 1,847,098 16 TOTAL OPERATING EXPENSES $ 22.433.565 $ 40,895,000 $ 1,986,065 $ 44,867,310 $ 39,281,383 17 18 NET REVENUE OR [EXPENSE) 689,951 $ 9.105.000 $ (3.862.549) $ 3.692,074 $ 8,218.617 19 20 IMPORTANT You MUST complete the "Estimate Current Total Year's Actuals" and the "Next Year's Budget" columns. You will use information in the Ist three columns to calculate the last 2 columns. Sheet1 D Ready Accessibility: Good to go + 72% M W X O V 3:23 PM Type here to search 5/6/2022 712