Spreadsheet: 374628d1422920208-need-help-calculating-fill-rate-fill-rate-example
Sheet: Cust. Shortage

OrderNo | ItemNo | Desc1 | Pack | Brand | CustName | CustCity | Inv. Date | Salesperson |  | Amt Ordered | Amt Shipped | Amt On Hand | Amt Commit | Order/Item
858255 | 6206015 | 4/6 OZ GROUPER FILLETS | 1/10 LB | PACKERS | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-04-05 00:00:00 | [NAME] |  | 12 | 10 | 4037.49 | 0
858255 | 6206018 | 6/8 OZ GROUPER FILLETS | 4/10 LB | SEA BEST | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-04-05 00:00:00 | [NAME] |  | 20 | 16 | 5290.72 | 0
870001 | 6300601 | 4/6 OZ SNAPPER FILLET | 1/10 LB | SEA BEST | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-06-21 00:00:00 | [NAME] |  | 25 | 16 | 5331.42 | 40
874408 | 6300601 | 4/6 OZ SNAPPER FILLET | 1/10 LB | SEA BEST | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-07-19 00:00:00 | [NAME] |  | 25 | 20 | 792.45 | 760
881163 | 6300601 | 4/6 OZ SNAPPER FILLET | 1/10 LB | SEA BEST | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-08-30 00:00:00 | [NAME] |  | 30 | 11 | 154.24 | 165
883771 | 6300601 | 4/6 OZ SNAPPER FILLET | 1/10 LB | SEA BEST | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-09-13 00:00:00 | [NAME] |  | 25 | 7 | 75.58 | 77
892073 | 6300601 | 4/6 OZ SNAPPER FILLET | 1/10 LB | SEA BEST | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-11-08 00:00:00 | [NAME] |  | 25 | 12 | 125.65 | 132
897365 | 6300601 | 4/6 OZ SNAPPER FILLET | 1/10 LB | SEA BEST | ALBERTSON'S/SUPERVALU (MELROSE) | MELROSE PARK | 2012-12-14 00:00:00 | [NAME] |  | 25 | 14 | 141.69 | 154
861625 | 7524476 | RET BAG JUMBO SCALLOPS | 12/1 LB | SEA BEST | ASSOC. GROCERS OF NEW ENGLAND | PEMBROKE | 2012-04-26 00:00:00 | [NAME] |  | 25 | 0 | 0 | 0
871204 | 7524476 | RET BAG JUMBO SCALLOPS | 12/1 LB | SEA BEST | ASSOC. GROCERS OF NEW ENGLAND | PEMBROKE | 2012-06-30 00:00:00 | [NAME] |  | 25 | 21 | 0.49 | 0
876706 | 7524476 | RET BAG JUMBO SCALLOPS | 12/1 LB | SEA BEST | ASSOC. GROCERS OF NEW ENGLAND | PEMBROKE | 2012-08-02 00:00:00 | [NAME] |  | 25 | 13 | 138.96 | 143
895376 | 7524476 | RET BAG JUMBO SCALLOPS | 12/1 LB | SEA BEST | ASSOC. GROCERS OF NEW ENGLAND | PEMBROKE | 2012-11-29 00:00:00 | [NAME] |  | 25 | 13 | 130.28 | 143
896358 | 7524476 | RET BAG JUMBO SCALLOPS | 12/1 LB | SEA BEST | ASSOC. GROCERS OF NEW ENGLAND | PEMBROKE | 2012-12-06 00:00:00 | [NAME] |  | 60 | 0 | 417 | 50
846432 | 6003060 | SALT MACKEREL FILLETS | 12/12 OZ | SEAPRO | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-01-30 00:00:00 | [NAME] |  | 80 | 0 | 363 | 50
848777 | 6003060 | SALT MACKEREL FILLETS | 12/12 OZ | SEAPRO | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-02-13 00:00:00 | [NAME] |  | 60 | 0 | 473 | 50
851044 | 6003060 | SALT MACKEREL FILLETS | 12/12 OZ | SEAPRO | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-02-27 00:00:00 | [NAME] |  | 60 | 0 | 371 | 50
851044 | 6604845 | 16/22 WHL BOILED CRAWFISH | 2/5 LB | NO BRAND | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-02-27 00:00:00 | [NAME] |  | 30 | 20 | 0 | 0
851044 | 7206215 | CKD SHRIMP RINGS- 10 OZ | 8/10 OZ | SEA BEST | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-02-27 00:00:00 | [NAME] |  | 16 | 0 | 1 | 0
851044 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-02-27 00:00:00 | [NAME] |  | 16 | 0 | 0 | 0
852461 | 6604845 | 16/22 WHL BOILED CRAWFISH | 2/5 LB | NO BRAND | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-03-06 00:00:00 | [NAME] |  | 8 | 5 | 0 | 0
852461 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-03-06 00:00:00 | [NAME] |  | 8 | 0 | 20 | 20
853533 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-03-14 00:00:00 | [NAME] |  | 49 | 48 | 0 | 0
854580 | 6604709 | 100/150 CRAFISH MEAT F/ON | 12/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-03-21 00:00:00 | [NAME] |  | 60 | 58 | 0 | 0
854580 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-03-21 00:00:00 | [NAME] |  | 6 | 0 | 49 | 20
855751 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-03-26 00:00:00 | [NAME] |  | 20 | 13 | 0 | 0
856952 | 6604709 | 100/150 CRAFISH MEAT F/ON | 12/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-02 00:00:00 | [NAME] |  | 20 | 19 | 0 | 0
856952 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-02 00:00:00 | [NAME] |  | 25 | 0 | 415 | 230
858206 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-09 00:00:00 | [NAME] |  | 25 | 23 | 0 | 0
859186 | 6604709 | 100/150 CRAFISH MEAT F/ON | 12/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-16 00:00:00 | [NAME] |  | 32 | 31 | 345 | 180
859186 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-16 00:00:00 | [NAME] |  | 1 | 0 | 0 | 0
860207 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-23 00:00:00 | [NAME] |  | 2 | 0 | 0 | 0
861279 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-30 00:00:00 | [NAME] |  | 1 | 0 | 0 | 0
861279 | 7527780 | RET BAG TILAPIA FILLETS | 10/2 LB | SEA BEST | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-04-30 00:00:00 | [NAME] |  | 1 | 0 | 0 | 0
863642 | 6604845 | 16/22 WHL BOILED CRAWFISH | 2/5 LB | NO BRAND | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-05-14 00:00:00 | [NAME] |  | 1 | 0 | 0 | 0
863642 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-05-14 00:00:00 | [NAME] |  | 110 | 109 | 0 | 0
864695 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-05-21 00:00:00 | [NAME] |  | 6 | 0 | 128 | 26
865840 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-05-29 00:00:00 | [NAME] |  | 1 | 0 | 20 | 20
867088 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-06-04 00:00:00 | [NAME] |  | 8 | 0 | 20 | 0
867667 | 6604845 | 16/22 WHL BOILED CRAWFISH | 2/5 LB | NO BRAND | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-06-11 00:00:00 | [NAME] |  | 62 | 61 | 0 | 0
867667 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-06-11 00:00:00 | [NAME] |  | 50 | 20
867667 | 7518981 | RET BOX V/P TILAPIA FILL | 5/3 LB | SEA BEST | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-06-11 00:00:00 | [NAME] |  | 40 | 30 | 0 | 0
868590 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-06-18 00:00:00 | [NAME] |  | 135 | 111 | 1230 | 1000
869858 | 6604845 | 16/22 WHL BOILED CRAWFISH | 2/5 LB | NO BRAND | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-06-25 00:00:00 | [NAME] |  | 40 | 22 | 0 | 0
869858 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-06-25 00:00:00 | [NAME] |  | 24 | 0 | 0 | 0
870924 | 6604845 | 16/22 WHL BOILED CRAWFISH | 2/5 LB | NO BRAND | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-07-02 00:00:00 | [NAME] |  | 48 | 0 | 1020 | 0
870924 | 7402008 | [NAME] MEAT | 20/1 LB | PACKERS | ASSOC. GROCERS OF THE SOUTH,INC. | BIRMINGHAM | 2012-07-02 00:00:00 | [NAME] |  | 48 | 34 | 340 | 340