City of Bacoor 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 |
|---|---|---|---|---|
| 20% Development Fund | ₱440.21M | ₱371.71M | ₱337.22M | |
| OFFICE OF THE SOCIAL WELFARE AND DEVELOPMENT | ₱418.52M | ₱382.21M | ₱334.2M | |
| CITY ENVIRONMENT SERVICE DEPARTMENT | ₱380.85M | ₱380.35M | ₱340.54M | |
| OFFICE OF THE GENERAL SERVICES | ₱287.98M | ₱337.99M | ₱252.07M | |
| Peace and Order/Public Safety Programs | ₱224.18M | ₱204.78M | ₱150.26M | |
| POST DISASTER FUND | ₱176.75M | ₱156M | ₱142.5M | |
| OFFICE OF THE CITY HEALTH SERVICES | ₱175.77M | ₱176.76M | ₱145.16M | |
| OFFICE OF THE CITY MAYOR | ₱155.1M | ₱171.26M | ₱175.77M | |
| Other Programs/Projects (Various Local Govt. Affairs) | ₱110.42M | ₱91M | ₱36.77M | |
| Suibsidies/Donations | ₱104.45M | ₱45.75M | ₱52.13M | |
| LOAN AMORTIZATION | ₱103.58M | ₱101.22M | ₱66.48M | |
| OFFICE OF THE CITY ENGINEER | ₱96.03M | ₱101.47M | ₱113.41M | |
| OFFICE OF THE SANGGUNIANG PANLUNGSOD | ₱92.72M | ₱88.92M | ₱76.31M | |
| Senior Citizens and Persons with Disabilities (PWDs) - DBM/DSWD Joint | ₱77.4M | ₱66.6M | ₱65.24M | |
| Special purpose — OFFICE OF THE CITY MAYOR | ₱64.25M | ₱58.43M | ₱0 | |
| CITY BACOOR TRAFFIC MANAGEMENT DEPARTMENT | ₱55.95M | ₱53.28M | ₱26.92M | |
| DISASTER RISK REDUCTION AND MANAGEMENT | ₱49.01M | ₱49.72M | ₱52.74M | |
| E-GOVERNANCE DEPARTMENT | ₱41.95M | ₱51.25M | ₱36.03M | |
| CITY FINANCE DEPARTMENT(CITY TREASURER'S OFFICE) | ₱41.83M | ₱35.43M | ₱25.3M | |
| OFFICE OF THE CITY VICE MAYOR | ₱39.02M | ₱38.63M | ₱33.03M | |
| Support to Bacoor City Public Schools (DepEd) | ₱26.98M | ₱26.98M | ₱26.83M | |
| OFFICE OF THE CITY MAYOR - Family Care Development Center | ₱25M | ₱25M | ₱25.78M | |
| City Council for the Protection of Children (CCPC) - Mandatory | ₱25M | ₱23.5M | ₱23.17M | |
| CITY ASSESSOR'S DEPARTMENT | ₱20.13M | ₱34.52M | ₱10.85M | |
| OFFICE OF THE CITY BUILDING OFFICIAL | ₱17.15M | ₱16.67M | ₱11.63M | |
| OFFICE OF THE ACCOUNTING AND INTERNAL AUDIT SERVICES | ₱17.12M | ₱16.38M | ₱10.03M | |
| DEPARTMENT OF PUBLIC SAFETY | ₱16.62M | ₱16.14M | ₱0 | |
| BACOOR CITY CULTURE, HISTORY, ARTS AND TOURISM OFFICE | ₱15.23M | ₱18.45M | ₱0 | |
| BUSINESS PERMITS AND LICENSING DEPARTMENT | ₱15.01M | ₱14.35M | ₱7.08M | |
| OFFICE OF THE CITY LEGAL SERVICE | ₱14.73M | ₱15.6M | ₱4.98M | |
| CITY INFORMATION AND COMMUNITY RELATIONS DEPARTMENT | ₱14.4M | ₱15.17M | ₱13.51M | |
| HUMAN RESOURCES DEVELOPMENT AND MANAGEMENT | ₱14.12M | ₱12.84M | ₱12.11M | |
| OFFICE OF THE CITY MAYOR - Sports Development Unit | ₱12M | ₱17.4M | ₱15.34M | |
| Miscellaneous Personnel Benefits Fund | ₱12M | ₱13.46M | ₱34.79M | |
| CITY LIVELIHOOD AND DEVELOPMENT DEPARTMENT | ₱11.36M | ₱0 | ₱0 | |
| HOUSING, URBAN DEVELOPMENT AND RESETTLEMENT | ₱11.21M | ₱10.74M | ₱4.12M | |
| OFFICE OF THE CITY CIVIL REGISTRY | ₱10.58M | ₱8.76M | ₱5.9M | |
| OFFICE OF VETERINARY SERVICES | ₱10.05M | ₱8.78M | ₱6.81M | |
| Barangay Development Fund | ₱10M | ₱15M | ₱2.18M | |
| CITY PLANNING AND DEVELOPMENT COORDINATING OFFICE | ₱9.75M | ₱10.03M | ₱5.22M | |
| PUBLIC EMPLOYMENT SERVICES OFFICE | ₱9.32M | ₱9.04M | ₱6.35M | |
| CITY BUDGET DEPARTMENT | ₱7.82M | ₱7.74M | ₱6.73M | |
| OFFICE OF THE AGRICULTURAL SERVICES | ₱7.68M | ₱7.53M | ₱7.76M | |
| ZONING AND LAND DEVELOPMENT DEPARTMENT | ₱7.22M | ₱6.92M | ₱2.7M | |
| LOCAL ECONOMIC DEVELOPMENT AND INVESTMENT PROMOTION OFFICE | ₱7.02M | ₱6.59M | ₱0 | |
| OFFICE OF THE CITY MAYOR-Building Maintenance Unit | ₱7M | ₱7M | ₱21.29M | |
| OFFICE OF THE CITY MAYOR- Operation of City Cemetery | ₱6.37M | ₱7.37M | ₱6.06M | |
| OFFICE OF THE POPULATION DEVELOPMENT | ₱6.03M | ₱5.63M | ₱4.72M | |
| OFFICE OF THE CITY ARCHITECTURAL PLANNING AND DESIGN | ₱5.39M | ₱5.31M | ₱0 | |
| OFFICE OF THE CITY MAYOR -Vehicle Services & Maintenance Unit | ₱5M | ₱5M | ₱4.95M | |
| CITY ADMINISTRATOR'S OFFICE | ₱4.42M | ₱7.29M | ₱6.35M | |
| OFFICE OF THE CITY MAYOR-Local Youth Development Office | ₱4.05M | ₱7M | ₱1.96M | |
| OFFICE OF THE CITY MAYOR - Bacoor Satellite Office | ₱3.5M | ₱3.5M | ₱2.75M | |
| OFFICE OF THE CITY MAYOR-Operations of Bacoor Public Market | ₱2.8M | ₱2.8M | ₱2M | |
| Board of Discipline/PPP-PBAC | ₱2.3M | ₱0 | ₱0 | |
| OFFICE OF THE CITY MAYOR - Cooperative Development | ₱1M | ₱1M | ₱1M | |
| OFFICE OF THE CITY MAYOR-Office of the Senior Citizen's Affairs | ₱1M | ₱1M | ₱990.08K | |
| OFFICE OF THE CITY MAYOR- Public Services Division | ₱500K | ₱500K | ₱483.4K | |
| OFFICE OF THE CITY MAYOR-Office of Person with Disability | ₱500K | ₱500K | ₱0 | |
| OFFICE OF THE CITY MAYOR - Overseas Workers Welfare Unit | ₱500K | ₱500K | ₱484.98K | |
| Adjudicators | ₱480K | ₱0 | ₱0 | |
| COA- Auditing Services | ₱300K | ₱300K | ₱163.82K | |
| OFFICE OF THE CITY MAYOR - Bids and Awards Unit | ₱250K | ₱250K | ₱242.49K | |
| OFFICE OF THE CITY MAYOR-STRIKE Gym Management Unit | ₱100K | ₱100K | ₱0 | |
| Bureau of Internal Revenue (BIR) | ₱60K | ₱60K | ₱60K |
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.54B | ₱3.38B | ₱3.54B |
| Vs estimated | +4.7% | 0% | +4.7% |
| Vs adopted | 0% | -4.5% | 0% |
| Top 3 concentration | 35.1% | 33.6% | 35.2% |
| Largest increase | Suibsidies/Donations +128.3% | 20% Development Fund 0% | Suibsidies/Donations +129.2% |
| Largest cut | OFFICE OF THE CITY MAYOR-Loc -42.1% | 20% Development Fund 0% | OFFICE OF THE CITY MAYOR-Loc -46.6% |
| MAPE vs actuals (hindsight) | 51.3% | 54.6% | 51.8% |
| Projected actual (learned) | ₱2.92B | ₱2.76B | ₱2.92B |
- Special purpose — OFFICE OF THE CITY MAYOR is +10% vs estimated — ledger offices grew in several of the mapped theft cases.
- CITY FINANCE DEPARTMENT(CITY TREASURER'S OFFICE) is +18.1% vs estimated — ledger offices grew in several of the mapped theft cases.
No automated risk callouts.
- CITY FINANCE DEPARTMENT(CITY TREASURER'S OFFICE) is +9% vs estimated — ledger offices grew in several of the mapped theft cases.
62 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 MAYOR-Building Maintenance Unit | +204.1% | ×3.041 |
| Miscellaneous Personnel Benefits Fund | +158.6% | ×2.586 |
| Special purpose — OFFICE OF THE CITY MAYOR | -100.0% | ×0.000 |
| DEPARTMENT OF PUBLIC SAFETY | -100.0% | ×0.000 |
| BACOOR CITY CULTURE, HISTORY, ARTS AND TOURISM OFFICE | -100.0% | ×0.000 |
| LOCAL ECONOMIC DEVELOPMENT AND INVESTMENT PROMOTION OFFICE | -100.0% | ×0.000 |
| OFFICE OF THE CITY ARCHITECTURAL PLANNING AND DESIGN | -100.0% | ×0.000 |
| OFFICE OF THE CITY MAYOR-Office of Person with Disability | -100.0% | ×0.000 |
| OFFICE OF THE CITY MAYOR-STRIKE Gym Management Unit | -100.0% | ×0.000 |
| Barangay Development Fund | -85.5% | ×0.145 |
| OFFICE OF THE CITY MAYOR-Local Youth Development Office | -72.1% | ×0.279 |
| CITY ASSESSOR'S DEPARTMENT | -68.6% | ×0.314 |
$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.