Answered step by step
Verified Expert Solution
Link Copied!

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). For scenario 1, if I have, for example, $83 as the total cost, would my final answer be $83 or double that

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Detecting Accounting Fraud Analysis And Ethics

Authors: Cecil W. Jackson

1st Edition

1292059400, 9781292059402

More Books

Students also viewed these Accounting questions