2022-23 Auditor General Schedules
Extracted text (via pymupdf)
60811 characters
Fiscal
Year
General
Fund
Special
Revenue
Funds
Debt
Service
Funds
Capital
Projects
Funds
Enterprise
Funds
Available
Internal
Service
Funds
Total All Funds
2022
Adopted/Adjusted Budgeted Expenditures/Expenses*
E
1
314,710,942
88,222,344
40,479,500
297,083,631
274,225,332
43,352,589
1,058,074,338
2022
Actual Expenditures/Expenses**
E
2
261,585,548
51,231,282
39,342,645
55,493,813
140,855,253
38,048,869
586,557,410
2023
Beginning Fund Balance/(Deficit) or Net Position/(Deficit) at
July 1***
3
162,093,344
45,754,856
1,952,701
208,904,393
152,765,800
5,737,541
577,208,635
2023
Primary Property Tax Levy
B
4
8,507,940
8,507,940
2023
Secondary Property Tax Levy
B
5
31,822,477
31,822,477
2023
Estimated Revenues Other than Property Taxes
C
6
294,520,338
117,313,633
731,249
79,729,722
211,064,342
31,760,200
735,119,484
2023
Other Financing Sources
D
7
-
-
-
-
-
-
-
2023
Other Financing (Uses)
D
8
-
-
-
-
-
-
-
2023
Interfund Transfers In
D
9
9,114,624
285,000
6,500,000
87,235,926
20,674,582
12,713,569
136,523,701
2023
Interfund Transfers (Out)
D
10
102,319,135
2,236,438
-
18,400,714
13,544,861
22,553
136,523,701
2023
Line 11: Reduction for Fund Balance Reserved for Future
Budget Year Expenditures
Maintained for Future Debt Retirement
-
Maintained for Future Capital Projects
-
Maintained for Future Financial Stability
-
2023
Total Financial Resources Available
12
371,917,111
161,117,051
41,006,427
357,469,327
370,959,863
50,188,757
1,352,658,536
2023
Budgeted Expenditures/Expenses
E
13
371,917,111
161,117,051
41,006,427
357,469,327
370,959,863
50,188,757
1,352,658,536
EXPENDITURE LIMITATION COMPARISON
2022
2023
1. Budgeted expenditures/expenses
1,058,074,338
$
1,352,658,536
$
2. Add/subtract: estimated net reconciling items
3. Budgeted expenditures/expenses adjusted for reconciling items
1,058,074,338
1,352,658,536
4. Less: estimated exclusions
5. Amount subject to the expenditure limitation
1,058,074,338
$
1,352,658,536
$
6. EEC expenditure limitation
1,058,074,338
$
1,352,658,536
$
*
**
***
Includes expenditure/expense adjustments approved in the current year from Schedule E.
Includes actual amounts as of the date the proposed budget was prepared, adjusted for estimated activity for the remainder of the fiscal year.
Amounts on this line represent fund balance/(deficit) or net position/(deficit) amounts except for nonspendable amounts (e.g., prepaids and inventories) or amounts legally or contractually required to be
maintained intact (e.g., principal of a permanent fund).
SCHEDULE A
CITY OF CHANDLER
Summary Schedule of Estimated Revenues and Expenditures/Expenses
Fiscal Year 2022-23
S
c
h
FUNDS
11
CITY OF CHANDLER, ARIZONA
Summary of Tax Levy and Tax Rate Information
Fiscal Year 2022-23
2021-22
2022-23
Fiscal Year
Fiscal Year
1.
Maximum allowable primary property tax levy.
A.R.S. §42-17051(A).
20,112,536
$
21,253,844
$
2.
Amount received from primary property taxation in the
current year in excess of the sum of that year's
maximum allowable primary property tax levy.
A.R.S. §42-17102(A)(18).
-
$
3.
Property tax levy amounts
A. Primary property taxes
8,298,220
$
8,507,940
$
Property tax judgment
-
-
B. Secondary property taxes
29,758,525
31,822,477
Property tax judgment
-
-
C. Total property tax levy amounts (1)
38,056,745
$
40,330,417
$
4.
Property taxes collected*
A. Primary property taxes
(1) Current year's levy
8,298,372
$
(2) Prior years’ levies (2)
50,000
(3) Total primary property taxes
8,348,372
$
B. Secondary property taxes
(1) Current year's levy
29,759,070
$
(2) Prior years’ levies (2)
220,000
(3) Total secondary property taxes
29,979,070
$
C. Total property taxes collected
38,327,442
$
5.
Property tax rates
A. City/Town tax rate
(1) Primary property tax rate
0.2426
0.2326
Property tax judgment
-
-
(2) Secondary property tax rate
0.8700
0.8700
Property tax judgment
-
-
(3) Total city/town tax rate
1.1126
1.1026
B. Special assessment district tax rates
Secondary property tax rates - As of the date the proposed budget was prepared, the
city/town was operating one special assessment district for which secondary property
taxes are levied. For information pertaining to these special assessment districts and
their tax rates, please contact the city/town.
(1) The estimated Salt River Project voluntary contributions in lieu of taxes has been moved to Schedule C under the
General Fund in the amount of $104,980 in 2021-22 and $105,138 in 2022-23 for primary property tax and under the
Debt Service Funds in the amount of $376,475 in 2021-22 and $393,249 in 2022-23 for the secondary property tax.
(2) Amount budgeted for Prior Year Primary and Secondary Levies for 2021-22 ($225,000) and 2022-23 ($250,000) are
presented under Schedule C, Prior Year Property Tax Collections. Estimated revenue collected for prior year levies
is presented above under Section 4, lines A (2) & B (2).
* Includes actual property taxes collected as of the date the proposed budget was prepared,
plus estimated property tax collections for the remainder of the fiscal year.
SCHEDULE B
CITY OF CHANDLER, ARIZONA
Summary by Fund Type of Revenues Other Than Property Taxes
Fiscal Year 2022-23
Estimated
Actual
Estimated
Revenues
Revenues*
Revenues
Source of Revenues
2021-22
2021-22
2022-23
General Fund
Local Taxes
Franchise Fees
2,980,000
$
3,451,000
$
3,451,000
$
Property Taxes (prior year's levies)
50,000
50,000
50,000
Transaction Privilege License Taxes/Fees
148,278,200
164,378,400
174,858,400
Licenses and Permits
Building Division Permits
6,540,000
8,565,000
7,665,000
Miscellaneous Licenses
921,000
905,500
915,500
Intergovernmental
State
Smart and Safe Shared Revenue
-
612,000
605,000
State Shared Sales Taxes
28,790,000
31,070,000
32,000,000
Urban Revenue Sharing
33,500,000
33,500,000
42,720,000
County
Auto Lieu Taxes
12,100,000
12,100,000
13,500,000
Charges for Services
Engineering Fees
1,369,100
1,469,100
1,469,100
Library Revenues
301,200
323,000
339,000
Parks and Recreation Fees
2,443,700
3,082,400
3,220,100
Planning Fees
265,500
299,500
299,500
Public Safety Miscellaneous Revenue
5,222,717
5,095,700
5,558,700
Fines and Forfeits
Court Fines
3,409,300
3,148,300
3,273,600
Library Fines
35,000
65,000
18,000
Miscellaneous Violation Fines
137,000
138,700
122,200
Interest on Investments
Interest on Investments
2,316,000
1,819,300
2,317,000
Contributions
Voluntary Contributions
104,980
104,828
105,138
Miscellaneous
Leases
144,000
144,000
144,000
Other Receipts
1,029,350
1,813,625
1,354,400
Property Rentals
116,700
147,900
134,700
Sale of Fixed Assets
490,000
787,000
400,000
Total General Fund
250,543,747
$
273,070,253
$
294,520,338
$
Special Revenue Funds
Forfeiture Fund
Police Forfeiture Reimbursement
750,000
$
342,400
$
750,000
$
Total Forfeiture Fund
750,000
$
342,400
$
750,000
$
Proposition 400 Fund
Regional Transportation Sales Taxes
200,000
$
1,887,411
$
302,000
$
Interest on Investments
-
2,000
-
Total Proposition 400 Fund
200,000
$
1,889,411
$
302,000
$
Highway User Revenue Fund
Highway Users Taxes
17,373,409
$
18,576,629
$
17,744,011
$
Interest on Investments
415,000
327,400
363,000
Other Receipts
-
40,000
-
Total Highway User Revenue Fund
17,788,409
$
18,944,029
$
18,107,011
$
Local Transportation Assistance Fund
HB2565 RPTA Grant Funds
673,600
$
673,600
$
673,600
$
Bus Shelter Revenue
153,600
166,000
159,600
Interest on Investments
60,000
49,800
55,000
Other Receipts
-
85,000
-
Total Local Transportation Assistance Fund
887,200
$
974,400
$
888,200
$
Grant Funds
Grants-In-Aid
57,650,000
$
3,913,646
$
59,484,522
$
Community Development Block Grant
2,065,950
3,897,305
5,680,000
Housing Urban Development
11,917,000
16,827,610
28,770,000
Public Housing Authority
2,671,000
2,707,909
3,075,000
Interest on Investments
289,000
413,600
91,000
Total Grant Funds
74,592,950
$
27,760,070
$
97,100,522
$
*Includes actual revenues recognized on the modified accrual or accrual basis as of the date the
proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year.
SCHEDULE C (1 OF 2)
CITY OF CHANDLER, ARIZONA
Summary by Fund Type of Revenues Other Than Property Taxes
Fiscal Year 2022-23
Estimated
Actual
Estimated
Revenues
Revenues*
Revenues
Source of Revenues
2021-22
2021-22
2022-23
Special Revenue Funds - continued
Expendable Trust Funds
Library Trust
80,000
$
80,000
$
80,000
$
Museum Trust
-
1,571
-
Parks and Recreation Trust
85,900
61,950
80,900
Interest on Investments
6,000
4,300
5,000
Total Expendable Trust Funds
171,900
$
147,821
$
165,900
$
Total Special Revenue Funds
94,390,459
$
50,058,131
$
117,313,633
$
Debt Service Funds
Property Taxes (prior year's levies)
175,000
$
220,000
$
200,000
$
Voluntary Contributions
376,475
375,930
393,249
Interest on Investments
169,500
99,700
138,000
Total Debt Service Funds
720,975
$
695,630
$
731,249
$
Capital Projects Funds
System Development Fees
Arterial Streets
4,440,700
$
3,900,000
$
6,000,000
$
Library
100,000
134,000
115,000
Parks
2,077,200
1,922,000
2,879,000
Public Building
184,300
270,000
277,000
Public Safety - Fire
384,000
538,000
553,000
Public Safety - Police
224,000
310,000
312,000
Wastewater
8,516,000
11,291,300
10,100,300
Water
6,180,300
6,400,300
6,300,000
Capital Grants
14,700,224
13,443,581
47,427,475
Capital Replacement
386,060
386,060
423,098
Interest on Investments
2,310,800
1,604,000
1,890,500
Municipal Arts Contributions
115,400
117,400
359,000
Other Receipts
-
493,230
-
Sale of Fixed Assets
300,000
214,559
300,000
Vehicle Replacement
2,654,229
2,654,230
2,793,349
Total Capital Project Funds
42,573,213
$
43,678,660
$
79,729,722
$
Enterprise Funds
Airport Services
887,900
$
883,892
$
881,000
$
Reclaimed Water Services
1,800,000
1,422,564
1,536,370
Solid Waste Services
17,732,000
17,548,194
18,465,964
Wastewater Services
63,967,371
61,923,515
131,692,076
Water Services
55,516,831
57,196,494
55,961,932
Interest on Investments
2,755,000
2,185,700
2,527,000
Total Enterprise Funds
142,659,102
$
141,160,359
$
211,064,342
$
Internal Service Funds
Self-Insurance Premiums
29,838,700
$
28,856,700
$
31,166,200
$
Other Receipts
210,000
327,200
210,000
Interest on Investments
724,000
384,900
384,000
Total Internal Service Funds
30,772,700
$
29,568,800
$
31,760,200
$
Total All Funds
561,660,196
$
538,231,833
$
735,119,484
$
*Includes actual revenues recognized on the modified accrual or accrual basis as of the date the
proposed budget was prepared, plus estimated revenues for the remainder of the fiscal year.
SCHEDULE C (2 OF 2)
CITY OF CHANDLER, ARIZONA
Summary by Fund Type of Other Financing Sources/<Uses> and Interfund Transfers
Fiscal Year 2022-23
Interfund
Other Financing
Transfers
2022-23
2022-23
Fund
Sources
<Uses>
In
<Out>
General Fund
General Fund
-
$
-
$
9,114,624
$
102,319,135
$
Total General Fund
-
$
-
$
9,114,624
$
102,319,135
$
Special Revenue Funds
Proposition 400
-
$
-
$
-
$
2,111,150
$
Highway User Revenue
-
-
-
123,552
Local Transportation Assistance
-
-
-
1,736
Housing
-
-
285,000
-
Total Special Revenue Funds
-
$
-
$
285,000
$
2,236,438
$
Debt Service Funds
General Obligation Debt Service
-
$
-
$
6,500,000
$
-
$
Total Debt Service Funds
-
$
-
$
6,500,000
$
-
$
Capital Projects Funds
General Government Capital Projects
-
$
-
$
80,385,810
$
-
$
Arterial Street Impact Fees
-
-
1,398,330
4,500,000
Computer Replacement
-
-
4,238,966
-
Park Impact Fees
-
-
-
2,000,000
Public Building Impact Fees
-
-
-
350,000
Public Safety Impact Fees - Fire
-
-
-
400,000
Public Safety Impact Fees - Police
-
-
-
500,000
Reclaimed Water Bonds
-
-
-
500,000
Street Bonds
-
-
712,820
-
Wastewater System Development Fees
-
-
500,000
10,000,000
Water System Development Fees
-
-
-
150,714
Total Capital Projects Funds
-
$
-
$
87,235,926
$
18,400,714
$
Enterprise Funds
Airport Operating
-
$
-
$
5,374,576
$
113,017
$
Reclaimed Water Operating
-
-
2,620,500
2,654,045
Solid Waste Operating
-
-
-
1,056,898
Wastewater Operating
-
-
11,139,992
3,829,671
Water Operating
-
-
1,539,514
5,258,622
Wastewater Industrial Process Treatment
-
-
-
632,608
Total Enterprise Funds
-
$
-
$
20,674,582
$
13,544,861
$
Internal Service Funds
Self-Insurance Funds
-
$
-
$
12,713,569
$
22,553
$
Total Internal Service Funds
-
$
-
$
12,713,569
$
22,553
$
Total All Funds
-
$
-
$
136,523,701
$
136,523,701
$
SCHEDULE D
CITY OF CHANDLER, ARIZONA
Summary by Department of Expenditures/Expenses Within Each Fund Type
Fiscal Year 2022-23
Adopted
Expenditure/
Budgeted
Expense
Actual
Budgeted
Expenditures/
Adjustments
Expenditures/
Expenditures/
Expenses
Approved
Expenses
Expenses
Fund/Department
2021-22
2021-22
2021-22
2022-23
General Fund
City Clerk
1,197,666
$
128,504
$
1,173,457
$
1,033,622
$
City Magistrate
4,996,699
112,354
4,164,563
5,025,617
City Manager
17,706,595
644,431
17,392,953
18,646,048
Communications and Public Affairs
2,888,741
474,316
3,319,186
2,682,072
Community Services
27,604,362
2,191,638
28,735,753
29,928,146
Cultural Development
3,779,431
217,099
4,009,595
4,001,437
Development Services
9,465,361
457,840
9,503,444
10,008,386
Information Technology
12,631,421
2,124,318
14,118,842
16,084,234
Law
3,915,729
122,644
4,117,165
4,236,416
Management Services
8,211,540
(485,595)
7,310,900
7,486,762
Mayor and Council
1,041,711
24,952
1,020,199
1,184,388
Neighborhood Resources
4,036,275
5,868,425
4,269,873
4,114,985
Non-Departmental
33,652,628
(2,467,209)
24,935,323
79,383,795
Public Safety - Fire
38,237,224
2,443,275
41,022,892
39,238,155
Public Safety - Police
79,309,326
4,045,104
83,736,262
83,324,801
Public Works & Utilities
10,834,092
2,727,652
12,755,141
10,314,947
Contingency/Reserves
47,176,300
(10,603,907)
-
55,223,300
Total General Fund
306,685,101
$
8,025,841
$
261,585,548
$
371,917,111
$
Special Revenue Funds
Police Forfeiture Fund
Public Safety - Police
750,000
$
-
$
285,000
$
750,000
$
Contingency/Reserves
22,000
(22,000)
-
22,000
Highway Users Revenue Fund
Development Services
721,506
12,712
647,574
737,115
Public Works & Utilities
21,427,934
(4,731,805)
11,208,955
27,005,774
Non-Departmental
181,400
(93,600)
-
318,800
Contingency/Reserves
1,532,000
1,905,551
-
1,435,000
Local Transportation Assistance Fund
City Manager
2,064,697
(12,509)
481,096
2,274,806
Public Works & Utilities
122,498
-
-
-
Non-Departmental
200
-
-
300
Contingency/Reserves
54,000
(17,456)
-
59,000
Grants In Aid Fund
City Magistrate
-
77,664
77,664
-
City Manager
-
3,194,773
264,501
-
Community Services
-
485,470
364,293
174,750
Cultural Development
-
19,600
19,600
-
Development Services
-
325,417
325,415
-
Information Technology
-
6,493,164
6,493,164
-
Law
-
9,522
9,522
-
Management Services
-
228,086
228,085
-
Mayor & Council
-
39,301
39,300
-
Neighborhood Resources
-
14,260,702
10,245,328
37,400
Public Safety - Fire
-
367,343
270,580
180,816
Public Safety - Police
56,464
7,156,073
1,871,158
59,835
Public Works & Utilities
-
302,978
302,975
-
Non-Departmental
-
149,560
7,495
-
Contingency/Reserves
74,762,956
(67,697,963)
-
89,649,051
Community Development Block Grant Fund
Neighborhood Resources
1,975,325
1,921,980
3,897,305
4,510,457
Contingency/Reserves
308,000
(308,000)
-
1,169,543
Housing and Urban Development Fund
Neighborhood Resources
17,588,313
2,100,638
14,009,516
29,354,946
Non-Departmental
36,200
(36,200)
-
102,900
Contingency/Reserves
361,081
(140,977)
-
3,010,510
Expendable Trust Funds
Community Services
209,536
-
160,016
201,438
Cultural Development
46,210
-
22,740
55,210
Non-Departmental
-
-
-
400
Contingency/Reserves
12,000
-
-
7,000
Total Special Revenue Funds
122,232,320
$
(34,009,976)
$
51,231,282
$
161,117,051
$
* Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date
the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year.
SCHEDULE E (1 OF 2)
CITY OF CHANDLER, ARIZONA
Summary by Department of Expenditures/Expenses Within Each Fund Type
Fiscal Year 2022-23
Adopted
Expenditure/
Budgeted
Expense
Actual
Budgeted
Expenditures/
Adjustments
Expenditures/
Expenditures/
Expenses
Approved
Expenses
Expenses
Fund/Department
2021-22
2021-22
2021-22
2022-23
Debt Service Funds
General Obligation Debt Service
40,144,916
$
-
$
39,342,645
$
40,656,427
$
Contingency/Reserves
334,584
-
-
350,000
Total Debt Service Funds
40,479,500
$
-
$
39,342,645
$
41,006,427
$
Capital Projects Funds
City Manager
13,726,373
$
740,983
$
2,355,259
$
24,779,958
$
Communications and Public Affairs
-
-
-
136,560
Community Services
25,165,221
2,818,654
6,010,117
54,923,304
Cultural Development
2,186,497
(2,756)
716,897
4,031,203
Development Services
4,254,992
4,039,574
42,003
8,866,024
Information Technology
7,711,619
(625,977)
1,406,728
12,694,632
Management Services
58,800
-
-
-
Neighborhood Resources
-
2,860,000
153,011
2,703,659
Public Safety - Fire
8,525,075
(28,796)
160,210
13,225,069
Public Safety - Police
9,873,956
(557,807)
2,475,530
10,998,591
Public Works & Utilities
180,277,256
6,931,351
39,186,727
201,158,532
Non-Departmental
11,213,817
8,534,062
2,987,331
11,200,115
Contingency/Reserves
5,179,007
4,201,730
-
12,751,680
Total Capital Projects Funds
268,172,613
$
28,911,018
$
55,493,813
$
357,469,327
$
Enterprise Funds
City Manager
3,968,489
$
(5,482)
$
1,662,968
$
5,895,710
$
Information Technology
1,445,391
-
-
1,445,391
Public Works & Utilities
171,685,780
29,263,101
106,222,003
313,993,276
Non-Departmental
1,712,700
(333,580)
659,835
1,974,500
Contingency/Reserves
65,204,625
(32,324,701)
-
15,989,625
Debt Service
33,609,009
-
32,310,447
31,661,361
Total Enterprise Funds
277,625,994
$
(3,400,662)
$
140,855,253
$
370,959,863
$
Internal Service Funds
Self-Insurance
City Manager
1,578,610
$
534,779
$
1,939,632
$
1,948,888
$
Law
6,066,777
103,156
4,515,385
7,580,228
Management Services
1,239,603
68,914
1,009,623
1,239,092
Non-Departmental
30,561,900
2,435,599
30,584,229
33,795,629
Contingency/Reserves
3,431,920
(2,668,669)
-
5,624,920
Total Internal Service Funds
42,878,810
$
473,779
$
38,048,869
$
50,188,757
$
Total All Funds
1,058,074,338
$
-
$
586,557,410
$
1,352,658,536
$
* Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date
the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year.
SCHEDULE E (2 OF 2)
Department/Fund
Adopted
Budgeted
Expenditures/
Expenses
2021-22
Expenditure/
Expense
Adjustments
Approved
2021-22
Actual Expenditures/
Expenses *
2021-22
Budgeted
Expenditures/
Expenses
2022-23
City Clerk
General Fund
1,197,666
$
128,504
$
1,173,457
$
1,033,622
$
Department Total
1,197,666
$
128,504
$
1,173,457
$
1,033,622
$
City Magistrate
General Fund
4,996,699
$
112,354
$
4,164,563
$
5,025,617
$
Special Revenue Fund - Grant
-
77,664
77,664
-
Department Total
4,996,699
$
190,018
$
4,242,227
$
5,025,617
$
City Manager
General Fund
17,706,595
$
644,431
$
17,392,953
$
18,646,048
$
Special Revenue Fund - LTAF
2,064,697
(12,509)
481,096
2,274,806
Special Revenue Fund - Grants
-
3,194,773
264,501
-
Capital Projects Fund - Gen Gov't Capital Project
8,889,998
(713,805)
1,310,534
13,163,161
Capital Projects Fund - Fleet
168,400
3,670
-
-
Capital Projects Fund - Grants
4,592,835
1,451,118
1,044,725
11,293,657
Capital Projects Fund - Bonds
75,140
-
-
323,140
Enterprise Fund - Water
14,000
-
11,108
2,892
Enterprise Fund - Airport
3,954,489
(5,482)
1,651,860
5,892,818
Internal Service Fund - Self Insurance
1,578,610
534,779
1,939,632
1,948,888
Department Total
39,044,764
$
5,096,975
$
24,096,409
$
53,545,410
$
Communications and Public Affairs
General Fund
2,888,741
$
474,316
$
3,319,186
$
2,682,072
$
Capital Projects Fund - Equipment
-
-
-
136,560
Department Total
2,888,741
$
474,316
$
3,319,186
$
2,818,632
$
Community Services
General Fund
27,604,362
$
2,191,638
$
28,735,753
$
29,928,146
$
Special Revenue Fund - Grants
-
485,470
364,293
174,750
Special Revenue Fund - Trust
209,536
-
160,016
201,438
Capital Projects Fund - Gen Gov't Capital Project
5,414,660
(378,432)
1,923,048
9,456,523
Capital Projects Fund - Fleet
248,600
-
-
37,200
Capital Projects Fund - Grants
1,804,685
4,803,946
-
10,578,776
Capital Projects Fund - Bonds
11,280,619
(924,501)
2,100,590
30,919,517
Capital Projects Fund - Impact Fees
6,416,657
(682,359)
1,986,479
3,931,288
Department Total
52,979,119
$
5,495,762
$
35,270,179
$
85,227,638
$
Cultural Development
General Fund
3,779,431
$
217,099
$
4,009,595
$
4,001,437
$
Special Revenue Fund - Grants
-
19,600
19,600
-
Special Revenue Fund - Trust
46,210
-
22,740
55,210
Capital Projects Fund - Gen Gov't Capital Project
1,337,385
-
527,332
1,891,792
Capital Projects Fund - Grants
196,356
(24,000)
87,491
371,287
Capital Projects Fund - Municipal Art
650,000
-
80,000
380,000
Capital Projects Fund - Bonds
2,756
21,244
22,074
1,388,124
Department Total
6,012,138
$
233,943
$
4,768,832
$
8,087,850
$
Development Services
General Fund
9,465,361
$
457,840
$
9,503,444
$
10,008,386
$
Special Revenue Fund - HURF
721,506
12,712
647,574
737,115
Special Revenue Fund - Grants
-
325,417
325,415
-
Capital Projects Fund - Gen Gov't Capital Project
1,335,092
7,324
5,384
2,180,811
Capital Projects Fund - Fleet
201,700
32,250
31,794
-
Capital Projects Fund - Grants
715,737
4,000,000
-
4,715,737
Capital Projects Fund - Bonds
2,002,463
-
4,825
1,969,476
Department Total
14,441,859
$
4,835,543
$
10,518,436
$
19,611,525
$
* Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date
the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year.
CITY OF CHANDLER, ARIZONA
Summary by Department of Expenditures/Expenses
Fiscal Year 2022-23
SCHEDULE F (1 OF 3)
Department/Fund
Adopted
Budgeted
Expenditures/
Expenses
2021-22
Expenditure/
Expense
Adjustments
Approved
2021-22
Actual Expenditures/
Expenses *
2021-22
Budgeted
Expenditures/
Expenses
2022-23
Information Technology
General Fund
12,631,421
$
2,124,318
$
14,118,842
$
16,084,234
$
Special Revenue Fund - Grants
-
6,493,164
6,493,164
-
Capital Projects Fund - Gen Gov't Capital Project
7,683,619
(625,977)
1,406,728
12,694,632
Capital Projects Fund - Fleet
28,000
-
-
-
Enterprise Fund - Water
684,694
-
-
684,694
Enterprise Fund - Wastewater
523,915
-
-
523,915
Enterprise Fund - Solid Waste
225,266
-
-
225,266
Enterprise Fund - Airport
11,516
-
-
11,516
Department Total
21,788,431
$
7,991,505
$
22,018,734
$
30,224,257
$
Law
General Fund
3,915,729
$
122,644
$
4,117,165
$
4,236,416
$
Special Revenue Fund - Grants
-
9,522
9,522
-
Internal Service Fund - Self Insurance
6,066,777
103,156
4,515,385
7,580,228
Department Total
9,982,506
$
235,322
$
8,642,072
$
11,816,644
$
Management Services
General Fund
8,211,540
$
(485,595)
$
7,310,900
$
7,486,762
$
Special Revenue Fund - Grants
-
228,086
228,085
-
Capital Projects Fund - Fleet
58,800
-
-
-
Internal Service Fund - Self Insurance
93,652
1,539
87,200
94,514
Internal Service Fund - Uninsured Liability
1,145,951
67,375
922,423
1,144,578
Department Total
9,509,943
$
(188,595)
$
8,548,608
$
8,725,854
$
Mayor and Council
General Fund
1,041,711
$
24,952
$
1,020,199
$
1,184,388
$
Special Revenue Fund - Grants
-
39,301
39,300
-
Department Total
1,041,711
$
64,253
$
1,059,499
$
1,184,388
$
Neighborhood Resources
General Fund
4,036,275
$
5,868,425
$
4,269,873
$
4,114,985
$
Special Revenue Fund - Grants
19,563,638
18,283,320
28,152,149
33,902,803
Capital Projects Fund - Grants
-
2,860,000
153,011
2,703,659
Department Total
23,599,913
$
27,011,745
$
32,575,033
$
40,721,447
$
Non-Departmental - Includes Contingencies
General Fund
80,828,928
$
(13,071,116)
$
24,935,323
$
134,607,095
$
Special Revenue Fund - Police Forfeiture
22,000
(22,000)
-
22,000
Special Revenue Fund - HURF
1,713,400
1,811,951
-
1,753,800
Special Revenue Fund - LTAF
54,200
(17,456)
-
59,300
Special Revenue Fund - Grants
75,468,237
(68,033,580)
7,495
93,932,004
Special Revenue Fund - Trust
12,000
-
-
7,400
Debt Service - General Obligation
334,584
-
-
350,000
Capital Projects Fund - Gen Gov't Capital Project
8,693,082
4,732,176
337,867
9,008,326
Capital Projects Fund - Equip/Tech/Fleet
5,072,712
(509,494)
2,507,064
7,414,289
Capital Projects Fund - Grants
-
1,029,243
-
-
Capital Projects Fund - Municipal Art
51,000
(51,000)
-
20,000
Capital Projects Fund - Bonds
33,599
5,474,339
-
300
Capital Projects Fund - Impact/System Dev Fees
2,542,431
2,060,528
142,400
7,508,880
Enterprise Fund - Water
11,688,600
(7,341,120)
248,296
9,474,700
Enterprise Fund - Reclaimed Water
229,400
(143,795)
9,141
663,700
Enterprise Fund - Wastewater
52,534,800
(24,506,399)
251,266
5,578,300
Enterprise Fund - Solid Waste
2,243,800
(750,613)
151,132
2,009,200
Enterprise Fund - Airport
220,725
83,646
-
238,225
Internal Service Fund - Self Insurance
33,394,400
353,518
30,584,229
38,798,529
Internal Service Fund - Uninsured Liability
599,420
(586,588)
-
622,020
Department Total
275,737,318
$
(99,487,760)
$
59,174,213
$
312,068,068
$
* Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date
the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year.
Fiscal Year 2022-23
SCHEDULE F (2 OF 3)
Summary by Department of Expenditures/Expenses
CITY OF CHANDLER, ARIZONA
Department/Fund
Adopted
Budgeted
Expenditures/
Expenses
2021-22
Expenditure/
Expense
Adjustments
Approved
2021-22
Actual Expenditures/
Expenses *
2021-22
Budgeted
Expenditures/
Expenses
2022-23
Public Safety - Fire
General Fund
38,237,224
$
2,443,275
$
41,022,892
$
39,238,155
$
Special Revenue Fund - Grants
-
367,343
270,580
180,816
Capital Projects Fund - Gen Gov't Capital Project
1,828,075
(28,796)
91,620
2,604,659
Capital Projects Fund - Bonds
6,697,000
-
68,590
10,620,410
Department Total
46,762,299
$
2,781,822
$
41,453,682
$
52,644,040
$
Public Safety - Police
General Fund
79,309,326
$
4,045,104
$
83,736,262
$
83,324,801
$
Special Revenue Fund - Police Forfeiture
750,000
-
285,000
750,000
Special Revenue Fund - Grants
56,464
7,156,073
1,871,158
59,835
Capital Projects Fund - Gen Gov't Capital Project
7,136,438
(1,141,378)
1,874,159
7,516,901
Capital Projects Fund - Equipment/Fleet
1,668,683
601,611
600,862
2,141,404
Capital Projects Fund - Bonds
1,068,835
(18,040)
509
1,340,286
Department Total
89,989,746
$
10,643,370
$
88,367,950
$
95,133,227
$
Public Works & Utilities
General Fund
10,834,092
$
2,727,652
$
12,755,141
$
10,314,947
$
Special Revenue Fund - HURF
21,427,934
(4,731,805)
11,208,955
27,005,774
Special Revenue Fund - LTAF
122,498
-
-
-
Special Revenue Fund - Grants
-
302,978
302,975
-
Capital Projects Fund - Gen Gov't Capital Project
12,684,266
7,410,169
2,362,739
21,869,005
Capital Projects Fund - Fleet
331,500
20,820
6,059
460,100
Capital Projects Fund - Grants
37,336,626
8,257,785
9,570,257
49,923,328
Capital Projects Fund - Bonds
89,816,001
(4,227,499)
22,872,556
76,939,245
Capital Projects Fund - Impact/System Dev Fees
40,108,863
(4,529,924)
4,375,116
51,966,854
Enterprise Fund - Water
43,843,428
7,067,512
39,491,086
58,039,204
Enterprise Fund - Reclaimed Water
1,536,178
112,948
1,799,810
1,510,583
Enterprise Fund - Wastewater
109,603,437
21,917,111
48,925,624
235,913,227
Enterprise Fund - Solid Waste
16,702,737
165,530
16,005,483
18,530,262
Department Total
384,347,560
$
34,493,277
$
169,675,801
$
552,472,529
$
Debt Service
Debt Service - General Obligation
40,144,916
$
-
$
39,342,645
$
40,656,427
$
Enterprise Fund - Water
14,663,089
-
13,865,882
13,685,273
Enterprise Fund - Wastewater
18,945,920
-
18,444,565
17,976,088
Department Total
73,753,925
$
-
$
71,653,092
$
72,317,788
$
Total All Departments
1,058,074,338
$
-
$
586,557,410
$
1,352,658,536
$
* Includes actual expenditures/expenses recognized on the modified accrual or accrual basis as of the date
the proposed budget was prepared, plus estimated expenditures/expenses for the remainder of the fiscal year.
CITY OF CHANDLER, ARIZONA
Summary by Department of Expenditures/Expenses
Fiscal Year 2022-23
SCHEDULE F (3 OF 3)
Full-Time
Equivalent (FTE)
Employee Salaries
and Hourly Costs
Retirement Costs
Healthcare Costs
Other Benefit Costs
Total Estimated
Personnel
Compensation
2023
2023
2023
2023
2023
2023
General Fund
1,405.679
$
140,249,000
$
79,491,452
$
18,418,927
$
13,780,880
$
251,940,259
Special Revenue Funds
Highway Users Revenue
48.250
$
3,330,925
412,825
592,468
364,982
$
4,701,200
Grants
0.729
149,562
43,463
33,568
14,058
240,651
Community Development Block Grant
6.292
363,598
47,394
48,379
36,386
495,757
PHA Family Sites
6.650
441,243
51,278
85,375
41,805
619,701
PHA Elderly & Scattered Sites
3.150
240,032
26,372
43,502
21,363
331,269
PHA Management
5.500
517,170
62,632
60,471
44,514
684,787
PHA Family Self Sufficiency
2.000
137,544
17,086
16,497
11,319
182,446
PHA Section 8
3.700
263,164
30,605
43,872
22,830
360,471
PHA Capital Fund Program
-
21,877
826
1,034
1,785
25,522
Museum Trust
-
1,136
42
52
80
1,310
Parks and Recreation Trust
-
4,507
168
210
453
5,338
Total Special Revenue Funds
76.271
$
5,470,758
$
692,691
$
925,428
$
559,575
$
7,648,452
Capital Projects Funds
In-House Capital
18.800
$
1,764,390
233,398
228,419
171,749
$
2,397,956
Total Capital Projects Funds
18.800
$
1,764,390
$
233,398
$
228,419
$
171,749
$
2,397,956
Enterprise Funds
Water Operating
95.560
$
7,694,738
952,537
1,276,887
784,044
$
10,708,206
Reclaimed Water Operating
4.190
321,612
40,096
39,448
34,467
435,623
Wastewater Operating
62.350
4,932,960
607,859
793,762
501,953
6,836,534
WW Industrial Process Treatment
17.000
1,365,749
165,657
181,192
143,256
1,855,854
Solid Waste Operating
22.200
1,408,808
173,413
272,983
139,238
1,994,442
Airport Operating
7.000
602,778
74,754
51,725
62,734
791,991
Total Enterprise Funds
208.300
$
16,326,645
$
2,014,316
$
2,615,997
$
1,665,692
$
22,622,650
Internal Service Funds
Workers' Compensation Self Insurance
4.550
$
381,219
47,395
66,369
30,990
$
525,973
Insured Liaibilty Self Insurance
4.000
385,188
47,982
35,743
30,821
499,734
Uninsured Liaibility Self Insurance
5.000
437,151
54,416
55,873
38,812
586,252
Short Term Disability Self Insurance
0.400
34,562
4,301
3,866
227,788
270,517
Medical Self Insurance
4.000
376,723
46,650
40,697
323,076
787,146
Total Internal Service Funds
17.950
$
1,614,843
$
200,744
$
202,548
$
651,487
$
2,669,622
Total All Funds
1,727.000
$
165,425,636
$
82,632,601
$
22,391,319
$
16,829,383
$
287,278,939
SCHEDULE G
CITY OF CHANDLER, ARIZONA
Full-Time Employees and Personnel Compensation
Fiscal Year 2022-23
Fund