Berkeley's 27 adopted plans, the City Auditor's 384 tracked recommendations, and the FY2027–28 biennial budget (adopted June 23, 2026), joined by strategic goal and by department. Compiled July 20, 2026.
Berkeley Transparency Hub · built from public documents · residents decideEach row is a Strategic Plan goal (January 2018). Columns show what the city has planned, what its own Auditor has flagged and what happened to those flags, and what the adopted budget funds. Backlog = recommendations open + dropped.
| Strategic goal | Plan coverage | Audit backlog in this domain | Budget reality (FY27 adopted†) | The tension |
|---|---|---|---|---|
| 4 · Financially healthy government | No plan No fiscal sustainability plan on the adopted-plans list |
4 of 5 dropped Financial Condition FY12–21 (2022) 15 of 15 dropped Citywide Grants Management (2016) Financial Condition FY16–25 audit (Apr 2026) not yet in dashboard |
Deficit of $29.2M (FY27) / $29.5M (FY28) closed via ~10% GF cuts + assumed Nov 2026 sales tax (~$10M/yr) | The city's dominant operational problem has the weakest planning and audit follow-through of any goal. |
| 9 · Talented, diverse workforce | No plan | 10 open Staff Shortages / Retention & Hiring (2023, 15 of 25 implemented) | −164.33 FTE net all funds; 138 positions slated for elimination | The retention audit is half-done while the budget cuts 9% of positions — mostly vacancies the city budgeted for but never filled. |
| 8 · Customer-focused service | No plan | 7 open Restaurant Inspections understaffed (2024) 5 dropped Code Enforcement constrained (2020) |
Planning $34.4M / HHCS $165.5M all funds | The audits that map to service quality are the ones stalled or dropped. |
| 3 · Social & racial equity | No standalone plan Equity appears as a lens inside newer plans |
13 of 15 done PRW On-Call equity procedures (2019) | — | One of the few domains where audit follow-through outran planning. |
| 1 · Affordable housing & vulnerable residents | Thin Adeline Corridor (2020); Housing Element lives outside this list; nothing on homelessness |
6 open Homeless Response Team (Jul 2025) — all 6 not started | HHCS $165.5M FY27 (largest YoY increase of any dept, +$45.6M vs FY26) | The newest audit backlog sits under the fastest-growing budget. |
| 2 · Climate leadership | Stale core Climate Action Plan is 17 yrs old (2009); Electrification Strategy (2021) lost its regulatory companion in CRA v. Berkeley |
11 open Fleet Replacement Fund Short Millions (2022) 6 dropped Zero Waste alignment (2020) |
Fleet electrification depends on the same fleet fund the Auditor found short — and which was later tapped for $2M + $0.5M | A 2020 Fleet Electrification Plan, a 2022 audit saying the replacement fund is short, and a budget that raided it: the clearest three-way miss on this page. |
| 5 · Infrastructure & facilities | Mixed Paving plan current; Watershed Plan 2012; General Plan 2002; ~$2.1B unfunded capital need, unranked CIP |
12 dropped Underfunded Mandate — sidewalks/streets (2020) 8 open 2009 Leases follow-up: "same risks 16 years later" (2025) 7 dropped Leases: conflicting directives (2019) |
PW $234.5M FY27, the city's largest department; PCI 56 ("at risk"), $250M paving backlog; $300M GO bond proposed for Nov 2026 | The domain with the most money, the most dropped recommendations, and the biggest unfunded backlog. Waterfront: a 1986 master plan, a repeat leases audit, and a tenant (Doubletree) not paying rent. |
| 6 · Sustainable local economy | Stale Corridor/area plans from 1986–2012 (Waterfront '86, West Berkeley '93, University Ave '96, S. Shattuck '98) |
No major open backlog specific to this goal | — | The oldest plan cluster; superseded in practice by state housing law more than by city planning. |
| 7 · Resilient, safe, prepared | Best covered LHMP 2025, CWPP 2023 current; EOP aging (2017); Vision Zero promises zero deaths by 2028 |
11 of 11 dropped Fire Prevention Inspections (2019) 13 of 14 done 911 Dispatchers (2019) 5 of 6 done Measure FF spending (2023) |
Fire $79.0M / Police $106.9M FY27 | Plans stay current here because FEMA and grant eligibility force it — yet the fire-prevention staffing audit was dropped in its entirety. |
All-funds FY2027 budget and FTE from the biennial budget†; audit counts from the Auditor's dashboard (snapshot 2026-04-24, re-verified live July 20, 2026). Sorted by audit backlog (open + dropped).
| Department | FY27 budget | FTE | Recs | Open | Dropped | Implemented | Impl. rate |
|---|---|---|---|---|---|---|---|
| City Manager | $23.1M | 44 | 88 | 12 | 32 | 44 | 50% |
| Public Works | $234.5M | 337 | 64 | 19 | 24 | 21 | 33% |
| Fire | $79.0M | 190 | 24 | 0 | 12 | 12 | 50% |
| Health, Housing & Community Services | $165.5M | 195 | 35 | 7 | 0 | 28 | 80% |
| Human Resources | $6.7M | 24 | 21 | 3 | 0 | 18 | 86% |
| Mayor and Council | $7.5M | 23 | 4 | 2 | 0 | 2 | 50% |
| Parks, Recreation & Waterfront | $52.2M | 114 | 19 | 0 | 2 | 17 | 89% |
| Information Technology | $20.0M | 45 | 9 | 0 | 2 | 7 | 78% |
| Finance | $11.6M | 48 | 43 | 0 | 1 | 42 | 98% |
| Police | $106.9M | 272 | 35 | 0 | 1 | 34 | 97% |
| Planning & Development | $34.4M | 105 | 20 | 0 | 1 | 19 | 95% |
| Library | $34.4M | 131 | 6 | 0 | 1 | 5 | 83% |
| Budget & Fiscal Management | — | — | 5 | 0 | 0 | 5 | 100% |
| City Auditor | $4.0M | 15.75 | 11 | 0 | 0 | 11 | 100% |
The pattern is monotonic at the top: the two departments with the largest operating footprints and most audit exposure — City Manager (88 recs) and Public Works (64 recs) — implement at 50% and 33%, while every department with 20+ recs and a narrower mandate (Finance, Police, Planning) clears 95%. Budget & Fiscal Management recs are tracked separately by the Auditor but the function sits within the City Manager's office in the budget.
External compulsion is the only reliable driver across all three systems. Plans that stay current (LHMP, CWPP, Bicycle/Pedestrian) have FEMA mandates or grant money behind them; the sewer program performs because of a federal consent decree; audit recommendations get implemented when a narrow-mandate department owns them. Purely internal commitments — the Climate Action Plan, the fiscal-health goal, fleet replacement, fire-prevention staffing — degrade in all three systems at once: the plan goes stale, the recommendations get dropped, and the budget line becomes the residual.
The accountability loop is open. Nothing currently connects plan adoption to funding, or audit acceptance to implementation. 76 recommendations were formally dropped — a fifth of everything the Auditor has recommended since 2013 — with no budget consequence. A published, criteria-based capital prioritization (GFOA-style) and an audit-to-budget crosswalk requirement at adoption would close the loop; neither exists today.