Manufacturing Planner

This model object reassigns workers on a production line if: 1. Employees are absent and the line needs rebalancing; 2. The production mix changes; 3. Production goals change.

The manufacturing planner defines skill levels, error rates, and resource assignments. A brilliant method of resources assignment accomplishes what seems to be impossible. The reassignment routine automatically rewrites the logic to reassign single, multi-shift, alternate or many resources to any station. For example, if a station has workers on three shifts, allows alternate workers and each person has different skills, then system automatically creates complex logic to assign workers. If a different worker, with greater skill is substituted then the logic rewrites, and will shorten production time because of using the higher skilled employee.

This new model object is important because complex resource reassignment is difficult. Now its visual, easy and fast. So easy that a novice can reassign workers on a production line. This is the most powerful model object ever built for you.

Manufacturing Planner fi

Where to Find the Model Object

The following model object can be found in the model objects directory:

  • Resources \ Manufacturing Planner

Difficulty Level

  • Ease of Use: Moderate
  • Ease of Modification: Moderate

How to Use the Model Object

  1. Open Your Model: Open your model or create a new blank model.
  2. Prep Your Model
    1. Add a storage before the activities, where a resource needs to  be captured.adding storage in Manufacturing Planner
    2. Rename the storage to *Act-Name*_InQ, where *Act-Name* is the actual name of your activity.rename storage in Manufacturing Planner Additionally, you can change the capacity of the storage to what you want the input queue size to be.
    3. Change the input queue size on the activity to 0.change input queue in Manufacturing Planner
    4. Repeat for every activity where you would like to have resource(s) work.add storage for all act in Manufacturing Planner
    5. Add all the resources you will need.add resources in Manufacturing Planner
  3. Insert the Model Object into Your Model
    1. Locate the model object Manufacturing Planner and click the Insert button.
    2. Move the cursor to the point of insertion and left mouse-click. The upper left corner of the model object will be inserted at the location of the mouse-click.

      If you do not see the model object in your model objects gallery, make sure that you have updated your model objects gallery by clicking Model Objects \ Update.

  4. Open the Excel File: Right click on the Manufacturing Planner Excel icon and click on the third option from the bottom to open the Manufacturing Planner vx-x Excel file, where x-x represents the version number of the Excel excel file in Manufacturing PlannerBefore using this Excel file for the first time, or after changing your model name, make sure that a manual export of data is done via ProcessModel. From your model, click Tools \ Export Data, click ‘Yes’ to all prompts until the data export file opens, close the data file and then use this Excel file.

    Click Enable Content if promptedEnable Macro

  5. Setup Workbook: Click the 1. Setup Workbook button. Once clicked, the Excel file will sync with ProcessModel and get the information regarding resources and relevant activities.

    All resources from the model should now be listed on the ShiftsTime DefinitionError RateSkills Portfolio and Resource Assignment worksheets.setup workbook in Manufacturing Planner

  6. Shifts: If your resources need to be scheduled for 24/7 skip to the next step Time Definition.
    1. On the Shifts worksheet, fill in the information required for all the resources.
    2. Qty: Quantity of the resource.
    3. Group: Group resource belongs to,  if you do not wish to do resource groupings, enter 1 for all.
    4. Start: Shift start time. Format: 12:00 AM
    5. End: Shift end time. Format: 8:00 AM
    6. Lunch St: Lunch start time. Format: 5:00 AM
    7. Lunch St: Lunch end time. Format: 5:30 AM
    8. Rate: Hourly pay.
    9. Sunday … Saturday: Enter days the resource needs to work. Format: ON = Resource available – OFF: Resource unavailable.
    10. Click the 2. Update Shifts button to send the shift information to ProcessModel.added shifts to Manufacturing PlannerIf you have different shift timings within a single resource group (#1.2 above), you can review the shifts in a graph by entering the resource group number in cell J2, and then clicking the Show Schedule Graphically for Resource Group:.
  7. Time Definition (Time  Multiplier)
    1. Enter the skill levels of the resources, below cell A6. Add upto 6 skill levels.

      Skill level  is level  of experience a resource has on a particular task. You may leave the skill level empty for a resources that does not have a particular skill.entering skill level in Manufacturing Planner

    2. Enter the time multiplier for each of the activity, based on the skill level to alter the standard production times.

      Using 1 makes no changegreater than 1 increases t