Assume you work for a local business person who owns 3 different fast food franchise locations in town. The owner would like to analyze the productivity and operations of each store individually as well as in comparison to each other. Each location is currently tracking operations in a spreadsheet which includes sheets for analyzing three key areas of interest to the owner. The owner also wants to track the following:
• Revenue/sales by product category and by individual item
• Employee data including schedules and salary expenses
Part 1: Select one of the above mentioned key areas and identify and explain what fields should be included in this analysis. Also explain HOW you would recommend organizing the data using features like Data Tables or Pivot Tables. If using Data Tables explain how you would accomplish the sorting, filtering and formatting using the fields you identify. If using a Pivot Table then explain how you would create the Pivot Table using the categories mentioned above. Which fields would be placed in the report, column, row and value fields when organizing the data?
Part 2: Using the Data Table or Pivot Table explained above, identify what type of chart you would recommend to use when comparing the 3 locations for the owner. Clearly explain WHY you are recommending that specific type of chart for the data - why is that data a good fit for that type of chart? Also include ideas for formatting this chart to make this important information more "readable" for the franchisee owner.