Important information more readable for franchisee owner

Assignment Help Operation Management

Reference no: EM13970507

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.

Reference no: EM13970507

Questions Cloud

Relatively large and active legal research firm : There are four copying center/file rooms serving a relatively large and active legal research firm. One attendant staffs each service room. The average arrival rate and service rate are the same for each room and are as follows: Arrival rate = 10.9 a..

Responsibilities of advertising from a social perspective : What are the responsibilities of advertising from a social perspective, a legal perspective, and an economic perspective? Advertising messages and product placement are increasingly featured in video games. In your view, is this unethical?

Universities refuse to enroll women during the middle ages : Why did universities refuse to enroll women during the Middle Ages?

Two forms of proactive land use policies : Two forms of 'proactive' land use policies that can be used independently or together could be____________ and ______________.

Important information more readable for franchisee owner : 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. why is that dat..

Event planning company that plans and caters social events : Ann owns an event planning company that plans and caters social events such as weddings and formal parties. She employs several event coordinators, one of whom is assigned to each event. Describe the process you would use to combine the data from all..

Describing the theme of the troubadours poetry : Although historians often rely on the term courtly love in describing the theme of the troubadours' poetry, the underlying theme of this literature is actually the ________________.

Increasing money for health care expenditures : As American continues to get more wealthy and health care more efficient, Should the US keep increasing money for health care expenditures? Why or why not?

Content from recent articles about social networking : Social Networking Research and apply the content from recent articles about social networking. Write a minimum of 3 to 5 pages for the body of the research paper discussing your viewpoint on the topic and refer to the content from the articles to sup..

User Account

All Pages