Portal Tools

OPEX Ratio & Profit Sensitivity

1Input Data 2Hasil Analisa

Download enam template CSV per kelompok data, lengkapi file, lalu upload seluruhnya. Seluruh file menggunakan ANALYSIS_ID sebagai relational key (satu ANALYSIS_ID = satu outlet pada satu periode). Klik Proses Analisa setelah keenam file ter-upload.

Lihat panduan lengkap →
1
BUSINESS_PROFILE Required
Identitas bisnis, outlet, periode, skala bisnis, dan area lokasi
↓ Download CSV
Not Uploaded
2
SALES Required
Gross sales, discount, dan breakdown sales per channel
↓ Download CSV
Not Uploaded
3
COGS Required
Food cost, beverage cost, dan packaging cost
↓ Download CSV
Not Uploaded
4
LABOR Required
Salary, overtime, incentive, dan employee benefits
↓ Download CSV
Not Uploaded
5
OCCUPANCY Required
Rent, service charge, maintenance building, dan promotion levy
↓ Download CSV
Not Uploaded
6
OTHER_OPEX Required
Utilities, marketing, platform fee, repair, cleaning, software, admin, dan biaya lain
↓ Download CSV
Not Uploaded
i
Relational Key. ANALYSIS_ID wajib tersedia pada seluruh file CSV. Contoh: ANL-001 pada BUSINESS_PROFILE harus memiliki pasangan ANL-001 pada SALES, COGS, LABOR, OCCUPANCY, dan OTHER_OPEX.