You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

This quick reference guide is a cheat sheet or Planning Key Users.

Running Monthly Adherence Report boils down to xxx things:

  • On the first day of the month
    • take a snapshot of the production schedule
    • upload it in the adherence report database
    • reset the validation punch card
    • email the other site planners (template 1)
  • On the 5th working day of the month
    • verify that actuals are in
    • email the other site planners (template 2)

Step-by-step guide

  1. On the first day of the month
    1. Take a snapshot of the production schedule:
      1. Find the Production Schedule in ADM
      2. make sure no filter is active:  if this function is greyed out, you are good. If it is not greyed out, press the button to clear your filter.

      3. export it  as a spreadsheet

      4. in your spreadsheet, make sure that production quantities are without decimals

         
    2. Upload it in the Adherence report database
      1. find the SpP PA Sch Data Extract & Sparsing file
      2. open the PicasoImport sheet
      3. clear the data (important !)
      4. copy/paste from your spreadsheet (see previous step)
      5. make sure the other views (MonthView, RemainingMonthView, WeekView) display no #N/A or #ERROR

      6. in the menu, find the 'Key User Toolbox'

      7. choose "Activate Monthly Schedule'. This will create the corresponding sheet the the SpP PA Sch Data Keep file. That will free you up from having to do it at a specific time.

    3. reset the validation punch card
      1. find the SpP PA Sch Data Keep file
      2. open the Schedule Validation Punch Card sheet

      3. clear the checkboxes

    4. let the site planners know about the snapshot → they have to validate it
      1. use this distribution list: SCo-$SpP_Monthly_ Adherence

      2. and this template:

        Adherence - Scheduled volumes for Month <MM YYYY>

        Dear all,

        The production volumes you have scheduled in Picaso for <MM YYYY>  have been downloaded in the SpP PA Sch Data Keep file.

        You can already go ahead and validate the schedule snapshot.

        Find step by step instructions in the Planning Wiki.

        Just do step 1 (validate schedule snapshot)

        As for step 2 (review and comment), the file is not ready yet.

        You will receive another email by <Day> when we will be ready to review the adherence of <M-1>.

        Thanks!

  2. On the 4th working day of the month
    1. open the SpP Adh - Heat Map file and verify that actuals are in. Just check the sanity of the actual numbers for your perimeter.
      1. between the first day, and the 3rd day of the month, the actual numbers in the report are wrong. By design. Because Al Quaeda.
      2. starting the 4th day of the month, the report is refreshed with the real actual numbers.
      3. there are two more refreshes (4th & 5th days of the month) to account for plants being late to report their numbers, vacations, etc. 
    2. email the other site planners
      1. use this distribution list: SCo-$SpP_Monthly_ Adherence

      2. and this template:

        Adherence - Performances of month <MM YYYY>

        Dear all,

        The Production Adherence of <MM YYYY> is now ready for review in the SpP Adh - Heat Map file.

        Please have performance reviewed with Manufacturing before the end of next week ( <day> ).

        Find step by step instructions in the Planning Wiki.

        Thanks.


  • No labels