Hollis Creek · Performance
Example dataA fictional home and kitchen retailer with eight stores and an online shop. Every figure comes from one data set and recalculates when you change a filter.
Sales
$7.66M
up 7.7% vs. Jul–Sep 2025
$7,662,950
Comp sales
+7.7%
vs. Jul–Sep 2025
locations open a full year
Gross margin
42.0%
down 1.3 pts vs. Jul–Sep 2025
Units sold
158,203
up 8.0% vs. Jul–Sep 2025
Average unit retail
$48.44
down 0.3% vs. Jul–Sep 2025
Inventory at cost
$4.56M
up 6.5% vs. Sep 30, 2025
Weeks of supply
13.3
down 0.4 wks vs. Sep 30, 2025
Stock unsold 90+ days
$412K
up $39K vs. Sep 30, 2025
1,180 SKUs
Orders delivered complete
87%
down 6 pts vs. Jul–Sep 2025
target: 95%
Needs attention
- Supplier
Lone Star Linen Co.
4 of its last 6 deliveries arrived short
- Running low
Air fryer, 6 qt
2.9 weeks of supply on a top-5 seller; 446 units on order
- Overstock
Cast-iron cookware · 14 SKUs
142 days of supply on hand
- Aged stock
Oklahoma City · Midtown
$96K in stock unsold for 90+ days, 23% of its inventory
- Running low
Insulated tumbler, 20 oz
2.6 weeks of supply on a top-5 seller; 1,800 units on order
- Margin
Houston · Heights
margin down 4.2 points since March
Weekly sales
Last 52 weeks against the same weeks a year earlier.
- This year
- Last year
- Selected period
Category mix
Share of sales in the period. The tick is the comparison period.
Sales by category
Select a category to see its products. Dollar columns in $ thousands.
| Category | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| 109 | −4.4% | 454 | 446 | 1,328 | 3,875 | +4.1% | 39.0% | 54,809 | |
| 115 | +20.6% | 489 | 474 | 1,347 | 3,579 | +11.2% | 24.3% | 23,145 | |
| 107 | +12.8% | 445 | 562 | 1,399 | 3,512 | +6.8% | 50.1% | 67,033 | |
| 86 | +4.0% | 365 | 351 | 1,049 | 2,998 | +5.8% | 47.9% | 115,655 | |
| 55 | +25.3% | 236 | 212 | 760 | 2,268 | +8.6% | 44.8% | 52,945 | |
| 61 | +11.7% | 243 | 239 | 700 | 2,063 | +6.0% | 44.0% | 28,234 | |
| 47 | +5.3% | 202 | 241 | 597 | 1,645 | +7.1% | 47.1% | 49,531 | |
| 43 | +5.2% | 179 | 164 | 484 | 1,494 | +7.3% | 49.2% | 52,486 | |
| Total | 623 | +9.1% | 2,613 | 2,689 | 7,663 | 21,435 | +7.0% | 42.0% | 443,838 |
Sales by location
Sales in the period. The tick is the comparison period.
Dollar columns in $ thousands.
| Location | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Online | 139 | +31.5% | 574 | 581 | 1,653 | 4,475 | +25.1% | 41.7% | +27.0% | 862 | 33 |
| Austin · South Congress | 72 | +2.9% | 313 | 335 | 924 | 2,614 | −1.3% | 42.3% | +1.3% | 556 | 46 |
| Austin · The Domain | 73 | +3.6% | 314 | 319 | 923 | 2,587 | +2.4% | 41.9% | +4.8% | 549 | 32 |
| Dallas · Lower Greenville | 63 | −7.8% | 270 | 275 | 799 | 2,223 | +0.2% | 42.3% | +5.0% | 475 | 42 |
| Houston · Heights | 65 | +6.8% | 261 | 266 | 767 | 2,202 | −3.3% | 40.2% | −1.0% | 482 | 53 |
| San Antonio · Pearl | 62 | +5.3% | 254 | 270 | 759 | 2,117 | +0.5% | 42.2% | +5.9% | 432 | 44 |
| Fort Worth · Near Southside | 51 | +8.0% | 225 | 238 | 665 | 1,883 | +2.8% | 42.4% | +4.7% | 416 | 32 |
| Round Rock | 54 | +10.1% | 215 | 225 | 638 | 1,812 | +2.7% | 42.4% | +2.4% | 379 | 34 |
| Oklahoma City · Midtown | 45 | +8.0% | 186 | 180 | 535 | 1,523 | +41.7% | 42.9% | +4.6% | 414 | 96 |
| Total | 623 | +9.1% | 2,613 | 2,689 | 7,663 | 21,435 | +7.0% | 42.0% | +7.7% | 4,563 | 412 |
Inventory
Stock as of today, at cost. Turns, GMROI and sell-through cover the selected period. Dollar columns in $ thousands.
Inventory by age
Days since the units were received.
| Category | ||||||||
|---|---|---|---|---|---|---|---|---|
| 1,095 | 26,573 | 350 | 17.4 | 41% | 3.2 | $2.03 | 114 | |
| 736 | 28,393 | 165 | 13.7 | 49% | 3.5 | $3.53 | 52 | |
| 720 | 6,359 | 240 | 8.3 | 58% | 5.6 | $1.79 | 8 | |
| 621 | 46,797 | 175 | 13.7 | 46% | 3.6 | $3.28 | 56 | |
| 513 | 13,007 | 33 | 16.6 | 42% | 3.2 | $2.52 | 75 | |
| 327 | 19,330 | 24 | 13.1 | 48% | 3.6 | $3.19 | 8 | |
| 304 | 21,614 | 141 | 14.3 | 44% | 3.6 | $3.47 | 13 | |
| 248 | 10,239 | 75 | 7.2 | 64% | 4.4 | $3.54 | 86 | |
| Total | 4,563 | 172,312 | 1,203 | 13.3 | 48% | 3.8 | $2.76 | 412 |
Purchasing by supplier
Received at cost in the selected period, by category. Dollar columns in $ thousands.
| Supplier | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Marlow Home Appliances | 1,105 | 1,105 | 86% | 90% | 14 days | |||||||
| Lone Star Linen Co. | 870 | 33 | 12 | 916 | 33% | 72% | 31 days | |||||
| Hartwell Steelworks | 485 | 40 | 94 | 619 | 97% | 94% | 28 days | |||||
| Bluebonnet Ceramics | 355 | 81 | 25 | 461 | 81% | 96% | 23 days | |||||
| Ozark Foundry Co. | 406 | 406 | 100% | 100% | 34 days | |||||||
| Keystone Cutlery | 393 | 393 | 97% | 97% | 20 days | |||||||
| Prairie Glassworks | 134 | 190 | 325 | 96% | 89% | 21 days | ||||||
| Northfield Housewares | 135 | 19 | 46 | 121 | 322 | 97% | 83% | 22 days | ||||
| Gulf Coast Bakeware | 182 | 182 | 96% | 96% | 13 days | |||||||
| Pecos Outdoor Supply | 174 | 174 | 97% | 87% | 29 days | |||||||
| Total | 1,026 | 453 | 1,105 | 582 | 310 | 870 | 370 | 186 | 4,903 | 87% | 90% | 22 days |
Definitions
- LW
- Last week: the last full Monday-to-Sunday week.
- MTD, QTD, YTD
- Month, quarter and year to date, through the as-of date.
- LM
- Last month: the full calendar month before this one.
- LY
- Last year: the same dates a year earlier. Weeks compare to the same weekdays.
- Prior period
- The window of the same length just before the selected one.
- Comp %
- Sales growth vs. last year for locations open through the whole comparison window.
- GM %
- Gross margin: sales minus cost of goods, as a share of sales.
- AUR
- Average unit retail: sales divided by units.
- WOS
- Weeks of supply: units on hand divided by average weekly units over the last four weeks.
- Sell-through
- Units sold in the period as a share of units sold plus units still on hand.
- Turns
- Cost of goods sold, annualized, divided by average inventory at cost.
- GMROI
- Gross margin dollars, annualized, per dollar of average inventory at cost.
- Aged 90+
- Stock received more than 90 days ago and still unsold, at cost.
- Fill rate
- Share of deliveries that arrived with every unit ordered.
Example figures for a fictional retailer. Yours would come straight from your own systems.