CNC VMC Production Sheet Format

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 13

Total

Part Number Operations Machine Setting Cycle


No. time
PER DAY PER NIGHT
SHIFT SHIFT
1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan 13-Jan 14-Jan 15-Jan 16-Jan 17-Jan 18-Jan 19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan 26-Jan 27-Jan 28-Jan 29-Jan 30-Jan 31-Jan
IN MIN QTY QTY D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D N D Total Work Hours
N
Drilling + Boring CNC 1 3.5 171 103 151 151 182 144 129 130 149 140 152 135 160 145 160 170 165 165 153 160 132 135 170 145 160 162 175 153 130 158 170 152 160 176 150 120 20 125 176 135 170 160 160 170 160 115 6720
140 392.00
1 005553025R1
Form Milling VMC 2 3.8 160 96 155 146 150 131 147 152 167 140 170 135 152 145 140 143 165 110 170 130 152 153 175 158 100 175 170 144 155 150 118 150 175 160 170 135 64 131 152 150 152 145 158 147 160 140 6642
155 415.13
Facing,Drilling,Reaming,Chamfering,Side Facing, Gang Milling VMC 1 20.5 29 18 28 30 33 27 25 31 33 32 26 29 34 34 32 34 31 35 31 32 29 28 20 31 25 34 31 19 33 30 34 28 32 33 30 32 32 30 34 35 34 21 5 9 26 31 35 33 26 1407
30 481.51
2 000032990B12
Facing,Drilling,Tapping,Chamfering,Side Facing,Form Milling VMC 2 8.4 71 43 46 55 57 50 60 57 30 30 61 60 68 25 8 43 35 64 64 45 70 55 49 70 76 45 40 1263 176.82
3 000032939B12 Facing + Drilling + Tapping + Chamfering VMC 1 4.6 130 78 115 82 104 70 109 35 20 125 133 100 138 112 51 40 100 100 86 1520 116.96
Facing + Drilling + Tapping + Chamfer VMC 1 4.4 136 82 86 89 42 85 56 40 50 82 85 44 125 90 125 90 65 85 94 95 113 90 128 125 80 85 63 78 62 50 2302 169.45
4 006518269B1
Form Milling VMC 2 7.5 80 48 38 65 50 25 54 24 70 58 64 35 27 49 50 50 40 26 65 55 55 40 69 38 62 55 52 55 50 60 48 1429 179.02
Drilling + Boring + Facing+Chamfer CNC 1 4.6 130 78 90 120 152 120 132 130 130 115 140 75 125 103 100 22 1554 119.57
5 006509751U1 Facing + Drilling + Tapping+Counter VMC 2 6.9 87 52 45 48 55 10 60 15 30 80 58 57 30 65 30 50 65 58 50 55 77 80 38 67 83 60 67 70 66 64 33 1566 180.09
Slot Machining VMC 3 7.6 79 48 40 41 57 10 50 62 50 68 42 60 55 46 55 66 60 59 50 65 60 38 10 60 45 60 50 15 44 1318 165.85
Drilling + Boring + Facing + Chamfer CNC 1 5.2 115 69 0 0.00
6 006509752U1 Facing + Drilling + Tapping + Chamfer VMC 2 7.2 84 50 0 0.00
Slot Machining VMC 3 12.1 50 30 0 0.00
7 006509696U1 Drilling 15.1, 9.1, 8.1, 7.6 VMC 1 4.4 137 82 25 50 90 100 125 90 480 35.07
Drilling + Boring + Facing + Chamfer CNC 1 5.8 104 62 51 84 75 73 81 88 75 60 54 - 73 714 68.62
8 006505967B1
Facing + Drilling + Counter Drilling VMC 2 6.9 87 52 17 60 55 67 60 75 66 55 47 7 77 52 65 15 65 36 47 38 904 104.21
Centre Drill + Big Drilling + Reaming + Chamfer VMC 1 5.2 115 69 0 0.00
9 006513549V1
Small Drilling + Chamfer VMC 2 2.3 265 159 0 0.00
Big Drilling + Small Drilling VMC 1 5.9 102 61 0 0.00
10 006512183U1
Drilling + Counter Drilling + Tapping M10 x 1.5 VMC 2 4.6 130 78 73 62 65 200 15.33
Drilling + Boring + Facing + Chamfer CNC 1 5.9 102 61 105 126 125 140 115 95 126 132 964 94.79
11 000012075P04
Centre Drilling, Drilling, Chamfer, Reamer, Endmill (Tip Length) VMC 2 5.3 113 68 20 108 150 26 115 80 100 98 697 61.57
Drilling Boring Facing Chamfer CNC 1 7.1 85 51 112 125 115 140 74 566 66.98
12 000012076P04
Bottom tip Facing, drill, tip Length Maintain VMC 2 10.0 60 36 0 0.00
Drilling + Boring + Facing + Chamfer CNC 1 4.7 128 77 0 0.00
Bottom Facing, 14, 8 drill, Reamer, Length Maintain VMC 2 11.6 52 31 6 42 44 33 41 35 201 38.86
13 000013881P04 Top Facing VMC 3 4.9 122 73 50 65 115 9.39
1st Side Facing VMC 4 2.8 214 129 0 0.00
2nd Side Facing VMC 5 2.8 214 129 0 0.00
Drilling + Boring + Facing + Chamfer CNC 1 4.7 128 77 100 130 130 100 - 80 97 120 100 110 66 123 1156 90.55
14 000013882P04
Bottom Facing + Drilling + Reamer + Chamfer VMC 2 7.0 86 51 40 65 60 80 60 45 350 40.83
15 000016341P06 Facing + Centre Drill+ Drill + Tapping + Chamfer VMC 2 6.1 98 59 47 50 50 82 60 51 50 41 62 5 498 50.63
Top Facing, Depth cutting, centre drill VMC 1 6.1 98 59 0 0.00
Turning,Facing, Grooving CNC 2 7.9 76 46 0 0.00
16 000012294P04
Form milling VMC 3 6.3 95 57 0 0.00
Cross Hole VMC 4 4.6 130 78 0 0.00
Top Facing, centre drill VMC 1 6.1 98 59 30 22 52 5.29
Step Turning + Groove CNC 2 11.7 51 31 24 36 33 28 37 37 30 225 43.88
17 006504698D1
Form Milling VMC 3 10.5 57 34 25 24 30 30 30 25 40 33 56 52 345 60.38
Cross Hole VMC 4 2.2 273 164 0 0.00
Top Facing, centre drill VMC 1 6.0 100 60 80 35 70 185 18.50
Step Turning + Groove CNC 2 9.9 61 36 0 0.00
18 006504623D1
Form Milling VMC 3 8.1 74 44 0 0.00
Cross Hole VMC 4 2.2 273 164 0 0.00
Bottom Facing VMC 1 5.3 113 68 0 0.00
Side Facing VMC 2 4.2 143 86 0 0.00
19 006503410D1
Centre drill, drill, Slot Milling, chamfer VMC 3 4.9 122 73 0 0.00
Radius Milling VMC 4 7.8 77 46 0 0.00
20 000012489P04 Facing + Centre Drill + Drilling through + Reaming + Chamfer VMC 1 7.2 83 50 46 40 40 60 48 40 56 30 40 37 437 52.44
Facing VMC 1 3.8 158 95 120 136 100 356 22.55
21 000016386P04 Centre drill, drill,chamfer, reamer VMC 2 4.3 140 84 15 90 143 35 283 20.28
Side Chamfer VMC 3 2.6 231 138 100 140 125 365 15.82
Total Work Hours 3312.35

Quick Parts
1 CP16 CNC 3.8 157.895 94.736842 63 75 119 68 88 70 171 380 40 143 1217 77.08
2 CP8 CNC 4.4 136.364 81.818182 30 80 61 70 80 50 129 500 36.67
3 Gear Shifter VMC 2.7 222.222 133.33333 204 154 358 16.11
Total Work Hours 129.85
Part Number Operations Machine

Drilling + Boring CNC


1 005553025R1
Form Milling VMC
Facing,Drilling,Reaming,Chamfering,Side Facing, Gang Milling VMC
2 000032990B12
Facing,Drilling,Tapping,Chamfering,Side Facing,Form Milling VMC
3 000032939B12 Facing + Drilling + Tapping + Chamfering VMC
Facing + Drilling + Tapping + Chamfer VMC
4 006518269B1
Form Milling VMC
Drilling + Boring + Facing+Chamfer CNC
5 006509751U1 Facing + Drilling + Tapping+Counter VMC
Slot Machining VMC
Drilling + Boring + Facing + Chamfer CNC
6 006509752U1 Facing + Drilling + Tapping + Chamfer VMC
Slot Machining VMC
7 006509696U1 Drilling 15.1, 9.1, 8.1, 7.6 VMC
Drilling + Boring + Facing + Chamfer CNC
8 006505967B1
Facing + Drilling + Counter Drilling VMC
Centre Drill + Big Drilling + Reaming + Chamfer VMC
9 006513549V1
Small Drilling + Chamfer VMC
Big Drilling + Small Drilling VMC
10 006512183U1
Drilling + Counter Drilling + Tapping M10 x 1.5 VMC
Drilling + Boring + Facing + Chamfer CNC
11 000012075P04
Centre Drilling, Drilling, Chamfer, Reamer, Endmill (Tip Length) VMC
Drilling Boring Facing Chamfer CNC
12 000012076P04
Bottom tip Facing, drill, tip Length Maintain VMC
Drilling + Boring + Facing + Chamfer CNC
Bottom Facing, 14, 8 drill, Reamer, Length Maintain VMC
13 000013881P04 Top Facing VMC
1st Side Facing VMC
2nd Side Facing VMC
Drilling + Boring + Facing + Chamfer CNC
14 000013882P04
Bottom Facing + Drilling + Reamer + Chamfer VMC
15 000016341P06 Facing + Centre Drill+ Drill + Tapping + Chamfer VMC
Top Facing, Depth cutting, centre drill VMC
Turning,Facing, Grooving CNC
16 000012294P04
Form milling VMC
Cross Hole VMC
Top Facing, centre drill VMC
Step Turning + Groove CNC
17 006504698D1
17 006504698D1
Form Milling VMC
Cross Hole VMC
Top Facing, centre drill VMC
Step Turning + Groove CNC
18 006504623D1
Form Milling VMC
Cross Hole VMC
Bottom Facing VMC
Side Facing VMC
19 006503410D1
Centre drill, drill, Slot Milling, chamfer VMC
Radius Milling VMC
20 000012489P04 Facing + Centre Drill + Drilling through + Reaming + Chamfer VMC
Facing VMC
21 000016386P04 Centre drill, drill,chamfer, reamer VMC
Side Chamfer VMC
Big Side (Drilling + Boring + Facing + Chamfer) CNC
Big Side (Facing, Turning, Chamfer) CNC
22 000012073P04 Small Side (Drilling + Boring + Facing + Chamfer) CNC
Facing, Drilling, Tapping, Chamfer VMC
Radius Milling VMC
Total
Setting PER DAY PER NIGHT
Cycle
No. SHIFT SHIFT
time
1-Jan 2-Jan 3-Jan 4-Jan 5-Jan
IN MIN QTY QTY D N D N D N D N D
1 3.5 171 103 157 140 165 75
2 3.8 160 96 150 80 174 115
1 20.5 29 18 31 21 36 31
2 8.4 71 43 43 55 65 60
1 4.6 130 78 100 67 130 87
1 4.4 136 82
2 7.5 80 48
1 4.6 130 78 105 58 145 26
2 6.9 87 52
3 7.6 79 48 20
1 5.2 115 69
2 7.2 84 50
3 12.1 50 30
1 4.4 137 82
1 5.8 104 62
2 6.9 87 52
1 5.2 115 69
2 2.3 265 159
1 5.9 102 61 92 70 90 36
2 4.6 130 78
1 5.9 102 61
2 5.3 113 68
1 7.1 85 51
2 10 60 36
1 4.7 128 77
2 11.6 52 31 12
3 4.9 122 73 78 13
4 2.8 214 129
5 2.8 214 129
1 4.7 128 77
2 7 86 51
2 6.1 98 59
1 6.1 98 59
2 7.9 76 46
3 6.3 95 57
4 4.6 130 78
1 6.1 98 59 70 60 65 54
2 11.7 51 31
3 10.5 57 34
4 2.2 273 164
1 6 100 60
2 9.9 61 36
3 8.1 74 44
4 2.2 273 164
1 5.3 113 68
2 4.2 143 86
3 4.9 122 73
4 7.8 77 46
1 7.2 83 50
1 3.8 158 95
2 4.3 140 84
3 2.6 231 138
1 6.1 98 59
2 4.1 146 88
3 4.3 140 84
4 4.7 128 77
5 7.3 82 49
5-Jan 6-Jan 7-Jan 8-Jan 9-Jan 10-Jan 11-Jan 12-Jan
N D N D N D N D N D N D N D
12-Jan 13-Jan 14-Jan 15-Jan 16-Jan 17-Jan 18-Jan 19-Jan
N D N D N D N D N D N D N D
19-Jan 20-Jan 21-Jan 22-Jan 23-Jan 24-Jan 25-Jan 26-Jan
N D N D N D N D N D N D N D
26-Jan 27-Jan 28-Jan 29-Jan 30-Jan 31-Jan
N D N D N D N D N D N Total
537
519
119
223
384
0
0
334
0
20
0
0
0
0
0
0
0
0

You might also like