Spreadsheet: 83326d1283327655-gantt-chart-labour-tool-2
Sheet: PLAN

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GIC
 |  |  |  |  | PASTE PLAN HERE |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  | NOTES |  | THEORECTICAL EFFICIENCY |  |  |  | offset |  |  |  |  |  |  | FAWEMA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan based on 2 shift pattern and 70% line efficiency |  |  |  |  |  |  |  |  |  |  |  |  | FLAT 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLAT 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  |  |  |  |  |  | HPL9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HPL10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SANKO
 | î |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Line | PRIORITY | SKU | Product | PLAN | PACK [NAME] (kg) | [NAME] (100%) |  |  |  | EFFICIENCY |  | HRS REQUIRED | Rounded up to next 15 mins |  | Line | PRIORITY | RUN ORDER |  |  | RUN time required (hrs:min) | START TIME | FINISH TIME |  |  |  |  |  |  |  |  | CHANGEOVER(hrs) | TOTAL TIME
 |  |  |  |  |  |  |  | [NAME] | kg / min | tph | tps | % | tph |  |  |  |  |  |  |  |  |  |  |  |  | DOWN TIME | TU | WED | TH | FR | SAT | SUN |  |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS
 |  | HPL9 |  | 32171 | HALF SPOON 10X1KG |  | 1 |  |  |  |  |  |  |  |  |  | HPL9 | 1
 |  |  |  | 32173 | HALF SPOON DOLLY 416 X 1KG |  | 1 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 32175 | HALF SPOON UDP 320 X 1KG |  | 1 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  | 1 | 32193 | LIGHT PARCEL 10 X 750G | 60 | 0.75 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | 33310 | CASTER 10X1KG |  | 1 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | 33514 | PRESERVING 10X1KG |  | 1 |  |  |  |  |  |  |  |  |  |  | 6
 |  | Total 072 H9 LOW CAL
 |  | HPL10 |  | 32197 | LIGHT 2X3X375G |  | 0.375 |  |  |  |  |  |  |  |  |  | HPL10 | 1
 |  |  |  | 33216 | GRANULATED 10X500G AZUCAR |  | 0.5 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | 2 | 33219 | GRANULATED 10X500G | 50 | 0.5 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  | 33231 | HALF SPOON 10X500G |  | 0.5 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  | 1 | 33378 | CASTER 10X500G | 60 | 0.5 |  |  |  |  |  |  |  |  |  |  | 5
 |  | Total 072 HPL10 500G
 |  | FLAT | 1F1 | 32322 | [NAME] 1000 | 9.36 | 3 |  |  |  |  |  |  |  |  |  | FLAT 1 | 1
 |  |  |  | 32327 | [NAME] |  | 3 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 32448 | STARBUCKS DEM SACHET 3G |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  | 2F2 | 34311 | S/SPOON WHITE SACHET 600 | 2.4 | 1.5 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | 34312 | S/SPOON WHITE SACHET 1000 |  | 2.5 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | 34313 | S/SPOON WHITE SACHET 2000 |  | 5 |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  | 34316 | S/SPOON DEM SACHET 600 |  | 1.5 |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  | 34317 | S/SPOON DEM SACHET 1000 |  | 2.5 |  |  |  |  |  |  |  |  |  |  | 8
 |  |  | 1F2 | 34318 | S/SPOON DEM SACHET 2000 | 2.1 | 5 |  |  |  |  |  |  |  |  |  |  | 9
 |  | Total 072 FLAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLAT 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  | FAWEMA | 2 | 33061 | GRANULATED 6X2KG | 200 | 2 |  |  |  |  |  |  |  |  |  | FAWEMA | 1
 |  |  | 1 | 33168 | 2KG DOLLY (216 X 2KG) | 150 | 2 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 33284 | 180 X 2KG GRAN ASDA MU PALLET |  | 2 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  | 33381 | CASTER 6X2KG (RETAIL) |  | 2 |  |  |  |  |  |  |  |  |  |  | 4
 |  | Total 072 FAWEMA2KG
 |  | GIC | 1 | 33083 | GRANULATED 5KG | 20 | 5 |  |  |  |  |  |  |  |  |  | GIC | 1
 |  |  |  | 33094 | GRANULATED 10KG |  | 10 |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | 33194 | CASTER 10KG |  | 10 |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  | 55067 | 10KG BRAKES GRANULATED |  | 10 |  |  |  |  |  |  |  |  |  |  | 4
 |  | Total 072 5&10KG
 |  | SANKO | 1 | 32382 | MCDONALDS STICK 7.5KG | 4.95 | 7.5 |  |  |  |  |  |  |  |  |  | SANKO | 1
 |  | Total 072 STICK
7
8
9
10