At a Glance
- Tasks: Join a dynamic team to create and manage sales forecasts for MAPA and Spontex products.
- Company: Newell Brands is home to iconic brands like Parker, Spontex, and Yankee Candle.
- Benefits: Enjoy flexible hybrid working, unlimited LinkedIn Learning access, and discounts on popular products.
- Why this job: This role offers growth opportunities, a collaborative culture, and the chance to make an impact.
- Qualifications: Ideal candidates have planning experience, strong Excel skills, and are fluent in English.
- Other info: Work in a supportive environment with a focus on well-being and community involvement.
The predicted salary is between 30000 - 42000 £ per year.
Your Role & Team in a Nutshell
As a Jr Demand Planner, you will work closely with the sales and marketing teams to formalise and compile sales forecasts into a single demand plan for MAPA and Spontex products. This plan will be maintained in the demand planning tool (DSCP) to ensure the business can meet future customer orders. You will also review the valorised demand plan and compare it with the sales forecast, budget, and historical data. You will be part of a small, dynamic team of seven people based in Worcester.
We will help you achieve your goals and develop by providing regular feedback and access to online training courses.
Your Key Responsibilities:
- Hold regular S&OP Teams calls to align sales history with forecasts, discuss promotional activities, and validate forecast proposals.
- Coordinate with marketing and codification teams on product code switches and new product launches, updating DSCP accordingly.
- Maintain the product tracker for switches, launches, and discontinuations.
- Calculate and analyse forecast accuracy and forecast bias metrics monthly using Excel.
- Maintain the frozen period of supply and safety stock levels in DSCP.
- Provide a valorised demand plan based on demand quantities and average pricing using DSCP and Excel.
- Review and align the valorised demand plan with the Cluster Forecasting Tool (CFT) and budget/business forecast.
- Manage product shortages and work with Customer Services and Inventory Controller for equitable stock allocation.
- Review weekly demand plan updates and provide manual intervention using SAP and DSCP.
What You'll Need
- Minimum: First experience in planning for either sales, supply, demand, materials, distribution or other.
- Good MS Excel skills (preferably incl. pivot tables and VLOOKUP function).
- Fluent in English (written & spoken).
Your advantage:
- Detail oriented with the ability to analyze and understand large volumes of data.
- Strong interpersonal, communication, and collaborative skills.
- Self-starter with the ability to work independently.
- Experience with SAP.
What You Gain
Newell Brands has a strong footprint in the EMEA region, with several thousand employees spread over many corporate offices and manufacturing facilities. You might recognise some of our iconic brands, like Parker, Sistema, Spontex, Crockpot, NUK, Coleman, and Yankee Candle, to name a few.
Join us and benefit from:
- Flexible hybrid working system (on average 3 days in the office and 2 days at home p.w.)
- Unlimited access to LinkedIn Learning - 17,000+ courses for your professional and personal development.
- Corporate Citizenship Philosophies - environmentally sustainable and socially sensitive business practices.
- Discounts on some of our products from brands Parker, DYMO, Sharpie, Contigo, and others.
- Global Employee Assistance Program - confidential support for you and your family, complementing our commitment to your well-being at work and beyond.
- Give@Newell - paid time-off for charity activities dedicated for local communities right where you live/work.
- Access to Employee Resource Groups that foster an inclusive culture.
Core Values: Integrity, Teamwork, Passion for Winning, Ownership, Leadership.
Are you interested?
If so, please click on "Apply Now" on this site and upload your CV. If your application is shortlisted, our recruiter will invite you for an initial phone interview.
Junior Demand Planner - Mapa, Spontex employer: NEWELL
Contact Detail:
NEWELL Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Junior Demand Planner - Mapa, Spontex
✨Tip Number 1
Familiarise yourself with demand planning tools like DSCP and SAP, as these are crucial for the role. Consider taking online courses or tutorials to boost your confidence in using these systems.
✨Tip Number 2
Brush up on your Excel skills, especially with pivot tables and VLOOKUP functions. Being proficient in these areas will help you analyse data effectively and stand out during the interview.
✨Tip Number 3
Prepare to discuss your experience with sales forecasting and how you've collaborated with teams in the past. Highlight any specific examples where your input made a difference in demand planning.
✨Tip Number 4
Research Newell Brands and their product lines, particularly MAPA and Spontex. Understanding their market position and recent developments can give you an edge in interviews and show your genuine interest in the company.
We think you need these skills to ace Junior Demand Planner - Mapa, Spontex
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities of a Junior Demand Planner. Familiarise yourself with key tasks such as maintaining demand plans, coordinating with teams, and analysing forecast accuracy.
Tailor Your CV: Highlight relevant experience in planning, sales, or supply chain management. Emphasise your MS Excel skills, especially if you have experience with pivot tables and VLOOKUP, as these are crucial for the role.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the position and the company. Mention specific skills that align with the job description, such as your attention to detail and ability to analyse data.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any spelling or grammatical errors. A polished application reflects your professionalism and attention to detail.
How to prepare for a job interview at NEWELL
✨Know Your Numbers
As a Junior Demand Planner, you'll be dealing with forecasts and data analysis. Brush up on your Excel skills, especially pivot tables and VLOOKUP functions, as these will likely come up in your interview. Be prepared to discuss how you've used these tools in past experiences.
✨Understand the Role
Familiarise yourself with the key responsibilities of the role, such as maintaining the demand planning tool (DSCP) and coordinating with sales and marketing teams. Showing that you understand what the job entails will demonstrate your genuine interest in the position.
✨Prepare for Scenario Questions
Expect questions that assess your problem-solving abilities, especially regarding managing product shortages or aligning forecasts with sales history. Think of examples from your past experiences where you successfully navigated similar challenges.
✨Show Your Collaborative Spirit
This role requires strong interpersonal and communication skills. Be ready to share examples of how you've worked effectively in a team setting, particularly in cross-functional collaborations. Highlight your ability to align different departments towards a common goal.