Building a workforce planning tool in Excel
An Excel model was developed that combines historical and current workforce data into one planning setup. The result gives clear department-level staffing insight and supports scenario modelling for future deployment.
Deliverable
Excel dashboard
Domain
Data and planning
Work location
Remote
Industry International operates across multiple departments and project types, which makes workforce planning a recurring operational challenge. Historical data and new inputs were both available, but they were not brought together in one model that could support decisions across teams.
Without that consolidated view, it became harder to spot undercapacity or overallocation in time. Forward-looking planning also remained limited, because there was no practical way to test staffing scenarios before decisions had to be made.
The challenge
The organisation needed an Excel-based planning tool that could combine existing and new workforce data, provide insight by department and allow users to simulate different staffing scenarios. It also had to stay fully usable within Excel, without dependencies on external systems or additional tooling.
Blackbear's role
Blackbear helped keep the assignment sharply scoped from the start. The solution had to remain fully Excel-based, without expanding into web applications, heavy integrations or ongoing maintenance. From there, the work was structured around requirements gathering, prototype development, iteration with users and final handover.
Result
The delivered model integrates historical and current data, shows staffing levels per department and enables scenario simulations for future resource planning. After review and presentation, the tool was accepted and transferred to internal users together with documentation and usage instructions.
