please help with this problem and include formulas used. THANK YOU

References Review View 12 Styles Styles Pane Dictate Sensitivity Design Layout Mailings ' ' AO E 211 ADA E a 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 e. 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 % 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 English (United States) 18,000 3,000 21,000 45.0% 30.0% 42.0% s Focus MacBook Pro 12 ' Aa Eve 211 x x ADA E Styles Styles Dictate Pane Consider the best ana wny. To receive Tul Credi, recreate and complete in Excel not handwritten. Sensitivity 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% I 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) 4,800 9.6%