Please show all calculations and formulas.If using Excel, please show data, formulas, etc.

Practice example 12:

Dewey's expects sales of $530, $560, $740, and $790 for the months of April through July, respectively. The firm collects 23 percent of sales in the month of sale, 51 percent in the month following the month of sale, and 24 percent in the second month following the month of sale. The remaining 2 percent of sales is never collected. How much money does the firm expect to collect in the month of July?