Moorcroft’s assistant controller suggested that Moorcroft hire a part time collector to encourage customers to pay more promptly
and to reduce the amount of uncollectible accounts. Sales are still 40% cash and 60% credit but the assistant controller predicted that this would cause credit sales to be collected 30% in the month of the sale, 50% in the month following sale, and 18% in the second month following sale; 2% are uncollectible.Prepare a schedule of expected collections from customers for June. How did these changes impact cash collections?
1 answer:
Answer:
The budgeted sales are missing, so I looked for them. I found the following question, hopefully it will be similar:
Month Sales
April $300,000
May $320,000
June $370,000
Schedule of expected collections
For the month of June, 202x
Cash sales during June = $370,000 x 40% = $148,000
Collection from June's credit sales = $222,000 x 30% = $66,600
Collection from May's credit sales = $192,000 x 50% = $96,000
Collection from April's credit sales = $180,000 x 18% = $32,400
Total cash collections during June = $343,000
Since the cost of the part time collector is $1,000 per month, and the total uncollectible accounts reduce from 4% to 2%, which represents $7,400 for June's sales, I would recommend hiring the collector.
You might be interested in