Amount Maturity Interest Rate Funds Amount
Wells Fargo Bank - General Checking $ 1,628,823.23 n/a 0% General Fund (101) $4,687,134.99 Utility Users Tax Fund (102) $582,676.09
Deposits Fund (103) ($10,121.98)
Long Term Planning Fee Fund (112) $8,189.07
$ 3,423,775.19 n/a 3.17% Technology Fee Fund (113) $14,418.00 Gas Tax Fund (200) $4,542.27
SB 1 Gas Tax Fund (201) $8,428.12
Webbank Salt Lake City $ 243,000.00 7/18/2023 2.75% Prop A Fund (203) $55,809.20 Texas Exchange Bank Crowley CD $ 249,000.00 7/9/2024 0.50% Prop C Fund (204) $32,317.69 BMW Bank of NA $ 248,000.00 12/10/2024 0.90% TDA Fund (205) $0.00 Salal Credit Union Seattle Wash $ 240,000.00 9/29/2023 4.20% Sewer Fund (206) $609.10 STPL Fund (208) $1,060.28
Recycling Grant Fund (209) $29,920.12
Measure R Fund (210) $72,393.44
Measure M Fund (212) $80,620.09
Measure W Fund (213) $39,781.14
COPS Fund (215) $396,006.90
County Park Grant Fund (217) $9,297.89
CWPP Grant Fund (219) $19,516.01
ARPA Fund (220) $0.00
Total $ 6,032,598.42 Total $ 6,032,598.42
I hereby certify that there are sufficient funds available to meet the City's obligations for the next three (3) months. $ - This report is prepared in accordance with the guidelines established in the Statement of Investment Policy adopted November 21, 2017 Submitted By: Reviewed By:
Laurie Stiver
City Manager City Treasurer
CASH ON DEPOSIT BY ACCOUNT CASH & INVESTMENTS ON DEPOSIT BY FUND Bank Accounts:
Monthly Investment Report for the month of June 2023
City of Bradbury
Kevin Kearney
Investments:
Local Agency Investment Fund (LAIF)
Expenditures
2021-22 2022-23
Account Description Budget Budget
General Fund:
City Council Division:
101-11-6100 Events and awards 6,500 922 14% 14,000 10,994 79% 101-11-6110 City Newsletter - #DIV/0! 400 265 66%
101-11-6500 Community Support (homelessness) 3,000 3,000 100% 4,000 3,600 90% 9,500 3,922 41% 18,400 14,859 81%
City Manager Division:
101-12-5010 Salaries 126,720 130,753 103% 150,000 153,333 102% 101-12-5100 Benefits 50,747 51,256 101% 58,099 60,662 104% 101-12-6020 Meetings & Conferences 5,000 3,076 62% 5,000 4,475 90% 101-12-6025 Expense Account 1,500 280 19% 1,500 320 21% 101-12-6050 Mileage 1,000 489 49% 1,000 1,098 110%
101-12-6440 Cell Phone 1,000 900 90% 900 975 108%
185,967 186,754 100% 216,499 220,863 102%
City Clerk Division:
101-13-5010 Salaries 67,000 67,000 100% 72,695 107,695 148% 101-13-5100 Benefits 30,000 27,793 93% 29,359 39,992 136% 101-13-6020 Meetings & Conferences - #DIV/0! - 689 #DIV/0! 101-13-6050 Mileage 100 107 107% 100 52 52%
101-13-6210 Special Department Supplies 275 0% 500 - 0% 101-13-6220 Election Supplies 500 564 113% 600 - 0%
101-13-6225 Codification 3,000 4,854 162% 3,500 2,916 83% 101-13-7000 Contract Election Services 15,000 0% - - #DIV/0! 115,875 100,318 87% 106,754 151,344 142%
Finance Division:
101-14-5010 Salaries 15,789 17,033 108% 25,000 19,646 79% 101-14-5100 Benefits 1,355 512 38% - - #DIV/0!
101-14-6210 Special Department Supplies 400 400 100% 500 420 84% 101-14-6230 Contracted Computer Services 1,000 1,981 198% 1,500 - 0% 101-14-7010 Contracted Banking Services 4,500 4,540 101% 4,000 3,597 90% 101-14-7020 Contracted Audit Services 19,000 10,000 53% 17,000 17,510 103% 101-14-7040 GASB Reports 700 700 100% 1,000 700 70%
42,744 35,166 82% 49,000 41,873 85%
City Attorney Division:
101-15-6125 City Attorney-Planning 3,000 - 0% 10,000 8,383 84% 101-15-7020 City Attorney Retainer 31,800 29,162 92% 34,800 31,900 92% 101-15-7070 City Attorney Special Service 3,000 14,080 469% 2,000 34,721 1736% 101-15-7075 Development Code Update 14,373 #DIV/0! 7,000 3,245 46% 101-15-7080 Seminars & Training - - #DIV/0! 1,000 385 39% 101-15-7450 City Attorney-Code Enforcement 2,000 0% 2,000 1,238 62% 36,800 57,615 157% 46,800 79,872 171%
General Government Division:
101-16-5010 Salaries 55,605 55,605 100% 60,331 67,321 112% 101-16-5100 Benefits 14,286 16,724 117% 21,297 16,936 80% 101-16-6010 Seminars & Training 1,000 496 50% 1,000 - 0% 101-16-6020 Meetings & Conferences 200 712 356% 1,000 35 4% 101-16-6040 Transportation & Lodging 500 0% 1,000 - 0%
101-16-6050 Mileage 300 371 124% 400 - 0%
101-16-6120 Postage 700 253 36% 400 704 176%
101-16-6200 Office Supplies 3,000 990 33% 2,000 5,224 261% 101-16-6210 Special Departmental Supplies 997 #DIV/0! 16,100 - 0% 101-16-6230 Computer & Website Services 10,000 2,396 24% 4,000 12,136 303% 101-16-6240 PERS UAL Payment 6,291 9,598 153% 12,920 12,490 97% 101-16-6241 PERS Replacement Benefit Contribution 2,600 2,823 109% 3,000 2,858 95% 101-16-6242 PERS SSA 218 Annual Fee 200 0% 200 - 0%
2021-22
YTD @ 06/30/2022
2022-23
YTD @ 06/30/2023
1 of 4
Expenditures
2021-22 2022-23
Account Description Budget Budget
2021-22
YTD @ 06/30/2022
2022-23
YTD @ 06/30/2023
101-16-6250 Copier & Duplications - #DIV/0! - 1,048 #DIV/0! 101-16-6300 Insurance 39,187 36,652 94% 40,000 42,609 107% 101-16-6400 Utilities 7,380 7,081 96% 5,500 10,197 185% 101-16-6440 Telephone 2,100 1,689 80% 2,000 2,210 111%
101-16-6450 Building Operations 1,200 504 42% 2,000 439 22% 101-16-6460 Building & Cleaning Service 4,500 4,500 100% 4,000 5,836 146% 101-16-6470 Maintenance & Supplies 20,500 21,468 105% 1,000 2,536 254% 101-16-7435 Redistricting 65,000 40,250 62% - 743 #DIV/0! 101-16-6415 Street Signs 6,000 0% 10,000 - 0%
240,549 203,109 84% 188,148 183,322 97%
Engineering Division:
101-19-7230 Contracted Engineering Services 80,000 54,950 69% 80,000 62,325 78% 80,000 54,950 69% 80,000 62,325 78%
Planning, Zoning & Development Division:
101-20-6020 Meetings & Conferences -
101-20-6120 Postage 500 35 7% 300 - 0%
101-20-6210 Special Department Supplies 500 80 16% 300 - 0% 101-20-6240 Environmental Filing Fees 500 0% - - #DIV/0! 101-20-7210 City Planner Retainer 46,800 30,125 64% 46,800 31,200 67% 101-20-7220 Contracted Building & Safety 120,000 73,235 61% 90,000 82,800 92% 101-20-7240 City Planner Special Service 15,000 6,765 45% 10,000 8,828 88% 101-20-7245 General Plan update 33,436 #DIV/0! 15,000 82,903 553% 101-20-7075 Development Code Update 2,000 0% - #DIV/0!
185,300 143,676 78% 162,400 205,731 127%
Parks & Landscape Maintenance Division:
101-21-7015 Royal Oaks Trail Maintenance 10,000 10,332 103% 10,000 14,232 142% 101-21-7020 City Hall Grounds Maintenance 7,000 9,540 136% 7,500 4,836 64% 101-21-7025 Trail Maintenance 10,000 2,758 28% 10,000 8,978 90% 101-21-7035 Mt.Olive Entrance & Trail 12,000 6,184 52% 12,000 6,831 57% 101-21-7045 Lemon/RO Horse Trail 7,000 1,685 24% 7,000 1,651 24% 101-21-7060 Street Tree Trimming 15,000 16,956 113% 15,000 8,245 55% 61,000 47,455 78% 61,500 44,773 73%
Public Safety Division:
101-23-6210 Special Departmental Services 42 #DIV/0! 50 52 104% 101-23-7410 Contract Services Sheriff 126,940 105,783 83% 128,000 107,295 84% 101-23-7420 City Hall Security 3,000 4,770 159% 3,500 2,976 85% 101-23-7450 Code Enforcement 12,000 1,439 12% 1,500 1,549 103% 101-23-7757 AED Purchase #DIV/0! - #DIV/0!
141,940 112,034 79% 133,050 111,872 84%
Emergency Preparedness Division:
101-24-6010 Seminars & Training 110 65 59% 100 44 44%
101-24-6020 Meetings & Conferences 500 0% 500 27 5%
101-24-6030 Memberships & Dues 400 360 90% 450 900 200% 101-24-6100 Events & Awards 200 0% 200 - 0%
101-24-6470 Maintenance & Supplies 5,500 261 5% 5,000 1,615 32% 101-24-6480 Civic Center Generator 1,000 291 29% 300 - 0% 101-24-7245 Hazard Mitigation Plan - #DIV/0! - - #DIV/0! 7,710 977 13% 6,550 2,586 39%
2 of 4
Expenditures
2021-22 2022-23
Account Description Budget Budget
2021-22
YTD @ 06/30/2022
2022-23
YTD @ 06/30/2023
Animal & Pest Control Division:
101-25-7000 Animal Control Services 11,450 10,496 92% 8,500 10,811 127% 101-25-7010 Pest Control Services 500 0% 500 - 0%
11,950 10,496 88% 9,000 10,811 120%
Intergovernmental Relations Division:
101-30-6030 Memberships & Dues 10,500 12,078 115% 11,000 11,479 104% 10,500 12,078 115% 11,000 11,479 104%
General Fund Totals 1,129,835 968,550 86% 1,089,101 1,141,711 105% Utility Users Tax Fund:
102-42-7630 NPDES Stormwater Compliance 90,000 16,128 18% 1,600 11,729 733% 90,000 16,128 18% 1,600 11,729 733%
Deposits Fund:
103-00-2039 Chadwick Ranch Development 75,000 92,263 123% 50,000 - 0% 75,000 92,263 123% 50,000 - 0%
Long Term Planning Fee Fund:
112-20-7245 General Plan Expense 2,000 - 0% - - #DIV/0! 2,000 - - - - #DIV/0!
Technology Fee Fund:
113-20-4500 Permit Digitizing - - #DIV/0! - #DIV/0!
113-20-7730 Website 3,000 1,800 60% 5,000 1,800 36%
113-20-8120 Capital Equipment-Server & Copier 10,000 19,648 196% 12,000 10,770 90% 13,000 21,448 165% 17,000 12,570 74%
Gas Tax Fund:
200-48-6400 Utilities-Select System 11,000 11,389 104% 11,000 11,357 103% 200-48-6410 Street Lights 10,000 10,468 105% 11,000 11,124 101% 200-48-7000 PW Contract Services 1,000 763 76% 600 406 68% 200-48-7290 Street Sweeping 4,000 4,384 110% 4,000 3,651 91% 200-48-7750 Wild Rose Project 25,097 14,168 56% 6,430 605 9% 51,097 41,172 81% 33,030 27,143 82%
SB1 Gas Tax Fund:
201-48-7750 Wild Rose Project 81,615 18,281 22% 61,070 20,055 33% 201-48-7755 City Wide Slurry Seal #DIV/0! - #DIV/0!
81,615 18,281 22% 61,070 20,055 33%
Prop. A Fund:
203-00-7600 Sale of Prop. A Funds
- - #DIV/0! - - #DIV/0!
Prop. C Fund:
204-20-6030 Memberships & Dues 900 353 39% 400 - 0%
204-40-7325 Transit Services 9,000 7,745 86% 8,449 7,744 92% 204-48-7745 Royal Oaks North Curb Extension - -
204-48-7750 Wild Rose Project 36,570 15,348 21,220 604
46,470 23,446 50% 30,069 8,348 28%
Transportation Development Act Fund:
205-48-7045 RO Trail - 2,600 #DIV/0! 5,000 856 17%
205-48-7720 Lemon/RO Horse Trail Project - #DIV/0! - - #DIV/0! 205-48-7735 Royal Oaks & Mt. Olive Trail Rehab. 5,000 2,920 58% - - #DIV/0! 205-00-7760 Return of Funds - - #DIV/0! - - #DIV/0!
5,000 5,520 #DIV/0! 5,000 856 #DIV/0!
3 of 4
Expenditures
2021-22 2022-23
Account Description Budget Budget
2021-22
YTD @ 06/30/2022
2022-23
YTD @ 06/30/2023
Sewer Fund:
206-50-7601 Mt. Olive Lane Sewer Project - - #DIV/0! - - #DIV/0! 206-50-7602 DUSD Message Board - - #DIV/0! - - #DIV/0!
206-50-7606 Winston Ave Project - - #DIV/0! - - #DIV/0! 665,476 - 0% - - #DIV/0!
STPL Fund:
208-48-7750 Wild Rose Project 1,055 - 0% 1,055 - 0%
1,055 - 0% 1,055 - 0%
Recycling Grant Fund:
209-35-7300 Recycling Education 5,000 - 0% 5,000 6,695 134% 5,000 - - 5,000 6,695 1
Measure R Fund:
210-48-7750 Wild Rose Project 88,739 - 0% 88,739 28,321 32% 88,739 - 0% 88,739 28,321 32%
Measure M Fund
212-48-7750 Wild Rose Project 58,470 0% 58,470 - 0%
58,470 - 0% 58,470 - 0%
Measure W Fund
213-42-7630 NPDES Stormwater Compliance 50,506 47,537
50,500 42,230 84% 50,506 47,537 94%
Citizen's Option for Public Safety (COPS) Fund:
215-23-7410 Contract Services Sheriff 50,000 50,000 100% - #DIV/0! 215-23-7411 Contract CSO Services & Supplies 56,500 52,116 92% 55,000 124,884 227% 106,500 102,116 96% 55,000 124,884 227%
County Park Grant:
217-21-7650 Civic Center Park 1,000 - 0% 1,000 - 0%
1,000 - 0% 1,000 - 0%
Fire Safe Grant 14-USFS-SFA-0053:
219-21-7761 Community Wildfire Protection Plan 30,934 3,555 11% 5,000 1,885 38% 30,934 3,555 11% 5,000 1,885 38%
ARPA Fund:
220-00-5000 Operating Transfers Out - - #DIV/0! 132,500 - 0% 220-00-6215 ARPA Expenses 100,000 - 0% 5,300 - 0%
100,000 - 0% 137,800 - 0%
Total Expenditures 2,601,691 1,334,709 51% 1,689,440 1,431,734 85% 4 of 4