Download this Delinquent Record Report and use the data it contains to complete the following:
Part-1: Create Delinquent Record Report Table
Using Microsoft Excel, input the data from the Delinquent Record Report. Include report, column and row titles, and the monthly data.
Use Excel to calculate and automatically insert the total number of discharges for the month.
Total discharges = total inpatient discharges + total ambulatory surgeries.
Total operations = total ambulatory surgeries + total inpatient operations.
Use Excel to calculate and insert the number of delinquent records, history and physical exam reports (H & Ps), and operative reports permitted according the Medical Staff Bylaws for each month in 20XX based on the hospital’s statistics for that month. To calculate the year’s figure, the monthly average should be used. Therefore, have a final monthly average column and use Excel to compute the averages for all rows.
Part-2: Create Line and Bar Graphs
Using Microsoft Excel, construct both line graphs and bar graphs showing the following:
The hospital’s actual delinquent records compared to the total number of delinquent records permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year)
The hospital’s actual delinquent H & Ps compared to the total number of delinquent H & Ps permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year).
The hospital’s actual delinquent ORs compared to the total number of delinquent ORs permitted by the Medical Staff Rules and Regulations for the 12 months in 20XX (do not include the total for the year).
Part-3: Write Narrative Analysis
In a Word document, provide a narrative analysis of the findings for the CEO.
Reference the table and use the graphs you prefer to illustrate compliance in the report.
Include in the analysis whether the hospital was in compliance with the Medical Staff Rules and Regulations in each of the three areas during each month of the year.
Was the hospital in compliance for the whole year?
Be sure your analysis is free of spelling and grammar errors.
Submit the following to your instructor:
Delinquent Record Report Table
Line and bar graphs
Narrative analysis of findings
DELINQUENT RECORD REPORT 20XX
ITEM JAN FEB MAR APR MAY JUN JULY AUG SEP OCT NOV DEC TOTAL
Total Inpatient Discharges 1499 1311 1297 1314 1708 1567 1736 1499 1578 1609 1588 1834
Total Ambulatory Surgeries 168 243 289 348 551 296 342 350 301 333 312 421
Total Inpatient Operations 672 888 553 540 354 468 494 416 518 437 279 599
Total Discharges 1667
Total Operations 840
Actual Delinquent Records 426 391 406 429 509 614 598 679 796 690 537 711
Actual Delinquent H & Ps 27 15 31 7 23 21 18 9 11 34 46 39
Actual Delinquent OR Reports 13 14 20 18 26 30 29 37 42 59 33 34
# of Delinquent Records
Permitted
834
# of Delinquent H&Ps Permitted 33
# of Delinquent OR Reports
Permitted
17