A(n) ______________________________ table contains repeating ...

[newyorker26]

A(n) ___________________ ___________ table contains repeating attributes (or fields) within each row (or record).
 Fill in the blank(s) with correct word

Question 2

(Assessment of a hospital's accounts receivable collection efficiency)
 
  Assess Plains Regional Hospital's accounts receivable collection efficiency based on the following set of facts:
 
  a. Days' revenue in patient accounts receivable at December 31, 2012, for Plains Regional Hospital - 76 days
   b. Extracts from Plains Regional Hospital's calendar year 2013 financial statements:
   Net patient accounts receivable, 16.4 million
   Net patient service revenue, 75 million
   c. Days' revenue in patient accounts receivable at December 31, 2013 for hospitals of comparable size - 65 days

[Cnarkel]

Answer to Question 1

unnormalized

Answer to Question 2

Computation of number of days' revenue in Plains Regional's patient accounts receivable at December 31, 2013:
Patient service revenue of 75 million / 365 = 205,479 revenues per day
Net patient accounts receivable (16.4 million) / revenues per day (205,479) = 80 days
Assessment: Plains Regional Hospital's number of days' revenue in patient receivables at December 31, 2013, was 80 . This is worse by 4 days over 2012 and worse by 15 days compared with hospitals of comparable size. Therefore, Plains Regional Hospital needs to devote more effort to speeding up the collection of its patient receivables.

[newyorker26]

Correct answers!

[Cnarkel]

Great! Please up vote