Chapter 2, Question 5 The Lopez brothers, Angelo, Antonio, and Isaiah, own the Lopez Cantina. Angelo is in charge of marketing, and he is developing his sales forecast for next year. Because of his marketing efforts, he predicts a 5 percent increase in his monthly guest counts. Angelo is not aware of any anticipated menu price increases and assumes therefore, that his weighted check average will remain stable. Using last year's sales and guest counts, estimate Angelo's weighted check average (average sales per guest) for the year. (Spreadsheet hint: Use the ROUND function to two decimal places on the cell containing the weighted check average, cell D18, because it will be used in another formula in part B.) Month January Sales Last Year Guest Count Last Year Check Average $45,216.00 4,800 February 48,538.00 5,120 March 50,009.00 5,006 April 45,979.00 4,960 May 49,703.00 5,140 June 48.813.00 5,300 July 55,142.00 5,621 August 59,119.00 6,002 September 55,257.00 5,780 October 50,900.00 5,341 November 54,054.00 5,460 December 50,998.00 5,400 Total B. Using the weighted check average calculated in part A, determine Angelo's projected sales, assuming a 5 percent increase in guest counts. (Spreadsheet hint: Use the ROUND function to zero decimal places in the Guest Count Forecast column, cells C23.C34. Use the SUM function for the total, cell C35. Otherwise, your answers will not be correct) Weighted Check Average Month Guest Count Last Year Guest Count Forecast Weighted Check Average Projected Sales January 4,800 February 5,120 March 5,006 April 4,960 May 5,140 June: 5,300 July 5,621 August 6,002 September 5,780 October 5,341 November 5,460 December 5,400 Total