Year
Branch
Dept
Month
Data Base — Complete Dashboard Data
Edit revenue & expenses · All metrics auto-calculated
Monthly Financial Records — Base Data (Editable)
| Month |
Revenue (K) ✎ |
Expenses (K) ✎ |
Net Profit |
Margin % |
Cash Flow |
ROI |
Exp Ratio |
Signal |
| TOTAL / AVG |
| |
| | |
| |
HEALTHY |
Branch Performance Parameters
| Branch | Rev Multiplier | Exp Multiplier |
Eff. Revenue | Eff. Expenses |
Eff. Margin | Signal |
Revenue by Segment — Base Values
| Segment | Base Value (K) | Share % | Tag |
| Commercial | 920K | 22% | B |
| Industrial | 1,450K | 34% | I |
| Services | 880K | 21% | S |
| Exports | 650K | 15% | X |
| Retail | 300K | 7% | R |
| TOTAL | 4,200K | 100% | — |
Year Modifiers — Filter Logic
| Year | Rev × | Exp × | Net Effect | Phase |
| 2022 | ×0.70 | ×0.80 | ↓ Weak | Low base |
| 2023 | ×0.88 | ×0.92 | ↗ Recovery | Growth |
| 2024 | ×1.00 | ×1.00 | ✓ Base | Reference |
| 2025 | ×1.18 | ×1.08 | ↑ Strong | Expansion |
| 2026 | ×1.35 | ×1.15 | ↑↑ Peak | Maturity |
| Department | Rev × | Exp × | Margin Impact |
| All Depts | ×1.00 | ×1.00 | Neutral |
| Commercial | ×1.15 | ×1.05 | ↑ Strong |
| Operations | ×0.85 | ×0.88 | → Moderate |
| HR | ×0.55 | ×0.72 | ↓ Low margin |
Budget Targets — Gauge Logic
| Category | Budget Target | Colour | Calculation |
| Revenue | 80% | Green | margin + 48 |
| Salaries | 100% | Gold | 97 × branch mult |
| Operations | 80% | Teal | 82 × branch mult |
| Marketing | 70% | Blue | 57 × branch mult |
| Transport | 70% | Blue | 76 × branch mult |
| Net Profit | 85% | Green | margin × 2.5 |