Please show all your work. (Excel formulae are good) 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? 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 %? 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 560001 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 Please show all your work. (Excel formulae are good) 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? 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 %? 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 560001 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