Excel File Edit View Insert Format Tools Data Window Help Mon Apr 4 12:14 PM AutoSave OFF SF LBL Waiting Lines-2021-Fall(2) (9) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Y 47. O Insert Arial v 14 AP 9. Wrao Text 2 General Delete Paste B Cell A TV Merge & Center Conditional Format $ -% Sort & Find & - Analyze Sensitivity Formatting as Table Styles Format Filter Select Data A21 fx GF Interior Design provides home and office decorating assistance to its customers. In normal operation, an average of 3 customers arrive each hour. One design consultant is available to answer customer questions and C M N O P J w Z AB F 40 Arulyaix of Waiting Line Ansignment You must do the mary calculation in the answer calls. Simply providing a number in the war call will not receive any credit When look at the BEE CHI, I want to sex number, wtan click on the call i want to the the bel formula, for example, if I make you the sum of calls through Ds, this is what I want to 7035.D 7034.0 1234 2345 3456 AD For full credit, planiraard proper calculation formule in the walls Problem 1: Use the information below, to answer the questions that follow. Enter the formulas into the yellow calls a thout the calls will show the information required. 10 Paine Sain lank pastasadimpleler wochst al customers to come bark traksion without getting out of her cars on weder meg, miwala ta the dive-poker window Coral random and follow a poisson distribution. The rival 20 custome's per hour or 0.223 customers per min. Service Tea Al the creussler for sportid probably distribution with A Service rate of 36.6tomers per hour or 0.6 customers per minute. Eren Erreth misal rate senice Ir In the cal rain in the bolow thia col bolom che this ons 11 12 13 Oucation 1 What is the probability that customers are in the system? 14 Oucation 2 What is the probably that 3 or more customers are in the system 15 Question 3 What is the werge number of stomers in ine? 16 Oucation 4 What is the crage number of O.stomers in the system IT Question 5 How long o.13 a 0.6mmer expect to wait fon average before being served 16 Problem 2: Use the Information below, to answer the questions that follow. Be sure to show your . work in the space below the quration Per hour HT GF Interior Design provides home and office decorating sasistance to to customers. In normal operator, ts Ange of custom Achhar. Ordesign contour cher Ener questions and make product recommendations. The consultan averages 10 minutes wth each otomer.sival rate service in the chi in the below this el botom 121 Then SKVICH Rhe not wel for AVEC CHI cvcraps of live minutes. Is this goal being mct? If noc, what cation Co you recommend? wwling 23 Questions 1 Ilms Mhe crtanian Hihe HSH IT sen hetic le mule, W- the mean service rate? Will the servoo goal be not? 24 Questions 2 Sheet1 Sheet2 Sheet3 + Ready Calculate Waiting Lines-2...xlsx 2 67% Show All X Og @ 090.29 $ A ? ada