The planning problem
Managers needed to forecast staffing requirements for the next four weeks while taking employee availability and planned leave into account. The information existed, but turning it into a usable resource plan required significant recurring manual effort.
The objective was to create a practical Excel tool that made the planning process faster while remaining simple enough for operational users to share.
The custom Excel solution
A semi-automated resource planning workbook was designed to bring staff availability and forward planning information into one model. It helped managers see upcoming capacity and allocate available resources more efficiently.
The workbook was shared by around 30 users, including team leaders, line managers and operations management, so usability was as important as the underlying calculations.
- Four-week forward resource view.
- Staff availability reflected in the planning process.
- Shared model for managers and team leaders.
- Reduced repeated manual planning and rework.
- Designed, tested and implemented with the end users in mind.
Business impact
The resource planning system was estimated to save approximately 250 staff hours every three weeks.
The important point was not the size of the workbook. It was that a recurring management task that previously required substantial manual effort became a structured tool that could be used repeatedly.
Why this translates well to SMEs
Small businesses often have similar planning problems: rotas, job allocation, technician availability, project capacity, stock requirements or delivery schedules. A well-designed Excel planning tool can often provide the structure needed without forcing the business into a larger software project.