Assume you work for a local business person who owns 3 different fast food franchise locations in
Question:
• 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.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Taxes And Business Strategy A Planning Approach
ISBN: 9780132752671
5th Edition
Authors: Myron Scholes, Mark Wolfson, Merle Erickson, Michelle Hanlon
Question Posted: