Complete the lab and submit the attached MS Excel Data sheet with your solutions. Answer the questions with a short narrative and submit on an MS Word document. Use CHF data for this lab The CFO at General Hospital noticed that the losses for Medicare CHF patients were becoming larger each year. In order to understand why this is occurring, he assigned a data analyst to review the issue. The analyst requested a file including the following billing information for each case in grouping to one of the CHF MS-DRGs (291, 292, 293): the analyst immediately notices that the data documentation or dictionary supplied with the data does not include some critical elements. The first step in the analysis will be finding the coded values for the following variables: age category, gender, admission source, discharge destination. The analyst knows that the IT department follows the standard UB-04 codes for admission source and discharge destination and the CMS MedPAR standard for patient gender and age categories. The goal of the study is to answer the following questions: 1. What is the typical loss per CHF patient? Assume that the cost to charge ratio (CCR) for General Hospital is 0.3 for ancillary departments and 0.5 for accommodation departments.A) Instructions for calculating profit: i)Profit/loss ＝ amtreim – cost I) Cost may be estimated by taking the charge times the CCR III) Create a column (M) called Cost ＝ ＝F2*.5+G2*.3 (where column F is accommodation charges and column G is ancillary or departmental charges) IV) Copy this column to all rows V) Create a column (N) called Profit ＝ amtreim – cost VI) Copy this column to all rows Does 2)General Hospital have any profitable CHF patients? If so, can you describe those patients? 3)How does the mix of no CC/CC/MCC patients compare to the national mix from the HCUP database? How might that impact the profitability of the CHS patients?
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|