Demand Planning & S&OP; Coordination

1. Daily Unit-Wise Sales Report

- Extract daily sales data from SAP and compile it into a standardized unit-wise sales report.
- Validate and consolidate sales data to ensure accuracy and consistency.
- Share the daily sales report over mail with all PepsiCo stakeholders to support business monitoring and decision-making.

2. Monthly S&OP; M0 Demand Preparation

- Consolidate Pristine demand inputs received from relevant stakeholders and prepare demand comparison reports for review and finalization.
- Coordinate with Unit RLMs, Sales and Planning teams to review demand projections and identify opportunities for demand rationalization.
- Analyze demand variations against business expectations, historical sales and planning targets.
- Facilitate demand review discussions and incorporate agreed revisions to finalize the monthly M0 demand plan.

3. Demand File Ownership and Management

- Own and maintain the consolidated demand planning file covering all four units.
- Compile demand aspirations from all Unit RLMs at the CFA SKU level.
- Ensure timely consolidation, validation and updating of demand inputs.
- Adjust demand forecasts based on stakeholder feedback, business requirements, historical trends and supply constraints.

3.1 Weekly Demand Actualization

- Update the monthly demand plan with the latest actual sales data on a weekly basis.
- Share the updated demand file every Monday with stakeholders across all units.
- Track actual sales against planned demand and highlight significant deviations for corrective action.

3.2 Weekly Demand Compilation

- Collect weekly demand inputs from individual Unit RLMs.
- Consolidate all inputs into a single, standardized demand file at the CFA SKU level.
- Ensure completeness, accuracy and consistency of the consolidated demand data.

3.3 Weekly Demand Comparison and Analysis





- Prepare weekly demand comparison reports using relevant formulas, analytical approach.
- Compare demand across multiple reference points, including:
- Current week revision vs. previous week revision
- Current demand vs. M0 plan
- Current demand vs. Annual Operating Plan (AOP)
- Planned demand vs. historical sales,, YTD, YTD Yago growth %, etc
- Identify demand fluctuations, significant variances and trends to support informed decision-making.
- 3.4 Demand Review with Supply and Production Planning Teams
- Review demand variations with Supply Planning and Production Planning teams.
- Evaluate supply limitations, production constraints and operational feasibility.
- Incorporate stakeholder inputs and apply appropriate demand adjustments or cuts at a granular CFA SKU level.
- Ensure that demand revisions are aligned with business priorities and supply feasibility while minimizing unnecessary demand reductions.

3.5 Final Demand Communication and Daily Report Alignment

- Finalize and circulate the approved weekly demand plan to relevant stakeholders.
- Coordinate with the reporting team to ensure that the latest approved demand is accurately reflected in daily reports.
- Follow up on discrepancies, missing inputs, or data inconsistencies to ensure timely resolution.

3.6 Ad Hoc Reporting and Analytical Support

- Maintain the demand planning file and ensure data availability for business reviews and reporting requirements.




- Respond to ad hoc requests for sales data extraction, demand analysis and performance reporting.
- Extract and analyze sales data at different levels, such as unit, brand, CFA, and SKU, based on business requirements.
- Provide insights into sales trends, demand movements, and performance gaps to support business decisions.
- 4. S&OP; Presentation Preparation
- Prepare and maintain the monthly Sales and Operations Planning (S&OP;) presentation.
- Consolidate and present key business insights across multiple slides, including:
- Demand planning and demand trends

- Current Product Development (NPD)

- DC updates
- Demand phasing and monthly projections
- Ensure that all slides are accurate, well-structured, visually consistent, and aligned with the agreed reporting format.
- Coordinate with stakeholders to obtain the latest inputs and ensure timely completion of the presentation.
- 5. Unit Connect Preparation for S&OP;
- Prepare unit-wise and brand-level growth comparison reports for S&OP; discussions.
- Develop brand summaries highlighting growth trends, demand performance, etc.
- Prepare and analyze demand phasing to support monthly and periodic planning reviews.
- Consolidate relevant insights to facilitate unit-level performance reviews and cross-functional alignment.

6. Expiry Review Calls and Reporting

- Represent the Demand Planning team in expiry review calls.
- Prepare and circulate expiry summaries to relevant stakeholders.

1. Key Skills Required: Advanced EXCEL, Pivot Table, Mathematical calculations, Analytical Approach, Stakeholder communication.

Skills Analytical Thinking, Stakeholder communication, Demand Planning,Analytical Skills, Advance excel

Work Mode: Remote ( As per requirement need to report to office )

📌 Executive Assistant (Gurugram)
🏢 3SC
📍 Gurugram