Actual and Projected Use of Measure A Sales Tax Revenues Over Ten Year Period Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Projected ($ in Millions) 13-14 14-15 15-16 16-17 17-18 18-19 19-20 20-21 21-22 22-23 23-24* Original Anticipated Revenue 6.9 $ 28.4$ 29.4 $ 30.4 $ 31.5 $ 32.7 $ 33.8 $ 35.0 $ 36.2 $ 37.5 $ 29.1$ Actual Sales Tax Revenue 6.6 $ 27.8$ 29.3 $ 30.0 $ 31.7 $ 34.6 $ 34.3 $ 40.8 $ 45.4 $ 49.7 $ 27.1$ Marshall Plan 0.0 $ 5.1 $ 12.9$ 18.3 $ 22.5 $ 24.2 $ 25.9 $ 27.2 $ 26.3 $ 31.9 $ 27.5$ % Annual Use of Tax 0% 18% 44% 61% 71% 70% 76% 67% 58% 64% 101% % Cumulative Use 0% 15% 28% 39% 47% 52% 56% 58% 58% 60% 62% Bankruptcy Recovery 6.6 $ 22.7$ 16.4 $ 11.8 $ 9.3 $ 10.3 $ 8.4 $ 13.6 $ 19.2 $ 17.8 $ (0.3)$ % Annual Use of Tax 100% 82% 56% 39% 29% 30% 24% 33% 42% 36% -1% % Cumulative Use 100% 85% 72% 61% 53% 48% 44% 42% 42% 40% 38% * FY 2023-24 compares the first three projected quarters of the year because Measure A was initially set to expire on 3/31/2024.
ATTACHMENT F
Final Year End Variance With
Budget Actual Final Budget
SOURCES / REVENUES:
Measure A Transaction and Use Tax 27,923,000$ 27,811,587 $ 111,413 $ Total Revenues 27,923,000 27,811,587 111,413 USES / EXPENDITURES:
Police:
Salary & Benefits
Sworn (40) 4,650,323 1,718,905 2,931,418 Non-Sworn (22) 1,465,235 741,613 723,622 Vacancy Savings (1,612,286) - (1,612,286) Other Services 691,811 396,961 294,850 Materials & Supplies
Fuel 186,000 3,935 182,065 Other Supplies 212,266 258,183 (45,917) Equipment
Office Equipment 78,756 26,125 52,631 Radios (39) 390,389 375,873 14,516 Vehicles (39) 1,309,990 1,102,228 207,762 Other Expenses
Training 260,843 233,567 27,276 7,633,327 4,857,390 2,775,937
Office of Violence Prevention:
Salary & Benefits
Non-Sworn (7) 370,555 77,520 293,035 Other Services 279,531 128,698 150,833 Materials & Supplies
Fuel 12,000 - 12,000 Other Supplies 10,000 1,334 8,666 Equipment
Office Equipment 17,500 - 17,500 Radios (39) 27,600 2,380 25,220 Vehicles (39) 75,000 - 75,000 Other Expenses 399 - 399 792,585 209,932 582,653
Basis Adjustment:
Encumbrances (Included in Final Budget) - 484,676 (484,676) Total Measure B Expenditures 8,425,912 5,551,998 2,873,914 Measure B Expenditures as a % of
Annual Measure A Revenues 30% 20%
Other City Services:
Administration Overhead 287,000 230,096 56,904 Mission Critical Projects:
Implementation of Strategic Priorities 200,000 200,000 - Public Safety Radios 1,000,000 1,000,000 - LED Lighting Project Phase I 1,200,000 1,200,000 - Information Technology Projects 5,236,000 5,236,000 - Purchasing Improvements 164,000 132,129 31,871 Economic Dev. Implementation - ULI 100,000 21,000 79,000 Marketing/Communications Plan 100,000 - 100,000 General Fund Available Fund Balance 11,210,088 14,209,583 (2,999,495) Basis Adjustment
Encumbrances (Included in Final Budget) - 30,781 (30,781) 19,497,088 22,259,589 (2,762,501)
Total Uses / Expenditures 27,923,000$ 27,811,587 $ 111,413 $ City of Stockton
Measures A and B
Schedule of Sources and Uses
For the Year Ended June 30, 2015
182
ATTACHMENT F
Final Year End Variance with
Budget Actual Final Budget
SOURCES / REVENUES:
Measure A Transaction and Use Tax 28,125,000$ 29,259,106$ 1,134,106$ Total Revenues 28,125,000 29,259,106 1,134,106 USES / EXPENDITURES:
Police:
Salary & Benefits
Sworn 10,089,556 6,247,971 3,841,585 Non-Sworn 2,502,200 1,954,953 547,247 Vacancy Savings (2,933,065) - (2,933,065) Other Services 1,213,234 775,634 437,600 Materials & Supplies
Fuel 175,202 58,588 116,614 Other Supplies 275,310 212,470 62,840 Radios 2,079,464 1,396,096 683,368 Vehicles 1,435,485 1,233,765 201,720 Technology Upgrades 796,000 104,547 691,453 Other Expenses
Training 307,500 271,761 35,739 15,940,886 12,255,785 3,685,101 Office of Violence Prevention:
Salary & Benefits
Non-Sworn 592,900 302,489 290,411 Other Services 315,389 221,737 93,652 Materials & Supplies
Fuel 12,000 - 12,000 Other Supplies 10,000 11,210 (1,210) Equipment
Office Equipment 17,500 451 17,049 Vehicles 74,774 74,274 500 Other Expenses 2,000 1,696 304 1,024,563 611,857 412,706 Basis Adjustment:
Encumbrances (included in Final Budget) - 556,016 (556,016) Total Measure B Expenditures 16,965,449$ 13,423,658$ 3,541,791$ Measure B expenditures as a % of
annual Measure A revenues 60% 46%
Other City Services:
LED Lighting Project Phase I & III 1,576,000 1,576,000 - Information Technology Projects 385,000 385,000 - Purchasing Improvements 30,781 30,781 - SEB 4th Floor Build Out 1,500,000 1,500,000 - Police Communications System Upgrade 650,000 650,000 - Citywide Training 130,000 36,400 93,600 Parks Irrigation Controller Upgrade 588,000 588,000 - Street Resurfacing 500,000 226,199 273,801 Sidewalks 300,000 300,000 - General Fund Services and Reserves 5,499,770 10,269,267 (4,769,497) Basis Adjustment:
Encumbrances (included in Final Budget) - 273,801 (273,801) 11,159,551 15,835,448 (4,675,897) Total Uses/Expenditures 28,125,000$ 29,259,106$ (1,134,106)$ Measures A and B
Schedule of Sources and Uses
For Year Ended June 30, 2016
City of Stockton
176
ATTACHMENT F
Final Year End Variance with
Budget Actual Final Budget
Revenues
Measure A Transaction and Use Tax 30,161,000$ 30,048,605$ (112,395)$ Total Revenues 30,161,000$ 30,048,605$ (112,395)$
Uses/Expenditures
Police
Salary & Benefits
Sworn 16,685,841 11,077,640 5,608,201
Non-Sworn 3,325,678 2,313,333 1,012,345
Vacancy Savings (3,640,000) - (3,640,000)
Other Services 1,363,526 1,217,757 145,769
Materials & Supplies
Fuel 146,461 135,690 10,771
Other Supplies 540,024 441,864 98,160
Equipment
Radios 489,465 411,352 78,113
Vehicles 1,487,914 1,259,990 227,924
Technology Upgrades 195,851 170,401 25,450
Other Expenses
Training 405,460 405,456 4
21,000,220 17,433,483 3,566,737
Office of Violence Prevention
Salary & Benefits
Non-Sworn 627,914 615,792 12,122
Other Services 252,850 169,557 83,293
Materials & Supplies
Other Supplies 11,289 9,487 1,802
Equipment
Office Equipment 20,897 20,928 (31)
Vehicles 23,747 23,746 1
Other Expenses 8,750 7,712 1,038
945,447 847,222 98,225
Basis Adjustment
Encumbrances (included in Final Budget) - 160,609 (160,609) Total Measure B Expenditures 21,945,667 18,441,314 3,504,353 Crime Prevention (Measure B) expenditures
as a % of annual Measure A revenues 73% 61%
Other City Services
Transfers to Mission Critical Projects
Street Resurfacing 273,801 273,801 -
Economic Dev. Implementation - ULI 76,166 31,600 44,566 Marketing/Communications Plan 100,000 74,800 25,200
General Fund Available Fund Balance 7,765,366 11,199,924 (3,434,558) Basis Adjustment
Encumbrances (included in Final Budget) - 27,166 (27,166) 8,215,333 11,607,291 (3,391,958)
Total Uses/Expenditures 30,161,000$ 30,048,605$ 112,395$ Measures A and B
Schedule of Sources and Uses
For Year Ended June 30, 2017
City of Stockton
174
ATTACHMENT F
Final Year End Variance with
Budget Actual Final Budget
Revenues
Measure A Transaction and Use Tax 31,020,000$ 31,735,727$ 715,727$ Total revenues 31,020,000 31,735,727 715,727 Uses/Expenditures
Police
Salary & benefits
Sworn 17,037,508 15,907,750 1,129, 758
Non-Sworn 3,385,429 2,879,875 505,554 Vacancy savings (1,635,312) - (1, 635,312) Other services 1,893,879 1,613,908 279,971 Materials & supplies
Fuel 108,308 226,062 (117, 754) Other supplies 418,364 213,637 204,727 Equipment
Radios 8,499 8,499 -
Vehicles 240,000 240,000 -
Technology upgrades 25,000 - 25,000 Other expenses
Training 512,305 510,977 1,328 Total police 21,993,980 21,600,708 393,272 Office of Violence Prevention
Salary & benefits
Non-sworn 654,522 564,609 89,913 Other services 360,407 275,911 84,496 Materials & supplies
Fuel 12,000 6,585 5,415 Other supplies 12,094 5,647 6,447 Equipment
Office equipment 18,624 10,494 8,130 Other expenses 15,750 10,363 5,387 Total Office of Violence Prevention 1,073,397 873,609 199,788 Basis Adjustment
Encumbrances (included in final budget) - 174,893 (174,893) Total Measure B Expenditures 23,067,377 22,649,210 418,167 Crime Prevention (Measure B) expenditures
as a % of annual Measure A revenues 74% 71% 58%
Other City Services
Prior Year - Mission Critical Projects
Economic development implementation - ULI 27,166 - 27,166 Marketing/communications plan 25,000 - 25,000 General Fund available fund balance 7,900,457 9,086,517 (1,186,060) Total adjustment 7,952,623 9,086,517 (1,133,894) Total Uses/Expenditures 31,020,000$ 31,735,727$ (715, 727)$ Measures A and B
Schedule of Sources and Uses
For Year Ended June 30, 2018
City of Stockton
See accompanying Notes to the Basic Financial Statements.
ATTACHMENT F
Final Year End Variance with
Budget Actual Final Budget
Revenues
Measure A Transaction and Use Tax 31,458,459$ 34,570,561$ 3,112,102$ Total revenues 31,458,459 34,570,561 3,112, 102 Uses/Expenditures
Police
Salary & benefits
Sworn 18,604,080 17,552,945 1,051, 135
Non-Sworn 3,207,584 3,085,164 122,420 Vacancy savings (1,046,464) - (1, 046,464) Other services 1,854,746 1,726,339 128,407 Materials & supplies
Fuel 140,434 312,503 (172, 069) Other supplies 348,629 142,380 206,249 Other expenses
Training 556,454 528,633 27,821 Total police 23,665,463 23,347,964 317,499 Office of Violence Prevention
Salary & benefits
Non-sworn 686,203 621,195 65,008 Other services 312,307 220,279 92,028 Materials & supplies
Fuel 6,731 5,620 1,111 Other supplies 28,600 5,060 23,540 Office equipment 5,441 3,467 1,974 Other expenses 20,250 19,741 509 Total Office of Violence Prevention 1,059,532 875,362 184,170 Basis Adjustment
Encumbrances (included in final budget) - 162,413 (162,413) Total Measure B Expenditures 24,724,995 24,385,739 339,256 Crime Prevention (Measure B) expenditures
as a % of annual Measure A revenues 79% 71%
Other City Services
Prior Year - Mission Critical Projects
Marketing/communications plan 14,325 - 14,325 General Fund available fund balance 6,719,139 10,184,822 (3,465,683) Total adjustment 6,733,464 10,184,822 (3,451,358) Total Uses/Expenditures 31,458,459$ 34,570,561$ (3, 112,102)$ Measures A and B
Schedule of Sources and Uses
For Year Ended June 30, 2019
City of Stockton
See accompanying Notes to the Basic Financial Statements.
ATTACHMENT F
Final Year End Variance with
Budget Actual Final Budget
Revenues
Measure A Transaction and Use Tax 32,508,651$ 34,329,713$ 1,821,062$ Total revenues 32,508,651 34,329,713 1,821, 062 Uses/Expenditures
Police
Salary & benefits
Sworn 20,525,184 18,424,245 2,100, 939
Non-Sworn 3,671,391 3,052,913 618,478 Vacancy savings (904,411) - (904, 411) Other services 2,345,422 2,239,423 105,999 Materials & supplies
Fuel 348,377 269,189 79,188
Other supplies 375,246 285,686 89,560 Other expenses
Training 658,347 654,522 3,825 Total police 27,019,556 24,925,978 2,093, 578 Office of Violence Prevention
Salary & benefits
Non-sworn 657,203 680,195 (22, 992) Other services 378,790 299,386 79,404 Materials & supplies
Fuel 5,752 3,190 2,562 Other supplies 10,620 15,781 (5, 161) Office equipment 3,979 1,379 2,600 Other expenses 11,572 11,572 - Total Office of Violence Prevention 1,067,916 1,011,503 56,413 Basis Adjustment
Encumbrances (included in final budget) - 136,347 (136,347) Total Measure B Expenditures 28,087,472 26,073,827 2,013, 645 Crime Prevention (Measure B) expenditures
as a % of annual Measure A revenues 86% 76%
Other City Services
Prior Year - Mission Critical Projects
Marketing/communications plan - - General Fund available fund balance 4,421,179 8,255,886 (3,834,707) Total adjustment 4,421,179 8,255,886 (3,834,707) Total Uses/Expenditures 32,508,651$ 34,329,713$ (1, 821,062)$ Measures A and B
Schedule of Sources and Uses
For Year Ended June 30, 2020
City of Stockton
ATTACHMENT F
Final Year End Variance with
Budget Actual Final Budget
Revenues
Measure A Transaction and Use Tax 28,472,000$ 40,810,516$ 12,338,516$ Total revenues 28,472,000 40,810,516 12,338, 516 Uses/Expenditures
Police
Salary & benefits
Sworn 21,413,141 19,316,382 2,096, 759
Non-Sworn 3,800,419 3,164,294 636,125 Vacancy savings (993,017) - (993, 017) Other services 2,920,889 2,675,205 245,684 Materials & supplies
Fuel 348,096 285,767 62,329
Other supplies 431,091 189,377 241,714 Other expenses
Training 620,018 617,265 2,753 Total police 28,540,637 26,248,290 2,292, 347 Office of Violence Prevention
Salary & benefits
Non-sworn 863,143 766,267 96,876 Other services 312,856 174,886 137,970 Materials & supplies
Fuel 6,231 6,243 (12) Other supplies 35,000 5,369 29,631 Office equipment 3,979 665 3,314 Other expenses 19,850 1,086 18,764 Total Office of Violence Prevention 1,241,059 954,516 286,543 Basis Adjustment
Encumbrances (included in final budget) - 171,220 (171,220) Total Measure B Expenditures 29,781,696 27,374,026 2,407, 670 Crime Prevention (Measure B) expenditures
as a % of annual Measure A revenues 105% 67%
Other City Services
Prior Year - Mission Critical Projects - - - General Fund available fund balance (1,309,696) 13,436,490 (14,746,186) Total adjustment (1,309,696) 13,436,490 (14,746,186) Total Uses/Expenditures 28,472,000$ 40,810,516$ (12, 338,516)$ Schedule of Sources and Uses
Measures A and B
For Year Ended June 30, 2021
City of Stockton
See accompanying Notes to the Basic Financial Statements.
ATTACHMENT F
Final Year End Variance with
Budget Actual Final Budget
Revenues
Measure A Transaction and Use Tax 36,132,000$ 45,412,129$ 9,280,129$ Total revenues 36,132,000 45,412,129 9,280,129 Uses/Expenditures
Police
Salary & benefits
Sworn 22,715,023 18,420,634 4,294,389
Non-Sworn 4,144,699 3,055,935 1,088,764 Vacancy savings (936,054) - (936,054) Other services 3,035,090 2,838,027 197,063 Materials & supplies
Fuel 281,265 359,709 (78,444) Other supplies 454,007 204,581 249,426 Other expenses
Technology upgrade - 9,515 (9,515) Training 595,000 520,287 74,713 Capital outlay 77,254 - 77,254 Total police 30,366,284 25,408,688 4,957,596 Office of Violence Prevention
Salary & benefits
Non-sworn 899,409 618,937 280,472 Other services 400,706 191,624 209,082 Materials & supplies
Fuel 3,182 3,933 (751) Other supplies 59,999 35,067 24,932 Office equipment 3,979 914 3,065 Other expenses 20,000 637 19,363 Total Office of Violence Prevention 1,387,275 851,112 536,163 Basis Adjustment
Encumbrances (included in final budget) - 344,973 (344,973)
Total Measure B Expenditures 31,753,559 26,604,773 5,148,786 Crime Prevention (Measure B) expenditures
as a % of annual Measure A revenues 88% 59%
Other City Services
General Fund available fund balance 4,378,441 18,807,356 (14,428,915) Total adjustment 4,378,441 18,807,356 (14,428,915) Total Uses/Expenditures 36,132,000$ 45,412,129 $ (9,280,129) $ Schedule of Sources and Uses
Measures A and B
For Year Ended June 30, 2022
City of Stockton
150
ATTACHMENT F
ATTACHMENT F