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 May- Aug- Sep- Oct- Nov Dec- Jan-14 Feb-14 14 Apr-14 14Jun-14 Jul-14 14 14 Sales Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual 56,4s |57,02 |57,30 | S7,64 157,99 158,34 12,42 12,79 13,43 13,51 13,59 13,67 6,137 6,383 6386 6388 6,324 6,577 6,774 6,778 6,782 6,788 6,829 57,00 Product 1 48,267 50.680 52,708 55,343 3 56433 6 o Product 210.21410,725 11.154 11,711 3 11,942 Product 3 5,845 Total Sales 64,326 67,542 244 440 SA 699 452 582 515 | 944 |in | 848 24,14 28,33 21,70 24,94 25,0825,23 15,09 | 19,91 | 15,50 | 16,36 | 15,67 | 15,77 16,036 | 3.735 15,282 2,298 | 3,101 3.897 3,919 | 3,942 24,14 Inventory 20,584 20,263 24,585 23,501 5 22,4105 12,865 13,508 10,537 14,688 2 18,6750 | Supplies 3,216 Total Cost of Goods 36,666 37.824 38,634 41,861 3 43,76 44,51 s0,S4 40,30 45,20 44,67 44,94 44,820 7 Operating 12,84 12.25 12.95 12,96 12,85 12,10 Salaries 12,879 13,179 12,879 12,579 2 12,780 s 410 1,150 1,250 1,200 1,000 Utilities 780 Insurance 1,522 Repairs 160 740 6B5 710795 910 1,180 1,020 650 710 745 522 1,522 522 1,522 522 1,522 1,522 22 1,522 1,522 800 15,11 16,07 15,36 16,64 16,38 16,56 15,46 Expenses 15,741 15,542 15,141 15.326 660 610579 10,402 11,063 11,053 719 691 880 10,82 13,02 11,45 11,79 11,86 3 8 10,458 79114 1.252 122 1252 1252 1252 1252 1.252 1,252 1,252 1.252 1,252 9,681 Expense 1,252 Net