2) The following accounts receivable information is presented for a firm over a 180-day analysis period (6 months): Past Due % A/R Schedule (As of December 31, 2019) Month Past Due Uncollected Credit Sales Amount Status July $ 130,000 $ 16,000 > 90 Days August $ 145,000 $ 20,000 > 90 Days September $ 115,000 $ 18,000 61.90 Days October $ 120,000 $ 20,000 31 - 60 Days November $ 150,000 $ 100,000 0-30 Days December $ 175,000 $ 175,000 Current $ 835,000 $ 349,000 4.6% 5.7% 5.2% 5.7% 28.7% 50.1% 100.0% A. Construct an Aging Schedule: focus on the uncollected amount only. Your total $ amount should be equal to $349,000 and your total % should be 100% A/R Aging (As of December 31, 2019) Current 0 - 30 31-60 61.90 Month December November October September August or Older Total s % B. Calculate DSO and A/R Turnover (times) for the 180-day analysis period (assume each month has 30 days): DSO - A/R / Avg Daily Sales A/R turnover = 180/DSO