Please answer the question using excel

10400 922 From the following data for Wang Enterprises calculate the receipts from costevable for me. Iuly and Augnt of 2016 Exercise 922 July August Actual Estimated Cash Budget April Mary Mily Ane Auglist Credit Sales April 168090 35% 168,000 Credits $168.000 5176000 $150 000 $164000 $165 00 Credit sales May 176,000 GORK 175,000 Candies in 186.00 Total Credits are normally settled according to the following pattern per cont in the month following and 35 per cent in the cond month following the sale Fore percent of accou 35X116000 CN116.000 35185.000 L0400 922 From the following data for Wing Enterpes calculate the receipts from accounts receive for use. Why and August of 2016 Emreise 9 22 ly AI Cash Actual May My 158168.000 5166000 5176000 5164000 5166 00 Credits May BONX 125.000 Credit sales june 186,00 Total Credit sales are normally settled according to the following patient per cent in the month following sales and 35 per cent in the second month following the sale. Five per cent of 25126000 GON 186.000 35150 000