You are working for a popular sports restaurant that has five branches. Your boss has asked you to plan a worksheet to show results for drinks,...

You are working for a popular sports restaurant that has five branches. Your boss has asked you to plan a worksheet to show results for drinks, meals, games, and souvenir sales. You are not creating the worksheet at this time. Using estimates, you will create the worksheet for Sports & You. You decide to add totals and averages. You also want to include a chart to compare your revenues.

What steps would you use to create the estimates? Based on your knowledge of restaurants, do you think seasonal sales would be different, and if so, why? How could you chart the information to show the comparisons? Which chart would be the best to use?