Question

Budgeted sales in Acer Corporation over the next four months are given below: September October November December Budgeted sales $120,000 $140,000 $180,000 $160,000 Thirty percent of the company's sales are for cash and 70% are on account. Collections for sales on account follow a stable pattern as follows: 50% of a month's credit sales are collected in the month of sale, 30% are collected in the month following sale, and 20% are collected in the second month following sale. Given these data, cash collections for December should be_____________.
a. $118,700
b. $100,500
c. $161,400
d. $141,800

Answer 1

Answer:

c. $161,400

Explanation:

The computation of the cash collections for December month is shown below:

Cash sales

= $160,000 × 30%

= $48,000

Credit sales

For same month  = $160,000 × 50% × 70% = $56,000

For one month = $180,000 × 30% × 70% = $37,800

For second month = $140,000 × 20% × 70% = $19,600

So, the total cash collections is

= $48,000 + $56,000 + $37,800 + $19,600

= $161,400