You developed a custom application to support complex workforce planning for international projects. What are the key features of this tool, and how does it help companies make their planning more efficient?
Meike: “It’s an operational workforce planning application that allows our client’s planners to schedule staff for projects over the next three months. Planners can create schedules manually within the application, supported by features like job creation, data filtering, and checks. The application shows suitable individuals for each job, ensuring a fair distribution of work. It also includes an algorithmic component that automatically creates schedules, which planners can then manually adjust. Additionally, there is a tactical planning module that enables the client to plan up to a year and a half in advance, helping them predict which skills are needed in which locations and proactively cross-train staff.”
Meike de With, Senior Solution Consultant at ORTEC
"Departments now have a central overview of the planning, allowing for easier employee exchanges."
Better insight into workforce deployment
The tool is a significant improvement over the old system, but according to Meike, its benefits extend beyond that. “The client now has better insight into their workforce. Where they used to coordinate staff availability by phone, they now have a central planning overview. This makes it easier for departments to share employees. The bottleneck in one of the client’s processes has also become more visible. Previously, it was mainly in production, but now it often lies in having enough staff. Lastly, it’s become much simpler to calculate and compare different scenarios, such as: can we schedule additional projects? Or: what’s the impact if we cross-train employees to perform other tasks within a project?”
Can you describe the main challenges in workforce planning for the client?
Meike: “In general, we’re dealing with a complex planning problem that involves deploying thousands of employees worldwide for various projects. These employees have different qualifications and must meet a wide range of requirements. One of the biggest challenges is the international aspect: you need to consider the employee’s work-life balance. There are agreements on how long someone can be away from home and how long they must stay in their home country before traveling again. You also want to keep travel costs as low as possible, but that must be balanced with the need to avoid keeping employees away from home for too long. These considerations make for a planning process where many interests must constantly be weighed against each other.”
“We talked extensively with the planners and built in flexibility so that different departments can set their own priorities.”
Weighing thousands of scenarios
Solving such a complex puzzle can’t be done without data analysis, Meike believes. “It’s too complicated to manage everything manually or keep track of it in an Excel sheet. If you try, mistakes are made quickly, which can have far-reaching consequences. Since so much money is involved, the implications of suboptimal planning are significant. The question then becomes: how can you still gain an overview of such a complex situation? Software plays a crucial role in this. It can weigh thousands of scenarios and options against each other based on the company’s business logic and make the best choices.”
Meike: “I think that’s where the strength of our solution lies. We don’t just make the huge amount of data insightful; we also support the planners. We really delve into their way of working. We talked a lot with the planners and asked them what they considered important. What makes a good plan? What factors do they weigh? Based on that input, we built flexibility into the application, allowing different departments to set their own priorities. For one department, work-life balance may be the most important, while another focuses more on cost savings.”
Close collaboration throughout the project
Bringing a project like this to a successful conclusion requires close collaboration, Meike says. “The project team consisted of five people from ORTEC, including a project manager, and six employees from our client. Together we formed one team, and we tried to work on-site as much as possible. We held a joint stand-up every morning where we discussed what we were going to work on that day. That helped us stay aligned. Although not everyone was available full-time, we made sure that the key project days were filled together. It was truly a team effort.”
Did this project involve a lot of change management? Such a large project must have impacted how the organization operates.
Meike: “In large projects like this, you often see a significant change management component. Different departments and levels within the organization may have different interests. Central management wanted more visibility and oversight of processes, while local planners were more hesitant to share their schedules. They had worked for years within their own, clearly defined departments, often keeping staff on standby in case of unexpected events. That had to change. Therefore, alongside the development project, a change management process was set up to bring all departments along in this transition.”
“Using smart algorithms to weigh different interests is something many companies could benefit from.”
Do you think management’s awareness of the importance of good planning has increased due to this project?
Chuck: “Our client is growing rapidly and faces shortages in many areas, especially staff. They want to make the best use of the people they have. Previously, local planners often worked in silos, which led to suboptimal planning and inefficiency. With the increased visibility and centralization of planning data, planners can now more easily see where capacity is available, even outside their own department. This has significantly improved the use of available resources.”
Applying solutions more broadly
That sounds like a promising development. Do you see opportunities to apply this approach more broadly, for example, in other sectors?
Chuck: “While our client’s planning challenges are very specific, you see a similar need to centralize data and make better plans based on that data in many sectors. Replacing Excel and using smart algorithms to weigh different interests is something many companies can benefit from. There’s also potential in linking material planning and workforce planning to better align machine production capacity and employee availability. These kinds of integrations can lead to greater efficiency and better planning outcomes.”
About Meike de With and Chuck Ng
Meike de With, Senior Solution Consultant at ORTEC, and Chuck Ng, team lead of the High-Tech team, played crucial roles in the development and implementation of this client’s solution. Over the past nine years, Meike has worked on a variety of projects with different clients, with a consistent focus on understanding customer needs and how ORTEC can support them. Chuck led the Centre of Excellence at ORTEC Data Science & Consulting for several years, using his expertise to build knowledge and act as a consulting hub. In early 2023, he transitioned to ORTEC’s High-Tech department to work more closely with clients and make a more direct impact.
