CIP PURCHASE ORDERS
Fund Funding Source PO# Vendor Description Amount
CIP PURCHASE ORDERS
306 3067500-60480
08380306-100 P00469 Glenn A Rick Engineering & Development Co. $1,119.00
135 1357500-70000
08448135-500 P00696 Habitat West Inc $2,156.56
135 1357500-60480
08335135-450 P01087 Helix Environmental Planning Inc. $4,729.23 306 3067500-60360
08257306-100 P02002 Glenn A Rick Engineering & Development Co. $523.01
306 3067500-60480
11000306-100 P02018 Glenn A Rick Engineering & Development Co. $29,422.16
513 5137500-60480
08357513-100 P02018 Glenn A Rick Engineering & Development Co. $160,820.00
513 5137500-60480
08357513-100 P02018 Glenn A Rick Engineering & Development Co. $435,470
513 5137500-60480
08357513-100 P02018 Glenn A Rick Engineering & Development Co. $87,128
135 1357500-60480
08448135-450 P02029 Glenn A Rick Engineering & Development Co. $9,827.02
306 3067500-60360
08438306-100 P02033 Glenn A Rick Engineering & Development Co. $2,000.00
513 5137500-60480
08303513-500 P02040 Helix Environmental Planning Inc. $7,808.96 551 5517500-60480
08323551-450 P02156 Helix Environmental Planning Inc. $17,466.11 306 3067500-60360
13027306-100 P02187 SB & O Inc $17,367.20
302 3027500-60480
08079302-100 P02219 Glenn A Rick Engineering & Development Co. $687.50
306 3067500-60480
13028306-100 P02295 Glenn A Rick Engineering & Development Co. $920.00
306 3067500-60480
13027306-100 P02296 Glenn A Rick Engineering & Development Co. $1,390.00
302 3027500-60480
13031302-100 P02395 Levin & Dentino Inc
$17,472.00
302 3027500-60480
08079302-200 P02538 Epic Land Solutions $2,463
302 3027500-60360
13031302-100 P02609 Glenn A Rick Engineering & Development Co. $518
135 1357500-60640
13031135-450 P02609 Levine, Laurie $12,832.25
302 3027500-60360
08079302-100 P02660 NV5 Inc $9,984.00
302 3027500-60480
08079302-100 P02726 Architerra Inc. $682.50
307 3077500-60360
08043307-100 P02884 Geo Soils Inc $1,366.50
307 3077500-60360
08043307-100 P02921 Glenn A Rick Engineering & Development Co. $4,730.23
302 3027500-70000
13031302-450 P03039 Geo Soils Inc $7,735.89
306 3067500-60480
1117500-100 P03045 Disability Access Consultants LLC $40 111 1117500-60480
1002111-100 P03045 Disability Access Consultants LLC $1,420.00 135 1357500-60480
13031135-450 P03072 Anser Advisory Management LLC $11,582.00 551 5517500-60480
08323551-100 P03116 Glenn A Rick Engineering & Development Co. $569.49
354 3547500-70000
13043354-100 P03151 Architerra Inc. $23,708.00
341 3417500-60360
13040341-100 P03238 Glenn A Rick Engineering & Development Co. $1,480.00
306 3067500-60480
13027306-100 P03350 Glenn A Rick Engineering & Development Co. $415.88
307 307500-60480
08043307-450 P03412 Geo Soils Inc $2,509.19
111 1117500-60480
21019111-100 P03413 Glenn A Rick Engineering & Development Co. $24,944
354 3547500-60480
13043354-100 P03415 Levine, Laurie
$2,937.50
135 1357500-70000
13031135-500 P03416 Adame Landscape Inc $18,515.00
Fund Funding Source PO# Vendor Description Amount
CIP PURCHASE ORDERS
513 5137500-60480
08303513-100 P03496 Michael Baker International Inc $8,300.00 111 1117500-60480
10041111-100 P03627 Geo Soils Inc $539.00
306 3067500-60360
13030306-100 P03635 Michael Baker International Inc $186,429.68 111 1117500-60600
10041111-100 P03686 Levine, Laurie $1,800.00
128 1287500-60480
08449128-400 P03851 Southstar Engineering & Consulting Inc $311,142.40 307 307500-60360
08043307-100 P03865 RMA Group Inc $3,610.00
302 3027500-70000
08430302-500 P03919 NexTech Systems Inc $8,192.95
307 3065000-60480
13030306-200 Monument Row $32,099.69
307 307500-60480
08043307-100
Glenn A Rick Engineering & Development
Co. $6,253.75
306 3067500-60360
13030306-100 P03976 Michael Baker International Inc $4,399.51 111 1117500-60480
21019111-100 P03980 Glenn A Rick Engineering & Development Co. $25,048.00
306 3067500-70000
08438306-500 P03981 DBX Inc $260,534.00
341 3417500-60480
13044341-100 P03989 Glenn A Rick Engineering & Development Co. $4,600.00
302 3027500-60480
13048302-100 P04037 Glenn A Rick Engineering & Development Co. $16,766.25
306 3067500-60360
13027306-100 P04053 SB & O Inc $214.78
306 3067500-60360
08438306-100 P04054 LG2WB Engineers Inc $32,744.00
513 5137500-60360
08357513-200 P04055 Monument Row $3,013.75
513 5137500-60600
08357513-100 P04066 Michael Baker International Inc $20,407.00 307 3077500-70000
08043307-500 P04085 Geo Soils Inc $3,062.70
307 3077500-70000
08043307-500 P04131 Onyx Paving Company Inc $49,335.58
306 3067500-60360
13049306-100 P04168 STC Traffic Inc $51,410.00
Total CIP POs $ 3,830,098
Fund GL Account PO# Vendo r Description Amount Comment 111 1113540-71060 P03513 SouthCoast Fire Equipment Type 1 Truck $1.00 111 1113520-60880 P03614 AllStar Fire Equipment $4,032.56 151 1513540-62200 P03905 Johnson Equipment BC command vehicle $46,247.25 111 1117500-71060 P04071 SouthCoast Fire Equipment Type 1 Truck $1.00 111 1113580-62000 P04083 Capital Construction Ongoing window repair work $21,096.00
151 1513520-62860 P04093 Motorola Solutions $27,176.62
111 1113520-60880 P04103 LN Curtis and Sons $8,634.86
110 1101600-71150 P03896 Clenn A Rick Engineering $18,126.82 110 1104100-62979 P04079 TS Worldwide $2,500.00
111 1114100-60020 P04125 Endeavor Video marketing $9,750.00 357 3570050-62920
50148357-62920 P03982 Lyrasis Ebook collections dev $11,725.28 Grant covered portion 311 3115900-62920 P03982 Lyrasis Ebook collections dev $5,000.00 357 3570050-71010
50147357-71010 P04117 TMC Furniture $18,552.20 Grant covered portion 311 3115900-62920 P04150 OCLC Inc $1,186.49
110 1102200-60480 P03812 Municipal Resource Group
LLC $32,924.00
110 1102100-60480 P03914 Howroyd Wright Employment
Agency Denise Powell $17,502.80
701 7018100-60480 P03987 Disability Access Consultants
LLC $22,490.00
358 3580040-71020
50087358-71020 P03423 Tyler Tech $7,974.78
110 1104400-60320 P03979 Granicus Inc $3,903.08
110 1101600-60320 P04192 Glenn Lukos Associates $35,662.69 110 1101600-60440 P02805 Seltzer Caplan McMhanon
Vitek $301,211.41
110 1101600-60320 P03664 Epic Land Solutions $12,438.11 110 1101600-60480 P03915 Hunter Consulting $30,681.70
111 1111600-62960 P03930 Roger Ortiz $27,321.50
110 1102200-60480 P04175 GVP Ventures Inc $13,574.36
110 1102600-60320 P03385 SCG Spicer Consulting $10,000.00 110 1103130-62160 P03815 Central Square $3,900.00
110 1103120-71030 P03966 Motorola Solutions $244,575.26 110 1103120-60880 P3977 Ame
rican AED LLC $1,524.24
110 1103120-71060 P04123 Motorola Solutions $47,146.10
110 1103120-71060 P04128 AEP California $143,089.00
411 4110030-71030 P04147 Advexure LLC $27,393.33
110 1103120-64200 P04188 Aardvark $9,374.00
111 1113120-71010 P04189 Takkt America Holdings $9,391.55 110 1102600-60200 P04182 RAMS Audit services $39,965.00 110 1103120-71060 P03574 AEP California Upfitting vehicles we havent received yet $63,148.17
411 4110030-71060 P03574 AEP California
Upfitting vehicles we
havent received yet $8,252.46
110 1107500-60480
10002110-60480 P03660 Central Square $1,890.00
171 1715144-60480 P04183 The Swimming Swan $8,318.31
182 1820050-61960 P04191 Playcore Wisconsin $7,111.84
726 7268340-62160 P03730 CyberTech Analytics $90,050.00 FY 23/24 ROLLOVER
Operating Purchase Orders
Fund GL Account PO# Vendo r Description Amount Comment Operating Purchase Orders
726 7268340-62160 P03964 NetFile $3,000.00
726 7268340-63220 P04061 Western Audio Visual $2,120.00 726 7268340-71030 P04067 CDW Government LLC $43,738.37
726 7268340-71030 P04069 Busy Bee Electrical $7,112.00
726 7268340-62160 P04206 Kronos Inc $4,490.05
726 7268340-62160 P04209 Kronos Inc $250.00
726 7268340-60480 P04227 South Coast Copy Systems $25,392.99 180 1800050-60480 P03723 Riverside County 28,214.07 $
171 1715162-61960 P04155 Bare Bees $4,500.00
180 1800050-60480 P03723 Riverside County $28,214
726 7268340-63880 P03765 CoreLogic $4,094.00
306 3060060-60680 P03113 Superior Pavement Markings
Inc $8,664.80
302 3020060-60680 P03113 Superior Pavement Markings
Inc $30,000
110 1103130-60480 P03864 US TelePacific Corp $577.08
726 7268340-60480 P04221 SHI International Corp $8,165.70 110 1103130-60480 P04222 SHI International Corp $4,494.30 110 1106120-60480 P03523 Helix Environmental Planning $25,515.63 110 1106160-60800 P04186 Fuller Truck Accessories $9,150 Total Operating POs $ 1,632,537
Total Operating and CIP POs $ 5,462,634
FY 2022/23
Audited
FY 2023/24
(Estimated) $ Change % Change
General Fund
Ending Fund Balance 64,893,194$ 75,407,892 $ 10,514,698 $ 16.20% Non-Spendable 3,977,214 3,563,337 (413,877) -10.41% Restricted 225,188 137,371 (87,817) -39.00% Committed 23,582,973 37,171,282 13,588,309 57.62% Assigned 52,482 52,482 - 0.00% Unassigned 37,055,337 34,483,419 (2,571,918) -6.94% Total Fund Balance 64,893,194 $ 75,407,892 $ 10,514,698 $ Measure T
Ending Fund Balance 52,958,047$ 58,091,034 $ 5,132,987 $ 9.69% Non-Spendable 204,392 177,020 (27,372) -13.39% Restricted - - - 0.00% Committed 21,540,828 43,440,175 21,899,347 101.66% Assigned - - - 0.00% Unassigned 31,212,827 14,473,840 (16,738,987) -53.63% Total Fund Balance 52,958,047 $ 58,091,034 $ 5,132,987 $ Fire District Fund
Ending Fund Balance 3,722,345$ 4,640,350 $ 918,005 $ -6.45% Non-Spendable 45,190$ 36,694 $ (8,496) -18.80% Restricted 3,677,155 3,738,225 61,070 1.66% Committed - - - 0.00% Assigned - - - 0.00% Unassigned - 865,430 865,430 100.00% Total Fund Balance 3,722,345 $ 4,640,350 $ 918,005 $ Community Services District Funds*
Ending Fund Balance 6,663,094$ 7,050,738 $ (372,063) $ -5.29% Non-Spendable 5,674$ 4,369 $ 1,850 48.38% Restricted 6,657,420 7,046,369 (373,913) -5.32% Committed - - 0.00% Assigned - 0.00%
Unassigned - - 0.00% Total Fund Balance 6,663,094 $ 7,050,738 $ (372,063) $ Components of Fund Balance (Estimated)
11/21/2024
1407
FY 2022/23
Audited
FY 2023/24
(Estimated) $ Change % Change
Library District Fund
Ending Fund Balance 1,388,136$ 1,265,517 $ (17,077) $ -1.22% Non-Spendable 4,263$ 4,228 $ 364 9.34% Restricted 1,383,873 737,419 (17,441) -1.24% Committed - 6,186 - 0.00% Assigned - - - 0.00% Unassigned - 517,683 - 0.00% Total Fund Balance 1,388,136 $ 1,265,517 $ (17,077) $ * For GASB 54 representation purposes the Community Services District Funds include the CSD, Local Zones, and Landscape Lighting Districts (LLDs).
11/21/2024
2408
Estimated Ending Fund Balances on June 30, 2024
Fund Fund Description Beginning Balance Actual Revenues Transfers In Transfers Out Actual Expenditures Estimated Ending Balance Amount Unavailable Amount Available 110 General Fund 64,514,536 $ 77,671,286 $ 2,584 $ (965,374)$ (65,815,141)$ 75,407,891 $ 40,924,472 $ 34,483,419 $ 111 Gen Fund Measure T 52,958,048 28,226,552 239,040 (5,950,395) (17,382,210) 58,091,034 43,617,194 14,473,840 151 Fire District Admin 3,722,345 20,239,044 3,954,583 - (23,275,622) 4,640,350 3,774,920 865,430 171 Community Service District Fun 1,154,536 2,992,458 2,166,490 - (4,822,853) 1,490,631 1,055,029 435,602 311 Library Fund 1,388,137 3,006,938 783 - (3,130,340) 1,265,517 747,834 517,683 Sum of All Major Funds 123,737,602 $ 132,136,277 $ 6,363,480 $ (6,915,768) $ (114,426,167)$ 140,895,423 $ 90,119,449$ 50,775,974 $ Fund Fund Description Beginning Balance Actual Revenues Transfers In Transfers Out Actual Expenditures Estimated Ending Balance 112 General Fund Capital 8,115,085 $ 69,091 $ 265,068 $ (10,501) $ (219,467)$ 8,219,277 $ 118 Traffic Safety Fund 118,695 16,638 - - (18,671) 116,662 119 Crime Prevention Fund (4,652) 58,249 - - (97,146) (43,550) 127 DIF Fire Fund 2,072,746 284,976 - (170,678) (275,295) 1,911,749 128 DIF Freeway overcrossing Bridg 8,638,197 327,437 - - (48,499) 8,917,136 129 DIF General Facility Fund 121,233 68,002 - - (100) 189,136 130 DIF Law Enforcement Fund 1,630,010 207,589 - - (602) 1,836,998 131 DIF Library Fund 1,488,434 127,204 - - (74,603) 1,541,035 132 DIF Open Space Fund 1,819,093 68,413 - - (187,538) 1,699,968 133 DIF Park Land Fund 6,076,046 1,027,736 - - (740,553) 6,363,229 134 DIF Storm Drain Fund 5,160,817 307,938 - - (2,398) 5,466,356 135 DIF Street Fund 10,938,495 415,736 - - (39,508) 11,314,723 136 DIF Traffic Signal Fund 3,362,486 473,613 - - (1,253) 3,834,846 137 DIF Community Center Fund 1,816,237 210,139 - - (643) 2,025,732 138 DIF-FWY,Street,Bridge 9,880,811 2,180,078 - - (2,510) 12,058,379 140 RSA Fees Fund 205,364 7,787 - - (101) 213,050 141 SWRBBD Fund 267,453 10,142 - - (109) 277,487 161 TUMF Fund (381,263) 2,250,000 - - (1,032,703) 836,034 180 CSD Exempt Maintenance - 1,763,679 348,253 - (2,111,933) - 181 Local Zone A Fund - 196,058 41,645 (47,945) (189,758) - 182 Local Zone B Fund 303,500 481,448 - (107,269) (421,389) 256,289 183 Local Zone C Fund 64,006 43,703 - (9,820) (42,269) 55,620 184 Local Zone D Fund - 105,403 38,587 (34,774) (109,216) - 185 Local Zone E Fund - 14,997 6,770 (9,762) (12,005) - 186 Local Zone F Fund 59,280 57,586 - (3,870) (50,687) 62,308 188 Local Zone H Fund - 141,223 49,892 (16,694) (174,422) - 189 Local Zone I Fund 19,026 4,858 - - (2,930) 20,954 200 LLD 1 Copper Canyon Fund 118,447 507,401 - (15,481) (486,596) 123,771 202 LLD 2 Grizzly Ridge Fund 89,575 145,775 - (5,834) (110,381) 119,135 203 LLD 3 Cherry Street Fund 15,741 18,908 - (693) (21,569) 12,386 204 LLD 4 Western Pacific Fund 123,891 63,242 - (5,257) (48,648) 133,227 205 LLD 5 Murrieta Ranchos Fund 9,618 28,141 - (3,986) (27,237) 6,537 206 LLD 6 Fallsgrove Fund 64,705 21,616 - (3,639) (15,095) 67,587 207 LLD 7 Continental Homes Fund 23,394 31,365 - (3,986) (24,551) 26,222 208 LLD 8 Lincoln Ranch Fund 163,475 148,704 - (8,607) (156,977) 146,594 209 LLD 9 Tapestry Fund 29,912 57,014 - (1,964) (45,157) 39,806 210 LLD 10 Hwy 79/Hunter Rd Fund - 154,808 21,884 (12,246) (164,446) - 211 LLD 11 Masters/Winchester Fnd - 48,388 6,422 (16,405) (38,405) - 212 LLD 12 Warm Springs Fund 1,308,719 758,630 - (35,294) (548,754) 1,483,301 213 LLD 13 Mira Mosa Fund 24,390 305,417 - (11,900) (285,036) 32,871 214 LLD 14 Sycamore Ranch Fund 38,727 56,938 - (4,217) (44,439) 47,009 215 LLD 15 Greer Ranch Fund 29,251 117,958 - (635) (107,900) 38,674 216 LLD 16 Mapleton Fund 467,407 649,352 - (16,925) (572,864) 526,970 217 LLD 17 Country Gate Fund 128,080 69,277 - (4,217) (55,866) 137,274 218 LLD 18 Vineyards Fund 105,259 109,624 - (3,177) (148,056) 63,649 219 LLD 19 Murrieta Oaks Fund 296,532 421,464 - (10,455) (545,323) 162,218 220 LLD 20 Blackmore Ranch Fund 226,943 176,493 - (3,581) (195,144) 204,710 11/12/2024
1 409
Estimated Ending Fund Balances on June 30, 2024
Fund Fund Description Beginning Balance Actual Revenues Transfers In Transfers Out Actual Expenditures Estimated Ending Balance 221 LLD 21 Northstar Ranch Fund 537,349 323,440 - (11,264) (285,668) 563,856 222 LLD 22 US Homes Fund 7,424 7,648 - (347) (5,505) 9,220 223 LLD 23 Creekside Village Fund 294,997 208,407 - (5,083) (183,591) 314,729 224 LLD 24 Springbrook Fund 12,191 36,517 - (1,675) (34,474) 12,559 225 LLD 25 Golden Cities Fund 606,656 308,486 - (3,004) (384,847) 527,291 226 LLD 26 Murrieta Field Fund 27,798 12,728 - (1,560) (11,130) 27,836 227 LLD 27 Hunter Ridge Fund 274,625 102,997 - (2,599) (80,378) 294,645 228 LLD 28 Lantana 25,575 68,454 - (1,562) (63,468) 28,999 229 LLD 29 Gallery Estates 12,067 8,595 - - (6,802) 13,859 302 Measure A Fund 11,234,568 4,048,823 - (724,736) (774,802) 13,783,853 306 State Gas Tax (HUTA) Fund 10,484,623 3,442,082 - - (3,087,558) 10,839,147 307 SB1 Road Maintenance and Rehab 4,852,752 3,071,403 - - (1,616,806) 6,307,350 316 Developer Agreement Fund 1,880,878 159,897 - - (5,816) 2,034,959 319 Reimbursement Agreement Fund (19,450) 41,483 - - (19,840) 2,193 322 Low Mod Income Housing Fund 12,675,490 114,847 - - (34,802) 12,755,535 323 Housing Authority 2,515,097 77,352 - - (501) 2,591,948 336 Air Quality Management Fund 791,926 177,495 - - (338) 969,084 338 Opioid Settlement Fund 6,581 156,644 - - (166,500) (3,275) 341 Community Development Block Gr (135,464) 776,597 - - (787,267) (146,134) 350 Other Grants (3,173) - - - (18,732) (21,906) 352 Cal Trans HBRR Grant Fund - - - - - - 353 Recycling Grant Fund 77,496 175,207 - - (165,180) 87,523 354 Projects Funded Via Grants Fun (1,443) 106,092 - - (3,107) 101,543 355 OTS Grant Fund (10,111) 44,612 - (27) (148,861) (114,387) 357 Library Grant Fund 28,110 122,147 - (783) (130,836) 18,638 358 Other State Grants Fund (190,417) 162,174 - - (342,134) (370,377) 361 Federal Grant - DOJ 1,083 22 - - (1,096) 9 374 ARPA Federal Grant Fund 404,258 2,506,178 - (506,665) (2,148,256) 255,514 376 Homeland Security - Federal Gr (126,599) 97,317 - - (14,617) (43,899) 377 Other Federal Grants Fund (511,814) 885,409 - - (791,579) (417,984) 380 State Transportation Imp Fund (71,065) 2,200 - - - (68,864) 402 Seized Assets Fund-State 127,481 5,347 - - (118,566) 14,262 403 Seized Assets Fund-Federal DOJ 640,028 25,817 - - (363,713) 302,132 404 Seized Asset Fnd-Fed Treasury 194,930 7,128 - - (40,508) 161,549 405 Undercover Operations 35,063 - - - - 35,063 411 Supplemental Law Fund 140,823 324,897 - - (371,453) 94,266 431 NPDES CSA 152 Fund 997,318 868,335 300,000 - (883,008) 1,282,645 451 City Wide Debt Service - - 577,646 - (577,646) - 502 SuccessrAgncy-2005 TABS Residu 159,908 6,064 - - (57) 165,915 511 Obligation Payment Fund 352,019 13,461 - - (174) 365,306 512 Obligation Pmt Fund 2005 TABs (10,501) - 10,501 - 0 0 513 Obligation Pmnt Fnd 2007 TABs 1,920,358 69,568 - - (758,542) 1,231,383 551 Area Drainage Fund 5,847,155 282,425 - - (55,516) 6,074,063 576 CFD'S Bond Proceeds 1,621,090 77,541 - - (951,214) 747,417 601 SuccessrAgncy-TaxIncr-Residual 63,994 242,000 - - (242,000) 63,994 602 SuccessrAgency RPTTF Debt Serv (29,849,439) 2,760,555 - - (1,073,176) (28,162,060) 655 2020A LRB Debt Service Fund 10,496 - 724,736 - (724,736) 10,496 656 MFA (LARB 2016A) 1,883,583 3,714,868 - - (3,615,258) 1,983,193 657 MFA (LARB 2016B) 329,994 648,619 - - (630,088) 348,526 658 MFA (LARB 2022) 1,509,695 3,582,423 - - (3,495,300) 1,596,818 659 MFA (STRRB 2012) - - - - - - 701 Risk Management Fund (6,727,902) 9,072,394 - - (8,461,470) (6,116,978) 715 Vehicle Replacement Fund 1,086,815 41,212 - - (529) 1,127,498 726 Information Services/GIS Fund 4,228,923 4,275,339 - - (4,258,921) 4,245,342 801 Trust Accounts - - - - - - 11/12/2024
2 410
Estimated Ending Fund Balances on June 30, 2024
Fund Fund Description Beginning Balance Actual Revenues Transfers In Transfers Out Actual Expenditures Estimated Ending Balance 810 Mur Valley Town Hall Endowment 509,730 19,149 - - (11,868) 517,011 811 Community Facilities Districts (2,526,788) 2,189,631 - - (1,934,758) (2,271,915) 812 Com. Facilities Dist Formation 26,777 - - - - 26,777 Sum of All Other Funds 93,288,721 $ 60,282,261 $ 2,391,406 $ (1,839,118) $ (49,381,746)$ 104,741,525 $ 11/12/2024
3 411
Fiscal Year 2023/24 Year- End
B
udget Update
Presented by Javier Carcamo, Director of Finance
Jennifer Terry, Finance Manager
Tanner Benson, Financial Analyst
December 3, 2024, City Council Meeting, Agenda Item No. 12 R e c e i v e d A f t e r A g e n d a P r i n t e d 1 2 / 0 3 / 2 0 2 4 - R e g u l a r M e e t i n g D I S C U S S I O N - I t e m N o . 1 2