Assignment Instructions

Download thisDelinquent Record Reportand 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.

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 388 553 540 354 468 494 416 518 437 279 599 Total Discharges 1667 Total Operations 340 Actual Delinquent Records 426 39 406 429 509 614 598 679 796 590 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 834 Permitted # of Delinquent H&Ps Permitted 33 # of Delinquent OR Reports 17 Permitted