Please help and please provide the formulas that you used to get the answer! Thank you for all your help!!

Design La Problem No2 Mailings Review View Tolme En. 331 Sina Aav A CON ALCOAaBb C 31 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 200 d. Repairs 300 c. Energy Costs 100 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 Current Month X Option 1 Option 2 MacBook Air 20 48 A $ 4 % 5 3 & 7 * 8 1 0 2 6 9 dele Q W C E R Y 1 0 P 1 A S D G H L ? C V B N M N A. V - of 76 option command command option Problem 2 Bran Design Layout Maling Rere Share Three De AaBb. 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% 2129 Net Income/(Loss) English States 4,80 9.6% To MacBook Air 94 3 73 FT 11 SM A * # 3 2 $ 4 % 5 6 & 7 8 9 Il + 0 W E R T Y U 1 o S DF G H J L