Client Background
A contemporary Indonesian fusion restaurant concept had grown from one location in 2012 to five across Jakarta by 2017. Customers loved the food, reviews were excellent, tables were full during peak hours.
But despite Rp 24 billion in annual revenue, net profit margin was disappointing at 8.5%—well below the 12-15% industry standard.
The Problem
Revenue Growth Without Profit Growth
After a strong revenue month (Rp 2.3B) resulted in disappointing profit (Rp 180M, 7.8% margin), the owner realized: "We're busy, but we're not profitable. We need to understand WHY."
The Symptoms:
Food costs: 38% of revenue (target: 28-32%)
Labor costs: 33% of revenue (target: 25-30%)
Food waste: Estimated 15-20% (no precise measurement)
Location performance highly variable (3-17% profit margin)
What She Didn't Know:
Which specific menu items were profitable vs. unprofitable
Actual food waste by ingredient and dish
Optimal staff scheduling by location, day, and hour
True cost of each dish (accounting for waste and prep time)
Customer ordering patterns and attachment rates
The Solution
Implemented comprehensive data analytics framework:
Phase 1: Data Foundation (Months 1-2)
Integrated POS transactions, recipe costing, supplier invoices, labor data, inventory counts
Defined key metrics: dish-level profitability, food cost %, labor efficiency, attachment rates
Established baseline across all 5 locations
Phase 2: Menu Engineering (Months 2-3)
Broke down every menu item to ingredient level
Calculated true profitability including waste factors and prep labor
Classified items: Stars (keep), Plowhorses (raise price/reduce cost), Puzzles (reposition), Dogs (eliminate)
Shocking Discovery: 12 menu items (18% of menu) were net negative contribution. Popular "Rendang Sliders" lost Rp 8,000 per order after accounting for prep time and waste.
Phase 3: Operational Optimization (Months 3-4)
Analyzed traffic patterns to create optimized staff schedules
Established demand-based par levels and prep schedules
Identified underpriced items for modest increases
Phase 4: Implementation (Months 4-6)
Eliminated 12 unprofitable items, introduced 8 high-margin items
Redesigned menu layout to highlight profitable items
Implemented optimized schedules and waste tracking
The Results
Financial Performance (12 Months Post-Implementation)
Net profit margin: 8.5% → 11.3% (+2.8 points = +33% improvement)
Annual profit increase: Rp 672 million
Food cost: 38% → 31% (-Rp 1.68B annually)
Labor cost: 33% → 28% (-Rp 1.2B annually)
Food waste: 18% → 9.2% (-Rp 864M annually)
Operational Efficiency
Inventory turnover: 24x → 35x annually
Table turn time: 75 min → 65 min (20% more covers daily)
Revenue per labor hour: Rp 165K → Rp 218K (+32%)
Customer satisfaction: 4.1 → 4.6
Key Discoveries
Discovery 1: The Over-Portioning Problem Grilled fish dishes had 48% food cost. Investigation revealed chefs using 240-280g portions vs. 180g standard recipe (being "generous"). Solution: portioning training and visual guides. Result: food cost 48% → 32%, Rp 156M annual savings with no customer satisfaction impact.
Discovery 2: The Lunch vs. Dinner Mystery Same menu and prices, but lunch showed 14% margin while dinner only 6%. Root cause: dinner customers ordered more alcoholic drinks (low margins from poor supplier pricing), elaborate plating was labor-intensive, evening staff more expensive. Solution: renegotiated beverage contracts, simplified plating, rebalanced staffing. Result: dinner margin 6% → 9.5%, Rp 288M impact.
Discovery 3: The Waste Culprit One location averaged 28% waste vs. 18% chain average. Kitchen manager over-prepped fresh herbs and garnishes "to be safe," discarding at night. Solution: prep-on-demand for perishables, demand forecasting training, daily waste tracking. Result: location waste 28% → 11%.
Discovery 4: The Invisible Winner House iced tea had 84% profit margin (Rp 38K price, Rp 6K cost) but only 12% order rate. Solution: server training to recommend as "house specialty," menu repositioning, combo meals. Result: order rate 12% → 34%, +Rp 245M annual profit.
The Analytics Culture Shift
Before: Intuition-Driven
"I think this dish is popular, let's keep it"
"We seem busy on weekends, staff accordingly"
Results: hit or miss, no validation
After: Data-Driven
"This dish is ordered 340 times monthly but loses Rp 8,000 per order—eliminate it"
"Friday dinner is 2.3x busier than Tuesday lunch—staff accordingly"
Results: measurable, optimizable, continuously improving
Manager Dashboards provide daily metrics: revenue, food cost %, labor cost %, waste, customer feedback, with weekly and monthly strategic reviews.
Investment & ROI
Costs:
Software: Rp 3.5M monthly
Initial setup: Rp 24M
Analytics consulting (6 months): Rp 48M
Returns:
Annual profit impact: Rp 672M
ROI: 933% in first year
Broader Impact
Data-driven capabilities enabled:
Expansion: Opened 3 additional locations (2019-2020), all profitable within 6 months
Team Development: Kitchen managers learned business analytics, servers understood contribution margin
Industry Recognition: Case study featured in Indonesian restaurant publications
Culture Shift: "What does the data tell us?" became the first question for all decisions
"I thought our problem was external—competition, rent, supplier prices. Analytics showed me most problems were internal—portions, pricing, scheduling, menu mix. And internal problems are fixable." - Owner
Today, every business decision—new menu items, pricing changes, location expansion—starts with data analysis. That shift from intuition to intelligence made all the difference.
Want to unlock hidden profitability in your restaurant or retail business? Contact KSI Digital Solutions to discuss data analytics implementation and business intelligence.