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 of 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 Wendy's Domino's Little Caesars KFC (Yum! Brands) Pizza Hut (Yum! Brands) Taco Bell (Yum! Brands) Burger King (RBI) McDonald's Papa John's Starbucks Subway Dunkin' (Inspire Brands) Chick-fil-A Chipotle Mexican Grill Panera Bread Arby's (Inspire Brands) $66 Jack in the Box Sonic (Inspire Brands) Popeyes (RBI) Five Guys Panda Express Dairy Queen 1997 1998 6661 2001 2003 0107 2011 2013 2014 2015 All limited-service restaur 70 66 68 69 69 70 71 71 74 76 77 77 78 78 75 79 80 80 80 77 79 79 80 79 78 78 All Others 74 75 73 74 74 72 73 74 75 78 80 79 80 83 76 81 82 82 84 81 81 82 82 82 80 80 73 71 69 73 71 70 72 74 74 75 76 78 73 76 77 77 78 79 78 73 76 76 77 77 76 73 70 68 68 70 67 69 69 73 71 69 73 75 75 71 75 75 75 77 77 77 77 81 80 75 78 78 79 79 79 80 69 70 74 75 74 77 75 75 75 78 80 82 82 80 74 81 78 77 77 76 76 68 69 67 64 64 65 63 69 71 69 70 71 70 69 75 75 75 81 74 73 78 78 77 78 79 79 71 70 75 71 76 72 76 74 78 81 78 80 82 78 77 76 80 80 77 78 66 63 71 71 68 70 66 66 67 64 64 63 68 72 70 69 70 73 74 76 77 74 72 72 75 76 74 75 74 74 68 71 70 69 71 69 74 75 75 76 76 72 76 77 76 76 76 76 66 67 65 67 68 64 66 67 65 68 63 60 60 61 61 59 62 61 76 77 78 76 64 62 76 78 63 64 69 70 67 72 73 73 71 67 69 69 69 69 70 70 79 77 76 75 80 79 83 82 82 78 82 82 80 80 78 77 77 78 77 76 78 80 76 80 76 74 75 77 78 79 78 79 82 83 78 77 80 81 80 79 79 75 79 80 75 78 80 79 78 78 79 77 86 87 87 87 86 84 83 83 78 79 79 80 80 77 2016 2017 2019 80 81 82 81 81 79 78 74 80 80 79 80 79 77 72 74 75 74 75 73 73 76 74 73 74 73 78 76 74