Resource Bottleneck Mapping

Even if a group of resources are underutilized, they still might be a bottleneck for part of the simulated time. The single utilization number provided in the standard output won’t tell “if” or “when” the resource might be constraining production.


The production times vary even when the resource attached is underutilized. This will help pin down the time when there was more work for the resource than it could have handled.

Resource Bottleneck Mapping Model Object

Difficulty Level

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

How to Use the Model Object

  1. Open the ‘Resource Bottleneck Mapping’ model object.
  2. Simulate the model.
  3. Once the simulation ends, open the Output Report.
  4. Click the second Excel icon to export variable values for ‘v_Usage1’.
  5. Once exported open the attached ‘Resource Bottleneck Mapper File’ Excel file. Before 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 prompted

    Enable Macro

  6. Click the ‘Get Resource Info’ button, browse to the exported variable file and open it.
  7. Change the shift times in the ‘SFT’ column, if needed.
  8. Click ‘Generate Heatmap’ button.

Outputs Available

Once the heatmap is generated, you will be able to review times where the resource was most utilized.

Was this article helpful?

Related Articles