Moorcroft sales are 40% cash and 60% credit. Credit sales are collected 20% in the month of sale, 50% in the month following sale, and 26% in the second month following sale; 4% are uncollectible. Moorcroft purchases are 50% cash and 50% on account. Purchases on account are paid 40% in the month following the purchase and 60% in the second month following the purchase. Prepare a schedule of expected collections from customers for June.

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 20% = $44,400

Collection from May's credit sales = $192,000 x 50% = $96,000

Collection from April's credit sales = $180,000 x 26% = $46,800

Total cash collections during June = $335,200