executive shirt v2 operations management
DESCRIPTION
executive shirt case analysis. excel preparation for all possibilities of executive shirt caseTRANSCRIPT
Current
Time
Prepare Cutting Table 4 90.00 480 0.1875Cutting 4 30.00 480 0.0625
Make Collar 8 3.90 8 0.4875 29.2500Make Cuf 4 2.00 4 0.5000 30.0000Make Sleeves 2 0.65 2 0.3250 19.5000Make Front 6 2.50 6 0.4167 25.0000Make Back 4 1.70 4 0.4250 25.5000Join Shoulder 2 0.66 2 0.3300 19.8000Attach Collar 4 1.65 4 0.4125 24.7500Attach Sleeve 4 1.55 4 0.3875 23.2500Stitch down Sleeve 2 0.65 2 0.3250 19.5000Sew Side Seam 4 1.80 4 0.4500 27.0000Attch Cuf 4 1.55 4 0.3875 23.2500Hem Bottom 4 1.70 4 0.4250 25.5000
Inspect 4 1.50 4 0.3750 22.5000Iron 4 1.95 4 0.4875 29.2500Fold & Package 4 1.75 4 0.4375 26.2500
0.5000 30.0000
Process Cap 120 Shirts Per Hour960 Shirts Per Day
19200 Shirts Per Month
Capacity Ut 0.833333
wip 11760
Direct Labo 30720Utilization 0.690365
wip*cylc time / total time in day
Man Power
Units Produced
Minutes Per Shirt
Time Per Batch
32644.08
12.25
Ike Plan
Custom
Time
0.7500 1 2.5 5 0.50.2500 1
3.9000 1 3.90 1 3.902.0000 1 2.00 1 2.000.6500 1 0.65 1 0.652.5000 1 2.50 1 2.501.7000 1 1.70 1 1.700.6600 1 0.66 1 0.661.6500 1 1.65 1 1.651.5500 1 1.55 1 1.550.6500 1 0.65 1 0.651.8000 1 1.80 1 1.801.5500 1 1.55 1 1.551.7000 1 1.70 1 1.70
1.5000 1 1.50 1 1.501.9500 1 1.95 1 1.951.7500 1 1.75 1 1.75
3.9026.5100 26.0100
Process Capacity 15.384615 Shirts Per Hour123.07692 Shirts Per Day2461.5385 Shirts Per Month
Capacity Uti 0.8125
21208 Direct Labo 7680 2601Utilization 0.3386719
wip*cylc time / total time in day
Labour Content minutes / Shirt
Man Power
Units Produced
Minutes Per Shirt
Ikea Plan Mikes Plan
Normal
Time
4 90.00 480 0.1875 0.754 30.00 480 0.0625 0.25
7 3.90 7 0.5571 3.9000 7753.84623 2.00 3 0.6667 2.0000 810 7290 72001 0.65 1 0.6500 0.6500 831 13.335 2.50 5 0.5000 2.50003 1.70 3 0.5667 1.70001 0.66 1 0.6600 0.6600 8183 1.65 3 0.5500 1.65003 1.55 3 0.5167 1.55001 0.65 1 0.6500 0.6500 8313 1.80 3 0.6000 1.80003 1.55 3 0.5167 1.55003 1.70 3 0.5667 1.7000
00
3 1.50 3 0.5000 1.50003 1.95 3 0.6500 1.95003 1.75 3 0.5833 1.7500
0.6667 0.000026.5100
Process Cap 90 Shirts Per Hour720 Shirts Per Day
14400 Shirts Per MonthShortfall 1600 Per MonthOvertime 17.777778 Hours
Sho
WIP 9060
Direct Labo 23520 19087.2Utilization 0.8115306
Man Power
Units Produced
Minutes Per Shirt
Man hours Per Shirt
1 2 3 4Prepare Cutting Table 90Cutting 30Make Collar 29.25Make Cuf 30Make SleevesMake FrontMake BackJoin ShoulderAttach CollarAttach SleeveStitch down SleeveSew Side SeamAttch CufHem BottomInspectIronFold & Package
5 6 7 8 9 10
19.525
25.519.8
24.7523.25
11 12 13 14 15 16
19.527
23.2525.5
22.529.25
17 18 19 20 21 22
26.25
23 24 25 26 27 28
29 30 31 32 33 34 35 36 37 38 39 40 41 42
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93
94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110
111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127
128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144
145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161
162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178
179 180
1 2 3 4 5 6800 800 1600 2400 3200 4000 4800
0.2500 1920.00
0.5571 861.54
0.6667 720.00 810 810 810 810 810 810 810810 1620 2430 3240 4050 4860810 810 810 810 810 810
0.6500 738.46 830.77 830 830 830 830 830 830738 1568 2398 3228 3966 4796738 830 830 830 738 830
0.5000 960.00738 1568 2398 3228 3966 4796738 830 830 830 738 830
0.5667 847.06738 1568 2398 3228 3966 4796738 830 830 830 738 830
0.6600 727.27 818.18 818 818 818 818 818 818738 1556 2374 3192 3919 4737738 818 818 818 727 818
0.5500 872.73 872 1744 2616 3488 4360 5232738 1556 2374 3192 3919 4737738 818 818 818 727 818
0.5167 929.03 929 1858 2787 3716 4645 5574738 1556 2374 3192 3919 4737738 818 818 818 727 818
0.6500 738.46 830.77 830 830 830 830 830 830738 1556 2294 3124 3862 4692738 818 738 830 738 830
0.6000 800.00 900.00 900 900 900 900 900 900738 1538 2294 3094 3862 4662738 800 756 800 768 800
0.5167 929.03738 1538 2294 3094 3862 4662738 800 756 800 768 800
0.5667 847.06 952.94738 1538 2294 3094 3862 4662738 800 756 800 768 800
0.5000 960.00738 1538 2294 3094 3862 4662738 800 756 800 768 800
0.6500 738.46 830.77738 1476 2215 3046 3784 4615738 738 738 831 738 831
0.5833 822.86 925.71 738 1476 2215 3037 3784 4606738 738 738 822 747 822
882
7 8 9 10 11 12 13 14 155600 6400 7200 8000 8800 9600 10400 11200 12000
810 810 810 720 810 810 810 810 8105670 6480 7290 8010 8820 9630 10440 11250 12060
810 810 810 720 810 810 810 810 810830 830 830 830 830 830 830 830 830
5626 6456 7194 7932 8762 9592 10422 11160 11990830 830 738 738 830 830 830 738 830
5626 6456 7194 7932 8762 9592 10422 11160 11990830 830 738 738 830 830 830 738 830
5626 6456 7194 7932 8762 9592 10422 11160 11990830 830 738 738 830 830 830 738 830818 818 818 818 818 818 818 818 818
5555 6373 7191 7918 8736 9554 10372 11099 11917818 818 818 727 818 818 818 727 818
6104 6976 7848 8720 9592 10464 11336 12208 130805555 6373 7191 7918 8736 9554 10372 11099 11917
818 818 818 727 818 818 818 727 8186503 7432 8361 9290 10219 11148 12077 13006 139355555 6373 7191 7918 8736 9554 10372 11099 11917
818 818 818 727 818 818 818 727 818830 830 830 830 830 830 830 830 830
5522 6352 7182 7918 8656 9486 10316 11054 11884830 830 830 736 738 830 830 738 830900 900 900 900 900 900 900 900 900
5462 6262 7062 7862 8656 9456 10256 11054 11854800 800 800 800 794 800 800 798 800
5462 6262 7062 7862 8656 9456 10256 11054 11854800 800 800 800 794 800 800 798 800
5462 6262 7062 7862 8656 9456 10256 11054 11854800 800 800 800 794 800 800 798 800
5462 6262 7062 7862 8656 9456 10256 11054 11854800 800 800 800 794 800 800 798 800
5446 6184 7015 7846 8584 9415 10246 10984 11815831 738 831 831 738 831 831 738 831
5428 6184 7006 7828 8584 9406 10228 10984 11806822 756 822 822 756 822 822 756 822
16 17 18 19 2012800 13600 14400 15200 16000
810 810 810 810 72012870 13680 14490 15300 16000
810 810 810 810 700 18830 830 830 830 830
12820 13650 14480 15218 16000830 830 830 738 782 13
12820 13650 14480 15218 16000830 830 830 738 782
12820 13650 14480 15218 16000830 830 830 738 782818 818 818 818 818
12735 13553 14371 15189 16000818 818 818 818 811 16
13952 14824 15696 16568 1744012735 13553 14371 15189 16000
818 818 818 818 81114864 15793 16722 17651 1858012735 13553 14371 15189 16000
818 818 818 818 811830 830 830 830 830
12714 13544 14371 15189 16000830 830 827 818 811 13900 900 900 900 900
12654 13454 14254 15154 16000800 800 800 900 846
12654 13454 14254 15154 16000800 800 800 900 846
12654 13454 14254 15101 16000800 800 800 847 899 1
12654 13454 14254 15101 16000800 800 800 847 899
12646 13384 14215 15046 16000831 738 831 831 954 13
12628 13384 14206 15028 16000822 756 822 822 972 2
76