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
- Shift Patterns
- Areas
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