| | PROJECTED DEPARTMENTAL BUDGET | Dec 16 YTD | 2017 Budget |
| Gross revenue |
| Initial revenue |
| | Per Diem ( $4,000 per patient day) | $ 12, 480, 000 | 12, 480, 000 |
| | DRG (Diagnostic Related Group- $5,000 per procedure | 4, 800, 000 | 4, 800, 000 |
| Outpatient Revenue |
| | Infusion (CPT-code) | 1, 296, 000 | 1, 324, 800 |
| | Radiology (CPT-Code | 2, 880, 000 | 3, 312, 000 |
| | Other Revenue | 1, 850, 000 | 1, 850, 000 |
| | TotalGrossPatientServicesRevenue | 24, 266, 000 | 24, 846, 800 |
| Contractural Allowance | | 3,842, 280 | 3, 950, 000 |
| | Total Net Patient Services Revenue | $ 20, 423, 720 | 20, 896, 8000 |
| Expenses |
| Salaries |
| | MD | $ 2,500,000 | 2, 500, 000 |
| | RN | $ 800,000 | 800, 000 |
| | LPN | $ 350, 000 | 350, 000 |
| | Other staff | $ 180, 000 | 180, 000 |
| | per diem Cost (staffing) | 360, 000 | 360, 000 |
| | fringe benefits | 2, 770, 000 | 2, 770, 000 |
| | Travel | 45, 000 | 50, 000 |
| | Total Salary Expense | $ 7, 005, 000 | 7, 010, 000 |
| Supplies |
| | Medical supplies | 485, 000 | 495, 000 |
| | Office supplies | 265, 000 | 266, 000 |
| | Toatl Supplies | 750, 000 | 761, 000 |
| Other Supplies |
| | Equipment | $ 250, 000, 000 | 150, 000 |
| | Legal Fees | $ 108, 786 | 110, 000 |
| | Professional Fees | 152, 288 | 153, 000 |
| | Utilities | 497, 694 | 498, 000 |
| | Repairs and Maintenance | 506, 984 | 508, 000 |
| | Equipement Lease | 183, 509 | 182, 509 |
| | Insurance | 154, 996 | 154, 996 |
| | Depreciation and Amortization | 40, 334 | 39, 500 |
| | Miscellaneous Expense | 15, 500 | 15, 500 |
| | Bad Debt Expense | 80, 000 | 80, 000 |
| | Total Other Expenses | $ 1, 739, 591 | 1, 741, 505 |
| | Total all Expenses | $ 8, 744, 591 | 8, 751, 505 |
Zambia892
5-2FinalProject-MilestoneTwoexcel.xlsx
