Gustine City Council
May 30, 2023

A AGENDA

GUSTINE CITY

CITY OF GUSTINE

CITY COUNCIL
INCO StOL SPECIAL MEETING
RPORA 11, A.D COUNCIL CHAMBERS, CITY HALL
TED NOV. 352 5'h STREET GUSTINE, CALIFORNIA
MAY 30, 2023 - 5:30 P.M.

The Council Chambers are open and in-person attendance is encouraged.

As a convenience, the City will be retaining the virtual component of public meetings for optional attendance with the use of an online meeting room.

Log-in and dial-in information is as follows:
https://meet.goto.com/898144317
or via telephone by dialing (872) 240-3311, access code: 898-144-317 Feedback and noise will be muted by the meeting organizer.

Please note, in the event of a technical issue causing a disruption in the call-in option or internet- based option, the meeting will continue unless otherwise required by law, such as when a Council Member is attending the meeting virtually pursuant to certain provisions of the Brown Act.

CALL TO ORDER - PLEDGE OF ALLEGIANCE
Please take a moment to silence your cell phones.

ROLL CALL
Council Members: Giles - Marsigli - Bonta - Mayor Pro Tem Ford - Mayor Nagy

APPROVAL OF AGENDA
At this time, any member of the City Council or staff may advise of any updates to the order of, or changes to, the agenda as published.

Any requested changes or edits shall be offered in the form of a motion by any City Council member, requiring a second, and followed by a 3/5 vote of approval by the Council.

DECLARATIONS OF CONFLICT OF INTEREST
At this time, any member of the City Council may declare their conflict of interest or their abstention from any item listed on, or within, the agenda.

PUBLIC COMMENT
At this time, any person may comment on any item which is not on the agenda. PLEASE STATE YOUR NAME FOR THE RECORD. Action will not be taken on the topic unless deemed an urgency matter by a 3/5 vote of the City Council. Topics not considered an urgency matter may be referred to City staff and/or placed on a subsequent agenda for consideration, by a 3/5 vote of the City Council.

Members of the public, who have questions or comments regarding a specific agenda item, may comment on that item before consideration of that item, when recognized by the Mayor.

ADMINISTRATIVE AGENDA

1. WORKSHOP: FY 23-24 Budget Discussion

1. Receive staff introduction and presentation

2. Receive public comment

3. Hold discussion
(continued)

ADJOURNMENT
In compliance with the Americans with Disabilities Act, a disabled person requesting a disability-related modification or accommodation to participate in this meeting, must contact City Hall at 209) 854-6471 or (209) 854-2127 (fax). Requests must be made as early as possible, preferably one-full business day before the start of Any document provided to a majority of the City Council regarding any open session item on this agenda is available for public inspection during normal business hours at the front counter of City Hall located at 352 5TH Street, Gustine, CA. Documents or writings received after the general distribution of the agenda are also

CERTIFICATION
I, Melanie Correa, Deputy City Clerk, do hereby declare under penalty of perjury that the foregoing agenda was posted at the Gustine City Hall, 352 5' Street, Gustine CA and made available for public review on this 25'h day of May, 2023, at ITEM NO. 1

ALTON ORIE

COUNCIL AGENDA ITEM
MAY 30, 2023
PREPARED BY: Jenny Morrison, Finance Director
SUBJECT: FY 2023-24 Budget Workshop

BACKGROUND/DISCUSSION
Each year, the City adopts a new operating budget for the upcoming fiscal year. The budget is generally adopted by June 30 of the current fiscal year, to have legal spending authority for the new fiscal year that begins July 1. As part of the budget presentation and adoption process, a budget workshop is held to communicate the proposed budget to the City Council, the community, and all stakeholders.

An annual operating budget serves two primary purposes; a spending plan and a communication tool of resources to be spent for the fiscal year. Through a collaborative process, the City Management team has identified priorities and a spending plan for the proposed Fiscal Year 2023-2024 budget that will require the use of the City's fiscal resources to operate all municipal departments. This budget workshop allows the opportunity to discuss the upcoming priorities and operations of FY 2023-2024, and to garner any feedback and/or changes that may need to be incorporated before the budget is adopted in June 2023.

FISCAL IMPACT
There is no fiscal impact to the City, as this is a discussion item only.

RECOMMENDATION
Staff recommends Council discuss and ask any questions from this presentation.

EXHIBIT(S)
A) Proposed FY 2023-24 Budget
AA
APPROVED BY:_
Anna Nicholas, City Manager

CITY OF GUSTINE
Proposed Budget
Fiscal Year 2023-2024
)
Fund Balance Report
City of Gustine, CA As Of 05/22/2023
Fund Beginning Balance Total Revenues Total Expenses Ending Balance 000 - POOLED CASH FUND 0.00 0.00 0.00 0.00
001 - GENERAL FUND 225,060.25 2,431,699.26 2,583,590.19 73,169.32 563,657.77 185,348.61 291,121.79 457,884.59
004 - CLEEP 0.00 0.00 0.00 0.00
005 - COPS SLESF 80,371.76 0.00 0.00 80,371.76
006 - PUBLIC SAFETY FUND 39,690.00 0.00 0.00 39,690.00
007 - GEN CAPITAL IMPROVEMENT 148,831.24 0.00 0.00 148,831.24 008 - CDBG REUSE FUND 222,678.35 0.00 0.00 222,678.35
009 - COMMUNITY CENTER FUND -16,518.08 49,926.40 52,793.97 -19,385.65 010 - GAS TAX 2105 FUND 197,437.98 37,198.19 13,608.35 221,027.82 011 - GAS TAX 2106 FUND 124,210.11 18,499.23 1,038.35 141,670.99 012 - GAS TAX 2107 FUND 255,193.85 35,576.92 1,038.35 289,732.42 013 - GAS TAX 2107.5 FUND 3,196.71 0.00 474.60 2,722.11 014 - LOCAL TRANSPORTATION FUND 73,327.63 0.00 0.00 73,327.63 015 - TRAFFIC CONG RELIEF 0.00 0.00 0.00 0.00
016 - SWIM POOL FUND -9,494.58 161,770.78 144,675.01 7,601.19 017 - CITY WIDE LIGHTING & LAND 213,764.71 71,014.20 165,802.57 118,976.34 018 - TRAFFIC SAFETY FUND 60,232.83 2,084.99 3,355.05 58,962.77 019 - RECREATION FUND -20,461.70 105,418.55 132,570.16 -47,613.31 020 - CMAQ 248,719.09 72,839.63 83,238.69 238,320.03
021 - REGIONAL STREET TRANSPORTATION PROGRAM 7,286.08 76,445.24 42,335.38 41,395.94 027 - PER CAPITA GRANT -35,834.13 0.00 444.13 -36,278.26 029 - GAS TAX 2103 FUND 294,810.11 43,863.10 1,038.35 337,634.86 030 - FIRE RESERVE FUND 35,908.47 0.00 0.00 35,908.47
031 - SWIM POOL CAPITAL 4,175.25 0.00 0.00 4,175.25
034 - FIRE SERVICE FUND 36,408.48 0.00 0.00 36,408.48
036 - TRANSPORTATION 5,291.12 0.00 0.00 5,291.12
038 - GENERAL RESERVE 404,823.08 125,000.00 0.00 529,823.08 040 - FIXED ASSETS GROUP -1,904,451.00 0.00 0.00 -1,904,451.00 042 - CANNABIS COMMUNITY CONTRIBUTES 0.00 0.00 0.00 0.00 047 - FIREWORKS 11,384.91 8,595.98 14,962.16 5,018.73
050 - LONG TERM DEBT -1,779,025.28 0.00 0.00 -1,779,025.28 059 - STORM DRAIN -10,582.62 99,392.32 66,454.69 22,355.01 060 - WATER FUND 1,489,875.58 1,165,482.14 1,333,599.67 1,321,758.05 061 - SEWER FUND 8,246,425.49 1,665,141.89 1,444,460.93 8,467,106.45 062 - REFUSE -132,957.54 665,488.62 711,996.32 -179,465.24 063 - AIRPORT FUND 617,409.26 200,442.00 549,287.76
064 - SEWER CAPITAL FUND 141,220.29 0.00 0.00 141,220.29 065 - SEWER REPLACEMENT FUND 200,272.20 0.00 0.00 200,272.20 066 - WATER CAPITAL 48,001.80 0.00 0.00 48,001.80
067 - WWTP CAPITAL RESERVE 16,940.64 0.00 0.00 16,940.64 068 - WATER CAPTIAL REPLACEMENT 18,038.41 0.00 0.00 18,038.41 073 - RDA -91.46 0.00 0.00 -91.46
074 - ASSESS - BORRELLI -27,837.28 3,020.15 28,195.69
075 - ASSESS - SOUTHPORT 32,335.74 0.00 34,349.87
076 - SOLISGEN 56,427.62 0.00 0.00 56,427.62
093 - INSURANCE TRUST FUND (RENTAL) 0.00 0.00 0.00 0.00 094 - SALE OF TOWN PROPERTIES 265,726.75 0.00 6,712.50 259,014.25 099 - PAYROLL TRUST FUND 3,655.70 0.00 0.00 3,655.70
101 - GENERAL GOVERNMENT IMPACT FEES 77,324.07 0.00 101.25 77,222.82 102 - POLICE IMPACT FEES 9,779.58 101.25 9,693.33
103 - FIRE IMPACT FEES 124,997.58 0.00 101.25 124,896.33 104 - PARKS IMPACT FEE 162,207.50 0.00 101.25 162,106.25 105 - STORM DRAIN IMPACT FEES 484,591.99 0.00 101.25 484,490.74 5/22/2023 11:26:59 AM Page 1 of 2
Fund Balance Report As Of 05/22/2023
Fund Beginning Balance Total Revenues Total Expenses Ending Balance 106 - WATER IMPACT FEES 127,966.75 0.00 101.25 127,865.50 107 - SEWER IMPACT FEES 253,374.09 0.00 101.25 253,272.84 108 - REGIONAL TRANSPORTATION IMPACT FEES 25,154.19 0.00 101.25 25,052.94 200 - REGIONAL MEASURE V -3,806.42 0.00 135,761.24 -139,567.66 201- MEASURE V 536,423.52 174,968.43 244,860.00 466,531.95 202-AL MODES MEASURE V 16,716.50 266,201.11 14,947.03 267,970.58 203 - SB1 - ROAD REPAIR/LOCAL STREETS 2017 ACT 390,862.79 89,599.26 0.00 480,462.05 204 - SB2 - BUILDING HOMES AND JOBS ACT OF 2017 0.00 0.00 0.00 0.00 220 - ABANDONED VEHICLE FUND 43,471,38 2,142.34 0.00 45,613.72 221 - PAL EXPLORERS - PD PROGRAMS 21,067.13 3,114.00 938.27 23,242.86 225 - COPS GRANT 2017UMWX0130 0.00 0.00 0.00 0.00
226 - RECYCLING FUND 10,462.73 20,000.00 0.00 30,462.73 301 - SWRCB GRANT WASTEWATER PROJ C-06-8179-110 -51,168.00 0.00 91,723.75 -142,891.75 302 - GUSTINE SOLAR PROJECT 2020 12,705.00 0.00 0.00 12,705.00 303 - EQUIPMENT REPLACEMENT FUND 2,036.17 9,000.00 0.00 11,035.17 304 - ACTIVE TRANSPORTATION PLAN FUND 2,904.25 0.00 0.00 2,904.25 400 - WATER METER GRANT - 2,420,086.25 2,419,787.00 0.00 -299.25 -56,126.94 57,493.87 87,658.39 -86,291.46
402 - AFG FIRE TRUCK GRANT 0.00 0.00 0.00 0.00
403 - AMERICAN RESCUE PLAN ACT FUND (ARPA) 502,975.92 703,550.00 0.00 1,206,525.92 501 - PIONEER PARK REHABILITATION GRANT -20,700.78 0.00 25,956.01 -46,656.79 502 - BODYWORN CAMERA GRANT 0.00 0.00 0.00 0.00
505 - CAL VIP GRANT 24,471.48 0.00 76,691.79 -52,220.31 Report Total: 10,733,139.82 10,960,044.81 7,978,119.94 13,715,064.79 5/22/2023 11:26:59 AM Page 2 of 2
FY 2023-2024 PROPOSED BUDGET SUMMARY BY FUND
City of Gustine, CA
Fund Total Revenue Total Expense Ending Balance
Fund: 001 - GENERAL FUND: $ 2,769,721 $ (2,660,949) $ 108,772 Fund: 002 - UTILITY TAX FUND: $ 313,000 $ (313,345) $ (345) Fund: 005 - COPS SLESF $ 60,000 $ (60,000) $
Fund: 008 - CDBG REUSE FUND: $ $
Fund: 009 - COMMUNITY CENTER FUND: $ 66,121 $ (66,121) $ Fund: 010 - GAS TAX 2105 FUND: $ 39,884 $ (39,884) $
Fund: 011 - GAS TAX 2106 FUND: $ 22,228 $ 22,228
Fund: 012 - GAS TAX 2107 FUND: $ 47,906 $ 47,906
Fund: 013 - GAS TAX 2107.5 FUND: $ 2,000
Fund: 014 - LOCAL TRANSPORTATION FUND: $ 12,615 $ $ 12,615 Fund: 016 - SWIM POOL FUND: $ 180,746 $ (180,746) $ -
Fund: 017 - CITY WIDE LIGHTING & LAND: $ 197,921 $ (187,192) $ 10,729 Fund: 018 - TRAFFIC SAFETY FUND: $ 2,000 $ (2,000) $
Fund: 019 - RECREATION FUND: 128,778 $ (128,778) $
Fund: 020 - CMAQ. $ - $ $
Fund: 021 - REGIONAL STREET TRANSPORTATION PROGRAM (RSTP) $ 71,411 $ (35,044) $ 36,367 Fund: 027 - PER CAPITA GRANT: $ 35,590 $ • $ 35,590
Fund: 029 - GAS FUND 2103 $ 60,229 $ 60,229
Fund: 034 - FIRE SERVICE FUND: $ - $ $
Fund: 038 - GENERAL RESERVE: $ - $ $
Fund: 047 - FIREWORKS: $ 34,000 $ (37,000) $ (3,000)
Fund: 059- STORM DRAIN: 45,500 (63,369) $ (17,869)
Fund: 060 - WATER FUND: 1,581,065 (1,497,378) $ 83,687
Fund: 061 - SEWER FUND: $ 2,054,472 (2,024,576) $ 29,896

Fund: 062 - REFUSE: $ 754,400 |$ (746,990) $ 7,410
Fund: 063 - AIRPORT FUND: $ 241,200 $ (241,009) $ 191
Fund: 074 - ASSESS - BORRELLI: $ 16,525 $ (14,500) $ 2,025 Fund: 075 - ASSESS - SOUTHPORT: $ 3,956 $ (3,880) $ 76
Fund: 101 - GENERAL GOVERNMENT IMPACT FEES: $ 4,000 $ $ 4,000 Fund: 102 - POLICE IMPACT FEES: $ 2,500 $ $ 2,500
Fund: 103 - FIRE IMPACT FEES: 5,000 $ - $ 5,000
Fund: 104 - PARKS IMPACT FEE: $ 12,000 $ $ 12,000
Fund: 105 - STORM DRAIN IMPACT FEES: $ 5,000 $ - $ 5,000 Fund: 106 - WATER IMPACT FEES: $ 10,000 $ - $ 10,000
Fund: 107 - SEWER IMPACT FEES: $ 25,000 $ - $ 25,000
Fund: 108 - REGIONAL TRANSPORTATION IMPACT FEES: $ - $ - $ • Fund: 200 - REGIONAL MEASURE V : $ 830,995 $ (830,995)
Fund: 201 - MEASURE V: $ 200,000 $ 200,000
Fund: 202 - ALT MODES MEASURE V: $ 286,459 $ (286,459) $ Fund: 203 - SB1 - ROAD REPAIR/LOCAL STREETS 2017 ACT: 150,250 $ (150,250) $ Fund: 204 - SB2 - BUILDING HOMES AND JOBS ACT OF 2017 $ 80,000 $ (80,000) $ Fund: 220 - ABANDONED VEHICLE: $ 12,000 $ (4,500) $ 7,500 Fund: 221 - PAL EXPLORERS - PD PROGRAMS: $ 2,000 $ (2,000) $ Fund: 226: RECYCLING $ 5,000 $ (3,000) $ 2,000
Fund: 301 - SWRCB GRANT WASTEWATER PROJ C-06-8179-110: $ 460,475 $ (460,475) $ (0) Fund: 303- EQUIPMENT REPLACEMENT FUND $ 15,000 (15,000) $ Fund: 401 - TOBACCO GRANT $ 90,321 $ (93,067) $ (2,746) Fund: 403 - AMERICAN RESCUE PLAN $ 703,549 $ (703,549) $ - Fund: 501 - PIONEER PARK REHABILITATION GRANT $ 1,300,000 $ (1,280,522) $ 19,478 Fund: 505 - CAL VIP GRANT $ 165,932 $ (141,363) $ 24,569 $ 13,106,748 $ (12,353,941) $ 750,807

Budget Worksheet
City of Gustine, CA Account Summary
For Fiscal: 2023-2024 Period Ending: 06/30/2024
Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 001 - GENERAL FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
001-0000-100.027-00 PD DONATIONS EVENTS 2,800.00 0.00 2,000.00 0.00 1,000.00 0.00 001-0000-100.028-00 CITY-COUNTY DINNER 0.00 0.00 0.00 2,600.00 0.00 0.00 001-0000-220.072-00 SB 1186 STATE BUS LICENSE FE 1,000.00 1,688.00 1,500.00 1,776.00 750.00 0.00 001-0000-400.000-00 SECURED PROPERTY TAXES 559,868.76 667,509.44 576,665.00 367,493.83 588,200.00 0.00 001-0000-400.001-00 SECURED SUP SB 813 2,500.00 0.00 2,500.00 0.00 0.00 0.00 001-0000-400.010-00 UNSECURED PROPERTY TAXES 46,350.00 62,907.47 68,205.00 55,057.01 69,569.00 0.00 001-0000-400.040-00 PROPERTY TAXES - PRIOR 1,500.00 1,146.47 1,500.00 87.66 1,500.00 0.00 001-0000-400.050-00 GENERAL SALES & USE TAX 239,126.00 393,687.05 329,576.00 336,786.46 390,000.00 0.00 001-0000-400.051-00 ADD-ON SALES TAX - BRADLEY- 348,213.00 409,739.53 287,891.18 320,000.00 0.00 001-0000-400.052-00 PROP 172 SALES TAX 32,960.00 46,623.83 40,015.82 40,000.00 0.00 001-0000-400.060-00 FRANCHISES - ELECTRIC 64,000.00 71,548.75 84,327.54 70,000.00 0.00 001-0000-400.061-00 FRANCHISES - GAS 20,000.00 26,366.82 34,880.54 25,000.00 0.00 001-0000-400.070-00 REAL PROP TRANSFER TAXES 12,000.00 17,771.55 9,089.84 12,000.00 0.00 001-0000-410.000-00 BUSINESS LIC & PERMITS 35,000.00 37,701.90 41,867.80 42,000.00 0.00 001-0000-410.002-00 PENALTY BUSINESS LICENSE 1,200.00 1,752.17 1,576.31 1,200.00 0.00 001-0000-410.005-00 OTHER SPECIAL/PLANNING PE 0.00 240.00 0.00 0.00 0.00 0.00 001-0000-410.020-00 ANIMAL LICENSES 8,000.00 3,401.00 3,078.00 3,400.00 0.00 001-0000-410.040-00 CONSTRUCTION PERMITS 45,000.00 154,768.94 60,937.85 50,000.00 0.00 001-0000-420.000-00 OTHER PERMITS 3,000.00 3,444.00 2,785.00 3,300.00 0.00 001-0000-420.026-00 HOMEOWNERS PROP TAX RELI 2,000.00 4,841.39 3,141.79 2,500.00 0.00 001-0000-420.027-00 POST REIMBURSEMENT 0.00 2,111.42 6,828.88 2,500.00 0.00 001-0000-420.040-00 STATE MOTOR VEHICLE LICENS 440,000.00 474,779.21 252,048.28 460,000.00 0.00 001-0000-420.060-00 OCJP/MCO/SLESF 150,000.00 161,318.25 176,518.72 170,000.00 0.00 001-0000-430.000-00 ADMIN PLANNING & DEV FEES 2,500.00 5,324.87 4,074.88 3,000.00 0.00 5/22/2023 2:38:28 PM Paye 1 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 001-0000-430.001-00 PLANNING FEES 11,000.00 77,959.28 20,000.00 3,444.27 20,000.00 0.00 001-0000-430.003-00 PLAN CHECK 25,000.00 37,578.28 25,000.00 35,453.95 25,000.00 0.00 001-0000-430.005-00 SITE PLAN REVIEW 0.00 0.00 0.00 275.62 0.00 0.00 001-0000-430.007-00 ADDRESS ASSIGNMENT OR CH 1,000.00 0.00 1,000.00 3.68 250.00 0.00 001-0000-430.008-00 SRO REVENUE 57,240.00 52,470.00 57,240.00 52,470.00 57,240.00 0.00 001-0000-430.010-00 SPECIAL POLICE SERVICES 18,000.00 16,651.46 18,000.00 17,032.63 18,000.00 0.00 001-0000-430.013-00 ANIMAL CONT & SHELTER FEE 500.00 220.00 500.00 515.00 500.00 0.00 001-0000-430.039-00 FIRE ELECTRIC/GAS REMI 3,500.00 8,278.52 4,000.00 3,863.64 4,000.00 0.00 001-0000-430.041-00 PLANNING DEPOSIT (PROJECT 40,000.00 30,018.36 35,000.00 66,683.23 35,000.00 0.00 001-0000-430.042-00 BUILDING FIRE PD BLDG INSPE 1,000.00 1,780.00 1,500.00 1,780.00 1,500.00 0.00 001-0000-430.043-00 SB 1473-GREEN BUILDING 220.00 329.00 220.00 259.00 220.00 0.00 001-0000-430.051-00 PARK & FACILITY FEES 5,000.00 10,983.34 7,500.00 13,776.24 13,000.00 0.00 001-0000-430.202-00 377 4TH ST CANNABIS RETAILS 0.00 47,614.72 120,000.00 171,240.86 180,000.00 0.00 001-0000-430.301-00 PD-GENERAL FUND GRANT RE 0.00 0.00 0.00 70,500.00 0.00 0.00 001-0000-440.010:00 OTHER FINES 10,000.00 15,531.54 10,000.00 11,437.82 10,000.00 0.00 001-0000-450.000-00 INTEREST 500.00 562.01 500.00 690.63 500.00 0.00 001-0000-450.010-00 RENTS 35,000.00 36,255.66 35,000.00 30,093.47 35,000.00 0.00 001-0000-450.045-00 POLICE DEPT. REIMBURSEMEN 0.00 13,615.00 0.00 0.00 0.00 0.00 001-0000-450.050-00 BAD CHECK FEES 1,000.00 1,075.00 1,000.00 1,610.00 1,000.00 0.00 001-0000-450.061-00 GRAZING INCOME/HAY SALE 71,290.15 71,464.66 71,465.00 72,592.00 72,592.00 0.00 001-0000-490.003-00 MISC REVENUES 12,000.00 65,709.99 15,000.00 97,295.83 35,000.00 0.00 001-0000-490.210-00 LIVESCAN 5,000.00 3,687.00 5,000.00 7,818.00 5,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 2,314,267.91 3,040,455.88 2,560,545.00 2,431,699.26 2,769,721.00 0.00 Revenue Total: 2,314,267.91 3,040,455.88 2,560,545.00 2,431,699.26 2,769,721.00 0.00 Expense
Department: 0110 - CITY COUNCIL
001-0110-500.010-00 SALARIES - PART TIME EMPL 18,000.00 18,000.00 18,000.00 15,900.00 18,000.00 0.00 001-0110-510.010-00 OASDI 1,377.00 1,377.00 1,377.00 1,216.35 1,377.00 0.00 001-0110-520.010-00 DEPT OPERATING SUPPLIES 1,250.00 165.53 1,000.00 322.50 1,000.00 0.00 001-0110-530.088-00 CITY - COUNTY DINNER HOST 2,500.00 0.00 2,500.00 3,076.78 0.00 0.00 001-0110-530.089-00 COMMUNITY PROMOTION 1,500.00 723.14 1,500.00 226.60 1,000.00 0.00 5/22/2023 2:38:28 PM Page 2 of 70
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 001-0110-530.090-00 MEMBERSHIPS/SUBSCRIPTION 7,500.00 7,455.42 7,500.00 4,869.25 7,600.00 0.00 001-0110-530.091-00 MEETINGS & TRAINING 12,800.00 6,331.27 10,000.00 13,348.87 12,000.00 0.00 001-0110-530.201-00 OTHER CONTRACT SERVICES 700.00 1,218.08 700.00 228.80 2,000.00 0.00 001-0110-540.039-00 MAINTENANCE CONTRACTS 322.42 692.99 322.00 238.40 500.00 0.00 Department: 0110 - CITY COUNCIL Total: 45,949.42 35,963.43 42,899.00 39,427.55 43,477.00 0.00 Department: 0120 - CITY MANAGER
001-0120-500.000-00 SALARIES - FULL TIME EMPL 15,625.58 15,308.15 15,625.00 20,337.69 23,344.00 0.00 001-0120-500.020-00 WAGES - HOURLY EMPLOYEES 0.00 0.00 75.00 0.00 75.00 0.00 001-0120-510.000-00 PERS 8,436.81 9,448.51 6,397.00 5,081.99 6,132.00 0.00 001-0120-510.010-00 OASDI 1,195.36 923.85 1,201.00 1,551.06 1,201.00 0.00 001-0120-510.020-00 GROUP HEALTH INSURANCE 1,091.20 454.90 850.00 239.58 850.00 0.00 001-0120-510.030-00 WORKER'S COMP INSURANCE 736.15 712.48 800.00 705.82 800.00 0.000 001-0120-520.010-00 DEPT OPERATING SUPPLIES 100.00 456.33 100.00 665.34 700.00 0.00 001-0120-520.030-00 MOTOR VEHICLE EXPENSE 480.00 400.00 500.00 153.96 500.00 0.00 001-0120-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 0.00 14,225.00 0.00 22,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Strategic Plan Strategic Plan Split
Water = $7K
Sewer = $7K
General Fund = $7K
Total $21K
001-0120-530.011-00 TELEPHONE & INTERNET 1,287.49 1,117.13 1,300.00 144.64 1,300.00 0.00 001-0120-530.089-00 COMMUNITY PROMOTION 200.00 0.00 200.00 0.00 200.00 0.00 001-0120-530.090-00 MEMBERSHIPS/SUBSCRIPTION 3,000.00 390.00 3,000.00 1,226.76 3,000.00 0.00 001-0120-530.091-00 MEETINGS & TRAINING 5,000.00 2,267.14 3,000.00 3,873.89 7,000.00 0.00 001-0120-530.099-00 EMPLOYEE EVENTS/MEETINGS 0.00 0.00 0.00 0.00 4,000.00 0.00 001-0120-530.201-00 OTHER CONTRACT SERVICES 0.00 356.97 0.00 339.28 1,000.00 0.00 001-0120-540.039-00 MAINTENANCE CONTRACTS 322.42 B,313.68 322.00 1,579.77 3,000.00 0.00 Department: 0120 - CITY MANAGER Total: 37,475.01 40,149.14 47,595.00 35,899.78 75,102.00 0.00 5/22/2023 2:38:28 PM Page 3 of 70
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Department: 0130 - ELECTIONS
001-0130-530.003-00 ELECTION 0.00 0.00 0.00 10,549.20 0.00 0.00 Department: 0130 - ELECTIONS Total: 0.00 0.00 0.00 10,549.20 0.00 0.00 Department: 0140 - FINANCE
001-0140-500.000-00 SALARIES - FULL TIME EMPL 16,499.66 17,426.69 17,532.00 19,939.16 21,996.00 0.00 001-0140-500.010-00 SALARIES - PART TIME EMPL 2,572.75 1,671.38 2,975.00 2,424.76 2,735.00 0.00 001-0140-500.030-00 OVERTIME 0.00 2.69 0.00 1.19 0.00 0.00 001-0140-510.000-00 PERS 21,594.14 21,649.76 15,606.00 12,829.33 15,584.00 0.00 001-0140-510.010-00 OASDI 1,459.04 1,018.58 1,569.00 1,661.93 1,569.00 0.00 001-0140-510.012-00 UNEMPLOYMENT INSURANCE 100.00 248.21 100.00 46.72 100.00 0.00 001-0140-510.020-00 GROUP HEALTH INSURANCE 3,522.34 3,686.92 3,645.00 3,541.90 3,645.00 0.00 001-0140-510.030-00 WORKER'S COMP INSURANCE 1,668.60 1,614.95 1,858.00 1,599.88 1,858.00 0.00 001-0140-520.000-00 OFFICE SUPPLIES 0.00 356.25 0.00 273.01 0.00 0.00 001-0140-520.010-00 DEPT OPERATING SUPPLIES 2,500.00 231.84 2,500.00 463.00 1,500.00 0.00 001-0140-520.030-00 MOTOR VEHICLE EXPENSE 360.00 320.00 360.00 96.98 360.00 0.00 001-0140-530.000-00 ACCOUNTING AUDITING 140.00 1,021.75 454.00 514.40 454.00 0.00 001-0140-530.009-00 OTHER PROFESSIONAL SERVICE 2,500.00 219.00 2,500.00 525.00 1,500.00 0.00 001-0140-530.011-00 TELEPHONE & INTERNET 1,287.49 1,317.13 1,287.00 168.92 1,287.00 0.00 001-0140-530.014-00 POSTAGE 1,500.00 758.39 1,500.00 425.02 750.00 0.00 001-0140-530.030-00 ADVERTISING 700.00 897.15 900.00 544.32 900.00 0.00 001-0140-530.050-00 BOND 0.00 0.00 0.00 74,599.56 0.00 0.00 001-0140-530.090-00 MEMBERSHIPS/SUBSCRIPTION 300.00 280.00 300.00 170.00 300.00 0.00 001-0140-530.091-00 MEETINGS & TRAINING 500.00 36.81 1,500.00 56.32 1,500.00 0.00 001-0140-530.201-00 OTHER CONTRACT SERVICES 8,500.00 2,686.31 7,500.00 4,215.02 5,000.00 0.00 001-0140-530.240-00 PROFESSIONAL DEVELOPMENT 0.00 150.00 200.00 0.00 200.00 0.00 001-0140-540.039-00 MAINTENANCE CONTRACTS 161.21 346.48 161.00 119.20 6135900 0.00 Department: 0140 - FINANCE Total: 65,865.23 55,940.29 62,447.00 124,215.62 0.00 Department: 0141 - CITY ATTORNEY
001-0141-530.009-00 OTHER PROFESSIONAL SERVICE 55,000.00 70,795.71 0.00 44,047.83 50,000.00 0.00 001-0141-530.091-00 MEETINGS & TRAINING 0.00 0.00 0.00 1,971.00 1,500.00 0.00 5/22/2023 2:38:28 PM Page 4 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 001-0141-530.201-00 OTHER CONTRACT SERVICES 0.00 78,458.73 102,000.00 124,687.80 106,284.00 0.00 - 170,706.63
Department: 0141 - CITY ATTORNEY Total: 55,000.00 149,254.44 102,000.00 157,784.00 0.00 Department: 0142 - CITY CLERK
001-0242-500.001-00 SALARIES - FULL TIME EMPL 32,623.07 31,221.87 40,479.00 36,729.01 40,998.00 0.00 001-0142-500.020-00 WAGES - HOURLY EMPLOYEES 0.00 162.83 0.00 0.00 0.00 0.00 001-0142-510.000-00 PERS 16,540.42 18,031.29 13,304.00 12,205.66 14,671.00 0.00 001-0142-510.010-00 OASDI 2,495.66 2,164.92 3,097.00 2,758.71 3,097.00 0.00 001-0142-510.012-00 UNEMPLOYMENT INSURANCE 40.00 217.94 40.00 28.77 40.00 0.00 001-0142-510.020-00 GROUP HEALTH INSURANCE 9,897.84 15,669.85 18,776.00 16,821.24 18,776.00 0.00 001-0142-510.030-00 WORKER'S COMP INSURANCE 2,846.43 2,754.92 3,170.00 2,729.20 3,170.00 0.00 001-0142-520.010-00 DEPT OPERATING SUPPLIES 4,000.00 1,946.66 3,000.00 1,291.59 2,500.00 0.00 001-0142-520.030-00 MOTOR VEHICLE EXPENSE 1,104.00 925.03 1,104.00 765.81 1,104.00 0.00 001-0142-530.011-00 TELEPHONE & INTERNET 1,287.49 1,317.13 1,287.00 433.56 1,000.00 0.00 001-0142-530.014-00 POSTAGE 0.00 279.37 150.00 34.00 75.00 0.00 001-0142-530.030-00 ADVERTISING 800.00 0.00 500.00 304.00 500.00 0.00 001-0142-530.090-00 MEMBERSHIPS/SUBSCRIPTION 125.00 219.00 500.00 0.00 250.00 0.00 001-0142-530.091-00 MEETINGS & TRAINING 500.00 2,430.69 2,500.00 3,332.36 3,000.00 0.00 001-0142-530.095-00 TAXES 0.00 -2,322.78 0.00 0.00 0.00 0.00 001-0142-530.201-00 OTHER CONTRACT SERVICES 2,000.00 1,190.82 1,500.00 6,845.15 1,500.00 0.00 001-0142-530.240-00 PROFESSIONAL DEVELOPMENT 5,600.00 14,247.75 4,200.00 1,402.61 4,200.00 0.00 001-0142-530.242-00 NOTARY 600.00 600.00 600.00 525.00 600.00 0.00 001-0142-540.039-00 MAINTENANCE CONTRACTS 322.42 692.99 322.00 238.40 9580300 0.00 Department: 0142 - CITY CLERK Total: 80,782.33 91,750.28 94,529.00 86,445.07 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG
001-0150-500.000-00 SALARIES - FULL TIME EMPL 8,769.22 8,285.91 9,577.00 8,367.43 9,437.00 0.00 001-0150-500.010-00 SALARIES - PART TIME EMPL 7,399.79 6,754.61 7,471.00 5,560.52 6,170.00 0.00 001-0150-500.030-00 OVERTIME 600.00 1,204.75 600.00 942.11 600.00 0.00 001-0150-510.000-00 PERS 1,053.96 1,163.04 875.00 1,070.48 1,071.00 0.00 001-0150-510.010-00 OASDI 1,282.83 1,214.83 1,350.00 1,118.90 1,350.00 0.00 001-0150-510.012-00 UNEMPLOYMENT INSURANCE 40.00 0.00 40.00 0.00 40.00 0.00 001-0150-510.020-00 GROUP HEALTH INSURANCE 3,223.87 2,994.95 3,003.00 2,982.50 3,003.00 0.00 5/22/2023 2:38:28 PM Page 5 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 001-0150-510.030-00 WORKER'S COMP INSURANCE 2,453.82 2,374.94 2,732.00 2,352.76 2,732.00 0.00 001-0150-520.010-00 DEPT OPERATING SUPPLIES 700.00 11,614.34 700.00 3,281.08 700.00 0.00 001-0150-520.011-00 UNIFORM ALLOWANCE 600.00 640.33 600.00 480.01 600.00 0.00 001-0150-520.040-00 FUEL 2,000.00 2,419.96 2,000.00 2,111.61 2,000.00 0.00 001-0150-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 873.45 0.00 0.00 0.00 0.00 001-0150-530.011-00 TELEPHONE & INTERNET 87.49 117.13 87.00 113.29 87.00 0.00 001-0150-530.051-00 INSURANCE 17,222.73 17,692.60 21,771.00 22,906.00 23,000.00 0.00 001-0150-530.060-00 ELECTRIC 33,000.00 18,609.16 20,000.00 15,320.38 20,000.00 0.00 001-0150-530.062-00 GAS 5,000.00 5,920.40 6,500.00 6,123.85 6,500.00 0.00 001-0150-530.072-00 OTHER EQUIPMENT REPAIR 3,000.00 1,040.36 1,500.00 343.13 1,500.00 0.00 001-0150-530.112-00 USDA CITY HALL COP LOAN PRI 5,000.00 5,000.00 5,000.00 0.00 5,000.00 0.00 001-0150-530.123-00 USDA CITY HALL COP LOAN INT 10,381.25 10,381.50 10,194.00 0.00 10,194.00 0.00 001-0150-530.124.00 Principal - Solar Loan 0.00 0.00 9,745.00 0.00 9,745.00 0.00 001-0150-530.125-00 Interest-Solar Loan 0.00 0.00 4,054.00 0.00 4,054.00 0.00 001-0150-530.201-00 OTHER CONTRACT SERVICES 10,000.00 1,502.88 4,000.00 8,224.72 8,000.00 0.00 MAINTENANCE CONTRACTS 222 47 952.31 322.00 238.40 322.00 0.00 001-0150-540.039-00
Department: 0150 - GENERAL GOVERNMENT BLDG Total: 112,137.38 100,757.45 112,121.00 81,537.17 116,105.00 0.00 Department: 0210 - POLICE
001-0210-500.000-00 SALARIES - FULL TIME EMPL 468,045.64 570,303.92 559,089.00 475,813.86 489,985.00 0.00 001-0210-500.010-00 SALARIES - RESERVES 0.00 31,461.60 0.00 11,470.36 13,177.00 0.00 001-0210-500.020-00 WAGES - HOURLY EMPLOYEES 0.00 0.00 0,00 0.00 37,856.00 0.00 Budget Notes
Budget Code Subject Description
WB P/T Record Clerk Budgeted for a PT Record Clerk for PD. $37,856 Annual
001-0210-500.030-00 OVERTIME 70,000.00 55,356.80 60,000.00 28,253.38 60,000.00 0.00 001-0210-500.045-00 BILINGUAL STIPEND 3,500.00 3,762.50 3,500.00 1,837.50 3,500.00 0.00 001-0210-510.000-00 PERS 204,097.58 218,384.37 168,637.00 134,457.57 168,637.00 0.00 001-0210-510.010-00 OASDI 41,160.49 49,818.70 47,360.00 41,310.55 47,360.00 0.00 001-0210-510.012-00 UNEMPLOYMENT INSURANCE 1,800.00 21.48 1,800.00 21.48 1,800.00 0.00 001-0210-510.020-00 GROUP HEALTH INSURANCE 108,880.15 114,489.15 169,699.00 99,638.92 169,699.00 0.00

5/22/2023 2:38:28 PM
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 001-0210-510.030-00 WORKER'S COMP INSURANCE 32,439.54 32,014.07 52,518.00 31,715.19 52,518.00 0.00 001-0210-520.000-00 OFFICE SUPPLIES 1,000.00 6,406.12 1,000.00 4,660.06 1,000.00 0.00 001-0210-520.010-00 DEPT OPERATING SUPPLIES 2,500.00 2,666.75 5,000.00 1,181.36 5,000.00 0.00 001-0210-520.011-00 UNIFORM ALLOWANCE 9,600.00 13,585.59 9,600.00 20,634.72 16,600.00 0.00 001-0210-520.012-00 K-9 EXPENSES 5,000.00 7,131.21 7,000.00 1,131.74 0.00 0.00 001-0210-520.030-00 MOTOR VEHICLE EXPENSE 20,000.00 22,941.00 25,000.00 27,846.90 38,500.00 0.00 Budget Notes
Budget Code Subject Description
WB Cameras in PD Car Estimated $12K for cameras in the Police Cars. 001-0210-520.040-00 FUEL 15,000.00 45,727.88 35,000.00 30,270.38 36,750.00 0.00 001-0210-530.009-00 OTHER PROFESSIONAL SERVICE 20,000.00 7,289.46 15,000.00 2,254.58 10,000.00 0.00 001-0210-530.011-00 TELEPHONE & INTERNET 19,999.83 19,917.23 20,000.00 17,976.01 20,000.00 0.00 001-0210-530.014-00 POSTAGE 800.00 768.99 800.00 68.00 800.00 0.00 001-0210-530.030-00 ADVERTISING 900.00 976.72 900.00 2,024.71 900.00 0.00 001.0210-530.060-00 ELECTRIC 1,000.00 761.33 700.00 798.61 700.00 0.00 001-0210-530.072-00 OTHER EQUIPMENT REPAIR 2,000.00 205.68 11,000.00 567.12 6,000.00 0.00 001-0210-530.089-00 COMMUNITY PROMOTION 1,000.00 0.00 1,000.00 1,937.89 1,000.00 0.00 001-0210-530.090-00 MEMBERSHIPS/SUBSCRIPTION 1,500.00 1,641.16 2,000.00 912.05 12,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Subscriptions for Cameras Subscriptions for Cameras in PD Cars 001-0210-530.091-00 MEETINGS & TRAINING 15,000.00 18,135.72 15,000.00 17,474.64 16,000.00 0.00 001-0210-530.094-00 OTHER EQUIPMENT 0.00 0.00 0.00 0.00 12,600.00 0.00 001-0210-530.201-00 OTHER CONTRACT SERVICES 185,000.00 153,411.16 160,000.00 165,430.99 160,000.00 0.00 001-0210-530.240-00 PROFESSIONAL DEVELOPMENT 0.00 3,022.55 0.00 0.00 0.00 0.00 001-0210-540.030-00 MACHINERY & EQUIPMENT 0.00 0.00 0.00 0.00 6,667.00 0.00 Budget Notes
Budget Code Subject Description
WB Message Board City to purchase a Message Board. Estimate $20,000 Split between departments- Police/Recreation/Sewer
Police = $6,666.67
5/22/2023 2:38:28 PM Page 7 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 001-0210-540.037-00 POLICE DEPT. REIMBURSEMEN 0.00 0.00 001-0210-540.038-00 TECHNOLOGY PURCH/REPLACE 12,500.00 12,500.00 0.00 001-0210-540.039-00 MAINTENANCE CONTRACTS 32,242.05 41,830.11 40,142.00 24,785.74 40,142.00 0.00 Department: 0210 - POLICE Total: 1,262,465.28 1,443,368.92 1,424,245.00 1,240,999.48 1,441,691.00 0.00 Department: 0220 - FIRE
001-0220-500.010-00 SALARIES - PART TIME EMPL 9,600.00 9,600.00 11,000.00 11,000.00 11,607.00 0.00 001-0220-510.010-00 OASDI 734.40 692.44 842.00 902.70 842.00 0.00 001-0220-510.050-00 DISABILITY INSURANCE 3,800.00 3,663.00 4,000.00 3,663.00 0.00 0.00 Budget Notes
Budget Code Subject Description
WB Disability Insurance Disability Insurance to be cancelled per Pat Borrelli. This is extra insurance carried on FD personnel that is not needed...Jenny 001-0220-520.010-00 DEPT OPERATING SUPPLIES 4,000.00 2,557.90 2,000.00 2,355.59 2,200.00 0.00 001-0220-520.011-00 UNIFORM ALLOWANCE 300.00 321.33 300.00 0.00 0.00 0.00 001-0220-520.030-00 MOTOR VEHICLE EXPENSE 4,000.00 4,316.49 500.00 908.90 12,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Motor Vehicle Exp Both Fire Engines need servicing and 1 Fire Engine needs 4 new tires. 001-0220-520.040-00 FUEL 1,000.00 893.70 1,000.00 818.23 1,050.00 0.00 001-0220-530.011-00 TELEPHONE 1,200.00 1,200.00 2,400.00 3,300.00 2,400.00 0.00 001-0220-530.030-00 ADVERTISING 100.00 0.00 0.00 0.00 0.00 0.00 001-0220-530.060-00 ELECTRIC 7,500.00 7,017.65 6,200.00 6,545.22 6,200.00 0.00 001-0220-530.062-00 GAS 1,000.00 956.58 1,000.00 1,978.45 2,100.00 0.00 001-0220-530.091-00 MEETINGS & TRAINING 4,800.00 4,800.00 4,800.00 0.00 4,800.00 0.00 001-0220-530.100-00 CONTRACT SERVICES 500.00 0.00 0.00 0.00 0.00 0.00 Department: 0220 - FIRE Total: 38,534.40 36,019.09 34,042.00 31,472.09 43,199.00 0.00 Department: 0230 - ANIMAL CONTROL
001-0230-500.000-00 SALARIES - FULL TIME EMPL 37,351.89 34,031.63 35,997.00 34,760.95 38,502.00 0.00 001-0230-500.030-00 OVERTIME 500.00 657.99 500.00 4,343.92 500.00 0.00 001-0230-510.000-00 PERS 9,490.10 10,339.27 7,275.00 6,992.50 8,409.00 0.00 001-0230-510.010-00 OASDI 2,895.67 2,576.65 2,792.00 2,965.73 2,792.00 0.00 001-0230-510.020-00 GROUP HEALTH INSURANCE 19,632.64 14,593.26 10,603.00 9,468.95 10,603.00 0.00 001-0230-510.030-00 WORKER'S COMP INSURANCE 4,416.88 4,274.88 4,918.00 4,234.97 4,918.00 0.00 5/22/2023 2:38:28 PM Page 8 of /6
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 001-0230-520.000-00 OFFICE SUPPLIES 0.00 73.52 0.00 0.00 0.00 0.00 001-0230-520.010-00 DEPT OPERATING SUPPLIES 500.00 1,262.41 600.00 3,035.44 1,500.00 0.00 001-0230-520.011-00 UNIFORM ALLOWANCE 500.00 -895.25 500.00 -1,259.02 500.00 0.00 001-0230-520.014-00 WEED ABATEMENT 300.00 2,500.00 0.00 0.00 0.00 0.00 001-0230-520.030-00 MOTOR VEHICLE EXPENSE 400.00 0.00 400.00 0.00 400.00 0.00 001-0230-530.009-00 OTHER PROFESSIONAL SERVICE 500.00 2,198.00 3,000.00 0.00 3,000.00 0.00 001-0230-530.014-00 POSTAGE 500.00 0.00 0.00 0.00 0.00 0.00 001-0230-530.030-00 ADVERTISING 800.00 702.14 800.00 0.00 250.00 0.00 001-0230-530.057-00 ANIMAL REG 1,500.00 0.00 1,000.00 0.00 250.00 0.00 001-0230-530.091-00 MEETINGS & TRAINING 2,500.00 441.03 1,500.00 0.00 500.00 0.00 001-0230.530.201-00 Departmen: 0730- AMA CONTROL TOl: 1,000.00 1,392.45 1,500.00 585.86 500.00 0.00 82,787.18 74,147.98 71,385.00 65,129.30 72,624.00 0.00
Department: 0410 - PLANNING
001-0410-500.005-00 CDD - SALARIES FULL TIME 13,024.92 11,688.25 13,644.00 15,872.83 17,299.00 0.00 001-0410-510.000-00 PERS 1,320.38 1,063.95 1,341.00 605.26 781.00 0.00 001-0410-510.010-00 OASDI 996.41 851.54 1,044.00 1,035.06 1,044.00 0.00 001-0410-510.012-00 UNEMPLOYMENT INSURANCE 0.00 99.72 0.00 28.03 0.00 0.00 001-0410-510.020-00 GROUP HEALTH INSURANCE 2,331.65 2,176.23 2,355.00 2,342.14 2,355.00 0.00 001-0410-510.030-00 WORKER'S COMP INSURANCE 687.07 664.98 765.00 658.78 765.00 0.00 001-0410-520.030-00 MOTOR VEHICLE EXPENSE 312.00 272.00 312.00 88.98 312.00 0.00 001-0410-530.009-00 OTHER PROFESSIONAL SERVICE 18,000.00 36,261.34 18,000.00 57,295.85 20,000.00 0.00 001-0410-530.011-00 TELEPHONE 87.49 117.13 87.00 129.19 87.00 0.00 001-0410-530.030-00 ADVERTISING 1,000.00 1,720.00 1,000.00 3,654.12 2,000.00 0.00 001-0410-530.040-00 PRINTING & BINDING 0.00 0.00 0.00 12.80 0.00 0.00 001-0410-530.090-00 MEMBERSHIPS/SUBSCRIPTION 0.00 0.00 0.00 1,088.94 0.00 0.00 001-0410-530.091-00 MEETINGS & TRAINING 0.00 441.43 0.00 0.00 10,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Training Planning Commissioner Academy Training
001-0410-530.094-00 PLANNING/CONSTRUCT LICEN 25,000.00 5,530.44 0.00 0.00 0.00 0.00 001-0410-530.201-00 OTHER CONTRACT SERVICES 0.00 115,647.71 60,000.00 207,173.75 60,000.00 0.00 5/22/2023 2:38:28 PM Page 9 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 001-0410-530.212-00 377 4TH ST CANNABIS DISTRIB 3,000.00 0.00 3,000.00 0.00 3,000.00 0.00 001-0410-530.230-00 PROJECT/DEV EXPENSES TOW 12,000.00 16,410.68 12,000.00 0.00 12,000.00 0.00 001-0410-540.039-00 MAINTENANCE CONTRACTS 322.42 692.99 322.00 238.40 250.00 0.00 001-0410-540.040-00 SB 1186 STATE BUSINESS FEE E 0.00 156.80 1,444.00 8.80 250.00 0.00 Department: 0410 - PLANNING Total: 78,082.34 193,795.19 115,314.00 290,232.93 130,143.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT
001-0460-500.000-00 SALARIES - FULL TIME EMPL 37,749.60 35,315.06 42,773.00 39,530.48 44,013.00 0.00 001-0460-510.000-00 PERS 11,034.61 12,006.74 9,543.00 8,970.84 10,718.00 0.00 001-0460-510.010-00 OASDI 2,887.84 2,603.80 3,272.00 3,004.65 3,272.00 0.00 001-0460-510.020-00 GROUP HEALTH INSURANCE 15,687.56 15,549.96 18,275.00 14,825.34 18,275.00 0.00 001-0460-520.010-00 DEPT OPERATING SUPPLIES 200.00 413.92 1,000.00 176.48 1,000.00 0.00 001-0460-520.030-00 MOTOR VEHICLE EXPENSE 1,800.00 1,800.00 1,980.00 1,575.00 1,980.00 0.00 001-0460-530.009-00 OTHER PROFESSIONAL SERVICE 200.00 0.00 0.00 0.00 0.00 0.00 001-0460-530.011-00 TELEPHONE 1,287,49 1,317.13 1,200.00 1,143.29 1,200.00 0.00 001-0460-530.090-00 MEMBERSHIPS & DUES 0.00 350.00 350.00 350.00 350.00 0.00 001-0460-530.091-00 MEETINGS & TRAINING 1,150.00 1,500.00 1,500.00 0.00 500.00 0.00 001-0460-530.201-00 OTHER CONTRACT SERVICES 0.00 316.54 0.00 300.52 300.00 0.00 001-0460-540.039:00 MAINTENANCE CONTRACTS 161.21 346.48 161.00 119.17 161.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT Total: 72,158.31 71,519.63 80,054.00 69,995.77 81,769.00 0.00 Department: 0610 - PARKS
001-0610-500.000-00 SALARIES - FULL TIME EMPL 27,084.33 19,732.02 28,931.00 24,510.67 27,926.00 0.00 001-0610-500.030-00 OVERTIME 2,000.00 2,211.11 2,000.00 3,873.29 2,000.00 0.00 001-0610-510.000-00 PERS 2,584.40 2,196.70 2,610.00 2,092.31 2,477.00 0.00 001-0610-510.010-00 OASDI 2,224.95 266.50 2,366.00 2,134.91 2,366.00 0.00 001-0610-510.012-00 UNEMPLOYMENT INSURANCE 200.00 0.00 200.00 0.00 200.00 0.00 001-0610-510.020-00 GROUP HEALTH INSURANCE 11,116.09 10,447.79 10,375.00 10,559.00 10,375.00 0.00 001-0610-510.030-00 WORKER'S COMP INSURANCE 2,797.36 2,707.42 3,115.00 2,682.15 3,115.00 0.00 001-0610-520.010-00 DEPT OPERATING SUPPLIES 35,000.00 48,130.57 40,000.00 27,234.88 40,000.00 0.00 001-0610-520.011-00 UNIFORM ALLOWANCE 350.00 486.94 350.00 415.57 600.00 0.00 001-0610-520.030-00 MOTOR VEHICLE EXPENSE 7,000.00 3,441.43 5,000.00 5,693.11 5,000.00 0.00 001-0610-520.040-00 FUEL 0.00 0.00 3,000.00 0.00 200.00 0.00 5/22/2023 2:38:28 PM Page 10 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 001-0610-530.011-00 TELEPHONE 87.49 1,337.13 87.00 1,259.29 1,500.00 0.00 001-0610-530.030-00 ADVERTISING 200.00 126.00 200.00 0.00 200.00 0.00 001-0610-530.051-00 INSURANCE 17,222.73 17,692.60 21,771.00 22,906.00 23,000.00 0.00 001-0610-530.060-00 ELECTRIC 1,500.00 762.12 900.00 462.81 900.00 0.00 001-0610-530.072-00 OTHER EQUIPMENT REPAIR 5,000.00 19,934.01 5,000.00 7,185.88 9,000.00 0.00 001-0610-530.080-00 EQUIPMENT RENTAL 500.00 0,00 500.00 119.60 500.00 0.00 001-0610-530.090-00 MEMBERSHIPS/SUBSCRIPTION 0.00 0.00 0.00 1.95 0.00 0.00 001-0620-530.201-00 OTHER CONTRACT SERVICES 15,000.00 33,712.32 20,000.00 29,675.47 73,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Borrelli Park Repair Borrelli Park Additional wark due to rodents Quote from Eric Doss DBA Incentive New
$5060.00
WB Tree Maintenance Tree Maintenance $40K
001-0610-540.011-00 BUILDINGS 1,600.00 1,943.92 1,600.00 2,598.66 1,600.00 0.00 001-0610-540.030-00 MACHINERY & EQUIPMENT 15,500.00 15,922.45 65,500.00 58,263.65 65,500.00 0.00 001-0610-540.039-00 MAINTENANCE CONTRACTS 322.42 692.99 322.00 238.40 322.00 0.00 Department: 0610 - PARKS Total: 147,289.77 181,744.02 213,827.00 201,907.60 269,781.00 0.00 Department: 0999 - MISSING DESCRIPTION
001-0999-990.099-00 TRANS OF FUNDS OUT 128,000.00 339,336.00 135,072.00 135,072.00 72,072.00 0.00 Budget Notes
Budget Code Subject Description
WB FY23/24 - Equpment Replace Equipment to be replaced by MidValley IT Quote #MVQQ7078
Replacement of 5 Computers with licensing. $9,052.12
Quote #: MVQQ7079
Replacement of 3 laptops with licensing. $5,457.55
Total $15000
WB Transfer Out Items COPS SLESF (Fund #005) = $60K Police Cars Soalr Loan to Sewer Fund = $7,072
Department: 0999 - MISSING DESCRIPTION Total: 128,000.00 339,336.00 135,072.00 135,072.00 72,072.00 0.00 Expense Total: 2,206,526.65 2,813,745.86 2,535,530.00 2,583,590.19 2,660,949.00 0.00 Fund: 001 - GENERAL FUND Surplus (Deficit): 107,741.26 226,710.02 25,015.00 -151,890.93 108,772.00 0.00 5/22/2023 2:38:28 PM Page 11 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Fund: 002 - UTILITY TAX FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
002-0000-400.074-00 UTILITY TAX 210,741.18 282,770.26 260,000.00 164,265.24 290,000.00 0.00 002-0000-430.057-00 LOAN REPAYMENT 20,000.04 18,333.44 35,000.00 18,333.37 20,000.00 0.00 002-0000-450.000-00 INTEREST 3,000.00 2,749.93 3,000.00 2,750.00 3,000.00 0.00 002-0000-450.031-00 CONTRIBUTION PROJECT / GRA 0.00 7,000.00 0.00 0.00 0.00 0.00 002-0000-990.099-00 TRANSFER IN 211,595.00 0.00 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 445,336.22 310,853.63 298,000.00 185,348.61 313,000.00 0.00 Revenue Total: 445,336.22 310,853.63 298,000.00 185,348.61 313,000.00 0.00 Expense
Department: 0110 - CITY COUNCIL
002-0110-530.089-00 COMMUNITY PROMOTION 0.00 60,000.00 0.00 0.00 0.00 0.00 Department: 0110 - CITY COUNCIL Total: 0.00 60,000.00 0.00 0.00 0.00 0.00 Department: 0145 - UUT
002-0145-520.010-00 DEPT OPERATING SUPPLIES 0.00 11,071.36 0.00 0.00 0.00 0.00 002-0145-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 48,675.62 0.00 3,172.50 0.00 0.00 002-0145-530.089-00 COMMUNITY PROMOTION 5,000.00 5,000.00 5,000.00 0.00 5,000.00 0.00 002-0145-530.201-00 OTHER CONTRACT SERVICES 0.00 205,551.30 0.00 17,027.29 0.00 0.00 002-0145-540.021-00 IMPROV OTHER THAN BLDGS 0.00 -7,642.00 0.00 0.00 0.00 0.00 Department: 0145 -UUT Total: 5,000.00 262,656.28 5,000.00 20,199.79 5,000.00 0.00 Department: 0147 - SUMMER YOUTH Y-LEAD
002-0147-530.201-00 OTHER CONTRACT SERVICES 226,000.00 0.00 22,000.00 29,500.00 22,000.00 0.00 Department: 0147-SUMMER YOUTH Y-LEAD Total: 226,000.00 0.00 22,000.00 29,500.00 22,000.00 0.00 Department: 0150 - GENERAL GOVERNMENT BIDG
002-0150-540.020-00 OTHER IMPROVEMENTS 0.00 0.00 18,460.00 0.00 0.00 0.00 Department: 0150- GENERAL GOVERNMENT BLDG Total: 0.00 0.00 18,460.00 0.00 0.00 0.00 Department: 0999 - MISSING DESCRIPTION
002-0999-990.099-00 TRANS OF FUNDS OUT 214,336.00 0.00 268,000.00 241,422.00 286,345.00 0.00 Department: 0999 - MISSING DESCRIPTION Total: 214,336.00 0.00 268,000.00 241,422.00 286,345.00 0.00 Expense Total: 445,336.00 322,656.28 313,460.00 291,121.79 313,345.00 0.00 Fund: 002 - UTILITY TAX FUND Surplus (Deficit): 0.22 -11,802.65 -15,460.00 -105,773.18 -345.00 0.00 5/22/2023 2:38:28 PM Page 12 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 005 - COPS SLESF
Revenue
Department: 0000 - MISSING DESCRIPTION
005-0000-420.031-00 SJVAPC REIMBURSEMENT 25,000.00 0.00 25,000.00 0.00 0.00 0.00 005-0000-990.099-00 TRANSFER IN 58,000.00 0.00 25,000.00 0.00 60,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Transfer In Transfer In from General Fund $60,000 - 2 Police Cars -
Department: 0000 - MISSING DESCRIPTION Total: 83,000.00 0.00 50,000.00 0.00 60,000.00 0.00 Revenue Total: 83,000.00 0.00 50,000.00 0.00 60,000.00 0.00 Expense
Department: 0210 - POLICE
005-0210-540.031-00 EQUIP SLESF 83,000.00 0.00 50,000.00 0.00 60,000.00 0.00 Budget Notes
Budget Code Subject Description
wB PD Charger/Outfitting 2 New Police Cars (Chargers) & Outfiting Breakdown:
$8OK from ARPA
$60K from SLEF
Department: 0210 - POLICE Total: B3,000.00 0.00 50,000.00 0.00 60,000.00 0.00 Expense Total: 83,000.00 0.00 50,000.00 0.00 60,000.00 0.00 Fund: 005 - COPS SLESF Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 008 - CDBG REUSE FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
008-0000-990.099-00 TRANSFER IN 222,578.00 0.00 0.00 0.00 0.00 0.00 Department: 0000-MISSING DESCRIPTION Total: 222,678.00 0.00 0.00 0.00 0.00 0.00 Revenue Total: 222,578.00 0.00 0.00 0.00 0.00 0.00
Expense
Department: 0140 - FINANCE
008-0140-530.201-00 OTHER CONTRACT SERVICES 222,678.00 0.00 0.00 0.00 0.00 0.00 Department: 0140 - FINANCE Total: 222,678.00 0.00 0.00 0.00 0.00 0.00 Expense Total: 222,678.00 0.00 0.00 0.00 0.00 0.00
Fund: 008 - CDBG REUSE FUND Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 5/22/2023 2:38:28 PM Page 13 ol 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 009 - COMMUNITY CENTER FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
009-0000-430.053-00 COMMUNITY CENTER RENTAL 30,000.00 9,603.87 30,000.00 8,625.40 15,000.00 0.00 009-0000-430.054-00 COMMUNITY CENTER CLEANIN 0.00 4,450.00 0.00 3,900.00 5,000.00 0.00 009-0000-450.033-00 DONATIONS COMMUNITY CEN 0.00 375.00 0.00 25.00 0.00 0.00 009-0000-990.099-00 TRANSFER IN 32,749.00 32,749.00 37,376.00 37,376.00 46,121.00 0.00 Budget Notes
Budget Code Subject Description
WB Transfer in from UUT Transfer in from UUT $46,121
Department: 0000 - MISSING DESCRIPTION Total: 62,749.00 47,177.87 67,376.00 49,926.40 66,121.00 0.00 Revenue Total: 62,749.00 47,177.87 67,376.00 49,926.40 66,121.00 0.00 Expense
Department: 0140 - FINANCE
009-0140-500.045-00 BILINGUAL STIPEND 0.00 940.82 950.00 43.76 950.00 0.00 009-0140-510.000-00 PERS 0.00 71.32 0.00 3.28 4.00 0.00 009-0140-510.010-00 PERS 0.00 69.73 0.00 3.23 4.00 0.00 Department: 0140 - FINANCE Total: 0.00 1,081.87 950.00 50.27 958.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG
009-0150-500.000-00 SALARIES - FULL TIME EMPL 5,426.57 5,544.45 5,900.00 4,832.07 5,490.00 0.00 009-0150-500.012-00 HOURLY SALARY-W 7,399.79 6,754.61 7,471.00 5,560.52 7,471.00 0.00 009-0150-500.030-00 OVERTIME 600.00 893.57 600.00 428.85 600.00 0.00 009-0150-510.000-00 PERS 739.91 920.25 539.00 775.66 856.00 0.00 009-0150-510.010-00 OASDI 1,027.12 989.23 1,069.00 815.35 1,069.00 0.00 009-0150-510.012-00 UNEMPLOYMENT INSURANCE 50.00 0.00 50.00 0.00 50.00 0.00 009-0150-510.020-00 GROUP HEALTH INSURANCE 2,027.83 1,592.52 1,532.00 1,367.71 1,532.00 0.00 009-0150-510.030-00 WORKER'S COMP INSURANCE 2,110.29 2,042.44 2,350.00 2,023.38 2,350.00 0.00 009-0150-520.010-00 DEPT OPERATING SUPPLIES 4,500.00 2,730.04 4,500.00 2,918.82 4,500.00 0.00 009-0150-520.011-00 UNIFORM ALLOWANCE 0.00 38.87 0.00 0.00 0.00 0.00 009-0150-520.040-00 FUEL 4,000.00 6,094.90 4,000.00 5,374.99 5,800.00 0.00 009-0150-530.011-00 TELEPHONE 0.00 457.01 0.00 358.71 500.00 0.00 009-0150-530.051-00 INSURANCE 17,222.73 17,692.60 21,771.00 22,906.00 23,000.00 0.00 5/22/2023 2:38:28 PM Page 14 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 009-0150-530.060-00 ELECTRIC 6,000.00 5,051.77 5,000.00 230.70 500.00 0.00 009-0150-530.062-00 GAS 1,500.00 2,389.57 1,500.00 1,824.53 2,000.00 0.00 009-0150-530.201-00 OTHER CONTRACT SERVICES 7,000.00 4,893.69 7,000.00 2,055.67 3,000.00 0.00 009-0150-540.011-00 BUILDINGS 500.00 0.00 500.00 0.00 500.00 0.00 009-0150-540.020-00 OTHER IMPROVEMENTS 1,000.00 0.00 1,000.00 0.00 4,300.00 0.00 Budget Notes
Budget Code Subject Description
WB Goman Center Paint Bar -- $500
Replace Gutters $3800
Total $4300
009-0150-540.030-00 MACHINERY & EQUIPMENT 1,000.00 3,291.29 1,000.00 319.00 1,000.00 0.00 009-0150-540.039-00 MAINTENANCE CONTRACTS 644.84 1,237.27 645.00 951.74 645.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG Total: 62,749.08 62,614.08 66,427.00 52,743.70 65,163.00 0.00 Expense Total: 62,749.08 63,695.95 67,377.00 52,793.97 66,121.00 0.00 Fund: 009 - COMMUNITY CENTER FUND Surplus (Deficit): -0.08 - 16,518.08 -1.00 -2,867.57 0.00 0.00 Fund: 010 - GAS TAX 2105 FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
010-0000-420.022-00 GAS TAX 2105 33,258.00 29,742.89 37,111.00 31,291.91 39,884.00 0.00 Budget Notes
Budget Code Subject Description
WB Emergency Street Tree Trimming Emergency Street Tree Trimming = $39,884 010-0000-420.023-00 GAS TAX 2106 0.00 0.00 0.00 3,906.28 0.00 0.00 010-0000-420.025-00 GAS TAX 2107.5 0.00 0.00 0.00 2,000.00 0.00 0.00 010-0000-990.099-00 TRANSFER IN 134,742.00 0.00 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 168,000.00 29,742.89 37,111.00 37,198.19 39,884.00 0.00 Revenue Total: 168,000.00 29,742.89 37,111.00 37,198.19 39,884.00 0.00 5/22/2023 2:38:28 PM Page 15 ot 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
Department: 0310 - TRANSPORTATION
010-0310-530.201-00 OTHER CONTRACT SERVICES 168,000.00 29,959.55 50,000.00 13,608.35 39,884.00 0.00 Department: 0310 - TRANSPORTATION Total: 168,000.00 29,959.55 50,000.00 13,608.35 39,884.00 0.00 Expense Total: 168,000.00 29,959.55 50,000.00 13,608.35 39,884.00 0.00 Fund: 010 - GAS TAX 2105 FUND Surplus (Deficit): 0.00 -216.66 -12,889.00 23,589.84 0.00 0.00 Fund: 011 - GAS TAX 2106 FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
021-0000-420.021-00 GAS TAX 2106 19,308.00 17,646.22 20,960.00 18,499.23 22,228.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 19,308.00 17,646.22 20,960.00 18,499.23 22,228.00 0.00 Revenue Total: 19,308.00 17,646.22 20,960.00 18,499.23 22,228.00 0.00 Expense
Department: 0310 - TRANSPORTATION
011-0310-530.201-00 OTHER CONTRACT SERVICES 0.00 5,929.55 0.00 1,038.35 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 0.00 5,929.55 0.00 1,038.35 0.00 0.00 Expense Total: 0.00 5,929.55 0.00 1,038.35 0.00 0.00
Fund: 011 - GAS TAX 2106 FUND Surplus (Deficit): 19,308.00 11,716.67 20,960.00 17,460.88 22,228.00 0.00 Fund: 012 - GAS TAX 2107 FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
012-0000-420.023-00 GAS TAX 2107 42,298.00 35,077.96 51,519.00 35,576.92 47,906.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 42,298.00 35,077.96 51,519.00 35,576.92 47,906.00 0.00 Revenue Total: 42,298.00 35,077.96 51,519.00 35,576.92 47,906.00 0.00 Expense
Department: 0310 - TRANSPORTATION
012-0310-530.201-00 OTHER CONTRACT SERVICES 0.00 5,929.55 0.00 1,038.35 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 0.00 5,929.55 0.00 1,038.35 0.00 0.00 Expense Total: 0.00 5,929.55 0.00 1,038.35 0.00 0.00
Fund: 012 - GAS TAX 2107 FUND Surplus (Deficit): 42,298.00 29,148.41 51,519.00 34,538.57 47,906.00 0.00 5/22/2023 2:38:28 PM Page 16 ur 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 013 - GAS TAX 2107.5 FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
013-0000-420.024-00 GAS TAX 2107.5 2,000.00 2,000.00 2,000.00 0.00 2,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 2,000.00 2,000.00 2,000.00 0.00 2,000.00 0.00 Revenue Total: 2,000.00 2,000.00 2,000.00 0.00 2,000.00 0.00 Expense
Department: 0310 - TRANSPORTATION
013-0310-530.201-00 OTHER CONTRACT SERVICES 0.00 515.17 0.00 474.60 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 0.00 515.17 0.00 474.60 0.00 0.00 Expense Total: 0.00 515.17 0.00 474.60 0.00 0.00
Fund: 013 - GAS TAX 2107.5 FUND Surplus (Deficit): 2,000.00 1,484.83 2,000.00 -474.60 2,000.00 0.00 Fund: 014 - LOCAL TRANSPORTATION FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
014-0000-400.098-00 LOCAL TRANSPORTATION FUN 12,615.00 5,952.00 12,615.00 0.00 12,615.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 12,615.00 5,952.00 12,615.00 0.00 12,615.00 0.00 Revenue Total: 12,615.00 5,952.00 12,615.00 0.00 12,615.00 0.00 Fund: 014 - LOCAL TRANSPORTATION FUND Total: 12,615.00 5,952.00 12,615.00 0.00 12,615.00 0.00 Fund: 016 - SWIM POOL FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
016-0000-430.050-00 SWIMMING POOL FEES 10,000.00 25,248.85 10,000.00 15,270.00 20,500.00 0.00 016-0000-450.011-00 CONCESSION STAND 1,000.00 2,778.00 1,000.00 4,347.78 4,000.00 0.00 016-0000-450.030-00 CONTRIBUTIONS/PRIVATE SOU 2,200.00 5,571.01 2,200.00 5,075.00 4,000.00 0.00 016-0000-990.099.00 TRANSFER IN 108,938.00 108,938.00 137,078.00 137,078.00 152,246.00 0.00 Budget Notes
Budget Code Subject Description
WB Transfer in From UUT Transfer In from UUT $152,246
Department: 0000 - MISSING DESCRIPTION Total: 122,138.00 142,535.86 150,278.00 161,770.78 180,746.00 0.00 Revenue Total: 122,138.00 142,535.86 150,278.00 161,770.78 180,746.00 0.00 Expense
Department: 0120 - CITY MANAGER
016-0120-500.000-00 SALARIES - FULL TIME EMPL 3,125.12 3,061.63 3,125.00 4,067.46 4,378.00 0.00 5/22/20232:38:28 PM Page 17 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 016-0120-510.000.00 PERS 366.95 304.30 362.00 144.54 190.00 0.00 016-0120-510.010-00 OASDI 239.07 218.45 239.00 310.14 239.00 0.00 016-0120-510.020-00 GROUP HEALTH INSURANCE 218.24 143.95 168.00 217.04 168.00 0.00 016-0120-510.030-00 WORKER'S COMP INSURANCE 98.15 95.00 109.00 94.12 109.00 0.00 016-0120-520.030-00 MOTOR VEHICLE EXPENSE 95.00 80.00 96.00 30.81 96.00 0.00 Department: 0120 - CITY MANAGER Total: 4,143.53 3,903.33 4,099.00 4,864.11 5,180.00 0.00 Department: 0613 - RECREATION
016-0613-500.000-00 SALARIES - FULL TIME EMPL 15,591.31 14,011.90 26,012.00 22,200.31 24,981.00 0.00 016-0613-500.020-00 WAGES - HOURLY EMPLOYEES 15,000.00 22,539.15 15,000.00 24,036.17 26,540.00 0.00 016-0613-500.030-00 OVERTIME 1,000.00 121.75 1,000.00 3,094.44 1,000.00 0.00 016-0613-510.000-00 PERS 1,423.96 1,144.80 2,034.00 1,775.03 2,120.00 0.00 016-0613-510.010-00 OASDI 2,416.74 2,766.62 3,214.00 3,722.84 3,214.00 0.00 016-0613-510.012-00 UNEMPLOYMENT INSURANCE 5,777.00 38.92 5,777.00 5.91 0.00 0.00 016-0613-510.020-00 GROUP HEALTH INSURANCE 9,530.18 9,809.32 10,180.00 9,421.22 10,180.00 0.00 016-0613-510.030-00 WORKER'S COMP INSURANCE 1,717.68 1,662.45 2,732.00 1,646.94 2,732.00 0.00 016-0613-520.010-00 DEPT OPERATING SUPPLIES 16,000.00 29,067.50 16,000.00 13,186.13 16,000.00 0.00 016-0613-520.012-00 AQUATICS CENTER SUPPLIES 0.00 6,629.98 0.00 1,886.12 4,000.00 0.00 016-0613-520.013-00 CONCESSION SUPPLIES 2,200.00 2,702.04 2,200.00 1,933.13 2,200.00 0.00 016-0613-520.030-00 MOTOR VEHICLE EXPENSE 420.00 150.00 300.00 131.25 300.00 0.00 016-0613-530.011-00 TELEPHONE 349.96 457.01 350.00 408.71 350.00 0.00 016-0613-530.030-00 ADVERTISING 500.00 635.25 500.00 0.00 500.00 0.00 016-0613-530.051-00 INSURANCE 17,222.73 17,692.60 21,771.00 22,906.00 23,000.00 0.00 016-0613-530.060-00 ELECTRIC 18,000.00 14,853.78 10,000.00 17,029.37 18,840.00 0.00 016-0613-530.072-00 OTHER EQUIPMENT REPAIR 2,000.00 0.00 2,000.00 2,218.86 2,500.00 0.00 016-0613-530.091-00 MEETINGS & TRAINING 500.00 218.50 500.00 0.00 500.00 0.00 016-0613-530.201-00 OTHER CONTRACT SERVICES 2,000.00 16,120.58 2,000.00 8,347.35 10,000.00 0.00 016-0613-530.240-00 PROFESSIONAL DEVELOPMENT 1,000.00 287.65 750.00 10.46 750.00 0.00 016-0613-540.011-00 BUILDINGS 1,000.00 0.00 1,000.00 0.00 1,000.00 0.00 016-0613-540.020-00 OTHER IMPROVEMENTS 3,000.00 0.00 3,000.00 0.00 5,000.00 0.00 016-0613-540.021-00 Solar Loan Principal 0.00 0.00 9,745.00 0.00 9,745.00 0.00 016-0613-540.022-00 Solar Loan Interest 0.00 0.00 4,054.00 0.00 4,054.00 0.00 5/22/2023 2:38:28 PM Page 18 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 016-0613-540.030-00 MACHINERY & EQUIPMENT 700.00 0.00 700.00 658.92 700.00 0.00 016-0613-540.038-00 TECHNOLOGY PURCH/REPLACE 0.00 4,988.72 0.00 0.00 0.00 0.00 016-0613-540.039-00 MAINTENANCE CONTRACTS 644.84 1,496.59 645.00 476.74 645.00 0.00 Department: 0613 - RECREATION Total: 117,994.40 147,395.11 141,464.00 135,095.90 170,851.00 0.00 Department: 0999 - MISSING DESCRIPTION
016-0999-990.099-00 TRANS OF FUNDS OUT 0.00 0.00 4,715.00 4,715.00 4,715.00 0.00 Budget Notes
Budget Code Subject Description
WB Transfer Out Transfer Out - Solar loan to Sewer Fund $4,715
Department: 0999 - MISSING DESCRIPTION Total: 0.00 0.00 4,715.00 4,715.00 4,715.00 0.00 Expense Total: 122,137.93 151,298.44( 150,278.00 194,675.01 180,746.00 0.00 Fund: 016 - SWIM POOL FUND Surplus (Deficit: 0.07 -8,762.58 0.00 17,095.77 0.00 0.00 Fund: 017 - CITY WIDE LIGHTING & LAND
Revenue
Department: 0000 - MISSING DESCRIPTION
017-0000-450.000-00 INTEREST 100.00 5,711.43 100.00 111.24 100.00 0.00 017-0000-450.020-00 STREET LIGHTING ASSMNT 193,446.40 189,259.92 197,821.00 70,902.96 197,821.00 0.00 017-0000-450.036-00 ADVERTISING MARQUEE 0.00 150.00 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 193,546.40 195,121.35 197,921.00 71,014.20 197,921.00 0.00 Revenue Total: 193,546.40 195,121.35 197,921.00 71,014.20 197,921.00 0.00 Expense
Department: 0120 - CITY MANAGER
017-0120-500.000-00 SALARIES - FULL TIME EMPL 6,250.23 6,123.25 6,250.00 8,135.11 8,755.00 0.00 017-0120-500.020-00 WAGES - HOURLY EMPLOYEES 0.00 0.00 75.00 0.00 0.00 0.00 017-0120-510.000-00 PERS 733.90 608.57 724.00 291.19 383.00 0.00 017-0120-510.010-00 OASDI 478.14 436.71 484.00 620.30 484.00 0.00 017-0120-510.012-00 UNEMPLOYMENT INSURANCE 150.00 0.00 150.00 0.00 150.00 0.00 017-0120-510.020-00 GROUP HEALTH INSURANCE 436.48 296.55 336.00 434.00 336.00 0.00 017-0120-510.030-00 WORKER'S COMP INSURANCE 441.69 427.49 492.00 423.50 492.00 0.00 017-0120-520.030-00 MOTOR VEHICLE EXPENSE 192.00 160.00 192.00 61.62 192.00 0.00 017-0120-530.011-00 TELEPHONE 0.00 0.00 0.00 20.54 0.00 0.00 017-0120-530.090-00 MEMBERSHIPS/SUBSCRIPTION 40.00 0.00 40.00 0.00 40.00 0.00 5/22/2023 2:38:28 PM Page 19 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 017-0120-530 091-00 MEETINGS & TRAINING 1,000.00 0.00 1,000.00 0.00 1,000.00 0.00 Department: 0120 - CITY MANAGER Total: 9,722.44 8,052.57 9,743.00 9,986.26 11,832.00 0.00 Department: 0140 - FINANCE
017-0140-500.000-00 SALARIES - FULL TIME EMPL 6,949.50 6,903.36 7,775.00 7,736.99 8,607.00 0.00 017-0140-500.030-00 OVERTIME 0.00 1,34 0.00 0.59 0.00 0.00 017-0140-510.000-00 PERS 537.34 520.14 581.00 324.61 406.00 0.00 017-0140-510.010-00 OASDI 531.64 520.76 595.00 350.75 595.00 0.00 017-0140-510.012-00 UNEMPLOYMENT INSURANCE 0.00 100.17 0.00 37.38 0.00 0.00 017-0140-510.020-00 GROUP HEALTH INSURANCE 2,381.39 2,421.68 2,580.00 2,399.53 2,580.00 0.00 027-0140-510.030-00 WORKER'S COMP INSURANCE 588.92 569.99 656.00 564.67 656.00 0.00 017-0140-520.030-00 MOTOR VEHICLE EXPENSE 96.00 96.00 96.00 16.00 96.00 0.00 Department: 0140 - FINANCE Total: 11,084.79 11,133.44 12,283.00 11,430.52 12,940.00 0.00 Department: 0260 - STREET LIGHTING
017-0260-530.060-00 ELECTRIC 70,000.00 57,656.31 50,000.00 46,243.16 50,000.00 0.00 017-0260-530.080-00 EQUIPMENT RENTAL 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 Department: 0260 - STREET LIGHTING Total: 72,000.00 57,656.31 52,000.00 46,243.16 52,000.00 0.00 Department: 0270 - LANDSCAPE LLD
017-0270-530.009-00 OTHER PROFESSIONAL SERVICE 3,000.00 2,155.13 3,000.00 2,147.26 3,000.00 0.00 017-0270-530.201-00 OTHER CONTRACT SERVICES 2,000.00 26.25 2,000.00 0.00 2,000.00 0.00 Department: 0270 - LANDSCAPE LLD Total: 5,000.00 2,181.38 5,000.00 2,147.26 5,000.00 0.00 Department: 0610 - PARKS
017-0610-500.000-00 SALARIES - FULL TIME EMPL 50,369.20 44,070.26 58,166.00 49,617.63 56,366.00 0.00 017-0610-500.030-00 OVERTIME 3,500.00 2,974.24 3,500.00 5,796.58 3,500.00 0.00 017-0610-510.000-00 PERS 4,274.63 3,777.60 4,501.00 4,106.40 4,927.00 0.00 017-0610-510.010-00 OASDI 3,853.24 3,516.44 4,450.00 4,184.05 4,450.00 0.00 017-0610-510.012-00 UNEMPLOYMENT INSURANCE 300.00 2359000 300.00 0.00 300.00 0.00 017-0610-510.020-00 GROUP HEALTH INSURANCE 22,713.30 25,312.00 23,795.86 25,312.00 0.00 017-0610-510.030-00 WORKER'S COMP INSURANCE 5,398.41 5,224.85 6,011.00 5,176.06 6,011.00 0.00 017-0610-520.010-00 DEPT OPERATING SUPPLIES 500.00 1,001.05 500.00 61.83 500.00 0.00 017-0610-520.011-00 UNIFORM ALLOWANCE 700.00 849.57 700.00 708.54 700.00 0.00 017-0610-520.030-00 MOTOR VEHICLE EXPENSE 360.00 560.00 600.00 325.00 600.00 0.00 017-0610-520.040-00 FUEL 1,200.00 2,262.29 1,200.00 1,151.79 1,200.00 0.00 5/22/20232:38:28 PM Page 20 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 017-0610-530.000-00 ACCOUNTING & AUDITING 140.00 1,021.75 454.00 514.40 454.00 0.00 017-0610-530.011-00 TELEPHONE 0.00 100.00 0.00 230.00 0.00 0.00 017-0610-530.030-00 ADVERTISING 200.00 344.80 200.00 327.23 200.00 0.00 017-0610-530.072-00 OTHER EQUIPMENT REPAIR 900.00 1,306.06 900.00 0.00 900.00 0.00 017-0610-530.201-00 OTHER CONTRACT SERVICES 0.00 136.90 0.00 0.00 0.00 0.00 Department: 0610-PARKS Total: 94,408.78 91,018.92 106,794.00 95,995.37 105,420.00 0.00 Expense Total: 192,216.01 170,042.62 185,820.00 165,802.57 183,192.00 0.00 Fund: 017 - CITY WIDE LIGHTING & LAND Surplus (Deficit): 1,330.39 25,078.73 12,101.00 -94,788.37 10,729.00 0.00 Fund: 018 - TRAFFIC SAFETY FUND
Revenue
Department: 0000-MISSING DESCRIPTION
018-0000-440.000-00 VEHICLE CODE FINES 2,000.00 3,943.10 2,000.00 2,084.99 2,000.00 0.00 018-0000-990.099-00 TRANSFER IN 5,400.00 0.00 5,400.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 7,400.00 3,943.10 7,400.00 2,084.99 2,000.00 0.00 Revenue Total: 7,400.00 3,943.10 7,400.00 2,084.99 2,000.00 0.00 Expense
Department: 0240 - MISSING DESCRIPTION
018-0240-530.009-00 OTHER PROFESSIONAL SERVICE 7,400.00 547.50 7,400.00 3,355.05 2000.00 0.00 Department: 0240 - MISSING DESCRIPTION Total: 7,400.00 547.50 1,400.00 3,355.05 0.00 Expense Total: 7,400.00 547.50 7,400.00 3,355.05 2,000.00 0.00 Fund: 018 - TRAFFIC SAFETY FUND Surplus (Deficit): 0.00 3,395.60 0.00 -1,270.06 0.00 0.00 Fund: 019 - RECREATION FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
019-0000-420.025-00 RECREATION PROGRAM FEES 0.00 6,684.50 6,228.00 6,000.00 0.00 019-0000-420.053-00 TRIBUTE TREE PROGRAM REVE 0.00 1,290.62 830.77 1,200.00 0.00 019-0000-420.054.00 RECREATION PROGRAM FEES - 3,000.00 5,945.54 5,030.00 5,000.00 0.00 019-0000-430.035-00 TRIBUTE BENCH REVENUE 0.00 0.00 0.00 3,385.16 0.00 0.00 019-0000-430.050-00 COMMUNITY EVENT - SPECIAL 0.00 0.00 0.00 1,917.62 0.00 0.00 019-0000-430.052-00 RECREATION PROGRAM FEES - 4,000.00 4,691.72 3,338.00 4,500.00 0.00 019-0000-430.053-00 COMMUNITY EVENT - COLOR R 10,000.00 8,530.00 1,947.00 5,000.00 0.00 029.0000-430.055-00 RECREATION PROGRAM FEES - 9,000.00 9,587.51 1,580.00 6,600.00 0.00 019-0000-430.056-00 RECREATION PROGRAM FEES- 1,250.00 1,333.13 1,500.00 1,500.00 0.00 5/22/2023 2:38:28 PM Page 21 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 019-0000-430.057-00 COMMUNITY EVENT - HALLOW 1,000.00 2,338.33 2,000.00 3,226.30 3,000.00 0.00 019-0000-450.033-00 COMMUNITY EVENT - FISHING 1,000.00 2,670.64 2,000.00 2,854.30 3,000.00 0.00 019-0000-990.099-00 TRANSFER IN 72,649.00 72,649.00 66,968.00 66,968.00 87,978.00 0.00 Budget Notes
Budget Code Subject Description
WB Transfer in from UUT Transfer in from UUT $87,978
Department: 0000 - MISSING DESCRIPTION Total: 101,899.00 115,720.99 109,668.00 98,805.15 123,778.00 0.00 Department: 0613 - RECREATION
019-0613-613.053-00 COMMUNITY EVENT - CHRIST 2,000.00 4,780.70 3,000.00 6,613.40 5,000.00 0.00 Department: 0613 - RECREATION Total: 2,000.00 4,780.70 3,000.00 6,613.40 5,000.00 0.00 Revenue Total: 103,899.00 120,501.69 112,668.00 105,418.55 128,778.00 0.00 Expense
Department: 0142 - CITY CLERK
019-0142-500.000-00 SALARIES- FULL TIME EMPL 12,641.98 12,068.70 15,790.00 13,734.83 15,406.00 0.00 019-0142-510.000-00 PERS 1,272.58 1,192.22 1,670.00 1,448.21 1,728.00 0.00 019-0142-510.010-00 OASDI 967.11 897.15 0.00 1,029.81 0.00 0.00 019-0142-510.012-00 UNEMPLOYMENT INSURANCE 50.00 77.83 50.00 11.81 50.00 0.00 019-0142-510.020-00 GROUP HEALTH INSURANCE 4,148.40 6,660.13 6,944.00 7,116.08 6,944.00 0.00 019-0142-510.030-00 WORKER'S COMP INSURANCE 1,177.83 1,139.97 1,202.00 1,129.32 1,202.00 0.00 019-0142-520.030-00 MOTOR VEHICLE EXPENSE 432.00 310.00 504.00 365.00 504.00 0.00 019-0142-530.011-00 TELEPHONE & INTERNET 1,549.96 0.00 1,550.00 140.00 1,550.00 0.00 019-0142-530.240-00 PROFESSIONAL DEVELOPMENT 2,400.00 4,393.68 2,100.00 1,081.12 2,100.00 0.00 Department: 0142 - CITY CLERK Total: 24,639.86 26,739.68 29,810.00 26,056.18 29,484.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG
019-0150-500.000-00 SALARIES - FULL TIME EMPLOY 0.00 5,117.76 0.00 4,186.83 4,600.00 0.00 019-0150-500.010-00 SALARIES - PART TIME EMPL 7,399.79 7,487.81 7,471.00 6,460.52 7,097.00 0.00 019-0150-500.030-00 OVERTIME 0.00 883.26 0.00 292.09 0.00 0.00 019-0150-510.000-00 PERS 572.15 888.80 390.00 728.06 797.00 0.00 019-0150-510.010-00 OASDI 566.08 1,011.73 571.00 825.77 571.00 0.00 019-0150-510.020-00 GROUP HEALTH INSURANCE 1,111.83 1,096.23 1,178.00 1,052.16 1,178.00 0.00 019-0150-510.030-00 WORKER'S COMP INSURANCE 1,963.06 1,899.95 2,186.00 1,882.21 2,186.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG Total: 11,612.91 18,385.54 11,796.00 15,427.64 16,429.00 0.00 5/22/2023 2:38:28 PM Page 22 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Department: 0440 - FARMERS MARKET
019-0440-520.030-00 DEPT OPERATING SUPPLIES - H 1,000.00 1,713.71 2,000.00 1,547.60 2,000.00 0.00 019-0440-520.050-00 DEPT OPS SUPPLIES -SPECIAL E 0.00 0.00 0.00 2,618.54 0.00 0.00 Department: 0440 - FARMERS MARKET Total: 1,000.00 1,713.71 2,000.00 4,166.14 2,000.00 0.00 Department: 0613 - RECREATION
019-0613-500.000-00 SALARIES - FULL TIME EMPL 0.00 12,389.52 0.00 6,636.18 7,308.00 0.00 019-0613-500.020-00 WAGES - HOURLY EMPLOYEES 0.00 0.00 75.00 0.00 0.00 0.00 019-0613-500.030-00 OVERTIME 0.00 156.83 0.00 639.00 0.00 0.00 019-0613-510.000-00 PERS 7,523.25 16,973.72 5,136.00 10,632.97 12,283.00 0.00 019-0613-510.010-00 OASDI 0.00 830.32 6.00 536.97 6.00 0.00 019-0613-510.012-00 UNEMPLOYMENT INSURANCE 100.00 0.00 100.00 0.00 100.00 0.00 019-0613-510.020-00 GROUP HEALTH INSURANCE 9,412.54 9,330.04 4,984.00 8,895.19 9,000.00 0.00 019-0613-510.030-00 WORKER'S COMP INSURANCE 1,717.68 1,662.45 1,093.00 1,646.94 1,093.00 0.00 019.0613-520.010-00 DEPT OPERATING SUPPLIES 13,000.00 8,602.96 11,000.00 10,885.45 11,000.00 0.00 019-0613-520.030-00 MOTOR VEHICLE EXPENSE 200.00 497.94 200.00 0.00 200.00 0.00 019-0613-520.035-00 TRIBUTE BENCH EXPENSE 0.00 0.00 0.00 3,780.05 0.00 0.00 019-0613-520.040-00 DEPT OPS SUPPLIES - FISHING 1,000.00 2,432.66 2,000.00 3,291.96 2,000.00 0.00 019-0613-520.050-00 TRIBUTE TREE PROGRAM EXPE 0.00 227.97 0.00 0.00 0.00 0.00 019-0613-520.060-00 DEPT OPERATING SUPPLIES - A 0.00 1,368.44 0.00 5,732.45 1,500.00 0.00 019-0613-530.009-00 OTHER PROFESSIONAL SERVICE 1,250.00 0.00 1,250.00 0.00 0.00 0.00 019-0613-530.011-00 TELEPHONE 1,549.96 457.01 1,550.00 358.70 1,550.00 0.00 019-0613-530.014-00 POSTAGE 0.00 525.00 0.00 0.00 0.00 0.00 019-0613-530.030-00 ADVERTISING 1,000.00 1,346.17 1,000.00 1,000.00 1,000.00 0.00 019-0613-530.060-00 ELECTRIC 3,900.00 2,768.55 3,000.00 415.04 3,000.00 0.00 019-0613-530.090-00 MEMBERSHIPS/SUBSCRIPTION 250.00 384.00 425.00 0.00 425.00 0.00 019-0613-530.091-00 MEETINGS & TRAINING 1,400.00 811.50 2,750.00 3,437.41 2,750.00 0.00 019-0613-530.092-00 BANK FEES 0.00 350.07 300.00 34.00 300.00 0.00 019-0613-530.201-00 OTHER CONTRACT SERVICES 15,500.00 16,276.10 15,500.00 11,069.14 15,500.00 0.00 019-0613-530.240.00 Professional Development Exp 0.00 0.00 350.00 0.00 350.00 0.00 019-0613-540.011-00 BUILDINGS 0.00 1,170.59 0.00 0.00 0.00 0.00 019-0613-540.039-00 MAINTENANCE CONTRACTS 5,842.34 6,694.09 5,842.00 5,934.12 1,500.00 0.00 5/22/2023 2:38:28 PM Page 23 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 019-0613-613.020-00 DEPT OPS SUPPLIES - COLOR R 2,000.00 4,356.96 10,000.00 5,484.53 5,000.00 0.00 019-0613-613.030-00 DEPT OPS SUPPLIES - CHRISTM 1,000.00 4,511.57 2,500.00 6,510.10 5,000.00 0.00 Department: 0613 - RECREATION Total: 66,645.77 94,124.46 69,061.00 86,920.20 80,865.00 0.00 Expense Total: 103,898.54 140,963.39 111,667.00 132,570.16 128,778.00 0.00 Fund: 019 - RECREATION FUND Surplus (Deficit): 0.46 - 20,461.70 1.00 - 27,151.61 0.00 0.00 Fund: 020 - CMAQ
Revenue
Department: 0000 - MISSING DESCRIPTION
020-0000-420.038-00 ST TRANSPORTATION PROGRA 4,158,000.00 488,458.15 0.00 72,839.63 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 4,158,000.00 488,458.15 0.00 72,839.63 0.00 0.00 Revenue Total: 4,158,000.00 488,458.15 0.00 72,839.63 0.00 0.00 Expense
Department: 0310 - TRANSPORTATION
020-0310-530.201-00 OTHER CONTRACT SERVICES 3,945,000.00 31,164.53 0.00 83,238.69 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 3,945,000.00 31,164.53 0.00 83,238.69 0.00 0.00 Expense Total: 3,945,000.00 31,164.53 0.00 83,238.69 0.00 0.00 Fund: 020 - MAQ Surplus (Deficit): 213,000.00 457,293.62 0.00 -10,399.06 0.00 0.00 Fund: 021 - REGIONAL STREET TRANSPORTATION PROGRAM
Revenue
Department: 0000 - MISSING DESCRIPTION
021-0000-410.001-00 ENCROACHMENT PERMITS 2,000.00 6,256.74 3,000.00 5,050.24 3,000.00 0.00 021-0000-420.034-00 STATE TRANS PROGRAM (MCA 68,411.00 70,786.90 68,411.00 71,395.00 68,411.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 70,411.00 77,043.64 71,411.00 76,445.24 71,411.00 0.00 Revenue Total: 70,411.00 77,043.64 71,411.00 76,145.24 71,911.00 0.00 Expense
Department: 0120 - CITY MANAGER
021-0120-500.000-00 SALARIES - FULL TIME EMPL 6,250.23 6,123.25 0.00 292.93 0.00 0.00 021-0120-510.000-00 PERS 733.90 608.57 0.00 0.00 0.00 0.00 021-0120-510.010-00 OASDI 478.14 436.71 0.00 22.41 0.00 0.00 021-0120-510.012-00 UNEMPLOYMENT INSURANCE 50.00 0.00 0.00 0.00 0.00 0.00 021-0120-510.020-00 GROUP HEALTH INSURANCE 436.48 287.98 0.00 434.00 0.00 0.00 021-0120-510.030-00 WORKER'S COMP INSURANCE 196.31 -539.15 0.00 188.22 0.00 0.00 021-0120-520.030-00 MOTOR VEHICLE EXPENSE 192.00 160.00 0.00 0.00 0.00 0.00 5/22/2023 2:38:28 PM Page 24 ot 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 021-0120-530.009-00 OTHER PROFESSIONAL SERVICE 100.00 18.37 0.00 0.00 0.00 0.00 021-0120-530.091-00 MEETINGS & TRAINING 1,000.00 0.00 0.00 0.00 0.00 0.00 Department: 0120 - CITY MANAGER Total: 9,437.06 7,095.73 0.00 937.56 0.00 0.00 Department: 0140 - FINANCE
021-0140-500.000-00 SALARIES - FULL TIME EMPL 6,949.50 6,903.36 0.00 675.78 0.00 0.00 021-0140-500.010-00 SALARIES - PART TIME EMPL 1,029.10 668.54 0.00 40.36 0.00 0.00 021-0140-500.030-00 OVERTIME 0.00 1.34 0.00 0.00 0.00 0.00 021-0140-510.000-00 PERS 616.91 570.86 0.00 28.59 35.00 0.00 021-0140-510.010-00 OASDI 686.86 571.87 0.00 54.44 0.00 0.00 021-0140-510.012-00 UNEMPLOYMENT INSURANCE 0.00 100.17 0.00 37.38 0.00 0.00 021-0140-510.020-00 GROUP HEALTH INSURANCE 2,381.39 2,421.68 0.00 2,399.53 0.00 0.00 021-0140-510.030-00 WORKER'S COMP INSURANCE 785.22 1,489.13 0.00 752.87 0.00 0.00 021-0140-520.030-00 MOTOR VEHICLE EXPENSE 0.00 96.00 0.00 4.00 0.00 0.00 Department: 0140 - FINANCE Total: 12,448.98 12,822.95 0.00 3,992.95 35.00 0.00 Department: 0142 - CITY CLERK
021-0142-500.000-00 SALARIES - FULL TIME EMPL 2,107.00 2,011.37 0.00 97.62 0.00 0.00 021-0142-500.010-00 SALARIES - PART TIME EMPL 1,029.10 668.54 0.00 40.36 0.00 0.00 021-0142-510.000-00 PERS 291.67 250.37 0.00 12.83 16.00 0.00 021-0142-510.010-00 OASDI 239.91 200.73 0.00 10.32 0.00 0.00 021-0142-510.012-00 UNEMPLOYMENT INSURANCE 50.00 15.56 0.00 2.36 0.00 0.00 021-0142-510.020-00 GROUP HEALTH INSURANCE 691.40 1,108.96 0.00 1,185.99 0.00 0.00 021-0142-510.030-00 WORKER'S COMP INSURANCE 392.61 379.98 0.00 376.44 0.00 0.00 021-0142-520.030-00 MOTOR VEHICLE EXPENSE 72.00 60.00 0.00 2.50 0.00 0.00 021-0142-530.240-00 PROFESSIONAL DEVELOPMENT 400.00 7.69 0.00 4.18 0.00 0.00 Department: 0142 - CITY CLERK Total: 5,273.69 4,703.20 0.00 1,732.60 16.00 0.00 Department: 0310 - TRANSPORTATION
021-0310-500.000-00 SALARIES - FULL TIME EMPL 20,993.51 16,380.28 22,287.00 17,864.01 20,899.00 0.00 021-0310-500.030-00 OVERTIME 5,306.00 1,604.79 0.00 773.08 0.00 0.00 021-0310-510.000-00 PERS 1,815.37 1,439.49 483.00 1,754.80 1,676.00 0.00 021-0310-510.010-00 OASDI 2,011.91 1,353.57 1,705.00 1,424.01 1,705.00 0.00 021-0310-510.020-00 GROUP HEALTH INSURANCE 8,931.42 8,799.33 9,019.00 8,315.83 9,019.00 0.00 5/22/2023 2:38:28 PM Page 25 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 021-0310-510.030-00 WORKER'S COMP INSURANCE 2,208.44 2,137.44 1,694.00 2,117.47 1,694.00 0.00 021-0310-520.010-00 DEPT OPERATING SUPPLES 0.00 5,297.17 0.00 2,458.88 0.00 0.00 021-0310-520.011-00 UNIFORM ALLOWANCE 0.00 100.46 0.00 103.88 0.00 0.00 021-0310-520.030-00 MOTOR VEHICLE EXPENSE 0.00 1,561.58 0.00 215.00 0.00 0.00 021-0310-530.009.00 OTHER PROFESSIONAL SERVICE 0.00 0.00 0.00 452.81 0.00 0.00 021-0310-530.011-00 TELEPHONE 0.00 50.00 0.00 192.50 0.00 0.00 021-0310-530.201-00 OTHER CONTRACT SERVICES 0.00 123.21 0.00 0.00 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 41,266.65 38,847.32 35,188.00 35,672.27 34,993.00 0.00 Expense Total: 68,426.38 63,469.20 35,188.00 42,335.38 35,044.00 0.00 Fund: 021 - REGIONAL STREET TRANSPORTATION PROGRAM Surplu 1,984.62 13,574.44 36,223.00 34,109.86 36,367.00 0.00 Fund: 027 - PER CAPITA GRANT
Revenue
Department: 0000 - MISSING DESCRIPTION
027-0000-420.062-00 PER CAPITA GRANT REIMBURS 16,000.00 142,362.00 16,000.00 0.00 35,590.00 0.00 Budget Notes
Budget Code Subject Description
WB Reimbursement amount Per Rosalind Roew in email on 4/5/2023 to Jami. The reimbursement amount is $35,590..Jenny Department: 0000 - MISSING DESCRIPTION Total: 16,000.00 142,362.00 16,000.00 0.00 35,590.00 0.00 Revenue Total: 16,000.00 142,362.00 16,000.00 0.00 35,590.00 0.00 Expense
Department: 0610 - PARKS
027-0610-530.009-00 OTHER CONTRACT SERVICES 16,000.00 14,905.39 0.00 444.13 0.00 0.00 Department: 0610 - PARKS Total: 16,000.00 14,905.39 0.00 444.13 0.00 0.00 Expense Total: 16,000.00 14,905.39 0.00 444.13 0.00 0.00 Fund: 027 - PER CAPITA GRANT Surplus (Deficit): 0.00 127,456.61 16,000.00 -444.13 35,590.00 0.00 Fund: 029 - GAS TAX 2103 FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
029-0000-420.020-00 GAS TAX 2103 45,273.00 43,294.06 57,567.00 43,863.10 60,229.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 45,273.00 43,294.06 57,567.00 43,863.10 60,229.00 0.00 Revenue Total: 45,273.00 43,294.06 57,567.00 43,863.10 60,229.00 0.00 5/22/2023 2:38:28 PM Page 26 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Expense
Department: 0310 - TRANSPORTATION
029-0310-530.201-00 OTHER CONTRACT SERVICES 0.00 929.51 0.00 1,038.35 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 0.00 929.51 0.00 1,038.35 0.00 0.00 Expense Total: 0.00 929.51 0.00 1,038.35 0.00 0.00
Fund: 029 - GAS TAX 2103 FUND Surplus (Deficit): 45,273.00 42,364,55 57,567.00 42,824.75 60,229.00 0.00 Fund: 034 - FIRE SERVICE FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
034-0000-990.099-00 TRANSFER IN 500.00 0.00 500.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 500.00 0.00 500.00 0.00 0.00 0.00 Revenue Total: 500.00 0.00 500.00 0.00 0.00 0.00
Expense
Department: 0220 - FIRE
034-0220-530.009-00 OTHER PROFESSIONAL SERVICE 500.00 21,214.64 500.00 0.00 0.00 0.00 Department: 0220 - FIRE Total: 500.00 21,214.64 500.00 0.00 0.00 0.00 Expense Total: 500.00 21,214.64 500.00 0.00 0.00 0.00
Fund: 034 - FIRE SERVICE FUND Surplus (Deficit): 0.00 -21,214.64 0.00 0.00 0.00 0.00 Fund: 038 - GENERAL RESERVE
Revenue
Department: 0000 - MISSING DESCRIPTION
038-0000-990.099-00 TRANSFER IN 0.00 125,696.97 0.00 125,000.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 125,696.97 0.00 125,000.00 0.00 0.00 Revenue Total: 0.00 125,696.97 0.00 125,000.00 0.00 0.00 Expense
Department: 0210 - POLICE
038-0210-540.030-00 MACHINERY, EQUIPMENT, VEC 0.00 43,995.99 0.00 0.00 0.00 0.00 Department: 0210 - POLICE Total: 0.00 43,995.99 0.00 0.00 0.00 0.00 Expense Total: 0.00 43,995.99 0.00 0.00 0.00 0.00
Fund: 038 - GENERAL RESERVE Surplus (Deficit: 0.00 81,700.98 0.00 125,000.00 0.00 0.00 Fund: 047 - FIREWORKS
Revenue
Department: 0000 - MISSING DESCRIPTION
047-0000-100.026-00 FIREWORKS - DONATIONS 25,000.00 25,215.55 25,000.00 6,800.48 27,000.00 0.00 5/22/20232:38:28 PM Page 27 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 047-0000-430.047-00 FUNDRAISING EVENTS/TAKEO 6,000.00 0.00 6,000.00 0.00 0.00 0.00 047-0000-430.048-00 MISS GUSTINE REVENUE 2,500.00 0.00 0.00 900.00 6,000.00 0.00 047-0000-430.057-00 PARK EVENT 4TH OF JULY REVE 0.00 1,065.00 0.00 895.50 3000000 0.00 Department: 0000-MISSING DESCRIPTION Total: 33,500.00 26,280.55 31,000.00 8,595.98 0.00 Revenue Total: 33,500.00 26,280.55 31,000.00 8,595.98 34,000.00 0.00 Expense
Department: 0704- FIREWORKS
047-0704-520.010-00 DEPT OPERATING SUPPLIES - FI 1,500.00 4,650.24 1,500.00 2,478.56 1,500.00 0.00 047-0704-520.011-00 DEPT OPERATING SUPPLIES - M 2,500.00 436.00 0.00 22.45 6,000.00 0.00 047-0704-520.012-00 DEPT OPERATING SUPPLIES - C 2,000.00 1,731.24 2,000.00 461.15 2,000.00 0.00 047-0704-530.009-00 OTHER PROFESSIONAL SERVICE 25,000.00 23,600.00 25,000.00 12,000.00 25,000.00 0.00 047-0704-530.030-00 ADVERTISING - FIREWORKS 2,500.00 1,523.59 2,500.00 0.00 2,500.00 0.00 Department: 0704 - FIREWORKS Total: 33,500.00 31,941.07 31,000.00 14,962.16 37,000.00 0.00 Expense Total: 33,500.00 31,941.07 31,000.00 14,962.16 37,000.00 0.00 Fund: 047 - FIREWORKS Surplus (Deficit): 0.00 -5,660.52 0.00 - 6,366.18 -3,000.00 0.00 Fund: 050 - LONG TERM DEBT
Expense
Department: 0000 - MISSING DESCRIPTION
050-0000-530.991-00 ACCRUED COMPENSATED ABSE 0.00 1,271.62 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 1,271.62 0.00 0.00 0.00 0.00 Expense Total: 0.00 1,271.62 0.00 0.00 0.00 0.00
Fund: 050 - LONG TERM DEBT Total: 0.00 1,271.62 0.00 0.00 0.00 0.00 Fund: 059 - STORM DRAIN
Revenue
Department: 0000 - MISSING DESCRIPTION
059-0000-430.060-00 SERVICE CHARGE 40,000.00 37,768.82 40,000.00 32,143.23 40,000.00 0.00 059-0000-430.079-00 STORM DRAIN FEE-COLLECTED 5,000.00 3,338.47 5,000.00 56,068.72 5,000.00 0.00 059-0000-430.080-00 STORM DRAIN LATE FEES 500.00 415.59 500.00 1,180.37 500.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 45,500.00 41,522.88 45,500.00 99,392.32 45,500.00 0.00 Revenue Total: 45,500.00 41,522.88 45,500.00 99,392.32 45,500.00 0.00 5/22/2023 2:38:28 PM Page 28 ol 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
Department: 0000 - MISSING DESCRIPTION
059-0000-530.991-00 ACCRUED COMPENSATED ABSE 0.00 -28.75 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 -28.75 0.00 0.00 0.00 0.00 Department: 0120 - CITY MANAGER
059-0120-500.000-00 SALARIES - FULL TIME EMPL 1,562.56 1,530.82 1,562.00 2,033.84 2,189.00 0.00 059-0120-510.000-00 PERS 183.48 159.27 181.00 72.92 181.00 0.00 059-0120-510.010-00 OASDI 119.54 112.05 155.06 120.00 0.00 059-0120-510.012-00 UNEMPLOYMENT INSURANCE 250.00 0.00 0.00 250.00 0.00 059-0120-510.020-00 GROUP HEALTH INSURANCE 109.12 99.45 108.50 84.00 0.00 059-0120-510.030-00 WORKER'S COMP INSURANCE 49.08 47.50 47.05 55.00 0.00 059-0120-520.030-00 MOTOR VEHICLE EXPENSE 48.00 80.00 15.36 48.00 0.00 059-0120-530.011-00 TELEPHONE 0.00 0.00 5.09 0.00 0.00
059-0120-530.091-00 MEETINGS & TRAINING 350.00 0.00 0.00 350.00 0.00 Department: 0120 - CITY MANAGER Total: 2,671.78 2,029.09 2,437.82 3,277.00 0.00 Department: 0140 - FINANCE
059-0140-500.000-00 SALARIES - FULL TIME EMPL 1,737.37 1,726.20 0.00 168.95 0.00 0.00 059-0140-500.010-00 SALARIES - PART TIME EMPL 257.28 167.13 0.00 10.09 0.00 0.00 059-0140-510.000-00 PERS 154,23 142.87 0.00 7.15 9.00 0.00 059-0140-510.010-00 OASDI 152.59 143.01 0.00 13.62 0.00 0.00 059-0140-510.012-00 UNEMPLOYMENT INSURANCE 25.00 132.09 25.00 18.69 25.00 0.00 059-0140-510.020-00 GROUP HEALTH INSURANCE 595.35 605.39 0.00 599.86 0.00 0.00 059-0140-510.030-00 WORKER'S COMP INSURANCE 245.38 237.49 0.00 235.28 0.00 0.00 059-0140-520.000-00 OFFICE SUPPLIES 150.00 24.28 150.00 0.00 150.00 0.00 059-0140-520.030-00 MOTOR VEHICLE EXPENSE 24.00 25.00 0.00 1.00 0.00 0.00 059-0140-530.014-00 POSTAGE 500.00 286.52 500.00 156.42 500.00 0.00 059-0140-530.051-00 INSURANCE 3,444.55 3,538.52 4,354.00 4,581.20 4,354.00 0.00 059-0140-530.092-00 BANK COSTS 200.00 404.85 200.00 0.00 200.00 0.00 059-0140-530.201-00 OTHER CONTRACT SERVICES 451.00 251.24 451.00 106.89 451.00 0.00 Department: 0140 - FINANCE Total: 7,936.75 7,684.59 5,680.00 5,899.15 5,689.00 0.00 Department: 0Z10 - POLICE
059-0210-500.000-00 SALARIES - FULL TIME EMPL 7,846.58 7,844.94 5,852.00 5,451.89 6,079.00 0.00 5/22/2023 2:38:28 PM Page 29 ol 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 20z1-20z2 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 059-0210-510.000-00 PERS 416.52 1,609.84 35.00 1,081.15 1,138.00 0.00 059-0210-510.010-00 OASDI 600.26 596.53 448.00 413.87 448.00 0.00 059-0210-510.020-00 GROUP HEALTH INSURANCE 1,591.30 1,674.56 1,498.00 1,754,49 1,498.00 0.00 059-0210-510.030-00 WORKER'S COMP INSURANCE 392.61 0.00 328.00 0.00 328.00 0.00 - 10,847.27 0.00
Department: 0210 - POLICE Total: 11,725.87 8,161.00 8,701.40 9,491.00 Department: 0730 - STORM DRAIN
059-0730-500.000-00 SALARIES - FULL TIME EMPL 4,653.91 3,668.41 466.00 533.06 605.00 0.00 059-0730-500.030-00 OVERTIME 0.00 438.84 0.00 106.79 0.00 0.00 059-0730-510.000-00 PERS 1,346.75 339.68 920.00 45.51 164.00 0.00 059-0730-510.010-00 OASDI 356.02 309.87 36.00 52.23 36.00 0.00 059-0730-510.012-00 UNEMPLOYMENT INSURANCE 50.00 0.00 50.00 0.00 50.00 0.00 059-0730-510.020-00 GROUP HEALTH INSURANCE 1,905.89 1,946.11 332.00 2,016.19 332.00 0.00 059-0730-510.030-00 WORKER'S COMP INSURANCE 490.76 474.99 55.00 470.56 55.00 0.00 059-0730-510.125-00 EQUIPMENT LEASE 12,436.66 12,436.66 12,437.00 12,436.66 12,437.00 0.00 059-0730-510.126-00 INTEREST - EQUIPMENT LEASE 2,362.37 2,362.37 2,362.00 2,362.37 2,362.00 0.00 059-0730-520.010-00 DEPT OPERATING SUPPLIES 3,200.00 9,471.18 3,200.00 5,325.19 5,500.00 0.00 059-0730-520.030-00 MOTOR VEHICLE EXPENSE 4,000.00 2,705.14 4,000.00 3,427.52 4,000.00 0.00 059-0730-530.000-00 ACCOUNTING & AUDITING 105.00 765.30 341.00 370.80 341.00 0.00 059-0730-530.009-00 OTHER PROFESSIONAL SERVICE 1,339.00 1,339.00 1,339.00 0.00 1,000.00 0.00 059-0730-530.011-00 TELEPHONE 0.00 10.00 0.00 0,50 0.00 0.00 059-0730-530.072-00 OTHER EQUIPMENT REPAIR 0.00 0.00 0.00 3,328.34 1,000.00 0.00 059-0730-530.094-00 LICENSES & PERMIT FEES 1,030.00 1,286.10 1,030.00 0.00 1,030.00 0.00 059-0730-530.095-00 PROPERTY TAXES 1,000.00 992.64 1,000.00 1,005.96 1,000.00 0.00 059-0730-530.201-00 OTHER CONTRACT SERVICES 22,000.00 8,427.47 0.00 17,934.64 15,000.00 0.00 Department: 0730 - STORM DRAIN Total: 56,276.36 46,973.76 27,568.00 49,416.32 44,912.00 0.00 Expense Total: — 77,732.16 68,384.56 44,059.00 66,454.69 63,369.00 0.00 Fund: 059 - STORM DRAIN Surplus (Deficit): -32,232.16 - 26,861.68 3,441.00 32,937.63 -17,869.00 0.00 Fund: 060 - WATER FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
060-0000-430.011-00 SPECIAL SERVICES- PW 4,000.00 3,274.40 4,000.00 4,262.84 4,000.00 0.00 060-0000-430.060-00 SERVICE CHARGE 1,335,361.20 1,324,717.58 1,442,190.00 1,114,371.03 1,557,565.20 0.00 5/22/2023 2:38:78 PM Page 30 ot 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Budget Notes
Budget Code Subject Description
WB Rate Increase Rate Increase of 8% on 7/3/2023.Jenny
060-0000-430.061-00 RECONNECTION FEES 8,505.00 1,120.00 8,505.00 1,295.00 5,000.00 0.00 060-0000-430.069-00 MISC REVENUE 0.00 6,604.67 0.00 0.00 0.00 0.00 060-0000-430.081-00 WATER LATE FEES 14,500.00 13,962.19 14,500.00 45,553.27 14,500.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 1,362,366.20 1,349,678.84 1,469,195.00 1,165,482.14 1,581,065.20 0.00 Revenue Total: 1,362,366.20 1,349,678.84 1,469,195.00 1,165,482.14 1,581,065.20 0.00 Expense
Department: 0000 - MISSING DESCRIPTION
060-0000-530.991-00 ACCRUED COMPENSATED ABSE 0.00 2,601.26 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 2,601.26 0.00 0.00 0.00 0.00 Department: 0120 - CITY MANAGER
060-0120-500.000-00 SALARIES - FULL TIME EMPL 40,626.52 47,162.76 79,607.00 54,380.53 63,095.00 0.00 060-0120-510.000-00 PERS 4,770.37 4,105.25 4,708.00 2,093.31 2,701.00 0.00 060-0120-510.010-00 DASDI 3,107.93 3,482.80 6,090.00 4,147.47 6,090.00 0.00 060-0120-510.012-00 UNEMPLOYMENT INSURANCE 125.00 0.00 125.00 0.00 125.00 0.00 060-0120-510.020-00 GROUP HEALTH INSURANCE 2,837.12 1,844.39 2,184.00 2,821.22 2,184.00 0.00 060-0120-510.030-00 WORKER'S COMP INSURANCE 1,275.99 1,234.96 1,421.00 1,223.43 1,421.00 0.00 060-0120-520.030-00 MOTOR VEHICLE EXPENSE 1,248.00 1,000.00 1,248.00 400.35 1,248.00 0.00 060-0120-530.009-00 OTHER PROFESSIONAL SERVICE 450.00 0.00 5,450.00 0.00 100.00 0.00 060-0120-530.011-00 TELEPHONE 0.00 0.00 0.00 133.42 161.00 0.00 060-0120-530.090-00 MEMBERSHIPS/SUBSCRIPTION 200.00 0.00 200.00 0.00 0.00 0.00 060-0120-530.091-00 MEETINGS & TRAINING 4,090.00 1,124.08 4,090.00 0,00 1,200.00 0.00 Department: 0120 • CITY MANAGER Total: 58,730.93 59,954.24 105,123.00 65,199.73 78,325.00 0.00 Department: 0140 - FINANCE
060-0140-500.000-00 SALARIES - FULL TIME EMPL 62,545.48 62,142.53 72,898.00 71,717.27 79,843.00 0.00 060-0140-500.010-00 SALARIES - PART TIME EMPL 7,975.53 5,181.27 9,210.00 7,284.37 8,249.00 0.00 060-0140-500.030-00 OVERTIME 0.00 0.00 0.00 5.93 0.00 0.00 060-0140-500.045-00 BILINGUAL STIPEND 0.00 1,410.85 1,400.00 65.62 1,400.00 0.00 060-0140-510.000-00 PERS 5,452.68 5,182.48 6,099.00 3,682.71 4,569.00 0.00 060-0140-510.010-00 OASDI 5,394.86 5,208.85 812.00 3,929.92 812.00 0.00 5/22/2023 2:38:28 PM Page 31 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 060-0140-510.012-00 UNEMPLOYMENT INSURANCE 350.00 1,122.46 350.00 327.03 350.00 0.00 060-0140-510.020-00 GROUP HEALTH INSURANCE 21,432.54 21,794.08 25,441.00 21,595.29 25,441.00 0.00 060-0140-510.030-00 WORKER'S COMP INSURANCE 8,293.92 8,027.27 9,618.00 7,952.32 9,618.00 0.00 060-0140-520.000-00 OFFICE SUPPLIES 1,500.00 364.26 500.00 398.80 500.00 0.00 060-0140-520.030-00 MOTOR VEHICLE EXPENSE 864.00 863.00 840.00 141.00 840.00 0.00 060-0140-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 418.75 0.00 0.00 0.00 0.00 060-0140-530.014-00 POSTAGE 3,329.00 4,866.14 3,500.00 2,665.80 3,500.00 0.00 060-0140-530.030-00 ADVERTISING 40.00 0.00 40.00 238.22 40.00 0.00 060-0140-530.051-00 INSURANCE 48,223.64 49,539.28 60,958.00 64,136.80 65,000.00 0.00 060-0140-530.090-00 MEMBERSHIPS/SUBSCRIPTION 350.00 290.00 300.00 0.00 100.00 0.00 060-0140-530.092-00 BANK COSTS 3,000.00 7,565.89 5,500.00 0.00 5,500.00 0.00 060-0140-530.201-00 OTHER CONTRACT SERVICES 0.00 2,829.80 0.00 2,065.44 2,000.00 0.00 Department: 0140 - FINANCE Total: 168,751.65 176,806.91 197,466.00 186,206.52 207,762.00 0.00 Department: 0142 - CITY CLERK
060-0142-500.000-00 SALARIES - FULL TIME EMPL 21,069.97 20,114.45 16,482.00 14,698.96 16,459.00 0.00 060-0142-510.000-00 PERS 2,120.97 2,195.78 1,511.00 1,366.76 1,625.00 0.00 060-0142-510.010-00 OASDI 1,611.85 1,495.20 1,261.00 1,099.48 1,261.00 0.00 060-0142-510.012-00 UNEMPLOYMENT INSURANCE 0.00 155.67 0.00 23.63 0.00 0.00 060-0142-510.020-00 GROUP HEALTH INSURANCE 6,914.00 11,089.89 9,304.00 11,860.14 9,304.00 0.00 060-0142-510.030-00 WORKER'S COMP INSURANCE 1,963.06 1,899.95 1,530.00 1,882.21 1,530.00 0.00 060-0142-520.010-00 DEPT OPERATING SUPPLIES 500.00 3,530.85 500.00 500.64 500.00 0.00 060-0142-520.030-00 MOTOR VEHICLE EXPENSE 720.00 600.00 288.00 225.00 288.00 0.00 060-0142-530.011-00 TELEPHONE & INTERNET 0.00 0.00 0.00 180.00 234.00 0.00 060-0142-530.030-00 ADVERTISING 77.00 0.00 77.00 0.00 50.00 0.00 060-0142-530.240-00 PROFESSIONAL DEVELOPMENT 4,000.00 3,670.21 1,200.00 1,677.78 1,200.00 0.00 Department: 0142 - CITY CLERK Total: 38,976.85 44,752.00 32,153.00 33,514.60 32,451.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG
060-0150-500.000-00 SALARIES - FULL TIME EMPLOY 0.00 3,396.51 0.00 430.63 0.00 0.00 060-0150-500.010-00 SALARIES - PART TIME EMPL 22,199.36 20,263.64 22,412.00 16,681.39 18,511.00 0.00 060-0150-500.030-00 "OVERTIME 0.00 2,649.69 0.00 804.01 0.00 0.00 060-0150-510.000-00 PERS 1,716.45 14,722.96 1,171.00 12,225.78 12,903.00 0.00 5/22/2023 2:38:28 PM Page 32 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 060-0150-510.010-00 DASDI 1,698.25 2,870.74 0.00 2,120.10 0.00 0.00 060-0150-510.020-00 GROUP HEALTH INSURANCE 3,335.50 3,288.76 2,945.00 3,156.37 2,945.00 0.00 060-0150-510.030-00 WORKER'S COMP INSURANCE 5,889.17 5,699.84 6,285.00 5,646.62 6,285.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG Total: 34,838.73 52,892.14 32,813.00 41,064.90 40,644.00 0.00 Department: 0210 - POLICE
060-0210-500.000-00 SALARIES - FULL TIME EMPL 16,928.41 16,928.56 23,166.00 21,243.18 23,699.00 0.00 .060-0210-500.030-00 OVERTIME 0.00 0.00 0.00 424.42 0.00 0.00 060-0210-510.000.00 PERS 2,612.20 3,482.25 3,371.00 3,794.88 4,405.00 0.00 060-0210-510.010-00 OASDI 1,295.02 1,282.96 1,772.00 1,640.25 1,772.00 0.00 060-0210-510.020-00 GROUP HEALTH INSURANCE 4,499.14 4,581.11 5,970.00 4,835.11 5,970.00 0.00 060-0210-510.030-00 WORKER'S COMP INSURANCE 883.38 854.97 1,585.00 846.99 1,585.00 0.00 Department: 0210 - POLICE Total: 26,218.15 27,129.85 35,864.00 32,784.83 37,431.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT
060-0460-500.000-00 SALARIES - FULL TIME EMPL 11,324.88 10,594.47 11,665.00 10,818.13 12,043.00 0.00 060-0460-510.000-00 PERS 1,329.77 1,150.75 1,352.00 1,185.28 1,414.00 0.00 060-0460-510.010-00 OASDI 866.35 769.02 892.00 790.85 892.00 0.00 060-0460-510.020-00 GROUP HEALTH INSURANCE 4,706.27 4,664.89 4,984.00 4,447.50 4,984.00 0.00 060-0460-520.030-00 MOTOR VECHICLE EXPENSE 540.00 0.00 540.00 0.00 0.00 0.00 060-0460-530.030-00 ADVERTISING 200.00 282.10 200.00 315.00 200.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT Total: 18,967.27 17,461.23 19,633.00 17,556.76 19,533.00 0.00 Department: 0520 - SEWER
060-0520-500.045-00 BILINGUAL STIPEND 0.00 3,020.50 2,700.00 3,408.50 2,700.00 0.00 060-0520-510.000-00 PERS 0.00 273.39 0.00 286.18 342.00 0.00 060-0520-510.010-00 OASDI 0.00 244.17 0.00 255.62 0.00 0.00 Department: 0520 - SEWER Total: 0.00 3,538.06 2,700.00 3,950.30 3,042.00 0.00 Department: 0710 - WATER
060-0710-500.000-00 SALARIES - FULL TIME EMPL 103,249.38 93,249.53 107,829.00 91,909.30 104,658.00 0.00 060-0710-500.030-00 OVERTIME 19,335.00 10,231.92 19,335.00 12,891.39 19,335.00 0.00 060-0710-510.000-00 PERS 8,262.99 10,027.30 8,275.00 7,603.26 9,137.00 0.00 060-0710-510.010-00 OASDI 9,377.71 7,985.79 9,728.00 7,841.20 9,728.00 0.00 060-0710-510.012-00 UNEMPLOYMENT INSURANCE 600.00 0.00 600.00 0.00 600.00 0.00 060-0710-510.020-00 GROUP HEALTH INSURANCE 35,537.63 39,523.51 41,551.00 38,682.93 41,551.00 0.00 5/22/2023 2:38:28 PM Page 33 ol 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 060-0710-510.030-00 WORKER'S COMP INSURANCE 10,796.82 10,449.69 11,149.00 10,352.13 11,149.00 0.00 060-0710-520.010-00 DEPT OPERATING SUPPLIES 50,000.00 54,592.09 50,000.00 40,117.52 50,000.00 0.00 060-0710-520.011-00 UNIFORM ALLOWANCE 2,788.00 3,013.46 2,788.00 3,419.20 3,500.00 0.00 060-0710-520.030-00 MOTOR VEHICLE EXPENSE 10,000.00 7,993.36 10,000.00 9,909.58 10,000.00 0.00 060-0710-520.040-00 FUEL 5,474.00 5,662.07 5,474.00 5,624.59 5,474.00 0.00 060-0710-530.000-00 ACCOUNTING & AUDITING 1,400.00 10,201.30 4,540.00 4,974.00 4,540.00 0.00 060-0710-530.009-00 OTHER PROFESSIONAL SERVICE 17,640.00 20,556.75 18,000.00 47,616.00 49,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Rate Study Rate Study for raising rates.
$60K - Split Water 40/Sewer 40/Refuse 20
Water = $24K
Sewer = $24K
Refuse = $12K
WB Strategic Plan Strategic Plan Split
Water = $7K
Sewer = $7K
General Fund = $7K
Total $21k
060-0710-530.011-00 TELEPHONE 6,124.24 7,883.12 6,124.00 6,749.10 5,124.00 0.00 060-0710-530.021-00 Solar Loan Principal 0.00 0.00 38,978.00 0.00 38,978.00 0.00 060-0710-530.022-00 Solar Loan Interest 0.00 0.00 16,217.00 0.00 16,217.00 0.00 060-0710-530.060-00 ELECTRIC 161,165.00 90,784.77 90,000.00 72,558.15 90,000.00 0.00 060-0710-530.072-00 OTHER EQUIPMENT REPAIR 0.00 0.00 0.00 228.22 500.00 0.00 060-0710-530.090-00 MEMBERSHIPS/SUBSCRIPTION 1,653.00 0.00 1,000.00 75.00 1,000.00 0.00 060-0710-530.091-00 MEETINGS & TRAINING 7,000.00 495.96 500.00 438.71 500.00 0.00 060-0710-530.094-00 LICENSES & PERMIT FEES 16,000.00 29,537.85 20,000.00 23,152.78 20,000.00 0.00 060-0710-530.111-00 NOTE PAYABLE (VIERRA LOAN) 6,098.34 0.00 6,098.00 9,031.71 9,715.00 0.00 060-0710-530.112-00 PRINCIPAL USDA COP CITY HAL 5,000.00 -15,000.00 5,000.00 0.00 5,000.00 0.00 060-0710-530.114-00 USDA 2012 WATER COP PRINCI 15,000.00 15,000.00 15,000.00 0.00 15,000.00 0.00 060-0710-530.121-00 INTEREST USDA 2012 COP WAT 18,823.75 18,823.75 18,824.00 0.00 18,824.00 0.00 060-0710-530.122-00 INTEREST EXPENSE (VIERRA LO 10,381.25 7,276.59 10,194.00 5,038.65 4,870.00 0.00 060-0710-530.123-00 INTEREST USDA COP CITY HALL 6,098.34 10,475.50 6,098.00 0.00 6,098.00 0.00 5/22/2023 2:38:28 PM Page 34 ot 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 060-0710-530.125-00 EQUIPMENT LEASE 24,873.34 24,873.34 24,873.00 24,873.34 24,873.00 0.00 060-0710-530.126-00 INTEREST - EQUIPMENT LEASE 4,724.74 4,724.74 4,725.00 4,724.74 4,725.00 0.00 060-0710-530.201-00 OTHER CONTRACT SERVICES 313,500.00 137,328.66 417,000.00 236,135.84 417,000.00 0.00 060-0710-540.011-00 BUILDINGS 2,500.00 1,733.68 2,000.00 3,297.00 2,000.00 0.00 060-0710-540.020-00 OTHER IMPROVEMENTS 20,000.00 0.00 10,000.00 2,914.92 10,000.00 0.00 060-0710-540.030-00 MACHINERY & EQUIPMENT 88,222.00 28,600.58 30,000.00 14,316.70 36,666.67 0.00 Budget Notes
Budget Code Subject Description
WB Message Board City to purchase a Message Board. Estimate $20,000 Split between departments - Police/Water/Sewer
Water Portion = $6,666.67
060-0710-540.038-00 TECHNOLOGY PURCH/REPLACE 0.00 1,850.66 0.00 3,846.94 4,000.00 0.00 060-0710-540.039-00 MAINTENANCE CONTRACTS 10,639.87 21,259.67 10,640.00 9,850.60 10,640.00 0.00 Department: 0710 - WATER Total: 992,265.40 659,135.64 1,022,540.00 698,173.50 1,061,402.67 0.00 Department: 0999 - MISSING DESCRIPTION
060-0999-990.099-00 TRANS OF FUNDS OUT 3,000.00 0.00 14,787.00 14,787.00 16,787.00 0.00 Budget Notes
Budget Code Subject Description
WB FY23/24-Equipment Replace Equipment to be replaced by MidValley IT Quote #MVQQ7078
Replacement of 5 Computers with licensing. $9,052.12
Quote #: MVQQ7079
Replacement of 3 laptops with licensing. $5,457.55
Total $15000
WB Transfer Out - Solar loan to Sewer Fund Transfer Out - Solar Loan to Sewer Fund $11,787 Department: 0999 - MISSING DESCRIPTION Total: 3,000.00 0.00 14,787.00 14,787.00 16,787.00 0.00 Department: 10B0 - CAPITAL IMPROVEMENT PROJECT
060-1080-550.108-00 FIRE HYDRANT REPLACEMENT 0.00 0.00 0.00 240,361.53 0.00 0.00 Department: 1080 - CAPITAL IMPROVEMENT PROJECT Total: 0.00 0.00 0.00 240,361.53 0.00 0.00 Expense Total: 1,341,748.98 1,044,271.33 1,463,079.00 1,333,599.67 1,497,377.67 0.00 Fund: 060 - WATER FUND Surplus (Deficit): 20,617.22 305,407.51 6,116.00 -168,117.53 83,687.53 0.00 5/22/2023 2:38:28 PM Page 35 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 061 - SEWER FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
061-0000-430.029-00 SEWER BOD CHARGES 800,000.00 1,076,539.51 1,000,000.00 751,412.81 1,000,000.00 0.00 061-0000-430.030-00 Sewer Service Charges 0.00 0.00 922,128.00 0.00 995,898.00 0.00 061-0000-430.030-00 SEWER SERVICE CHARGES 853,822,30 872,757.66 0.00 781,508.37 0.00 0.00 061-0000-430.082-00 SEWER LATE FEES 0.00 9,711.87 5,000.00 28,154.98 5,000.00 0.00 061-0000-450.000-00 INTEREST 45,784.00 14,316.67 30,000.00 78,885.06 30,000.00 0.00 061-0000-450.041-00 INSURANCE REVENUES 0.00 3,639.80 0.00 1,606.67 0.00 0.00 061-0000-990.099-00 TRANSFER IN 0.00 0.00 23,574.00 23,574.00 23,574.00 0.00 Budget Notes
Budget Code Subject Description
wB Transfer In Transfer in-Solar Loan Repayment from Gener/Pool/Water Fund - $23,574 Department: 0000 - MISSING DESCRIPTION Total: 1,699,606.30 1,976,965.51 1,980,702.00 1,665,141.89 2,054,472.00 Revenue Total: 1,699,606.30 1,976,965.51 1,980,702.00 1,665,141.89 2,054,472.00 Expense
Department: 0000 - MISSING DESCRIPTION
061-0000-530.991-00 ACCRUED COMPENSATED ABSE 0.00 -11,935.69 0.00 0.00 0.00 0.00 Department: 0000-MISSING DESCRIPTION Total: 0.00 -11,935.69 0.00 0.00 0.00 0.00 Department: 0120 - CITY MANAGER
061-0120-500.000-00 SALARIES- FULL TIME EMPL 39,063.96 45,632.01 87,419.00 64,110.09 73,585.00 0.00 061-0120-510.000-00 PERS 4,586.89 3,960.28 5,614.00 2,257.40 5,614.00 0.00 061-0120-510.010-00 OASDI 2,988.39 3,292.46 6,688.00 4,889.26 6,688.00 0.00 061-0120-510.020-00 GROUP HEALTH INSURANCE 2,728.00 1,799.86 2,604.00 2,712.74 2,604.00 0.00 061-0120-510.030-00 WORKER'S COMP INSURANCE 1,226.91 1,187.46 1,694.00 1,176.38 1,694.00 0.00 061-0120-520.030-00 MOTOR VEHICLE EXPENSE 1,200.00 1,000.00 1,488.00 477.33 1,488.00 0.00 061-0120-530.009-00 OTHER PROFESSIONAL SERVICE 200.00 0.00 9,425.00 41.11 9,425.00 0.00 061-0120-530.011-00 TELEPHONE 0.00 0.00 0.00 159.14 415.00 0.00 Department: 0120 - CITY MANAGER Total: 51,994.15 56,872007 114,932.00 75,823.45 101,513.00 0.00 Department: 0140 - FINANCE
061-0140-500.000-00 SALARIES- FULL TIME EMPL 60,808.10 60,404.65 89,412.00 88,245.44 98,226.00 0.00 061-0140-500.010-00 SALARIES - PART TIME EMPL 7,718.26 5,014.15 13,567.00 10,760.10 12,176.00 0.00 061-0140-500.030-00 OVERTIME 0.00 11.75 0.00 6.08 0.00 0.00 5/22/2023 2:38:28 PM Page 36 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 061-0140-500.045-00 BILINGUAL STIPEND 0.00 1,410.83 1,400.00 65.62 1,400.00 0.00 061-0140-510.000-00 PERS 5,298.46 5,039.89 7,659.00 4,269.20 5,348.00 0.00 061-0140-510.010-00 OASDI 5,242.27 5,219.32 1,038.00 4,522.96 1,038.00 0.00 061-0140-510.012-00 UNEMPLOYMENT INSURANCE 500.00 1,122.45 500.00 327.03 500.00 0.00 061-0140-510.020-00 GROUP HEALTH INSURANCE 20,837.19 21,188.74 27,166.00 20,995.42 27,166.00 0.00 061-0140-510.030-00 WORKER'S COMP INSURANCE 8,097.62 7,599.76 11,367.00 7,528.82 11,367.00 0.00 061-0140-520.000-00 OFFICE SUPPLIES 2,348.00 711.33 2,348.00 5.38 500.00 0.00 061-0140-520.030-00 MOTOR VEHICLE EXPENSE 840.00 840.00 1,224.00 188.00 700.00 0.00 061-0140-530.000-00 ACCOUNTING & AUDITING 1,400.00 0.00 4,540.00 0.00 700.00 0.00 061-0140-530.009.00 OTHER PROFESSIONAL SERVICE 0.00 0.00 0.00 85.90 0.00 0.00 061-0140-530.014-00 POSTAGE 4,000.00 4,866.14 4,000.00 2,665.80 4,000.00 0.00 061-0140-530.051-00 INSURANCE 51,668.18 52,181.92 65,312.00 68,717.98 65,312.00 0.00 061-0140-530.092-00 BANK COSTS 4,683.00 7,966.35 4,683.00 -13.01 4,683.00 0.00 061-0140-530.201-00 OTHER CONTRACT SERVICES 6,709.00 8,764.15 6,709.00 4,637.83 6,709.00 0.00 Department: 0140 - FINANCE Total: 180,150.08 182,341.44 240,925.00 213,008.55 239,825.00 0.00 Department: 0142 - CITY CLERK
061-0142-500.000-00 SALARIES - FULL TIME EMPL 26,337.46 25,143.21 40,991.00 35,547.47 39,885.00 0.00 061-0142-510.000-00 PERS 2,651.21 2,494.83 4,113.00 3,559.71 4,250.00 0.00 061-0142-510.010-00 OASDI 2,014.82 1,869.19 3,136.00 2,664.87 3,136.00 0.00 061-0142-510.012-00 UNEMPLOYMENT INSURANCE 50.00 194.59 50.00 29.54 50.00 0.00 061-0142-510.020-00 GROUP HEALTH INSURANCE 8,642.50 13,862.52 20,601.00 14,825.34 20,601.00 0.00 061-0142-510.030-00 WORKER'S COMP INSURANCE 2,453.82 2,374.94 3,388.00 2,352.76 3,388.00 0.00 061-0142-520.030-00 MOTOR VEHICLE EXPENSE 900.00 750.00 1,080.00 781.25 1,080.00 0.00 061-0142-530.011-00 TELEPHONE & INTERNET 0.00 0.00 0.00 300.00 390.00 0.00 061-0142-530.030-00 ADVERTISING 1,000.00 1,918.98 1,000.00 0.00 1,000.00 0.00 061-0142-530.240-00 PROFESSIONAL DEVELOPMENT 0.00 3,326.89 4,500.00 1,443.84 1,500.00 0.00 Department: 0142 - CITY CLERK Total: 44,049.81 51,935.15 78,859.00 61,504.78 75,280.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG
061-0150-500.000-00 SALARIES - FULL TIME EMPLOY 0.00 15,353.35 0.00 14,502.84 15,926.00 0.00 061-0150-500.010-00 SALARIES - PART TIME EMPL 22,199.36 20,263.64 22,412.00 16,681.39 18,511.00 0.00 061-0150-500.030-00 OVERTIME 0.00 2,649.69 0.00 948.54 0.00 0.00 5/22/2023 2:38:28 PM Page 37 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 061-0150-510.000-00 PERS 1,716.45 2,766.12 1,171.00 2,329.20 2,543.00 0.00 061-0150-510.010-00 OASDI 1,698.25 2,959.69 1,714.00 2,420.85 1,714.00 0.00 061-0150-510.020-00 GROUP HEALTH INSURANCE 3,891.41 3,858.55 4,124.00 3,682.40 4,124.00 0.00 061-0150-510.030-00 WORKER'S COMP INSURANCE 6,134.56 5,937.33 6,831.00 5,881.90 6,831.00 0.00 Department: 0150 - GENERAL GOVERNMENT BLDG Total: 35,640.03 53,788.37 36,252.00 46,447.12 49,649.00 0.00 Department: 0210 - POLICE
061-0210-500.000-00 SALARIES - FULL TIME EMPL 16,038.38 16,038.38 16,464.00 15,045.77 16,800.00 0.00 061-0210-510.000-00 PERS 2,496.10 3,298.38 2,534.00 2,995.72 3,459.00 0.00 061-0210-510.010-00 OASDI 1,226.94 1,216.01 1,259.00 1,141.33 1,259.00 0.00 061-0210-510.020-00 GROUP HEALTH INSURANCE 4,185.39 4,270.15 4,409.00 4,418.61 4,409.00 0.00 061-0210-510.030-00 WORKER'S COMP INSURANCE 834.30 807.47 929.00 799.93 929.00 0.00 Department: 0210 - POLICE Total: 24,781.11 25,630.39 25,595.00 24,401.36 26,856.00 0.00 Department: 0410 - PLANNING
061-0410-520.030-00 MOTOR VECHICLE EXPENSE 180.00 0.00 180.00 0.00 180.00 0.00 061-0410-530.030-00 ADVERTISING 200.00 0.00 200.00 127.00 200.00 0.00 061-0410-530.200-00 CONSULTING SERVICES 0.00 1,491.66 0.00 0.00 0.00 0.00 Department: 0410 - PLANNING Total: 380.00 1,491.66 380.00 127.00 380.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT
061-0460-500.000-00 SALARIES - FULL TIME EMPL 3,774.96 3,531.52 3,888.00 3,606.05 4,015.00 0.00 061-0460-510.000-00 PERS 443.26 558.42 451.00 549.28 631.00 0.00 061-0460-510.010-00 OASDI 288.78 373.74 297.00 367.23 297.00 0.00 061-0460-510.020-00 GROUP HEALTH INSURANCE 1,568.76 1,555.07 1,661.00 1,482.55 1,661.00 0.00 061-0460-510.030-00 WORKER'S COMP INSURANCE 834.30 0.00 929.00 0.00 929.00 0.00 061-0460-520.030-00 MOTOR VEHICLE EXPENSE 0.00 1,620.00 0.00 1,417.50 1,755.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT Total: 6,910.06 7,638.75 7,226.00 7,422.61 9,288.00 0.00 Department: 0520 - SEWER
061-0520-500.000-00 SALARIES - FULL TIME EMPL 1653,258.42 141,004.52 160,807.00 134,816.38 151,747.00 0.00 061-0520-500.030-00 OVERTIME 19,897.00 9,422.27 19,897.00 19,927.61 19,897.00 0.00 061-0520-500.045-00 BILINGUAL STIPEND 0.00 3,020.50 2,668.00 3,408.50 2,668.00 0.00 061-0520-510.000-00 PERS 36,386.22 36,678.74 28,807.00 26,020.49 31,635.00 0.00 061-0520-510.010-00 OASDI 14,011.39 11,874.56 14,028.00 11,940.88 14,028.00 0.00 061-0520-510.012-00 UNEMPLOYMENT INSURANCE 200.00 0.00 200.00 0.00 200.00 0.00 5/22/2023 2:38:28 PM Page 38 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 061-0520-510.020-00 GROUP HEALTH INSURANCE 52,873.90 51,645.33 59,581.00 45,540.77 59,581.00 0.00 061-0520-510.030-00 WORKER'S COMP INSURANCE 16,735.07 16,197.03 21,587.00 16,045.81 21,587.00 0.00 061-0520-520.010-00 DEPT OPERATING SUPPLIES 20,000.00 41,962.55 25,000.00 33,553.55 40,000.00 0.00 061-0520-520.011-00 UNIFORM ALLOWANCE 18,500.00 5,699.19 9,000.00 4,098.98 5,000.00 0.00 061-0520-520.030-00 MOTOR VEHICLE EXPENSE 9,500.00 8,630.77 11,000.00 11,953.27 11,000.00 0.00 061-0520-520.040-00 FUEL 6,000.00 6,706.02 8,000.00 5,643.80 8,000.00 0.00 061-0520-530.000-00 ACCOUNTING & AUDITING 1,400.00 13,666.30 0.00 4,974.00 5,000.00 0.00 Budget Notes
Budget Code Subject Description
WB GASB6& State Controller Report GASB68 & Audits
061-0520-530.009-00 OTHER PROFESSIONAL SERVICE 15,000.00 57,829.24 111,000.00 49,953.02 102,000.00 0.00 Budget Notes
Budget Code Subject Description
WB Rate Study Rate Study for raising rates.
$60K - Split Water 40/Sewer 40/Refuse 20
Water = $24K
Sewer = $24K
Refuse = $12K
WB Strategic Plan Strategic Plan Split
Water = $7K
Sewer = $7K
General Fund = $7K
Total $21k
061-0520-530.011-00 TELEPHONE 7,324.24 9,255.98 7,324.00 6,931.15 7,324.00 0.00 061-0520-530.021-00 Solar Loan Principal 0.00 0.00 38,978.00 0.00 38,978.00 0.00 061-0520-530.022-00 Solar Loan Interest 0.00 0.00 16,217.00 0.00 16,217.00 0.00 061-0520-530.060-00 ELECTRIC 155,000.00 149,810.55 110,000.00 100,849.24 110,000.00 0.00 061-0520-530.072-00 OTHER EQUIPMENT REPAIR 20,000.00 5,079.36 50,000.00 6,794.24 40,000.00 0.00 061-0520-530.090-00 MEMBERSHIPS/SUBSCRIPTION 500.00 94.00 0.00 0.00 0.00 0.00 061-0520-530.091-00 MEETINGS & TRAINING 0.00 213.90 500.00 897.49 500.00 0.00 061-0520-530.094-00 LICENSES & PERMIT FEES 40,000.00 39,727.10 40,000.00 44,615.00 45,000.00 0.00 061-0520-530.095-00 TAXES 20,500.00 20,464.62 21,730.00 20,746.26 21,730.00 0.00 061-0520-530.102-00 BOND PRINC/COP'S & SRF (CITI 74,413.53 0.00 74,414.00 78,142.59 74,414.00 0.00 5/22/2023 2:38:28 PM Page 39 ol 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 061-0520-530.111-00 NOTE PAYABLE (VIERRA LOAN) 9,251.16 0.00 9,251.00 9,031.76 9,715.00 0.00 061-0520-530.112-00 PRINCIPAL USDA COP CITY HAL 5,000.00 0.00 5,000.00 0.00 5,000.00 0.00 061-0520-530.121-00 INTEREST - COP'S & SRF (CITIZE 91,595.02 17,181.49 91,595.00 13,452.43 91,595.00 0.00 061-0520-530.122-00 INTEREST EXPENSE (VIERRA LO 6,098.34 7,276.46 6,098.00 5,038.63 4,870.00 0.00 061-0520-530.123-00 INTEREST USDA COP CITY HALL 10,381.25 10,286.75 10,194.00 0.00 10,194.00 0.00 061-0520-530.125-00 EQUIPMENT LEASE 24,873.34 24,873.34 24,873.00 24,873.34 24,873.00 0.00 061-0520-530.126-00 INTEREST - EQUIPMENT LEASE 4,724.74 4,724,74 4,725.00 4,724.74 4,725.00 0.00 061-0520-530.201-00 OTHER CONTRACT SERVICES 320,500.00 108,002.26 407,000.00 219,090.73 450,000.00 0.00 Budget Notes
Budget Code Subject Description
wB Lagoon System Treatment 12 month lagoon treatment schedule/Microbe Lift Sludge Annual $30,600
061-0520-540.011-00 BUILDINGS 1,000.00 1,733.16 1,000.00 1,979.85 2,000.00 0.00 061-0520-540.020-00 OTHER IMPROVEMENTS 20,000.00 11,065.03 20,000.00 26,906.65 20,000.00 0.00 061-0520-540.030-00 MACHINERY & EQUIPMENT 132,500.00 89,381.72 50,000.00 72,599.14 56,666.67 0.00 Budget Notes
Budget Code Subject Description
WB Message Board City to purchase a Message Board. Estimate $20,000 Split between departments - Police/Water/Sewer
Sewer Portion = $6,666.67
061-0520-540.039-00 MAINTENANCE CONTRACTS 10,639.87 21055.34 10,640.00 8,175.76 10,640.00 0.00 Department: 0520 - SEWER Total: 1,328,063.49 924,562.82 1,471,114.00 1,012,726.06 1,516,784.67 0.00 5/22/2023 2:38:28 PM Page 40 ol 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Department: 0999 - MISSING DESCRIPTION
061-0999-990.099-00 TRANS OF FUNDS OUT 3,000.00 12,705.00 0.00 3,000.00 5,000.00 0.00 Budget Notes
Budget Code Subject Description
WB FY23/24 - Equipment Replace Equipment to be replaced by MidValley IT Quote #MVQQ7078
Replacement of 5 Computers with licensing. $9,052.12
Quote #: MVQQ7079
Replacement of 3 laptops with licensing. $5,457.55
Total $15000
Department: 0999 - MISSING DESCRIPTION Total: 3,000.00 12,705.00 0.00 3,000.00 5,000.00 0.00 Expense Total: 1,674,968.73 1,305,029.96 1,975,283.00 1,444,460.93 2,024,575.67 0.00 Fund: 061 - SEWER FUND Surplus (Deficit): 24,637.57 671,935.55 5,419.00 220,680.96 29,896.33 0.00 Fund: 062 - REFUSE
Revenue
Department: 0000 - MISSING DESCRIPTION
062-0000-430.032-00 SOLD WASTE SERVICE CHARG 575,069.14 567,346.30 734,400.00 616,782.23 734,400.00 0.00 062-0000-430.033-00 SOLID WASTE BIN RENTAL / FR 12,000.00 20,725.85 12,000.00 24,740.46 12,000.00 0.00 062-0000-430.083-00 REFUSE LATE FEES 8,000.00 6,943.06 8,000.00 23,965.93 8,000.00 0.00 Department: 0000-MISSING DESCRIPTION Total: 595,069.14 595,015.21 754,400.00 665,488.62 754,400.00 0.00 Revenue Total: 595,069.14 595,015.21 754,400.00 665,488.62 754,400.00 0.00 Expense
Department: 0000 - MISSING DESCRIPTION
062-0000-530.991-00 ACCRUED COMPENSATED ABSE 0.00 -1,561.11 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 -1,561.11 0.00 0.00 0.00 0.00 Department: 0120 - CITY MANAGER
062-0120-500.000-00 SALARIES - FULL TIME EMPL 7,812.79 7,654.08 1,562.00 2,326.77 2,491.00 0.00 062-0120-510.000-00 PERS 917.38 760.60 181.00 72.92 95.00 0.00 062-0120-510.010-00 OASDI 597.68 545.83 120.00 177.47 120.00 0.00 062-0120-510.012-00 UNEMPLOYMENT INSURANCE 600.00 0.00 600.00 0.00 600.00 0.00 062-0120-510.020-00 GROUP HEALTH INSURANCE 545.60 360.01 84.00 542.55 84.00 0.00 062-0120-510.030-00 WORKER'S COMP INSURANCE 245.38 237.49 55.00 235.28 55.00 0.00 062-0120-520.030-00 MOTOR VEHICLE EXPENSE 240.00 200.00 48.00 15.36 48.00 0.00 5/22/20232:36:28 PM Page 41 ot 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 062-0120-530.011-00 TELEPHONE 0.00 0.00 0.00 5.09 0.00 0.00 Department: 0120 - CITY MANAGER Total: 10,958.83 9,758.01 2,650.00 3,375.44 3,493.00 0.00 Department: 0140 - FINANCE
062-0140-500.000-00 SALARIES - FULL TIME EMPL 17,373.74 18,279.44 1,944.00 3,503.15 3,769.00 0.00 062-0140-500.010-00 SALARIES - PART TIME EMPL 5,145.50 3,342.74 4,672.00 3,687.60 4,181.00 0.00 062-0140-500.030-00 OVERTIME 0.00 3.36 0.00 0.15 0.00 0.00 062-0140-510.000-00 PERS 1,741.19 1,628.29 472.00 417.80 497.00 0.00 062-0140-510.010-00 OASDI 1,722.72 1,635.13 506.00 488.77 506.00 0.00 062-0140-510.012-00 UNEMPLOYMENT INSURANCE 150.00 348.80 150.00 93.42 150.00 0.00 062-0140-510.020-00 GROUP HEALTH INSURANCE 5,953.48 6,054.72 645.00 5,998.72 645.00 0.00 062-0140-510.030-00 WORKER'S COMP INSURANCE 3,435.35 3,324.91 2,077.00 3,293.87 2,077.00 0.00 062-0140-520.000-00 OFFICE SUPPLIES 1,500.00 364.27 1,500.00 0.00 500.00 0.00 062-0140-520.010-00 DEPT OPERATING SUPPLIES 700.00 638.40 700.00 125.46 500.00 0.00 062-0140-520.030-00 MOTOR VEHICLE EXPENSE 240.00 240.00 24.00 13.00 24.00 0.00 062-0140-530.000-00 ACCOUNTING & AUDITING 140.00 1,021,75 454.00 494.40 454.00 0.00 062-0140-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 0.00 0.00 78.07 0.00 0.00 062-0140-530.014-00 POSTAGE 3,000.00 3,759.68 3,000.00 2,111.57 3,000.00 0.00 062-0140-530.030-00 ADVERTISING 0.00 72.00 0.00 238.22 0.00 0.00 062-0140-530.092-00 BANK COSTS 3,439.00 5,749.51 3,439.00 0.00 3,439.00 0.00 062-0140-530.201-00 OTHER CONTRACT SERVICES 4,862.00 2,584.74 4,862.00 1,469.67 2,500.00 0.00 Department: 0140 - FINANCE Total: 49,402.98 49,047.74 24,445.00 22,013.87 22,242.00 0.00 Department: 0142 - CITY CLERK
062-0142-500.000-00 SALARIES - FULL TIME EMPL 3,160.49 1,996.29 13,341.00 11,274.89 12,676.00 0.00 062-0142-510.000-00 PERS 318.15 231.05 1,347.00 1,126.18 1,350.00 0.00 062-0142-510.010-00 OASDI 241.78 147.14 1,021.00 845.69 1,021.00 0.00 062-0142-510.020-00 GROUP HEALTH INSURANCE 1,037.10 1,563.46 6,646.00 1,779.01 6,546.00 0.00 062-0142-510.030-00 WORKER'S COMP INSURANCE 294.46 285.01 1,093.00 282.34 1,093.00 0.00 062-0142-520.030-00 MOTOR VEHICLE EXPENSE 108.00 140.00 360.00 253.75 360.00 0.00 062-0142-530.240-00 PROFESSIONAL DEVELOPMENT 0.00 795.48 1,500.00 245.27 1,500.00 0.00 Department: 0142 - CITY CLERK Total: 5,159.98 5,258.43 25,308.00 15,807.13 24,646.00 0.00 5/22/2023 2:38:28 PM Page 42 ul 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Department: 0150 - GENERAL GOVERNMENT BLDG
062-0150-500.000-00 SALARIES - FULL TIME EMPLOY 0.00 5,117,90 0.00 2,243.84 2,473.00 0.00 062-0150-500.010-00 SALARIES - PART TIME EMPL 7,399.79 6,754.42 7,471.00 5,559.97 6,169.00 0.00 062-0150-500.030-00 OVERTIME 0.00 883.17 0.00 219.82 0.00 0.00 062-0150-510.000-00 PERS 572.15 888.12 390.00 582.06 644.00 0.00 062-0150-510.010-00 DASDI 0.00 955.75 0.00 605.53 0.00 0.00 062-0150-510.020-00 GROUP HEALTH INSURANCE 555.92 551.23 589.00 526.03 589.00 0.00 062-0150-510.030-00 WORKER'S COMP INSURANCE 1,717.68 1,662.45 1,913.00 1,646.94 1,913.00 0.00 Department: 0150- GENERAL GOVERNMENT BLDG Total: 10,245.54 16,813.04 10,363.00 11,384.19 11,788.00 0.00 Department: 0510 - SOLID WASTE
062-0510-510.000-00 PERS 0.00 0.00 0.00 0.77 1.00 0.00
062-0510-510.030-00 WORKER'S COMP INSURANCE 1,717.68 0.00 1,913.00 0.00 1,913.00 0.00 062-0510-520.000-00 OFFICE SUPPLIES 0.00 682.56 0.00 660.97 0.00 0.00 062-0510-520.010-00 DEPT OPERATING SUPPLIES 1,140.00 486.76 1,140.00 553.63 1,000.00 0.00 062-0510-520.011-00 UNIFORM ALLOWANCE 1,195.00 1,150.67 1,195.00 918.41 1,195.00 0.00 062-0510-530.009-00 OTHER PROFESSIONAL SERVICE 543,422.78 561,533.29 624,240.00 607,792.08 636,240.00 0.00 Budget Notes
Budget Code Subject Description
wB Rate Study Rate Study for raising rates.
$60K - Split Water 40/Sewer 40/Refuse 20
Water = $24K
Sewer = $24K
Refuse = $12K
062-0510-530.011-00 TELEPHONE & INTERNET 3,499.57 4,570.21 3,500.00 3,596.96 3,500.00 0.00 062-0510-530.030-00 ADVERTISING 500.00 0.00 500.00 72.00 500.00 0.00 062-0510-530.201-00 OTHER CONTRACT SERVICES 10,000.00 13,927.60 25,000.00 4,011.95 5,000.00 0.00 062-0510-540.011-00 BUILDINGS 0.00 0.00 0.00 144.70 0.00 0.00 062-0510-540.038-00 TECHNOLOGY PURCH/REPLACE 0.00 1,850.66 0.00 3,846.95 0.00 0.00 062-0510-540.039.00 MAINTENANCE CONTRACTS 6,448.41 8,150.95 6,448.00 3,827.23 6,448.00 0.00 Department: 0510 - SOLID WASTE Total: 567,923.44 592,352.70 663,936.00 625,425.65 655,797.00 0.00 Department: 0530 - REFUSE
062-0530-500.000-00 SALARIES- FULL TIME EMPL 23,828.09 23,865.52 6,106.00 6,074.29 6,823.00 0.00 5/22/2023 2:38:28 PM Page 43 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 062-0530-500.020-00 WAGES - HOURLY EMPLOYEES 0.00 1,717.54 0.00 0.00 0.00 0.00 062-0530-500.030-00 OVERTIME 0.00 973.57 0.00 997.77 0.00 0.00 062-0530-510.000-00 PERS 24,543.12 25,234.64 16,616.00 14,996.98 18,525.00 0.00 062-0530-510.010-00 OASDI 1,822.85 1,985.74 467.00 531.64 467.00 0.00 062-0530-510.020-00 GROUP HEALTH INSURANCE 6,895.25 9,998.09 2,284.00 8,922.07 2,284.00 0.00 062-0530-510.030-00 WORKER'S COMP INSURANCE 2,502.90 2,422.43 710.00 2,399.79 710.00 0.00 062-0530-520.030-00 MOTOR VEHICLE EXPENSE 0.00 360.00 0.00 67.50 65.00 0.00 062-0530-530.000-00 ACCOUNTING & AUDITING 140.00 0.00 454.00 0.00 150.00 0.00 Department: 0530 - REFUSE Total: 59,732.21 66,557.53 26,637.00 33,990.04 29,024.00 0.00 Expense Total: 703,422.98 738,226.34 753,339.00 711,996.32 746,990.00 0.00 Fund: 062 - REFUSE Surplus (Deficit): -108,353.84 -143,211.13 1,061.00 -46,507.70 7,410.00 0.00 Fund: 063 - AIRPORT FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
063-0000-420.015-00 FED-AVIATION GRANT 9,000.00 0.00 110,000.00 0.00 110,000.00 0.00 063-0000-420.031-00 STATE - AVIATION 10,000.00 0.00 10,000.00 0.00 10,000.00 0.00 063-0000-420.042-00 SPONSORSHIPS AIRPORT 4,000.00 0.00 4,000.00 3,779.00 4,200.00 0.00 063-0000-430.020-00 MISC AIRPORT REVENUE 0.00 20,150.00 0.00 360.00 0.00 0.00 063-0000-430.021-00 FAA 8,000.00 0.00 9,000.00 0.00 9,000.00 0.00 063-0000-430.022-00 AIRPORT RENTAL 26,000.00 15,798.95 12,000.00 15,957.18 13,000.00 0.00 063-0000-430.023-00 SALE OF AVIATION GASOLINE 70,000.00 101,781.17 80,000.00 110,890.85 95,000.00 0.00 063-0000-430.084-00 AIRPORT LATE FEES 0.00 83.75 0.00 383.47 0.00 0.00 063-0000-450.033-00 DONATIONS 0.00 0.00 200.00 950.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 127,000.00 137,813.87 225,200.00 132,320.50 241,200.00 0.00 Revenue Total: 127,000.00 137,813.87 225,200.00 132,320.50 241,200.00 0.00 *Departmen: -MISSING DESCRIPTION
063-0000-530.991-00 ACCRUED COMPENSATED ABSE 0.00 2,862.94 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 2,862.94 0.00 0.00 0.00 0.00 Department: 0120 - CITY MANAGER
063-0120-500.002-00 CITY MGR SALARIES 7,812.79 7,653.79 10,937.00 14,089.95 15,173.00 0.00 063-0120-510.000-00 PERS 917.38 761.02 1,268.00 509.26 669.00 0.00 5/22/2023 2:38:28 PM Page 44 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 063-0120-510.010-00 OASDI 597.68 544.98 837.00 1,074.34 837.00 0.00 063-0120-510.012-00 UNEMPLOYMENT INSURANCE 50.00 0.00 50.00 0.00 50.00 0.00 063-0120-510.020-00 GROUP HEALTH INSURANCE 545.60 359.93 588.00 542.55 588.00 0.00 063-0120-510.030-00 WORKER'S COMP INSURANCE 245.38 237.49 383.00 235.28 383.00 0.00 063-0120-520.030-00 MOTOR VEHICLE EXPENSE 240.00 200.00 336.00 107.79 336.00 0.00 063-0120-530.011-00 TELEPHONE 0.00 0.00 0.00 35.99 0.00 0.00 063-0120-530.091-00 MEETINGS & TRAINING 500.00 0.00 500.00 0.00 500.00 0.00 Department: 0120 - CITY MANAGER Total: 10,908.83 9,757.21 14,899.00 16,595.16 18,536.00 0.00 Department: 0140 - FINANCE
063-0140-500.000-00 SALARIES - FULL TIME EMPL 3,474.75 3,451.58 2,916.00 2,873.02 3,197.00 0.00 063-0140-500.030-00 OVERTIME 0.00 0.67 0.00 0.29 0.00 0.00 063-0140-510.000-00 PERS 268.67 260.27 218.00 144.68 176.00 0.00 063-0140-510.010-00 OASDI 265.82 260.17 223.00 157.64 223.00 0.00 063-0140-510.012-00 UNEMPLOYMENT INSURANCE 0.00 50.09 0.00 18.69 0.00 0.00 063-0140-510.020-00 GROUP HEALTH INSURANCE 1,190.70 1,210.71 1,218.00 1,199.73 1,218.00 0.00 063-0140-510.030-00 WORKER'S COMP INSURANCE 294.46 284.99 273.00 282.34 273.00 0.00 063-0140-520.030-00 MOTOR VEHICLE EXPENSE 48.00 48.00 24.00 5.00 24.00 0.00 Department: 0140 - FINANCE Total: 5,542.40 5,566.48 4,872.00 4,681.39 5,111.00 0.00 Department: 0142 - CITY CLERK
063-0142-500.003-00 AIRPORT CITY CLERK 5,267.49 5,028.37 6,670.00 5,832.45 6,670.00 0.00 063-0142-510.000-00 PERS 530.24 498.95 673.00 587.40 701.00 0.00 063-0142-510.010-00 OASDI 402.96 373.44 510.00 437.05 510.00 0.00 063-0142-510.012-00 UNEMPLOYMENT INSURANCE 20.00 77.84 20.00 11.82 20.00 0.00 063-0142-510.020-00 GROUP HEALTH INSURANCE 1,728.50 2,772.56 3,323.00 2,965.10 3,323.00 0.00 063-0142-510.030-00 WORKER'S COMP INSURANCE 490.76 1,370.85 546.00 470.56 546.00 0.00 063-0142-520.030-00 MOTOR VEHICLE EXPENSE 180.00 150.00 180.00 131.25 180.00 0.00 063-0142-530.011-00 TELEPHONE & INTERNET 0.00 0.00 0.00 50.00 60.00 0.00 063-0142-530.240-00 PROFESSIONAL DEVELOPMENT 0.00 803.14 750.00 250.47 500.00 0.00 Department: 0142 - CITY CLERK Total: 8,619.95 11,075.15 12,672.00 10,736.10 12,510.00 0.00 Department: 0210 - POLICE
063-0210-500.000-00 SALARIES - FULL TIME EMPL 1,961.64 1,961.10 2,010.00 1,873.81 2,088.00 0.00 5/22/2023 2:38:28 PM Page 45 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 063-0210-510.000-00 PERS 336.69 402.68 343.00 364.78 425.00 0.00 063-0210-510.010-00 OASDI 150.07 148.63 154.00 142.14 154.00 0.00 063-0210-510.020-00 GROUP HEALTH INSURANCE 397.83 418.71 417.00 468.64 417.00 0.00 063-0210-510.030-00 WORKER'S COMP INSURANCE 98.15 95.00 109.00 94.12 109.00 0.00 Department: 0210 - POLICE Total: 2,944.38 3,026.12 3,033.00 2,943.49 3,193.00 0.00 Department: 0340 - AIRPORT
063-0340-500.000-00 SALARIES - FULL TIME EMPL 3,893.94 3,440.46 20,006.00 15,322.60 18,046.00 0.00 063-0340-500.030-00 OVERTIME 0.00 0.00 449.41 0.00 0.00 063-0340-510.000-00 PERS 320.41 326.00 1,531.45 1,711.00 0.00 063-0340-510.010-00 OASDI 297.89 1,530.00 1,195.96 1,530.00 0.00 063-0340-510.012-00 UNEMPLOYMENT INSURANCE 30.00 30.00 0.00 30.00 0.00 063-0340-510.020-00 GROUP HEALTH INSURANCE 1,179.20 7,688.00 976.85 7,688.00 0.00 063-0340-510.030-00 WORKER'S COMP INSURANCE 392.61 1,476.00 376.42 1,476.00 0.00 063-0340-520.010-00 DEPT OPERATING SUPPLIES 4,000.00 4,000.00 3,405.40 4,000.00 0.00 063-0340-520.011-00 UNIFORM ALLOWANCE 0.00 0.00 23.28 0.00 0.00 063-0340-520.016-00 AVIATION GASOLINE 35,000.00 83,132.21 38,000.00 82,173.95 85,000.00 0.00 063-0340-520.030-00 MOTOR VEHICLE EXPENSE 0.00 140.00 0.00 106.00 0.00 0.00 063-0340-530.000-00 ACCOUNTING & AUDITING 175.00 1,276.85 568.00 618.00 568.00 0.00 063-0340-530.009-00 OTHER PROFESSIONAL SERVICE 8,000.00 11,392.54 8,000.00 3,851.97 8,000.00 0.00 063-0340-530.011-00 TELEPHONE 87.49 157.40 87.00 271.30 150.00 0.00 063-0340-530.014-00 POSTAGE 60.00 207.08 60.00 33.96 60.00 0.00 063-0340-530.055-00 LIABILITY INSURANCE 5,500.00 5,366.00 5,800.00 6,100.00 6,500.00 0.00 063-0340-530.060-00 ELECTRIC 4,000.00 4,154.10 4,000.00 2,643.04 4,000.00 0.00 063-0340-530.072-00 OTHER EQUIPMENT REPAIR 0.00 290.00 0.00 0.00 0.00 0.00 063-0340-530.090-00 MEMBERSHIPS/SUBSCRIPTION 150.00 289.00 150.00 2,838.45 2,500.00 0.00 063-0340-530.094-00 AIRPORT LICENSE/PERMIT 801.00 970.20 801.00 903.20 950.00 0.00 063-0340-530.201-00 OTHER CONTRACT SERVICES 14,540.00 25,863.85 43,840.00 11,896.44 10,000.00 0.00 063-0340-540.038-00 TECHNOLOGY PURCH/REPLACE 322.42 0.00 322.00 0.00 322.00 0.00 Department: 0340 - AIRPORT Total: 78,749.96 139,492.23 136,684.00 134,717.68 152,531.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT
063-0460-500.000-00 SALARIES - FULL TIME EMPL 22,649.76 21,188.73 19,442.00 18,166.04 20,211.00 0.00 5/22/20232:38:28 PM Page 46 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 063-0460-510.000-00 PERS 2,659.53 2,301.32 2,253.00 1,989.99 2,373.00 0.00 063-0460-510.010-00 OASDI 2,237.00 1,537.51 2,237.00 1,327.62 2,237.00 0.00 063-0460-510.020-00 GROUP HEALTH INSURANCE 9,412.54 9,329.80 8,307.00 9,284.53 8,307.00 0.00 063-0460-520.030-00 MOTOR VEHICLE EXPENSE 1,080.00 0.00 900.00 0.00 0.00 0.00 063-0460-520.040.00 Loan Repayment - FAA Grant 0.00 0.00 16,000.00 0.00 16,000.00 0.00 Department: 0460 - ECONOMIC DEVELOPMENT Total: 38,038.83 34,357.36 49,139.00 30,768.18 49,128.00 0.00 Expense Total: 144,804.35 206,137.49 221,299.00 200,442.00 241,009.00 0.00 Fund: 063 - AIRPORT FUND Surplus (Deficit): - 17,804.35 -68,323.62 3,901.00 -68,121.50 191.00 0.00 Fund: 074 - ASSESS - BORRELLI
Revenue
Department: 0000 - MISSING DESCRIPTION
074-0000-450.000-00 INTEREST 20.00 55.24 20.00 4.91 20.00 0.00 074-0000-450.023-00 BORELLI ASSESSMENT 17,374.50 15,950.44 16,505.00 59,048.21 16,505.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 17,394.50 16,005.68 16,525.00 59,053.12 16,525.00 0.00 Revenue Total: 17,394.50 16,005.68 16,525.00 59,053.12 16,525.00 0.00 Expense
Department: 0610 - PARKS
074-0610-530.059-00 WATER UTILITY 13,000.00 933.58 13,000.00 670.02 13,000.00 0.00 074-0610-530.060-00 ELECTRIC 2,000.00 1,958.05 1,500.00 1,595.43 1,500.00 0.00 Department: 0610 - PARKS Total: 15,000.00 2,891.63 14,500.00 2,265.45 14,500.00 0.00 Department: 0910 - MISSING DESCRIPTION
074-0910-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 1,625.75 0.00 754.70 0.00 0.00 Department: 0910 - MISSING DESCRIPTION Total: 0.00 1,625.75 0.00 754.70 0.00 0.00 Expense Total: 15,000.00 4,517.38 14,500.00 3,020.15 14,500.00 0.00 Fund: 074 - ASSESS - BORRELLI Surplus (Deficit): 2,394.50 11,488.30 2,025.00 56,032.97 2,025.00 0.00 Fund: 075 - ASSESS - SOUTHPORT
Revenue
Department: 0000 - MISSING DESCRIPTION
075-0000-450.024-00 SOUTHPORT ASSESSMENT 3,956.40 2,960.39 3,956.00 2,014.13 3,956.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 3,956.40 2,960.39 3,956.00 2,014.13 3,956.00 0.00 Revenue Total: 3,956.40 2,960.39 3,956.00 2,014.13 3,956.00 0.00 5/22/2023 2:38:28 PM Page 47 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024
Total Budget Total Activity Total Budget Total Activity YTD Activity Expense
Department: 0910 - MISSING DESCRIPTION
075-0910-520.010-00 DEPT OPERATING SUPPLIES 1,500.00 0.00 1,500.00 0.00 1,500.00 0.00 075-0910-530.009-00 OTHER PROFESSIONAL SERVICE 1,780.00 120.75 1,780.00 0.00 1,780.00 0.00 075-0910-530.072-00 OTHER EQUIPMENT REPAIR 300.00 178.71 300.00 0.00 300.00 0.00 075-0910-540.030-00 MACHINERY & EQUIPMENT 300.00 0.00 300.00 0.00 300.00 0.00 Department: 0910 - MISSING DESCRIPTION Total: 3,880.00 299.46 3,880.00 0.00 3,880.00 0.00 Expense Total: 3,880.00 299.46 3,880.00 0.00 3,880.00 0.00 Fund: 075 - ASSESS - SOUTHPORT Surplus (Deficit): 76.40 2,660.93 76.00 2,014.13 76.00 0.00 Fund: 094 - SALE OF TOWN PROPERTIES
Revenue
Department: 0000 - MISSING DESCRIPTION
094-0000-400.005-00 SALE OF LAND 10,000.00 0.00 10,000.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 10,000.00 0.00 10,000.00 0.00 0.00 0.00 Revenue Total: 10,000.00 0.00 10,000.00 0.00 0.00 0.00
Expense
Department: 0141 - CITY ATTORNEY
094-0141-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 3,832.50 0.00 2,467.50 0.00 0.00 094-0141-530.201-00 OTHER CONTRACT SERVICES 0.00 65,698.75 0.00 4,245.00 0.00 0.00 Department: 0141 - CITY ATTORNEY Total: 0.00 69,531.25 0.00 6,712.50 0.00 0.00 Expense Total: 0.00 69,531.25 0.00 6,712.50 0.00 0.00
Fund: 094 - SALE OF TOWN PROPERTIES Surplus (Deficit): 10,000.00 -69,531.25 10,000.00 -6,712.50 0.00 0.00 Fund: 099 - PAYROLL TRUST FUND
Expense
Department: 0000-MISSING DESCRIPTION
099-0000-530.99-00 YEAR END ADJ 0.00 -7,018.00 0.00 0.00 0,00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 -7,018.00 0.00 0.00 0.00 0.00 Expense Total: 0.00 -7,018.00 0.00 0.00 0.00 0.00
Fund: 099 - PAYROLL TRUST FUND Total: 0.00 -7,018.00 0.00 0.00 0.00 0.00 5/27/2023 2:38:28 PM Page 48 o1 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Fund: 101 - GENERAL GOVERNMENT IMPACT FEES
Revenue
Department: 0000 - MISSING DESCRIPTION
101-0000-400.083-00 GENERAL GOVT IMPACT FEES 4,000.00 1,664.00 4,000.00 0.00 4,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 4,000.00 1,664.00 4,000.00 0.00 4,000.00 0.00 Revenue Total: 4,000.00 1,664.00 4,000.00 0.00 4,000.00 0.00 Expense
Department: 0140 - FINANCE
101-0140-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 151.96 0.00 101.25 0.00 0.00 Department: 0140 - FINANCE Total: 0.00 151.96 0.00 101.25 0.00 0.00 Expense Total: 0.00 151.96 0.00 101.25 0.00 0.00
Fund: 101 - GENERAL GOVERNMENT IMPACT FEES Surplus (Deficit): 4,000.00 1,512.04 4,000.00 -101.25 4,000.00 0.00 Fund: 102 - POLICE IMPACT FEES
Revenue
Department: 0000 - MISSING DESCRIPTION
102-0000-400.085-00 POLICE IMPACT FEES 2,500.00 1,049.00 2,500.00 15.00 2,500.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 2,500.00 1,049.00 2,500.00 15.00 2,500.00 0.00 Revenue Total: 2,500.00 1,049.00 2,500.00 15.00 2,500.00 0.00 Expense
Department: 0210 - POLICE
102-0210-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 205.94 0.00 101.25 0.00 0.00 Department: 0210 - POLICE Total: 0.00 205.94 0.00 101.25 0.00 0.00 Expense Total: 0.00 205.94 0.00 101.25 0.00 0.00
Fund: 102 - POLICE IMPACT FEES Surplus (Deficit): 2,500.00 843.06 2,500.00 -86.25 2,500.00 0.00 Fund: 103 - FIRE IMPACT FEES
Revenue
Department: 0000 - MISSING DESCRIPTION
103-0000-400.082-00 FIRE IMPACT FEES 5,000.00 2,097.00 5,000.00 0.00 5,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 5,000.00 2,097.00 5,000.00 0.00 5,000.00 0.00 Revenue Total: 5,000.00 2,097.00 5,000.00 0.00 5,000.00 0.00 5/22/20232:38:28 PM Page 49 ot 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 zz0z-1z0z 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
Department: 0220 - FIRE
103-0220-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 157.64 0.00 101.25 0.00 0.00 Department: 0220 - FIRE Total: 0.00 157.64 0.00 101.25 0.00 0.00 Expense Total: 0.00 157.64 0.00 101.25 0.00 0.00
Fund: 103 - FIRE IMPACT FEES Surplus (Deficit): 5,000.00 1,939.36 5,000.00 -101.25 5,000.00 0.00 und: 104 - PARKS IMPACT FEI
levenu
Department: 0000 - MISSING DESCRIPTION
104-0000-400.079-00 PARKS IMPACT FEES 12,000.00 4,820.00 12,000.00 0.00 12,000.00 0.00 Department: 0000-MISSING DESCRIPTION Total: 12,000.00 4,820.00 00000'2 0.00 12,000.00 0.00 Revenue Total: 12,000.00 4,820.00 12,000.00 0.00 12,000.00 0.00 Expense
Department: 0610 - PARKS
104-0610-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 208.97 0.00 101.25 0.00 0.00 Department: 0610 - PARKS Total: 0.00 208.97 0.00 101.25 0.00 0.00 Expense Total: 0.00 208.97 0.00 101.25 0.00 0.00
Fund: 104 - PARKS IMPACT FEE Surplus (Deficit): 12,000.00 4,611.03 12,000.00 -101.25 12,000.00 0.00 Fund: 105 - STORM DRAIN IMPACT FEES
Revenue
Department: 0000 - MISSING DESCRIPTION
105-0000-400.081-00 STORM DRAIN IMPACT FEES 5,000.00 9,176.00 5,000.00 0.00 5,000.00 . 0.00 Department: 0000 - MISSING DESCRIPTION Total: 5,000.00 9,176.00 5,000.00 0.00 5,000.00 0.00 Revenue Total: 5,000.00 9,176.00 5,000.00 0.00 5,000.00 0.00 Expense
Department: 0730 - STORM DRAIN
105-0730-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 291.86 0.00 101.25 0.00 0.00 Department: 0730 - STORM DRAIN Total: 0.00 291.86 0.00 101.25 0.00 0.00 Expense Total: 0.00 291.86 0.00 101.25 0.00 0.00
Fund: 105 - STORM DRAIN IMPACT FEES Surplus (Deficit: 5,000.00 8,884.14 5,000.00 -101.25 5,000.00 0.00

5/22/2023 2:38:28 PM
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Fund: 106 - WATER IMPACT FEES
Revenue
Department: 0000 - MISSING DESCRIPTION
106-0000-400.077-00 WATER IMPACT FEES 10,000.00 12,309.00 10,000.00 0.00 10,000.00 0.00 - 10,000.00
Department: 0000 - MISSING DESCRIPTION Total: 10,000.00 12,309.00 0.00 10,000.00 0.00 Revenue Total: 10,000.00 12,309.00 10,000.00 0.00 10,000.00 0.00 Expense
Department: 0710 - WATER
106-0710-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 50,924.47 0.00 101.25 0.00 0.00 Department: 0710 - WATER Total: 0.00 50,924.47 0.00 101.25 0.00 0.00 Expense Total: 0.00 50,924.47 0.00 101.25 0.00 0.00
Fund: 106 - WATER IMPACT FEES Surplus (Deficit): 10,000.00 -38,615.47 10,000.00 -101.25 10,000.00 0.00 Fund: 107 - SEWER IMPACT FEES
Revenue
Department: 0000 - MISSING DESCRIPTION
107-0000-400.078-00 SEWER IMPACT FEES 25,000.00 30,999.00 25,000.00 0.00 25,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 25,000.00 30,999.00 25,000.00 0.00 25,000.00 0.00 Revenue Total: 25,000.00 30,999.00 25,000.00 0.00 25,000.00 0.00 Expense
Department: 0520 - SEWER
107-0520-520.010-00 DEPT. OPS SUPPLIES 0.00 250.00 0.00 0.00 0.00 0.00 107-0520-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 96649(67 0.00 101.25 0.00 0.00 107-0520-540.021-00 IMPROV OTHER THAN BLDGS 0.00 487.00 0.00 0.00 0.00 0.00 Department: 0520 - SEWER Total: 0.00 30,416.96 0.00 101.25 0.00 0.00 Expense Total: 0.00 30,416.96 0.00 101.25 0.00 0.00
Fund: 107 - SEWER IMPACT FEES Surplus (Deficit): 25,000.00 582.04 25,000.00 -101.25 25,000.00 0.00 Fund: 108 - REGIONAL TRANSPORTATION IMPACT FEES
Expense
Department: 0310 - TRANSPORTATION
108-0310-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 193.58 0.00 101.25 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 0.00 193.58 0.00 101.25 0.00 0.00 Expense Total: 0.00 193.58 0.00 101.25 0.00 0.00
Fund: 108 - REGIONAL TRANSPORTATION IMPACT FEES Total: 0.00 193.58 0.00 101.25 0.00 0.00 5/22/2023 2:38:28 PM Page 51 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Fund: 200 - REGIONAL MEASURE V
Revenue
Department: 0000 - MISSING DESCRIPTION
200-0000-400.106-00 REGIONAL MEASURE V 1,089,558.50 35,287.61 830,995.00 0.00 830,995.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 1,089,558.50 35,287.61 830,995.00 0.00 830,995.00 0.00 Revenue Total: 1,089,558.50 35,287.61 830,995.00 0.00 830,995.00 0.00 Expense
Department: 1080 - CAPITAL IMPROVEMENT PROJECT
200-1080-550.106-00 CONTRACT SERVICES - HWY 33 789,558.50 39,094.03 605,995.00 135,761.24 605,995.00 0.00 200-1080-550.107-00 CONTRACT SERVICES - HWY 33 300,000.00 0.00 225,000.00 0.00 225,000.00 0.00 Department: 1080 - CAPITAL IMPROVEMENT PROJECT Total: 05551680 39,094.03 830,995.00 135,761.24 830,995.00 0.00 Expense Total: 05'855'680T 39,094.03 830,995.00 135,761.24 830,995.00 0.00 Fund: 200 - REGIONAL MEASURE V Surplus (Deficit): 0.00 -3,806.42 0.00 -135,761.24 0.00 0.00 Fund: 201 - MEASURE V
Revenue
Department: 0000 - MISSING DESCRIPTION
201-0000-400.103-00 MEASURE V 198,101.00 317,341.93 200,000.00 174,968.43 200,000.00 0.00 201-0000-990.099-00 TRANSFER IN 60,380.00 0.00 22,459.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 258,481.00 317,341.93 222,459.00 174,958.43 200,000.00 0.00 Revenue Total: 258,481.00 317,341.93 222,459.00 174,968.43 200,000.00 0.00 Expense
Department: 0310 - TRANSPORTATION
201-0310-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 36,942.35 0.00 0.00 0.00 0.00 201-0310-530.201-00 OTHER CONTRACT SERVICES 258,481.00 7,740.28 0.00 22,401.00 0.00 0.00 Department: 0310 - TRANSPORTATION Total: 258,481.00 44,682.63 0.00 22,401.00 0.00 0.00 Department: 0999 - MISSING DESCRIPTION
201-0999-990.099-00 TRANS OF FUNDS OUT 0.00 29,425.68 0.00 222,459.00 0.00 0.00 Department: 0999 - MISSING DESCRIPTION Total: 0.00 29,425.68 0.00 222,459.00 0.00 0.00 Expense Total: 258,481.00 74,108.31 0.00 244,860.00 0.00 0.00 Fund: 201 - MEASURE V Surplus (Deficit): 0.00 243,233.62 222,459.00 -69,891.57 200,000.00 0.00 Fund: 202 - ALT MODES MEASURE V
Revenue
Department: 0000 - MISSING DESCRIPTION
202-0000-400.104-00 ALT MODES MEASURE V 49,525.00 76,852.36 64,000.00 43,742.11 64,000.00 0.00 5/22/2023 2:38:28 PM Page 52 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 202-0000-990.099-00 TRANSFER IN 475.00 29,425.68 280459-00 222,459.00 222,459.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 50,000.00 106,278.04 266,201.11 286,459.00 0.00 Revenue Total: 50,000.00 106,278.04 286,459.00 266,201.11 286,459.00 0.00 Expense
Department: 0310 - TRANSPORTATION
202-0310-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 13,828.27 0.00 0.00 0.00 0.00 202-0310-530.201-00 OTHER CONTRACT SERVICES 0.00 55,491.93 286,459.00 14,947.03 285,459.00 0.00 Department: 0310 - TRANSPORTATION Total: 0.00 69,320.20 286,459.00 14,947.03 286,459.00 0.00 Department: 1080 - CAPITAL IMPROVEMENT PROJECT
202-1080-550.000-00 SIDEWALK RECONST REHAB 50,000.00 0.00 0.00 0.00 0.00 0.00 Department: 1080 - CAPITAL IMPROVEMENT PROJECT Total: 50,000.00 0.00 0.00 0.00 0.00 0.00 Expense Total: 50,000.00 69,320.20 286,459.00 14,947.03 286,459.00 0.00 Fund: 202 - ALT MODES MEASURE V Surplus (Deficit): 0.00 36,957.84 0.00 251,254.08 0.00 0.00 Fund: 203 - SB1 - ROAD REPAIR/LOCAL STREETS 2017 ACT
Revenue
Department: 0000 - MISSING DESCRIPTION
203-0000-400.105-00 SB1 - ROAD REPAIR/LOCAL STR 112,860.00 117,258.87 133,235.00 89,599.26 150,250.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 112,860.00 117,258.87 133,235.00 89,599.26 150,250.00 0.00 Revenue Total: 112,860.00 117,258.87 133,235.00 89,599.26 150,250.00 0.00 Expense
Department: 0310 - TRANSPORTATION
203-0310-530.009-00 OTHER PROFESSIONAL SERVICE 112,408.90 57,421.66 133,235.00 0.00 150,250.00 0.00 Department: 0310 - TRANSPORTATION Total: 112,408.90 57,421.66 133,235.00 0.00 150,250.00 0.00 Expense Total: — 112,408.90 57,421.66 133,235.00 0.00 150,250.00 0.00 Fund: 203 - SB1 - ROAD REPAIR/LOCAL STREETS 2017 ACT Surplus ( 451.10 59,837.21 0.00 89,599.26 0.00 0.00 Fund: 204 - SB2 - BUILDING HOMES AND JOBS ACT OF 2017
Revenue
Department: 1080 - CAPITAL IMPROVEMENT PROJECT
204-1080-550.113-00 SB 2 REVENUE 100.000.00 0.00 0.00 0.00 80,000.00 0.00 Department: 1080 - CAPITAL IMPROVEMENT PROJECT Total: 100,000.00 0.00 0.00 0.00 80,000.00 0.00 Revenue Total: 100,000.00 0.00 0.00 0.00 80,000.00 0.00 Expense
Department: 1080 - CAPITAL IMPROVEMENT PROJECT
204-1080-550.114-00 GENERAL PLAN UPDATE 72,000.00 0.00 0.00 0.00 0.00 0.00 5/22/20232:38:78 PM Page 53 or 16
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 204-1080-550.115-00 HOUSING ELEMENT 2019 0.00 0.00 0.00 0.00 80,000.00 0.00 Department: 1080 - CAPITAL IMPROVEMENT PROJECT Total: 72,000.00 0.00 0.00 0.00 80,000.00 0.00 Expense Total: 72,000.00 0.00 0.00 0.00 80,000.00 0.00
Fund: 204 - SB2 - BUILDING HOMES AND JOBS ACT OF 2017 Surplus 28,000.00 0.00 0.00 0.00 0.00 0.00 Fund: 220 - ABANDONED VEHICLE FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
220-0000-430.019-00 ABANDONED VEHICLE ALLOCA 10,000.00 19,256.93 12,000.00 2,142.34 12,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 10,000.00 19,256.93 12,000.00 2,142.34 12,000.00 0.00 Revenue Total: 10,000.00 19,256.93 12,000.00 2,142.34 12,000.00 0.00 Expense
Department: 0210 - POLICE
220-0210-540.030-00 MACHINERY & EQUIPMENT 0.00 5,529.90 4,500.00 0.00 4,500.00 0.00 Department: 0210 - POLICE Total: 0.00 5,529.90 4,500.00 0.00 4,500.00 0.00 Department: 0230 - ANIMAL CONTROL
220-0230-540.030-00 MACHINERY & EQUIPMENT 4,500.00 0.00 0.00 0.00 0.00 0.00 Department: 0230 - ANIMAL CONTROL Total: 4,500.00 0.00 0.00 0.00 0.00 0.00 Expense Total: 4,500.00 5,529.90 4,500.00 0.00 4,500.00 0.00 Fund: 220 - ABANDONED VEHICLE FUND Surplus (Deficit): 5,500.00 13,727.03 7,500.00 2,142.34 7,500.00 0.00 Fund: 221 - PAL EXPLORERS - PD PROGRAMS
Revenue
Department: 0000-MISSING DESCRIPTION
221-0000-450.033-00 DONATIONS 2,000.00 18,217.32 0.00 3,114.00 0.00 0.00 221-0000-990.099-00 Transfer In 0.00 0.00 2,000.00 0.00 2,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 2,000.00 18,217.32 2,000.00 3,114.00 2,000.00 0.00 Revenue Total: 2,000.00 18,217.32 2,000.00 3,114.00 2,000.00 0.00 Expense
Department: 0210 - POLICE
221-0210-520.010-00 DEPT OPERATING SUPPLIES 2,000.00 1,253.64 2,000.00 938.27 2,000.00 0.00 Department: 0210 - POLICE Total: 2,000.00 1,253.64 2,000.00 938.27 2,000.00 0.00 Expense Total: 2,000.00 1,253.64 2,000.00 938.27 2,000.00 0.00 Fund: 221 - PAL EXPLORERS - PD PROGRAMS Surplus (Deficit): 0.00 16,963.68 0.00 2,175.73 0.00 0.00 5/22/2023 2:38:28 PM Paye 54 ol 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2z0z-1z0z EZOZ-ZZOZ 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 225 - COPS GRANT 2017UMWX0130
Expense
Department: 0999 - MISSING DESCRIPTION
225-0999-990.099-00 TRANS OF FUNDS OUT 0.00 18,696.69 0.00 0.00 0.00 0.00 Department: 0999 - MISSING DESCRIPTION Total: 0.00 18,696.69 0.00 0.00 0.00 0.00 Expense Total: 0.00 18,696.69 0.00 0.00 0.00 0.00
Fund: 225 - COPS GRANT 2017UMWX0130 Total: 0.00 18,696.69 0.00 0.00 0.00 0.00 Fund: 226 - RECYCLING FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
226-0000-420.061-00 RECYCLING REVENUE 5,000.00 6,200.00 5,000.00 20,000.00 5,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 5,000.00 6,200.00 5,000.00 20,000.00 5,000.00 0.00 Revenue Total: 5,000.00 6,200.00 5,000.00 20,000.00 5,000.00 0.00 Expense
Department: 0000 - MISSING DESCRIPTION
226-0000-530.009-00 OTHER CONTRACTED SERVICES 2,500.00 5,401.15 3,000.00 0.00 3,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 2,500.00 5,401.15 3,000.00 0.00 3,000.00 0.00 Expense Total: 2,500.00 5,401.15 3,000.00 0.00 3,000.00 0.00 Fund: 226 - RECYCLING FUND Surplus (Deficit): 2,500.00 798.85 2,000.00 20,000.00 2,000.00 0.00 Fund: 301 - SWRCB GRANT WASTEWATER PROJ C-06-B179-110
Revenue
Department: 0000 - MISSING DESCRIPTION
301-0000-420.061-00 SWRCB WW GRANT 460,474.68 0.00 460,475.00 0.00 460,475.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 460,474.68 0.00 460,475.00 0.00 460,475.00 0.00 Revenue Total: 460,474.68 0.00 460,475.00 0.00 460,475.00 0.00 Expense
Department: 0520 - SEWER
301-0520-530.009-00 OTHER PROFESSIONAL SERVICE 460,475.00 51,168.00 460,475.00 91,723.75 460,475.00 0.00 Department: 0520 - SEWER Total: 460,475.00 51,168.00 460,475.00 91,723.75 460,475.00 0.00 Expense Total: 460,475.00 51,168.00 460,475.00 91,723.75 460,475.00 0.00 Fund: 301 - SWRCB GRANT WASTEWATER PROJ C-06-8179-110 Surp -0.32 -51,168.00 0.00 -91,723.75 0.00 0.00 Fund: 302 - GUSTINE SOLAR PROJECT 2020
Revenue
Department: 0000 - MISSING DESCRIPTION
302-0000-420.062-00 SOLAR REIMBURSEMENT FRO 487,159.00 487,158.68 0.00 0.00 0.00 0.00 5/27/2023 2:38:28 PM Page 55 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 302-0000-990.099-00 TRANSFER IN 0.00 12,705.00 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 487,159.00 499,863.68 0.00 0.00 0.00 0.00 Revenue Total: 487,159.00 499,863.68 0.00 0.00 0.00 0.00 Expense
Department: 0520 - SEWER
302-0520-530.009-00 OTHER CONTRACT SERVICES 487,159.00 100,410.68 0.00 0.00 0.00 0.00 Department: 0520 - SEWER Total: 487,159.00 100,410.68 0.00 0.00 0.00 0.00 Expense Total: 487,159.00 100,410.68 0.00 0.00 0.00 0.00 Fund: 302 - GUSTINE SOLAR PROJECT 2020 Surplus (Deficit): 0.00 399,453.00 0.00 0.00 0.00 0.00 Fund: 303 - EQUIPMENT REPLACEMENT FUND
Revenue
Department: 0000-MISSING DESCRIPTION
303-0000-990.099.00 TRANSFER IN 9,000.00 0.00 9,000.00 9,000.00 15,000.00 0.00 Budget Notes
Budget Code Subject Description
WB FY23/24 Equipment Replace Equipment to be replaced by MidValley IT Quote #MVQQ7078
Replacement of 5 Computers with licensing. $9,052.12
Quate #: MVQQ7079
Replacement of 3 laptops with licensing. $5,457.55
Total $15000
Department: 0000 - MISSING DESCRIPTION Total: 9,000.00 0.00 9,000.00 9,000.00 15,000.00 0.00 Revenue Total: 9,000.00 0.00 9,000.00 9,000.00 15,000.00 0.00 Expense
Department: 0000 - MISSING DESCRIPTION
303-0000-540.030-00 MACHINERY & EQUIPMENT 9,000.00 8,463.83 9,000.00 0.00 15,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 9,000.00 8,463.83 9,000.00 0.00 15,000.00 0.00 Expense Total: 9,000.00 8,463.83 9,000.00 0.00 15,000.00 0.00 Fund: 303 - EQUIPMENT REPLACEMENT FUND Surplus (Deficit): 0.00 -8,463.83 0.00 9,000.00 0.00 0.00 Fund: 304 - ACTIVE TRANSPORTATION PLAN FUND
Revenue
Department: 0000 - MISSING DESCRIPTION
304-0000-420.062-00 ATP - REVENUE 135,000.00 115,376.49 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 135,000.00 115,376.49 0.00 0.00 0.00 0.00 Revenue Total: 135,000.00 115,376.49 0.00 0.00 0.00 0.00 5/22/2023 2:38:28 PM Page 56 or 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
Department: 0000 - MISSING DESCRIPTION
304-0000-530.009-00 OTHER CONTRACT SERVICES 135,000.00 108,686.99 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 135,000.00 108,686.99 0.00 0.00 0.00 0.00 Expense Total: 135,000.00 108,686.99 0.00 0.00 0.00 0.00 Fund: 304 - ACTIVE TRANSPORTATION PLAN FUND Surplus (Deficit): 0.00 6,689.50 0.00 0.00 0.00 0.00 Fund: 400 - WATER METER GRANT
Revenue
Department: 0000 - MISSING DESCRIPTION
400-0000-420.062-00 STATE WATER BOARD - REIMB 2,224,438.00 0.00 2,419,787.00 2,419,787.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 2,224,438.00 0.00 2,419,787.00 2,419,787.00 0.00 0.00 Revenue Total: 2,224,438.00 0.00 2,419,787.00 2,419,787.00 0.00 0.00 Expense
Department: 0710 - WATER
400-0710-530.009-00 CONTRACT SERVICES 2,224,438.00 1,239,048.15 0.00 0.00 0.00 0.00 Department: 0710 - WATER Total: 2,224,438.00 1,239,048.15 0.00 0.00 0.00 0.00 Expense Total: 2,224,438.00 1,239,048.15 0.00 0.00 0.00 0.00 Fund: 400 - WATER METER GRANT Surplus (Deficit): 0.00 - 1,239,048.15 2,419,787.00 2,419,787.00 0.00 0.00 Fund: 401 - TOBACCO GRANT
Revenue
Department: 0210- POLICE
401-0210-100.024-00 TOBACCO GRANT REIMBUSEM 81,365.00 39,820.68 90,321.00 57,493.87 90,321.00 0.00 Department: 0210 - POLICE Total: 81,365.00 39,820.68 90,321.00 57,493.87 90,321.00 0.00 Revenue Total: 81,365.00 39,820.68 90,321.00 57,493.87 90,321.00 0.00 Expense
Department: 0210 - POLICE
401-0210-500.000-00 SALARIES - FULL TIME EMPL 58,202.59 53,001.97 60,678.00 56,160.52 62,623.00 0.00 401-0210-500.030-00 OVERTIME 0.00 0.00 0.00 8,719.04 0.00 0.00 401-0210-510.000-00 PERS 7,591.95 6,655.27 7,755.00 7,219.81 8,556.00 0.00 401-0210-510.010-00 OASDI 4,452.50 4,157.96 4,642.00 5,037.91 4,642.00 0.00 401-0210-510.020-00 GROUP HEALTH INSURANCE 11,118.32 11,852.56 11,781.00 10,521.11 11,781.00 0.00 5/22/2023 2:38:28 PM Page 57 of 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 401-0210-510.030-00 WORKER'S COMP INSURANCE 0.00 0.00 5,465.00 0.00 5,465.00 0.00 Department: 0210 - POLICE Total: 81,365.36 75,667.76 90,321.00 87,658.39 93,067.00 0.00 Expense Total: 81,365.36 75,667.76 90,321.00 87,658.39 93,067.00 0.00 Fund: 401 - TOBACCO GRANT Surplus (Deficit: -0.36 -35,847.08 0.00 -30,164.52 -2,746.00 0.00 Fund: 403 - AMERICAN RESCUE PLAN ACT FUND (ARPA)
Revenue
Department: 0000 - MISSING DESCRIPTION
403-0000-420.062-00 AMERICAN RESCUE PLAN REVE 1,158,000.00 703,550.00 703,549.00 703,550.00 703,549.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 1,158,000.00 703,550.00 703,549.00 703,550.00 703,549.00 0.00 Revenue Total: 1,158,000.00 703,550.00 703,549.00 703,550.00 703,549.00 0.00 Expense
Department: 0000 - MISSING DESCRIPTION
403-0000-500.000-00 SALARIES - FULL TIME EMPL 0.00 30,127.58 0.00 0.00 0.00 0.00 103-0000-510.010.00 OASDI 0.00 4,609.56 0.00 0.00 0.00 0.00 403-0000-510.013-00 PAYROLL TAXES 0.00 2,322.78 0.00 0.00 0.00 0.00 403-0000-530.009-00 OTHER CONTRACT SERVICES 1,158,000.00 4,837.88 703,549.00 0.00 703,549.00 0.00 403-0000-530.010-00 BUSINESS GRANTS 0.00 158,676.28 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 1,158,000.00 200,574.08 703,549.00 0.00 703,549.00 0.00 Expense Total: 1,158,000.00 200,574.08 703,549.00 0.00 703,549.00 0.00 Fund: 403 - AMERICAN RESCUE PLAN ACT FUND (ARPA) Surplus (De 0.00 502,975.92 0.00 703,550.00 0.00 0.00 Fund: 501 - PIONEER PARK REHABILITATION GRANT
Revenue
Department: 0000 - MISSING DESCRIPTION
501-0000-420.062-00 STATE OF CALIFORNIA GRANT 1,300,000.00 0.00 1,300,000.00 0.00 1,300,000.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 1,300,000.00 0.00 1,300,000.00 0.00 1,300,000.00 0.00 Revenue Total: 1,300,000.00 0.00 1,300,000.00 0.00 1,300,000.00 0.00 Expense
Department: 0610 - PARKS
501-0610-200.010-00 ACCOUNTS PAYABLE 0.00 -1,421.44 0.00 1,421.44 0.00 0.00 501-0610-530.009.00 OTHER PROFESSIONAL SERVICE 1,300,000.00 21,368.84 1,280,522.00 24,534.57 1,280,522.00 0.00 Department: 0610-PARKS Total: 1,300,000.00 19,947.40 1,280,522.00 25,956.01 1,280,522.00 0.00 Expense Total: — 1,300,000.00 19,947.40 1,280,522.00 25,956.01 1,280,522.00 0.00 Fund: 501 - PIONEER PARK REHABILITATION GRANT Surplus (Deficit 0.00 -19,947.40 19,478.00 -25,956.01 19,478.00 0.00 5/22/2023 2:38:28 PM Page 58 ur 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 502 - BODYWORN CAMERA GRANT
Revenue
Department: 0000 - MISSING DESCRIPTION
502-0000-990.099-00 TRANSFER IN 0.00 17,999.72 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 0.00 17,999.72 0.00 0.00 0.00 0.00 Revenue Total: 0.00 17,999.72 0.00 0.00 0.00 0.00
Fund: 502 - BODYWORN CAMERA GRANT Total: 0.00 17,999.72 0.00 0.00 0.00 0.00 Fund: 505 - CAL VIP GRANT
Revenue
Department: 0000 - MISSING DESCRIPTION
505-0000-420.062-00 STATE OF CALIFORNIA GRANT 98,832.00 195,958.00 165,932.00 0.00 165,932.00 0.00 505-0000-990.099-00 TRANSFER IN 100,000.00 0.00 0.00 0.00 0.00 0.00 Department: 0000 - MISSING DESCRIPTION Total: 198,832.00 195,958.00 165,932.00 0.00 165,932.00 0.00 Revenue Total: 198,832.00 195,958.00 165,932.00 0.00 165,932.00 0.00 Expense
Department: 0210 - POLICE
505-0210-500.000-00 SALARIES - FULL TIME EMPL 41,098.36 38,934.43 41,823.00 12,401.98 17,746.00 0.00 505-0210-510.000-00 PERS 6,602.06 2,955.11 4,586.00 926.42 1,594.00 0.00 505-0210.510.010.00 OASDI 3,144.02 2,893.08 3,199.00 925.46 3,199.00 0.00 505-0210-510.020-00 GROUP HEALTH INSURANCE 1,053.98 31,099.85 33,228.00 5,307.10 33,228.00 0.00 505-0210-510.030-00 WORKER'S COMP INSURANCE 0.00 0.00 5,465.00 0.00 5,465.00 0.00 505-0210-520.000-00 OFFICE SUPPLIES 0.00 460.76 0.00 0.00 0.00 0.00 505-0210-520.010-00 DEPT OPERATING SUPPLIES 26,633.61 2,126.64 26,631.00 5,629.41 26,631.00 0.00 505-0210-520.040-00 TELEPHONE EXPENSE 300.00 99.39 500.00 253.46 500.00 0.00 505-0210-530.009-00 OTHER PROFESSIONAL SERVICE 0.00 9,592.50 500.00 0.00 500.00 0.00 505-0210-530.090-00 MEMBERSHIPS/SUBSCRIPTION 0.00 126.23 0.00 1,747.99 2,500.00 0.00 505-0210-530.201-00 OTHER CONTRACT SERVICES 120,000.00 132,333.36 50,000.00 49,499.97 50,000.00 0.00 Department: 0210 - POLICE Total: 198,832.03 220,621.35 165,932.00 76,691.79 141,363.00 0.00 Expense Total: 198,832.03 220,621.35 165,932.00 76,691.79 141,363.00 0.00 Fund: 505 - CAL VIP GRANT Surplus (Deficit): -0.03 -24,663.35 0.00 - 76,691.79 24,569.00 0.00 Report Surplus (Deficit): 444,836.67 1,507,108.69 2,970,414.00 2,981,924.97 752,808.86 0.00 5/22/2023 2:38:28 PM Page 39 or 16
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Group Summary
Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 001 - GENERAL FUND
Revenue
0000 - MISSING DESCRIPTION 2,314,267.91 3,040,455.88 2,560,545.00 2,431,699.26 2,769,721.00 0.00 Revenue Total: 2,314,267.91 3,040,455.88 2,560,545.00 2,431,699.26 2,769,721.00 0.00 Expense
0110 - CITY COUNCIL 45,949.42 35,963.43 42,899.00 39,427.55 43,477.00 0.00 0120 - CITY MANAGER 37,475.01 40,149.14 47,595.00 35,899.78 75,102.00 0.00 0130 - ELECTIONS 0.00 0.00 0.00 10,549.20 0.00 0.00
0140 - FINANCE 65,865.23 55,940.29 62,447.00 124,215.62 61,399.00 0.00 0141 - CITY ATTORNEY 55,000.00 149,254.44 102,000.00 170,706.63 157,784.00 0.00 0142 - CITY CLERK 80,782.33 91,750.28 94,529.00 86,445.07 95,803.00- 0.00 0150 - GENERAL GOVERNMENT BLDG 112,137.38 100,757.45 112,121.00 81,537.17 116,105.00 0.00 0210 - POLICE 1,262,465.28 1,443,368.92 1,424,245.00 1,240,999.48 1,441,691.00 0.00 0220 - FIRE 38,534.40 36,019.09 34,042.00 31,472.09 43,199.00 0.00 0230 - ANIMAL CONTROL 82,787.18 74,147.98 71,385.00 65,129.30 72,624.00 0.00 0410 - PLANNING 78,082.34 193,795.19 115,314.00 290,232.93 130,143.00 0.00 0460 - ECONOMIC DEVELOPMENT 72,158.31 71,519.63 80,054.00 69,995.77 81,769.00 0.00 0610 - PARKS 147,289.77 181,744.02 213,827.00 201,907.60 269,781.00 0.00 0999 - MISSING DESCRIPTION 128,000.00 339,336.00 135,072.00 135,072.00 72,072.00 0.00 Expense Total: 2,206,526.65 2,813,745.86 2,535,530.00 2,583,590.19 2,660,949.00 0.00 Fund: 001 - GENERAL FUND Surplus (Deficit): 107,741.26 226,710.02 25,015.00 -151,890.93 108,772.00 0.00 Fund: 002 - UTILITY TAX FUND
Revenue
0000 - MISSING DESCRIPTION 445,336.22 310,853.63 298,000.00 185,348.61 313,000.00 0.00 Revenue Total: 445,336.22 310,853.63 298,000.00 185,348.61 313,000.00 0.00 Expense
0110 - CITY COUNCIL 0.00 60,000.00 0.00 0.00 0.00 0.00
0145 - UUT 5,000.00 262,656.28 5,000.00 20,199.79 5,000.00 0.00 0147 - SUMMER YOUTH Y-LEAD 226,000.00 0.00 22,000.00 29,500.00 22,000.00 0.00 0150 - GENERAL GOVERNMENT BLDG 0.00 0.00 18,460.00 0.00 0.00 0.00 0999 - MISSING DESCRIPTION 214,336.00 0.00 268,000.00 241,422.00 286,345.00 0.00 Expense Total: — 445,336.00 322,656.28 313,460.00 291,121.79 313,345.00 0.00 Fund: 002 - UTILITY TAX FUND Surplus (Deficit): 0.22 -11,802.65 -15,460.00 -105,773.18 -345.00 0.00 Fund: 005 - COPS SLESF
Revenue
0000 - MISSING DESCRIPTION 83,000.00 0.00 50,000.00 0.00 0.00 50,000.00 0000000 0.00
Revenue Total: 83,000.00 0.00 0.00
5/2212023 2:32:29 PM Page 60 ut 70
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Expense
0210 - POLICE 83,000.00 0.00 50,000.00 0.00 60,000.00 0.00 Expense Total: 83,000.00 0.00 50,000.00 0.00 60,000.00 0.00 Fund: 005 - COPS SLESF Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 008 - CDBG REUSE FUND
Revenue
OO0O - MISSING DESCRIPTION 222,678.00 0.00 0.00 0.00 0.00 0.00 Revenue Total: 222,678.00 0.00 0.00 0.00 0.00 0.00
Expense
0140 - FINANCE 222,678.00 0.00 0.00 0.00 0.00 0.00
Expense Total: 222,678.00 0.00 0.00 0.00 0.00 0.00
Fund: 008 - CDBG REUSE FUND Surplus (Deficit): 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 009 - COMMUNITY CENTER FUND
Revenue
0000 - MISSING DESCRIPTION 62,749.00 47,177.87 67,376.00 49,926.40 66,121.00 0.00 Revenue Total: 62,749.00 47,177.87 67,376.00 49,926.40 66,121.00 0.00 Expense
0140 - FINANCE 0.00 1,081.87 950.00 50.27 958.00 0.00
0150 - GENERAL GOVERNMENT BLDG 62,749.08 62,614.08 66,427.00 52,743.70 65,163.00 0.00 Expense Total: 62,749.08 63,695.95 67,377.00 52,793.97 66,121.00 0.00 Fund: 009 - COMMUNITY CENTER FUND Surplus (Deficit): -0.08 -16,518.08 -1.00 -2,867.57 0.00 0.00 Fund: 010 - GAS TAX 2105 FUND
Revenue
0000 - MISSING DESCRIPTION 168,000.00 29,742.89 37,111.00 37,198.19 39,884.00 0.00 Revenue Total: 168,000.00 29,742.89 37,111.00 37,198.19 39,884.00 0.00 Expense
0310 - TRANSPORTATION 168,000.00 29,959.55 50,000.00 13,608.35 39,884.00 0.00 Expense Total: 168,000.00 29,959.55 50,000.00 13,608.35 39,884.00 0.00 Fund: 010 - GAS TAX 2105 FUND Surplus (Deficit): 0.00 - 216.66 -12,889.00 23,589.84 0.00 0.00 Fund: 011 - GAS TAX 2106 FUND
Revenue
0000 - MISSING DESCRIPTION 19,308.00 17,646.22 20,960.00 18,499.23 22,228.00 0.00 Revenue Total: 19,308.00 17,646.22 20,960.00 18,499.23 22,228.00 0.00 Expense
0310 - TRANSPORTATION 0.00 5,929.55 0.00 1,038.35 0.00 0.00 Expense Total: 0.00 5,929.55 0.00 1,038.35 0.00 0.00
Fund: 011 - GAS TAX 2106 FUND Surplus (Deficit): 19,308.00 11,716.67 20,960.00 17,460.88 22,228.00 0.00 5222/20232:38:26 PM
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 012 - GAS TAX 2107 FUND
Revenue
00O0 - MISSING DESCRIPTION 42,298.00 35,077.96 51,519.00 35,576.92 47,906.00 0.00 Revenue Total: 42,298.00 35,077.96 51,519.00 35,576.92 47,906.00 0.00 Expense
0310 - TRANSPORTATION 0.00 5,929.55 0.00 1,038.35 0.00 0.00 Expense Total: 0.00 5,929.55 0.00 1,038.35 0.00 0.00
Fund: 012 - GAS TAX 2107 FUND Surplus (Deficit): 42,298.00 29,148.41 51,519.00 34,538.57 47,906.00 0.00 Fund: 013 - GAS TAX 2107.5 FUND
Revenue
0000 - MISSING DESCRIPTION 2,000.00 2,000.00 2,000.00 0,00 2,000.00 0.00 Revenue Total: 2,000.00 2,000.00 2,000.00 0.00 2,000.00 0.00 Expense
0310 - TRANSPORTATION 0.00 515.17 474.60 0.00
Expense Total: 0.00 515.17 474.60 0.00
Fund: 013 - GAS TAX 2107.5 FUND Surplus (Deficit): 2,000.00 1,484.83 2,000.00 -474.60 2,000.00 0.00 Fund: 014 - LOCAL TRANSPORTATION FUND
Revenue
0000 - MISSING DESCRIPTION 12,615.00 5,952.00 12,615.00 0.00 12,615.00 0.00 Revenue Total: 12,615.00 5,952.00 12,615.00 0.00 12,615.00 0.00 Fund: 014 - LOCAL TRANSPORTATION FUND Total: 12,615.00 5,952.00 12,615.00 0.00 12,615.00 0.00 Fund: 016 - SWIM POOL FUND
Revenue
0000 - MISSING DESCRIPTION 122,138.00 142,535.86 150,278.00 161,770.78 180,746.00 0.00 Revenue Total: 122,138.00 142,535.86 150,278.00 161,770.78 180,746.00 0.00 Expense
0120 - CITY MANAGER 4,143.53 3,903.33 4,099.00 4,864.11 5,180.00 0.00 0613 - RECREATION 117,994.40 147,395.11 141,464.00 135,095.90 170,851.00 0.00 0999 - MISSING DESCRIPTION 0.00 0.00 4,715.00 4,715.00 4,715.00 0.00 Expense Total: 122,137.93 151,298.44 150,278.00 144,675.01 180,746.00 0.00 Fund: 016 - SWIM POOL FUND Surplus (Deficit): 0.07 -8,762.58 0.00 17,095.77 0.00 0.00 Fund: 017 - CITY WIDE LIGHTING & LAND
Revenue
0000 - MISSING DESCRIPTION 193,546.40 195,121.35 197,921.00 71,014.20 197,921.00 0.00 Revenue Total: 193,546.40 195,121.35 197,921.00 71,014.20 197,921.00 0.00 Expense
0120 - CITY MANAGER 9,722.44 8,052.57 9,743.00 9,986.26 11,832.00 0.00 0140 - FINANCE 11,084.79 11,133.44 12,283.00 11,430.52 12,940.00 0.00 573212073 2 38:28 PM Page 62 ü: 70
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity 0260 - STREET LIGHTING 72,000.00 57,656.31 52,000.00 46,243.16 52,000.00 0.00 0270 - LANDSCAPE LLD 5,000.00 2,181.38 5,000.00 2,147.26 5,000.00 0.00 0610 - PARKS 94,408.78 91,018.92 106,794.00 95,995.37 105,420.00 0.00 Expense Total: 192,216.01 170,042.62 185,820.00 165,802.57 187,192.00 0.00 Fund: 017 - CITY WIDE LIGHTING & LAND Surplus (Deficit): 1,330.39 25,078.73 12,101.00 -94,788.37 10,729.00 0.00 Fund: 018 - TRAFFIC SAFETY FUND
Revenue
0000-MISSING DESCRIPTION 7,400.00 3,943.10 7,400.00 2,084.99 2,000.00 0.00 Revenue Total: 7,400.00 3,943.10 7,400.00 2,084.99 2,000.00 0.00 Expense
0240 - MISSING DESCRIPTION 7,400.00 547.50 7,400.00 3,355.05 2,000.00 0.00 Expense Total: 7,400.00 547.50 7,400.00 3,355.05 2,000.00 0.00 Fund: 018 - TRAFFIC SAFETY FUND Surplus (Deficit): 0.00 3,395.60 0.00 -1,270.06 0.00 0.00 Fund: 019 - RECREATION FUND
Revenue
0000 - MISSING DESCRIPTION 101,899.00 115,720.99 109,668.00 98,805.15 123,778.00 0.00 0613 - RECREATION 2,000.00 4,780.70 3,000.00 6,613.40 5,000.00 0.00 Revenue Total: 103,899.00 120,501.69 112,668.00 105,418.55 128,778.00 0.00 Expense
0142 - CITY CLERK 24,639.86 26,739.68 29,810.00 26,056.18 29,484.00 0.00 0150 - GENERAL GOVERNMENT BLDG 11,612.91 18,385.54 11,796.00 15,427.64 16,429.00 0.00 0440 - FARMERS MARKET 1,000.00 1,713.71 2,000.00 4,166.14 2,000.00 0.00 0613 - RECREATION 66,645.77 94,124.46 69,061.00 86,920.20 30,865.00 0.00 Expense Total: 103,898.54 140,963.39 112,667.00 132,570.16 128,778.00 0.00 Fund: 019 - RECREATION FUND Surplus (Deficit): 0.46 -20,461.70 1.00 -27,151.61 0.00 0.00 Fund: 020 - CMAQ
Revenue
0000 - MISSING DESCRIPTION 4,158,000.00 488,458.15 0.00 72,839.63 0.00 0.00 Revenue Total: 4,158,000.00 483,458.15 0.00 72,839.63 0.00 0.00 Expense
0310 - TRANSPORTATION 3,945,000.00 31,164.53 0.00 83,238.69 0.00 0.00 Expense Total: 3,945,000.00 31,164.53 0.00 83,238.69 0.00 0.00 Fund: 020 - CMAQ Surplus (Deficit): 213,000.00 457,293.62 0.00 -10,399.06 0.00 0.00 Fund: 021 - REGIONAL STREET TRANSPORTATION PROGRAM
Revenue
0000 - MISSING DESCRIPTION 70,411.00 77,043.64 71,411.00 76,445.24 71,411.00 0.00 Revenue Total: 70,411.00 77,043.64 71,411.00 76,445.24 71,411.00 0.00 5172/2023 2:38:26 PM PAgO ö3 01 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
0120 - CITY MANAGER 9,437.06 7,095.73 0.00 937.56 0.00 0.00 0140 - FINANCE 12,448.98 12,822.95 0.00 3,992.95 35.00 0.00 0142 - CITY CLERK 5,273.69 4,703.20 0.00 1,732.60 16.00 0.00 0310 - TRANSPORTATION 41,266.65 38,847.32 35,188.00 35,672.27 34,993.00 0.00 Expense Total: 68,426.38 63,469.20 35,188.00 42,335.38 35,044.00 0.00 Fund: 021 - REGIONAL STREET TRANSPORTATION PROGRAM Surplu 1,984.62 13,574.44 36,223.00 34,109.86 36,367.00 0.00 Fund: 027 - PER CAPITA GRANT
Revenue
0000 - MISSING DESCRIPTION 16,000.00 142,362.00 16,000.00 0.00 35,590.00 0.00 Revenue Total: 16,000.00 142,362.00 16,000.00 0.00 35,590.00 0.00 Expense
0610 - PARKS 16,000.00 14,905.39 0.00 444.13 0.00 0.00
Expense Total: T 16,000.00 14,905.39 0.00 444.13 0.00 0.00 Fund: 027 - PER CAPITA GRANT Surplus (Deficit): 0.00 127,456.61 16,000.00 -444.13 35,590.00 0.00 Fund: 029 - GAS TAX 2103 FUND
Revenue
0000 - MISSING DESCRIPTION 45,273.00 43,294.06 57,567.00 43,863.10 60,229.00 0.00 Revenue Total: 45,273.00 43,294.06 57,567.00 43,863.10 60,229.00 0.00 Expense
0310 - TRANSPORTATION 0.00 929.51 0.00 1,038.35 0.00 0.00 Expense Total: 0.00 929.51 0.00 1,038.35 0.00 0.00
Fund: 029 - GAS TAX 2103 FUND Surplus (Deficit): 45,273.00 42,364.55 57,567.00 42,824.75 60,229.00 0.00 Fund: 034 - FIRE SERVICE FUND
Revenue
0000 - MISSING DESCRIPTION 500.00 0.00 500.00 0.00 0.00 0.00 Revenue Total: 500.00 0.00 500.00 0.00 0.00 0.00
Expense
0220 - FIRE 500.00 21,214.64 500.00 0.00 0.00 0.00
Expense Total: 500.00 21,214.64 500.00 0.00 0.00 0.00
Fund: 034 - FIRE SERVICE FUND Surplus (Deficit): 0.00 - 21,214.64 0.00 0.00 0.00 0.00 Fund: 038 - GENERAL RESERVE
Revenue
0000 - MISSING DESCRIPTION 0.00 125,696.97 0.00 125,000.00 0.00 0.00 Revenue Total: 0.00 125,696.97 0.00 125,000.00 0.00 0.00 5/22/2023 2:38:28 PM Paye 54 or 26
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
0210 - POLICE 0.00 43,995.99 0.00 0.00 0.00 0.00
Expense Total: 0.00 43,995.99 0.00 0.00 0.00 0.00
Fund: 038 - GENERAL RESERVE Surplus (Deficit): 0.00 81,700.98 0.00 125,000.00 0.00 0.00 Fund: 047 - FIREWORKS
Revenue
0000 - MISSING DESCRIPTION 33,500.00 25,280.55 31,000.00 8,595.98 34,000.00 0.00 Revenue Total: 33,500.00 26,280.55 31,000.00 8,595.98 34,000.00 0.00 Expense
0704 - FIREWORKS 33,500.00 31,941.07 31,000.00 14,962.16 37,000.00 0.00 - 33,500.00
Expense Total: 31,941.07 31,000.00 14,962.16 37,000.00 0.00 Fund: 047 - FIREWORKS Surplus (Deficit): 0.00 -5,660.52 0.00 -6,366.18 -3,000.00 0.00 Fund: 050 - LONG TERM DEBT
Expense
0000 - MISSING DESCRIPTION 0.00 1,271.62 0.00 0.00 0.00 0.00 Expense Total: 0.00 1,271.62 0.00 0.00 0.00 0.00
Fund: 050 - LONG TERM DEBT Total: 0.00 1,271.62 0.00 0.00 0.00 0.00 Fund: 059 - STORM DRAIN
Revenue
0000 - MISSING DESCRIPTION 45,500.00 41,522.88 45,500.00 99,392.32 45,500.00 0.00 Revenue Total: 45,500.00 41,522.88 45,500.00 99,392.32 45,500.00 0.00 Expense
0000 - MISSING DESCRIPTION 0.00 -28.75 0.00 0.00 0.00 0.00 0120 - CITY MANAGER 2,671.78 2,029.09 2,650.00 2,437.82 3,277.00 0.00 0140 - FINANCE 7,936.75 7,684.59 5,680.00 5,899.15 5,689.00 0.00 0210 - POLICE 10,847.27 11,725.87 8,161.00 8,701.40 9,491.00 0.00 0730 - STORM DRAIN 56,276.36 46,973.76 27,568.00 49,416.32 44,912.00 0.00 Expense Total: 77,732.16 68,384.56 44,059.00 66,454.69 63,369.00 0.00 Fund: 059 - STORM DRAIN Surplus (Deficit): -32,232.16 - 26,861.68 1,441.00 32,937.63 -17,869.00 0.00 Fund: 060 - WATER FUND
Revenue
0000 - MISSING DESCRIPTION 1,362,366.20 1,349,678.84 1,469,195.00 1,165,482.14 1,581,065.20 0.00 Revenue Total: 1,362,366.20 1,349,678.84 1,469,195.00 1,165,482.14 1,581,065.20 0.00 Expense
0000 - MISSING DESCRIPTION 0.00 2,601.26 0.00 0.00 0.00 0.00 0120 - CITY MANAGER 58,730.93 59,954.24 105,123.00 65,199.73 78,325.00 0.00 0140 - FINANCE 168,751.65 176,806.91 197,466.00 186,206.52 207,762.00 0.00 0142 - CITY CLERK 38,976.85 44,752.00 32,153.00 33,514.60 32,451.00 0.00

5/22/2023 2.38:28 PM
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 0150 - GENERAL GOVERNMENT BLDG 34,838.73 52,892.14 32,813.00 41,064.90 40,644.00 0.00 0210 - POLICE 26,218.15 27,129.85 35,864.00 32,784.83 37,431.00 0.00 0460 - ECONOMIC DEVELOPMENT 18,967.27 17,461.23 19,633.00 17,556.76 19,533.00 0.00 0520 - SEWER 0.00 3,538.06 2,700.00 3,950.30 3,042.00 0.00 0710 - WATER 992,265.40 659,135.64 1,022,540.00 698,173.50 1,061,402.67 0.00 0999 - MISSING DESCRIPTION 3,000.00 0.00 14,787.00 14,787.00 16,787.00 0.00 1080 - CAPITAL IMPROVEMENT PROJECT 0.00 0.00 0.00 240,361.53 0.00 0.00 Expense Total: 1,341,748.98 1,044,271.33 1,463,079.00 1,333,599.67 1,497,377.67 D.00 Fund: 060 - WATER FUND Surplus (Deficit): 20,617.22 305,407.51 6,116.00 -168,117.53 83,687.53 0.00 Fund: 061 - SEWER FUND
Revenue
0000 - MISSING DESCRIPTION 1,699,606.30 1,976,965.51 1,980,702.00 1,665,141,89 2,054,472.00 0.00 Revenue Total: 1,699,606.30 1,976,965.51 1,980,702.00 1,665,141,89 2,054,472.00 0.00 Expense
0000 - MISSING DESCRIPTION 0.00 -11,935.69 0.00 0.00 0.00 0.00 0120 - CITY MANAGER 51,994.15 56,872.07 114,932.00 75,823.45 101,513.00 0.00 0140 - FINANCE 180,150.08 182,341.44 240,925.00 213,008.55 239,825.00 0.00 0142 - CITY CLERK 44,049.81 51,935.15 78,859.00 61,504.78 75,280.00 0.00 0150 - GENERAL GOVERNMENT BLDG 35,640.03 53,788.37 36,252.00 46,447.12 49,649.00 0.00 0210 - POLICE 24,781.11 25,630.39 25,595.00 24,401.36 26,856.00 0.00 0410 - PLANNING 380.00 1,491.66 380.00 127.00 380.00 0.00 0460 - ECONOMIC DEVELOPMENT 6,910.06 7,638.75 7,226.00 7,422.61 9,288.00 0.00 0520 - SEWER 1,328,063.49 924,562.82 1,471,114.00 1,012,726.06 1,516,784.67 0.00 0999 - MISSING DESCRIPTION 3,000.00 12,705.00 0.00 3,000.00 5,000.00 0.00 Expense Total: 1,674,968.73 1,305,029.96 1,975,283.00 1,444,460.93 2,024,575.67 0.00 Fund: 061 - SEWER FUND Surplus (Deficit): 24,637.57 671,935.55 5,419.00 220,680.96 29,896.33 0.00 Fund: 062 - REFUSE
Revenue
0000 - MISSING DESCRIPTION 595,069.14 595,015.21 754,400.00 665,488.62 754,400.00 0.00 Revenue Total: 595,069.14 595,015.21 754,400.00 665,488.62 754,400.00 0.00 Expense
0000 - MISSING DESCRIPTION 0.00 -1,561.11 0.00 0.00 0.00 0.00 0120 - CITY MANAGER 10,958.83 9,758.01 2,650.00 3,375.44 3,493.00 0.00 0140 - FINANCE 49,402.98 49,047.74 24,445.00 22,013.87 22,242.00 0.00 0142 - CITY CLERK 5,159.98 5,258.43 25,308.00 15,807.13 24,646.00 0.00 0150 - GENERAL GOVERNMENT BLDG 10,245.54 16,813.04 10,363.00 11,384.19 11,788.00 0.00 0510 - SOLID WASTE 567,923.44 592,352.70 663,936.00 625,425.65 655,797.00 0.00 0530 - REFUSE 59,732.21 66,557.53 26,637.00 33,990.04 29,024.00 0.00 5/22/202:2:38:28 PM Faye 660: 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Expense Total: 703,422.98 73B,226.34 753,339.00 711,996.32 746,990.00 0.00 - -143,211.13 7,410.00 0.00
Fund: 062 - REFUSE Surplus (Deficit): -108,353.84 1,061.00 -46,507.70 Fund: 063 - AIRPORT FUND
Revenue
0000 - MISSING DESCRIPTION 127,000.00 137,813.87 225,200.00 132,320.50 241,200.00 0.00 Revenue Total: 127,000.00 137,813.87 225,200.00 132,320.50 241,200.00 0.00 Expense
0000 - MISSING DESCRIPTION 0.00 2,862.94 0.00 0.00 0.00 0.00 0120 - CITY MANAGER 10,908.83 9,757.21 14,899.00 16,595.16 18,536.00 0.00 0140 - FINANCE 5,542.40 5,566.48 4,872.00 4,681.39 5,111.00 0.00 0142 - CITY CLERK 8,619.95 11,075.15 12,672.00 10,736.10 12,510.00 0.00 0210 - POLICE 2,944.38 3,026.12 3,033.00 2,943.49 3,193.00 0.00 0340 - AIRPORT 78,749.96 139,492.23 136,684.00 134,717,68 152,531.00 0.00 0460 - ECONOMIC DEVELOPMENT 38,038.83 34,357.36 49,139.00 30,768.18 49,128.00 0.00 Expense Total: 144,804.35 206,137.49 221,299.00 200,442.00 241,009.00 0.00 Fund: 063 - AIRPORT FUND Surplus (Deficit): -17,804.35 -68,323.62 3,901.00 -68,121.50 191.00 0.00 Fund: 074 - ASSESS - BORRELLI
Revenue
0000 - MISSING DESCRIPTION 17,394.50 16,005.68 16,525.00 59,053.12 16,525.00 0.00 Revenue Total: 17,394.50 16,005.68 16,525.00 59,053.12 16,525.00 0.00 Expense
0610 - PARKS 15,000.00 2,891.63 14,500.00 2,265.45 14,500.00 0.00 0910 - MISSING DESCRIPTION 0.00 1,625.75 0.00 754.70 0.00 0.00 Expense Total: 15,000.00 4,517.3B 14,500.00 3,020.15 14,500.00 0.00 Fund: 074 - ASSESS - BORRELLI Surplus (Deficit): 2,394.50 11,488.30 2,025.00 56,032.97 2,025.00 0.00 Fund: 075 - ASSESS - SOUTHPORT
Revenue
0000 - MISSING DESCRIPTION 3,956.40 2,960.39 3,956.00 2,014.13 3,956.00 0.00 Revenue Total: 3,956.40 2,960.39 3,956.00 2,014.13 3,956.00 0.00 Expense
0910 - MISSING DESCRIPTION 3,880.00 299.46 3,880.00 0.00 3,880.00 0.00 Expense Total: 3,880.00 299.46 3,880.00 0.00 3,880.00 0.00 Fund: 075 - ASSESS - SOUTHPORT Surplus (Deficit): 76.40 2,660.93 76.00 2,014.13 76.00 0.00 Fund: 094 - SALE OF TOWN PROPERTIES
Revenue
0000 - MISSING DESCRIPTION Revenue Total: 100000 0.00 10,000.00 0.00 0.00 0.00 Revenue Total: 10,000.00 0.00 10,000.00 0.00 0.00 0.00
5/72/2023 2:38:28 PM Page 6? ul 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
0141 - CITY ATTORNEY 0.00 69,531.25 0.00 6,712.50 0.00 0.00 Expense Total: 0.00 69,531.25 0.00 6,712.50 0.00 0.00
Fund: 094 - SALE OF TOWN PROPERTIES Surplus (Deficit): 10,000.00 -69,531.25 10,000.00 -6,712.50 0.00 0.00 Fund: 099 - PAYROLL TRUST FUND
Expense
0000 - MISSING DESCRIPTION 0.00 018. 0.00 0.00 0.00 0.00 Expense Total: 0.00 ,018. 0.00 0.00 0.00 0.00
Fund: 099 - PAYROLL TRUST FUND Total: 0.00 -7,018.00 0.00 0.00 0.00 0.00 Fund: 101 - GENERAL GOVERNMENT IMPACT FEES
Revenue
0000 - MISSING DESCRIPTION 4,000.00 1,664.00 4,000.00 0.00 4,000.00 0.00 Revenue Total: 4,000.00 1,664.00 4,000.00 0.00 4,000.00 0.00 Expense
0140 - FINANCE 0.00 151.96 0.00 101.25 0.00 0.00
Expense Total: 0.00 151.96 0.00 101.25 0.00 0.00
Fund: 101 - GENERAL GOVERNMENT IMPACT FEES Surplus (Deficit): 4,000.00 1,512.04 4,000.00 -101.25 4,000.00 0.0D Fund: 102 - POLICE IMPACT FEES
Revenue
0000 - MISSING DESCRIPTION 2,500.00 1,049.00 2,500.00 15.00 2,500.00 0.00 Revenue Total: 2,500.00 1,049.00 2,500.00 15.00 2,500.00 0.00 Expense
0210 - POLICE 0.00 205.94 0.00 101.25 0.00 0.00
Expense Total: 0.00 205.94 0.00 101.25 0.00 0.00
Fund: 102 - POLICE IMPACT FEES Surplus (Deficit): 2,500.00 843.06 2,500.00 86.25 2,500.00 0.00 Fund: 103 - FIRE IMPACT FEES
Revenue
0000-MISSING DESCRIPTION 5,000.00 2,097.00 5,000.00 0.00 5,000.00 0.00 Revenue Total: 5,000.00 2,097.00 5,000.00 0.00 5,000.00 0.00 Expense
0220- FIRE 0.00 157.64 0.00 101.25 0.00
Expense Total: 0.00 157.64 0.00 101.25 0.00
Fund: 103 - FIRE IMPACT FEES Surplus (Deficit): 5,000.00 1,939.36 5,000.00 -101.25 5,000.00 0.00 Fund: 104 - PARKS IMPACT FEE
Revenue
0000 - MISSING DESCRIPTION 12,000.00 4,820.00 12,000.00 12,000.00 0.00 Revenue Total: 12,000.00 4,820.00 12,000.00 12,000.00 0.00 1/22/2023 2 38:28 PM Page 06 ul 70
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Expense
0610-PARKS 0.00 208.97 0.00 101.25 0.00 0.00
Expense Total: 0.00 208.97 0.00 101.25 0.00 0.00
Fund: 104 - PARKS IMPACT FEE Surplus (Deficit: 12,000.00 4,611.03 12,000.00 -101.25 12,000.00 0.00 Fund: 105 - STORM DRAIN IMPACT FEES
Revenue
0000 - MISSING DESCRIPTION 5,000.00 9,176.00 5,000.00 0.00 5,000.00 0.00 Revenue Total: 5,000.00 9,176.00 5,000.00 0.00 5,000.00 0.00 Expense
0730 - STORM DRAIN 0.00 291.86 0.00 101.25 0.00 0.00
Expense Total: 0.00 291.86 0.00 101.25 0.00 0.00
Fund: 105 - STORM DRAIN IMPACT FEES Surplus (Deficit): 5,000.00 8,884.14 5,000.00 -101.25 5,000.00 0.00 Fund: 106 - WATER IMPACT FEES
Revenue
0000 - MISSING DESCRIPTION 10,000.00 12,309.00 10,000.00 0.00 10,000.00 0.00 Revenue Total: 10,000.00 12,309.00 10,000.00 0.00 10,000.00 0.00 Expense
0710 - WATER 0.00 50,924.47 0.00 101.25 0.00 0.00
Expense Total: 0.00 50,924,47 0.00 101.25 0.00 0.00
Fund: 106 - WATER IMPACT FEES Surplus (Deficit): 10,000.00 -38,615.47 10,000.00 -101.25 10,000.00 0.00 Fund: 107 - SEWER IMPACT FEES
Revenue
0000-MISSING DESCRIPTION 25,000.00 30,999.00 25,000.00 0.00 25,000.00 0.00 Revenue Total: 25,000.00 30,999.00 25,000.00 0.00 25,000.00 0.00 Expense
0520 - SEWER 0.00 30,416.96 0.00 101.25 0.00 0.00
Expense Total: 30,416.96 0.00 101.25 0.00 0.00
Fund: 107 - SEWER IMPACT FEES Surplus (Deficit): 25,000.00 582.04 25,000.00 -101.25 25,000.00 0.00 Fund: 10B - REGIONAL TRANSPORTATION IMPACT FEES
0310 - TRANSPORTATION 193.58 0.00 101.25 0.00 0.00
Expense Total: 0.00 193.58 0.00 101.25 0.00 0.00
Fund: 108 - REGIONAL TRANSPORTATION IMPACT FEES Total: 193.58 0.00 101.25 0.00 0.00 Fund: 200 - REGIONAL MEASURE V
Revenue
0000-MISSING DESCRIPTION 1,089,558.50 35,287.61 830,995.00 0.00 830,995.00 0.00 Revenue Total: 1,089,558.50 35,287.61 830,995.00 0.00 830,995.00 0.00 5/72/20232:38:28 PM Page 69 ct 76
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Expense
1080 - CAPITAL IMPROVEMENT PROJECT 1,089,558.50 39,094.03 830,995.00 135,761.24 830,995.00 0.00 Expense Total: 1,089,558.50 830,995.00 135,761.24 830,995.00 0.00 Fund: 200 - REGIONAL MEASURE V Surplus (Deficit): 0.00 -3,806.42 0.00 -135,761.24 0.00 0.00 Fund: 201 - MEASURE V
Revenue
0000 - MISSING DESCRIPTION 258,481.00 317,341.93 222,459.00 174,968.43 200,000.00 0.00 Revenue Total: 258,481.00 317,341.93 222,459.00 174,968.43 200,000.00 0.00 Expense
0310 - TRANSPORTATION 258,481.00 44,682.63 0.00 22,401.00 0.00 0.00 0999 - MISSING DESCRIPTION 0.00 29,425.68 0.00 222,459.00 0.00 0.00 Expense Total: 258,481.00 74,108.31 0.00 244,860.00 0.00 0.00 Fund: 201 - MEASURE V Surplus (Deficit): 0.00 243,233.62 222,459.00 -69,891.57 200,000.00 0.00 Fund: 202 - ALT MODES MEASURE V
Revenue
0000 - MISSING DESCRIPTION 50,000.00 106,278.04 286,459.00 266,201.11 286,459.00 0.00 Revenue Total: 50,000.00 106,278.04 286,459.00 266,201.11 286,459.00 0.00 Expense
0310 - TRANSPORTATION 0.00 69,320.20 286,459.00 14,947.03 286,459.00 0.00 1080 - CAPITAL IMPROVEMENT PROJECT 50,000.00 0.00 0.00 0.00 0.00 0.00 Expense Total: 50,000.00 69,320.20 286,459.00 14,947.03 286,459.00 0.00 Fund: 202 - ALT MODES MEASURE V Surplus (Deficit): 0.00 36,957.84 0.00 251,254.08 0.00 0.00 Fund: 203 - SB1 - ROAD REPAIR/LOCAL STREETS 2017 ACT
Revenue
0000 - MISSING DESCRIPTION 112,860.00 117,258.87 133,235.00 89,599.26 150,250.00 0.00 Revenue Total: 112,860.00 117,258.87 133,235.00 89,599.26 150,250.00 0.00 Expense
0310 - TRANSPORTATION 112,408.90 57,421.66 133,235.00 0.00 150,250.00 0.00 Expense Total: 112,408.90 57,421.66 133,235.00 0.00 150,250.00 0.00 Fund: 203 - SB1 - ROAD REPAIR/LOCAL STREETS 2017 ACT Surplus ( 451.10 59,837.21 0.00 89,599.26 0.00 0.00 Fund: 204 - SB2 - BUILDING HOMES AND JOBS ACT OF 2017
Revenue
1080 - CAPITAL IMPROVEMENT PROJECT 100,000.00 0.00 0.00 0.00 80,000.00 0.00 Revenue Total: 100,000.00 0.00 0.00 0.00 80,000.00 0.00 Expense
1080 - CAPITAL IMPROVEMENT PROJECT 72,000.00 0.00 0.00 0.00 80,000.00 0.00 4/02/20237: 18:28 PM
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense Total: — 72,000.00 0.00 0.00 0.00 80,000.00 0.00 Fund: 204 - 5B2 - BUILDING HOMES AND JOBS ACT OF 2017 Surplus 28,000.00 0.00 0.00 0.00 0.00 0.00 Fund: 220 - ABANDONED VEHICLE FUND
Revenue
0000-MISSING DESCRIPTION 10,000.00 19,256.93 12,000.00 2,142.34 12,000.00 0.00 Revenue Total: 10,000.00 19,256.93 12,000.00 2,142.34 12,000.00 0.00 Expense
0210 - POLICE 0.00 5,529.90 4,500.00 0.00 4,500.00 0.00 0230 - ANIMAL CONTROL 4,500.00 0.00 0.00 0.00 0.00 0.00 Expense Total: — 4,500.00 5,529.90 4,500.00 0.00 4,500.00 0.00 Fund: 220 - ABANDONED VEHICLE FUND Surplus (Deficit: 5,500.00 13,727.03 7,500.00 2,142.34 7,500.00 0.00 Fund: 221 - PAL EXPLORERS - PD PROGRAMS
Revenue
0000 - MISSING DESCRIPTION 2,000.00 18,217.32 2,000.00 3,114.00 2,000.00 Revenue Total: 2,000.00 18,217.32 2,000.00 3,114.00 2,000.00 Expense
0210 - POLICE 2,000.00 1,253.64 2,000.00 938.27 2,000.00 0.00 Expense Total: 2,000.00 1,253.64 2,000.00 938.27 2,000.00 0.00 Fund: 221 - PAL EXPLORERS - PD PROGRAMS Surplus (Deficit): 0.00 16,963.68 0.00 2,175.73 0.00 0.00 Fund: 225 - COPS GRANT 2017UMWX0130
Expense
0999 - MISSING DESCRIPTION 0.00 18,696.69 0.00 0.00 0.00 0.00 Expense Total: 0.00 18,696.69 0.00 0.00 0.00 0.00
Fund: 225 - COPS GRANT 2017UMWX0130 Total: 0.00 18,696.69 0.00 0.00 0.00 0.00 Fund: 226 - RECYCLING FUND
Revenue
0000 - MISSING DESCRIPTION 5,000.00 6,200.00 5,000.00 20,000.00 5,000.00 0.00 Revenue Total: 5,000.00 6,200.00 5,000.00 20,000.00 5,000.00 0.00 Expense
0000 - MISSING DESCRIPTION 2,500.00 5,401.15 3,000.00 0.00 3,000.00 0.00 Expense Total: 2,500.00 5,401.15 3,000.00 0.00 3,000.00 0.00 Fund: 226 - RECYCLING FUND Surplus (Deficit): 2,500.00 798.85 2,000.00 20,000.00 2,000.00 0.00 Fund: 301 - SWRCB GRANT WASTEWATER PROJ C-06-8179-110
Revenue
0000-MISSING DESCRIPTION Revenue Total. - 460477.68 0.00 460,475.00 0.00 460,475.00 0.00 Revenue Total: 460,474.68 0.00 460,475.00 0.00 460,475.00 0.00 5/22/2023 2-38:28 PM Paye 71 ol 75
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Expense
0520 - SEWER 460,475.00 51,168.00 460,475.00 91,723.75 460,475.00 0.00 Expense Total: 460,475.00 51,168.00 460,475.00 91,723.75 460,475.00 0.00 Fund: 301 - SWRCB GRANT WASTEWATER PROJ C-06-8179-110 Surp -0.32 -51,168.00 0.00 -91,723.75 0.00 0.00 Fund: 302 - GUSTINE SOLAR PROJECT 2020
Revenue
0000 - MISSING DESCRIPTION 487,159.00 499,863.68 0.00 0.00 0.00 0.00 Revenue Total: 487,159.00 499,863.68 0.00 0.00 0.00 0.00 Expense
0520-SEWER 487,159.00 100,410.68 0.00 0.00 0.00 0.00
Expense Total: 487,159.00 100,410.68 0.00 0.00 0.00 0.00 Fund: 302 - GUSTINE SOLAR PROJECT 2020 Surplus (Deficit): 0.00 399,453.00 0.00 0.00 0.00 0.00 Fund: 303 - EQUIPMENT REPLACEMENT FUND
Revenue
0000 - MISSING DESCRIPTION 9,000.00 0.00 9,000.00 9,000.00 15,000.00 0.00 Revenue Total: 9,000.00 0.00 9,000.00 9,000.00 15,000.00 0.00 Expense
0000 - MISSING DESCRIPTION 9,000.00 8,463.83 9,000.00 0.00 15,000.00 0.00 Expense Total: 9,000.00 8,463.83 9,000.00 0.00 15,000.00 0.00 Fund: 303 - EQUIPMENT REPLACEMENT FUND Surplus (Deficit): 0.00 -8,463.83 0.00 9,000.00 0.00 0.00 Fund: 304 - ACTIVE TRANSPORTATION PLAN FUND
Revenue
0000 - MISSING DESCRIPTION 135,000.00 115,376.49 0.00 0.00 0.00 0.00 Revenue Total: 135,000.00 115,376.49 0.00 0.00 0.00 0.00 Expense
0000 - MISSING DESCRIPTION 135,000.00 108,686.99 0.00 0.00 0.00 0.00 Expense Total: 135,000.00 108,686.99 0.00 0.00 0.00 0.00 Fund: 304 - ACTIVE TRANSPORTATION PLAN FUND Surplus (Deficit: 0.00 6,689.50 0.00 0.00 0.00 0.00 Fund: 400 - WATER METER GRANT
0000 - MISSING DESCRIPTION 2,224,438.00 0.00 2,419,787.00 2,419,787.00 0.00 0.00 Revenue Total: 2,224,438.00 0.00 2,419,787.00 2,419,787.00 0.00 0.00 Expense
0710 - WATER 2,224,438.00 1,239,048.15 0.00 0.00 0.00 0.00 Expense Total: 2,224,438.00 1,239,048.15 0.00 0.00 0.00 0.00 Fund: 400 - WATER METER GRANT Surplus (Deficit): 0.00 -1,239,048.15 2,419,787.00 2,419, 787.00 0.00 0.00 5137120232:38:28 PM Page 72 ct 75
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget VTD Activity Fund: 401 - TOBACCO GRANT
Revenue
0210 - POLICE 81,365.00 39,820.68 90,321.00 57,493.87 90,321.00 0.00 Revenue Total: 81,365.00 39,820.68 90,321.00 57,493.87 90,321.00 0.00 Expense
0210 - POLICE 81,365.36 75,667.76 90,321.00 87,658.39 93,067.00 0.00 Expense Total: — 81,365.36 75,667.76 90,321.00 87,658.39 93,067.00 0.00 Fund: 401 - TOBACCO GRANT Surplus (Deficit): -0.36 -35,847.08 0.00 -30,164.52 -2,746.00 0.00 Fund: 403 - AMERICAN RESCUE PLAN ACT FUND (ARPA)
Revenue
0000 - MISSING DESCRIPTION 1,158,000.00 703,550.00 703,549.00 703,550.00 703,549.00 0.00 Revenue Total: 1,158,000.00 703,550.00 703,549.00 703,550.00 703,549.00 0.00 Expense
0000 - MISSING DESCRIPTION 200,574.08 703,549.00 0.00 703,549.00 0.00 Expense Total: 1,158.00000 200,574.08 703,549.00 0.00 703,549.00 0.00 Fund: 403 - AMERICAN RESCUE PLAN ACT FUND (ARPA) Surplus (De 0.00 502,975.92 0.00 703,550.00 0.00 0.00 Fund: 501 - PIONEER PARK REHABILITATION GRANT
Revenue
0000 - MISSING DESCRIPTION 1,300,000.00 0.00 1,300,000.00 0.00 1,300,000.00 0.00 Revenue Total: 1,300,000.00 0.00 1,300,000.00 0.00 1,300,000.00 0.00 Expense
0610 - PARKS 1,300,000.00 19,947.40 1,280,522.00 25,956.01 1,280,522.00 0.00 Expense Total: 1,300,000.00 19,947.40 1,280,522.00 25,956.01 1,280,522.00 0.00 Fund: 501 - PIONEER PARK REHABILITATION GRANT Surplus (Deficit 0.00 -19,947.40 19,478.00 - 25,956.01 19,478.00 0.00 Fund: 502 - BODYWORN CAMERA GRANT
Revenue
0000 - MISSING DESCRIPTION 0.00 17,999.72 0.00 0.00 0.00 0.00 Revenue Total: 0.00 17,999.72 0.00 0.00 0.00 0.00
Fund: 502 - BODYWORN CAMERA GRANT Total: 0.00 17,999.72 0.00 0.00 0.00 0.00 Fund: 505 - CAL VIP GRANT
Revenue
0000 - MISSING DESCRIPTION 198,832.00 195,958.00 165,932.00 0.00 165,932.00 0.00 Revenue Total: 198,832.00 195,958.00 165,932.00 0.00 165,932.00 0.00 Expense
0210 - POLICE 198,832.03 220,621.35 165,932.00 76,691.79 141,363.00 0.00 Paue 7? 01 76
5/22/2023 2:18:28 PM
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Department Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity - 165,932.00 76,691.79 141,363.00
Expense Total: 198,832.03 220,621.35 0.00
Fund: 505 - CAL VIP GRANT Surplus (Deficit): -0.03 -24,663.35 0.00 -76,691.79 24,569.00 0.00 Report Surplus (Deficit): 444,836.67 1,507,108.69 2,970,414.00 2,981,924.97 752,808.86 0.00 5/22/2023 2:38:28 PM Page 14 of /0
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 Fund Summary
Defined Budgets
2021-2022 2021-2022 2022-2023 2022-2023 2023-2024 2023-2024 Fund Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity 001 - GENERAL FUND 107,741.26 226,710.02 -151,890.93 108,772.00 0.00 002 - UTILITY TAX FUND 0.22 -11,802.65 -105,773.18 -345.00 0.00 005 - COPS SLESF 0.00 0.00 0.00 0.00 0.00
008 - CDBG REUSE FUND 0.00 0.00 0.00 0.00 0.00
009 - COMMUNITY CENTER FUND -0.08 -16,518.08 -2,867.57 0.00 0.00 010 - GAS TAX 2105 FUND 0.00 -216.66 23,589.84 0.00 0.00 011 - GAS TAX 2106 FUND 19,308.00 11,716.67 17,460.88 22,228.00 0.00 012 - GAS TAX 2107 FUND 42,298.00 29,148.41 34,538.57 47,906.00 0.00 013 - GAS TAX 2107.5 FUND 2,000.00 1,484.83 -474.60 2,000.00 0.00 014 - LOCAL TRANSPORTATION FUND 12,615.00 5,952.00 0.00 12,615.00 0.00 016 - SWIM POOL FUND 0.07 -8,762.58 17,095.77 0.00 0.00 017 - CITY WIDE LIGHTING & LAND 1,330.39 25,078.73 -94,788.37 10,729.00 0.00 018 - TRAFFIC SAFETY FUND 0.00 3,395.60 -1,270.06 0.00 0.00 019 - RECREATION FUND 0.46 -20,461.70 -27,151.61 0.00 0.00 020 - CMAQ 213,000.00 457,293.62 0.00 -10,399.06 0.00 0.00 021 - REGIONAL STREET TRANSPORTATION PROGRAM 1,984.62 13,574.44 34,109.86 36,367.00 0.00 027 - PER CAPITA GRANT 0.00 127,456.61 -444.13 35,590.00 0.00 029 - GAS TAX 2103 FUND 45,273.00 42,364.55 42,824.75 60,229.00 0.00 034 - FIRE SERVICE FUND 0.00 -21,214.64 0.00 0.00 0.00 0.00 038 - GENERAL RESERVE 0.00 81,700.98 0.00 125,000.00 0.00 0.00 047 - FIREWORKS 0.00 -5,660.52 0.00 -6,366.18 -3,000.00 0.00 050 - LONG TERM DEBT 0.00 -1,271.62 0.00 0.00 0.00 0.00 059 - STORM DRAIN -32,232.16 -26,861.68 32,937.63 -17,869.00 0.00 060 - WATER FUND 20,617.22 305,407.51 -168,117.53 83,687.53 0.00 061 - SEWER FUND 24,637.57 671,935.55 220,680.96 29,896.33 0.00 062 - REFUSE -108,353,84 -143,211.13 -46,507.70 7,410.00 0.00 063 - AIRPORT FUND -17,804,35 -68,323.62 -68,121.50 191.00 0.00 074 - ASSESS - BORRELLI 2,394.50 11,488.30 56,032.97 2,025.00 0.00 075 - ASSESS - SOUTHPORT 76.40 2,660.93 2,014.13 76.00 0.00 094 - SALE OF TOWN PROPERTIES 10,000.00 -69,531.25 -6,712.50 0.00 0.00 099 - PAYROLL TRUST FUND 0.00 7,018.00 0.00 0.00 0.00 0.00 101 - GENERAL GOVERNMENT IMPACT FEES 4,000.00 1,512.04 -101.25 4,000.00 0.00 102 - POLICE IMPACT FEES 2,500.00 843.06 -86.25 2,500.00 0.00 103 - FIRE IMPACT FEES 5,000.00 1,939.36 -101.25 5,000.00 0.00 104 - PARKS IMPACT FEE 12,000.00 4,611.03 -101.25 12,000.00 0.00 105 - STORM DRAIN IMPACT FEES 5,000.00 8,884.14 -101.25 5,000.00 0.00 106 - WATER IMPACT FEES 10,000.00 -38,615.47 -101.25 10,000.00 0.00 107 - SEWER IMPACT FEES 25,000.00 582.04 -101.25 25,000.00 0.00 108 - REGIONAL TRANSPORTATION IMPACT FEES 0.00 -193.58 0.00 -101.25 0.00 0.00 200 - REGIONAL MEASURE V 0.00 -3,806.42 0.00 -135,761.24 0.00 0.00 5/2712073? 38:28 0M Page 75 or 70
Budget Worksheet For Fiscal: 2023-2024 Period Ending: 06/30/2024 201- MEASURE V 0.00 243,233.62 222,459.00 -69,891.57 200,000.00 0.00 202 - ALT MODES MEASURE V 0.00 36,957.84 0.00 251,254.08 0.00 0.00 203 - SB1 - ROAD REPAIR/LOCAL STREETS 2017 ACT 451.10 59,837.21 0.00 89,599.26 0.00 0.00 204 - SB2 - BUILDING HOMES AND JOBS ACT OF 2017 28,000.00 0.00 0.00 0.00 0.00 0.00 220 - ABANDONED VEHICLE FUND 5,500.00 13,727.03 7,500.00 2,142.34 7,500.00 0.00 221 - PAL EXPLORERS - PD PROGRAMS 0.00 16,963.68 0.00 2,175.73 0.00 0.00 225 - COPS GRANT 2017UMWX0130 0.00 -18,696.69 0.00 0.00 0.00 0.00 2,500.00 798.85 2,000.00 20,000.00 2,000.00 0.00
226 - RECYCLING FUND
301 - SWRCB GRANT WASTEWATER PROJ C-06-8179-110 -0.32 -51,168.00 0.00 -91,723.75 0.00 0.00 302 - GUSTINE SOLAR PROJECT 2020 0.00 399,453.00 0.00 0.00 0.00 0.00 303 - EQUIPMENT REPLACEMENT FUND 0.00 -8,463.83 0.00 9,000.00 0.00 0.00 304 - ACTIVE TRANSPORTATION PLAN FUND 0.00 6,689.50 0.00 0.00 0.00 0.00 400 - WATER METER GRANT 0.00 -1,239,048.15 2,419,787.00 2,419,787.00 0.00 0.00 401 - TOBACCO GRANT -0.36 -35,847.08 0.00 -30,164.52 -2,746.00 0.00 403 - AMERICAN RESCUE PLAN ACT FUND (ARPA) 0.00 502,975.92 0.00 703,550.00 0.00 0.00 501 - PIONEER PARK REHABILITATION GRANT 0.00 -19,947.40 19,478.00 -25,956.01 19,478.00 0.00 502 - BODYWORN CAMERA GRANT 0.00 17,999.72 0.00 0.00 0.00 0.00 505 - CAL VIP GRANT -0.03 - 24,663.35 0.00 -76,691.79 24,569.00 0.00 Report Surplus (Deficit): 444,836.67 1,507,108.69 2,970,414.00 2,981,924.97 752,808.86 0.00

5/22/2023 2:38:28 PM
AC AD AE 1
1 PERCENT SPLITS FY 2023/24
Bastion Total time avadable as 100% for all employees PT hours are already adjusted in the BASE SHEET. Ths nage is the how the iotal time working is sRi Gen Geri Gon Ger. Pack GAy LLC CAY LLD Rec Storm
(sen aci
6 Chy Mg: Finance GImm Annis E Des Cly Ng Chy No Cry Cle Cly Nig Clas Fem. Pario Cir hit Choo Stam 0225- 059- 059- D59- 059-
0120 10160 pATe COTO 0,140 ofar 0a10 0210 0140 0730
EMPLOYEE (Last Name)
8 FULL
2% 10% 2095
[PW Diroctor (SNAK start oatime BLANK 10% 588
10 Alonso Alvarado BLANK 2% 10% 1%
11 Barbosa BLANK 10% 10% 5% 10%
12 Bishoo BLANK 0% 5% 5%
13 Rincon I BLANK 286 10% 5% 10%
14 Castro BLANK 2% 10% 15% 4%
15 [WWTO BLANK 0% 0%
16 Rodriguez BLANK 10%| 15%
117 Palomino BLANK 10% 15%
0%2 20%3 055 0% 05) 57% 0% 113% 0% 30% 9R090 10%1 7097 0%1 3193 0% (05) 1% 18 PUBLIC WORKS DEPARTMENT TOTAL 099)
19 POLICE DEPARTMENT
20 Chavez (SWORN) BLANK 8596
21 Fuentes (SWORNI BLANK 100%
22 Gilstrap (SWORN)
23 Ganzales (SWORN) BLANK 70%
24 Joseph (SWORN) BLANK 100%
25 Martinez (SWORN) BLANK 100%
26] Truillo (SWORN) BLANK 100%
27 Lobato-Canals BLANK 100%
28 Becerra Alvarez (SWORN) Grant
29 Gallardo (CSO) BLANK 90%
30 POLICE DEPARTMENT TOTAL 0%1 10% 655% 909T 09020 0% TONI 31 CITY ADMINISTRATION/HUMA, BLANK
32 Nicholas BLANK 10% 2% 5% 2%
BLANK 28% 3% 14931
33 Correa
34 Porras BLANK 28%|
35 Vitorino BLANK 10% 30% 15%
36 CITY ADMINISTRATION, HUMA BLANK 10% 58% 0% 6% 0% 6%l 010% 2% 20% 0%1 4X 0% 0% 30% 14% 0% 15 os? 0% 0%0% 37 FINANCE DEPARTMENT BLANK
38 Morrison 5% 3% 4%
39 Avellan [BLANK 551
40 Caballero BLANK 5%%
FINANCE DEPARTMENT TOTA BLANK 1524 0%1 0% 05. 0% 0% 0% 0% 0% 0% 8% 0% 0% OSE 0% 0% 0% 41 0%
42 ECONOMIC / COMMUNITY DEV BLANK
43 Westervelt BLANK 5095
44| ECONOMIC / COMMUNITY DEV BLANK
45 PART TIME NO BENEFITS BLANK
46 Borrelli, Pat BLANK 10%
47 Account Clerk (Gultierrer, M) BLANK 10%| 10% 10%
48 Reserve (MOCK) BLANK 4% 5%.
49 Publie Works (Cardona) BLANK 10% 10%
50 Publie Works (TSilvoita) BLANK 10%| 10%1
511 PART TIME NO BENEFITS TOT BLANK
AG AN 8B

PERCENT SPLITS F)
Bosed on Total lime avadal
toward
Stam Walte Wider Water Water Walte Serra Sener Refuse Rutao Refuse Refuse Arport Ripart Apport Alport Arport Arpar CALVIP Grand Potce CHug Cles GoeBd Fole СУМа cann OvER Peas Chan Gov Ed PH суми France Cal Pole Apport Pang 059- 050- 060- 060- 060- 060- 060- 060. 061- 061- 081. U01. 06T- 001. 061- 062 062. 082 062- 0120 0140 0142 0150 0210 0460 0710 0120 0140 0142 0150 0210 2460 0520 0120 OTAC 0150 530 5050210 0210 CHECK EMPLOYEE (Last Name) 0210

FULL TIME
9 PW Director (5B9K start ostima 20%| 28% 0% 20% 100%
10) Nonso Alvarado 25% 43% 1% 100%
11 Barbona 25% 35% 5% 100%
12 Bishop 31% 365% 19% 100%
25% 41% 19% 100%
13 Rincon IE
14 Castro 27% 3993 1% 29h 100%
100% 100%
16 Rodriguez 25% 44% 3% 1% 100%
17 Palomino 25% 44% 1% 1%| 100%
18 PUBLIC WORKS DEPARTMENT 10% 0% 0% 25% 20% 0% 179% 0% 10% 0% 35% 0% 0ssl375% 0% 1233 0% 27% 0% 90015 19) POLICE DEPARTMENT
20 Chavez (SWORN) 2% 75| 5%| 1% 100%
21 Fuentes (SWORN) 100%
22 Gilsirap (SWORN) 100% 100%
23 Gonzalas (SWORN) 4% 135 12% 1% 100%
100%
24 Josoph (SWORN)
25 Martinez (SWORN) 100%
126 Trujillo (SWORNI 100%
27 Lobato-Canals 100%
Becerta Alvatez (SWORN) 100% 100%
29) Gallardo (CSO) 9%| 1% 100%
180 POLICE DEPARTMENT TOTAL 0%AD 0% 19% 0x 30x 0% 0% 250 100% 100% 1000% 31 CITY ADMINISTRATION/HUMA* 0%
26% 31% 100%
anacholas
8% 30% 10% 100%
33 Correa
34 Porras 20% 32%% 10% 100%
35 Vitoring 25% 2098 100%
136 CITY ADMINISTRATION, HUMA 25% 0% 28% 0% 0% 26% 31% 0% 62% 0% 0% 0% 20% 1% 0% 20% 0% 0% 0%1 10% 0% 0% 0% 0% 0% 400% 37 FINANCE DEPARTMENT
38 Motrison 35% 51% 1% 0% 100%
39 Avellan 40%
40 Caballero 40%
41 FINANCE DEPARTMENT TOTA 50% 0% MESS 09G 0% 0% 133% 0% ON 0% 0% 0% 0% 0% .0% 0% 0% 0% 0% 0% 142 ECONOMIC / COMMUNITY DEV
43 Wostervelt 15%| 5% 30%
4a ECONOMIC / COMMUNITY DEV LE
45 PART TIME NO BENEFITS
46 Borrolli, Pal 30% 45% 15%
E7 Account Clerk (Guitierraz. M) 30% 30% 10%
48l Roserve (MOCK) 31%1 30% 20%
49 Public Works (Cardona) 30%
50 Public Works (TSilvoira) 30%
51 PART TIME NO BENEFITS TOT