Homework help

desond
2009Variance1.xlsx

Sheet1

Patton - Fuller Community Hospital
Operating Budget Variance Report 2009
2009 Projected 2009 (9 months actual data projected to 12 months) Variance
Revenues
Net Patient Revenue $447,805 $459,900 3%
Other Revenue $3,225 $3,082 -4%
Total Revenues $451,030 $462,982 3%
Expenses
Salaries and benefits $220,553 $220,752 0%
Supplies $73,487 $74,584 1%
Physician and professional fees $110,277 $110,376 0%
Utilities $1,222 $1,200 -2%
Other $1,838 $1,840 0%
Depreciation & Amorization ("non-cash" expenses) $29,946 $36,036 20%
Interest $3,705 $3,708 0%
Provision for doubtful accounts $14,721 $13,797 -6%
Total Expenses $455,749 $462,293 1%
Operating Income ($4,719) $689 P
Non-operating Income (Loss)
Investment income $304 ($62) -120%
Net Income ($4,416) $627 P

Sheet2

Sheet3