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.

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper