Period Wk Ship Tot Plan Plan-YID Ship YTD Cum Dev.
Bookings B-Log OD B-Log
1 370 677 677 370 -307 380 2304 593
2 567 677 1354 937 -417 353 2090 764
3 237 677 2031 1174 -857 300 2153 1001
1 4 380 677 2708 1554 -1154 717 2490 1331
5 493 493 3201 2047 -1154 1997
6 493 493 3694 2540 -1154 1504
7 493 493 4187 3033 -1154 1011
2 8 493 493 4680 3526 -1154 518
9 263 263 4943 3789 -1154 255
10 440 440 5383 4229 -1154 -185
11 440 440 5823 4669 -1154 -625
12 263 263 6086 4932 -1154 -888
3 13 723 723 6809 5655 -1154 -1611
14 723 723 7532 6378 -1154 -2334
15 907 907 8439 7285 -1154 -3241
16 907 907 9346 8192 -1154 -4148
4 17 500 500 9846 8692 -1154 -4648
18 500 500 10346 9192 -1154 -5148
19 500 500 10846 9692 -1154 -5648
20 500 500 11346 10192 -1154 -6148
5 21 633 633 11979 10825 -1154 -6781
22 633 633 12612 11458 -1154 -7414
23 633 633 13245 12091 -1154 -8047
24 633 633 13878 12724 -1154 -8680
25 633 633 14511 13357 -1154 -9313
6 26 890 890 15401 14247 -1154 -10203
27 894 894 16295 15141 -1154 -11097
28 890 890 17185 16031 -1154 -11987
29 653 653 17838 16684 -1154 -12640
7 30 653 653 18491 17337 -1154 -13293
31 653 653 19144 17990 -1154 -13946
32 653 653 19797 18643 -1154 -14599
33 610 610 20407 19253 -1154 -15209
8 34 763 763 21170 20016 -1154 -15972
35 763 763 21933 20779 -1154 -16735
36 867 867 22800 21646 -1154 -17602
37 867 867 23667 22513 -1154 -18469
38 1084 1084 24751 23597 -1154 -19553
9 39 1084 1084 25835 24681 -1154 -20637
40 1084 1084 26919 25765 -1154 -21721
41 1084 1084 28003 26849 -1154 -22805
42 800 800 28803 27649 -1154 -23605
10 43 800 800 29603 28449 -1154 -24405
44 800 800 30403 29249 -1154 -25205
45 567 567 30970 29816 -1154 -25772
46 567 567 31537 30383 -1154 -26339
11 47 453 453 31990 30836 -1154 -26792
48 567 567 32557 31403 -1154 -27359
49 567 567 33124 31970 -1154 -27926
50 453 453 33577 32423 -1154 -28379
51 567 567 34144 32990 -1154 -28946
12 52 567 567 34711 33557 -1154 -29513
33557 667.519231 33557 -1154 3693
3
Production Data has been disguised due to the confidentiality of the data 645.3269
Service
74.2
63.87
45
32
Total Lead time 57.42 days
8.202857 weeks
Receive Resolve
Order and order Order
check Book related interfacin
Days payments order issues g to MRP MRP
same day 0.5 0.75 0.95 0.95
Normal 2.5 0.2 0.6 0.7
Normal 2 0.05
3 days 3
3-5 days 4
5 days 5
Error 7 0.05
Rush 0.5 0.3
Large 7 0.1
In stock 1 0.1
Special cert 7 0.2
Problem (1 84 0.05
8 weeks 56
Lead time 1.225 2.35 3.25 4.675 0.575
International
Receiving Assign Travel
Parts Purchase inspection WIP order to cards Pick
available Material stores Complete floor parts Manufacturing release Shipping
0.95 0.85 0.15 0.95 0.05 0.05 0.03
0.04 0.6 0.15
0.13
0.05 0.05
0.75
0.84
0.05
0.3
0.9 0.9 0.1 0.8
0.01
0.22
0.05 0.02 0.01
3.275 1.805 4.835 0.645 1.075 1.075 21.495 3.7 1.525
Domestic
Pick Ship
release Shipping Confirm
0.45 0.08
0.5
0.02
0.05 0.9
4.675 0 1.24
Rosemount Non Flow Lab Analysis
Case
Data
Number Raw Number
of Processing Effective Setup between MTTF
stations Time (hr) hrs/day Yield Time setups (hr)
Welding 5 0.262 8 0.99 0.03 1 40
Hydro 1 0.019 8 0.96 0.15 5 40
Sensoring 1 0.025 8 0.95 0 5 40
Flowlab 20
Config 1 0.030 8 0.85 0 1 40
Test 1 0.023 8 0.99 0 1 40
Inspection 1 0.015 8 0.99 0 1 99999999
Packing 1 0.015 8 1 0 1 99999999
MTTR
(hr)
0.17
0.17
0.17
0.5
0.17
0.17
0
0
Flow Lab Analysis Days Shifts
5 2
Case
Data
Mean STD Setup
Demand / Demand / Avg Process time
Line Scale Product week week mix time (hr) (hr)
1A 18"-24" M 6.668 1 0.01 0.80 0.15
1A 6"-8" V 70.014 5 0.09 0.28 0.07
2A 14" & 16" M 6.668 5 0.01 0.20 0.07
3A 12" M 6.668 90.018 5 0.01 0.22 0.07
3B 8" & 10" M 6.668 1 0.01 0.58 0.13
4B 4" M 16.67 1 0.02 0.72 0.12
4B 6" M 10.002 1 0.01 0.37 0.12
4B 4" V 80.016 113.356 7 0.10 0.20 0.07
5C 2" M 16.67 1 0.02 0.90 0.10
5C 3" M 16.67 1 0.02 0.68 0.10
5C 2" V 116.69 7 0.15 0.17 0.05
5C 3" V 120.024 270.054 8 0.15 0.17 0.07
6D 1.5" M 10.002 1 0.01 0.67 0.10
6D 1" V 123.358 8 0.16 0.13 0.05
6D 1.5" V 100.02 233.38 7 0.13 0.12 0.05
7E 0.5" M 10.002 1 0.01 0.38 0.10
7E 1" M 16.67 1 0.02 0.37 0.10
7E 0.5" V 56.678 83.35 3 0.07 0.08 0.05
Total Total M 123.358 0.16 7.03333333 1.55
Total V 666.8 0.84
790.158
Ideal State
Hours Net
8 80 4800
Reqd
/week which process deviation to consider- due to std de
Run Total
Time mins
/week /scale net demand/hrstdev CV/hr SCV Mean Process Time
6.33 5.3344
24.50 19.8373
1.78 1.3336
1.89 34.51 90.018 1.125225 0.974679 0.866208 0.750317 0.310493827160494 1.444733
4.78 3.889667
13.89 11.94683
4.83 3.6674
21.34 44.84 113.356 1.41695 0.806226 0.568987 0.323746 0.313235294117647 16.0032
16.67 15.003
13.06 11.39117
25.28 19.44833
28.01 83.02 270.054 3.375675 1.198958 0.355176 0.12615 0.243827160493827 20.004
7.67 6.668
22.62 16.44773
16.67 46.95 233.38 2.91725 1.193734 0.409198 0.167443 0.149047619047619 11.669
4.83 3.8341
7.78 6.112333
7.56 20.17 83.35 1.041875 0.37081 0.355906 0.126669 0.176 4.723167
229.49 229.49
ation to consider- due to std dev of demand or the process itself due to multiple lines
stdev proc SCV proces
Mean Setup Time SCV(setupBatch size
1.0002
4.6676
0.444533
8.77 9.963849 0.07284 0.444533 0.12206 1.708861
0.889067
1.944833
1.1669
6.12 4.765602 0.082353 5.3344 0.096793 2.151899
1.667
1.667
5.8345
4.05 3.455606 0.06358 8.0016 0.385514 5.126582
1.0002
6.1679
4.89 13.4564 1.000857 5.001 0.001146 4.43038
1.0002
1.667
1.15 0.532036 1.002999 2.8339 0.000134 1.582278
MEASURE: STATION: A B C D E
Arrival Rate (part ra 1.125 1.417 3.376 2.917 1.042
Arrival SCV ca2 0.750 0.324 0.126 0.167 0.127
Natural Process T t0 0.310 0.313 0.244 0.149 0.176
Natural Process c02 9.964 4.766 3.456 13.456 0.532
Number of Machi m 1 1 1 1 1
MTTF (hr) mf 20 20 20 20 20
MTTR (hr) mr 0.5 0.5 0.5 0.5 0.5
Availability A 0.976 0.976 0.976 0.976 0.976
Effective Process te' 0.318 0.321 0.250 0.153 0.180
Eff Process SCV ( ce2' 10.040 4.842 3.553 13.616 0.667
Batch Size k 2 2 5 4 2
Setup Time (hr) ts 0.073 0.082 0.064 1.001 1.003
Setup Time SCV cs2 0.122 0.097 0.386 0.001 0.000
Arrival Rate of B ra/k 0.658 0.658 0.658 0.658 0.658
Eff Batch Processte = kt0/A+ts 0.617 0.773 1.345 1.678 1.288
k*s
Eff Batch
0/A + 2m
2 2
Process
r(1-A)kt0/A+ss
2
1.739 1.075 1.139 1.409 0.034
Eff Process SCV ( ce2
4.571 1.797 0.630 0.501 0.021
Utilization u 0.406 0.509 0.886 Overload 0.848
Departure SCV cd2 1.380 0.706 0.521 #VALUE! 0.050
Yield y 1.000 1.000 1.000 1.000 1.000
Final Departure R ra*y 1.125 1.417 3.376 2.917 1.042
Final Departure ycd2+(1-y) 1.380 0.706 0.521 #VALUE! 0.050
Utilization u 0.406 0.509 0.886 Overload 0.848
Throughput TH 1.125 1.417 3.376 2.917 1.042
Queue Time (hr) CTq 1.122 0.851 3.933 #VALUE! 0.532
Cycle Time (hr) CTq+te 1.739 1.624 5.278 #VALUE! 1.820
Cumulative Cycle
Si(CTq(i)+te(i)) 1.739 1.624 5.278 #VALUE! 1.820
WIP in Queue (jo raCTq 1.262 1.205 13.276 #VALUE! 0.554
WIP (jobs) raCT 1.956 2.301 17.816 #VALUE! 1.896
Cumulative WIPS(i(ra(i)CT(i)) 1.956 2.301 17.816 #VALUE! 1.896