please use excel to create a chart following given tables

3. Parkers Car Restoration expects the following sales for March, April, and May. The controller has determined that the company collects credit sales in the following pattern: collects cash at the time of sale from 30% of customers. Of the remaining sales, 50% are collected in the month following the sale, and 10% are uncollectible. The sales budget for the first seven months of the year is as follows