Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

create a powerpoint slide based on this data - basically how did i find this data and what does it mean

1 answer below »
Step 1 - Bucket Sales By Mo (2)
    EX)    Part No.    Desciption    Sales Qty    Date    Month bucket        Negative Quantity Items:
        123        100    12/4/24    12         XXXXXXXXXX    SCREW, 5/16"-18, X 3", STRAP, VESSEL, 316    RAW    -96    4/26/24    4
        123        50    10/4/24    10         XXXXXXXXXX    SHAFT SLEEVE VPXP-80X178, 100X178    RAW    -1    12/22/23    12
        123        25    5/4/24    5
    Item number    Product name    Item Group    Quantity    Confirmed ship date    Month bucket
     XXXXXXXXXX    ITEMS FOR FLUSHING for RACK & MANIFOLD, 24 PX, CUSTOM    RAW    1    5/12/23    5
     XXXXXXXXXX    CRATE, PX, XL, W/ LABOR    RAW    10    12/6/24    12
     XXXXXXXXXX    CRATE, MEDIUM    RAW    2    11/29/24    11
     XXXXXXXXXX    RING, LOCK, SEGMENT, 8"    RAW    50    11/14/24    11
     XXXXXXXXXX    SCREW, SOCKET-HEAD, 5/16"-18, X .75", 316    RAW    1    10/30/24    10
     XXXXXXXXXX    SCREW, SOCKET-HEAD, 5/16"-18, X 1.25", 316    RAW    20    9/24/24    9
     XXXXXXXXXX    SCREW, HEX-HEAD, 5/8"-11, X .5", NYLON    RAW    50    11/14/24    11
     XXXXXXXXXX    WASHER, FLAT, SEALING, 5/8" ID, EPDM    RAW    24    10/17/24    10
     XXXXXXXXXX    RING, SECURING, 65 SERIES, GRP    RAW    60    12/13/24    12
     XXXXXXXXXX    PLATE, BEARING, PORT, THREADED, 4", PX-Q300    RAW    2    12/5/24    12
     XXXXXXXXXX    INTERCONNECT, 2-1/2", TITANIUM    RAW    4    12/5/24    12
     XXXXXXXXXX    PORT, STRAIGHT, LP, 4" SERIES, 2507    RAW    6    12/5/24    12
     XXXXXXXXXX    PLATE, SEAL, 4" PORT, THREADED    RAW    2    12/5/24    12
     XXXXXXXXXX    RING, THRUST, PX-Q300    RAW    2    12/5/24    12
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE P, 6", 100 PSI, GFRP    RAW    2    12/13/23    12
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE DS, 4", 1200 PSI, 2507    RAW    6    11/27/24    11
     XXXXXXXXXX    GUARD, COUPLING, BARREL, 16.43" X 16.5"-26"    RAW    2    3/21/23    3
     XXXXXXXXXX    MOTOR, 700HP, 5500V, 50HZ, 400, ABB    RAW    2    3/21/23    3
     XXXXXXXXXX    NIPPLE, LOW PRESSURE, 65 SERIES, TITANUM    RAW    2    11/18/24    11
     XXXXXXXXXX    PLATE, BEARING, 65 SERIES, ALU    RAW    25    11/14/24    11
     XXXXXXXXXX    PLATE, SEAL, 65 SERIES, GRP    RAW    2    11/26/24    11
     XXXXXXXXXX    RING, LOCK, PORT, 65 SERIES, AL6XN    RAW    24    9/20/24    9
     XXXXXXXXXX    SCREW, SOCKET-HEAD, 5/16"-18, X 1.0", 316    RAW    30    9/20/24    9
     XXXXXXXXXX    PORT, 90 DEG, 3 X 2.5, 65 SERIES, IC, AL6XN    RAW    1    10/28/24    10
     XXXXXXXXXX    PORT, STRAIGHT, 3 X 2.5, 65 SERIES, IC, AL6XN    RAW    4    9/30/24    9
     XXXXXXXXXX    KIT, SPARE PARTS, VP-4671    RAW    1    3/27/23    3
     XXXXXXXXXX    CRATE, PX, M, W/ LABOR    RAW    1    9/27/24    9
     XXXXXXXXXX    PX-Q300, RACKS & MANIFOLD, CUSTOM    RAW    2    10/8/24    10
     XXXXXXXXXX    CRATE, XSMALL    RAW    3    12/2/24    12
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE DS, 2", 1200 PSI, 2507    RAW    4    4/22/24    4
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE DS, 1.5", 1200 PSI, 2507    RAW    2    11/5/24    11
     XXXXXXXXXX    CRADLE, AQUABOLD, 2X3X5, CARBON STEEL    RAW    2    3/23/23    3
     XXXXXXXXXX    CRATE, LARGE    RAW    1    12/6/24    12
     XXXXXXXXXX    SEAL, MECHANICAL, TYPE 1, 1.875", SHAFT, JOHN CRANE    RAW    1    9/13/24    9
     XXXXXXXXXX    MOTOR, 500HP, 460V, 60HZ, F1, 5011LS, GE    RAW    1    4/12/23    4
     XXXXXXXXXX    MOTOR, 250HP, 460V, 60HZ, F1, 447/9TSC, GE, SPECIAL    RAW    2    6/2/23    6
     XXXXXXXXXX    DIFFUSER, INLET, HP-PUMP, 2400    RAW    1    9/30/24    9
     XXXXXXXXXX    BEARING, JOURNAL, HP-PUMP, AL6XN    RAW    3    9/30/24    9
     XXXXXXXXXX    SLEEVE, IMPELLER, HP-2400, HP-PUMP, AL6XN    RAW    2    9/11/24    9
     XXXXXXXXXX    CRATE, SMALL    RAW    1    12/4/24    12
     XXXXXXXXXX    CRATE, AQUABOLD, SKID, MEDIUM    RAW    1    5/13/24    5
     XXXXXXXXXX    SLEEVE, INTERSTAGE, MACHINED, AQUABOLD, 4X6X9, 2205    RAW    2    6/26/24    6
     XXXXXXXXXX    KEY, AQUABOLD, 4X6X9, 2205    RAW    3    6/26/24    6
     XXXXXXXXXX    SEAL, MECHANICAL, TYPE 1, 2.25", SHAFT, JOHN CRANE    RAW    2    8/30/24    8
     XXXXXXXXXX    SLEEVE, BEARING, SPACER, MACHINED, AQUABOLD, 4X6X9    RAW    1    6/26/24    6
     XXXXXXXXXX    SLEEVE, RETAINING, MACHINED, AQUABOLD, 4X6X9, 2205    RAW    1    6/26/24    6
     XXXXXXXXXX    NUT, NYLOCK, 1"-8, 2507    RAW    1    6/26/24    6
     XXXXXXXXXX    COUPLING, SHAFT, RIGID, STEPPED, 5/8" X 1-5/8", HP-PUMP, TIT    RAW    1    10/11/24    10
     XXXXXXXXXX    SCREW, SOCKET-HEAD, 5/16"-24, X 1.0", 316    RAW    8    9/11/24    9
     XXXXXXXXXX    COUPLING, SHAFT, RIGID, STEPPED, 5/8" X 1-1/8", HP-PUMP, TIT    RAW    1    11/12/24    11
     XXXXXXXXXX    SCREW, SOCKET-HEAD, 1/4"-28, X .75", 316    RAW    16    11/12/24    11
     XXXXXXXXXX    DIFFUSER, MACHINED, AQUABOLD, 4X6X9, A, 2205    RAW    1    6/4/24    6
     XXXXXXXXXX    SET-SCREW, SOCKET-HEAD, 1/2"-13, X .5", FLAT POINT, 2205    RAW    6    9/30/24    9
     XXXXXXXXXX    CRATE, AQUABOLD, 4X6X9, SMALL    RAW    2    6/4/24    6
     XXXXXXXXXX    O-RING, CASE, VP-347, VP-467    RAW    2    9/27/24    9
     XXXXXXXXXX    O-RING, GLAND, RETAINER, VP    RAW    2    9/27/24    9
     XXXXXXXXXX    IMPELLER, INSERT, BEARING, VP    RAW    1    11/22/24    11
     XXXXXXXXXX    KIT, REPAIR, SEAL, VP    RAW    4    9/27/24    9
     XXXXXXXXXX    CARRIER, BEARING, IMPELLER, VP-PUMP    RAW    1    8/14/24    8
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE P, 4", 225 PSI, GFRP    RAW    8    8/16/24    8
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE DS, 3", 1200 PSI, 2507    RAW    8    11/15/24    11
     XXXXXXXXXX    RING, THRUST, 65 SERIES, PVC    RAW    2    10/28/24    10
     XXXXXXXXXX    END-CAP, MACHINED, AT-350, PUMP, 2205    RAW    1    2/17/23    2
     XXXXXXXXXX    KIT, CONTROLS HARDWARE, PX G1300    RAW    1    3/14/23    3
     XXXXXXXXXX    KIT, MECHANICAL SEAL, VPXP, 2507    RAW    1    9/27/24    9
     XXXXXXXXXX    KIT, BEARING, VPXP    RAW    2    12/8/23    12
     XXXXXXXXXX    IMPELLER, MACHINED, A, AQUABOLD, 3X4X7, 2205    RAW    12    11/13/23    11
     XXXXXXXXXX    SLEEVE, INTERSTAGE, MACHINED, AQUABOLD, 3X4X7, 2205    RAW    16    9/24/24    9
     XXXXXXXXXX    DIFFUSER, MACHINED, AQUABOLD, 3X4X7, B, 2205    RAW    2    11/13/23    11
     XXXXXXXXXX    DIFFUSER, MACHINED, AQUABOLD, 3X4X7, B, RADIAL-POS, 2205    RAW    1    2/16/23    2
     XXXXXXXXXX    DIFFUSER, MACHINED, AQUABOLD, 3X4X7, B, FINAL, 2205    RAW    1    5/12/23    5
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE P, 3", 250 PSI, GFRP    RAW    4    9/26/24    9
     XXXXXXXXXX    COUPLING, SHAFT, FLEXIBLE, N-EUPEX, 5", 2.250 X 80MM    RAW    2    3/21/23    3
     XXXXXXXXXX    BOLT, HEX-HEAD, 5/8"-11, X 1", 316    RAW    8    3/21/23    3
     XXXXXXXXXX    MANIFOLD, CENTER, 4S SERIES, GRP    RAW    1    11/21/24    11
     XXXXXXXXXX    CRATE, AQUABOLD, 2X3X5/3X4X7, LARGE    RAW    2    10/31/24    10
     XXXXXXXXXX    CRATE, XLARGE    RAW    1    11/1/24    11
     XXXXXXXXXX    PLATE, SEAL, HP-PUMP, AL6XN    RAW    1    11/15/24    11
     XXXXXXXXXX    KEY, CUT, 3/16" SQ, X 1.00", SHAFT, HP-PUMP, 316    RAW    3    10/11/24    10
     XXXXXXXXXX    RING, SECURING, 4" SERIES, GRP    RAW    2    11/26/24    11
     XXXXXXXXXX    PORT, SIDE, 2", 4 SERIES, DUAL, AL6XN    RAW    10    9/30/24    9
     XXXXXXXXXX    BEARING, RADIAL, END, THRUST, AQUABOLD, 4X6X9, GRAPHITE M-14    RAW    2    6/26/24    6
     XXXXXXXXXX    NUT, IMPELLER, VP-347, VP-467    RAW    1    8/14/24    8
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE P, 1.5", 250 PSI, GFRP    RAW    2    11/5/24    11
     XXXXXXXXXX    SHAFT, VP-467    RAW    1    8/14/24    8
     XXXXXXXXXX    CASE, WEAR RING, VP-467    RAW    1    8/14/24    8
     XXXXXXXXXX    IMPELLER, VP-PUMP, VP-467    RAW    1    8/14/24    8
     XXXXXXXXXX    BEARING, THRUST, HP-PUMP, 15-20HP, LEESON    RAW    5    11/27/24    11
     XXXXXXXXXX    END-CAP, FINISHED, IC, HP-PUMP, AL6XN    RAW    1    10/3/24    10
     XXXXXXXXXX    CRATE, AQUABOLD, 2X3X5/3X4X7, MEDIUM    RAW    1    11/13/23    11
     XXXXXXXXXX    SCREW, SOCKET-HEAD, 1/4"-20, X .62", 316    RAW    12    11/15/24    11
     XXXXXXXXXX    CASE, WEAR RING, VP-347    RAW    2    11/6/24    11
     XXXXXXXXXX    FITTING, STRAIGHT, 1" X 3/4", NPT, 2507    RAW    4    2/24/23    2
     XXXXXXXXXX    BEARING, RADIAL, DRIVE-END, AQUABOLD, 3X4X7    RAW    2    3/1/24    3
     XXXXXXXXXX    CRATE, AQUABOLD, 2X3X5/3X4X7, SMALL    RAW    1    2/23/24    2
     XXXXXXXXXX    SCREW, HEX-HEAD, 1/2"-13, X 1.25", 316    RAW    4    4/30/24    4
     XXXXXXXXXX    SCREW, HEX-HEAD, 3/8"-16, X 1.25", 316    RAW    4    4/30/24    4
     XXXXXXXXXX    BEARING, BACK, 15-20HP, LEESON, HP-PUMP    RAW    1    8/6/24    8
     XXXXXXXXXX    FAN, REPLACEMENT, 15 HP, 20 HP, MOTORS    RAW    1    10/3/24    10
     XXXXXXXXXX    COVER, ACCESS, 4" SERIES, DUAL, GRP    RAW    1    11/26/24    11
     XXXXXXXXXX    MOTOR, 400HP, 460V, 60HZ, F1, 5011LS, GE    RAW    1    4/26/23    4
     XXXXXXXXXX    HOUSING, SUCTION, IC, HP-PUMP, AL6XN    RAW    1    10/11/24    10
     XXXXXXXXXX    MOTOR, 7.5HP, 380V/50HZ, 460V/60HZ, 213TC, B34R, TECO, CE    RAW    1    3/6/23    3
     XXXXXXXXXX    TOOL, ASSY, AT-250, UHMW    RAW    1    3/23/23    3
     XXXXXXXXXX    O-RING, EPDM, 014    RAW    6    9/23/24    9
     XXXXXXXXXX    SLEEVE, SHAFT, SEAL, HP-PUMP, AL6XN    RAW    2    11/13/24    11
     XXXXXXXXXX    RING, RETAINING, SHAFT, .625", 276    RAW    10    11/15/24    11
     XXXXXXXXXX    RING, RETAINING, SHAFT, .750", 276    RAW    10    11/15/24    11
     XXXXXXXXXX    BEARING, RADIAL, END, AQUABOLD, 3X4X7    RAW    1    4/30/24    4
     XXXXXXXXXX    COUPLING, PUMP HUB, VP    RAW    1    7/14/23    7
     XXXXXXXXXX    COUPLING, MOTOR, LG, HUB, VP    RAW    1    7/14/23    7
     XXXXXXXXXX    THRUST RING, VP    RAW    1    7/14/23    7
     XXXXXXXXXX    RING KEY, MOTOR, LG, HUB, VP    RAW    1    7/14/23    7
     XXXXXXXXXX    BEARING, RADIAL, DRIVE-END, AQUABOLD, 4X6X9    RAW    2    6/26/24    6
     XXXXXXXXXX    RING, SPIRAL, WH, 337, HASTELLOY    RAW    2    6/26/24    6
     XXXXXXXXXX    FAN, REPLACEMENT, 7.5HP, MOTOR, GE    RAW    5    3/15/23    3
     XXXXXXXXXX    KIT, O-RING, ATMP    RAW    2    12/15/23    12
     XXXXXXXXXX    CRATE, PX, L, W/ LABOR    RAW    1    12/6/24    12
     XXXXXXXXXX    BEARING, THRUST, HP-PUMP, 7.5-10HP, GE    RAW    2    4/2/24    4
     XXXXXXXXXX    CRATE, AQUABOLD, SKID, SMALL    RAW    1    3/2/23    3
     XXXXXXXXXX    CRATE, PX, S, W/ LABOR    RAW    1    11/27/24    11
     XXXXXXXXXX    COUPLING, SHAFT, RIGID, STEPPED, 5/8" X 1-3/8", HP-PUMP, TIT    RAW    1    11/11/24    11
     XXXXXXXXXX    WASHER, LOCK, 1/2" ID, 316    RAW    4    4/30/24    4
     XXXXXXXXXX    MOTOR, 15HP, 380V/50HZ, 460V/60HZ, 254TC, B34R, TECO    RAW    1    4/12/23    4
     XXXXXXXXXX    WASHER, FLAT, 1/2" ID, .875" OD, 18-8    RAW    8    8/9/24    8
     XXXXXXXXXX    WASHER, FLAT, 3/8" ID, 316    RAW    4    4/30/24    4
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE DS, 1.25", 1200 PSI, 2507    RAW    1    6/23/23    6
     XXXXXXXXXX    RING, THRUST, SIDE-PORT    RAW    1    9/24/24    9
     XXXXXXXXXX    MOTOR, 5HP, 380V/50HZ, 460V/60HZ, 184TC, B34R, TECO    RAW    1    7/6/24    7
     XXXXXXXXXX    MOTOR, 10HP, 380V/50HZ, 460V/60HZ, 215TC, B34R, TECO    RAW    1    11/12/24    11
     XXXXXXXXXX    CRATE, AQUABOLD, 4X6X9, LARGE    RAW    1    3/13/24    3
     XXXXXXXXXX    COUPLING, SHAFT, FLEXIBLE, N-EUPEX, 5", 1.875 X 2.375    RAW    1    6/30/23    6
     XXXXXXXXXX    DOWEL, PIN, 1/8" DIA, X 3/8", 316    RAW    4    3/28/24    3
     XXXXXXXXXX    DOWEL, PIN, 3/16" DIA, X 3/8", 316    RAW    4    3/28/24    3
     XXXXXXXXXX    SLEEVE, RETAINING, MACHINED, AQUABOLD, 3X4X7, 2205    RAW    1    9/24/24    9
     XXXXXXXXXX    MOTOR, 20HP, 380V/50HZ, 460V/60HZ, 256TC, B34R, TECO    RAW    1    10/3/23    10
     XXXXXXXXXX    RING, SPIRAL, WHT, 575, HASTELLOY    RAW    1    7/12/23    7
     XXXXXXXXXX    VFD, WEG CFW500A04P3T4NB20 + CFW500-KN1A    RAW    1    5/3/24    5
     XXXXXXXXXX    CRATE, SHIPPING, PUMP, WOOD    RAW    1    12/11/23    12
     XXXXXXXXXX    MOTOR, 250HP, 460V, 60HZ, F1, 447/9TS, GE    RAW    1    8/31/23    8
     XXXXXXXXXX    BEARING, BACK, 5HP, GE, HP-PUMP    RAW    2    12/14/23    12
     XXXXXXXXXX    BEARING, THRUST, HP-PUMP, 5HP, GE    RAW    2    1/24/24    1
     XXXXXXXXXX    BUSHING, SLEEVE, HP-PUMP, RULON    RAW    4    5/28/24    5
     XXXXXXXXXX    COUPLING, SHAFT, FLEXIBLE, N-EUPEX, 5", 2.250 X 70MM    RAW    1    6/16/23    6
     XXXXXXXXXX    BEARING, BACK, 10HP, GE, HP-PUMP    RAW    2    4/2/24    4
     XXXXXXXXXX    MOTOR, 125HP, 460V, 60HZ, F1, 444/5TS, GE    RAW    1    10/31/23    10
     XXXXXXXXXX    SCREW, 5/16"-18, X 3", STRAP, VESSEL, 316    RAW    -96    4/26/24    4
     XXXXXXXXXX    STRAP, VESSEL, SIDE PORT, 8"    RAW    20    5/2/24    5         XXXXXXXXXX    SHAFT SLEEVE VPXP-80X178, 100X178    RAW    -1    12/22/23    12
     XXXXXXXXXX    DOWEL, PULL, 3/4" DIA, X 5-1/4", 2205    RAW    1    10/9/23    10
     XXXXXXXXXX    SPARE PARTS, RACK & MANIFOLD, 18PX, CUSTOM    RAW    1    10/6/23    10
     XXXXXXXXXX    CASING WEAR RING 106/126 DIA. X 11, PEEK    RAW    1    11/3/23    11
     XXXXXXXXXX    CRATE, AQUABOLD, SKID, LARGE    RAW    1    10/31/23    10
     XXXXXXXXXX    SHAFT, AQUABOLD, 3X4X7-19, TYPE 1 SEAL, 2205    RAW    1    9/5/23    9
     XXXXXXXXXX    SLEEVE, RETAINING, MACHINED, AQUABOLD, 3X4X7, 2507    RAW    2    4/30/24    4
     XXXXXXXXXX    PIN, ANTIROLL, HALO, XXXXXXXXXX    RAW    1    10/15/24    10
     XXXXXXXXXX    KIT, O-RING, AT-250    RAW    4    8/31/23    8
     XXXXXXXXXX    SPARE PARTS, RACK & MANIFOLD, 12PX, CUSTOM    RAW    1    3/15/24    3
     XXXXXXXXXX    SPARE PARTS, RACK & MANIFOLD, 24PX, CUSTOM    RAW    1    3/6/24    3
     XXXXXXXXXX    FLUSHING, RACK & MANIFOLD, 24 PX, CUSTOM    RAW    2    3/6/24    3
     XXXXXXXXXX    MOTOR, 500HP, 380V, 50HZ, F1, 588/9TS, WEG    RAW    1    12/6/23    12
     XXXXXXXXXX    SCREW, SOCKET-HEAD, 5/16"-18, X 1.50", 316    RAW    12    2/5/24    2
     XXXXXXXXXX    NIPPLE, LOW PRESSURE, 3.445", 4S SERIES, TI    RAW    1    4/24/24    4
     XXXXXXXXXX    IMPELLER, MACHINED, B, AQUABOLD, 3X4X7, 2507    RAW    2    4/30/24    4
     XXXXXXXXXX    RING, SPIRAL, WH, 287, HASTELLOY    RAW    2    7/26/23    7
     XXXXXXXXXX    PX-Q300, RACK & MANIFOLD, 4PX, CUSTOM    RAW    3    4/26/24    4
     XXXXXXXXXX    MOTOR, 20HP, 440V, 60HZ, F1, GE, SPECIAL    RAW    1    11/16/23    11
     XXXXXXXXXX    BEARING, RADIAL, END, AQUABOLD, 2X3X5    RAW    1    6/24/24    6
     XXXXXXXXXX    IMPELLER, MACHINED, C, AQUABOLD, 2X3X5, 2205    RAW    2    4/15/24    4
     XXXXXXXXXX    KEY, CUT, 1/4" SQ, AQUABOLD, 3X4X7, 2205    RAW    2    11/22/24    11
     XXXXXXXXXX    SLEEVE, BEARING SPACER, MACHINED, AQUABOLD, 3X4X7, 2205    RAW    1    9/24/24    9
     XXXXXXXXXX    DIFFUSER, MACHINED, AQUABOLD, 2X3X5, C, 2507    RAW    1    2/21/24    2
     XXXXXXXXXX    SEAL, MECHANICAL, TYPE 1, 1.75", SHAFT, JOHN CRANE    RAW    1    9/16/24    9
     XXXXXXXXXX    KEY, PUMP, COUPLNG, AQUABOLD, 2X3X5, 2205    RAW    1    2/21/24    2
     XXXXXXXXXX    IMPELLER, VP-PUMP, VP-347    RAW    1    11/30/23    11
     XXXXXXXXXX    SHAFT SLEEVE VPXP-80X178, 100X178    RAW    -1    12/22/23    12
     XXXXXXXXXX    RING, VPXP-80X178    RAW    1    11/8/23    11
     XXXXXXXXXX    PIN, ANTIROLL, AT-250/875, 316    RAW    1    11/16/23    11
     XXXXXXXXXX    LABEL, "MADE IN U.S.A."    RAW    1000    11/14/24    11
     XXXXXXXXXX    LABEL, "HP OUT"    RAW    1000    11/14/24    11
     XXXXXXXXXX    LABEL, "HP IN"    RAW    1000    11/14/24    11
     XXXXXXXXXX    LABEL, "LP IN"    RAW    1000    11/14/24    11
     XXXXXXXXXX    LABEL, PX-Q300    RAW    1000    11/14/24    11
     XXXXXXXXXX    LABEL, ERI LOGO, 65 SERIES    RAW    1000    11/14/24    11
     XXXXXXXXXX    LABEL, "WARNING", 65 SERIES    RAW    1000    11/14/24    11
     XXXXXXXXXX    BASE, AQUASPIRE, 900, 449TSC    RAW    1    1/17/24    1
     XXXXXXXXXX    LABEL, "LP OUT"    RAW    1000    11/14/24    11
     XXXXXXXXXX    MOTOR, 300HP, 460V, 60HZ, F1, 447/9TS, GE, SPECIAL    RAW    1    5/13/24    5
     XXXXXXXXXX    RING, SPIRAL, WH, 200, PASSIVATED, 316    RAW    1    11/16/23    11
     XXXXXXXXXX    SUB-CONTRACT, INSPECTION SERVICES    RAW    1    11/17/23    11
     XXXXXXXXXX    FITTING, 90 DEG, 3/8" X 1/4", NPT, 2507    RAW    1    12/13/23    12
     XXXXXXXXXX    MOTOR, 7.5HP, 380V/50HZ, 460V/60HZ, 213TC, B34R, TECO    RAW    1    11/3/23    11
     XXXXXXXXXX    BEARING, BACK, 7.5-10HP, GE, HP-PUMP    RAW    1    11/3/23    11
     XXXXXXXXXX    DOWEL, PIN, 3/16" DIA, X 1/2", 316    RAW    1    8/6/24    8
     XXXXXXXXXX    RING, SPIRAL, WH-725, 316    RAW    1    8/6/24    8
     XXXXXXXXXX    DOWEL, PIN, 1/4" DIA, X 1/2", 316    RAW    1    8/6/24    8
     XXXXXXXXXX    RING, SPIRAL, WH-950, 316    RAW    1    8/6/24    8
     XXXXXXXXXX    SHAFT, VP-347    RAW    1    3/19/24    3
     XXXXXXXXXX    O-RING, EPDM, 249    RAW    1    9/22/23    9
     XXXXXXXXXX    RING, SPIRAL, WH, 293, PASSIVATED, 316    RAW    1    11/29/23    11
     XXXXXXXXXX    MOTOR, VPXP-80X178, 22KW, 460V, 60HZ    RAW    2    11/28/23    11
     XXXXXXXXXX    MOTOR, 125HP, 380V, 50HZ, F1, 444/5TS, GE    RAW    1    2/15/24    2
     XXXXXXXXXX    KIT, MECHANICAL SEAL, ATMP    RAW    2    4/23/24    4
     XXXXXXXXXX    KIT, COUPLING, SPLINE, ATMP    RAW    1    3/8/24    3
     XXXXXXXXXX    PORT, END, 1-1/2", 4 SERIES, IC, AL6XN    RAW    2    8/21/24    8
     XXXXXXXXXX    NIPPLE, LOW PRESSURE, 3.313", 4S SERIES, TI    RAW    2    11/11/24    11
     XXXXXXXXXX    STANDOFF, TENS, 1.95", 4S SERIES, 276    RAW    2    8/21/24    8
     XXXXXXXXXX    SHAFT, AQUABOLD, 3X4X7-18, TYPE 1 SEAL, 2205    RAW    1    3/25/24    3
     XXXXXXXXXX    NAMEPLATE, ATMP, SPEC.    RAW    2    6/21/24    6
     XXXXXXXXXX    MOTOR, 350HP, 380V, 50HZ, F1, 5011LS, GE    RAW    1    4/2/24    4
     XXXXXXXXXX    DIFFUSER, BOWL, PUMP, 2400, NORYL    RAW    4    12/13/23    12
     XXXXXXXXXX    RING, SPIRAL, WH, 387, PASSIVATED, 316    RAW    2    2/20/24    2
     XXXXXXXXXX    NIPPLE, LOW PRESSURE, 3.563", 4S SERIES, AL6XN    RAW    2    8/21/24    8
     XXXXXXXXXX    BEARING, THRUST, LPT-1000    RAW    2    11/13/24    11
     XXXXXXXXXX    SHELL, CONTAINMENT, AQUABOLD, 4X6X9-5, 2205    RAW    1    6/4/24    6
     XXXXXXXXXX    HOUSING, MACHINED, SUCTION, AQUABOLD, 4X6X9, TYPE 1, 2205    RAW    1    6/4/24    6
     XXXXXXXXXX    FITTING, PLUG, 3/8", PIPE, 2507    RAW    6    6/4/24    6
     XXXXXXXXXX    END-CAP, MACHINED, AQUABOLD, 4X6X9    RAW    1    6/4/24    6
     XXXXXXXXXX    SET-SCREW, SOCKET-HEAD, 3/4"-10, X 5/8", FLAT POINT, 2205    RAW    12    6/26/24    6
     XXXXXXXXXX    FITTING, PLUG, 3/4", PIPE, NPT, 2507    RAW    6    6/4/24    6
     XXXXXXXXXX    NUT, HEAVY HEX, 3/4"-10, PTFE COATED (2H)    RAW    36    6/26/24    6
     XXXXXXXXXX    KIT, MECHANICAL SEAL, VPXP, SPECIAL    RAW    2    3/22/24    3
     XXXXXXXXXX    SHAFT, SLEEVE VPXP, SPECIAL    RAW    1    3/22/24    3
     XXXXXXXXXX    NUT, NYLOCK, 3/4"-10, 2507    RAW    2    4/15/24    4
     XXXXXXXXXX    NUT, NYLOCK, 7/8"-9, 2507    RAW    3    4/30/24    4
     XXXXXXXXXX    SLEEVE, INTERSTAGE, AQUABOLD, 3X4X7, 2507    RAW    3    4/30/24    4
     XXXXXXXXXX    WASHER, 3/8" ID, .005" THK, 316    RAW    10    3/7/24    3
     XXXXXXXXXX    PIN, ANTIROLL, HALO-900, 2507    RAW    1    5/30/24    5
     XXXXXXXXXX    PX-Q400, RACK & MANIFOLD, CUSTOM    RAW    6    9/6/24    9
     XXXXXXXXXX    CASE, MACHINED, AT-350, 2507    RAW    1    5/23/24    5
     XXXXXXXXXX    SET-SCREW, SOCKET-HEAD, 5/8"-11, X 5/8", CUP POINT, 2205    RAW    16    9/2/24    9
     XXXXXXXXXX    END-CAP, MACHINED, AQUABOLD, 3X4X7, 2205    RAW    1    6/17/24    6
     XXXXXXXXXX    LABEL, PX-Q400    RAW    2    4/16/24    4
     XXXXXXXXXX    STUD, 5/8"-11, X 2-3/4", 316    RAW    8    6/26/24    6
     XXXXXXXXXX    NUT, HEAVY HEX, 5/8"-11, 316    RAW    16    6/26/24    6
     XXXXXXXXXX    NUT, HEAVY HEX, 1"-8, 316    RAW    8    6/26/24    6
     XXXXXXXXXX    NUT, JAM, 1"-8, 316    RAW    8    6/26/24    6
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE HS, 1.5", 2000 PSI, 2507    RAW    6    7/29/24    7
     XXXXXXXXXX    COUPLING, PIPE, GROOVED, STYLE HS, 2", 2000 PSI, 2507    RAW    2    7/29/24    7
     XXXXXXXXXX    MOTOR, 100HP, 380V, 60HZ, F1, 404/5TSC, GE, SPECIAL    RAW    1    6/28/24    6
     XXXXXXXXXX    PX G1300 CONTROLLER, CAREL, BL3    RAW    1    6/21/24    6
     XXXXXXXXXX    STUD, 1/2"-13, X 3-1/2", 316    RAW    16    8/9/24    8
     XXXXXXXXXX    SET-SCREW, SOCKET-HEAD, 3/8"-16, X .5", FLAT POINT, 2205    RAW    8    9/30/24    9
     XXXXXXXXXX    RING, SPIRAL, WH, 275, PASSIVATED, 316    RAW    1    9/30/24    9
     XXXXXXXXXX    KIT, ASSY., BEARING, THRUST, W/SHAFT, ATMP, 2205    RAW    1    9/16/24    9
     XXXXXXXXXX    RING, SPIRAL, WHT, 237, PASSIVATED, 316    RAW    2    9/3/24    9
     XXXXXXXXXX    RING, SPIRAL, WH, 250, PASSIVATED, 316    RAW    2    9/3/24    9
     XXXXXXXXXX    ITEMS FOR FLUSHING, RACKS & MANIFOLD, CUSTOM    RAW    1    7/31/24    7
     XXXXXXXXXX    KEY, CUT, 1/8" SQ, X 1/2", 2205    RAW    10    9/26/24    9
     XXXXXXXXXX    RING, SPIRAL, WH, 275, HASTELLOY    RAW    1    6/24/24    6
     XXXXXXXXXX    COUPLING, SHAFT, FLEXIBLE, A035, 5", 1.750 X 75MM    RAW    4    8/30/24    8
     XXXXXXXXXX    TAG, AQUABOLD    RAW    1    8/7/24    8
     XXXXXXXXXX    FITTING, PLUG, 1/4", PIPE, 2507    RAW    1    10/4/24    10
     XXXXXXXXXX    SEAL, MECHANICAL,TYPE 1B, 1.875", SHAFT, JOHN CRANE    RAW    1    10/4/24    10
     XXXXXXXXXX    STUD, 5/8"-11, X 3", PTFE COATED (B7)    RAW    24    10/4/24    10
     XXXXXXXXXX    NUT, HEAVY HEX, 5/8"-11, PTFE COATED (2H)    RAW    24    10/4/24    10
     XXXXXXXXXX    FITTING, STRAIGHT, 3/8" X 3/8", NPT, 2507    RAW    1    10/4/24    10
     XXXXXXXXXX    PLATE, SEAL, 65 SERIES, PVC,
Answered 1 days After Jan 25, 2025

Solution

Khushboo answered on Jan 25 2025
3 Votes
Under step 1, we have put all data in excel with their item number, Product Name, Item group, Quantity and confirmed ship date and we have calculated respective month for each shipped item.
Under step 2, we made a pivot table based on item wise for each month and calculated quantity for each month in columnar format.
Post that we have calculated average and monthly maximum demand for each item by putting formula in excel.
We have also calculated Standard deviation for each month demand for each item by putting standard deviation formula in excel.
Under step 3, we have calculated lead time in days and months for each item. Basis monthly max demand time requirement the average lead time for average monthly demand has been reduced and we have calculated safety stock level.
Further, safety stock at level 2 has also been calculated by multiplying lead time * average monthly demand.
The analysis of sales demand per month and top 10 demanding items are as follows:
Steps to followed for safety stock requirement
Top 10 demanding items
Qty    
LABEL, "MADE IN U.S.A."    LABEL, "HP OUT"    LABEL, "HP IN"    LABEL, "LP IN"    LABEL, PX-Q300    LABEL, ERI LOGO, 65 SERIES    LABEL, "WARNING", 65 SERIES    LABEL, "LP OUT"    RING, LOCK, SEGMENT, 8"    SCREW, HEX-HEAD, 5/8"-11, X .5", NYLON    RING, SECURING, 65 SERIES, GRP    1000    1000    1000    1000    1000    1000    1000    1000    50    50    60    
Monthly Average Highest Demanding items
Monthly Average    SCREW, SOCKET-HEAD, 5/16"-18, X 1.0", 316    SCREW, HEX-HEAD, 5/8"-11, X .5", NYLON    LABEL, "HP OUT"    LABEL, "HP IN"    LABEL, "LP OUT"    LABEL, "LP IN"    LABEL, "MADE IN U.S.A."    LABEL, "WARNING", 65 SERIES    LABEL, ERI LOGO, 65 SERIES    LABEL, PX-Q300    PLATE, BEARING, 65 SERIES, ALU    RING, SECURING, 65 SERIES, GRP    RING, LOCK, SEGMENT, 8"    NUT, HEAVY HEX, 3/4"-10, PTFE COATED (2H)    2.5    4.166666666666667    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    83.333333333333329    2.0833333333333335    5    4.166666666666667    3    
    Item number    Product name    Quantity    Month bucket    AVG Monthly Demand    Max Monthly...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here