Directions and Analysis Task 1: Analyzing Data Following is a set of data for a small company Using this data analyze the expenses . Using the functions in the spreadsheet calculate the monthly average for each expense for the year Using the calculations, calculate the percentage of each expenses to the total sales Pele War 14 14.14 Hun 14 14 10:14 Dec Sa A Actual AC Art Actu Act A Actu 18 262 02.05.147.000 44.45 70200 ST 45 10,21410.72511.11.11 13.0611,42 12.420 13.732124213.30 13.525 Products S84 637 6.186 134 6.527 SYM 6.77 A3 SA 5 $ $ S Total 43 M2 70.44 73.440 7.454 74,099 75,452 71.387 17.15 11.7.14 5 Direct Inventory 20.5420.263 4.585 22.501 24,145.22.410 2445 20.371.70 249425.00 25.235 12,5 13,50 10,5 14.5 15.67515.000 19.919 15.0 15.0 15.67515.770 3.897 5,036 3.101 2.919 3.942 3.7355.2822,298 4.053 3.512 3.216 3,672 Supplies Total Cost of Goods 36,666 37.824 18,634 41.361 43.763 44.320 46,517 50.547 40,700 45,207 44,675 44.943 Operating Expenses Salaries 12,829.11.129 12.379 12.579 12882 1270 12 845 12.250 12.950 12.963 12.850 12.100 410 1,150 500 1,200 1.250 1,000 Advertising 400 780 841 745 740 685 710 795 710 1,180 Utilities 910 1,020 650 1.522 1.522 1.522 1.522 1522 1.522 1.522 2.522 1.522 Insurance 1.522 1.522 741 800 40 280 100 Repairs 160 Total Operating Expenses 15.741 15,542 15.141 15.126 15,11415,838 16,077 15,362 16,642 16,385 16,562 15 467 FAIT 5 5 $ $ $ $ 5 $ $ $ $ $ 27.660 29.719 31,610 31,579 31.491 29,880 30,936 26.040 22,207 32,736 33,702 33.904 9,681 10,402 11,063 11053 11.092 10,458 10.827 9,114 13,023 11,458 11,296 11,867 Income Taxes Interest Expense -1,252 1.252 1,252 1,252 1.252 1.252 1.252 1.252 1.252 1.252 1.252 1,252 Net Income $ $ $ 5 $ $ $ $ $ $ 5 $ 16,727 18.065 19.294 19,275 19,347 18,170 18,856 15,674 22,933 20,027 20,654 20,786 Type your response here: Task 2: Preparing a Budget Using the data above, determine which expenses relate to sales and which ones do not. Use this knowledge to do the following: in 400 words, explain how you might use this information to budget expenses for the next year Type your response here