Spreadsheet: 151624d1335025739-excel-2007-help-with-spreadsheet-2012-dsis-by-month
Sheet: MAR TOTAL

Reported Date | CO Number | Parts Cost
1120312 | 913916 | 8.26
1120305 | 921784 | 8.33
1120315 | 923746 | 10.23
1120306 | 924736 | 92.51
1120309 | 924772 | 7.67
1120313 | 924772 | 7.67
1120301 | 924840 | 13.07
1120302 | 924941 | 9.57
1120301 | 925175 | 7.34
1120306 | 925344 | 10.23
1120301 | 925395 | 57.23
1120301 | 925396 | 7.34
1120306 | 925445 | 60.81
1120302 | 925451 | 9.57
1120306 | 925472 | 183.25
1120309 | 925624 | 11.46
1120306 | 925629 | 62.61
1120302 | 925801 | 8.26
1120308 | 925892 | 8.61
1120306 | 926006 | 11.36
1120305 | 926131 | 9.02
1120309 | 926326 | 131.43
1120309 | 926440 | 111.52
1120308 | 927005 | 8.26
1120308 | 927084 | 7.67
1120328 | 927216 | 7.67
1120314 | 927222 | 85.61
1120308 | 927616 | 8.26
1120314 | 927738 | 7.34
1120309 | 927768 | 148.33
1120308 | 927782 | 7.67
1120309 | 927783 | 148.33
1120314 | 927783 | 60.81
1120314 | 928199 | 7.67
1120313 | 928278 | 10.14
1120313 | 928332 | 12.42
1120314 | 928784 | 16.1
1120313 | 928806 | 55.56
1120319 | 929188 | 9.61
1120314 | 929717 | 9.61
1120314 | 929737 | 8.13
1120314 | 929843 | 11.5
1120319 | 930071 | 64.42
1120316 | 930317 | 10.81
1120316 | 930403 | 82.97
1120319 | 930592 | 15.73
1120320 | 930968 | 8.51
1120320 | 930970 | 19.66
1120328 | 931594 | 11.36
1120328 | 931621 | 8.26
1120328 | 932393 | 7.34
1120328 | 932398 | 10.66
1120328 | 932576 | 7.69
1120328 | 932958 | 7.34
1120328 | 933080 | 47.4
1120328 | 933767 | 12.2
Reported Date | CO Number or DSI CO Number | Shipping Cost | Total Cost | Picker | Packer | [NAME]'s | [NAME]'s | Error Type/Root Cause
1120312 | 899229 / 913916 | 6.44 |  | x |  |  | Forrace | Ord'd 2 ea 1014207; short 1 ea |  |  | Row Labels | Count of Name/'s2
1120312 | 921784 | 8.7 |  |  |  |  |  | Cust ord'd 8 each 1011843 but when recv'd lenses were clear not red. [NAME] |  |  | [NAME] | 1
1120305 | 923746 | 22 |  |  |  |  |  | Ordered 1ea:101811301 intake Duct and received a 101820201/ Inventory was mixed |  |  | [NAME] | 1
1120315 | 924736 | 7.34 |  |  |  |  |  | Ordered 1ea:101811301 intake Duct and received a 101820201/ Inventory was mixed |  |  | Calvin | 1
1120306 | 924772 | 1616 |  |  |  |  |  | [NAME] was missing items : missing p/n 8067; p/n 1015597 and p/n 8067 |  |  | [NAME] | 1
1120309 | 924772 | 0.31 |  |  |  |  |  | [NAME] was missing items : missing p/n 8067; p/n 1015597 and p/n 8068 |  |  | G. Price | 1
1120313 | 924840 | 0.21 |  |  |  |  |  | Cust picked up another Cust order. |  |  | [NAME] | 1
1120301 | 921945 / 924941 | 67.86 |  |  | x |  | [NAME] | p/n AM1241201 damaged. |  |  | Valdis | 1
1120302 | 925175 / 923101 | 18.14 |  |  | x |  | [NAME] | Short on qty packed |  |  | [NAME] | 1
1120301 | 925344 | 0.13 |  |  |  |  |  | Boxes were not properly labeled |  |  | (blank) | 28
1120306 | 923494 / 925395 | 763.56 |  |  | x |  | [NAME] | Cust ord'd 20 each 102534404 but only recv'd 16. |  |  | [NAME] | 6
1120301 | 923388 / 925396 | 21.04 |  |  | x |  | [NAME] | Cust ord'd 4 each 101973701 but only recv'd 2. |  |  | [NAME] | 1
1120301 | 917777 / 925445 | 6.37 |  |  | x |  | [NAME] | Rec'd 10 ea 102502407 rear bodies stacked on top of each other in one box that was on a pallet. 1 body broken;3 scratched/scuffed seriously.  4 with minor scratches that may be buffed out. |  |  | [NAME] | 3
1120306 | 923101 / 925451 | 80.47 |  | x |  |  | Lorenzo | Cust ord'd 3 each 103351001 but recv'd 3 each 102267301 instead. |  |  | Dennis | 1
1120302 | 921252 / 925472 | 15.05 |  |  | x |  | [NAME] | Box mixed with 922252 and labels added incorrectly |  |  | Forrace | 1
1120306 | 925624 | 185.42 |  |  |  |  |  | Invoicing Error |  |  | [NAME] | 2
1120309 | 925629 / 922252 | 35.95 |  |  |  |  |  | Shipped to wrong location |  |  | Jamone M | 1
1120306 | 925801 / 920831 | 288.12 |  |  |  |  |  | Inventory Mixed |  |  | [NAME] | 1
1120302 | 925892 | 9.17 |  |  |  |  |  | Our Inventory is Correct |  |  | L Marshall | 1
1120308 | 926006 | 33.68 |  |  |  |  |  | Past 30 day's (orders shipped 011612) |  |  | Lorenzo | 3
1120306 | 926131 | 50.17 |  | x |  |  |  | Picker pulled from wrong location |  |  | [NAME] | 1
1120305 | 926326 | 6.61 |  |  |  |  |  | Our Inventory is Correct |  |  | [NAME] | 2
1120309 | 926440 | 240.68 |  |  |  |  |  | Our Inventory is Correct |  |  | [NAME] | 1
1120309 | 927005 | 2082.75 |  |  |  |  |  | [NAME] |  |  | Unknown | 1
1120308 | 927084 | 9.17 |  |  |  |  |  | Kint missing parts |  |  | [NAME] | 1
1120308 | 927216 | 11.15 |  |  |  |  |  | Our Inventory is Correct |  |  | [NAME] | 2
1120328 | 927222 / 919863 | 103.55 |  | x | x | [NAME] | [NAME] | Picker/ packer  short on Qty. |  |  | (blank)
1120314 | 927616 / 920845 | 17.74 |  | x | x | Valdis | [NAME] | Picker/ packer  short on Qty. |  |  | Grand Total | 32
1120308 | 927738 | 27.5 |  | x | x |  |  | picker short on qty's.
1120314 | 927768 | 3.02 |  |  |  |  |  | Inventory Mixed
1120309 | 927782 / 926249 | 231.13 |  | x | x | G. Price | [NAME] | Missing parts off of order
1120308 | 927783 / 932146 | 4.84 |  |  | x |  | [NAME] | Parts Damaged/Scratched
1120309 | 927783 | 68.02 |  |  | x |  | [NAME] | Parts Scratched
1120314 | 928199 / 926308 | 20.12 |  | x |  |  | Jamone M | picker error picked wrong part
1120314 | 928278 / 926639 | 3.71 |  |  | x |  | [NAME] | packer error part damaged
1120313 | 928332 / 926989 | 2.5 |  | x | x | Calvin | [NAME] | short on qty's picker/packer
1120313 | 928784 | 77.86 |  |  |  |  | Unknown | Unknown
1120314 | 928806 / 927067 | 110.94 |  |  | x |  | [NAME] | Parts broken
1120313 | 929188 / 924937 | 94.49 |  | x |  |  | Lorenzo | picker short on qty's.
1120319 | 929717 / 925161 | 5.98 |  | x |  |  | [NAME] | picker short on qty's.
1120314 | 929737 / 921688 | 11.07 |  | x |  |  | Lorenzo | picker short on qty's.
1120314 | 929843 / 927299 | 0.35 |  |  | x |  | [NAME] | packer error part damaged
1120314 | 930071 | 11.68 |  |  |  |  |  | Picker parts are on 9dock, qty. 18
1120319 | 930317 | 1497.6 |  |  |  |  |  | Our Inventory is Correct
1120316 | 930403 / 928306 | 7.85 |  | x |  |  | Dennis | Picker pulled from wrong location
1120316 | 930592 / 926265 | 536.93 |  |  | x |  | [NAME] | packer error part damaged
1120319 | 930968 | 84.98 |  |  |  |  |  | Parts mixed, locating error
1120320 | 930970 / 917723 | 17.95 |  |  | x |  | L Marshall | Parts were damaged
1120320 | 931594 / 928153 | 87.17 |  | x |  |  | [NAME] | picker error picked wrong part and qty.
1120328 | 931621 / 929383 | 112.19 |  | x |  |  | [NAME] | Picker   short on Qty.
1120328 | 932393 / 928733 | 1.27 |  |  | x |  | [NAME] | packer error part damaged
1120328 | 932398 / 930249 | 3.62 |  | x |  |  | [NAME] | picker pulled wrong part
1120328 | 932576 / 929125 | 32.92 |  | x |  |  | [NAME] | picker pulled wrong part
1120328 | 932958 / 928618 | 6.31 |  | x |  |  | [NAME] | Picker   short on Qty.
1120328 | 933080 / 932104 | 0.01 |  | x |  |  | [NAME] | picker pulled wrong part
1120328 | 933767 | 4.54 |  |  |  |  |  | Parts returned, they were dirty parts rejected.
1120328 | 933767 | 13.22 |  |  |  |  |  | Parts returned, they were dirty parts rejected.