Spreadsheet: 102041d1300111507-calculation-problem-database
Sheet: critical original UPDATED

DAILY CRITICAL LIST AS ON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 615 |  | Minutes per day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | VFA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Working hrs per day |  |  |  |  |  |  |  |  | CONSUMPTION VERSION-WISE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALCULATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PG-5 |  |  |  |  |  |  |  | stock/(prod*60/min p.day) |  |  |  |  |  |  |  |  | SB-308 |  |  |  | RA-410 |  | SF-410 |  | RS-413 |  |  | RH-413/416 |  |  |  |  | ST308R |  |  |  | ST308V
PART DESCRIPTION | SYSTEM STOCK | Item Code | 2nd  Item Code | 3rd  Item Code | WORKING AREA |  |  | Total | MODEL | VENDOR | MATERIAL WISE | VERSION WISE | SHOP WISE | QTY / VEHICLE | AREA WISE | MATERIAL SECTTION | PG-1 | PG-2 | PG-3 | PG-4 | PG-5 | LAST DAY RTI | PID PASSED & REJECT | PENDING DI,S QTY | TOTAL SCHEDULE (MAR) | INV IN HOURS | SAFETY STOCK | MTD-PROD VARIANCE |  |  |  |  | NOR |  | CNG |  | NOR | CNG | NOR | CNG | NOR |  | CNG | NOR |  |  | CNG |  | NOR | EXPORT |  | CNG | NOR |  |  | CNG |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SAFETY STOCK ERP | SAFETY DAYS | APR SAFETY STOCK
 |  |  |  |  | 1 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VX | VXR | VX | VXR | VXR | VXR | VXR | VXR | DLX | DX | DX | RXI | LXI | AXI | RXI | LXI |  | WO/D | W/D |  | VX | VXR | CGO | VX | VXR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170 | 171 | 174 | 176 | 145 | 195 | 224 | 226 | 241 | 242 | 243 | 152 | 162 | 183 | 153 | 164 | 232 | 239 | 251 | 233 | 235 | 237 | 248 | 236 | 238 |  | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK | PROD (REQ) | SCH | RCVD | ACT.STK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP
PART DESCRIPTION |  | item code | Second  item code | Third  item code |  |  |  | Total
COVER COMP,EXHAUST MANIFOLD | `14-03-2011 | 605114 |  |  |  |  |  |  | STR,STV | AB ENGG | SHT | E | ENGN | 1 | KHI |  | PG-3 |  |  |  |  | 800 | 0 | 0 | 2800 |  | 400 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 0 | 800 | 1221 |  | 100 | 0 | 1901 |  | 0 | 0 |  |  | 200 | 0 | 1683 |  | 0 | 0 |  |  | 300 | 0 | 1480 |  | 0 | 0 |  |  | 200 | 0 |  |  | 0 | 0 | 1113 |  | 300 | 0 |  |  | 0 | 800 |  |  | 200 | 0 | 1589 |  | 0 | 0 |  |  | 300 | 0 |  |  | 0 | 0 |  |  | 200 | 0 |  |  | 0 | 0 |  |  | 400 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 200 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | * |  | 1
BRACKET COMP,ENGINE FRONT,R | `14-03-2011 | 605065 |  |  |  |  |  |  | STR,STV | COSMOS ENGG | SHT | V-NOR | ENGN | 1 | KHI |  | PG-2 |  |  |  |  | 36 | 0 | 14 | 550 |  | 80 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 0 |  |  | 0 | 0 | 376 |  | 0 | 0 | 302 |  | 0 | 0 |  |  | 0 | 0 | 284 |  | 0 | 0 |  |  | 50 | 0 | 270 |  | 0 | 0 |  |  | 50 | 100 |  |  | 0 | 0 | 352 |  | 0 | 0 |  |  | 50 | 36 |  |  | 50 | 0 | 386 |  | 0 | 0 |  |  | 50 | 0 |  |  | 0 | 0 |  |  | 100 | 0 |  |  | 0 | 0 |  |  | 100 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | * |  | 2
ARM & BLADE ASSY,WIPER,DR | `14-03-2011 | 650005 |  |  |  |  |  |  | RA | AUTOMOTIVE SP/JAWED MTL | SHT | V | VFA | 1 | KHI |  | PG-5 | PG-1 |  |  |  | 120 | 0 | 0 | 1440 |  | 190 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 416 |  | 0 | 0 | 331 |  | 0 | 0 |  |  | 0 | 120 | 174 |  | 0 | 0 |  |  | 180 | 40 | 201 |  | 60 | 60 |  |  | 60 | 60 |  |  | 120 | 140 | 201 |  | 60 | 60 |  |  | 120 | 120 |  |  | 60 | 0 | 370 |  | 60 | 0 |  |  | 60 | 0 |  |  | 60 | 0 |  |  | 60 | 0 |  |  | 60 | 0 |  |  | 60 | 0 |  |  | 60 | 0 |  |  | 60 | 0 |  |  | 60 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | * |  | 3
ARM & BLADE ASSY,WIPER,AS | `14-03-2011 | 650006 |  |  |  |  |  |  | RA | AUTOMOTIVE SP/JAWED MTL | SHT | V | VFA | 1 | KHI |  | PG-5 | PG-1 |  |  |  | 60 | 0 | 0 | 1440 |  | 190 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 403 |  | 0 | 0 | 318 |  | 60 | 0 |  |  | 0 | 180 | 161 |  | 60 | 60 |  |  | 120 | 100 | 308 |  | 60 | 60 |  |  | 120 | 120 |  |  | 60 | 80 | 428 |  | 60 | 60 |  |  | 60 | 60 |  |  | 60 | 0 | 477 |  | 60 | 0 |  |  | 60 | 0 |  |  | 120 | 0 |  |  | 0 | 0 |  |  | 60 | 0 |  |  | 120 | 0 |  |  | 0 | 0 |  |  | 120 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | * |  | 4
RADIATOR ASSY | `14-03-2011 | 620851 |  |  |  |  |  |  | SB | [NAME] | SHT | V | VFA | 1 | KHI |  | PG-3 |  |  |  |  | 85 | 0 | 145 | 1350 |  | 220 |  |  |  |  |  | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 20 | 581 |  | 60 | 60 | 475 |  | 95 | 95 |  |  | 85 | 85 | 367 |  | 105 | 105 |  |  | 125 | 125 | 372 |  | 0 | 0 |  |  | 0 | 0 |  |  | 30 | 80 | 203 |  | 85 | 0 |  |  | 195 | 85 |  |  | 100 | 0 | 116 |  | 100 | 0 |  |  | 100 | 0 |  |  | 90 | 0 |  |  | 80 | 0 |  |  | 100 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | * |  | 5
ROD ASSY,[NAME] | `14-03-2011 | 650527 |  |  |  |  |  |  | RA | AB ENGG | SHT | V | VFA | 1 | KHI |  | PG-3 |  |  |  |  | 0 | 0 | 144 | 1395 |  | 180 |  |  |  |  |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 404 |  | 0 | 0 | 319 |  | 0 | 0 |  |  | 90 | 0 | 162 |  | 0 | 0 |  |  | 105 | 55 | 69 |  | 0 | 50 |  |  | 165 | 90 |  |  | 0 | 60 | 104 |  | 165 | 126 |  |  | 0 | 0 |  |  | 120 | 0 | 139 |  | 0 | 0 |  |  | 120 | 0 |  |  | 0 | 0 |  |  | 105 | 0 |  |  | 0 | 0 |  |  | 195 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 105 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  | * |  | 6