Please help!!

Fleto View SEND Wed 216 PMMQ Insert Format Toote Window Help ABO La References Malings Problem s 2 red Share Com Times Ne. --AA A- AaBbd des EXTRA CREDIT (WORTH 2 POINTS) A stand-alone restaurant's is currently looking and improving its profitability and has two options: Option 1: By improving purchasing and reducing portions, cutting the food cost from 45% to 40% of food sales revenue. There would be no other changes. Option 2: Cutting the food costs from 45% to 40% of food sales revenue and spending an additional $2,000 a month on advertising. It is estimated that the advertising would bring in extra customers and increase the volume of both food and beverage revenue by 20% over present levels. The extra customers would also incur extra costs over present levels as follows: a. Wages - $2,000 b. Supplies - 800 c. Administration d. Repairs 300 e. Energy Costs Recreate the schedule below in Excel and prepare how both alternatives compare to the budgeted proposed for the current month and advise the owner of which alternative you consider the best and why. To receive full credit, recreate and complete in Excel not handwritten 1 200 100 MacBook All 80 188 >> A 2 3 $ 4 % 5 & 7 6 8 9 0 W E R T Y U O P S D F H K L Sare ABU Den Design Problem No. 2 Malings Review view Time Layout Share Time - 12 - AA A KAD AaBb. 19 Current Month % Option 1 % Option 2 % Revenue Food Beverage Total Revenue 40,000 10,000 50,000 80.0% 20.0% 100.0% Cost of Sales Food Beverage Total Cost of Sales 18,000 3,000 21,000 45.0% 30.0% 42.0% Gross Profit 29,000 58.0% Total Payroll 13,600 27.2% Other Expenses Operating Supplies Administrative & General Advertising Repairs & Maintenance Utilities Total Other Expenses 4,000 2,600 1,800 900 1,300 10,600 8.0% 5.2% 3.6% 1.8% 2.6% 21.2% Net Income loss) 10 words English (United States 4800 303 MacBook Air # 3 $ 4 2 & 7 5 6 8 9 0 W E R T Y o S D F G H K 2