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):

1.How many calls are lost in an average hour due to a busy signal?

2. =

3. =

B D E F Call length (hours) 0.0544 0.0503 0.0191 0.0109 CON 0.0877 . 1 Catalog data 2 3 Call 4 number 5 1 6 2 7 3 8 4 9 5 10 11 7 12 8 13 9 14 10 15 11 16 12 17 13 18 14 19 15 20 16 21 17 22 18 23 19 24 20 Arrival Busy? time (1=busy (hours) signal) 0.0359 0.1564 0.3066 0 0.3609 0 0.3610 1 0.3689 1 0.4094 0 0.4652 1 0.8518 0 0.8597 1 0.9653 0 1.0852 0 1.5867 0 1.6252 1 1.6475 1.6953 1 1.7270 1 1.7457 0 1.7791 1.7876 1 0.0219 Revenue (dollars) Inter-Arrival Time 65.21 2.151835675 62.47 7.232081958 62.46 9.009974003 38.11 3.262165614 0.002146373 0.477753143 54.02 2.429079722 3.344210408 16.82 23.19963651 0.472766914 26.38 6.334347326 27.88 7.198613536 47.30 30.08929216 2.306420017 56.18 1.339447795 2.866870123 1.902358277 41.68 1.1202437 2.008023876 0.509495544 0.0544 0.0175 0.0583 0.0939 0.1049 . 0 0 0 D 0.0869 0.0438 0.0818 E 46.05 25.03 28.75 0 0 0.0859 0.1466 0.1417 78.54 27.09 33.79 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 B 1.9197 2.1416 2.2508 2.3207 2.4315 2.6049 2.8200 2.9286 2.9494 3.2749 3.5034 3.6799 3.8093 3.8299 4.0392 4.0918 4.1434 4.4357 4.4385 4.7999 4.9794 4.9964 5.0116 5.0591 0.0244 0.1513 0.0985 0.0869 46.12 45.88 10.00 27.63 1 1 0 0 0 0 1 0 0 0 0 1 0 F 7.922770056 13.31654726 6.551995995 4.196631577 6.647246196 10.40033153 12.90776589 6.515538158 1.248288766 19.5288214 13.70944913 10.59318675 7.760871494 1.240761799 12.55677206 3.15263945 3.095231108 17.54167158 0.167616232 21.68445773 10.77117749 1.019735172 0.909222521 2.852796072 0.0180 0.0309 0.0470 0.0801 25.63 35.40 10.00 68.24 0.0231 0.0141 0.0680 10.00 29.43 58.03 45 46 47 48 0 1 1 A D 0.1233 E 68.93 0 1 1 0 0 0.0189 0.1212 10.00 12.80 1 0.1049 0.1155 0.1176 47.04 53.03 25.39 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 0 0 1 1 0 B 5.3208 5.3846 5.3927 5.4588 5.5933 5.6614 5.7382 5.8696 6.0807 6.1491 6.1709 6.2136 6.4046 6.4233 6.4693 6.5602 6.5861 6.6703 6.7295 6.8607 6.9368 6.9474 7.1178 7.1967 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 0.0591 0.2174 56.95 25.35 F. 15.69687903 3.831516735 0.482499634 3.970429935 8.069367004 4.086965284 4.607678776 7.883819499 12.66738826 4.102539812 1.308108027 2.558336454 11.46062504 1.122518022 2.762490698 5.450044948 1.557307734 5.052383535 3.553235879 7.870370164 4.568101261 0.6339439 10.22308786 4.731357644 1 1 1 0.0384 0.0895 0.0806 27.72 24.74 69.30 OOOOO 0.2175 47.75 0 0.1058 10.00 A D E 0.0253 0.0359 0.0963 0.0743 34.68 33.51 47.12 22.15 73 74 75 76 77 78 79 80 81 82 69 70 71 72 73 74 75 76 77 78 79 80 B 7.2355 7.5454 7.6737 7.7762 8.0674 8.1217 8.1224 8.1944 8.3930 8.3989 8.4033 8.4890 1 0 0 0 0 1 1 0 0 1 1 0 F 2.328214993 18.59768836 7.699769635 6.145369505 17.47084953 3.257886834 0.045148532 4.319810724 11.91851627 0.349485224 0.265270503 5.140723149 0.0802 0.0728 28.67 39.02 83 0.0310 10.00 84 85 B D E F Call length (hours) 0.0544 0.0503 0.0191 0.0109 CON 0.0877 . 1 Catalog data 2 3 Call 4 number 5 1 6 2 7 3 8 4 9 5 10 11 7 12 8 13 9 14 10 15 11 16 12 17 13 18 14 19 15 20 16 21 17 22 18 23 19 24 20 Arrival Busy? time (1=busy (hours) signal) 0.0359 0.1564 0.3066 0 0.3609 0 0.3610 1 0.3689 1 0.4094 0 0.4652 1 0.8518 0 0.8597 1 0.9653 0 1.0852 0 1.5867 0 1.6252 1 1.6475 1.6953 1 1.7270 1 1.7457 0 1.7791 1.7876 1 0.0219 Revenue (dollars) Inter-Arrival Time 65.21 2.151835675 62.47 7.232081958 62.46 9.009974003 38.11 3.262165614 0.002146373 0.477753143 54.02 2.429079722 3.344210408 16.82 23.19963651 0.472766914 26.38 6.334347326 27.88 7.198613536 47.30 30.08929216 2.306420017 56.18 1.339447795 2.866870123 1.902358277 41.68 1.1202437 2.008023876 0.509495544 0.0544 0.0175 0.0583 0.0939 0.1049 . 0 0 0 D 0.0869 0.0438 0.0818 E 46.05 25.03 28.75 0 0 0.0859 0.1466 0.1417 78.54 27.09 33.79 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 B 1.9197 2.1416 2.2508 2.3207 2.4315 2.6049 2.8200 2.9286 2.9494 3.2749 3.5034 3.6799 3.8093 3.8299 4.0392 4.0918 4.1434 4.4357 4.4385 4.7999 4.9794 4.9964 5.0116 5.0591 0.0244 0.1513 0.0985 0.0869 46.12 45.88 10.00 27.63 1 1 0 0 0 0 1 0 0 0 0 1 0 F 7.922770056 13.31654726 6.551995995 4.196631577 6.647246196 10.40033153 12.90776589 6.515538158 1.248288766 19.5288214 13.70944913 10.59318675 7.760871494 1.240761799 12.55677206 3.15263945 3.095231108 17.54167158 0.167616232 21.68445773 10.77117749 1.019735172 0.909222521 2.852796072 0.0180 0.0309 0.0470 0.0801 25.63 35.40 10.00 68.24 0.0231 0.0141 0.0680 10.00 29.43 58.03 45 46 47 48 0 1 1 A D 0.1233 E 68.93 0 1 1 0 0 0.0189 0.1212 10.00 12.80 1 0.1049 0.1155 0.1176 47.04 53.03 25.39 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 0 0 1 1 0 B 5.3208 5.3846 5.3927 5.4588 5.5933 5.6614 5.7382 5.8696 6.0807 6.1491 6.1709 6.2136 6.4046 6.4233 6.4693 6.5602 6.5861 6.6703 6.7295 6.8607 6.9368 6.9474 7.1178 7.1967 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 0.0591 0.2174 56.95 25.35 F. 15.69687903 3.831516735 0.482499634 3.970429935 8.069367004 4.086965284 4.607678776 7.883819499 12.66738826 4.102539812 1.308108027 2.558336454 11.46062504 1.122518022 2.762490698 5.450044948 1.557307734 5.052383535 3.553235879 7.870370164 4.568101261 0.6339439 10.22308786 4.731357644 1 1 1 0.0384 0.0895 0.0806 27.72 24.74 69.30 OOOOO 0.2175 47.75 0 0.1058 10.00 A D E 0.0253 0.0359 0.0963 0.0743 34.68 33.51 47.12 22.15 73 74 75 76 77 78 79 80 81 82 69 70 71 72 73 74 75 76 77 78 79 80 B 7.2355 7.5454 7.6737 7.7762 8.0674 8.1217 8.1224 8.1944 8.3930 8.3989 8.4033 8.4890 1 0 0 0 0 1 1 0 0 1 1 0 F 2.328214993 18.59768836 7.699769635 6.145369505 17.47084953 3.257886834 0.045148532 4.319810724 11.91851627 0.349485224 0.265270503 5.140723149 0.0802 0.0728 28.67 39.02 83 0.0310 10.00 84 85