Data Report

Report ยท 04
๐Ÿœ

Legal and Compliance

Mie Gacoan ยท 557 Outlets ยท 34 Provinces

Total BranchesAll verified outlets scraped from Google Maps. Each requires IMB, lease, and halal compliance tracking.
557
Expiring Leases < 90 days7 of these 19 are in high-revenue locations. Losing them costs est. Rp 3-5B/year in revenue.
19
High-Risk Disputes32% are in Jakarta alone โ€” driven by expensive real estate and complex landlord relationships.
56

Mie Gacoan operates 557 outlets across 34 provinces โ€” each with its own lease agreement, building permit, halal certificate, and potential legal disputes. This dashboard answers the 3 strategic questions that the Head of Legal needs answered every morning: which branches are at risk, where are the risks concentrated, and what needs action today.

Q1 โ€” HEAD OF LEGAL

Which branches have critical compliance issues?

The map below shows dispute risk by province. Red provinces (Jakarta, Jawa Barat, Jawa Timur, Banten) have the highest concentration of legal disputes โ€” these 4 provinces alone account for 60% of all high-risk cases despite having 55% of outlets.

Tingkat_Sengketa Low High (Butuh Eskalasi) Medium
Java island carries 80% of high-dispute cases. Dedicated legal counsel for Jabodetabek alone would reduce dispute resolution time by est. 40% and save Rp 200-300M in annual legal fees.
Q2 โ€” CFO ยท LEGAL TEAM

Where are the lease expiration risks concentrated?

Lease renewals involve Rp 150-800M per outlet per year. The chart below shows how many outlets fall into each urgency bucket. The red bars represent branches that need action within 90 days โ€” or face closure.

Lease Expiry Distribution (Days Remaining)
Average Annual Rent by Province (M IDR)
19 outlets expire within 90 days โ€” total annual rent exposure for these 19 is est. Rp 8.5B. Jakarta branches carry the highest per-outlet risk (avg Rp 720M/year). The CFO should pre-approve renewal budgets for the top 7 high-revenue locations immediately.
Q3 โ€” VP OPERATIONS ยท LEGAL

What's the geographic distribution of disputes?

Understanding where disputes cluster helps identify systemic issues โ€” is it a region, a property type, or a landlord pattern?

Dispute Level Distribution
Outlets by Province (Top 10)
70% of outlets have low dispute levels โ€” the network is generally healthy. But the 10% with high disputes are overwhelmingly in urban Java. Jawa Timur has the most outlets (120) but Jakarta has the highest dispute rate per outlet. This suggests Jakarta's property market dynamics (not outlet count) drive legal risk.
DAILY ACTION

Priority Action List โ€” Sorted by Urgency

This table is designed for the legal team's daily standup. Red rows are past due โ€” these outlets are operating on expired leases. The team should contact these landlords within 48 hours.

Branch NameProvinceMapsIMB StatusDue DateDays LeftAction
1.Mie Gacoan - KenjeranKota SurabayaMapsApprovedMar 1, 2026-12Renewal Required
2.Mie Gacoan SerangKota SerangMapsApprovedMar 2, 2026-11Renewal Required
3.Mie Gacoan Bengkulu - SudirmanKota BengkuluMapsApprovedMar 4, 2026-9Renewal Required
4.Mie Gacoan PakerisanKota DenpasarMapsApprovedMar 8, 2026-5Renewal Required
5.Mie Gacoan Kapten MuslimKota MedanMapsApprovedMar 9, 2026-4Renewal Required
6.Mie Gacoan SungailiatKab. BangkaMapsApprovedMar 14, 20261Renewal Required
7.Mie Gacoan Jakarta - CondetKota Jakarta TimurMapsApprovedMar 17, 20264Renewal Required
8.Mie Gacoan Bandung - BragaKota BandungMapsApprovedMar 17, 20264Renewal Required
9.Mie Gacoan Semarang - PemudaKota SemarangMapsIn ProgressMar 22, 20269Renewal Required
10.Mie Gacoan Malang - Soekarno HattaKota MalangMapsApprovedMar 28, 202615Renewal Required
โš ๏ธ Outlet locations are real (Google Maps). Legal compliance data is generated based on realistic patterns for portfolio demonstration purposes.