A Data-Driven Framework for Product Profitability, Margin Risk, and Portfolio Concentration: A Case Study of Nassau Candy Distributor

This paper presents an end-to-end business analytics framework for evaluating product-line profitability, margin quality, concentration risk, cost structure, and margin stability in a distributor portfolio. The empirical study uses 10,194 cleaned Nassau Candy Distributor transaction records covering 8,549 unique orders, 5,044 customers, 15 products, three divisions, four regions, and 59 states/provinces. The analysis integrates gross-margin and profit-per-unit metrics with product ranking, division level revenue–profit comparison, Pareto concentration, geographic dependency, portfolio-relative cost diagnostics, and margin volatility assessment. A methodological feature is the use of distribution-based thresholds for cost diagnostics: the first quartile of gross margin, third quartile of cost ratio, first quartiles of sales and gross profit, and median sales are used to identify cost heavy, margin-poor, repricing, cost-renegotiation, and discontinuation-review candidates. Results show that the company generated $141,783.63 in sales and $93,442.80 in gross profit, corresponding to an overall gross margin of 65.91%. Five Chocolate products account for 92.88% of revenue and 95.06% of gross profit, revealing substantial portfolio dependence. Kazookles is the clearest pricing/cost-risk product, with a 92.31% cost ratio and 7.69% gross margin, while Fun Dip, SweeTARTS, and Nerds meet the portfolio-relative criteria for discontinuation review. Geographic results show that 16 of 59 states/provinces account for approximately 80% of revenue and profit. The framework is operationalized through an interactive Streamlit dashboard with date, division, margin-threshold, and product-search controls. The study demonstrates how EDA, financial KPIs, concentration analysis, and interactive visualization can be combined into a practical product-portfolio decision-support system. This study presents a data-driven framework for evaluating product profitability, gross-margin performance, cost efficiency, profit concentration, geographic dependency, and margin volatility using the Nassau Candy Distributor dataset. The analytical framework integrates product- and division-level profitability metrics, Pareto analysis, quantile-based cost-structure diagnostics, and an interactive Streamlit decision-support dashboard.