Scribd Logo
Upload

Welcome to Scribd!

    • 29 views

    3M Sales Format

    Uploaded by

    Elsa_Tee_Siew__5508
    This document contains stock information for office supplies over a one week period. It includes the daily beginning balance, sales, and ending balance for 12 different stock keeping units (SKUs) such as Post-It notes, glue sticks, and tape. The data is organized into tables with columns showing the date, SKU information, stock levels, and other metrics for monitoring inventory levels like replenishment needs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    3M Sales Format

    Uploaded by

    Elsa_Tee_Siew__5508
    29 views10 pages
    This document contains stock information for office supplies over a one week period. It includes the daily beginning balance, sales, and ending balance for 12 different stock keeping units (SKUs) such as Post-It notes, glue sticks, and tape. The data is organized into tables with columns showing the date, SKU information, stock levels, and other metrics for monitoring inventory levels like replenishment needs.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains stock information for office supplies over a one week period. It includes the daily beginning balance, sales, and ending balance for 12 different stock keeping units (SKUs) such as Post-It notes, glue sticks, and tape. The data is organized into tables with columns showing the date, SKU information, stock levels, and other metrics for monitoring inventory levels like replenishment needs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    29 views10 pages

    3M Sales Format

    Uploaded by

    Elsa_Tee_Siew__5508
    This document contains stock information for office supplies over a one week period. It includes the daily beginning balance, sales, and ending balance for 12 different stock keeping units (SKUs) such as Post-It notes, glue sticks, and tape. The data is organized into tables with columns showing the date, SKU information, stock levels, and other metrics for monitoring inventory levels like replenishment needs.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 10

    Sheet2 PROJECT: DURATION/DATE: OUTLET: DAY/DATE SKUs

    3M Post It Note 3x3 100's 654 P/Green 3M Post It Note 3x3 100's 654 P/Blue 3M Post It Note 3x3 100's 654 P/yellow 3M Post It Note 3x3 100's 654 P/Pink 3M Post It Flags 680 asst col 3M Scotch Glue Stick 7gm 2 in 1 White+Purple SCOTCH STAT TAPE 12MMX30Y-6 ROLLS SCOTCH STAT TAPE 18MMX30Y-4 ROLLS SCOTCH STAT TAPE 24MMX30Y-3 ROLLS SCOTCH STAT TAPE 48MMX30YARD SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Blue SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Pink SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Black SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Grey

    27/05/2011

    PRICE
    rm3.10 rm3.10 rm3.10 rm3.10 Rm5.70 Rm3.99 Rm4.00 Rm4.00 Rm2.1 Rm7.85 Rm7.85 Rm7.85 Rm7.85

    HMS

    GE

    Remarks:

    Booth Location: SSO - Sellling Stock Observation:

    HMS = Homeshelf FS = Fullshelf IN = In stock Page 1 HS = Halfshelf REP = Replenishment

    Sheet2

    fri BD HMS IN 80 84 26 85 350 23 18 22 0 58 18 13 12 11 GE REP 0 0 0 0 0 0 0 0 0 0 0 0 0 BD BAL 80 83 26 83 342 23 16 20 0 57 15 12 12 10 SALES 0 1 0 2 8 0 2 2 0 1 3 1 0 1 HMS IN 80 83 26 83 342 23 16 20 0 57 15 12 12 10 GE REP

    Sat BD BAL 80 82 24 83 330 22 20 16 0 55 14 11 10 10 SALES 0 1 2 0 12 1 0 4 0 2 1 1 2 0

    TOTAL SALES 0 2 2 2 20 1 2 6 0 3 4 2 2 1

    HS = Halfshelf

    L = Low

    OOS = Out Of Stock

    REP = Replenishment Page 2

    Sheet3 PROJECT: DURATION/DATE: OUTLET: DAY/DATE SKUs


    3M Post It Note 3x3 100's 654 P/Green 3M Post It Note 3x3 100's 654 P/Blue 3M Post It Note 3x3 100's 654 P/yellow 3M Post It Note 3x3 100's 654 P/Pink 3M Post It Flags 680 asst col 3M Scotch Glue Stick 7gm 2 in 1 White+Purple SCOTCH STAT TAPE 12MMX30Y-6 ROLLS SCOTCH STAT TAPE 18MMX30Y-4 ROLLS SCOTCH STAT TAPE 24MMX30Y-3 ROLLS SCOTCH STAT TAPE 48MMX30YARD SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Blue SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Pink SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Black SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Grey

    PRICE
    rm3.10 rm3.10 rm3.10

    HMS

    GE

    rm3.10
    Rm5.70

    Rm3.99
    Rm4.00 Rm4.00 Rm2.1 Rm7.85 Rm7.85 Rm7.85 Rm7.85

    Remarks:

    HMS = Homeshelf Booth Location: FS = Fullshelf SSO - Sellling Stock Observation: IN = In stock REP = Replenishment HS = Halfshelf

    Page 3

    Sheet3

    Sun BD HMS GE IN REP 80 0 82 0 24 0 83 0 342 0 23 0 0 20 0 16 0 0 0 55 0 0 18 0 13 0 12 0 11

    mon BD HMS GE BAL SALES IN REP 79 1 79 80 2 80 22 2 22 82 1 82 339 3 339 23 0 23 0 0 0 20 0 20 14 2 14 0 0 0 50 5 50 0 0 0 7 12 6 12 13 10 3 10 11 1 11 1 11 0 11 BD BAL SALES 78 1 80 0 20 2 80 2 330 9 23 0 0 0 20 0 12 2 0 0 50 0 0 7 22 3 8 2 11 1 11 0

    TOTAL SALES 2 2 4 3 12 0 0 0 4 0 7 9 5 2

    HS = Halfshelf

    L = Low

    OOS = Out Of Stock

    REP = Replenishment

    Page 4

    Sheet4 PROJECT: DURATION/DATE: OUTLET: DAY/DATE SKUs


    3M Post It Note 3x3 100's 654 P/Green 3M Post It Note 3x3 100's 654 P/Blue 3M Post It Note 3x3 100's 654 P/yellow 3M Post It Note 3x3 100's 654 P/Pink 3M Post It Flags 680 asst col 3M Scotch Glue Stick 7gm 2 in 1 White+Purple SCOTCH STAT TAPE 12MMX30Y-6 ROLLS SCOTCH STAT TAPE 18MMX30Y-4 ROLLS SCOTCH STAT TAPE 24MMX30Y-3 ROLLS SCOTCH STAT TAPE 48MMX30YARD SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Blue SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Pink SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Black SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Grey

    27/05/2011

    PRICE
    rm3.10 rm3.10 rm3.10 Rm5.70 rm3.10 Rm3.99 Rm4.00 Rm4.00 Rm2.1 Rm7.85 Rm7.85 Rm7.85 Rm7.85

    HMS

    GE

    Remarks:

    HMS = Homeshelf Booth Location: FS = Fullshelf SSO - Sellling Stock Observation: IN = In stock REP = Replenishment HS = Halfshelf

    Page 5

    Sheet4

    TUE BD HMS GE IN REP 78 0 80 0 20 0 80 0 330 0 23 0 0 20 0 12 0 0 0 50 0 0 22 0 8 0 11 0 11 BD BAL SALES 75 3 78 2 16 4 78 2 325 5 22 1 0 0 18 2 10 0 0 0 50 0 0 0 20 2 5 3 10 1 11 0

    WED HMS GE BD IN REP BAL SALES 75 75 0 78 78 0 16 16 0 78 78 0 325 319 6 22 20 2 0 0 0 18 16 2 10 10 0 0 0 0 50 50 0 0 0 0 20 15 5 5 5 0 10 9 1 11 11 0

    TOTAL SALES 3 2 4 2 11 0 4 0 0 0 7 3 2

    HS = Halfshelf

    L = Low

    OOS = Out Of Stock

    REP = Replenishment

    Page 6

    Sheet5 PROJECT: DURATION/DATE: OUTLET: DAY/DATE PRICE SKUs


    3M Post It Note 3x3 100's 654 P/Green 3M Post It Note 3x3 100's 654 P/Blue 3M Post It Note 3x3 100's 654 P/yellow 3M Post It Note 3x3 100's 654 P/Pink 3M Post It Flags 680 asst col 3M Scotch Glue Stick 7gm 2 in 1 White+Purple SCOTCH STAT TAPE 12MMX30Y-6 ROLLS SCOTCH STAT TAPE 18MMX30Y-4 ROLLS SCOTCH STAT TAPE 24MMX30Y-3 ROLLS SCOTCH STAT TAPE 48MMX30YARD SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Blue SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Pink SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Black SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Grey rm3.10 rm3.10 rm3.10 Rm5.70 rm3.10 Rm3.99 Rm4.00 Rm4.00 Rm2.1 Rm7.85 Rm7.85 Rm7.85 Rm7.85

    27/05/2011

    HMS

    GE

    Remarks:

    HMS = Homeshelf Booth Location: FS = Fullshelf SSO - Sellling Stock Observation: IN = In stock Page 7 REP = Replenishment HS = Halfshelf

    Sheet5

    BD

    thur fri HMS GE BD HMS GE BD IN REP BAL SALES IN REP BAL SALES 75 0 73 2 73 70 3 78 0 73 5 73 73 0 16 0 14 2 14 14 0 78 0 76 2 76 75 1 319 0 300 19 300 280 20 20 18 2 18 18 0 0 0 0 0 0 0 0 16 0 14 2 14 14 0 10 0 8 0 8 8 0 0 0 0 0 0 0 50 50 0 50 50 0 0 0 0 0 0 0 15 0 10 5 10 8 2 5 0 5 0 5 2 3 9 0 9 0 9 2 7 11 11 0 11 4 7

    TOTAL SALES 5 5 2 3 39 0 2 0 0 0 7 3 7

    HS = Halfshelf

    L = Low

    OOS = Out Of Stock

    REP = Replenishment Page 8

    Sheet6 PROJECT: DURATION/DATE: OUTLET: DAY/DATE PRICE SKUs


    3M Post It Note 3x3 100's 654 P/Green 3M Post It Note 3x3 100's 654 P/Blue 3M Post It Note 3x3 100's 654 P/yellow 3M Post It Note 3x3 100's 654 P/Pink 3M Post It Flags 680 asst col 3M Scotch Glue Stick 7gm 2 in 1 White+Purple SCOTCH STAT TAPE 12MMX30Y-6 ROLLS SCOTCH STAT TAPE 18MMX30Y-4 ROLLS SCOTCH STAT TAPE 24MMX30Y-3 ROLLS SCOTCH STAT TAPE 48MMX30YARD SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Blue SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Pink SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Black SCOTCH M.TAPE (18MMX10M) W/ RABBIT DPSR- Grey rm3.10 rm3.10 rm3.10 rm3.10

    27/05/2011

    HMS

    GE

    Rm5.70
    Rm3.99 Rm4.00 rm4.00 Rm2.1 Rm7.85 Rm7.85 Rm7.85 Rm7.85

    Remarks:

    HMS = Homeshelf Booth Location: FS = Fullshelf SSO - Sellling Stock Observation: IN = In stock REP = Replenishment HS = Halfshelf

    Page 9

    Sheet6

    BD

    HMS IN 70 73 14 75 280 18 0 14 8 0 50 0 8 2 2 4

    SAT GE BD REP BAL 0 66 0 73 0 14 0 69 0 265 18 0 0 0 10 0 8 0 0 48 0 0 0 2 0 2 0 2 4

    SALES 4 0 0 6 15 0 0 4 0 0 2 0 6 0 0

    SUN HMS GE BD IN REP BAL SALES 66 63 73 73 0 14 14 0 69 59 0 265 246 0 18 16 0 13 0 10 4 0 8 0 8 0 0 48 48 0 0 0 0 2 0 2 2 0 0 2 2 0 4 4

    TOTAL SALES 4 0 0 6 15 0 4 8 0 0 8 0 0

    HS = Halfshelf

    L = Low

    OOS = Out Of Stock

    REP = Replenishment

    Page 10

    You might also like