Data provided above
- Draft suggestions fro enhancing profitability including changes in volume, revenue, enhancements, and/or cost reductions.
- Restate the flexible budget for actual volumes assuming the 2023 fiscal year has ended and actual inpatient discharges and outpatient encounters are 12,260 and 610,233.
Chapter 33 - Budgeting Table 33.1, Barton Medical Center Rejected Incremental Budget (millions) \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Table 33.1, Barton Medical Center Rejected Incremental Budget (millions) } \\ \hline & & & & 2022 YTD & 2023 & 2023 \\ \hline & 2022 & 2022 YTD & 2022 YTD & Actual & Inflation & Incremental \\ \hline Revenue & Budget & Actual & Budget & Annualized & Factor & Budget \\ \hline Inpatient revenue & $123.656 & $60.500 & $61.828 & $121.000 & 2.0% & $123.420 \\ \hline Outpatient revenue & 145.530 & 73.400 & 72.765 & 146.800 & 4.0% & 152.672 \\ \hline Other revenue & 11.550 & 5.400 & 5.775 & 10.800 & 4.0% & 11.232 \\ \hline Total Revenue & $280.736 & $139.300 & $140.368 & $278.600 & & $287.324 \\ \hline \multicolumn{7}{|l|}{ Expenses } \\ \hline Salaries & $115.257 & $58.900 & $57.600 & $117.800 & 3.0% & $121.334 \\ \hline Fringe benefits & 24.720 & 13.300 & 12.540 & 26.600 & 6.0% & 28.196 \\ \hline Supplies & 56.135 & 27.600 & 28.100 & 55.200 & 2.0% & 56.304 \\ \hline Rent & 3.708 & 1.900 & 1.900 & 3.800 & 0.0% & 3.800 \\ \hline Depreciation & 11.948 & 5.900 & 6.000 & 11.800 & 0.0% & 11.800 \\ \hline Interest & 6.695 & 3.200 & 3.300 & 6.400 & 2.0% & 6.528 \\ \hline Other expense & 50.161 & 25.500 & 25.100 & 51.000 & 3.0% & 52.530 \\ \hline Total Expense & $268.624 & $136.300 & $134.540 & $272.600 & & $280.492 \\ \hline & & & & & & \\ \hline Net income & $12.112 & $3.000 & $5.828 & $6.000 & & $6.832 \\ \hline Discharges & 12,530 & 6,166 & 6,265 & -99 & 1.58% & 12,200 \\ \hline O/P Encounters & 599,766 & 299,545 & 299,883 & -338 & 0.11% & 611,072 \\ \hline \multicolumn{7}{|c|}{ Table 33.2, YTD Financial Performance by Revenue (Inpatient and Outpatient) Line (millions) } \\ \hline & 2022 & 2022 & 2022 & 2022 & & \\ \hline & I/P Actual & 1/P Budget & O/P Actual & O/P Budget & & \\ \hline Total Revenue & $60.500 & $61.828 & $73.400 & $72.765 & & \\ \hline & & & & & & \\ \hline \multicolumn{7}{|l|}{ Expenses } \\ \hline Salaries & $27.043 & $26.446 & $31.857 & $31.154 & & \\ \hline Fringe benefits & 6.107 & 5.779 & 7.193 & 6.761 & & \\ \hline Supplies & 12.672 & 12.902 & 14.928 & 15.198 & & \\ \hline Rent & 0.872 & 0.872 & 1.028 & 1.028 & & \\ \hline Depreciation & 2.709 & 2.755 & 3.191 & 3.245 & & \\ \hline Interest & 1.469 & 1.515 & 1.731 & 1.785 & & \\ \hline Other expense & 11.708 & 11.524 & 13.792 & 13.576 & & \\ \hline Total Expense & $62.581 & $61.794 & $73.719 & $72.746 & & \\ \hline Net income & $2.081 & $0.034 & $0.319 & $0.019 & & \\ \hline Profit margin & 3.44% & 0.05% & 0.44% & 0.03% & & \\ \hline & & & & & & \\ \hline Discharges & 6,166 & 6,265 & & & & \\ \hline O/P Encounters & & & 299,545 & 299,883 & & \\ \hline & & & & & & \\ \hline \end{tabular}