Create a Pivot Table on a new sheet to the right of Profitability called "Rental and Ratio" $($no quotes$).$ The pivot table should show the name of every region and a KPI that you calculate. Create a KPI that considers the price of avocados in a region and the price of rental housing in that region. Ensure that some of the regions score high $($a green light$)$ and that others do not $($yellow and red$).$ Your column with the KPI should be titles "KPI". Below the pivot table, explain what your KPI is$,$ how it is calculated, and what exactly it means to someone looking at your KPI $-$ explain the value of this KPI.

Create a forecast sheet that predicts overall volume of sales. You will need to sum the total volume of avocados per date before creating this sheet. Create a new sheet to the right of Ratic and Rental called $"4$cast" $($no quotes$).$ Create your table for the forecast worksheet on the $4$cas sheet. Set the forecast worksheet to end the forecast on $6/1/2022.$ Rename the new forecast worksheet to "Forecast" $($no quotes$)$ and move it to the right of $4$cast. Add an Exponential trendline based on the forecast to your forecast chart. In cell G$1,$ state how much the differenc is between the forecasted volume of $\frac{6}{1}\frac{?}{2022}$ and $5/31/2017.$ For example: $"\frac{6}{1}\frac{?}{2022}$ is fprecasted to have a $200,000$ ounces greater volume than $\frac{5}{31}\frac{?}{2017}".$