Question

Disk Productions needs to know its anticipated cash inflows for the next quarter by month. Cash sales are 10 percent of total sales each month. Historically, sales on account have been collected as follows: 60 percent in the month of sale, 30 percent in the month after the sale, and the remaining 10 percent two months after the sale. Sales for the quarter are projected as follows:

April, $120,000; May, $100,000; and June, $80,000.
Accounts receivable on March 31 were $60,000.
The expected cash collections of Discus Productions for June are _____________?

Answer 1

$89,000

Step-by-step explanation:

Expected cash collections of Discus Productions for June:

= 10% of June sales + 60% of 90% of June sales + 30% of 90% of May sales + 10% of 90% of April sales

= (0.1 × $80,000) + (0.6 × 0.9 × $80,000) + (0.3 × 0.9 × $100,000) + (0.1 × 0.9 × $120,000)

= $8,000 + $43,200 + $27,000 + $10,800

= $89,000