Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Statement: Wheelnuts, the company owned by Hannah B. Kwik and her brother Otto, is a bicycle courier service delivering parcels in Edmonton and Calgary. Wheelnuts
Statement: Wheelnuts, the company owned by Hannah B. Kwik and her brother Otto, is a bicycle courier service delivering parcels in Edmonton and Calgary. Wheelnuts provides same-day delivery to downtown companies. In downtown Edmonton, Hannah takes bookings using her Bluetooth headset while on her bike or when picking up or delivering a parcel. Otto performs the same tasks in downtown Calgary. Only calls are accepted. Edmonton customers dial Hannah's local number, while Calgary customers dial Otto's. Each has a distinct number but the same plan: 12 per minute with call waiting but no voicemail. During order taking, a second call is placed on hold (also 12 per minute). Any subsequent call receives a busy signal. In each city, call arrivals follow a Poisson distribution with an average of 33 per hour. Call durations follow an exponential distribution with an average of 42.14 seconds (rate of 85.42 per hour). On average, $25 is collected per completed call. Question 1. Using the Qalculator, estimate the total hourly cost of this system (connection and blocking) for both cities (Cgy + Edm). Enter values in cells A to D, B7 & B8, and cost formulas in cells M and N. Assume a blocked call costs Wheelnuts $25. Cost: connection (M) , blocking (N), Total (O) _________ Question 2. Hannah and Otto are considering asking their younger siblings, Ada and Izzi, to take calls and send orders via SMS to Hannah or Otto, depending on the caller's location in Edmonton or Calgary. Ada and Izzi would work from the family home in Sherwood Park. Their work phone would share the same number (when one call is serviced, a new caller is routed to the other phone). Additionally, their plan would allow up to 2 calls on hold when Ada and Izzi are both on calls. After completing a call, Ada or Izzi would send an SMS with pickup and delivery information and then move to the next call on hold. The distribution of call durations + texts would remain the same (85.42 per hour), as would the cost (12 per minute per call), but any call beyond four would receive a busy signal. The package would include texting. Use the Qalculator to estimate the total hourly cost of this system (connection and blocking) for both cities combined. Enter values in cells A to D and cost formulas in cells M and N. Cost: connection (M) _________, blocking (N) _, total (O) Don't answer the questions in the statement, I'll explain: the professor provided an Excel template with macros for calculating costs. What I need from you is what to put below: Arrival rate; service rate; number of servers; Q capacity (of the queue); Unit blocking cost ($per blocked client); Unit connection cost ($per minute per connected client)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started