Foster Pharmaceuticals updated its Forecast Receivable Collection Pattern.

Customer

0-30 days

31-60 days

61-90 days

91-120 days

Large Retail Chain 1

35%

45%

10%

10%

Large Retail Chain 2

20%

30%

35%

15%

Regional Drug Store

20%

35%

35%

10%

Small Grocery Chain

30%

55%

10%

5%

There is no other update.

Question 1-1. (6 points) Provide the updated Average Collection Period. Please show your all works using Excel.

Question 1-2. (7 points) Provide the updated Aging Schedules of the end of May. Please show your all works using Excel.

Question 1-3. (7 points) Provide the updated Uncollected Balances Schedules of the end of April. Please show your all works using Excel.

[End]