Assume you work for local business

$4.50

Assume you work for local business
(TCO 3) Assume you work for a local business person who owns 3 different fast food…

Description

Assume you work for local business

Assume you work for local business

A+ BIS 155 Final Exam

(TCO 3) 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 first sheet for tracking inventory quantity and prices for food and paper products looks something like the following:

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 using the categories mentioned above. Which fields would be placed in the report, column, row and value fields when organizing the data?

Using the revenue/sale by individual item I would consider using first column to describe the item ordered, ….

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.

(Points : 40)

The best chart to use in this case to compare the three locations graphs. The graph is encouraged in this case because….