The Northwest regional manager of an outdoor equipment retailer conducted a study to determine how managers at three store locations are using their time. A summary of the results are shown in the following table. Percentage of Manager's Work Week Spent on Store Location Meetings Reports Customers Idle Bend 18 11 52 19 Portland 52 11 24 13 Seattle 32 17 37 14 (a) Create a stacked bar chart with store location on the horizontal axis and percentage of time spent on each task on the vertical axis. 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% Bend Portland Seattle 100% 90% 80% 70% 60% 100% 90% 80% 70% Idle 60% Customers 50% Reports 40% Meetings 30% 20% 10% 0% Bend Portland Seattle Idle Customers 100% 90% 80% 70% Idle 60% Customers 50% Reports 40% Meetings 30% 20% 10% 0% Bend Portland Seattle Idle Cus Rep Me