Question

Joy Manufacturing Company needs to know its anticipated cash inflows for the next quarter by month. Cash sales are 25 percent of total sales each month. Historically, sales on account have been collected as follows: 50 percent in the month of the sale, 30 percent in the month after the sale, and the remaining 20 percent two months after the sale.

Gross sales for the quarter are projected as follows:
January $20,000
February $10,000
March $40,000
Accounts receivable on December 31 were $30,000.
Joy's expected cash collections for March would be:________.
A. $37,000
B. $32,000
C. $30,250
D. $47,200

Answer 1

Total cash collection= $30,250

Step-by-step explanation:

Giving the following information:

Cash sales are 25 percent of total sales each month.

Sales on account:

50 percent in the month of the sale

30 percent in the month after the sale

20 percent two months after the sale.

Sales:

January $20,000

February $10,000

March $40,000

We need to calculate the cash collection for March:

Sales on cash March= 40,000*0.25= 10,000

Sales on account March= (40,000*0.75)*0.5= 15,000

Sales on account February= (10,000*0.75)*0.3= 2,250

Sales on account January= (20,000*0.75)*0.2= 3,000

Total cash collection= $30,250