| Med/Surg Department Budget |
| | Current YTD (Jul - Dec) Actuals | Current Year's Total Budget | Current Year's Variance YTD | Estimate Current Total Year's Actuals | Next Year's Budget |
| OPERATING REVENUE: |
| Inpatient Revenue | $ 23,123,516 | $ 50,000,000 | $ (1,876,484) |
| TOTAL PATIENT SERVICES REVENUE | $ 23,123,516 | $ 50,000,000 | $ (1,876,484) |
| OPERATING EXPENSES |
| Salaries and Wages | $ 12,157,632 | $ 23,000,000 | $ 657,632 |
| Employee Benefits | $ 3,040,408 | $ 5,750,000 | $ 165,408 |
| Professional Fees | $ 250,160 | $ 400,000 | $ 50,160 |
| Supplies | $ 5,883,497 | $ 10,000,000 | $ 883,497 |
| Purchased Services - Utilities | $ 27,456 | $ 50,000 | $ 2,456 |
| Purchased Services - Other | $ 23,484 | $ 50,000 | $ (1,516) |
| Insurance | $ 57,315 | $ 105,000 | $ 4,815 |
| License and Taxes | $ 21,456 | $ 40,000 | $ 1,456 |
| Other Direct Expenses | $ 972,157 | $ 1,500,000 | $ 222,157 |
| TOTAL OPERATING EXPENSES | $ 22,433,565 | $ 40,895,000 | $ 1,986,065 |
| NET REVENUE OR (EXPENSE) | $ 689,951 | $ 9,105,000 | $ (3,862,549) |
| IMPORTANT |
| 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. |
asher87
medicalsurgicaldepartmentbudget.xlsx
