A sample sales analysis of a fictional stationery shop. Twelve months, three product categories, and a question that revenue alone cannot answer.

Sample project · Fictional data

This demonstration uses constructed data for January–December 2026. It is a practice case, not a client engagement.

NET REVENUE+24.0%₹3,89,120 → ₹4,82,330
GROSS PROFIT−42.6%₹1,49,760 → ₹85,900
GROSS MARGIN17.8%Down from 38.5%

Comparison: July–December versus January–June. Gross profit excludes operating expenses and is not net profit.

More sales. Less gross profit.

Higher sales volumes did not offset the lower profit per unit. Larger discounts reduced margins in all three categories. Accessories reached zero gross profit: a ₹300 item discounted by 30% sold for ₹210, exactly its product cost.

Net revenue increased from 389.1 thousand rupees to 482.3 thousand. Gross profit decreased from 149.8 thousand to 85.9 thousand.
H1: January–June. H2: July–December. All amounts in INR.

What would I investigate next?

  1. Review accessory discounts first: the current price covers product cost, leaving nothing for operating expenses.
  2. Track revenue, gross profit and gross margin together, by category.
  3. Test a narrower promotion with a comparison group and measure profit after returns and campaign costs.
  4. Add order-level data, customer repeat purchases and fulfilment costs before making a commercial decision.

From question to evidence.

The dataset has 36 rows: 12 months × 3 categories. Every row represents a category-month summary. Calculations reconcile from units and prices to revenue, product cost and gross profit. The download includes a Python verification script and a guide to recreating the analysis in Excel.

These are proposed next steps. No real-world profit improvement or client result is claimed. Customer behaviour, returns, tax and operating costs are not modelled.

Explore the analysis.