Cities Index.
Internal Service Funds - Proposed Budget Workbooks

Cotati City Council
April 18, 2023

Document
Internal Service Funds - Proposed Budget Workbooks
Meeting
April 18, 2023
Body
Cotati City Council
Original file
405 KB
Text extracted from the city's file for reading and search. Open the original on cotaticity.primegov.com. That file is the official record.

Parent Budget % %
VEHICLE USE FEE - GENERAL FUND 57,554.81 247,850.00 298,745.00 -220.53 -22,850.00 -9.22 VEHICLE USE FEE - OTHER FUND 0.00 5,000.00 7,619.00 -252.38 0.00 0.00 VEHICLE USE FEE - SEWER FUND 0.00 91,075.00 46,115.00 -49.37 -56,575.00 -62.12 VEHICLE USE FEE - WATER FUND 0.00 57,075.00 48,521.00 -14.99 15,425.00 27.03 REV. OTHER 0.00 0.00 0.00 0.00 0.00 0.00
57,554.81 401,000.00 401,000.00 0.00 -64,000.00 0.00
INVESTMENT EARNINGS 566.99 0.00 0.00 0.00 0.00 0.00
566.99 0.00 0.00 0.00 0.00 0.00
58,121.80 401,000.00 401,000.00 0.00 -64,000.00 0.00
R&M-VEHICLE 2,356.40 35,000.00 35,000.00 0.00 0.00 0.00 2,356.40 35,000.00 35,000.00 0.00 0.00 0.00
OTHER EXPENSES 0.00 0.00 0.00 0.00 0.00 0.00

0.00 0.00 0.00 0.00 0.00 0.00
INVESTMENT EXPENSE - FMV 2,144.37 0.00 0.00 0.00 0.00 0.00 2,144.37 0.00 0.00 0.00 0.00 0.00
FIXED ASSET-EQUIP. 0.00 361,000.00 361,000.00 0.00 -59,000.00 -16.34 DEPRECIATION 124,983.33 0.00 0.00 0.00 0.00 0.00
CONTRA-ASSET EXPENSE 4,422.04 0.00 0.00 0.00 0.00 0.00
129,405.37 361,000.00 361,000.00 0.00 -59,000.00 0.00
133,906.14 396,000.00 396,000.00 0.00 -59,000.00 0.00
-75,784.34 5,000.00 5,000.00 0.00 -5,000.00 0.00
Ending Fund Balance: 580,909 319,198 585,909 0.84 266,711 0.84 Total Expense: 114,941.49 112,935.66 0.00 337,000.00
Total Fund: 501 - VEHICLE MAINTENANCE AND REPLACEMENT: 93,772.10 134,926.13 0.00 0.00

0.00 Total Category: 808 - DEBT SERVICE: 0.00 0.00 0.00 0.00

0.00 Category: 808 - DEBT SERVICE
Total Category: 809 - CAPITAL OUTLAY: 105,849.33 110,160.43 0.00 302,000.00 501-00-80990-000000 105,849.33 110,160.43 0.00 0.00
501-00-80999-999999 -160,017.85 0.00 0.00 0.00
302,000.00
Category: 809 - CAPITAL OUTLAY
501-00-80900-000000 160,017.85 0.00 0.00
Total Category: 806 - OTHER EXPENSES: 0.00 0.00 0.00
501-00-80822-999999 0.00 0.00 0.00

0.00 35,000.00
Total Category: 805 - REPAIR & MAINTENANCE: 9,092.16 2,775.23 0.00 35,000.00 Expense
Total Category: 650 - INVESTMENT EARNINGS: 1,374.59 1,687.58 0.00 0.00 Category: 805 - REPAIR & MAINTENANCE
501-00-80572-000000 9,092.16 2,775.23 0.00
Category: 806 - OTHER EXPENSES
501-00-80660-000000 0.00 0.00 0.00
25,000.00 -44,960.00 34,500.00
501-00-60910-WTRFND 19,073.00 57,500.00 -8,554.00 72,500.00 Total Revenue: 208,713.59 247,861.79 0.00 337,000.00
Category: 650 - INVESTMENT EARNINGS
501-00-65010-000000 1,374.59 1,687.58 0.00 0.00
501-00-60910-OTHFND 5,000.00 5,000.00 2,619.00 5,000.00 Fund: 501 - VEHICLE MAINTENANCE AND REPLACEMENT
Revenue
Category: 609 - OTHER REVENUE
521,767 656,693 266,711 585,909
501-00-60920-000000 0.00 1,898.98 0.00 0.00
Total Category: 609 - OTHER REVENUE: 207,339.00 246,174.21 0.00 337,000.00 501-00-60910-SWRFND 19,073.00
Budget Comparison Report
Internal Service Funds Account Summary
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
501-00-60910-GENFND 164,193.00 156,775.23 50,895.00 225,000.00 Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
Parent Budget % %
Comparison 1
Budget
Comparison 1
to Parent
Budget
Comparison 2
Budget
Comparison 2
to Parent
Budget
Increase /
(Decrease)
2023-2024
Proposed
Increase /
(Decrease)
Account Number
2019-2020
Total Activity
2020-2021
Total Activity
2021-2022
Total Activity
2022-2023
Adopted
2022-2023
EST Actuals
PAYOUT FEES - GENERAL FUND 121,024.56 80,000.00 150,000.00 87.50 0.00 0.00 PAYOUT FEES - OTHER FUND 7,707.44 4,000.00 8,000.00 100.00 0.00 0.00 PAYOUT FEES - SEWER FUND 31,647.29 17,280.00 50,000.00 189.35 0.00 0.00 PAYOUT FEES - WATER FUND 32,214.98 18,200.00 50,000.00 174.73 0.00 0.00 192,594.27 119,480.00 258,000.00 174.73 0.00 0.00
INVESTMENT EARNINGS 1,196.18 0.00 800.00 0.00 0.00 0.00 1,196.18 0.00 800.00 0.00 0.00 0.00
193,790.45 119,480.00 258,800.00 0.00 0.00 0.00
193,790.45 119,480.00 258,800.00 0.00 0.00 0.00
PAYOUT - GENERAL FUND 98,310.54 80,000.00 80,000.00 0.00 27,770.00 34.71 PAYOUT - OTHER FUND 7,940.93 4,000.00 4,000.00 0.00 -1,200.00 -30.00 PAYOUT - SEWER FUND 31,647.29 17,280.00 17,280.00 0.00 8,870.00 51.33 PAYOUT - WATER FUND 32,214.98 18,200.00 18,200.00 0.00 8,790.00 48.30 170,113.74 119,480.00 119,480.00 0.00 44,230.00 48.30
INVESTMENT EXPENSE - FMV 4,982.30 0.00 0.00 0.00 0.00 0.00 4,982.30 0.00 0.00 0.00 0.00 0.00
175,096.04 119,480.00 119,480.00 0.00 44,230.00 0.00
175,096.04 119,480.00 119,480.00 0.00 44,230.00 0.00
18,694.41 0.00 139,320.00 0.00 -44,230.00 0.00
Ending Fund Balance: 85,959 98,850 117,544 99,708 256,864 157,156 1.00 212,634 112,926 1.00 Total Fund: 502 - COMPENSATED ABSENCES: -33,541.92 12,890.58 139,320.00 -44,230.00 Total Department: 00 - UNDESIGNATED: 103,447.16 168,422.56 0.00 163,710.00 Total Expense: 103,447.16 168,422.56 0.00 163,710.00
Total Category: 707 - PAYOUTS: 103,447.16 168,422.56 0.00 163,710.00 Category: 808 - DEBT SERVICE
502-00-70700-SWRFND 6,276.57 37,849.17 0.00 26,150.00
502-00-70700-WTRFND 6,276.58 38,322.71 0.00 26,990.00
502-00-80822-999999 0.00 0.00 0.00 0.00
Total Category: 808 - DEBT SERVICE: 0.00 0.00 0.00 0.00 Total Department: 00 - UNDESIGNATED: 69,905.24 181,313.14 139,320.00 119,480.00 Total Revenue: 69,905.24 181,313.14 139,320.00 119,480.00 107,770.00
502-00-70700-OTHFND 6,303.13 7,321.80 0.00 2,800.00
Expense
Department: 00 - UNDESIGNATED
Category: 707 - PAYOUTS
502-00-70700-GENFND 84,590.88 84,928.88 0.00
Total Category: 609 - OTHER REVENUE: 62,840.25 177,562.52 138,520.00 119,480.00 Category: 650 - INVESTMENT EARNINGS
502-00-60910-SWRFND 6,276.57 37,849.17 32,720.00 17,280.00 502-00-60910-WTRFND 6,276.58 38,322.71 31,800.00 18,200.00 502-00-65010-000000 7,064.99 3,750.62 800.00 0.00
Total Category: 650 - INVESTMENT EARNINGS: 7,064.99 3,750.62 800.00 0.00 Fund: 502 - COMPENSATED ABSENCES
Revenue
Department: 00 - UNDESIGNATED
Category: 609 - OTHER REVENUE
502-00-60910-GENFND 46,684.59 95,026.02 70,000.00 80,000.00 502-00-60910-OTHFND 3,602.51 6,364.62 4,000.00 4,000.00

← All documents from this meeting