🤖 AI Insights (Coming Soon)
Connect your LLM API for AI-generated store performance and manpower efficiency insights.
💡 Manpower cost = Gross Wage + Employer CPF (total cost to company).
Total Net Sales
-
Total Manpower Cost
-
Gross Wage + Employer CPF
Sales / Manpower $
-
Active Stores
-
Mapped Staff
-
📋 Store Performance 0
| Code | Name | Cluster | Net Sales | Gross Wage | Er CPF | Total MP Cost | Staff | Sales/MP$ |
|---|
📊 Sales per Manpower $ by Store
👤 Staff-Store Mapping: Auto-mapped from the Location sheet. Unmapped staff shown in orange.
Use dropdowns to manually assign stores. Changes persist in your browser.
| Month | Emp ID | Name | Location (File) | Auto | Assigned Store | Gross Wage | Er CPF | Total Cost |
|---|
📋 Parsed sales rows after BU Name → Store mapping. Rows with no store match are excluded from KPIs.
| Month | BU Name (Raw) | Mapped Store | Net Sales (SGD) |
|---|