Health Budgeting
Sheet1
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) | $ 71,247,032 | $ 67,684,680 |
TOTAL PATIENT SERVICES REVENUE | $ 23,123,516 | $ 50,000,000 | $ (1,876,484) | $ 71,247,032 | $ 67,684,680 |
OPERATING EXPENSES | $ – 0 | ||||
Salaries and Wages | $ 12,157,632 | $ 23,000,000 | $ 657,632 | $ 35,815,264 | $ 34,024,501 |
Employee Benefits | $ 3,040,408 | $ 5,750,000 | $ 165,408 | $ 8,955,816 | $ 8,508,025 |
Professional Fees | $ 250,160 | $ 400,000 | $ 50,160 | $ 700,320 | $ 665,304 |
Supplies | $ 5,883,497 | $ 10,000,000 | $ 883,497 | $ 16,766,994 | $ 15,928,644 |
Purchased Services – Utilities | $ 27,456 | $ 50,000 | $ 2,456 | $ 79,912 | $ 75,916 |
Purchased Services – Other | $ 23,484 | $ 50,000 | $ (1,516) | $ 71,968 | $ 68,370 |
Insurance | $ 57,315 | $ 105,000 | $ 4,815 | $ 167,130 | $ 158,774 |
License and Taxes | $ 21,456 | $ 40,000 | $ 1,456 | $ 62,912 | $ 59,766 |
Other Direct Expenses | $ 972,157 | $ 1,500,000 | $ 222,157 | $ 2,694,314 | $ 2,559,598 |
TOTAL OPERATING EXPENSES | $ 22,433,565 | $ 40,895,000 | $ 1,986,065 | $ 65,314,630 | $ 62,048,899 |
NET REVENUE OR (EXPENSE) | $ 689,951 | $ 9,105,000 | $ (3,862,549) | $ 5,932,402 | $ 5,635,782 |
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. |
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper
Get Answer Over WhatsApp Order Paper Now