Question: Please, solving question step by step. An average of 40 patients per hour arrive at an emergency department. The average patient occupies a resource (say,

Please, solving question step by step.

Please, solving question step by step. An averagePlease, solving question step by step. An average

Please, solving question step by step. An average

An average of 40 patients per hour arrive at an emergency department. The average patient occupies a resource (say, a nurse) for 10 minutes. Assume exponential interarrival and service times. Use the following M/M/s Excel templates to answer the questions: Data Results = 40 (mean arrival rate) L = 23.88939328 = 6 (mean service rate) Lg 17.22272661 S = 7 (# servers) W = 0.597234832 Pr(Wt) = 0.916851 Wq = 0.430568165 when t = 0.083 p= 0.952380952 Prob(W t) = 0.729422 when t = 0.083 n Pn 0 0.00035312 1 0.002354131 2 0.007847105 3 0.017438011 4 0.029063351 5 0.038751135 Data 40 6 Results = L = 9.330099553 L2.663432886 = S= 8 W = 0.233252489 Wa=0.066585822 Pr(W) 0.756296 when t = 0.083 p=0.833333333 Prob(Wat) = 0.274221 when t = 0.083 n P 0 0.000917426 1 0.006116174 2 0.020387247 3 0.045304993 4 0.075508322 5 0.100677763 Data = 40 Results L = 7.561682847 0.89501618 = 6 S= 9 W = 0.189042071 Pr(W>t)= 0.677026 Wa 0.022375405 when t = 0.083 p= 0.740740741 Prob(W>t)= 0.098005 when t = 0.083 n P 0 0.001132968 1 0.007553119 2 0.025177062 30.055949028 4 0.09324838 0.124331173 Data Results 40 L = 7.015830514 La 0.349163847 = 6 S= 10 W = 0.175395763 Wa 0.008729096 Pr(W) 0.638991 when t = 0.083 p=0.666666667 Prob(Wat) 0.033195 when t = 0.083 n P 0 0.001217737 1 0.008118249 2 0.027060831 0.06013518 0.1002253 0.133633734 a) If we want the average time a patient waits for a resource to be at most 3 minutes, how many resources should the department have? Indicate how you used the template to arrive at this decision. (mean arrival rate) (mean service rate) (# servers) (mean arrival rate) (mean service rate) (# servers) (mean arrival rate) (mean service rate) (# servers) b) Suppose each resource costs the department $4 per hour and each hour a patient spends in the department costs $1. What is the optimal number of resources that minimizes total expected cost per hour

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!