Fortuna City Council
January 17, 2023

1/10/2023 4:16:07 PM Page 1 of 24
Budget Report
CITY OF FORTUNA Account Summary
For Fiscal: 2022-2023 Period Ending: 12/31/2022
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
Division: 1000 - City Council
Fund: 100 - General Fund
100-5165-1000 Wages Part Time 18,000.00 18,000.00 3,318.00 9,468.00 8,532.00 47.40 % 100-5200-1000 Workers' Compensation 1,507.00 1,507.00 90.93 174.68 1,332.32 88.41 % 100-5210-1000 P/T Retirement - VALIC 0.00 0.00 132.72 378.72 -378.72 0.00 % 100-5230-1000 Medicare 0.00 0.00 48.11 137.26 -137.26 0.00 % 100-5240-1000 Medical Insurance 0.00 0.00 0.00 32.50 -32.50 0.00 % 100-5500-1000 Department Supplies 500.00 500.00 200.18 545.35 -45.35 -9.07 % 100-5720-1000 Equipment Repair 200.00 200.00 0.00 0.00 200.00 100.00 % 100-7000-1000 Travel, Conferences & Training 8,000.00 8,000.00 0.00 1,867.64 6,132.36 76.65 % 100-7612-1000 Contingency 2,000.00 2,000.00 0.00 938.16 1,061.84 53.09 % 100-7616-1000 Televised Meetings 4,000.00 4,000.00 0.00 1,922.45 2,077.55 51.94 % Fund: 100 - General Fund Total: 34,207.00 34,207.00 3,789.94 15,464.76 18,742.24 54.79 % Division: 1000 - City Council Total: 34,207.00 34,207.00 3,789.94 15,464.76 18,742.24 54.79 % Division: 1100 - City Manager
Fund: 100 - General Fund
100-5100-1100 Wages 74,724.00 74,724.00 5,811.72 34,410.49 40,313.51 53.95 % 100-5180-1100 Vacation/Comp Time/Sick Leave Buy… 2,500.00 2,500.00 0.00 0.00 2,500.00 100.00 % 100-5200-1100 Workers' Compensation 27,652.00 27,652.00 64.82 410.67 27,241.33 98.51 % 100-5230-1100 Medicare 0.00 0.00 80.98 480.78 -480.78 0.00 % 100-5240-1100 Medical Insurance 0.00 0.00 1,064.97 5,922.55 -5,922.55 0.00 % 100-5250-1100 Retirement - CalPERS 0.00 0.00 506.90 3,024.77 -3,024.77 0.00 % 100-5255-1100 PERS Unfunded Liability Payment 0.00 0.00 0.00 5,436.04 -5,436.04 0.00 % 100-5265-1100 Miscellaneous Benefits 0.00 0.00 20.00 120.00 -120.00 0.00 % 100-5500-1100 Department Supplies 2,000.00 2,000.00 3.42 3,242.16 -1,242.16 -62.11 % 100-5505-1100 Vehicle Fuel & Oil 300.00 300.00 0.00 128.56 171.44 57.15 % 100-5705-1100 Equipment Maintenance 500.00 500.00 0.00 143.10 356.90 71.38 % 100-6035-1100 Personnel Services 500.00 500.00 0.00 0.00 500.00 100.00 % 100-6205-1100 Cell Phones 500.00 500.00 56.85 267.37 232.63 46.53 % 100-7000-1100 Travel, Conferences & Training 6,000.00 6,000.00 0.00 2,769.32 3,230.68 53.84 % 100-7015-1100 Dues & Subscriptions 2,000.00 2,000.00 0.00 286.93 1,713.07 85.65 % 100-7612-1100 Contingency 5,000.00 5,000.00 48.83 508.81 4,491.19 89.82 % Fund: 100 - General Fund Total: 121,676.00 121,676.00 7,658.49 57,151.55 64,524.45 53.03 % Division: 1100 - City Manager Total: 121,676.00 121,676.00 7,658.49 57,151.55 64,524.45 53.03 % Division: 1150 - City Clerk
Fund: 100 - General Fund
100-5100-1150 Wages 27,655.00 27,655.00 2,167.48 12,796.95 14,858.05 53.73 % 100-5165-1150 Wages Part Time 8,578.00 8,578.00 356.04 2,518.15 6,059.85 70.64 % 100-5180-1150 Vacation/Comp Time/Sick Leave Buy… 500.00 500.00 0.00 0.00 500.00 100.00 % 100-5200-1150 Workers' Compensation 15,670.00 15,670.00 28.13 183.35 15,486.65 98.83 % 100-5210-1150 P/T Retirement - VALIC 0.00 0.00 14.25 100.76 -100.76 0.00 % 100-5230-1150 Medicare 0.00 0.00 34.53 210.75 -210.75 0.00 % 100-5240-1150 Medical Insurance 0.00 0.00 700.09 3,890.80 -3,890.80 0.00 % 100-5250-1150 Retirement - CalPERS 0.00 0.00 240.84 1,437.38 -1,437.38 0.00 % 100-5255-1150 PERS Unfunded Liability Payment 0.00 0.00 0.00 2,536.82 -2,536.82 0.00 % 100-5265-1150 Miscellaneous Benefits 0.00 0.00 20.00 120.00 -120.00 0.00 % 100-5500-1150 Department Supplies 1,000.00 1,000.00 0.00 175.54 824.46 82.45 % 100-6035-1150 Personnel Services 500.00 500.00 0.00 0.00 500.00 100.00 % 100-7000-1150 Travel, Conferences & Training 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 2 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-7015-1150 Dues & Subscriptions 1,000.00 1,000.00 0.00 204.92 795.08 79.51 % Fund: 100 - General Fund Total: 57,903.00 57,903.00 3,561.36 24,175.42 33,727.58 58.25 % Division: 1150 - City Clerk Total: 57,903.00 57,903.00 3,561.36 24,175.42 33,727.58 58.25 % Division: 1200 - Finance
Fund: 100 - General Fund
100-5100-1200 Wages 111,961.00 111,961.00 7,775.45 46,607.08 65,353.92 58.37 % 100-5170-1200 Overtime Pay 500.00 500.00 0.00 0.00 500.00 100.00 % 100-5180-1200 Vacation/Comp Time/Sick Leave Buy… 3,000.00 3,000.00 697.23 1,722.13 1,277.87 42.60 % 100-5200-1200 Workers' Compensation 51,815.00 51,815.00 94.47 577.49 51,237.51 98.89 % 100-5230-1200 Medicare 0.00 0.00 117.41 670.11 -670.11 0.00 % 100-5240-1200 Medical Insurance 0.00 0.00 2,226.74 12,500.35 -12,500.35 0.00 % 100-5250-1200 Retirement - CalPERS 0.00 0.00 777.58 4,679.30 -4,679.30 0.00 % 100-5255-1200 PERS Unfunded Liability Payment 0.00 0.00 0.00 9,712.36 -9,712.36 0.00 % 100-5265-1200 Miscellaneous Benefits 0.00 0.00 40.00 240.00 -240.00 0.00 % 100-5500-1200 Department Supplies 7,000.00 7,000.00 74.16 2,081.39 4,918.61 70.27 % 100-5705-1200 Equipment Maintenance 600.00 600.00 0.00 286.18 313.82 52.30 % 100-6025-1200 Professional Services 6,000.00 6,000.00 50.00 2,308.85 3,691.15 61.52 % 100-6035-1200 Personnel Services 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 100-7000-1200 Travel, Conferences & Training 8,000.00 8,000.00 0.00 0.00 8,000.00 100.00 % 100-7015-1200 Dues & Subscriptions 500.00 500.00 0.00 190.00 310.00 62.00 % Fund: 100 - General Fund Total: 190,376.00 190,376.00 11,853.04 81,575.24 108,800.76 57.15 % Division: 1200 - Finance Total: 190,376.00 190,376.00 11,853.04 81,575.24 108,800.76 57.15 % Division: 1300 - Legal Services
Fund: 100 - General Fund
100-6020-1300 Legal Services 50,000.00 50,000.00 0.00 12,001.00 37,999.00 76.00 % Fund: 100 - General Fund Total: 50,000.00 50,000.00 0.00 12,001.00 37,999.00 76.00 % Division: 1300 - Legal Services Total: 50,000.00 50,000.00 0.00 12,001.00 37,999.00 76.00 % Division: 1400 - Misc. Non Departmental
Fund: 100 - General Fund
100-6000-1400 Audit Fees 21,600.00 21,600.00 0.00 8,783.10 12,816.90 59.34 % 100-6020-1400 Legal Services 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 100-6025-1400 Professional Services 32,000.00 32,000.00 1,338.07 20,475.83 11,524.17 36.01 % 100-6036-1400 Franchise Fees 4,500.00 4,500.00 0.00 1,057.50 3,442.50 76.50 % 100-6225-1400 Codification Misc 2,000.00 2,000.00 0.00 1,071.75 928.25 46.41 % 100-6300-1400 Advertising 0.00 0.00 119.00 119.00 -119.00 0.00 % 100-6305-1400 Publication Expense 500.00 500.00 0.00 0.00 500.00 100.00 % 100-6315-1400 Employee Recognition 2,500.00 2,500.00 350.00 1,252.97 1,247.03 49.88 % 100-6700-1400 Administration Fees 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % 100-6710-1400 County Election 4,000.00 4,000.00 0.00 401.52 3,598.48 89.96 % 100-6720-1400 County Property Tax 150.00 150.00 0.00 0.00 150.00 100.00 % 100-7000-1400 Travel, Conferences & Training 2,500.00 2,500.00 0.00 0.00 2,500.00 100.00 % 100-7015-1400 Dues & Subscriptions 7,500.00 7,500.00 0.00 150.00 7,350.00 98.00 % Fund: 100 - General Fund Total: 107,250.00 107,250.00 1,807.07 33,311.67 73,938.33 68.94 % Division: 1400 - Misc. Non Departmental Total: 107,250.00 107,250.00 1,807.07 33,311.67 73,938.33 68.94 % Division: 1500 - General Building
Fund: 100 - General Fund
100-5100-1500 Wages 7,513.00 7,513.00 665.36 3,970.35 3,542.65 47.15 % 100-5200-1500 Workers' Compensation 4,534.00 4,534.00 36.87 236.54 4,297.46 94.78 % 100-5230-1500 Medicare 0.00 0.00 9.56 57.09 -57.09 0.00 % 100-5240-1500 Medical Insurance 0.00 0.00 0.87 6.13 -6.13 0.00 % 100-5250-1500 Retirement - CalPERS 0.00 0.00 41.48 250.98 -250.98 0.00 % 100-5255-1500 PERS Unfunded Liability Payment 0.00 0.00 0.00 1,449.61 -1,449.61 0.00 % 100-5500-1500 Department Supplies 3,500.00 3,500.00 94.20 1,879.27 1,620.73 46.31 % 100-5505-1500 Vehicle Fuel & Oil 500.00 500.00 84.34 458.28 41.72 8.34 % 100-5705-1500 Equipment Maintenance 14,000.00 14,000.00 957.14 5,979.31 8,020.69 57.29 % 100-5710-1500 Software Maintenance 8,500.00 8,500.00 11,701.40 19,559.96 -11,059.96 -130.12 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 3 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-5715-1500 Vehicle Repairs 1,000.00 1,000.00 0.00 179.50 820.50 82.05 % 100-5720-1500 Equipment Repair 0.00 0.00 0.00 9.39 -9.39 0.00 % 100-5740-1500 Building Repair and Maintenance 1,000.00 1,000.00 42.50 658.43 341.57 34.16 % 100-5775-1500 Network Support 17,710.00 17,710.00 1,361.93 9,136.16 8,573.84 48.41 % 100-5780-1500 Web Maintenance 1,000.00 1,000.00 0.00 257.14 742.86 74.29 % 100-6035-1500 Personnel Services 500.00 500.00 0.00 0.00 500.00 100.00 % 100-6060-1500 Bank Fees 12,000.00 12,000.00 0.00 4,252.94 7,747.06 64.56 % 100-6061-1500 Credit Card Transaction Charge 4,000.00 4,000.00 0.00 2,070.93 1,929.07 48.23 % 100-6200-1500 Telephone 5,000.00 5,000.00 0.00 723.88 4,276.12 85.52 % 100-6205-1500 Cell Phones 1,000.00 1,000.00 78.72 485.12 514.88 51.49 % 100-6210-1500 Internet Service 1,000.00 1,000.00 58.37 350.22 649.78 64.98 % 100-6505-1500 Utility - General & Electric 6,000.00 6,000.00 0.00 1,780.53 4,219.47 70.32 % Fund: 100 - General Fund Total: 88,757.00 88,757.00 15,132.74 53,751.76 35,005.24 39.44 % Division: 1500 - General Building Total: 88,757.00 88,757.00 15,132.74 53,751.76 35,005.24 39.44 % Division: 1600 - Risk Management / HR
Fund: 100 - General Fund
100-5100-1600 Wages 45,438.00 45,438.00 3,511.80 20,885.11 24,552.89 54.04 % 100-5165-1600 Wages Part Time 8,578.00 8,578.00 356.04 2,518.15 6,059.85 70.64 % 100-5180-1600 Vacation/Comp Time/Sick Leave Buy… 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 100-5200-1600 Workers' Compensation 18,245.00 18,245.00 43.10 279.87 17,965.13 98.47 % 100-5210-1600 P/T Retirement - VALIC 0.00 0.00 14.25 100.76 -100.76 0.00 % 100-5230-1600 Medicare 0.00 0.00 53.91 327.44 -327.44 0.00 % 100-5240-1600 Medical Insurance 0.00 0.00 704.47 3,915.75 -3,915.75 0.00 % 100-5250-1600 Retirement - CalPERS 0.00 0.00 325.69 1,950.81 -1,950.81 0.00 % 100-5255-1600 PERS Unfunded Liability Payment 0.00 0.00 0.00 3,261.62 -3,261.62 0.00 % 100-5300-1600 Unemployment Insurance 20,000.00 20,000.00 0.00 0.00 20,000.00 100.00 % 100-5500-1600 Department Supplies 500.00 500.00 0.00 0.00 500.00 100.00 % 100-6020-1600 Legal Services 10,000.00 10,000.00 0.00 7,243.13 2,756.87 27.57 % 100-6035-1600 Personnel Services 500.00 500.00 0.00 0.00 500.00 100.00 % 100-6350-1600 Liability Insurance 329,421.00 329,421.00 0.00 65,000.00 264,421.00 80.27 % 100-6360-1600 Claims/Settlement 0.00 0.00 0.00 11,451.00 -11,451.00 0.00 % 100-7000-1600 Travel, Conferences & Training 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % Fund: 100 - General Fund Total: 437,682.00 437,682.00 5,009.26 116,933.64 320,748.36 73.28 % Division: 1600 - Risk Management / HR Total: 437,682.00 437,682.00 5,009.26 116,933.64 320,748.36 73.28 % Division: 1800 - Tourist & Community Promotion
Fund: 100 - General Fund
100-6800-1800 Chamber Of Commerce 23,000.00 23,000.00 0.00 18,220.00 4,780.00 20.78 % 100-6801-1800 Chamber TOT 70,000.00 70,000.00 0.00 47,855.25 22,144.75 31.64 % 100-6804-1800 FBID Rent 2,400.00 2,400.00 0.00 0.00 2,400.00 100.00 % 100-7612-1800 Contingency - Community Events 3,000.00 3,000.00 0.00 5,374.44 -2,374.44 -79.15 % 100-7625-1800 FBID 63,000.00 63,000.00 0.00 277.00 62,723.00 99.56 % Fund: 100 - General Fund Total: 161,400.00 161,400.00 0.00 71,726.69 89,673.31 55.56 % Fund: 250 - FBID Fund
250-5165-1800 Wages Part Time 0.00 0.00 0.00 245.66 -245.66 0.00 % 250-5200-1800 Workers' Compensation 0.00 0.00 0.00 30.83 -30.83 0.00 % 250-5210-1800 P/T Retirement - VALIC 0.00 0.00 0.00 9.83 -9.83 0.00 % 250-5230-1800 Medicare 0.00 0.00 0.00 3.56 -3.56 0.00 % 250-6025-1800 Professional Services 0.00 0.00 6,866.42 7,616.42 -7,616.42 0.00 % 250-6035-1800 Personnel Services 0.00 0.00 0.00 853.25 -853.25 0.00 % Fund: 250 - FBID Fund Total: 0.00 0.00 6,866.42 8,759.55 -8,759.55 0.00 % Division: 1800 - Tourist & Community Promotion Total: 161,400.00 161,400.00 6,866.42 80,486.24 80,913.76 50.13 % Division: 2000 - Police
Fund: 100 - General Fund
100-5100-2000 Wages 1,304,140.00 1,304,140.00 96,894.07 593,306.57 710,833.43 54.51 % 100-5165-2000 Wages Part Time 31,351.00 31,351.00 1,923.42 12,532.75 18,818.25 60.02 % 100-5170-2000 Overtime Pay 160,000.00 160,000.00 15,194.69 80,801.99 79,198.01 49.50 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 4 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-5175-2000 Holiday Pay 35,000.00 35,000.00 29,962.47 32,129.94 2,870.06 8.20 % 100-5180-2000 Vacation/Comp Time/Sick Leave Buy… 80,000.00 80,000.00 10,009.29 53,581.43 26,418.57 33.02 % 100-5200-2000 Workers' Compensation 1,118,857.00 1,118,857.00 21,997.84 118,440.47 1,000,416.53 89.41 % 100-5210-2000 P/T Retirement - VALIC 0.00 0.00 76.93 511.90 -511.90 0.00 % 100-5230-2000 Medicare 0.00 0.00 2,160.97 10,816.34 -10,816.34 0.00 % 100-5240-2000 Medical Insurance 0.00 0.00 27,526.17 146,214.90 -146,214.90 0.00 % 100-5250-2000 Retirement - CalPERS 0.00 0.00 16,072.52 98,397.96 -98,397.96 0.00 % 100-5255-2000 PERS Unfunded Liability Payment 0.00 0.00 0.00 289,694.73 -289,694.73 0.00 % 100-5260-2000 Uniform Allowance 15,000.00 15,000.00 0.00 0.00 15,000.00 100.00 % 100-5265-2000 Miscellaneous Benefits 0.00 0.00 180.00 1,080.00 -1,080.00 0.00 % 100-5500-2000 Department Supplies 38,000.00 38,000.00 1,532.82 19,891.82 18,108.18 47.65 % 100-5505-2000 Vehicle Fuel & Oil 75,000.00 75,000.00 5,934.54 44,189.81 30,810.19 41.08 % 100-5515-2000 Ammunition & Range Supplies 15,000.00 15,000.00 0.00 821.81 14,178.19 94.52 % 100-5700-2000 Radio Equipment 5,000.00 5,000.00 269.82 775.27 4,224.73 84.49 % 100-5705-2000 Equipment Maintenance 8,000.00 8,000.00 721.19 5,028.00 2,972.00 37.15 % 100-5710-2000 Software Maintenance 44,800.00 44,800.00 0.00 40,950.85 3,849.15 8.59 % 100-5715-2000 Vehicle Repairs 25,000.00 25,000.00 2,388.25 10,908.28 14,091.72 56.37 % 100-5720-2000 Equipment Repair 7,500.00 7,500.00 0.00 1,658.96 5,841.04 77.88 % 100-5740-2000 Building Repair and Maintenance 2,000.00 2,000.00 157.22 2,385.71 -385.71 -19.29 % 100-5775-2000 Network Support 27,810.00 27,810.00 1,984.07 12,869.00 14,941.00 53.73 % 100-5780-2000 Web Maintenance 1,000.00 1,000.00 0.00 257.14 742.86 74.29 % 100-6020-2000 Legal Services 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 100-6025-2000 Professional Services 10,000.00 10,000.00 287.56 8,009.96 1,990.04 19.90 % 100-6035-2000 Personnel Services 15,000.00 15,000.00 0.00 4,881.31 10,118.69 67.46 % 100-6061-2000 Credit Card Transaction Charge 2,000.00 2,000.00 0.00 1,120.37 879.63 43.98 % 100-6200-2000 Telephone 25,000.00 25,000.00 0.00 8,612.21 16,387.79 65.55 % 100-6205-2000 Cell Phones 8,000.00 8,000.00 467.81 4,440.36 3,559.64 44.50 % 100-6210-2000 Internet Service 8,000.00 8,000.00 666.52 3,892.46 4,107.54 51.34 % 100-6220-2000 CLETS Service 10,000.00 10,000.00 5,000.00 6,537.90 3,462.10 34.62 % 100-6500-2000 Utility - Water 1,200.00 1,200.00 144.57 560.30 639.70 53.31 % 100-6505-2000 Utility - General & Electric 20,000.00 20,000.00 0.00 8,374.74 11,625.26 58.13 % 100-6600-2000 State Fees 3,000.00 3,000.00 0.00 665.00 2,335.00 77.83 % 100-6625-2000 Livescan Fees 15,000.00 15,000.00 0.00 3,824.00 11,176.00 74.51 % 100-6720-2000 County Property Tax 200.00 200.00 0.00 0.00 200.00 100.00 % 100-7000-2000 Travel, Conferences & Training 50,000.00 50,000.00 1,287.00 27,151.59 22,848.41 45.70 % 100-7015-2000 Dues & Subscriptions 8,000.00 8,000.00 65.61 1,911.25 6,088.75 76.11 % 100-7405-2000 Special Expense 10,000.00 10,000.00 0.00 3,165.00 6,835.00 68.35 % 100-7415-2000 SCOP Volunteers 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 100-7612-2000 Contingency 6,000.00 6,000.00 100.00 2,217.57 3,782.43 63.04 % Fund: 100 - General Fund Total: 3,187,858.00 3,187,858.00 243,005.35 1,662,609.65 1,525,248.35 47.85 % Fund: 101 - Transaction and Use Tax Fund
101-5100-2000 Wages 256,384.00 256,384.00 15,701.64 95,135.02 161,248.98 62.89 % 101-5165-2000 Wages Part Time 25,813.00 25,813.00 1,927.20 7,675.80 18,137.20 70.26 % 101-5170-2000 Overtime Pay 40,000.00 40,000.00 288.34 6,409.09 33,590.91 83.98 % 101-5175-2000 Holiday Pay 0.00 0.00 9,360.97 9,360.97 -9,360.97 0.00 % 101-5180-2000 Vacation/Comp Time/Sick Leave Buy… 4,000.00 4,000.00 0.00 10,229.35 -6,229.35 -155.73 % 101-5200-2000 Workers' Compensation 237,945.00 237,945.00 3,519.91 17,960.51 219,984.49 92.45 % 101-5210-2000 P/T Retirement - VALIC 0.00 0.00 77.09 307.03 -307.03 0.00 % 101-5230-2000 Medicare 0.00 0.00 378.77 1,774.65 -1,774.65 0.00 % 101-5240-2000 Medical Insurance 0.00 0.00 6,880.38 38,186.10 -38,186.10 0.00 % 101-5250-2000 Retirement - CalPERS 0.00 0.00 3,175.72 19,213.11 -19,213.11 0.00 % 101-5255-2000 PERS Unfunded Liability Payment 0.00 0.00 0.00 51,746.84 -51,746.84 0.00 % 101-5500-2000 Department Supplies 500.00 500.00 0.00 0.00 500.00 100.00 % 101-5505-2000 Vehicle Fuel & Oil 2,000.00 2,000.00 108.23 970.71 1,029.29 51.46 % 101-6025-2000 Professional Services 10,000.00 10,000.00 0.00 8,750.00 1,250.00 12.50 % 101-6205-2000 Cell Phones 500.00 500.00 31.59 189.70 310.30 62.06 % 101-7000-2000 Travel, Conferences & Training 4,000.00 4,000.00 0.00 62.00 3,938.00 98.45 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 5 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
101-8000-2000 Capital Outlay 0.00 0.00 0.00 1,813.41 -1,813.41 0.00 % Fund: 101 - Transaction and Use Tax Fund Total: 581,142.00 581,142.00 41,449.84 269,784.29 311,357.71 53.58 % Fund: 105 - Donations Fund
105-5500-2000 Department Supplies 0.00 0.00 0.00 114.99 -114.99 0.00 % Fund: 105 - Donations Fund Total: 0.00 0.00 0.00 114.99 -114.99 0.00 % Fund: 180 - Asset Seizure Fund
180-5500-2000 Dept Supplies 20,000.00 20,000.00 0.00 16,719.31 3,280.69 16.40 % 180-8000-2000 Capital Outlay 0.00 0.00 0.00 3,027.70 -3,027.70 0.00 % Fund: 180 - Asset Seizure Fund Total: 20,000.00 20,000.00 0.00 19,747.01 252.99 1.26 % Fund: 183 - Every 15 Minute
183-5500-2000 Department Supplies 2,800.00 2,800.00 0.00 0.00 2,800.00 100.00 % Fund: 183 - Every 15 Minute Total: 2,800.00 2,800.00 0.00 0.00 2,800.00 100.00 % Fund: 186 - AB109 Realignment Pool Fund
186-5170-2000 Overtime Pay 30,000.00 30,000.00 0.00 1,090.03 28,909.97 96.37 % 186-5200-2000 Workers' Compensation 0.00 0.00 0.00 114.86 -114.86 0.00 % 186-5230-2000 Medicare 0.00 0.00 0.00 15.57 -15.57 0.00 % 186-5240-2000 Medical Insurance 0.00 0.00 0.00 97.16 -97.16 0.00 % 186-5250-2000 Retirement - CalPERS 0.00 0.00 0.00 163.87 -163.87 0.00 % Fund: 186 - AB109 Realignment Pool Fund Total: 30,000.00 30,000.00 0.00 1,481.49 28,518.51 95.06 % Fund: 188 - ABC GRANT
188-5170-2000 Overtime Pay 0.00 0.00 0.00 1,213.62 -1,213.62 0.00 % 188-5200-2000 Workers' Compensation 0.00 0.00 0.00 127.88 -127.88 0.00 % 188-5230-2000 Medicare 0.00 0.00 0.00 17.00 -17.00 0.00 % 188-5240-2000 Medical Insurance 0.00 0.00 0.00 254.63 -254.63 0.00 % 188-5250-2000 Retirement - CalPERS 0.00 0.00 0.00 191.08 -191.08 0.00 % Fund: 188 - ABC GRANT Total: 0.00 0.00 0.00 1,804.21 -1,804.21 0.00 % Fund: 189 - Measure Z Fund
189-5100-2000 Wages 156,582.00 156,582.00 10,164.82 61,378.20 95,203.80 60.80 % 189-5170-2000 Overtime Pay 30,000.00 30,000.00 852.92 5,066.53 24,933.47 83.11 % 189-5175-2000 Holiday Pay 0.00 0.00 6,038.90 6,038.90 -6,038.90 0.00 % 189-5180-2000 Vacation/Comp Time/Sick Leave Buy… 0.00 0.00 0.00 2,486.07 -2,486.07 0.00 % 189-5200-2000 Workers' Compensation 113,955.00 113,955.00 2,651.03 12,635.39 101,319.61 88.91 % 189-5230-2000 Medicare 0.00 0.00 239.25 1,042.41 -1,042.41 0.00 % 189-5240-2000 Medical Insurance 0.00 0.00 3,084.46 17,085.92 -17,085.92 0.00 % 189-5250-2000 Retirement - CalPERS 0.00 0.00 1,286.28 7,766.26 -7,766.26 0.00 % 189-5255-2000 PERS Unfunded Liability Payment 0.00 0.00 0.00 37,250.74 -37,250.74 0.00 % 189-5500-2000 Department Supplies 5,000.00 5,000.00 0.00 881.85 4,118.15 82.36 % 189-5505-2000 Vehicle Fuel & Oil 5,000.00 5,000.00 791.18 2,746.53 2,253.47 45.07 % 189-7000-2000 Travel, Conferences & Training 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % Fund: 189 - Measure Z Fund Total: 315,537.00 315,537.00 25,108.84 154,378.80 161,158.20 51.07 % Division: 2000 - Police Total: 4,137,337.00 4,137,337.00 309,564.03 2,109,920.44 2,027,416.56 49.00 % Division: 2400 - Dispatch
Fund: 100 - General Fund
100-5100-2400 Wages 322,661.00 322,661.00 20,197.47 116,553.48 206,107.52 63.88 % 100-5165-2400 Wages Part Time 29,711.00 29,711.00 1,612.83 12,622.14 17,088.86 57.52 % 100-5170-2400 Overtime Pay 20,000.00 20,000.00 2,832.05 14,074.88 5,925.12 29.63 % 100-5175-2400 Holiday Pay 10,000.00 10,000.00 11,149.52 11,149.52 -1,149.52 -11.50 % 100-5180-2400 Vacation/Comp Time/Sick Leave Buy… 10,000.00 10,000.00 0.00 12,436.11 -2,436.11 -24.36 % 100-5200-2400 Workers' Compensation 143,650.00 143,650.00 593.67 3,373.66 140,276.34 97.65 % 100-5210-2400 P/T Retirement - VALIC 0.00 0.00 64.51 514.56 -514.56 0.00 % 100-5230-2400 Medicare 0.00 0.00 503.22 2,332.32 -2,332.32 0.00 % 100-5240-2400 Medical Insurance 0.00 0.00 5,107.45 28,118.15 -28,118.15 0.00 % 100-5250-2400 Retirement - CalPERS 0.00 0.00 2,028.83 11,676.66 -11,676.66 0.00 % 100-5255-2400 PERS Unfunded Liability Payment 0.00 0.00 0.00 38,102.79 -38,102.79 0.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 6 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-6035-2400 Personnel Services 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % Fund: 100 - General Fund Total: 538,022.00 538,022.00 44,089.55 250,954.27 287,067.73 53.36 % Division: 2400 - Dispatch Total: 538,022.00 538,022.00 44,089.55 250,954.27 287,067.73 53.36 % Division: 2800 - Animal Control
Fund: 100 - General Fund
100-5165-2800 Wages Part Time 17,160.00 17,160.00 864.53 4,260.32 12,899.68 75.17 % 100-5200-2800 Workers' Compensation 1,828.00 1,828.00 42.08 207.39 1,620.61 88.65 % 100-5210-2800 P/T Retirement - VALIC 0.00 0.00 34.58 170.40 -170.40 0.00 % 100-5230-2800 Medicare 0.00 0.00 12.53 61.75 -61.75 0.00 % 100-5500-2800 Department Supplies 4,000.00 4,000.00 175.77 2,743.62 1,256.38 31.41 % 100-5505-2800 Vehicle Fuel & Oil 2,500.00 2,500.00 396.85 2,390.62 109.38 4.38 % 100-6035-2800 Personnel Services 300.00 300.00 0.00 615.00 -315.00 -105.00 % 100-6505-2800 Utility - General & Electric 2,000.00 2,000.00 0.00 1,152.19 847.81 42.39 % 100-7400-2800 Miranda's Rescue 22,000.00 22,000.00 965.50 8,130.72 13,869.28 63.04 % 100-7455-2800 Veterinary Expenses 5,000.00 5,000.00 252.92 2,514.24 2,485.76 49.72 % Fund: 100 - General Fund Total: 54,788.00 54,788.00 2,744.76 22,246.25 32,541.75 59.40 % Division: 2800 - Animal Control Total: 54,788.00 54,788.00 2,744.76 22,246.25 32,541.75 59.40 % Division: 2850 - K-9 Unit
Fund: 101 - Transaction and Use Tax Fund
101-5170-2850 Overtime Pay 10,000.00 10,000.00 461.54 6,292.57 3,707.43 37.07 % 101-5200-2850 Workers' Compensation 5,000.00 5,000.00 72.96 910.16 4,089.84 81.80 % 101-5230-2850 Medicare 0.00 0.00 6.31 87.58 -87.58 0.00 % 101-5240-2850 Medical Insurance 0.00 0.00 118.19 1,157.46 -1,157.46 0.00 % 101-5250-2850 Retirement - CalPERS 0.00 0.00 49.77 567.00 -567.00 0.00 % 101-5500-2850 Department Supplies 1,000.00 1,000.00 123.67 432.19 567.81 56.78 % 101-6025-2850 Professional Services 0.00 0.00 0.00 283.75 -283.75 0.00 % 101-7000-2850 Travel, Conferences & Training 2,000.00 2,000.00 0.00 4,036.47 -2,036.47 -101.82 % 101-7455-2850 Veterinary Expenses 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % Fund: 101 - Transaction and Use Tax Fund Total: 20,000.00 20,000.00 832.44 13,767.18 6,232.82 31.16 % Fund: 105 - Donations Fund
105-5170-2850 Overtime Pay 0.00 0.00 1,597.61 8,321.20 -8,321.20 0.00 % 105-5200-2850 Workers' Compensation 0.00 0.00 192.67 1,092.72 -1,092.72 0.00 % 105-5230-2850 Medicare 0.00 0.00 21.91 114.12 -114.12 0.00 % 105-5240-2850 Medical Insurance 0.00 0.00 459.41 2,406.98 -2,406.98 0.00 % 105-5250-2850 Retirement - CalPERS 0.00 0.00 129.26 749.62 -749.62 0.00 % 105-5500-2850 Department Supplies 0.00 0.00 123.67 737.09 -737.09 0.00 % 105-7000-2850 Travel, Conferences & Training 0.00 0.00 0.00 4,050.45 -4,050.45 0.00 % Fund: 105 - Donations Fund Total: 0.00 0.00 2,524.53 17,472.18 -17,472.18 0.00 % Division: 2850 - K-9 Unit Total: 20,000.00 20,000.00 3,356.97 31,239.36 -11,239.36 -56.20 % Division: 3000 - Building
Fund: 120 - Development & Building Fund
120-5100-3000 Wages 169,243.00 169,243.00 12,846.98 77,666.28 91,576.72 54.11 % 120-5180-3000 Vacation/Comp Time/Sick Leave Buy… 4,000.00 4,000.00 642.27 3,222.29 777.71 19.44 % 120-5200-3000 Workers' Compensation 82,155.00 82,155.00 642.16 4,118.50 78,036.50 94.99 % 120-5230-3000 Medicare 0.00 0.00 187.78 1,129.48 -1,129.48 0.00 % 120-5240-3000 Medical Insurance 0.00 0.00 2,526.12 14,019.94 -14,019.94 0.00 % 120-5250-3000 Retirement - CalPERS 0.00 0.00 1,742.35 10,541.27 -10,541.27 0.00 % 120-5255-3000 PERS Unfunded Liability Payment 0.00 0.00 0.00 16,815.48 -16,815.48 0.00 % 120-5265-3000 Miscellaneous Benefits 0.00 0.00 20.00 120.00 -120.00 0.00 % 120-5500-3000 Department Supplies 5,000.00 5,000.00 57.06 3,804.03 1,195.97 23.92 % 120-5505-3000 Vehicle Fuel & Oil 2,000.00 2,000.00 65.76 1,029.98 970.02 48.50 % 120-5705-3000 Equipment Maintenance 1,000.00 1,000.00 0.00 71.56 928.44 92.84 % 120-5715-3000 Vehicle Repairs 600.00 600.00 0.00 45.93 554.07 92.35 % 120-6005-3000 Engineering Services 4,000.00 4,000.00 0.00 250.00 3,750.00 93.75 % 120-6035-3000 Personnel Services 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 120-6200-3000 Telephone 200.00 200.00 0.00 86.41 113.59 56.80 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 7 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
120-6205-3000 Cell Phones 1,000.00 1,000.00 56.34 328.72 671.28 67.13 % 120-6350-3000 Liability Insurance 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 120-6505-3000 Utility - General & Electric 1,000.00 1,000.00 0.00 314.21 685.79 68.58 % 120-7000-3000 Travel, Conferences & Training 6,500.00 6,500.00 0.00 3,047.84 3,452.16 53.11 % 120-7015-3000 Dues & Subscriptions 600.00 600.00 0.00 280.00 320.00 53.33 % Fund: 120 - Development & Building Fund Total: 280,298.00 280,298.00 18,786.82 136,891.92 143,406.08 51.16 % Division: 3000 - Building Total: 280,298.00 280,298.00 18,786.82 136,891.92 143,406.08 51.16 % Division: 3100 - Development Review
Fund: 120 - Development & Building Fund
120-5100-3100 Wages 135,620.00 135,620.00 10,152.65 60,416.88 75,203.12 55.45 % 120-5180-3100 Vacation/Comp Time/Sick Leave Buy… 3,000.00 3,000.00 160.57 802.85 2,197.15 73.24 % 120-5200-3100 Workers' Compensation 63,978.00 63,978.00 252.89 1,571.35 62,406.65 97.54 % 120-5230-3100 Medicare 0.00 0.00 143.55 854.68 -854.68 0.00 % 120-5240-3100 Medical Insurance 0.00 0.00 2,387.81 13,254.64 -13,254.64 0.00 % 120-5250-3100 Retirement - CalPERS 0.00 0.00 1,074.64 6,439.42 -6,439.42 0.00 % 120-5255-3100 PERS Unfunded Liability Payment 0.00 0.00 0.00 11,959.28 -11,959.28 0.00 % 120-5500-3100 Department Supplies 500.00 500.00 0.00 0.00 500.00 100.00 % 120-5710-3100 Software Maintenance 2,000.00 2,000.00 0.00 2,047.90 -47.90 -2.40 % 120-6005-3100 Engineering Services 22,000.00 22,000.00 0.00 4,296.36 17,703.64 80.47 % 120-6035-3100 Personnel Services 250.00 250.00 0.00 15.08 234.92 93.97 % 120-6300-3100 Advertising 2,000.00 2,000.00 0.00 307.43 1,692.57 84.63 % 120-7000-3100 Travel, Conferences & Training 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % Fund: 120 - Development & Building Fund Total: 234,348.00 234,348.00 14,172.11 101,965.87 132,382.13 56.49 % Division: 3100 - Development Review Total: 234,348.00 234,348.00 14,172.11 101,965.87 132,382.13 56.49 % Division: 3200 - Planning
Fund: 100 - General Fund
100-5100-3200 Wages 32,074.00 32,074.00 2,510.36 15,177.63 16,896.37 52.68 % 100-5180-3200 Vacation/Comp Time/Sick Leave Buy… 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 100-5200-3200 Workers' Compensation 16,909.00 16,909.00 27.98 181.71 16,727.29 98.93 % 100-5230-3200 Medicare 0.00 0.00 34.71 210.66 -210.66 0.00 % 100-5240-3200 Medical Insurance 0.00 0.00 712.04 3,951.90 -3,951.90 0.00 % 100-5250-3200 Retirement - CalPERS 0.00 0.00 335.31 2,028.61 -2,028.61 0.00 % 100-5255-3200 PERS Unfunded Liability Payment 0.00 0.00 0.00 2,899.22 -2,899.22 0.00 % 100-5500-3200 Department Supplies 2,000.00 2,000.00 100.67 372.37 1,627.63 81.38 % 100-5705-3200 Equipment Maintenance 200.00 200.00 0.00 71.56 128.44 64.22 % 100-6025-3200 Professional Services 2,000.00 2,000.00 5.25 2,564.24 -564.24 -28.21 % 100-6035-3200 Personnel Services 250.00 250.00 0.00 0.00 250.00 100.00 % 100-6205-3200 Cell Phones 600.00 600.00 39.18 235.54 364.46 60.74 % 100-7000-3200 Travel, Conferences & Training 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 100-7600-3200 Planning Commission 3,000.00 3,000.00 0.00 960.00 2,040.00 68.00 % 100-7616-3200 Televised Meetings 1,400.00 1,400.00 0.00 459.38 940.62 67.19 % 100-8000-3200 Capital Outlay 80,000.00 80,000.00 1,242.00 43,112.00 36,888.00 46.11 % Fund: 100 - General Fund Total: 142,433.00 142,433.00 5,007.50 72,224.82 70,208.18 49.29 % Fund: 300 - Special Grants
300-6025-3200 Professional Services 0.00 0.00 0.00 23,097.55 -23,097.55 0.00 % Fund: 300 - Special Grants Total: 0.00 0.00 0.00 23,097.55 -23,097.55 0.00 % Division: 3200 - Planning Total: 142,433.00 142,433.00 5,007.50 95,322.37 47,110.63 33.08 % Division: 4000 - Engineering
Fund: 100 - General Fund
100-5100-4000 Wages 36,664.00 36,664.00 3,373.71 15,799.10 20,864.90 56.91 % 100-5180-4000 Vacation/Comp Time/Sick Leave Buy… 500.00 500.00 0.00 0.00 500.00 100.00 % 100-5200-4000 Workers' Compensation 17,759.00 17,759.00 186.91 927.45 16,831.55 94.78 % 100-5230-4000 Medicare 0.00 0.00 47.65 222.12 -222.12 0.00 % 100-5240-4000 Medical Insurance 0.00 0.00 538.66 2,996.58 -2,996.58 0.00 % 100-5250-4000 Retirement - CalPERS 0.00 0.00 243.04 1,159.12 -1,159.12 0.00 % 100-5255-4000 PERS Unfunded Liability Payment 0.00 0.00 0.00 2,899.22 -2,899.22 0.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 8 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-5265-4000 Miscellaneous Benefits 0.00 0.00 40.00 240.00 -240.00 0.00 % 100-5500-4000 Department Supplies 1,450.00 1,450.00 114.05 460.01 989.99 68.28 % 100-5505-4000 Vehicle Fuel & Oil 1,500.00 1,500.00 0.00 214.86 1,285.14 85.68 % 100-5705-4000 Equipment Maintenance 2,000.00 2,000.00 66.32 455.27 1,544.73 77.24 % 100-5710-4000 Software Maintenance 2,000.00 2,000.00 0.00 500.00 1,500.00 75.00 % 100-5715-4000 Vehicle Repairs 500.00 500.00 0.00 34.61 465.39 93.08 % 100-5775-4000 Network Support 6,160.00 6,160.00 347.63 2,085.78 4,074.22 66.14 % 100-5780-4000 Web Maintenance 1,000.00 1,000.00 0.00 257.14 742.86 74.29 % 100-6005-4000 Engineering Services 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 100-6025-4000 Professional Services 200.00 200.00 0.00 0.00 200.00 100.00 % 100-6035-4000 Personnel Services 500.00 500.00 0.00 75.46 424.54 84.91 % 100-6205-4000 Cell Phones 900.00 900.00 47.81 275.99 624.01 69.33 % 100-6505-4000 Utility - General & Electric 250.00 250.00 0.00 111.25 138.75 55.50 % 100-7000-4000 Travel, Conferences & Training 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 100-7015-4000 Dues & Subscriptions 4,200.00 4,200.00 0.00 1,232.56 2,967.44 70.65 % Fund: 100 - General Fund Total: 82,583.00 82,583.00 5,005.78 29,946.52 52,636.48 63.74 % Division: 4000 - Engineering Total: 82,583.00 82,583.00 5,005.78 29,946.52 52,636.48 63.74 % Division: 4100 - General Services
Fund: 100 - General Fund
100-5100-4100 Wages 99,897.00 99,897.00 7,528.83 43,668.03 56,228.97 56.29 % 100-5170-4100 Overtime Pay 800.00 800.00 0.00 0.00 800.00 100.00 % 100-5180-4100 Vacation/Comp Time/Sick Leave Buy… 1,500.00 1,500.00 172.95 1,487.11 12.89 0.86 % 100-5200-4100 Workers' Compensation 60,573.00 60,573.00 426.65 2,661.82 57,911.18 95.61 % 100-5230-4100 Medicare 0.00 0.00 105.59 621.15 -621.15 0.00 % 100-5240-4100 Medical Insurance 0.00 0.00 2,138.60 11,916.77 -11,916.77 0.00 % 100-5250-4100 Retirement - CalPERS 0.00 0.00 643.54 3,760.49 -3,760.49 0.00 % 100-5255-4100 PERS Unfunded Liability Payment 0.00 0.00 0.00 13,408.89 -13,408.89 0.00 % 100-5260-4100 Uniform Allowance 0.00 0.00 0.00 4.85 -4.85 0.00 % 100-5265-4100 Miscellaneous Benefits 0.00 0.00 40.00 1,240.00 -1,240.00 0.00 % 100-5500-4100 Department Supplies 20,000.00 20,000.00 696.27 4,524.06 15,475.94 77.38 % 100-5505-4100 Vehicle Fuel & Oil 20,000.00 20,000.00 3,795.43 17,161.64 2,838.36 14.19 % 100-5715-4100 Vehicle Repairs 8,000.00 8,000.00 371.14 6,785.15 1,214.85 15.19 % 100-5720-4100 Equipment Repair 4,000.00 4,000.00 184.28 1,410.34 2,589.66 64.74 % 100-5740-4100 Building Repair and Maintenance 500.00 500.00 72.12 181.34 318.66 63.73 % 100-5755-4100 Tree Trimming & Removal 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 100-5900-4100 Tools & Small Equipment 2,000.00 2,000.00 67.31 1,701.52 298.48 14.92 % 100-6025-4100 Professional Services 1,000.00 1,000.00 200.00 1,168.75 -168.75 -16.88 % 100-6035-4100 Personnel Services 1,500.00 1,500.00 0.00 284.33 1,215.67 81.04 % 100-6205-4100 Cell Phones 1,200.00 1,200.00 118.01 686.79 513.21 42.77 % 100-7000-4100 Travel, Conferences & Training 2,000.00 2,000.00 0.00 523.95 1,476.05 73.80 % 100-7015-4100 Dues & Subscriptions 1,200.00 1,200.00 65.61 544.30 655.70 54.64 % Fund: 100 - General Fund Total: 227,170.00 227,170.00 16,626.33 113,741.28 113,428.72 49.93 % Division: 4100 - General Services Total: 227,170.00 227,170.00 16,626.33 113,741.28 113,428.72 49.93 % Division: 4150 - TDA Ongoing Street Repairs
Fund: 260 - TDA Non-Transit Fund
260-8000-4150 Capital Outlay 98,000.00 98,000.00 0.00 8,049.52 89,950.48 91.79 % Fund: 260 - TDA Non-Transit Fund Total: 98,000.00 98,000.00 0.00 8,049.52 89,950.48 91.79 % Division: 4150 - TDA Ongoing Street Repairs Total: 98,000.00 98,000.00 0.00 8,049.52 89,950.48 91.79 % Division: 4200 - Streets Division
Fund: 280 - Gas Tax Fund
280-5100-4200 Wages 179,207.00 179,207.00 13,841.69 80,234.32 98,972.68 55.23 % 280-5170-4200 Overtime Pay 1,500.00 1,500.00 31.84 1,216.37 283.63 18.91 % 280-5180-4200 Vacation/Comp Time/Sick Leave Buy… 2,500.00 2,500.00 761.53 2,712.28 -212.28 -8.49 % 280-5200-4200 Workers' Compensation 108,743.00 108,743.00 792.20 4,838.57 103,904.43 95.55 % 280-5230-4200 Medicare 0.00 0.00 201.16 1,158.55 -1,158.55 0.00 % 280-5240-4200 Medical Insurance 0.00 0.00 3,941.77 22,424.91 -22,424.91 0.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 9 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
280-5250-4200 Retirement - CalPERS 0.00 0.00 1,272.62 7,522.05 -7,522.05 0.00 % 280-5255-4200 PERS Unfunded Liability Payment 0.00 0.00 0.00 22,758.88 -22,758.88 0.00 % 280-5260-4200 Uniform Allowance 0.00 0.00 0.00 9.24 -9.24 0.00 % 280-5500-4200 Department Supplies 8,000.00 8,000.00 308.88 4,847.29 3,152.71 39.41 % 280-5505-4200 Vehicle Fuel & Oil 5,000.00 5,000.00 368.50 2,961.18 2,038.82 40.78 % 280-5520-4200 Base Materials 700.00 700.00 0.00 270.18 429.82 61.40 % 280-5525-4200 Asphalt 5,000.00 5,000.00 0.00 2,031.70 2,968.30 59.37 % 280-5526-4200 Crack Seal Material 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 280-5710-4200 Software Maintenance 1,700.00 1,700.00 0.00 1,571.71 128.29 7.55 % 280-5715-4200 Vehicle Repairs 5,000.00 5,000.00 0.00 1,843.20 3,156.80 63.14 % 280-5720-4200 Equipment Repair 12,000.00 12,000.00 548.95 5,892.08 6,107.92 50.90 % 280-5722-4200 Retroflective Sign Compliance 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % 280-5725-4200 Traffic Signal Maintenance 9,500.00 9,500.00 0.00 1,040.54 8,459.46 89.05 % 280-5726-4200 Street Light Maintenance 2,000.00 2,000.00 977.85 1,567.81 432.19 21.61 % 280-5745-4200 Vandalism Repair 800.00 800.00 0.00 0.00 800.00 100.00 % 280-5755-4200 Tree Trimming & Removal 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 280-5900-4200 Tools & Small Equipment 1,200.00 1,200.00 0.00 488.90 711.10 59.26 % 280-6025-4200 Professional Services 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 280-6035-4200 Personnel Services 1,500.00 1,500.00 0.00 385.86 1,114.14 74.28 % 280-6350-4200 Liability Insurance 20,564.00 20,564.00 0.00 0.00 20,564.00 100.00 % 280-6505-4200 Utility - General & Electric 30,000.00 30,000.00 2,918.24 19,215.59 10,784.41 35.95 % 280-7000-4200 Travel, Conferences & Training 1,200.00 1,200.00 0.00 163.95 1,036.05 86.34 % Fund: 280 - Gas Tax Fund Total: 409,114.00 409,114.00 25,965.23 185,155.16 223,958.84 54.74 % Division: 4200 - Streets Division Total: 409,114.00 409,114.00 25,965.23 185,155.16 223,958.84 54.74 % Division: 4300 - Storm Drain Maintenance
Fund: 200 - Storm Drainage Fund
200-5100-4300 Wages 27,401.00 27,401.00 2,078.03 12,144.91 15,256.09 55.68 % 200-5180-4300 Vacation/Comp Time/Sick Leave Buy… 400.00 400.00 156.06 168.24 231.76 57.94 % 200-5200-4300 Workers' Compensation 14,124.00 14,124.00 110.30 651.01 13,472.99 95.39 % 200-5230-4300 Medicare 0.00 0.00 31.12 171.59 -171.59 0.00 % 200-5240-4300 Medical Insurance 0.00 0.00 472.00 2,639.95 -2,639.95 0.00 % 200-5250-4300 Retirement - CalPERS 0.00 0.00 204.95 1,206.75 -1,206.75 0.00 % 200-5255-4300 PERS Unfunded Liability Payment 0.00 0.00 0.00 2,971.70 -2,971.70 0.00 % 200-5260-4300 Uniform Allowance 0.00 0.00 0.00 0.92 -0.92 0.00 % 200-5500-4300 Department Supplies 7,500.00 7,500.00 0.00 291.39 7,208.61 96.11 % 200-6035-4300 Personnel Services 200.00 200.00 0.00 38.58 161.42 80.71 % 200-7000-4300 Travel, Conferences & Training 500.00 500.00 0.00 0.00 500.00 100.00 % Fund: 200 - Storm Drainage Fund Total: 50,125.00 50,125.00 3,052.46 20,285.04 29,839.96 59.53 % Division: 4300 - Storm Drain Maintenance Total: 50,125.00 50,125.00 3,052.46 20,285.04 29,839.96 59.53 % Division: 4310 - Stormwater Management
Fund: 200 - Storm Drainage Fund
200-6025-4310 Professional Services 18,200.00 18,200.00 6,650.00 16,129.75 2,070.25 11.38 % 200-6612-4310 Permits 12,000.00 12,000.00 0.00 10,602.00 1,398.00 11.65 % 200-6618-4310 SWMP Implementation 3,000.00 3,000.00 0.00 912.80 2,087.20 69.57 % 200-7015-4310 Dues & Subscriptions 300.00 300.00 0.00 0.00 300.00 100.00 % Fund: 200 - Storm Drainage Fund Total: 33,500.00 33,500.00 6,650.00 27,644.55 5,855.45 17.48 % Division: 4310 - Stormwater Management Total: 33,500.00 33,500.00 6,650.00 27,644.55 5,855.45 17.48 % Division: 5000 - Transit System
Fund: 590 - TDA Transit Fund
590-5100-5000 Wages 72,870.00 72,870.00 5,639.76 33,918.58 38,951.42 53.45 % 590-5165-5000 Wages Part Time 49,519.00 49,519.00 3,513.86 19,624.35 29,894.65 60.37 % 590-5180-5000 Vacation/Comp Time/Sick Leave Buy… 500.00 500.00 52.30 142.22 357.78 71.56 % 590-5200-5000 Workers' Compensation 75,055.00 75,055.00 1,093.30 6,717.93 68,337.07 91.05 % 590-5210-5000 P/T Retirement - VALIC 0.00 0.00 140.56 784.99 -784.99 0.00 % 590-5230-5000 Medicare 0.00 0.00 124.45 728.18 -728.18 0.00 % 590-5240-5000 Medical Insurance 0.00 0.00 3,021.45 16,770.23 -16,770.23 0.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 10 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
590-5250-5000 Retirement - CalPERS 0.00 0.00 467.46 2,811.48 -2,811.48 0.00 % 590-5255-5000 PERS Unfunded Liability Payment 0.00 0.00 0.00 11,162.00 -11,162.00 0.00 % 590-5500-5000 Department Supplies 800.00 800.00 0.00 516.61 283.39 35.42 % 590-5505-5000 Vehicle Fuel & Oil 14,000.00 14,000.00 1,097.39 8,760.82 5,239.18 37.42 % 590-5715-5000 Vehicle Repairs 4,500.00 4,500.00 0.00 4,379.20 120.80 2.68 % 590-6035-5000 Personnel Services 500.00 500.00 0.00 1,170.07 -670.07 -134.01 % 590-6200-5000 Telephone 200.00 200.00 0.00 902.61 -702.61 -351.31 % 590-6300-5000 Advertising 200.00 200.00 0.00 120.00 80.00 40.00 % 590-6350-5000 Liability Insurance 13,942.00 13,942.00 0.00 0.00 13,942.00 100.00 % 590-7000-5000 Travel, Conferences & Training 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % 590-7015-5000 Dues & Subscriptions 600.00 600.00 0.00 0.00 600.00 100.00 % Fund: 590 - TDA Transit Fund Total: 235,686.00 235,686.00 15,150.53 108,509.27 127,176.73 53.96 % Division: 5000 - Transit System Total: 235,686.00 235,686.00 15,150.53 108,509.27 127,176.73 53.96 % Division: 5050 - Public Transit
Fund: 590 - TDA Transit Fund
590-6620-5050 Humboldt Transit 168,700.00 168,700.00 0.00 168,659.00 41.00 0.02 % Fund: 590 - TDA Transit Fund Total: 168,700.00 168,700.00 0.00 168,659.00 41.00 0.02 % Division: 5050 - Public Transit Total: 168,700.00 168,700.00 0.00 168,659.00 41.00 0.02 % Division: 5300 - Recycling Division
Fund: 210 - Solid Waste Fund
210-5100-5300 Wages 10,277.00 10,277.00 836.16 5,055.77 5,221.23 50.81 % 210-5180-5300 Vacation/Comp Time/Sick Leave Buy… 300.00 300.00 207.54 207.54 92.46 30.82 % 210-5200-5300 Workers' Compensation 6,515.00 6,515.00 57.83 312.52 6,202.48 95.20 % 210-5230-5300 Medicare 0.00 0.00 14.25 71.40 -71.40 0.00 % 210-5240-5300 Medical Insurance 0.00 0.00 275.20 1,527.32 -1,527.32 0.00 % 210-5250-5300 Retirement - CalPERS 0.00 0.00 121.73 736.48 -736.48 0.00 % 210-5255-5300 PERS Unfunded Liability Payment 0.00 0.00 0.00 869.77 -869.77 0.00 % 210-5500-5300 Department Supplies 500.00 500.00 0.00 6.00 494.00 98.80 % 210-5735-5300 Janitorial Services - HHW 3,000.00 3,000.00 0.00 2,050.49 949.51 31.65 % 210-5752-5300 Illegal Dumping 1,000.00 1,000.00 0.00 427.60 572.40 57.24 % 210-7015-5300 Dues & Subscriptions 200.00 200.00 0.00 0.00 200.00 100.00 % 210-8000-5300 Capital Outlay 45,000.00 45,000.00 0.00 9,750.06 35,249.94 78.33 % Fund: 210 - Solid Waste Fund Total: 66,792.00 66,792.00 1,512.71 21,014.95 45,777.05 68.54 % Division: 5300 - Recycling Division Total: 66,792.00 66,792.00 1,512.71 21,014.95 45,777.05 68.54 % Division: 5400 - Recreation Programs Department
Fund: 100 - General Fund
100-5100-5400 Wages 39,582.00 39,582.00 3,122.92 18,163.39 21,418.61 54.11 % 100-5165-5400 Wages Part Time 132,537.00 132,537.00 9,914.01 109,375.55 23,161.45 17.48 % 100-5180-5400 Vacation/Comp Time/Sick Leave Buy… 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 100-5200-5400 Workers' Compensation 40,781.00 40,781.00 489.71 6,224.94 34,556.06 84.74 % 100-5210-5400 P/T Retirement - VALIC 0.00 0.00 396.53 4,374.97 -4,374.97 0.00 % 100-5230-5400 Medicare 0.00 0.00 185.07 1,827.14 -1,827.14 0.00 % 100-5240-5400 Medical Insurance 0.00 0.00 1,287.19 7,143.94 -7,143.94 0.00 % 100-5250-5400 Retirement - CalPERS 0.00 0.00 351.62 2,046.58 -2,046.58 0.00 % 100-5255-5400 PERS Unfunded Liability Payment 0.00 0.00 0.00 5,798.44 -5,798.44 0.00 % 100-5265-5400 Miscellaneous Benefits 0.00 0.00 80.00 425.16 -425.16 0.00 % 100-5500-5400 Department Supplies 2,300.00 2,300.00 214.90 1,939.36 360.64 15.68 % 100-5710-5400 Software Maintenance 3,400.00 3,400.00 0.00 3,170.53 229.47 6.75 % 100-5775-5400 Network Support 6,160.00 6,160.00 347.63 3,175.37 2,984.63 48.45 % 100-5780-5400 Web Maintenance 1,000.00 1,000.00 0.00 257.14 742.86 74.29 % 100-6035-5400 Personnel Services 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 100-6061-5400 Credit Card Transaction Charge 2,400.00 2,400.00 0.00 1,264.24 1,135.76 47.32 % 100-6200-5400 Telephone 4,000.00 4,000.00 0.00 2,377.32 1,622.68 40.57 % 100-6300-5400 Advertising 2,500.00 2,500.00 0.00 0.00 2,500.00 100.00 % 100-6500-5400 Utility - Water 1,300.00 1,300.00 72.63 897.19 402.81 30.99 % 100-6505-5400 Utility - General & Electric 4,000.00 4,000.00 265.08 2,191.86 1,808.14 45.20 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 11 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-7000-5400 Travel, Conferences & Training 1,200.00 1,200.00 0.00 0.00 1,200.00 100.00 % 100-7015-5400 Dues & Subscriptions 200.00 200.00 0.00 0.00 200.00 100.00 % 100-7200-5400 Sports Leagues 31,000.00 31,000.00 0.00 3,970.00 27,030.00 87.19 % 100-7215-5400 Adult Sports 1,500.00 1,500.00 0.00 630.61 869.39 57.96 % 100-7220-5400 Summer Fun 5,500.00 5,500.00 0.00 2,833.45 2,666.55 48.48 % 100-7221-5400 School Recreation Program 800.00 800.00 5.98 177.52 622.48 77.81 % 100-7222-5400 Kiddie Kamp Program 2,750.00 2,750.00 0.00 2,114.69 635.31 23.10 % 100-7225-5400 Youth Sports League 3,650.00 3,650.00 66.30 66.30 3,583.70 98.18 % 100-7230-5400 Skating/Pavilion 2,500.00 2,500.00 6.07 1,790.19 709.81 28.39 % 100-8000-5400 Capital Outlay 15,000.00 15,000.00 763.20 3,816.00 11,184.00 74.56 % Fund: 100 - General Fund Total: 307,060.00 307,060.00 17,568.84 186,051.88 121,008.12 39.41 % Fund: 101 - Transaction and Use Tax Fund
101-5100-5400 Wages 76,990.00 76,990.00 5,874.54 35,484.14 41,505.86 53.91 % 101-5170-5400 Overtime Pay 0.00 0.00 7.16 401.07 -401.07 0.00 % 101-5200-5400 Workers' Compensation 44,118.00 44,118.00 188.06 1,223.36 42,894.64 97.23 % 101-5230-5400 Medicare 0.00 0.00 78.68 483.63 -483.63 0.00 % 101-5240-5400 Medical Insurance 0.00 0.00 1,823.04 10,117.92 -10,117.92 0.00 % 101-5250-5400 Retirement - CalPERS 0.00 0.00 541.02 3,271.61 -3,271.61 0.00 % 101-5255-5400 PERS Unfunded Liability Payment 0.00 0.00 0.00 10,509.67 -10,509.67 0.00 % 101-5500-5400 Department Supplies 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 101-6025-5400 Professional Services 60,000.00 60,000.00 0.00 60,000.00 0.00 0.00 % Fund: 101 - Transaction and Use Tax Fund Total: 182,108.00 182,108.00 8,512.50 121,491.40 60,616.60 33.29 % Fund: 105 - Donations Fund
105-5165-5400 Wages Part Time 0.00 0.00 0.00 1,915.98 -1,915.98 0.00 % 105-5200-5400 Workers' Compensation 0.00 0.00 0.00 93.27 -93.27 0.00 % 105-5210-5400 P/T Retirement - VALIC 0.00 0.00 0.00 76.64 -76.64 0.00 % 105-5230-5400 Medicare 0.00 0.00 0.00 27.79 -27.79 0.00 % Fund: 105 - Donations Fund Total: 0.00 0.00 0.00 2,113.68 -2,113.68 0.00 % Fund: 306 - Recycle-Parks
306-5500-5400 Department Supplies 0.00 0.00 582.30 3,717.06 -3,717.06 0.00 % Fund: 306 - Recycle-Parks Total: 0.00 0.00 582.30 3,717.06 -3,717.06 0.00 % Division: 5400 - Recreation Programs Department Total: 489,168.00 489,168.00 26,663.64 313,374.02 175,793.98 35.94 % Division: 5450 - Parks Maintenance Department
Fund: 100 - General Fund
100-5100-5450 Wages 224,803.00 224,803.00 15,243.93 96,604.14 128,198.86 57.03 % 100-5165-5450 Wages Part Time 49,764.00 49,764.00 3,316.26 12,444.65 37,319.35 74.99 % 100-5170-5450 Overtime Pay 400.00 400.00 0.00 649.22 -249.22 -62.31 % 100-5180-5450 Vacation/Comp Time/Sick Leave Buy… 2,500.00 2,500.00 0.00 794.09 1,705.91 68.24 % 100-5200-5450 Workers' Compensation 156,868.00 156,868.00 1,028.24 6,577.00 150,291.00 95.81 % 100-5210-5450 P/T Retirement - VALIC 0.00 0.00 132.65 497.78 -497.78 0.00 % 100-5230-5450 Medicare 0.00 0.00 256.52 1,535.01 -1,535.01 0.00 % 100-5240-5450 Medical Insurance 0.00 0.00 4,906.50 26,585.43 -26,585.43 0.00 % 100-5250-5450 Retirement - CalPERS 0.00 0.00 1,620.26 10,334.94 -10,334.94 0.00 % 100-5255-5450 PERS Unfunded Liability Payment 0.00 0.00 0.00 33,703.43 -33,703.43 0.00 % 100-5260-5450 Uniform Allowance 0.00 0.00 0.00 26.18 -26.18 0.00 % 100-5500-5450 Department Supplies 25,000.00 25,000.00 408.88 15,557.74 9,442.26 37.77 % 100-5505-5450 Vehicle Fuel & Oil 10,500.00 10,500.00 1,051.10 5,428.85 5,071.15 48.30 % 100-5565-5450 Janitorial Supplies 15,000.00 15,000.00 2,376.69 9,512.70 5,487.30 36.58 % 100-5570-5450 Special Events 5,000.00 5,000.00 0.00 911.70 4,088.30 81.77 % 100-5705-5450 Equipment Maintenance 2,400.00 2,400.00 176.21 1,205.65 1,194.35 49.76 % 100-5715-5450 Vehicle Repairs 3,000.00 3,000.00 297.10 4,033.87 -1,033.87 -34.46 % 100-5720-5450 Equipment Repair 5,500.00 5,500.00 31.75 1,905.68 3,594.32 65.35 % 100-5730-5450 Alarm System Maintenance 800.00 800.00 0.00 150.00 650.00 81.25 % 100-5740-5450 Building Repair and Maintenance 5,100.00 5,100.00 968.93 2,855.22 2,244.78 44.02 % 100-5741-5450 Newburg Park Maintenance 4,000.00 4,000.00 159.16 3,080.64 919.36 22.98 % 100-5742-5450 Median Maintenance 2,000.00 2,000.00 0.00 1,997.05 2.95 0.15 % 100-5743-5450 Pavilion Maintenance 2,500.00 2,500.00 1,941.75 2,505.41 -5.41 -0.22 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 12 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-5745-5450 Vandalism Repair 2,000.00 2,000.00 469.26 1,065.65 934.35 46.72 % 100-5750-5450 Weed Abatement 500.00 500.00 0.00 0.00 500.00 100.00 % 100-5755-5450 Tree Trimming & Removal 2,500.00 2,500.00 0.00 0.00 2,500.00 100.00 % 100-5900-5450 Tools & Small Equipment 1,800.00 1,800.00 31.39 430.65 1,369.35 76.08 % 100-6035-5450 Personnel Services 1,000.00 1,000.00 0.00 4,482.39 -3,482.39 -348.24 % 100-6205-5450 Cell Phones 1,500.00 1,500.00 193.68 1,205.06 294.94 19.66 % 100-6210-5450 Internet Service 3,000.00 3,000.00 236.37 1,418.22 1,581.78 52.73 % 100-6500-5450 Utility - Water 42,000.00 42,000.00 2,416.32 23,375.46 18,624.54 44.34 % 100-6505-5450 Utility - General & Electric 28,000.00 28,000.00 1,477.97 18,474.75 9,525.25 34.02 % 100-6720-5450 County Property Tax 500.00 500.00 0.00 0.00 500.00 100.00 % 100-7000-5450 Travel, Conferences & Training 600.00 600.00 0.00 625.40 -25.40 -4.23 % 100-7015-5450 Dues & Subscriptions 150.00 150.00 0.00 0.00 150.00 100.00 % 100-7215-5450 Adult Sports 3,000.00 3,000.00 0.00 0.00 3,000.00 100.00 % Fund: 100 - General Fund Total: 601,685.00 601,685.00 38,740.92 289,973.96 311,711.04 51.81 % Fund: 101 - Transaction and Use Tax Fund
101-5100-5450 Wages 36,722.00 36,722.00 2,768.74 16,739.62 19,982.38 54.42 % 101-5200-5450 Workers' Compensation 22,838.00 22,838.00 153.39 996.45 21,841.55 95.64 % 101-5230-5450 Medicare 0.00 0.00 37.71 229.17 -229.17 0.00 % 101-5240-5450 Medical Insurance 0.00 0.00 1,032.04 5,727.88 -5,727.88 0.00 % 101-5250-5450 Retirement - CalPERS 0.00 0.00 312.76 1,892.18 -1,892.18 0.00 % 101-5255-5450 PERS Unfunded Liability Payment 0.00 0.00 0.00 3,261.62 -3,261.62 0.00 % 101-8000-5450 Capital Outlay 100,000.00 100,000.00 0.00 22,285.83 77,714.17 77.71 % Fund: 101 - Transaction and Use Tax Fund Total: 159,560.00 159,560.00 4,304.64 51,132.75 108,427.25 67.95 % Fund: 105 - Donations Fund
105-5500-5450 Department Supplies 0.00 0.00 0.00 5,871.31 -5,871.31 0.00 % Fund: 105 - Donations Fund Total: 0.00 0.00 0.00 5,871.31 -5,871.31 0.00 % Fund: 110 - Rohner Rec District Fund
110-5570-5450 Special Events 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 110-6025-5450 Professional Services 18,800.00 18,800.00 0.00 7,872.50 10,927.50 58.13 % 110-6700-5450 Administration Fees 600.00 600.00 0.00 215.00 385.00 64.17 % 110-7000-5450 Travel, Conferences & Training 600.00 600.00 0.00 0.00 600.00 100.00 % Fund: 110 - Rohner Rec District Fund Total: 21,000.00 21,000.00 0.00 8,087.50 12,912.50 61.49 % Division: 5450 - Parks Maintenance Department Total: 782,245.00 782,245.00 43,045.56 355,065.52 427,179.48 54.61 % Division: 5500 - Library
Fund: 100 - General Fund
100-5100-5500 Wages 3,757.00 3,757.00 332.66 1,985.18 1,771.82 47.16 % 100-5200-5500 Workers' Compensation 2,267.00 2,267.00 18.41 118.34 2,148.66 94.78 % 100-5230-5500 Medicare 0.00 0.00 4.79 28.61 -28.61 0.00 % 100-5240-5500 Medical Insurance 0.00 0.00 0.44 3.09 -3.09 0.00 % 100-5250-5500 Retirement - CalPERS 0.00 0.00 20.77 125.57 -125.57 0.00 % 100-5255-5500 PERS Unfunded Liability Payment 0.00 0.00 0.00 724.81 -724.81 0.00 % 100-5500-5500 Department Supplies 250.00 250.00 0.00 35.79 214.21 85.68 % 100-5740-5500 Building Repair and Maintenance 1,000.00 1,000.00 21.91 21.91 978.09 97.81 % 100-6500-5500 Utility - Water 2,000.00 2,000.00 62.41 696.12 1,303.88 65.19 % 100-6505-5500 Utility - General & Electric 5,000.00 5,000.00 324.77 2,057.11 2,942.89 58.86 % 100-6720-5500 County Property Tax 250.00 250.00 0.00 0.00 250.00 100.00 % Fund: 100 - General Fund Total: 14,524.00 14,524.00 786.16 5,796.53 8,727.47 60.09 % Division: 5500 - Library Total: 14,524.00 14,524.00 786.16 5,796.53 8,727.47 60.09 % Division: 5600 - Railroad Depot Museum
Fund: 100 - General Fund
100-5165-5600 Wages Part Time 22,754.00 22,754.00 1,370.82 7,854.18 14,899.82 65.48 % 100-5200-5600 Workers' Compensation 1,494.00 1,494.00 66.73 413.78 1,080.22 72.30 % 100-5210-5600 P/T Retirement - VALIC 0.00 0.00 54.83 314.15 -314.15 0.00 % 100-5230-5600 Medicare 0.00 0.00 19.87 113.88 -113.88 0.00 % 100-5500-5600 Department Supplies 500.00 500.00 18.64 548.33 -48.33 -9.67 % 100-5705-5600 Equipment Maintenance 250.00 250.00 0.00 0.00 250.00 100.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 13 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
100-5730-5600 Alarm System Maintenance 750.00 750.00 0.00 141.00 609.00 81.20 % 100-5740-5600 Building Repair and Maintenance 1,200.00 1,200.00 0.00 703.18 496.82 41.40 % 100-5775-5600 Network Support 770.00 770.00 43.45 260.70 509.30 66.14 % 100-6300-5600 Advertising 150.00 150.00 0.00 0.00 150.00 100.00 % 100-6500-5600 Utility - Water 750.00 750.00 61.06 366.36 383.64 51.15 % 100-6505-5600 Utility - General & Electric 3,400.00 3,400.00 198.58 1,569.28 1,830.72 53.84 % 100-7015-5600 Dues & Subscriptions 200.00 200.00 45.00 159.90 40.10 20.05 % Fund: 100 - General Fund Total: 32,218.00 32,218.00 1,878.98 12,444.74 19,773.26 61.37 % Division: 5600 - Railroad Depot Museum Total: 32,218.00 32,218.00 1,878.98 12,444.74 19,773.26 61.37 % Division: 5610 - Museum Exhibit Acquisition
Fund: 165 - Museum Exhibit Fund
165-5500-5610 Department Supplies 3,500.00 3,500.00 0.00 0.00 3,500.00 100.00 % 165-5550-5610 Gift Shop Purchases 3,000.00 3,000.00 292.11 995.95 2,004.05 66.80 % 165-6025-5610 Professional Services 750.00 750.00 0.00 0.00 750.00 100.00 % Fund: 165 - Museum Exhibit Fund Total: 7,250.00 7,250.00 292.11 995.95 6,254.05 86.26 % Division: 5610 - Museum Exhibit Acquisition Total: 7,250.00 7,250.00 292.11 995.95 6,254.05 86.26 % Division: 5700 - Monday Club
Fund: 160 - Riverlodge Fund
160-5165-5700 Wages Part Time 0.00 0.00 7.79 71.97 -71.97 0.00 % 160-5200-5700 Workers' Compensation 0.00 0.00 0.38 3.51 -3.51 0.00 % 160-5210-5700 P/T Retirement - VALIC 0.00 0.00 0.31 2.88 -2.88 0.00 % 160-5230-5700 Medicare 0.00 0.00 0.11 1.04 -1.04 0.00 % 160-5500-5700 Department Supplies 400.00 400.00 0.00 0.00 400.00 100.00 % 160-5720-5700 Equipment Repair 750.00 750.00 0.00 562.50 187.50 25.00 % 160-5740-5700 Building Repair and Maintenance 2,150.00 2,150.00 0.00 505.07 1,644.93 76.51 % 160-6200-5700 Telephone 300.00 300.00 0.00 126.32 173.68 57.89 % 160-6210-5700 Internet Service 0.00 0.00 91.07 558.78 -558.78 0.00 % 160-6300-5700 Advertising 200.00 200.00 0.00 0.00 200.00 100.00 % 160-6500-5700 Utility - Water 2,150.00 2,150.00 65.28 883.64 1,266.36 58.90 % 160-6505-5700 Utility - General & Electric 3,500.00 3,500.00 0.00 893.37 2,606.63 74.48 % 160-6720-5700 County Property Tax 200.00 200.00 0.00 0.00 200.00 100.00 % Fund: 160 - Riverlodge Fund Total: 9,650.00 9,650.00 164.94 3,609.08 6,040.92 62.60 % Division: 5700 - Monday Club Total: 9,650.00 9,650.00 164.94 3,609.08 6,040.92 62.60 % Division: 5800 - Riverlodge
Fund: 160 - Riverlodge Fund
160-5100-5800 Wages 119,665.00 119,665.00 8,720.12 50,170.45 69,494.55 58.07 % 160-5165-5800 Wages Part Time 29,997.00 29,997.00 2,752.86 15,532.42 14,464.58 48.22 % 160-5170-5800 Overtime Pay 400.00 400.00 0.00 0.00 400.00 100.00 % 160-5180-5800 Vacation/Comp Time/Sick Leave Buy… 2,000.00 2,000.00 0.00 80.58 1,919.42 95.97 % 160-5200-5800 Workers' Compensation 49,375.00 49,375.00 489.45 3,030.78 46,344.22 93.86 % 160-5210-5800 P/T Retirement - VALIC 0.00 0.00 110.13 621.30 -621.30 0.00 % 160-5230-5800 Medicare 0.00 0.00 158.84 921.02 -921.02 0.00 % 160-5240-5800 Medical Insurance 0.00 0.00 2,847.33 12,163.18 -12,163.18 0.00 % 160-5250-5800 Retirement - CalPERS 0.00 0.00 996.06 5,675.58 -5,675.58 0.00 % 160-5255-5800 PERS Unfunded Liability Payment 0.00 0.00 0.00 18,844.93 -18,844.93 0.00 % 160-5260-5800 Uniform Allowance 0.00 0.00 0.00 3.08 -3.08 0.00 % 160-5500-5800 Department Supplies 6,000.00 6,000.00 16.90 2,038.75 3,961.25 66.02 % 160-5539-5800 Kitchen Supplies 2,000.00 2,000.00 0.00 -79.31 2,079.31 103.97 % 160-5540-5800 Catering - Food 11,000.00 11,000.00 648.06 4,731.01 6,268.99 56.99 % 160-5546-5800 Catering - Other 1,200.00 1,200.00 8.66 442.29 757.71 63.14 % 160-5547-5800 User Group Linen 8,000.00 8,000.00 770.88 4,560.01 3,439.99 43.00 % 160-5550-5800 Gift Shop Purchases 750.00 750.00 0.00 0.00 750.00 100.00 % 160-5565-5800 Janitorial Supplies 5,500.00 5,500.00 529.68 3,904.83 1,595.17 29.00 % 160-5571-5800 Bridal Faire 2,500.00 2,500.00 0.00 0.00 2,500.00 100.00 % 160-5572-5800 Craft Faire 2,100.00 2,100.00 0.00 1,457.19 642.81 30.61 % 160-5575-5800 Kitchen Chemical 800.00 800.00 0.00 274.51 525.49 65.69 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 14 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
160-5705-5800 Equipment Maintenance 1,500.00 1,500.00 66.32 1,040.73 459.27 30.62 % 160-5706-5800 Equipment Lease 1,200.00 1,200.00 125.56 737.14 462.86 38.57 % 160-5720-5800 Equipment Repair 3,500.00 3,500.00 0.00 1,087.80 2,412.20 68.92 % 160-5730-5800 Alarm System Maintenance 300.00 300.00 0.00 0.00 300.00 100.00 % 160-5740-5800 Building Repair and Maintenance 16,750.00 16,750.00 0.00 3,242.35 13,507.65 80.64 % 160-5775-5800 Network Support 5,390.00 5,390.00 304.18 1,825.08 3,564.92 66.14 % 160-5780-5800 Web Maintenance 1,000.00 1,000.00 0.00 257.14 742.86 74.29 % 160-6035-5800 Personnel Services 1,000.00 1,000.00 0.00 2,961.89 -1,961.89 -196.19 % 160-6061-5800 Credit Card Transaction Charge 2,000.00 2,000.00 0.00 1,600.88 399.12 19.96 % 160-6200-5800 Telephone 5,500.00 5,500.00 0.00 3,536.24 1,963.76 35.70 % 160-6205-5800 Cell Phones 300.00 300.00 2.07 12.41 287.59 95.86 % 160-6210-5800 Internet Service 1,200.00 1,200.00 119.45 716.70 483.30 40.28 % 160-6300-5800 Advertising 3,000.00 3,000.00 0.00 103.58 2,896.42 96.55 % 160-6500-5800 Utility - Water 11,000.00 11,000.00 792.56 4,754.57 6,245.43 56.78 % 160-6505-5800 Utility - General & Electric 21,000.00 21,000.00 0.00 10,422.28 10,577.72 50.37 % 160-6720-5800 County Property Tax 200.00 200.00 0.00 0.00 200.00 100.00 % 160-7000-5800 Travel, Conferences & Training 400.00 400.00 0.00 0.00 400.00 100.00 % 160-8000-5800 Capital Outlay 10,000.00 10,000.00 508.80 2,544.00 7,456.00 74.56 % Fund: 160 - Riverlodge Fund Total: 326,527.00 326,527.00 19,967.91 159,215.39 167,311.61 51.24 % Division: 5800 - Riverlodge Total: 326,527.00 326,527.00 19,967.91 159,215.39 167,311.61 51.24 % Division: 6000 - Water - Pumping & Treatment
Fund: 500 - Water Fund
500-5100-6000 Wages 150,097.00 150,097.00 9,604.14 56,042.73 94,054.27 62.66 % 500-5170-6000 Overtime Pay 300.00 300.00 83.63 83.63 216.37 72.12 % 500-5180-6000 Vacation/Comp Time/Sick Leave Buy… 1,500.00 1,500.00 489.10 643.85 856.15 57.08 % 500-5200-6000 Workers' Compensation 94,942.00 94,942.00 563.08 3,355.90 91,586.10 96.47 % 500-5230-6000 Medicare 0.00 0.00 139.12 775.86 -775.86 0.00 % 500-5240-6000 Medical Insurance 0.00 0.00 3,287.70 18,013.09 -18,013.09 0.00 % 500-5250-6000 Retirement - CalPERS 0.00 0.00 1,025.38 5,983.23 -5,983.23 0.00 % 500-5255-6000 PERS Unfunded Liability Payment 0.00 0.00 0.00 17,757.72 -17,757.72 0.00 % 500-5260-6000 Uniform Allowance 0.00 0.00 15.02 18.87 -18.87 0.00 % 500-5500-6000 Department Supplies 10,000.00 10,000.00 4,284.86 6,514.51 3,485.49 34.85 % 500-5505-6000 Vehicle Fuel & Oil 2,500.00 2,500.00 83.65 187.07 2,312.93 92.52 % 500-5555-6000 Plant Chemicals 4,500.00 4,500.00 0.00 3,442.87 1,057.13 23.49 % 500-5557-6000 Lab Supplies 7,000.00 7,000.00 0.00 4,828.24 2,171.76 31.03 % 500-5715-6000 Vehicle Repairs 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 500-5719-6000 Information Technology 5,500.00 5,500.00 0.00 728.34 4,771.66 86.76 % 500-5720-6000 Equipment Repair 17,000.00 17,000.00 906.41 1,328.97 15,671.03 92.18 % 500-5730-6000 Alarm System Maintenance 1,500.00 1,500.00 129.00 729.32 770.68 51.38 % 500-5740-6000 Building Repair and Maintenance 10,000.00 10,000.00 0.00 3,661.07 6,338.93 63.39 % 500-5900-6000 Tools & Small Equipment 1,500.00 1,500.00 0.00 383.30 1,116.70 74.45 % 500-6005-6000 Engineering Services 5,000.00 5,000.00 0.00 2,670.50 2,329.50 46.59 % 500-6025-6000 Professional Services 12,000.00 12,000.00 4,296.25 14,696.25 -2,696.25 -22.47 % 500-6035-6000 Personnel Services 1,000.00 1,000.00 0.00 275.21 724.79 72.48 % 500-6045-6000 Laboratory Services 6,000.00 6,000.00 0.00 1,710.00 4,290.00 71.50 % 500-6505-6000 Utility - General & Electric 220,000.00 220,000.00 15,748.36 126,441.18 93,558.82 42.53 % 500-6605-6000 Lab Permit Fees 3,000.00 3,000.00 0.00 1,062.50 1,937.50 64.58 % 500-6612-6000 Permits 14,000.00 14,000.00 15,388.38 15,388.38 -1,388.38 -9.92 % 500-6633-6000 Regulatory Compliance 5,000.00 5,000.00 0.00 2,059.18 2,940.82 58.82 % 500-7000-6000 Travel, Conferences & Training 2,500.00 2,500.00 0.00 325.66 2,174.34 86.97 % 500-7012-6000 Certification 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 500-7015-6000 Dues & Subscriptions 1,500.00 1,500.00 65.61 645.30 854.70 56.98 % 500-7820-6000 Water Reports Wtr Pumping/Tre 2,500.00 2,500.00 0.00 0.00 2,500.00 100.00 % 500-8000-6000 Capital Outlay 47,500.00 47,500.00 0.00 18,118.38 29,381.62 61.86 % Fund: 500 - Water Fund Total: 628,339.00 628,339.00 56,109.69 307,871.11 320,467.89 51.00 % Division: 6000 - Water - Pumping & Treatment Total: 628,339.00 628,339.00 56,109.69 307,871.11 320,467.89 51.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 15 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
Division: 6100 - Water - Transmission & Distribution
Fund: 500 - Water Fund
500-5100-6100 Wages 239,491.00 239,491.00 15,653.72 91,651.85 147,839.15 61.73 % 500-5170-6100 Overtime Pay 2,000.00 2,000.00 0.00 262.64 1,737.36 86.87 % 500-5180-6100 Vacation/Comp Time/Sick Leave Buy… 3,500.00 3,500.00 331.02 1,593.89 1,906.11 54.46 % 500-5200-6100 Workers' Compensation 160,684.00 160,684.00 869.54 5,423.78 155,260.22 96.62 % 500-5230-6100 Medicare 0.00 0.00 215.60 1,260.91 -1,260.91 0.00 % 500-5240-6100 Medical Insurance 0.00 0.00 5,415.14 32,341.04 -32,341.04 0.00 % 500-5250-6100 Retirement - CalPERS 0.00 0.00 1,404.21 8,296.13 -8,296.13 0.00 % 500-5255-6100 PERS Unfunded Liability Payment 0.00 0.00 0.00 33,051.11 -33,051.11 0.00 % 500-5260-6100 Uniform Allowance 0.00 0.00 5.01 26.19 -26.19 0.00 % 500-5265-6100 Miscellaneous Benefits 0.00 0.00 40.00 240.00 -240.00 0.00 % 500-5500-6100 Department Supplies 60,000.00 60,000.00 2,036.89 24,321.98 35,678.02 59.46 % 500-5505-6100 Vehicle Fuel & Oil 30,000.00 30,000.00 3,091.52 19,980.91 10,019.09 33.40 % 500-5520-6100 Base Materials 10,000.00 10,000.00 0.00 1,543.99 8,456.01 84.56 % 500-5525-6100 Asphalt 8,000.00 8,000.00 0.00 3,679.02 4,320.98 54.01 % 500-5715-6100 Vehicle Repairs 10,000.00 10,000.00 324.01 3,787.44 6,212.56 62.13 % 500-5719-6100 Information Technology 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 500-5720-6100 Equipment Repair 10,000.00 10,000.00 39.93 7,469.58 2,530.42 25.30 % 500-5740-6100 Building Repair and Maintenance 2,000.00 2,000.00 72.11 139.83 1,860.17 93.01 % 500-5760-6100 Water Meters 75,000.00 75,000.00 7,575.87 13,107.13 61,892.87 82.52 % 500-5900-6100 Tools & Small Equipment 5,000.00 5,000.00 0.00 319.66 4,680.34 93.61 % 500-6005-6100 Engineering Services 1,500.00 1,500.00 0.00 0.00 1,500.00 100.00 % 500-6015-6100 General Contracting 25,000.00 25,000.00 0.00 0.00 25,000.00 100.00 % 500-6025-6100 Professional Services 7,500.00 7,500.00 0.00 0.00 7,500.00 100.00 % 500-6035-6100 Personnel Services 1,500.00 1,500.00 0.00 1,149.65 350.35 23.36 % 500-6200-6100 Telephone 1,500.00 1,500.00 33.97 681.26 818.74 54.58 % 500-6360-6100 Claims/Settlement 10,000.00 10,000.00 0.00 0.00 10,000.00 100.00 % 500-6505-6100 Utility - General & Electric 500.00 500.00 0.00 0.00 500.00 100.00 % 500-7000-6100 Travel, Conferences & Training 5,000.00 5,000.00 0.00 901.75 4,098.25 81.97 % 500-7012-6100 Certification 1,000.00 1,000.00 80.00 330.00 670.00 67.00 % 500-7015-6100 Dues & Subscriptions 500.00 500.00 0.00 151.72 348.28 69.66 % 500-8000-6100 Capital Outlay 66,550.00 66,550.00 0.00 0.00 66,550.00 100.00 % Fund: 500 - Water Fund Total: 737,225.00 737,225.00 37,188.54 251,711.46 485,513.54 65.86 % Division: 6100 - Water - Transmission & Distribution Total: 737,225.00 737,225.00 37,188.54 251,711.46 485,513.54 65.86 % Division: 6200 - Water - Customer Account Expense
Fund: 500 - Water Fund
500-5100-6200 Wages 43,055.00 43,055.00 2,900.75 17,203.97 25,851.03 60.04 % 500-5170-6200 Overtime Pay 200.00 200.00 0.00 0.00 200.00 100.00 % 500-5180-6200 Vacation/Comp Time/Sick Leave Buy… 500.00 500.00 0.00 154.75 345.25 69.05 % 500-5200-6200 Workers' Compensation 30,460.00 30,460.00 112.04 712.47 29,747.53 97.66 % 500-5230-6200 Medicare 0.00 0.00 38.57 231.34 -231.34 0.00 % 500-5240-6200 Medical Insurance 0.00 0.00 1,170.74 6,945.42 -6,945.42 0.00 % 500-5250-6200 Retirement - CalPERS 0.00 0.00 322.58 1,925.31 -1,925.31 0.00 % 500-5255-6200 PERS Unfunded Liability Payment 0.00 0.00 0.00 5,798.44 -5,798.44 0.00 % 500-5260-6200 Uniform Allowance 0.00 0.00 0.00 3.85 -3.85 0.00 % 500-5500-6200 Department Supplies 14,000.00 14,000.00 1,183.70 7,064.22 6,935.78 49.54 % 500-6035-6200 Personnel Services 500.00 500.00 0.00 129.37 370.63 74.13 % 500-6300-6200 Advertising 200.00 200.00 0.00 0.00 200.00 100.00 % Fund: 500 - Water Fund Total: 88,915.00 88,915.00 5,728.38 40,169.14 48,745.86 54.82 % Division: 6200 - Water - Customer Account Expense Total: 88,915.00 88,915.00 5,728.38 40,169.14 48,745.86 54.82 % Division: 6300 - Water - Administration
Fund: 500 - Water Fund
500-5100-6300 Wages 301,436.00 301,436.00 23,612.99 132,782.23 168,653.77 55.95 % 500-5165-6300 Wages Part Time 5,719.00 5,719.00 237.36 1,678.75 4,040.25 70.65 % 500-5170-6300 Overtime Pay 800.00 800.00 0.00 0.00 800.00 100.00 % 500-5180-6300 Vacation/Comp Time/Sick Leave Buy… 6,000.00 6,000.00 435.77 1,672.71 4,327.29 72.12 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 16 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
500-5200-6300 Workers' Compensation 138,180.00 138,180.00 598.17 3,310.24 134,869.76 97.60 % 500-5210-6300 P/T Retirement - VALIC 0.00 0.00 9.50 67.17 -67.17 0.00 % 500-5230-6300 Medicare 0.00 0.00 339.76 1,902.16 -1,902.16 0.00 % 500-5240-6300 Medical Insurance 0.00 0.00 4,864.02 28,410.07 -28,410.07 0.00 % 500-5250-6300 Retirement - CalPERS 0.00 0.00 2,077.40 11,953.94 -11,953.94 0.00 % 500-5255-6300 PERS Unfunded Liability Payment 0.00 0.00 0.00 27,470.11 -27,470.11 0.00 % 500-5500-6300 Department Supplies 10,000.00 10,000.00 250.52 4,527.35 5,472.65 54.73 % 500-5705-6300 Equipment Maintenance 3,000.00 3,000.00 198.97 1,594.98 1,405.02 46.83 % 500-5710-6300 Software Maintenance 6,800.00 6,800.00 0.00 7,060.60 -260.60 -3.83 % 500-5740-6300 Building Repair and Maintenance 2,000.00 2,000.00 0.00 32.29 1,967.71 98.39 % 500-5775-6300 Network Support 5,390.00 5,390.00 666.67 4,000.02 1,389.98 25.79 % 500-5780-6300 Web Maintenance 1,000.00 1,000.00 0.00 257.15 742.85 74.29 % 500-6000-6300 Audit Fees 7,200.00 7,200.00 0.00 2,927.70 4,272.30 59.34 % 500-6005-6300 Engineering Services 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 500-6025-6300 Professional Services 4,000.00 4,000.00 0.00 993.72 3,006.28 75.16 % 500-6035-6300 Personnel Services 500.00 500.00 0.00 143.39 356.61 71.32 % 500-6060-6300 Bank Fees 8,000.00 8,000.00 0.00 2,193.13 5,806.87 72.59 % 500-6061-6300 Credit Card Transaction Charge 24,000.00 24,000.00 0.00 9,541.21 14,458.79 60.24 % 500-6200-6300 Telephone 1,400.00 1,400.00 0.00 361.94 1,038.06 74.15 % 500-6205-6300 Cell Phones 2,000.00 2,000.00 172.70 973.08 1,026.92 51.35 % 500-6210-6300 Internet Service 1,000.00 1,000.00 58.36 350.16 649.84 64.98 % 500-6350-6300 Liability Insurance 83,034.00 83,034.00 0.00 15,000.00 68,034.00 81.94 % 500-6505-6300 Utility - General & Electric 5,000.00 5,000.00 0.00 1,571.06 3,428.94 68.58 % 500-7000-6300 Travel, Conferences & Training 4,000.00 4,000.00 0.00 0.00 4,000.00 100.00 % 500-7800-6300 Bad Debts 10,000.00 10,000.00 -149.14 4,642.19 5,357.81 53.58 % Fund: 500 - Water Fund Total: 631,459.00 631,459.00 33,373.05 265,417.35 366,041.65 57.97 % Division: 6300 - Water - Administration Total: 631,459.00 631,459.00 33,373.05 265,417.35 366,041.65 57.97 % Division: 6500 - Wastewater - Collection
Fund: 550 - Wastewater Fund
550-5100-6500 Wages 216,571.00 216,571.00 14,294.51 82,950.46 133,620.54 61.70 % 550-5170-6500 Overtime Pay 500.00 500.00 0.00 0.00 500.00 100.00 % 550-5180-6500 Vacation/Comp Time/Sick Leave Buy… 2,000.00 2,000.00 331.04 1,444.35 555.65 27.78 % 550-5200-6500 Workers' Compensation 141,977.00 141,977.00 802.30 4,928.94 137,048.06 96.53 % 550-5230-6500 Medicare 0.00 0.00 198.18 1,143.32 -1,143.32 0.00 % 550-5240-6500 Medical Insurance 0.00 0.00 4,700.71 27,693.90 -27,693.90 0.00 % 550-5250-6500 Retirement - CalPERS 0.00 0.00 1,274.18 7,443.56 -7,443.56 0.00 % 550-5255-6500 PERS Unfunded Liability Payment 0.00 0.00 0.00 29,427.08 -29,427.08 0.00 % 550-5260-6500 Uniform Allowance 0.00 0.00 5.01 23.34 -23.34 0.00 % 550-5500-6500 Department Supplies 10,000.00 10,000.00 266.68 2,302.05 7,697.95 76.98 % 550-5505-6500 Vehicle Fuel & Oil 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 550-5520-6500 Base Materials 2,500.00 2,500.00 0.00 244.95 2,255.05 90.20 % 550-5525-6500 Asphalt 2,000.00 2,000.00 0.00 110.35 1,889.65 94.48 % 550-5710-6500 Software Maintenance 1,500.00 1,500.00 0.00 0.00 1,500.00 100.00 % 550-5715-6500 Vehicle Repairs 10,000.00 10,000.00 0.00 510.60 9,489.40 94.89 % 550-5719-6500 Information Technology 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 550-5720-6500 Equipment Repair 5,000.00 5,000.00 74.36 1,674.93 3,325.07 66.50 % 550-5740-6500 Building Repair and Maintenance 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 550-5900-6500 Tools & Small Equipment 5,000.00 5,000.00 0.00 108.23 4,891.77 97.84 % 550-6005-6500 Engineering Services 2,500.00 2,500.00 0.00 0.00 2,500.00 100.00 % 550-6015-6500 General Contracting 15,000.00 15,000.00 0.00 0.00 15,000.00 100.00 % 550-6025-6500 Professional Services 0.00 0.00 0.00 240.00 -240.00 0.00 % 550-6035-6500 Personnel Services 1,200.00 1,200.00 0.00 1,154.54 45.46 3.79 % 550-6200-6500 Telephone 3,000.00 3,000.00 0.00 1,885.31 1,114.69 37.16 % 550-6612-6500 Permits 3,800.00 3,800.00 3,453.00 3,453.00 347.00 9.13 % 550-6630-6500 Fines Levied 25,000.00 25,000.00 0.00 0.00 25,000.00 100.00 % 550-6631-6500 Compliance Fees 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 550-7000-6500 Travel, Conferences & Training 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 550-7012-6500 Certification 500.00 500.00 0.00 0.00 500.00 100.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 17 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
550-7015-6500 Dues & Subscriptions 500.00 500.00 0.00 151.71 348.29 69.66 % 550-8000-6500 Capital Outlay 26,550.00 26,550.00 0.00 0.00 26,550.00 100.00 % Fund: 550 - Wastewater Fund Total: 487,098.00 487,098.00 25,399.97 166,890.62 320,207.38 65.74 % Division: 6500 - Wastewater - Collection Total: 487,098.00 487,098.00 25,399.97 166,890.62 320,207.38 65.74 % Division: 6505 - Maint Dist Buena Vista Lift Station
Fund: 670 - Rancho Bueno Vista Fund
670-5195-6505 Wages Distribution 2,900.00 2,900.00 0.00 0.00 2,900.00 100.00 % 670-5295-6505 Benefits Distribution 975.00 975.00 0.00 0.00 975.00 100.00 % 670-6055-6505 Trustee Fees 250.00 250.00 0.00 0.00 250.00 100.00 % 670-6505-6505 Utility - General & Electric 365.00 365.00 0.00 138.91 226.09 61.94 % 670-6700-6505 Administration Fees 10.00 10.00 0.00 0.00 10.00 100.00 % 670-9100-6505 Depreciation Expense 1,614.00 1,614.00 0.00 0.00 1,614.00 100.00 % Fund: 670 - Rancho Bueno Vista Fund Total: 6,114.00 6,114.00 0.00 138.91 5,975.09 97.73 % Division: 6505 - Maint Dist Buena Vista Lift Station Total: 6,114.00 6,114.00 0.00 138.91 5,975.09 97.73 % Division: 6510 - Maint Dist Kenwood Meadows Lift Station Fund: 671 - Kenwood Meadows Fund
671-5195-6510 Wages Distribution 2,900.00 2,900.00 0.00 0.00 2,900.00 100.00 % 671-5295-6510 Benefits Distribution 975.00 975.00 0.00 0.00 975.00 100.00 % 671-6055-6510 Trustee Fees 250.00 250.00 0.00 0.00 250.00 100.00 % 671-6505-6510 Utility - General & Electric 500.00 500.00 0.00 280.44 219.56 43.91 % 671-6700-6510 Administration Fees 10.00 10.00 0.00 0.00 10.00 100.00 % 671-9100-6510 Depreciation Expense 3,619.00 3,619.00 0.00 0.00 3,619.00 100.00 % Fund: 671 - Kenwood Meadows Fund Total: 8,254.00 8,254.00 0.00 280.44 7,973.56 96.60 % Division: 6510 - Maint Dist Kenwood Meadows Lift Station Total: 8,254.00 8,254.00 0.00 280.44 7,973.56 96.60 % Division: 6515 - Maint Dist Forest Hill Water Booster
Fund: 672 - Forest Hill Water Booster Fund
672-5195-6515 Wages Distribution 9,000.00 9,000.00 0.00 0.00 9,000.00 100.00 % 672-5295-6515 Benefits Distribution 1,850.00 1,850.00 0.00 0.00 1,850.00 100.00 % 672-5720-6515 Equipment Repair 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 672-6055-6515 Trustee Fees 250.00 250.00 0.00 0.00 250.00 100.00 % 672-6505-6515 Utility - General & Electric 2,200.00 2,200.00 264.79 1,540.44 659.56 29.98 % 672-6700-6515 Administration Fees 10.00 10.00 0.00 0.00 10.00 100.00 % 672-9100-6515 Depreciation Expense 8,000.00 8,000.00 0.00 0.00 8,000.00 100.00 % Fund: 672 - Forest Hill Water Booster Fund Total: 23,310.00 23,310.00 264.79 1,540.44 21,769.56 93.39 % Division: 6515 - Maint Dist Forest Hill Water Booster Total: 23,310.00 23,310.00 264.79 1,540.44 21,769.56 93.39 % Division: 6520 - Maint Dist Forest Hill Retention
Fund: 673 - Forest Hill Retention Basin Fund
673-5195-6520 Wages Distribution 2,900.00 2,900.00 0.00 0.00 2,900.00 100.00 % 673-5295-6520 Benefits Distribution 975.00 975.00 0.00 0.00 975.00 100.00 % 673-5600-6520 Supplies - High Rock Crew 200.00 200.00 0.00 0.00 200.00 100.00 % 673-6055-6520 Trustee Fees 225.00 225.00 0.00 0.00 225.00 100.00 % 673-6700-6520 Administration Fees 10.00 10.00 0.00 0.00 10.00 100.00 % 673-9100-6520 Depreciation Expense 1,695.00 1,695.00 0.00 0.00 1,695.00 100.00 % Fund: 673 - Forest Hill Retention Basin Fund Total: 6,005.00 6,005.00 0.00 0.00 6,005.00 100.00 % Division: 6520 - Maint Dist Forest Hill Retention Total: 6,005.00 6,005.00 0.00 0.00 6,005.00 100.00 % Division: 6522 - Maint Dist Dove Subdv Detention Basin
Fund: 674 - Dove Subdivision Retention Basin Fund
674-5195-6522 Wages Distribution 80.00 80.00 0.00 0.00 80.00 100.00 % 674-5295-6522 Benefits Distribution 20.00 20.00 0.00 0.00 20.00 100.00 % 674-6055-6522 Trustee Fees 25.00 25.00 0.00 0.00 25.00 100.00 % 674-6700-6522 Administration Fees 5.00 5.00 0.00 0.00 5.00 100.00 % 674-9100-6522 Depreciation Expense 941.00 941.00 0.00 0.00 941.00 100.00 % Fund: 674 - Dove Subdivision Retention Basin Fund Total: 1,071.00 1,071.00 0.00 0.00 1,071.00 100.00 % Division: 6522 - Maint Dist Dove Subdv Detention Basin Total: 1,071.00 1,071.00 0.00 0.00 1,071.00 100.00 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 18 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
Division: 6524 - Maint Dist Gulliksen Storm Water Basin Fund: 675 - Gulliksen Maintenance Fund
675-5195-6524 Wages Distribution 80.00 80.00 0.00 0.00 80.00 100.00 % 675-5295-6524 Benefits Distribution 20.00 20.00 0.00 0.00 20.00 100.00 % 675-5600-6524 Supplies - High Rock Crew 200.00 200.00 0.00 0.00 200.00 100.00 % 675-6055-6524 Trustee Fees 25.00 25.00 0.00 0.00 25.00 100.00 % 675-6700-6524 Administration Fees 5.00 5.00 0.00 0.00 5.00 100.00 % 675-9100-6524 Depreciation Expense 2,068.00 2,068.00 0.00 0.00 2,068.00 100.00 % Fund: 675 - Gulliksen Maintenance Fund Total: 2,398.00 2,398.00 0.00 0.00 2,398.00 100.00 % Division: 6524 - Maint Dist Gulliksen Storm Water Basin Total: 2,398.00 2,398.00 0.00 0.00 2,398.00 100.00 % Division: 6525 - Maint Dist Astor Drainage Assessment
Fund: 676 - Astor Drainage Fund
676-5195-6525 Wages Distribution 80.00 80.00 0.00 0.00 80.00 100.00 % 676-5295-6525 Benefits Distribution 20.00 20.00 0.00 0.00 20.00 100.00 % 676-6055-6525 Trustee Fees 25.00 25.00 0.00 0.00 25.00 100.00 % 676-6700-6525 Administration Fees 5.00 5.00 0.00 0.00 5.00 100.00 % 676-9100-6525 Depreciation Expense 2,707.00 2,707.00 0.00 0.00 2,707.00 100.00 % Fund: 676 - Astor Drainage Fund Total: 2,837.00 2,837.00 0.00 0.00 2,837.00 100.00 % Division: 6525 - Maint Dist Astor Drainage Assessment Total: 2,837.00 2,837.00 0.00 0.00 2,837.00 100.00 % Division: 6526 - Maint Dist Astor Subdivision Lift Statio Fund: 677 - Astor Sewer District Fund
677-5195-6526 Wages Distribution 2,900.00 2,900.00 0.00 0.00 2,900.00 100.00 % 677-5295-6526 Benefits Distribution 975.00 975.00 0.00 0.00 975.00 100.00 % 677-6055-6526 Trustee Fees 250.00 250.00 0.00 0.00 250.00 100.00 % 677-6505-6526 Utility - General & Electric 265.00 265.00 0.00 117.60 147.40 55.62 % 677-6700-6526 Administration Fees 5.00 5.00 0.00 0.00 5.00 100.00 % 677-9100-6526 Depreciation Expense 800.00 800.00 0.00 0.00 800.00 100.00 % Fund: 677 - Astor Sewer District Fund Total: 5,195.00 5,195.00 0.00 117.60 5,077.40 97.74 % Division: 6526 - Maint Dist Astor Subdivision Lift Statio Total: 5,195.00 5,195.00 0.00 117.60 5,077.40 97.74 % Division: 6527 - Maint Dist Wright Drainage Assessment A Fund: 678 - Wright Drainage District Fund
678-5195-6527 Wages Distribution 80.00 80.00 0.00 0.00 80.00 100.00 % 678-5295-6527 Benefits Distribution 20.00 20.00 0.00 0.00 20.00 100.00 % 678-6055-6527 Trustee Fees 25.00 25.00 0.00 0.00 25.00 100.00 % 678-9100-6527 Depreciation Expense 1,693.00 1,693.00 0.00 0.00 1,693.00 100.00 % Fund: 678 - Wright Drainage District Fund Total: 1,818.00 1,818.00 0.00 0.00 1,818.00 100.00 % Division: 6527 - Maint Dist Wright Drainage Assessment A Total: 1,818.00 1,818.00 0.00 0.00 1,818.00 100.00 % Division: 6600 - Wastewater - Treatment
Fund: 550 - Wastewater Fund
550-5100-6600 Wages 423,332.00 423,332.00 27,043.50 155,925.06 267,406.94 63.17 % 550-5170-6600 Overtime Pay 1,500.00 1,500.00 193.72 787.61 712.39 47.49 % 550-5180-6600 Vacation/Comp Time/Sick Leave Buy… 2,000.00 2,000.00 1,793.08 1,817.24 182.76 9.14 % 550-5200-6600 Workers' Compensation 271,074.00 271,074.00 1,600.79 9,320.41 261,753.59 96.56 % 550-5230-6600 Medicare 0.00 0.00 398.28 2,174.68 -2,174.68 0.00 % 550-5240-6600 Medical Insurance 0.00 0.00 9,399.84 49,261.74 -49,261.74 0.00 % 550-5250-6600 Retirement - CalPERS 0.00 0.00 2,928.14 16,907.49 -16,907.49 0.00 % 550-5255-6600 PERS Unfunded Liability Payment 0.00 0.00 0.00 51,098.75 -51,098.75 0.00 % 550-5260-6600 Uniform Allowance 0.00 0.00 75.06 75.98 -75.98 0.00 % 550-5500-6600 Department Supplies 40,000.00 40,000.00 5,083.87 17,470.57 22,529.43 56.32 % 550-5505-6600 Vehicle Fuel & Oil 25,000.00 25,000.00 1,309.10 13,754.54 11,245.46 44.98 % 550-5555-6600 Plant Chemicals 190,000.00 190,000.00 27,532.68 82,113.46 107,886.54 56.78 % 550-5557-6600 Lab Supplies 20,500.00 20,500.00 181.41 6,725.67 13,774.33 67.19 % 550-5715-6600 Vehicle Repairs 15,000.00 15,000.00 32.96 11,131.77 3,868.23 25.79 % 550-5719-6600 Information Technology 5,000.00 5,000.00 0.00 1,059.96 3,940.04 78.80 % 550-5720-6600 Equipment Repair 75,000.00 75,000.00 4,964.57 82,514.30 -7,514.30 -10.02 % 550-5730-6600 Alarm System Maintenance 1,500.00 1,500.00 84.00 168.00 1,332.00 88.80 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 19 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Percent
Remaining
Current
Total Budget
Period
Activity
Original
Total Budget
550-5740-6600 Building Repair and Maintenance 15,000.00 15,000.00 0.00 1,790.00 13,210.00 88.07 % 550-5766-6600 Bio solids Management 10,000.00 10,000.00 0.00 1,170.96 8,829.04 88.29 % 550-5770-6600 Percolation Pond 110,000.00 110,000.00 0.00 0.00 110,000.00 100.00 % 550-5900-6600 Tools & Small Equipment 4,000.00 4,000.00 180.14 1,357.11 2,642.89 66.07 % 550-6005-6600 Engineering Services 7,500.00 7,500.00 0.00 11.59 7,488.41 99.85 % 550-6015-6600 General Contracting 2,000.00 2,000.00 0.00 0.00 2,000.00 100.00 % 550-6025-6600 Professional Services 14,000.00 14,000.00 13,697.41 13,897.41 102.59 0.73 % 550-6035-6600 Personnel Services 1,000.00 1,000.00 0.00 729.24 270.76 27.08 % 550-6045-6600 Laboratory Services 17,000.00 17,000.00 16.50 8,505.24 8,494.76 49.97 % 550-6500-6600 Utility - Water 25,000.00 25,000.00 1,447.84 5,717.08 19,282.92 77.13 % 550-6505-6600 Utility - General & Electric 240,000.00 240,000.00 1,281.46 116,745.20 123,254.80 51.36 % 550-6605-6600 Lab Permit Fees 11,500.00 11,500.00 0.00 3,187.50 8,312.50 72.28 % 550-6612-6600 Permits 15,000.00 15,000.00 11,961.00 11,961.00 3,039.00 20.26 % 550-6630-6600 Fines Levied 50,000.00 50,000.00 0.00 0.00 50,000.00 100.00 % 550-6633-6600 Regulatory Compliance 20,000.00 20,000.00 0.00 4,150.29 15,849.71 79.25 % 550-7000-6600 Travel, Conferences & Training 6,000.00 6,000.00 700.00 1,547.81 4,452.19 74.20 % 550-7012-6600 Certification 2,500.00 2,500.00 0.00 760.00 1,740.00 69.60 % 550-7015-6600 Dues & Subscriptions 2,000.00 2,000.00 65.61 746.29 1,253.71 62.69 % 550-8000-6600 Capital Outlay 47,500.00 47,500.00 0.00 0.00 47,500.00 100.00 % Fund: 550 - Wastewater Fund Total: 1,669,906.00 1,669,906.00 111,970.96 674,583.95 995,322.05 59.60 % Division: 6600 - Wastewater - Treatment Total: 1,669,906.00 1,669,906.00 111,970.96 674,583.95 995,322.05 59.60 % Division: 6700 - Wastewater - Administration
Fund: 550 - Wastewater Fund
550-5100-6700 Wages 284,887.00 284,887.00 23,067.75 129,484.85 155,402.15 54.55 % 550-5165-6700 Wages Part Time 5,719.00 5,719.00 237.36 1,678.77 4,040.23 70.65 % 550-5170-6700 Overtime Pay 1,000.00 1,000.00 0.00 0.00 1,000.00 100.00 % 550-5180-6700 Vacation/Comp Time/Sick Leave Buy… 5,000.00 5,000.00 435.77 1,672.71 3,327.29 66.55 % 550-5200-6700 Workers' Compensation 129,909.00 129,909.00 567.86 3,113.81 126,795.19 97.60 % 550-5210-6700 P/T Retirement - VALIC 0.00 0.00 9.48 67.09 -67.09 0.00 % 550-5230-6700 Medicare 0.00 0.00 332.07 1,854.79 -1,854.79 0.00 % 550-5240-6700 Medical Insurance 0.00 0.00 4,680.92 27,394.00 -27,394.00 0.00 % 550-5250-6700 Retirement - CalPERS 0.00 0.00 2,061.59 11,858.60 -11,858.60 0.00 % 550-5255-6700 PERS Unfunded Liability Payment 0.00 0.00 0.00 26,382.90 -26,382.90 0.00 % 550-5500-6700 Department Supplies 24,000.00 24,000.00 1,448.20 11,708.78 12,291.22 51.21 % 550-5705-6700 Equipment Maintenance 3,000.00 3,000.00 198.97 1,595.01 1,404.99 46.83 % 550-5710-6700 Software Maintenance 6,800.00 6,800.00 0.00 7,060.59 -260.59 -3.83 % 550-5740-6700 Building Repair and Maintenance 2,000.00 2,000.00 59.00 348.00 1,652.00 82.60 % 550-5775-6700 Network Support 10,010.00 10,010.00 927.39 5,564.34 4,445.66 44.41 % 550-5780-6700 Web Maintenance 1,000.00 1,000.00 0.00 257.15 742.85 74.29 % 550-6000-6700 Audit Fees 7,200.00 7,200.00 0.00 2,927.70 4,272.30 59.34 % 550-6005-6700 Engineering Services 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 550-6025-6700 Professional Services 10,000.00 10,000.00 0.00 993.72 9,006.28 90.06 % 550-6035-6700 Personnel Services 500.00 500.00 0.00 143.39 356.61 71.32 % 550-6060-6700 Bank Fees 8,000.00 8,000.00 0.00 2,193.12 5,806.88 72.59 % 550-6061-6700 Credit Card Transaction Charge 26,000.00 26,000.00 0.00 9,541.20 16,458.80 63.30 % 550-6200-6700 Telephone 2,000.00 2,000.00 0.00 361.94 1,638.06 81.90 % 550-6205-6700 Cell Phones 3,000.00 3,000.00 243.85 1,401.23 1,598.77 53.29 % 550-6210-6700 Internet Service 5,000.00 5,000.00 58.36 350.16 4,649.84 93.00 % 550-6350-6700 Liability Insurance 104,630.00 104,630.00 0.00 20,000.00 84,630.00 80.89 % 550-6505-6700 Utility - General & Electric 5,000.00 5,000.00 0.00 1,571.06 3,428.94 68.58 % 550-6720-6700 County Property Tax 450.00 450.00 0.00 0.00 450.00 100.00 % 550-7000-6700 Travel, Conferences & Training 5,000.00 5,000.00 0.00 0.00 5,000.00 100.00 % 550-7015-6700 Dues & Subscriptions 0.00 0.00 0.00 101.00 -101.00 0.00 % 550-7800-6700 Bad Debts 7,500.00 7,500.00 0.00 0.00 7,500.00 100.00 % Fund: 550 - Wastewater Fund Total: 662,605.00 662,605.00 34,328.57 269,625.91 392,979.09 59.31 % Division: 6700 - Wastewater - Administration Total: 662,605.00 662,605.00 34,328.57 269,625.91 392,979.09 59.31 % Report Total: 14,652,278.00 14,652,278.00 924,526.35 6,735,245.21 7,917,032.79 54.03 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 20 of 24
Group Summary
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
Fun… Activity
Current
Total Budget
Original
Total Budget
Percent
Remaining
Division: 1000 - City Council
100 - General Fund 34,207.00 34,207.00 3,789.94 15,464.76 18,742.24 54.79 % Division: 1000 - City Council Total: 34,207.00 34,207.00 3,789.94 15,464.76 18,742.24 54.79 % Division: 1100 - City Manager
100 - General Fund 121,676.00 121,676.00 7,658.49 57,151.55 64,524.45 53.03 % Division: 1100 - City Manager Total: 121,676.00 121,676.00 7,658.49 57,151.55 64,524.45 53.03 % Division: 1150 - City Clerk
100 - General Fund 57,903.00 57,903.00 3,561.36 24,175.42 33,727.58 58.25 % Division: 1150 - City Clerk Total: 57,903.00 57,903.00 3,561.36 24,175.42 33,727.58 58.25 % Division: 1200 - Finance
100 - General Fund 190,376.00 190,376.00 11,853.04 81,575.24 108,800.76 57.15 % Division: 1200 - Finance Total: 190,376.00 190,376.00 11,853.04 81,575.24 108,800.76 57.15 % Division: 1300 - Legal Services
100 - General Fund 50,000.00 50,000.00 0.00 12,001.00 37,999.00 76.00 % Division: 1300 - Legal Services Total: 50,000.00 50,000.00 0.00 12,001.00 37,999.00 76.00 % Division: 1400 - Misc. Non Departmental
100 - General Fund 107,250.00 107,250.00 1,807.07 33,311.67 73,938.33 68.94 % Division: 1400 - Misc. Non Departmental Total: 107,250.00 107,250.00 1,807.07 33,311.67 73,938.33 68.94 % Division: 1500 - General Building
100 - General Fund 88,757.00 88,757.00 15,132.74 53,751.76 35,005.24 39.44 % Division: 1500 - General Building Total: 88,757.00 88,757.00 15,132.74 53,751.76 35,005.24 39.44 % Division: 1600 - Risk Management / HR
100 - General Fund 437,682.00 437,682.00 5,009.26 116,933.64 320,748.36 73.28 % Division: 1600 - Risk Management / HR Total: 437,682.00 437,682.00 5,009.26 116,933.64 320,748.36 73.28 % Division: 1800 - Tourist & Community Promotion
100 - General Fund 161,400.00 161,400.00 0.00 71,726.69 89,673.31 55.56 % 250 - FBID Fund 0.00 0.00 6,866.42 8,759.55 -8,759.55 0.00 % Division: 1800 - Tourist & Community Promotion Total: 161,400.00 161,400.00 6,866.42 80,486.24 80,913.76 50.13 % Division: 2000 - Police
100 - General Fund 3,187,858.00 3,187,858.00 243,005.35 1,662,609.65 1,525,248.35 47.85 % 101 - Transaction and Use Tax Fund 581,142.00 581,142.00 41,449.84 269,784.29 311,357.71 53.58 % 105 - Donations Fund 0.00 0.00 0.00 114.99 -114.99 0.00 % 180 - Asset Seizure Fund 20,000.00 20,000.00 0.00 19,747.01 252.99 1.26 % 183 - Every 15 Minute 2,800.00 2,800.00 0.00 0.00 2,800.00 100.00 % 186 - AB109 Realignment Pool Fund 30,000.00 30,000.00 0.00 1,481.49 28,518.51 95.06 % 188 - ABC GRANT 0.00 0.00 0.00 1,804.21 -1,804.21 0.00 % 189 - Measure Z Fund 315,537.00 315,537.00 25,108.84 154,378.80 161,158.20 51.07 % Division: 2000 - Police Total: 4,137,337.00 4,137,337.00 309,564.03 2,109,920.44 2,027,416.56 49.00 % Division: 2400 - Dispatch
100 - General Fund 538,022.00 538,022.00 44,089.55 250,954.27 287,067.73 53.36 % Division: 2400 - Dispatch Total: 538,022.00 538,022.00 44,089.55 250,954.27 287,067.73 53.36 % Division: 2800 - Animal Control
100 - General Fund 54,788.00 54,788.00 2,744.76 22,246.25 32,541.75 59.40 % Division: 2800 - Animal Control Total: 54,788.00 54,788.00 2,744.76 22,246.25 32,541.75 59.40 % Division: 2850 - K-9 Unit
101 - Transaction and Use Tax Fund 20,000.00 20,000.00 832.44 13,767.18 6,232.82 31.16 % 105 - Donations Fund 0.00 0.00 2,524.53 17,472.18 -17,472.18 0.00 % Division: 2850 - K-9 Unit Total: 20,000.00 20,000.00 3,356.97 31,239.36 -11,239.36 -56.20 % Division: 3000 - Building
120 - Development & Building Fund 280,298.00 280,298.00 18,786.82 136,891.92 143,406.08 51.16 % Division: 3000 - Building Total: 280,298.00 280,298.00 18,786.82 136,891.92 143,406.08 51.16 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 21 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
Fun… Activity
Current
Total Budget
Original
Total Budget
Percent
Remaining
Division: 3100 - Development Review
120 - Development & Building Fund 234,348.00 234,348.00 14,172.11 101,965.87 132,382.13 56.49 % Division: 3100 - Development Review Total: 234,348.00 234,348.00 14,172.11 101,965.87 132,382.13 56.49 % Division: 3200 - Planning
100 - General Fund 142,433.00 142,433.00 5,007.50 72,224.82 70,208.18 49.29 % 300 - Special Grants 0.00 0.00 0.00 23,097.55 -23,097.55 0.00 % Division: 3200 - Planning Total: 142,433.00 142,433.00 5,007.50 95,322.37 47,110.63 33.08 % Division: 4000 - Engineering
100 - General Fund 82,583.00 82,583.00 5,005.78 29,946.52 52,636.48 63.74 % Division: 4000 - Engineering Total: 82,583.00 82,583.00 5,005.78 29,946.52 52,636.48 63.74 % Division: 4100 - General Services
100 - General Fund 227,170.00 227,170.00 16,626.33 113,741.28 113,428.72 49.93 % Division: 4100 - General Services Total: 227,170.00 227,170.00 16,626.33 113,741.28 113,428.72 49.93 % Division: 4150 - TDA Ongoing Street Repairs
260 - TDA Non-Transit Fund 98,000.00 98,000.00 0.00 8,049.52 89,950.48 91.79 % Division: 4150 - TDA Ongoing Street Repairs Total: 98,000.00 98,000.00 0.00 8,049.52 89,950.48 91.79 % Division: 4200 - Streets Division
280 - Gas Tax Fund 409,114.00 409,114.00 25,965.23 185,155.16 223,958.84 54.74 % Division: 4200 - Streets Division Total: 409,114.00 409,114.00 25,965.23 185,155.16 223,958.84 54.74 % Division: 4300 - Storm Drain Maintenance
200 - Storm Drainage Fund 50,125.00 50,125.00 3,052.46 20,285.04 29,839.96 59.53 % Division: 4300 - Storm Drain Maintenance Total: 50,125.00 50,125.00 3,052.46 20,285.04 29,839.96 59.53 % Division: 4310 - Stormwater Management
200 - Storm Drainage Fund 33,500.00 33,500.00 6,650.00 27,644.55 5,855.45 17.48 % Division: 4310 - Stormwater Management Total: 33,500.00 33,500.00 6,650.00 27,644.55 5,855.45 17.48 % Division: 5000 - Transit System
590 - TDA Transit Fund 235,686.00 235,686.00 15,150.53 108,509.27 127,176.73 53.96 % Division: 5000 - Transit System Total: 235,686.00 235,686.00 15,150.53 108,509.27 127,176.73 53.96 % Division: 5050 - Public Transit
590 - TDA Transit Fund 168,700.00 168,700.00 0.00 168,659.00 41.00 0.02 % Division: 5050 - Public Transit Total: 168,700.00 168,700.00 0.00 168,659.00 41.00 0.02 % Division: 5300 - Recycling Division
210 - Solid Waste Fund 66,792.00 66,792.00 1,512.71 21,014.95 45,777.05 68.54 % Division: 5300 - Recycling Division Total: 66,792.00 66,792.00 1,512.71 21,014.95 45,777.05 68.54 % Division: 5400 - Recreation Programs Department
100 - General Fund 307,060.00 307,060.00 17,568.84 186,051.88 121,008.12 39.41 % 101 - Transaction and Use Tax Fund 182,108.00 182,108.00 8,512.50 121,491.40 60,616.60 33.29 % 105 - Donations Fund 0.00 0.00 0.00 2,113.68 -2,113.68 0.00 % 306 - Recycle-Parks 0.00 0.00 582.30 3,717.06 -3,717.06 0.00 % Division: 5400 - Recreation Programs Department Total: 489,168.00 489,168.00 26,663.64 313,374.02 175,793.98 35.94 % Division: 5450 - Parks Maintenance Department
100 - General Fund 601,685.00 601,685.00 38,740.92 289,973.96 311,711.04 51.81 % 101 - Transaction and Use Tax Fund 159,560.00 159,560.00 4,304.64 51,132.75 108,427.25 67.95 % 105 - Donations Fund 0.00 0.00 0.00 5,871.31 -5,871.31 0.00 % 110 - Rohner Rec District Fund 21,000.00 21,000.00 0.00 8,087.50 12,912.50 61.49 % Division: 5450 - Parks Maintenance Department Total: 782,245.00 782,245.00 43,045.56 355,065.52 427,179.48 54.61 % Division: 5500 - Library
100 - General Fund 14,524.00 14,524.00 786.16 5,796.53 8,727.47 60.09 % Division: 5500 - Library Total: 14,524.00 14,524.00 786.16 5,796.53 8,727.47 60.09 % Division: 5600 - Railroad Depot Museum
100 - General Fund 32,218.00 32,218.00 1,878.98 12,444.74 19,773.26 61.37 % Division: 5600 - Railroad Depot Museum Total: 32,218.00 32,218.00 1,878.98 12,444.74 19,773.26 61.37 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 22 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
Fun… Activity
Current
Total Budget
Original
Total Budget
Percent
Remaining
Division: 5610 - Museum Exhibit Acquisition
165 - Museum Exhibit Fund 7,250.00 7,250.00 292.11 995.95 6,254.05 86.26 % Division: 5610 - Museum Exhibit Acquisition Total: 7,250.00 7,250.00 292.11 995.95 6,254.05 86.26 % Division: 5700 - Monday Club
160 - Riverlodge Fund 9,650.00 9,650.00 164.94 3,609.08 6,040.92 62.60 % Division: 5700 - Monday Club Total: 9,650.00 9,650.00 164.94 3,609.08 6,040.92 62.60 % Division: 5800 - Riverlodge
160 - Riverlodge Fund 326,527.00 326,527.00 19,967.91 159,215.39 167,311.61 51.24 % Division: 5800 - Riverlodge Total: 326,527.00 326,527.00 19,967.91 159,215.39 167,311.61 51.24 % Division: 6000 - Water - Pumping & Treatment
500 - Water Fund 628,339.00 628,339.00 56,109.69 307,871.11 320,467.89 51.00 % Division: 6000 - Water - Pumping & Treatment Total: 628,339.00 628,339.00 56,109.69 307,871.11 320,467.89 51.00 % Division: 6100 - Water - Transmission & Distribution
500 - Water Fund 737,225.00 737,225.00 37,188.54 251,711.46 485,513.54 65.86 % Division: 6100 - Water - Transmission & Distribution Total: 737,225.00 737,225.00 37,188.54 251,711.46 485,513.54 65.86 % Division: 6200 - Water - Customer Account Expense
500 - Water Fund 88,915.00 88,915.00 5,728.38 40,169.14 48,745.86 54.82 % Division: 6200 - Water - Customer Account Expense Total: 88,915.00 88,915.00 5,728.38 40,169.14 48,745.86 54.82 % Division: 6300 - Water - Administration
500 - Water Fund 631,459.00 631,459.00 33,373.05 265,417.35 366,041.65 57.97 % Division: 6300 - Water - Administration Total: 631,459.00 631,459.00 33,373.05 265,417.35 366,041.65 57.97 % Division: 6500 - Wastewater - Collection
550 - Wastewater Fund 487,098.00 487,098.00 25,399.97 166,890.62 320,207.38 65.74 % Division: 6500 - Wastewater - Collection Total: 487,098.00 487,098.00 25,399.97 166,890.62 320,207.38 65.74 % Division: 6505 - Maint Dist Buena Vista Lift Station
670 - Rancho Bueno Vista Fund 6,114.00 6,114.00 0.00 138.91 5,975.09 97.73 % Division: 6505 - Maint Dist Buena Vista Lift Station Total: 6,114.00 6,114.00 0.00 138.91 5,975.09 97.73 % Division: 6510 - Maint Dist Kenwood Meadows Lift Station 671 - Kenwood Meadows Fund 8,254.00 8,254.00 0.00 280.44 7,973.56 96.60 % Division: 6510 - Maint Dist Kenwood Meadows Lift Station Total: 8,254.00 8,254.00 0.00 280.44 7,973.56 96.60 % Division: 6515 - Maint Dist Forest Hill Water Booster
672 - Forest Hill Water Booster Fund 23,310.00 23,310.00 264.79 1,540.44 21,769.56 93.39 % Division: 6515 - Maint Dist Forest Hill Water Booster Total: 23,310.00 23,310.00 264.79 1,540.44 21,769.56 93.39 % Division: 6520 - Maint Dist Forest Hill Retention
673 - Forest Hill Retention Basin Fund 6,005.00 6,005.00 0.00 0.00 6,005.00 100.00 % Division: 6520 - Maint Dist Forest Hill Retention Total: 6,005.00 6,005.00 0.00 0.00 6,005.00 100.00 % Division: 6522 - Maint Dist Dove Subdv Detention Basin
674 - Dove Subdivision Retention Basin Fund 1,071.00 1,071.00 0.00 0.00 1,071.00 100.00 % Division: 6522 - Maint Dist Dove Subdv Detention Basin Total: 1,071.00 1,071.00 0.00 0.00 1,071.00 100.00 % Division: 6524 - Maint Dist Gulliksen Storm Water Basin 675 - Gulliksen Maintenance Fund 2,398.00 2,398.00 0.00 0.00 2,398.00 100.00 % Division: 6524 - Maint Dist Gulliksen Storm Water Basin Total: 2,398.00 2,398.00 0.00 0.00 2,398.00 100.00 % Division: 6525 - Maint Dist Astor Drainage Assessment
676 - Astor Drainage Fund 2,837.00 2,837.00 0.00 0.00 2,837.00 100.00 % Division: 6525 - Maint Dist Astor Drainage Assessment Total: 2,837.00 2,837.00 0.00 0.00 2,837.00 100.00 % Division: 6526 - Maint Dist Astor Subdivision Lift Statio 677 - Astor Sewer District Fund 5,195.00 5,195.00 0.00 117.60 5,077.40 97.74 % Division: 6526 - Maint Dist Astor Subdivision Lift Statio Total: 5,195.00 5,195.00 0.00 117.60 5,077.40 97.74 % Division: 6527 - Maint Dist Wright Drainage Assessment A 678 - Wright Drainage District Fund 1,818.00 1,818.00 0.00 0.00 1,818.00 100.00 % Division: 6527 - Maint Dist Wright Drainage Assessment A Total: 1,818.00 1,818.00 0.00 0.00 1,818.00 100.00 % Division: 6600 - Wastewater - Treatment
550 - Wastewater Fund 1,669,906.00 1,669,906.00 111,970.96 674,583.95 995,322.05 59.60 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 23 of 24
Fiscal
Activity
Variance
Favorable
(Unfavorable)
Period
Fun… Activity
Current
Total Budget
Original
Total Budget
Percent
Remaining
Division: 6600 - Wastewater - Treatment Total: 1,669,906.00 1,669,906.00 111,970.96 674,583.95 995,322.05 59.60 % Division: 6700 - Wastewater - Administration
550 - Wastewater Fund 662,605.00 662,605.00 34,328.57 269,625.91 392,979.09 59.31 % Division: 6700 - Wastewater - Administration Total: 662,605.00 662,605.00 34,328.57 269,625.91 392,979.09 59.31 % Report Total: 14,652,278.00 14,652,278.00 924,526.35 6,735,245.21 7,917,032.79 54.03 % Budget Report For Fiscal: 2022-2023 Period Ending: 12/31/2022 1/10/2023 4:16:07 PM Page 24 of 24
Fund Summary
Fiscal
Activity
Variance
Favorable
Fund (Unfavorable)
Period
Activity
Current
Total Budget
Original
Total Budget
Percent
Remaining
100 - General Fund 6,437,592.00 6,437,592.00 424,266.07 3,112,081.63 3,325,510.37 51.66 % 101 - Transaction and Use Tax Fund 942,810.00 942,810.00 55,099.42 456,175.62 486,634.38 51.62 % 105 - Donations Fund 0.00 0.00 2,524.53 25,572.16 -25,572.16 0.00 % 110 - Rohner Rec District Fund 21,000.00 21,000.00 0.00 8,087.50 12,912.50 61.49 % 120 - Development & Building Fund 514,646.00 514,646.00 32,958.93 238,857.79 275,788.21 53.59 % 160 - Riverlodge Fund 336,177.00 336,177.00 20,132.85 162,824.47 173,352.53 51.57 % 165 - Museum Exhibit Fund 7,250.00 7,250.00 292.11 995.95 6,254.05 86.26 % 180 - Asset Seizure Fund 20,000.00 20,000.00 0.00 19,747.01 252.99 1.26 % 183 - Every 15 Minute 2,800.00 2,800.00 0.00 0.00 2,800.00 100.00 % 186 - AB109 Realignment Pool Fund 30,000.00 30,000.00 0.00 1,481.49 28,518.51 95.06 % 188 - ABC GRANT 0.00 0.00 0.00 1,804.21 -1,804.21 0.00 % 189 - Measure Z Fund 315,537.00 315,537.00 25,108.84 154,378.80 161,158.20 51.07 % 200 - Storm Drainage Fund 83,625.00 83,625.00 9,702.46 47,929.59 35,695.41 42.69 % 210 - Solid Waste Fund 66,792.00 66,792.00 1,512.71 21,014.95 45,777.05 68.54 % 250 - FBID Fund 0.00 0.00 6,866.42 8,759.55 -8,759.55 0.00 % 260 - TDA Non-Transit Fund 98,000.00 98,000.00 0.00 8,049.52 89,950.48 91.79 % 280 - Gas Tax Fund 409,114.00 409,114.00 25,965.23 185,155.16 223,958.84 54.74 % 300 - Special Grants 0.00 0.00 0.00 23,097.55 -23,097.55 0.00 % 306 - Recycle-Parks 0.00 0.00 582.30 3,717.06 -3,717.06 0.00 % 500 - Water Fund 2,085,938.00 2,085,938.00 132,399.66 865,169.06 1,220,768.94 58.52 % 550 - Wastewater Fund 2,819,609.00 2,819,609.00 171,699.50 1,111,100.48 1,708,508.52 60.59 % 590 - TDA Transit Fund 404,386.00 404,386.00 15,150.53 277,168.27 127,217.73 31.46 % 670 - Rancho Bueno Vista Fund 6,114.00 6,114.00 0.00 138.91 5,975.09 97.73 % 671 - Kenwood Meadows Fund 8,254.00 8,254.00 0.00 280.44 7,973.56 96.60 % 672 - Forest Hill Water Booster Fund 23,310.00 23,310.00 264.79 1,540.44 21,769.56 93.39 % 673 - Forest Hill Retention Basin Fund 6,005.00 6,005.00 0.00 0.00 6,005.00 100.00 % 674 - Dove Subdivision Retention Basin Fund 1,071.00 1,071.00 0.00 0.00 1,071.00 100.00 % 675 - Gulliksen Maintenance Fund 2,398.00 2,398.00 0.00 0.00 2,398.00 100.00 % 676 - Astor Drainage Fund 2,837.00 2,837.00 0.00 0.00 2,837.00 100.00 % 677 - Astor Sewer District Fund 5,195.00 5,195.00 0.00 117.60 5,077.40 97.74 % 678 - Wright Drainage District Fund 1,818.00 1,818.00 0.00 0.00 1,818.00 100.00 % Report Total: 14,652,278.00 14,652,278.00 924,526.35 6,735,245.21 7,917,032.79 54.03 %