State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular MR Facilities Page 1 Summary
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Salaries & Wages: Outside Professional Fees: Employee Expenses: Taxes (Non-Payroll): Office Expenses: Insurance: General Expenses: Drugs & Medical Supplies: Capital Related Cost: Administrative Services: Other Expenses: $ $ $ $ $ $ $ $ $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 15,090,979 1,208,702 2,717,644 101,444 1,174,709 362,981 2,971,076 491,256 1,651,224 1,089,529 2,255,917 Cost Per Day $ $ $ $ $ $ $ $ $ $ $ 57.55 4.61 10.36 0.39 4.48 1.38 11.33 1.87 6.30 4.15 8.60
Total:
$ 29,115,459
$
111.03
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary Regular ICF M/R Facilities SFY 2007 Versus SFY 2006
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Salaries & Wages: Outside Professional Fees: Employee Expenses: Taxes (Non-Payroll): Office Expenses: Insurance: General Expenses: Drugs & Medical Supplies: Capital Related Cost: Administrative Services: Other Expenses: $ $ $ $ $ $ $ $ $ $ $ $
SFY 2007 365,336 262,238 257,902 4,336 71.78% 98.35% Total Per Day 57.55 4.61 10.36 0.39 4.48 1.38 11.33 1.87 6.30 4.15 8.60 111.03 $ $ $ $ $ $ $ $ $ $ $ $
SFY 2006 371,205 279,077 276,472 2,605 75.18% 99.07% Total Per Day 54.03 6.13 10.58 0.20 4.61 1.01 10.85 1.69 5.93 2.61 8.11 105.75
Total:
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 2 Salaries and Wages
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Registered Nurses: Licensed Practical Nurses: Director of Nursing: Nurse Aides: CMA Aides: QMRP'S (ICF-MR Only): Medical Director: Physical Therapist: Occupational Therapist: Respitory Therapist: Speech Therapist: Therapy Aide/Assistant: Administrator: Assistant Administrator: Accountant/Bookeeper: Other Office Staff: Soc Serv Dir/Soc Worker: Other Soc Serv Staff: Activities Director: Other Activities Staff: Comb Soc Serv/Activities: Dietician: Other Dietary Staff: $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Total Cost 82,602 1,492,074 431,367 7,294,443 1,063,917 660,726 13,000 23,934 487,901 2,041 117,262 194,505 126,321 14,197 121,354 55,845 69,893 1,237,123 Total Hours 3,464 92,309 21,869 853,035 114,110 36,828 520 800 22,467 67 6,873 20,139 8,194 1,371 10,234 6,984 5,793 150,966 Cost Per Day $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 0.31 5.69 1.64 27.82 4.06 2.52 0.05 0.09 1.86 0.01 0.45 0.74 0.48 0.05 0.46 0.21 0.27 4.72 Hrs Per Day $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 0.01 0.35 0.08 3.25 0.44 0.14 0.00 0.00 0.09 0.00 0.03 0.08 0.03 0.01 0.04 0.03 0.02 0.58 $ $ $ $ $ $ $ $ $ $ Cost Per Hr $ $ $ $ $ $ $ $ 23.85 16.16 19.73 8.55 9.32 17.94 25.00 29.92 #DIV/0! #DIV/0! #DIV/0! #DIV/0! 21.72 30.46 17.06 9.66 #DIV/0! 15.42 10.36 11.86 8.00 12.07 8.19
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular MR Facilities Page 2 cont. Salaries and Wages
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Housekeeping Supervisor: Housekeeping Staff: Maintenance Supervisor: Maintenance Staff: Laundry Supervisor: Other Laundry Staff: Medical Records: Misc: 365,336 262,238 257,902 4,336 71.78% 98.35% Total Cost 54,041 685,081 58,366 427,798 271,450 15,621 90,116 Total Hours 4,351 95,964 2,709 47,537 40,319 1,998 6,508 Cost Per Day $ 0.21 $ $ $ $ $ $ $ 2.61 0.22 1.63 1.04 0.06 0.34 Hrs Per Day $ 0.02 $ $ $ $ $ $ $ 0.37 0.01 0.18 0.15 0.01 0.02 $ $ $ Cost Per Hr $ 12.42 $ $ $ 7.14 21.55 9.00 #DIV/0! 6.73 7.82 13.85
$ $ $ $ $ $ $ $
Total Salaries & Wages:
$ 15,090,979
1,555,409
$
57.55
$
5.93
$
9.70
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 3 Outside Professional Fees
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Contract Registered Nurse: Contract Lic. Practical Nurse: Contract Nurse Aides: Medical Director: Therapists: Consulting Social Worker: Dietician: Pharmacist: Dentist: Accountants: Legal: Housekeeping: Maintenance: Other: Computer Programmer: $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 49,257 58,500 124,764 20,269 61,753 42,332 5,057 30,817 55,311 760,197 445 Cost Per Day $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 0.19 0.22 0.48 0.08 0.24 0.16 0.02 0.12 0.21 2.90 0.00
Total O/S Professional:
$ 1,208,702
$
4.61
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 4 Employee Expenses
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Employee Benefits and Payroll Related Expenses Fica: Unemployment Compensation Tax: Workman's Compensation Insurance: Group Health Dental Insurance: Life Insurance: Retirement and Pension: Other Employee Benefits: Staff Development and Training Nurse Aide Competency Evaluation: Other Licensed Direct Care Training: Other: $ $ $ $ $ $ $ $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 1,148,980 177,310 958,671 283,034 7,834 8,119 58,237 25,450 27,488 22,520 Cost Per Day $ $ $ $ $ $ $ $ $ $ 4.38 0.68 3.66 1.08 0.03 0.03 0.22 0.10 0.10 0.09
Total
$ 2,717,644
$
10.36
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 5 Taxes Non-Payroll Related
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Excise Tax: Corportation License: Ad Valorem: Auto Tag/Registration: Other: $ $ $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 8,719 85,424 3,471 3,829 Cost Per Day $ $ $ $ $ 0.03 0.33 0.01 0.01
Total Taxes Non-Payroll
$ 101,444
$
0.39
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 6 Office Expense
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Office Supplies: Office Phone: Office Utilities: 365,336 262,238 257,902 4,336 71.78% 98.35% Totals $ $ $ 161,961 106,830 905,918 Cost Per Day $ $ $ 0.62 0.41 3.45
Total Office Expense:
$ 1,174,709
$
4.48
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 7 Insurance Non-Payroll
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Building Insurance: Automobile Insurance: Other Insurance: $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 130,266 33,192 199,523 Cost Per Day $ $ $ 0.50 0.13 0.76
Total Insurance Expense:
$ 362,981
$
1.38
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 8 General Expenses
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Dues and Publications: Public Relations: Automobile Expense: Maintenance: Laundry and Linen: Housekeeping Supplies: Food and Kitchen Supplies: Social Services Supplies: $ $ $ $ $ $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 34,265 45,531 150,430 636,113 102,378 250,419 1,613,293 138,648 Cost Per Day $ $ $ $ $ $ $ $ 0.13 0.17 0.57 2.43 0.39 0.95 6.15 0.53
Total General Expenses:
$ 2,971,076
$
11.33
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 9 Drugs & Medical Supplies
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Drugs and Medical Supplies: Over-the-Counter Medication: Special Adaptive Medical Equip: $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 395,478 86,274 9,503 Cost Per Day $ $ $ 1.51 0.33 0.04
Total Drugs & Medical:
$ 491,256
$
1.87
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 10 Capital Related Cost
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Equipment Rent/Lease: Facility Rent/Lease: Interest Expense: Depreciation Summary Building & Improvements: Local Improvements: Leasehold & Improvements: Equipment: Total Depreciation: $ 119,897 $ $ 6,315 $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 97,040 1,209,011 36,397 Cost Per Day $ $ $ $ $ $ $ $ $ 308,776 $ 0.37 4.61 0.14 0.46 0.02 0.70 1.18
$ 182,564
Total Capital Related Costs:
$ 1,651,224
$
6.30
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 11 Administrative Services
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Home Office Expense: Owner's Non-Salary Compensation: Owner's Salaries Paid: Benefits on Owner's Salaries: Director's Fees: Management Fees Paid: $ $ $ $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 446,985 294,555 117,322 6,667 224,000 Cost Per Day $ $ $ $ $ $ 1.70 1.12 0.45 0.03 0.85
Total Administrative Services:
$ 1,089,529
$
4.15
State of Oklahoma Oklahoma Health Care Authority Nursing Home Facility Cost Report Summary State Fiscal Year June 30, 2007
Regular ICF/MR Facilities Page 12 Other Expenses
Available Patient Days: Total Patient Days: Medicaid Days: Medicare Days: Other Days: Occupancy %: % of Medicaid: Description: Hepatitis Vaccination Costs: Provider Fees: Other Costs: $ $ $ 365,336 262,238 257,902 4,336 71.78% 98.35% Totals 6,655 1,599,597 649,665 Cost Per Day $ $ $ 0.03 6.10 2.48
Total Other Costs:
$ 2,255,917
$
8.60