Organizational Strategies
Toolkit
Medicaid Business Planning Spreadsheet
Author: Spotlight Action Team
Region: Nevada
Last modified: 3 June 2026
Updated April 2026: not an official Medicaid document.
Hypothetical example - CHW Workweek NEED TO EDIT THIS SIDE to match your organization
| Activity |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Total Time |
Revenue |
| Day Overview |
CHW starts the week in medical Office |
Call to check on rural clients from the office |
CHW drives to unserved neighboring community |
Client meetings in the office |
CHW drives to unserved neighboring community |
|
|
| Travel |
|
|
1.0 |
|
2.0 |
3.0 |
$0.00 |
| Notes |
1.0 |
1.0 |
1.0 |
1.0 |
1.0 |
5.0 |
$0.00 |
| Supervision |
0.5 |
|
|
0.5 |
|
1.0 |
$0.00 |
| Patient Edu |
3.0 |
4.0 |
3.5 |
3.0 |
2.5 |
16.0 |
$586.88 |
| Group of 3 |
1.0 |
|
1.0 |
2.0 |
|
4.0 |
$211.68 |
| Group of 8 |
1.5 |
|
1.0 |
1.5 |
2.0 |
6.0 |
$618.24 |
| Team/Office |
1.0 |
3.0 |
0.5 |
|
0.5 |
5.0 |
$0.00 |
| |
|
|
|
|
|
|
|
| hours/day |
8.0 |
8.0 |
8.0 |
8.0 |
8.0 |
40.0 |
$1,416.80 |
| |
|
|
|
|
|
|
|
| |
|
|
|
|
TIME |
HOURS |
BILLABLE |
| |
|
|
|
|
50 weeks |
2000 |
$70,840.00 |
| |
|
|
|
|
2 weeks PTO |
0.0 |
$0.00 |
| |
|
|
|
|
|
|
|
| |
Hourly Rate |
Annual |
20% Fringe |
5% admin, data, billing |
Annual Cost |
|
|
| 1FTE |
$ 27.25 |
$ 56,680.00 |
$ 11,336.00 |
$ 2,834.00 |
$ 70,850.00 |
|
|
