This spreadsheet contains three tabs. The tab titled "AHW Calculator" can be used to calculate a hospital's proposed FY 2010 Average Hourly Wage (not adjusted for occupational mix) using the hospital's wage data from Worksheet S-3, Parts II and III of the Medicare cost report. This calculator includes salaries and hours for overhead contract labor (lines 9.03, 22.01, 26.01, and 27.01 of Worksheet S-3, Part II). The tab titled "Occ Mix Calculator" demonstrates how to calculate a provider's proposed occupational mix adjusted AHW for FY 2010 in accordance with CMS-1460-P. The tab titled "Inflation Factor Table" is a list of inflation factors that should be used in conjunction with the "AHW Calculator" tab to calculate a hospital's Average Hourly Wage. All text files are for 508 compliance.
|