On the excel sheet perform the following tasks:

$1.$ Create a prioritization logic that will determine the booking queue. This is the order in which open cases are picked by the team members. Our goal here is to minimize the CancelledHeadout rate.

$2.$ Create a prioritization logic that will determine the booking queue if the goal is to

optimize for customer experience. We define customer experience by the following SLAs

for time to resolution

$1.$ Same$-$day booking $-12$ minutes.

$2.2-7$ day bookings $-25$ minutes.

$3.$ Experience date more than $7$ days ahead $-45$ minutes

$3.$ Assuming the expected booking volumes for next week are expected to be identical to

this week and you have a team of $30$ members, draft a staffing schedule to achieve the

SLAs defined under #$2$ above. Assume:

$1.$ Every team member works in $9-$hour continuous shifts.

$2.$ Every team member works for $5$ continuous day in a week.

$3.$ Shifts can overlap with each other.

$4.$ We are working with our engineering team to automate the reservation process for some of these experiences. If you had the option to get the bookings automated for $3$

experiences i$.$e$.$ there is no manual input required to send tickets to customers, which one would you choose and why?

Reading the data:

$1.$ Created Date $|$ Hour $|$ Time $-$ represent the time at which the customer made the

booking.

$2.$ Experience Date represents the date of the experience$/$activity$.$

$3.$ Ticket Tags $-$ are internal identifiers with different tags being used to power different

workflows.

$4.$ Experience ID $-$ Product booked by the customer.

$5.$ Completion Type:

$1.$ super $-$ tickets were sent;

$2.$ cancelled guest$-$ tickets were sent but later cancelled by the guest;

$3.$ cancelledHO $-$ we weren$$t able to get the tickets that the guest booked for their

desired date$/$time

$6.$ Time to assignment $-$ Time in minutes when case was assigned$/$picked by the team

member. Calculated from booking time.

$7.$ Time to first resolve $-$ Time in minutes from booking time when tickets were sent to the

customer.