SAMPLE SALES ANALYSIS - FICTIONAL DATA
36 category-month rows; Jan-Dec 2026; INR. No real shop or clients.
month: YYYY-MM
half: H1 Jan-Jun; H2 Jul-Dec
category: Notebooks, Planners, Accessories
units_sold: fictional units
list_price_inr: pre-discount selling price per unit
unit_cost_inr: product cost per unit
discount_rate: fractional reduction in price
gross_sales_inr: units * list price
discount_inr: gross sales * discount rate
net_revenue_inr: gross sales - discount
cogs_inr: units * unit cost
gross_profit_inr: net revenue - COGS
Gross margin: SUM(gross profit)/SUM(net revenue), never the mean of row margins.
Taxes, returns, operating costs, shipping, marketing costs and customer data excluded.
Data was deliberately constructed to demonstrate rising revenue with declining gross profit. It is not a random or representative real-world sample.
