1. Business
  2. Accounting
  3. lowing is a set of data for a small company...

Question: lowing is a set of data for a small company...

Question details

lowing 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 Feb- Mar- May- 14 Aug- Sep- 14 14 Jan-14 14 Jun-14 Jul-14 14 Dec-1 Sales Revenue Actual Actual Actual Actual Actualal Actualcal ctal Actual Actual Actual Product 1 48267 50,680 52708 55,343 57,003 56,433 56456 57,020 57,305 57,549 57,995 58,343 Product 2 10,214 10,725 | 11,15411,711 12,063 11,942 1242 12,792 13,432 13,513 13,594 13,675 Product 3 5,845 6137 6,383 6,386 6388 6324 6577 6774 6778 6782 6,788 6,829 Total Sales 64,326 | 67,542 | 70,244 | 73,440 | zsAsa | 74,699丨25-25 sez | ZZS15 | ZZ944 nventory 20,584 20,263 24 585 23,501 24,145 22410 24245 28,337 21,704 24942 25081 25.23 Supplies 3,216 4053 3,512 3,672 6,036 3.735 5,282 2.298 3,101 3,89 3919 3.942 Direct 12,865 13,508 10,537 14.688 13.582 18675 15,090 19,913 15,503 16.368 15,675 15.770 Total Cost of Goods 36,666 37,824 38,634 41,861 43,763 44,820 44517 50,547 40,308 45,207 4,675 44943 Salaries 12.879 13,179 12.879 1279 1288 12780 1245 12250 12.950 12963 12.850 12 100 Utilities 780 | 841 | 740 | 685 | 710 | 795 | 910 180 | 1,020|650 710 745 Operating Expenses Advertising 400 410 1,150 1,250 1,200 1,000 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 100 741 800 280 160 40 Total Operating Expenses 15,741 15,542 15,141 15,326 15,114 15,838 16,077 15,362 16,642 16,385 16,562 15,467 EBIT-一ㄧ 27,660 29,719 31,610 31,579|31 6ll 29,880 3a936-040 322n2-236 33702-0- 9681 10,402 11,063 11,053 11,092 10,458 10827 9,114 13,023 11,458 11,796 11,867 1,252 | 1,252 | 1,2sa l 1,252 1,252 ↓ 1,252 1,2 1,252 1,252 ncome 16,727 18,065 19,294 19,275 19.347 18,170 18856 15.674 22 933 20,022 20.654 20 286 ncome Taxes Interest 252
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution