For Expert_Researcher ONLY! Assignment 4-5
Mr1970B
Assessment4-5Sample_Operating_Budget.xlsx
Sheet1
| | 2015 Actual | 2016 Budget | 2017 Projected |
| SALARIES & BENEFITS: |
| Salaries | $ 762,348 | $ 838,583 |
| Overtime | $ 48,245 | $ 53,070 |
| Shift Differential | $ 92,456 | $ 101,702 |
| FICA | $ 68,125 | $ 74,938 |
| Health Insurance | $ 58,463 | $ 64,309 |
| Pension | $ 43,572 | $ 47,929 |
| SUB-TOTAL | $ 1,073,209 | $ 1,180,530 | $ - 0 |
| OPERATING EXPENSES: |
| Office Supplies | $ 10,214 | $ 11,235 |
| Patient Care Supplies | $ 45,215 | $ 49,737 |
| Travel & Training | $ 8,456 | $ 9,302 |
| Memberships | $ 1,512 | $ 1,663 |
| Equipment Repair | $ 10,215 | $ 11,237 |
| Rentals & Leases | $ 2,572 | $ 2,829 |
| Miscellaneous | $ 450 | $ 495 |
| SUB-TOTAL | $ 78,634 | $ 86,497 | $ - 0 |
| TOTAL COSTS | $ 1,151,843 | $ 1,267,027 | $ - 0 |
