INTERNAL SERVICE FUNDS
Attachment 8
Vehicle Replacement
Fund Summary - Fund 450
Fund Description / Budget Highlights
Fund Activity
FY 20-21 FY 21-22 FY 22-23 FY 23-24
Actual Actual Projection Proposed
Beginning Available Fund Balance 645,986 $ 270,915 $ Revenues
Charges for Services 159,000 $ - $ 148,300 153,000 Interest Income 700 3,700 - - Miscellaneous Revenues - - - - 159,700 3,700 148,300 153,000
Transfers In - - - - 159,700 3,700 148,300 153,000
Expenditures
Salary and Benefits - - - - Contractual Services - - - - Utilities - - - - Maintenance & Repairs - - - - Other Expenses - - - - Cost Allocation - - - - Capital Outlay 206,373 381 523,371 220,000 Debt Service - - - - 206,373 381 523,371 220,000 Transfer Out - - - - 206,373 381 523,371 220,000 Changes in restricted reserves
Net Annual Activity (46,673)$ 3,319 (375,071) (67,000) Ending Available Fund Balance 645,986 270,915 $ 203,915 $ By Department
Police 20,800
Public Works 108,872
Parks & Recreation 74,243
203,915 $
To account for the financing, operations, servicing and maintenance of fleet vehicles and major equipment utilized by City departments, of which the services are rendered on a cost reimbursement basis.
Attachment 8
Information Technology (IT) Operations
Fund Summary - Fund 460
Fund Description / Budget Highlights
Fund Activity
FY 20-21 FY 21-22 FY 22-23 FY 23-24
Actual Actual Projection Proposed
Beginning Available Fund Balance 365,515 $ 362,284 $ Revenues
Charges for Services 1,010,200 $ 736,313 $ 1,271,986 $ 996,333 Interest Income - 124 - - Miscellaneous Revenues 8,077 5,781 - - 1,018,277 742,218 1,271,986 996,333
Transfers In - - - - 1,018,277 742,218 1,271,986 996,333
Expenditures
Salary and Benefits 337,202 393,027 390,427 423,367 Contractual Services 18,800 78,430 30,000 30,900 Utilities 45,450 46,933 50,200 51,706 Maintenance & Repairs 273,612 320,020 386,550 422,380 Other Expenses 2,981 3,345 13,040 13,432 Cost Allocation 91,168 104,038 89,000 98,189 Capital Outlay 68,391 273,645 316,000 300,000 837,604 1,219,438 1,275,217 1,339,974
Transfer Out - - - - 837,604 1,219,438 1,275,217 1,339,974
Changes in restricted reserves
Net Annual Activity 180,673 $ (477,220) (3,231) (343,641) Ending Available Fund Balance 731,031 $ 362,284 $ 18,643 $ Allocate 50% to Facility Replacement Fund (365,516)
Ending Available Fund Balance, as adjusted 365,515 $
This fund accounts for Information Technology who provide a variety of technology related services for the city, including networking and infrastructure technology including servers, switching, security, cyber protection, internet connectivity, service desk, disaster recovery and other data communication technologies. Resources are from administrative charges to departments based upon their proportional share of program costs.
Attachment 8
Facility Maintenance
Fund Summary - Fund 470
Fund Description / Budget Highlights
Fund Activity
FY 20-21 FY 21-22 FY 22-23 FY 23-24
Actual Actual Projection Proposed
Beginning Available Fund Balance 361,695 $ 323,504 $ Revenues
Charges for Services 883,150 $ 817,040 $ 787,000 938,955 Interest Income - - - - Miscellaneous Revenues - - - - 883,150 817,040 787,000 938,955
Transfers In - - - - 883,150 817,040 787,000 938,955
Expenditures
Salary and Benefits 158,539 159,927 183,191 191,509 Contractual Services 13,883 10,842 180,000 185,400 Utilities 228,671 301,154 172,000 273,164 Maintenance & Repairs 68,043 100,577 169,000 174,070 Other Expenses 20,728 28,446 24,000 27,224 Cost Allocation 68,027 72,039 72,000 144,264 Capital Outlay - - 25,000 - 557,891 672,985 825,191 995,631
Transfer Out 440,643 - - - 998,534 672,985 825,191 995,631
Changes in restricted reserves
Net Annual Activity (115,384)$ 144,055 (38,191) (56,676) Ending Available Fund Balance 723,391 $ 323,504 $ 266,828 $ Allocate 50% to Facility Replacement Fund (361,696)
Ending Available Fund Balance, as adjusted 361,695 $
This fund accounts for Facility Maintenance provides and manages maintenance and emergency structural repair services for all City facilities. The source of revenue is reimbursement from departments for the cost of providing facility maintenance services.
Attachment 8
Information Technology (IT) Equipment Replacement
Fund Summary - Fund 480
Fund Description / Budget Highlights
Fund Activity
FY 20-21 FY 21-22 FY 22-23 FY 23-24
Actual Actual Projection Proposed
Beginning Available Fund Balance 365,516 $ 365,516 $ Revenues
Charges for Services - $ - $ - - Interest Income - - - - Miscellaneous Revenues - - - - - - - -
Transfers In - - - - - - - -
Expenditures
Salary and Benefits - - - - Contractual Services - - - - Utilities - - - - Maintenance & Repairs - - - - Other Expenses - - - - Cost Allocation - - - - Capital Outlay - - - - Debt Service - - - - - - - -
Transfer Out - - - - - - - -
Changes in restricted reserves
Net Annual Activity - $ - - - Ending Available Fund Balance - $ 365,516 $ 365,516 $ Allocate 50% to IT Operations 365,516
Ending Available Fund Balance, as adjusted 365,516 $
This fund provides for the replacement of government technology infrastructure and equipment used to support City's departmental needs (servers, switches, data security, etc.). The source of revenue is contributions from various departments for future replacement of computer and related technology equipment included in the program.
Attachment 8
Facilities Replacement
Fund Summary - Fund 490
Fund Description / Budget Highlights
Fund Activity
FY 20-21 FY 21-22 FY 22-23 FY 23-24
Actual Actual Projection Proposed
Beginning Available Fund Balance 361,696 $ 261,696 $ Revenues
Charges for Services - $ - $ - - Interest Income - - - - Miscellaneous Revenues - - - - - - - -
Transfers In - - - - - - - -
Expenditures
Salary and Benefits - - - - Contractual Services - - - - Utilities - - - - Maintenance & Repairs - - - - Other Expenses - - - - Cost Allocation - - - - Capital Improvement Projects (CIP) - - 100,000 142,000 Debt Service - - - - - - 100,000 142,000 Transfer Out - - - - - - 100,000 142,000 Changes in restricted reserves
Net Annual Activity - $ - (100,000) (142,000) Ending Available Fund Balance - $ 261,696 $ 119,696 $ Allocate 50% from Facility Maintenance Fund 361,696
Ending Available Fund Balance, as adjusted 361,696 $
This fund will be used to cover the major replacement of City buildings and facilities. The source of revenue is an annual contribution from various departments based on the square footage occupied.
Attachment 8