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

Add the steps involved:

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 "New Version - HeatMap" sheet.

   4. validate actual production (all in MT on that sheet)
   5. 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

   6. if you want a drill down, open the "New Version - Chart" sheet

      1. find the hereafter tiles and pick your plant

      2. Use the drop-down menu and pick your plant

      3. give it a few seconds before you pick your product group.

      4. Once it shows a red triangle...

      5. ...pick the product group you want to take a deeper look at

      6. the chart and the table underneath now show data related to the plant and the product group you picked

      7. scroll to the right to find the details at product level (here, for March 2023).

      8. use the drop-down menu right above the detailed list if you wish to analyze a previous month, 

Related articles

Related articles appear here based on the labels you select. Click to edit the macro and add or change labels.