Required:

Compute the estimated total cash collections during October from credit sales.

Compute the estimated total cash collections during the fourth quarter from sales made on account

during the fourth quarter.

Build a spreadsheet: Construct an Excel spreadsheet to solve both of the preceding requirements.

Show how the solution will change if the following information changes: sales in June and July

were $$50,000$ and $$65,000,$ respectively.