Operating data for Beach Ltd is presented here: Sales Cost of sales Selling expenses Administrative expenses Income tax expense Profit 2019 $870,000 $460,000 $93,000 $61,000 $76,800 $179,200 2020 $900,000 $520,000 $140,000 $65,000 $52,500 $122,500 Required 1. Transfer the above data to an MS Excel worksheet. 2. Within the MS Excel worksheet prepare a schedule to indicate a vertical analysis for 2019 and 2020. The base amount for performing vertical analysis is the sales amount 3. In your worksheet draw graphs for 2019 and 2020 to show how expenses are distributed in 2019 and 2020