Blog · Board and management reporting
Retail operations analytics compares sales, paid labor, returns and stock availability on consistent periods. Follow a spreadsheet method with exact formulas, a worked store comparison and reconciliation checks.
Retail operations analytics compares store sales, labor, returns and stock availability on the same operating basis. Start with the exports your operations team already receives, reconcile each source, then calculate ratios from the amounts and counts. A store ranking becomes useful when its differences lead to a specific staffing, returns or replenishment investigation.
Choose one review period and the stores open throughout it. Record closures, unusual opening hours and major format differences before comparing performance. Keep the broad commercial picture in retail analytics; this comparison concerns the resources and operating conditions behind store results.
Use merchandise revenue excluding sales tax. Deduct merchandise refunds to calculate net sales, consistent with the relevant Census Bureau retail sales definition. Define the refund measure here as refund dollars divided by merchandise sales before refunds; it is a period measure, not a rate for an original purchase cohort.
For labor, use actual paid hours and wages in every store. This example excludes benefits and payroll taxes. For stockouts, use completed checks of authorized items, with empty-shelf results identified separately from missing observations.
Create a store-period summary from the sales export, payroll or timekeeping export, and stock-check export. In Excel, Microsoft documents SUMIFS for adding values that meet several criteria. For a Sales sheet with date in A, store in B and merchandise sales before refunds in C, use this formula to select the store in summary A2:
=SUMIFS(Sales!$C$2:$C$10000,Sales!$B$2:$B$10000,$A2,Sales!$A$2:$A$10000,">="&$N$1,Sales!$A$2:$A$10000,"<"&$O$1)
N1 contains the period start and O1 the exclusive end, both as real dates. For October 12–18, 2026, enter October 12, 2026, and October 19, 2026. Apply the same store and date criteria to each source's appropriate amount or count column. Covirage is not affiliated with Microsoft.
The illustrative US retailer below has no unmatched store identifiers or missing stock checks. Sales amounts are after discounts but before the separately shown refunds.
| Store | Merchandise sales (USD) | Refunds (USD) | Paid hours | Wage cost (USD) | Completed stock checks | Empty-shelf checks |
|---|---|---|---|---|---|---|
| Cedar | 120,000 | 6,000 | 1,000 | 20,000 | 200 | 20 |
| Maple | 100,000 | 8,000 | 800 | 17,600 | 160 | 24 |
| Total | 220,000 | 14,000 | 1,800 | 37,600 | 360 | 44 |
Keep a reconciliation tab or review record showing each summary total against its source export. Resolve differences before comparing stores; a missing payroll period can make a location appear unusually efficient.
In the input table, A is store, B merchandise sales, C refunds, D paid hours, E wage cost, F completed checks and G empty checks. Put these formulas in H2:L2 and copy down:
H2: =B2-C2
I2: =IF(D2=0,"",H2/D2)
J2: =IF(H2=0,"",E2/H2)
K2: =IF(B2=0,"",C2/B2)
L2: =IF(F2=0,"",G2/F2)
H is net sales, I sales per paid hour, J wage cost/net sales, K refund dollars/merchandise sales, and L observed stockout rate. Format J:L as percentages. A blank signals an undefined denominator and needs review.
| Store | Net sales (USD) | Sales per paid hour (USD) | Wage cost/net sales | Refund rate | Observed stockout rate |
|---|---|---|---|---|---|
| Cedar | 114,000 | 114.0 | 17.5% | 5.0% | 10.0% |
| Maple | 92,000 | 115.0 | 19.1% | 8.0% | 15.0% |
| Total | 206,000 | 114.4 | 18.3% | 6.4% | 12.2% |
Cedar net sales are 120,000 − 6,000 = $114,000. Its sales per paid hour are 114,000 / 1,000 = $114.0, and its wage ratio is 20,000 / 114,000 = 17.5%. All displayed ratios are rounded to one decimal place after calculation.
Calculate total ratios from summed inputs. Total stockouts are 44 / 360 = 12.2%; total wage cost/net sales is 37,600 / 206,000 = 18.3%. Do not average the displayed store percentages.
Maple generates slightly more sales per paid hour, yet its wage ratio is higher. Its paid-hour cost is 17,600 / 800 = $22 versus Cedar's 20,000 / 1,000 = $20. At Cedar's hourly cost, Maple's hours would cost 800 × 20 = $16,000, a $1,600 difference from actual wages.
That is a diagnostic comparison, not a savings promise. Review overtime, role mix and local rates before considering staffing changes. Maple's refund and stockout rates also warrant investigation; check reasons, items and completed observations before assigning causes.
For shelf and promotion evidence, use retail execution analytics. The broader COO supply and service questions help connect store exceptions with the operating decisions that follow.
Bring a sample of your own store sales, labor and stock-check summaries to Covirage; it maps the columns, and its tools compute and check consistent store ratios and totals. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See cost variance analysis for the supporting business context.
Start with net sales, paid hours, labor cost, merchandise refunds and completed stock checks. Calculate sales per paid hour, labor cost as a share of net sales, a stated refund measure and observed stockout rate. Keep the underlying counts and amounts visible beside each ratio.
Use a definition approved by finance and apply it to every store. Separate wages, overtime premiums, payroll taxes and benefits when those components matter. Compare actual paid hours with actual paid costs; scheduled hours and fully loaded payroll costs answer different questions.
Sales per paid hour measures revenue against hours, while labor cost also reflects the cost of each hour. A store can generate more sales per hour yet have a higher labor-to-sales ratio because of overtime, wage rates, benefits or its mix of roles.