This assignment will be practice in calculating censuses in several different scenarios. Open the attached spreadsheet and follow the instructions for BOTH tabs. Fill in your answers directly on the sheet, save it with your name in the title of the file (example: week2assignment1_oneil), and upload it to the drop box properly.
Average daily census by month, by hospital, 2009.
Hospital A Hospital B
Month Days in the month Inpatient Service Days Average Daily Census Inpatient Service Days Average Daily Census
January 467 370
February 327 280
March 436 352
April 415 404
May 398 437
June 442 489
July 468 428
August 502 475
September 485 421
October 431 361
November 385 374
December 363 302
Total
Exercise 1a
Calculate annual inpatient service days for Hospital A and for Hospital B (round to a whole number).
Exercise 1b
Calculate the monthly and annual average daily census for Hospital A and for Hospital B (round to a whole number).
***Hint: You must determine how many days there are in each month first and fill that in assume it is the year 2015
