Thompson$$ Industries' supply chain$$ manager, Xun$$ Xu$,$ wishes to better understand the quality and$$ on$-$time performance of his supply base. He suggests that$$ you, using the data provided$$ below, use Excel to create a PivotTable that displays the number of$$ suppliers, grouped by quality level$($sorted largest$-$to$-$smallest$),$ and subtotbaled by percentage of$$ on$-$time shipments$($but only for suppliers with more than $50\%$on$-$time shipments$).$ Show values as $\%$ of Column Total. What value appears in the cell for $90\%$on$-$time shipping percentage and quality level of $5?$

LOADING... Click the icon to view the Thompson$$ Industries' supplier file.

Part $2$

The value in the cell for $90\%$on$-$time shipping percentage and quality level of $5$ is

$$

enter your response here$\%($round your response to two decimal$$ places$).$