Spreadsheet: 139577d1328309291-find-closest-match-quantity-breaks-in-pricing-speadsheet-find-closest-match-pricing-spreadsheet
Sheet: Sheet1

Item | Description | Sales Last 12 mnts | No Orders | Ave order size | [NAME] | Units | Break 1: | Current Price | Previous Price | Var | Break 2: | Current Price | Previous Price | Var | Break 3: | Current Price | Previous Price | Var | Break 4: | Current Price | Previous Price | Var | Break 5: | Current Price | Previous  Price | Var
CPPNA-842 | 842 PP Compound Natural | 19102 | 15 | 1273.466666666667 |  | [NAME] | 1000 | 3.54 | 3.54 | 0
MLDBL-18868 | 18868 LD Masterbatch Purple | 406 | 5 | 81.2 |  | [NAME] | 20 | 29.35 | 29.35 | 0 | 40 | 23.5 | 23.5 | 0 | 60 | 21.5 | 21.5 | 0 | 100 | 19.25 | 19.25 | 0 | 200 | 17.5 | 17.5 | 0
MLDMT-98311 | 98311 LDPE Masterbatch Pink Pearl |  |  |  |  | [NAME] | 25 | 29.35 | 29.35 | 0 | 50 | 23.53 | 23.53 | 0 | 75 | 21.58 | 21.58 | 0
MLDMT-98312 | 98312 LDPE Masterbatch Magenta Pearl |  |  |  |  | [NAME] | 25 | 33.75 | 33.75 | 0 | 50 | 27.92 | 27.92 | 0 | 75 | 25.97 | 25.97 | 0
MLDRE-48624 | 48624 LDPE Masterbatch Lazy Pink |  |  |  |  | [NAME] | 25 | 24.72 | 24.72 | 0 | 50 | 18.88 | 18.88 | 0 | 75 | 16.93 | 16.93 | 0
MLDRE-48889 | 48889 LD Masterbatch Magenta Hexachrome | 272.3 | 4 | 68.075 |  | [NAME] | 20 | 38 | 38 | 0 | 40 | 32 | 32 | 0 | 60 | 29.95 | 29.95 | 0 | 100 | 28.5 | 28.5 | 0 | 200 | 26.25 | 26.25 | 0
MLLBL-18479 | 18479 LL Masterbatch Purple | 49.6 | 1 | 49.6 |  | [NAME] | 25 | 39.75 | 39.75 | 0 | 50 | 33.92 | 33.92 | 0
MLLRE-48288 | 48288 [NAME] 179c Red |  |  |  |  | [NAME] | 25 | 26.77 | 26.77 | 0
MLLRE-48705 | 48705 LLDPE Masterbatch Pink PMS219c | 122.5 | 2 | 61.25 | 219c | [NAME] | 20 | 34.38 | 34.38 | 0 | 40 | 28.14 | 28.14 | 0 | 60 | 26.05 | 26.05 | 0 | 80 | 25.01 | 25.01 | 0
[NAME] | 48885 LL Masterbatch Red | 100 | 10 | 10 |  | [NAME] | 20 | 30.5 |  |  | 40 | 24 |  |  | 60 | 22
MLLYE-37218 | 37218 LL Masterbatch PMS 1235C Yellow |  |  |  |  | [NAME] | 15 | 35.98 | 35.98 | 0
MPPBL-18536 | 18536 PP Masterbatch Macy Blue |  |  |  |  | [NAME] | 20 | 23.5 | 23.5 | 0 | 50 | 17.07 | 17.07 | 0
MPPGR-28339 | 28339 PP Masterbatch Green Clip |  |  |  |  | [NAME] | 20 | 35.01 | 35.01 | 0 | 25 | 32.44 | 32.44 | 0 | 50 | 27.31 | 27.31 | 0 | 75 | 25.59 | 25.59 | 0
MPPMT-98124 | 98124 PP MBX Magenta Gold 305 Sistema |  |  |  |  | [NAME] | 25 | 32.17 | 32.17 | 0 | 50 | 26.78 | 26.78 | 0
MPPRE-48767 | 48767 PP Masterbatch Red Bowl | 225 | 5 | 45 | Red bowl | [NAME] | 25 | 28.76 | 28.4 | 0.01267605633802817 | 50 | 23.38 | 23 | 0.01652173913043479 | 100 | 20.69 | 20.35 | 0.01670761670761671 | 250 | 19.08 | 17.35 | 0.09971181556195953 | 500 | 18.54 | 16.1 | 0.1515527950310559
MPPRE-48768 | 48768 PP Masterbatch Red Clip |  |  |  | Red Clip | [NAME] | 25 | 29.95 |  |  | 50 | 24.55 |  |  | 100 | 22 |  |  | 250 | 18.9 |  |  | 500 | 17.3
MPSBL-18365 | 18365 PS Mbx Hanger Label Blue (GP60117) |  |  |  |  | [NAME] | 50 | 20.28 | 19.54 | 0.03784092937563973 | 100 | 15.62 | 15.01 | 0.04048281479014009
MPSGR-28301 | 28301 PS Masterbatch Clip Lime |  |  |  |  | [NAME] | 50 | 18.19 | 17.16 | 0.05977355944055943
[NAME] | 48399 HIPS [NAME] (GP30093) |  |  |  |  | [NAME] | 50 | 25.54 | 23.48 | 0.08785592589437805 | 100 | 21.01 | 19.75 | 0.06401446632911388
MPSYE-37300 | 37300 HIPS Orange Lable (GP20111) |  |  |  |  | [NAME] | 50 | 18.51 | 17.31 | 0.06913152281917985
MPSYE-37303 | 37303 PS Masterbatch Yellow (GP20114) |  |  |  |  | [NAME] | 50 | 19.7 | 18.45 | 0.06775067750677508