Please enable JavaScript.

Coggle requires JavaScript to display documents.

ULV Retail Commercial Plan Review - Coggle Diagram

- - - - Compare assortment between previous commercial plan & this month commercial plan
      - Source Data
        
        Final Previous Commercial Plan
        
        This Month Commercial Plan
  - - - Step 1: Get updated ULV SC Status
        
        Source Data
        
        This Month Commercial Plan
        
        Missed SKUs in This Month Commercial Plan
        
        Master Data from ULV
      - Step 2: Check Deleted
        
        2.1 Check Old Code
        
        a. There is old code
        
        Check stock current code & old code
        
        Both of them have stock
        
        Check performance old code
        
        2 more items...
        
        Old code has no stock & current has stock
        
        Request ULV push clearance current code
        
        Both of them have no stock
        
        Request ULV remove from Commercial Plan
        
        Old code has stock & current has no stock
        
        Check performance old code
        
        2 more items...
        
        b. There is no old code
        
        Check stock current stock
        
        Has stock
        
        Request ULV push clearance current code
        
        Has no stock
        
        Request ULV remove from Commercial Plan
      - Step 3: Check Substituted
        
        3.1 Check Old Code
        
        a. There is old code
        
        Check stock current code & old code
        
        Both of them have stock
        
        Check performance old code
        
        2 more items...
        
        Old code has no stock & current has stock
        
        Request ULV push clearance current code
        
        Old code has stock & current has no stock
        
        Check performance old code
        
        2 more items...
        
        Both of them have no stock
        
        Request ULV remove from Commercial Plan
        
        b. There is no old code
        
        Check stock current stock
        
        Has stock
        
        Request ULV push clearance current code
        
        Has no stock
        
        Check there is new code
        
        2 more items...
      - Step 4: Check Active
        
        4.1 Check Old Code
        
        a. There is old code
        
        Check stock current code & old code
        
        Both of them have stock
        
        Check performance old code
        
        2 more items...
        
        Change current code to "Not yet effective"
        
        Old code has no stock & current has stock
        
        Change ADA status of current code to "Active"
        
        Old code has stock & current has no stock
        
        Check performance old code
        
        2 more items...
        
        Change current code to "Not yet effective"
        
        Both of them have no stock
        
        Request ULV remove old code from Commercial Plan
        
        Change ADA status of current code to "Active"
      - Step 5: Check bunlde detail
        
        5.1 Commercial = "Single", ULV MD = "Single"
        
        Do nothing
        
        5.2 Commercial = "Single", ULV MD = "Bundle"
        
        Check Commercial Plan, if included bundle forecast
        
        Yes
        
        Do nothing
        
        No
        
        Break Bundle to Single.
        
        Request ULV update Single Code to Master Data
        
        Set ADA status to "Inactive"
        
        5.3 Commercial = "Bundle", ULV MD = "Single"
        
        Request ULV update Bundle Code to Master Data
        
        Suggestion
        
        Keep inbound
        
        Raise extra
        
        Bundle before inbound
        
        Set ADA status to "Inactive"
        
        5.4 Commercial = "Bundle", ULV MD = "Bundle"
        
        Do nothing
      - Step 6: Check list "Take out assortment"
        
        Check final list vs "Take out assortment" list
        
        Yes
        
        Check stock
        
        Has stock
        
        Do nothing
        
        Has no stock
        
        Request ULV remove from commercial plan.
        
        No
        
        Do nothing
        
        Suggestion: ULV KA update ULV Commercial Status to "Inactive" for these SKUs
      - Note for Tiki
        
        ULV send plan based on Tiki Code
        
        If there is old code & new code in the same time, ADA will manually replace new code for Tiki Code when old code is OOS
        
        Difficult to check:
        
        1st time Tiki raise Secondary Bundle
        
        After that, raise Primary Bundle
        
        Issue: can't check this case so, ADA keep purchase singles and make bundle at ADA WH => Increase cost bundle
        
        Solution: Remake ADA Product Master Data
- - - - There is GAP
        
        Yes
        
        Request ULV re-check U-Retail Price
        
        Request ULV KA confirm GAP via email
        
        Yes
        
        Claim based on SP - ADA's U-Retail Price
        
        No
        
        Claim based on SP - Commercial Plan's U-Retail Price
        
        Define GAP of margin
        
        No
        
        Do nothing
  - - - There is GAP
        
        Yes: Check % GAP/Maximum Price
        
        Big GAP: >10%
        
        Challenge ULV KA
        
        Small GAP: <=10%
        
        No: Do nothing
- - - - Sheet "Retail - Single"
    - - Sheet "Retail - Single" & "Retail - Combo"