Page History

...

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

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

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

      Image RemovedImage Added

   4. Here, in this example, we use a filter view named 'Borger'.:

      1. February 2024 April production schedule is highlighted.

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

         Image RemovedImage Added

   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.

      Image Added

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

         Image Added

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

         Image Added

2. Review and comment the adherence performances of last month
   1. open the MatSeg Monthly SchedAdh 2022-2023 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.

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

      Image Added

   6. Open the "Monthly" section

      1. Summary per product line on top

      2. Details per product on the bottom.

         Image Added

   7. validate actual production (all in MT on that sheet)
   8. update comments update 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 liners 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

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

      1. find the hereafter tiles and pick your plant

         Image Removed

         Use the drop-down menu and pick your plant

         Image Removed

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

         Image Removed

         Once it shows a red triangle...

         Image Removed

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

         Image Removed

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

         Image Removed

         scroll to the right to find the product details.

         Image Removed

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

         Image Removed

Related articles

...