Coyote Loco, Inc, a distributor of salsa, has the following historical collection pattern for its credit sales.

70% collected in the month of sale

15% collected in the first month after sale

10% collected in the second month after sale

4% collected in the third month after sale

1% uncollectable

The sales on account have been budgeted for the last seven months as follows

June - $49,000

July - $60,000

August - $70,000

September - $80,000

October - $90,000

November - $100,000

December - $85,000

1. estimated total cash collections during October from credit sales

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

3.in excel spreadsheet to, how would the solutions change if the following information changes; sales in June - $50,000 and July $65,000.