Loading...
HomeMy WebLinkAbout21-Finance CITY OF SAN BERN~DINO - REQUEST lOR COUNCIL ACTION From: VICTOR LORCH/ANDREW GREEN Subject: FIXED ASSETS AND INVENTORY Dept: RISK MANAGEMENT/FINANCE Date: OCTOBER 24, 19!n. Synopsis of Previous Council action: NONE Recommended motion: ADOPT RESOLUTION ~U~~D- Signature Contlct plrlon: Victor Lorch/ Andrew Green Phone: 5308/5242 Supporting dlt8 Ittlched: Wlrd: FUNDING REQUIREMENTS: Amount: Source: lACCr. NO. ))01-451-53150 -$50,500 lACCr. DESCRIPTION) Professional Contractual Flnence: (1\.....),...) D~ Council Note.: A ___....1_ 1..__ 1.1_ ,,2/ -.-' -....... .. . ~ ,..----------.- CITY OF SAN BER~RDINO - "EQUEST 2R COUNCIL ACTION STAFF REPORT '. Funding was included in the FY 1991-92 Budget for the development of a Fixed Asset Inventory program. The City of San Bernardino conducted the RFP (Request for Proposal) process for a Fixed Assets Inventory. Proposals were sent to 8 different firms of which only 3 responded. The 3 proposals were reviewed by a committee consisting of the Assistant City Administrator, the Director of Finance, and the Director of Risk Management. Based upon our review, we recommend that the Proposal of Marshall and stevens be accepted. The project will consist of the following: Inventory all contents of all City owned buildings and improvements that have been made in these buildings. Establish a cost record for accounting, auditing and financial reporting purposes. Establish an estimate of the total useful life of all buildings, improvements and contents. Coding of all buildings and assigned improvements and contents. Provide current reproduction costs of all items inventoried. Tagging of all City owned property. Produce a final report which consists of all fixed assets for the City of San Bernardino. Provide a means for updating the program on an annual basis utilizing City staff. Over the years, the city's Annual Financial Audit has been qualified due to the lack of a Fixed Assets Inventory. This inventory will eliminate this qualification on the City's annual financial audit. The City of San Bernardino has never had a Fixed Assets Inventory. In the early 1980's two CETA employees were hired to develop a program, however, this was never carried out. As a result, the City has purchased commercial insurance without substantiated values for contents, data processing, phone and other equipment for several years. In 1986, the city had all of its buildings appraised, but the contents and other City owned property was not appraised. These figures are necessary to update the City's values for insurance on an annual basis. By completing the Fixed Assets Inventory, we will be able to accomplish the following: Provide the city with better controls for safeguarding its investments and fixed assets. Establish the responsibility for custody and effective o o use of fixed assets. Substantiate, in addition to serve as a basis for determination of, the amount of grant funds used to finance expenditures for fixed assets. Detehnine the insurance needs and verify loss recovery in the event of a loss. A potential savings of approximately $50,000 in insurance premiums. Reduce the amount of theft of city property, since all items will be tagged and serial numbers recorded. Provide accurate charge back to Economic Development Agency for property premium. Eliminate qualif~cation on City Financial Statement for Fixed Asset Inventory. This will provide the City with a higher bond rating. A 1/4 point rating increase could equate to a potential savings of $20,000 on a $10,000,000 bond. Provide accurate information to FEMA in event of a major disaster to seek reimbursement of Federal Funds for damaged or destroyed City property. This Fixed Assets Inventory was a budgeted item as part of the fiscal year 1991-92. We budgeted $50,000 for this proposal. Once adopted by Council, the project can be started immediately and completed not later than 30 March 1991. 1 2 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 o o RESOLUTION NO. , RESOLUTION OF THE CITY OF SAN BERNARDINO AUTHORIZING THE EXECUTION OF AN AGREEMENT WITH MARSHALL & STEVENS, INCORPORATED, TO PERFORM A PERPETUAL FIXED ASSET INVENTORY OF THE CITY OF SAN BERNARDINO AND TO RECONCILE THIS INVENTORY TO ACCOUNTING POLICY AND PROCEDURES. SECTION 1. The Mayor of the city of San Bernardino is hereby authorized and directed to execute on behalf of said City an agreement with Marshall and Stevens, incorporated, to perform a perpetual fixed asset inventory for the city of San Bernardino 9 and to reconcile this inventory to accounting policy and procedures, which is attached hereto marked Exhibit "A" and incorporated herein by reference as fully as though set forth at length. SECTION 2. The authorization to execute the above referenced agreement is rescinded if the parties to the agreement fail to execute it within sixty (6) days of the passage of this resolution. / / / / / / / / / / / / / / I / / / / / / / Fixed .1l.SGets (, Inventory Nove:nber 12, ., OOi .... "" -. 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 - L 1 o o Resolution to adopt agreement with Marshall & Stevens for Fixed Assets and Inventory for the City of San Bernardino. I HEREBY CERTIFY that the foregoing resolution was duly adopted by the Mayor and Common Council of the City of San Bernardino at meeting thereof, held on the , 1991, by the following vote, day of to wit: Council Members NAYS ABSTAIN AYES ESTRADA REILLY HERNANDEZ MAUDSLEY MINOR POPE-LUDLAM MILLER The foregoing resolution is hereby approved this day of , 1991. w. R. HOLCOMB, MAYOR City of San Bernardino Approved as to form and legal content: JAMES F. PENMAN City Aitorney - /, By: /- .'-- ~. J.,-......... ,.~..~... 7 / ; / Fixed Assets & Inventory 2 November 8, 1991 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 o o A G R E E MEN T TaIS AGREEMENT is made and entered into this day of , 1991, by and between the CITY OF SAN BERNARDINO, a municipal corporation, 300 North 0 Street, San Bernardino, California 92418, (herein referred to as "City"), and Marshall and stevens, Incorporated, (herein referred to as "Consultant") 600 South Commonwealth, 7th Floor, Los Angeles, California 90005. City and Consultant agree as follows: 1. General. City hereby engages Consultant, and Consultant hereby accepts such engagement, to perform services herein described for the compensation herein provided. Consultant hereby assures and covenants to City that they have the qualifications, experience and facilities to properly perform said services, and hereby agrees to undertake and complete the performance thereof for the compensation herein provided. 2. Term. The term of this agreement shall commence on execution of this agreement by both parties. The term of this agreement is for the period of one (1) year, commencing from the date first set forth herein. 3. ~ Fee includes professional service, production and processing, travel and living expenses. Fee is payable by the Fixed Assets & Inventory 1 November 5, 1991 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 ~ ~ 24 25 26 27 28 ~ ~ - o o City as statements are submitted during course of th~ engagement. Approximately 80% of the fee will be billed prior to the deiivery of the reports, with the balance due after delivery as follows: Buildina Site Imorovements and Contents Fixed Asset Inventory $41,000 Property Records Manual $ 3,000 Land $ 3,000 Tags (25,000) $ 3,500 4. General Descriotion of Work to be Done. Consultant hereby agrees to perform the following services. A. Conduct a meeting with auditors for the City of San Benardino to establish that our inventory conforms to our capitalization policies. B. Produce a fixed asset inventory of the City of San Benardino's assets. This inventory will include: a. All equipment, buildings and improvements. All equipment-type movable items to be tagged and bar-code tagged by Marshall & Stevens. b. All city owned land. C. Produce a final report which consists of fixed asset inventory of the City of San Bernardino assets providing for each capital asset as follows: a. Fund b. Department Fixed Assets & Inventory 2 November 5, 1991 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 J! ..l ..L 1- - JL - o o Account original Cost Replacement Cost New Year Acquired Life Equipment Code Tag Number Location Code Description, plus make, model and serial number C. Produce a final report on a diskette or computer tape that us compatible with the city's computer system. 6. Reports bv Consultant. Reports shall consist of insurable values of values including assets by building location showing reproduction cost new, insurable reproduction, depreciated reproduction, depreciated insurable value, and exclusions. A computer report of assets by Department shall include machinery and equipment by site, department fund, asset description, including but not limited to: acquisi tion year, estimated useful life, replacement year, original cost, and current depreciation. Reports of land by site, parcel, description, use classification, acquisition date and original cost shall be provided. A magnetic tape or diskette containing a copy of our c. . d. e. f. g. h. i. j. 1. Fixed Assets & Inventory 3 November 5, 1991 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 ~ - o o inventory will be supplied. 7 . Amendments. This agreement may be amended or modified only by written agreement executed by both parties. 8. Assianment. Consultant's rights under this agreement shall not be assigned by Consultant to any other person, firm or corporation, unless specifically authorized herein, without the prior written consent of the City. 9. Attornev's Fees. In the event an action is filed by either party to enforce rights under this agreement, the prevailing party shall be entitled to recover reasonable attorney's fees in addition to any other relief granted by the court. 10. Terminated bv city. Notwithstanding any other provision of this agreement, the city, by notifying in writing, may terminate all or a portion of the services agreed to be performed under this agreement with or without cause. Consultant shall be given five (5) days written notice if termination is for other reasons. Notice shall be mailed posted to the address set forth herein for the receipt of notices. In the event of any termination, consultant shall have the right and obligation to immediately assemble work in progress and forward same to the City. All charges outstanding at the notice of termination shall be payable by the City to Consultant within thirty-five (35) days following submission of Fixed Assets & Inventory 4 November 5, 1991 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 l1li _ o o final statement by Consultant. 11. AcceDtance of Final PaYment Constitutes Release. The acceptance by Consultant of the final payment made according to the terms of t his Agreement shall operate and be a release to the City, and every employee and agent thereof, from all claims and liabilities to Consultant for anything done or furnished or relating work or services, or for any act or failure to act of the City relating to or arising out of work and this agreement. 12. Insurance. Consultant shall provide to city evidence of insurance covering Consultant and City as additional insured as to any potential liability to Consultant and city. The evidence to be provided shall be a Certificate of Insurance describing the coverage provided and naming the City as an additional insured. The insurance shall consist of the following: (a) Workers' Compensation. Consultant shall provide for all of its employees pursuant to this agreement. Evidence of such insurance shall be furnished to the Risk Management Division prior to commencement of this agreement. (b) Professional Liability Insurance. Professional liability insurance covering the professional service provided by Consultant, including coverage for professional errors and omissions in a combined single limit of not less than $1,000,000 per Fixed Assets & Inventory 5 November 5, 1991 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 o o person. 13. Hold Harmless. Consultant hereby agrees to, and shall, hold city its elective and appointive boards, commissions, officers, agents and employees, harmless from any liability for damage or claims for damage for personal injury, including death, as well as from claims for property damage which may arise from Contractor's agents or employees' operations under this agreement. Contractor agrees to, and shall, defend City, and its elective boards and appointive boards, commissions, officers, agents and employees from any suits or actions at law or in equity for damages caused or alleged to have been caused, by reason of any of the aforesaid operations, provided as follows: a. That City does not, and shall not, waive any rights against Contractor which it may have by reason of the aforesaid hold harmless agreement, because of the acceptance by City, or any of the insurance policies in paragraph 12 hereof. b. That the aforesaid hold harmless agreement by Contractor shall apply to all damages and claims for damages of every kind suffered, or alleged to be suffered, by reason of any of the aforesaid operations referred to in this paragraph, or regardless of whether or not such insurance policies shall have been determined to applicable to any of such damages or claims for damages. 14. Notices. , Fixed Assets & Inventory 6 November 5, 1991 o o 1 Any notices required to given hereunder shall be deemed to . 2 have been given by depositing said notice in the United States 3 mail, postage prepaid, and addressed as follows: 4 5 6 7 8 9 CITY Rachael Krasney, City Clerk city of San Bernardino 300 N. 0 Street San Bernardino, Ca. 92418 15. Entire Aareement. CONSULTANT Marshall and Stevens, Inc. 600 S. Commonwealth, 7th Floor Los Angeles, California 90005 This contract constitutes a portion of the Agreement between City and Consultant. The original Proposal, dated 10 October 7, 1991, is attached as Exhibit "A", and incorporated 11 herein as though fully setforth hereat. 12 IN WITNESS WHEREOF, this agreement has been executed 13 by the parties effective as of the date and year first above 14 written. 15 16 17 18 19 20 21 22 ATTEST: Rachel Krasney, City Clerk Approved as to form 23 and legal content: 24 25 26 27 28 JAMES F. PENMAN City ~ttorney By: _;.-_./ 'l_ ,~- ../ " ,....---: - -J .!"" Fixed Assets & Inventory CITY OF SAN BERNARDINO Municipal Corporation of the State of California W. R. Holcomb, Mayor CONSULTANT: By: Marshall and Stevens, Inc. 7 November 5, 1991 o o MARSHALL AND STEVENS - - - - - - -::~3,sers =~: .; :..a;:.::" ':::-5... :ar-:s 600 S. CrJmmonwesltn Ave. SUite 700 '-os Anaeles. ~ 90005-4017 ~2131 385-1515 "AX r2131 386-6911 October 7, 1991 Mr. Andrew Green Director of Finance City of San Bernardino 300 North "D" Street San Bernardino, CA 92418 Dear Mr. Green: Marshall and Stevens is pleased to present this proposal for appraisal and consulting services. The purpose of these services is to provide a perpetual fixed asset inventory to the City of San Bernardino to reconcile this inventory to your accounting policy and procedures. These services will include the following: I) A meeting with your auditors to establish that our inventory conforms to your capitalization policies. Produce a fixed asset inventory of the City of San Bernardino's assets. This inventory will include: o Ail equipment, buildings and improvements o City owned land AIl equipment-type movable itetns can be tagged with bar-coded tags by Marshall and Stevens. These tags can be acquired by ~arshalI and Stevens with the cost being added to your fee. Our final repon will consist of a fIXed asset inventory of City of San Bernardino assets. providing for each capital asset' the following: o Fund o Depanment o Account o Original Cost o Replacement Cost New o Year Acquired o Ute o Equipment Code o Tag Number (if applicable) o Location Code o Description, plus make. model, and serial number 2) 3) o o Mr. Andrew Green City of San Bernardino October 7, 1991 . Page two Marshall and Stevens' fee for these services is attached. AIl invoices are due and . payable on presen- tation and are subject to carryin~ charges of I 112% per month beginning one month from date of onginal invoice. Collection costs including legal fees and court costs, if needed, would be additional. If the tagging options should be elected, the cost of the tags will be at the most $3;500 for approximately 25,000 tags. 4) Enclosed are addendum which supply the following: o A summary of key points. o A detailed description of how our inventory and pricing will be completed for the buildings. o Some background information about Marshall and Stevens. o Attached as well is .a list of clients as requested and a summary of answers to issues from your R.F.P. We look forward to working with you on this important project. Very truIy yours, MARSHAlL AND STEVENS INCORPORATED ~~ Donald B. McDougall Valuation Consultant Government Services DBM:dmz SANBERNA:D Enclosures MlI\AlIIlJlI L AND STEVENS INCDAPORATED o o DESCRIPIlVE SECllON , MARSHALL ana STEVENS incorDOrallG o o PROPOSAL TO TIlE CITY OF SAN BERNARDINO FOR FIXED ASSET INVENTORY MaRSH"" AND STEVENS INCORPORAtED o 0 T ABT F OF CONTENTS Page No. I. PROJECT OBJECTIVES 1 II. PROJECT SCOPE 2 III. PlANNING. 3 IV. BUilDINGS AND IMPROVEMENTS (Other than buildings) 4 V. MACHINERY AND EQUIPMENT 8 VI. LAND 12 VII. UCENSED VEHICLES, MOBILE EQUIPMENT AND MINOR EQUIPMENT 13 VIII. REPORTS 13 IX. FEE AND DEUVERY 15 X. GENERAL 16 XI. ANNUAL VALUATION SERVICE 17 XII. ACCEPTANCE 18 MA. PiLl. AND SISVENB INCORPDRATED o o , I. PROJECTIVE OBJECTIVE ~ The proposed service will assist the City of establish a Fixed Asset Management System information for: San Bernardino to which will provide A. FIN G 1. Materiality Disclosure (Ref: Disclosure Guidelines for Offerings of Securities by State and Local Governments - GFOA) 2. Audit Compliance (Ref: AIeA. NCGNGAAFR) 3. GFOA Certificate of Excellence B. COST ACCOlJN'IING 1. Rate Setting 2. Program Cost Recovery (Ref: 74-4) C. CAPITAL EXPENDITURE PLANNING 1. Budget Request Substantiation 2. Capital Asset Improvements and Replacement Forecasting D. INSURANCE RPOUlREMENTS 1. Total Insurable Value 2. Specific Values 3. Coinsurance Compliance 4. Proper Rating 5. Proof of Loss Assistance 6. Perpetuation of Insurable Values E. ACCOUNTABILITY AND CONTROL 1. Responsibility and Custodianship 2. Operational Efficiency II. PROJEcr SCOPE A. Marshall and Stevens will implement a compre- hensive Fixed Asset Management System which will provide a verified record of all included fixed assets. M'lASt'Jl" AND STEVENS INCORPOAAlEI o o n. PROJECf SCOPE (coatinued B. Marshall and Stevens will provide an inventory, costing, valuation and the preparation of property accounting records covering buildings, improvements other than buildings, machinery and equipment. and land and underground. Assets or locations not specified therein could be included upon your specific authorization at an additional fee. C. Land parcels, licensed vehicles, formulators and mobile equipment will be included on the basis of data to be provided by Citv personnel. Marshall and Stevens will provide the forms and InstructiOns needed to complete them. A property records search is an option you may select. D. The system can be computerized and installed on Marshall and Stevens' computer for report processing. The Master File will be the City's property and will be available at any time the City is in a position to process at its own computer facility. E. Based on our prior experience, and our present understanding of vour requirements, the major steps in the implementation of your Fixed Asset Management System would be: 1. Project Planning (The Work Plan) 2. Inventory of Fixed Assets 3. CostinglValuation 4. lifinglCoding 5. Data Review 6. Data Processing 7. Annual Valuation and Consulting Services for Perpetuation of the System, if required. m. PLANNING A PLANNING 1. A project of this sIZe and complexity requires thought and planning to assure success. It is essential that the project have the support and commitment of all Department heads at the outset since it will require coooeration and an investment of their time. . IUIABllUAII AM" ~ 11W'YIDDII"IID4T'1;1"!1 o o Ill. PLANNING (continued) A PLANNING (continued) 2. However, the investment m time should be minimal. limited to the assemblage of cost records and construction and engineering data and the providing of access to areas to be included. 3. It is essential that one person be appointed to head the project for the City before commencement of any work and that a person be designated to continue the System after completion of the initial project. The appointee must have knowledge of property accounting. B. JOINT PLANNING 1. Our Project Manager would meet with you to finalize our property accounting principles and prepare a detailed work plan: a. Review asset accounting procedures, depr.eciation convention and method, useful life assIgnment procedures and set a cutoff date for inventory and costing. b. Review cost centers and chart of accounts and funds. c. Define codes to be used in the System. d. Review available cost records. e. Review the work schedule and establish procedures to gain access to security areas, locked rooms and to other areas where prior arrangements are required. f. Arrange for staff working space. 2. During the Planning Stage, pre-established report data will be reviewed: a. Content and format of input documents, i.e., inventory and property accounting source forms. b. The content of final property accounting and insurance reports. IV. BUILDINGS AND IMPROVEMENTS OTHER THAN BUILDINGS A INVENTORY 1. Documentation: Experienced and qualified appraisers of Marshall and Stevens' consultant staff will personally inspect. describe and compute measurements and areas of all buildings and improvements other than buildings. MIUllIlIALL AND STEVENS INCORIIORATm o o , IV. BUILDINGS f\ND IMPROVEMENTS OTHt;K THAN BUILDINGS (continued) A INVENTORY (continued) Building components (listed below) will be individually analyzed. a. Basic Structure Site Preparation Foundation Frame Exterior Walls Floor Structure Roof Structure Roof Cover Fire Protection Attached Exterior Construction b. Interior Construction Interior Construction Ceiling . Floor Covenng c. Suildin!!: Service Eauioment Plumbing Electrical Heating, Ventilating & Air Conditioning Elevators Improvements other than buildings generally consist of: a. Parking and exterior lightings b. Miscellaneous Structures - sheds, loading stations. etc. 2. Data to be recorded will include types of construction. dimensions, appunenances, occupancy and use, and insurance amounts. B. ORIGINAL COST RECORD/ACCOUNTING 1. To establish the necessary cost record for accounting, auditing and financial reporting purposes. Marshall and Stevens will establish an original cost record based on acquisition cost and date for each building and improvement other than buildings. Cost generally include: MIlASHIl" AND STEVENS INCORPORATED - o o IV. BUILDINGS AND IMPROVEMENTS OTHI!:K THAN BUILDINGS (continued) - B. O~IGINAL COST RECORD/ACCOlJNTlliQ (continued) a. Construction cost (or allocated purchase) b. Fixed equipment costs c. Architect's fees d. Inspection and other fees e. Cost of permits and licenses f. Applicable sales tax g. Insurance and interest during construction. if applicable h. Other incidental expenses 2. Original costs will be assigned on the basis of Citv records, provided that they are readily available. Various sources may be available: a. General Ledger, audits and other fmancial records b. Architect's request for payment documents c. Project files d. Reports issued to agencies such as HUD e. Inventory files, cards f. Maintenance records g. Purchase orders and invoices h. Capital improvement budgets 3. If the appropriate original cost data is not readily available or cannot be provided as described above, the normal original cost will be established bv Marshall and Stevens using the following method: . a. Determine current Reproduction Cost New and apply reverse cost trends to the date of acquisition. MaRSHall AND STEVENS INCORPORATED o o IV. BUILDINGS. AND IMPROVEMENTS OTHER THAN BURDINGS (continued) B. ORIGINAL COST RECORD/ACCOUNTING (continued) 4. An estimate of the Total Useful Life of each building or improvement will be made. This estimate, together with the estimated date of acquisitions, will be the basis for the ratio of expired life to remaining life to provide the depreciation reserves to date for applicable funds. In arriving at our opinion of Total Useful Life, consideration will be given to: a. The type, character and reasonable life expectancy under past and projected operating conditions relative to the designed use; b. Functional obsolescence and developing technology; c. External obsolescence and developing economic conditions in relationship to the use of the facilities; d. The City's history, policies or plans regarding capitalization of maintenance, major repairs or replacement of facilities. C. CODING 1. The following codes will be assigned to buildings and improvements other than buildinJs when supplied to our Project Manger by the City at the belrinmnl!: of this nroiect: a. Site Designations b. Building Number c. Departments d. Funds e. Accounts 2. This data must be furnished by the City in schedule form. D. CURRENT VALUATION 1. Current Reproduction Cost New information is required for (1) adequacy of property insurance coverage, (2) capital expenditure planning for replacement, and (3) maintenance decisions. IWYIIlHALL AND STEVENS INCDAPOAATED o o . IV. BUILDINGS AND IMPROVEMENTS OTHJ!:K THAN BUILDINGS (continued) ~. D. CURRENT VALUATION (continued) 2. Marshall and Stevens will utilize the following valuation procedures: a. Reoroduction Cost New - Each building and improvement other than building will be valued at Reproduction Cost New. Consideration will be given to labor material costs in the local area to replace the property in like, kind and quality, plus the indirect costs for architect's and engineers' fees, inspection fees, licenses, applicable sales tax, insurance and other incidents. b. Depreciated Reoroduction Cost - Physical deterioration and functional and external obsolescence, relevant for insurance purposes, will be observed and deducted to arrive at Depreciated Reproduction Cost. c. Exclusions and Insurable Values - In computing Insurable Values, the value of items specifically excluded from coverage in accordance with your present insurance policy will be deducted to arrive at Insurable Value. A copy of the current property insurance policy must be provided to Marshall and Stevens by the City prior to the start of the project. V. MACHINERY AND EQUIPMENT A. INVENTORY PROCEDURe 1. Verification: Experienced and qualified members of the professional staff of Marshall and Stevens wiIl conduct a field inventory of machinery and equipment owned bv the City. The assets will be listed by building and depanment of use in one of the following categories: a. Caoitalized Equipment - Individual Control Those equipment items (1) which can be identified by manufacturer, model and serial number and, as such, are identified from other like items; (2) have a unit original cost of $300 or more and (3) have a useful life in excess of one year, wiIl be listed individually. Generally, this classification includes business machines, major machinery and equipment, audiovisual equipment, lab equipment, communications equipment and maintenance equipment. MARSHALL AND STEVENS INCaAPORATEI ~ - o o V. MA~)' AND EQUIPMENT (continued) A ~NTORY PROCEDURE (continued) b. Caoitali7.ed Eouipment - Grouo Control Those equipment items (1) which are homogeneous and not individually identifiable, (2) mayor may not have a unit cost of $300 or more but the Citys' practice is to purchase in groups and capitalize the total group cost and (3) have an average group life in excess of one year, will be listed by homogeneous grouping by each year capitalized within each department location or fund. All furniture will be in this category. c. Minor Eouioment . Noncontrollable Those equipment items which are expensed for accounting purposes only will be grouped by building and department with a general description of the group. Generally, this classification includes miscellaneous office accessories. tools, shop general equipment and minor lab items. B. TAGGING 1. Should the City desire, Marshall and Stevens can place tags on all physically inventoried equipment. The cost of the tags would be additional to our proposed costs and should not exceed $3,500 we would recommend 25,000. C. ORJGINAL COST RECORD/ACCOUNTING 1. To establish the necessary cost record for accounting, auditing and financial reporting purposes, Marshall and Stevens will establish an original cost record based on acquisition cost and date for each individual machine or capitalized group. Costs generally include: a. Purchase or assembled cost b. Freight and installation c. Applicable sales tax 2. Original costs will be assigned on the basis of City records provided that they can be furnished at a centralized location assembled bv year acquired and bv department of responsibility.' . MARSHALL AND STEVENS INCORPORATED 1U . If ~ J - - o o v. MACHINERY AND EOUIPMENT (CODtinUed) - C. ORIGINAL COST RECORD/ACCOUNTING (continued) 3. If the appropriate original cost data is not available or cannot be provided as described above, the normal original cost will be established by Marshall and Stevens using one of the following methods: a. Research the normal cost at date of acquisition from our historical pricing records. b. Determine current Reproduction Cost New and apply reverse cost trends to the date of acquisition. 4. An estimate of the Total Useful Life of each item or homogeneous group will be made. This estimate, together with the estimated date of acquisition, will be the basis for the ratio of expired life to remaining life to rrovide depreciation reserves. In arriving at our opinion 0 Total Useful Life, consideration will be given to: a. The type, character and reasonable life expectancy under past and projected operating conditions relative to the designed use; b. Functional obsolescence resulting from changing conditions in relationship to use; c. External obsolescence resulting from changing economic conditions in relationship to use; d. The Citys' history, policies or plans regarding capitalization of maintenance, major repairs or replacement. D. CODING 1. The following codes will be assigned to Machinery and Equipment: a. Site Designation b. Building Numbers c. Departments d. Funds e. Accounts WASH"'" AND STEVENIlINCOAPORATBl .. . - ~ ~ !. - l o o '. V. MACHINERY AND EOUlPMENT (continued) D. CODING (continued) 2. In addition, Marshall and Stevens will apply its Qassification Codes to the following classes of property to provide increased information retrieval for special purpose reports. a. Office Machines and Equipment b. Office Furniture and Fixtures c. Machinery and Equipment d. Communication Equipment e. Non-Ucensed Vehicles f. Ucensed Road Vehicles E. CURRENT VALUATION 1. Current Reproduction Cost New information is required for (1) adequacy of property insurance coverage, (2) capital expenditure planning for replacement. and (3) maintenance decisions. 2. Marshall and Stevens will utilize the following valuation procedures: a. Reoroduction Cost New - Each item or group of capitalized equipment and each group of expensed equipment will be valued on the basis of Reproduction Cost New. b. Deoreciated Reproduction Cost - Physical deterioration and functional relevant for insurance purposes will be observed and deducted to arrive at Depreciated Reproduction Cost. c. Exclusions and Insurable Values - In computing Insurable Value, the value of items specifically excluded from coverage in accordance with your present insurance policy will be deducted to arrive at Insurable Reproduction Cost and Depreciated Insurable Value. VI. LAND A Marshall and Stevens completed a title survey of land within the boundaries of the City and market value study of a few years ago. Based on this studv and vears of acquisition supplied by the City, Marshall and' Stevens' can estimate this original cost at each parcel. MI\RSHAU AND STEVENS INCORPORATED -- . Ll - - - o o VI. LAND (CODtUaued) This option will supply values for each parcel. as prescribed by the G.F.OA VII. LICENSED VEHICT .ES, MOBILE EOUlPMENT AND MINOR EOUIPMENT A. licensed vehicles, mobile equipment and minor equipment such as mobile communication equipment should be included in the Fixed Asset Management System for insurance and accounting purposes as applicable. B. Due to the mobility of these assets, they are very difficult to inventory. For this reason, we will rely on listings provided by the City. We will spot check these lists and we will be responsible for data entry into the Fixed Asset Management System. vm. REPORTS A. Three complete sets of the original report will be furnished to the City, consisting of: 1. An appraisal certification specifying the date and purpose of our report. A general description of the assets included, techniques used to gather data and prepare reports and definitions of the terminology and codes used m the reports. A summary of the insurable values of included assets by building location and in total for the City showing: a. Reproduction Cost New b. Insurable Reproduction Cost c. Depreciated Reproduction Cost d. Depreciated Insurable Value e. Exclusions 2. 3. 4. A computer generated report of assets by Department which displays for each asset or group of assets: a. BUilDINGS. LV1PROVEMENTS OTHER THAN BUILDINGS. MACHINERY AND EQUIPMENT 1. City 2. Site Designation MARSHALL AND STEVENS INCORPORATED o o VIII. REPORTS (continued) 3. Building No. 4. Depanment 5. Fund 6. Class Code 7. Asset Description (Model No., Serial No.,Manufacturer when available on asset) 8. Asset No. (Computer Assigned) 9. Quantity 10. Acquisition Year 11. Estimated Useful Life 12. Replacement Year 13. Reproduction Cost New 14. Original Cost 15. Unrecovered Cost 16. Current Year Depreciation 17. Account b. LAND (as provided) 1. Site 2. Assessor's Parcel No. 3. Description. Size, Lot, Block, Tract 4. Use Qassification 5. Acquisition Date 6. Original Cost 7. Asset Number 8. Account 9. Depanment MARSH"" AND STEVENllINCORPORAlEI o o VllI. REPORTS (~DdDued) c. A magnetic tape or diskettes containing a copy of our inventory can be supplied as part of this assignment. IX. FEE AND DEUVERY A Our fees for services as described above are as follows: Buildin~ Site Improvements and Contents Fixed Asset Inventory Property Records Manual Land Tags (25,000) $41,000 $3,000 $ 3,000 $ 3,500 This fee includes professional services rendered, production and processing, and travel and living expenses. The fee would be payable by the City as statements are submitted during the course of the engagement. Approximately 80% of the fee will be billed prior to delivery of the reports, with the balance due after delivery. B. This fee is guaranteed for a period of 90 days. point we reserve the right to revise the fee escalating costs of personnel, travel and living expenses. Bevond this based upon X. GENERAL A All field notes and working papers prepared as a part of this engagement will remain on file with Marshall and Stevens for a period of five years after delivery of our reports. They will be available for reference should the City be challenged to substantiate an insurance claim or if needed in an audit of property accounts. A reconciliation will not be made between the results of this project and existing financial statements of the City due to the prior lack of recording retirements and the possibility of unrecorded additional through the years. After the Master File of Asset Data has been compiled, Marshall and Stevens' Computer Center could supply a variety of special purpose detailed or summary reports which could be obtained in advance as required. Typical Master File Data would include: 1. Location Data B. c. *Site *Building *Department Ml'R&Hjl.LL AND STEVENS INCORPORATED o o X. GENERAL (CODtinUed) 2. Descriptive Data · Asset Number · Asset Qass · Asset Description 3. Financial Data .Fund · Account Quantity Acquisition Cost · Anticipated Replacement Year Reproduction Cost New Insurable Reproduction Cost Depreciated Reproduction Cost Depreciated Insurable Value Depreciation Reserve Unrecovered Cost Current Year Depreciation D. All records, costs and values will be prepared as of a current date. XI. ANNUAL VALUATION SERVICE AND RF.PORTS A While the initial service proposed herein will provide an up-to-date property accounting record and valuation of the included assets as of a specific date, they become inaccurate unless the original data is kept current. B. The Annual Valuation Service keeps your reports up-to-date on an annual basis. 1. Property Accountinl!: Records Building and equipment changes, including additions, retirements and transfers are reflected in the annually updated property accounting reports. Current depreciation changes are calculated for Enterprise and Internal Service Funds. 2. Insurance Records Fluctuations in Reproduction Cost New of property in existence plus the efforts of additions, retirements and transfers are calculated to indicate the proper amount of insurance coverage required. Accurate records provide a basis for proof of loss. MARSHALL AND STEVENS INCORPORATED o o XI. ANNUAL VALUATION SERVICE AND REPORTS C. The Annual Valuation Service is a cooperative service. City personnel will provide us with the details of additions. retirements and transfers on forms which we will supply, along with an Instruction Manual. Marshall and Stevens will process this data to provide updated annual reports similar to the initial reports. XII. ACCEPTANCE This proposal is submitted in duplicate. You may signify your acceptance by endorsing one copy and returning it to my attention. The assignment will be scheduled and you will be contacted by our Project Manager within a timely period. Thank you for the opportunity to present this proposal to the City of San Bernardmo. We look forward to working with you in this important project. Very truly yours, MARSHAll AND STEVENS INCO ORATED /k#h DONALD B. McDOU Valuation Consultant Government Services DBM:dmz SANBERNA:D ACCEPTED BY:CI1Y OF SAN BERNARDINO Signature: Typed Name: Title: Date: M"RSIIAU AND STEVENlIINCDRPORATED o o '. SPECIFICATIONS FOR MARSHALL AND STEVENS PROPER1YRECORD SERVICE I. MARSHAlL AND STEVENS INCORPORATED agrees to furnish the following services to: City of San Bernardino A. ANNUAL SERVICE: At annual intervals, as of the close of your fiscal year, ADDmONSREPORT TRANSFER REPORT DELETION REPORT DEPARTMENT WITHIN FUND SUMMARY COST DEPRECIATION RESERVE UNRECOVERED COST CURRENT YEAR DEPRECIATION ACCOUNT WfmIN FUND SUMMARY COST DEPRECIATION RESERVE UNRECOVERED COST CURRENT YEAR DEPRECIATION DETA TT Fn PROPERTY LEDGER INSURANCE SUMMARY The reports will be processed, based upon: 1. The initial property record report of the assets prepared by Marshall and Stevens, 2, Subsequent data regarding additions, retirements, transfers or other changes to the property, submitted by you. Reporting forms and instructions will be provided by Marshall and Stevens. (Changes and/or additions in excess of 10% of the total cost of the property in anyone year must be verified by Marshall and Stevens' personnel. Time requirements for field verifications will be billable at standard per diem rates plus expenses. in addition to the basic retainer fee.) MMlIIl'1l11 AND ll1EIIENS INCORPORATED o o . SPEcmCATIONS FOR MARSHALL AND STEVENS PROPERlY RECORD SERVICE (Continued) 3. Analysis and application of price adjustment and depreciation factors for insurance purposes. CASUALTY LOSS SERVICE: In the event of a casualty loss. assistance will be rendered to establish a basis for a "Proof of Loss" claim including: 1. Consultation regarding any reports that may be required. 2. Preparation of a report covering the "loss area" providing insurable values as of the loss date; and/or if required, furnish a revised summary of all property covered by this service agreement. 3. Reasonable consultation with adjustors in valuation matters. If prolonged consultation with adjustors or coun testimony is required, a fee will be charged based upon our standard per diems, plus expenses. II. RETAINER FEE: The retainer fee, payable annually to Marshall and Stevens, will be $4,500 of the original appraisal fees. The retainer fee will be payable one year in advance of the repon date and it will cover all standard services and repon processing described herein. B. III. ADJUSTMENT: This agreement may be discontinued or service and fee adjustments made at annual intervals upon written notice to either party. MARBU"LL AND STEVENS INCDAPClRATEl o o ADDENDUM A In your RFP there were several issues which we feel are important to you. While these issues are addressed in our proposal, they are given special consideration in this section of our proposal. Marshall and Stevens is a stable, profitable and growing finn. We have been supplyin~ services to Cities since 1932. Our original MSF AMS software was the basIS for GFOA (then MFOA) fixed assets requirements. Our fixed asset surveys are still an integral part of the "Certificate of Excellence." Manoower Ms. O'Neil's qualifications are attached and she has personally worked with the Cities of Oxnard and Palmdale, both referenced as clients of ours. Ms. O'Neil's staff consists of over a dozen public sector specialists. To supply all of their professional qualifications would be voluminous EDP The qualification of Ms. Mary Lynn Pointier is also enclosed. Ms. Pointier is our Corporate Director and Vice President of Management Information Systems and has designed fixed asset systems for both PCs and mainframes. She is familiar with most all of the current commercially available fixed asset software packages. Our corporate data processing center is in Los Angeles. We have no problems meeting your insurance requirement. Comoanv Experience Arlene O'Neil and I have been working at Marshall and Stevens Incorporated as a team since 1984 and have proved services to hundreds of public entities. This element of stabihty is one of Marshall and Stevens' greatest strength. We have not changed names or companies. We have the staff, all full-time employees, to do this job. We will be there for the City of EI Segundo five or ten years from now, should you need our assistance to support a loss or update your inventory. The references attached are all for fixed asset inventories. all with parameters similar to yours. If you should have any questions, please give me a call at (213) 385-1515. MAIli'''l''' I AND STEVENS INCORPORATED o o RF.FERENCES City of Oxnard City of Santa Monica City of Palmdale City of Barstow City of Culver City Orlando Capulong Louise Baker Bill Ramsey Evelyn Randel Don Perlick Additionally, we have previously provided the following services to the City of San Bernardino. 1. Determination of Original Cost on all city owned construction. 2. Valuation of all construction for insurance purposes. 3. Valuation and identification of City owned land. we discovered over 200 parcels. many unknown to the City. MMSHALL. AND STEVENS INCOAPORATm o o ADDENDUM B All of the senior and middle level management involved in this project have been employed by Marshall and Stevens for five or more years. The qualifications of these senior staff are attached. Certificates of Insurance for both Workers Compensation and Errors and Omissions will be supplied upon authorization for Marshall and Stevens to proceed, we have in the past supplied this information to your City's Risk Manager. MARSHALL AND 5TEIIENS INCORPORATED - 41 - ~ - o o , ADDENDUM C In reviewing your R.F.P, there are several questions which we have answered below, while the answers are contained throughout the body of our proposal it seemed appropriate to summarize them here. 1. We will supply a special report to meet your insurance requirements. 2. We can work with Dames and Moore to meet specific requirements for a Seismic Loss Study, saving money for your City. 3. Our update fees will not increase by more than 10% over the next six years unless major additions or a reappraisal is needed. 4. Marshall and Stevens provides and produces our own tags, there will be no problem in delivery or quality control. MMIlIHIIII AND STEVENS INCORPORATm ~ ..I. 4 J - o PROPERTY SCHEDULE C:TY OF SAN BERNADINO Downtown Center DESCRIPTION CITY HALL CONVENTION CENTER DOWNTOWN GARAGE POLICE HEADQUARTERS SENIOR CITIZENS BLDG. CENTRAL LIBRARY CENTRAL CITY PARKING CENTRAL MALL City Yarci DESCRIPTION BLDG. ;flOO BLDG. #lOl BLDG. n02 BLDG. n03 BLDG. #ll4 BLDG. nl3 BLDG. #lll BLDG. U04 BLDG. HOS BLDG. U06 BLDG. #l07 BLDG. H09 BLDG. nos COVERED STORAGE BLDG. nlO BLDG. Ul2 BLDG. HlS BLDG. Ul6 BLDG. HlS BLDG. Ul9 o AI - L - lllI1 ~RO~ERTY SCHEDULE ::~y C5 SAN BERNADINO CUltural Cen~er DESCRIPTION CULTURAL CENTER ANNEX o Center For Individuals With Disabilities DESCRIPTION MULTI-PURPOSE BLDG. NORTH NORTON BLDG. Animal Control DESCRIPTION OFFICES FEMALE KENNEL FELINE KENNEL KENNEL City Cemetery DESCRIPTION TOOL ROOM LUNCH/RESTROOM PROPERTY SCHEC~LE ....~~'1f -.... Jt)SAN BERNADINO OFFICE Villasenor Library DESCRIPTION LIBRARY Fire station #1 DESCRIPTION FIRE STATION Fire station #2 DESCRIPTION FIRE STATION Fire station #3 DESCRIPTION FIRE STATION o '. PROPERTY SCHEDULE C:~y C:>S~~ BERNADINO Fire Station =14 DESCRIPTION FIRE STATION DRILL TOWER Fire Station #5 DESCRIPTION FIRE STATION Fire Station #6 DESCRIPTION FIRE STATION Fire Station =17 DESCRIPTION FIRE STATION SITE TOTALS o 'fROPl>R'I'V "'CU"'N'~ ':' _ ..... oJ ...__""'_ ..........., '--"'~ ~S~~ BERNADINO Fire Station #8 DESCRIPTION FIRE STATION Fire Station #9 DESCRIPTION FIRE STATION Fire station #10 DESCRIPTION FIRE STATION Search & Rescue DESCRIPTION SEARCH & RESctJE Comm. Maintenance o ?ROPERTY SCHEDULE C:~Y C:>SAN 3ERNAO:NO o . DESCRIPTION COMM. MAINTENANCE F. D. MAINTENANCE Wildwood Park DESCRIPTION MELTON CONCESSION CONCESSION/ANNOUNCERS RESTROOM PICNIC SHELTER/STORAGE RESTROOM DOTY CONCESSION DOTY RESTROOM Harrison canyon Park DESCRIPTION MAINTENANCE SLOG. Horine Park DESCRIPTION RESTROOM .J. . lb. rROPERTY SCHE:UU: _.-":JOAN aERNACI~O Patton Farm Park DESCRIPTION BARN H BARN :; 2 BARN :j 3 BARN :;4 Perris$ Hill Park DESCRIPTION POOL SLDG. CERAMICS PUMP &. BOILER CONCESSION STORAGE RESTROOM ROOSEVELT BOWL RESTROOM/STORAGE TENNIS PRO SHOP CODDINGTON LIBRARY HORSESHOE PREVENTION AGAPE HOUSE PISTOL RANGE RANGE STORAGE FISCALINI FIELD FIELD CLUBHOUSE Blair Park DESCRIPTION ...L _ - ..... o i PROPERTY SCHEDULE :::,:,y 0 SAN BERNADINO RESTROOM ELECTRICAL BLOG. CONCESSION/ROOM JAHNZ ANNOUNCERS BARTHA ANNOUNCERS ANNOUNCERS BOOTH Delmann Heiqhts Park DESCRIPTION NEIGHBORHOOD CENTER POOL BLOG. CONCESSION/RESTROOM Hudson Park DESCRIPTION RESTROOM Anne Shirrels Park Site 28 DESCRIPTION RESTROOM RESTROOM/CONCESSION Nicholson Park o PROPERTY SCHEDULE ::,:,y - oQAN BERNADINO o . DESCRIPTION RESTROOM ANNOUNCERS/CONCESSION FORCE FIELD CONCESSION CLUB HOUSE Seccombe Lake Park DESCRIPTION IRS BLDG. CONCESSION/RESTROOM GAZEBO PUMPHOUSE ELECTRICAL SLOG. Meadowbrook Park DESCRIPTION HERNANDEZ COMM. CENTER RESTROOM Nunez Park DESCRIPTION COMM. CENTER RESTROOM fRbPERTY SCHEDULE ,"'--'f ""'... - J o SAN BERNADINO RESTROOM/CONCESSION SNACK BAR RESTROOM/STORAGE Encanto Park DESCRIPTION BOY'S CWB RESTROOM/CONCESSION SCORERS Lytle Creek Park DESCRIPTION COMMUNITY CENTER STORAGE RESTROOM RESTROOM STORAGE Newark Park DESCRIPTION CONCESSION STORAGE o -PROPERTY SCHEDGLZ - -.-., 0 ~'" ____ . _.~1 o 3ERNAOI~O ~el ValleJo Rec~ea~:on Area DESCRIPTION ANNOUNCERS BOOTH RESTROOM Del Rosa Little League DESCRIPTION CONCESSION/ROOM STORAGE Highland Baseball Park DESCRIPTION NO. RESTROOM/CONCESSION NO. SCORES III NO. SCORES #2 SO. RESTROOM/CONCESSION SO. SCORES #3 SO. SCORES #4 SO. ANNOUNCERS (HOCKABAA) Guadalupe Field DESCRIPTION ?R6p~TY SCHEDULZ ::~Y~AN BERNADINO o CONCESSION/RESTROOM Winstead Park DESCRIPTION CONCESSION Palm Field DESCRIPTION CONCESSION Johnson Hall Recreation Center DESCRIPTION JOHNSON HALL Meadowbrook Recreation Center DESCRIPTION BOXING CENTER RESTROOM . ",ROPERT'i SCHEDUU: :::"! <:5 SAN BERNADINO Mill Center DESCRIPTION ADMINISTRATION CAFETERIA CLASSROOM KINDERGARTEN CLASSROOM RECREATION CENTER STORAGE TRANSFORMER POOL BLDG. SITE TOTALS Neighborly Services DESCRIPTION CLASSROOM BLDG. #1 CLASSROOM/RESTROOM BLDG. #2 J'unior Foot=all DESCRIPTION RESTROOM/DRESSING o Garden paper - 181 S. G Street IPR6FERT'! SCHEDULE ::,:,y =OSAN BERNADI~O o DESCRIPTION LIBRARY. Patton Park DESCRIPTION RESTROOM Senior Citizens Center - 780 E. 21st S DESCRIPTION SENIOR CITIZENS CENTER Sturqis Auditorium DESCRIPTION AUDITORIUM GAZEBO Fire Station - 450 Vander~uiltway DESCRIPTION PROPERTY SCHEDULE:::"! 0 SAN BERNADINO o DESCRIPTION WAREHOUSE OFFICE Gallo Flowers - 1505 Waterman DESCRIPTION RENTAL STORE Golden Valley Medical Supply DESCRIPTION FORMER FIRE STATION Employment , Training DESCRIPTION OFFICES Rowe Library - P~OPERTY SCHEDULE :::-Y (5 SAN BERNADINO o FIRE STATION La Plaza Park DESCRIPTION RESTROOM PERGOIA