The following table is a report of the first quarter

The following table is a report of the first quarter of 20XX (January through March) from a 400-bed medical center regarding its insurance categories. In this example, deaths are included in discharges. Round all to one decimal place. This is a non-leap year. Create an Excel spreadsheet to complete the table and use the results to answer questions 4, 5, and 6. Community Medical Center Inpatient Service Days and Number of Discharges by Insurance Category January-March 20XX Insurance Category Inpatient Service Days Number of Discharges Occupancy Rate Bed Turnover Rate (Direct Formula) Average Daily Inpatient Census Third-party contracts  5,849   598 Medicare  9,427 1,450 Medicaid 13,604 2,011 No insurance  2,598   480 Total  4.Calculate the occupancy rate for the following: a.Total b.Medicare c.Third-party contracts  5.Use the direct formula to calculate the bed turnover rate for the following: a.Total b.Medicare c.Third-party contracts  6.What is the total average daily inpatient census for this period of time?

******CLICK ORDER NOW BELOW AND OUR WRITERS WILL WRITE AN ANSWER TO THIS ASSIGNMENT OR ANY OTHER ASSIGNMENT, DISCUSSION, ESSAY, HOMEWORK OR QUESTION YOU MAY HAVE. OUR PAPERS ARE PLAGIARISM FREE*******."