Los Banos City Council
June 1, 2022

1020
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 9:58AM
Fiscal Year: 2023
2020 2021
Actual Actual
44,284.37 45,569.57
44,284.37 45,569.57
437.96 142.72
lll .95 (99.15)

0.00 0.00
549.91 43.57
44,834.28 45,613.14
314.11 345.70
379.44 388.11

0.00 0.00

0.00 0.00
7,971.84 8,145.18
12,612.01 12,147.70

0.00 0.00

36.10 169.95
493.32 260.10
1,000.00 1,000.00

0.00 0.00
2,070.82 2,010.71

0.00 0.00
GL-BudgetAnalysis (5/20/2022 - 9:58 AM)
2022 2022
Adopted Estimated Account
280
R06
46,992.00 46,992.00 355-020
46,992.00 46,992.00
R07

85.00 35.00 361-010

0.00 -6.00 362-010

0.00 0.00 369-000

85.00 29.00
47,077.00 47,021.00
458
E03
323.00 323.00 200-202
468.00 468.00 200-204
500.00 0.00 200-210

0.00 0.00 200-213
8,203.00 8,203.00 200-220
15,000.00 15,000.00 200-221

0.00 0.00 200-222
200.00 200.00 200-223
500.00 147.00 200-224
2,000.00 2,000.00 200-225

0.00 0.00 200-226
2,381.00 2,265.00 200-230

0.00 0.00 200-231
LOsBanos
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
LB CREEKSHPCNTRAD#I0R
Assessments
Landscape & Lighting Assessmen 0.00 51 ,691.00 0.00 0.00 0.00 Assessments Totals: 0.00 5 1,691.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 25.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 25.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 51,716.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 492.00 0.00 0.00 0.00
Fleet Services 0.00 736.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 500.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 0.00 0.00 0.00 0.00
Landscape Maintenance 0.00 8,203.00 0.00 0.00 0.00
Park Maintenance 0.00 15,000.00 0.00 0.00 0.00
A.O. Park Facility Maint. 0.00 0.00 0.00 0.00 0.00
Storm Drain Maintenance 0.00 200.00 0.00 0.00 0.00
Street Sign Maintenance 0.00 500.00 0.00 0.00 0.00
Street Tree Maintenance 0.00 2,000.00 0.00 0.00 0.00
Fence Maintenance 0.00 0.00 0.00 0.00 0.00
Administrative Services 0.00 2,572.00 0.00 0.00 0.00
Professional Services 0.00 0.00 0.00 0.00 0.00
Pagel
-171-
1021
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00 232.73 242.77 250.00 0.00 200-263 Street Light Maintenance 0.00 250.00 0.00 0.00 0.00 4,588.51 3,849.06 5,670.00 5,200.00 200-264 Electricity & Gas 0.00 5,600.00 0.00 0.00 0.00 504.73 545.75 590.00 590.00 200-265 Gasoline & Oil 0.00 655.00 0.00 0.00 0.00 30,203.61 29,105.03 36,085.00 34,396.00 Supplies & Services Totals: 0.00 39,508.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 0.00 0.00 200-714 Storm Drain Improvements 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Capital Outlay Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs
15,463.32 15,236.35 16,638.00 15,570.00 200-820 Charge In 0.00 18,250.00 0.00 0.00 0.00 15,463.32 15,236.35 16,638.00 15,570.00 Charge Ins - Outs Totals: 0.00 18,250.00 0.00 0.00 0.00 El0 Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 45,666.93 44,341.38 52,723.00 49,966.00 EXPENDITURES TOTALS: 0.00 57,758.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 45,666.93 44,341.38 52,723.00 49,966.00 DEPT EXPENSES 0.00 57,758.00 0.00 0.00 0.00 (45,666.93) (44,341.38) (52,723.00) (49,966.00) Assessment District Totals: 0.00 (57,758.00) 0.00 0.00 0.00 44,834.28 45,613.14 47,077.00 47,021.00 FUND REVENUES 0.00 51,716.00 0.00 0.00 0.00 45,666.93 44,341.38 52,723.00 49,966.00 FUND EXPENSES 0.00 57,758.00 0.00 0.00 0.00 (832.65) 1,271.76 (5,646.00) (2,945.00) LB CREEK SHP CNTR AD#l0 IT 0.00 (6,042.00) 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:58 AM) Page2
-172-
1022
2020
Actual
44,834.28
45,666.93
(832.65)
2021
Actual
45,613.14
44,341.38
1,271.76
GL-BudgetAnalysis (5/20/2022 - 9:58 AM)
2022
Adopted
47,077.00
52,723.00
(5,646.00)
2022
Estimated Account Description
47,021.00 REPORT REVENUES
49,966.00 REPORT EXPENSES
(2,945.00) REPORT TOTALS:
-173-
FTE

0.00 0.00

0.00 2023
Requested
51,716.00
57,758.00
(6,042.00)
2023
Proposed

0.00 0.00

0.00 2023
Approved

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00

1023
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 9:58AM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 0.00

0.00 0.00

0.00 0.00
215,325.70 226,105.76
215,325.70 226,105.76
521.62 215.06

0.00 0.00

0.00 0.00
521.62 215.06

0.00 0.00

0.00 0.00
215,847.32 226,320.82
1,258.25 1,382.81
1,518.67 1,554.28

0.00 0.00
56,648.02 58,522.95
15,194.40 17,224.88
GL-Budget Analysis (5/20/2022 - 9:58 AM)
2022 2022
Adopted Estimated Account
281
R03

0.00 0.00 331-010

0.00 0.00 334-010

0.00 0.00
R06
276,448.00 276,448.00 355-020
276,448.00 276,448.00
R07
100.00 75.00 361-010

0.00 0.00 362-010

0.00 0.00 369-000
100.00 75.00
ROS

0.00 0.00 390-010

0.00 0.00
276,548.00 276,523.00
458
E03
1,292.00 1,292.00 200-202
1,870.00 1,870.00 200-204

0.00 0.00 200-210
58,900.00 60,000.00 200-213
25,836.00 25,836.00 200-220
rOsBanos
· 11,e Crnssmads of C,diJorni,t
2023 2023 2023 2023
Description FfE Requested Proposed Approved Adopted
MEADOWLANDSAD#llFUND
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Assessments
Landscape & Lighting Assessmen 0.00 288,342.00 0 .00 0.00 0.00 Assessments Totals: 0.00 288,342.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 50.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 50.00 0.00 0.00 0.00
Miscellaneous
Miscellaneous Revenues 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 288,392.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 1,969.00 0.00 0.00 0.00 Fleet Services 0.00 2,944.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 0.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 66,000.00 0.00 0.00 0.00 Landscape Maintenance 0.00 25,836.00 0.00 0.00 0.00

-174-
1024
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 26,591.51 29,883.14 30,000.00 30,000.00 200-221 Park Maintenance 0.00 31,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-223 Storm Drain Maintenance 0.00 0.00 0.00 0.00 0.00 499.54 433.47 500.00 365.00 200-224 Street Sign Maintenance 0.00 500.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-225 Street Tree Maintenance 0.00 2,000.00 0.00 0.00 0.00 744.74 749.08 750.00 750.00 200-226 Fence Maintenance 0.00 750.00 0.00 0.00 0.00 11,586.55 11,716.89 12,714.00 12,405.00 200-230 Administrative Services 0.00 13,520.00 0.00 0.00 0.00 63,042.00 64,456.91 64,871.00 64,871.00 200-231 Professional Services 0.00 64,871.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00 9,798.47 4,384.65 10,000.00 8,000.00 200-263 Street Light Maintenance 0.00 10,000.00 0.00 0.00 0.00 24,095.69 23,990.18 26,300.00 23,000.00 200-264 Electricity & Gas 0.00 26,000.00 0.00 0.00 0.00 2,018.03 2,185.76 2,362.00 2,362.00 200-265 Gasoline & Oil 0.00 2,622.00 0.00 0.00 0.00 212,995.87 216,485.00 235,395.00 230,751.00 Supplies & Services Totals: 0.00 250,812.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 9,204.63 0.00 0.00 200-714 Storm Drain Improvements 0.00 30,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 9,204.63 0.00 0.00 Capital Outlay Totals: 0.00 30,000.00 0.00 0.00 0.00 E08 Charge Ins - Outs
42,518.13 41,903.19 45,756.00 42,818.00 200-820 Charge In 0.00 50,187.00 0.00 0.00 0.00 42,518.13 41,903.19 45,756.00 42,818.00 Charge Ins - Outs Totals: 0.00 50,187.00 0.00 0.00 0.00 EIO Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 255,514.00 267,592.82 281,151.00 273,569.00 EXPENDITURES TOTALS: 0.00 330,999.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 255,514.00 267,592.82 281,151.00 273,569.00 DEPT EXPENSES 0.00 330,999.00 0.00 0.00 0.00 (255,514.00) (267,592.82) (281,151.00) (273,569.00) Assessment District Totals: 0.00 (330,999.00) 0.00 0.00 0.00 498 Transfer Out
GL-Budget Analysis (5/20/2022 - 9:58 AM) Page2
-175-
1025
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FI'E Requested Proposed Approved Adopted E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 215,847.32 226,320.82 276,548.00 276,523.00 FUND REVENUES 0.00 288,392.00 0.00 0.00 0.00 255,514.00 267,592.82 281 ,151.00 273,569.00 FUND EXPENSES 0.00 330,999.00 0.00 0.00 0.00 (39,666.68) (41,272.00) (4,603.00) 2,954.00 MEADOWLANDS AD#l l FUND 0.00 (42,607.00) 0.00 0.00 0.00 215,847.32 226,320.82 276,548.00 276,523.00 REPORT REVENUES 0.00 288,392.00 0.00 0.00 0.00 255,514.00 267,592.82 281 ,151.00 273,569.00 REPORT EXPENSES 0.00 330,999.00 0.00 0.00 0.00 (39,666.68) (41,272.00) (4,603.00) 2,954.00 REPORT TOTALS: 0.00 (42,607.00) 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 9:58 AM) Page3
-176-
1026
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 9:58AM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 0.00

0.00 0.00

0.00 0.00
118,529.12 139,978.00
118,529.12 139,978.00
709.20 231.90
167.79 (189.40)

0.00 0.00
876.99 42.50
119,406.11 140,020.50
418.82 460.94
506.52 518.09

0.00 0.00
19,410.99 25,013.74
2,296.92 2,346.87
13,975.69 11,436.30

0.00 0.00
499.53 390.14
GL-Budget Analysis (5/20/2022 - 9:58 AM)
2022 2022
Adopted Estimated Account
282
R03

0.00 0.00 331-010

0.00 0.00 334-010

0.00 0.00
R06
149,864.00 149,864.00 355-020
149,864.00 149,864.00
R07
100.00 70.00 361-010

0.00 -8.00 362-010

0.00 0.00 369-000
100.00 62.00
149,964.00 149,926.00
458
E03
431.00 431.00 200-202
623.00 623.00 200-204
500.00 0.00 200-210
25,565.00 29,000.00 200-213
2,364.00 2,364.00 200-220
18,000.00 18,000.00 200-221

0.00 0.00 200-223
500.00 0.00 200-224
Ci9'oJ [osBanos
Ar , Cms.smmls ()f Califi'm1fo
2023 2023 2023 2023
Description FI'E Requested Proposed Approved Adopted
MISSION ESTATES AD#12 FUNJ
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Assessments
Landscape & Lighting Assessmen 0.00 157,354.00 0.00 0.00 0.00 Assessments Totals: 0.00 157,354.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 50.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 50.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 157,404.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 656.00 0.00 0.00 0.00
Fleet Services 0.00 982.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 500.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 32,000.00 0.00 0.00 0.00 Landscape Maintenance 0.00 2,364.00 0.00 0.00 0.00
Park Maintenance 0.00 20,000.00 0.00 0.00 0.00
Storm Drain Maintenance 0.00 0.00 0.00 0.00 0.00
Street Sign Maintenance 0.00 500.00 0.00 0.00 0.00

-177-
1027
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 2,000.00 2,000.00 200-225 Street Tree Maintenance 0.00 2,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-226 Fence Maintenance 0.00 0.00 0.00 0.00 0.00 5,233.28 5,411.21 6,100.00 6,014.00 200-230 Administrative Services 0.00 6,729.00 0.00 0.00 0.00 12,116.28 12,379.80 12,468.00 12,480.00 200-231 Professional Services 0.00 12,480.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00 991.80 995.88 1,000.00 1,000.00 200-263 Street Light Maintenance 0.00 1,000.00 0.00 0.00 0.00 20,626.48 21,552.81 23,000.00 21,000.00 200-264 Electricity & Gas 0.00 22,470.00 0.00 0.00 0.00 672.98 728.28 788.00 788.00 200-265 Gasoline & Oil 0.00 874.00 0.00 0.00 0.00 76,749.29 81,234.06 93,339.00 93,700.00 Supplies & Services Totals: 0.00 105,355.00 0.00 0.00 0.00 E05 Capital Outlay
9,737.25 0.00 13,000.00 13,000.00 200-714 Storm Drain Improvements 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-717 Landscaping & Irrigation 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-720 Building & Structures 0.00 0.00 0.00 0.00 0.00

0.00 5,562.83 0.00 0.00 200-747 Park & Playground Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 38,000.00 30,000.00 200-753 Specialized Equipment 0.00 15,000.00 0.00 0.00 0.00 9,737.25 5,562.83 51,000.00 43,000.00 Capital Outlay Totals: 0.00 15,000.00 0.00 0.00 0.00 E08 Charge Ins - Outs
38,658.30 38,097.29 41,596.00 38,926.00 200-820 Charge In 0.00 45,625.00 0.00 0.00 0.00 38,658.30 38,097.29 41,596.00 38,926.00 Charge Ins - Outs Totals: 0.00 45,625.00 0.00 0.00 0.00 El0 Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 125,144.84 124,894.18 185,935.00 175,626.00 EXPENDITURES TOTALS: 0.00 165,980.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 125,144.84 124,894.18 185,935.00 175,626.00 DEPT EXPENSES 0.00 165,980.00 0.00 0.00 0.00 (125,144.84) (124,894.18) (185,935.00) (175,626.00) Assessment District Totals: 0.00 (165,980.00) 0.00 0.00 0.00 498 Transfer Out
GL-BudgetAnalysis (5/20/2022 - 9:58 AM) Page2
-178-
1028
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 119,406.11 140,020.50 149,964.00 149,926.00 FUND REVENUES 0.00 157,404.00 0.00 0.00 0.00 125,144.84 124,894.18 185,935.00 175,626.00 FUND EXPENSES 0.00 165,980.00 0.00 0.00 0.00 (5,738.73) 15,126.32 (35,971.00) (25,700.00) MISSION ESTATES AD#l2 FUNI 0.00 (8,576.00) 0.00 0.00 0.00 119,406.11 140,020.50 149,964.00 149,926.00 REPORT REVENUES 0.00 157,404.00 0.00 0.00 0.00 125,144.84 124,894.18 185,935.00 175,626.00 REPORT EXPENSES 0.00 165,980.00 0.00 0.00 0.00 =========== :::::::::::
(5,738 .73) 15,126.32 (35,971.00) (25,700.00) REPORT TOTALS: 0.00 (8,576.00) 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022- 9:58 AM) Page3
-179-
1029
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual

0.00 0.00

0.00 30,839.83
30,839.83
593.90
116.82

0.00 710.72
31,550.55
314.11
379.44

0.00 527.76
703.08
7,889.33

36.10 188.19
swilliams
05/20/2022 - 9:58AM
2023
2021
Actual

0.00 0.00

0.00 34,872.52
34,872.52
146.54
(80.34)

0.00 66.20
34,938.72
345.70-
388.11

0.00 543.12
718.38
7,923.16

0.00 0.00
GL-BudgetAnalysis (5/20/2022 - 9:58 AM)
2022 2022
Adopted Estimated Account
283
R03

0.00 0.00 331-010

0.00 0.00 334-010

0.00 0.00
R06
36,000.00 36,000.00 355-020
36,000.00 36,000.00
R07
125.00 35.00 361-010

0.00 -5.00 362-010

0.00 0.00 369-000
125.00 30.00
36,125.00 36,030.00
458
E03
323.00 323.00 200-202
468.00 468.00 200-204
500.00 0.00 200-210
570.00 570.00 200-213
724.00 724.00 200-220
10,000.00 10,000.00 200-221

0.00 0.00 200-223
200.00 0.00 200-224
LOsBanos
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
SOMERSET PARKAD#l3 FUND
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Assessments
Landscape & Lighting Assessmen 0.00 39,600.00 0.00 0.00 0.00 Assessments Totals: 0.00 39,600.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 25.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 25.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 39,625.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 492.00 0.00 0.00 0.00
Fleet Services 0.00 736.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 500.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 650.00 0.00 0.00 0.00
Landscape Maintenance 0.00 724.00 0.00 0.00 0.00
Park Maintenance 0.00 10,000.00 0.00 0.00 0.00
Storm Drain Maintenance 0.00 0.00 0.00 0.00 0.00
Street Sign Maintenance 0.00 200.00 0.00 0.00 0.00

-180-
1030
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 1,500.00 1,500.00 200-225 Street Tree Maintenance 0.00 1,500.00 0.00 0.00 0.00 243.94 248.91 250.00 250.00 200-226 Fence Maintenance 0.00 250.00 0.00 0.00 0.00 1,297.79 1,287.79 1,554.00 1,463.00 200-230 Administrative Services 0.00 1,816.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-231 Professional Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00 420.85 499.60 500.00 400.00 200-263 Street Light Maintenance 0.00 500.00 0.00 0.00 0.00 4,522.83 4,468.22 4,812.00 4,300.00 200-264 Electricity & Gas 0.00 4,600.00 0.00 0.00 0.00 504.73 545.75 590.00 590.00 200-265 Gasoline & Oil 0.00 655.00 0.00 0.00 0.00 17,028.15 16,968.74 21 ,991.00 20,588.00 Supplies & Services Totals: 0.00 25,423.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 0.00 0.00 200-714 Storm Drain Improvements 0.00 0.00 0.00 0.00 0.00 15,106.63 20,000.00 0.00 0.00 200-717 Landscape & Irrigation 0.00 13,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00 15,106.63 20,000.00 0.00 0.00 Capital Outlay Totals: 0.00 13,000.00 0.00 0.00 0.00 E08 Charge Ins - Outs
11,591.48 11,430.47 12,479.00 11,678.00 200-820 Charge In 0.00 13,687.00 0.00 0.00 0.00 11,591.48 11,430.47 12,479.00 11,678.00 Charge Ins - Outs Totals: 0.00 13,687.00 0.00 0.00 0.00 EI0 Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 43,726.26 48,399.21 34,470.00 32,266.00 EXPENDITURES TOTALS: 0.00 52,110.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 43,726.26 48,399.21 34,470.00 32,266.00 DEPT EXPENSES 0.00 52,110.00 0.00 0.00 0.00 (43,726.26) (48,399.2 I) (34,470.00) (32,266.00) Assessment District Totals: 0.00 (52,110.00) 0.00 0.00 0.00 498 Transfer Out
E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:58 AM) Pagel
-181-
1031
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 31,550.55 34,938.72 36,125.00 36,030.00 FUND REVENUES 0.00 39,625.00 0.00 0.00 0.00 43,726.26 48,399.21 34,470.00 32,266.00 FUND EXPENSES 0.00 52,110.00 0.00 0.00 0.00 (12,175.71) (13,460.49) 1,655.00 3,764.00 SOMERSET PARK AD#l3 FUND 0.00 (12,485.00) 0.00 0.00 0.00 31,550.55 34,938.72 36,125.00 36,030.00 REPORT REVENUES 0.00 39,625.00 0.00 0.00 0.00 43,726.26 48,399.21 34,470.00 32,266.00 REPORT EXPENSES 0.00 52,110.00 0.00 0.00 0.00 (12,175.71) (13,460.49) 1,655.00 3,764.00 REPORT TOTALS: 0.00 (12,485.00) 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:58 AM) Page3
-182-
1032
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual

0.00 0.00

0.00 282,753.69
282,753.69
1,167.81
214.35

0.00 1,382.16

64.16 64.16
284,200.01
1,047.94
1,265.41
4,874.26
27,116.52
11,773.44
swilliams
05/20/2022 - 9:59AM
2023
2021
Actual

0.00 0.00

0.00 271,599.17
271,599.17
341.02
(199.50)

0.00 141.52

0.00 0.00
271,740.69
1,152.34
1,294.31
4,500.39
39,158.54
13,746.03'
GL-BudgetAnalysis (S/20/2022 - 9:59 AM)
2022 2022
Adopted Estimated Account
284
R03

0.00 0.00 331-010

0.00 0.00 334-010

0.00 0.00
R06
299,113.00 299,113.00 355-020
299,113.00 299,113.00
R07
150.00 80.00 361-010

0.00 -1.00 362-010

0.00 0.00 369-000
150.00 79.00
ROS

0.00 0.00 390-010

0.00 0.00
299,263.00 299,192.00
458
E03
1,077.00 1,077.00 200-202
1,558.00 1,558.00 200-204
5,000.00 5,000.00 200-210
38,800.00 38,800.00 200-213
13,844.00 13,844.00 200-220
tOsBanos
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
NORTHGATE@REGENCY AD#
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Assessments
Landscape & Lighting Assessmcn 0.00 329,038.00 0.00 0.00 0.00 Assessments Totals: 0.00 329,038.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 50.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 50.00 0.00 0.00 0.00
Miscellaneous
Misc Revenues 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 329,088.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 1,640.00 0.00 0.00 0.00 Fleet Services 0.00 2,452.00 0.00 0.00 Q.00
Sidewalk Maintenance 0.00 5,000.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 41,000.00 0.00 0.00 0.00 Landscape Maintenance 0.00 13,844.00 0.00 0.00 0.00

-183-
1033
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 26,806.81 22,274.09 25,000.00 25,000.00 200-221 Park Maintenance 0.00 27,000.00 0.00 0.00 0.00

36.10 86.95 200.00 200.00 200-223 Storm Drain Maintenance 0.00 200.00 0.00 0.00 0.00 499.53 455.15 500.00 350.00 200-224 Street Sign Maintenance 0.00 500.00 0.00 0.00 0.00 500.00 500.00 500.00 500.00 200-225 Street Tree Maintenance 0.00 1,000.00 0.00 0.00 0.00 241.12 248.91 250.00 250.00 200-226 Fence Maintenance 0.00 250.00 0.00 0.00 0.00 12,201.66 12,597.45 13,362.00 12,699.00 200-230 Administrative Services 0.00 13,902.00 0.00 0.00 0.00 20,851.32 21,304.92 21,457.00 21,457.00 200-231 Professional Services 0.00 21,457.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00 1,956.96 1,992.85 2,000.00 2,000.00 200-263 Street Light Maintenance 0.00 2,000.00 0.00 0.00 0.00 26,787.99 27,145.00 29,000.00 23,000.00 200-264 Electricity & Gas 0.00 25,000.00 0.00 0.00 0.00 1,681.54 1,821.62 1,968.00 1,968.00 200-265 Gasoline & Oil 0.00 2,185.00 0.00 0.00 0.00 137,640.60 148,278.55 154,516.00 147,703.00 Supplies & Services Totals: 0.00 160,230.00 0.00 0.00 0.00 BOS Capital Outlay

0.00 0.00 0.00 0.00 200-717 Landscape & Irrigation 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Capital Outlay Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs
131,438.20 129,528.34 141,426.00 132,347.00 200-820 Charge In 0.00 155,124.00 0.00 0.00 0.00 131,438.20 129,528.34 141,426.00 132,347.00 Charge Ins - Outs Totals: 0.00 155,124.00 0.00 0.00 0.00 BIO Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 269,078.80 277,806.89 295,942.00 280,050.00 EXPENDITURES TOTALS: 0.00 315,354.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 269,078.80 277,806.89 295,942.00 280,050.00 DEPT EXPENSES 0.00 315,354.00 0.00 0.00 0.00 (269,078.80) (277,806.89) (295,942.00) (280,050.00) Assessment District Totals: 0.00 (315,354.00) 0.00 0.00 0.00 498 Transfer Out
GL-Budget Analysis (5/20/2022 - 9:59 AM) Page2
-184-
1034
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 284,200.01 271 ,740.69 299,263.00 299,192.00 FUND REVENUES 0.00 329,088.00 0.00 0.00 0.00 269,078.80 277,806.89 295,942.00 280,050.00 FUND EXPENSES 0.00 315,354.00 0.00 0.00 0.00 15,121.21 (6,066.20) 3,321.00 19,142.00 NORTHGATE@ REGENCY AD# 0.00 13,734.00 0.00 0.00 0.00 284,200.01 271,740.69 299,263.00 299,192.00 REPORT REVENUES 0.00 329,088.00 0.00 0.00 0.00 269,078.80 277,806.89 295,942.00 280,050.00 REPORT EXPENSES 0.00 315,354.00 0.00 0.00 0.00 15,12 1.21 (6,066.20) 3,321.00 19,142.00 REPORT TOTALS: 0.00 13,734.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:59 AM) Page3
-185-
1035
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual
11,611.27
11,611.27

28.00 0.00

0.00 28.00
11,639.27
314.11
379.44

0.00 1,232.56
403.08
321.50

0.00 0.00

77.05 0.00

0.00 218.30

0.00 swilliams
05/20/2022 - 9:59AM
2023
2021
Actual
11,611.27
11,611.27

11.98 (6.66)

0.00 5.32
11,616.59
345.70
388.11

0.00 1,700.13
411.81

0.00 0.00

0.00 0.00

0.00 0.00
227.70

0.00 GL-Budget Analysis (5/20/2022 - 9:59 AM)
2022 2022
Adopted Estimated Account
285
R06
12,022.00 12,022.00 355-020
12,022.00 12,022.00
R07

8.00 5.00 361-010

0.00 -2.00 362-010

0.00 0.00 369-000

8.00 3.00
12,030.00 12,025.00
458
E03
323.00 323.00 200-202
467.00 467.00 200-204
200.00 0.00 200-210
1,820.00 1,820.00 200-213
415.00 415.00 200-220
1,500.00 1,500.00 200-221

0.00 0.00 200-222

0.00 0.00 200-223
100.00 0.00 200-224

0.00 0.00 200-225

0.00 0.00 200-226
330.00 300.00 200-230

0.00 0.00 200-231
LOsBanos
· du: Cms~ma11s of C'1lffmnia
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
MAGNOLIA GROVE AD#15 Filli
Assessments
Landscape & Lighting Assessmen 0.00 13,225.00 0.00 0.00 0.00 Assessments Totals: 0.00 13,225.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 5.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 5.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 13,230.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 492.00 0.00 0.00 0.00
Fleet Services 0.00 736.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 200.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 2,000.00 0.00 0.00 0.00
Landscape Maintenance 0.00 415.00 0.00 0.00 0.00
Park Maintenance 0.00 1,500.00 0.00 0.00 0.00
A.D. Park Facility Maint. 0.00 0.00 0.00 0.00 0.00
Storm Drain Maintenance 0.00 0.00 0.00 0.00 0.00
Street Sign Maintenance 0.00 100.00 0.00 0.00 0.00
Street Tree Maintenance 0.00 0.00 0.00 0.00 0.00
Fence Maintenance 0.00 0.00 0.00 0.00 0.00
Administrative Services 0.00 515.00 0.00 0.00 0.00
Professional Services 0.00 0.00 0.00 0.00 0.00

-186-
1036
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-253 Advertising 0.00 0.00 0.00 0.00 0.00 134.96 143.35 150.00 0.00 200-263 Street Light Maintenance 0.00 150.00 0.00 0.00 0.00 1,228.44 1,258.82 1,500.00 1,200.00 200-264 Electricity & Gas 0.00 1,300.00 0.00 0.00 0.00 504.73 545.75 591.00 591.00 200-265 Gasoline & Oil 0.00 655.00 0.00 0.00 0.00 4,814.17 5,021.37 7,396.00 6,616.00 Supplies & Services Totals: 0.00 10,863.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 0.00 0.00 200-717 Landscape & Irrigation 0.00 10,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Capital Outlay Totals: 0.00 10,000.00 0.00 0.00 0.00 E06 Interest - Debt Service

0.00 0.00 0.00 0.00 200-821 Principal - Lease/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Interest - Debt Service Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs

0.00 0.00 0.00 0.00 200-820 Charge In 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Charge Ins - Outs Totals: 0.00 0.00 0.00 0.00 0.00 ElO Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 4,814.17 5,021.37 7,396.00 6,616.00 EXPENDITURES TOTALS: 0.00 20,863.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 4,814.17 5,021.37 7,396.00 6,616.00 DEPT EXPENSES 0.00 20,863.00 0.00 0.00 0.00 (4,814.17) (5,021.37) (7,396.00) (6,616.00) Assessment District Totals: 0.00 (20,863.00) 0.00 0.00 0.00 11,639.27 11,616.59 12,030.00 12,025.00 FUND REVENUES 0.00 13,230.00 0.00 0.00 0.00 4,814.17 5,021.37 7,396.00 6,616.00 FUND EXPENSES 0.00 20,863.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 9:59 AM) Page2
-187-
1037
2020
Actual
6,825.10
11 ,639.27
4,814.17
6,825.10
2021
Actual
6,595.22
11,616.59
5,021.37
6,595.22
GL-BudgetAnalysis (5/20/2022 - 9:59 AM)
2022
Adopted
4,634.00
12,030.00
7,396.00
4,634.00
2022
Estimated Account
5,409.00
12,025.00
6,616.00
5,409.00
Description
MAGNOLIA GROVE AD#l5 Fl.11'

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-188-
FTE

0.00 0.00

0.00 0.00
2023
Requested
(7,633.00)
13,230.00
20,863.00
(7,633.00)
2023
Proposed

0.00 0.00

0.00 0.00
2023
Approved

0.00 0.00

0.00 0.00
2023
Adopted

0.00 0.00

0.00 0.00
Page3
1038
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual

0.00 0.00

0.00 13,760.14
13,760.14
118.19

21.89 0.00
140.08
13,900.22
314.11
379.44

0.00 1,196.04
2,000.00

0.00 0.00
500.00
swilliams
05/20/2022 - 9:59AM
2023
2021
Actual

0.00 0.00

0.00 13,760.14
13,760.14

33.50 (25.82)

0.00 7.68
13,767.82
345.70
388.11

0.00 1,222.14
2,000.00

0.00 0.00

0.00 GL-BudgetAnalysis (5/20/2022 - 9:59 AM)
2022 2022
Adopted Estimated Account
286
R03

0.00 0.00 331-010

0.00 0.00 334-010

0.00 0.00
R06
14,553.00 14,553.00 355-020
14,553.00 14,553.00
R07

25.00 15.00 361-010

0.00 -2.00 362-010

0.00 0.00 369-000

25.00 13.00
14,578.00 14,566.00
458
E03
323.00 323.00 200-202
467.00 467.00 200-204

0.00 0.00 200-210
1,231.00 1,231.00 200-220
2,000.00 2,000.00 200-221

0.00 0.00 200-223

0.00 0.00 200-224

0.00 0.00 200-225
rOsBanos
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
SENIOR VILLAGES AD#l 6 FUNJ
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Assessments
Landscape & Lighting Assessmen 0.00 16,007.00 0.00 0.00 0.00 Assessments Totals: 0.00 16,007.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 15.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 15.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 16,022.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 492.00 0.00 0.00 0.00
Fleet Services 0.00 736.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 0.00 0.00 0.00 0.00
Landscape Maintenance 0.00 1,231.00 0.00 0.00 0.00
Park Maintenance 0.00 3,000.00 0.00 0.00 0.00
Storm Drain Maintenance 0.00 0.00 0.00 0.00 0.00
Street Sign Maintenance 0.00 0.00 0.00 0.00 0.00
Street Tree Maintenance 0.00 500.00 0.00 0.00 0.00

-189-
1039
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

42.52 50.00 50.00 50.00 200-226 Fence Maintenance 0.00 50.00 0.00 0.00 0.00 484.01 469.60 496.00 476.00 200-230 Administrative Services 0.00 730.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-231 Professional Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00

0.00 92.70 100.00 78.00 200-263 Street Light Maintenance 0.00 100.00 0.00 0.00 0.00 1,393.09 1,436.05 1,670.00 1,400.00 200-264 Electricity & Gas 0.00 1,500.00 0.00 0.00 0.00 504.73 545.75 590.00 590.00 200-265 Gasoline & Oil 0.00 655.00 0.00 0.00 0.00 6,813.94 6,550.05 6,927.00 6,615.00 Supplies & Services Totals: 0.00 11,794.00 0.00 0.00 0.00 E05 Capital Outlay
6,985.00 0.00 8,000.00 8,000.00 200-717 Landscape & Irrigation 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00 6,985.00 0.00 8,000.00 8,000.00 Capital Outlay Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs
3,859.83 3,805.83 4,160.00 3,893.00 200-820 Charge In 0.00 4,562.00 0.00 0.00 0.00 3,859.83 3,805.83 4,160.00 3,893.00 Charge Ins - Outs Totals: 0.00 4,562.00 0.00 0.00 0.00 ElO Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 17,658.77 10,355.88 19,087.00 18,508.00 EXPENDITURES TOTALS: 0.00 16,356.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 17,658.77 10,355.88 19,087.00 18,508.00 DEPT EXPENSES 0.00 16,356.00 0.00 0.00 0.00 (17,658.77) (10,355.88) (19,087.00) (18,508.00) Assessment District Totals: 0.00 (16,356.00) 0.00 0.00 0.00 498 Transfer Out
E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:59 AM) Page2
-190-
1040
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 13,900.22 13,767.82 14,578.00 14,566.00 FUND REVENUES 0.00 16,022.00 0.00 0.00 0.00 17,658.77 10,355.88 19,087.00 18,508.00 FUND EXPENSES 0.00 16,356.00 0.00 0.00 0.00 (3,758.55) 3,411.94 (4,509.00) (3,942.00) SENIOR VILLAGES AD#l6 FUN! 0.00 (334.00) 0.00 0.00 0.00 13,900.22 13,767.82 14,578.00 14,566.00 REPORT REVENUES 0.00 16,022.00 0.00 0.00 0.00 17,658.77 10,355.88 19,087.00 18,508.00 REPORT EXPENSES 0.00 16,356.00 0.00 0.00 0.00 (3,758.55) 3,411.94 (4,509.00) (3,942.00) REPORT TOTALS: 0.00 (334.00) 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:59 AM) Page3
-191-
1041
General Ledger
Budget Analysis
User: swilliarns
Printed: 05/20/2022 - 9:59AM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 0.00

0.00 0.00

0.00 0.00
332,150.45 394,600.34
332,150.45 394,600.34
1,110.08 557.63
233.24 (457.03)

0.00 0.00
1,343.32 100.60

0.00 0.00

0.00 0.00

0.00 0.00
333,493.77 394,700.94
629.12 691.40
758.89 776.22
4,904.23 4,491.82
48,738.12 50,997.63
GL-Budget Analysis (5/20/2022 - 9:59 AM)
2022 2022
Adopted Estimated Account
287
R03

0.00 0.00 331-010

0.00 0.00 334-010

0.00 0.00
R06
469,391.00 469,391.00 355-020
469,391.00 469,391.00
R07
100.00 100.00 361-010

0.00 -10.00 362-010

0.00 0.00 369-000
100.00 90.00
ROS

0.00 0.00 390-010

0.00 0.00 390-040

0.00 0.00
469,491.00 469,481.00
458
E03
646.00 646.00 200-202
935.00 935.00 200-204
4,500.00 3,479.00 200-210
53,510.00 53,510.00 200-213
rOsBanos
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
STONE CREEK VLLGE AD#l 7 F
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Assessments
Landscape & Lighting Assessmen 0.00 481,233.00 0.00 0.00 0.00 Assessments Totals: 0.00 481,233.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 100.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 100.00 0.00 0.00 0.00
Miscellaneous
Misc Revenues 0.00 0.00 0.00 0.00 0.00
Insurance Proceeds 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 481,333.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 984.00 0.00 0.00 0.00
Fleet Services 0.00 1,472.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 4,500.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 58,000.00 0.00 0.00 0.00 Pagel
-192-
1042
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 15,006.00 31,578.21 31,803.00 31,803.00 200-220 Landscape Maintenance 0.00 31,803.00 0.00 0.00 0.00 19,871.87 22,237.11 30,000.00 30,000.00 200-221 Park Maintenance 0.00 43,000.00 0.00 0.00 0.00 3,014.30 1,398.44 0.00 0.00 200-223 Storm Drain Maintenance 0.00 0.00 0.00 0.00 0.00 499.53 910.31 1,000.00 900.00 200-224 Street Sign Maintenance 0.00 1,000.00 0.00 0.00 0.00 2,000.00 2,000.00 2,000.00 2,000.00 200-225 Street Tree Maintenance 0.00 2,000.00 0.00 0.00 0.00 289.03 444.07 450.00 450.00 200-226 Fence Maintenance 0.00 450.00 0.00 0.00 0.00 13,576.24 13,524.69 14,535.00 14,348.00 200-230 Administrative Services 0.00 16,205.00 0.00 0.00 0.00 15,778.68 16,121.85 16,237.00 16,237.00 200-231 Professional Services 0.00 16,237.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00

94.12 138.13 273.00 256.00 200-250 Insurance 0.00 220.00 0.00 0.00 0.00 991.80 999.20 1,000.00 979.00 200-263 Street Light Maintenance 0.00 1,000.00 0.00 0.00 0.00 22,108.85 21,325.08 22,150.00 27,350.00 200-264 Electricity & Gas 0.00 30,000.00 0.00 0.00 0.00 1,008.57 1,092.42 1,180.00 1,180.00 200-265 Gasoline & Oil 0.00 1,311.00 0.00 0.00 0.00 149,269.35 168,726.58 180,219.00 184,073.00 Supplies & Services Totals: 0.00 210,982.00 0.00 0.00 0.00 E05 Capital Outlay
18,684.34 0.00 0.00 0.00 200-714 Storm Drain Improvements 0.00 0.00 0.00 0.00 0.00

0.00 31,504.20 70,000.00 64,800.00 200-717 Landscape & Irrigation 0.00 70,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-747 Park & Playground Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00 18,684.34 31,504.20 70,000.00 64,800.00 Capital Outlay Totals: 0.00 70,000.00 0.00 0.00 0.00 E08 Charge Ins - Outs
131,438.20 129,528.34 141 ,426.00 132,347.00 200-820 Charge In 0.00 155,124.00 0.00 0.00 0.00 131,438.20 129,528.34 141,426.00 132,347.00 Charge Ins - Outs Totals: 0.00 155,124.00 0.00 0.00 0.00 El0 Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 299,391.89 329,759.12 391,645.00 381,220.00 EXPENDITURES TOTALS: 0.00 436,106.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:59 AM) Page2
-193-
1043
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FfE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 299,391.89 329,759.12 391,645.00 381,220.00 DEPT EXPENSES 0.00 436,106.00 0.00 0.00 0.00 (299,391.89) (329,759.12) (391 ,645.00) (381,220.00) Assessment District Totals: 0.00 (436,106.00) 0.00 0.00 0.00 498 Transfer Out
E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 333,493.77 394,700.94 469,491.00 469,481.00 FUND REVENUES 0.00 481,333.00 0.00 0.00 0.00 299,391.89 329,759.12 391,645.00 381,220.00 FUND EXPENSES 0.00 436,106.00 0.00 0.00 0.00 34,101.88 64,941.82 77,846.00 88,261.00 STONE CREEK VLLGE AD#l 7 F 0.00 45,227.00 0.00 0.00 0.00 333,493.77 394,700.94 469,491.00 469,481.00 REPORT REVENUES 0.00 481,333.00 0.00 0.00 0.00 299,391.89 329,759.12 391,645.00 381,220.00 REPORT EXPENSES 0.00 436,106.00 0.00 0.00 0.00 34,101.88 64,941.82 77,846.00 88,261.00 REPORT TOTALS: 0.00 45,227.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 9:59 AM) Page3
-194-
1044
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 9:59AM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 0.00

0.00 0.00

0.00 0.00
111,681.95 II4,920.81
111,681.95 114,920.81
1,273.92 348.16
251.55 (218.26)

0.00 0.00
1,525.47 129.90

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00
113,207.42 115,050.71
629.12 691.40
GL-BudgetAnalysis (5/20/2022 - 9:59 AM)
2022 2022
Adopted Estimated Account
288
R03

0.00 0.00 331-010

0.00 0.00 334-010

0.00 0.00
R06
120,648.00 120,648.00 355-020
120,648.00 120,648.00
R07
200.00 125.00 361-010

0.00 -14.00 362-010

0.00 0.00 369-000
200.00 lll.00
ROS

0.00 0.00 390-010

0.00 0.00 390-020

0.00 0.00
R09

0.00 0.00 499-000

0.00 0.00
120,848.00 120,759.00
458
E03
646.00 646.00 200-202
LOsBanos
41 the Cm~smads of Californfo
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
RAIL TRAIL CORDOR AD#l 8 Fl
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Assessments
Landscape & Lighting Assessmen 0.00 77,272.00 0.00 0.00 0.00 Assessments Totals: 0.00 77,272.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 100.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 100.00 0.00 0.00 0.00
Miscellaneous
Misc Revenues 0.00 0.00 0.00 0.00 0.00
Refunds 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
Transfer Ins
Transfer In 0.00 0.00 0.00 0.00 0.00
Transfer Ins Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 77,372.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 984.00 0.00 0.00 0.00
Page I
-195-
1045
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 758.89 776.22 935.00 935.00 200-204 Fleet Services 0.00 1,472.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-210 Sidewalk Maintenance 0.00 0.00 0.00 0.00 0.00 8,123.34 8,581.97 10,500.00 8,000.00 200-213 Water Sewerage & Disposal 0.00 5,000.00 0.00 0.00 0.00 10,502.28 10,730.70 10,807.00 10,807.00 200-220 Landscape Maintenance 0.00 10,807.00 0.00 0.00 0.00 29,588.98 26,681.05 25,000.00 25,000.00 200-221 Park Maintenance 0.00 25,000.00 0.00 0.00 0.00 173.40 11 ,575.95 0.00 0.00 200-224 Street Sign Maintenance 0.00 0.00 0.00 0.00 0.00 5,000.00 5,000.00 5,000.00 5,000.00 200-225 Street Tree Maintenance 0.00 5,000.00 0.00 0.00 0.00 3,595.62 4,032.81 3,596.00 3,427.00 200-230 Administrative Services 0.00 3,567.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-231 Professional Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-250 Insurance 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-255 Street Tree Maintenance 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-263 Street Light Maintenance 0.00 0.00 0.00 0.00 0.00 4,449.41 4,535.10 5,350.00 5,000.00 200-264 Electricity & Gas 0.00 5,500.00 0.00 0.00 0.00 1,008.57 1,092.42 1,180.00 1,180.00 200-265 Gasoline & Oil 0.00 1,311.00 0.00 0.00 0.00 63,829.61 73,697.62 63,014.00 59,995.00 · Supplies & Services Totals: 0.00 61,441.00 0.00 0.00 0.00 ·.E05 Capital Outlay
16,109.56 17,558.57 0.00 0.00 200-717 Landscape & Irrigation 0.00 0.00 0.00 0.00 0.00

0.00 0.00 40,000.00 34,500.00 200-718 Sidewalk Improvements 0.00 50,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00 16,109.56 17,558.57 40,000.00 34,500.00 Capital Outlay Totals: 0.00 50,000.00 0.00 0.00 0.00 EOS Charge Ins - Outs
15,463.32 15,236.35 16,638.00 15,570.00 200-820 Charge In 0.00 18,250.00 0.00 0.00 0.00 15,463.32 15,236.35 16,638.00 15,570.00 Charge Ins - Outs Totals: 0.00 18,250.00 0.00 0.00 0.00 EIO Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 95,402.49 106,492.54 119,652.00 110,065.00 EXPENDITURES TOTALS: 0.00 129,691.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 9:59 AM) Page2
-196-
1046
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 95,402.49 106,492.54 119,652.00 110,065.00 DEPT EXPENSES 0.00 129,691.00 0.00 0.00 0.00 (95,402.49) (106,492.54) (119,652.00) (110,065.00) Assessment District Totals: 0.00 (129,691.00) 0.00 0.00 0.00 113,207.42 115,050.71 120,848.00 120,759.00 FUND REVENUES 0.00 77,372.00 0.00 0.00 0.00 95,402.49 106,492.54 119,652.00 110,065.00 FUND EXPENSES 0.00 129,691.00 0.00 0.00 0.00 17,804.93 8,558.17 1,196.00 10,694.00 RAIL TRAILCORDORAD#18 Fl 0.00 (52,319.00) 0.00 0.00 0.00 113,207.42 115,050.71 120,848.00 120,759.00 REPORT REVENUES 0.00 77,372.00 0.00 0.00 0.00 95,402.49 106,492.54 119,652.00 110,065.00 REPORT EXPENSES 0.00 129,691.00 0.00 0.00 0.00 17,804.93 8,558.17 1,196.00 10,694.00 REPORT TOTALS: 0.00 (52,319.00) 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 9:59 AM) Page3
-197-
1047
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual
66,924.50
66,924.50
144.69

0.00 0.00
144.69

0.00 0.00
67,069.19
524.42
632.70

0.00 22,555.26

0.00 4,891.12

0.00 0.00

0.00 swilliams
0S/20/2022 - 1 0:00AM
2023
2021
Actual
73,622.32
73,622.32
l00.J l

0.00 0.00
100.11

0.00 0.00
73,722.43
576.17
647.15

0.00 6,882.23

0.00 4,842.31

0.00 0.00

0.00 GL-BudgetAnalysis (5/20/2022 - 10:00 AM)
2022 2022
Adopted Estimated Account
289
R06
81 ,044.00 81,044.00 355-020
81 ,044.00 81,044.00
R07
100.00 20.00 361-010

0.00 0.00 362-010

0.00 0.00 369-000
100.00 20.00
ROS

0.00 0.00 390-010

0.00 0.00
81,144.00 81,064.00
458
E03
539.00 539.00 200-202
779.00 779.00 200-204
300.00 0.00 200-210
16,560.00 1,000.00 200-213

0.00 0.00 200-220
6,000.00 6,000.00 200-221

0.00 0.00 200-222
200.00 200.00 200-223
300.00 0.00 200-224
LOsBanos

4.1 d1r Cros~n,ali; of Ced if orni<t
2023 2023 2023 2023
Description FI'E Requested Proposed Approved Adopted
TALBOTI PARKAD#\9 FUND
Assessments
Landscape & Lighting Assessmen 0.00 90,548.00 0.00 0.00 0.00 Assessments Totals: 0.00 90,548.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 20.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 20.00 0.00 0.00 0.00
Miscellaneous
Misc Revenues 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 90,568.00 0.00 0.00 0.00
Assessment District
Supplies & Services
Fleet Repair & Maintenance 0.00 820.00 0.00 0.00 0.00
Fleet Services 0.00 1,226.00 0.00 0.00 0.00
Sidewalk Maintenance 0.00 300.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 3,000.00 0.00 0.00 0.00
Landscape Maintenance 0.00 0.00 0.00 0.00 0.00
Park Maintenance 0.00 7,000.00 0.00 0.00 0.00
A.O. Park Facility Maint. 0.00 0.00 0.00 0.00 0.00
Storm Drain Maintenance 0.00 200.00 0.00 0.00 0.00
Street Sign Maintenance 0.00 300.00 0.00 0.00 0.00

-198-
1048
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 200-225 Street Tree Maintenance 0.00 5,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-226 Fence Maintenance 0.00 0.00 0.00 0.00 0.00 2,770.55 2,057.90 2,683.00 1,902.00 200-230 Administrative Services 0.00 2,546.00 0.00 0.00 0.00 16,818.60 17,184.36 17,307.00 17,307.00 200-231 Professional Services 0.00 17,307.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-235 City Engineer 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-238 Technical Services 0.00 2,800.00 0.00 0.00 0.00 1,170.20 1,215.91 1,450.00 1,450.00 200-263 Street Light Maintenance 0.00 1,450.00 0.00 0.00 0.00 3,162.11 3,440.59 4,000.00 4,000.00 200-264 Elecll'icity & Gas 0.00 4,500.00 0.00 0.00 0.00 841.22 910.81 984.00 984.00 200-265 Gasoline & Oil 0.00 1,093.00 0.00 0.00 0.00 53,366.18 37,757.43 51 ,102.00 34,161.00 Supplies & Services Totals: 0.00 47,542.00 0.00 0.00 0.00 E0S Capital Outlay

0.00 0.00 0.00 0.00 200-714 Storm Drain Improvements 0.00 30,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 200-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Capital Outlay Totals: 0.00 30,000.00 0.00 0.00 0.00 E08 Charge Ins - Outs
7,731.67 7,624.62 8,319.00 7,785.00 200-820 Charge In 0.00 9,125.00 0.00 0.00 0.00 7,731.67 7,624.62 8,319.00 7,785.00 Charge Ins - Outs Totals: 0.00 9,125.00 0.00 0.00 0.00 EI0 Contingency

0.00 0.00 0.00 0.00 200-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Contingency Totals: 0.00 0.00 0.00 0.00 0.00 61,097.85 45,382.05 59,421.00 41,946.00 EXPENDITURES TOTALS: 0.00 86,667.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 61,097.85 45,382.05 59,421.00 41,946.00 DEPT EXPENSES 0.00 86,667.00 0.00 0.00 0.00 (61,097.85) (45,382.05) (59,421.00) (41,946.00) Assessment Disll'ict Totals: 0.00 (86,667.00) 0.00 0.00 0.00 67,069.19 73,722.43 81,144.00 81,064.00 FUND REVENUES 0.00 90,568.00 0.00 0.00 0.00 61,097.85 45,382.05 59,421.00 41,946.00 FUND EXPENSES 0.00 86,667.00 0.00 0.00 0.00 GL-Budget Analysis (S/20/2022 - 10:00 AM) Page2
-199-
1049
2020
Actual
5,971.34
67,069.19
61 ,097.85
5,971.34
2021
Actual
28,340.38
73,722.43
45,382.05
28,340.38
GL-Budget Analysis (S/20/2022 - 10:00 AM)
2022
Adopted
21,723.00
81,144.00
59,421.00
21,723.00
2022
Estimated Account
39,118.00
81,064.00
41,946.00
39,118.00
Description
TALBOTT PARK AD#l 9 FUND T,

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-200-
FTE

0.00 0.00

0.00 0.00
2023
Requested
3,901.00
90,568.00
86,667.00
3,901.00
2023
Proposed

0.00 0.00

0.00 0.00
2023
Approved

0.00 0.00

0.00 0.00
2023
Adopted

0.00 0.00

0.00 0.00
Page3
1050

ENTERPRISE FUNDS
1051
General Ledger
Budget Analysis
User: k:tomas
Printed: 05/02/2022- 3:31PM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 32,842.00

0.00 32,842.00
5,686,245.24 6,352,968.53
155,579.45 164,644.05

0.00 0.00
1,314,127.73 1,729,108.19

0.00 0.00
7,155,952.42 8,246,720.77
(15.00) 0.00
(15.00) 0.00
438,985.91 133,251.11

0.00 0.00
95,331.09 (99,212.94)
465,396.13 637,285.00

0.00 0.00

0.00 0.00
999,713.13 671,323.17
177,923.37 262,162.86
GL-BudgetAnalysis (5/2/2022 - 3:31 PM) 1
2022 2022
Adopted Estimated Account
501
R03

0.00 0.00 331-050

0.00 0.00
R04
6,081,508.00 6,567,426.00 343-010
155,000.00 268,000.00 343-015

0.00 0.00 343-020
1,000,000.00 1,250,000.00 343-025

0.00 0.00 343-050
7,236,508.00 8,085,426.00
ROS

0.00 0.00 351-011

0.00 0.00
R07
150,000.00 52,941.00 361-010

0.00 1 0.00 361-050
o.oo : 0.00 362-010

0.00 0.00 365-050

0.00 0.00 369-000

0.00 0.00 396-030
150,000.00 52,941.00
ROS
85,000.00 175,000.00 390-010
Lityof B os .anos
Al tfo:· Crossroads of Gllffornia
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

WATER FUND
Shared Revenues
CARES Act Funding 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Charges for Services
Water Fees Collected 0.00 6,698,775.00 0.00 0.00 0.00
Penalties 0.00 165,000.00 0.00 0.00 0.00
Water Development Fees 0.00 0.00 0.00 0.00 0.00
Water Connection Fee 0.00 1,000,000.00 0.00 0.00 0.00
Water Contribution Fees 0.00 0.00 0.00 0.00 0.00
Charges for Services Totals: 0.00 7,863,775.00 0.00 0.00 0.00 Fines & Fees
Water Admn Cit Fees 0.00 0.00 0.00 0.00 0.00
Fines & Fees Totals: 0.00 0.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 45,000.00 0.00 0.00 0.00
Interest Restrict LAIF 0.00 0.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Devlop. Contrib. Infrastr 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Fiscal Agent-Restricted Eamin 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 45,000.00 0.00 0.00 0.00 Miscellaneous
Misc Revenues 0.00 100,000.00 0.00 0.00 0.00
Page I
-201-
1052
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 15,346.48 0.00 0.00 390-020 Refunds 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 390-030 Reimbursement - Chromium 6 0.00 0.00 0.00 0.00 0.00 15,997.41 0.00 0.00 0.00 392-010 Sale-Fixed Assets 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 399-020 Other Financial Sources 0.00 0.00 0.00 0.00 0.00 193,920.78 277,509.34 85,000.00 175,000.00 Miscellaneous Totals: 0.00 100,000.00 0.00 0.00 0.00 R09 Transfer Ins
3,259.12 0.00 0.00 0.00 499-000 Transfer In 0.00 0.00 0.00 0.00 0.00 3,259.12 0.00 0.00 0.00 Transfer Ins Totals: 0.00 0.00 0.00 0.00 0.00 8,352,830.45 9,228,395.28 7,471,508.00 8,313,367.00 REVENUES TOTALS: 0.00 8,008,775.00 0.00 0.00 0.00 8,352,830.45 9,228,395.28 7,471,508.00 8,313,367.00 FUND REVENUES 0.00 8,008,775.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND EXPENSES 0.00 0.00 0.00 0.00 0.00 8,352,830.45 9,228,395.28 7,471,508.00 8,313,367.00 WATER FUND Totals: 0.00 8,008,775.00 0.00 0.00 0.00 8,352,830.45 9,228,395.28 7,471,508.00 8,313,367.00 REPORT REVENUES 0.00 8,008,775.00 0.00 0.00 0.00 ::.:.:.:.:.:.:.:.:.============

0.00 0.00 0.00 0.00 REPORT EXPENSES 0.00 0.00 0.00 0.00 0.00 8,352,830.45 9,228,395.28 7,471,508.00 8,313,367.00 REPORT TOTALS: 0.00 8,008,775.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/2/2022 - 3:31 PM) Page2
-202-
1053
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 10:27AM
Fiscal Year: 2023
2020 2021
Actual Actual
647,098.96 649,916.55
15,638.00 0.00
32,897.32 24,802.39
489,154.06 519,799.10
166,476.19 179,857.58

0.00 3,429.15

0.00 262.33

0.00 850.67
2,658.08 (460.72)

0.00 0.00

0.00 0.00
1,353,922.61 1,378,457.05
2,834.87 3,000.00
14,225.56 19,166.66
8,188.68 2,617.96
50,979.69 32,472.05
11,026.21 5,297.95
256,311.00 256,311.00
17,963.89 11,909.77
29,060.38 64,675.21

0.00 0.00

0.00 0.00
GL-BudgetAnalysis (5/20/2022 - 10:27 AM)
2022 2022
Adopted Estimated Account
501
461
E0I
699,350.00 635,037.00 100-101
43,500.00 34,000.00 100-102
23,500.00 15,000.00 100-103
543,342.00 490,000.00 100-120
180,474.00 173,766.00 100-121

0.00 0.00 300-101

0.00 0.00 300-120

0.00 0.00 300-121

0.00 0.00 990-101

0.00 0.00 990-102

0.00 0.00 990-120
1,490,166.00 1,347,803.00
E03
8,000.00 8,000.00 100-201
16,500.00 16,500.00 100-202
9,000.00 9,000.00 100-203
36,543.00 36,543.00 100-204
12,000.00 13,865.00 100-205
256,311.00 256,311.00 100-206
12,000.00 12,000.00 100-208
100,000.00 94,500.00 100-212

0.00 0.00 100-213

0.00 0.00 100-230
LOsBanos
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

WATER FUND
Water
Personnel Services
Salaries 0.00 809,108.00 0.00 0.00 0.00
Part Time 0.00 45,000.00 0.00 0.00 0.00
Overtime 0.00 23,500.00 0.00 0.00 0.00
Benefits 0.00 611,923.00 0.00 0.00 0.00
Benefits-PERS 0.00 201,105.00 0.00 0.00 0.00
Salaries 0.00 0.00 0.00 0.00 0.00
Benefits 0.00 0.00 0.00 0.00 0.00
Benefits-PERS 0.00 0.00 0.00 0.00 0.00
Compensated Absences 0.00 0.00 0.00 0.00 0.00
Part Time 0.00 0.00 0.00 0.00 0.00
Benefits 0.00 0.00 0.00 0.00 0.00
Personnel Services Totals: 0.00 1,690,636.00 0.00 0.00 0.00 Supplies & Services
Grounds Maintenance 0.00 6,000.00 0.00 0.00 0.00
Fleet Repair & Maintenance 0.00 18,150.00 0.00 0.00 0.00 Equipment Repair & Maintenance 0.00 9,000.00 0.00 0.00 0.00 Fleet Services 0.00 45,947.00 0.00 0.00 0.00
Facility Maintenance 0.00 13,000.00 0.00 0.00 0.00
Property Lease 0.00 256,311.00 0.00 0.00 0.00
Rental - Vehicles & Equipment 0.00 12,000.00 0.00 0.00 0.00 Well Repair & Maintenance 0.00 100,000.00 0.00 0.00 0.00 Water Sewerage & Disposal 0.00 0.00 0.00 0.00 0.00
Administrative Services 0.00 0.00 0.00 0.00 0.00

-203-
1054
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 40,618.41 95,994.71 555,000.00 88,000.00 100-231 Professional Services 0.00 410,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-233 Consulting Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-234 Engineering Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-235 City Engineer 0.00 0.00 0.00 0.00 0.00 1,365.21 1,253.81 1,500.00 1,500.00 100-236 Medical Services 0.00 1,500.00 0.00 0.00 0.00 714.36 32.00 1,000.00 2,000.00 100-237 Recruitment 0.00 1,000.00 0.00 0.00 0.00 66,663.07 112,813.64 90,000.00 90,000.00 100-238 Technical Services 0.00 90,000.00 0.00 0.00 0.00 7,520.00 6,381.00 6,434.00 6,434.00 100-240 I.T. Services 0.00 6,467.00 0.00 0.00 0.00 50,977.52 61,763.33 93,696.00 86,503.00 100-250 Insurance 0.00 94,750.00 0.00 0.00 0.00 6,083.50 5,745.57 7,000.00 6,800.00 100-251 Memberships & Dues 0.00 7,000.00 0.00 0.00 0.00 7,988.58 8,103.83 8,000.00 6,000.00 100-252 Communications 0.00 9,500.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-253 Advertising 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-254 Franchise Fees 0.00 0.00 0.00 0.00 0.00 46,044.70 44,562.10 55,000.00 56,000.00 100-256 Permits, Fees & Charges 0.00 65,000.00 0.00 0.00 0.00 1,342.59 2,020.10 5,000.00 5,000.00 100-257 Travel & Training 0.00 6,000.00 0.00 0.00 0.00 9,380.69 1,081.81 7,000.00 14,800.00 100-259 Community Promotion 0.00 7,000.00 0.00 0.00 0.00 6,509.75 5,850.20 4,000.00 4,600.00 100-260 Office Supplies 0.00 7,500.00 0.00 0.00 0.00 8,652.61 8,006.07 9,500.00 9,300.00 100-262 Uniform Expenses 0.00 9,800.00 0.00 0.00 0.00 726,771.22 826,354.95 894,000.00 890,000.00 100-264 Electricity & Gas 0.00 950,000.00 0.00 0.00 0.00 27,603.63 29,592.12 40,133.00 40,133.00 100-265 Gasoline & Oil 0.00 36,625.00 0.00 0.00 0.00 196,099.13 245,687.59 230,000.00 250,000.00 100-267 General Materials & Supplies 0.00 250,000.00 0.00 0.00 0.00 2,320.09 1,311.29 2,000.00 2,000.00 100-273 Special Departmental Exp. 0.00 2,000.00 0.00 0.00 0.00

75.04 75.04 100.00 75.00 100-274 Books & Periodicals 0.00 0.00 0.00 0.00 0.00 (197.89) (45.00) 0.00 0.00 100-275 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-277 Fraud Expense 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-202 Fleet Repair & Maintenance 0.00 0.00 0.00 0.00 0.00 1,059,652.04 1,068,779.91 0.00 0.00 990-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-279 Loss On Sale Of Equip 0.00 0.00 0.00 0.00 0.00 2,656,774.53 2,920,814.67 2,459,717.00 2,005,864.00 Supplies & Services Totals: 0.00 2,414,550.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 900,000.00 0.00 100-710 Land Purchase 0.00 900,000.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - I 0:27 AM) Page2
-204-
1055
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 3,989.71 0.00 0.00 100-720 Building & Structures 0.00 10,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-735 Master Plan 0.00 0.00 0.00 0.00 0.00 139,744.95 230,000.00 250,000.00 245,000.00 100-737 Meters 0.00 250,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-738 Wells 0.00 0.00 0.00 0.00 0.00 527,396.87 57,846.83 1,850,000.00 0.00 100-739 Water Master Plan Improve 0.00 1,850,000.00 0.00 0.00 0.00 45,483.31 0.00 0.00 0.00 100-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-743 Monitor/Detect/Test Equip 0.00 0.00 0.00 0.00 0.00 162,190.54 0.00 60,000.00 0.00 100-750 Vehicles 0.00 122,377.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-751 Radio Equipment 0.00 0.00 0.00 0.00 0.00

98.93 0.00 2,000.00 272.00 100-752 Communication Equipment 0.00 3,750.00 0.00 0.00 0.00 29,220.58 33,325.19 0.00 0.00 100-753 Specialized Equipment 0.00 12,500.00 0.00 0.00 0.00

0.00 116,235.18 75,000.00 62,959.00 100-755 Specialized Vehicles 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-763 Office Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-765 Fire Hydrants 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 (3,989.71) 0.00 0.00 990-720 Building & Structures 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-735 Master Plan 0.00 0.00 0.00 0.00 0.00 (139,744.95) (230,000.00) 0.00 0.00 990-737 Meters 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-738 Wells 0.00 0.00 0.00 0.00 0.00 (527,396.87) (57,846.83) 0.00 0.00 990-739 Water Master Plan Improve 0.00 0.00 0.00 0.00 0.00 (45,483.31) 0.00 0.00 0.00 990-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00 (162,190.54) 0.00 0.00 0.00 990-750 Vehicles 0.00 0.00 0.00 0.00 0.00 (98.93) 0.00 0.00 0.00 990-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00 (29,220.58) (33,325.19) 0.00 0.00 990-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 (116,235.18) 0.00 0.00 990-755 Specialized Vehicles 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-763 Office Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-765 Fire Hydrants 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00 198,738.67 0.00 0.00 0.00 990-799 Capital Asset Write Off 0.00 0.00 0.00 0.00 0.00 198,738.67 0.00 3,137,000.00 308,231.00 Capital Outlay Totals: 0.00 3,148,627.00 0.00 0.00 0.00 E06 Interest - Debt Service
GL-BudgetAnalysis (5/20/2022 - 10:27 AM) Page3
-205-
1056
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 100-281 Interest - Leases/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-821 Principal - Lease/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-822 Principal-Debt Service 93 & 02 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-881 Interest - Leases/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-882 Interest Debt Service 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-885 Debt Related Fees 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-285 Non-Op Exp - Cop Iss Cost 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-821 Principal - Lease/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-822 Principal:93 & 02 Cop 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Interest - Debt Service Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs

0.00 0.00 0.00 0.00 100-825 Water Charge Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Charge Ins - Outs Totals: 0.00 0.00 0.00 0.00 0.00 4,209,435.81 4,299,271.72 7,086,883.00 3,661,898.00 EXPENDITURES TOTALS: 0.00 7,253,813.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 4,209,435.81 4,299,271.72 7,086,883.00 3,661,898.00 DEPT EXPENSES 0.00 7,253,813.00 0.00 0.00 0.00 (4,209,435.81) (4,299,271.72) (7,086,883.00) (3,661,898.00) Water Totals: 0.00 (7,253,813.00) 0.00 0.00 0.00 495 Contingency
EIO Contingency

0.00 10,357.08 100,000.00 0.00 100-900 Contingency 0.00 100,000.00 0.00 0.00 0.00

0.00 10,357.08 100,000.00 0.00 Contingency Totals: 0.00 100,000.00 0.00 0.00 0.00

0.00 10,357.08 100,000.00 O;OO EXPENDITURES TOTALS: 0.00 100,000.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 10:27 AM) Page4
-206-
1057
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 10,357.08 100,000.00 0.00 DEPT EXPENSES 0.00 100,000.00 0.00 0.00 0.00

0.00 (10,357.08) (100,000.00) 0.00 Contingency Totals: 0.00 (100,000.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND REVENUES 0.00 0.00 0.00 0.00 0.00 4,209,435.81 4,309,628.80 7,186,883.00 3,661,898.00 FUND EXPENSES 0.00 7,353,813.00 0.00 0.00 0.00 (4,209,435.81) (4,309,628.80) (7,186,883.00) (3,661,898.00) WATER FUND Totals: 0.00 (7,353,813.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 REPORT REVENUES 0.00 0.00 0.00 0.00 0.00 4,209,435.81 4,309,628.80 7,186,883.00 3,661,898.00 REPORT EXPENSES 0.00 7,353,813.00 0.00 0.00 0.00 (4,209,435.81) (4,309,628.80) (7,186,883.00) (3,661,898.00) REPORT TOTALS: 0.00 (7,353,813.00) 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 10:27 AM) Page5
-207-
1058
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual

0.00 0.00

0.00 0.00
160,753.36
3,553,288.78
2,174,335.46

0.00 1,495,556.46

0.00 0.00
7,383,934.06
190,618.34

0.00 44,980.75
34,550.00
77,921.71
368,380.11

0.00 5,516.73
ktomas
05/02/2022 - 3:42PM
2023
2021
Actual

0.00 24,208.06

0.00 24,208.06
152,816.22
3,739,065.59
2,545,614.90

0.00 2,659,218.76

0.00 0.00
9,096,715.47
67,999.23

0.00 (56,304.92)
34,965.00
70,971.05
509,137.00

0.00 0.00
GL-BudgetAnalysis (5/2/2022- 3:42 PM)
2022 2022
Adopted Estimated Account
502
R03

0.00 0.00 331-010

0.00 0.00 331-050
o.oo 0.00 334-010

0.00 0.00
R04
160,000.00 250,100.00 343-015
3,780,805.00 3,780,805.00 344-010
2,561 ,187.00 2,561,187.00 344-015

0.00 0.00 344-020
1,300,000.00 1,680,000.00 344-025

0.00 0.00 344-050

0.00 0.00 344-060
7,801 ,992.00 8,272,092.00
R07
77,000.00 32,000.00 361-010

0.00 0.00 361-050

0.00 -4,451.00 362-010
34,965.00 34,965.00 363-014
23,000.00 23,244.00 363-017

0.00 0.00 365-050

0.00 0.00 369-000

0.00 0.00 396-030
LOs Banos
A, fhf.:' Crossroads of California
2023 2023 2023 2023
Description FI'E Requested Proposed Approved Adopted

WASTE WATER FUND
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
CARES Act Funding 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Charges for Services
Penalties 0.00 135,000.00 0.00 0.00 0.00
Sewer Collection Fee 0.00 3,815,000.00 0.00 0.00 0.00
Sewer Treatment Fee 0.00 2,590,000.00 0.00 0.00 0.00
Sewer Development Fees 0.00 0.00 0.00 0.00 0.00
Sewer Connection Fee 0.00 1,000,000.00 0.00 0.00 0.00
Sewer Contribution Fees 0.00 0.00 0.00 0.00 0.00
Storm Drain Cont Fee 0.00 0.00 0.00 0.00 0.00
Charges for Services Totals: 0.00 7,540,000.00 0.00 0.00 0.00 Interest & Income
Interest Earnings 0.00 25,000.00 0.00 0.00 0.00
Interest Restrict LAIF 0.00 0.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Rental Of Pasture 0.00 34,965.00 0.00 0.00 0.00
Ag Farming Income 0.00 23,000.00 0.00 0.00 0.00
Devlop. Contrib. Infrastr 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Fiscal Agent-Restricted Earnin 0.00 0.00 0.00 0.00 0.00

-208-
1059
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 721,967.64 626,767.36 134,965.00 85,758.00 Interest & Income Totals: 0.00 82,965.00 0.00 0.00 0.00 ROS Miscellaneous
10,816.55 97,048.55 1,182.00 1,650.00 390-010 Misc Revenues 0.00 1,500.00 0.00 0.00 0.00

0.00 647.82 0.00 0.00 390-020 Refunds 0.00 0.00 0.00 0.00 0.00 36,820.08 2,821.50 0.00 0.00 392-010 Sale-Fixed Assets 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 399-020 Other Financial Sources 0.00 0.00 0.00 0.00 0.00 47,636.63 100,517.87 1,182.00 1,650.00 Miscellaneous Totals: 0.00 1,500.00 0.00 0.00 0.00 R09 Transfer Ins

0.00 0.00 0.00 0.00 499-000 Transfer In 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Ins Totals: 0.00 0.00 0.00 0.00 0.00 8,153,538.33 9,848,208.76 7,938,139.00 8,359,500.00 REVENUES TOTALS: 0.00 7,624,46?,00 0.00 0.00 0.00 8,153,538.33 9,848,208.76 7,938,139.00 8,359,500.00 FUND REVENUES 0.00 7,624,465.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND EXPENSES 0.00 0.00 0.00 0.00 0.00 8,153,538.33 9,848,208.76 7,938,139.00 8,359,500.00 WASTE WATER FUND Totals: 0.00 7,624,465.00 0.00 0.00 0.00 8,153,538.33 9,848,208.76 7,938,139.00 8,359,500.00 REPORT REVENUES 0.00 7,624,465 .00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 REPORT EXPENSES 0.00 0.00 0.00 0.00 0.00 8,153,538.33 9,848,208.76 7,938,139.00 8,359,500.00 REPORT TOTALS: 0.00 7,624,465.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/2/2022 - 3:42 PM) Page 2
-209-
1060
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 12:58PM
Fiscal Year: 2023
2020 2021
Actual Actual
366,408.32 383,041.36

0.00 0.00
14,201.26 10,016.30
281,037.25 327,950.92
94,060.70 97,148.81

0.00 1,489.31

0.00 113.93

0.00 191.86
(2,432.25) (2,256.46)
753,275.28 817,696.03
1,989.50 3,978.31
25,216.00 19,165.74
18,558.03 16,956.28
22,669.07 32,472.05
533.l 7 561.S4
2,946.00 2,946.00
15,496.32 1,291.36

0.00 0.00
28,230.45 91,706.21

0.00 0.00

0.00 0.00
6S8.54 479.87
GL-BudgetAnalysis (S/20/2022 - 12:58 PM)
2022 2022
Adopted Estimated Account
502
432
EOl
411 ,235.00 411,235.00 100-101

0.00 0.00 100-102
18,000.00 18,000.00 100-103
346,099.00 346,099.00 100-120
94,079.00 94,079.00 100-121

0.00 0.00 300-101

0.00 0.00 300-120

0.00 0.00 300-121

0.00 0.00 990-101
869,413.00 869,413.00
E03
8,000.00 8,000.00 100-201
16,500.00 16,500.00 100-202
25,000.00 25,000.00 100-203
36,543.00 36,543.00 100-204
2,000.00 2,850.00 100-205
2,946.00 2,946.00 100-206
3,000.00 0.00 100-208

0.00 0.00 100-230
120,000.00 118,000.00 100-231

0.00 0.00 100-233

0.00 0.00 100-235
1,000.00 500.00 100-236
rityof B os . anos
A1 dte Cmssmatls cfCalijvrnia
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

WASTE WATER FUND
Wastewater Collection
Personnel Services
Salaries 0.00 516,095.00 0.00 0.00 0.00
Part Time 0.00 0.00 0.00 0.00 0.00
Overtime 0.00 18,000.00 0.00 0.00 0.00
Benefits 0.00 391,596.00 0.00 0.00 0.00
Benefits-PERS 0.00 107,685.00 0.00 0.00 0.00
Salaries 0.00 0.00 0.00 0.00 0.00
Benefits 0.00 0.00 0.00 0.00 0.00
Benefits-PERS 0.00 0.00 0.00 0.00 0.00
Compensated Absences 0.00 0.00 0.00 0.00 0.00
Personnel Services Totals: 0.00 1,033,376.00 0.00 0.00 0.00 Supplies & Services
Grounds Maintenance 0.00 6,000.00 0.00 0.00 0.00
Fleet Repair & Maintenance 0.00 18,150.00 0.00 0.00 0.00 Equipment Repair & Maintenance 0.00 25,000.00 0.00 0.00 0.00 Fleet Services 0.00 45,947.00 0.00 0.00 0.00
Facility Maintenance 0.00 2,300.00 0.00 0.00 0.00
Property Lease 0.00 2,946.00 0.00 0.00 0.00
Rental - Vehicles & Equipment 0.00 0.00 0.00 0.00 0.00
Administrative Services 0.00 0.00 0.00 0.00 0.00
Professional Services 0.00 335,000.00 0.00 0.00 0.00
Consulting Services 0.00 0.00 0.00 0.00 0.00
City Engineer 0.00 0.00 0.00 0.00 0.00
Medical Services 0.00 1,000.00 0.00 0.00 0.00

-210-
1061
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FI'E Requested Proposed Approved Adopted 1,592.93 0.00 1,000.00 1,700.00 100-237 Recruitment 0.00 1,000.00 0.00 0.00 0.00 2,435.52 3,267.83 5,000.00 3,000.00 100-238 Technical Services 0.00 5,000.00 0.00 0.00 0.00 7,519.00 6,381.00 6,434.00 6,434.00 100-240 I. T .Services 0.00 6,467.00 0.00 0.00 0.00 21,302.00 21,836.03 26,296.00 23,782.00 100-250 Insurance 0.00 31,817.00 0.00 0.00 0.00 4S6.98 467.12 1,000.00 S00.00 100-251 Memberships & Dues 0.00 1,000.00 0.00 0.00 0.00 5,450.61 4,282.66 6,000.00 6,000.00 100-252 Communications 0.00 7,000.00 0.00 0.00 0.00 198.SO 0.00 3,000.00 3,000.00 100-2S3 Advertising 0.00 3,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-254 Franchise Fees 0.00 0.00 0.00 0.00 0.00 127,349.15 132,050.99 140,000.00 140,000.00 100-2S6 Permits, Fees & Charges 0.00 160,000.00 0.00 0.00 0.00 1,203.40 1,458.88 2,600.00 2,600.00 100-257 Travel & Training 0.00 2,700.00 0.00 0.00 0.00

37.50 0.00 1,000.00 1,000.00 100-259 Community Promotion 0.00 1,000.00 0.00 0.00 0.00 1,217.94 1,297.70 1,800.00 1,800.00 100-260 Office Supplies 0.00 3,000.00 0.00 0.00 0.00 3,806.00 4,076.81 5,000.00 5,000.00 100-262 Uniform Expenses 0.00 5,500.00 0.00 0.00 0.00 81 ,736.33 72,784.15 85,600.00 80,000.00 100-264 Electricity & Gas 0.00 85,600.00 0.00 0.00 0.00 12,978.05 14,012.47 21,504.00 21,504.00 100-265 Gasoline & Oil 0.00 19,000.00 0.00 0.00 0.00 23,773.40 22,500.77 25,000.00 25,000.00 100-267 General Materials & Supplies 0.00 28,000.00 0.00 0.00 0.00 538.63 270.28 1,000.00 500.00 100-273 Special Departmental Exp. 0.00 1,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-274 Books & Periodicals 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-275 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-276 Depreciaition Expense 0.00 0.00 0.00 0.00 0.00 793,846.92 809,429.30 0.00 0.00 990-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 1,201,739.94 1,263,673.35 547,223.00 532,159.00 Supplies & Services Totals: 0.00 797,427.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 2,800,000.00 0.00 100-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-713 SD Imp (Talbott/Place) 0.00 0.00 0.00 0.00 0.00 97,085.40 31,468.06 600,000.00 30,000.00 100-714 Storm Drain Improvement 0.00 658,000.00 0.00 0.00 0.00

0.00 3,989.71 0.00 0.00 100-720 Building & Structures 0.00 10,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-733 Lift Station Overhaul/Imp 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-735 Master Plan 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-737 Piping 0.00 0.00 0.00 0.00 0.00

0.00 33,706.72 473,000.00 85,000.00 100-739 Master Plan Improvements 0.00 800,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 12:58 PM) Page2
-211-
1062
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 100-743 Monitor/Detect/fest Equip 0.00 0.00 0.00 0.00 0.00

0.00 0.00 30,000.00 0.00 100-744 Sewer Line Manholes 0.00 30,000.00 0.00 0.00 0.00 114,115.02 50,521.04 0.00 0.00 100-750 Vehicles 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-751 Radio Equipment 0.00 0.00 0.00 0.00 0.00

98.93 16,913.10 2,000.00 272.00 100-752 Communication Equipment 0.00 3,750.00 0.00 0.00 0.00 42,292.33 14,269.59 70,000.00 63,448.00 100-753 Specialized Equipment 0.00 12,500.00 0.00 0.00 0.00

0.00 0.00 75,000.00 62,959.00 100-755 Specialized Vehicles 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-763 Office Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-713 S D Imp (Talbott/Place) 0.00 0.00 0.00 0.00 0.00 (97,085.40) (31,468.06) 0.00 0.00 990-714 Storm Drain Improvement 0.00 0.00 0.00 0.00 0.00

0.00 (3,989.71) 0.00 0.00 990-720 Building & Structures 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-733 Lift Station Overhaul/Imp 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-735 Master Plan 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-737 Piping 0.00 0.00 0.00 0.00 0.00

0.00 (33,706.72) 0.00 0.00 990-739 Master Plan 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-743 Monitor/Detect/fest Equip 0.00 0.00 0.00 0.00 0.00 (114,115.02) (50,521.04) 0.00 0.00 990-750 Vehicles 0.00 0.00 0.00 0.00 0.00 (98.93) (16,913.10) 0.00 0.00 990-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00 (42,292.33) (14,269.59) 0.00 0.00 990-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-763 Office Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 4,050,000.00 241,679.00 Capital Outlay Totals: 0.00 1,514,250.00 0.00 0.00 0.00 E06 Interest - Debt Service

0.00 0.00 0.00 0.00 100-281 Interest - Leases/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-821 Principal - Lease/Loans 0.00 0.00 0.00 0.00 0,00

0.00 0.00 0.00 0.00 100-881 Interest - Leases/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-885 Debt Related Fees 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-821 Principal - Lease/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Interest - Debt Service Totals: 0.00 0.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 12:58 PM) Page3
-212-
1063
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FI'E Requested Proposed Approved Adopted E0S Charge Ins - Outs

0.00 0.00 0.00 0.00 100-825 Waste Water Charge Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Charge Ins - Outs Totals: 0.00 0.00 0.00 0.00 0.00 1,955,015.22 2,081,369.38 5,466,636.00 1,643,251.00 EXPENDITURES TOTALS: 0.00 3,345,053.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 1,955,015.22 2,081,369.38 5,466,636.00 1,643,251.00 DEPT EXPENSES 0.00 3,345,053.00 0.00 0.00 0.00 (1,955,015.22) {2,081,369.38) (5,466,636.00) (1,643,251.00) Wastewater Collection Totals: 0.00 (3,345,053.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND REVENUES 0.00 0.00 0.00 0.00 0.00 1,955,015.22 2,081,369.38 5,466,636.00 1,643,251.00 FUND EXPENSES 0.00 3,345,053.00 0.00 0.00 0.00 (1,955,015.22) (2,081,369.38) (5,466,636.00) (1,643,251.00) WASTE WATER FUND Totals: 0.00 {3,345,053.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 REPORT REVENUES 0.00 0.00 0.00 0.00 0.00 1,955,015.22 2,081,369.38 5,466,636.00 1,643,251.00 REPORT EXPENSES 0.00 3,345,053.00 0.00 0.00 0.00 (1,955,015.22) (2,081 ,369.38) (5,466,636.00) (1,643,251.00) REPORT TOTALS: 0.00 (3,345,053:00) 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 12:58 PM) Page4
-213-
1064
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 1:07PM
Fiscal Year: 2023
2020 2021
Actual Actual
276,576.57 277,767.07

0.00 0.00
8,719.68 5,269.43
179,885.11 185,286.92
91,993.86 101,016.16
(1,703.69) 1,422.23
555,471.53 570,761.81
5,266.31 9,205.69
9,459.24 9,430.76
27,450.30 30,379.03
32,784.29 27,686.61
5,519.94 6,436.65
427,857.00 427,857.00
216.00 216.00

0.00 0.00
37,542.26 115,608.74

0.00 0.00

0.00 0.00

0.00 0.00
436.74 387.45
311.84 0.00
66,800.78 73,996.06
GL-Budget Analysis (5/20/2022 - 1 :07 PM)
2022 2022
Adopted Estimated Account
502
433
E0l
288,766.00 288,766.00 100-101

0.00 0.00 100-102
11,000.00 11,000.00 100-103
196,871.00 196,871.00 100-120
96,153.00 96,153.00 100-121

0.00 0.00 990-101
592,790.00 592,790.00
E03
10,000.00 6,500.00 100-201
9,330.00 9,330.00 100-202
30,000.00 25,000.00 100-203
20,057.00 20,057.00 100-204
6,000.00 4,000.00 100-205
427,857.00 427,857.00 100-206
30,000.00 250.00 100-208

0.00 0.00 100-230
1,005,000.00 150,000.00 100-231

0.00 0.00 100-233

0.00 0.00 100-234

0.00 0.00 100-235
700.00 450.00 100-236
500.00 500.00 100-237
85,000.00 97,000.00 100-238
LOsBanos
Ar dtt Cmssmads of Calfornitt
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

WASTE WATER FUND
Wastewater Treatment
Personnel Services
Salaries 0.00 380,484.00 0.00 0.00 0.00
Part Time 0.00 0.00 0.00 0.00 0.00
Overtime 0.00 11,000.00 0.00 0.00 0.00
Benefits 0.00 260,671.00 0.00 0.00 0.00
Benefits-PERS 0.00 106,687.00 0.00 0.00 0.00
Compensated Absences 0.00 0.00 0.00 0.00 0.00
Personnel Services Totals: 0.00 758,842.00 0.00 0.00 0.00 Supplies & Services
Grounds Maintenance 0.00 8,000.00 0.00 0.00 0.00
Fleet Repair & Maintenance 0.00 10,263.00 0.00 0.00 0.00 Equipment Repair & Maintenance 0.00 30,000.00 0.00 0.00 0.00 Fleet Services 0.00 25,219.00 0.00 0.00 0.00
Facility Maintenance 0.00 5,000.00 0.00 0.00 0.00
Property Lease 0.00 427,857.00 0.00 0.00 0.00
Rental - Vehicles & Equipment 0.00 500.00 0.00 0.00 0.00 Administrative Services 0.00 0.00 0.00 0.00 0.00
Professional Services 0.00 2,200,000.00 0.00 0.00 0.00
Consulting Services 0.00 0.00 0.00 0.00 0.00
Engineering Services 0.00 0.00 0.00 0.00 0.00
City Engineer 0.00 0.00 0.00 0.00 0.00
Medical Services 0.00 700.00 0.00 0.00 0.00
Recruitment 0.00 500.00 0.00 0.00 0.00
Technical Services 0.00 85,000.00 0.00 0.00 0.00

-214-
1065
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 5,986.00 6,759.00 6,041.00 6,041.00 100-240 I. T. Services 0.00 5,938.00 0.00 0.00 0.00 19,460.93 22,160.07 32,807.00 30,041.00 100-250 Insurance 0.00 33,287.00 0.00 0.00 0.00 798.27 497.92 3,500.00 2,500.00 100-251 Memberships & Dues 0.00 3,000.00 0.00 0.00 0.00 1,760.42 2,265.90 2,500.00 2,500.00 100-252 Communications 0.00 8,000.00 0.00 0.00 0.00 34,204.97 36,789.08 45,000.00 30,000.00 100-256 Permits, Fees & Charges 0.00 38,000.00 0.00 0.00 0.00 574.21 1,011.02 1,500.00 1,500.00 100-257 Travel & Training 0.00 2,000.00 0.00 0.00 0.00 1,486.35 870.19 2,000.00 1,800.00 100-260 Office Supplies 0.00 2,000.00 0.00 0.00 0.00 2,495.55 2,573.17 3,200.00 3,200.00 100-262 Uniform Expenses 0.00 3,300.00 0.00 0.00 0.00 109,598.19 147,329.70 155,150.00 160,000.00 100-264 Electricity & Gas 0.00 170,000.00 0.00 0.00 0.00 10,687.07 11,615.60 18,254.00 18,254.00 100-265 Gasoline & Oil 0.00 18,250.00 0.00 0.00 0.00 16,386.35 20,438.11 20,000.00 17,000.00 100-267 General Materials & Supplies 0.00 20,000.00 0.00 0.00 0.00 31,762.09 32,394.19 34,000.00 34,000.00 100-273 Special Departmental Exp. 0.00 35,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-274 Books & Periodicals 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-275 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 585,295.12 567,161.47 0.00 0.00 990-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 1,434,140.22 1,553,069.41 1,948,396.00 1,047,780.00 Supplies & Services Totals: 0.00 3,131,814.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 0.00 0.00 100-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 134,581.74 150,000.00 40,000.00 100-716 Street & Road Improvements 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-717 Landscape & Irrigation 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-720 Building & Structures 0.00 0.00 0.00 0.00 0.00 29,468.43 9,263.50 395,000.00 0.00 100-735 Master Plan 0.00 500,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-740 MiscelJaneous Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-741 WW Treatment Plant Expansion 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-743 Monitor/Detect/fest Equip 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-750 Vehicles 0.00 70,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-751 Radio Equipment 0.00 0.00 0.00 0.00 0.00

93.37 0.00 2,000.00 0.00 100-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00 175,156.23 24,964.23 165,000.00 142,581.00 100-753 Specialized Equipment 0.00 45,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-762 Equipment Overhaul/Imprv 0.00 0.00 ;. 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-763 Office Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - I :07 PM) Page2
-215-
1066
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 990-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 (134,581.74) 0.00 0.00 990-716 Street/Road Improvements 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-717 Landscape & Irrigation 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-720 Building & Structures 0.00 0.00 0.00 0.00 0.00 (29,468.43) (9,263.50) 0.00 0.00 990-735 Master Plan 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-741 WW Treatment Plant Expansion 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-750 Vehicles 0.00 0.00 0.00 0.00 0.00 (93 .37) 0.00 0.00 0.00 990-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00 (175,156.23) (24,964.23) 0.00 0.00 990-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-762 Equipment Overhaul 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-763 Office Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-799 Capital AssetWrite Off 0.00 0.00 0.00 0.00 0.00

0.00 0.00 712,000.00 182,581.00 Capital Outlay Totals: 0.00 615,000.00 0.00 0.00 0.00 E06 Interest - Debt Service
460,000.00 0.00 0.00 0.00 100-822 Principal:93,97,03 Cop 0.00 0.00 0.00 0.00 0.00 8,433.10 0.00 0.00 0.00 100-882 Interest Debt Service 0.00 0.00 0.00 0.00 0.00 750.00 0.00 0.00 0.00 100-885 Debt Related Fees 0.00 0.00 0.00 0.00 0.00 31,841.00 0.00 0.00 0.00 990-285 Non Op Exp - Cop Iss Cost 0.00 0.00 0.00 0.00 0.00 (460,000.00) 0.00 0.00 0.00 990-822 Principal 1997 Cop 0.00 0.00 0.00 0.00 0.00 41,024.10 0.00 0.00 0.00 Interest - Debt Service Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs

0.00 0.00 0.00 0.00 100-825 Charge Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Charge Ins - Outs Totals: 0.00 0.00 0.00 0.00 0.00 2,030,635.85 2,123,831.22 3,253,186.00 1,823,151.00 EXPENDITURES TOTALS: 0.00 4,505,656.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - 1 :07 PM) Page3
-216-
1067
2020 2021 2022 2022 2023 2023 2023 2023
ActuaJ ActuaJ Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 2,030,635.85 2,123,831.22 3,253,186.00 1,823,151.00 DEPT EXPENSES 0.00 4,505,656.00 0.00 0.00 0.00 (2,030,635.85) (2,123,831.22) (3,253,186.00) (1,823,151.00) Wastewater Treatment Totals: 0.00 (4,505,656.00) 0.00 0.00 0.00 495 Contingency
EI0 Contingency

0.00 0.00 100,000.00 0.00 100-900 Contingency 0.00 100,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-900 Contingency 0.00 0.00 0.00 0.00 0.00

0.00 0.00 100,000.00 0.00 Contingency Totals: 0.00 100,000.00 0.00 0.00 0.00

0.00 0.00 100,000.00 0.00 EXPENDITURES TOTALS: 0.00 100,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0,00 0.00 0.00 0.00 0.00

0.00 0.00 100,000.00 0.00 DEPT EXPENSES 0.00 100,000.00 0.00 0.00 0.00

0.00 0.00 (100,000.00) 0.00 Contingency Totals: 0.00 (100,000.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND REVENUES 0.00 0.00 0.00 0.00 0.00 2,030,635.85 2,123,831.22 3,353,186.00 1,823,151.00 FUND EXPENSES 0.00 4,605,656.00 0.00 0.00 0.00 (2,030,635.85) (2,123,831.22) (3,353,186.00) (1,823,151.00) WASTE WATER FUND Totals: 0.00 (4,605,656.00) 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - I :07 PM) Page4
-217-
1068
2020
Actual

0.00 2,030,635.85
(2,030,635.85)
2021 2022
Actual Adopted

0.00 0.00
2,123,831.22 3,353,186.00
(2,123,831.22) (3,353,186.00)
GL-Budget Analysis (S/20/2022 - I :07 PM)
2022
Estimated Account

0.00 1,823,ISI.OO
(1,823, l S 1.00)
Description

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-218-
FTE

0.00 0.00

0.00 2023
Requested

0.00 4,605,656.00
(4,605,656.00)
2023
Proposed

0.00 0.00

0.00 2023
Approved

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00 PageS
1069
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual

0.00 0.00
6,987.86

0.00 6,987.86
778.47
173.16

0.00 951.63

0.00 0.00
7,939.49

0.00 0.00

0.00 0.00

0.00 ktomas
05/02/2022 - 4:01PM
2023
2021
Actual

0.00 0.00
104,775.63

0.00 104,775.63
342.80
(417.28)

0.00 (74.48)

0.00 0.00
104,701.15

0.00 0.00

0.00 0.00

0.00 GL-BudgetAnalysis (5/2/2022 - 4:01 PM)
2022 2022
Adopted Estimated Account
232
R03

0.00 0.00 334-010

0.00 0.00
R04
10,000.00 170,552.00 349-030

0.00 0.00 349-031
10,000.00 170,552.00
R07
300.00 200.00 361-010

0.00 -75.00 362-010

0.00 0.00 369-000
300.00 125.00
ROB

0.00 0.00 390-020

0.00 0.00
10,300.00 170,677.00
440
E03

0.00 0.00 220-231

0.00 0.00 220-233

0.00 0.00 220-234

0.00 0.00 220-235

0.00 0.00 220-238
Lityaf B os . anos
.A, tht· Crossroads of Califontia
2023 2023 2023 2023
Description FI'E Requested Proposed Approved Adopted

STORM DRAIN IMPACT FUND
Shared Revenues
State Grant 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Charges for Services
Storm Drain Fees 0.00 10,000.00 0.00 0.00 0.00
Ccid Storm Drainage Fees 0.00 0.00 0.00 0.00 0.00
Charges for Services Totals: 0.00 10,000.00 0.00 0.00 0.00 Interest & Income
Interest Earnings 0.00 200.00 0.00 0.00 o.oo·
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 200.00 0.00 0.00 0.00
Miscellaneous
Refunds 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 10,200.00 0.00 0.00 0.00
Storm Drain
Supplies & Services
Professional Services 0.00 0.00 0.00 0.00 0.00
Consulting Services 0.00 0.00 0.00 0.00 0.00
Engineering Services 0.00 0.00 0.00 0.00 0.00
City Engineer 0.00 0.00 0.00 0.00 0.00
Technical Services 0.00 0.00 0.00 0.00 0.00

-219-
1070
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FfE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 220-256 Permits, Fees & Charges 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Supplies & Services Totals: 0.00 0.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 0.00 0.00 220-714 Storm Drain Improvement 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 220-735 Master Plan 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 220-737 Piping 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Capital Outlay Totals: 0.00 0.00 0.00 0.00 0.00 E06 Interest - Debt Service

0.00 0.00 0.00 0.00 220-281 Interest - Leases/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Interest - Debt Service Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Storm Drain Totals: 0.00 0.00 0.00 0.00 0.00 7,939.49 104,701.15 10,300.00 170,677.00 FUND REVENUES 0.00 10,200.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND EXPENSES 0.00 0.00 0.00 0.00 0.00 7,939.49 104,701.15 10,300.00 170,677.00 STORM DRAIN IMPACT FUND 1 0.00 10,200.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/2/2022 - 4:01 PM) Page2
-220-
1071
2020
Actual
7,939.49

0.00 7,939.49
2021
Actual
104,701.15

0.00 104,701.15
GL-BudgetAnalysis (5/2/2022 - 4:01 PM)
2022
Adopted
10,300.00
2022
Estimated Account
170,677.00
======================

0.00 0.00
10,300.00 170,677.00
Description

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-221-
FfE

0.00 0.00

0.00 2023
Requested
10,200.00

0.00 10,200.00
2023
Proposed

0.00 0.00

0.00 2023
Approved

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00

1072
General Ledger
Budget Analysis
User: swilliams
Printed: 05/24/2022 - 4:49PM
Fiscal Year: 2023
2020 2021
Actual Actual
3,962.74 4,077.14
3,962.74 4,077.14

0.00 0.00

0.00 31,242.30
10,000.00 10,000.00
10,000.00 41,242.30
462.00 125.00
157,826.96 191,676.40
158,288.96 191,801.40
7,810.49 2,372.20
1,796.26 (1,848.62)
94,222.65 101,011.92

0.00 0.00
103,829.40 101,535.50

0.00 0.00

0.00 450.01

0.00 0.00

0.00 450.01
GL-Budget Analysis (5/24/2022 - 4:49 PM)
2022 2022
Adopted Estimated Account
505
ROI
4,100.00 4,100.00 311-015
4,100.00 4,100.00
R03
150,000.00 0.00 331-010

0.00 0.00 331-050
10,000.00 10,000.00 334-010
160,000.00 10,000.00
R04
100.00 125.00 346-010
234,000.00 190,000.00 346-020
234,100.00 190,125.00
R07
3,000.00 1,000.00 361-010

0.00 -200.00 362-010
95,000.00 105,000.00 363-014

0.00 0.00 369-000
98,000.00 105,800.00
ROS

0.00 0.00 390-010

0.00 0.00 390-020

0.00 0.00 399-020

0.00 0.00
tOsBanos
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

AIRPORT FUND
Taxes
Property Tax Unsecured 0.00 4,100.00 0.00 0.00 0.00
Taxes Totals: 0.00 4,100.00 0.00 0.00 0.00
Shared Revenues
Federal Grant 0.00 0.00 0.00 0.00 0.00
CARES Act Funding 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 10,000.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 10,000.00 0.00 0.00 0.00
Charges for Services
Aiiport Tie Down Fees 0.00 100.00 0.00 0.00 0.00
Aviation Fuel 0.00 200,000.00 0.00 0.00 0.00
Charges for Services Totals: 0.00 200,100.00 0.00 0.00 0.00 Interest & Income
Interest Earnings 0.00 1,000.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Rental - Land & Buildings 0.00 105,000.00 0.00 0.00 0.00 Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 106,000.00 0.00 0.00 0.00 Miscellaneous
Misc Revenues 0.00 0.00 0.00 0.00 0.00
Refunds 0.00 0.00 0.00 0.00 0.00
Other Financial Sources 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
Page I
-222-
1073
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FfE Requested Proposed Approved Adopted R09 Transfer Ins

0.00 0.00 0.00 0.00 499-000 Transfer In 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Ins Totals: 0.00 0.00 0.00 0.00 0.00 276,081.10 339,106.35 496,200.00 310,025.00 REVENUES TOTALS: 0.00 320,200.00 0.00 0.00 0.00 435 Airport
E0l Personnel Services

0.00 0.00 0.00 0.00 100-101 Salaries 0.00 0.00 0.00 0.00 0.00 8,324.50 0.00 14,500.00 12,000.00 100-102 Part Time 0.00 15,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-103 Overtime 0.00 0.00 0.00 0.00 0.00 2,373.81 144.00 2,862.00 2,450.00 100-120 Benefits 0.00 2,920.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 300-101 Salaries 0.00 0.00 0.00 0.00 0.00 442.00 0.00 0.00 0.00 300-102 Part Time 0.00 0.00 0.00 0.00 0.00 1,126.31 0.00 0.00 0.00 300-120 Benefits 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-101 Compensated Absences 0.00 0.00 0.00 0.00 0.00 12,266.62 144.00 17,362.00 14,450.00 Personnel Services Totals: 0.00 17,920.00 0.00 0.00 0.00 E03 Supplies & Services
4,828.16 9,280.55 10,000.00 7,500.00 100-201 Ground Maintenance 0.00 10,000.00 0.00 0.00 0.00 18,838.08 20,794.57 25,000.00 25,000.00 100-205 Facilily Maintenance 0.00 27,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-207 Rental - Land & Buildings 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-213 Water Sewerage & Disposal 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-230 Administrative Services 0.00 0.00 0.00 0.00 0.00 35,700.00 0.00 177,500.00 0.00 100-231 Professional Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-233 Consulting Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-234 Engineering Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-235 City Engineer 0.00 0.00 0.00 0.00 0.00

85.00 0.00 200.00 200.00 100-236 Medical Services 0.00 200.00 0.00 0.00 0.00 10,449.70 10,710.20 21,000.00 21,000.00 100-238 Technical Services 0.00 15,000.00 0.00 0.00 0.00 12,229.33 13,721.79 18,245.00 17,675.00 100-250 Insurance 0.00 16,454.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-251 Memberships & Dues 0.00 0.00 0.00 0.00 0.00 1,398.10 1,449.73 1,500.00 1,500.00 100-252 Communications 0.00 1,600.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-253 Advertising 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-257 Travel & Training 0.00 0.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/24/2022 - 4:49 PM) Page2
-223-
1074
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 100-259 Community Promotion 0.00 0.00 0.00 0.00 0.00 264.36 470.58 1,500.00 1,500.00 100-260 Office Supplies 0.00 1,000.00 0.00 0.00 0.00 18,702.91 15,952.20 19,800.00 19,800.00 100-264 Electricity & Gas 0.00 21,200.00 0.00 0.00 0.00 129,912.43 140,985.67 175,000.00 175,000.00 100-265 Gasoline & Oil 0.00 200,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 91,914.07 92,461.86 0.00 0.00 990-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 324,322.14 305,827.15 449,745.00 269,175.00 Supplies & Services Totals: 0.00 292,454.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 0.00 0.00 0.00 100-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-717 Landscape & Irrigation 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-719 Fencing 0.00 0.00 0.00 0.00 0.00 14,314.34 0.00 0.00 0.00 100-720 Building & Structures 0.00 0.00 0.00 0.00 0.00

0.00 0.00 70,000.00 0.00 100-725 Airport Improvements 0.00 110,000.00 0.00 0.00 0.00 5,731.10 0.00 10,000.00 8,963.00 100-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-719 Fencing 0.00 0.00 0.00 0.00 0.00 (14,314.34) 0.00 0.00 0.00 990-720 Building & Structures 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-725 Airport Improvements 0.00 0.00 0.00 0.00 0.00 (5,731.10) 0.00 0.00 0.00 990-740 Miscellaneous Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-799 Capital Asset Write Off 0.00 0.00 0.00 0.00 0.00

0.00 0.00 80,000.00 8,963.00 Capital Outlay Totals: 0.00 110,000.00 0.00 0.00 0.00 E06 Interest - Debt Service

0.00 0.00 0.00 0.00 100-281 Interest - Leases/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-821 Principal - Lease/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-881 Interest - Leases/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-821 Principal - Lease/Loans 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Interest - Debt Service Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs

0.00 0.00 0.00 0.00 100-825 Charge-Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Charge Ins - Outs Totals: 0.00 0.00 0.00 0.00 0.00 GL-Budget Analysis (5/24/2022 - 4:49 PM) Page3
-224-
1075
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 336,588.76 305,971.15 547,107.00 292,588.00 EXPENDITURES TOTALS: 0.00 420,374.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 336,588.76 305,971.15 547,107.00 292,588.00 DEPT EXPENSES 0.00 420,374.00 0.00 0.00 0.00 (336,588.76) (305,971.15) (547,107.00) (292,588.00) Airport Totals: 0.00 (420,374.00) 0.00 0.00 0.00 498 Transfer Out
E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 276,081.10 339,106.35 496,200.00 310,025.00 FUND REVENUES 0.00 320,200.00 0.00 0.00 0.00 336,588.76 305,971.15 547,107.00 292,588.00 FUND EXPENSES 0.00 420,374.00 0.00 0.00 0.00 (60,507.66) 33,135.20 (50,907.00) 17,437.00 AIRPORT FUND Totals: 0.00 (100,174.00) 0.00 0.00 0.00 GL-Budget Analysis (5/24/2022 - 4:49 PM) Page4
-225-
1076
2020
Actual
276,081.10
336,588.76
(60,507.66)
2021
Actual
339,106.35
305,971.15
33,135.20
GL-Budget Analysis (5/24/2022 - 4:49 PM)
2022
Adopted
496,200.00
547,107.00
(50,907.00)
2022
Estimated Account
310,025.00
292,588.00
17,437.00
Description

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-226-
FTE

0.00 0.00

0.00 2023
Requested
320,200.00
420,374.00
(100,174.00)
2023
Proposed

0.00 0.00

0.00 2023
Approved

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00 Page5
1077
General Ledger
Budget Analysis
User: ktomas
Printed: 05/02/2022 - 4:03PM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 16,631.01
10,572.00 10,612.00
10,572.00 27.243.01
102,964.25 71,957.27
227,929.58 200,689.70
7,798,089.72 8,134,545.90
3,930.48 1,510.29
319,149.00 319,149.00

0.00 0.00

0.00 0.00

0.00 0.00
4,770.00 4,770.00
8,456,833.03 8,732,622.16
120,482.96 35,114.83

0.00 0.00
26,716.41 (28,677.52)

0.00 0.00

0.00 0.00
147,199.37 6.437.31
813.10 151,164.56
GL-BudgetAnalysis (5/2/2022 - 4:03 PM)
2022 2022
Adopted Estimated Account
510
R03

0.00 0.00 331-050
10,000.00 10,000.00 334-010
10,000.00 10,000.00
R04
90,000.00 60,000.00 318-020
220,000.00 335,000.00 343-015
8,169,756.00 6,100,000.00 344-030
1,000.00 7,100.00 344-035

0.00 26,596.00 344-040

0.00 0.00 344-050

0.00 0.00 344-060

0.00 0.00 348-010
4,770.00 4,770.00 349-010
8,485,526.00 6,533,466.00
R07
40,000.00 15,000.00 361-010

0.00 0.00 361-050

0.00 -2,075.00 362-010

0.00 0.00 369-000

0.00 0.00 396-030
40,000.00 12,925.00
ROS
601 ,184.00 601,500.00 390-010
rOsBanos
Al th-r Crnssmads of California
2023 2023 2023 2023
Description FfE Requested Proposed Approved Adopted

SOLID WASTE FUND
Shared Revenues
CARES Act Funding 0.00 0.00 0.00 0.00 0.00
State Grant 0.00 10,000.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 10,000.00 0.00 0.00 0.00
Charges for Services
Roll Off Fee 0.00 65,000.00 0.00 0.00 0.00
Penalties 0.00 200,000.00 0.00 0.00 0.00
Solid Waste Fees 0.00 6,300,000.00 0.00 0.00 0.00
Recycle Revenue 0.00 1,500.00 0.00 0.00 0.00
Landfill Closure Fees 0.00 0.00 0.00 0.00 0.00
Green Waste Fees 0.00 0.00 0.00 0.00 0.00
Recycling Fees 0.00 0.00 0.00 0.00 0.00
Weed Abatement 0.00 0.00 0.00 0.00 0.00
Highway Cleaning 0.00 4,770.00 0.00 0.00 0.00
Charges for Services Totals: 0.00 6,571,270.00 0.00 0.00 0.00 Interest & Income
Interest Earnings 0.00 10,000.00 0.00 0.00 0.00
Interest Restrict LAIF 0.00 0.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Fiscal Agent-Restricted Eamin 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 10,000.00 0.00 0.00 0.00 Miscellaneous
Misc Revenues 0.00 1,500.00 0.00 0.00 0.00

-227-
1078
2020 2021 2022 2022
Actual Actual Adopted Estimated Account

0.00 533.37 0.00 0.00 390-020
32,562.09 2,200.77 0.00 0.00 392-010

0.00 0.00 0.00 0.00 399-020
33,375.19 153,898.70 601 ,184.00 601,500.00
R09

0.00 0.00 0.00 0.00 499-000

0.00 0.00 0.00 0.00
8,647,979.59 8,920,201 .18 9,136,710.00 7,157,891.00
8,647,979.59 8,920,20 I.I 8 9,136,710.00 7,157,891.00

0.00 0.00 0.00 0.00
8,647,979.59 8,920,201.18 9,136,710.00 7,157,891.00
8,647,979.59 8,920,201.18 9,136,710.00 7,157,891.00
======================

0.00 0.00 0.00 0.00
=========== ===========
8,647,979.59 8,920,20 I.I 8 9,136,710.00 7,157,891.00
GL-Budget Analysis (5/2/2022 - 4:03 PM)
Description FfE
Refunds 0.00
Sale-Fixed Assets 0.00
Other Financial Sources 0.00
Miscellaneous Totals: 0.00
Transfer Ins
Transfer In 0.00
Transfer Ins Totals: 0.00
REVENUES TOTALS: 0.00
FUND REVENUES 0.00
FUND EXPENSES 0.00
SOLID WASTE FUND Totals: 0.00
REPORT REVENUES 0.00
REPORT EXPENSES 0.00
REPORT TOTALS: 0.00
-228-
2023 2023 2023
Requested Proposed Approved

0.00 0.00 0.00

0.00 0.00 0.00

0.00 0.00 0.00
1,500.00 0.00 0.00

0.00 0.00 0.00

0.00 0.00 0.00
6,592,770.00 0.00 0.00
6,592,770.00 0.00 0.00

0.00 0.00 0.00
6,592,770.00 0.00 0.00
6,592,770.00 0.00 0.00
=========== ======================

0.00 0.00 0.00
::::::::::: ======================
======================
6,592,770.00 0.00 0.00
2023
Adopted

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00

1079
General Ledger
Budget Analysis
User: swilliams
Printed: 05/20/2022 - 1:16PM
Fiscal Year: 2023
2020 2021
Actual Actual
332,736.03 324,607.38

0.00 8,174.00
9,019.94 7,940.83
204,846.35 236,551.89
105,760.89 106,223.03
8,930.00 9,082.00
683.11 939.74
661,976.32 693,518.87
1,450.86 2,452.94
19,016.93 29,084.17
3,128.79 4,928.98
28,310.61 30,284.44
6,917.51 6,988.09
56,280.00 56,280.00

0.00 0.00
14,448.75 2,406.99
4,212.38 5,735.29

0.00 0.00
95,550.48 116,463.03

0.00 0.00

0.00 0.00
797.82 753.71
GL-BudgetAnalysis (5/20/2022- 1:16 PM)
2022 2022
Adopted Estimated Account
510
490
E0l
347,499.00 347,499.00 100-101
14,500.00 14,500.00 100-102
8,500.00 8,500.00 100-103
227,392.00 227,392.00 100-120
104,987.00 104,987.00 100-121
14,500.00 14,500.00 170-102
1,501.00 1,501.00 170-120
718,879.00 718,879.00
E03
2,500.00 2,100.00 100-201
27,210.00 27,210.00 100-202
3,000.00 2,000.00 100-203
35,601.00 35,601.00 100-204
9,000.00 8,500.00 100-205
56,280.00 56,280.00 100-206

0.00 0.00 100-207
3,000.00 2,000.00 100-208
5,000.00 3,700.00 100-209

0.00 0.00 100-213
52,000.00 30,000.00 100-231

0.00 0.00 100-233

0.00 0.00 100-235
1,200.00 500.00 100-236
rOsBanos
.At tlat~ Crossmads of Cctlljornia
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

SOLID WASTE FUND
Waste Management
Personnel Services
Salaries 0.00 363,950.00 0.00 0.00 0.00
Part Time 0.00 15,000.00 0.00 0.00 0.00
Overtime 0.00 8,500.00 0.00 0.00 0.00
Benefits 0.00 243,710.00 0.00 0.00 0.00
Benefits-PERS 0.00 114,529.00 0.00 0.00 0.00
Part Time 0.00 15,000.00 0.00 0.00 0.00
Benefits 0.00 1,553.00 0.00 0.00 0.00
Personnel Services Totals: 0.00 762,242.00 0.00 0.00 0.00 Supplies & Services
Grounds Maintenance 0.00 2,500.00 0.00 0.00 0.00
Fleet Repair & Maintenance 0.00 29,931.00 0.00 0.00 0.00 Equipment Repair & Maintenance 0.00 3,000.00 0.00 0.00 0.00 Fleet Services 0.00 44,762.00 0.00 0.00 0.00
Facility Maintenance 0.00 9,000.00 0.00 0.00 0.00
Property Lease 0.00 56,280.00 0.00 0.00 0.00
Rental - Land & Buildings 0.00 0.00 0.00 0.00 0.00
Rental - Vehicles & Equipment 0.00 2,000.00 0.00 0.00 0.00 Alley Maintenance/Repair 0.00 5,000.00 0.00 0.00 0.00
Water Sewerage & Disposal 0.00 0.00 0.00 0.00 0.00
Professional Services 0.00 30,000.00 0.00 0.00 0.00
Consulting Services 0.00 0.00 0.00 0.00 0.00
City Engineer 0.00 0.00 0.00 0.00 0.00
Medical Services 0.00 1,000.00 0.00 0.00 0.00
Page I
-229-
1080
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted 458.69 0.00 800.00 500.00 100-237 Recruitment 0.00 800.00 0.00 0.00 0.00 3,779,409.72 3,915,897.76 5,700,000.00 2,900,000.00 100-238 Technical Services 0.00 3,000,000.00 0.00 0.00 0.00 7,519.00 6,381.00 6,434.00 6,434.00 100-240 I.T. Services 0.00 6,467.00 0.00 0.00 0.00 18,612.67 22,173.15 26,626.00 23,771.00 100-250 Insurance 0.00 30,713.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-251 Memberships & Dues 0.00 0.00 0.00 0.00 0.00 576.58 1,521.91 1,500.00 2,700.00 100-252 Communications 0.00 4,500.00 0.00 0.00 0.00 198.50 0.00 2,000.00 2,000.00 100-253 Advertising 0.00 2,000.00 0.00 0.00 0.00 1,163,128.24 1,249,914.12 100,000.00 100,000.00 100-255 Solid Waste Dumping Fees 0.00 100,000.00 0.00 0.00 0.00 1,246.67 790.63 1,200.00 500.00 100-256 Permits, Fees & Charges 0.00 1,500.00 0.00 0.00 0.00 761.32 961.01 2,000.00 2,000.00 100-257 Travel & Training 0.00 2,500.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-259 Community Promotion 0.00 0.00 0.00 0.00 0.00 2,378.09 1,573.26 1,800.00 1,600.00 100-260 Office Supplies 0.00 1,600.00 0.00 0.00 0.00 2,774.57 3,104.38 4,000.00 3,800.00 100-262 Uniform Expenses 0.00 4,000.00 0.00 0.00 0.00 1,268.85 917.41 1,400.00 1,000.00 100-264 Electricity & Gas 0.00 1,200.00 0.00 0.00 0.00 30,677.66 32,818.67 44,509.00 44,509.00 100-265 Gasoline & Oil 0.00 44,575.00 0.00 0.00 0.00 9,865.04 9,734.27 7,500.00 7,500.00 100-267 General Materials & Supplies 0.00 7,500.00 0.00 0.00 0.00

0.00 0.00 3,000,000.00 100,000.00 100-272 Landfill Closure 0.00 4,000,000.00 0.00 0.00 0.00 3,901.04 1,928.77 3,000.00 2,300.00 100-273 Special Departmental Exp. 0.00 3,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-274 Books & Periodicals 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-275 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 170-267 General Materials & Supplies 0.00 0.00 0.00 0.00 0.00 5,252,890.77 5,503,093.98 9,097,560.00 3,366,505.00 Supplies & Services Totals: 0.00 7,393,828.00 0.00 0.00 0.00 E0S Capital Outlay

0.00 0.00 0.00 0.00 100-710 Land Purchase 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-720 Building & Structures 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-734 Landfill Closure 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-735 Master Plan 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-750 Vehicles 0.00 80,000.00 0.00 0.00 0.00

98.93 0.00 2,000.00 272.00 100-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00 268,754.42 337,056.58 0.00 0.00 100-7S3 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-755 Specialized Vehicles 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-763 Office Equipment 0.00 0.00 0.00 0.00 0.00 GL-Budget Analysis (5/20/2022 - I: 16 PM) Page2
-230-
1081
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual .Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 11,750.18 0.00 0.00 100-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00 268,853.35 348,806.76 2,000.00 272.00 Capital Outlay Totals: 0.00 80,000.00 0.00 0.00 0.00 E08 Charge Ins - Outs
393,459.00 397,361.00 400,000.00 400,000.00 100-820 Charge In 0.00 412,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-825 Solid Waste Charge Out 0.00 0.00 0.00 0.00 0.00 393,459.00 397,361.00 400,000.00 400,000.00 Charge Ins - Outs Totals: 0.00 412,000.00 0.00 0.00 0.00 6,577,179.44 6,942,780.61 10,218,439.00 4,485,656.00 EXPENDITURES TOTALS: 0.00 8,648,070.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 6,577,179.44 6,942,780.61 10,218,439.00 4,485,656.00 DEPT EXPENSES 0.00 8,648,070.00 0.00 0.00 0.00 (6,577,179.44) (6,942,780.61) (10,218,439.00) (4,485,656.00) Waste Management Totals: 0.00 (8,648,070.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND REVENUES 0.00 0.00 0.00 0.00 0.00 6,577,179.44 6,942,780.6 I 10,218,439.00 4,485,656.00 FUND EXPENSES 0.00 8,648,070.00 0.00 0.00 0.00 (6,577,179.44) (6,942,780.61) (10,218,439.00) (4,485,656.00) SOLID WASTE FUND Totals: 0.00 (8,648,070.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 REPORT REVENUES 0.00 0.00 0.00 0.00 0.00 6,577,179.44 6,942,780.61 10,218,439.00 4,485,656.00 REPORT EXPENSES 0.00 8,648,070.00 0.00 0.00 0.00 (6,577,179.44) (6,942,780.61) (10,218,439.00) (4,485,656.00) REPORT TOTALS: 0.00 (8,648,070.00) 0.00 0.00 0.00 GL-BudgetAnalysis (5/20/2022 - 1:16 PM) Page 3
-231-
1082
General Ledger
Budget Analysis
User: ktomas
Printed: 05/02/2022 - 4:06PM
Fiscal Year: 2023
2020 2021
Actual Actual
86,495.37 70,076.18

0.00 0.00

0.00 0.00
44,535.14 42,966.78
6,262.39 5,734.38
137,292.90 118,777.34
1,394.22 2,373.57
58,637.47 67,962.31
3,914.41 4,727.19
39,527.47 42,182.13
3,856.45 2,960.16

0.00 0.00
1,926.74 1,573.93
1,788.31 415.70

0.00 0.00
359.44 341.08

0.00 0.00

0.00 0.00
5,986.00 6,459.00
7,659.88 8,867.44

0.00 0.00
130.69 200.89
GL-Budget Analysis (5/2/2022 - 4:06 PM)
2022 2022
Adopted Estimated Account
510
490
E0I
103,120.00 103,120.00 210-101

0.00 0.00 210-102
1,000.00 1,000.00 210-103
46,790.00 46,790.00 210-120
8,384.00 8,384.00 210-121
159,294.00 159,294.00
E03
2,500.00 2,500.00 210-201
67,050.00 67,050.00 210-202
3,000.00 3,000.00 210-203
48,476.00 48,476.00 210-204
5,000.00 5,000.00 210-205

0.00 0.00 210-208
2,000.00 2,000.00 210-209
2,000.00 0.00 210-231

0.00 0.00 210-233
1,000.00 800.00 210-236

0.00 0.00 210-237

0.00 0.00 210-238
6,041.00 6,041.00 210-240
11,611.00 10,419.00 210-250

0.00 0.00 210-251
200.00 200.00 210-252
LOsBanos
A, Ow Cmssroads of CaH{orniu
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

SOLID WASTE FUND
Waste Management
Personnel Services
Salaries 0.00 106,424.00 0.00 0.00 0.00
Part Time 0.00 0.00 0.00 0.00 0.00
Overtime 0.00 1,000.00 0.00 0.00 0.00
Benefits 0.00 47,906.00 0.00 0.00 0.00
Benefits-PERS 0.00 8,748.00 0.00 0.00 0.00
Personnel Services Totals: 0.00 164,078.00 0.00 0.00 0.00 Supplies & Services
Grounds Maintenance 0.00 2,500.00 0.00 0.00 0.00
Fleet Repair & Maintenance 0.00 69,300.00 0.00 0.00 0.00 Equipment Repair & Maintenance 0.00 3,000.00 0.00 0.00 0.00 Fleet Services 0.00 50,016.00 0.00 0.00 0.00
Facility Maintenance 0.00 5,000.00 0.00 0.00 0.00
Rental - Vehicles & Equipment 0.00 0.00 0.00 0.00 0.00
Alley Maintenance & Repair 0.00 2,000.00 0.00 0.00 0.00 Professional Services 0.00 5,000.00 0.00 0.00 0.00
Consulting Services 0.00 0.00 0.00 0.00 0.00
Medical Services 0.00 1,000.00 0.00 0.00 0.00
Recruitment 0.00 0.00 0.00 0.00 0.00
Technical Services 0.00 0.00 0.00 0.00 0.00
I. T. Services 0.00 5,938.00 0.00 0.00 0.00
Insurance 0.00 12,495.00 0.00 0.00 0.00
Membership & Dues 0.00 0.00 0.00 0.00 0.00
Communications 0.00 300.00 0.00 0.00 0.00

-232-
1083
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 210-2S3 Advertising 0.00 0.00 0.00 0.00 0.00 424.66 343.62 500.00 500.00 210-256 Permits, Fees & Charges 0.00 S00.00 0.00 0.00 0.00 199.37 0.00 0.00 0.00 210-257 Travel & Training 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-2S9 Community Promotion 0.00 0.00 0.00 0.00 0.00 2,065.38 1,293.04 1,000.00 1,000.00 210-260 Office Supplies 0.00 1,000.00 0.00 0.00 0.00 1,331.92 1 .• 612.04 2,000.00 2,000.00 210-262 Uniform Expenses 0.00 2,100.00 0.00 0.00 0.00 28,688.27 31,343.68 42,509.00 42,509.00 210-265 Gasoline & Oil 0.00 42,500.00 0.00 0.00 0.00 2,206.06 2,372.81 2,500.00 2,500.00 210-267 General Materials & Supplies 0.00 3,000.00 0.00 0.00 0.00 589.98 41S.64 600.00 600.00 210-273 Special Departmental Exp. 0.00 600.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-274 Books & Periodocials 0.00 0.00 0.00 0.00 0.00 160,686.72 175,504.23 197,987.00 194,595.00 Supplies & Services Totals: 0.00 206,249.00 0.00 0.00 0.00 BOS Capital Outlay

0.00 0.00 0.00 0.00 210-720 Building & Structures 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-750 Vehicles 0.00 0.00 0.00 0.00 0.00

93.37 0.00 2,000.00 0.00 210-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00 328,135.04 0.00 375,000.00 355,000.00 210-753 Specialized Equipment 0.00 11 ,200.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-7S5 Specialized Vehicles 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00 328,228.41 0.00 377,000.00 355,000.00 Capital Outlay Totals: 0.00 11,200.00 0.00 0.00 0.00 E08 Charge Ins - Outs

0.00 0.00 0.00 0.00 210-825 Solid Waste Charge Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Charge Ins - Outs Totals: 0.00 0.00 0.00 0.00 0.00 626,208.03 294,281.57 734,281.00 708,889.00 EXPENDITURES TOTALS: 0.00 381,527.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 626,208.03 294,281.57 734,281.00 708,889.00 DEPT EXPENSES 0.00 381,527.00 0.00 0.00 0.00 (626,208.03) (294,281.57) (734,281 .00) (708,889.00) Waste Management Totals: 0.00 (381,527.00) 0.00 0.00 0.00

0.00 0.00 0.00 0.00 FUND REVENUES 0.00 0.00 0.00 0.00 0.00 GL-Budget Analysis (5/2/2022 - 4:06 PM) Page2
-233-
1084
2020
Actual
626,208.03
(626,208.03)

0.00 2021
Actual
294,281.57
(294,281.57)

0.00 2022
Adopted
734,281.00
(734,281.00)

0.00 2022
Estimated Account
708,889.00
(708,889.00)

0.00 =========== :::::::::::::::::::::::::=
626,208.03
(626,208.03)
294,281.57 734,281.00
======================
=========== ===========
(294,281.57) (734,281 .00)
GL-BudgetAnalysis (5/2/2022 - 4:06 PM)
708,889.00
(708,889.00)
Description

FUND EXPENSES
SOLID WASTE FUND Totals:

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-234-
FfE

0.00 0.00
2023
Requested
381,527.00
(381,527.00)
-------_ -_ -_ -_ -_ -_-_ -_ -_ -_ -_

0.00 0.00
2023
Proposed

0.00 0.00

0.00 ------ _ --_ -_ -_ -_ -_ -_-_ -_ -_ -__ -_-_-_-_-_-_-:__-_-_-_-

0.00 381 ,527.00 0.00

0.00 (381 ,527.00) 0.00
2023
Approved

0.00 0.00

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00 0.00

0.00 Page3
1085
General Ledger
Budget Analysis
User:

Printed:

Fiscal Year:
2020
Actual

0.00 (45,339.31)
(45,339.31)
(45,339.31)

0.00 (45,339.31)
45,339.31

0.00 (45,339.31)
45,339.31
ktomas
05/02/2022 - 4:06PM
2023
2021
Actual

0.00 (203,271.01)
(203,271.01)
(203,271.01)

0.00 (203,271.01)
203,271.01

0.00 (203,271.01)
203,271.01
GL-BudgetAnalysis (5/2/2022 - 4:06 PM)
2022 2022
Adopted Estimated Account
510
495
ElO
100,000.00 0.00 100-900

0.00 0.00 100-901
100,000.00 0.00
100,000.00 0.00

0.00 0.00
100,000.00 0.00
(100,000.00) 0.00

0.00 0.00
100,000.00 0.00
(100,000.00) 0.00
LOsBanos
At tl1e Cmssmads o_[ C-"Jifornia
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

SOLID WASTE FUND
Contingency
Contingency
Contingency 0.00 100,000.00 0.00 0.00 0.00
Change in Estimate 0.00 0.00 0.00 0.00 0.00
Contingency Totals: 0.00 100,000.00 0.00 0.00 0.00
EXPENDITURES TOTALS: 0.00 100,000.00 0.00 0.00 0.00
DEPT REVENUES 0.00 0.00 0.00 0.00 0.00
DEPT EXPENSES 0.00 100,000.00 0.00 0.00 0.00
Contingency Totals: 0.00 (100,000.00) 0.00 0.00 0.00
FUND REVENUES 0.00 0.00 0.00 0.00 0.00
FUND EXPENSES 0.00 100,000.00 0.00 0.00 0.00
SOLID WASTE FUND Totals: 0.00 (100,000.00) 0.00 0.00 0.00 Page I
-235-
1086
2020
ActuaJ

0.00 (45,339.31)
45,339.31
2021
ActuaJ

0.00 (203,271.01)
203,271.01
GL-Budget Analysis (S/2/2022 - 4:06 PM)
2022
Adopted

0.00 100,000.00
(100,000.00)
2022
Estimated Account

0.00 0.00

0.00 Description

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-236-
FfE

0.00 0.00

0.00 2023
Requested

0.00 100,000.00
(100,000.00)
2023
Proposed

0.00 0.00

0.00 2023
Approved

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00 Page2
1087

INTERNAL SERVICE
FUNDS
1088
General Ledger
Budget Analysis
User: ktomas
Printed: 05/03/2022 - 11:39AM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 677.42

0.00 677.42
870,331.08 828,484.60
870,331.08 828,484.60
6,336.01 1,682.58
624.77 (309.00)

0.00 0.00
6,960.78 1,373.58

0.00 3,854.84

0.00 126.11

0.00 3,980.95
877,291.86 834,516.55
136,842.58 139,511.58
14,167.00 910.00
157.74 2,309.61
95,112.04 101,721.67
60,467.85 38,358.91
GL-Budget Analysis (5/3/2022 - 11:39 AM)
2022 2022
Adopted Estimated Account
601
R03

0.00 0.00 331-050

0.00 0.00
R04
942,516.00 943,500.00 341-060
942,516.00 943,500.00
RO?
3,000.00 740.00 361-010

0.00 -125.00 362-010

0.00 0.00 369-000
3,000.00 615.00
ROS

0.00 0.00 390-010

0.00 0.00 390-020

0.00 0.00
945,516.00 944,115.00
480
EOl
141,413.00 139,000.00 210-101
29,000.00 15,000.00 210-102
1,000.00 300.00 210-103
113,625.00 113,625.00 210-120
38,252.00 34,130.00 210-121
rOs Banos
Ar tfot C,nssma,1s o.J Cali_(ornia
2023 2023 2023 2023
Description FI'E Requested Proposed Approved Adopted

FLEET MAINTENANCE FUND
Shared Revenues
CARES Act Funding 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Charges for Services
Fleet Maint. Service Chge 0.00 1,073,528.00 0.00 0.00 0.00 Charges for Services Totals: 0.00 I ,073,528.00 0.00 0.00 0.00 Interest & Income
Interest Earnings 0.00 500.00 0.00 0.00 0.00
Gain/Value on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 500.00 0.00 0.00 0.00
Miscellaneous
Misc Revenues 0.00 0.00 0.00 0.00 0.00
Refunds 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 1,074,028.00 0.00 0.00 0.00
Fleet Maintenance
Personnel Services
Salaries 0.00 189,355.00 0.00 0.00 0.00
Part Time 0.00 30,000.00 0.00 0.00 0.00
Overtime 0.00 1,000.00 0.00 0.00 0.00
Benefits 0.00 156,074.00 0.00 0.00 0.00
Benefits-PERS 0.00 44,669.00 0.00 0.00 0.00

-237-
1089
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FfE Requested Pro-posed A-p-proved Adopted 621.92 0.00 0.00 0.00 300-101 Salaries 0.00 0.00 0.00 0.00 0.00

47.58 0.00 0.00 0.00 300-120 Benefits 0.00 0.00 0.00 0.00 0.00

7.92 0.00 0.00 0.00 300-121 Benefits-PERS 0.00 0.00 0.00 0.00 0.00

40.59 (66.87) 0.00 0.00 990-101 Compensated Absences 0.00 0.00 0.00 0.00 0.00

0.00 53,390.00 0.00 0.00 990-120 GASB 75 Expense 0.00 0.00 0.00 0.00 0.00

0.00 28,540.00 0.00 0.00 990-121 GASB 68 Expense 0.00 0.00 0.00 0.00 0.00 307,465.22 364,674.90 323,290.00 302,055.00 Personnel Services Totals: 0.00 421,098.00 0.00 0.00 0.00 E03 Supplies & Services

0.00 0.00 0.00 0.00 210-201 Grounds Maintenance 0.00 0.00 0.00 0.00 0.00 333,521.21 300,599.62 300,000.00 300,000.00 210-202 Fleet Repair & Maintenance 0.00 330,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-203 Equipment Repair & Maintenance 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-204 Fleet Services 0.00 0.00 0.00 0.00 0.00 5,047.32 4,904.35 3,078.00 2,328.00 210-205 Facility Maintenance 0.00 5,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-208 Rental - Vehicles & Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-213 Water Sewerage & Disposal 0.00 0.00 0.00 0.00 0.00 5,333.71 4,731.27 10,500.00 10,500.00 210-231 Professional Services 0.00 8,000.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-235 City Engineer 0.00 0.00 0.00 0.00 0.00 859.45 409.63 900.00 900.00 210-236 Medical Services 0.00 900.00 0.00 0.00 0.00 101.30 0.00 250.00 500.00 210-237 Recruitment 0.00 500.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-238 Technical Services 0.00 0.00 0.00 0.00 0.00 6,201.00 0.00 0.00 0.00 210-240 I. T. Services 0.00 0.00 0.00 0.00 0.00 5,503.23 5,791.36 6,687.00 6,176.00 210-250 Insurance 0.00 8,730.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-251 Memberships & Dues 0.00 0.00 0.00 0.00 0.00 825.71 835.32 1,000.00 1,000.00 210-252 Communications 0.00 1,200.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-256 Permits, Fees & Charges 0.00 0.00 0.00 0.00 0.00 590.81 1,180.13 1,000.00 1,000.00 210-257 Travel & Training 0.00 2,000.00 0.00 0.00 0.00 1,588.07 1,275.39 1,500.00 1,500.00 210-260 Office Supplies 0.00 1,500.00 0.00 0.00 0.00 2,460.51 2,602.97 2,500.00 2,950.00 210-262 Uniform Expenses 0.00 3,200.00 0.00 0.00 0.00 11,658.81 12,442.14 14,311.00 15,000.00 210-264 Electricity & Gas 0.00 16,000.00 0.00 0.00 0.00 179,308.93 176,418.14 250,000.00 250,000.00 210-265 Gasoline & Oil 0.00 250,000.00 0.00 0.00 0.00 18,883.68 15,836.13 20,000.00 20,000.00 210-267 General Materials & Supplies 0.00 25,000.00 0.00 0.00 0.00 9,280.35 349.29 500.00 500.00 210-273 Special Departmental Exp. 0.00 400.00 0.00 0.00 0.00 GL-Budget Analysis (5/3/2022 - 11:39 AM) Page2
-238-
1090
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FfE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 210-274 Books & Periodicals 0.00 0.00 0.00 0.00 0.00 41,727.67 8,900.14 0.00 0.00 990-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 622,891.76 536,275.88 612,226.00 612,354.00 Supplies & Services Totals: 0.00 652,430.00 0.00 0.00 0.00 E05 Capital Outlay

0.00 24,810.86 6,922.00 6,922.00 210-720 Building & Structures 0.00 0.00 0.00 0.00 0.00 8,890.31 0.00 0.00 0.00 210-743 Monitor/Detect/Test Equip 0.00 0.00 0.00 0.00 0.00

93.37 0.00 2,000.00 257.00 210-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 210-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 (24,810.86) 0.00 0.00 990-720 Building & Structures 0.00 0.00 0.00 0.00 0.00 (8,890.31) 0.00 0.00 0.00 990-743 Monitor/Detect/Test Equip 0.00 0.00 0.00 0.00 0.00 (93.37) 0.00 0.00 0.00 990-752 Communication Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-753 Specialized Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 990-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 0.00 8,922.00 7,179.00 Capital Outlay Totals: 0.00 0.00 0.00 0.00 0.00 E06 Interest - Debt Service
1,408.14 13.77 0.00 0.00 210-882 Interest Debt Service 0.00 0.00 0.00 0.00 0.00 1,408.14 13.77 0.00 0.00 Interest - Debt Service Totals: 0.00 0.00 0.00 0.00 0.00 E08 Charge Ins - Outs

0.00 0.00 0.00 0.00 210-825 Charge Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Charge Ins - Outs Totals: 0.00 0.00 0.00 0.00 0.00 931,765.12 900,964.55 ' 944,438.00 921,588.00 EXPENDITURES TOTALS: 0.00 1,073,528.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 931,765.12 900,964.55 944,438.00 921,588.00 DEPT EXPENSES 0.00 1,073,528.00 0.00 0.00 0.00 (931,765.12) (900,964.55) (944,438.00) (921,588.00) Fleet Maintenance Totals: 0.00 (1,073,528.00) 0.00 0.00 0.00 481 Community Center
EOI Personnel Services

0.00 0.00 0.00 0.00 210-121 Benefits-PERS 0.00 0.00 0.00 0.00 0.00 GL-Budget Analysis (5/3/2022 - 11 :39 AM) Page3
-239-
1091
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FI'E Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 Personnel Services Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITIJRES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Community Center Totals: 0.00 0.00 0.00 0.00 0.00 498 Transfer Out
E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITIJRES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 877,291.86 834,516.55 945,516.00 944,115.00 FUND REVENUES 0.00 1,074,028.00 0.00 0.00 0.00 931,765.12 900,964.55 944,438.00 921,588.00 FUND EXPENSES 0.00 1,073,528.00 0.00 0.00 0.00 (54,473.26) (66,448.00) 1,078.00 22,527.00 FLEET MAINTENANCE FUND l 0.00 500.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/3/2022- 11:39 AM) Page4
-240-
1092
2020
Actual
877,291.86
2021
Actual
834,516.55
------ _-_-_-_--:__-_-_-_-_-_-_-
931,765.12 900,964.55
2022
Adopted
945,516.00
944,438.00
2022
Estimated Account
944,ll5.00
921,588.00
-------_ -_ -_ -_ -_ -_ -_ -_-_-_ -_ ------------
(54,473 .26) (66,448.00) 1,078.00 22,527.00
GL-Budget Analysis (5/3/2022 - 11:39 AM)
Description

REPORT REVENUES

REPORT EXPENSES
REPORT TOTALS:
-241-
FIE

0.00 0.00
2023
Requested
1,074,028.00
1,073,528.00
2023
Proposed

0.00 0.00
------------ ===========

0.00 500.00 0.00
2023
Approved

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00

1093
General Ledger
Budget Analysis
User: ktomas
Printed: 05/02/2022- 4:14PM
Fiscal Year: 2023
2020 2021
Actual Actual

0.00 10,811.49

0.00 10,811.49
465,622.00 439,142.00
465,622.00 439,142.00
4,906.49 1,181.98
709.34 (406.35)
5,615.83 775.63
1,386.18 0.00

0.00 91.63
1,386.18 91.63

0.00 0.00

0.00 0.00
472,624.01 450,820.75
156,183.03 64,872.00
899.33 12.57
139,433.14 44,301.60
GL-BudgetAnalysis (5/2/2022 - 4:14 PM)
2022 2022
Adopted Estimated Account
610
R03

0.00 0.00 331-050

0.00 0.00
R04
429,700.00 415,305.00 341-060
429,700.00 415,305.00
R07
1,000.00 484.00 361-010

0.00 -68.00 362-010
1,000.00 416.00
ROS

0.00 0.00 390-010

0.00 0.00 390-020

0.00 0.00
R09

0.00 0.00 499-000

0.00 0.00
430,700.00 415,721.00
410
E0I
66,782.00 66,782.00 100-101
1,500.00 200.00 100-103
33,645.00 33,645.00 100-120
Lei's Banos
Al t1Jfr Crossmad.c. of Ccdffontia
2023 2023 2023 2023
Description FI'E Requested Proposed Approved Adopted

INFORMATION TECH FUND
Shared Revenues
CARES Act Funding 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Charges for Services
It Service Charges 0.00 425,035.00 0.00 0.00 0.00
Charges for Services Totals: 0.00 425,035.00 0.00 0.00 0.00 Interest & Income
Interest Earnings 0.00 700.00 0.00 0.00 0.00
Gain/Value on Invest.GASB 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 700.00 0.00 0.00 0.00
Miscellaneous
Miscellaneous 0.00 0.00 0.00 0.00 0.00
Refunds 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
Transfer Ins
Transfer In 0.00 0.00 0.00 0.00 0.00
Transfer Ins Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 425,735.00 0.00 0.00 0.00
Administration
Personnel Services
Salaries 0.00 69,292.00 0.00 0.00 0.00
Overtime 0.00 1,500.00 0.00 0.00 0.00
Benefits 0.00 34,224.00 0.00 0.00 0.00
Pagel
-242-
1094
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FfE Requested Proposed Approved Adopted 40,411.46 28,401.80 28,823.00 28,823.00 100-121 Benefits-PERS 0.00 32,041.00 0.00 0.00 0.00 6,081.86 0.00 0.00 0.00 300-101 Salaries 0.00 0.00 0.00 0.00 0.00 2,715.26 0.00 0.00 0.00 300-120 Benefits 0.00 0.00 0.00 0.00 0.00 2,014.37 0.00 0.00 0.00 300-121 Benefits-PERS 0.00 0.00 0.00 0.00 0.00 (7,241.43) 1,136.98 0.00 0.00 990-101 Compensated Absences 0.00 0.00 0.00 0.00 0.00

0.00 (63,478.00) 0.00 0.00 990-120 GASB 75 Expense 0.00 0.00 0.00 0.00 0.00

0.00 (129,197.00) 0.00 0.00 990-121 GASB 68 fapense 0.00 0.00 0.00 0.00 0.00 340,497.02 (53,950.05) 130,750.00 129,450.00 Personnel Services Totals: 0.00 137,057.00 0.00 0.00 0.00 E03 Supplies & Services
507.42 0.00 0.00 0.00 100-202 Fleet Repair & Maintenance 0.00 0.00 0.00 0.00 0.00 1,268.99 0.00 0.00 0.00 100-204 Fleet Services 0.00 0.00 0.00 0.00 0.00 66,060.17 138,000.00 138,000.00 138,000.00 100-231 Professional Services 0.00 138,000.00 0.00 0.00 0.00

40.00 0.00 0.00 0.00 100-236 Medical Services 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 100-237 Recruitment 0.00 0.00 0.00 0.00 0.00 50,281.77 52,116.71 54,656.00 40,000.00 100-238 Technical Services 0.00 39,000.00 0.00 0.00 0.00 7,670.66 5,423.61 5,929.00 5,419.00 100-250 Insurance 0.00 7,578.00 0.00 0.00 0.00 130.00 0.00 0.00 0.00 100-251 Memberships & Dues 0.00 0.00 0.00 0.00 0.00 1,649.03 804.48 1,700.00 1,150.00 100-252 Communications 0.00 1,200.00 0.00 0.00 0.00 1,725.45 921.40 1,000.00 586.00 100-257 Travel & Training 0.00 1,000.00 0.00 0.00 0.00 2,146.98 223.72 1,000.00 500.00 100-260 Office Supplies 0.00 1,000.00 0.00 0.00 0.00 165.56 184.37 200.00 200.00 100-265 Gasoline&Oil 0.00 200.00 0.00 0.00 0.00 1,686.71 0.00 1,500.00 0.00 100-273 Special Departmental Expense 0.00 0.00 0.00 0.00 0.00 50,537.81 53,219.60 0.00 0.00 990-276 Depreciation Expense 0.00 0.00 0.00 0.00 0.00 183,870.55 250,893.89 203,985.00 185,855.00 Supplies & Services Totals: 0.00 187,978.00 0.00 0.00 0.00 E05 Capital Outlay
29,028.75 112,977.63 98,500.00 100,000.00 100-770 Computer Equipment 0.00 100,000.00 0.00 0.00 0.00 (29,028.75) (112,977.63) 0.00 0.00 990-770 Computer Equipment 0.00 0.00 0.00 0.00 0.00

0.00 19,984.63 0.00 0.00 990-799 Capital Asset Write Off 0.00 0.00 0.00 0.00 0.00

0.00 19,984.63 98,500.00 100,000.00 Capital Outlay Totals: 0.00 100,000.00 0.00 0.00 0.00 524,367.57 216,928.47 433,235.00 415,305.00 EXPENDITURES TOTALS: 0.00 425,035.00 0.00 0.00 0.00 GL-Budget Analysis (5/2/2022 - 4:14 PM) Page2
-243-
1095
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 524,367.57 216,928.47 433,235.00 415,305.00 DEPT EXPENSES 0.00 425,035.00 0.00 0.00 0.00 (524,367.57) (216,928.47) (433,235.00) (415,305.00) Administration Totals: 0.00 (425,035 .00) 0.00 0.00 0.00 472,624.0] 450,820.75 430,700.00 415,721.00 FUND REVENUES 0.00 425,735.00 0.00 0.00 0.00 524,367.57 216,928.47 433,235.00 415,305.00 FUND EXPENSES 0.00 425,035.00 0.00 0.00 0.00 (51 ,743.56) 233,892.28 (2,535.00) 416.00 INFORMATION TECH FUND Tot 0.00 700.00 0.00 0.00 0.00 472,624.01 450,820.75 430,700.00 415,721.00 REPORT REVENUES 0.00 425,735.00 0.00 0.00 0.00 =========== ===========
======================
524,367.57 216,928.47 433,235.00 415,305.00 REPORT EXPENSES 0.00 425,035.00 0.00 0.00 0.00 (51 ,743.56) 233,892.28 (2,535.00) 416.00 REPORT TOTALS: 0.00 700.00 0.00 0.00 0.00 =========== =========== ===========
GL-Budget Analysis (5/2/2022 - 4: 14 PM) Page3
-244-
1096
General Ledger
Budget Analysis
User: ktomas
Printed: 05/02/2022 - 4:15PM
Fiscal Year: 2023
2020 2021
Actual Actual
23,604.38 22,930.08
23,604.38 22,930.08

0.00 0.00

0.00 0.00
715.64 272.17
174.98 (226.02)

0.00 0.00
890.62 46.15
24,495.00 22,976.23
252.76 475.44

0.00 0.00
252.76 475.44

0.00 0.00

0.00 0.00
252.76 475.44
GL-Budget Analysis (5/2/2022 - 4: 15 PM)
2022 2022
Adopted Estimated Account
212
ROI
23,500.00 23,500.00 318-025
23,500.00 23,500.00
R03

0.00 0.00 337-010

0.00 0.00
R07
300.00 134.00 361-010

0.00 - 142.00 362-010

0.00 0.00 369-000
300.00 (8.00)
23,800.00 23,492.00
410
E03
5,000.00 0.00 100-203
1,000.00 0.00 100-273
6,000.00 0.00
E05

0.00 0.00 100-752

0.00 0.00
6,000.00 0.00
rtiyof B os · anos
At tf1e Cmssmads of Ct1H/ornfo
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted

PEG FRANCIDSE FUND
Taxes
PEG Franchise Fee 0.00 23,500.00 0.00 0.00 0.00
Taxes Totals: 0.00 23,500.00 0.00 0.00 0.00
Shared Revenues
County Grants 0.00 0.00 0.00 0.00 0.00
Shared Revenues Totals: 0.00 0.00 0.00 0.00 0.00
Interest & Income
Interest Earnings 0.00 100.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 100.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 23,600.00 0.00 0.00 0:00
Administration
Supplies & Services
Equip Repair & Maintenance 0.00 5,000.00 0.00 0.00 0.00 Special Departmental Expense 0.00 1,000.00 0.00 0.00 0.00 Supplies & Services Totals: 0.00 6,000.00 0.00 0.00 0.00 Capital Outlay
Communication Equipment 0.00 0.00 0.00 0.00 0.00
Capital Outlay Totals: 0.00 0.00 0.00 0.00 0.00
EXPENDITIJRES TOTALS: 0.00 6,000.00 0.00 0.00 0.00

-245-
1097
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FfE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 252.76 475.44 6,000.00 0.00 DEPT EXPENSES 0.00 6,000.00 0.00 0.00 0.00 (252.76) (475.44) (6,000.00) 0.00 Administration Totals: 0.00 (6,000.00) 0.00 0.00 0.00 498 Transfer Out
E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITIJRES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 24,495.00 22,976.23 23,800.00 23,492.00 FUND REVENUES 0.00 23,600.00 0.00 0.00 0.00 252.76 475.44 6,000.00 0.00 FUND EXPENSES 0.00 6,000.00 0.00 0.00 0.00 24,242.24 22,500.79 17,800.00 23,492.00 PEG FRANCIIlSE FUND Totals: 0.00 17,600.00 0.00 0.00 0.00 24,495.00 22,976.23 23,800.00 23,492.00 REPORT REVENUES 0.00 23,600.00 0.00 0.00 0.00 ================================= 252.76 475.44 6,000.00 0.00 REPORT EXPENSES 0.00 6,000.00 0.00 0.00 0.00 =========== =========== =========== =========== - ----- 24,242.24 22,500.79 17,800.00 23,492.00 REPORT TOTALS: 0.00 17,600.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/2/2022 - 4:15 PM) Page2
-246-
1098
General Ledger
Budget Analysis
User: ktomas
Printed: 05/02/2022 - 4:16PM
Fiscal Year: 2023
2020 2021
Actual Actual
1,955,496.00 2,106,055.00
1,955,496.00 2,106,055.00
10,000.82 2,032.82
1,088.40 (813.20)

0.00 0.00
11 ,089.22 1,219.62

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00
1,966,585.22 2,107,274.62
1,956,758.42 2,106,054.38
1,956,758.42 2,106,054.38

0.00 0.00

0.00 0.00
GL-BudgetAnalysis (5/2/2022 - 4:16 PM)
2022 2022
Adopted Estimated Account
656
R04
1,938,870.00 1,938,870.00 341-012
1,938,870.00 1,938,870.00
R07
2,300.00 900.00 361-010

0.00 -150.00 362-010

0.00 0.00 369-000
2,300.00 750.00
ROS

0.00 0.00 390-010

0.00 0.00 390-020

0.00 0.00
R09

0.00 0.00 499-000

0.00 0.00
1,941 ,170.00 1,939,620.00
415
E0I
1,938,870.00 1,938,870.00 530-125
1,938,870.00 1,938,870.00
E03

0.00 0.00 100-250

0.00 0.00 530-250
Lityaf B os 1 ·anos
-\1 thr:· Crossroads of (~di{ornia
2023 2023 2023 2023
Description FTE Requested Proposed Approved Adopted
RETIREE MEDICAL HEALTH Fl
Charges for Services
Payroll Assessments 0.00 1,938,870.00 0.00 0.00 0.00
Charges for Services Totals: 0.00 1,938,870.00 0.00 0.00 0.00 Interest & Income
Interest Earnings 0.00 700.00 0.00 0.00 0.00
GainNalue on Investment GASB 0.00 0.00 0.00 0.00 0.00
Discounts Earned 0.00 0.00 0.00 0.00 0.00
Interest & Income Totals: 0.00 700.00 0.00 0.00 0.00
Miscellaneous
Misc. Revenues 0.00 0.00 0.00 0.00 0.00
Refunds 0.00 0.00 0.00 0.00 0.00
Miscellaneous Totals: 0.00 0.00 0.00 0.00 0.00
Transfer Ins
Transfer In 0.00 0.00 0.00 0.00 0.00
Transfer Ins Totals: 0.00 0.00 0.00 0.00 0.00
REVENUES TOTALS: 0.00 1,939,570.00 0.00 0.00 0.00
Insurance
Personnel Services
Retired Employee Benefits 0.00 1,938,870.00 0.00 0.00 0.00 Personnel Services Totals: 0.00 1,938,870.00 0.00 0.00 0.00 Supplies & Services
Insurance 0.00 0.00 0.00 0.00 0.00
Insurance - Retiree's Med 0.00 0.00 0.00 0.00 0.00

-247-
1099
2020 2021 2022 2022 2023 2023 2023 2023
Actual Actual Adopted Estimated Account Description FTE Requested Proposed Approved Adopted

0.00 0.00 0.00 0.00 Supplies & Services Totals: 0.00 0.00 0.00 0.00 0.00 1,956,758.42 2,106,054.38 1,938,870.00 1,938,870.00 EXPENDITURES TOTALS: 0.00 1,938,870.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00 1,956,758.42 2,106,054.38 1,938,870.00 1,938,870.00 DEPT EXPENSES 0.00 1,938,870.00 0.00 0.00 0.00 (1 ,956,758.42) (2, I 06,054.38) (I ,938,870.00) (1 ,938,870.00) Insurance Totals: 0.00 (1,938,870.00) 0.00 0.00 0.00 498 Transfer Out
E09 Transfer Out

0.00 0.00 0.00 0.00 000-000 Transfer Out 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 EXPENDITURES TOTALS: 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT REVENUES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 DEPT EXPENSES 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 Transfer Out Totals: 0.00 0.00 0.00 0.00 0.00 1,966,585.22 2,107,274.62 1,941 ,170.00 1,939,620.00 FUND REVENUES 0.00 1,939,570.00 0.00 0.00 0.00 1,956,758.42 2,106,054.38 1,938,870.00 1,938,870.00 FUND EXPENSES 0.00 1,938,870.00 0.00 0.00 0.00 9,826.80 1,220.24 2,300.00 750.00 RETIREE MEDICAL HEALTH Fl 0.00 700.00 0.00 0.00 0.00 GL-BudgetAnalysis (5/2/2022 - 4:16 PM) Page2
-248-
1100
2020
Actual
1,966,585.22
2021
Actual
2,107,274.62
-------_ -_ -_ -_ -_ -_ -_ -_ -_ -_ -_
I ,956, 758.42 2,106,054.38
9,826.80 1,220.24
GL-Budget Analysis (5/2/2022 - 4:16 PM)
2022
Adopted
1,941,170.00
1,938,870.00
2,300.00
2022
Estimated Account Description
1,939,620.00 REPORT REVENUES
1,938,870.00 REPORT EXPENSES
750.00 REPORT TOTALS:
-249-
FfE

0.00 0.00

0.00 2023
Requested
1,939,570.00
1,938,870.00
700.00
2023
Proposed

0.00 0.00

0.00 2023
Approved

0.00 0.00

0.00 2023
Adopted

0.00 0.00

0.00 Page3
1101

CIPSUMMARY
1102

CAPITAL IMPROVEMENT PLAN
Summary by Fund
Total Project Prior Year(s)
Fiscal Year Available
Project Type Cost Expenditures 2023 2024 2025 2026 2027 Funding General Fund $ 10,659,860 $ 467,000 $ 5,132,860 $ 2,280,000 $ 1,820,000 $ 570,000 $ 390,000 $ 10,659,860 Measure H - Police $ 1,189,000 $ - $ 1,129,000 $ 60,000 $ - $ - $ - $ 1,189,000 Measure H - Fire $ 457,032 $ 306,670 $ 100,362 $ 50,000 $ - $ - $ - $ 457,032 Measure H - Recreation $ 1,823,000 $ 140,000 $ 197,000 $ 35,000 $ 170,000 $ 820,000 $ 320,000 $ 1,682,000 City Hall Admin $ 450,000 $ 65,000 $ 385,000 $ - $ - $ - $ - $ 450,000 Impact Fees - City Hall $ 786,802 $ 413,730 $ - $ 373.072 $ - $ - $ - $ 786 802 Measure P - Police $ 17,913,891 $ 1,265,000 $ 16,588,891 $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 17,913,891 Measure P - Fire $ 194,000 $ 6,000 $ 24,000 $ 16,000 $ 16,000 $ 16,000 $ 16,000 $ 94,000 Impact Fees - Police $ 2,253,609 $ 1,250,000 $ 1,003,609 $ - $ - $ - $ - $ 2,253,609 Impact Fees - Fire $ 880,000 $ - $ - $ 880,000 $ - $ - $ - $ 880,000 Traffic Safety $ 20,000 $ - $ - $ 20,000 $ - $ - $ - $ 20,000 Streets - Charge Out $ 2,767,377 $ - $ 1,897,377 $ 260,000 $ 310,000 $ 135,000 $ 165,000 $ 2,767,377 CMAQ/RSTP $ - $ - $ - $ - $ - $ - $ - $ -
MeasureV $ 7,290,000 $ 40,000 $ 2,510,000 $ 1,580,000 $ 1,500,000 $ 80,000 $ 1,580,000 $ 7,290,000 CPD-Police $ 350,000 $ - $ 350,000 $ - $ - $ - $ - $ 350,000 CFD- Fire $ 350,000 $ - $ 350,000 $ - $ - $ - $ - $ 350,000 Impact Fees -Traffic $ 1,600,000 $ - $ 1,600,000 $ - $ - $ - $ - $ 1,600,000 Impact Fees - Comm Center $ 1,072,354 $ 72,354 $ 1,000,000 $ - $ - $ - $ - $ 1,072,354 -250-
1103
Total Project Prior Year(s)
Fiscal Year Available
Project Type Cost Expenditures 2023 2024 2025 2026 2027 Funding Water Administration $ 161,000 $ 18,000 $ 143,000 $ - $ - $ - $ - $ 161,000 Water $ 9,981,661 $ 302,034 $ 3,148,627 $ 4,472,000 $ 1,012,500 $ 475,500 $ 571,000 $ 9,981,661 Wastewater Administration $ 137,000 $ 18,000 $ 119,000 $ - $ - $ - $ - $ 137,000 Wastewater - Collections $ 14,819,550 $ 156,300 $ 1,514,250 $ 3,075,000 $ 5,131,500 $ 2,540,500 $ 2,402,000 $ 14,819,550 Wastewater - Treatment $ 888,768 $ 43,768 $ 615,000 $ 60,000 $ 70,000 $ 25,000 $ 75,000 $ 888,768 Solid Waste Administration $ 137,000 $ 18,000 $ 119,000 $ - $ - $ - $ - $ 137,000 Solid Waste $ 530,000 $ - $ 80,000 $ 275,000 $ 70,000 $ 70,000 $ 35,000 $ 530,000 Solid Waste-Street Sweeping $ 786,200 $ - $ 11,200 $ 375,000 $ - $ 400,000 $ - $ 786,200 Airport $ 2,690,000 $ - $ 110,000 $ 1,600,000 $ 350,000 $ 630,000 $ - $ 2,690,000 LB Park Development $ 15,171,086 $ 141,700 $ 3,129,386 $ 8,500,000 $ 3,000,000 $ 400,000 $ - $ 15,171,086 Assessment Districts $ 4,559,000 $ 50,000 $ 363,000 $ 515,000 $ 738,000 $ 898,000 $ 1,567,000 $ 4,131,000 Fleet $ - $ - $ - $ - $ - $ - $ - $ -
IT Services $ 578,125 $ 178,125 $ 100,000 $ 75,000 $ 75,000 $ 75,000 $ 75,000 $ 578,125 ARPA $ 2,090,000 $ 176,156 $ 1,913,844 $ - $ - $ - $ - $ 2,090,000 Homeland Security $ - $ - $ - $ - $ - $ - $ - $ -
Unknown Source $ 9,000,000 $ - $ - $ - $ - $ - $ - $ -
Total New Projects $111,586,315 $ 5,127,837 $ 43,634,406 $ 24,516,072 $ 14,278,000 $ 7,150,000 $ 7,211,000 $101,917,315 -251-
1104
$25,000,000
$20,000,000
$15,000,000
$10,000,000
$5,000,000
General Fund
Impact Fees
Water
Wastewater
Solid Waste
■ Available Funding Ill Project Cost
-252-
1105

THIS PAGE IS INTENTIONALLY LEFT BLANK
1106
T Cityof B' LOS.· anos

COMMUNITY AND ECONOMIC DEVELOPMENT DEPARTMENT
Date: May 27, 2022
Re: Notice of Public Hearing
Proposal: Site Plan Review #2022-05 New Loftin Stadium Renovation NOTICE IS HEREBY GIVEN THAT a Public Hearing will be held by the Los Banos Planning Commission to consider a Categorical Exemption from the California Environmental Quality Act (CEQA) and Site Plan Review #2022-05 for the Loftin Stadium Renovation. The project site is located at 1414 S. Seventh St.; more specifically identified as Assessor's Parcel Numbers: 026-110-004.

A PUBLIC HEARING on this matter will be held at the next scheduled meeting of the Los Banos Planning Commission on Wednesday, June 8, 2022 at 6:00 p.m. in the Council Chambers of Los Banos City Hall, located at 520 "J" Street, Los Banos, California. Questions regarding the above-referenced item may be directed to Rudy Luquin, Associate Planner, at City Hall or at (209) 827-2432.

All persons are invited to be present at the public hearing. Written and oral testimony is invited. Notice is hereby further given that if you challenge the above described Project in court, you may be limited to raising only those issues you or someone else raised at the public hearing described in this Notice, or in written correspondence delivered to the Planning Commission at, or prior to, the public hearing.

Additional information may be obtained from the Community & Economic Development Department at 520 J Street, Los Banos, California. In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the Office of the City Clerk at (209) 827-7000. Notification at least 72 hours prior to the public hearing will enable the City to make reasonable arrangements to allow participation at this hearing
Rudy Luu-·~~-::.-:::..

Associate Planner
1107
Lityof B
os anos
'" r .. 11111,.,., r ... 11 .:a • 1 .. ·r--11!::'.P- · ..... nu ·•,-.,, --~~1111"-i-...r-,i:;,..

COMMUNITY AND ECONOMIC DEVELOPMENT DEPARTMENT
Date: May 27, 2022
Regarding: Notice of Public Hearing
Proposal: Mobile Food Vendor Permit #2022-02 - Juan Carlos Gutierrez Alcaraz (dba El Grullense Jal #8 J&A)
NOTICE IS HEREBY GIVEN THAT a Public Hearing will be held by the Los Banos Planning Commission to consider a Categorical Exemption from the California Environmental Quality Act (CEQA) and a revision to Mobile Food Vendor Permit #2022-02 to allow the operation of a mobile food vending vehicle on private property for Juan Carlos Gutierrez Alcaraz dba El Grullense Jal #8 J&A The subject property is located within the Highway Commercial Zoning District at 1400 Mercey Spring Rd., more specifically identified as Assessor's Parcel Number: 083-130-053.

A PUBLIC HEARING on this matter will be held at the next scheduled meeting of the Los Banos Planning Commission on Wednesday, June 8, 2022 at 6:00 p.m. in the Council Chambers of Los Banos City Hall, located at 520 "J" Street, Los Banos, California. Questions regarding the above-referenced item may be directed to Rudy Luquin, Associate Planner, at City Hall or at (209) 827-2432.

All persons are invited to be present at the public hearing. Written and oral testimony is invited. Notice is hereby further given that if you challenge the above described Project in court, you may be limited to raising only those issues you or someone else raised at the public hearing described in this Notice, or in written correspondence delivered to the Planning Commission · at, or prior to, the public hearing.

Additional information may be obtained from the Community & Economic Development Department at 520 J Street, Los Banos, California. In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the Office of the City Clerk at (209) 827-7000. Notification at least 72 hours prior to the public hearing will enable the City to make reasonable arrangements to allow participation at this hearing

OF LOS BANOS
1108
rityof
Os
'· · s . . anos
• I

COMMUNITY AND ECONOMIC DEVELOPMENT DEPARTMENT
Date: May 27, 2022
Regarding: Notice of Public Hearing
Proposal: Conditional Use Permit #2022-01 - Spray Booth NOTICE IS HEREBY GIVEN THAT a Public Hearing will be held by the Los Banos Planning Commission to consider a Categorical Exemption from the California Environmental Quality Act (CEQA) and a Conditional Use Permit to allow the operation of a spray booth for auto restoration for Speedy Auto Service, LLC. The subject property is located in the Highway Commercial Zoning District at 1235 E St., more specifically identified as Assessor's Parcel Number: 025-142- 017.

A PUBLIC HEARING on this matter will be held at the next scheduled meeting of the Los Banos Planning Commission on Wednesday, June 8, 2022 at 6:00 p.m. in the Council Chambers of Los Banos City Hall, located at 520 "J" Street, Los Banos, California. Questions regarding the above-referenced item may be directed to Rudy Luquin, Associate Planner, at City Hall or at (209) 827-2432.

All persons are invited to be present at the public hearing. Written and oral testimony is invited. Notice is hereby further given that if you challenge the above described Project in court, you may be limited to raising only those issues you or someone else raised at the public hearing described in this Notice, or in written correspondence delivered to the Planning Commission at, or prior to, the public hearing.

Additional information may be obtained from the Community & Economic Development Department at 520 J Street, Los Banos, California. In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the Office of the City Clerk at (209) 827-7000. Notification at least 72 hours prior to the public hearing will enable the City to make reasonable arrangements to allow participation at this hearing 1109
LOsBanos ~ _ tlW\ m-....= o-iliPi = ,...., .-~,_.,...,_,,,.;;;,:.: COMMUNITY AND ECONOMIC DEVELOPMENT DEPARTMENT Date: May 27, 2022
Regarding: Notice of Public Hearing
Proposal: Mobile Food Vendor Permit #2022-10 - Antemio Cortes Jr. (dba Taco Mex)
NOTICE IS HEREBY GIVEN THAT a Public Hearing will be held by the Los Banos Planning Commission to consider a Categorical Exemption from the California Environmental Quality Act (CEQA) and a revision to Mobile Food Vendor Permit #2022-10 to allow the operation of a mobile food vending vehicle on private property for Antemio Cortes Jr. dba Taco Mex The subject property is located within the General Commercial Zoning District at 740 G St., more specifically identified as Assessor's Parcel Number: 025-111-021.

A PUBLIC HEARING on this matter will be held at the next scheduled meeting of the Los Banos Planning Commission on Wednesday, June 8, 2022 at 6:00 p.m. in the Council Chambers of Los Banos City Hall, located at 520 "J" Street, Los Banos, California. Questions regarding the above-referenced item may be directed to Rudy Luquin, Associate Planner, at City Hall or at (209) 827-2432.

All persons are invited to be present at the public hearing. Written and oral testimony is invited. Notice is hereby further given that if you challenge the above described Project in court, you may be limited to raising only those issues you or someone else raised at the public hearing described in this Notice, or in written correspondence delivered to the Planning Commission at, or prior to, the public hearing.

Additional information may be obtained from the Community & Economic Development Department at 520 J Street, Los Banos, California. In compliance with the Americans with Disabilities Act, if you need special assistance to participate in this meeting, please contact the Office of the City Clerk at (209) 827-7000. Notification at least 72 hours prior to the public hearing will enable the City to make reasonable arrangements to allow participation at this hearing

OF LOS BANOS
Ru bu.....,..·._._...

Associate Planner
1110