Understand the results
Understand the results
OutcomeYou can explain the dashboard without folding hours, the balance, and reserve growth into one yes or no.
The dashboard shows five measures. Three of them answer different questions. Do not fold them into one yes or no.
Three readings, kept apart
Reading 1
Hours test
Do planned care hours fit the funded hours?
Planned care hourscompared withfunded hours
Over funded hours is a warning. It does not reject the plan, and it does not decide the budget.
Reading 2
Operating balance
Do employment cost and operating expenses fit the funding?
Monthly fundingminusEmployment costminusOperating expenses
Desired reserve growth is not part of this test. A fit is not permission under CSIL policy.
Reading 3
Reserve-growth goal
Does this month's change cover the growth the employer wants?
Expected monthly reserve changeminusDesired monthly reserve growth
Missing this goal is not a failed budget. It is also not the 12-month reserve status.
- Over funded hoursdoes not meanover budget
- A budget that fitsdoes not meanthe reserve-growth goal is met
The sentence beside the projected 12-month reserve is a status. It is not a fourth pass or fail.
How the dashboard uses those readings
- Funding / month is the funding rate times funded hours. Planned care hours do not replace funded hours.
- Care hours / month are the care hours on the team, turned into a month. This is the hours reading.
- Total cost / month is employment cost plus operating expenses. Desired reserve growth is not in that cost.
- Operating balance / month is funding minus total cost. Positive grows the reserve. Negative draws it down. This is the budget reading.
- 12-month operating reserve starts from the opening balance and carries that monthly change forward for a year. It is not capped. The sentence beside it is a status, not a fourth test.
The reserve-growth goal asks a further question: does the operating balance cover the monthly growth the employer wants? The example wants $200.00 desired monthly reserve growth. Missing that goal is not the same as a budget that does not fit.
What the example shows
Care hours stay at 182.50 on both plans, the same as funded hours. Funding goes from $6,969.68 to $7,394.90 because the rate goes from $38.19 per hour to $40.52 per hour. Total cost goes from $7,004.68 to $7,332.58 because the Care Team Proposed rates are filled in. The operating balance goes from -$35.00 to $62.32.
| Measure | Current | Proposed |
|---|---|---|
| Funding / month | $6,969.68 | $7,394.90 |
| Care hours / month | 182.50 | 182.50 |
| Total cost / month | $7,004.68 | $7,332.58 |
| Operating balance / month | -$35.00 | $62.32 |
| 12-month operating reserve | $2,579.96 | $3,747.81 |
A different plan can show 200 funded hours and 220 planned care hours. The workbook will show that hours difference. It will not clamp the care hours, and it will not treat the difference as an automatic budget failure.