Marlcairn Coffee
Coffee-chain store sales, drive-thru throughput, product mix, and loyalty
About Marlcairn Coffee
Industry
Quick-Service Coffee Chain
Company size
17 cafes across five metros, a 70,000-member loyalty app, and a 138-item menu
Modeled scale
About $14.3M gross and $13.3M net sales across 1.7 million transactions
Packaged scale
About 3.23 million rows across 11 Standard-tier tables
Daily rhythm
About 137 transactions per store per day at an average ticket near $7.85
Operating footprint
Cafes, drive-thru-only units, and kiosks across Coastal, Inland, and Northwest reporting regions
Customer mix
Members and guests buying espresso, coffee, tea, food, bakery, and retail beans across four channels
Marlcairn Coffee is a fictional regional quick-service coffee chain used for synthetic BI analysis. The company is not real. Its story is built around a maturing multi-unit cafe base where store sales, daypart and drive-thru behavior, product mix, loyalty engagement, and speed-of-service come together into one trustworthy analytics environment.
Operating Profile
- Runs a maturing regional cafe base where each store rings hundreds of low-ticket transactions a day, led by the morning rush and beverages.
- Every transaction connects to a store, day, daypart, channel, product, and, for members, a loyalty account.
- Channel follows store format: drive-thru-only units take about 87 percent of sales through the lane, cafes with a lane sit near 42, kiosks at zero.
- Ticket size follows channel, from delivery near $9.67 down to the mostly single-drink drive-thru at about $7.47.
- A thirty-campaign promotion calendar discounts about 18 percent of tickets, and loyalty tracks earning, redemption, tiers, and expiration by channel.
- Excludes individual customer records, payment-card data, staff scheduling, supplier purchasing, drink recipes, and equipment telemetry.
Recent Business Events
- 1AM Peak volume is up 7 percent and counter service slowed from 219 to 229 seconds, while the drive-thru lane held near 180.
- 2The lane keeps taking share from the counter, 35.6 percent of net sales to 37.3, led by the two drive-thru-only units.
- 3A fall and holiday limited-time-offer calendar lifts seasonal items from about 6 percent of units to nearly 15 at the yearly peak.
- 4The loyalty app keeps adding members, 1,165 a month at the window's start rising to 1,466 at its end, tying earning back to store sales.
These are the operating questions this kit is optimized to answer first.
Net sales, transactions, units, and average ticket by store, day, daypart, and year over year
Channel mix and drive-thru sales share
Product category and item mix, including seasonal and limited-time offers
Loyalty points earned, redeemed, and expired, outstanding balance, and member-attached share
Throughput and service seconds by store, daypart, and channel
Promotion redemption volume, discount cost, and mix contribution by campaign
Embedded Analytical Stories
Ticket-level drillthrough
Move from a chain KPI down to store, day, daypart, channel, product, and ticket on one consistent sales model.
Morning-rush tradeoff
The AM Peak dominates traffic but runs the slowest service, 224 seconds against 155 in the Early AM, and keeps slowing.
Format-driven channel mix
Drive-thru share separates cleanly by store format, from 87 percent lane share to zero at the kiosks.
Seasonal mix
Beverages lead while limited-time offers climb from about 6 percent of units to nearly 15 through the fall and holiday peak.
Same-store growth
Compare year two against year one for every cafe, from Hollowbrook up 28 percent to the Elmsworth kiosk down 9.
Promotion effectiveness
Compare redemption volume, discount cost, and incremental mix across thirty campaigns, each with its own window, rate, and channel scope.