calculate the Break Even Adjusted Admissions

	Rasmussen Community Hospital
	Budget Analysis Worksheet
	12/31/2022
					(F) Favorable
	Budget	Actual	Variance	Variance %	(U) Unfavorable
Net Revenues	$ 13,500,000	$ 15,400,000	$ 1,900,000.00	14%	F
Expenses
Salaries	$ 5,400,000	$ 6,160,000	$ 760,000.00	14%	U
Benefit	1,350,000	1,540,000	$ 190,000.00	14%	U
Supplies	3,375,000	3,850,000	$ 475,000.00	14%	U
Utilities	741,000	775,000	$ 34,000.00	5%	U
Rent	66,000	66,000	$ -	0%	F
Depreciation	1,325,000	1,325,000	$ -	0%	F
Insurance	476,000	476,000	$ -	0%	F
Other	212,000	210,000	$ 2,000.00	1%	F
Total Expense	$ 12,945,000	$ 14,402,000	$ 1,457,000.00	11%	U
Net Income	$ 555,000	$ 998,000	$ 443,000.00	80%	F
Statistical Information
Adjusted Admission	1,350	1,400	50	4%
Break Even Analysis:
		Actual	Per Adjusted Admission
Net Revenue		$ 15,400,000
Variable Costs		12,535,000
Contribution Margin
Fixed Costs		1,867,000
Net Income*		$ 998,000
*Should match Income Statement
Break Even Formula:
Break Even Adjusted Admissions