Supermarket Branch Revenue Drivers

Comparing Giza, Alex, and Cairo to isolate whether revenue differences come from foot traffic, basket size, product-line mix, or customer-type split.

Revenue leader
$110.6K
Giza generates the highest branch revenue.
+2.7% vs branch average
Traffic leader
340
Alex sees the most transactions.
+12 orders vs lowest branch
Largest basket
$337
Giza has the strongest average ticket.
+$24.7 vs the smallest basket
Mix effect ceiling
< $1
Share mix barely changes basket size.
Product $0.97 | customer $0.78 per order
Bottom line
Basket size is the real separator Traffic alone does not explain revenue

Giza leads branch revenue at $110.6K, even though Alex handles the most transactions. The winning difference is ticket size: Giza averages $337 per order, while Alex and Cairo stay below that level.

Relative to the branch average, Giza gives back roughly $1.7K from lighter traffic but gains about $4.7K from larger baskets, leaving it nearly $2.9K ahead overall.

Why mix is not the answer
Product mix effect is negligible Customer split effect is also small

Product-line share shifts basket size by less than $1 per order for every branch, and customer-type share moves it by less than $0.8. In other words, the branches are not winning because they sell a radically different mix.

Giza’s product mix is actually slightly unfavorable (-$0.93 per order), but it more than makes up for that with stronger spending inside categories and customer segments. The key driver is within-group spend, not mix.

Branch revenue ranking
Giza is ahead, while Alex and Cairo are effectively tied on total sales.
Foot traffic vs average basket size
Bubble size represents total revenue; dashed guides mark the three-branch average.
Revenue gap decomposition vs branch average
Stacked bars show how much of each branch’s revenue gap comes from traffic, ticket size, and their interaction.
Product-line revenue mix by branch
Revenue shares differ only modestly, which is why mix contributes little to the overall gap.
Average basket inside each product line
Heatmap cells highlight where branches ring up larger orders within the same category.
Customer-type mix vs customer-type spend
Bars show revenue mix; line markers show average basket for members and normal shoppers.
Branch scorecard
Branch Revenue Transactions Avg basket Units / order Member share Avg rating