Brelloro Markets
Grocery sales, perishables, stockouts, and promotion lift
About Brelloro Markets
Industry
Grocery / CPG
Company size
120 stores across 6 operating regions
Commercial focus
Inventory turns, perishables shrink, promotion lift, and vendor reliability
Modeled sales scale
about $586M modeled two-year gross sales and $544M net after $41M of promotional discount
Gross margin posture
37% to 47% modeled gross margin rate by department, with about 44% overall on net sales
Workforce
about 4,800 employees across stores, replenishment, and regional operations
Store footprint
supermarkets, fresh markets, urban markets, value basket stores, and marketplace formats
Data scope
15 tables, about 2.1M generated rows
Brelloro Markets is a fictional 120-store grocery operator built for analytics teams that need believable sales, margin, inventory, perishables, vendor, stockout, and promotion data in one purchase-ready model. The kit focuses on daily store-SKU operations rather than loyalty identities or second-by-second POS streams, so buyers can build executive, category, replenishment, and store operations dashboards without handling customer PII.
Operating Profile
- Merchandising posture: fresh and prepared categories carry the shrink risk while pantry and household provide steadier margin.
- Replenishment posture: daily review covers high-velocity, perishable and promoted SKUs across formats; most order lines are received complete.
- Availability spread: fresh departments and urban formats run tighter on-shelf, center-store skews overstocked, and stockouts rise at peaks.
- Vendor posture: each line carries a promised delivery date and the date it landed, so lateness is the gap; fill rate and substitution vary by supplier.
- Promotion posture: each department runs one campaign at a time and rotates featured SKUs, so most volume still sells at full price.
- Buyer use case: dashboards for region, store, department, category, SKU, vendor, and promotion drilldowns.
Recent Business Events
- 1Summer cold-beverage and cookout demand stretched store replenishment and exposed vendor fill-rate gaps.
- 2Deep holiday event pricing lifted units hardest of any mechanic but gave back more margin than it earned.
- 3A fresh-market remodel changed assortment breadth and shrink pressure in several urban stores; assortment lines carry an opened date and any planned close.
- 4Daily inventory review now ties stockout events, vendor reliability, and promotion planning into one operating cadence.
These are the operating questions this kit is optimized to answer first.
Net sales, gross sales, discounts, gross margin, gross margin rate, and basket proxy count
Inventory value, on-hand units, days of supply, inventory health, low-stock flags, and turns
Waste units, markdown amounts, retail value lost, disposition, and shrink pressure
Stockout hours, estimated lost units, estimated lost sales, root cause, and recovery behavior
Ordered and received units, fill rate, perfect order rate, and promised versus actual delivery
Promoted and baseline units, incremental units, lift, discount, and margin per discount dollar
Embedded Analytical Stories
Executive grocery scorecard
A buyer can trend sales, gross margin, shrink, stockout pressure, and vendor fill rate by month, region, and department.
Perishables turn review
Rank fresh departments by days of supply, markdown cost, and waste value.
Vendor reliability drillthrough
Move from supplier reliability into order lines, compare promised against actual delivery, then follow short receipts to stockouts.
Promotion margin tradeoff
Compare promoted volume against the full-price baseline the same SKUs sell at when they are off deal.