Student: Arya Mulay
Roll Number: 23F3002123
This repository documents a Business Data Management (BDM) capstone project completed as part of the IIT Madras Online BS Degree Program. The project focuses on solving real-world operational and financial challenges faced by a single-branch retail pharmacy operating in the Indian healthcare sector.
Using primary operational data collected directly from the organization, the study addresses two key business problems: scalability limitations caused by inefficient working capital utilization, and inventory inefficiencies resulting in overstocking and stockouts. The analysis integrates financial modeling, inventory analytics, and scenario-based simulations to derive data-driven insights.
The methodology includes working capital flow simulation, main branch profitability and reinvestment capacity analysis, monthly supply versus demand assessment, and Safety Stock and Reorder Point (ROP) modeling. All analytical choices are justified and aligned with BDM theory and business context.
The findings demonstrate that internal profit reinvestment is the most optimal and low-risk scalability strategy, while inventory optimization through scientific reorder policies significantly reduces capital lock-in and lost sales.
This project exemplifies the practical application of Business Data Management concepts using primary data to support informed managerial decision-making in small retail enterprises.
Final Grade Awarded: A (81/100)
- Proposal Evaluation (TA): Approved with 79/100, strong problem-solving approach (36/40) and clarity in objectives; minor feedback on quantification of outcomes and contextual business metrics.
- Mid-Term Evaluation (TA): Approved with 81/100, high scores in metadata and descriptive statistics (25/25) and methods analysis (24/25); suggestions focused on deeper justification of visualizations.
- Final Report Evaluation (TA): Approved with 80/100, excellent results and findings (34/40) and interpretation (18/20); minor remarks on clearer labeling and methodological exposition.
- Viva Voce Evaluation (Examiner): Evaluated with 83/100, strong articulation of primary data usage, analytical justification, business interpretation, and actionable recommendations.
#IITMadras #BDM #BusinessDataManagement #CapstoneProject #RetailAnalytics #PrimaryData