Budget Analysis III | JKL CCRC Facility This is your fourth departmental budgetary summary. You will be including your discussions with the department managers and possible staff interviews. You will be providing the budget outline on an Excel spreadsheet for each line item for this department. A summary budget template has been provided for you under the DocSharing. This is your third and final budget analysis which is much more detailed in the aspect it relates to a Continuing Care Retirement Center (CCRC) that means it offers a vast array of health care services to a specific population. During this analysis you are continuing the process of per patient day (PPD) rates and utilize this information for your final Administrative Review. Efficiency in healthcare operations is becoming an increasingly important objective for many decision makers. Efficiency is simply the ratio of outputs to inputs, not the quality of outputs but the lowest possible cost of production. Adequate assessment of efficiency implies the availability of standards against which actual costs may be compared. In many health care organizations, these standards may be formally introduced into the budgetary process. Thus, a given nursing unit may have an efficiency standard of 4.3 nursing hours per patient day of care delivered. This standard may then be used as a benchmark by which to evaluate the relative efficiency of the unit. If actual employment were 6.0 nursing hours per patient day, management would be likely to reassess staffing patterns. Instructions: The spreadsheet completed is where you will gather information for your written summary). Please be sure to save your progress. When finished reviewing the spreadsheet, you will submit a minimum one-page analysis of your findings with the JKL CCRC facility. You DO NOT have to complete the spreadsheet, it is already completed. NO Plagiarism and APA format

312 qattachments_6933e1cbfe7644fc3802fb893f8bc1f28006102c.xls BRISTOL HEALTHCARE JKL CCRC BUDGET period ending days in period beds units 100.00 nh 12/31/12 365.00 50.00 28.00 UT ILIZ AT ION Census - nursing facility 5010 rm & board, private pay, semi 5011 rm & board, medicare 5012 rm & board, medicaid 5014 rm & board, other 5015 rm & board, private pay, private total nh census 5901 5902 5903 5904 5905 5906 5907 5908 5909 5910 5920 5921 5420 5425 5430 5435 5020 5030 5040 5050 5060 200.00 al 12/31/12 365.00 50.00 26.00 250.00 600.00 alz h&w 12/31/12 12/31/12 365.00 365.00 24.00 12.00 mods 800.00 hh pssprt 12/31/12 365.00 900.00 hospice 12/31/12 365.00 mods visits 10.00 5.00 30.00 0.00 2.50 47.50 Census - assisted living rm & board al unit - a -semi private rm & board al unit - b -respite rm & board al unit - c -suite rm & board al unit - d rm & board al unit - e -pvt rm & board al unit - f rm & board al unit - g rm & board al unit - h rm & board al unit - i rm & board al unit - j rm & board al unit - k rm & board al unit - l total al census 100.00 nh 12/31/12 365.00 50.00 28.00 200.00 al 12/31/12 365.00 50.00 26.00 600.00 h&w 12/31/12 365.00 0.00 2.00 2.00 0.00 19.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 23.00 0.00 0.00 0.00 0.00 11.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11.50 0.00 0.00 0.00 0.00 11.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 11.50 24.00 1.00 47.50 23.00 0.27 0.28 5.94 17.94 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1332.05 20.15 0.00 0.00 0.00 0.00 0.00 11.50 509.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 1.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 1.20 1.20 1.00 1.00 0.50 0.50 0.50 0.50 0.50 0.0000 1.0000 1.0000 1.0000 0.0010 0.0000 0.0000 1639.67 0.00 12.08 17.60 18.75 0.00 0.00 0.00 0.00 1.00 1.00 1.00 0.00 0.00 0.00 2.00 0.00 1.15 20.00 1.00 1.78 0.00 136 144 3025 9132 0 0 0 0 0 12437 425.46 42.10 0.00 4198 12437 32453 220 75039 0 0 0 0.00 0.00 0.00 0 0 31969 484 0 0 0 0 0 32453 249 0 12 0 0 0 0 0 0 261 385 144 35006 9616 0 0 0 0 0 45151 832 0 0 0 0 0 0 0 0 730 25942 29209 35677 402 650 0 92610 832 0 94717 0 0 136 144 3025 9132 0 0 0 0 0 12437 0 4407 6422 6842 20 0 0 17691 0 4198 4198 4198 0 0 0 12593 730 0 420 7300 365 650 0 9464 1640 425 42 0 18117 12635 9464 0 56940 77380 0 509723 0 0 0 0 0 0 0 644043 0 0 0 0 444935 0 0 0 0 0 0 0 444935 76.7174 106.0000 2800919 644043 444935 0 0 0 3889896 161.5526 76.7174 106.0000 0 0 0 0 0 1492 1584 12101 31962 47138 0 0 127237 1644 128882 22945 0 1325 0 24270 24437 1584 140663 33606 200290 0.00 0.00 0.00 0 0 0 0 0 0 0.1199 0.1274 0.9730 2.5700 3.7902 3.9207 0.0507 3.9714 0 0 0 0 85 0 0 85 0 17630 35322 51314 150 0 0 104416 0 0 0 0 0 0 0 0 3103 0 3253 54750 2829 5360 4727 0 0 0 0 0 3103 17630 43302 106064 3064 5360 0 178522 851 84 0.00 2.1000 4.2075 6.1125 0.0179 0.00 0.00 12.4379 0.00 0.1014 0.00 0.00 0.00 0.00 0.00 0.00 12.5392 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0201 0.00 0.00 0.00 0.00 0.00 0.00 0.0201 0.2495 0.00 0.2616 4.4023 0.2274 0.4310 0.00 5.5717 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.5717 0.00 0.00 0.1457 0.00 0.00 0.00 0.00 0.1457 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.1457 0.00 0.00 0.00 0.00 106.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 38.00 34.00 0.00 10.00 38.00 34.00 0.00 10.00 11.00 11.00 4.00 3.50 0.00 4.00 5.50 7.50 7.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.25 105% 2.00 2.00 7.75 7.50 7.75 8.25 0.00 0.00 3.98 3.40 5.68 2.00 3279 0.0000 6.1552 1.1313 59.1382 2.5887 0.6275 5031 5032 5033 5034 5036 5037 ot - m'care b / m'caid ot - m'care b / other ot - private ot - m'care a ot - other ot - m'caid Subtotal 0.0000 5.4778 0.0283 52.1261 1.4285 0.6007 5041 st - m'care b / m'caid 5042 st - m'care b / other 5043 st - private 5044 st - m'care a 5046 st - other 5047 st - m'caid Subtotal 0.0000 0.8129 0.0000 5.2084 0.0000 0.0000 5051 5052 5053 5054 5056 5057 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 59.54 0 0 0 0 0.00 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.00 0.00 0.0000 0.0000 0.9638 3.9952 0.1388 1.4436 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 5091 min equip bill m'care - m'care b / m'caid 5092 min equip bill m'care - m'care b / other 5093 min equip bill m'care - private 5094 min equip bill m'care - m'care a 5096 min equip bill m'care - other 5097 med min equip bill m'care - m'caid Subtotal 0.0000 0.0000 0.1938 0.7214 0.0000 0.1001 5101 min equip routine - m'care b / m'caid 5102 min equip routine - m'care b / other 5103 min equip routine - private 5104 min equip routine - m'care a 5106 min equip routine - other 5107 min equip routine - m'caid Subtotal 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 5111 5112 5113 5114 5116 5117 0.0000 0.0000 0.2345 0.4776 0.0000 0.1720 5121 enterals routine - m'care b / m'caid 5122 enterals routine - m'care b / other 5123 enterals routine - private 5124 enterals routine - m'care a 5126 enterals routine - other 5127 enterals routine - m'caid Subtotal 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 5131 5132 5133 5134 5136 5137 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 5141 incont sup - m'care b / m'caid 5142 incont sup - m'care b / other 5143 incont sup - private 5144 incont sup - m'care a 5146 incont sup - other 5147 incont sup - m'caid Subtotal 0.0000 0.0000 1.1147 0.7451 0.0517 1.8627 5151 5152 5153 5154 5156 5157 0.0000 0.0000 0.0641 0.1518 0.0000 0.0936 0.00 0.0000 0.3705 0 0 4397 7291 633 15808 28129 0.00 0.0000 0.0911 0.00 0.0000 0.0000 0.0000 0.0000 0.00 0.00 0.00 0.0000 0.0000 0 0 1070 872 0 1883 3825 0.00 0.00 0.00 0.00 0.0000 0.2368 0.0000 0.4860 0.00 0.00 0.00 0.0000 0.0000 0.0000 0.0000 0.00 0.00 0.00 0.0000 0.3795 0 0 5086 1360 236 20397 27078 0.00 0.0000 0.2334 0.00 0.0000 0.0000 0.0000 0.0000 0.00 0.00 T otal supply revenue 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0.2995 0.00 0.5483 0.00 0.00 0.8477 0.2995 0.5483 0.8477 0 0 0 0 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 329128 18.9836 0 765 0 1555 0 0 1555 0 0 0 6717 7291 633 15808 30449 0.00 0.00 0.2536 0.4206 0.0365 0.9118 1.6225 0 0 765 0 0 0 0 0 0 0 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1988 0 2040 2040 0 0 0 0 0 0 0 0 0 0 0 0 0 1988 0 0 0 0 0 0 0 0 0 0 0 0 1959 0 1593 1593 0 0 0 1959 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 18.9836 0.00 0.00 0.0911 0.00 0.00 0.00 0.0911 0.00 0.00 0.3705 0.00 0.00 0.00 0.3705 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 0 0 0 1034 1317 0 1096 3446 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0510 0.0759 0.00 0.0632 0.1901 0.00 0.00 0.0179 0.00 0.00 0.00 0.0179 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0617 0.0503 0.00 0.1086 0.2206 0.00 0.00 0.2368 0.00 0.00 0.00 0.2368 0.00 0.00 0.4860 0.00 0.00 0.00 0.4860 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 0 0 0 5097 872 0 1883 7852 0.00 0.00 0.7152 0.4206 0.0365 0.9118 2.0840 0.00 0.00 0.0688 0.0759 0.00 0.0632 0.2080 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.7844 0.0503 0.00 0.1086 0.9433 0 0 0 0 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 8638 1360 236 20397 30630 0.00 0.00 0.2934 0.0784 0.0136 1.1765 1.5618 0.00 0.00 0.2334 0.00 0.00 0.00 0.2334 0.00 0.00 0.3795 0.00 0.00 0.00 0.3795 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.9063 0.0784 0.0136 1.1765 2.1747 0.00 0.00 0.0169 0.0160 0.00 0.0591 0.0920 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0169 0.0160 0.00 0.0591 0.0920 0 0 0 0 0 0 0 0 0 0 0 0 0 292 277 0 1025 1595 0 0 0 73973 3.6870 0.5791 1.2359 0.00 0.00 0.00 5.5021 0 5445 0 8395 29722 0 0.00 0.3141 0.00 0.1535 0.5639 0.00 0.00 0.00 0.00 0.6531 2.2035 0.00 0.00 0.00 0.00 0.0599 0.3446 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.3141 0.00 0.8664 3.1121 0.00 0 5188 0 0 0 0 0 0 0 0 485 0 0 485 0.00 0.00 0.00 0.0280 0.00 0.00 0.0280 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0280 0.00 0.00 0.0280 0 0 0 0 0 0 11603 0 0 0 0 11603 0.00 0.6693 0.00 0.00 0.00 0.00 0.6693 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.6693 0.00 0.00 0.00 0.00 0.6693 0 0 2029 510 0 0 0 2539 0.00 0.1170 0.00 0.00 0.00 0.00 0.1170 0.00 0.00 0.0608 0.00 0.00 0.00 0.0608 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.1170 0.0608 0.00 0.00 0.00 0.1778 147069 0 4689 0 0 0 0 0 0 35630 4810 34800 -25551 0 -791 0 0 0 0 0 0 0 0 5887 0 0 0 0 0 -19926 0 0 0 0 0 59848 304656 5.2593 0.00 0.1070 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0629 0.00 -0.7059 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -1.1493 0.00 0.00 0.00 0.00 0.00 0.00 5.4197 3.8211 0.00 0.2742 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.4431 0.00 -0.9638 0.00 -0.0942 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.5837 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.9280 10.9094 4.2338 0.00 0.1269 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -1.2442 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6.4021 9.9232 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.8649 0.00 2.7981 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0794 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.7424 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27.4668 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 27.4668 40.7809 0.00 0.5081 0.00 0.00 0.00 0.00 0.00 0.00 2.8649 0.5060 2.7981 -2.9138 0.00 -0.0942 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.6631 0.00 0.00 0.00 0.00 0.00 -1.1493 0.00 0.00 0.00 0.00 0.00 10.3301 59.4615 0 0 0 4980681 66.3742 148860 -315070 -65716 -149687 -52632 0 0 -434244 189.8370 0.0109 8.5860 -18.1727 -3.7904 -8.6337 -3.0357 0.00 0.00 -25.0465 100.7452 0.0120 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 117.1792 0.0279 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 15.1044 Err:508 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.1170 Err:508 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 137.8868 Err:508 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 564.8695 Err:508 8.5860 -18.1727 -3.7904 -8.6337 -3.0357 0.00 0.00 -25.0465 491860 187850 133609 30308 117.1792 Err:508 Err:508 Err:508 0 11603 0 0 0 0 11603 0 2029 0 0 0 0 2029 49.9630 0.0000 0.1070 0.0608 0.0000 3.8211 0.0000 0.2742 0.0000 4.2338 0.0000 0.1269 0.0000 0.0000 0.0000 0.4431 0.0000 -0.9638 0.0000 -0.0942 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.5837 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 3.9280 0.0000 0.0000 -1.2442 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 6037.2000 0.0000 0 510 0 32078 0 2302 0 17771 0 533 0 0 91182 0 1855 510 0 3720 0 -8091 0 -791 0 0 0 0 0 0 0 -5222 0 0 0 0 0 0 0 0 0 4900 0 0 0 0 0 0 0 0 0 0 0 32975 91585 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26873 41653 0 0 0 0 0 35630 0 34800 0 0 0 0 0 0 0 0 0 0 0 987 0 0 0 0 0 0 0 0 0 0 0 0 71417 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6037 0 commons 0.0629 0.0000 -0.7059 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 -1.1493 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 $5.83 0.0000 2.7981 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 1090 0 -12238 0 0.0000 0.0000 0.0000 0.0000 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -19926 0 0 0 0 0 0 93965 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 6.4021 0.0000 0.0794 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 T OT AL REVENUE BEFORE CA 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6037 0 0 0 0 -6037.20 0.00 3291300 189.8370 148860 -315070 -65716 -149687 -52632 0 0 -434244 845756 100.7452 2857055 164.7905 241.57 -172.79 -3.65 146.33 -4.9002 0.0000 0.0000 T OT AL REVENUE NET OF CA 491860 187850 133609 30308 117.1792 Err:508 Err:508 Err:508 845756 100.7452 4546437 60.5873 164.7905 100.7452 117.1792 15.1044 4.1170 137.8868 539.8230 18753 12308 0 2198 7623 0 40882 510 330 340 100 120 0 1400 1037 279 6296 0 749 0 8361 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 20300 12917 6636 2298 8492 0 50643 1.0816 0.7099 0.00 0.1268 0.4397 0.00 2.3580 0.0607 0.0393 0.0405 0.0119 0.0143 0.00 0.1668 0.2470 0.0666 1.5000 0.00 0.1783 0.00 1.9919 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.3894 0.8158 1.5405 0.1387 0.6323 0.00 4.5167 173 0 0 0 0 173 0 0 0 0 0 0 0 109512 4335 19855 1920 641 136263 4.3763 0.1637 0.8508 0.0741 0.0370 5.5017 2.2319 0.1265 0.5274 0.0643 0.00 2.9501 3.5090 0.1038 0.1614 0.0229 0.00 3.7970 0.0139 0.00 0.00 0.00 0.00 0.0139 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10.1311 0.3939 1.5395 0.1613 0.0370 12.2627 0 0 0 0 0 0 0 0 0 0 0 35238 0 35238 0.00 0.00 0.00 2.0325 0.00 2.0325 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.0325 0.00 2.0325 0 0 222144 2.9604 9.8922 3.1169 5.7889 0.0139 0.00 0.00 18.8119 0.1218 3.0762 2.3127 0.9918 6.0684 0.2801 9.5700 0.4417 16.6280 0.7674 1.3179 1.1479 1.1023 0.7489 0.00 0.00 0.3390 0.00 0.00 2.1629 0.00 0.3179 1.2807 0.2884 0.00 48.9639 0.1315 0.00 0.00 2.0482 0.00 0.00 10.9300 0.5044 8.9805 0.4145 0.00 0.00 0.00 0.6186 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 23.6277 0.00 0.00 0.00 0.00 0.00 0.00 21.6588 0.9996 18.3773 0.8481 0.00 0.00 2.3930 5.3357 0.00 0.00 0.00 0.00 0.00 0.00 2.3930 0.00 0.00 0.00 0.00 52.0054 0.0193 0.00 0.2883 0.00 0.1690 0.0078 0.00 0.00 1.8328 0.0846 0.00 1.3207 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.7225 0.0074 0.00 0.2762 0.00 0.00 0.00 0.00 0.00 1.8750 0.0865 0.00 0.0281 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.2733 0.00 0.00 8.1570 0.00 17.5845 0.8115 0.00 0.00 0.4095 0.0189 0.00 4.1515 0.00 0.00 0.00 0.00 0.00 0.00 0.00 16.8438 0.00 13.2500 0.00 0.00 0.00 61.2267 0.2800 3.0762 11.0343 3.0400 23.8219 1.0994 42.1588 1.9456 48.1032 2.2200 1.3179 6.6482 3.4953 6.7032 0.00 0.00 0.3390 0.00 0.00 19.0066 2.3930 13.5679 1.2807 0.2884 0.00 191.8196 0 0 0 0 0 0 0 0 0 0 0 0 101% 150% 71% 150% 150% 44% 150% 4% 150% 150% 1% 150% 7% 150% 150% 18% 150% 150% 150% 150% 150% 150% 150% 150% 150% 150% 150% 150% Utilities 6020 heat, light and power 6021 cable tv 6030 water & sewer 6040 trash 6050 hazardous medical waste T otal utilities 4.3763 0.1637 0.8508 0.0741 0.0370 2.2319 0.1265 0.5274 0.0643 0.0000 3.51 0.10 0.16 0.02 0.00 0.01392 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0601 0.0000 0.0101 0.0000 0.0000 75873 2838 14750 1284 641 95387 18737 1062 4427 540 0 24766 14729 436 677 96 0 15938 T axes 6060 real estate taxes 6070 personal property taxes 6080 franchise taxes 6090 bed tax fee (govt. mandated) 6095 ho cost T otal taxes 0.0000 0.0000 0.0000 2.0325 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0 0 0 35238 0 35238 0 0 0 0 0 0 0 0 0 0 0 0 171506 9.8922 26166 3.1169 T OT AL PROT ECT ED T OT AL PROT ECT ED PER DAY (VISIT ) Hours/ fte applies to all staff - input here hrs / fte / yr #1 2080.00 hrs / fte / yr #2 2080.00 6115 adon and assessment days eves nights lpn - charge hrs ppd or visit 0 0 0 5192 0 9505 0 0 14698 0 0 0 251 1447 0 0.0000 0.3176 0.0000 0.0000 0.0000 0.0000 6110 assessment and unit manager days eves nights rn - charge hrs ppd or visit 0 4862 0.0000 1.8166 0.0000 0.0000 0.0000 0.0000 DIRECT Staffing plan 6101 medical director - salaried 6102 medical director - contract 6105 don hrs ppd or visit 0 0 0 0 0 0 5483 18498 0 5381 02 - m'care b / m'caid 5382 02 - m'care b / other 5383 02 - private 5384 02 - m'care a 5386 02 - other 5387 02 - m'caid total EXPENSES 0 0 0 0 5445 0 2661 9777 0 0.0000 0.0000 0.0000 0.0599 0.3446 0.0000 5371 lab - m'care b / m'caid 5372 lab - m'care b / other 5373 lab - private 5374 lab - m'care a 5376 lab - other 5377 lab - m'caid total PROT ECT ED Medical supplies 6000 medical sup m'care billable 6001 medical sup m'care nonbillable 6003 oxygen 6005 medical minor m'care billable 6006 medical minor m'care nonbillable 6010 prior authorized medical equip T otal medical supplies 0.00 2.0181 0.0074 5.4870 0.3759 0.3794 8.2678 0 0 0 0 0 485 0 0 485 0.0000 0.0000 0.0000 0.6531 2.2035 0.0000 0.0000 0.0000 0.0000 0.2660 0.0000 0.0000 5710 ca - m'care a - rm & board 5711 ca - m'care a - ancillaries 5714 ca - m'care b 5720 ca - m'caid 5721 ca - m'caid ancillaries 5731 ca - other 5731 ca - other T otal Contractual Allowance 2.0181 0.0074 5.4870 0.3759 0.3794 8.2678 0 63924 0.0000 0.8524 0.0000 0.1535 0.5639 0.0000 5361 radiology - m'care b / m'caid 5362 radiology - m'care b / other 5363 radiology - private 5364 radiology - m'care a 5366 radiology - other 5367 radiology - m'caid total legend drugs bill m'care a legend drugs routine other - tv cable entrance contribution housekeeping plan - 1 housekeeping plan - 2 nutritional counseling social services assessment monthly fee miscellaneous other management services cash discounts late fee revenue furniture discount rebates & refunds gift shop vending machine rental - space rental - equip - private rental - equip - m'care rental - equip - m'caid rental - other interest - working capital interest - restricted interest - funded depreciation interest - related party interest - contributions endowments gain / loss - asset disposal gain / loss - investment sale nurse aide training activity donations restrictred unrestricted donations employee contrib - restricted Additional Nursing Services T otal other revenue 0.00 2.2677 0.2977 6.2251 0.6812 0.3963 9.8680 0 0 0 0 0 0 0 292 277 0 1025 1595 0.00 2.2677 0.2977 6.2251 0.6812 0.3963 9.8680 0 34990 129 95130 6517 6577 143344 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0.00 0.0000 0.0000 0 39316 5162 107927 11811 6871 171087 0 0 0 0 0 0 0 0 0 0.00 0.0000 0.0000 0 0 0 0 0 0 0 0 0 0.00 0.0000 0.0000 0.0000 0.0000 0 0 884 1317 0 1096 3297 0.00 0.0000 0.0179 4214 182737 0 0 0 0 0 0 0 0 0 0 0.00 0.0000 0.2495 2.1000 4.6147 10.5148 0.2502 0.4310 0.00 18.1601 0.00 0.3106 0.00 0.00 0.00 0.00 0.00 0.00 18.4707 0 0 329128 5081 med sup routine - m'care b / m'caid 5082 med sup routine - m'care b / other 5083 med sup routine - private 5084 med sup routine - m'care a 5086 med sup routine - other 5087 med sup routine - m'caid Subtotal 0 0 0 0 0 0 0 0 0 0 0.0000 104.5115 0.1274 4.8937 2.6206 7.7616 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 0 0 0 0 0 0 0 0 0.0000 104.3916 0 0 0 0 0 5192 0 9505 0 0 14698 0.00 0.0000 0.0000 0.0000 0.00 4727 0 0 0.00 0.0000 0.0000 T otal therapy revenue Other service revenue 5160 laundry services 5170 ambulance 5310 dry cleaning services 5320 communications 5340 barber & beauty 5350 personal purchases 0 0 0 34990 129 95130 6517 6577 143344 0.00 106.0000 0 0 0 0 0 69294 0 39316 5162 107927 11811 6871 171087 0.0000 6.7826 9.2174 60.7174 0 0 0 0 0 84 0.00 0.0000 0.0000 33.6842 16.8421 101.0526 0.00 9.9737 161.5526 0.00 0.00 0.00 6.7826 9.2174 0.00 166.7174 0.00 0.00 0.00 0.00 0.00 0.00 0.00 182.7174 0.00 344.2700 9.9737 161.5526 0.00 0.00 0.00 0.00 0.0049 0.00 0.00 0.0049 0.00 0.1891 0.00 0.00 0.00 0.00 0.00 0.00 0.1940 0 0 0 0 0 105267 0.00 0.0000 0.0000 33.6842 16.8421 101.0526 4727 69294 0 0 0 0 T herapy revenue 5021 pt - m'care b / m'caid 5022 pt - m'care b / other 5023 pt - private 5024 pt - m'care a 5026 pt - other 5027 pt - m'caid Subtotal m'care b / m'caid m'care b / other private m'care a other m'caid 0 0 0 0 0 56940 77380 0 954658 0 0 0 0 0 0 0 1088978 3364 T otal meal revenue personal care personal care personal care personal care personal care personal care Subtotal 2107 584000 292000 1752000 0 172919 2800919 110.42 110.42 110.42 0.00 restaurant breakfast restaurant lunch restaurant dinner- home delivered 5339 total restaurant meals m'care b / m'caid m'care b / other private m'care a other m'caid 832 584000 292000 1752000 0 172919 2800919 57.00 78.00 106.00 0.00 73.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5331 employee meals habil sup habil sup habil sup habil sup habil sup habil sup Subtotal 343 144 35006 9616 0 0 0 0 0 45109 8395 0 160.00 160.00 160.00 0.00 189.50 0.00 0.00 0.00 0.00 5.00 0.00 0.00 enterals bill m'care - m'care b / m'caid enterals bill m'care - m'care b / other enterals bill m'care - private enterals bill m'care - m'care a enterals bill m'care - other enterals bill m'care - m'caid Subtotal PPD 1.02 Meal revenue ($/meal) Parties (rotary,singles, etc) breakfast lunch- home delivered dinner guest dinner- home delivered & pickup snacks 5330 total in-house client meals Supply revenue 5071 med sup bill m'care - m'care b / m'caid 5072 med sup bill m'care - m'care b / other 5073 med sup bill m'care - private 5074 med sup bill m'care - m'care a 5076 med sup bill m'care - other 5077 med sup bill m'care - m'caid Subtotal total PPD 82.00 208 0 12 0 0 0 0 0 0 220 0 0 0 Revenue/visit - home health 5420 rn hours 5425 lpn hours 5430 aide hours 5435 home making services Subtotal revenue - home health 5061 rt - m'care b / m'caid 5062 rt - m'care b / other 5063 rt - private 5064 rt - m'care a 5066 rt - other 5067 rt - m'caid Subtotal 900.0000 hospice PPD 53669 Rm & board - assisted living rm & board al unit - a -semi private rm & board al unit - b -respite rm & board al unit - c -suite rm & board al unit - d rm & board al unit - e -pvt rm & board al unit - f rm & board al unit - g rm & board al unit - h rm & board al unit - i rm & board al unit - j rm & board al unit - k rm & board al unit - l total m'care b / m'caid m'care b / other private m'care a other m'caid 1.00 0 0 31969 484 0 0 0 0 0 32453 0 17338 17338 17338 17 0 0 52030 2.28 T otal meal volume audiology audiology audiology audiology audiology audiology Subtotal 800.0000 hh pssprt PPD 0 730 730 0 11133 0 0 0 0 0 0 0 12593 restaurant breakfast restaurant lunch restaurant dinner- home delivered 5339 total restaurant meals T otal room & board revenue 24.00 0.00 0.00 0.00 0.00 4197.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4197.50 207.80 0.00 12.00 0.00 0.00 0.00 0.00 0.00 0.00 17338 Hours/visit - home health (for rate setting and expense budgeting) rn hours 0.00 lpn hours 0.00 aide hours 0.00 home making services 0.00 pt ot st audiology rt total hours REVENUE Rm & board - nursing facility 5010 rm & board, private pay, semi 5011 rm & board, medicare 5012 rm & board, medicaid 5014 rm & board, other 5015 rm & board, private pay, private total 600.0000 h&w PPD 3650 1825 10950 0 913 17338 0 730 730 0 6935 0 0 0 0 0 0 0 8395 T otal days and visits 5331 employee meals 250.0000 alz PPD 0.00 2.00 2.00 0.00 30.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 34.50 3650 1825 10950 0 913 17338 Visits/client/year - home health rn hours lpn hours aide hours home making services pt ot st audiology rt total visits Meal Volume Parties (rotary,singles, etc) breakfast lunch- home delivered dinner guest dinner- home delivered & pickup snacks 5330 total in-house client meals 200.0000 al PPD 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Days - assisted living rm & board al unit - a -semi private rm & board al unit - b -respite rm & board al unit - c -suite rm & board al unit - d rm & board al unit - e -pvt rm & board al unit - f rm & board al unit - g rm & board al unit - h rm & board al unit - i rm & board al unit - j rm & board al unit - k rm & board al unit - l total al days 5420 5425 5430 5435 5020 5030 5040 5050 5060 100.0000 nh total 12/31/12 365.00 visits 10.00 5.00 30.00 0.00 2.50 47.50 0.00 2.00 2.00 0.00 19.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 23.00 509.00 5901 5902 5903 5904 5905 5906 5907 5908 5909 5910 5920 5921 5392 5393 5401 5412 5416 5417 5437 5440 5441 5445 5499 5510 5520 5521 5522 5530 5540 5550 5560 5571 5572 5573 5580 5590 5600 5610 5620 5625 5630 5640 5650 5660 5670 5671 5672 5930 900.00 hospice 12/31/12 365.00 mods Clients - home health rn hours lpn hours aide hours home making services pt ot st audiology rt T otal census 5901 5902 5903 5904 5905 5906 5907 5908 5909 5910 5920 5921 800.00 hh pssprt 12/31/12 365.00 mods 10.00 5.00 30.00 0.00 2.50 47.50 Days - nursing facility 5010 rm & board, private pay, semi 5011 rm & board, medicare 5012 rm & board, medicaid 5014 rm & board, other 5015 rm & board, private pay, private total nh days 5420 5425 5430 5435 5020 5030 5040 5050 5060 250.00 alz 12/31/12 365.00 24.00 12.00 2080.00 2080.00 2080.00 2080.00 2080.00 2080.00 2080.00 2080.00 2080.00 2080.00 1.00 0.00 0.00 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.10 0.00 0.00 0.25 0.00 0.00 0.05 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2080.00 2080.00 2080.00 2080.00 24299 173 5.7889 Err:508 Err:508 2080.00 2080.00 2080.00 2080.00 Err:508 2080.00 2080.00 2080.00 2080.00 0.0000 0.0000 1.0000 0.1200 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Err:508 Err:508 Err:508 0.0000 0.0000 1.0000 0.0000 1.0000 0.0000 0.0000 1.0000 0.1200 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.1000 0.2500 0.0500 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.1000 0.2500 0.0500 0.0000 Err:508 Err:508 Err:508 1.4000 0.0000 0.0000 1.4000 0.0000 0.50 0.00 0.00 0.50 0.00 0.00 0.00 0.00 0.00 0.5000 0.0000 0.0000 0.5000 0.0600 0.5000 0.0000 0.0000 0.5000 0.1239 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Err:508 Err:508 Err:508 1.0000 0.0000 0.0000 1.0000 0.0000 6120 days eves nights additional nursing svcs rn hrs ppd or visit 0.00 1.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0000 1.4000 1.4000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0652 0.0000 0.1199 0.0000 0.0000 0.0000 0.0000 0.0652 0.0000 0.1199 0.0000 Err:508 Err:508 Err:508 0.1851 1.4000 1.4000 6125 days eves nights additional nursing svcs lpn hrs ppd or visit 2.00 1.00 1.00 1.00 0.50 0.50 1.00 0.50 0.50 2.8000 1.4000 1.4000 1.4000 0.7000 0.7000 0.0000 2.8000 0.6937 1.4000 0.0000 0.0000 0.0000 0.7000 0.7000 0.0000 2.8000 0.0000 0.0000 0.0000 1.3875 Err:508 Err:508 Err:508 6130 days eves nights ward clerk resource 6131 ward clerk level 2 additional nursing svcs nurse aide, rsp, ward sec'y hrs ppd or visit 5.00 4.00 3.00 1.00 1.00 1.00 1.00 1.00 0.00 0.00 1.00 1.00 1.00 0.00 0.00 0.00 0.90 0.00 0.05 0.00 0.05 18.8000 2.2555 1.4000 1.4000 1.4000 0.0000 0.0000 0.0000 4.2000 1.0406 1.4000 1.4000 1.4000 0.0000 0.0000 0.0000 4.2000 2.0812 3.4687 0.4040 0.00 0.40 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.50 1.00 0.00 0.00 0.00 0.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 3.5631 3.5631 1.0000 1.0000 0.0000 0.0000 1.0000 0.0000 0.2000 0.6000 0.3500 1.8582 1.00 1.00 0.00 0.00 1.00 0.00 0.20 0.60 0.35 0.0000 0.4000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.5000 1.4000 0.0000 0.0000 0.0000 0.5000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.1218 23.94 19.28 16.53 18.07 4.62% 14.24 4.62% 8.25 4.62% 10.99 9.57 8.62 6.24 0.00 0.00 0.3390 0.0000 0.0000 16.84 0.00 13.25 17.79 0.2884 0.0000 0.1315 23.94 19.28 16.53 18.07 4.62% 15.76 4.62% 8.63 4.62% 10.99 9.57 8.62 6.24 0.00 0.00 0.00 0.00 0.00 16.84 0.00 13.25 17.79 0.00 0.00 0.00 23.94 19.28 16.53 18.07 4.62% 15.61 4.62% 8.83 4.62% 10.99 9.57 9.66 7.69 0.00 0.00 0.00 0.00 0.00 16.84 9.66 13.25 17.79 0.00 0.00 0.0193 23.94 17.24 16.53 15.50 4.62% 14.24 4.62% 7.50 4.62% 10.99 8.77 8.62 6.24 0.00 0.00 0.00 0.00 0.00 16.84 0.00 13.25 0.00 0.00 0.00 0.0074 23.94 17.24 16.53 15.50 4.62% 14.24 4.62% 7.50 4.62% 10.99 8.77 8.62 6.24 0.00 0.00 0.00 0.00 0.00 16.84 0.00 13.25 0.00 0.00 0.00 0.0601 23.94 17.24 16.53 15.50 4.62% 14.24 4.62% 7.50 4.62% 10.99 8.77 8.62 6.24 0.00 0.00 0.00 0.00 0.00 16.84 0.00 13.25 0.00 0.00 0.00 0 2112 53334 40096 17195 105211 4855 165920 7657 288288 13304 22850 19901 19111 12984 0 0 5877 0 0 37499 0 5512 22204 5000 0 848911 0 1104 0 0 17195 0 0 91757 4235 75392 3479 0 0 0 5194 0 0 0 0 0 0 0 0 0 0 0 198355 0 0 0 0 0 0 0 90913 4196 77139 3560 0 0 10045 22396 0 0 0 0 0 0 10045 0 0 0 0 218293 0 0 0 0 0 0 0 0 18.8580 0.0000 0.0000 0.9966 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 13729 0 0 17278 0 0 0 0 0 0 31007 0 0 0 0 0 0 0 0 0 0 0 8.00% 3.00% 20.00% 0.35% 0.20% 0.00% 1.30% 7.50% 3.00% 18.00% 0.35% 0.25% 0.00% 0.25% 7.50% 3.00% 18.00% 0.35% 0.25% 0.00% 0.50% 7.00% 3.00% 18.00% 0.00% 0.20% 0.00% 1.00% 7.00% 3.00% 16.00% 0.35% 0.20% 0.00% 1.30% 4.00% 1.00% 5.00% 0.00% 0.00% 0.00% 0.00% 65907 24715 164767 2883 1648 0 10710 270629 14215 5686 34117 663 474 0 474 55629 1150548 66.3618 37.49 37.98 253984 30.2542 0 17338 17338 17338 17 0 0 52030 0 4407 6422 6842 20 0 0 17691 6135 6140 6160 6170 6190 6195 6196 6205 6400 6101 6102 6105 6110 6115 6120 6120 6125 6125 6130 6130 6131 6131 6135 6140 6160 6170 6176 6181 6186 6190 6195 6196 6205 6210 6230 avg nursing hours ppd or per visit Total nurs hrs ppd for nh &mrcdp activity director activity staff habilitation supervisor habilitation staff social worker - licensed social worker - unlicensed social services / pastoral care qa in-house trainer wages Staffing cost medical director - salaried medical director - contract don rn - charge lpn - charge rn vac,sick lpn vac,sick nurse aide,rsp, ward sec'y vac,sick ward clerk resource ward clerk level 2 activity director activity staff habilitation supervisor habilitation staff psychologist -contracted psychology assistant - contracted respiratory therapist - contracted social worker - licensed social worker - unlicensed social services / pastoral care qa salaried consulting ho cost T otal staffing cost 2.8000 0.3359 5.6000 0.6718 Purchased nursing 6300 Purchased Nursing -RN 6310 Purchased Nursing -LPN 6320 Purchased Nursing -Aides T otal purchased nursing 6400 6410 6420 6430 6440 6450 6455 6460 6470 6490 Nurse aide training in-house trainer wages classroom wages -aides clinical wages -aides books & supplies transportation tuition payments tuition reimbursements contractual registration/application employee fringes na training T otal nurse aide training 6510 6520 6530 6531 6535 6540 6550 Payroll taxes & fringes payroll taxes workers' comp fringes silb eap administrator self funded prog admin staff development T otal payroll taxes & fringes 0% 0% 0% T OT AL DIRECT T OT AL DIRECT PER DAY OR VISIT INDIRECT Dietary Meal Volume Parties (rotary,singles, etc) breakfast lunch- home delivered dinner guest dinner- home delivered & pickup snacks total in-house client meals employee meals 1640 3.9006 0.0058 0.0000 0.9000 0.0000 0.0500 0.0000 0.0500 15.1675 8.4000 7.0000 1.0000 2.0000 2.3612 0.4040 3.9506 0.2532 0.0558 9.6667 33.5675 0.0000 0.2532 9.6667 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 1.5000 2.8000 0.0000 0.0000 1.0000 0.5000 0.2000 0.6000 0.3500 0 240 0 3586 0 2102 97 0 0 22795 1052 0 16425 0 0 0 0 0 0 0 0 0 0 0 0 0 46296 0 240 0 8965 0 0 0 0 0 60849 2808 0 912 0 0 0 0 0 0 0 0 0 0 0 0 0 73774 0 0 1793 0 3865 178 0 0 90 4 0 912 0 0 0 0 0 0 0 3702 0 2912 0 0 0 13458 0 3696 53334 54440 34389 111177 5131 348590 16087 524552 24208 22850 38151 29155 40574 0 0 5877 0 0 41201 10045 8424 22204 5000 0 1399087 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 13729 0 0 17278 0 0 0 0 0 0 31007 0.7918 0.00 0.00 0.9966 0.00 0.00 0.00 0.00 0.00 0.00 1.7884 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.7918 0.00 0.00 0.9966 0.00 0.00 0.00 0.00 0.00 0.00 1.7884 15790 6316 37897 737 526 0 1053 62319 3144 1347 8083 0 90 0 449 13113 4951 2122 11316 248 141 0 919 19697 531 133 664 0 0 0 0 1328 104538 40319 256843 4531 2879 0 13605 422715 280612 59409 93471 14785 66.8522 Err:508 Err:508 Err:508 1852809 24.6912 3.8014 1.4255 9.5035 0.1663 0.0950 0.00 0.6177 15.6095 0.00 66.3618 1.6933 0.6773 4.0639 0.0790 0.0564 0.00 0.0564 6.6265 0.00 30.2542 3.7618 1.5047 9.0284 0.1756 0.1254 0.00 0.2508 14.8467 0.00 66.8522 0.2528 0.1083 0.6500 0.00 0.0072 0.00 0.0361 1.0544 0.00 4.7769 0.1526 0.0654 0.3487 0.0076 0.0044 0.00 0.0283 0.6069 0.00 2.8802 2.4159 0.6040 3.0198 0.00 0.00 0.00 0.00 6.0396 0.00 67.2663 12.0777 4.3852 26.6143 0.4285 0.2885 0.00 0.9894 44.7836 0.00 238.3916 730 25942 29209 35677 402 650 0 92610 0.00 1.0000 1.0000 1.0000 0.0010 0.00 0.00 3.0010 0.00 0.5250 0.7650 0.8150 0.0024 0.00 0.00 2.1074 0.00 1.0000 1.0000 1.0000 0.00 0.00 0.00 3.0000 0.0587 0.00 0.0338 0.5870 0.0293 0.0522 0.00 0.7610 0.00 0.00 0.0256 0.00 0.00 0.00 0.00 0.0256 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0587 2.5250 2.8244 3.4020 0.0327 0.0522 0.00 8.8950 2107 0 4198 4198 4198 0 0 0 12593 730 0 420 7300 365 650 0 9464 1.000 0.05 0.50 1.00 0.50 0.94 0.00 0.25 0.25 1.50 0.25 0.30 0.00 0.25 0.25 0.40 0.25 0.15 0.00 0.20 1.00 0.10 0.00 1.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 42 0 0 832 0 0 0 0 832 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 T otal meal volume 425 5.6000 2.8000 2.8000 1.4612 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0946 0.00 0.00 0.00 0.00 0.00 0.0507 0.00 0.00 0.00 0.00 0.00 0.0100 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.1553 0.00 0.00 0.00 0.00 0.00 53669 restaurant breakfast restaurant lunch restaurant dinner- home delivered total restaurant meals Staffing plan dietician - salaried food svc supv food svc supv assistant dietary personnel - am cook dietary personnel - am assistant dietary personnel - pm cook dietary personnel - pm assistant total 7.0000 5.6000 4.2000 1.0000 1.0000 2.9851 0.0000 11.2000 0.0000 18117 12635 9464 832 0 94717 3.0956 2.1581 3.0100 0.7610 0.0256 0.00 9.0503 0.0000 1.0000 0.0700 0.7000 1.4000 0.7000 1.3160 5.1860 0.2010 0.0000 0.0000 0.3500 0.3500 2.1000 0.3500 0.4200 3.5700 0.4099 0.0000 0.0000 0.3500 0.3500 0.5600 0.3500 0.2100 1.8200 0.0000 0.0000 0.2800 1.4000 0.1400 0.0000 1.4000 3.2200 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 1.0000 1.0500 2.8000 4.2000 1.4000 3.3460 13.7960 0.3030 0.9816 2.2234 0.0854 0.7541 1.3146 0.00 0.5459 1.0297 0.00 0.3706 0.0577 0.0577 0.00 1.2500 1.2500 1.2500 0.0012 0.00 0.3700 0.1182 0.00 0.00 0.00 0.3300 0.1846 0.1471 0.00 12.3218 0.00 0.00 0.8818 0.7787 4.0723 0.00 0.5637 0.6787 0.00 0.3339 0.00 0.00 0.00 0.6563 0.9563 1.0188 0.0030 0.00 0.00 0.0634 0.00 0.00 0.00 0.00 0.1191 0.1578 0.00 10.2836 0.00 0.00 1.7635 1.5575 2.1719 0.00 1.1273 0.6787 0.00 0.2905 0.00 0.00 0.00 1.2500 1.2500 1.2500 0.00 0.00 0.00 0.0125 0.00 0.00 0.00 0.00 0.00 0.3240 0.00 11.6759 0.00 0.00 0.4762 2.1026 0.1833 0.00 0.00 1.5271 0.00 0.1713 0.00 0.00 0.0734 0.00 0.0422 0.7337 0.0367 0.0653 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.4116 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0074 0.00 0.00 0.00 0.00 0.0321 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0395 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.9816 2.2234 3.2069 5.1929 7.7420 0.00 2.2369 3.9142 0.00 1.1737 0.0577 0.0577 0.0734 3.1563 3.5305 4.2525 0.0409 0.0653 0.3700 0.1941 0.00 0.00 0.00 0.3300 0.3037 0.6289 0.00 39.7324 0.6161 0.2347 1.8777 0.0651 0.0299 0.00 0.0264 2.8500 0.00 15.1718 0.5789 0.2437 1.0968 0.1828 0.0311 0.00 0.0274 2.1607 0.00 12.4443 0.5259 0.2214 0.9964 0.1661 0.0282 0.00 0.0249 1.9628 0.00 13.6387 0.1144 0.1144 0.3050 0.0423 0.0194 0.00 0.0172 0.6127 0.00 6.0244 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0395 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.8352 0.8142 4.2759 0.4563 0.1087 0.00 0.0959 7.5863 0.00 47.3186 0.1512 0.1717 0.5679 0.0736 0.3172 1.2816 1.2487 0.0203 0.0849 0.00 0.1429 1.4968 1.0406 0.0223 0.1380 0.00 0.2859 1.4868 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2.4405 0.2142 0.7908 0.0736 0.7461 4.2652 0.00 0.6630 0.00 0.4635 0.7651 0.00 0.0476 0.00 2.1452 0.4803 0.00 0.3019 0.0821 0.00 0.00 0.00 0.1191 0.00 0.00 0.00 0.0119 0.00 11.1320 16.2118 0.00 0.2238 0.00 0.00 0.00 0.00 0.0680 0.00 2.0434 0.1100 0.00 0.0276 0.00 0.00 0.00 0.00 0.0546 0.00 0.0072 0.0258 0.00 0.00 1.4349 3.9953 0.00 0.00 0.00 0.1299 0.0075 0.00 0.2150 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.3911 0.7435 0.00 0.00 0.00 3.0737 14.7120 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13.0992 30.8849 4.4719 2.6838 0.0302 4.6749 17.6440 0.00 0.4420 1.5565 7.4323 1.3154 1.6553 1.3110 0.6647 0.2054 0.00 1.2171 0.8529 0.00 0.8067 0.4754 0.5674 0.00 51.2832 99.2899 7000 7001 7005 7015 7015 7015 7015 7015 7015 7015 7025 7030 7035 7040 7040 7040 7040 7040 7040 7040 7045 7045 7045 7045 7041 7050 7055 7056 Dietary costs dietician - salaried dietician - contracted food svc supv food svc supv assistant dietary personnel - am cook dietary personnel - am assistant vac,sick dietary personnel - pm cook dietary personnel - pm assistant vac,sick dietary supplies expense dietary minor equipment dietary maintenance & repair Parties (rotary,singles, etc) breakfast lunch- home delivered dinner guest dinner- home delivered & pickup snacks employee meals restaurant breakfast restaurant lunch restaurant dinner- home delivered medical needs nutrition volunteers, meetings, other enterals - m'care billable enterals - m'care non billable subtotal dietary costs 0 0.31710 17.43 10.17 8.98 7.83 0.00% 6.50 6.52 0.00% 0.37065 0.05768 0.05768 1.25000 1.25000 1.25000 1.25000 1.25000 1.25000 0.3700 1.25000 1.25000 1.25000 1.25000 0.3300 0.1846 150% 150% 0.00 0.00000 17.43 10.17 8.98 7.83 0.00% 6.50 6.52 0.00% 0.33389 0.00000 0.00000 1.25000 1.25000 1.25000 1.25000 1.25000 1.25000 0.3700 1.25000 1.25000 1.25000 1.25000 0.0000 0.1191 150% 150% 0.00 0.00 17.43 10.17 8.98 7.83 0.00 6.50 6.52 0.00 0.29 0.00 0.00 1.25000 1.25000 1.25000 1.25000 1.25000 1.25000 0.3700 1.25000 1.25000 1.25000 1.25000 0.0000 0.0000 150% 150% 0.00 0.00000 17.43 10.17 8.98 7.83 0.00% 6.50 6.52 0.00% 0.17127 0.00000 0.00000 1.25000 1.25000 1.25000 1.25000 1.25000 1.25000 0.3700 1.25000 1.25000 1.25000 1.25000 0.0000 0.0000 0.00 0.00000 17.43 10.17 8.98 7.83 0.00% 6.50 6.52 0.00% 0.29000 0.00000 0.00000 1.25000 1.25000 1.25000 1.25000 1.25000 1.25000 0.3700 1.25000 1.25000 1.25000 1.25000 0.0000 0.0000 0.00 0.08906 17.43 10.17 8.98 7.83 0.00% 6.50 6.52 0.00% 0.00000 0.00000 0.00000 1.25000 1.25000 1.25000 1.25000 1.25000 1.25000 0.3700 1.25000 1.25000 1.25000 1.25000 0.0000 0.0000 0 17018 38549 1480 13075 22791 0 9464 17853 0 6426 1000 1000 0 21672 21672 21672 21 0 6415 2050 0 0 0 5721 3200 2550 0 213629 0 0 0 7402 6537 34187 0 4732 5698 0 2803 0 0 0 5509 8028 8552 25 0 0 532 0 0 0 0 1000 1325 0 86331 0 0 0 7402 6537 9117 0 4732 2849 0 1219 0 0 0 5247 5247 5247 0 0 0 53 0 0 0 0 0 1360 0 49010 0 0 0 5922 26150 2279 0 0 18992 0 2130 0 0 913 0 525 9125 456 812 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 241 0 0 0 0 1040 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67303 1282 0 0 17018 38549 22207 52300 68374 0 18928 45391 0 12820 1000 1000 913 32428 36511 44596 503 812 6415 2634 0 0 0 5721 4200 5235 0 417554 7060 7065 7070 7071 7075 7080 7090 Payroll taxes & fringes payroll taxes workers' comp fringes silb eap administrator self funded prog admin staff development T otal payroll taxes & fringes 10.50% 4.00% 32.00% 1.11% 0.51% 0.00% 0.45% 9.50% 4.00% 18.00% 3.00% 0.51% 0.00% 0.45% 9.50% 4.00% 18.00% 3.00% 0.51% 0.00% 0.45% 3.00% 3.00% 8.00% 1.11% 0.51% 0.00% 0.45% 9.50% 3.00% 8.00% 1.11% 0.51% 0.00% 0.45% 9.50% 3.00% 8.00% 1.11% 0.51% 0.00% 0.45% 10682 4069 32554 1129 519 0 458 49411 4860 2046 9208 1535 261 0 230 18139 2207 929 4182 697 118 0 105 8239 1423 1423 3794 526 242 0 213 7621 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19171 8467 49738 3887 1140 0 1006 83410 263040 15.1718 4.9011 104470 12.4443 5.7664 57249 74924 1282 0 13.6387 Err:508 Err:508 Err:508 4.5311 7.9164 1.5400 0.0000 500964 6.6760 5.2890 150% 8.40 0.1717 275% 125% 0.3172 150% 8.40 0.0203 275% 125% 0.1429 150% 8.40 0.02 275% 125% 0.29 150% 8.40 0.0000 275% 125% 0.0000 150% 8.40 150% 8.40 0.0000 275% 125% 0.0000 0 2621 2976 9847 1276 5500 22219 0 10483 170 712 0 1200 12566 0 4368 94 579 0 1200 6241 0 0 275% 125% 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17472 3240 11138 1276 7900 41026 1.00 0.15 0.50 1.00 1.44 1.29 0.00 0.50 0.00 0.00 0.60 0.30 0.00 0.88 0.00 0.00 0.30 0.00 0.00 0.25 0.10 0.00 0.50 0.00 0.00 0.00 0.00 0.00 0.00 0.10 0.00 1.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.0000 0.1500 0.5000 1.0000 2.0125 1.8125 0.0000 0.5000 0.0000 6.9750 0.0000 0.6000 0.3000 0.0000 0.8750 0.0000 0.0000 0.3000 0.0000 2.0750 0.0000 0.2500 0.1000 0.0000 0.7000 0.0000 0.0000 0.0000 0.0000 1.0500 0.0000 0.0000 0.1000 0.0000 2.1000 0.0000 0.0000 0.0000 0.0000 2.2000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 1.0000 1.0000 1.0000 1.0000 5.6875 1.8125 0.0000 0.8000 0.0000 12.3000 35.32 13.38 0.0302 0.7678 1.3051 0.0000 0.10 12.14 6.18 0.4594 7.61 0.6295 0.5472 0.2054 0.0000 1.2171 0.3731 0.0000 0.7994 0.4496 0.3172 0.0000 9.50% 35.32 13.38 0.00 0.2401 0.8544 0.00 0.01 12.14 8.07 0.2656 7.61 0.3520 0.0354 0.0000 0.0000 0.0000 0.3061 0.0000 0.0000 0.0000 0.2382 0.0000 9.50% 35.32 13.38 0.00 0.4635 0.7651 0.00 0.05 12.14 6.18 0.4803 7.61 0.3019 0.0821 0.0000 0.0000 0.0000 0.1191 0.0000 0.0000 0.0000 0.0119 0.0000 9.50% 35.32 13.38 0.00 0.0000 0.0000 0.00 0.07 12.14 5.82 0.1100 7.61 0.0276 0.0000 0.0000 0.0000 0.0000 0.0546 0.0000 0.0072 0.0258 0.0000 0.0000 9.50% 35.32 13.38 0.00 175.6215 10.1030 0.00 290.7900 12.14 5.82 0.0000 7.61 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 9.50% 35.32 13.38 0.00 3.0737 14.7120 0.00 0.0000 12.14 5.82 0.0000 7.61 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 9.50% 77532 13914 524 13311 22627 0 1725 26986 25888 7966 28699 10914 9486 3560 0 21101 6468 0 13860 7795 5500 0 271420 569276 0 8349 0 2016 7172 0 100 0 14696 2230 0 2955 297 0 0 0 2570 0 0 0 2000 0 80347 122731 0 2783 0 1945 3211 0 200 0 9005 2016 0 1267 345 0 0 0 500 0 0 0 50 0 46727 68049 0 2783 0 0 0 0 845 0 25413 1368 0 343 0 0 0 0 679 0 90 321 0 0 17846 49688 0 0 0 4215 242 0 6979 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12693 24129 0 0 0 676 3234 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2879 6789 77532 27829 524 22163 36487 0 9849 26986 75002 13580 28699 15479 10128 3560 0 21101 10218 0 13950 8116 7550 0 431911 840662 4.4719 0.8026 0.0302 0.7678 1.3051 0.00 0.0995 1.5565 1.4932 0.4594 1.6553 0.6295 0.5472 0.2054 0.00 1.2171 0.3731 0.00 0.7994 0.4496 0.3172 0.00 15.6551 32.8350 0.00 0.9945 0.00 0.2401 0.8544 0.00 0.0119 0.00 1.7505 0.2656 0.00 0.3520 0.0354 0.00 0.00 0.00 0.3061 0.00 0.00 0.00 0.2382 0.00 9.5708 14.6195 T otal dietary T otal dietary ppd or visit T otal dietary per meal Indirect pt care supplies 7100 habilitation supplies 7105 medical/habilitation records 7110 pharmaceutical consultant 7115 incontinence supplies 7120 personal care supplies 7125 program supplies T otal indirect pt care supplies 7200 7105 7210 7240 7245 7250 7265 7320 7330 7200 7210 7215 7220 7225 7231 7235 7240 7245 7246 7250 7251 7255 7260 7265 7266 7270 7275 7280 7285 7290 7295 7310 Administrative & general Staffing plan administrator medical/habilitation records other adminstrative personnel laundry & hsk supv hsk - salaried laundry & linen salaried accounting - salaried plant operations supv plant operations staff total A & g costs administrator other adminstrative personnel consulting & management fees office & admin sup communications security svcs - contracted travel & entertainment laundry & hsk supv hsk - salaried hsk - sup & contracted laundry & linen salaried laundry & linen sup & contracted universal precautions legal svcs accounting - salaried accounting - contracted dues, subscriptions, license interest - other insurance date svcs help wanted amortization ho costs - indirect Subtotal a & g costs Plant operations 7320 plant operations supv 7330 plant operations staff 7340 repairs & maint 7350 minor equipment 7400 Leased Equipment Subtotal plant operations 7500 7510 7520 7521 7525 7530 7535 Payroll taxes & fringes payroll taxes workers' comp fringes silb eap administrator self funded prog admin staff development T otal payroll taxes & fringes 13.37 9.00 1.6203 0.0577 0.2769 13.37 9.00 0.4896 0.0000 0.0000 13.37 9.00 0.98 0.00 0.00 13.37 0.00 0.0000 0.0000 0.0000 0.00 0.00 0.0000 0.0000 0.0000 13.37 9.00 0.0000 0.0000 0.0000 16399 0 28091 1000 4800 50290 8344 0 4111 0 0 12454 0 0 4101 0 0 4101 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24743 0 36302 1000 4800 66845 0.9459 0.00 1.6203 0.0577 0.2769 2.9007 0.9939 0.00 0.4896 0.00 0.00 1.4835 0.00 0.00 0.9769 0.00 0.00 0.9769 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.9397 0.00 3.0868 0.0577 0.2769 5.3611 6.80% 2.25% 21.11% 1.30% 0.33% 0.00% 1.00% 10.00% 4.00% 15.00% 1.30% 0.80% 0.00% 1.00% 10.00% 4.00% 15.00% 1.30% 0.80% 0.00% 1.00% 9.00% 2.25% 15.00% 1.30% 0.33% 0.00% 1.00% 6.80% 2.25% 15.00% 1.30% 0.33% 0.00% 1.00% 6.80% 2.25% 15.00% 1.30% 0.33% 0.00% 1.00% 13059 4321 40539 2497 634 0 1920 62970 4187 1675 6281 544 335 0 419 13441 1616 646 2423 210 129 0 162 5186 2538 634 4229 367 93 0 282 8143 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21399 7276 53473 3617 1191 0 2783 89739 0.7532 0.2492 2.3383 0.1440 0.0366 0.00 0.1108 3.6320 0.4988 0.1995 0.7481 0.0648 0.0399 0.00 0.0499 1.6010 0.3849 0.1540 0.5773 0.0500 0.0308 0.00 0.0385 1.2355 0.2040 0.0510 0.3401 0.0295 0.0075 0.00 0.0227 0.6548 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.8409 0.6537 4.0038 0.2883 0.1147 0.00 0.2218 7.1232 4.8184 0.0000 0.0000 0.00 0.0000 0.0000 0.0000 13.7167 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0000 0.0000 0.0000 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 200% 200% 200% 200% 150% 150% 200% 200% 200% 200% 175% 175% 200% 200% 200% 200% 200% 200% 200% 200% 257% 202% 257% 202% 100% 100% 100% 100% 100% 100% 0.0000 0.0000 0.0000 0.0000 0.5956 0.0000 0.1001 0.0000 0.0000 65% 0.1331 150% 0.0000 100% 100% 100% 100% 100% 100% 0.00 0.00 0.00 0.00 0.60 0.00 0.10 0.00 0.00 65% 0.11 0.85 0.00 100% 100% 100% 100% 100% 100% 0.0000 0.0000 0.0000 0.0000 0.0402 0.0000 0.0000 0.0000 0.0000 0% 0.0000 0% 0% 0% 0% 0% 0% 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0% 0.0000 100% 100% 100% 100% 100% 100% 0.0000 0.0000 0.0000 0.0000 4.5496 0.0000 0.0000 0.0000 0.0000 0% 0.0000 0.0000 0.0000 0.0000 T otal a & g T otal a & g ppd & visit 704755 40.6492 CAPIT AL COST S depreciation - bldg 3.6848 amortization - land improvements 0.0081 amortization - leasehold improvements 0.0791 depreciation - equipment 3.07 depreciation - transport equipment 0.0393 lease & rent - bldg 0.1114 lease & rent - equip 0.0000 interest - p,p&e 10.4850 amortization of financing costs 0.0000 ho costs 0.0000 deprecitaion - renovations 0.0000 interest - renovations 0.0000 amortization - financing costs 0.0000 T OT AL CAPIT AL COST S T OT AL CAPIT AL COST S PPD OR VISIT 161191 19.2009 83576 57832 24129 6789 19.9109 Err:508 Err:508 Err:508 1038272 13.8364 967796 55.8209 T OT AL INDIRECT T OT AL INDIRECT PPD & VISIT 8010 8020 8030 8040 8050 8060 8065 8070 8080 8090 8500 8570 8580 265661 31.6451 140825 132756 25411 6789 33.5497 Err:508 Err:508 Err:508 63885 141 1372 53309 682 1931 0 181784 0 0 0 0 0 303103 17.4825 40451 0 0 0 0 0 0 115151 0 0 0 0 0 155602 18.5351 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.0000 Err:508 85543 0 71672 0 7349 0 0 0 0 0 0 164564 9.4918 0 0 0 0 0 0 0 0 0 0 0 0 0.0000 0 0 0 0 0 0 0 0 0 0 0 0 0.0000 Err:508 0 91182 485 11603 2029 5445 0 936 0 0 10000 0 5167 0 6965 6355 597 0 0 140765 8.1191 0 32078 0 0 510 0 0 0 0 0 5000 0 840 0 0 12024 1118 0 0 51570 6.1429 0 0 17771 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2500 500 0 0 420 0 0 0 0 0 940 0 471 0 0 0 0 22103 500 5.2656 Err:508 Err:508 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22103 500 5.2656 Err:508 Err:508 0 0 19.2009 19.9109 4.6500 0.7435 30.8849 116.0394 55.8209 31.6451 33.5497 10.6744 0.7830 30.8849 163.3581 104335 141 1372 53309 682 1931 0 296935 0 0 0 0 0 458705 6.1129 3.6848 0.0081 0.0791 3.0748 0.0393 0.1114 0.00 10.4850 0.00 0.00 0.00 0.00 0.00 17.4825 4.8184 0.00 0.00 0.00 0.00 0.00 0.00 13.7167 0.00 0.00 0.00 0.00 0.00 18.5351 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8.5032 0.0081 0.0791 3.0748 0.0393 0.1114 0.00 24.2017 0.00 0.00 0.00 0.00 0.00 36.0176 0 0 0 0 0 0 0 0 0 0 0 0 0 Err:508 40.6492 1539236 20.5124 0 0 0 0 0 0 0 0 0 0 0 0 0 0 85543 0 71672 0 7349 0 0 0 0 0 0 164564 2.1930 4.9340 0.00 4.1339 0.00 0.4239 0.00 0.00 0.00 0.00 0.00 0.00 9.4918 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.9340 0.00 4.1339 0.00 0.4239 0.00 0.00 0.00 0.00 0.00 0.00 9.4918 0 141032 485 11603 2539 5445 0 936 0 0 19000 0 6427 0 6965 19319 2185 0 0 215937 2.8776 0.00 5.2593 0.0280 0.6693 0.1170 0.3141 0.00 0.0540 0.00 0.00 0.5768 0.00 0.2980 0.00 0.4017 0.3666 0.0344 0.00 0.00 8.1191 0.00 3.8211 0.00 0.00 0.0608 0.00 0.00 0.00 0.00 0.00 0.5956 0.00 0.1001 0.00 0.00 1.4323 0.1331 0.00 0.00 6.1429 0.00 4.2338 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.5956 0.00 0.1001 0.00 0.00 0.2240 0.1122 0.00 0.00 5.2656 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0402 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.0402 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.5496 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.5496 0.00 13.3141 0.0280 0.6693 0.1778 0.3141 0.00 0.0540 0.00 0.00 6.3578 0.00 0.4982 0.00 0.4017 2.0228 0.2798 0.00 0.00 24.1174 Err:508 NONREIMBURSABLES 6600 6605 6610 6615 6620 6630 6640 6650 6660 6670 6680 T herapy physical therapist physical therapy assistant occupational therapist occupational therapy assistant speech therapist audiologist payroll taxes - therapy workers comp. - therapy employee fringes - therapy self funded -therapy staff development - therapy T otal therapy T otal therapy ppd or visit Misc nonreimbursables 9705 legend drugs nonbillable m'care 100% 9706 legend drugs billable m'care 100% 9710 radiology 100% 9715 laboratory 100% 9720 oxygen 100% 9721 ambulance 100% 9725 other nonreimburseable (BPAV mgmt fee) 0.0000 9726 other- Dentist Nursing Home 0.0540 9730 late fees 0.0000 9740 state income tax 0.0000 9755 promotional advertising 0.5768 9760 contributions 0.0000 9765 bad debt 2.8313 9770 parenteral nutrition therapy 0.0000 9775 miscellaneous 0.4017 9780 barber & beauty -salary 65% 9781 barber & beauty -sup 0.0344 9790 vending 165% 9795 gift shop expense 0.0000 total misc nonreimbursables total misc nonreimbursables ppd & visit T OT AL NONREIMBURSABLE T OT AL NONREIMBURSABLE PPD OR VISIT 305329 17.6109 ADD: accrual capital costs amort of financing costs LESS: 1406 replacement reserve cash debt service CASH FLOW SUMMARY: NOMINAL UT ILIZ AT ION T otal census T otal days and visits T otal meal volume REVENUE T otal room & board revenue Subtotal revenue - home health T otal meal revenue T otal therapy revenue T otal supply revenue T otal other revenue T otal Contractual Allowance T OT AL REVENUE NET OF CA 92773 0 0 0 0 0 0 0 0 0 0 0 0 Err:508 Err:508 0 0 0 0 0 0 1000 0 0 0 0 0 0 0 0 1000 Err:508 1000 380501 5.0707 17.6109 6.1429 5.2656 0.0402 0.00 4.5496 33.6092 467838 192838 118882 22574 111.4563 Err:508 Err:508 Err:508 4453396 59.3474 167.1684 89.6942 111.4563 15.5054 3.6632 102.7008 490.1883 93041 -2.3778 11.0510 5.7228 -0.4011 0.4538 35.1860 49.6347 458705 0 17.4825 0.00 0.00 -0.5768 -13.3756 18.5351 0.00 0.00 -1.1912 -19.0192 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 36.0176 0.00 0.00 -1.7680 -32.3948 1.1522 9.3757 5.7228 -0.4011 0.4538 35.1860 51.4895 51.4895 24022 0 0 0 0 0 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 0 Err:508 14726 0 0 7734 155602 0 -10000 -231900 -10000 -159666 0 0 0 0 0 -20000 -391566 19977 -10000 -159666 0 0 -4988 303103 0 -10000 -231900 OPERAT ING CASH FLOW LESS: Capital items from operating cash 1202 Land Improvements 1203 Bldg & Bldg Improvements 1204 Equipment 1205 T ransportation Equipment 752983 89.6942 -41226 ACCRUAL NET INCOME 51570 6.1429 2898281 167.1684 T OT AL EXPENSES T OT AL EXPENSES PPD & VISIT 0 0 0 0 0 0 0 0 0 0 0 0 78709 24 022 -4 988 14 726 7734 0 0 14 0180 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19977 78709 24022 -4988 14726 7734 140180 1.1522 9.3757 5.7228 -0.4011 0.4538 35.1860 48 17338 53669 23 8395 18117 12 4198 12635 509 12437 9464 24 32453 832 1 220 0 82 75039 94717 1.0000 3.0956 1.0000 2.1581 1.0000 3.0100 1.0000 0.7610 1.0000 0.0256 1.0000 0.00 6.0000 9.0503 2800919 0 3364 329128 63924 93965 -434244 2857055 644043 0 105267 0 4862 91585 0 845756 444935 0 84 0 5188 41653 0 491860 0 47138 69294 0 0 71417 0 187850 0 128882 4727 0 0 0 0 133609 0 24270 0 0 0 6037 0 30308 3889896 200290 182737 329128 73973 304656 -434244 4546437 161.5526 0.00 0.1940 18.9836 3.6870 5.4197 -25.0465 164.7905 76.7174 0.00 12.5392 0.00 0.5791 10.9094 0.00 100.7452 106.0000 0.00 0.0201 0.00 1.2359 9.9232 0.00 117.1792 0.00 3.7902 5.5717 0.00 0.00 5.7424 0.00 15.1044 0.00 3.9714 0.1457 0.00 0.00 0.00 0.00 4.1170 0.00 110.4200 0.00 0.00 0.00 27.4668 0.00 137.8868 344.2700 118.1816 18.4707 18.9836 5.5021 59.4615 -25.0465 539.8230 EXPENSES PROT ECT ED T otal medical supplies T otal utilities T otal taxes T OT AL PROT ECT ED 40882 95387 35238 171506 1400 24766 0 26166 8361 15938 0 24299 0 173 0 173 0 0 0 0 0 0 0 0 50643 136263 35238 222144 2.3580 5.5017 2.0325 9.8922 0.1668 2.9501 0.00 3.1169 1.9919 3.7970 0.00 5.7889 0.00 0.0139 0.00 0.0139 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4.5167 12.2627 2.0325 18.8119 848911 0 31007 270629 1150548 198355 0 0 55629 253984 218293 0 0 62319 280612 46296 0 0 13113 59409 73774 0 0 19697 93471 13458 0 0 1328 14785 1399087 0 31007 422715 1852809 48.9639 0.00 1.7884 15.6095 66.3618 23.6277 0.00 0.00 6.6265 30.2542 52.0054 0.00 0.00 14.8467 66.8522 3.7225 0.00 0.00 1.0544 4.7769 2.2733 0.00 0.00 0.6069 2.8802 61.2267 0.00 0.00 6.0396 67.2663 191.8196 0.00 1.7884 44.7836 238.3916 Dietary Personnel Food Other T otal payroll taxes & fringes T otal dietary 103212 79223 31194 49411 263040 58556 22646 5128 18139 104470 30637 15793 2579 8239 57249 53343 11831 2130 7621 74924 0 1040 241 0 1282 0 0 0 0 0 245749 130533 41273 83410 500964 5.9531 4.5694 1.7992 2.8500 15.1718 6.9751 2.6976 0.6108 2.1607 12.4443 7.2989 3.7625 0.6144 1.9628 13.6387 4.2891 0.9513 0.1713 0.6127 6.0244 0.00 0.0321 0.0074 0.00 0.0395 0.00 0.00 0.00 0.00 0.00 24.5163 12.0129 3.2032 7.5863 47.3186 T otal indirect pt care supplies Subtotal a & g costs Subtotal plant operations T otal payroll taxes & fringes T otal a & g 22219 569276 50290 62970 704755 12566 122731 12454 13441 161191 6241 68049 4101 5186 83576 0 49688 0 8143 57832 0 24129 0 0 24129 0 6789 0 0 6789 41026 840662 66845 89739 1038272 1.2816 32.8350 2.9007 3.6320 40.6492 1.4968 14.6195 1.4835 1.6010 19.2009 1.4868 16.2118 0.9769 1.2355 19.9109 0.00 3.9953 0.00 0.6548 4.6500 0.00 0.7435 0.00 0.00 0.7435 0.00 30.8849 0.00 0.00 30.8849 4.2652 99.2899 5.3611 7.1232 116.0394 T OT AL INDIRECT 967796 265661 140825 132756 25411 6789 1539236 55.8209 31.6451 33.5497 10.6744 0.7830 30.8849 163.3581 T OT AL CAPIT AL COST S 303103 155602 0 0 0 0 458705 17.4825 18.5351 0.00 0.00 0.00 0.00 36.0176 NONREIMBURSABLES T otal therapy promotional advertising other misc nonreimbursables 164564 10000 130765 0 5000 46570 0 2500 19603 0 500 0 0 0 0 0 1000 0 164564 19000 196937 9.4918 0.5768 7.5423 0.00 0.5956 5.5473 0.00 0.5956 4.6701 0.00 0.0402 0.00 0.00 0.00 0.00 0.00 4.5496 0.00 T OT AL NONREIMBURSABLE 305329 51570 22103 500 0 1000 380501 17.6109 6.1429 5.2656 0.0402 0.00 4.5496 33.6092 2898281 752983 467838 192838 118882 22574 4453396 167.1684 89.6942 111.4563 15.5054 3.6632 102.7008 490.1883 -41226 92773 24022 -4988 14726 7734 93041 -2.3778 11.0510 5.7228 -0.4011 0.4538 35.1860 49.6347 303103 0 0 -10000 -231900 0 19977 155602 0 0 -10000 -159666 0 78709 0 0 0 0 0 0 0 0 0 0 0 -4 988 0 0 0 0 0 0 14 726 0 0 0 0 0 0 7734 458705 0 0 -20000 -391566 137621 14 17.4825 0.00 0.00 -0.5768 -13.3756 18.5351 0.00 0.00 -1.1912 -19.0192 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 36.0176 0.00 0.00 -1.7680 -32.3948 DIRECT T otal staffing cost T otal purchased nursing T otal nurse aide training T otal payroll taxes & fringes T OT AL DIRECT INDIRECT T OT AL EXPENSES ACCRUAL NET INCOME ADD: accrual capital costs amort of financing costs LESS: replacement reserve cash debt service OPERAT ING CASH FLOW 02/17/2015, 07:30:54 page 1 24 022 9.4918 6.3578 17.7597