Context and Data Preparation
Analysis Overview and Data Quality
Analysis Overview
Product Profitability Configuration
Analysis overview and configuration
test_1773213771
Key Insights
Analysis Overview
Purpose
This analysis evaluates product-level profitability across a 1,089-product portfolio spanning 2014–2017, identifying which products drive profit concentration, which operate at losses, and how profitability varies by category and time. The objective is to optimize product mix by understanding margin distribution, loss leader exposure, and category performance.
Key Findings
- Overall Margin: 13.17% across $1.67M revenue generating $219.6K profit—indicating thin margins typical of retail operations
- Profit Concentration: Top 228 products (21%) generate 80% of profit; top single product (Canon copier) contributes $25.2K (11.5% of total profit)
- Loss Leaders: 170 products (15.6%) operate at negative margins; 919 products (84.4%) are profitable
- Category Performance: Technology leads with 22.67% avg margin and $106K profit; Furniture underperforms at 3.07% margin and $18.9K profit
- Margin Distribution: 455 products cluster in 0–25% range; only 3 products exceed -50% loss threshold
Interpretation
The portfolio exhibits classic Pareto behavior: heavy reliance on a small profitable core subsidizes a large tail of marginal performers. Furniture’s weak profit
Key Insights
Analysis Overview
Purpose
This analysis evaluates product-level profitability across a 1,089-product portfolio spanning 2014–2017, identifying which products drive profit concentration, which operate at losses, and how profitability varies by category and time. The objective is to optimize product mix by understanding margin distribution, loss leader exposure, and category performance.
Key Findings
- Overall Margin: 13.17% across $1.67M revenue generating $219.6K profit—indicating thin margins typical of retail operations
- Profit Concentration: Top 228 products (21%) generate 80% of profit; top single product (Canon copier) contributes $25.2K (11.5% of total profit)
- Loss Leaders: 170 products (15.6%) operate at negative margins; 919 products (84.4%) are profitable
- Category Performance: Technology leads with 22.67% avg margin and $106K profit; Furniture underperforms at 3.07% margin and $18.9K profit
- Margin Distribution: 455 products cluster in 0–25% range; only 3 products exceed -50% loss threshold
Interpretation
The portfolio exhibits classic Pareto behavior: heavy reliance on a small profitable core subsidizes a large tail of marginal performers. Furniture’s weak profit
Data Preprocessing
Data Quality & Completeness
Data preprocessing and column mapping
Key Insights
Data Preprocessing
Purpose
This section documents the data intake and cleaning phase for the product-level P&L analysis. A 100% retention rate indicates no rows were filtered or removed during preprocessing, meaning all 9,994 transaction records proceeded to analysis. This is critical for ensuring the profitability insights, Pareto analysis, and loss leader detection reflect the complete dataset without selection bias.
Key Findings
- Retention Rate: 100% (9,994 rows retained) - No data loss occurred during preprocessing, preserving the full transaction population for analysis
- Rows Removed: 0 - No filtering, deduplication, or outlier removal was applied to the dataset
- Data Completeness: All 1,089 unique products and 9,994 transactions remained intact through the pipeline
- Train/Test Split: Not applicable - This is a descriptive P&L analysis, not a predictive modeling exercise
Interpretation
The perfect retention rate suggests either exceptionally clean source data or minimal preprocessing rigor. For a P&L analysis spanning 1,089 products across three categories, this means all revenue, cost, and margin calculations include every transaction without exclusion. However, the absence of any data quality interventions (no outlier handling, no missing value treatment) raises questions about whether problematic records—such as negative revenues or extreme margin anomalies—were genuinely
Key Insights
Data Preprocessing
Purpose
This section documents the data intake and cleaning phase for the product-level P&L analysis. A 100% retention rate indicates no rows were filtered or removed during preprocessing, meaning all 9,994 transaction records proceeded to analysis. This is critical for ensuring the profitability insights, Pareto analysis, and loss leader detection reflect the complete dataset without selection bias.
Key Findings
- Retention Rate: 100% (9,994 rows retained) - No data loss occurred during preprocessing, preserving the full transaction population for analysis
- Rows Removed: 0 - No filtering, deduplication, or outlier removal was applied to the dataset
- Data Completeness: All 1,089 unique products and 9,994 transactions remained intact through the pipeline
- Train/Test Split: Not applicable - This is a descriptive P&L analysis, not a predictive modeling exercise
Interpretation
The perfect retention rate suggests either exceptionally clean source data or minimal preprocessing rigor. For a P&L analysis spanning 1,089 products across three categories, this means all revenue, cost, and margin calculations include every transaction without exclusion. However, the absence of any data quality interventions (no outlier handling, no missing value treatment) raises questions about whether problematic records—such as negative revenues or extreme margin anomalies—were genuinely
Executive Summary
Key Findings and Recommendations
Executive Summary
Key Findings & Recommendations
Key Performance Indicators
Key Findings
Key findings
| Metric | Value |
|---|---|
| Total Revenue | $1,667,092 |
| Total Profit | $219,570.1 |
| Overall Margin | 13.2% |
| Products Analyzed | 1089 |
| Profitable Products | 919 (84.4%) |
| Loss Leaders | 170 (15.6%) |
| Top Product | Canon imageCLASS 2200 Advanced Copier ($25,199.93) |
| Pareto Vital Few | Top 228 of 1089 (20.9%) drive 80% of Profit |
Executive Summary
Bottom Line: Your 1089-product portfolio generated $219,570.1 in total Profit at a 13.2% overall margin from $1,667,092 in Sales. Strong Pareto concentration: top 228 products (20.9%) drive 80% of Profit. 170 products have negative margins (loss leaders).
Key Findings:
• Vital Few: Focus marketing and inventory on the top 228 products that drive the majority of Profit
• Top Performer: 'Canon imageCLASS 2200 Advanced Copier' generates $25,199.93 in Profit — protect and promote this winner
• Urgent Fixes: 170 loss leaders are bleeding money — reprice or discontinue ASAP
• Portfolio Health: 84.4% of products are profitable with positive margins
Recommendation: PRIORITY: Fix 170 loss leaders immediately to stop Profit leakage. Shift marketing budget to the vital few (228 products driving 80% of Profit) to maximize ROI. Consider discontinuing low-volume loss leaders that don't drive related sales. Potential Profit increase: Repricing loss leaders alone could swing thousands in annual Profit.
Key Insights
Executive Summary
EXECUTIVE SUMMARY
Purpose
This section synthesizes the complete product-level P&L analysis to assess whether the portfolio is optimized for profitability. It answers the core business question: which products drive value, which drain it, and where should management focus resources to maximize return on the $1.67M sales base.
Key Findings
- Overall Profitability: $219,570 profit on $1.67M revenue = 13.2% margin—modest but positive, indicating the portfolio is fundamentally viable
- Pareto Concentration: Top 228 products (20.9% of portfolio) generate 80% of profit, confirming classic vital-few distribution
- Loss Leader Burden: 170 products (15.6%) operate at negative margins, collectively destroying shareholder value
- Portfolio Health: 919 of 1,089 products (84.4%) are profitable, suggesting selective rather than systemic pricing problems
- Top Performer: Canon imageCLASS 2200 generates $25,200 profit alone—11.5% of total portfolio profit from one SKU
Interpretation
The analysis confirms the business objective was achieved: clear identification of profit drivers, loss leaders, and margin distribution. The portfolio exhibits healthy Pareto structure—concentrated profit in a manageable subset—but is handicapped by 170
Key Insights
Executive Summary
EXECUTIVE SUMMARY
Purpose
This section synthesizes the complete product-level P&L analysis to assess whether the portfolio is optimized for profitability. It answers the core business question: which products drive value, which drain it, and where should management focus resources to maximize return on the $1.67M sales base.
Key Findings
- Overall Profitability: $219,570 profit on $1.67M revenue = 13.2% margin—modest but positive, indicating the portfolio is fundamentally viable
- Pareto Concentration: Top 228 products (20.9% of portfolio) generate 80% of profit, confirming classic vital-few distribution
- Loss Leader Burden: 170 products (15.6%) operate at negative margins, collectively destroying shareholder value
- Portfolio Health: 919 of 1,089 products (84.4%) are profitable, suggesting selective rather than systemic pricing problems
- Top Performer: Canon imageCLASS 2200 generates $25,200 profit alone—11.5% of total portfolio profit from one SKU
Interpretation
The analysis confirms the business objective was achieved: clear identification of profit drivers, loss leaders, and margin distribution. The portfolio exhibits healthy Pareto structure—concentrated profit in a manageable subset—but is handicapped by 170
Top Profitable Products
Top 20 Products by Total Profit with Revenue Comparison
Top Profitable Products
Top 20 Products by Total Profit
Top 20 most profitable products ranked by total Profit
Key Insights
Top Profitable Products
Purpose
This section identifies the 20 most profitable products by absolute profit contribution, revealing which items drive the greatest financial value to the business. Understanding profit leaders is essential for P&L analysis, as it shows which products justify inventory investment and marketing focus despite varying revenue and margin profiles.
Key Findings
- Top Performer: Canon imageCLASS 2200 Advanced Copier generates $25,199.93 profit (40.91% margin) on $61,599.82 revenue—accounting for ~11.5% of total company profit from a single product
- Profit Concentration: Top 5 products contribute $46,880.14 in profit, representing ~21% of total company profit despite being only 0.5% of the product portfolio
- Margin Variance: Top 20 products average 27.74% margin (mean), significantly above the overall 13.17% company margin, indicating elite profitability
- Revenue-Profit Disconnect: Apple iPhone 5 ranks 20th in profit ($1,611.58) despite $12,996.60 revenue, showing 12.4% margin—demonstrating that high sales don’t guarantee strong profit contribution
Interpretation
The top 20 products represent a highly profitable segment where both volume and margin align favorably. The Canon copier exemplifies this—
Key Insights
Top Profitable Products
Purpose
This section identifies the 20 most profitable products by absolute profit contribution, revealing which items drive the greatest financial value to the business. Understanding profit leaders is essential for P&L analysis, as it shows which products justify inventory investment and marketing focus despite varying revenue and margin profiles.
Key Findings
- Top Performer: Canon imageCLASS 2200 Advanced Copier generates $25,199.93 profit (40.91% margin) on $61,599.82 revenue—accounting for ~11.5% of total company profit from a single product
- Profit Concentration: Top 5 products contribute $46,880.14 in profit, representing ~21% of total company profit despite being only 0.5% of the product portfolio
- Margin Variance: Top 20 products average 27.74% margin (mean), significantly above the overall 13.17% company margin, indicating elite profitability
- Revenue-Profit Disconnect: Apple iPhone 5 ranks 20th in profit ($1,611.58) despite $12,996.60 revenue, showing 12.4% margin—demonstrating that high sales don’t guarantee strong profit contribution
Interpretation
The top 20 products represent a highly profitable segment where both volume and margin align favorably. The Canon copier exemplifies this—
Pareto Analysis
Concentration of Profit in Vital Few Products
Pareto Analysis
Cumulative Profit Concentration (80/20 Rule)
Pareto principle: percentage of products driving 80% of total Profit
Key Insights
Pareto Analysis
Purpose
This section applies the Pareto principle to identify which products are profit drivers. By ranking all 1,089 products by profitability and calculating cumulative profit contribution, it reveals the concentration of profit generation. Understanding this distribution is critical for portfolio management and resource allocation in the P&L analysis.
Key Findings
- Pareto Cutoff Rank: 228 products (20.9% of portfolio) - These vital few products generate 80% of total profit
- Profit Concentration: The top product alone contributes $25,199.93, while the median product contributes only $59.57, indicating extreme skewness
- Tail Risk: 170 loss-leader products generate negative profit, dragging overall margin to 13.17%
- Steep Initial Curve: The cumulative profit percentage climbs rapidly through the first 228 products, then plateaus, confirming classic Pareto distribution
Interpretation
The data demonstrates severe profit concentration typical of product portfolios. Just one-fifth of products account for four-fifths of profit, while the remaining 861 products contribute minimally or negatively. This pattern reflects the reality that high-value items (copiers, binding machines, accessories) drive profitability, whereas commodity office supplies and furniture generate thin or negative margins. The presence of 170 loss leaders suggests strategic
Key Insights
Pareto Analysis
Purpose
This section applies the Pareto principle to identify which products are profit drivers. By ranking all 1,089 products by profitability and calculating cumulative profit contribution, it reveals the concentration of profit generation. Understanding this distribution is critical for portfolio management and resource allocation in the P&L analysis.
Key Findings
- Pareto Cutoff Rank: 228 products (20.9% of portfolio) - These vital few products generate 80% of total profit
- Profit Concentration: The top product alone contributes $25,199.93, while the median product contributes only $59.57, indicating extreme skewness
- Tail Risk: 170 loss-leader products generate negative profit, dragging overall margin to 13.17%
- Steep Initial Curve: The cumulative profit percentage climbs rapidly through the first 228 products, then plateaus, confirming classic Pareto distribution
Interpretation
The data demonstrates severe profit concentration typical of product portfolios. Just one-fifth of products account for four-fifths of profit, while the remaining 861 products contribute minimally or negatively. This pattern reflects the reality that high-value items (copiers, binding machines, accessories) drive profitability, whereas commodity office supplies and furniture generate thin or negative margins. The presence of 170 loss leaders suggests strategic
Margin Distribution
Portfolio Health and Margin Spread
Margin Distribution
Product Count by Profit Margin Range
Distribution of Profit margins across all products
Key Insights
Margin Distribution
Purpose
This section visualizes how profit margins are distributed across the 1,089-product portfolio, revealing the health of pricing strategy and cost control. Understanding margin distribution is critical for the P&L analysis objective, as it identifies whether profitability is concentrated in a few products or broadly distributed, and quantifies the extent of loss-leader activity.
Key Findings
- Positive Margin Products: 919 products (84.4%) generate profit, indicating a fundamentally healthy portfolio structure
- Loss-Leader Products: 170 products (15.6%) operate at negative margins, representing deliberate or unintended margin erosion
- Dominant Cluster: 464 products (42.6%) fall in the 25–50% margin bin, showing strong concentration in the profitable range
- Negative Margin Concentration: 170 loss leaders are distributed across three bins (<−50%, −50 to −25%, −25 to 0%), with 148 products in the −25 to 0% range
Interpretation
The right-skewed distribution—with the largest product cluster in positive margins and zero products exceeding 50% margins—reflects a portfolio optimized for steady profitability rather than premium pricing. The 15.6% loss-leader rate is material but manageable, suggesting these products may serve strategic purposes (customer acquisition, bundling
Key Insights
Margin Distribution
Purpose
This section visualizes how profit margins are distributed across the 1,089-product portfolio, revealing the health of pricing strategy and cost control. Understanding margin distribution is critical for the P&L analysis objective, as it identifies whether profitability is concentrated in a few products or broadly distributed, and quantifies the extent of loss-leader activity.
Key Findings
- Positive Margin Products: 919 products (84.4%) generate profit, indicating a fundamentally healthy portfolio structure
- Loss-Leader Products: 170 products (15.6%) operate at negative margins, representing deliberate or unintended margin erosion
- Dominant Cluster: 464 products (42.6%) fall in the 25–50% margin bin, showing strong concentration in the profitable range
- Negative Margin Concentration: 170 loss leaders are distributed across three bins (<−50%, −50 to −25%, −25 to 0%), with 148 products in the −25 to 0% range
Interpretation
The right-skewed distribution—with the largest product cluster in positive margins and zero products exceeding 50% margins—reflects a portfolio optimized for steady profitability rather than premium pricing. The 15.6% loss-leader rate is material but manageable, suggesting these products may serve strategic purposes (customer acquisition, bundling
Loss Leaders
Products with Negative Margins Requiring Action
Loss Leaders
Bottom 10 Products with Negative Margins
Bottom 10 loss leaders with negative Profit margins that need repricing or discontinuation
Key Insights
Loss Leaders
Purpose
This section identifies the 10 most severe loss leaders—products with deeply negative profit margins that are actively eroding overall portfolio profitability. Loss leaders represent 15.6% of the 1,089-product portfolio (170 products), and understanding their severity and volume is critical for pricing strategy and product viability decisions within the P&L analysis framework.
Key Findings
- Margin Range: -99.33% to -38.27% (mean: -51.56%) — extreme negative margins indicating costs far exceed selling prices
- Total Loss Concentration: Top 10 loss leaders collectively lose ~$688 across modest revenue (~$1,559), demonstrating profitability drain despite low sales volume
- Order Frequency: 5–9 orders per product (mean: 7.3) — consistent but unprofitable demand, suggesting systematic pricing misalignment rather than isolated transactions
- Revenue Paradox: Premier Elliptical Ring Binder generates $526.61 revenue yet loses $201.51, while GBC Plasticlear Covers loses $68.42 on just $68.88 revenue—both unsustainable
Interpretation
These loss leaders represent a structural pricing problem: customers are purchasing at prices below cost. The consistent order frequency (5–9 per product) indicates these aren’t anomalies
Key Insights
Loss Leaders
Purpose
This section identifies the 10 most severe loss leaders—products with deeply negative profit margins that are actively eroding overall portfolio profitability. Loss leaders represent 15.6% of the 1,089-product portfolio (170 products), and understanding their severity and volume is critical for pricing strategy and product viability decisions within the P&L analysis framework.
Key Findings
- Margin Range: -99.33% to -38.27% (mean: -51.56%) — extreme negative margins indicating costs far exceed selling prices
- Total Loss Concentration: Top 10 loss leaders collectively lose ~$688 across modest revenue (~$1,559), demonstrating profitability drain despite low sales volume
- Order Frequency: 5–9 orders per product (mean: 7.3) — consistent but unprofitable demand, suggesting systematic pricing misalignment rather than isolated transactions
- Revenue Paradox: Premier Elliptical Ring Binder generates $526.61 revenue yet loses $201.51, while GBC Plasticlear Covers loses $68.42 on just $68.88 revenue—both unsustainable
Interpretation
These loss leaders represent a structural pricing problem: customers are purchasing at prices below cost. The consistent order frequency (5–9 per product) indicates these aren’t anomalies
Category Comparison
Profitability Across Product Categories
Category Comparison
Profitability by Product Category
Profitability comparison across product categories
Key Insights
Category Comparison
Purpose
This section evaluates profitability performance across the three product categories to identify which segments drive overall business profit and margin performance. Understanding category-level profitability is essential for resource allocation decisions and identifying which product lines merit strategic focus within the broader P&L analysis.
Key Findings
- Technology Category: $106,089 total profit (48% of portfolio) with 22.67% average margin across 188 products—highest profitability despite smallest product count
- Office Supplies Category: $94,566 total profit (43% of portfolio) with 16.21% average margin across 658 products—largest product base with solid margin performance
- Furniture Category: $18,915 total profit (9% of portfolio) with 3.07% average margin across 243 products—significantly underperforming on both margin and absolute profit
- Efficiency Gap: Technology generates 56% more profit than Furniture while managing 23% fewer products, indicating vastly different unit economics
Interpretation
The data reveals a stark efficiency divide: Technology products deliver premium margins (22.67%) on a lean portfolio, while Furniture struggles with near-breakeven margins (3.07%) despite substantial product volume. Office Supplies occupies the middle ground, balancing scale (658 products) with respectable margins (16.21%). This pattern suggests Technology products
Key Insights
Category Comparison
Purpose
This section evaluates profitability performance across the three product categories to identify which segments drive overall business profit and margin performance. Understanding category-level profitability is essential for resource allocation decisions and identifying which product lines merit strategic focus within the broader P&L analysis.
Key Findings
- Technology Category: $106,089 total profit (48% of portfolio) with 22.67% average margin across 188 products—highest profitability despite smallest product count
- Office Supplies Category: $94,566 total profit (43% of portfolio) with 16.21% average margin across 658 products—largest product base with solid margin performance
- Furniture Category: $18,915 total profit (9% of portfolio) with 3.07% average margin across 243 products—significantly underperforming on both margin and absolute profit
- Efficiency Gap: Technology generates 56% more profit than Furniture while managing 23% fewer products, indicating vastly different unit economics
Interpretation
The data reveals a stark efficiency divide: Technology products deliver premium margins (22.67%) on a lean portfolio, while Furniture struggles with near-breakeven margins (3.07%) despite substantial product volume. Office Supplies occupies the middle ground, balancing scale (658 products) with respectable margins (16.21%). This pattern suggests Technology products
Sub-Category Comparison
Profitability Across Product Sub-Categories
Sub-Category Comparison
Profitability by Product Sub-Category
Profitability comparison across product sub-categories
Key Insights
Sub-Category Comparison
Purpose
This section reveals profitability performance across 17 product sub-categories, providing granular insight beyond top-level category analysis. Understanding sub-category margins helps identify which specific product types drive the overall 13.17% portfolio margin and which are underperforming, enabling targeted optimization of product mix and pricing strategy.
Key Findings
- Copiers: $43,223.54 profit (37.3% margin) across 8 products—highest absolute and relative profitability
- Paper: $26,833.52 profit with 43.52% margin—strongest margin despite lower absolute profit than Copiers
- Tables: -$12,475.83 loss (−7.62% margin) across 36 products—largest drag on portfolio profitability
- Margin Disparity: Range spans 51 percentage points (−7.62% to 43.52%), indicating significant structural differences in sub-category economics
- Scale Mismatch: Binders (170 products, 14.02% margin) generate less profit than Copiers (8 products, 37.3% margin), suggesting volume doesn’t compensate for margin weakness
Interpretation
Sub-categories exhibit stark profitability divergence. High-margin sub-categories (Paper, Copiers, Fasteners) operate with fundament
Key Insights
Sub-Category Comparison
Purpose
This section reveals profitability performance across 17 product sub-categories, providing granular insight beyond top-level category analysis. Understanding sub-category margins helps identify which specific product types drive the overall 13.17% portfolio margin and which are underperforming, enabling targeted optimization of product mix and pricing strategy.
Key Findings
- Copiers: $43,223.54 profit (37.3% margin) across 8 products—highest absolute and relative profitability
- Paper: $26,833.52 profit with 43.52% margin—strongest margin despite lower absolute profit than Copiers
- Tables: -$12,475.83 loss (−7.62% margin) across 36 products—largest drag on portfolio profitability
- Margin Disparity: Range spans 51 percentage points (−7.62% to 43.52%), indicating significant structural differences in sub-category economics
- Scale Mismatch: Binders (170 products, 14.02% margin) generate less profit than Copiers (8 products, 37.3% margin), suggesting volume doesn’t compensate for margin weakness
Interpretation
Sub-categories exhibit stark profitability divergence. High-margin sub-categories (Paper, Copiers, Fasteners) operate with fundament
Profit Trends
Monthly Profit Evolution by Category
Profit Trends
Monthly Profit by Top Categories
Monthly Profit trends over time by top categories
Key Insights
Profit Trends
Purpose
This section tracks how profitability and margins have evolved across product categories from 2014–2017, revealing whether the business is experiencing margin improvement or erosion. Understanding these trends is critical for identifying cost pressures, pricing effectiveness, and seasonal patterns that inform forecasting and strategic decisions.
Key Findings
- Monthly Profit Range: $-3,014 to $11,708 across all categories, with mean of $1,989 and high variability (SD: $2,385)
- Margin Volatility: Monthly margins span -25.67% to +37.13%, indicating significant fluctuation rather than stable improvement
- Category Distribution: Three categories tracked over 48 months (4 years), with 16 observations per category
- Trend Pattern: Late 2017 Technology data shows stronger margins (15–25%), suggesting recent improvement in that segment
Interpretation
The data reveals inconsistent profitability trends across the analysis period. While Technology shows recent strength in Q4 2017 with margins reaching 23–25%, the overall volatility (negative margins in early periods, wide swings) suggests margin erosion has been a persistent challenge. The high standard deviation relative to mean profit indicates seasonal or operational factors significantly impact monthly performance, making year-over-year comparison essential for distinguishing true improvement from cyclical patterns.
Context
Key Insights
Profit Trends
Purpose
This section tracks how profitability and margins have evolved across product categories from 2014–2017, revealing whether the business is experiencing margin improvement or erosion. Understanding these trends is critical for identifying cost pressures, pricing effectiveness, and seasonal patterns that inform forecasting and strategic decisions.
Key Findings
- Monthly Profit Range: $-3,014 to $11,708 across all categories, with mean of $1,989 and high variability (SD: $2,385)
- Margin Volatility: Monthly margins span -25.67% to +37.13%, indicating significant fluctuation rather than stable improvement
- Category Distribution: Three categories tracked over 48 months (4 years), with 16 observations per category
- Trend Pattern: Late 2017 Technology data shows stronger margins (15–25%), suggesting recent improvement in that segment
Interpretation
The data reveals inconsistent profitability trends across the analysis period. While Technology shows recent strength in Q4 2017 with margins reaching 23–25%, the overall volatility (negative margins in early periods, wide swings) suggests margin erosion has been a persistent challenge. The high standard deviation relative to mean profit indicates seasonal or operational factors significantly impact monthly performance, making year-over-year comparison essential for distinguishing true improvement from cyclical patterns.
Context
Product P&L Table
Complete Financial Detail for All Products
Product P&L Table
Complete Product-Level Financial Detail
Complete product-level P&L table with Sales, cost, Profit, and margin metrics
| Product Name | Category | total_revenue | total_cost | total_profit | profit_margin_pct | order_count | profit_rank |
|---|---|---|---|---|---|---|---|
| Canon imageCLASS 2200 Advanced Copier | Technology | 61599.824 | 36399.896 | 25199.928 | 40.910 | 5.000 | 1.000 |
| Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind | Office Supplies | 27453.384 | 19700.345 | 7753.039 | 28.240 | 10.000 | 2.000 |
| Hewlett Packard LaserJet 3310 Copier | Technology | 18839.686 | 11855.802 | 6983.884 | 37.070 | 8.000 | 3.000 |
| Plantronics Savi W720 Multi-Device Wireless Headset System | Technology | 9367.290 | 5671.008 | 3696.282 | 39.460 | 7.000 | 4.000 |
| Honeywell Enviracaire Portable HEPA Air Cleaner for 17' x 22' Room | Office Supplies | 11304.440 | 8057.420 | 3247.020 | 28.720 | 8.000 | 5.000 |
| Hewlett Packard 610 Color Digital Copier / Printer | Technology | 8899.822 | 5774.885 | 3124.938 | 35.110 | 7.000 | 6.000 |
| Plantronics CS510 - Over-the-Head monaural Wireless Headset System | Technology | 10822.360 | 7737.328 | 3085.032 | 28.510 | 10.000 | 7.000 |
| Canon Imageclass D680 Copier / Fax | Technology | 8959.872 | 6159.912 | 2799.960 | 31.250 | 5.000 | 8.000 |
| Fellowes PB300 Plastic Comb Binding Machine | Office Supplies | 8070.192 | 5552.137 | 2518.055 | 31.200 | 6.000 | 9.000 |
| Ibico Ibimaster 300 Manual Binding System | Office Supplies | 7985.383 | 5667.046 | 2318.337 | 29.030 | 8.000 | 10.000 |
| GBC DocuBind TL300 Electric Binding System | Office Supplies | 19823.479 | 17589.974 | 2233.505 | 11.270 | 11.000 | 11.000 |
| Razer Tiamat Over Ear 7.1 Surround Sound PC Gaming Headset | Technology | 5119.744 | 2963.852 | 2155.892 | 42.110 | 7.000 | 12.000 |
| Hot File 7-Pocket, Floor Stand | Office Supplies | 8138.232 | 6121.521 | 2016.711 | 24.780 | 13.000 | 13.000 |
| Adjustable Depth Letter/Legal Cart | Office Supplies | 7730.196 | 5797.647 | 1932.549 | 25.000 | 12.000 | 14.000 |
| Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | Furniture | 10637.528 | 8710.086 | 1927.442 | 18.120 | 12.000 | 15.000 |
| Samsung Galaxy Mega 6.3 | Technology | 13943.668 | 12120.911 | 1822.757 | 13.070 | 6.000 | 16.000 |
| Sharp 1540cs Digital Laser Copier | Technology | 4399.920 | 2749.950 | 1649.970 | 37.500 | 7.000 | 17.000 |
| Logitech P710e Mobile Speakerphone | Technology | 10196.604 | 8551.243 | 1645.361 | 16.140 | 9.000 | 18.000 |
| Dual Level, Single-Width Filing Carts | Office Supplies | 6574.544 | 4934.009 | 1640.535 | 24.950 | 9.000 | 19.000 |
| Apple iPhone 5 | Technology | 12996.600 | 11385.022 | 1611.578 | 12.400 | 6.000 | 20.000 |
| GBC DocuBind TL200 Manual Binding Machine | Office Supplies | 4322.814 | 2730.316 | 1592.498 | 36.840 | 6.000 | 21.000 |
| Tennsco 6- and 18-Compartment Lockers | Office Supplies | 10925.004 | 9349.894 | 1575.110 | 14.420 | 11.000 | 22.000 |
| Global Deluxe High-Back Manager's Chair | Furniture | 8665.194 | 7106.603 | 1558.591 | 17.990 | 8.000 | 23.000 |
| Dot Matrix Printer Tape Reel Labels, White, 5000/Box | Office Supplies | 3322.878 | 1804.972 | 1517.906 | 45.680 | 8.000 | 24.000 |
| Canon PC-428 Personal Copier | Technology | 4119.794 | 2649.867 | 1469.927 | 35.680 | 6.000 | 25.000 |
| Logitech diNovo Edge Keyboard | Technology | 7399.704 | 5967.261 | 1432.443 | 19.360 | 5.000 | 26.000 |
| Hon 4070 Series Pagoda Armless Upholstered Stacking Chairs | Furniture | 8430.997 | 7042.362 | 1388.635 | 16.470 | 8.000 | 27.000 |
| Iceberg Mobile Mega Data/Printer Cart | Office Supplies | 5751.774 | 4363.166 | 1388.608 | 24.140 | 8.000 | 28.000 |
| Deluxe Rollaway Locking File with Drawer | Office Supplies | 5572.792 | 4192.070 | 1380.722 | 24.780 | 5.000 | 29.000 |
| Office Star - Professional Matrix Back Chair with 2-to-1 Synchro Tilt and Mesh Fabric Seat | Furniture | 8774.500 | 7468.854 | 1305.646 | 14.880 | 8.000 | 30.000 |
| Xerox 1915 | Office Supplies | 2789.010 | 1526.616 | 1262.394 | 45.260 | 9.000 | 31.000 |
| Standard Rollaway File with Lock | Office Supplies | 6594.954 | 5333.624 | 1261.330 | 19.130 | 10.000 | 32.000 |
| GE 48" Fluorescent Tube, Cool White Energy Saver, 34 Watts, 30/Box | Furniture | 2699.056 | 1438.835 | 1260.221 | 46.690 | 8.000 | 33.000 |
| Letter Size Cart | Office Supplies | 4600.092 | 3347.210 | 1252.882 | 27.240 | 8.000 | 34.000 |
| Hon GuestStacker Chair | Furniture | 6936.102 | 5703.017 | 1233.085 | 17.780 | 9.000 | 35.000 |
| SAFCO Arco Folding Chair | Furniture | 11572.780 | 10393.406 | 1179.374 | 10.190 | 13.000 | 36.000 |
| Panasonic KX-TG9471B | Technology | 4978.146 | 3810.046 | 1168.100 | 23.460 | 7.000 | 37.000 |
| Brother DCP1000 Digital 3 in 1 Multifunction Machine | Technology | 4859.838 | 3704.876 | 1154.961 | 23.770 | 7.000 | 38.000 |
| Panasonic KX-TG9541B DECT 6.0 Digital 2-Line Expandable Cordless Phone With Digital Answering System | Technology | 3059.796 | 1912.372 | 1147.424 | 37.500 | 5.000 | 39.000 |
| Tennsco 16-Compartment Lockers with Coat Rack | Office Supplies | 7515.524 | 6401.153 | 1114.371 | 14.830 | 5.000 | 40.000 |
| Samsung Galaxy S4 Mini | Technology | 6109.870 | 5005.394 | 1104.476 | 18.080 | 5.000 | 41.000 |
| Easy-staple paper | Office Supplies | 2504.192 | 1408.163 | 1096.029 | 43.770 | 46.000 | 42.000 |
| Ibico EB-19 Dual Function Manual Binding System | Office Supplies | 3234.913 | 2148.536 | 1086.377 | 33.580 | 8.000 | 43.000 |
| Hon 4070 Series Pagoda Round Back Stacking Chairs | Furniture | 5906.032 | 4853.218 | 1052.814 | 17.830 | 7.000 | 44.000 |
| Wilson SignalBoost 841262 DB PRO Amplifier Kit | Technology | 5327.260 | 4283.405 | 1043.855 | 19.590 | 6.000 | 45.000 |
| Razer Kraken 7.1 Surround Sound Over Ear USB Gaming Headset | Technology | 2619.738 | 1623.838 | 995.900 | 38.020 | 6.000 | 46.000 |
| Lifetime Advantage Folding Chairs, 4/Carton | Furniture | 5212.112 | 4239.475 | 972.637 | 18.660 | 7.000 | 47.000 |
| Bose SoundLink Bluetooth Speaker | Technology | 2865.600 | 1898.460 | 967.140 | 33.750 | 5.000 | 48.000 |
| Global Troy Executive Leather Low-Back Tilter | Furniture | 12975.382 | 12023.520 | 951.862 | 7.340 | 9.000 | 49.000 |
| Nortel Meridian M3904 Professional Digital phone | Technology | 4434.912 | 3498.653 | 936.259 | 21.110 | 10.000 | 50.000 |
| Global Commerce Series High-Back Swivel/Tilt Chairs | Furniture | 7979.440 | 7053.255 | 926.185 | 11.610 | 9.000 | 51.000 |
| Cisco SPA301 | Technology | 4180.532 | 3275.790 | 904.742 | 21.640 | 9.000 | 52.000 |
| Polycom VVX 310 VoIP phone | Technology | 6227.654 | 5327.704 | 899.950 | 14.450 | 8.000 | 53.000 |
| Logitech G700s Rechargeable Gaming Mouse | Technology | 2339.766 | 1449.855 | 889.911 | 38.030 | 9.000 | 54.000 |
| Safco Contoured Stacking Chairs | Furniture | 5697.760 | 4827.600 | 870.160 | 15.270 | 8.000 | 55.000 |
| Global Leather and Oak Executive Chair, Black | Furniture | 6410.874 | 5556.091 | 854.783 | 13.330 | 8.000 | 56.000 |
| Multicolor Computer Printout Paper | Office Supplies | 1887.300 | 1035.918 | 851.382 | 45.110 | 5.000 | 57.000 |
| Hewlett Packard 310 Color Digital Copier | Technology | 4199.860 | 3359.888 | 839.972 | 20.000 | 6.000 | 58.000 |
| GE 30524EE4 | Technology | 5291.730 | 4452.893 | 838.837 | 15.850 | 9.000 | 59.000 |
| Hon Olson Stacker Stools | Furniture | 5294.456 | 4460.861 | 833.595 | 15.740 | 10.000 | 60.000 |
| Hon 4700 Series Mobuis Mid-Back Task Chairs with Adjustable Arms | Furniture | 7582.374 | 6749.381 | 832.993 | 10.990 | 6.000 | 61.000 |
| Hon Multipurpose Stacking Arm Chairs | Furniture | 6584.640 | 5770.224 | 814.416 | 12.370 | 6.000 | 62.000 |
| Xerox 1908 | Office Supplies | 1712.988 | 913.594 | 799.394 | 46.670 | 7.000 | 63.000 |
| Global Ergonomic Managers Chair | Furniture | 6008.536 | 5223.083 | 785.453 | 13.070 | 11.000 | 64.000 |
| Mitel MiVoice 5330e IP Phone | Technology | 7699.720 | 6918.748 | 780.972 | 10.140 | 9.000 | 65.000 |
| Atlantic Metals Mobile 3-Shelf Bookcases, Custom Colors | Furniture | 7539.712 | 6759.382 | 780.330 | 10.350 | 8.000 | 66.000 |
| GuestStacker Chair with Chrome Finish Legs | Furniture | 9070.944 | 8297.683 | 773.261 | 8.520 | 8.000 | 67.000 |
| Logitech Wireless Gaming Headset G930 | Technology | 2879.820 | 2116.668 | 763.152 | 26.500 | 6.000 | 68.000 |
| GBC Ibimaster 500 Manual ProClick Binding System | Office Supplies | 19024.500 | 18263.520 | 760.980 | 4.000 | 9.000 | 69.000 |
| Xerox 1945 | Office Supplies | 1696.986 | 940.721 | 756.265 | 44.570 | 8.000 | 70.000 |
| Plantronics S12 Corded Telephone Headset System | Technology | 2242.032 | 1487.502 | 754.530 | 33.650 | 6.000 | 71.000 |
| Staple envelope | Office Supplies | 1686.812 | 935.183 | 751.629 | 44.560 | 48.000 | 72.000 |
| Global Executive Mid-Back Manager's Chair | Furniture | 4626.582 | 3875.854 | 750.728 | 16.230 | 6.000 | 73.000 |
| Xerox 189 | Office Supplies | 1782.450 | 1035.918 | 746.532 | 41.880 | 6.000 | 74.000 |
| Wireless Extenders zBoost YX545 SOHO Signal Booster | Technology | 4044.386 | 3311.105 | 733.281 | 18.130 | 7.000 | 75.000 |
| Xerox 1919 | Office Supplies | 1565.818 | 836.196 | 729.622 | 46.600 | 9.000 | 76.000 |
| Logitech G19 Programmable Gaming Keyboard | Technology | 4389.246 | 3660.185 | 729.061 | 16.610 | 8.000 | 77.000 |
| NETGEAR AC1750 Dual Band Gigabit Smart WiFi Router | Technology | 2623.836 | 1900.681 | 723.155 | 27.560 | 5.000 | 78.000 |
| Enermax Aurora Lite Keyboard | Technology | 1641.150 | 919.044 | 722.106 | 44.000 | 5.000 | 79.000 |
| Logitech Wireless Headset h800 | Technology | 2799.720 | 2079.792 | 719.928 | 25.710 | 6.000 | 80.000 |
| Hoover Shoulder Vac Commercial Portable Vacuum | Office Supplies | 5009.480 | 4293.840 | 715.640 | 14.290 | 6.000 | 81.000 |
| Google Nexus 5 | Technology | 3815.788 | 3104.827 | 710.961 | 18.630 | 5.000 | 82.000 |
| Xerox 1941 | Office Supplies | 1740.510 | 1035.918 | 704.592 | 40.480 | 5.000 | 83.000 |
| Global Leather Executive Chair | Furniture | 5861.533 | 5159.553 | 701.980 | 11.980 | 7.000 | 84.000 |
| Logitech G35 7.1-Channel Surround Sound Headset | Technology | 2157.834 | 1458.488 | 699.346 | 32.410 | 6.000 | 85.000 |
| Global Comet Stacking Arm Chair | Furniture | 6084.144 | 5387.002 | 697.141 | 11.460 | 5.000 | 86.000 |
| Economy Rollaway Files | Office Supplies | 3138.800 | 2444.960 | 693.840 | 22.110 | 7.000 | 87.000 |
| Fellowes PB200 Plastic Comb Binding Machine | Office Supplies | 4181.754 | 3488.195 | 693.559 | 16.590 | 9.000 | 88.000 |
| Logitech Gaming G510s - Keyboard | Technology | 2362.722 | 1686.202 | 676.520 | 28.630 | 8.000 | 89.000 |
| Jabra SPEAK 410 | Technology | 3158.064 | 2503.894 | 654.170 | 20.710 | 9.000 | 90.000 |
| Microsoft Sculpt Comfort Mouse | Technology | 1574.030 | 939.624 | 634.406 | 40.300 | 10.000 | 91.000 |
| Cameo Buff Policy Envelopes | Office Supplies | 1555.750 | 923.493 | 632.257 | 40.640 | 8.000 | 92.000 |
| Enermax Acrylux Wireless Keyboard | Technology | 2450.160 | 1819.692 | 630.468 | 25.730 | 6.000 | 93.000 |
| Electrix Architect's Clamp-On Swing Arm Lamp, Black | Furniture | 2863.800 | 2236.628 | 627.172 | 21.900 | 5.000 | 94.000 |
| NETGEAR N750 Dual Band Wi-Fi Gigabit Router | Technology | 1890.000 | 1267.200 | 622.800 | 32.950 | 7.000 | 95.000 |
| Xerox 1893 | Office Supplies | 1434.650 | 815.291 | 619.359 | 43.170 | 11.000 | 96.000 |
| SAFCO PlanMaster Heigh-Adjustable Drafting Table Base, 43w x 30d x 30-37h, Black | Furniture | 3739.115 | 3131.072 | 608.043 | 16.260 | 5.000 | 97.000 |
| 1.7 Cubic Foot Compact "Cube" Office Refrigerators | Office Supplies | 2706.080 | 2127.395 | 578.685 | 21.380 | 6.000 | 98.000 |
| Pyle PMP37LED | Technology | 3590.026 | 3013.126 | 576.900 | 16.070 | 10.000 | 99.000 |
| Aastra 57i VoIP phone | Technology | 3684.708 | 3109.376 | 575.332 | 15.610 | 7.000 | 100.000 |
Key Insights
Product P&L Table
Purpose
This section provides a complete product-level Profit & Loss statement for all 1,089 products meeting the minimum 5-order threshold. It serves as the foundational detail layer supporting the overall P&L analysis, enabling drill-down investigation into individual product economics, cost structures, and margin performance across the portfolio.
Key Findings
- Total Portfolio: 1,089 products generating $1.67M revenue, $219.6K profit at 13.17% overall margin
- Profitability Distribution: 919 profitable products (84.4%) vs. 170 loss leaders (15.6%), with profits ranging from -$2,876 to +$25,200
- Margin Concentration: 455 products (41.7%) cluster in the 0–25% margin band; 148 products (13.6%) operate at negative margins
- Top Performer: Canon imageCLASS 2200 Advanced Copier dominates with $25.2K profit on $61.6K revenue (40.91% margin)
Interpretation
The product-level detail reveals significant margin heterogeneity within the portfolio. While the overall 13.17% margin masks strong performers (Technology category at 22.67% avg margin), it also conceals structural profitability challenges in Furniture (-7.
Key Insights
Product P&L Table
Purpose
This section provides a complete product-level Profit & Loss statement for all 1,089 products meeting the minimum 5-order threshold. It serves as the foundational detail layer supporting the overall P&L analysis, enabling drill-down investigation into individual product economics, cost structures, and margin performance across the portfolio.
Key Findings
- Total Portfolio: 1,089 products generating $1.67M revenue, $219.6K profit at 13.17% overall margin
- Profitability Distribution: 919 profitable products (84.4%) vs. 170 loss leaders (15.6%), with profits ranging from -$2,876 to +$25,200
- Margin Concentration: 455 products (41.7%) cluster in the 0–25% margin band; 148 products (13.6%) operate at negative margins
- Top Performer: Canon imageCLASS 2200 Advanced Copier dominates with $25.2K profit on $61.6K revenue (40.91% margin)
Interpretation
The product-level detail reveals significant margin heterogeneity within the portfolio. While the overall 13.17% margin masks strong performers (Technology category at 22.67% avg margin), it also conceals structural profitability challenges in Furniture (-7.