Hybrid Excel-Driven Forecast & Stock Planner (Edinburgh)

Lorien; City of Edinburgh; Hybrid; GBP 40,000 - 45,000; Full time

Job summary

Lorien is looking for a hands-on Supply and Demand Planner to own the forecasting and stock planning process from start to finish in Edinburgh. This is a true working planner role in a hybrid environment, with in-office 2/3 days per week and the remaining days remote.

You’ll turn sales trends, seasonality and promotions into accurate purchasing volumes across a wide product range. You will manage stock at SKU level, build routines, and deliver under pressure while collaborating with marketing,

Qualifications

• Excel: advanced level, used daily for forecasting, analysis and reporting.
• Planning: hands-on demand and supply forecasting, measure and improve accuracy.
• SKU management: confident managing range, availability and replenishment at SKU level.
• Stock control: hands-on stock level management, shelf life, waste and reconciliation.

Responsibilities

• Building short term and long-range forecasts and demand plans, and tracking their accuracy.
• Managing stock at SKU level, including reducing excess and short dated stock and keeping key lines available.
• Reconciling internal stock records against supplier and logistics partner figures.
• Calculating purchasing volumes and submitting them through a structured sales and operations planning process.
• Agreeing fortnightly production plans with our third party logistics partner.
• Producing weekly and month end stock reporting, including expiry and valuation.
• Working with marketing, buying and operations colleagues to build upcoming activity into your plans.
• Identifying ways to improve processes and automate reporting.

Skills

Excel

Planning

SKU management

Stock control

Job description

Lorien is looking for a hands-on Supply and Demand Planner to own the forecasting and stock planning process from start to finish in Edinburgh. This is a true working planner role in a hybrid environment, with in-office 2/3 days per week and the remaining days remote.

You’ll turn sales trends, seasonality and promotions into accurate purchasing volumes across a wide product range. You will manage stock at SKU level, build routines, and deliver under pressure while collaborating with marketing,