In: Finance
Route Canal Shipping Company has the following schedule for aging of accounts receivable:
| 
 Age of Receivables  | 
|||||
| (1) | (2) | (3) | (4) | ||
| 
Month of Sales  | 
Age of Account  | 
Amounts | 
Percent of Amount Due  | 
||
| April | 0–30 | $ | 189,000 | _______ | |
| March | 31–60 | 135,000 | _______ | ||
| February | 61–90 | 162,000 | _______ | ||
| January | 91–120 | 54,000 | _______ | ||
| Total receivables | $ | 540,000 | 100% | ||
a. Calculate the percentage of amount due for
each month.
b. If the firm had $1,620,000 in credit sales
over the four-month period, compute the average collection period.
Average daily credit sales should be based on a 120-day
period.
c. If the firm likes to see its bills collected
in 45 days, should it be satisfied with the average collection
period?
d. Disregarding your answer to part c and
considering the aging schedule for accounts receivable, should the
company be satisfied?