B Exercise 1.1 D 5 E F G H 6 Complete the Income Statement by inserting the following figures in the appropriate place, 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Food Sales Beverage Sales Food Cost Beverage Cost Salaries & Wages Employee Benefits Other Controllable Expenses Occupancy Costs Interest Deprecation $ S $ $ $ $ 1,230,964.00 485,200.00 402,337.00 112,344.00 406,541.00 109,135.00 295,330.00 90,000.00 35,600.00 89,900.00 S $ S S Exercise 1.2 21 22 23 24 Calculate Food Cost % and Labour Cost % Exercise 1.3 25 26 27 28 Calculate overhead as a % of total sales. Exercise 1.4 29 30 31 32 Calculate prime cost as a % of total costs. When completed add the cost% for prime cost, overhead costs and profit to arrive at 100%. Instruction Sheet Exercise 1.1 Exercise 1.2 Exercise 1.3 Exercise 1.4 B D E F G $ Food Beverage 112,344.00 $ 406,541.00 Total COGS Gross Profit $ $ 518,885.00 1,197,279.00 S 295,330.00 $ Controllable Expenses Salaries & Wages Employee Benefits Other Controllable Expenses Total Controllable Expenses Income Before Occupancy Costs 90,000.00 89,900.00 $ $ 475,230.00 722,049.00 $ Interest, Depreciation and Income Taxes Occupancy Costs #REFI Interest AREFI Depreciation #REFI Total HREFI Restaurant Profit/Loss HREF! Exercise 14 A B D E G H K 5 Food Cost % Food Cost - x 100% 6 Food Sales 7 00 Food Cost % x 100% 9 10 11 12 . 13 Calculation of Beverage Cost Percent 14 15 Beverage Cost % * 100% 16 17 18 Beverage Cost % * 100% 19 20 21 22 23 Calculation of Labour Cost 24 25 Salaries & Wages Instruction Sheet Beverage Cost% 11 x 100% Beverage Cost % = x 100% = Calculation of Labour Cost Salaries & Wages Employee Benefits Calculation of Labour Cost Percent Labour Cost Labour Cost% * 100% Total Sales C B 1 Exercise 1.3 2 3 Calculation of Overhead Costs 4 Other Controllable Expenses 5 Occupancy Costs 6 Interest 7 Depreciation 8 Total Overhead Costs 9 10 Calculation of Overhead Cost Percent 11 12 Overhead Cost Percent 13 14 15 Overhead Cost Percent 16 17 18 19 20 21 Total Overhead Costs Total Sales x 100% x 100% 1 Exercise 1.4 2 3 Calculation of Prime Cost 4 5 6 7 Total Cost of F&B Labour Cost Prime Cost + 8 Calculation of Prime Cost Percent Prime Cost Percent Prime Cost Total Sales x 100% Prime Cost Percent x 100% 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Calculation of Profit Percent Profit Total Sales x 100% Profit Percent Profit Percent x 100% Calculation of Prime Cost Percent Prime Cost Percent Prime Cost Total Sales x 100% Prime Cost Percent x 100% Calculation of Profit Percent 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 Profit Percent Profit Total Sales x 100% Profit Percent X 100% Calculation of Total Cost Percents Prime Cost% Overhead Cost % Profit % Total