Collection Efficiency
93.2%
Target: ≥95%
On Track| Concern / Issue | Division | Status |
|---|---|---|
| Collection efficiency below target | Accounts | For Action |
| New service growth shortfall | Customer Service | Monitor |
| Unresolved customer complaints | Customer Service | Priority |
TABACO WATER DISTRICT (TAWAD)
COMMERCIAL SERVICES DEPARTMENT
MANAGEMENT DASHBOARD
Reporting Period: October 2026
“Safe, Adequate, Affordable Water
for a Better Tabaco!”
for a Better Tabaco!”
1. EXECUTIVE SUMMARY
Total Collections
₱4.80M
vs. Billing: ₱5.20M
92% of BillingNet Service Growth
+85
Target: ≥100/month
Needs AttentionCustomer Complaints
38
32 Resolved (84.2%)
On TrackAccounts Receivable (AR)
₱8.75M
vs. Total Billing: ₱5.20M
Monitor▦ ACCOUNTS DIVISION
Collection Performance
94.8%
Target: ≥95%
Collections Trend
Key Highlights
● Collection efficiency at 94.8%
● AR balance at ₱8.75M
● 485 dormant accounts for validation
♟ CUSTOMER SERVICE DIVISION
Service Performance
92.0%
Target: 100 new
applications/month
applications/month
Key Indicators
▤ New Service Applications
92 (92% of target)
92 (92% of target)
⌕ Investigations Completed
47 / 50 (94%)
47 / 50 (94%)
⚒ Disconnection Actions
425 / 708 (60.0%)
425 / 708 (60.0%)
♧ Reconnection Requests
78
78
Service Concerns
▲ New service growth below target
▲ Delinquent accounts at 60.0% action rate
▲ Unresolved complaints (6)
▥ 2. FINANCIAL PERFORMANCE
Billing vs Collection
₱5.20MTotal Billing
₱4.80MCollections
AR Balance
₱8.75M(≈ 1.8× monthly billing)⚙ 3. MANAGEMENT ACTION TRACKER
♟ 4. KEY RECOMMENDATIONS
●Intensify collection efforts and monitor aging accounts.
●Accelerate processing of new service applications and attend to customer concerns.
●Continue coordination between Accounts and Customer Service Divisions for improved service delivery and revenue performance.