Resource Planning Manager (UK & NL) — Excel Automation

HOLLAND AND BARRETT; Burton upon Trent; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Annual bonus up to 10%

Private medical insurance

Pension with 5% employer contribution

Life assurance (2x salary)

Colleague product allowance

Colleague discount 25%

Job summary

Holland & Barrett is seeking a Resource Planning Manager to shape how we plan and manage resources across our Warehouse and Transport operations in Burton-on-Trent and Beverwijk, Netherlands. This role will build a resource planning system from the ground up using advanced Excel and macro development to drive visibility and smarter decisions.

You will partner with operational leaders across both locations to develop forecasts, rotas and capacity plans, leading cross-site workforce planning and

Qualifications

• Experience in resource or workforce planning within Warehouse, Distribution, Transport or Supply Chain environments.
• Advanced proficiency in Microsoft Excel, including building complex spreadsheets, formulas, models and macros.
• Experience developing Excel macros and automating processes, with the technical capability to build a resource planning system from the ground up.
• Experience creating or improving planning tools, systems and processes to increase operational efficiency.
• Strong analytical skills, with the ability to translate complex operational data into meaningful business recommendations.
• Experience partnering with operational leaders and influencing decisions across different teams or locations.
• Knowledge of workforce forecasting, capacity planning and resource optimisation.
• The ability to build effective relationships and collaborate with stakeholders across different functions.
• Experience managing or developing planning teams, with a proactive approach to continuous improvement.

Responsibilities

• Design and build a resource planning system from scratch, developing practical, scalable tools and processes to support Warehouse and Transport operations.
• Use advanced Excel functionality and develop macros to automate planning activities, improve reporting accuracy and streamline resource management.
• Partner with operational leadership teams across Burton and Beverwijk, providing expert resource planning advice and insight to support business decisions.
• Lead workforce and capacity planning across Warehouse and Transport operations, balancing service, productivity, efficiency and cost.
• Develop accurate resource forecasts, rotas and skills plans to meet changing operational requirements.
• Work collaboratively with People, Finance, Supply Chain and agency partners to align workforce strategies with business priorities.
• Plan proactively for seasonal peaks, promotional activity and future business needs across both locations.
• Use operational data and performance insights to identify risks, challenge existing approaches and recommend practical improvements.
• Support skills development and multi-skilling initiatives to build flexible, capable teams across both operations.

Skills

Resource planning

Advanced Excel

Macros

Data analysis

Stakeholder collaboration

Workforce planning

Tools

Microsoft Excel

Macros (VBA)

Job description

Holland & Barrett is seeking a Resource Planning Manager to shape how we plan and manage resources across our Warehouse and Transport operations in Burton-on-Trent and Beverwijk, Netherlands. This role will build a resource planning system from the ground up using advanced Excel and macro development to drive visibility and smarter decisions.

You will partner with operational leaders across both locations to develop forecasts, rotas and capacity plans, leading cross-site workforce planning and