Uploaded image for project: 'OSCAR'
  1. OSCAR
  2. OS-18558

Market CSL Network & Visualizer: prepare data sets for calculation

Insert Lucidchart DiagramSend email
    XporterXMLWordPrintable

Details

    • Task
    • Resolution: Completed
    • Medium
    • 11.0
    • None
    • AE
    • None

    Description

      Each Material is flagged as Top Priority or Standard Priority. Market CSL should be calculated separately for both data sets and shared for front-end visualization. 

       

      Market Customer Service Level (MKT CSL)

      Metric Contact / SME CarlosA.Manzano@pfizer.com
      Metric (Logic) Description Market Customer Service Level
      Metric Scope Market Customer Service Level
      Data definitions
      (back end)
      Percentage_In_Stock pgsudh_metrics.bsc_customer_service_period
      Product type = FG
      Material Segments = M, S, A, B, C
      KPI Flag = Y or C
      rc_event_suppresion to exclude “Suppressed”
       
      Metric links Network Supply Dashboard: 1: Customer Service - Tableau Server (pfizer.com)
      Pre-calculation of metric No
      Calculation: 1 – (Stock_OUT_DAYS / SHIP_Days) * 100
      Targets Targets provided across hierarchy (Parameters) level based on OpU Category Targets reference file
      Validation Approach Site, Product level…
      SupplyIQ visualization SupplyIQ presents outputs for last closed month in Network and Site metric widget
      Metric tooltip displays data trend for all closed months starting with Jan of previous year, supplemented with volume data trend for same horizon
      Comments PoA:
      -          SupplyIQ does not include Upjohn data
      -          SupplyIQ excludes active SKUs without 101F (101B ES) transactions in last 2 years

      Attachments

        Activity

          People

            CHILLS01 Chillakuru, Siva
            SZYMAM04 Szymanowski, Michal
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 1 day Original Estimate - 1 day
                1d
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 4 hours
                1d 4h