Eastern Auto Parts Inc. has forecasted the following sales for the 2^nd Quarter of 2023.

April $350,000

May $300,000

June $450,000

Past results indicate that 20% of sales are cash and 80% are on account. Credit sales are collected in installments of 30% in the month of sale, 50% in the month following the sale, and the balance during the month after. February and March 2023 Credit Sales were $200,000 and $250,000 respectively.

Prepare a Cash Collection schedule for the months of April and May of 2023.

[Show detailed calculation]