Manpower Planning System

This system was developed for a client in the automotive industry to allow them to track manpower planning requirements for the year ahead – by Plant.

For each site the system allows the user to setup the site capacity details:

  • Buildings
    • Areas
      • Shift Patterns
        • Gross JPH
        • OPR%
        • Working Hours Capacity

They can also log the predicted production line rate (volume) by week number.

The system then allows the user to create a budget for each Site/Building/Area by Fiscal Year – with a headcount requirement predicted for each job role – based on rules defined in the database.

As the year progresses the required headcount can be adjusted and this data feeds into several management reports:

  • Budget Summary
  • Budget VS Forecast
  • Budget Walk
  • Forecast Walk