Id is 922

Puctions Income Statement HOST 1150 - Mid Term 1 - F 2021 NAME: ID#: 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 I thing: a) Insert the last 3 digits of your student ID number as the last 3 digits of the Food Sales on the income statement 3) Show your work (using Excel formulas is good). 4) You have till till 5pm today to complete the test. 5) Test must be emailed to Andy by 5pm (Toronto time) today at ahickla georgebrown.ca 6) 1 decimal for%'s. 7) No pennies, round to the nearest S 8) If I ask for a %, don't give me a decimal, please. 9) Print your final answers in the appropriate spaces below. 10) Read the Instructions again! Please show all your work. (Excel formulae are good) marks 1) What is the Break Even for September? 2) What is the Prime Cost%? 3) What are the sales required to make $100,000 in profit? 5 4) What is the Net Profit %? 5) What is the Food Cost%? 6) What is the Beverage Cost %? 7) What is the Labour Cost %? 8) What is the Rent Cost %? answers 6 4 2 2 2 2 2 25 Instructions Income Statement Sam 'n Ella's Diner September 30, 2021 Sales 124 Food Sales Bev Sales 49.000 Cost of Sales Food Cost Bev Cost 42,500 15,200 57.700 Labour (25% FC) 56000 56000 Rent Office & General Utilities Repairs & Maintenance Rest & Kitchen supplies Advertising Insurance Automobile Other OH 16000 4800 3800 3150 3050 3850 4200 1800 1400 42050 Profit