please answer using excel

03030 9:29 Amy's Candies makes specially designed candies. The entity has recently implemented a new marketing strategy Sales for each quarter of 2015 were as follows Sales Budget 2016 30 Jun 30 S 31 Dec -26000010%) 220.000x11-10%) -180.000 x (1 204) 200.000 (1-20%) 286.000 $250 000 Outer ending 31 March 30 ne 30 September 31 December 210,000/20 - 13.000 unit 13,000 (1.100 14300 Unit sold sales budgetint 220000 150 000 240000 Sales budget ins 24.00 520 285.000 Due to the change in sales strategy. the marketing department at Anys Candies expect sales to grow by 10 per cent in the first two quarters of 2016. und by 20 per cent in the second two quarters el 2010. The wordt sales puter will be the same as in 2015, de $20 per unit. Required Prepare a sales trudoit for 2016 03030 9:29 Amy's Candies makes specially designed candies. The entity has recently implemented a new marketing strategy Sales for each quarter of 2015 were as follows Sales Budget 2016 30 Jun 30 S 31 Dec -26000010%) 220.000x11-10%) -180.000 x (1 204) 200.000 (1-20%) 286.000 $250 000 Outer ending 31 March 30 ne 30 September 31 December 210,000/20 - 13.000 unit 13,000 (1.100 14300 Unit sold sales budgetint 220000 150 000 240000 Sales budget ins 24.00 520 285.000 Due to the change in sales strategy. the marketing department at Anys Candies expect sales to grow by 10 per cent in the first two quarters of 2016. und by 20 per cent in the second two quarters el 2010. The wordt sales puter will be the same as in 2015, de $20 per unit. Required Prepare a sales trudoit for 2016