Instructions: (Please read carefully) 1) Print your name and ID# at the top of this page. If not I'll email it back. 2) In order to calculate the answers, you will need to do 1 thing, a) Insert the last 4 digits of your student ID number as the number of portions of LAMB sold in the October Menu Mix - Food. 3) Show your work (using Excel formulas is good). 4) You have 4 hours to complete the test. 5) Test must be emailed to Andy by the end of class on the day of your test at ahickl@georgebrown.ca 6) 1 decimal for %'s. 7) If I ask for a %, don't give me a decimal (ie. 45% not 0.45), please. 8) No pennies please, round to the nearest dollar. 9) Print your final answers in the appropriate spaces below. 10) Read the instructions again! Please show all your work. (Excel formulae are good) ANSWERS marks 1) What is the Prime cost %? 2) What is the potential savings (S) for Food? 3) What is the Net Profit %? 4) What is the Food Cost %? 2 5) What is the Beverage Cost %? 2 2 6) What is the Labour Cost %? 2 8) What is the Rent Cost %? 9) Using the # of portions sold as the # of covers, what is the average food check? 4 6 4 3 F G H H M Sam 'n Ella's Diner Income statement ending October 2021 Sales Food Beverage 39789 11293 Cost of Sales Food Beverage 1 Salaries & Wages 3 Rent 4 Office & General 5 Utilities 16 Repairs & Maintenance 17 Rest & Kitchen supplies 18 Advertising 19 Professional fees 20 Insurance 21 Entertainment (live music) 22 Car (33%) 14500 6589 3789 3654 3298 3854 2500 1748 2000 2448 Closing Food Inventory October 31 Closing Food Inventory September 30 Food Purchases October Closing Bev Inventory October 31 Closing Bey Inventory September 30 Beverage Purchases October Kitchen (food) to Bar October Bar to kitchen October Staff Meals October Staff Beverages October 15654 17258 31658 13254 16587 13933 1598 2587 275 0 24 Net Profit 25 3 A F B D E Sam 'n Ella's Diner Food Sales Mix - October 2021 G H tot s/cost tot sales std cost % - Food Lamb 5 Pasta 6 Steak 7 Salmon 8 Meatloaf 9 Pot Pie 10 Cobb 11 Clubhouse 12 Total 13 # sold 1922 987 1289 865 962 988 960 812 menu $ 12.95 9.95 15.95 15.95 12.95 11.95 9.95 9.95 Std cost 4.5 3 5.4 4.5 3.15 4 3.2 2.95 14 15 16 17 18