Commercial Inventory Analyst

Commercial Inventory Analyst VBA SQL User jobs...

Posted today

Job Description

Demand Forecasting & Analysis

• Create and update both short- and long-term demand forecasts.
• Review historical sales, market movements, and seasonal trends to improve forecast accuracy.
• Identify and resolve forecast variances, providing actionable recommendations.
• Utilize statistical models and data-driven methods to strengthen forecasting efforts.

Cross-Functional Collaboration

• Coordinate with Sales, Marketing, Finance, and Operations to gather inputs for demand planning.
• Integrate promotions, new product launches, and customer insights into forecast projections.
• Take part in monthly Sales & Operations Planning (S&OP) meetings, presenting forecast updates and analyses.

Inventory & Supply Alignment

• Work with inventory and supply chain teams to ensure demand forecasts match supply availability.
• Track stock levels and support inventory management to avoid shortages or excess.
• Contribute to replenishment plans to sustain optimal service levels.

Systems & Reporting

• Manage forecasting data within ERP and demand planning tools such as SAP, Oracle, or NetSuite.
• Prepare regular reports and dashboards to measure forecast accuracy, inventory turnover, and related KPIs.
• Support the development and automation of reporting tools and planning workflows.

Process Improvement

• Spot opportunities to enhance demand planning processes and contribute to ongoing improvements.
• Assist in designing and refining standard operating procedures (SOPs) for forecasting and planning.

Job Type: Full-time

• Company Christmas gift
• Company events
• Opportunities for promotion
• Paid training
• Promotion to permanent employee

Demand Planning Officer

Posted 1 day ago

Job Description

JOB OBJECTIVE: This Demand Planning Officer position is responsible for all forecasting activities associated with Channels, Customers, Plants, Brands and SKUs. The Demand Planner holds the position of the key integration point into the key functional areas of Sales, Marketing, Finance, and Supply Chain.

DUTIES AND RESPONSIBILITIES: A. Accountabilities

a. Forecast Accuracy (KPI)

b. Use and maintain the Demand Planning data repository system (BW, BobJ and Anaplan) as the primary forecast and STD/STT performance system data reference, ensuring correctness and accuracy of data (product hierarchy, channel, and account maintenance etc.). Maintenance of these two business intelligence tools is significant on business decisions of key people from Sales, Marketing and Supply Chain, as follows:

• i. Analysis and recommendations from Sales/Marketing driven from historical data on STD/STT in volume/values; and,
• ii. 18-Mos Rolling Forecast in Anaplan/BobJ/BW as planning reference points of the Finance and Supply Chain organization. Master Production Schedule (MPS) for capacity planning, and Material Requirement Plan (MRP) for raw/packaging materials planning reference.

B. Communication

a. Interact with Sales, Marketing and VCG/SC to understand demand forecast drivers thru: Utilising a collaborative and consensus approach by working with Sales, Marketing and Supply Chain to obtain and ensure that current and accurate information is used for demand forecasts. Provide input to the Supply Planning organization in developing inventory strategies on existing items (ATL and BTL promotions), new products, and product phase-outs. Closely coordinate and communicate customer action plans with supply planning. Review sales plans, Latest Estimates, and demand drivers. Present, solicit, and assess feedback on the various forecasts from sales and marketing. Recommend adjustments for operational forecasts. Review promotional plans with sales. Prepare relevant material to facilitate analysis and discussion. Provide input to volume planning (Latest Estimates / annual process). Facilitates monthly, quarterly, and as needed, the Demand Management Review (DMR) on specific plant/category/brands as assigned.

C. Authority

a. Facilitates Demand Management Review Process meetings on categories/channel assigned. Only the Demand Management Group is authorized per Demand Management Review (DMR) Policy to run process. b. Maintains 18 months rolling forecast availability in system for Daily Performance Report tracking and MPS/MRP requirement. Only Demand Management Group is authorized to maintain 18-months rolling forecast in system (BW/BobJ/Anaplan/SAP).

FUNCTIONAL KNOWLEDGE / SKILL REQUIREMENTS

A. Education – College graduate, Business course, Statistics/Math and Planning related courses (eg. IE).

B. Experience / Expertise – Preferably at least 3-5 years as Demand Planner / Planner / Statistician or any relevant experience in the industry.

C. Skills / Competencies

• a. Demonstrated proficiency in statistics, forecasting and forecasting methods with an understanding of their financial and operational impacts. Knowledge of Demand Planning or other software related to demand planning is preferred.
• b. Experienced with other software packages including Windows, and Microsoft Office.
• c. This position requires strong analytical, organizational, decision making, and presentation skills.
• d. Strong interpersonal skills are also essential to effectively interact with all teams, areas and levels of business affecting the forecast process. Good facilitation skill is required.

Analyst, Demand Planning

Posted today

Job Description

Job Description: Are You Ready to Make It Happen at Mondelēz International? Join our Mission to Lead the Future of Snacking. Make It Possible. You will develop the 0-24-month IBP forecast by brand and at the stock keeping unit (SKU) level. You will coordinate, challenge and influence building block with input from sales, marketing and other partners. In addition, you will review the disaggregated short-term demand plan, which includes SKU/location mix and weekly pacing. Finally, you will provide the finalized detailed demand plan by SKU to supply planners and adjust it based on feedback from supply planners or commercial teams.

How You Will Contribute

• Contribute to the demand management cycle of the integrated business planning (IBP) process for your categories and to strategy and structure discussions
• Liaise with the commercial and operational teams and develop ways to continuously improve communication between the functions to support the delivery of the business KPIs for their families
• Manage forecast compilation process, which includes owning the short-term weekly plan and the long-term forecast (three or more months)
• Interact with modelling team to generate statistical forecasting
• Participate in the integrated business planning process and manage the demand planning tool
• Perform root-cause analysis for continuous plan improvement for key service issues, forecast error and bias, and share output with appropriate leadership

What You Will Bring

A desire to drive your future and accelerate your career and the following experience and knowledge:

• Experience in a fast-moving consumer goods or consumer packaged goods environment, preferably in food or other fast moving, dynamic industry where shelf life is a constraint
• Experience within an IBP/S&OP environment
• Able to influence cross-functional teams, working on priorities and improving the plan
• Excellent problem-solving skills, analytical skills – and able to understand and interpret data
• Strong verbal and written communication skills
• Team player who can work with many other functions on a daily basis

More About This Role

What you need to know about this position:

Education / Certifications:

Job specific requirements:

Travel requirements:

Work schedule:

No Relocation support available

Business Unit Summary

Mondelēz International in Southeast Asia is in five countries serving 19 markets with more than 18 nationalities and 7,500 employees. This group is emerging as one of the fastest growing regions in Asia, the Middle East and Africa, and we are proud of consistently producing high quality products in nine manufacturing sites. We are market leaders in key snacking categories, making and selling brands like Oreo and Tiger biscuits, Kinh Do mooncakes, Jacob's crackers, Cadbury Dairy Milk chocolate, Tang powdered beverage, Halls candy and Eden cheese. We set the benchmark in being a responsible business and contributing to the communities in which we operate.

Mondelēz International is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation or preference, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.

Job Type Regular

Demand Planning

Customer Service & Logistics

Demand Planning Associate

Posted today

Job Description

The Demand Planning Associate will ensure that every demand will be met by monitoring stock support. Provides a high level of forecast accuracy through trends analysis, prediction and optimization of Sales to Stock level. Assists the Demand Planning Supervisor in all forecasting and demand planning activities. Detail oriented, analytical, excel proficiency and strong mathematical abilities are needed for this role.

Data Analysis and Forecasting:

• Utilize statistical methods and analytical tools to interpret data and make informed decisions about demand planning strategies.
• Conduct current and future forecasting analysis, ensuring forecasting processes and methods are followed.
• Assemble and analyze all data pertinent to creating the sales forecast (historical sales, market trends, seasonality, promotions, and inventory levels).
• Submits accurate and timely information and analytics to assess the performance of the brand/category being handled against the prevailing goals and objectives.
• Perform competitive study by checking fashion trends and forecasts.
• Identify and mitigate potential risks related to demand planning, such as supply chain disruptions or changing market conditions.
• Keeps track of stocks/inventory movement in the warehouse and flags potential obsolescence for immediate action and move out.

Reporting and Presentation:

• Design and generate weekly and monthly statistical forecast reports
• Prepare, report, and communicate forecast and inventory measurements to management (forecast accuracy, inventory plan vs. targets).
• Conducts the Demand Planning/Forecast Review Meeting with Brand to come up with the standard Forecast on a monthly basis.
• Monitor SKU levels and recommend SKU rationalization initiatives in the future
• Monitors supply situations including replenishment and operational requirements
• Monitor and report on important changes in sales forecasts, budgets, and business strategies.

Job Type: Full-time

• Company Christmas gift
• Company events
• Opportunities for promotion
• Paid training
• Promotion to permanent employee

Education:

• Bachelor's (Preferred)

Language:

Demand Planning Manager

Posted today

Job Description

About the Opportunity: GA HR Consultancy Inc., an accredited headhunter, executive search, and talent acquisition partner for our client, a leading retail company specializing in the distribution of air conditioners, is seeking a skilled Demand Planning Manager. This position offers an exciting opportunity to lead demand planning efforts, optimize inventory levels, and ensure product availability to meet customer demand in a growing business.

As the Demand Planning Manager, you will be responsible for analyzing historical data, forecasting future demand, and collaborating with sales, procurement, and logistics teams to ensure smooth product flow from suppliers to customers.

Key Responsibilities:

• Demand Forecasting: Lead demand forecasting processes using historical data, market insights, and sales trends to predict future product demand.
• Inventory Management: Oversee inventory levels to ensure product availability while minimizing excess stock and reducing holding costs.
• Collaboration with Sales & Operations: Work closely with sales, procurement, and logistics teams to align demand forecasts with business goals and customer requirements.
• Data Analysis: Use analytical tools and techniques to assess demand patterns, identify discrepancies, and recommend solutions for optimal inventory management.
• Supply Chain Optimization: Identify opportunities to improve supply chain processes, ensuring efficient product flow and minimizing lead times.
• Performance Monitoring: Track demand forecast accuracy and recommend adjustments to improve forecasting methods and align with customer needs.
• Vendor Coordination: Collaborate with suppliers to ensure the timely delivery of products and coordinate stock replenishment to meet forecasted demand.

What We're Looking For:

• Education: Bachelor's degree in Business Administration, Supply Chain Management, Logistics, or related fields.
• Experience: At least 3 years of experience in demand planning or supply chain management, with at least 2-3 years in a leadership role.
• Skills & Knowledge: Strong understanding of demand forecasting, inventory management, and supply chain processes. Proficiency in Excel, forecasting software (e.g., SAP, Oracle, APICS). Excellent analytical, problem-solving, and data interpretation skills. Ability to collaborate effectively with cross-functional teams and communicate complex data insights. Strong organizational skills with the ability to manage multiple tasks simultaneously.

Why This Opportunity is Right for You:

• Competitive Salary: Based on qualifications and experience.
• Comprehensive Benefits: Health coverage, paid leave, and more.
• Career Growth: Leadership opportunities in a growing retail company with a dynamic supply chain environment.
• Collaborative Environment: Work in a team-driven environment focused on innovation and operational excellence.

Demand Planning Associate

Posted today

Job Description

The Demand Planning Associate will ensure that every demand will be met by monitoring stock support. Provides a high level of forecast accuracy through trends analysis, prediction and optimization of Sales to Stock level. Assists the Demand Planning Supervisor in all forecasting and demand planning activities. Detail oriented, analytical, excel proficiency and strong mathematical abilities are needed for this role.

Data Analysis and Forecasting:

• Utilize statistical methods and analytical tools to interpret data and make informed decisions about demand planning strategies.
• Conduct current and future forecasting analysis, ensuring forecasting processes and methods are followed.
• Assemble and analyze all data pertinent to creating the sales forecast (historical sales, market trends, seasonality, promotions, and inventory levels).
• Submits accurate and timely information and analytics to assess the performance of the brand/category being handled against the prevailing goals and objectives.
• Perform competitive study by checking fashion trends and forecasts.
• Identify and mitigate potential risks related to demand planning, such as supply chain disruptions or changing market conditions.
• Keeps track of stocks/inventory movement in the warehouse and flags potential obsolescence for immediate action and move out.

Reporting and Presentation:

• Design and generate weekly and monthly statistical forecast reports
• Prepare, report, and communicate forecast and inventory measurements to management (forecast accuracy, inventory plan vs. targets).
• Conducts the Demand Planning/Forecast Review Meeting with Brand to come up with the standard Forecast on a monthly basis.
• Monitor SKU levels and recommend SKU rationalization initiatives in the future
• Monitors supply situations including replenishment and operational requirements
• Monitor and report on important changes in sales forecasts, budgets, and business strategies.

Job Type: Full-time

• Company Christmas gift
• Company events
• Opportunities for promotion
• Paid training
• Promotion to permanent employee

Education:

• Bachelor's (Preferred)

Experience:

• Demand Planning : 1 year (Required)

Demand Planning Officer

Mandaluyong, National Capital Region ₱ - ₱ Y Sunnies Inc.

Posted 1 day ago

Job Description

AT A GLANCE

The Demand Planning Officer is responsible for monitoring demand forecasting, supply ordering, ABC analysis, and replenishment strategies of the assigned brand.

YOUR OVERALL MISSION & DAY-TO-DAY

Demand and Replenishment Strategy

• Work with cross functional teams including Inventory, Outbound Logistics, Inbound Logistics, and Merchandising to ensure proper demand forecasting and replenishment.
• Analyze and develop demand forecasting and replenishment strategies.

Demand Forecasting

• Develop effective forecast models based on industry trends and demand patterns.
• Review historical sales trends, research demand drivers, prepare forecast data, and evaluate forecast results.

Supply Ordering and Monitoring

• Manage inventory at a healthy level below plan target with optimum safety stocks and ensure no stock outs.
• Monitor bad stocks inventory (slow and non-moving SKUs) and ensure their inventory levels are within targets.

Forecast Accuracy

• Drive continuous improvement in forecasting accuracy and forecasting processes to positively impact stock outs, shrink, on shelf availability, sales, and margins.

ABC Analysis

• Categorize products into three categories (A, B, and C) to determine levels of importance.
• Optimize inventory levels and achieve efficient use of budget.

Demand and Replenishment Policies, SOPs, and Process Improvements

• Develop and implement demand and replenishment improvement related projects.

YOUR TALENT

• Bachelor's Degree in Business Management, Supply Chain, or related field
• At least 1 year of experience in demand forecasting and planning

Be The First To Know

About the latest Commercial inventory analyst vba sql user Jobsin Taguig

Set Email Alert:

Job title

Location

Demand Planning Head

Taguig, National Capital Region ₱ - ₱ Y 1Rotary Trading Corporation

Posted today

Job Description

The Demand Planning Head is responsible for all forecasting activities associated with products, channels, and depots. To attain sales and inventory level targets, he/she has to ensure a corresponding supply and purchasing plan, with periodic replenishment to the depots.

• Generates a sound & accurate statistical demand forecast per SKU bucketed into weeks, months, channel, depot, brand & category;
• Reviews, recommends & complies with inventory policies (M/EOQ, TIL, ROP, Safety stock, ABC classification) for FSL replenishment, periodic distribution & order fulfillment processes at a controlled &/or approved cost.
• Plans adjustments in both short term and long term plans based on surges (increase and decrease) in demand, unexpected shortages in material supply, and environmental & industry risks (like typhoons, and port congestion).
• Escalates the management of the current and potential product shortages and develops a quick recovery plan.
• Responds to all inquiries concerning demand, inventory, and other sales & marketing concerns.
• Supports New Product Introduction in achieving goals on Sales Attainment, Forecast Accuracy, Inventory levels, reorder points, lead times & process stability.
• Plans a phase-in/phase-out of SKUs and ensures communication to sales to minimize unserved.
• Arranges and processes the return of defective products to suppliers.

Job Requirements:

• Candidate must possess at least Bachelor's Degree in Engineering (Industrial), Mathematics, Economics, or equivalent.
• At least 10 years of working experience in demand planning is required.

Demand Planning Manager

Posted today

Job Description

Job Description: Develop effective forecast models based on industry trends and demand patterns.

• Support management with risk assessments and mitigation activities.
• Propose and implement solutions to improve demand forecast accuracy.
• Successfully communicate forecast and inventory estimations to management.
• Monitor and report on important changes in sales forecasts, budgets, and business strategies.
• Conduct monthly forecast maintenance.
• Address demand-related issues in a timely and effective manner

.

Job Specifications:

• Bachelor's degree in business, supply chain or other relevant fields.
• A minimum of 5 years experience in a demand planning/forecasting role.
• Solid understanding of inventory management practices and procedures.
• Strong mathematical and statistical knowledge.
• Must have a food industry background preferably in a group of restaurants
• Capability to multitask in a fast-paced environment.
• Excellent written and verbal communication skills
• Willing to start immediately
• Willing to work in Pasig

Analyst, Demand Planning

Posted today

Job Description

SC JOHNSON IS A FIFTH-GENERATION FAMILY COMPANY BUILT ON THE SPIRIT OF OUR PEOPLE. We have been leading with purpose for over 130 years, building iconic brands that win the hearts and minds of consumers – such as Raid, Glade, Ziploc and more, in virtually every country around the world. Together, we are creating a better future – for the planet, for future generations and for every SCJ team member. Join our winning team of Wave Makers and Go Getters and help us write the next chapter in the SCJ story.

To develop the baseline forecast through statistical modeling and analytics for the full portfolio they support using shipment history, historical events, and market trends.

Essential Duties and Responsibilities:

• Use and maintain current demand planning systems to create the best baseline forecast possible using established processes
• Assess the impact of market changes or significant variances in the forecast, and recommend appropriate revisions and tactics
• Manage statistical forecasting exceptions by utilizing demand-planning exception reports to identify and fix potential issues
• Make recommendations to enhance business processes, and identify opportunities to improve operational efficiencies
• Interact with Market Demand Planner and Marketing to understand and interpret the potential impact that market trends and demand drivers can have on demand, and adjust the statistical forecast to reflect those impacts
• Work with the Market Demand Planner to help maintain cleansed history in APO at the appropriate level and ensure a 24-month rolling forecast in APO
• Work with the Market Demand Planner to complete root cause analysis on forecast misses and incorporate properly into corrective actions with cross functional teams, history cleansing, and adjustments to the baseline forecast
• Measure, analyze, and communicate key process metrics and monitor adherence to key performance indicators, while driving continuous improvement
• Constant and clear communication with Cluster market demand planner on baseline forecast changes and impacts
• Key participant in yearly budget building process

Required Skills / Experience / Competencies:

• Bachelor's degree in Economics, Supply Chain Management, Engineering, or a related business field
• Minimum of 1 year of Supply Chain or Business experience
• Very good communication skills
• Experience in using PC-based applications (such as Microsoft Excel, PowerPoint, Word and/or Access)

Preferred Skills / Experience / Competencies:

• Hands-on experience in demand planning and simulation systems or tools
• Experience working in the Consumer Packed Goods industry is an advantage
• Working knowledge in process improvement
• Quantitative and qualitative data analysis, including business process metrics and measures linking to business KPIs

JOB REQUIREMENTS

• Onsite work setup (M-F);remote work once a week is available after 3 months
• Work Hours: 8:00AM or 9:00AM to 5:00PM or 6:00PM (Mondays thru Fridays)
• Overtime might be required depending on the critical deliverables
• This role is not eligible for relocation
• Overtime might be required depending on the critical deliverables and the urgent requirements of countries supported

Benefits & Culture:

SC Johnson is committed to providing a Great Place to Work for all its employees. Here are just some of the benefits you will receive when joining the SC Johnson Family:

• Competitive pay (up to 14th-month pay, pension plan, etc.)
• Health care benefits, a fitness centre and more
• A family-oriented program
• Independence and Autonomy

Inclusion & Diversity

We're a global business, with people from every culture, ethnicity, race, religion, gender identity, sexual orientation, age and ability. We recognize the breadth of human experience, and we work to celebrate it. It is our goal to build a diverse, inclusive and supportive work environment where all people can thrive.

We're committed to ongoing efforts that help us attract, hire, and retain diverse talent who want to build a positive, inclusive environment. Read more about our ongoing initiatives at

Not ready to apply? Sign up for Job Alerts.

#J-18808-Ljbffr

---