Question: Stuck at question (d) 15. The [Call Data] worksheet includes call handling information for a team in one of the sites you support. Please use


15. The [Call Data] worksheet includes call handling information for a team in one of the sites you support. Please use that spreadsheet to answer the following questions: (A) Calculate the team level AHT (Average Handle Time (B) Calculate the Interlata Sales Yield for the team (C) Calculate the Intralata Sales Yield for the team 453.00 (D) Provide a calculation to show the sum of calls handled by those agents that did not meet an AHT goal of 7min. Search the menus (Alt+ I) \begin{tabular}{llllllll} Victor & Paul & 280 & 225 & 2.32% & 2.52% & 87% \\ \hline Wall & Frank & 405 & 578 & 2.45% & 2.49% & 92% \\ Xavier & Renee & 460 & 456 & 2.56% & 2.45% & 90% \\ Young & Lisa & 310 & 321 & 2.78% & 2.36% & 85% \\ Zeeland & Oliver & 389 & 584 & 2.13% & 2.96% & 91% \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
