Blog · Finance metrics and formulas
Connect retail sales mix, merchandise margin, store operating costs and inventory investment. Work through a store's category review, build the spreadsheet calculations and check the results against the ledger and inventory reports.
Retail industry financial analysis connects net sales, merchandise margin, store operating costs and inventory investment. A useful review shows which categories contribute profit and how much stock they require. Build it from the retailer's sales, cost and inventory exports, then reconcile the figures before changing the assortment or store budget.
Use the same closed period for every store and category. Keep store identifiers, category codes and fiscal dates in the underlying exports. Compare like store populations when locations open, close or change format.
Start with net sales after discounts, returns and allowances. That is also how the SEC's income statement presentation rule describes tangible-product net sales. The rule permits merchandising companies to include buying and occupancy costs in cost of goods sold, so reported gross margins may have different boundaries.
For this management review, merchandise cost contains the cost of sold goods. Store labor, occupancy and other store costs sit below merchandise profit. If your ledger uses another classification, build a bridge rather than deducting the same expense twice. The separate gross profit margin guide covers the underlying metric.
Merchandise profit = Net sales − Merchandise cost
Store contribution = Merchandise profit − Store labor − Occupancy − Other store operating costs
Store contribution here is before headquarters costs, financing and taxes. It is a defined management subtotal, not the company's net income.
Consider an illustrative US general merchandise store for July through September 2026. Put the category in column A, net sales in B, merchandise cost in C, labor in D, occupancy in E and other store costs in F. Categories occupy rows 2 through 4, with totals in row 5.
| Category, A | Net sales (USD), B | Merchandise cost (USD), C | Store labor (USD), D | Occupancy (USD), E | Other store costs (USD), F |
|---|---|---|---|---|---|
| Food | 300,000 | 210,000 | 50,000 | 24,000 | 9,000 |
| Home | 200,000 | 120,000 | 20,000 | 16,000 | 6,000 |
| Apparel | 100,000 | 55,000 | 20,000 | 10,000 | 5,000 |
| Total | 600,000 | 385,000 | 90,000 | 50,000 | 20,000 |
Use actual category labor where available. Allocate shared occupancy using an explicit basis, such as occupied floor area. Keep unassigned costs visible rather than forcing a zero balance through an unexplained allocation.
For a sales export with store in A, category in B and net sales in C, select a store in summary cell P1. Calculate category sales in summary B2 with:
=SUMIFS(Sales!$C:$C,Sales!$A:$A,$P$1,Sales!$B:$B,$A2)
Filter the export to the chosen quarter first. Microsoft's SUMIFS documentation explains how the function adds values matching multiple criteria. Covirage is not affiliated with Microsoft.
Keep posted returns with the appropriate reporting period and preserve a separate returns view when assessing older sales cohorts. For markdowns against original tickets, use the maintained margin calculation rather than expanding this review into a promotion analysis.
Put merchandise profit in I2 and copy down:
=B2-C2
Put store contribution in J2:
=I2-SUM(D2:F2)
For sales share in K2 and merchandise margin in L2, respectively:
=B2/SUM($B$2:$B$4)
=I2/B2
Enter each formula in its stated cell, then fill down. Calculate the total margin from total profit divided by total sales. Percentages below are rounded to two decimals.
| Category | Sales share | Merchandise profit (USD) | Merchandise margin | Store contribution (USD) |
|---|---|---|---|---|
| Food | 50.00% | 90,000 | 30.00% | 7,000 |
| Home | 33.33% | 80,000 | 40.00% | 38,000 |
| Apparel | 16.67% | 45,000 | 45.00% | 10,000 |
| Total | 100.00% | 215,000 | 35.83% | 55,000 |
Food supplies half the sales, but $90,000 of merchandise profit less $50,000 labor, $24,000 occupancy and $9,000 other costs leaves $7,000. Home produces $38,000 of contribution on lower sales. The difference gives the store manager a concrete operating question: what makes Food expensive to run?
Do not assume allocated occupancy disappears if Food shrinks. Trace staffing, space commitments and customer shopping behavior before treating a category contribution ranking as a closure decision.
Bring June 30 opening inventory into G and September 30 closing inventory into H. Both are at cost. The IRS inventory guidance describes purchased merchandise cost as invoice cost after appropriate discounts, plus transportation and other acquisition charges; use your approved inventory policy consistently.
Calculate the simple opening-and-closing average in M2, then quarter inventory turns in N2:
=(G2+H2)/2
=C2/M2
| Category | Opening inventory (USD), G | Closing inventory (USD), H | Average inventory (USD), M | Quarter inventory turns, N |
|---|---|---|---|---|
| Food | 70,000 | 80,000 | 75,000 | 2.80 |
| Home | 110,000 | 130,000 | 120,000 | 1.00 |
| Apparel | 90,000 | 110,000 | 100,000 | 0.55 |
| Total | 270,000 | 320,000 | 295,000 | 1.31 |
These are quarter turns, not annual turns. Use daily or weekly inventory averages when deliveries and seasonality make the two-date average unrepresentative. The inventory turnover guide owns the detailed ratio method.
Apparel has the highest merchandise margin but requires $100,000 of average stock to generate $45,000 of merchandise profit. Its average inventory is 33.90% of the $295,000 total, while its sales are only 16.67% of store sales. Review stock age, availability and purchase commitments before adding more inventory to pursue the headline margin.
The contribution proof is $600,000 − $385,000 − $90,000 − $50,000 − $20,000 = $55,000. Category contributions also total $7,000 + $38,000 + $10,000 = $55,000. Tie every cost total to the ledger, identifying any excluded headquarters expenses.
Inventory rose by $320,000 − $270,000 = $50,000. A stock-movement report should explain that increase through receipts, sold cost, transfers, shrinkage and valuation adjustments. An increase in inventory is not itself an additional income statement expense, and it is not automatically the same amount of cash paid to suppliers.
Finance owns the reconciliation, merchants investigate assortment and stock, and store operations owns staffing and controllable expenses. Keep the wider retail financial ratios review separate so the monthly discussion stays focused on these decisions.
Bring sales, merchandise costs, store expenses and inventory balances; Covirage maps the columns, and its tools compute and check the figures while the external AI model explains the result with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting with Covirage for the supporting finance context.
Start with point-of-sale sales and returns, merchandise costs, store payroll, occupancy and other operating costs, plus inventory balances at consistent dates. Preserve store and category identifiers. A purchasing or stock-movement report helps explain why inventory rose even when reported sales and profit improved.
A high merchandise margin can coexist with slow-moving stock or heavy store costs. Compare the dollars of profit earned with the inventory required and the expenses of selling the category. The best action depends on demand, capacity and costs that would actually change.
State the boundary explicitly. The example deducts store labor, occupancy and other store operating costs, then leaves headquarters, financing and taxes below store contribution. Corporate allocations can be shown separately, especially when managers need to distinguish operating performance from the allocation method.
Use inventory at cost on a basis consistent with the merchandise cost numerator. Do not compare retail ticket value with cost of goods sold. Use more frequent inventory observations when opening and closing balances miss seasonal peaks or major delivery cycles.