Question

Q2) An average of 10 people per hour arrive (with exponential inter-arrival times) intending to swim laps at the local YMCA. Each intends to swim an average of 30 minutes. The YMCA has three lanes open for lap swimming. If one swimmer is in a lane, he or she swims up and down the right side of the lane. If there are two swimmers are in a lane, each swims up and down one side of the lane. Swimmers always join the lane with the fewest number of swimmers. If all three lanes are occupied by two swimmers each, a prospective swimmer becomes disgusted and goes running. a) What fraction of time will exactly three people be swimming laps? b) On the average, how many people will be swimming laps in the pool ? a) How many lanes does the YMCA need to allot to lap swimming to ensure that at most 5% of all prospective swimmers will become disgusted and go running. 135 pts]

Please solve using excel(spread sheet) and show equations used to find each value. Thanks(Sorry but it's required to be done on excel)

Answer 1

Answex Mdina to Swis laps at YMCA Shihi an alenge →This is a Bcc or blocked Customers Cleage d pvoblen Assuming thart the inter aival tines ave Sxp Mential such a Systen is modeled as ou e inter avrival times ae p aand mean sesvice time → He the fractions of aynVals that ave turned ouhday ave of priney intevest > Since the annuals are tonne dawan only when -s costoners ave present , a fractou, ou Heve Arrilval yorte s

people/hok t action of time w gnactty three people be stormming taps ? es thot 3 peopie il be Sh3 "wvning (aps fs to be deteR ruined. 回トtow 나 YMCA rpA 3 (aps -for Swimming ls- the fraction s, 와 ali avrWals that Loit be tuined traction of times thort 3 pec.@le hilt be shǐm'ming

O Thus , the fvaction or time thet 3 people it be shoimmin taps is 55 b on -the average, haw mahy people will be Suimining taps in the pool? The WUmber ef People gwimwinglops in the ool on on auevage is the ixpected humbe 2( 0 55) hus on an average -It- people ave Swimm wg Lops nthe ps i

FoR P-5 the shallest Vaue af s for which 7ts-o.05 or smalley is -to be deteR'mined İS approximate u 9 prospective sulimmevs ill be (ome dtsgusted and go vmning YHCA needs to altot lones for tp suinhi