2022-23 Auditor General Schedules

City of Chandler — Special (2022-06-09)

View PDF Meeting page

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