Sample data · illustrative build by Woodfrog

Dealer group performance

— · showrooms across Pune, Pimpri-Chinchwad, Nashik and Kolhapur

—

New units retailed · quarter——
Vehicle sales revenue · ₹ Cr——
Gross margin · revenue-weighted——
Lead → delivery conversion——
Avg days in stock——
Aftersales revenue · ₹ Cr——

Sales and margin

Monthly retail volume

New and used units delivered per month, last 12 months. Shaded band marks the Navratri–Diwali festive window.

NewUsed (pre-owned)

Gross margin %

Vehicle gross incl. F&I income over net sales, monthly. Dashed line is the 12-month average.

Average days in stock

Days from GRN to retail invoice, monthly. Dashed line is the 45-day target.

Leads and conversion

Lead-to-delivery funnel · quarter

Thick bar is this quarter, thin bar the quarter before. Grey figure is the share kept from the stage above; the biggest drop is in red.

Lead sources · quarter

Bookings and cost efficiency by channel. Cost per booking uses media and tele-calling spend only.

Inventory health

Stock ageing by segment

Units on hand at quarter end, by days since GRN. Stock past 90 days carries the highest holding cost.

Stock position at quarter end

Value at landed cost. Aged stock is anything past 90 days.

Units on hand—
Stock value · ₹ Cr—
Aged units (90+ days)—
Aged share of units—
Aged value · ₹ Cr—
Days of supply—

Days of supply = units on hand ÷ average daily new-car retail over the quarter.

Showroom scorecard · quarter

Click a column to sort. Days in stock above 45 is flagged red. CSI is the OEM customer satisfaction index (0–100). Sparkline: monthly new units, last 12 months.

Aftersales

Workshop revenue by month · ₹ lakh

Labour, parts and accessories billed across all workshops.

Revenue mix by job type · quarter

Share of workshop revenue, with repair orders and average ticket per RO.

This is a demonstration build. The dealer group, showrooms and every figure are synthetic, modelled on the shape of Indian passenger-vehicle dealership data (festive peaks, monsoon dip, year-end push). Built by Woodfrog on a DMS-style data model: sales, lead management, inventory and workshop modules joined at showroom-month grain.