Categories
Excel

What is your recommendation concerning a single-agent system?

1. A detailed analysis of the operating characteristics of the reservation system with one agent as proposed by the vice president of administration. What is your recommendation concerning a single-agent system?
2. A detailed analysis of the operating characteristics of the reservation system based on your recommendation regarding the number of agents Regional should use.
3. A detailed analysis of the advantages or disadvantages of the expanded system. Discuss the number of waiting callers the expanded system would need to accommodate.
4. This report represents a pilot study of the reservation system for the 10:00 a.m. to 11:00 a.m. time period during which an average of one call arrives every 4.75 minutes; however, the arrival rate of incoming calls is expected to change from hour to hour. Describe how your waiting line analysis could be used to develop a ticket agent staffing plan that would enable the company to provide different levels of staffing for the ticket reservation system at different times during the day. Indicate the information that you would need to develop this staffing plan.
Please also upload an Excel file to show your analytics. In other words, you submit an Excel file and a Word file.

Categories
Excel

Demonstrate the following in maximum 3 sheet set it up as table and name it (amaa_l) use data validation for the date to be between 01/11/2020 till today

demonstrate the following in maximum 3 sheet
set it up as table and name it (Amaa_L)
use data validation for the date to be between 01/11/2020 till today
Dependent Dropdown list
UMPRODUCT
sum ifs
vlookup
filter and uniique
combo box
povt table and slicer and time line
match and index
if error
HLOOKUP
the over all style must be good
((writ the steps for each function as side note for me ))