Batangas City scenarios A, B, C
Adopted FY2025 is scenario A. B holds the estimated year (FY2024). C trims ledger offices and holds the total. Upload a proposed book, edit departments, then read the simulation against estimated and FY2023 actuals.
| Department | Adopted FY2025 | FY2024 est. | FY2023 actual | Scenario A |
|---|---|---|---|---|
| OFFICE OF THE CITY MAYOR | ₱1.45B | ₱1.69B | ₱2.16B | |
| SPECIAL PURPOSE APPROPRIATIONS | ₱763.38M | ₱773.63M | ₱581.46M | |
| OFFICE OF THE CITY HEALTH OFFICER | ₱233.82M | ₱213.38M | ₱175.65M | |
| OFFICE OF THE CITY GENERAL SERVICES OFFICER | ₱139.22M | ₱126.92M | ₱117.3M | |
| SANGGUNIANG PANLUNGSOD | ₱137.06M | ₱134.52M | ₱112.35M | |
| OFFICE OF THE CITY ENGINEER | ₱125.71M | ₱120.61M | ₱93.85M | |
| OFFICE OF THE CITY SOCIAL WELFARE & DEV'T. OFFICER | ₱90M | ₱81.23M | ₱123.81M | |
| COLEGIO NG LUNGSOD NG BATANGAS | ₱77.34M | ₱118.9M | ₱61.93M | |
| OFFICE OF THE CITY TREASURER | ₱67.54M | ₱61M | ₱48.1M | |
| OFFICE OF THE CITY ASSESSOR | ₱57.59M | ₱52.27M | ₱39.78M | |
| OFFICE OF THE CITY MARKET ADMINISTRATOR | ₱55.33M | ₱70.46M | ₱50.35M | |
| OFFICE OF THE CITY ACCOUNTANT | ₱51.62M | ₱42.49M | ₱38.65M | |
| OFFICE OF THE CITY VETERINARY | ₱50.1M | ₱47M | ₱38.66M | |
| OFFICE OF THE CITY ENVIRONMENT AND NATURAL RESOURCES OFFICER | ₱47.86M | ₱150.52M | ₱196.05M | |
| OFFICE OF THE CITY AGRICULTURE | ₱45.85M | ₱42.87M | ₱33.02M | |
| OFFICE OF THE CITY PLANNING & DEVELOPMENT COORDINATOR | ₱36.43M | ₱29.98M | ₱27.14M | |
| OFFICE OF THE CITY DISASTER RISK REDUCTION & MANAGEMENT OFFICER | ₱36.4M | ₱31.58M | ₱14.96M | |
| OFFICE OF THE CITY HUMAN RESOURCE MANAGEMENT & DEVELOPMENT | ₱33.44M | ₱31.21M | ₱18.93M | |
| OFFICE OF THE CITY CIVIL REGISTRAR | ₱30.81M | ₱28.89M | ₱25.75M | |
| OFFICE OF THE CITY BUDGET OFFICER | ₱27.54M | ₱26.43M | ₱20.92M | |
| OFFICE OF THE CITY LEGAL OFFICER | ₱21.28M | ₱15.4M | ₱10.94M | |
| OFFICE OF THE CITY INTERNAL AUDIT SERVICE | ₱13.83M | ₱13.28M | ₱6.06M | |
| OFFICE OF THE CITY PROSECUTOR | ₱5.13M | ₱4.11M | ₱2.68M |
Simulated results vs estimated
Each scenario is scored against the estimated year the city already printed. When actuals exist, MAPE says which book would have been closer — and learned department biases project the next year.
| Metric | A · Adopted FY2025 | B · Hold FY2024 estimated | C · Hold total · trim ledger offices |
|---|---|---|---|
| Total | ₱3.6B | ₱3.91B | ₱3.6B |
| Vs estimated | -7.9% | 0% | -7.9% |
| Vs adopted | 0% | +8.6% | 0% |
| Top 3 concentration | 68.1% | 68.6% | 67.3% |
| Largest increase | OFFICE OF THE CITY LEGAL OFF +38.2% | OFFICE OF THE CITY MAYOR 0% | OFFICE OF THE CITY LEGAL OFF +42.8% |
| Largest cut | OFFICE OF THE CITY ENVIRONME -68.2% | OFFICE OF THE CITY MAYOR 0% | OFFICE OF THE CITY ENVIRONME -67.1% |
| MAPE vs actuals (hindsight) | 48.5% | 38.3% | 52.2% |
| Projected actual (learned) | ₱3.6B | ₱4B | ₱3.57B |
- OFFICE OF THE CITY TREASURER is +10.7% vs estimated — ledger offices grew in several of the mapped theft cases.
- Top 3 departments hold 68.1% of this scenario. Concentration is not waste, but it is where a bad year hides.
- Top 3 departments hold 68.6% of this scenario. Concentration is not waste, but it is where a bad year hides.
- Top 3 departments hold 67.3% of this scenario. Concentration is not waste, but it is where a bad year hides.
23 departments have actuals vs estimated
Where FY2023 actuals missed the FY2024 estimate, we keep that factor. The next proposed book is simulated as “what this office usually really spends,” not what it prints. Lowest MAPE after learning is the scenario to take to council.
| Department | Est. error | Learned factor |
|---|---|---|
| OFFICE OF THE CITY INTERNAL AUDIT SERVICE | -54.4% | ×0.456 |
| OFFICE OF THE CITY DISASTER RISK REDUCTION & MANAGEMENT OFFICER | -52.6% | ×0.474 |
| OFFICE OF THE CITY SOCIAL WELFARE & DEV'T. OFFICER | +52.4% | ×1.524 |
| COLEGIO NG LUNGSOD NG BATANGAS | -47.9% | ×0.521 |
| OFFICE OF THE CITY HUMAN RESOURCE MANAGEMENT & DEVELOPMENT | -39.4% | ×0.606 |
| OFFICE OF THE CITY PROSECUTOR | -35.0% | ×0.650 |
| OFFICE OF THE CITY ENVIRONMENT AND NATURAL RESOURCES OFFICER | +30.3% | ×1.303 |
| OFFICE OF THE CITY LEGAL OFFICER | -29.0% | ×0.710 |
| OFFICE OF THE CITY MARKET ADMINISTRATOR | -28.5% | ×0.715 |
| OFFICE OF THE CITY MAYOR | +27.3% | ×1.273 |
| SPECIAL PURPOSE APPROPRIATIONS | -24.8% | ×0.752 |
| OFFICE OF THE CITY ASSESSOR | -23.9% | ×0.761 |
$1,500 / month on mapped cities
Upload as many proposed books as you run through council. We keep the scenarios, score them when estimated and actuals move, and the model tightens. This preview runs in the browser on the extract we already hold; the paid feed stores the city's own proposed files.