Assessfy Business Functions Lab Advanced 6 milestones 100 marks

Designing a Demand Forecasting and S&OP Framework for an Indian FMCG Company

Function: Supply Chain Industry: FMCG Function: Supply Chain Type: Business-function applied project Team: up to 4 Assessment: 6 milestones (100 marks)

Real-world project · AICTE-aligned · AI-graded · Audit-ready certificate

Enroll as Student Mentor this project

Milestones

Available mentors

Enrolled students

Core skills

About this project

Objective: To develop a robust demand forecasting model and integrated S&OP process to optimize inventory and supply chain efficiency for an FMCG firm.

Context: Rapidly growing Indian FMCG companies face demand volatility due to changing consumer behavior, regional diversity, and seasonal effects, leading to inventory imbalances and service gaps.

Approach: The project involves collecting historical sales data, analyzing demand drivers, and benchmarking best practices in S&OP. The team will use statistical and machine learning methods to forecast demand and design a cross-functional S&OP process tailored to the company’s needs.

Deliverables: Students will deliver a data-driven demand forecasting model (e.g., ARIMA, regression, or Prophet), an S&OP process blueprint, scenario analysis, and KPIs to measure supply chain performance improvement.

Business Impact: The recommendations will enable better alignment of sales, inventory, and production planning, reducing stockouts and excess inventory, and supporting data-driven decision-making for the supply chain leadership team.

Milestones

1. Problem Definition & Business Case

10 marks 16d

Define the business challenge, scope, and objectives; submit a project charter and get stakeholder sign-off. Reviewed by faculty and company mentor.

2. Domain Research & Data Gathering

12 marks 22d

Conduct secondary research on FMCG S&OP best practices and collect relevant sales and inventory data from public sources or company records; submit a research summary and data quality report.

3. Solution Design / Methodology

16 marks 18d

Define forecasting methodology, S&OP design, and KPI framework; submit a detailed methodology and process flowchart for review.

4. Build / Analysis & Implementation

30 marks 36d

Develop and test forecasting models, simulate S&OP cycles, analyze scenarios, and create dashboards; submit model outputs and interim findings. Peer and faculty review.

5. Validation & Results

22 marks 28d

Validate model accuracy, review improvement in KPIs, and refine S&OP recommendations based on feedback; submit validation report and present results to stakeholders.

6. Final Report & Presentation

10 marks 20d

Prepare a comprehensive business report and deliver a professional presentation with actionable recommendations; assessed by faculty and company mentor.

Open internships using this project -->

Skills you'll learn

FMCGSupply ChainSupply chain process mapping and analysisStatistical and time-series forecasting techniquesData cleaning and visualizationCross-functional communication and stakeholder managementHands-on use of Excel and Python for modelingBusiness process documentationScenario analysis and KPI tracking

Tools used

Microsoft Excel for data analysis and visualizationPython (pandasstatsmodelsProphet for forecasting)Power BI or Tableau for dashboardsPublic FMCG sales datasets (e.g.Nielsencompany annual reportsKaggle datasets)S&OP frameworks (APICSGartner S&OP Maturity Model)Scenario analysis templates

Prerequisites

Basic statistics and data analysisOperations and supply chain managementExcel proficiencyIntroduction to business analytics or Python

Available mentors

No mentors have signed up for this project yet.

Be the first to mentor

You'll earn — Certificate (PDF)

AICTE-aligned Project Completion Certificate

A formal, audit-ready PDF certificate issued by Assessfy + your institute on successful completion. Includes AICTE credit hours, your evaluator's signature, and a QR code for third-party verification.

AICTE-aligned

Certificate of Project Completion

This is to certify that

has successfully completed the project

Designing a Demand Forecasting and S&OP Framework for an In…

Scan to Verify

Date

Signature

Auto-issued on completion QR-verifiable

You'll earn — Digital Badge

Shareable LinkedIn / Resume Skill Badge

A compact, verifiable Open-Badges-2.0-compliant digital credential. Add to your LinkedIn profile, GitHub README, or resume in one click. Recruiters can validate authenticity via a unique URL.

Advanced

Designing a Demand Forecasting and S&…

Assessfy

Auto-issued on completion One-click LinkedIn add