Healthcare Financial Management and Economics Week 9 Assignment Budgeting
The following are budgeted and actual revenues and expenses for a hospital. ______________________________________________________________________________ Budgeted Actual Revenues Surgical Volume 2,500 2800 Gift Shop Revenues $19,500 $22,200 Surgery Revenues $590,500 $850,000 Parking Revenues $18,500 $21,800 Expenses Patients Days 28,000 26,000 Pharmacy $123,000 $155,000 Misc Supplies $695,000 $790,000 Fixed Overhead Costs $840,000 $875,000 Using an Excel spreadsheet to show your calculations: 1....