Upon reception of the monthly notification, you want to:

  1. validate the schedule snapshot (the current month schedule)
  2. review and comment the adherence performances of last month (last month schedule vs last month actual)

Step-by-step guide

  1. Validate the schedule snapshot (this month's schedule snapshot, in order to prepare for the next Adherence cycle)
    1. open the SpP PA Sch Data Keep file.

    2. open the MYYYYMM sheet. YYYYMM is the current month. E.g. if today is April 03 2023, you want to work on M202304.

    3. Use a filter view to help. Many have been already created. Feel free to use them or create yours.

    4. Here, in this example:

      1. February 2024 production schedule is highlighted.

      2. The schedule of February has been downloaded from Picaso into that spreadsheet on February the 1st.

    5. Review/validate these numbers, and make necessary adjustments. When should you adjust these numbers?

      1. if you made schedule changes on the first days of the month, that you think should have been accounted for in the monthly snapshot

      2. if for any reason, you could not update the schedule prior to the snapshot (prior to April 1st) and you think they should be accounted for in the snapshot.

    6. Once you are done, open the "Schedule Validation Punch Card" sheet.

      1. let me know that you are done and that the numbers are validated: 

      2. if you think there is something wrong with the extraction and want to let me know, check the other box:

  2. Review and comment the adherence performances of last month
    1. open the SpP PA - Heat Map file.

    2. You will be reviewing last month's performances. E.g. if today is April 03 2023, you will be reviewing the performances of March 2023

    3. Open the your sheet (=your plant). It shows this:

    4. Open the "Monthly" section

      1. Summary per product line on top

      2. Details per product on the bottom.

    5. validate actual production (all in MT on that sheet)
    6. update comments as follows

      1. where Adherence is green or blue: no comment necessary. Adherence is within range of, or higher than, the target. Just enter "OK" to confirm that you have reviewed the performances.

      2. where Adherence is orange or red: adherence is lower than target. Provide with a high level, one or two liner that recaps what happened
      3. use a category that best represents the type of root cause. You may pick up to three.

      4. see example below