Headcount and Annual Revenues at BeFit Gyms (Revisited). In this problem, we revisit the data from Problem 16 on staff headcount and annual revenues for BeFit Gyms. Recall that each gym is a different size. To support larger headcounts, larger gyms are expected to generate greater annual revenue. BeFit is interested in identifying the incremental revenue a location should expect from a larger headcount. In Problem 16, a clustered column chart was used to display these data. However, we would like to make it easier for the audience to make comparisons from these data and generate insights about the relation between headcount and annual revenue. L03,4,6 a. Using the data in the file BeFit, create two different column charts to display the headcount and annual revenue data for BeFit Gyms: one chart that displays the headcount for each location and one chart that displays the annual revenue for each location. Make sure to create a meaningful chart title for each chart and create vertical-axes titles that clearly define the units of measurement. Remobe unnecessary and redundant information to increase the dataink ratio. Why might these two charts be easier for the audience to generate insights from the data than the original clustered column chart in Problem 16 ? b. Recall that the audience is most interested in identifying the incremental revenue a location should expect from a larger headcount. Create a single column chart using these data that would compare each location based on both headcount and annual revenue. (Hint: You can create a new metric for each location that measures the annual revenue per FTE.) Which location generates the greatest annual revenue per headcount? \begin{tabular}{llrrrr} & \multicolumn{1}{c}{ A } & B & C & D & E \\ 1 & Gym Location & Headcount (in FTE) & Annual Revenue (in \$1000s) & \\ 2 & Saline & 18 & 787 & \\ 3 & Tecumseh & 11 & 674 & \\ 4 & Dexter & 9 & 784 & \\ 5 & Jackson & 12 & 642 & \end{tabular}