Blog · Board and management reporting
Automotive business analytics connects vehicle sales, gross profit and inventory aging by location and product. Follow a worked dealership example, the files it needs and the checks that make comparisons useful.
Automotive business analytics connects sales, gross margin and inventory aging so managers can compare commercial performance by location and product. It starts with the sales and stock exports the business already has, then checks that every comparison agrees with the underlying records. The scope here is vehicle retail performance: what sold, what it earned and what remains unsold.
A dealership group may need to decide where to investigate discounting, which unsold vehicles need attention or whether a location's stronger revenue also produced stronger gross profit. Those questions need different measures. Do not make a single revenue ranking stand in for all of them.
Keep new and used vehicles separate. Give parts, service and finance income their own categories if you later bring them into the review. Their revenue and cost definitions differ, so including them without explanation changes the meaning of a vehicle margin comparison.
Write down the reporting period, the locations included and the definition of a completed sale. Specify how cancellations, returns, dealer incentives and later cost adjustments are treated. Finance should approve the definitions before managers compare results.
Use a sales register with a transaction identifier, vehicle or stock identifier, sale date, location, category, units and net revenue. Add the cost recorded for the vehicles sold. Separately, use an inventory snapshot with the stock identifier, current location, category, acquisition date, carrying cost and snapshot date.
The cost boundary matters. IRS Publication 538 explains that purchased merchandise cost includes the invoice price after appropriate discounts and charges incurred in acquiring the goods. Your controller should document how the business records vehicle costs and subsequent adjustments. Apply that policy consistently across locations.
Inventory is a balance at a date, while sales cover a period. The Census Bureau's retail definitions likewise distinguish end-of-period merchandise inventory at cost from sales during a month. A monthly sales file cannot tell you what is still on hand without a stock snapshot.
Check identifiers before combining records. A vehicle can have multiple cost entries, but that must not multiply its sales revenue. Sum valid costs to the agreed vehicle or transaction level first, and review unmatched identifiers separately.
Consider an illustrative US dealership group for September 2026. The following rows summarize its completed vehicle sales; all figures come from the same period and approved cost policy.
Gross profit = Net revenue - Cost of goods sold
Gross margin = Gross profit / Net revenue
| Location and category | Units sold | Net revenue (USD) | Cost of goods sold (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|---|
| North, new | 20 | 800,000 | 744,000 | 56,000 | 7.0% |
| North, used | 15 | 375,000 | 330,000 | 45,000 | 12.0% |
| South, new | 15 | 600,000 | 564,000 | 36,000 | 6.0% |
| South, used | 10 | 250,000 | 212,500 | 37,500 | 15.0% |
| Total | 60 | 2,025,000 | 1,850,500 | 174,500 | 8.6% |
For North's used vehicles, 375,000 - 330,000 = $45,000 of gross profit, and 45,000 / 375,000 = 12.0%. For the group, 2,025,000 - 1,850,500 = $174,500, and 174,500 / 2,025,000 = 8.6%, rounded to one decimal place.
The total margin divides total profit by total revenue. It does not average the row percentages; the gross profit margin method explains that weighting check in detail. Gross profit also precedes selling, administrative and financing costs, so this table does not establish location net profitability.
South's used category has the highest percentage margin, while North's new category produces the most gross profit dollars. A manager should ask which pricing, acquisition-cost or product differences explain that pattern before setting targets.
The stock snapshot below is dated September 30, 2026. For this example, the aging threshold is more than 90 elapsed days since acquisition. That is a review policy for this business, not an industry benchmark.
| Location and category | Unsold units | Inventory cost (USD) | Units over 90 days | Cost over 90 days (USD) |
|---|---|---|---|---|
| North, new | 30 | 1,116,000 | 4 | 148,800 |
| North, used | 18 | 396,000 | 6 | 132,000 |
| South, new | 24 | 902,400 | 2 | 75,200 |
| South, used | 12 | 255,000 | 4 | 85,000 |
| Total | 84 | 2,669,400 | 16 | 441,000 |
The older-stock share is 441,000 / 2,669,400 = 16.5% by cost, compared with 16 / 84 = 19.0% by units. Both percentages are rounded to one decimal place. They answer different questions: dollars tied up versus the proportion of vehicles needing review.
Reconcile inventory cost to the inventory control account and units to the stock listing. The aged units must be a subset of all unsold units, and each vehicle must appear in only one age band. For the full aging method, see inventory aging by site.
The sales manager owns the explanation of realized selling prices and discounts. The inventory manager reviews aged vehicles and transfer candidates. Finance owns the cost policy, ledger reconciliation and evidence that sales and costs belong together.
Keep the next question narrow: why does South retain more margin on used vehicles, or which North used vehicles make up the older balance? Interactive business analytics describes how to follow that question without losing the company total. Marketing response and lead performance belong in automotive marketing analytics, rather than being inferred from this sales table.
Bring a sales register, matching cost records and a dated inventory file: Covirage maps the columns, and its tools compute and check the location and product comparisons. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See revenue driver analysis for the supporting commercial review approach.
Start with a sales register, the cost of the vehicles sold and an inventory snapshot for the same reporting date. Keep stable vehicle or stock identifiers, location, product category, transaction dates and acquisition dates so totals and aging can be checked.
Review both. Revenue measures sales value, while gross profit subtracts the recorded cost of what was sold. A location can generate more revenue while retaining less profit per dollar, so sales alone cannot establish which commercial decisions worked.
Choose a consistent acquisition date and a fixed inventory snapshot date. Calculate elapsed days for each unsold vehicle, then group units and carrying cost into agreed age bands. Report both counts and dollars because expensive vehicles can dominate the value at risk.
A transfer changes which location holds a vehicle, but it does not create a sale to an outside customer. Keep transfers separate from retail sales and preserve the original acquisition date when reviewing how long the business has held the stock.