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 bud proposed for the current month and advise the of which alternative you consider the best and why. To receive full credit must be in Excel not handwritten. Current Month Option 1 Option 2 Revenue: Food Beverage Total Revenue 40,000 10,000 50,000 80% 20% 100% Cost of Sales Food Beverage Total Cost of Sales 18,000 3,000 21,000 45% 30% 42% Gross Profit 29,000 58% Total Payroll 13,600 27% 4,000 Other Expenses Operating Supplies Administrative & General Advertising Repairs & Maintenance Utilities Total Other Expenses 2,600 1,800 900 1,300 10,600 8% 5% 4% 2% 3% 21% Net Income/(Loss) 4,800 10%