Acct- expected cash collections.

I need the answer to Exercise 7-1 Part 1

Exercise 7-1 Schedule of Expected Cash Collections [LO2) The tolowing information applies to the questions aisplayed below Mowest products iswholesase ostroutor of lear rakes. Thus, peak tales occur n August or eacn year as shown in the company's saies budget for the third quarter, given below 9iven below August SeptemberTotal Juty s600,000 $ 900,000 $500,000 2.000,000 Budgeted sales (all on account From past experience, te company has learned at 20% saie, another 70% are collected in the mom, second month folowing sale. Bad debts are negligible and can be ignored. May sales totaled $430,000, and June salies totaied $540,000 or a morms sales are collected in the month of are collected in the month following sale, and the remaining 10% are collected in the Section Break Exercise 7-1 Schedule of Expected Cash Collections [LO2] Award 2.50 points Exercise 7-1 Part 1 a schedule of expected cash collections from sales, by month and in total, for the third quarter (Do not round intermediate calculations. Leave no cells blank be certain to enter "0" wherever required. ) Schedule of Expected Cash Collections August September Total May sales June sales July sales August sales September sales Total cash collections Hints