End-to-end supply chain cost leakage analysis for a fictional Bangladeshi FMCG company — identifying ৳29.22 lakh in hidden costs across Procurement, Inventory, Logistics, and Fulfillment, with a prior
Bongo Consumer Products Ltd. (BCPL) is a fictional Bangladeshi FMCG company whose supply chain costs grew 18% over 2025 while revenue grew only 7%. Management had no visibility into where the money was going—or how to stop it.
This project builds a complete cost leakage diagnostic and recovery framework from the ground up: a Python data pipeline generating and cleaning synthetic supply chain data, a SQL Server star schema with 7 analytical views calculating leakage by supplier, route, and warehouse, and a 6-page Power BI dashboard delivering executive-ready insights with a prioritized 7-point recovery action plan.