1. The first is the case study ( Quantitative Analysis )

profileMichelle_Michy
201911180135313._proposed_spreadsheet.zip
Home>Business & Finance homework help>Management homework help>1. The first is the case study ( Quantitative Analysis )

Current Situation.xlsx

Hourly Costs

Hourly Rates Hours per day Avg Reg Hourly Rate Weekday Hours Per Week Weekend Hours Per week Total Hours Per Week Average Total Hourly Rate Hourly Fringe Total Hourly Cost
Regular Employees AM PM Night AM PM Night Reg OT Reg OT
HN $ 17.50 $ 17.50 8 4 0 $ 17.50 40 20 0 24 84 $ 22.08 $ 5.25 $ 27.33
RN $ 14.50 $ 16.00 $ 17.50 8 8 8 $ 16.00 80 40 0 24 144 $ 19.56 $ 4.80 $ 24.36
LPN $ 9.80 $ 10.80 $ 11.80 8 8 8 $ 10.80 80 40 0 24 144 $ 13.20 $ 3.24 $ 16.44
NA $ 6.50 $ 7.50 8 4 0 $ 6.83 40 20 0 24 84 $ 8.62 $ 2.05 $ 10.67
US $ 7.50 $ 8.50 $ 9.50 8 8 8 $ 8.50 80 40 0 24 144 $ 10.39 $ 2.55 $ 12.94
Flex Pool Employees
RN $ 16.00 $ 17.50 $ 19.00 8 8 8 $ 17.50 120 0 24 0 144 $ 17.50 $ 5.25 $ 22.75
LPN $ 11.30 $ 12.30 $ 13.30 8 8 8 $ 12.30 120 0 24 0 144 $ 12.30 $ 3.69 $ 15.99
NA $ 7.50 $ 8.50 8 4 0 $ 7.83 80 0 24 0 104 $ 7.83 $ 2.35 $ 10.18
Agency Employees
RN $ 22.00 $ 24.00 $ 25.00 8 8 8 $ 23.67 120 0 24 0 144 $ 23.67 $ - 0 $ 23.67
LPN $ 16.00 $ 17.00 $ 18.00 8 8 8 $ 17.00 120 0 24 0 144 $ 17.00 $ - 0 $ 17.00
NA $ 12.00 $ 13.00 8 4 0 $ 12.33 60 0 24 0 84 $ 12.33 $ - 0 $ 12.33

Labor Mix

Admin Staff AM PM Total
HN 1 0 1
NA 4 0 4
Total 5 0 5
Direct Care Staff AM PM Total Skill Mix
RN 19 19 38 76.0%
LPN 4 4 8 16.0%
US 2 2 4 8.0%
Total 25 25 50 100%

Regular Labor Cost

Admin Staff Direct Care Staff Cost Per Labor Category Total Cost
Pay Period Regular HN NA RN (76%) LPN (16%) NA (8%) HN NA RN LPN NA
1 SEP 84 2 8 56.24 11.84 5.92 $ 4,592.00 $ 7,172.27 $ 115,059.54 $ 16,350.57 $ 5,307.48 $ 148,481.85
2 SEP 83 2 8 55.48 11.68 5.84 $ 4,592.00 $ 7,172.27 $ 113,504.68 $ 16,129.61 $ 5,235.75 $ 146,634.32
3 OCT 88 2 8 59.28 12.48 6.24 $ 4,592.00 $ 7,172.27 $ 121,278.98 $ 17,234.38 $ 5,594.37 $ 155,871.99
4 OCT 98 2 8 66.88 14.08 7.04 $ 4,592.00 $ 7,172.27 $ 136,827.56 $ 19,443.92 $ 6,311.59 $ 174,347.34
5 NOV 99 2 8 67.64 14.24 7.12 $ 4,592.00 $ 7,172.27 $ 138,382.42 $ 19,664.87 $ 6,383.32 $ 176,194.88
6 NOV 99.4 2 8 67.94 14.30 7.15 $ 4,592.00 $ 7,172.27 $ 139,004.36 $ 19,753.25 $ 6,412.01 $ 176,933.89
7 NOV 99 2 8 67.64 14.24 7.12 $ 4,592.00 $ 7,172.27 $ 138,382.42 $ 19,664.87 $ 6,383.32 $ 176,194.88
8 DEC 99.8 2 8 68.25 14.37 7.18 $ 4,592.00 $ 7,172.27 $ 139,626.31 $ 19,841.63 $ 6,440.70 $ 177,672.90
9 DEC 100.3 2 8 68.63 14.45 7.22 $ 4,592.00 $ 7,172.27 $ 140,403.74 $ 19,952.11 $ 6,476.56 $ 178,596.67
10 JAN 100.4 2 8 68.70 14.46 7.23 $ 4,592.00 $ 7,172.27 $ 140,559.22 $ 19,974.21 $ 6,483.73 $ 178,781.42
11 JAN 106.31 2 8 73.20 15.41 7.70 $ 4,592.00 $ 7,172.27 $ 149,748.44 $ 21,280.04 $ 6,907.61 $ 189,700.36
12 FEB 105.64 2 8 72.69 15.30 7.65 $ 4,592.00 $ 7,172.27 $ 148,706.68 $ 21,132.00 $ 6,859.56 $ 188,462.51
13 FEB 106.5 2 8 73.34 15.44 7.72 $ 4,592.00 $ 7,172.27 $ 150,043.86 $ 21,322.02 $ 6,921.24 $ 190,051.39
14 MAR 106.78 2 8 73.55 15.48 7.74 $ 4,592.00 $ 7,172.27 $ 150,479.22 $ 21,383.89 $ 6,941.32 $ 190,568.70
15 MAR 106.31 2 8 73.20 15.41 7.70 $ 4,592.00 $ 7,172.27 $ 149,748.44 $ 21,280.04 $ 6,907.61 $ 189,700.36
16 APR 104.5 2 8 71.82 15.12 7.56 $ 4,592.00 $ 7,172.27 $ 146,934.14 $ 20,880.12 $ 6,777.79 $ 186,356.32
17 APR 106.5 2 8 73.34 15.44 7.72 $ 4,592.00 $ 7,172.27 $ 150,043.86 $ 21,322.02 $ 6,921.24 $ 190,051.39
18 APR 106.02 2 8 72.98 15.36 7.68 $ 4,592.00 $ 7,172.27 $ 149,297.53 $ 21,215.96 $ 6,886.81 $ 189,164.57
19 MAY 105.36 2 8 72.47 15.26 7.63 $ 4,592.00 $ 7,172.27 $ 148,271.32 $ 21,070.14 $ 6,839.47 $ 187,945.20
20 MAY 104.22 2 8 71.61 15.08 7.54 $ 4,592.00 $ 7,172.27 $ 146,498.78 $ 20,818.25 $ 6,757.71 $ 185,839.01
21 JUN 102.51 2 8 70.31 14.80 7.40 $ 4,592.00 $ 7,172.27 $ 143,839.98 $ 20,440.42 $ 6,635.06 $ 182,679.72
22 JUN 101.46 2 8 69.51 14.63 7.32 $ 4,592.00 $ 7,172.27 $ 142,207.37 $ 20,208.42 $ 6,559.76 $ 180,739.81
23 JUL 97.19 2 8 66.26 13.95 6.98 $ 4,592.00 $ 7,172.27 $ 135,568.13 $ 19,264.94 $ 6,253.50 $ 172,850.84
24 JUL 90 2 8 60.80 12.80 6.40 $ 4,592.00 $ 7,172.27 $ 124,388.69 $ 17,676.29 $ 5,737.81 $ 159,567.06
25 AUG 90 2 8 60.80 12.80 6.40 $ 4,592.00 $ 7,172.27 $ 124,388.69 $ 17,676.29 $ 5,737.81 $ 159,567.06
26 AUG 89 2 8 60.04 12.64 6.32 $ 4,592.00 $ 7,172.27 $ 122,833.83 $ 17,455.33 $ 5,666.09 $ 157,719.53
Annual Totals $ 119,392.00 $ 186,478.93 $ 3,606,028.22 $ 512,435.59 $ 166,339.21 $ 4,590,673.95

Flex Pool Labor Cost

Direct Care Staff Total Cost
Pay Period Flex Pool RN (76%) LPN (16%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 10 7.60 1.60 0.80 $ 14,523.60 $ 2,149.06 $ 684.32 $ 17,356.98
7 NOV 9.5 7.22 1.52 0.76 $ 13,797.42 $ 2,041.60 $ 650.10 $ 16,489.13
8 DEC 9.7 7.37 1.55 0.78 $ 14,087.89 $ 2,084.58 $ 663.79 $ 16,836.27
9 DEC 9.1 6.92 1.46 0.73 $ 13,216.48 $ 1,955.64 $ 622.73 $ 15,794.85
10 JAN 9.3 7.07 1.49 0.74 $ 13,506.95 $ 1,998.62 $ 636.42 $ 16,141.99
11 JAN 8.9 6.76 1.42 0.71 $ 12,926.00 $ 1,912.66 $ 609.04 $ 15,447.71
12 FEB 10 7.60 1.60 0.80 $ 14,523.60 $ 2,149.06 $ 684.32 $ 17,356.98
13 FEB 11.8 8.97 1.89 0.94 $ 17,137.85 $ 2,535.89 $ 807.50 $ 20,481.23
14 MAR 12.6 9.58 2.02 1.01 $ 18,299.74 $ 2,707.81 $ 862.24 $ 21,869.79
15 MAR 12.9 9.80 2.06 1.03 $ 18,735.44 $ 2,772.28 $ 882.77 $ 22,390.50
16 APR 12.6 9.58 2.02 1.01 $ 18,299.74 $ 2,707.81 $ 862.24 $ 21,869.79
17 APR 12.5 9.50 2.00 1.00 $ 18,154.50 $ 2,686.32 $ 855.40 $ 21,696.22
18 APR 12.9 9.80 2.06 1.03 $ 18,735.44 $ 2,772.28 $ 882.77 $ 22,390.50
19 MAY 12 9.12 1.92 0.96 $ 17,428.32 $ 2,578.87 $ 821.18 $ 20,828.37
20 MAY 10.1 7.68 1.62 0.81 $ 14,668.84 $ 2,170.55 $ 691.16 $ 17,530.55
21 JUN 11.6 8.82 1.86 0.93 $ 16,847.38 $ 2,492.90 $ 793.81 $ 20,134.09
22 JUN 9.9 7.52 1.58 0.79 $ 14,378.36 $ 2,127.57 $ 677.48 $ 17,183.41
23 JUL 9.2 6.99 1.47 0.74 $ 13,361.71 $ 1,977.13 $ 629.57 $ 15,968.42
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 282,629.26 $ 41,820.63 $ 13,316.87 $ 337,766.75

Agency Labor Cost

Direct Care Staff Total Cost
Pay Period Flex Pool RN (76%) LPN (16%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 10 7.60 1.60 0.80 $ 15,108.80 $ 2,284.80 $ 828.80 $ 18,222.40
7 NOV 9.5 7.22 1.52 0.76 $ 14,353.36 $ 2,170.56 $ 787.36 $ 17,311.28
8 DEC 9.7 7.37 1.55 0.78 $ 14,655.54 $ 2,216.26 $ 803.94 $ 17,675.73
9 DEC 9.1 6.92 1.46 0.73 $ 13,749.01 $ 2,079.17 $ 754.21 $ 16,582.38
10 JAN 9.3 7.07 1.49 0.74 $ 14,051.18 $ 2,124.86 $ 770.78 $ 16,946.83
11 JAN 8.9 6.76 1.42 0.71 $ 13,446.83 $ 2,033.47 $ 737.63 $ 16,217.94
12 FEB 10 7.60 1.60 0.80 $ 15,108.80 $ 2,284.80 $ 828.80 $ 18,222.40
13 FEB 11.8 8.97 1.89 0.94 $ 17,828.38 $ 2,696.06 $ 977.98 $ 21,502.43
14 MAR 12.6 9.58 2.02 1.01 $ 19,037.09 $ 2,878.85 $ 1,044.29 $ 22,960.22
15 MAR 12.9 9.80 2.06 1.03 $ 19,490.35 $ 2,947.39 $ 1,069.15 $ 23,506.90
16 APR 12.6 9.58 2.02 1.01 $ 19,037.09 $ 2,878.85 $ 1,044.29 $ 22,960.22
17 APR 12.5 9.50 2.00 1.00 $ 18,886.00 $ 2,856.00 $ 1,036.00 $ 22,778.00
18 APR 12.9 9.80 2.06 1.03 $ 19,490.35 $ 2,947.39 $ 1,069.15 $ 23,506.90
19 MAY 12 9.12 1.92 0.96 $ 18,130.56 $ 2,741.76 $ 994.56 $ 21,866.88
20 MAY 10.1 7.68 1.62 0.81 $ 15,259.89 $ 2,307.65 $ 837.09 $ 18,404.62
21 JUN 11.6 8.82 1.86 0.93 $ 17,526.21 $ 2,650.37 $ 961.41 $ 21,137.98
22 JUN 9.9 7.52 1.58 0.79 $ 14,957.71 $ 2,261.95 $ 820.51 $ 18,040.18
23 JUL 9.2 6.99 1.47 0.74 $ 13,900.10 $ 2,102.02 $ 762.50 $ 16,764.61
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 294,017.25 $ 44,462.21 $ 16,128.45 $ 354,607.90

Total Labor Cost

FTE Count By Source Labor Cost by Source
Pay Period Regular Flex Pool Agency Total Regular Flex Pool Agency Total
1 SEP 84 0 0 84 $ 148,481.85 $ - 0 $ - 0 $ 148,481.85
2 SEP 83 0 0 83 $ 146,634.32 $ - 0 $ - 0 $ 146,634.32
3 OCT 88 0 0 88 $ 155,871.99 $ - 0 $ - 0 $ 155,871.99
4 OCT 98 0 0 98 $ 174,347.34 $ - 0 $ - 0 $ 174,347.34
5 NOV 99 0 0 99 $ 176,194.88 $ - 0 $ - 0 $ 176,194.88
6 NOV 99.4 10 10.6 120 $ 176,933.89 $ 17,356.98 $ 18,222.40 $ 212,513.27
7 NOV 99 9.5 21.5 130 $ 176,194.88 $ 16,489.13 $ 17,311.28 $ 209,995.28
8 DEC 99.8 9.7 15.5 125 $ 177,672.90 $ 16,836.27 $ 17,675.73 $ 212,184.90
9 DEC 100.3 9.1 20.6 130 $ 178,596.67 $ 15,794.85 $ 16,582.38 $ 210,973.90
10 JAN 100.4 9.3 21.3 131 $ 178,781.42 $ 16,141.99 $ 16,946.83 $ 211,870.24
11 JAN 106.31 8.9 13.8 129.01 $ 189,700.36 $ 15,447.71 $ 16,217.94 $ 221,366.00
12 FEB 105.64 10 6.36 122 $ 188,462.51 $ 17,356.98 $ 18,222.40 $ 224,041.88
13 FEB 106.5 11.8 6.71 125.01 $ 190,051.39 $ 20,481.23 $ 21,502.43 $ 232,035.05
14 MAR 106.78 12.6 12.62 132 $ 190,568.70 $ 21,869.79 $ 22,960.22 $ 235,398.71
15 MAR 106.31 12.9 4.79 124 $ 189,700.36 $ 22,390.50 $ 23,506.90 $ 235,597.75
16 APR 104.5 12.6 4.9 122 $ 186,356.32 $ 21,869.79 $ 22,960.22 $ 231,186.33
17 APR 106.5 12.5 1.01 120.01 $ 190,051.39 $ 21,696.22 $ 22,778.00 $ 234,525.61
18 APR 106.02 12.9 1.08 120 $ 189,164.57 $ 22,390.50 $ 23,506.90 $ 235,061.97
19 MAY 105.36 12 0.64 118 $ 187,945.20 $ 20,828.37 $ 21,866.88 $ 230,640.45
20 MAY 104.22 10.1 1.69 116.01 $ 185,839.01 $ 17,530.55 $ 18,404.62 $ 221,774.18
21 JUN 102.51 11.6 1.9 116.01 $ 182,679.72 $ 20,134.09 $ 21,137.98 $ 223,951.80
22 JUN 101.46 9.9 2.64 114 $ 180,739.81 $ 17,183.41 $ 18,040.18 $ 215,963.39
23 JUL 97.19 9.2 3.61 110 $ 172,850.84 $ 15,968.42 $ 16,764.61 $ 205,583.86
24 JUL 90 0 0 90 $ 159,567.06 $ - 0 $ - 0 $ 159,567.06
25 AUG 90 0 0 90 $ 159,567.06 $ - 0 $ - 0 $ 159,567.06
26 AUG 89 0 0 89 $ 157,719.53 $ - 0 $ - 0 $ 157,719.53
Annual Total $ 4,590,673.95 $ 337,766.75 $ 354,607.90 $ 5,283,048.61

Staff Needs (22 HPPD)

Nursing Staff FTE Nursing Staff Hours
Pay Period ADC Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 6067.6 56.24 11.84 5.92 4724.16 994.56 497.28 6216 148.4
2 SEP 19.7 6067.6 55.48 11.68 5.84 4660.32 981.12 490.56 6132 64.4
3 OCT 21.2 6529.6 59.28 12.48 6.24 4979.52 1048.32 524.16 6552 22.4
4 OCT 25.7 7915.6 66.88 14.08 7.04 5617.92 1182.72 591.36 7392 -523.6
5 NOV 28.8 8870.4 67.64 14.24 7.12 5681.76 1196.16 598.08 7476 -1394.4
6 NOV 36.3 11180.4 83.14 17.50 8.75 6984.096 1470.336 735.168 9189.6 -1990.8
7 NOV 39.3 12104.4 82.08 17.28 8.64 6894.72 1451.52 725.76 9072 -3032.4
8 DEC 36.3 11180.4 82.99 17.47 8.74 6971.328 1467.648 733.824 9172.8 -2007.6
9 DEC 39.3 12104.4 82.46 17.36 8.68 6926.64 1458.24 729.12 9114 -2990.4
10 JAN 39.3 12104.4 82.84 17.44 8.72 6958.56 1464.96 732.48 9156 -2948.4
11 JAN 39.3 12104.4 86.72 18.26 9.13 7284.7824 1533.6384 766.8192 9585.24 -2519.16
12 FEB 39.3 12104.4 87.89 18.50 9.25 7382.4576 1554.2016 777.1008 9713.76 -2390.64
13 FEB 39.3 12104.4 91.28 19.22 9.61 7667.184 1614.144 807.072 10088.4 -2016
14 MAR 39.3 12104.4 92.70 19.52 9.76 7787.2032 1639.4112 819.7056 10246.32 -1858.08
15 MAR 36.3 11180.4 92.80 19.54 9.77 7795.5024 1641.1584 820.5792 10257.24 -923.16
16 APR 33.3 10256.4 90.97 19.15 9.58 7641.648 1608.768 804.384 10054.8 -201.6
17 APR 30.3 9332.4 92.34 19.44 9.72 7756.56 1632.96 816.48 10206 873.6
18 APR 30.3 9332.4 92.58 19.49 9.75 7776.9888 1637.2608 818.6304 10232.88 900.48
19 MAY 26.5 8162 90.71 19.10 9.55 7619.9424 1604.1984 802.0992 10026.24 1864.24
20 MAY 26.5 8162 86.96 18.31 9.15 7304.5728 1537.8048 768.9024 9611.28 1449.28
21 JUN 25.1 7730.8 87.94 18.51 9.26 7386.9264 1555.1424 777.5712 9719.64 1988.84
22 JUN 25.1 7730.8 84.56 17.80 8.90 7102.8384 1495.3344 747.6672 9345.84 1615.04
23 JUL 22.7 6991.6 80.25 16.89 8.45 6740.8656 1419.1296 709.5648 8869.56 1877.96
24 JUL 21.5 6622 60.80 12.80 6.40 5107.2 1075.2 537.6 6720 98
25 AUG 19.7 6067.6 60.80 12.80 6.40 5107.2 1075.2 537.6 6720 652.4
26 AUG 19.7 6067.6 60.04 12.64 6.32 5043.36 1061.76 530.88 6636 568.4
Annual Totals -12672.8

Staff Needs (3.5 Acuity)

Direct Care Staff Direct Care % Direct Care Hours
Pay Period ADC Acuity Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 2.5 2413.25 56.24 11.84 5.92 42% 58% 50% 1984.1472 576.8448 248.64 2809.632 396.382
2 SEP 19.7 2.6 2509.78 55.48 11.68 5.84 42% 58% 50% 1957.3344 569.0496 245.28 2771.664 261.884
3 OCT 21.2 2.6 2700.88 59.28 12.48 6.24 42% 58% 50% 2091.3984 608.0256 262.08 2961.504 260.624
4 OCT 25.7 2.58 3248.994 66.88 14.08 7.04 42% 58% 50% 2359.5264 685.9776 295.68 3341.184 92.19
5 NOV 28.8 2.9 4092.48 67.64 14.24 7.12 42% 58% 50% 2386.3392 693.7728 299.04 3379.152 -713.328
6 NOV 36.3 2.87 5104.869 83.14 17.50 8.75 42% 58% 50% 2933.32032 852.79488 367.584 4153.6992 -951.1698
7 NOV 39.3 2.76 5314.932 82.08 17.28 8.64 42% 58% 50% 2895.7824 841.8816 362.88 4100.544 -1214.388
8 DEC 36.3 3.2 5691.84 82.99 17.47 8.74 42% 58% 50% 2927.95776 851.23584 366.912 4146.1056 -1545.7344
9 DEC 39.3 3.4 6547.38 82.46 17.36 8.68 42% 58% 50% 2909.1888 845.7792 364.56 4119.528 -2427.852
10 JAN 39.3 3.1 5969.67 82.84 17.44 8.72 42% 58% 50% 2922.5952 849.6768 366.24 4138.512 -1831.158
11 JAN 39.3 3.2 6162.24 86.72 18.26 9.13 42% 58% 50% 3059.608608 889.510272 383.4096 4332.52848 -1829.71152
12 FEB 39.3 3.6 6932.52 87.89 18.50 9.25 42% 58% 50% 3100.632192 901.436928 388.5504 4390.61952 -2541.90048
13 FEB 39.3 3.4 6547.38 91.28 19.22 9.61 42% 58% 50% 3220.21728 936.20352 403.536 4559.9568 -1987.4232
14 MAR 39.3 3.6 6932.52 92.70 19.52 9.76 42% 58% 50% 3270.625344 950.858496 409.8528 4631.33664 -2301.18336
15 MAR 36.3 3.4 6047.58 92.80 19.54 9.77 42% 58% 50% 3274.111008 951.871872 410.2896 4636.27248 -1411.30752
16 APR 33.3 3.2 5221.44 90.97 19.15 9.58 42% 58% 50% 3209.49216 933.08544 402.192 4544.7696 -676.6704
17 APR 30.3 3.1 4602.57 92.34 19.44 9.72 42% 58% 50% 3257.7552 947.1168 408.24 4613.112 10.542
18 APR 30.3 2.9 4305.63 92.58 19.49 9.75 42% 58% 50% 3266.335296 949.611264 409.3152 4625.26176 319.63176
19 MAY 26.5 2.9 3765.65 90.71 19.10 9.55 42% 58% 50% 3200.375808 930.435072 401.0496 4531.86048 766.21048
20 MAY 26.5 2.7 3505.95 86.96 18.31 9.15 42% 58% 50% 3067.920576 891.926784 384.4512 4344.29856 838.34856
21 JUN 25.1 2.5 3074.75 87.94 18.51 9.26 42% 58% 50% 3102.509088 901.982592 388.7856 4393.27728 1318.52728
22 JUN 25.1 2.2 2705.78 84.56 17.80 8.90 42% 58% 50% 2983.192128 867.293952 373.8336 4224.31968 1518.53968
23 JUL 22.7 2.4 2669.52 80.25 16.89 8.45 42% 58% 50% 2831.163552 823.095168 354.7824 4009.04112 1339.52112
24 JUL 21.5 2.5 2633.75 60.80 12.80 6.40 42% 58% 50% 2145.024 623.616 268.8 3037.44 403.69
25 AUG 19.7 2.5 2413.25 60.80 12.80 6.40 42% 58% 50% 2145.024 623.616 268.8 3037.44 624.19
26 AUG 19.7 2.3 2220.19 60.04 12.64 6.32 42% 58% 50% 2118.2112 615.8208 265.44 2999.472 779.282
Annual Totals -10502.2638

__MACOSX/._Current Situation.xlsx

Proposed (1).xlsx

Hourly Costs

Hourly Rates Hours per day Avg Reg Hourly Rate Weekday Hours Per Week Weekend Hours Per week Total Hours Per Week Average Total Hourly Rate Hourly Fringe Total Hourly Cost
Regular Employees AM PM Night AM PM Night Reg OT Reg OT
HN $ 17.50 $ 17.50 8 4 0 $ 17.50 60 0 0 24 84 $ 20.00 $ 5.25 $ 25.25
RN $ 14.50 $ 16.00 $ 17.50 8 8 8 $ 16.00 120 0 0 24 144 $ 17.33 $ 4.80 $ 22.13
LPN $ 9.80 $ 10.80 $ 11.80 8 8 8 $ 10.80 120 0 0 24 144 $ 11.70 $ 3.24 $ 14.94
NA $ 6.50 $ 7.50 8 4 0 $ 6.83 60 0 0 24 84 $ 7.81 $ 2.05 $ 9.86
US $ 7.50 $ 8.50 $ 9.50 8 8 8 $ 8.50 120 0 0 24 144 $ 9.21 $ 2.55 $ 11.76
Flex Pool Employees
RN $ 16.00 $ 17.50 $ 19.00 8 8 8 $ 17.50 120 0 24 0 144 $ 17.50 $ 5.25 $ 22.75
LPN $ 11.30 $ 12.30 $ 13.30 8 8 8 $ 12.30 120 0 24 0 144 $ 12.30 $ 3.69 $ 15.99
NA $ 7.50 $ 8.50 8 4 0 $ 7.83 80 0 24 0 104 $ 7.83 $ 2.35 $ 10.18
Agency Employees
RN $ 22.00 $ 24.00 $ 25.00 8 8 8 $ 23.67 120 0 24 0 144 $ 23.67 $ - 0 $ 23.67
LPN $ 16.00 $ 17.00 $ 18.00 8 8 8 $ 17.00 120 0 24 0 144 $ 17.00 $ - 0 $ 17.00
NA $ 12.00 $ 13.00 8 4 0 $ 12.33 60 0 24 0 84 $ 12.33 $ - 0 $ 12.33

Labor Mix

Admin Staff AM PM Total
HN 1 0 1
NA 4 0 4
Total 5 0 5
Direct Care Staff AM PM Total Skill Mix
RN 19 19 38 76.0%
LPN 4 4 8 16.0%
US 2 2 4 8.0%
Total 25 25 50 100%

Regular Labor Cost

Admin Staff Direct Care Staff Cost Per Labor Category Total Cost
Pay Period Regular HN NA RN (76%) LPN (16%) NA (8%) HN NA RN LPN NA
1 SEP 84 2 8 56.24 11.84 5.92 $ 4,242.00 $ 6,625.60 $ 104,561.41 $ 14,858.73 $ 4,902.94 $ 135,190.68
2 SEP 83 2 8 55.48 11.68 5.84 $ 4,242.00 $ 6,625.60 $ 103,148.42 $ 14,657.93 $ 4,836.69 $ 133,510.64
3 OCT 88 2 8 59.28 12.48 6.24 $ 4,242.00 $ 6,625.60 $ 110,213.38 $ 15,661.90 $ 5,167.97 $ 141,910.84
4 OCT 98 2 8 66.88 14.08 7.04 $ 4,242.00 $ 6,625.60 $ 124,343.30 $ 17,669.84 $ 5,830.53 $ 158,711.26
5 NOV 99 2 8 67.64 14.24 7.12 $ 4,242.00 $ 6,625.60 $ 125,756.29 $ 17,870.63 $ 5,896.78 $ 160,391.30
6 NOV 99.4 2 8 67.94 14.30 7.15 $ 4,242.00 $ 6,625.60 $ 126,321.48 $ 17,950.95 $ 5,923.29 $ 161,063.32
7 NOV 99 2 8 67.64 14.24 7.12 $ 4,242.00 $ 6,625.60 $ 125,756.29 $ 17,870.63 $ 5,896.78 $ 160,391.30
8 DEC 99.8 2 8 68.25 14.37 7.18 $ 4,242.00 $ 6,625.60 $ 126,886.68 $ 18,031.27 $ 5,949.79 $ 161,735.34
9 DEC 100.3 2 8 68.63 14.45 7.22 $ 4,242.00 $ 6,625.60 $ 127,593.18 $ 18,131.66 $ 5,982.92 $ 162,575.36
10 JAN 100.4 2 8 68.70 14.46 7.23 $ 4,242.00 $ 6,625.60 $ 127,734.48 $ 18,151.74 $ 5,989.54 $ 162,743.36
11 JAN 106.31 2 8 73.20 15.41 7.70 $ 4,242.00 $ 6,625.60 $ 136,085.26 $ 19,338.43 $ 6,381.12 $ 172,672.41
12 FEB 105.64 2 8 72.69 15.30 7.65 $ 4,242.00 $ 6,625.60 $ 135,138.55 $ 19,203.90 $ 6,336.72 $ 171,546.78
13 FEB 106.5 2 8 73.34 15.44 7.72 $ 4,242.00 $ 6,625.60 $ 136,353.73 $ 19,376.58 $ 6,393.70 $ 172,991.61
14 MAR 106.78 2 8 73.55 15.48 7.74 $ 4,242.00 $ 6,625.60 $ 136,749.37 $ 19,432.80 $ 6,412.26 $ 173,462.03
15 MAR 106.31 2 8 73.20 15.41 7.70 $ 4,242.00 $ 6,625.60 $ 136,085.26 $ 19,338.43 $ 6,381.12 $ 172,672.41
16 APR 104.5 2 8 71.82 15.12 7.56 $ 4,242.00 $ 6,625.60 $ 133,527.74 $ 18,975.00 $ 6,261.19 $ 169,631.53
17 APR 106.5 2 8 73.34 15.44 7.72 $ 4,242.00 $ 6,625.60 $ 136,353.73 $ 19,376.58 $ 6,393.70 $ 172,991.61
18 APR 106.02 2 8 72.98 15.36 7.68 $ 4,242.00 $ 6,625.60 $ 135,675.49 $ 19,280.20 $ 6,361.90 $ 172,185.19
19 MAY 105.36 2 8 72.47 15.26 7.63 $ 4,242.00 $ 6,625.60 $ 134,742.92 $ 19,147.68 $ 6,318.17 $ 171,076.37
20 MAY 104.22 2 8 71.61 15.08 7.54 $ 4,242.00 $ 6,625.60 $ 133,132.11 $ 18,918.77 $ 6,242.64 $ 169,161.12
21 JUN 102.51 2 8 70.31 14.80 7.40 $ 4,242.00 $ 6,625.60 $ 130,715.89 $ 18,575.42 $ 6,129.34 $ 166,288.25
22 JUN 101.46 2 8 69.51 14.63 7.32 $ 4,242.00 $ 6,625.60 $ 129,232.25 $ 18,364.58 $ 6,059.77 $ 164,524.20
23 JUL 97.19 2 8 66.26 13.95 6.98 $ 4,242.00 $ 6,625.60 $ 123,198.77 $ 17,507.19 $ 5,776.86 $ 157,350.43
24 JUL 90 2 8 60.80 12.80 6.40 $ 4,242.00 $ 6,625.60 $ 113,039.36 $ 16,063.49 $ 5,300.48 $ 145,270.93
25 AUG 90 2 8 60.80 12.80 6.40 $ 4,242.00 $ 6,625.60 $ 113,039.36 $ 16,063.49 $ 5,300.48 $ 145,270.93
26 AUG 89 2 8 60.04 12.64 6.32 $ 4,242.00 $ 6,625.60 $ 111,626.37 $ 15,862.69 $ 5,234.22 $ 143,590.89
Annual Totals $ 110,292.00 $ 172,265.60 $ 3,277,011.05 $ 465,680.52 $ 153,660.92 $ 4,178,910.08

Flex Pool Labor Cost

Direct Care Staff Total Cost
Pay Period Flex Pool RN (76%) LPN (16%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 10 7.60 1.60 0.80 $ 14,523.60 $ 2,149.06 $ 684.32 $ 17,356.98
7 NOV 9.5 7.22 1.52 0.76 $ 13,797.42 $ 2,041.60 $ 650.10 $ 16,489.13
8 DEC 9.7 7.37 1.55 0.78 $ 14,087.89 $ 2,084.58 $ 663.79 $ 16,836.27
9 DEC 9.1 6.92 1.46 0.73 $ 13,216.48 $ 1,955.64 $ 622.73 $ 15,794.85
10 JAN 9.3 7.07 1.49 0.74 $ 13,506.95 $ 1,998.62 $ 636.42 $ 16,141.99
11 JAN 8.9 6.76 1.42 0.71 $ 12,926.00 $ 1,912.66 $ 609.04 $ 15,447.71
12 FEB 10 7.60 1.60 0.80 $ 14,523.60 $ 2,149.06 $ 684.32 $ 17,356.98
13 FEB 11.8 8.97 1.89 0.94 $ 17,137.85 $ 2,535.89 $ 807.50 $ 20,481.23
14 MAR 12.6 9.58 2.02 1.01 $ 18,299.74 $ 2,707.81 $ 862.24 $ 21,869.79
15 MAR 12.9 9.80 2.06 1.03 $ 18,735.44 $ 2,772.28 $ 882.77 $ 22,390.50
16 APR 12.6 9.58 2.02 1.01 $ 18,299.74 $ 2,707.81 $ 862.24 $ 21,869.79
17 APR 12.5 9.50 2.00 1.00 $ 18,154.50 $ 2,686.32 $ 855.40 $ 21,696.22
18 APR 12.9 9.80 2.06 1.03 $ 18,735.44 $ 2,772.28 $ 882.77 $ 22,390.50
19 MAY 12 9.12 1.92 0.96 $ 17,428.32 $ 2,578.87 $ 821.18 $ 20,828.37
20 MAY 10.1 7.68 1.62 0.81 $ 14,668.84 $ 2,170.55 $ 691.16 $ 17,530.55
21 JUN 11.6 8.82 1.86 0.93 $ 16,847.38 $ 2,492.90 $ 793.81 $ 20,134.09
22 JUN 9.9 7.52 1.58 0.79 $ 14,378.36 $ 2,127.57 $ 677.48 $ 17,183.41
23 JUL 9.2 6.99 1.47 0.74 $ 13,361.71 $ 1,977.13 $ 629.57 $ 15,968.42
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 282,629.26 $ 41,820.63 $ 13,316.87 $ 337,766.75

Agency Labor Cost

Direct Care Staff Total Cost
Pay Period Agency RN (76%) LPN (16%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 10 7.60 1.60 0.80 $ 15,108.80 $ 2,284.80 $ 828.80 $ 18,222.40
7 NOV 9.5 7.22 1.52 0.76 $ 14,353.36 $ 2,170.56 $ 787.36 $ 17,311.28
8 DEC 9.7 7.37 1.55 0.78 $ 14,655.54 $ 2,216.26 $ 803.94 $ 17,675.73
9 DEC 9.1 6.92 1.46 0.73 $ 13,749.01 $ 2,079.17 $ 754.21 $ 16,582.38
10 JAN 9.3 7.07 1.49 0.74 $ 14,051.18 $ 2,124.86 $ 770.78 $ 16,946.83
11 JAN 8.9 6.76 1.42 0.71 $ 13,446.83 $ 2,033.47 $ 737.63 $ 16,217.94
12 FEB 10 7.60 1.60 0.80 $ 15,108.80 $ 2,284.80 $ 828.80 $ 18,222.40
13 FEB 11.8 8.97 1.89 0.94 $ 17,828.38 $ 2,696.06 $ 977.98 $ 21,502.43
14 MAR 12.6 9.58 2.02 1.01 $ 19,037.09 $ 2,878.85 $ 1,044.29 $ 22,960.22
15 MAR 12.9 9.80 2.06 1.03 $ 19,490.35 $ 2,947.39 $ 1,069.15 $ 23,506.90
16 APR 12.6 9.58 2.02 1.01 $ 19,037.09 $ 2,878.85 $ 1,044.29 $ 22,960.22
17 APR 12.5 9.50 2.00 1.00 $ 18,886.00 $ 2,856.00 $ 1,036.00 $ 22,778.00
18 APR 12.9 9.80 2.06 1.03 $ 19,490.35 $ 2,947.39 $ 1,069.15 $ 23,506.90
19 MAY 12 9.12 1.92 0.96 $ 18,130.56 $ 2,741.76 $ 994.56 $ 21,866.88
20 MAY 10.1 7.68 1.62 0.81 $ 15,259.89 $ 2,307.65 $ 837.09 $ 18,404.62
21 JUN 11.6 8.82 1.86 0.93 $ 17,526.21 $ 2,650.37 $ 961.41 $ 21,137.98
22 JUN 9.9 7.52 1.58 0.79 $ 14,957.71 $ 2,261.95 $ 820.51 $ 18,040.18
23 JUL 9.2 6.99 1.47 0.74 $ 13,900.10 $ 2,102.02 $ 762.50 $ 16,764.61
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 294,017.25 $ 44,462.21 $ 16,128.45 $ 354,607.90

Total Labor Cost

FTE Count By Source Labor Cost by Source
Pay Period Regular Flex Pool Agency Total Regular Flex Pool Agency Total
1 SEP 84 0 0 84 $ 135,190.68 $ - 0 $ - 0 $ 135,190.68
2 SEP 83 0 0 83 $ 133,510.64 $ - 0 $ - 0 $ 133,510.64
3 OCT 88 0 0 88 $ 141,910.84 $ - 0 $ - 0 $ 141,910.84
4 OCT 98 0 0 98 $ 158,711.26 $ - 0 $ - 0 $ 158,711.26
5 NOV 99 0 0 99 $ 160,391.30 $ - 0 $ - 0 $ 160,391.30
6 NOV 99.4 10 10.6 120 $ 161,063.32 $ 17,356.98 $ 18,222.40 $ 196,642.70
7 NOV 99 9.5 21.5 130 $ 160,391.30 $ 16,489.13 $ 17,311.28 $ 194,191.71
8 DEC 99.8 9.7 15.5 125 $ 161,735.34 $ 16,836.27 $ 17,675.73 $ 196,247.33
9 DEC 100.3 9.1 20.6 130 $ 162,575.36 $ 15,794.85 $ 16,582.38 $ 194,952.59
10 JAN 100.4 9.3 21.3 131 $ 162,743.36 $ 16,141.99 $ 16,946.83 $ 195,832.18
11 JAN 106.31 8.9 13.8 129.01 $ 172,672.41 $ 15,447.71 $ 16,217.94 $ 204,338.05
12 FEB 105.64 10 6.36 122 $ 171,546.78 $ 17,356.98 $ 18,222.40 $ 207,126.15
13 FEB 106.5 11.8 6.71 125.01 $ 172,991.61 $ 20,481.23 $ 21,502.43 $ 214,975.28
14 MAR 106.78 12.6 12.62 132 $ 173,462.03 $ 21,869.79 $ 22,960.22 $ 218,292.04
15 MAR 106.31 12.9 4.79 124 $ 172,672.41 $ 22,390.50 $ 23,506.90 $ 218,569.80
16 APR 104.5 12.6 4.9 122 $ 169,631.53 $ 21,869.79 $ 22,960.22 $ 214,461.54
17 APR 106.5 12.5 1.01 120.01 $ 172,991.61 $ 21,696.22 $ 22,778.00 $ 217,465.83
18 APR 106.02 12.9 1.08 120 $ 172,185.19 $ 22,390.50 $ 23,506.90 $ 218,082.59
19 MAY 105.36 12 0.64 118 $ 171,076.37 $ 20,828.37 $ 21,866.88 $ 213,771.62
20 MAY 104.22 10.1 1.69 116.01 $ 169,161.12 $ 17,530.55 $ 18,404.62 $ 205,096.29
21 JUN 102.51 11.6 1.9 116.01 $ 166,288.25 $ 20,134.09 $ 21,137.98 $ 207,560.32
22 JUN 101.46 9.9 2.64 114 $ 164,524.20 $ 17,183.41 $ 18,040.18 $ 199,747.79
23 JUL 97.19 9.2 3.61 110 $ 157,350.43 $ 15,968.42 $ 16,764.61 $ 190,083.45
24 JUL 90 0 0 90 $ 145,270.93 $ - 0 $ - 0 $ 145,270.93
25 AUG 90 0 0 90 $ 145,270.93 $ - 0 $ - 0 $ 145,270.93
26 AUG 89 0 0 89 $ 143,590.89 $ - 0 $ - 0 $ 143,590.89
Annual Total $ 4,178,910.08 $ 337,766.75 $ 354,607.90 $ 4,871,284.74
Change #1 $ 4,871,284.74 No weekday overtime
Change #2 $ 4,611,951.76 Labor Mix Change
Change #3 $ 4,895,293.37 Right-size Labor Force

Staff Needs (22 HPPD)

Nursing Staff FTE Nursing Staff Hours
Pay Period ADC Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 6067.6 56.24 11.84 5.92 4724.16 994.56 497.28 6216 148.4
2 SEP 19.7 6067.6 55.48 11.68 5.84 4660.32 981.12 490.56 6132 64.4
3 OCT 21.2 6529.6 59.28 12.48 6.24 4979.52 1048.32 524.16 6552 22.4
4 OCT 25.7 7915.6 66.88 14.08 7.04 5617.92 1182.72 591.36 7392 -523.6
5 NOV 28.8 8870.4 67.64 14.24 7.12 5681.76 1196.16 598.08 7476 -1394.4
6 NOV 36.3 11180.4 83.14 17.50 8.75 6984.096 1470.336 735.168 9189.6 -1990.8
7 NOV 39.3 12104.4 82.08 17.28 8.64 6894.72 1451.52 725.76 9072 -3032.4
8 DEC 36.3 11180.4 82.99 17.47 8.74 6971.328 1467.648 733.824 9172.8 -2007.6
9 DEC 39.3 12104.4 82.46 17.36 8.68 6926.64 1458.24 729.12 9114 -2990.4
10 JAN 39.3 12104.4 82.84 17.44 8.72 6958.56 1464.96 732.48 9156 -2948.4
11 JAN 39.3 12104.4 86.72 18.26 9.13 7284.7824 1533.6384 766.8192 9585.24 -2519.16
12 FEB 39.3 12104.4 87.89 18.50 9.25 7382.4576 1554.2016 777.1008 9713.76 -2390.64
13 FEB 39.3 12104.4 91.28 19.22 9.61 7667.184 1614.144 807.072 10088.4 -2016
14 MAR 39.3 12104.4 92.70 19.52 9.76 7787.2032 1639.4112 819.7056 10246.32 -1858.08
15 MAR 36.3 11180.4 92.80 19.54 9.77 7795.5024 1641.1584 820.5792 10257.24 -923.16
16 APR 33.3 10256.4 90.97 19.15 9.58 7641.648 1608.768 804.384 10054.8 -201.6
17 APR 30.3 9332.4 92.34 19.44 9.72 7756.56 1632.96 816.48 10206 873.6
18 APR 30.3 9332.4 92.58 19.49 9.75 7776.9888 1637.2608 818.6304 10232.88 900.48
19 MAY 26.5 8162 90.71 19.10 9.55 7619.9424 1604.1984 802.0992 10026.24 1864.24
20 MAY 26.5 8162 86.96 18.31 9.15 7304.5728 1537.8048 768.9024 9611.28 1449.28
21 JUN 25.1 7730.8 87.94 18.51 9.26 7386.9264 1555.1424 777.5712 9719.64 1988.84
22 JUN 25.1 7730.8 84.56 17.80 8.90 7102.8384 1495.3344 747.6672 9345.84 1615.04
23 JUL 22.7 6991.6 80.25 16.89 8.45 6740.8656 1419.1296 709.5648 8869.56 1877.96
24 JUL 21.5 6622 60.80 12.80 6.40 5107.2 1075.2 537.6 6720 98
25 AUG 19.7 6067.6 60.80 12.80 6.40 5107.2 1075.2 537.6 6720 652.4
26 AUG 19.7 6067.6 60.04 12.64 6.32 5043.36 1061.76 530.88 6636 568.4
Annual Totals -12672.8

Staff Needs (3.5 Acuity)

Direct Care Staff Direct Care % Direct Care Hours
Pay Period ADC Acuity Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 2.5 2413.25 56.24 11.84 5.92 42% 58% 50% 1984.1472 576.8448 248.64 2809.632 396.382
2 SEP 19.7 2.6 2509.78 55.48 11.68 5.84 42% 58% 50% 1957.3344 569.0496 245.28 2771.664 261.884
3 OCT 21.2 2.6 2700.88 59.28 12.48 6.24 42% 58% 50% 2091.3984 608.0256 262.08 2961.504 260.624
4 OCT 25.7 2.58 3248.994 66.88 14.08 7.04 42% 58% 50% 2359.5264 685.9776 295.68 3341.184 92.19
5 NOV 28.8 2.9 4092.48 67.64 14.24 7.12 42% 58% 50% 2386.3392 693.7728 299.04 3379.152 -713.328
6 NOV 36.3 2.87 5104.869 83.14 17.50 8.75 42% 58% 50% 2933.32032 852.79488 367.584 4153.6992 -951.1698
7 NOV 39.3 2.76 5314.932 82.08 17.28 8.64 42% 58% 50% 2895.7824 841.8816 362.88 4100.544 -1214.388
8 DEC 36.3 3.2 5691.84 82.99 17.47 8.74 42% 58% 50% 2927.95776 851.23584 366.912 4146.1056 -1545.7344
9 DEC 39.3 3.4 6547.38 82.46 17.36 8.68 42% 58% 50% 2909.1888 845.7792 364.56 4119.528 -2427.852
10 JAN 39.3 3.1 5969.67 82.84 17.44 8.72 42% 58% 50% 2922.5952 849.6768 366.24 4138.512 -1831.158
11 JAN 39.3 3.2 6162.24 86.72 18.26 9.13 42% 58% 50% 3059.608608 889.510272 383.4096 4332.52848 -1829.71152
12 FEB 39.3 3.6 6932.52 87.89 18.50 9.25 42% 58% 50% 3100.632192 901.436928 388.5504 4390.61952 -2541.90048
13 FEB 39.3 3.4 6547.38 91.28 19.22 9.61 42% 58% 50% 3220.21728 936.20352 403.536 4559.9568 -1987.4232
14 MAR 39.3 3.6 6932.52 92.70 19.52 9.76 42% 58% 50% 3270.625344 950.858496 409.8528 4631.33664 -2301.18336
15 MAR 36.3 3.4 6047.58 92.80 19.54 9.77 42% 58% 50% 3274.111008 951.871872 410.2896 4636.27248 -1411.30752
16 APR 33.3 3.2 5221.44 90.97 19.15 9.58 42% 58% 50% 3209.49216 933.08544 402.192 4544.7696 -676.6704
17 APR 30.3 3.1 4602.57 92.34 19.44 9.72 42% 58% 50% 3257.7552 947.1168 408.24 4613.112 10.542
18 APR 30.3 2.9 4305.63 92.58 19.49 9.75 42% 58% 50% 3266.335296 949.611264 409.3152 4625.26176 319.63176
19 MAY 26.5 2.9 3765.65 90.71 19.10 9.55 42% 58% 50% 3200.375808 930.435072 401.0496 4531.86048 766.21048
20 MAY 26.5 2.7 3505.95 86.96 18.31 9.15 42% 58% 50% 3067.920576 891.926784 384.4512 4344.29856 838.34856
21 JUN 25.1 2.5 3074.75 87.94 18.51 9.26 42% 58% 50% 3102.509088 901.982592 388.7856 4393.27728 1318.52728
22 JUN 25.1 2.2 2705.78 84.56 17.80 8.90 42% 58% 50% 2983.192128 867.293952 373.8336 4224.31968 1518.53968
23 JUL 22.7 2.4 2669.52 80.25 16.89 8.45 42% 58% 50% 2831.163552 823.095168 354.7824 4009.04112 1339.52112
24 JUL 21.5 2.5 2633.75 60.80 12.80 6.40 42% 58% 50% 2145.024 623.616 268.8 3037.44 403.69
25 AUG 19.7 2.5 2413.25 60.80 12.80 6.40 42% 58% 50% 2145.024 623.616 268.8 3037.44 624.19
26 AUG 19.7 2.3 2220.19 60.04 12.64 6.32 42% 58% 50% 2118.2112 615.8208 265.44 2999.472 779.282
Annual Totals -10502.2638

__MACOSX/._Proposed (1).xlsx

Proposed (2).xlsx

Hourly Costs

Hourly Rates Hours per day Avg Reg Hourly Rate Weekday Hours Per Week Weekend Hours Per week Total Hours Per Week Average Total Hourly Rate Hourly Fringe Total Hourly Cost
Regular Employees AM PM Night AM PM Night Reg OT Reg OT
HN $ 17.50 $ 17.50 8 4 0 $ 17.50 60 0 0 24 84 $ 20.00 $ 5.25 $ 25.25
RN $ 14.50 $ 16.00 $ 17.50 8 8 8 $ 16.00 120 0 0 24 144 $ 17.33 $ 4.80 $ 22.13
LPN $ 9.80 $ 10.80 $ 11.80 8 8 8 $ 10.80 120 0 0 24 144 $ 11.70 $ 3.24 $ 14.94
NA $ 6.50 $ 7.50 8 4 0 $ 6.83 60 0 0 24 84 $ 7.81 $ 2.05 $ 9.86
US $ 7.50 $ 8.50 $ 9.50 8 8 8 $ 8.50 120 0 0 24 144 $ 9.21 $ 2.55 $ 11.76
Flex Pool Employees
RN $ 16.00 $ 17.50 $ 19.00 8 8 8 $ 17.50 120 0 24 0 144 $ 17.50 $ 5.25 $ 22.75
LPN $ 11.30 $ 12.30 $ 13.30 8 8 8 $ 12.30 120 0 24 0 144 $ 12.30 $ 3.69 $ 15.99
NA $ 7.50 $ 8.50 8 4 0 $ 7.83 80 0 24 0 104 $ 7.83 $ 2.35 $ 10.18
Agency Employees
RN $ 22.00 $ 24.00 $ 25.00 8 8 8 $ 23.67 120 0 24 0 144 $ 23.67 $ - 0 $ 23.67
LPN $ 16.00 $ 17.00 $ 18.00 8 8 8 $ 17.00 120 0 24 0 144 $ 17.00 $ - 0 $ 17.00
NA $ 12.00 $ 13.00 8 4 0 $ 12.33 60 0 24 0 84 $ 12.33 $ - 0 $ 12.33

Labor Mix

Admin Staff AM PM Total
HN 1 0 1
NA 4 0 4
Total 5 0 5
Direct Care Staff AM PM Total Skill Mix
RN 15 15 30 60.0%
LPN 8 8 16 32.0%
US 2 2 4 8.0%
Total 25 25 50 100%

Regular Labor Cost

Admin Staff Direct Care Staff Cost Per Labor Category Total Cost
Pay Period Regular HN NA RN (60%) LPN (32%) NA (8%) HN NA RN LPN NA
1 SEP 84 2 8 44.40 23.68 5.92 $ 4,242.00 $ 6,625.60 $ 82,548.48 $ 29,717.45 $ 4,902.94 $ 128,036.48
2 SEP 83 2 8 43.80 23.36 5.84 $ 4,242.00 $ 6,625.60 $ 81,432.96 $ 29,315.87 $ 4,836.69 $ 126,453.11
3 OCT 88 2 8 46.80 24.96 6.24 $ 4,242.00 $ 6,625.60 $ 87,010.56 $ 31,323.80 $ 5,167.97 $ 134,369.93
4 OCT 98 2 8 52.80 28.16 7.04 $ 4,242.00 $ 6,625.60 $ 98,165.76 $ 35,339.67 $ 5,830.53 $ 150,203.56
5 NOV 99 2 8 53.40 28.48 7.12 $ 4,242.00 $ 6,625.60 $ 99,281.28 $ 35,741.26 $ 5,896.78 $ 151,786.92
6 NOV 99.4 2 8 53.64 28.61 7.15 $ 4,242.00 $ 6,625.60 $ 99,727.49 $ 35,901.90 $ 5,923.29 $ 152,420.27
7 NOV 99 2 8 53.40 28.48 7.12 $ 4,242.00 $ 6,625.60 $ 99,281.28 $ 35,741.26 $ 5,896.78 $ 151,786.92
8 DEC 99.8 2 8 53.88 28.74 7.18 $ 4,242.00 $ 6,625.60 $ 100,173.70 $ 36,062.53 $ 5,949.79 $ 153,053.62
9 DEC 100.3 2 8 54.18 28.90 7.22 $ 4,242.00 $ 6,625.60 $ 100,731.46 $ 36,263.32 $ 5,982.92 $ 153,845.30
10 JAN 100.4 2 8 54.24 28.93 7.23 $ 4,242.00 $ 6,625.60 $ 100,843.01 $ 36,303.48 $ 5,989.54 $ 154,003.63
11 JAN 106.31 2 8 57.79 30.82 7.70 $ 4,242.00 $ 6,625.60 $ 107,435.73 $ 38,676.86 $ 6,381.12 $ 163,361.31
12 FEB 105.64 2 8 57.38 30.60 7.65 $ 4,242.00 $ 6,625.60 $ 106,688.33 $ 38,407.80 $ 6,336.72 $ 162,300.46
13 FEB 106.5 2 8 57.90 30.88 7.72 $ 4,242.00 $ 6,625.60 $ 107,647.68 $ 38,753.16 $ 6,393.70 $ 163,662.15
14 MAR 106.78 2 8 58.07 30.97 7.74 $ 4,242.00 $ 6,625.60 $ 107,960.03 $ 38,865.61 $ 6,412.26 $ 164,105.49
15 MAR 106.31 2 8 57.79 30.82 7.70 $ 4,242.00 $ 6,625.60 $ 107,435.73 $ 38,676.86 $ 6,381.12 $ 163,361.31
16 APR 104.5 2 8 56.70 30.24 7.56 $ 4,242.00 $ 6,625.60 $ 105,416.64 $ 37,949.99 $ 6,261.19 $ 160,495.42
17 APR 106.5 2 8 57.90 30.88 7.72 $ 4,242.00 $ 6,625.60 $ 107,647.68 $ 38,753.16 $ 6,393.70 $ 163,662.15
18 APR 106.02 2 8 57.61 30.73 7.68 $ 4,242.00 $ 6,625.60 $ 107,112.23 $ 38,560.40 $ 6,361.90 $ 162,902.13
19 MAY 105.36 2 8 57.22 30.52 7.63 $ 4,242.00 $ 6,625.60 $ 106,375.99 $ 38,295.36 $ 6,318.17 $ 161,857.11
20 MAY 104.22 2 8 56.53 30.15 7.54 $ 4,242.00 $ 6,625.60 $ 105,104.29 $ 37,837.55 $ 6,242.64 $ 160,052.08
21 JUN 102.51 2 8 55.51 29.60 7.40 $ 4,242.00 $ 6,625.60 $ 103,196.76 $ 37,150.83 $ 6,129.34 $ 157,344.53
22 JUN 101.46 2 8 54.88 29.27 7.32 $ 4,242.00 $ 6,625.60 $ 102,025.46 $ 36,729.17 $ 6,059.77 $ 155,682.00
23 JUL 97.19 2 8 52.31 27.90 6.98 $ 4,242.00 $ 6,625.60 $ 97,262.19 $ 35,014.39 $ 5,776.86 $ 148,921.04
24 JUL 90 2 8 48.00 25.60 6.40 $ 4,242.00 $ 6,625.60 $ 89,241.60 $ 32,126.98 $ 5,300.48 $ 137,536.66
25 AUG 90 2 8 48.00 25.60 6.40 $ 4,242.00 $ 6,625.60 $ 89,241.60 $ 32,126.98 $ 5,300.48 $ 137,536.66
26 AUG 89 2 8 47.40 25.28 6.32 $ 4,242.00 $ 6,625.60 $ 88,126.08 $ 31,725.39 $ 5,234.22 $ 135,953.29
Annual Totals $ 110,292.00 $ 172,265.60 $ 2,587,113.98 $ 931,361.03 $ 153,660.92 $ 3,954,693.53

Flex Pool Labor Cost

Direct Care Staff Total Cost
Pay Period Flex Pool RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 10 6.00 3.20 0.80 $ 11,466.00 $ 4,298.11 $ 684.32 $ 16,448.43
7 NOV 9.5 5.70 3.04 0.76 $ 10,892.70 $ 4,083.21 $ 650.10 $ 15,626.01
8 DEC 9.7 5.82 3.10 0.78 $ 11,122.02 $ 4,169.17 $ 663.79 $ 15,954.98
9 DEC 9.1 5.46 2.91 0.73 $ 10,434.06 $ 3,911.28 $ 622.73 $ 14,968.07
10 JAN 9.3 5.58 2.98 0.74 $ 10,663.38 $ 3,997.24 $ 636.42 $ 15,297.04
11 JAN 8.9 5.34 2.85 0.71 $ 10,204.74 $ 3,825.32 $ 609.04 $ 14,639.10
12 FEB 10 6.00 3.20 0.80 $ 11,466.00 $ 4,298.11 $ 684.32 $ 16,448.43
13 FEB 11.8 7.08 3.78 0.94 $ 13,529.88 $ 5,071.77 $ 807.50 $ 19,409.15
14 MAR 12.6 7.56 4.03 1.01 $ 14,447.16 $ 5,415.62 $ 862.24 $ 20,725.02
15 MAR 12.9 7.74 4.13 1.03 $ 14,791.14 $ 5,544.56 $ 882.77 $ 21,218.48
16 APR 12.6 7.56 4.03 1.01 $ 14,447.16 $ 5,415.62 $ 862.24 $ 20,725.02
17 APR 12.5 7.50 4.00 1.00 $ 14,332.50 $ 5,372.64 $ 855.40 $ 20,560.54
18 APR 12.9 7.74 4.13 1.03 $ 14,791.14 $ 5,544.56 $ 882.77 $ 21,218.48
19 MAY 12 7.20 3.84 0.96 $ 13,759.20 $ 5,157.73 $ 821.18 $ 19,738.12
20 MAY 10.1 6.06 3.23 0.81 $ 11,580.66 $ 4,341.09 $ 691.16 $ 16,612.92
21 JUN 11.6 6.96 3.71 0.93 $ 13,300.56 $ 4,985.81 $ 793.81 $ 19,080.18
22 JUN 9.9 5.94 3.17 0.79 $ 11,351.34 $ 4,255.13 $ 677.48 $ 16,283.95
23 JUL 9.2 5.52 2.94 0.74 $ 10,548.72 $ 3,954.26 $ 629.57 $ 15,132.56
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 223,128.36 $ 83,641.26 $ 13,316.87 $ 320,086.49

Agency Labor Cost

Direct Care Staff Total Cost
Pay Period Agency RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 10 6.00 3.20 0.80 $ 11,928.00 $ 4,569.60 $ 828.80 $ 17,326.40
7 NOV 9.5 5.70 3.04 0.76 $ 11,331.60 $ 4,341.12 $ 787.36 $ 16,460.08
8 DEC 9.7 5.82 3.10 0.78 $ 11,570.16 $ 4,432.51 $ 803.94 $ 16,806.61
9 DEC 9.1 5.46 2.91 0.73 $ 10,854.48 $ 4,158.34 $ 754.21 $ 15,767.02
10 JAN 9.3 5.58 2.98 0.74 $ 11,093.04 $ 4,249.73 $ 770.78 $ 16,113.55
11 JAN 8.9 5.34 2.85 0.71 $ 10,615.92 $ 4,066.94 $ 737.63 $ 15,420.50
12 FEB 10 6.00 3.20 0.80 $ 11,928.00 $ 4,569.60 $ 828.80 $ 17,326.40
13 FEB 11.8 7.08 3.78 0.94 $ 14,075.04 $ 5,392.13 $ 977.98 $ 20,445.15
14 MAR 12.6 7.56 4.03 1.01 $ 15,029.28 $ 5,757.70 $ 1,044.29 $ 21,831.26
15 MAR 12.9 7.74 4.13 1.03 $ 15,387.12 $ 5,894.78 $ 1,069.15 $ 22,351.06
16 APR 12.6 7.56 4.03 1.01 $ 15,029.28 $ 5,757.70 $ 1,044.29 $ 21,831.26
17 APR 12.5 7.50 4.00 1.00 $ 14,910.00 $ 5,712.00 $ 1,036.00 $ 21,658.00
18 APR 12.9 7.74 4.13 1.03 $ 15,387.12 $ 5,894.78 $ 1,069.15 $ 22,351.06
19 MAY 12 7.20 3.84 0.96 $ 14,313.60 $ 5,483.52 $ 994.56 $ 20,791.68
20 MAY 10.1 6.06 3.23 0.81 $ 12,047.28 $ 4,615.30 $ 837.09 $ 17,499.66
21 JUN 11.6 6.96 3.71 0.93 $ 13,836.48 $ 5,300.74 $ 961.41 $ 20,098.62
22 JUN 9.9 5.94 3.17 0.79 $ 11,808.72 $ 4,523.90 $ 820.51 $ 17,153.14
23 JUL 9.2 5.52 2.94 0.74 $ 10,973.76 $ 4,204.03 $ 762.50 $ 15,940.29
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 232,118.88 $ 88,924.42 $ 16,128.45 $ 337,171.74

Total Labor Cost

FTE Count By Source Labor Cost by Source
Pay Period Regular Flex Pool Agency Total Regular Flex Pool Agency Total
1 SEP 84 0 0 84 $ 128,036.48 $ - 0 $ - 0 $ 128,036.48
2 SEP 83 0 0 83 $ 126,453.11 $ - 0 $ - 0 $ 126,453.11
3 OCT 88 0 0 88 $ 134,369.93 $ - 0 $ - 0 $ 134,369.93
4 OCT 98 0 0 98 $ 150,203.56 $ - 0 $ - 0 $ 150,203.56
5 NOV 99 0 0 99 $ 151,786.92 $ - 0 $ - 0 $ 151,786.92
6 NOV 99.4 10 10.6 120 $ 152,420.27 $ 16,448.43 $ 17,326.40 $ 186,195.10
7 NOV 99 9.5 21.5 130 $ 151,786.92 $ 15,626.01 $ 16,460.08 $ 183,873.02
8 DEC 99.8 9.7 15.5 125 $ 153,053.62 $ 15,954.98 $ 16,806.61 $ 185,815.20
9 DEC 100.3 9.1 20.6 130 $ 153,845.30 $ 14,968.07 $ 15,767.02 $ 184,580.39
10 JAN 100.4 9.3 21.3 131 $ 154,003.63 $ 15,297.04 $ 16,113.55 $ 185,414.23
11 JAN 106.31 8.9 13.8 129.01 $ 163,361.31 $ 14,639.10 $ 15,420.50 $ 193,420.91
12 FEB 105.64 10 6.36 122 $ 162,300.46 $ 16,448.43 $ 17,326.40 $ 196,075.29
13 FEB 106.5 11.8 6.71 125.01 $ 163,662.15 $ 19,409.15 $ 20,445.15 $ 203,516.45
14 MAR 106.78 12.6 12.62 132 $ 164,105.49 $ 20,725.02 $ 21,831.26 $ 206,661.78
15 MAR 106.31 12.9 4.79 124 $ 163,361.31 $ 21,218.48 $ 22,351.06 $ 206,930.84
16 APR 104.5 12.6 4.9 122 $ 160,495.42 $ 20,725.02 $ 21,831.26 $ 203,051.71
17 APR 106.5 12.5 1.01 120.01 $ 163,662.15 $ 20,560.54 $ 21,658.00 $ 205,880.69
18 APR 106.02 12.9 1.08 120 $ 162,902.13 $ 21,218.48 $ 22,351.06 $ 206,471.67
19 MAY 105.36 12 0.64 118 $ 161,857.11 $ 19,738.12 $ 20,791.68 $ 202,386.91
20 MAY 104.22 10.1 1.69 116.01 $ 160,052.08 $ 16,612.92 $ 17,499.66 $ 194,164.66
21 JUN 102.51 11.6 1.9 116.01 $ 157,344.53 $ 19,080.18 $ 20,098.62 $ 196,523.33
22 JUN 101.46 9.9 2.64 114 $ 155,682.00 $ 16,283.95 $ 17,153.14 $ 189,119.08
23 JUL 97.19 9.2 3.61 110 $ 148,921.04 $ 15,132.56 $ 15,940.29 $ 179,993.88
24 JUL 90 0 0 90 $ 137,536.66 $ - 0 $ - 0 $ 137,536.66
25 AUG 90 0 0 90 $ 137,536.66 $ - 0 $ - 0 $ 137,536.66
26 AUG 89 0 0 89 $ 135,953.29 $ - 0 $ - 0 $ 135,953.29
Annual Total $ 3,954,693.53 $ 320,086.49 $ 337,171.74 $ 4,611,951.76
Change #1 $ 4,871,284.74 No weekday overtime
Change #2 $ 4,611,951.76 Labor Mix Change
Change #3 $ 4,895,293.37 Right-size Labor Force

Staff Needs (22 HPPD)

Nursing Staff FTE Nursing Staff Hours
Pay Period ADC Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 6067.6 44.40 23.68 5.92 3729.6 1989.12 497.28 6216 148.4
2 SEP 19.7 6067.6 43.80 23.36 5.84 3679.2 1962.24 490.56 6132 64.4
3 OCT 21.2 6529.6 46.80 24.96 6.24 3931.2 2096.64 524.16 6552 22.4
4 OCT 25.7 7915.6 52.80 28.16 7.04 4435.2 2365.44 591.36 7392 -523.6
5 NOV 28.8 8870.4 53.40 28.48 7.12 4485.6 2392.32 598.08 7476 -1394.4
6 NOV 36.3 11180.4 65.64 35.01 8.75 5513.76 2940.672 735.168 9189.6 -1990.8
7 NOV 39.3 12104.4 64.80 34.56 8.64 5443.2 2903.04 725.76 9072 -3032.4
8 DEC 36.3 11180.4 65.52 34.94 8.74 5503.68 2935.296 733.824 9172.8 -2007.6
9 DEC 39.3 12104.4 65.10 34.72 8.68 5468.4 2916.48 729.12 9114 -2990.4
10 JAN 39.3 12104.4 65.40 34.88 8.72 5493.6 2929.92 732.48 9156 -2948.4
11 JAN 39.3 12104.4 68.47 36.52 9.13 5751.144 3067.2768 766.8192 9585.24 -2519.16
12 FEB 39.3 12104.4 69.38 37.00 9.25 5828.256 3108.4032 777.1008 9713.76 -2390.64
13 FEB 39.3 12104.4 72.06 38.43 9.61 6053.04 3228.288 807.072 10088.4 -2016
14 MAR 39.3 12104.4 73.19 39.03 9.76 6147.792 3278.8224 819.7056 10246.32 -1858.08
15 MAR 36.3 11180.4 73.27 39.08 9.77 6154.344 3282.3168 820.5792 10257.24 -923.16
16 APR 33.3 10256.4 71.82 38.30 9.58 6032.88 3217.536 804.384 10054.8 -201.6
17 APR 30.3 9332.4 72.90 38.88 9.72 6123.6 3265.92 816.48 10206 873.6
18 APR 30.3 9332.4 73.09 38.98 9.75 6139.728 3274.5216 818.6304 10232.88 900.48
19 MAY 26.5 8162 71.62 38.20 9.55 6015.744 3208.3968 802.0992 10026.24 1864.24
20 MAY 26.5 8162 68.65 36.61 9.15 5766.768 3075.6096 768.9024 9611.28 1449.28
21 JUN 25.1 7730.8 69.43 37.03 9.26 5831.784 3110.2848 777.5712 9719.64 1988.84
22 JUN 25.1 7730.8 66.76 35.60 8.90 5607.504 2990.6688 747.6672 9345.84 1615.04
23 JUL 22.7 6991.6 63.35 33.79 8.45 5321.736 2838.2592 709.5648 8869.56 1877.96
24 JUL 21.5 6622 48.00 25.60 6.40 4032 2150.4 537.6 6720 98
25 AUG 19.7 6067.6 48.00 25.60 6.40 4032 2150.4 537.6 6720 652.4
26 AUG 19.7 6067.6 47.40 25.28 6.32 3981.6 2123.52 530.88 6636 568.4
Annual Totals -12672.8

Staff Needs (3.5 Acuity)

Direct Care Staff Direct Care % Direct Care Hours
Pay Period ADC Acuity Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 2.5 2413.25 44.40 23.68 5.92 42% 58% 50% 1566.432 1153.6896 248.64 2968.7616 555.5116
2 SEP 19.7 2.6 2509.78 43.80 23.36 5.84 42% 58% 50% 1545.264 1138.0992 245.28 2928.6432 418.8632
3 OCT 21.2 2.6 2700.88 46.80 24.96 6.24 42% 58% 50% 1651.104 1216.0512 262.08 3129.2352 428.3552
4 OCT 25.7 2.58 3248.994 52.80 28.16 7.04 42% 58% 50% 1862.784 1371.9552 295.68 3530.4192 281.4252
5 NOV 28.8 2.9 4092.48 53.40 28.48 7.12 42% 58% 50% 1883.952 1387.5456 299.04 3570.5376 -521.9424
6 NOV 36.3 2.87 5104.869 65.64 35.01 8.75 42% 58% 50% 2315.7792 1705.58976 367.584 4388.95296 -715.91604
7 NOV 39.3 2.76 5314.932 64.80 34.56 8.64 42% 58% 50% 2286.144 1683.7632 362.88 4332.7872 -982.1448
8 DEC 36.3 3.2 5691.84 65.52 34.94 8.74 42% 58% 50% 2311.5456 1702.47168 366.912 4380.92928 -1310.91072
9 DEC 39.3 3.4 6547.38 65.10 34.72 8.68 42% 58% 50% 2296.728 1691.5584 364.56 4352.8464 -2194.5336
10 JAN 39.3 3.1 5969.67 65.40 34.88 8.72 42% 58% 50% 2307.312 1699.3536 366.24 4372.9056 -1596.7644
11 JAN 39.3 3.2 6162.24 68.47 36.52 9.13 42% 58% 50% 2415.48048 1779.020544 383.4096 4577.910624 -1584.329376
12 FEB 39.3 3.6 6932.52 69.38 37.00 9.25 42% 58% 50% 2447.86752 1802.873856 388.5504 4639.291776 -2293.228224
13 FEB 39.3 3.4 6547.38 72.06 38.43 9.61 42% 58% 50% 2542.2768 1872.40704 403.536 4818.21984 -1729.16016
14 MAR 39.3 3.6 6932.52 73.19 39.03 9.76 42% 58% 50% 2582.07264 1901.716992 409.8528 4893.642432 -2038.877568
15 MAR 36.3 3.4 6047.58 73.27 39.08 9.77 42% 58% 50% 2584.82448 1903.743744 410.2896 4898.857824 -1148.722176
16 APR 33.3 3.2 5221.44 71.82 38.30 9.58 42% 58% 50% 2533.8096 1866.17088 402.192 4802.17248 -419.26752
17 APR 30.3 3.1 4602.57 72.90 38.88 9.72 42% 58% 50% 2571.912 1894.2336 408.24 4874.3856 271.8156
18 APR 30.3 2.9 4305.63 73.09 38.98 9.75 42% 58% 50% 2578.68576 1899.222528 409.3152 4887.223488 581.593488
19 MAY 26.5 2.9 3765.65 71.62 38.20 9.55 42% 58% 50% 2526.61248 1860.870144 401.0496 4788.532224 1022.882224
20 MAY 26.5 2.7 3505.95 68.65 36.61 9.15 42% 58% 50% 2422.04256 1783.853568 384.4512 4590.347328 1084.397328
21 JUN 25.1 2.5 3074.75 69.43 37.03 9.26 42% 58% 50% 2449.34928 1803.965184 388.7856 4642.100064 1567.350064
22 JUN 25.1 2.2 2705.78 66.76 35.60 8.90 42% 58% 50% 2355.15168 1734.587904 373.8336 4463.573184 1757.793184
23 JUL 22.7 2.4 2669.52 63.35 33.79 8.45 42% 58% 50% 2235.12912 1646.190336 354.7824 4236.101856 1566.581856
24 JUL 21.5 2.5 2633.75 48.00 25.60 6.40 42% 58% 50% 1693.44 1247.232 268.8 3209.472 575.722
25 AUG 19.7 2.5 2413.25 48.00 25.60 6.40 42% 58% 50% 1693.44 1247.232 268.8 3209.472 796.222
26 AUG 19.7 2.3 2220.19 47.40 25.28 6.32 42% 58% 50% 1672.272 1231.6416 265.44 3169.3536 949.1636
Annual Totals -4678.12044

__MACOSX/._Proposed (2).xlsx

Proposed (3).xlsx

Hourly Costs

Hourly Rates Hours per day Avg Reg Hourly Rate Weekday Hours Per Week Weekend Hours Per week Total Hours Per Week Average Total Hourly Rate Hourly Fringe Total Hourly Cost
Regular Employees AM PM Night AM PM Night Reg OT Reg OT
HN $ 17.50 $ 17.50 8 4 0 $ 17.50 60 0 0 24 84 $ 20.00 $ 5.25 $ 25.25
RN $ 14.50 $ 16.00 $ 17.50 8 8 8 $ 16.00 120 0 0 24 144 $ 17.33 $ 4.80 $ 22.13
LPN $ 9.80 $ 10.80 $ 11.80 8 8 8 $ 10.80 120 0 0 24 144 $ 11.70 $ 3.24 $ 14.94
NA $ 6.50 $ 7.50 8 4 0 $ 6.83 60 0 0 24 84 $ 7.81 $ 2.05 $ 9.86
US $ 7.50 $ 8.50 $ 9.50 8 8 8 $ 8.50 120 0 0 24 144 $ 9.21 $ 2.55 $ 11.76
Flex Pool Employees
RN $ 16.00 $ 17.50 $ 19.00 8 8 8 $ 17.50 120 0 24 0 144 $ 17.50 $ 5.25 $ 22.75
LPN $ 11.30 $ 12.30 $ 13.30 8 8 8 $ 12.30 120 0 24 0 144 $ 12.30 $ 3.69 $ 15.99
NA $ 7.50 $ 8.50 8 4 0 $ 7.83 80 0 24 0 104 $ 7.83 $ 2.35 $ 10.18
Agency Employees
RN $ 22.00 $ 24.00 $ 25.00 8 8 8 $ 23.67 120 0 24 0 144 $ 23.67 $ - 0 $ 23.67
LPN $ 16.00 $ 17.00 $ 18.00 8 8 8 $ 17.00 120 0 24 0 144 $ 17.00 $ - 0 $ 17.00
NA $ 12.00 $ 13.00 8 4 0 $ 12.33 60 0 24 0 84 $ 12.33 $ - 0 $ 12.33
Everyone works 42 hours per week
3x12 + 1x6
No more overtime during the week but still have overtime over the weekend
no more weekend only staff
Sunday - Wednesday and Wednesday - Sunday

Labor Mix

Admin Staff AM PM Total
HN 1 0 1
NA 4 0 4
Total 5 0 5
Direct Care Staff AM PM Total Skill Mix
RN 15 15 30 60.0%
LPN 8 8 16 32.0%
US 2 2 4 8.0%
Total 25 25 50 100%

Regular Labor Cost

Admin Staff Direct Care Staff Cost Per Labor Category Total Cost
Pay Period Regular HN NA RN (60%) LPN (32%) NA (8%) HN NA RN LPN NA
1 SEP 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
2 SEP 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
3 OCT 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
4 OCT 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
5 NOV 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
6 NOV 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
7 NOV 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
8 DEC 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
9 DEC 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
10 JAN 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
11 JAN 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
12 FEB 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
13 FEB 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
14 MAR 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
15 MAR 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
16 APR 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
17 APR 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
18 APR 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
19 MAY 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
20 MAY 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
21 JUN 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
22 JUN 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
23 JUL 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
24 JUL 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
25 AUG 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
26 AUG 72 2 8 37.20 19.84 4.96 $ 4,242.00 $ 6,625.60 $ 69,162.24 $ 24,898.41 $ 4,107.87 $ 109,036.12
Annual Totals $ 110,292.00 $ 172,265.60 $ 1,798,218.24 $ 647,358.57 $ 106,804.67 $ 2,834,939.08

Flex Pool Labor Cost

Direct Care Staff Total Cost
Pay Period Flex Pool RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 1 0.60 0.32 0.08 $ 1,146.60 $ 429.81 $ 68.43 $ 1,644.84
3 OCT 6 3.60 1.92 0.48 $ 6,879.60 $ 2,578.87 $ 410.59 $ 9,869.06
4 OCT 20 12.00 6.40 1.60 $ 22,932.00 $ 8,596.22 $ 1,368.64 $ 32,896.86
5 NOV 41 24.60 13.12 3.28 $ 47,010.60 $ 17,622.26 $ 2,805.71 $ 67,438.57
6 NOV 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
7 NOV 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
8 DEC 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
9 DEC 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
10 JAN 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
11 JAN 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
12 FEB 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
13 FEB 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
14 MAR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
15 MAR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
16 APR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
17 APR 53 31.80 16.96 4.24 $ 60,769.80 $ 22,779.99 $ 3,626.90 $ 87,176.69
18 APR 46 27.60 14.72 3.68 $ 52,743.60 $ 19,771.32 $ 3,147.87 $ 75,662.79
19 MAY 32 19.20 10.24 2.56 $ 36,691.20 $ 13,753.96 $ 2,189.82 $ 52,634.98
20 MAY 26 15.60 8.32 2.08 $ 29,811.60 $ 11,175.09 $ 1,779.23 $ 42,765.92
21 JUN 15 9.00 4.80 1.20 $ 17,199.00 $ 6,447.17 $ 1,026.48 $ 24,672.65
22 JUN 6 3.60 1.92 0.48 $ 6,879.60 $ 2,578.87 $ 410.59 $ 9,869.06
23 JUL 5 3.00 1.60 0.40 $ 5,733.00 $ 2,149.06 $ 342.16 $ 8,224.22
24 JUL 4 2.40 1.28 0.32 $ 4,586.40 $ 1,719.24 $ 273.73 $ 6,579.37
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 1,049,139.00 $ 393,277.25 $ 62,615.28 $ 1,505,031.53

Agency Labor Cost

Direct Care Staff Total Cost
Pay Period Agency RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 6 3.60 1.92 0.48 $ 7,156.80 $ 2,741.76 $ 497.28 $ 10,395.84
7 NOV 11 6.60 3.52 0.88 $ 13,120.80 $ 5,026.56 $ 911.68 $ 19,059.04
8 DEC 20 12.00 6.40 1.60 $ 23,856.00 $ 9,139.20 $ 1,657.60 $ 34,652.80
9 DEC 42 25.20 13.44 3.36 $ 50,097.60 $ 19,192.32 $ 3,480.96 $ 72,770.88
10 JAN 27 16.20 8.64 2.16 $ 32,205.60 $ 12,337.92 $ 2,237.76 $ 46,781.28
11 JAN 32 19.20 10.24 2.56 $ 38,169.60 $ 14,622.72 $ 2,652.16 $ 55,444.48
12 FEB 51 30.60 16.32 4.08 $ 60,832.80 $ 23,304.96 $ 4,226.88 $ 88,364.64
13 FEB 42 25.20 13.44 3.36 $ 50,097.60 $ 19,192.32 $ 3,480.96 $ 72,770.88
14 MAR 51 30.60 16.32 4.08 $ 60,832.80 $ 23,304.96 $ 4,226.88 $ 88,364.64
15 MAR 29 17.40 9.28 2.32 $ 34,591.20 $ 13,251.84 $ 2,403.52 $ 50,246.56
16 APR 9 5.40 2.88 0.72 $ 10,735.20 $ 4,112.64 $ 745.92 $ 15,593.76
17 APR 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
18 APR 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
19 MAY 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
20 MAY 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
21 JUN 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
22 JUN 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
23 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 381,696.00 $ 146,227.20 $ 26,521.60 $ 554,444.80

Staff Needs (3.5 Acuity)

Direct Care Staff Direct Care % Direct Care Hours
Pay Period ADC Acuity Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 2.5 2413.25 37.20 19.84 4.96 42% 58% 50% 1312.416 966.6048 208.32 2487.3408 74.0908
2 SEP 19.7 2.6 2509.78 37.80 20.16 5.04 42% 58% 50% 1333.584 982.1952 211.68 2527.4592 17.6792
3 OCT 21.2 2.6 2700.88 40.80 21.76 5.44 42% 58% 50% 1439.424 1060.1472 228.48 2728.0512 27.1712
4 OCT 25.7 2.58 3248.994 49.20 26.24 6.56 42% 58% 50% 1735.776 1278.4128 275.52 3289.7088 40.7148
5 NOV 28.8 2.9 4092.48 61.80 32.96 8.24 42% 58% 50% 2180.304 1605.8112 346.08 4132.1952 39.7152
6 NOV 36.3 2.87 5104.869 76.80 40.96 10.24 42% 58% 50% 2709.504 1995.5712 430.08 5135.1552 30.2862
7 NOV 39.3 2.76 5314.932 79.80 42.56 10.64 42% 58% 50% 2815.344 2073.5232 446.88 5335.7472 20.8152
8 DEC 36.3 3.2 5691.84 85.20 45.44 11.36 42% 58% 50% 3005.856 2213.8368 477.12 5696.8128 4.9728
9 DEC 39.3 3.4 6547.38 98.40 52.48 13.12 42% 58% 50% 3471.552 2556.8256 551.04 6579.4176 32.0376
10 JAN 39.3 3.1 5969.67 89.40 47.68 11.92 42% 58% 50% 3154.032 2322.9696 500.64 5977.6416 7.9716
11 JAN 39.3 3.2 6162.24 92.40 49.28 12.32 42% 58% 50% 3259.872 2400.9216 517.44 6178.2336 15.9936
12 FEB 39.3 3.6 6932.52 103.80 55.36 13.84 42% 58% 50% 3662.064 2697.1392 581.28 6940.4832 7.9632
13 FEB 39.3 3.4 6547.38 98.40 52.48 13.12 42% 58% 50% 3471.552 2556.8256 551.04 6579.4176 32.0376
14 MAR 39.3 3.6 6932.52 103.80 55.36 13.84 42% 58% 50% 3662.064 2697.1392 581.28 6940.4832 7.9632
15 MAR 36.3 3.4 6047.58 90.60 48.32 12.08 42% 58% 50% 3196.368 2354.1504 507.36 6057.8784 10.2984
16 APR 33.3 3.2 5221.44 78.60 41.92 10.48 42% 58% 50% 2773.008 2042.3424 440.16 5255.5104 34.0704
17 APR 30.3 3.1 4602.57 69.00 36.80 9.20 42% 58% 50% 2434.32 1792.896 386.4 4613.616 11.046
18 APR 30.3 2.9 4305.63 64.80 34.56 8.64 42% 58% 50% 2286.144 1683.7632 362.88 4332.7872 27.1572
19 MAY 26.5 2.9 3765.65 56.40 30.08 7.52 42% 58% 50% 1989.792 1465.4976 315.84 3771.1296 5.4796
20 MAY 26.5 2.7 3505.95 52.80 28.16 7.04 42% 58% 50% 1862.784 1371.9552 295.68 3530.4192 24.4692
21 JUN 25.1 2.5 3074.75 46.20 24.64 6.16 42% 58% 50% 1629.936 1200.4608 258.72 3089.1168 14.3668
22 JUN 25.1 2.2 2705.78 40.80 21.76 5.44 42% 58% 50% 1439.424 1060.1472 228.48 2728.0512 22.2712
23 JUL 22.7 2.4 2669.52 40.20 21.44 5.36 42% 58% 50% 1418.256 1044.5568 225.12 2687.9328 18.4128
24 JUL 21.5 2.5 2633.75 39.60 21.12 5.28 42% 58% 50% 1397.088 1028.9664 221.76 2647.8144 14.0644
25 AUG 19.7 2.5 2413.25 37.20 19.84 4.96 42% 58% 50% 1312.416 966.6048 208.32 2487.3408 74.0908
26 AUG 19.7 2.3 2220.19 37.20 19.84 4.96 42% 58% 50% 1312.416 966.6048 208.32 2487.3408 267.1508
Annual Totals 882.2898

Total Labor Cost

FTE Count By Source Labor Cost by Source
Pay Period Regular Flex Pool Agency Total Regular Flex Pool Agency Total
1 SEP 72 0 0 72 $ 109,036.12 $ - 0 $ - 0 $ 109,036.12
2 SEP 72 1 0 73 $ 109,036.12 $ 1,644.84 $ - 0 $ 110,680.96
3 OCT 72 6 0 78 $ 109,036.12 $ 9,869.06 $ - 0 $ 118,905.18
4 OCT 72 20 0 92 $ 109,036.12 $ 32,896.86 $ - 0 $ 141,932.98
5 NOV 72 41 0 113 $ 109,036.12 $ 67,438.57 $ - 0 $ 176,474.69
6 NOV 72 50 16 138 $ 109,036.12 $ 98,690.59 $ 10,395.84 $ 218,122.55
7 NOV 72 60 11 143 $ 109,036.12 $ 98,690.59 $ 19,059.04 $ 226,785.75
8 DEC 72 60 20 152 $ 109,036.12 $ 98,690.59 $ 34,652.80 $ 242,379.51
9 DEC 72 60 42 174 $ 109,036.12 $ 98,690.59 $ 72,770.88 $ 280,497.59
10 JAN 72 60 27 159 $ 109,036.12 $ 98,690.59 $ 46,781.28 $ 254,507.99
11 JAN 72 60 32 164 $ 109,036.12 $ 98,690.59 $ 55,444.48 $ 263,171.19
12 FEB 72 60 51 183 $ 109,036.12 $ 98,690.59 $ 88,364.64 $ 296,091.35
13 FEB 72 60 42 174 $ 109,036.12 $ 98,690.59 $ 72,770.88 $ 280,497.59
14 MAR 72 60 51 183 $ 109,036.12 $ 98,690.59 $ 88,364.64 $ 296,091.35
15 MAR 72 60 29 161 $ 109,036.12 $ 98,690.59 $ 50,246.56 $ 257,973.27
16 APR 72 60 9 141 $ 109,036.12 $ 98,690.59 $ 15,593.76 $ 223,320.47
17 APR 72 53 0 125 $ 109,036.12 $ 87,176.69 $ - 0 $ 196,212.81
18 APR 72 46 0 118 $ 109,036.12 $ 75,662.79 $ - 0 $ 184,698.91
19 MAY 72 32 0 104 $ 109,036.12 $ 52,634.98 $ - 0 $ 161,671.10
20 MAY 72 26 0 98 $ 109,036.12 $ 42,765.92 $ - 0 $ 151,802.04
21 JUN 72 15 0 87 $ 109,036.12 $ 24,672.65 $ - 0 $ 133,708.77
22 JUN 72 6 0 78 $ 109,036.12 $ 9,869.06 $ - 0 $ 118,905.18
23 JUL 72 5 0 77 $ 109,036.12 $ 8,224.22 $ - 0 $ 117,260.33
24 JUL 72 4 0 76 $ 109,036.12 $ 6,579.37 $ - 0 $ 115,615.49
25 AUG 72 0 0 72 $ 109,036.12 $ - 0 $ - 0 $ 109,036.12
26 AUG 72 0 0 72 $ 109,036.12 $ - 0 $ - 0 $ 109,036.12
Annual Total $ 2,834,939.08 $ 1,505,031.53 $ 554,444.80 $ 4,894,415.41
Current Situation $ 5,283,048.61
Change #1 $ 4,871,284.74 No weekday overtime
Change #2 $ 4,611,951.76 Labor Mix Change
Change #3 $ 4,894,415.41 Right-size Labor Force

__MACOSX/._Proposed (3).xlsx

Proposed (4).xlsx

Hourly Costs

Hourly Rates Hours per day Avg Reg Hourly Rate Weekday Hours Per Week Weekend Hours Per week Total Hours Per Week Average Total Hourly Rate Hourly Fringe Total Hourly Cost
Regular Employees AM PM Night AM PM Night Reg OT Reg OT
HN $ 17.50 $ 17.50 8 4 0 $ 17.50 60 0 0 24 84 $ 20.00 $ 5.25 $ 25.25
RN $ 14.50 $ 16.00 $ 17.50 8 8 8 $ 16.00 120 0 0 24 144 $ 17.33 $ 4.80 $ 22.13
LPN $ 9.80 $ 10.80 $ 11.80 8 8 8 $ 10.80 120 0 0 24 144 $ 11.70 $ 3.24 $ 14.94
NA $ 6.50 $ 7.50 8 4 0 $ 6.83 60 0 0 24 84 $ 7.81 $ 2.05 $ 9.86
US $ 7.50 $ 8.50 $ 9.50 8 8 8 $ 8.50 120 0 0 24 144 $ 9.21 $ 2.55 $ 11.76
Flex Pool Employees
RN $ 16.00 $ 17.50 $ 19.00 8 8 8 $ 17.50 120 0 24 0 144 $ 17.50 $ 5.25 $ 22.75
LPN $ 11.30 $ 12.30 $ 13.30 8 8 8 $ 12.30 120 0 24 0 144 $ 12.30 $ 3.69 $ 15.99
NA $ 7.50 $ 8.50 8 4 0 $ 7.83 80 0 24 0 104 $ 7.83 $ 2.35 $ 10.18
Agency Employees
RN $ 22.00 $ 24.00 $ 25.00 8 8 8 $ 23.67 120 0 24 0 144 $ 23.67 $ - 0 $ 23.67
LPN $ 16.00 $ 17.00 $ 18.00 8 8 8 $ 17.00 120 0 24 0 144 $ 17.00 $ - 0 $ 17.00
NA $ 12.00 $ 13.00 8 4 0 $ 12.33 60 0 24 0 84 $ 12.33 $ - 0 $ 12.33
Everyone works 42 hours per week
3x12 + 1x6
No more overtime during the week but still have overtime over the weekend
no more weekend only staff
Sunday - Wednesday and Wednesday - Sunday

Labor Mix

Admin Staff AM PM Total
HN 1 0 1
NA 4 0 4
Total 5 0 5
Direct Care Staff AM PM Total Skill Mix
RN 15 15 30 60.0%
LPN 8 8 16 32.0%
US 2 2 4 8.0%
Total 25 25 50 100%

Regular Labor Cost

Admin Staff Direct Care Staff Cost Per Labor Category Total Cost
Pay Period Regular HN NA RN (60%) LPN (32%) NA (8%) HN NA RN LPN NA
1 SEP 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
2 SEP 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
3 OCT 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
4 OCT 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
5 NOV 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
6 NOV 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
7 NOV 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
8 DEC 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
9 DEC 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
10 JAN 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
11 JAN 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
12 FEB 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
13 FEB 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
14 MAR 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
15 MAR 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
16 APR 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
17 APR 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
18 APR 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
19 MAY 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
20 MAY 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
21 JUN 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
22 JUN 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
23 JUL 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
24 JUL 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
25 AUG 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
26 AUG 65 2 8 33.00 17.60 4.40 $ 4,242.00 $ 6,625.60 $ 61,353.60 $ 22,087.30 $ 3,644.08 $ 97,952.58
Annual Totals $ 110,292.00 $ 172,265.60 $ 1,595,193.60 $ 574,269.70 $ 94,746.08 $ 2,546,766.98

Flex Pool Labor Cost

Direct Care Staff Total Cost
Pay Period Flex Pool RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 2 1.20 0.64 0.16 $ 2,293.20 $ 859.62 $ 136.86 $ 3,289.69
3 OCT 6 3.60 1.92 0.48 $ 6,879.60 $ 2,578.87 $ 410.59 $ 9,869.06
4 OCT 19 11.40 6.08 1.52 $ 21,785.40 $ 8,166.41 $ 1,300.21 $ 31,252.02
5 NOV 38 22.80 12.16 3.04 $ 43,570.80 $ 16,332.83 $ 2,600.42 $ 62,504.04
6 NOV 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
7 NOV 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
8 DEC 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
9 DEC 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
10 JAN 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
11 JAN 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
12 FEB 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
13 FEB 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
14 MAR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
15 MAR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
16 APR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
17 APR 49 29.40 15.68 3.92 $ 56,183.40 $ 21,060.75 $ 3,353.17 $ 80,597.32
18 APR 43 25.80 13.76 3.44 $ 49,303.80 $ 18,481.88 $ 2,942.58 $ 70,728.26
19 MAY 30 18.00 9.60 2.40 $ 34,398.00 $ 12,894.34 $ 2,052.96 $ 49,345.30
20 MAY 25 15.00 8.00 2.00 $ 28,665.00 $ 10,745.28 $ 1,710.80 $ 41,121.08
21 JUN 15 9.00 4.80 1.20 $ 17,199.00 $ 6,447.17 $ 1,026.48 $ 24,672.65
22 JUN 7 4.20 2.24 0.56 $ 8,026.20 $ 3,008.68 $ 479.02 $ 11,513.90
23 JUL 6 3.60 1.92 0.48 $ 6,879.60 $ 2,578.87 $ 410.59 $ 9,869.06
24 JUL 5 3.00 1.60 0.40 $ 5,733.00 $ 2,149.06 $ 342.16 $ 8,224.22
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 1,037,673.00 $ 388,979.14 $ 61,930.96 $ 1,488,583.10

Agency Labor Cost

Direct Care Staff Total Cost
Pay Period Agency RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 1 0.60 0.32 0.08 $ 1,192.80 $ 456.96 $ 82.88 $ 1,732.64
7 NOV 5 3.00 1.60 0.40 $ 5,964.00 $ 2,284.80 $ 414.40 $ 8,663.20
8 DEC 14 8.40 4.48 1.12 $ 16,699.20 $ 6,397.44 $ 1,160.32 $ 24,256.96
9 DEC 33 19.80 10.56 2.64 $ 39,362.40 $ 15,079.68 $ 2,735.04 $ 57,177.12
10 JAN 20 12.00 6.40 1.60 $ 23,856.00 $ 9,139.20 $ 1,657.60 $ 34,652.80
11 JAN 25 15.00 8.00 2.00 $ 29,820.00 $ 11,424.00 $ 2,072.00 $ 43,316.00
12 FEB 42 25.20 13.44 3.36 $ 50,097.60 $ 19,192.32 $ 3,480.96 $ 72,770.88
13 FEB 33 19.80 10.56 2.64 $ 39,362.40 $ 15,079.68 $ 2,735.04 $ 57,177.12
14 MAR 42 25.20 13.44 3.36 $ 50,097.60 $ 19,192.32 $ 3,480.96 $ 72,770.88
15 MAR 22 13.20 7.04 1.76 $ 26,241.60 $ 10,053.12 $ 1,823.36 $ 38,118.08
16 APR 3 1.80 0.96 0.24 $ 3,578.40 $ 1,370.88 $ 248.64 $ 5,197.92
17 APR 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
18 APR 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
19 MAY 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
20 MAY 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
21 JUN 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
22 JUN 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
23 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 286,272.00 $ 109,670.40 $ 19,891.20 $ 415,833.60

Staff Needs (3.5 Acuity)

Direct Care Staff Direct Care % Direct Care Hours
Pay Period ADC Acuity Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 2.5 2413.25 33.00 17.60 4.40 47% 63% 55% 1302.84 931.392 203.28 2437.512 24.262
2 SEP 19.7 2.6 2509.78 34.20 18.24 4.56 47% 63% 55% 1350.216 965.2608 210.672 2526.1488 16.3688
3 OCT 21.2 2.6 2700.88 36.60 19.52 4.88 47% 63% 55% 1444.968 1032.9984 225.456 2703.4224 2.5424
4 OCT 25.7 2.58 3248.994 44.40 23.68 5.92 47% 63% 55% 1752.912 1253.1456 273.504 3279.5616 30.5676
5 NOV 28.8 2.9 4092.48 55.80 29.76 7.44 47% 63% 55% 2202.984 1574.8992 343.728 4121.6112 29.1312
6 NOV 36.3 2.87 5104.869 69.60 37.12 9.28 47% 63% 55% 2747.808 1964.3904 428.736 5140.9344 36.0654
7 NOV 39.3 2.76 5314.932 72.00 38.40 9.60 47% 63% 55% 2842.56 2032.128 443.52 5318.208 3.276
8 DEC 36.3 3.2 5691.84 77.40 41.28 10.32 47% 63% 55% 3055.752 2184.5376 476.784 5717.0736 25.2336
9 DEC 39.3 3.4 6547.38 88.80 47.36 11.84 47% 63% 55% 3505.824 2506.2912 547.008 6559.1232 11.7432
10 JAN 39.3 3.1 5969.67 81.00 43.20 10.80 47% 63% 55% 3197.88 2286.144 498.96 5982.984 13.314
11 JAN 39.3 3.2 6162.24 84.00 44.80 11.20 47% 63% 55% 3316.32 2370.816 517.44 6204.576 42.336
12 FEB 39.3 3.6 6932.52 94.20 50.24 12.56 47% 63% 55% 3719.016 2658.7008 580.272 6957.9888 25.4688
13 FEB 39.3 3.4 6547.38 88.80 47.36 11.84 47% 63% 55% 3505.824 2506.2912 547.008 6559.1232 11.7432
14 MAR 39.3 3.6 6932.52 94.20 50.24 12.56 47% 63% 55% 3719.016 2658.7008 580.272 6957.9888 25.4688
15 MAR 36.3 3.4 6047.58 82.20 43.84 10.96 47% 63% 55% 3245.256 2320.0128 506.352 6071.6208 24.0408
16 APR 33.3 3.2 5221.44 70.80 37.76 9.44 47% 63% 55% 2795.184 1998.2592 436.128 5229.5712 8.1312
17 APR 30.3 3.1 4602.57 62.40 33.28 8.32 47% 63% 55% 2463.552 1761.1776 384.384 4609.1136 6.5436
18 APR 30.3 2.9 4305.63 58.80 31.36 7.84 47% 63% 55% 2321.424 1659.5712 362.208 4343.2032 37.5732
19 MAY 26.5 2.9 3765.65 51.00 27.20 6.80 47% 63% 55% 2013.48 1439.424 314.16 3767.064 1.414
20 MAY 26.5 2.7 3505.95 48.00 25.60 6.40 47% 63% 55% 1895.04 1354.752 295.68 3545.472 39.522
21 JUN 25.1 2.5 3074.75 42.00 22.40 5.60 47% 63% 55% 1658.16 1185.408 258.72 3102.288 27.538
22 JUN 25.1 2.2 2705.78 37.20 19.84 4.96 47% 63% 55% 1468.656 1049.9328 229.152 2747.7408 41.9608
23 JUL 22.7 2.4 2669.52 36.60 19.52 4.88 47% 63% 55% 1444.968 1032.9984 225.456 2703.4224 33.9024
24 JUL 21.5 2.5 2633.75 36.00 19.20 4.80 47% 63% 55% 1421.28 1016.064 221.76 2659.104 25.354
25 AUG 19.7 2.5 2413.25 33.00 17.60 4.40 47% 63% 55% 1302.84 931.392 203.28 2437.512 24.262
26 AUG 19.7 2.3 2220.19 33.00 17.60 4.40 47% 63% 55% 1302.84 931.392 203.28 2437.512 217.322
Annual Totals 785.085

Total Labor Cost

FTE Count By Source Labor Cost by Source
Pay Period Regular Flex Pool Agency Total Regular Flex Pool Agency Total
1 SEP 65 0 0 65 $ 97,952.58 $ - 0 $ - 0 $ 97,952.58
2 SEP 65 2 0 67 $ 97,952.58 $ 3,289.69 $ - 0 $ 101,242.26
3 OCT 65 6 0 71 $ 97,952.58 $ 9,869.06 $ - 0 $ 107,821.64
4 OCT 65 19 0 84 $ 97,952.58 $ 31,252.02 $ - 0 $ 129,204.60
5 NOV 65 38 0 103 $ 97,952.58 $ 62,504.04 $ - 0 $ 160,456.62
6 NOV 65 60 1 126 $ 97,952.58 $ 98,690.59 $ 1,732.64 $ 198,375.81
7 NOV 65 60 5 130 $ 97,952.58 $ 98,690.59 $ 8,663.20 $ 205,306.37
8 DEC 65 60 14 139 $ 97,952.58 $ 98,690.59 $ 24,256.96 $ 220,900.13
9 DEC 65 60 33 158 $ 97,952.58 $ 98,690.59 $ 57,177.12 $ 253,820.29
10 JAN 65 60 20 145 $ 97,952.58 $ 98,690.59 $ 34,652.80 $ 231,295.97
11 JAN 65 60 25 150 $ 97,952.58 $ 98,690.59 $ 43,316.00 $ 239,959.17
12 FEB 65 60 42 167 $ 97,952.58 $ 98,690.59 $ 72,770.88 $ 269,414.05
13 FEB 65 60 33 158 $ 97,952.58 $ 98,690.59 $ 57,177.12 $ 253,820.29
14 MAR 65 60 42 167 $ 97,952.58 $ 98,690.59 $ 72,770.88 $ 269,414.05
15 MAR 65 60 22 147 $ 97,952.58 $ 98,690.59 $ 38,118.08 $ 234,761.25
16 APR 65 60 3 128 $ 97,952.58 $ 98,690.59 $ 5,197.92 $ 201,841.09
17 APR 65 49 0 114 $ 97,952.58 $ 80,597.32 $ - 0 $ 178,549.89
18 APR 65 43 0 108 $ 97,952.58 $ 70,728.26 $ - 0 $ 168,680.83
19 MAY 65 30 0 95 $ 97,952.58 $ 49,345.30 $ - 0 $ 147,297.87
20 MAY 65 25 0 90 $ 97,952.58 $ 41,121.08 $ - 0 $ 139,073.66
21 JUN 65 15 0 80 $ 97,952.58 $ 24,672.65 $ - 0 $ 122,625.22
22 JUN 65 7 0 72 $ 97,952.58 $ 11,513.90 $ - 0 $ 109,466.48
23 JUL 65 6 0 71 $ 97,952.58 $ 9,869.06 $ - 0 $ 107,821.64
24 JUL 65 5 0 70 $ 97,952.58 $ 8,224.22 $ - 0 $ 106,176.79
25 AUG 65 0 0 65 $ 97,952.58 $ - 0 $ - 0 $ 97,952.58
26 AUG 65 0 0 65 $ 97,952.58 $ - 0 $ - 0 $ 97,952.58
Annual Total $ 2,546,766.98 $ 1,488,583.10 $ 415,833.60 $ 4,451,183.67
Current Situation $ 5,283,048.61
Change #1 $ 4,871,284.74 $ 411,763.87 No weekday overtime
Change #2 $ 4,611,951.76 $ 259,332.98 Labor Mix Change
Change #3 $ 4,894,415.41 $ (282,463.65) Right-size Labor Force
Change #4 $ 4,451,183.67 $200,000 Increase Efficiency by 5%
$ 4,651,183.67 $ 243,231.74

__MACOSX/._Proposed (4).xlsx

Proposed (5).xlsx

Hourly Costs

Hourly Rates Hours per day Avg Reg Hourly Rate Weekday Hours Per Week Weekend Hours Per week Total Hours Per Week Average Total Hourly Rate Hourly Fringe Total Hourly Cost
Regular Employees AM PM Night AM PM Night Reg OT Reg OT
HN $ 18.20 $ 18.20 8 4 0 $ 18.20 60 0 0 24 84 $ 20.80 $ 5.46 $ 26.26
RN $ 15.08 $ 16.64 $ 18.20 8 8 8 $ 16.64 120 0 0 24 144 $ 18.03 $ 4.99 $ 23.02
LPN $ 10.19 $ 11.23 $ 12.27 8 8 8 $ 11.23 120 0 0 24 144 $ 12.17 $ 3.37 $ 15.53
NA $ 6.76 $ 7.80 8 4 0 $ 7.11 60 0 0 24 84 $ 8.12 $ 2.13 $ 10.25
US $ 7.80 $ 8.84 $ 9.88 8 8 8 $ 8.84 120 0 0 24 144 $ 9.58 $ 2.65 $ 12.23
Flex Pool Employees
RN $ 16.00 $ 17.50 $ 19.00 8 8 8 $ 17.50 120 0 24 0 144 $ 17.50 $ 5.25 $ 22.75
LPN $ 11.30 $ 12.30 $ 13.30 8 8 8 $ 12.30 120 0 24 0 144 $ 12.30 $ 3.69 $ 15.99
NA $ 7.50 $ 8.50 8 4 0 $ 7.83 80 0 24 0 104 $ 7.83 $ 2.35 $ 10.18
Agency Employees
RN $ 22.00 $ 24.00 $ 25.00 8 8 8 $ 23.67 120 0 24 0 144 $ 23.67 $ - 0 $ 23.67
LPN $ 16.00 $ 17.00 $ 18.00 8 8 8 $ 17.00 120 0 24 0 144 $ 17.00 $ - 0 $ 17.00
NA $ 12.00 $ 13.00 8 4 0 $ 12.33 60 0 24 0 84 $ 12.33 $ - 0 $ 12.33
Everyone works 42 hours per week
3x12 + 1x6
No more overtime during the week but still have overtime over the weekend
no more weekend only staff
Sunday - Wednesday and Wednesday - Sunday

Labor Mix

Admin Staff AM PM Total
HN 1 0 1
NA 4 0 4
Total 5 0 5
Direct Care Staff AM PM Total Skill Mix
RN 15 15 30 60.0%
LPN 8 8 16 32.0%
US 2 2 4 8.0%
Total 25 25 50 100%

Regular Labor Cost

Admin Staff Direct Care Staff Cost Per Labor Category Total Cost
Pay Period Regular HN NA RN (60%) LPN (32%) NA (8%) HN NA RN LPN NA
1 SEP 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
2 SEP 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
3 OCT 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
4 OCT 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
5 NOV 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
6 NOV 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
7 NOV 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
8 DEC 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
9 DEC 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
10 JAN 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
11 JAN 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
12 FEB 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
13 FEB 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
14 MAR 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
15 MAR 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
16 APR 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
17 APR 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
18 APR 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
19 MAY 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
20 MAY 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
21 JUN 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
22 JUN 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
23 JUL 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
24 JUL 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
25 AUG 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
26 AUG 65 2 8 33.00 17.60 4.40 $ 4,411.68 $ 6,890.62 $ 63,807.74 $ 22,966.70 $ 3,789.84 $ 101,866.59
Annual Totals $ 114,703.68 $ 179,156.22 $ 1,659,001.34 $ 597,134.14 $ 98,535.92 $ 2,648,531.31

Flex Pool Labor Cost

Direct Care Staff Total Cost
Pay Period Flex Pool RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 2 1.20 0.64 0.16 $ 2,293.20 $ 859.62 $ 136.86 $ 3,289.69
3 OCT 6 3.60 1.92 0.48 $ 6,879.60 $ 2,578.87 $ 410.59 $ 9,869.06
4 OCT 19 11.40 6.08 1.52 $ 21,785.40 $ 8,166.41 $ 1,300.21 $ 31,252.02
5 NOV 38 22.80 12.16 3.04 $ 43,570.80 $ 16,332.83 $ 2,600.42 $ 62,504.04
6 NOV 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
7 NOV 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
8 DEC 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
9 DEC 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
10 JAN 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
11 JAN 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
12 FEB 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
13 FEB 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
14 MAR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
15 MAR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
16 APR 60 36.00 19.20 4.80 $ 68,796.00 $ 25,788.67 $ 4,105.92 $ 98,690.59
17 APR 49 29.40 15.68 3.92 $ 56,183.40 $ 21,060.75 $ 3,353.17 $ 80,597.32
18 APR 43 25.80 13.76 3.44 $ 49,303.80 $ 18,481.88 $ 2,942.58 $ 70,728.26
19 MAY 30 18.00 9.60 2.40 $ 34,398.00 $ 12,894.34 $ 2,052.96 $ 49,345.30
20 MAY 25 15.00 8.00 2.00 $ 28,665.00 $ 10,745.28 $ 1,710.80 $ 41,121.08
21 JUN 15 9.00 4.80 1.20 $ 17,199.00 $ 6,447.17 $ 1,026.48 $ 24,672.65
22 JUN 7 4.20 2.24 0.56 $ 8,026.20 $ 3,008.68 $ 479.02 $ 11,513.90
23 JUL 6 3.60 1.92 0.48 $ 6,879.60 $ 2,578.87 $ 410.59 $ 9,869.06
24 JUL 5 3.00 1.60 0.40 $ 5,733.00 $ 2,149.06 $ 342.16 $ 8,224.22
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 1,037,673.00 $ 388,979.14 $ 61,930.96 $ 1,488,583.10

Agency Labor Cost

Direct Care Staff Total Cost
Pay Period Agency RN (60%) LPN (32%) NA (8%) RN LPN NA
1 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
2 SEP 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
3 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
4 OCT 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
5 NOV 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
6 NOV 1 0.60 0.32 0.08 $ 1,192.80 $ 456.96 $ 82.88 $ 1,732.64
7 NOV 5 3.00 1.60 0.40 $ 5,964.00 $ 2,284.80 $ 414.40 $ 8,663.20
8 DEC 14 8.40 4.48 1.12 $ 16,699.20 $ 6,397.44 $ 1,160.32 $ 24,256.96
9 DEC 33 19.80 10.56 2.64 $ 39,362.40 $ 15,079.68 $ 2,735.04 $ 57,177.12
10 JAN 20 12.00 6.40 1.60 $ 23,856.00 $ 9,139.20 $ 1,657.60 $ 34,652.80
11 JAN 25 15.00 8.00 2.00 $ 29,820.00 $ 11,424.00 $ 2,072.00 $ 43,316.00
12 FEB 42 25.20 13.44 3.36 $ 50,097.60 $ 19,192.32 $ 3,480.96 $ 72,770.88
13 FEB 33 19.80 10.56 2.64 $ 39,362.40 $ 15,079.68 $ 2,735.04 $ 57,177.12
14 MAR 42 25.20 13.44 3.36 $ 50,097.60 $ 19,192.32 $ 3,480.96 $ 72,770.88
15 MAR 22 13.20 7.04 1.76 $ 26,241.60 $ 10,053.12 $ 1,823.36 $ 38,118.08
16 APR 3 1.80 0.96 0.24 $ 3,578.40 $ 1,370.88 $ 248.64 $ 5,197.92
17 APR 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
18 APR 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
19 MAY 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
20 MAY 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
21 JUN 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
22 JUN 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
23 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
24 JUL 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
25 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
26 AUG 0 0.00 0.00 0.00 $ - 0 $ - 0 $ - 0 $ - 0
Annual Totals $ 286,272.00 $ 109,670.40 $ 19,891.20 $ 415,833.60

Staff Needs (3.5 Acuity)

Direct Care Staff Direct Care % Direct Care Hours
Pay Period ADC Acuity Direct Care Needed RN (76%) LPN (16%) NA (8%) RN LPN NA RN LPN NA Total Hours Surplus or Shortage
1 SEP 19.7 2.5 2413.25 33.00 17.60 4.40 47% 63% 55% 1302.84 931.392 203.28 2437.512 24.262
2 SEP 19.7 2.6 2509.78 34.20 18.24 4.56 47% 63% 55% 1350.216 965.2608 210.672 2526.1488 16.3688
3 OCT 21.2 2.6 2700.88 36.60 19.52 4.88 47% 63% 55% 1444.968 1032.9984 225.456 2703.4224 2.5424
4 OCT 25.7 2.58 3248.994 44.40 23.68 5.92 47% 63% 55% 1752.912 1253.1456 273.504 3279.5616 30.5676
5 NOV 28.8 2.9 4092.48 55.80 29.76 7.44 47% 63% 55% 2202.984 1574.8992 343.728 4121.6112 29.1312
6 NOV 36.3 2.87 5104.869 69.60 37.12 9.28 47% 63% 55% 2747.808 1964.3904 428.736 5140.9344 36.0654
7 NOV 39.3 2.76 5314.932 72.00 38.40 9.60 47% 63% 55% 2842.56 2032.128 443.52 5318.208 3.276
8 DEC 36.3 3.2 5691.84 77.40 41.28 10.32 47% 63% 55% 3055.752 2184.5376 476.784 5717.0736 25.2336
9 DEC 39.3 3.4 6547.38 88.80 47.36 11.84 47% 63% 55% 3505.824 2506.2912 547.008 6559.1232 11.7432
10 JAN 39.3 3.1 5969.67 81.00 43.20 10.80 47% 63% 55% 3197.88 2286.144 498.96 5982.984 13.314
11 JAN 39.3 3.2 6162.24 84.00 44.80 11.20 47% 63% 55% 3316.32 2370.816 517.44 6204.576 42.336
12 FEB 39.3 3.6 6932.52 94.20 50.24 12.56 47% 63% 55% 3719.016 2658.7008 580.272 6957.9888 25.4688
13 FEB 39.3 3.4 6547.38 88.80 47.36 11.84 47% 63% 55% 3505.824 2506.2912 547.008 6559.1232 11.7432
14 MAR 39.3 3.6 6932.52 94.20 50.24 12.56 47% 63% 55% 3719.016 2658.7008 580.272 6957.9888 25.4688
15 MAR 36.3 3.4 6047.58 82.20 43.84 10.96 47% 63% 55% 3245.256 2320.0128 506.352 6071.6208 24.0408
16 APR 33.3 3.2 5221.44 70.80 37.76 9.44 47% 63% 55% 2795.184 1998.2592 436.128 5229.5712 8.1312
17 APR 30.3 3.1 4602.57 62.40 33.28 8.32 47% 63% 55% 2463.552 1761.1776 384.384 4609.1136 6.5436
18 APR 30.3 2.9 4305.63 58.80 31.36 7.84 47% 63% 55% 2321.424 1659.5712 362.208 4343.2032 37.5732
19 MAY 26.5 2.9 3765.65 51.00 27.20 6.80 47% 63% 55% 2013.48 1439.424 314.16 3767.064 1.414
20 MAY 26.5 2.7 3505.95 48.00 25.60 6.40 47% 63% 55% 1895.04 1354.752 295.68 3545.472 39.522
21 JUN 25.1 2.5 3074.75 42.00 22.40 5.60 47% 63% 55% 1658.16 1185.408 258.72 3102.288 27.538
22 JUN 25.1 2.2 2705.78 37.20 19.84 4.96 47% 63% 55% 1468.656 1049.9328 229.152 2747.7408 41.9608
23 JUL 22.7 2.4 2669.52 36.60 19.52 4.88 47% 63% 55% 1444.968 1032.9984 225.456 2703.4224 33.9024
24 JUL 21.5 2.5 2633.75 36.00 19.20 4.80 47% 63% 55% 1421.28 1016.064 221.76 2659.104 25.354
25 AUG 19.7 2.5 2413.25 33.00 17.60 4.40 47% 63% 55% 1302.84 931.392 203.28 2437.512 24.262
26 AUG 19.7 2.3 2220.19 33.00 17.60 4.40 47% 63% 55% 1302.84 931.392 203.28 2437.512 217.322
Annual Totals 785.085

Total Labor Cost

FTE Count By Source Labor Cost by Source
Pay Period Regular Flex Pool Agency Total Regular Flex Pool Agency Total
1 SEP 65 0 0 65 $ 101,866.59 $ - 0 $ - 0 $ 101,866.59
2 SEP 65 2 0 67 $ 101,866.59 $ 3,289.69 $ - 0 $ 105,156.28
3 OCT 65 6 0 71 $ 101,866.59 $ 9,869.06 $ - 0 $ 111,735.65
4 OCT 65 19 0 84 $ 101,866.59 $ 31,252.02 $ - 0 $ 133,118.61
5 NOV 65 38 0 103 $ 101,866.59 $ 62,504.04 $ - 0 $ 164,370.63
6 NOV 65 60 1 126 $ 101,866.59 $ 98,690.59 $ 1,732.64 $ 202,289.82
7 NOV 65 60 5 130 $ 101,866.59 $ 98,690.59 $ 8,663.20 $ 209,220.38
8 DEC 65 60 14 139 $ 101,866.59 $ 98,690.59 $ 24,256.96 $ 224,814.14
9 DEC 65 60 33 158 $ 101,866.59 $ 98,690.59 $ 57,177.12 $ 257,734.30
10 JAN 65 60 20 145 $ 101,866.59 $ 98,690.59 $ 34,652.80 $ 235,209.98
11 JAN 65 60 25 150 $ 101,866.59 $ 98,690.59 $ 43,316.00 $ 243,873.18
12 FEB 65 60 42 167 $ 101,866.59 $ 98,690.59 $ 72,770.88 $ 273,328.06
13 FEB 65 60 33 158 $ 101,866.59 $ 98,690.59 $ 57,177.12 $ 257,734.30
14 MAR 65 60 42 167 $ 101,866.59 $ 98,690.59 $ 72,770.88 $ 273,328.06
15 MAR 65 60 22 147 $ 101,866.59 $ 98,690.59 $ 38,118.08 $ 238,675.26
16 APR 65 60 3 128 $ 101,866.59 $ 98,690.59 $ 5,197.92 $ 205,755.10
17 APR 65 49 0 114 $ 101,866.59 $ 80,597.32 $ - 0 $ 182,463.91
18 APR 65 43 0 108 $ 101,866.59 $ 70,728.26 $ - 0 $ 172,594.85
19 MAY 65 30 0 95 $ 101,866.59 $ 49,345.30 $ - 0 $ 151,211.88
20 MAY 65 25 0 90 $ 101,866.59 $ 41,121.08 $ - 0 $ 142,987.67
21 JUN 65 15 0 80 $ 101,866.59 $ 24,672.65 $ - 0 $ 126,539.24
22 JUN 65 7 0 72 $ 101,866.59 $ 11,513.90 $ - 0 $ 113,380.49
23 JUL 65 6 0 71 $ 101,866.59 $ 9,869.06 $ - 0 $ 111,735.65
24 JUL 65 5 0 70 $ 101,866.59 $ 8,224.22 $ - 0 $ 110,090.80
25 AUG 65 0 0 65 $ 101,866.59 $ - 0 $ - 0 $ 101,866.59
26 AUG 65 0 0 65 $ 101,866.59 $ - 0 $ - 0 $ 101,866.59
Annual Total $ 2,648,531.31 $ 1,488,583.10 $ 415,833.60 $ 4,552,948.00
Current Situation $ 5,283,048.61
Change #1 $ 4,871,284.74 $ 411,763.87 No weekday overtime
Change #2 $ 4,611,951.76 $ 259,332.98 Labor Mix Change
Change #3 $ 4,894,415.41 $ (282,463.65) Right-size Labor Force
Change #4 $ 4,451,183.67 $200,000 Increase Efficiency by 5%
$ 4,651,183.67 $ 243,231.74
Change #5 $ 4,752,948.00 $ (101,764.33) Add 4% to hourly rates
$ 530,100.60

__MACOSX/._Proposed (5).xlsx