Revenue vs Profit: Product Category Profitability Decomposition
Intermediate
60 min
0 views
0 solutions
Overview
UrbanMart's category report ranks Electronics as the top performer with ₹3.2 crore in monthly revenue. But after allocating shared costs (rent, staffing, storage) by actual usage, the analyst suspects Electronics may be barely breaking even. She must decompose total profit by category — by hand — before the category review meeting.
Case Details
# Aplly.xyz Case Study Submission
## Title
Revenue vs Profit: Product Category Profitability Decomposition
## Type
Data Analytics
## Difficulty
Intermediate
## Estimated Time
60 minutes
## Overview
UrbanMart's category report ranks Electronics as the top performer with ₹3.2 crore in monthly revenue. But after allocating shared costs (rent, staffing, storage) by actual usage, the analyst suspects Electronics may be barely breaking even. She must decompose total profit by category — by hand — before the category review meeting.
## Case Details
Function Focus: Full-cost allocation, overhead distribution, gross-to-net profit decomposition, revenue vs profit ranking comparison
Scenario:
UrbanMart's monthly category review ranks all 6 product categories by revenue. Electronics has held the #1 spot for a year. But the new analyst notices the P&L shows only gross profit (revenue minus COGS) — shared costs like rent, staffing, and storage are tracked at the store level and never allocated down to categories. She proposes a full-cost allocation: apportion shared overhead to each category based on floor space and staff hours. The category managers push back — they know their rankings will shift. The analyst must manually compute the fully-allocated profit for all 6 categories before the review meeting, producing a ranking that reflects true profitability.
Dataset Structure:
- 6 product categories with monthly revenue and COGS
- Gross profit per category
- Overhead pools: Rent (₹12L), Staffing (₹18L), Utilities (₹3L)
- Allocation bases: floor space % for rent and utilities, staff hours % for staffing
- Per-category floor space (sq ft) and staff hours (%)
Tasks:
1. Compute gross profit and gross margin % for each category — rank the 6 categories by gross profit
2. Allocate the three overhead pools (rent, staffing, utilities) to each category using the given allocation bases — show the allocation math for at least one category in full (e.g., Electronics) and then present the full allocation table
3. Compute net profit (gross profit minus allocated overhead) and net margin % for each category — produce a final ranking by net profit
4. Compare the revenue ranking vs net profit ranking — identify which category gains the most positions and which loses the most, and explain what drives the shift
5. Only after submitting your manual decomposition, re-run the full allocation in a spreadsheet or AI tool and report any discrepancies in your net profit figures
Expected Output:
A full-cost analysis memo containing: (a) gross profit ranking table, (b) overhead allocation table with sample calculation for one category, (c) net profit ranking table, (d) a ranking shift comparison (revenue → net profit) with explanation of the biggest mover, and (e) a round-trip discrepancy note.
Evaluation Criteria:
Correct overhead allocation using the specified bases (not arbitrary splits), complete allocation table for all 6 categories, correct net profit arithmetic, insightful analysis of which category gains/loses most and why, and honest discrepancy reporting.
## Data Sources
Category Data (Monthly, ₹Lakhs):
| Category | Revenue (₹L) | COGS (₹L) | Floor Space (sq ft) | Staff Hours (%) |
|---|---|---|---|---|
| Electronics | 320 | 275 | 2,400 | 15% |
| Grocery | 280 | 235 | 1,800 | 35% |
| Apparel | 195 | 140 | 2,100 | 20% |
| Home & Kitchen | 165 | 120 | 1,500 | 15% |
| Beauty & Personal Care | 95 | 55 | 600 | 10% |
| Books & Media | 45 | 28 | 600 | 5% |
Total: Revenue = 1,100 | COGS = 853 | Floor Space = 9,000 | Staff Hours = 100%
Overhead Pools (Monthly):
| Overhead Item | Total (₹L) | Allocation Basis |
|---|---|---|
| Rent | 12.0 | Floor space (%) |
| Staffing (salaries + benefits) | 18.0 | Staff hours (%) |
| Utilities (power + HVAC) | 3.0 | Floor space (%) |
Category Manager Claims (for reference):
- Electronics manager: "We generate more revenue than anyone — of course we're the top performer."
- Grocery manager: "Our margins are thin but we drive foot traffic. We deserve credit for store-level traffic."
- Beauty manager: "We use barely any floor space and have the highest gross margin — our net profit is probably the best."
- Books manager: "We use almost no resources. Small but efficient."
## Solution Frameworks
Full-cost allocation, overhead distribution, activity-based costing principles, gross-to-net decomposition, ranking sensitivity analysis
## Solver Guidance & Tutorials
Link to: "Activity-Based Cost Allocation for Retail Categories" tutorial
## What You'll Learn
- Allocating shared overhead costs using activity-based bases
- Comparing revenue rankings vs true profitability rankings
- Understanding why high-revenue categories can be low-profit
- Building a defensible cost allocation for management review
## Tags
profitability analysis, cost allocation, retail analytics, category management, activity-based costing
## Registration Links
- Register as Solver
- Register as Evaluator
## Title
Revenue vs Profit: Product Category Profitability Decomposition
## Type
Data Analytics
## Difficulty
Intermediate
## Estimated Time
60 minutes
## Overview
UrbanMart's category report ranks Electronics as the top performer with ₹3.2 crore in monthly revenue. But after allocating shared costs (rent, staffing, storage) by actual usage, the analyst suspects Electronics may be barely breaking even. She must decompose total profit by category — by hand — before the category review meeting.
## Case Details
Function Focus: Full-cost allocation, overhead distribution, gross-to-net profit decomposition, revenue vs profit ranking comparison
Scenario:
UrbanMart's monthly category review ranks all 6 product categories by revenue. Electronics has held the #1 spot for a year. But the new analyst notices the P&L shows only gross profit (revenue minus COGS) — shared costs like rent, staffing, and storage are tracked at the store level and never allocated down to categories. She proposes a full-cost allocation: apportion shared overhead to each category based on floor space and staff hours. The category managers push back — they know their rankings will shift. The analyst must manually compute the fully-allocated profit for all 6 categories before the review meeting, producing a ranking that reflects true profitability.
Dataset Structure:
- 6 product categories with monthly revenue and COGS
- Gross profit per category
- Overhead pools: Rent (₹12L), Staffing (₹18L), Utilities (₹3L)
- Allocation bases: floor space % for rent and utilities, staff hours % for staffing
- Per-category floor space (sq ft) and staff hours (%)
Tasks:
1. Compute gross profit and gross margin % for each category — rank the 6 categories by gross profit
2. Allocate the three overhead pools (rent, staffing, utilities) to each category using the given allocation bases — show the allocation math for at least one category in full (e.g., Electronics) and then present the full allocation table
3. Compute net profit (gross profit minus allocated overhead) and net margin % for each category — produce a final ranking by net profit
4. Compare the revenue ranking vs net profit ranking — identify which category gains the most positions and which loses the most, and explain what drives the shift
5. Only after submitting your manual decomposition, re-run the full allocation in a spreadsheet or AI tool and report any discrepancies in your net profit figures
Expected Output:
A full-cost analysis memo containing: (a) gross profit ranking table, (b) overhead allocation table with sample calculation for one category, (c) net profit ranking table, (d) a ranking shift comparison (revenue → net profit) with explanation of the biggest mover, and (e) a round-trip discrepancy note.
Evaluation Criteria:
Correct overhead allocation using the specified bases (not arbitrary splits), complete allocation table for all 6 categories, correct net profit arithmetic, insightful analysis of which category gains/loses most and why, and honest discrepancy reporting.
## Data Sources
Category Data (Monthly, ₹Lakhs):
| Category | Revenue (₹L) | COGS (₹L) | Floor Space (sq ft) | Staff Hours (%) |
|---|---|---|---|---|
| Electronics | 320 | 275 | 2,400 | 15% |
| Grocery | 280 | 235 | 1,800 | 35% |
| Apparel | 195 | 140 | 2,100 | 20% |
| Home & Kitchen | 165 | 120 | 1,500 | 15% |
| Beauty & Personal Care | 95 | 55 | 600 | 10% |
| Books & Media | 45 | 28 | 600 | 5% |
Total: Revenue = 1,100 | COGS = 853 | Floor Space = 9,000 | Staff Hours = 100%
Overhead Pools (Monthly):
| Overhead Item | Total (₹L) | Allocation Basis |
|---|---|---|
| Rent | 12.0 | Floor space (%) |
| Staffing (salaries + benefits) | 18.0 | Staff hours (%) |
| Utilities (power + HVAC) | 3.0 | Floor space (%) |
Category Manager Claims (for reference):
- Electronics manager: "We generate more revenue than anyone — of course we're the top performer."
- Grocery manager: "Our margins are thin but we drive foot traffic. We deserve credit for store-level traffic."
- Beauty manager: "We use barely any floor space and have the highest gross margin — our net profit is probably the best."
- Books manager: "We use almost no resources. Small but efficient."
## Solution Frameworks
Full-cost allocation, overhead distribution, activity-based costing principles, gross-to-net decomposition, ranking sensitivity analysis
## Solver Guidance & Tutorials
Link to: "Activity-Based Cost Allocation for Retail Categories" tutorial
## What You'll Learn
- Allocating shared overhead costs using activity-based bases
- Comparing revenue rankings vs true profitability rankings
- Understanding why high-revenue categories can be low-profit
- Building a defensible cost allocation for management review
## Tags
profitability analysis, cost allocation, retail analytics, category management, activity-based costing
## Registration Links
- Register as Solver
- Register as Evaluator
Data Sources
Category Data (Monthly, ₹Lakhs):
| Category | Revenue (₹L) | COGS (₹L) | Floor Space (sq ft) | Staff Hours (%) |
|---|---|---|---|---|
| Electronics | 320 | 275 | 2,400 | 15% |
| Grocery | 280 | 235 | 1,800 | 35% |
| Apparel | 195 | 140 | 2,100 | 20% |
| Home & Kitchen | 165 | 120 | 1,500 | 15% |
| Beauty & Personal Care | 95 | 55 | 600 | 10% |
| Books & Media | 45 | 28 | 600 | 5% |
Total: Revenue = 1,100 | COGS = 853 | Floor Space = 9,000 | Staff Hours = 100%
Overhead Pools (Monthly):
| Overhead Item | Total (₹L) | Allocation Basis |
|---|---|---|
| Rent | 12.0 | Floor space (%) |
| Staffing (salaries + benefits) | 18.0 | Staff hours (%) |
| Utilities (power + HVAC) | 3.0 | Floor space (%) |
Category Manager Claims (for reference):
- Electronics manager: "We generate more revenue than anyone — of course we're the top performer."
- Grocery manager: "Our margins are thin but we drive foot traffic. We deserve credit for store-level traffic."
- Beauty manager: "We use barely any floor space and have the highest gross margin — our net profit is probably the best."
- Books manager: "We use almost no resources. Small but efficient."
| Category | Revenue (₹L) | COGS (₹L) | Floor Space (sq ft) | Staff Hours (%) |
|---|---|---|---|---|
| Electronics | 320 | 275 | 2,400 | 15% |
| Grocery | 280 | 235 | 1,800 | 35% |
| Apparel | 195 | 140 | 2,100 | 20% |
| Home & Kitchen | 165 | 120 | 1,500 | 15% |
| Beauty & Personal Care | 95 | 55 | 600 | 10% |
| Books & Media | 45 | 28 | 600 | 5% |
Total: Revenue = 1,100 | COGS = 853 | Floor Space = 9,000 | Staff Hours = 100%
Overhead Pools (Monthly):
| Overhead Item | Total (₹L) | Allocation Basis |
|---|---|---|
| Rent | 12.0 | Floor space (%) |
| Staffing (salaries + benefits) | 18.0 | Staff hours (%) |
| Utilities (power + HVAC) | 3.0 | Floor space (%) |
Category Manager Claims (for reference):
- Electronics manager: "We generate more revenue than anyone — of course we're the top performer."
- Grocery manager: "Our margins are thin but we drive foot traffic. We deserve credit for store-level traffic."
- Beauty manager: "We use barely any floor space and have the highest gross margin — our net profit is probably the best."
- Books manager: "We use almost no resources. Small but efficient."
Solution Frameworks
Full-cost allocation, overhead distribution, activity-based costing principles, gross-to-net decomposition, ranking sensitivity analysis
Solver Guidance & Tutorials
Link to: "Activity-Based Cost Allocation for Retail Categories" tutorial
What You'll Learn
- Problem-solving and analytical thinking
- Data-driven decision making
- Business strategy development
- Professional report writing
0
Solutions Submitted
Difficulty
Intermediate
Estimated Time
60 minutes
Relevance
Fresh
Source
case-studies-in