Supply & Demand Planner

Beer52.com | B-Corp; City of Edinburgh; On-site; GBP 40,000 - 60,000; Full time

Benefits offered by this job

Access to HQ facilities including gym/

Enhanced paternity leave and sick pay

Monthly beer and wine subscription

Job summary

Beer52 is seeking a Supply & Demand Planner to own short and long-range forecasts, aligning seasonal patterns and marketing activity to determine optimal purchasing volumes across beer, wine, whisky and coffee lines. You will build monthly themes, break plans into fortnightly production schedules with our 3PL partner, and report stock status with clear visuals.

You will collaborate with the Supply Chain Director and Operations Manager to reduce excess stock and improve forecasting accuracy,

Qualifications

• Experience in demand planning or forecasting, ideally in FMCG, food and drink or e-commerce.
• Highly numerate with advanced Excel or Google Sheets skills.
• Able to turn data into clear, visual reporting for the wider business.

Responsibilities

• Take account of current and future stock to create short, full-theme and long-range forecasts and demand plans.
• Collaborate with marketing to reflect plans in forecasting.
• Drive commercial opportunities through timing of themes with Head Buyers and ensure stock availability.
• Submit purchasing volumes for subscription and shop via S&OP process with sign-off from the Supply Chain Director.
• Report on stock levels, weekly progress on reducing excess and upcoming risks.
• Plan production with 3PL to minimise delays in dispatch.
• Plan brew and drawdown schedules for Welcome Box and non-core items; manage packaging and snacks.
• Identify opportunities to sell surplus stock through other Beer52 channels.
• Deliver peak forecasts and forward plans to manage volume increases.

Skills

Demand planning

Forecasting

Excel/Sheets

Data visualization

Stock control

3PL coordination

Communication

Process improvement

Job description

Beer52 | B Corp is the home of the UK’s No.1 craft beer club, and now a family of four discovery clubs spanning beer, wine, whisky and coffee. Each month, members receive hand-selected, small-batch products chosen by experts, delivered to their door alongside stories that bring each discovery to life, including Ferment, the UK’s No.1 craft beer magazine.

Our mission is to build the world’s leading community of curious drinkers, connecting people through discovery and a shared love of quality, independent producers. With over 9 million member reviews and counting, our community is at the heart of everything we do.

As a certified B Corp, carbon neutral business and accredited Living Wage employer, we’re committed to using business as a force for good. Based in Edinburgh, our team works in a fast-growing, collaborative environment where curiosity, creativity and a passion for great drinks and community-building are truly valued.

Role Description:

As our Supply & Demand Planner, you’ll play a pivotal role in getting the right products to our members at the right time. You’ll own our robust short and long-range forecasts and demand plans, bringing together seasonal patterns, customer trends and upcoming marketing activity to determine optimal purchasing volumes across all of our product types.

You’ll build the long-term view of our monthly themes, finding smart ways to put excess legacy kits and theme stock to good use where appropriate. From there, you’ll break that plan down into full theme forecasts and fortnightly production plans, agreed with our 3PL partner.

You’ll also be the go-to person for stock reporting, reconciling our internal view of stock against supplier stock levels, taking into account both regular reporting and every stock movement, so the business always has an accurate picture.

Great communication is key to success in this role. You’ll work closely with your own team and the wider business, bringing data to life through clear, visual reporting that gives everyone complete transparency.

Working alongside our Supply Chain Director and Operations Manager, you’ll have the opportunity to shape how we plan, driving improvements in forecasting accuracy and building processes that reduce excess stock and risk.

Key Responsibilities:

Planning & Forecasting

• Taking account of current and future stock, create and implement short, full-theme and long-range forecasts and demand plans.
• Collaborate with the marketing team to understand their plans and objectives and reflect these in forecasting.
• Partner with the Head Buyers to drive commercial opportunities through the strategic timing of themes, and to ensure consistent stock availability for retail opportunities and permanent listings with key partners .
• Calculate and submit purchasing volumes for subscription and shop through a defined S&OP process, using available technology to improve accuracy, and work with the Supply Chain Director to ensure a smooth sign-off.
• Report on overall stock levels, weekly progress on reducing excess and short-dated stock, and upcoming risks and priorities.
• Work with marketing, the Operations Manager and the Supply Chain Director to clear short-dated stock, including promotional packs and shop activity, so that every short-dated item has a plan and no expired product is used.
• Work with our 3PL to plan and direct production, minimising delays to order despatch.
• Work with the wider team to plan brew and drawdown schedules for Welcome Box beer and wine, and to ensure consistent availability of non-core items such as packaging, magazines and snacks.
• Identify opportunities to sell surplus stock through other Beer52 channels.
• Work with the Supply Chain Director and Operations Manager to deliver peak forecasts and forward plans that manage volume increases.
• Develop robust processes and tools that promote good practice and continuous improvement.

3PL Supervision

• Share forecasts as appropriate to allow for efficient production planning.
• Maintain an internal stock tracking system and carry out regular data quality checks to hold the 3PL to account and ensure FIFO/FEFO is followed.
• Work with the 3PL to assess whether damaged or expired stock is still usable.
• Provide product ID sheets and replacements promptly.
• Manage product listings and replenishment quantities for the online shop.

Reporting

• Develop clear reporting and visualisations to communicate key stock metrics, including stock count, valuation and depletion.
• Produce weekly stock expiry reports, focusing on stock with under 6 months and over 12 months of shelf life remaining, and a month-end stock valuation for the finance team.
• Create reporting templates for third parties as required.

Automation and Efficiency

• Work with the Supply Chain Director to identify key areas for improved automation and transparency using various technologies as deemed appropriate.

About you

• Experience in demand planning or forecasting, ideally in FMCG, food and drink or e-commerce.
• Highly numerate, with advanced Excel or Google Sheets skills.
• Able to turn data into clear, visual reporting for the wider business.
• Strong understanding of stock control, including short-dated stock.
• Confident working with 3PLs and suppliers.
• A clear communicator who builds strong relationships across teams.
• Organised and detail-focused, with a drive to improve processes and reduce waste.

What we offer

• The chance to influence and shape one of the fastest-growing areas of our business, with genuine scope for career progression.
• A collaborative, energetic working environment.
• Access to HQ facilities including private gym and sauna.
• Enhanced paternity leave and sick pay.
• A complimentary monthly subscription: 10 beers and 3 wines delivered to your door.