please answer using excel format (no screenshot/image)

L0 4 I DU 922 From the following data [or ng Enterprises. calculate the receipts from accounts receivable for lure. My and August of 2016' Exercise 9.22 Cash Budget Actual Estimated April May June July Credit sales $168000 $118000 $186000 $164000 Credit sales are namally settled according to the following pattern: 60 per cent in the month following sale, and 35 per cent in the second month following the sale. Five per cult of aecom we never settled L0 3 II Ll 9.29 Amy's Candles makes specmlly designed candles. The entity has recently gem Budget 2015 314\"\" 30.1\"\" 30-52;: implemented a new marketing strategy Sales for each quarter of 2015 were as follows. =260000'l1+10%} 220,000 x {1+1096] =180.000 x [1+20%l :21\". A 285,000 Quarter ending Unit sold 260,000/20 = 3,000 unit 31 Myth 5250 000 sales budget In unit 13,000 3: (1+ 36} 30 lune 220M 1 .300 30 September 1 80 OOC_ tales budget in 5 14,300 x $20 31 December 240C\") 235,000 _ Due to the change in sales strategy, the marketing depa'trnent at Amy's Candles expect sales to grow by 10 per cent in the rst two quarters of 2016. and by 20 per cent in the second two quarters of 2016' The unit sales price will he the same as in 2015.31 3520 per unit. Due to the change in sales strategy. the marketing department at Amy's Candies expect sales to gowby lOpercent in the rst two quartersuizm. and by 20 percent in d1esecondtwo quarters at 2016. The unit sales price will be the same as in 2015' at $20 per unit. Required Prepare a sales budget for 2016