Executive Assistant

Job Description 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

• New 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.

7. 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 )