-The Lopez brothers, Angelo, Antonio, and Isaiah, own the Lopez Cantina. Angelo is in charge of...

Transcribed Image Text:

-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. A. 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 Sales Last Year Guest Count Last Year Check Average January February March April May June July August September October November December Total $45,216 48,538 50,000 45.979 49.703 48,813 55.142 59,119 55.257 50,900 54.054 50,998 4.800 5,120 5,006 4.960 5.140 5.300 5,621 6,002 5.780 5.341 5.460 5.400 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.) Month Guest Count Last Year Guest Count Forecast Weighted Check Average Projected Sales January February March April May June July August September October November - December Total 4,800 5,120 5,006 4.960 5,140 5.300 5,621 6,002 5.780 5.341 5,460 5,400 -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. A. 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 Sales Last Year Guest Count Last Year Check Average January February March April May June July August September October November December Total $45,216 48,538 50,000 45.979 49.703 48,813 55.142 59,119 55.257 50,900 54.054 50,998 4.800 5,120 5,006 4.960 5.140 5.300 5,621 6,002 5.780 5.341 5.460 5.400 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.) Month Guest Count Last Year Guest Count Forecast Weighted Check Average Projected Sales January February March April May June July August September October November - December Total 4,800 5,120 5,006 4.960 5,140 5.300 5,621 6,002 5.780 5.341 5,460 5,400

Answer rating: 100% (QA)

Weighted Ch... View the full answer