Assessfy Business Functions Lab Advanced 6 milestones 100 marks

Supplier Selection and Procurement Cost Optimisation Framework for Indian FMCG Firms

Function: Supply Chain Industry: Retail 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

6
Milestones
0
Available mentors
0
Enrolled students
9
Core skills
About this project

Objective: Develop a data-driven framework to optimise supplier selection and reduce procurement costs for FMCG companies in India.

Problem & Context: FMCG companies in India face challenges in selecting suppliers due to varying quality, costs, and reliability, impacting overall supply chain efficiency and profitability. Rising input costs and fragmented supplier networks further complicate decision-making.

Approach & Methodology: The student team will analyse procurement data, supplier profiles, and market benchmarks using structured frameworks such as the Analytic Hierarchy Process (AHP) and Total Cost of Ownership (TCO). Interviews with purchasing managers and benchmarking against industry best practices will supplement quantitative analysis.

Deliverables & Analysis: The project will produce a supplier evaluation matrix, cost optimisation strategies, and decision-support tools. Analysis will include cost-benefit comparisons, supplier risk assessment, and scenario modelling using real procurement datasets and Excel-based models.

Business Impact & Decision: The resulting framework will enable FMCG firms to make informed supplier selection decisions, negotiate better terms, and achieve measurable reductions in procurement costs, strengthening their supply chain resilience and competitiveness.

Milestones
1. Problem Definition & Business Case
10 marks 14d
Define supply chain challenges in supplier selection and procurement costs for Indian FMCG sector; submit business case and scope for faculty review.
2. Domain Research & Data Gathering
15 marks 28d
Collect procurement data, supplier profiles, and conduct interviews with purchasing managers; review by supervisor with data summary and insights.
3. Solution Design / Methodology
15 marks 21d
Design AHP and TCO-based supplier selection and cost optimisation framework; submit methodology document for peer and faculty feedback.
4. Build / Analysis & Implementation
25 marks 35d
Build supplier evaluation matrix, conduct cost-benefit and scenario analysis using Excel, Python, and Power BI; progress reviewed with interim dashboard.
5. Validation & Results
25 marks 35d
Test framework with real/simulated data; validate results with sector benchmarks and purchasing managers; submit results for faculty evaluation.
6. Final Report & Presentation
10 marks 28d
Compile final report with findings, recommendations, and business impact; deliver presentation to faculty and industry mentors for assessment.
Open internships using this project -->
Skills you'll learn
RetailSupply ChainSupply chain analysis and procurement strategyData analytics and quantitative modellingExcel and Power BI for scenario analysisSupplier evaluation using AHP/TCO frameworksCost optimisation and benchmarkingStakeholder interviewing and communicationReport writing and presentation skills
Tools used
Microsoft ExcelPower BIPython (for advanced analytics)SQL (for data extraction)Supplier procurement datasets (real or simulated)Analytic Hierarchy Process (AHP) frameworkTotal Cost of Ownership (TCO) modelIndustry benchmarking reports (e.g.NielsenCRISIL)
Prerequisites
Basic supply chain managementBusiness statistics or quantitative methodsOperations managementExcel proficiencyIntroduction to business analytics
Available mentors

No mentors have signed up for this project yet.

Be the first to mentor
Share
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.

Certificate of Project Completion

This is to certify that

has successfully completed the project

Supplier Selection and Procurement Cost Optimisation Framew…

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
Supplier Selection and Procurement Co…
Assessfy
Auto-issued on completion One-click LinkedIn add

Similar Projects you might like

Hand-picked by the recommender from your program & skill area.

Relevant Certifications to boost your application

From the Assessfy Certification library — take one and add it to your resume / LinkedIn before applying.

100 marks Advanced
Sign up & enroll