Please explain it with formulas and working.

3) Show your work (using Excel formulas is good). 4) Test must be emailed to Andy at ahickl@georgebrown.ca by 5pm today. 5) 1 decimal for %'s, no pennies just $ (except for average check). 6) If I ask for a %, do not put it in decimal form, please. 7) Print your final answers in the appropriate spaces below. 8) Read the Instructions again! Please show all your work. (Excel formulae are good) 1) What is the Prime cost % for Feb? 2) What is the Potential savings (S) for Food in Feb? 3) What is the Potential savings (S) for Beverage in Feb? 4) What is the Net Profit % for Feb? 5) What is the Rent %? answers marks 4 5 5 5 4 2 Sales Food Beverage CINTA Cost of Sales Food Beverage Salaries & Wages Rent Office & General Utilities Repairs & Maintenance Rest & Kitchen supplies Advertising Professional fees Insurance Entertainment 3 Car 30% 15500 6589 3789 3654 3298 3854 2500 1748 2000 2448 Closing Bev Inventory Feb 28 Closing Bev Inventory Jan 31 Beverage Purchases Closing Food Inventory Feb 28 Closing Food Inventory Jan 31 Food Purchases Food to Bar Bar to Kitchen Staff Meals Staff Beverages 12254 15587 10933 14654 16258 34658 1369 2654 775 852 5. Net Profit Sam 'n Ella's Diner Food Sales Mix - Feb 21 Std cost tots/cost 4 Beer Tsing Tao Stella Log Tread 7. Creemore #sold 356 498 327 922 menu $ Std cost 6 2.25 5 2 5 2 5 2.25 tot s/cost tot sales std cost % 37.5% 40.0% 40.0% 37,5% Food Fried Chicken Kebob Steak Frites Crab Cakes Meatloaf Veggie Pot Pie Turkey Club Cobb Salad Total sold 987 865 1289 1922 962 989 960 812 menu $ 11.95 9.95 15.95 15.95 12.95 11.95 9.95 9.95 3 5.4 45 3.15 4 3.2 2.95 tot sales std coat 339 30% 34% 28% 24% 33% 789 0.9 . Spirits Ram Gm Vodka Scotch 5 5 5 6 0.9 589 665 30% 18.0% 18.0% 18.0 27.5% 09 1.65 - Wine BI Chard Shiraz Cali total 98 96 123 129 25 30 35 40 10 12 14 16 40.0% 40.0% 40.0 40.ON 3) Show your work (using Excel formulas is good). 4) Test must be emailed to Andy at ahickl@georgebrown.ca by 5pm today. 5) 1 decimal for %'s, no pennies just $ (except for average check). 6) If I ask for a %, do not put it in decimal form, please. 7) Print your final answers in the appropriate spaces below. 8) Read the Instructions again! Please show all your work. (Excel formulae are good) 1) What is the Prime cost % for Feb? 2) What is the Potential savings (S) for Food in Feb? 3) What is the Potential savings (S) for Beverage in Feb? 4) What is the Net Profit % for Feb? 5) What is the Rent %? answers marks 4 5 5 5 4 2 Sales Food Beverage CINTA Cost of Sales Food Beverage Salaries & Wages Rent Office & General Utilities Repairs & Maintenance Rest & Kitchen supplies Advertising Professional fees Insurance Entertainment 3 Car 30% 15500 6589 3789 3654 3298 3854 2500 1748 2000 2448 Closing Bev Inventory Feb 28 Closing Bev Inventory Jan 31 Beverage Purchases Closing Food Inventory Feb 28 Closing Food Inventory Jan 31 Food Purchases Food to Bar Bar to Kitchen Staff Meals Staff Beverages 12254 15587 10933 14654 16258 34658 1369 2654 775 852 5. Net Profit Sam 'n Ella's Diner Food Sales Mix - Feb 21 Std cost tots/cost 4 Beer Tsing Tao Stella Log Tread 7. Creemore #sold 356 498 327 922 menu $ Std cost 6 2.25 5 2 5 2 5 2.25 tot s/cost tot sales std cost % 37.5% 40.0% 40.0% 37,5% Food Fried Chicken Kebob Steak Frites Crab Cakes Meatloaf Veggie Pot Pie Turkey Club Cobb Salad Total sold 987 865 1289 1922 962 989 960 812 menu $ 11.95 9.95 15.95 15.95 12.95 11.95 9.95 9.95 3 5.4 45 3.15 4 3.2 2.95 tot sales std coat 339 30% 34% 28% 24% 33% 789 0.9 . Spirits Ram Gm Vodka Scotch 5 5 5 6 0.9 589 665 30% 18.0% 18.0% 18.0 27.5% 09 1.65 - Wine BI Chard Shiraz Cali total 98 96 123 129 25 30 35 40 10 12 14 16 40.0% 40.0% 40.0 40.ON