Food and Beverage Cost Controls FC Income Statement analysis WOW ve do COMPARATIVE RESULTS OF OPERATIONS, Income statement and ratio enlysis SER Mr. Werner Schnitzel, owner, would like to know if Lucie, the manager, did a google. He had promised Lucie that he would give her a raise if she increased the profit margin by ons 1 W Lucie receive her bonus? What do you think? Click on the Excel loon below to open the table in excel Format UNIFORM SYSTEM of ACCOUNTS for RESTAURANTS Lucie's Profit & Loss Last Year This Year SALES Variance 9 C Ya c Food 26472015 84 1694 2675889 73.48% 26474 Beverage 1. 498119 15.849965660 26.5294 467543 9386 Total Sales 3145534 100.00 3641'549 100.00% 496 015 COST OF SALES: 35.77 Food 855'104 32.309 10744420 40.15% 219316 25.65 Beverage 104'00S 20.85% 115879 12.0096 15874 11425 Total Cost of Sales 959 109 30.49% 1'190299 32.69 231190 24.10% GROSS PROFIT Food 1792311 67.709 1 601 1469 59.85 -14 -10.6 Beverage 394116 279.129 549781 BOOM 455667 1156 Total Gross Profit 2186/42695124051.250 67 319 26425 12-11 OPERATING EXPENSES: Salaries and Wages 769319 24.46% 785482 21.57 16'16 2.10 Employee Benefits 1161996 3.78% 122 994 3.38% 3998 3.361 Direct Operating Expense 146 669 4.66% 145352 3.99% -1312 -0.89% Music and Entertainment 2767 0.09% 8386 0.239 5619 203.07% Marketing 52'579 1.67% 69883 1.92% 17304 32.919 Utility Services 88 555 2.82% 97836 2.69% 9281 10.489 Repairs and Maintenance 41'510 1.32% 39 135 1.079 -2375 -5.72% Administrative and General 80252 2.55% 78'269 2.159 -1983 -2.47% Total Operating Expenses 1'300'647 41.35% 1'347'347 37.00% 46'700 3.59% OPERATING PROFIT 885'778 28.16% 1'103903 30.31% 218125 24.6396 OCCUPATION COSTS: 144'000 Depreciation 4.58% 132'000 3.62% -12'000 -8.33% 104'100 3.31% Interest 93'378 2.56% -10'722 -10.30% other Occupancy Costs 49'812 1.58% 61'498 1.69% 11'686 23.46% Total Occ. Costs 297912 9.47% 286876 7.88% -3.709 -11'036 INCOME BEFORE I.T. Income Taxes 235 146 7.48% 343150 9.4296 108'004 45.93% NET INCOME 352720 11.21% 473877 13.01% 121157 34.35%