Spreadsheet: 102522d1300450490-sumproduct-and-iserror-daily-backlog-reasons
Sheet: Data Review

Work Centre | Requested | Reason Code |  |  |  |  |  | CODES
#N/A | 2011-03-15 00:00:00 | On Pick
3788VA14 | 2011-03-15 00:00:00 | 20 - Shortage VMI |  |  |  |  |  | On Pick
3788VA12 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain |  |  |  |  |  | 50 - Partial
3788VA12 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain |  |  |  |  |  | 45 - Open
3788VA15 | 2011-03-15 00:00:00 | On Pick |  |  |  |  |  | 30 - Awaiting Kitting
3788VA01 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain |  |  |  |  |  | 20 - Shortage Manufacturing
3788VA14 | 2011-03-15 00:00:00 | On Pick |  |  |  |  |  | 20 - Shortage Supply Chain
#N/A | 2011-03-15 00:00:00 |  |  |  |  |  |  | 20 - Shortage VMI
3788VA02 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain |  |  |  |  |  | JDE System
3788VA01 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain |  |  |  |  |  | Capacity
3788VA15 | 2011-03-15 00:00:00 | On Pick |  |  |  |  |  | Short Dated Order
3788VA02 | 2011-03-15 00:00:00 | 45 - Open
3788VA09 | 2011-03-15 00:00:00 | On Pick
3788VA09 | 2011-03-15 00:00:00 | On Pick
3788VA09 | 2011-03-15 00:00:00 | On Pick
3788VA15 | 2011-03-15 00:00:00 | On Pick
3785BD01 | 2011-03-15 00:00:00
3788VA13 | 2011-03-15 00:00:00 | 45 - Open
3788AD01 | 2011-03-15 00:00:00
3788AD01 | 2011-03-15 00:00:00
3788VA15 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788AD01 | 2011-03-15 00:00:00
3788AD01 | 2011-03-15 00:00:00
#N/A | 2011-03-15 00:00:00 | On Pick
3788VA12 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
#N/A | 2011-03-15 00:00:00 | On Pick
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA03 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA11 | 2011-03-15 00:00:00 | 45 - Open
3788VA11 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
#N/A | 2011-03-15 00:00:00 | On Pick
#N/A | 2011-03-15 00:00:00 | On Pick
3788VA13 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA13 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA12 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA13 | 2011-03-15 00:00:00 | 45 - Open
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA11 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA11 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA10 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA11 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
#N/A | 2011-03-15 00:00:00
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
#N/A | 2011-03-15 00:00:00
3788VA13 | 2011-03-15 00:00:00 | 45 - Open
#N/A | 2011-03-15 00:00:00 | On Pick
#N/A | 2011-03-15 00:00:00
3788VA09 | 2011-03-15 00:00:00 | 45 - Open
3788VA12 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
#N/A | 2011-03-15 00:00:00
#N/A | 2011-03-15 00:00:00 | On Pick
3788VA01 | 2011-03-15 00:00:00 | 20 - Shortage VMI
3788AD01 | 2011-03-15 00:00:00
3788AD01 | 2011-03-15 00:00:00
3788VA15 | 2011-03-15 00:00:00 | On Pick
3788AD01 | 2011-03-15 00:00:00
3788VA01 | 2011-03-15 00:00:00 | 20 - Shortage VMI
3788AD01 | 2011-03-15 00:00:00
3788VA11 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
#N/A | 2011-03-15 00:00:00 | On Pick
#N/A | 2011-03-15 00:00:00 | Short Dated Order
#N/A | 2011-03-15 00:00:00 | Short Dated Order
3788VA13 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA14 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA13 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA13 | 2011-03-15 00:00:00 | 20 - Shortage Manufacturing
3788VA14 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA14 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA03 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA03 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA03 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA13 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA12 | 2011-03-15 00:00:00 | 45 - Open
3788VA12 | 2011-03-15 00:00:00 | 45 - Open
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA14 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA12 | 2011-03-15 00:00:00 | 45 - Open
3788VA13 | 2011-03-15 00:00:00 | On Pick
3788VA03 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA12 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA12 | 2011-03-15 00:00:00 | 45 - Open
3788VA14 | 2011-03-15 00:00:00 | 20 - Shortage Manufacturing
3788VA12 | 2011-03-15 00:00:00 | 45 - Open
3788VA14 | 2011-03-15 00:00:00 | 20 - Shortage Manufacturing
3788VA12 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA03 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA03 | 2011-03-15 00:00:00 | JDE System
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA13 | 2011-03-15 00:00:00 | 45 - Open
3788VC01 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA15 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA13 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA14 | 2011-03-15 00:00:00 | 20 - Shortage Manufacturing
3788VA13 | 2011-03-15 00:00:00 | 20 - Shortage VMI
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
3788VA03 | 2011-03-15 00:00:00 | 20 - Shortage Manufacturing
3788VA11 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA12 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VC01 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA12 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA15 | 2011-03-15 00:00:00 | Short Dated Order
#N/A | 2011-03-15 00:00:00
3787VS01 | 2011-03-15 00:00:00
#N/A | 2011-03-15 00:00:00
#N/A | 2011-03-15 00:00:00
3787VS01 | 2011-03-15 00:00:00
#N/A | 2011-03-15 00:00:00 | Short Dated Order
3788AD01 | 2011-03-15 00:00:00
3788VA12 | 2011-03-15 00:00:00 | JDE System
3788VA02 | 2011-03-15 00:00:00 | On Pick
3788VA02 | 2011-03-15 00:00:00 | 50 - Partial
3788VA12 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA12 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA03 | 2011-03-15 00:00:00 | 45 - Open
#N/A | 2011-03-15 00:00:00 | Short Dated Order
#N/A | 2011-03-15 00:00:00 | Short Dated Order
3787VS01 | 2011-03-15 00:00:00
3787VS01 | 2011-03-15 00:00:00
3788VA13 | 2011-03-15 00:00:00 | 20 - Shortage VMI
3788VA01 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA01 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA02 | 2011-03-15 00:00:00 | 20 - Shortage Supply Chain
3788VA11 | 2011-03-15 00:00:00 | On Pick
3788VA14 | 2011-03-15 00:00:00 | 30 - Awaiting Kitting
3788VA11 | 2011-03-15 00:00:00 | 45 - Open
3788VA15 | 2011-03-15 00:00:00 | On Pick
3788AV01 | 2011-03-15 00:00:00 | On Pick
3788VA13 | 2011-03-16 00:00:00 | 45 - Open
3788VA13 | 2011-03-16 00:00:00 | 20 - Shortage Supply Chain
3788VA13 | 2011-03-16 00:00:00 | 45 - Open
3788VA13 | 2011-03-16 00:00:00 | On Pick
3788VA13 | 2011-03-16 00:00:00 | 30 - Awaiting Kitting
3788VA14 | 2011-03-16 00:00:00 | 45 - Open
3788VA14 | 2011-03-16 00:00:00 | 20 - Shortage VMI
3788VA14 | 2011-03-16 00:00:00 | 20 - Shortage VMI
#N/A | 2011-03-16 00:00:00 | Short Dated Order
3788VA02 | 2011-03-16 00:00:00 | On Pick
#N/A | 2011-03-16 00:00:00 | Short Dated Order
#N/A | 2011-03-16 00:00:00 | Short Dated Order
#N/A | 2011-03-16 00:00:00 | Short Dated Order