You have recently been hired by Five Guys (burgers and fries) to assess the competitive landscape in the quick service restaurant industry. The American Customer Satisfaction Index (ACSI) tracks customer satisfaction with many brands across many industries. Data from the ACSI from 1995 to 2021 (excluding 2004 due to unavailability) for Limited-Service Restaurants is provided here. Limited-Service Restaurants represents the total salinification all restaurants; All Others represents all non-limited-service restaurants.

Instructions

There are two parts to this problem. Use Excel to perform the following.

a. Create a combo chart to help you visualize the data. Chart Limited-Service Restaurants and All Others on separate lines. Use clustered columns to chart each of the burger organizations. Include a chart legend, appropriate chart title, and axes labels.

b. Use the chart you created in part a to describe Five Guys positioning in the burger industry. Describe any trends you see in burger organizations as compared to Limited-Service Restaurants.

ACSI Customer Satisfaction data for Limited-Service Restaurants over time ACSI Customer Satisfaction data for Limited-Service Restaurants over time