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. Sales Revenue Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual 48,26 50,68 52,70 55,34 57,00 56,43 56,45 57,02 57,30 57,64 57,99 Product 1 3 0 5 58.343 10,21 10,72 11,15 11,71 12,06 11,94 12,42 12,79 13,43 13,51 13,59 Product 2 4 4 0 4 13,675 Feb-1 Mar-1 Apr-1 May-1 Aug-1 Sep-1 Oct-1 Nov-1 Jan-14 4 4 Jun-14 Jul-14 4 4 Dec-14 Product 3 5,845 6,137 6,383 6,386 6,388 6,324 6,577 6,774 6,778 6,782 6,788 6,829 $ S $ S $ 64,32 67,54 70,24 73,44 75,45 74,69 75,45 76,58 77,51 77,94 78,37 S Total Sales 6 2 4 4 9 7 5 4 7 78,848 Direct 27,31 28.12 Expenses 7 edmentum 2015 EDMENTUM, INC.20,58 20,26 24,58 23,50 24,14 22,41 24,14 28,33 21,70 24,94 25,08 Inventory 25,231 12,86 13,50 10,53 14,68 13,58 18,67 15,09 19,91 15,50 16,36 15,67 Labor 5 15,770 Supplies 3.216 4.053 3.512 3,672 6.036 3.735 5.287 2.298 3.101 3.897 3919 3.942 Total Cost 36,66 37,82 38,63 41,86 43,76 44,82 44,51 50,54 40,30 45,20 44,67 of Goods 44,943 Operating Expenses 12,87 13,17 12,87 12,57 12,88 12,78 12,84 12,25 12,95 12,96 12,85 Salaries 12,100 Advertisin 400 500 410 1,150 1,250 1,200 1,000 Utilities 780 841 740 685 710 795 910 1,180 1,020 650 710 745 Insurance 1,522 1,522 1,522 1,522 1.522 1,522 1,522 1,522 1,522 1,522 1,522 1,522 Repairs 160 40 741 800 280 100 Tota Operating 15,74 15,54 15,14 15,32 15,11 15,83 16,07 15,36 16,64 16,38 16,56 Expenses 15,467 S 5 5 5 S 5 S 27.66 29.71 31.61 31.57 31,69 29.88 30.93 26.04 37.20 32. 73 33,70 S BIT 33,904 Income 10,40 11,06 11,05 11,09 10,45 10,82 13,02 11,45 11,79 Taxes 9.681 3 9,114 11,867 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 S $ S S S S S S S S S Net 16,72 18,06 19,29 19,27 19,34 18,17 18,85 15,67 22,93 20,02 20,65 S Income 5 4 0 6 4 3 4 20,786 Type your response here