I Header Foter Page Text Box WordA Number s, and improvements, choose Check for Updates. Type your response here: Calculation of expenses as % of total sales Jan- Feb- Mar- Apr- 1Ma Jun- Jul- Aug- Sept Oct- Nov-Deo- 14 14 14 14 y-14 14 14 14 -14 1414 14 actu actu actu actu actu actu Sales actu actu actu actu actu Revenu al a ala Inventor 32 30 35 32 32 30 32 37 28 32 32 32 Supplies 5 6 5 5 857 3 4 5 55 COGS 57 56 55 57 58 60 59 66 52 58 57 57 Operatin expense Salaries 20.0 19.5 18.3 17.1 17.0 17.1 17.0 15.9 16.7 16.6 16.4 15.3 Advertisi 0.62 0 0 00 0 0 0.54 1.48 1.6 1.53 1.27 Utilities 1.21 1.25 1.05 0.93 0.94 1.06 1.21 1.54 1.31 0.83 0.900/9 2 Insuranc 2.37 2.25 2.17 2.07 2.02 2.04 2.02 199 1.96 1.95 1.94 1.93 Repairs .25 000.05 0% 0.99 1.06190 00.36 13 24.4 23.0 21.5 20.8 20.0 21.2 21.3 20.0 21.5 21 21 19.6 TOE Income- 15.0 15.4 15.7 15.0 14.7 14% 14.3 11.9 16.8 14.7 T15- 15 Interest 1.95 1.85 1.78 1.70 1.66 1.68 1.66 1.63 1.61 1.6 1.601.59 7 taxes 5 0 5 5o 5 0 expense Usiig the data above, determine which expenses relate to sales and which ones do not. Use this dge to do the following: in 400 words, explain how you might use this information to budget expenses for the next year Mar- 14 Apr-14 Aug Sep-Oct Nov Dec- Jan-14 Feb-14 14 Jun-14 Jul-14 14 14 14 Actuai Atu Acua Actu Actuat Actut nctut Actul ctutl Atual Actul Actul 57,00 56,45 57,02 5730 57,64 57,99 58,34 Product 1 48267 50,680 52708 55,3433 56,433 6 12,42 12,79 13,43 13,51 13,59 13,67 12,06 Product 2 10,214 10,72511,154 11,711 3 11,9420 Product 3 5,845 6,1376,3836,386 6,388 6,324 6,577 6,774 6,778 6,782 6,788 6,829 Total Sales 64326 67.542 244 44 454 699 Direct 452 S8 515944 3 848 Expenses 24,14 22.410 5 13,58 24,14 28,33 21,70 24,94 25,08 25,23 Invento 20,58420,263 24,585 23,501 5 15,09 19,91 15,s0 16,3615,67 15,77 Labor 12,86513,508 10,3 4,688 218,675 o3 3 8 5lo 18,675 0 3,216 4,0533,5123,672 6,036 3,735S 2,298 3,1013,8973,919 3,942 43,76 Total Cost of Goods 36,66637,824 38,634 41,861 3 Operating Expenses 44,51 50,54 40,30 45,20 44,67 44,94 44,820 7 12,88 12,84 12,25 12,95 12,96 12,85 12,10 12,879 13,179 12,879 12,579 2,7805 400 500 410 1,150 1,250 1,200 1,000 841 685 910 1,180 1,020 60710 745 740 710 795 1,522 1522 1,522 1,522 1,522 21,522 1,522 1,522 Insurance 1,522 160 40 741 800 280 100 Total Operating Expenses 15,741 15,11 16,07 15,36 16,64 16,38 16,56 15,46 15,542 15,141 15,326 4 15.838 7 EBIT 719 610 579 691 880 11,09 10,82 13,02 1145 11, 79 11,86 10,458 7 9,114 Taxes 10,402 11,063 11,053 2 252 252 252 1,252 1,252 252 1,252 Prepariig 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 s)