Solved Problem 2
Learning Curves
<Back
Learning curve percent 75%
Time for first unit 15.9
Unit Unit Total Average
Number Time Time Time
1 15.9 15.9 15.9
2 11.925 27.825 13.9125
14 0
14 5.31754
Unit Total Average
5.32
6
8
10
12
14
16
18
0 5 10 15 20 25 30 35 40 45
Unit Time
Unit Number
60% 70% 80% 90% 75%
Page 15
3 10.078 37.903 12.6343
Solved Problem 2
Unit 75% Cum 60% 70% 80% 90%
1 15.900 15.900 15.900 15.900 15.900 15.900
2 11.925 27.825 9.540 11.130 12.720 14.310
4 8.944 46.847 5.724 7.791 10.176 12.879
5 8.153 54.999 4.856 6.946 9.471 12.449
6 7.558 62.558 4.245 6.324 8.931 12.109
7 7.090 69.648 3.790 5.842 8.498 11.829
8 6.708 76.356 3.434 5.454 8.141 11.591
10 6.114 88.858 2.914 4.862 7.577 11.205
11 5.877 94.735 2.716 4.629 7.348 11.043
12 5.669 100.404 2.547 4.427 7.145 10.898
13 5.484 105.888 2.401 4.248 6.963 10.766
14 5.318 111.205 2.274 4.089 6.799 10.646
16 5.031 121.404 2.061 3.818 6.513 10.432
18 4.791 131.100 1.889 3.593 6.270 10.247
20 4.586 140.371 1.748 3.403 6.061 10.084
21 4.494 144.865 1.686 3.319 5.967 10.010
22 4.408 149.273 1.630 3.241 5.878 9.939
23 4.327 153.600 1.577 3.167 5.795 9.872
24 4.252 157.852 1.528 3.099 5.716 9.808
26 4.113 166.145 1.441 2.974 5.570 9.690
28 3.988 174.182 1.364 2.862 5.439 9.581
30 3.876 181.988 1.297 2.763 5.319 9.481
32 3.773 189.584 1.236 2.672 5.210 9.389
33 3.725 193.309 1.209 2.630 5.159 9.345
34 3.679 196.989 1.182 2.590 5.109 9.303
35 3.635 200.624 1.157 2.552 5.062 9.262
36 3.593 204.217 1.134 2.515 5.016 9.222
38 3.513 211.283 1.089 2.446 4.930 9.147
39 3.476 214.759 1.069 2.414 4.889 9.111
40 3.439 218.198 1.049 2.382 4.849 9.076
3 10.078 37.903 7.076 9.034 11.163 13.455
Supplement to Chapter 7 – Problems 1-10 Note: This worksheet displays results only, you must copy the shaded
<Back area into the corresponding template to make additional calculations.
1. Learning Curves
Learning curve percent 80%
Time for first unit 300
Unit Unit Total Average
Number Time Time Time
2. Learning Curves
Learning curve percent 72%
Time for first unit 80
Unit Unit Total Average
Number Time Time Time
Learning curve percent 87%
Time for first unit 80
Unit Unit Total Average
Number Time Time Time
Learning curve percent 95%
Unit Unit Total Average
Number Time Time Time
3. Learning Curves
Learning curve percent 85%
Time for first unit 8
Unit Unit Total Average
Number Time Time Time
4. Learning Curves
Learning curve percent 82%
Time for first unit 20
Unit Unit Total Average
Number Time Time Time
5. Learning Curves
Learning curve percent 85%
Time for first unit 46
Unit Unit Total Average
Number Time Time Time
146 46 46
239.1 85.1 42.55
433.235 153.8891 38.47227
531.54087 185.43 37.08599
630.22097 215.6509 35.94182
6. Learning Curves
Learning curve percent 70%
Time for first unit 50
Unit Unit Total Average
Number Time Time Time
424.5 137.909 34.47725
7. Learning Curves
Learning curve percent 75%
Time for first unit 203.6428
Unit Unit Total Average
Number Time Time Time
4114.5491 600 150
696.80707 801.2238 133.5373
8. Learning Curves
335.55408 120.6541 40.21803
Learning curve percent 90%
Time for first unit 18.51883
Unit Unit Total Average
Number Time Time Time
514.5 80.35678 16.07136
10. Learning Curves
Learning curve percent 89%
Time for first unit 9
Unit Unit Total Average
Number Time Time Time
28.01 17.01 8.505
Learning curve percent 80%
Time for first unit 10
Unit Unit Total Average
Number Time Time Time
110 10 10
Learning curve percent 75%
Time for first unit 12
Unit Unit Total Average
Number Time Time Time
Supplement to Chapter 7 – Problems 11-18 Note: This worksheet displays results only, you must copy the shaded
<Back area into the corresponding template to make additional calculations.
11. Learning Curves
Learning curve percent 88%
Time for first unit 40
Unit Unit Total Average
Number Time Time Time
235.2 75.2 37.6
430.976 138.8398 34.70996
12. Learning Curves
Learning curve percent 77%
Time for first unit 12
Unit Unit Total Average
Number Time Time Time
112 12 12
13. Learning Curves
Learning curve percent 82%
Time for first unit 30.5
Unit Unit Total Average
Number Time Time Time
225.01 55.51 27.755
322.26886 77.77886 25.92629
420.5082 98.28706 24.57177
Learning curve percent 93%
Time for first unit 30.5
Unit Unit Total Average
Number Time Time Time
130.5 30.5 30.5
327.18607 86.05107 28.68369
426.37945 112.4305 28.10763
14. Learning Curves
Learning curve percent 75%
Time for first unit 9.75144
Unit Unit Total Average
Number Time Time Time
15. Learning Curves
Learning curve percent 90%
130.5 30.5 30.5
Time for first unit 11
Unit Unit Total Average
Number Time Time Time
111 11 11
39.308266 30.20827 10.06942
48.91 39.11827 9.779566
58.612854 47.73112 9.546224
18 7.089039 146.6779 8.148774
19 7.031018 153.7089 8.089944
20 6.976412 160.6854 8.034268
Learning curve percent 80%
Time for first unit 10.5
Unit Unit Total Average
Number Time Time Time
110.5 10.5 10.5
28.4 18.9 9.45
37.372089 26.27209 8.757363
46.72 32.99209 8.248022
Learning curve percent 85%
Time for first unit 12
Unit Unit Total Average
Number Time Time Time
112 12 12
210.2 22.2 11.1
39.274978 31.47498 10.49166
48.67 40.14498 10.03624
58.228053 48.37303 9.674606
67.883731 56.25676 9.376127
29.9 20.9 10.45
87.3695 71.23014 8.903767
97.168768 78.39891 8.71099
10 6.993845 85.39275 8.539275
16. Learning Curves
Learning curve percent 83%
Time for first unit 30
Unit Unit Total Average
Number Time Time Time
130 30 30
322.32868 77.22868 25.74289
420.667 97.89568 24.47392
519.46374 117.3594 23.47189
618.53281 135.8922 22.64871
717.78053 153.6728 21.95325
17. Learning Curves
Learning curve percent 86%
Time for first unit 36
Unit Unit Total Average
Number Time Time Time
136 36 36
328.34556 95.30556 31.76852
525.3637 147.2949 29.45897
624.37718 171.672 28.61201
77.603878 63.86064 9.122949
Learning curve percent 90%
Time for first unit 40
Unit Unit Total Average
Number Time Time Time
140 40 40
236 76 38
432.4 142.2482 35.56206
16 26.244 481.5927 30.09954
17 26.00327 507.5959 29.85859
18 25.77832 533.3743 29.6319
19 25.56734 558.9416 29.41798
20 25.36877 584.3104 29.21552
21 25.18132 609.4917 29.02341
22 25.00389 634.4956 28.84071
Learning curve percent 81%
Time for first unit 37
Unit Unit Total Average
Number Time Time Time
137 37 37
326.49439 93.46439 31.1548
18. Learning Curves
Learning curve percent 75%
333.84824 109.8482 36.61608
Unit Unit Total Average
Number Time Time Time
155 55 55
241.25 96.25 48.125
430.9375 162.0485 40.51212
528.20096 190.2494 38.04989
626.14573 216.3952 36.06586
724.52536 240.9205 34.41722
823.20313 264.1236 33.01546
922.09613 286.2198 31.8022
10 21.15072 307.3705 30.73705
11 20.33039 327.7009 29.79099
12 19.6093 347.3102 28.94252
13 18.96856 366.2787 28.17529
334.86097 131.111 43.70366