Please enable JavaScript.

Coggle requires JavaScript to display documents.

JBP performance - Coggle Diagram

- - - - ADO: Values from YEARLY PLANNING
      - Food Value: Values from YEARLY PLANNING
      - Total Merchant Invesment:
        
        Merchant Discount (System) : Values from Monthly Raw
        
        Merchant Discount (Non-System) : Values from Monthly Raw
      - Commission: Values from Monthly Raw
      - Gross Profit
        
        Gross Profit %
        
        Gross Profit Value
    - - 12 Tables = 12 brand name
    - - 12 months
      - Target Perf
        
        Target
        
        YTD: SUMIF 12 months up to this month
        
        Year - to - Go
  - - - MONTHLY ADO KPI
        
        MTG
        
        % Completion
        
        MTD
        
        Target
        
        [X]
      - DAILY TRACKING
        (daily raw)
        
        start day
        
        current day
      - YEARLY PLANNING
        (monthly raw)
        
        Plan ahead until Dec 2021
        
        Current month
        
        Jan 2021
      - TARGET ACHIEVEMENT
        
        2021 FCST: SUMPRODUCT(YEARLY PLANNING, month days) /
        SUM(month days)
        
        COMPLETE
        
        2021 TARGET
    - - Hierarchy 1: 12 Brands + All
      - Hierarchy 2: 4 Areas + VN
  - - - MONTHLY ADGMV KPI
        
        MTG
        
        % Completion
        
        MTD
        
        Target
      - DAILY TRACKING
        (daily raw)
        
        start day
        
        current day
      - YEARLY PLANNING
        (monthly raw)
        
        Plan ahead until Dec 2021
        
        Current month
        
        Jan 2021
      - 2021 FCST: SUMPRODUCT(YEARLY PLANNING, month days) /
        SUM(month days)
    - - Hierarchy 1: 12 Brands + All
      - Hierarchy 2: 4 Areas + VN
  - - - MONTHLY ADO KPI
        
        MTG
        
        % Completion
        
        MTD
        
        Target
      - DAILY TRACKING
        (daily raw)
        
        start day
        
        current day
      - YEARLY PLANNING
        (monthly raw)
        
        Plan ahead until Dec 2021
        
        Current month
        
        Jan 2021
      - TARGET ACHIEVEMENT
        
        2021 FCST: SUMPRODUCT(YEARLY PLANNING, month days) /
        SUM(month days)
        
        COMPLETE
        
        2021 TARGET
    - - Hierarchy 1: 12 Brands + All
      - Hierarchy 2: 4 Areas + VN