quality management "Excel"

Mike23
t29.xls
Home>Mathematics homework help>Statistics homework help>quality management "Excel"

Hired and complaints per day

Day # hired/requests mgt complaint
1 768 240
2 912 144
3 1376 368
4 1120 320
5 1376 368
6 624 336
7 1440 144
8 1312 288
9 640 400
10 1280 192
11 1744 336
12 656 416
13 672 304
14 1184 352
15 1504 192
16 912 128
17 752 368
18 768 384
19 1344 400
20 1216 128
21 1760 272
22 1664 416
23 1168 192
24 1040 336
25 1552 384
26 1408 400
27 1168 240
28 1392 256
29 720 192
30 944 288
31 1760 368
32 1008 432
Post Change 1 33 640 96
2 34 768 160
3 35 640 160
4 36 496 96
5 37 896 16
6 38 896 96
7 39 864 48
8 40 784 32
9 41 896 64
10 42 752 128
11 43 880 64
12 44 768 64
13 45 688 80
14 46 592 112
15 47 400 48
16 48 688 80
17 49 864 32
18 50 464 32
19 51 448 96
20 52 912 64
21 53 448 80
22 54 784 144
23 55 944 48
24 56 832 64
25 57 928 64
26 58 896 64
27 59 656 0
28 60 864 96
29 61 848 32
30 62 816 128
31 63 576 0
32 64 768 80

Errors on Request

request Opportunity for error errors
1 464 144
2 400 80
3 352 32
4 528 144
5 496 32
6 432 64
7 512 80
8 368 144
9 352 128
10 352 112
11 432 48
12 512 160
13 512 96
14 384 48
15 512 128
16 336 64
17 464 32
18 368 112
19 384 96
20 352 160
21 512 80
22 384 64
23 368 128
24 512 128
25 512 64
26 352 160
27 352 144
28 512 96
29 432 48
30 384 128
Post Change 1 31 432 32
2 32 432 48
3 33 432 64
4 34 416 64
5 35 320 16
6 36 448 48
7 37 352 48
8 38 384 48
9 39 304 48
10 40 432 48
11 41 336 64
12 42 432 64
13 43 320 0
14 44 320 0
15 45 368 64
16 46 416 32
17 47 352 32
18 48 464 16
19 49 400 16
20 50 336 48
21 51 432 16
22 52 384 48
23 53 416 16
24 54 464 32
25 55 448 32
26 56 352 0
27 57 336 32
28 58 352 48
29 59 400 64
30 60 368 48

Total duration time

I used an n of 3, so please do the same.
Request # Duration Time in Days
1 148.8
2 107.2
3 65.6
4 144
5 20.8
6 129.6
7 136
8 32
9 84.8
10 148.8
11 132.8
12 62.4
13 17.6
14 147.2
15 57.6
16 51.2
17 150.4
18 97.6
19 38.4
20 126.4
21 152
22 25.6
23 84.8
24 38.4
25 40
26 92.8
27 140.8
28 49.6
29 128
30 72
Post Change 1 31 20
2 32 10
3 33 20
4 34 12
5 35 14
6 36 18
7 37 28
8 38 13
9 39 16
10 40 22
11 41 22
12 42 23
13 43 28
14 44 11
15 45 25
16 46 11
17 47 16
18 48 12
19 49 28
20 50 21
21 51 15
22 52 21
23 53 17
24 54 26
25 55 26
26 56 11
27 57 12
28 58 21
29 59 29
30 60 13

Actual Touch time

Request # Touch time in hours
1 2.7180721108
2 25.5063580128
3 1.4640177765
4 12.6903292964
5 3.328868508
6 29.0402229827
7 11.0312127419
8 17.7950355795
9 54.7669306704
10 44.5663877339
11 54.7584778564
12 2.1388751877
13 36.3273249066
14 14.0961425255
15 2.6023206517
16 20.676340316
17 37.8161036357
18 34.9073602155
19 16.3008828861
20 17.7804231952
21 24.575894125
22 35.6865676312
23 27.5866393198
24 23.028654381
25 23.2420778272
26 6.1688199491
27 10.4811322049
28 20.5920322273
29 33.6534937677
30 8.3427900829
Post Change 1 31 15.3229505964
2 32 11.3928451473
3 33 10.9604799809
4 34 16.9210477308
5 35 14.3240031035
6 36 16.0785985612
7 37 12.7131733724
8 38 13.6086525449
9 39 10.5613121767
10 40 13.581810792
11 41 13.3918903724
12 42 21.1664521416
13 43 17.9252844715
14 44 16.5190502974
15 45 15.1745317134
16 46 14.7239008109
17 47 15.6099642894
18 48 9.5064417287
19 49 22.3656960539
20 50 22.3297929279
21 51 19.6733636622
22 52 17.9350694618
23 53 14.4488135058
24 54 11.725008852
25 55 14.5339399165
26 56 20.967607329
27 57 21.7085847359
28 58 11.3133811073
29 59 15.4457457201
30 60 13.4506749665

Financial information

0.0676320622 a random number
18.58 APR Let your rate vary within a uniform distribution +/- 2% of the displayed rate in A2. For example, if the rate in A2 said 10%, the APR would vary between 8% to 12%.
4.55 Time in years
$ 63,106,901.68 Time zero cost
$ 2,905,968.62 Annual maintenance cost Let your cost vary within a uniform distribution +/- $100,000 of the annual cost displayed in A5.
$ 80.31 Cost per person hour for touch time during the hire process
$ 1,257.02 Cost to train a new hire
260 number of days worked per year or 21.6666666667 days per month
Accrue monthly and generate 50 possible NPV's using a data table to generate a 95% confidence interval for your NPV and the probability the NPV will be zero or less.