Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    Po List Checking

    Uploaded by

    pascual.raven.3
    The document provides instructions for reviewing purchase orders. It includes details on checking delivery dates, order amounts, supplier locations, and order methods. Key aspects to review are delivery dates, large order amounts, and order breakdowns by batch, material, and month.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Po List Checking

    Uploaded by

    pascual.raven.3
    10 views12 pages
    The document provides instructions for reviewing purchase orders. It includes details on checking delivery dates, order amounts, supplier locations, and order methods. Key aspects to review are delivery dates, large order amounts, and order breakdowns by batch, material, and month.

    Original Title

    PO LIST CHECKING

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for reviewing purchase orders. It includes details on checking delivery dates, order amounts, supplier locations, and order methods. Key aspects to review are delivery dates, large order amounts, and order breakdowns by batch, material, and month.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    10 views12 pages

    Po List Checking

    Uploaded by

    pascual.raven.3
    The document provides instructions for reviewing purchase orders. It includes details on checking delivery dates, order amounts, supplier locations, and order methods. Key aspects to review are delivery dates, large order amounts, and order breakdowns by batch, material, and month.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 12

    PO LIST

    ZMM016 LAYOUT: /PO-CHECK

    QUANTITY
    MOQ GAP = PO QTY (-) MOQ
    > Negative value: METHOD 4,5, & 8 ONLY
    > 0 value = METHOD 2, 3, & ABOVE 80% OF MOQ PO QTY ONLY
    > Positive value: METHOD 1, NO MOQ & ABOVE MOQ PO QTY ONLY

    PO QTY vs BALANCE QTY (normal PO), round up those qty w/ decimal


    PO QTY vs PR QTY (manual PO)

    DELIVERY DATE
    DELIVERY DATE ALLOWANCE = REQUIREMENT DATE (-) DELIVERY DATE
    ACTUAL NEEDED DATE (-) DELIVERY DATE (IF INDICATED IN PR LIST)
    LACKING LEAD TIME = DLV. DATE COUNT (-) PLANNED DELIVERY DATE

    BATCH
    1 - NORMAL PO
    FOLLOWS FACTORY SAP REQUIREMENT DATE
    REQUIREMENT DATE (-) GR PROCESSING TIME (-) SHIPPING LEAD TIME (-) SPECIAL LEAD TIME ALLOWANCE
    BATCH 1 : no -5 & below
    Delivery date allowance :
    No below 38-39 days
    No above 42-45 days (except vendor w/ special allw.)
    Local : no below and above 28 days (except ND materials and vendor w/ special allw.)

    BATCH 2 : DEL. DATE COUNT IS ALWAYS 21-24 DAYS (EXCEPT BELOW 21 LEAD TIME)
    2 - PRE-PRODUCTION
    GIVES 3 WEEKS ALLOWANCE ALLOAWNCE TO VENDOR TO FINISH/DELIVERY THE ORDER REGARDLESS OF FACTORY SAP REQUIREMEN
    CREATE DATE (+) 21 DAYS

    BATH 3 : DEL. DATE COUNT IS ALWAYS 14 DAYS (EXCEPT BELOW 21 LEAD TIME)
    3 - ADDITIONAL
    GIVES 2 WEEKS ALLOWANCE TO VENDOR TO FINISH/DELIVERY THE ORDER REGARDLESS OF FACTORY SAP REQUIREMENT DATE
    CREATE DATE (+) 14 DAYS
    > please attach SQ01, layout JEKIM

    BATCH 4 : LACKING LEAD TIME IS -5 & BELOW BUT MAKE SURE SUPPLIER CONFIRMED ON THAT
    4 - SPECIAL CASE
    CENTRAL WAREHOUSE DECISION TO MAKE DELIVERY DATE AS SHORT LEAD TIME

    BATCH 99 : FOLLOW LEAD TIME


    99 - FORECAST
    FACTORY NEEDS IN PRODUCTION IN FUTURE TIME
    CREATE DATE (+) VENDOR LEAD TIME

    STORAGE LOCATION
    KOREA: 1100 > NEXT STOR. LOC > A100
    IMPORT: ALWAYS A100, EXCEPT ND BULK MATERIALS
    ND BULK: DIRECT FACTORY LOCATION
    VINA KOREA : STOR. LOC(1100) / NEXT LOC.(B100)
    VINA IMPORT/LOCAL : B100

    METHOD
    1 - NORMAL PO
    QUANTITY IS 80% AND ABOVE OF MOQ, AND/OR MATERIAL WITH NO MOQ

    2 - MOQ BUYER
    PO QUANTITY IS BASED ON MOQ (BUYER DECISION TO PROCEED AS MOQ)

    3 - MOQ FACTORY
    PO QUANTITY IS BASED ON MOQ (FACTORY DECISION TO PROCEED AS MOQ)

    4 - SURCHARGE BUYER
    PO QUANTITY IS BELOW MOQ WITH ADDITIONAL SURCHARGE, BUYER CONFIRMED TO PAY THE SUCHARGE (NEEDS DOCSWAVE APPR
    ADD CUSTOMER CODE
    MATERIAL PO TEXT: D/N#: ******* or APPLIED SURCHARGE IN BOM

    5 - SURCHARGE FACTORY
    PO QUANTITY IS BELOW MOQ WITH ADDITIONAL SURCHARGE, FACTORY CONFIRMED TO PAY THE SURCHARGE (NEEDS DOCSWAVE A
    MATERIAL PO TEXT: FACTORY NAME & D/N#: ******* or APPLIED SURCHARGE IN BOM

    8 - BELOW MOQ ORDER


    PO QUANTITY IS BELOW MOQ BUT NO ADDITIONAL SURCHARGE, SUPPLIER MUST CONFIRM WE CAN PROCEED ORDER AS BELOW M
    SS OF FACTORY SAP REQUIREMENT DATE

    RY SAP REQUIREMENT DATE


    CHARGE (NEEDS DOCSWAVE APPROVAL)

    SURCHARGE (NEEDS DOCSWAVE APPROVAL)

    N PROCEED ORDER AS BELOW MOQ


    para less po ung time na maconsume sa pag ayos ng format.

    1. Remove unnecessary columns*


    2. Remove vlookup formula*
    3. Recheck if formula for each column is correct
    4. Recheck all cells' format especially date (44928 > 01/02/2023)
    5. Align all column to LEFT, except;
    6. QTY and Amount must have comma ( , ) separator and must be WHOLE NUMBER ONLY (10000 > 10,000.00
    *important!

    apply to ZMM088 & ZMM016

    DELIVERY DATE

    LACKING L/T COLUMN (SORT DESCENDING)

    IF DELIVERY DATE IS SHORT L/T(NEGATIVE FIVE AND B


    PROCEED IF :
    PRE-PRODUCTION (BATCH 2)
    ADDITIONAL (BATCH 3)

    DELIVERY DATE ALLOWANCE (SORT DESCENDING)

    IF THE REQUIREMENT DATE IS TOO TIGHT, ALWAYS M


    FOR NORMAL PO (BATCH 1)

    FOR MANUAL PR (BATCH 99), NOT ALL ARE GUARANT


    CHECK FACTORY NEEDED DATE TO DECIDE DELIVERY D

    OVER $10K/₩10M ORDER AMOUNT


    AMOUNT KRW (SORT DESCENDING)

    CHECK IF POSSIBLE TO SPLIT THE QTY.


    IN SPLITTING QTY, DELIVERY DATE MUST NOT BE WIT
    EXCEPT FOR MONTHLY PAYMENT TERM, WEEKLY SPLI

    FOR SUPPLIERS LOCATED AT US/EU, SPLITTING QTY IS

    % OF NEEDED QTY FROM MOQ


    ONLY (10000 > 10,000.00 > 10,000)

    SORT DESCENDING)

    ORT L/T(NEGATIVE FIVE AND BELOW), CHECK FOR THE REASON OF PO (BATCH).

    ANCE (SORT DESCENDING)

    ATE IS TOO TIGHT, ALWAYS MAKE SURE DELIVERY DATE MUST BE FOLLOWING VENDORS' L/T.

    H 99), NOT ALL ARE GUARANTEED FORECAST.


    D DATE TO DECIDE DELIVERY DATE.
    PLIT THE QTY.
    VERY DATE MUST NOT BE WITHIN THE SAME MONTH.
    PAYMENT TERM, WEEKLY SPLITTING IS CONSIDERABLE.

    D AT US/EU, SPLITTING QTY IS NOT ADVISEABLE DUE TO EXPENSIVE SHIPPING COST


    NEW PO REVIEW COMPARISON OF
    S/O AMOUNT WIL
    PO DATE : 2023.08.25 Unit: Won CURRENCY MUST
    Ex. Rate: 1,250
    TO GET KRW AMO
    1. S/O vs PO AMT
    PO AMOUNT S/O AMOUNT % WHY NEED TO MU
    1,045,210,390 666,597,583 157% BECAUSE RM COS

    2. S/O TYPE
    S/O TYPE PO AMOUNT %
    TOTAL 666,597,583 100%
    SMS - 0%
    BULK 666,597,583 100% BASED ON BATCH M
    ETC (RM) - 0%

    3. BATCH PO AMT
    BATCH # PO AMOUNT %
    TOTAL 1,045,210,390 100%
    1 623,629,341 60%
    2 347,754,553 33%
    3 16,500,938 2%
    4 31,723,304 3%
    99 25,602,254 2% BASED ON PO LIST, J
    (NEED TO GET TOTA

    4. RM ORDER AMOUNT RANGE


    RANGE CASE %
    TOTAL 697 #DIV/0!
    1000 above 20 #DIV/0!
    500~999 266 #DIV/0! BASED ON PO LIST, J
    50~499 264 #DIV/0! (NEED TO GET COUN
    49 under 147 #DIV/0!

    5. DELIVERY SCHEDULE PER MONTH


    DELIVERY AMOUNT %
    TOTAL 1,045,210,390 100%
    SEPT 591,015,100 57%
    BASED ON PO LIST, J
    OCT 261,920,957 25% (NEED TO GET TOTA
    NOV~ 192,274,333 18%

    6. SPECIAL REMARKS
    THE PO AMOUNT IS LARGER DUE TO CALLAWAY IF YOU NOTICE SOME
    PREVIOUS HOLDING LOT WAS PROCEEDED TO COMMENT SO THE A
    TODAY'S PO CREATION.
    IF YOU NOTICE SOME
    COMMENT SO THE A
    COMPARISON OF CREATED PO AMOUNT AND NEW LOT AMOUNT
    S/O AMOUNT WILL BE FROM BATCH MONITORING FILE, WHEN INPUT IN THIS FILE,
    CURRENCY MUST BE CONVERTED FROM USD TO KRW.

    TO GET KRW AMOUNT = USD TOTAL AMOUNT * 1250(RATE) * 45%

    WHY NEED TO MULTIPLY BY 45%?


    BECAUSE RM COST IS 45% OF THE FOB AMOUNT

    BASED ON BATCH MONITORING FILE "REMARK"

    BASED ON PO LIST, JUST NEED TO USE PIVOT TO GET EASIER


    (NEED TO GET TOTAL AMOUNT PER BATCH)

    BASED ON PO LIST, JUST NEED TO USE PIVOT TO GET EASIER


    (NEED TO GET COUNT PER RANGE INDICATED)

    BASED ON PO LIST, JUST NEED TO USE PIVOT TO GET EASIER


    (NEED TO GET TOTAL AMOUNT EACH; WITHIN 3 MONTHS)

    IF YOU NOTICE SOMETHING STRANGE AND UNFAMILIAR GIVE


    COMMENT SO THE APPROVING MANAGER WILL HAVE IDEA.
    IF YOU NOTICE SOMETHING STRANGE AND UNFAMILIAR GIVE
    COMMENT SO THE APPROVING MANAGER WILL HAVE IDEA.

    You might also like