Phone orders are accepted at Catalog Company's toll-free number. The number is available 9 hours per day (9 A.M. to 5 P.M.), five days a week. Currently, Catalog employs a single full-time operator to take orders over the phone. With only one phone line, any incoming calls that arrive when Betty is on the phone to another customer get a busy signal. After talking to the phone company, Sarah learned that she could borrow equipment for one day to detect when a call was coming in, even when Betty was on the phone. The caller would still get a busy signal and be lost, but Sarah would know that a call had been attempted. Sarah collected almost nine hours of data the next day. 1st call arrives at 0.036 hours into the day. It takes 0.054 hours to process the call and record the order for $65.21 worth of merchandise. Callers 5 and 6 get busy signals when they call because Betty was still processing caller 4. Because calls 5 and 6 were lost, no call length information was available, and no orders were placed. Data collection was stopped at call number 80. (calculate down to three decimal points) Use the info below to answer the questions (explain through Excel):

 

A 1 Catalog data 23456700 9 8 10 11 12 13 14 15 16 17 18 692722 19 20 21 23 24 Call number 1 2 3 4 5 (hours) 0.0359 0.1564 0.3066 0.3609 0.3610 0.3689 0.4094 0.4652 0.8518 0.8597 0.9653 1.0852 1.5867 1.6252 1.6475 1.6953 17 1.7270 18 1.7457 1.7791 1.7876 6700 8 9 10 11 12 13 14 15 16 B 19 20 Arrival Busy? time (1=busy signal) 0 0 0 0 0 0.0877 1 0 1 0 1 1 1 0 D 1 0.0503 0.0191 0.0109 Call length Revenue (hours) (dollars) Inter-Arrival Time 0.0544 65.21 62.47 62.46 38.11 0.0219 0.0544 0.0175 0.0583 0.0939 E 0.1049 54.02 16.82 26.38 27.88 47.30 56.18 FL 41.68 2.151835675 7.232081958 9.009974003 3.262165614 0.002146373 0.477753143 2.429079722 3.344210408 23.19963651 0.472766914 6.334347326 7.198613536 30.08929216 2.306420017 1.339447795 2.866870123 1.902358277 1.1202437 2.008023876 0.509495544 A 1 Catalog data 23456700 9 8 10 11 12 13 14 15 16 17 18 692722 19 20 21 23 24 Call number 1 2 3 4 5 (hours) 0.0359 0.1564 0.3066 0.3609 0.3610 0.3689 0.4094 0.4652 0.8518 0.8597 0.9653 1.0852 1.5867 1.6252 1.6475 1.6953 17 1.7270 18 1.7457 1.7791 1.7876 6700 8 9 10 11 12 13 14 15 16 B 19 20 Arrival Busy? time (1=busy signal) 0 0 0 0 0 0.0877 1 0 1 0 1 1 1 0 D 1 0.0503 0.0191 0.0109 Call length Revenue (hours) (dollars) Inter-Arrival Time 0.0544 65.21 62.47 62.46 38.11 0.0219 0.0544 0.0175 0.0583 0.0939 E 0.1049 54.02 16.82 26.38 27.88 47.30 56.18 FL 41.68 2.151835675 7.232081958 9.009974003 3.262165614 0.002146373 0.477753143 2.429079722 3.344210408 23.19963651 0.472766914 6.334347326 7.198613536 30.08929216 2.306420017 1.339447795 2.866870123 1.902358277 1.1202437 2.008023876 0.509495544