Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
PACKET MAY 29 1984
AGENDA REGULAR SESSION OF THE CITY COUNCIL MAY 29, 1984 CITY COUNCIL CHAMBERS 1:15 P.M. � Invocation. � Pledge of Allegiance. � Roll call . i Proclamations. �r Consent Agenda. 1. A resolution awarding a bid for sanitary sewer improvements. 2. A resolution authorizing Change Order No. 2 and final payment to the contractor for sanitary sewer improvements, Sabine Pass Interceptor. :3. A resolution accepting an 8.10-acre tract of land for Dowlen Road right-of-way. 4. A resolution authorizing the extension of water and sewer services on property at 7395 Frint Road, approximately one-quarter mile outside the City limits in the extra-territorial jurisdiction area. 5. A resolution authorizing a study and master plan for the Henry Homberg Golf Course on Tyrrell Park. ,6. A resolution authorizing purchase of a remote control console radio for the Police Department. 7. A resolution authorizing the sale of surplus City-owned property. �B. A resolution authorizing purchase of sideloading refuse vehicles. 9. A resolution revising the contract with Underwood Neuhaus and Company for financial services on the City's drainage bond issue. 10. A resolution accepting a donation for the purchase of an acoustical shell for the Julie Rogers Theatre. 11. An ordinance confirming the appointment of a Police Chief. Other business. Hear citizens. Recess. RECONVENE FOR WORK SESSION. 1 1. May 25, 1984 Council Letter 517 Honorable Mayor and Members of City Council Subject: Award of Bid for Sanitary Sewer-Improvements Buds were received May 7, 1984, for Contract 15A Sanitary Sewer Rehabilita- tion. This is an Environmental Protection Agency federal participation 7:5/25 percent project. Estimated cost for the project was $1,233,000. Bids ranged from $771,477.55 to $1,188,577.00. This is the second phase of a project intended to reduce infiltration into existing sewer lines. The first phase of this project, which was completed in 1982, identified the principal problem areas in town by using remote TV cameras and other sensing devices. As can be seen from the attached maps, work will occur in some eleven separate areas. Work to be performed under this contract consists of replacing 15,184 feet of 6-inch through 12-inch sewer, slip lining 10,015 feet of 6-inch through 10-inch sewer and replacing 25 manholes. Slip lining consists of install- ing a polyethylene liner in the existing sewer line. This procedure is used where it is impractical to remove and replace existing sewers. Most of the work to be performed under this contract consists of rehabilitating sewers located in back lot easements. Many of the lines are beneath out-buildings, bushes and fences. A great deal of contractor cooperation and citizen patience will be required to accomplish this work. It is recommended that a contingent award, subject to Texas Department of Water Resources and Environmental Protection Agency approval , be made to the low bidder, Teal Contracting Co. , Inc. for the amount of $771,477.55. Local monies are available from our 1982 bond sale earmarked for these projects. The bids are as follows: Teal Contracting Company, Inc. $ 771,477.55 Sterling Utility Construction Company, Inc. 1,021,097.25 Baytown Construction Co. , Inc. 1,188,577.00 It is recommended this resolution be approved. Karl Nollenberger U City Manager AGEND A RT �tl NO- R E S O L U T I O N '= WHEREAS, on May 7 , 1984, bids were received for Contract 15A - Sanitary Sewer Rehabilitation; and, WHEREAS, Teal Constracting Co. , Inc. submitted a bid in the amount of $771,477. 55; and, WHEREAS, the City Council is of the opinion that the bid submitted by Teal Contracting Co. , Inc. is the lowest and best bid and should be accepted; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the bid of Teal Contracting Co. , Inc. be accepted by the City of Beaumont and the City Manager be, and he is hereby , authorized +to enter into a contract with Teal Contracting Co. , Inc. in the amount of $771,477. 55 for Contract 15A - Sanitary Sewer Rehabilitation subject to Texas Department of Water Resources and Environmental Protection Agency approval. PASSED BY THE CITY COUNCIL of the City of Beaumont this the day of 1984. Mayor - 2. May 25, 1984 Council Letter 518 Honorable Mayor and Members of City Council Subject: Change Order No. 2 and Final Payment for Sanitary Sewer Improve- ments, Segment 66, Sabine Pass Interceptor Sanitary Sewer Improvements Contract 5, Segment 66, Sabine Pass Interceptor, has been completed in accordance with plans and specifications. The project was funded with a 75/25 percent grant from the Environmental Protection Agency. The work performed under contract with Saucier and Sons Enterprises, Inc. consisted of installing a 36-inch gravity sewer from Harriot Street along Sabine Pass to Buford Street. The purpose of the sewer is to separate sani- tary flow out of the existing storm sewer in Sabine Pass Street and to re- verse the flow from the north to south, terminating at the Harriot Street Lift Station. This improvement will allow for the elimination of an existing major lift station located at Sabine Pass and Emmett Streets. Change Order No. 1, which dealt. with necessary changes in the depth of the lines to be installed, was previously approved by Council October 28, 1983. Change Order No. 2 is intended to adjust actual quantities of pipe and material installed, extra items of necessary work, adjust the contract completion date and, finally, to serve as the basis for final payment. The Change Order being considered consists of five separate items, as follows: Item No. 1 - Time extension of 52 days for weather Item No. 2 - Installation of two additional manholes + $ 3,850.00 Item No. 3 - Installation of 128 linear feet of 36-inch sewer + 22,784.00 Item No. 4 - Installation of Additional Hot Mix on Sabine Pass (100% local cost) + 4,895.00 Item No. 5 - Quantity adjustment on 29 separate items - 84,031.70 Total - $52,502.70 AA Council Letter 518 May 25, 1984 Page 2 Amount Time Original Contract $1,089,740.50 270 days Change Order No. 1 + 5,500.00 - Change Order No. 2 -52,502.70 + 52 days Revised Contract Amount $1,042,737.80 322 Days With these changes, the final payment due the contractor amounts to $70,967.32. The work has been inspected and approved and the project is recommended for ac- ceptance by staff. It is recommended that the resolution be approved. Karl Nollenberger City Manager '`ANGMAM db;-- 7±4 so — BUFORD RO Y11 L cr T b \ /CLAY (D I I /a N fli Aft P: CRAIG SHAM RO X %b r- IRMA 'TT7 1, TT c) JACKSC T- 4 FAY \ :.CAP GOO \ \` � - I d Q ul Z'' CMWARM�! I U) > 6111 --T z z w uj CL at M GOVI FIN tp ,- 0" -T71 INCOLN R ICK[ r" 'Ilk ARY 3 uj ST-i Z w LAW S O N Ti IL ra -rTTT ill L IV. E M I —--- I kp — ig — --FL0;T1E11s S'. > z LY 0 ,ODGE!4* :1 ul > -= —< — I ul SCHDX* - - W w .4 is w w > cr > > < BOLIVA —0 < 4 , -N �6' C l 10 SEGMENT 140. 66 iSTANTIN —I CONTRACT p 11 if Sc TIL� 5 I COMPLETE ) 2- 11-84 4 19, .11)ISO N! 1561' *10 ITI 17 !L 7-,'T 17-T :7"Tj 7-11T�F'-r7j I FT- 1_1 -7 1-100 n 14ee I k I LaLj I I I 4 DOI 'POBE All I LEE UA L 4 z- I < 1 4 — e — PARK -j am. /all T, 17 77-.T] F�RKLL AVE.] Tr 10 tj VK-) r c Di, )00 all I 1i L%4 T roil G 14 14 80 S tse9 ARR tur LD ;0 1 3. May 25, 1984 Council Letter 505 Honorable Mayor and Members of Cuty Council Subject: Dowlen Road Right-of-Way Donation The Official Street and Highway Plan, adopted by the City Council in 1973, includes Dowlen Road as an arterial street on a 100-foot right-of-way ex- tending southward to Walden Road. Dowlen Road was recently constructed from Calder Avenue to College Street with a railroad grade separation to provide reduced delays and increased convenience to citizens. The southern end of Dowlen Road, from College Street to Walden Road, does not currently exist and no right-of-way has been acquired. Mr. J. C. Chance, Jr. has offered to donate a portion of the right-of-way potentially needed for the future expansion of Dowlen Road. The tract of land includes 8.10 acres out of the C. Williams Survey and is located between Walden Road and the Lower Neches Valley Authority canal , as il- lustrated on the attached sketch. The tract would provide approximately 2,125 feet of the 100-foot wide right-of-way immediately north of Walden Road, and would provide half of the proposed right-of-way width along an additional 2,790 feet of the proposed arterial . The staff has examined the tract and found that it matches the right-of-way anticipated for the future extension of Dowlen Road. Mr. Chance is aware that acceptance of the donation does not constitute a commitment to build the road and the project is not currently funded nor is it anticipated for funding in the immediate future. It is recommended that this resolution be approved. �')'R N Karl Nollenberger City Manager P WASHINGTON 6LVD. M •�M^• !�-• !W ®1 141MV2�E l►0. r,�4 IC ROW�i Cow Gr = • • It NYA/ lAW Ann - - fYN�2 !�� Tin! IM•dr S•rwr• •�' , • , Crrenr+o• OC'ROw p Q Aorlp w4p, ArnrrMj ;— -� OR &flops+ L1ry/. A.v+ • • • • - 2.Ig1 Arows � fNr•�//7,A l Z war .-. • • w _ C J ,phi- J/I'MM ow • *Is • � � 1© Lam.E�erorwrrr 0 C i T • M. • C 1 • • 6141 / w`\ i •- 1 p•M fir••• h ll�s j� • �• • � to \ � Ei Xf►r�fdd'' R' I • • • • o \ 1 Ar s`•Orr'nw•° WALDEN . • ore,,—' ON i -5470303¢•E c••�•.�` � •,�` 6749 ✓ LOCATION PLAN vo ,fr' *•or er 1. 3 NOT TO SCAL£ D W a 0 a d � = f i� Ppp N � Nwt M w1•wwI r124 4 w + * 'r MODS/D L )aoo N�sa WALDEN RD. lvntrso-w -L� -sOrl�ow•, �--- PLAT OF AN 8.10 ACRE TRACT OUT OF C. WILLIAMS SURVEY , ABSTRACT 59 FOR THE PROPOSED DOWLEN ROAD R.O.W. F'rG�va/-eo� By.' elwa-iv TANS. Z;;L dw Z. R E S 0 L `U T I 0 N WHEREAS, Mr. J . C. Chance, Jr. has tendered an easement to the City of Beaumont, Jefferson County, Texas, for street and utility purposes as described in Exhibit "A" attached hereto; ,a nd, WHEREAS, the City Council has considered the purposes of said easement and is of the opinion that the acceptance of said easement for street and utility purposes is necessary and desirable and that same should be accepted; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT: THAT said street and utility easement tendered by Mr. J. C . Chance, Jr . to the City of Beaumont be, and the same is hereby , in all things accepted. PASSED BY THE CITY COUNCIL of the City of Beaumont this the day of 1984. - Mayor - s ; May 21, 1984 4. Council Letter 506 Honorable Mayor and Members of City Council Subject: Extension of water and sewer service to 7395 Frint Road GENERAL INFORMATION Applicant Larry Mills on behalf of Lamar Electric Status of Applicant property owner Requested Action extension of water and sewer service Purpose service to existing business Existing Zoning site is outside city limits in ETJ area Location approximately 1/4 mile outside city limits Comprehensive Plan non urban 13ee ANALYS I S er and Sewer Conditions for Extension of Wat Utilities. PLANNING STAFF RECOMMENDATION �:taff feels applicant has co mends approval of the request.plied with the 8 conditions and recom- PLANNING COMMISSION RECOMMENDATION IWT'ater ae Planning Commission recommended approval of the extension of and sewer utilities by a vote of 5 to 0. Ehe City Manager recommends approval of this ordinance. its, Karl Nollenberger City Manager cc: Sherell J. Cockrell, Planning Director IFCONDITIONS FOR EXTENSIO74 OF MATER AND SEWER UTILITIES 1) The proposed use of the property must be in accordance- with the City' s comprehensive plan. Applicant ' s property is in compliance with comprehen- sive plan. 2) The owner of the property must execute a contract for payments to the City in lieu of taxes. Applicant has agreed to contract for payments prior to annexation. 3) If the property to be served is in a utility district, the owner must either obtain deannexation of the property from the district or obtain a release from the district allowing the City . to annex the property. Correspondence from the West Jefferson County Municipal Water District on file in Planning Department releases the area in this request for service by Cityy of Beaumont. 4) The property to be served should be apprcpriate for annexation within seven (7) years. Staff will undertake annexation within the 7-year time period. `i) The City must receive satisfactory assurances that all con- struction will be in accordance with all utility construction regulations , codes and ordinances of the City. All construction will conform to applicable city codes . 6) Prior to approving extension of utility services , the City Council shall receive a recommendation from the Planning Commission. See "Recommendation. " 7) The development shall be located in the service area shown in City' s Certificate of Convenience and Necessity as approved by the Public Utility Commission of Texas. The City ' s 'Certificate of Convenience will include the subject property. 8) The extension of utility services shall not have an adverse effect on existing customers. Water Utilities Department has a 1 as not having an adverse effect onrexiisting customers . 9 ) The above guidelines will not apply to extension of service to a single-family dwellino, so long as such single-family dwelling is constructed in accordance with the codes of the City of Beaumont. The City Manager is hereby authorized to provide water and sewer service to a single-family dwelling. not applicable R E S O L U T I O N WHEREAS, Larry Miles, on behalf of Lamar Electric, has requested water and sewer service be extended to property located at 7395 Frint Road approximately one-fourth ( 1/4 ) mile outside the city limits in the extra-territorial jurisdiction area; and, WHEREAS, the city desires to extend water and sewer services to such property; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT: That the City Manager be, and he is hereby , authorized to extend water and sewer services to property located at 7395 Frint Road approximately one-fourth ( 1/4 ) mile outside the city limits in the extra-territorial jurisdiction area. PASSED BY THE CITY COUNCIL of the City of Beaumont this the day of 1984. - Mayor - May 25, 1984 5. Council Letter 513 Honorable Mayor and Members of City Council Subject: Master Plan for Henry Homberg Golf Course There is $40,000 budgeted for capital improvements to the Henry Homberg Golf Course on Tyrrell Park. There have been no major capital improvements made at the Golf Course for many years. After looking over the course and list- ing the needs, it became apparent that an engineering study needed to be made of the course and a master plan developed for golf course improvements. 'The Parks and Recreation Advisory Committee, at the January 16, 1984 meeting, recommended that an engineering firm be hired to do a master plan for the Golf Course. Four local engineering firms with some golf course experience were contacted and asked to present proposals. Three of the four firms re- sponded. The three proposals were: Bob Shaw Consulting Engineers $15,000 Kohler and Kohler 45,100 Schaumburg and Polk, Inc. 30,000 The bid proposals were evaluated by City staff and it is recommended that Bob Shaw Consulting Engineers, Beaumont, be employed to do the study and master plan for the Henry Homberg Golf Course on Tyrrell Park at a cost not to exceed $15,000. It is recommended that this resolution be approved. Karl Nollenberger City Manager .. ..r AGENDA ZM R E S O L U T I O N BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the City Manager be, and he is hereby , authorized to enter into an engineering contract with Bob Shaw Consulting Engineers to do a study and master plan for the Henry Homberg Golf Course at Tyrrell Park at a cost not to exceed Fifteen Thousand Dollars ( $15,000) . PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of _ 1984. Mayor - 6. May 25, 1984 Council Letter 509 Honorable Mayor and Members of City Council Subject: Purchase of Remote Control Console Radio On May 8, 1984, the City Council awarded the bid for a remote control con- sole radio for use by the Police Department to G. E. Company of Houston, 'Texas, in the amount of $17,633. On May 17th, the City received a letter 'from G. E. withdrawing their bid for this unit. The next low bidder for 'the radio equipment was Trinity Communications of Beaumont, with a bid of $20,000. The difference in cost between these two units is $2,367, and 'the Legal Department will be acting against G. E. for this difference. :ft is recommended that Council award the bid to the second low bidder, Trinity,Communications of Beaumont, in the amount of $20,000. Karl Nollenberger City Manager , . A R E S O L U T I O N WHEREAS, on May 8 , 1984, the City Council awarded the bid for a remote control console radio to General Electric Company of Houston, Texas in the amount of $17,633 ; and, WHEREAS, General Electric Company has refused to honor their bid; and, WHEREAS, the next low bidder, Trinity Communications of Beaumont, Texas, submitted a bid in the amount of $20 ,000 ; and, WHEREAS, the City Council is of the opinion that the bid submitted by Trinity Communications is the best bid and should be accepted; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the bid submitted by Trinity Communications in the amount of $20,000 for the purchase of a remote control console radio is ;hereby accepted by the City of Beaumont. PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of 1984. - Mayor - 7. May 25, 1984 Council Letter 516 Honorable Mayor and Members of City Council Subject: Sale of Jarrette Addition Property The Urban Transportation Department is currently studying alternative means of improving east and west access in the vicinity of IH-10 in an area bounded approximately by Calder, College, 11th and 23rd Streets. Alternatives being considered include such features as a grade separation of IH-10 in the vi- cinity of Laurel Avenue, roadway realignments and other concepts. Within this area, the City owns a 1,982.21 square-foot tract of land located on the south side of Phelan Boulevard approximately 80 feet west of 18th Street, which is the remainder of Lots 4 and 5 of Block 24 of the Jarrette Addition, as shown on the attached sketch. A 12-foot alley was closed in 1983, giving the City an additional 6 feet along the south line of this tract, which is included in the square footage total . The City's property was purchased for Phelan Boulevard right-of-way. Since there was such a small unusable remainder, the City acquired the entire tract. This un- economic remnant is incapable of being used independently as zoned and can be sold to the abutting property owner without being sold at a public bid. The owners of the property adjacent to this parcel have requested that they be allowed to purchase this remainder at a price of $3,964.42 for the 1,982.21 square-foot tract, a rate of $y per square foot. The owners plan to expand an existing building to provide additional leased office space as shown on the attached sketch. The property to be acquired will be used for parking. Since the alignments of the potential grade separation of Interstate 10 in the vicinity of Laurel Avenue and the impacts in the Phelan-Calder area have not yet been established, there is a reservation in the proposed deed that states if the City needs this property for right-of-way purposes within ten years of the date of purchase, the property will be sold back to the City for the original purchase price. City departments and utility companies have been notified and have no objections to the sale. It is the staff's opinion that the offer is reasonable and should be accepted. It: is recommended that a resolution be passed authorizing the City Manager to execute a deed conveying the 1,982.21 square foot tract of land to the abutting property owner in payment of $3,964.42. Karl Nollenberger City Manager � O « � r O � y i ® � MARRI L rVa - CAL Y � I Pit • LAUREL � u �0 ^ Location Map � :� � I"=200' _ music r a♦o West G • = r � co �p,N 28,0 0 2 2 I- ,! n o aj Gr3 L W (Y 1-- 25.0' 25.0' 25.0' U) c0 �..-. / f2-ALL-Ey(-CwSEDj 136.13 0 \ CD N AVOW A 12 filr1ury EAsEwNT 6 oo� Q o 136.13' W ,( N 7 �'\ 0 Z) _3 o w N J a U PROPOSED SALE OF CITY OWNED PROPERTY Part of Lots 4 8c 5, Block 24 of the Jorrette Addition PROPOSED SALE OF CITY OWNED PROPERTY Part of Lots 4 a 5, Block 24 of the Jarrette Addition y���' N�` c co c Q� �`<,�' �`�a X"V ,fir w � S � +• .•N t -a ,«fix I t QD Cr 0.. 10 q I 1.5' ��► n db`I4 4k`6 138.4 i ,I / SITG FL�.N / .LE A GITTTY� R E S O -L. U T I O N WHEREAS, the parcel of land described in the general warranty deed attached hereto as Exhibit "A" was originally acquired for Phelan Boulevard right-of-way purposes and is no longer needed by the City of Beaumont; and, WHEREAS, said parcel of land, because of its size and shape, is incapable of being used independently as zoned and is an uneconomic remnant and should be sold to the abutting property owner; and, WHEREAS, the abutting property owners are Gilson Viator .and Lucille West, of Beaumont, Jefferson County, Texas; and, WHEREAS, Gilson Viator and Lucille West have agreed to pay the City of Beaumont $3, 964. 42 for said property; NOW , THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the City Manager be, and he is hereby , authorized to execute, for and in behalf of the City of Beaumont, a general warranty deed in substantially the form attached hereto as Exhibit "A" and in consideration of $3 ,964. 42. PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of 1984. - Mayor - May 25, 1984 8. Council Letter 515 Honorable Mayor and Members of City Council .Subject: Purchase of Sideloading Refuse Vehicles On May 4, 1984, the City received bids on the purchase of five sideloading refuse vehicles to be delivered at the beginning of our fiscal 1985 year. As has been the case in prior years, we received separate bids from companies who bid only the cab and chassis and other firms who only bid on the packer bodies. Bids on the cab and chassis are as follows: Cost Per Unit Total Tidelands International , Beaumont $57,976.85 $289,884.25 American LaFrance Elmira, N. Y. 61,680.00 308,400.00 Five bids were received on packer bodies from the following vendors: Cost Per Unit Total Industrial Disposal , Houston $24,108.00 $120,540.00 Belgium Standard, Schaumburg, Illinois 22,201.00 111,005.00 Basic Waste Systems, Houston 24,878.00 124,390.00 Able Body Company Newark, California 21,100.00 105,500.00 Environmental Sales, Houston 23,960.00 119,800.00 The staff is recommending that the Council approve the bids of Tidelands International for five cab and chassis at $289,884.25 and the bid of Able Body Company for five packer bodies at $105,500.00. Additional costs on these units will be $1,100 each freight from Crane Carrier in Tulsa, Oklahoma to Newark, California, where Able Body is located, and back to Beaumont. This will result in an overall cost of $80,176.85 per unit for Council Letter 515 May 25, 1984 Page 2 these vehicles. This compares with $77,199 each as the purchase price of these vehicles last fiscal year. A part of this $2,978 increase came from revisions that the City made to our specifications to the brake system which resulted in an increased cost of approximately $1,100 per unit. As delivery was a problem on the vehicles that we received this fiscal year, the City has put a $100 per day per unit liquidating clause in our specifi- cations, and will impose damages if certain delivery dates are not met by the respective vendors. It is recommended that this resolution be approved. Karl Nollenberger City Manager . r f Y R E S O L U T I O N WHEREAS, bids were received for the purchase of five ( 5 ) sideloading refuse vehicles; and, WHEREAS, the following bids were submitted: Tidelands International -(Beaumont, Texas) 5 Cab Chassis - $289,884. 25 Able Body Company (Newark , California) 5 Packer Units - $105,500 and, WHEREAS, the City Council is of the opinion that the bids submitted above are the lowest and best bids and should be accepted; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT: THAT the bids of Tidelands International and Able Body Company in the amounts listed above for the purchase of five ( 5 ) sideloading refuse vehicles are hereby accepted by the City of Beaumont. PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of 1984. - Mayor - 9. flay 25, 1984 Council Letter 507 Honorable Mayor and Members of City Council Subject: Financial Advisory Contract The City has, at this time, a contractural arrangement with Underwood Neuhaus and Company, approved by Council in 1980, for financial advisory services on the $13 million remaining authorization for our street bonds glassed by the voters in 1980. As of this date, we do not have such a con- tract for the proposed $16 million drainage improvements issue. As we anticipate selling a combination issue for both street and drainage bonds, it would be reasonable to have the same financial advisor for both issues. Additionally, by revising the contract with Underwood Neuhaus to include the $16 million drainage improvement issue, the City will achieve a signi- ficant reduction in the overall cost of financial advisory charges. It is recommended that this resolution be approved. �L f"u-L�' Karl Nollenberger City Manager n 1 { r= TDA y j 3 R E S O L U T I-0 N WHEREAS, the City desires to amend its financial advisory contract with Underwood Neuhaus and Company to provide for financial services in connection with the sale of Sixteen Million Dollars ( $16 ,000, 000) in Drainage Improvement Bonds ; NOW , THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the City Manager be, and he is hereby , authorized to execute an amendment to the contract with Underwood Neuhaus and Company , a copy of which is attached hereto as Exhibit "A" , to provide for financial advisory services for the proposed sale of Sixteen Million Dollars ( $16 ,000,000) in Drainage Improvement Bonds. PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of 1984. Mayor - 10. May 25, 1984 Council Letter 512 Honorable Mayor and Members of City Council Subject: Julie Rogers Theatre Acoustical Shell The Julie Rogers Theatre for the Performing Arts has been well received by Beaumont' s performing arts organizations and their audiences, since opening -in October, 1982. The level of usage, approximately 175 event days per year, and attendance at these events, approximately 80,000 per year, is a good indication of the suitability of the Theatre for that type of use. However, there is a need to acquire a piece of equipment that will greatly enhance the quality of musical ensemble performances in the Theatre: a portable acoustical shell . Essentially, an acoustical shell is a devise ghat, when installed for musical ensemble performances, encloses on the sides, rear and overhead, the space occupied by performers. The shell serves as a blending chamber; it mixes the sound and projects it to the audience, and prevents dissipation of the sound. The shell also allows per- formers to hear themselves, and through subsequent small adjustments, im- prove the blended quality of the ensemble. Also, a shell provides a pleas- ing visual setting for a performance. An acoustical shell of the type that we consider most appropriate for the Theatre will cost approximately $60,000 to $70,000. There is approximately $20,000 available in the Theatre Construction Fund that can be used for the City portion of the cost. To complete funding for this project, Mrs. Carol Tyrrell Kyle has offered to donate $50,000 in two phases: $25,000 this year and $25,000 next year. A resolution accepting the donation from Mrs. Kyle is attached. It is recommended that this resolution be approved. Karl Nollenberger City Manager v Tr b{ R E S O L U T 1-0 N BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT: THAT the City Manager be, and he is hereby , authorized to execute an agreement with Mrs. Carol Tyrrell Kyle accepting the donation of Fifty Thousand Dollars ( $ 50,000) for an acoustical shell for the Julie Rigers Theatre for the Performing Arts and authorizing the purchase of such shell at a price not to exceed Seventy Thousand Dollars ( $70, 000) . PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of 1984. - Mayor - 11. May 25, 1984 Council Letter 519 Honorable Mayor and Members of City Council :Subject: Confirming Appointment of Police Chief An item has been listed on the May 29th Agenda which will provide for the confirmation of a Chief of Police for the City of Beaumont. Further informa- tion on the specific selection will be provided prior to the meeting. The Charter of the City of Beaumont and the Civil Service laws of the State of Texas have relevance to this appointment process. Most department head positions in the City are covered by the Charter provision as follows: Article. V, Section 3, Powers and Duties of the City Manager The powers and duties of the City Manager shall be as follows: Appoint and remove all heads of departments and all subordinate officers and employees of the City except as otherwise provided by this Charter and except as he may authorize the head of a department or office to appoint and remove subordinates in such department or office. The decision of the City Manager or other appointing officer shall be final and there shall be no appeal therefrom to any other office, body or court whatsoever. However, in this case, the Civil Service Laws 1269M also pertain. They read as follows: Article 1269M, Section 8, Fourth Para raph Said Chiefs or Department Heads shall be appointed by the Chief Executive, and confirmed by the City Council or legis- lative body except in cities where the Department Heads are elected. This item has been placed on the Agenda in hopes of having a selection made by the May 29th meeting. If no selection of a Chief of Police has been made by that time, the matter will be deferred. t� f�a Karl Nol1enberger City Manager i CONSENT AGENDA MAY 29, 1984 * Approval of Minutes. a. A resolution authorizing purchase of a carpet cleaner for the Library. b. A resolution authorizing purchase of two 6-ton air condi- tioning units for the Data Process Division. c. A resolution authorizing execution of a lease agreement with the Opportunity Industrialization Center of Southeast Texas. d. A resolution authorizing payment for rental of a bulldozer. c IMay 25, 1984 a. Council Letter 514 Honorable Mayor and Members of City Council Subject: Purchase of Carpet Cleaner On April 30, 1984, the City received five bids for the purchase of a carpet cleaner for the Library. The bids received on this unit ranged in price from a low bid of $2,154 to a high of $2,785, as shown below: Airwick, Houston $2,280.60 Kirby Sales, Beaumont 2,785.00 Chemical Products, Beaumont 2,568.00 Gulf Chemical , Beaumont 2,174.00 Sanitary Supply, Beaumont 2,154.00 Only the bid of Airwick Professional Products met the specifications issued by the City. The specifications called for the recovery tank to be 5-gallon capacity and removable for disposal . The other vendors' recovery tanks were all stationary with drain plugs. This specification is important for the unit's use in the Library because, without the removable recovery tank, the entire unit would have to be transported to the basement each time the tank became full . Gulf Chemical Company and Sanitary Supply bids were lower than the bid of Airwick, by up to $126. It is recommended that the bid of Airwick Professional Products of Houston, Texas, be accepted, in the amount of $2,280.60, as the only bid received meeting specifications. Karl Nollenberger City Manager ti a R E S O L U T I O N WHEREAS, bids were received for the purchase of a soil extraction unit; and, WHEREAS, Airwick Professional Products of Houston submitted a bid in the amount of $2 ,280. 60 ; and, WHEREAS, the City Council is of the opinion that the bid submitted by Airwick Professional Products is the best bid and should be accepted; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT: THAT the bid submitted by Airwick Professional Products in the ,amount of $2 , 280. 60 for the purchase of a soil extraction unit is hereby accepted by the City of Beaumont. PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of 1984. - Mayor - t 1 b. May 25, 1984 Council Letter 510 Honorable Mayor and Members of City Council Subject: Purchase of Air Conditioning Units The City received bids from six vendors for the purchase of two 6-ton capa- city air conditioning units for the Data Processing Division. The computer room at this point has a 5-ton air conditioning unit to cool that room. The wattage for all of the computer equipment in place in that room currently re- quires a maximum of 11 tons of cooling capacity. By purchasing these two El-ton units, with the 5-ton we currently have in place, we will have more than ample cooling capacity for the present and for any future growth in t:he system. Monies a,re available for this expenditure within the fixed assets line item in the Data Processing Division. Bids were received from the following vendors: United Southwest, Inc. $3,973.00 Lindy Dennis Air-Conditioning 3,866.00 Air Comfort, Inc. 4,742.60 Pierce Industrial Air, Inc. 5,230.77 Greson Technical Sales and Service, Inc. 3,275.34 Solar Supply, Inc. 3,940.00 It is recommended that the bid of Gr_eson Technical Sales and Service, Inc. in the amount of $3,275.34, be accepted. 4'L tjz"L&A_�\ Karl Nollenberger City Manager r �v R E S O L U T I O N ~ WHEREAS, bids were received for the purchase of two ( 2 ) air conditioning units for the Data Center; and, WHEREAS, Greson Technical Sales and Service, Inc. submitted a bid in the amount of $3 , 275. 34 ; and, WHEREAS, the City Council is of the opinion that the bid submitted by Greson Technical Sales and Service, Inc. is the lowest and best bid and should be accepted; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the bid submitted by Greson Technical Sales and Service, Inc. in the amount of $3 , 275. 34 for the purchase of two ( 2 ) air conditioning units for the Data Center is hereby accepted by the City of Beaumont. PASSED BY THE CITY COUNCIL of the City of Beaumont this the day of 1984. - Mayor - q c. May 25, 1984 Council Letter 508 Honorable Mayor and Members of City Council Subject: Execution of Lease Agreement This resolution would authorize the City Manager to enter into a lease agree- ment with the Opportunity Industrialization Center of Southeast Texas, Inc. The Opportunity Industrialization Center (OIC) has, in the past, leased one ruing of the Best Year' s Center on 4th Street as a training facility in which 'to conduct their business. Because of a lack of funding several years ago, 'the organization ceased using the facility. As this organization has again received funding, they wish to again lease this one wing, containing approxi- mately 2,733 square feet, from the City. OIC agrees to pay the City a monthly payment of $800, of which $600 per month is applicable to rent and $200 is applicable to utilities. OIC has used this space in the past to train people in various computer applications for absorption into the work f=orce. 't is recommended that this resolution be approved. k�Lz k n �^ Karl Nollenberger City Manager a ,� •�. �l'.i Arsua'r5 4� j.✓e?�°i� a i t�aa�i�a�.4 R E S O L U T I O N BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the City Manager be, and he is hereby , authorized to enter into a lease agreement with the Opportunity Industrialization Center of Southeast Texas, Inc. (OIC) , a copy of which is attached as Exhibit "A" , to lease a portion of the Best years Center with a monthly rental payment of Eight Hundred Dollars ( $800) . PASSED BY THE CITY COUNCIL of the City of Beaumont this the _ day of 1984. Mayor - d. May 25, 1984 Council Letter 511 Honorable Mayor and Members of City Council Subject: Payment for Rental of Bulldozer- Because of a fire at the landfill at 1846 Pine on November 27, 1983, it was necessary to rent a TD-15 Dozer for emergency purposes in extinguishing the combustible fire. The rental was necessary because the landfill equipment dozers Nos. 5019, 5046 and 5043 were not available due to needed mechanical repairs. Troy Dodson Construction Company was contracted for rental of the dozer for 16 hours. ITD-15 Dozer - 16 hours at $572/day $1,144 Move-in fee - 2 hours at $60/hour 120 $1,264 Because of the move to the new landfill , payment of the original invoice has been delayed. It is recommended that this resolution be approved. n Karl Nollenberger City Manager q r•1 ; 'ii r;\ kill R E S O L U T I O N BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF BEAUMONT : THAT the City Manager be, and he is hereby, authorized to pay Troy Dodson Construction Company One Thousand Two Hundred Sixty-Four Dollars ($1,264) for the rental of a TD-15 bulldozer for emergency purposes in extinguishing a combustible fire at the landfill on Pine Street on November 27, 1983. PASSED BY THE CITY COUNCIL of the City of Beaumont this the day of 1984. Mayor - WORK SESSION AGENDA MAY 29, 1984 CITY COUNCIL CHAMBERS 1. Discussion of Data Processing Study. W/S May 25, 1984. 1. Council Letter 520 Honorable Mayor and Members of City Council Subject: Long-Range DP Plan As John Naisbett wrote in his book "MegaTrends" we are truly in an information age. The City of Beaumont started into this information age in 1957, when our first computer was purchased. Since that time, computer usage has grown here within the City from that original batch system non-user interactive to our current on-line real time interactive system. To put the growth in data processing/management information systems into perspective, in 1979 the entire budget for the data processing applications of the city was X159,000. By way of comparison, the current year budget for our management information services is $756,000. This represents a 475 growth over that 5 year period. While we feel that this rapid growth in the budget for data processing is justifiable, the fact that we have a single department whose budget has grown to this extent while the rest of the city has been mandated to maintain little if any increases to their budgets immediately causes some concern. As of this date, we have taken the original computer that the city bought and are now in the final stages of removing the last operational system from it to our new computer network. When this conversion is complete, all 14 of the base systems that the City was operating will have been reprogrammed and placed on our new computer system. Along with this reprogramming of the systems, various enhancements have occurred in the systems making them much more user interactive. The information is much easier to obtain and overall the system is much more useful to the user. As this core of the city's financial and management systems are operational, the question to be asked is where do we go from here. This is the intent behind the development of a long range DP plan. This analysis will address such issues as: 1 ) a commitment to a central processor or a gradual conversion to a distributive processing network with everyone having their own mini-computer tied together to a network; 2) developing a framework for evaluating current and future departmental needs. In addition, the analysis will address our basic system's needs. The study will look at whether the current equipment is satisfying our needs and with the anticipated growth of the system what will need to happen to this ea uipment to satisfy those needs during the planning horizon of five years. This, of course, does not rule out any possibilities for change in the system. We will be looking not only at the current prime equipment we have to see if it will continue to satisfy our needs or whether we should move to some other main frame environment. If we 1 w decide to stay with prime, the study will address what the system configuration needs to be to provide adequate capacity for the various system's envisioned from this study. (MOWTH OF SYSTEM — HARDWARE AND SOFTWARE It seems somewhat of a truism that to understand where you need to go in the future you must understand where you were in the past. In this regard, we need to understand what data processing was and has became within the City of Beaumont. Prior to 1957, the only data processing the the City had was the calculator, pencil and paper. In 1957 the city purchased an IBM model 360. This was the first of IBM's third generation computers, the model 20. This was a single computing system or a single stem as it is called within the industry. This computer can process only one job at a time and had a total internal memory or core available to process these programs of 12,000 bytes. The only way to input data into this system was by the use of the punch cards. This was adequate for the city's needs in data processing terms for a. long period of time. In 1063 the city added two disk drives to this system and that was the total growth on this IBM system until 10RO. In terms of systems running on this IBM, the city had operating 14 computer systems and this constitutes the core of the city's financial information systems, all those base systems that the city must have in order to operate. Along with a. certain useful life for hardware, software or the programs to operate the systems has certain useful life also. The software that was operational on this IBM had been in place for approximately 15 years by the time we changed systems in 1980. With the system change in 1080 we also changed our software programs with respect to our basic financial management needs. Quite simply, our programs had not kept pace with our needs. We structured this bid proposal in 1980 such that the first needs of the city were a new package to operate its financial functions, its accounting, purchasing, and accounts payable system. Because of the limitations of our outdated 360, new software needs meant that we also needed a new computer to run this system on. This forced software dealers or program dealers to find what to them was the best system available to operate their software. This bid was structured in this manner because when all is said and done the main interest of the user revolves around the information he is able to receive from the system. Of secondary importance is what type of machine processes information. In taking the bids on these systems, we received approximately 13 bids from various hardware and software dealers. The Assistant Manager, Finance Director, and Data Processing Manager reviewed these bids and brought the 13 down to the ton 3 that we felt were there available to us. These top three were: the IBM System 34 with IBM software; an NCR machine operating a series of programs develored by the Moore Companies of Baton Rouge; and the Prime Computer system operating Price Waterhouse's financial information system. This committee then visited sites where these systems were operational to look at these systems and to see the outputs that they processed. The committee then reviewed all the proposals one more time and their recommendation was that the City buy the Price Waterhouse software running on the Prime Computer. 2 At the end of October, 1980, this Prime Computer was delivered and implementation was started with the financial package that we had purchased. Initially, in the accounting, purchasing, and accounts payable areas there were 10 terminals on line on this system. Work was immediately begun to start converting the systems that we had on the 360 over to the Prime. Since that time, 13 of the 14 systems running on the IBM have been implemented on the prime computer system with the final system, that of the water utilities billing system, scheduled to be operational on the prime in September of this year. A much more dramatic increase has occurred in the number of people requesting information from the system and also requesting the ability to log into the system and be on line with the data base. From that original 10 users, the city is now operating in an environment with 96 terminals and printers in a network around the city attached to our mainframe computers. These computers are currently configured with 3 1/2 million or megabytes of internal memory on one system and 300 megabytes of internal memory on the second system. Additionally, for on line storage there are 5 - 300 megabytes disks spinning at all times. This means that our current system has the capacity of 6 112 million bytes of internal memory to process jobs and 1 .5 billion bytes of external memory for storage. The largest new application that was not possible prior to our receiving this on line system that is now operational is our word processing network. Word processing is a fairly new technology to the City of Beaumont, but in 1981 the city purchased a centralized word processing computer software from Information Solutions of Houston and then began developing a network of word processing users throughout the city. Currently, there are 17 word processing stations all tied in to our central processing unit plus these 17 users have 5 letter quality terminals available for their outputs. The impact of all of these systems now operational is that of the 1 .5 billion bytes of memory storage capacity that we have on our disk drives some 60% or 900 million bytes is currently being used. When the water system becomes operational this year, we anticipate this usage to go up to at least 80�,' or 1 .2 billion bytes of usage. The data processing day itself has expanded. such that utilization of the central processor between the hours of 7:00 in the morning and 6:00 in the evening tends to average between 70 and 8014 of that system's capacity. This requires us to run a. second shift in data processing in the evenings to perform our major job functions and to perform backups on this system daily. With the final of the 14 core systems of the City operational on our on line network, it is our concern that we would be at capacity for our current system's configuration. We currently have the ability to serve 06 users with these two systems and with the water system's implementation, we have 96 devices attached to these 2 systems. STUDY TO BE PERFORMED Attached in your supplemental information is a, copy of the specification the city produced and sent to the various proposers on our list. We sent this proposal to fourteen potential vendors and asked them to put together a proposal and submit it to us by the end of April. These 3 r ' specifications break the study down into five distinct phases. First phase in the specifications could be characterized as "a study of the environment as it currently is". The outputs of this study will be data processing organization charts for departments, a cross reference of the -- systems currently in place and the interview notes to go to departments. Phase II of the study could be characterized as an information gathering and evaluation stage. During this phase the consultant will interview all city departments with an eye toward what their data processing needs a-re currently plus what their potential needs will be over the _five year planning horizon. The consultant will also review our current management information systems resources consisting of computer equipment and the various facilities we have for its applicability both currently and over the planning horizon. From this information, the consultant will provide us with an evaluation of the resources and staff of the management information systems, prepare a projected requirements for both computer equipment and staff requirements during the planning horizon and recommend various system profiles. These profiles could include the mainframe environment that we currently operate in or the distributive processing network that is currently in place in many organizations. Phase III of the proposal is basically one of evaluation. The principal output of this phase of the long range data processing plan project will be a priority ranking of all those systems identified as needs from the various departments within the City of Beaumont. Both phase TV and V of this program are to sum up the requirements listed earlier. A number of planning documents will be developed in these reports that will cane out of phase IV and V which will all be summarized as integral information building toward the final report which will be the long term management information services plan. Within this plan estimates of both resources reciuired and budgets required to implement the systems of those highly ranked needs addressed earlier will be formalized into various reports. During the 14 weeks that this study will take approximately 3 different meetings will occur on a formal basis with the data processing steering committee. These reporting times will give the consultants the opportunity to disseminate and for the committee to review the various outputs of the phases of this project. As was said previously, all of these reports culminate into the long range data processing plan. At the point this plan is complete we anticipate holding a workshop session with the city council to review the entire plan. This proposal is structured so that the hardware and software reauirements that are made as a part of this study will be out in time to incorporate into the fiscal 1985 budget process. THE FVALUATION PROCFSS Starting in early May, these proposals were received from six vendors to proivde the city with this long range systems plan. Copies of each of these proposals were given to every member of the data processing steering comittee. The data processing steering committee is a users group which controls the overall direction of management information services within the City of Beaumont. Seven departments are represented on the committee and these departments are: the Water Utilities 4 Department, the Health Department, the Fire Department, the City Clerk and Municipal Court, Urban Transportation, the Executive Department, and the Finance Department. Fach of these seven people evaluated these proposals based on the criteria that you have in your supplemental - information package. This criteria allowed a maximum of 100 points per proposal and all six proposals were to be evaluated by each member. This task was accomplished by the committee and then the committee net and recapped all of these point scores. Also in your supplemental information is a, copy of this recap sheet listing the scores from the six vendors evaluated by the committee. These scores run from a low score of 73 by Frnst and Whinny to a high score of 84.83 from that of Coopers and Lybrand. The top three proposers, Coopers and Lybrand, LWFW Group, and Peat, Marwick and Mitchell, were within a 2 point range. As these scores were that close, the committee invited these top three proposers in for an oral presentation on their proposals. All three of these vendors did come in on May 21 and held a one hour session with the committee on their proposal. After these meetings culminated, the conmittee then met to air their impressions of those proposals. It was the consensus of the committee that the best proposal was that of LWFW Group from Dallas and Houston. This is an independent consulting firm which has been in existence for some 27 years and their major focus is in governmental consulting. They are highly qualified to do this work as they have done this same project in a half dozen other governmental entities around this 5 state region. The project team that they have assigned to the City of Beaumont is a seven member team which incorporates expertise in every area that the city currently has applications. They anticipate the study taking between 14 and 16 weeks and they anticipate a minimum of 139 to a maximum of 153 ma.ndays to complete this work. CONCLTISI ON In conclusion, the committee is recommending that the proposal of LWFW Group be undertaken and they be employed by the city to perform this study for us. The estimated cost of this study would be a figure not to exceed $111 ,000. While this cost is certainly not negligible, the overall benefits that will be provided by this study are many. For the first time the city will know what direction it should be taking within the data processing environment and also have some idea of what the cost to implement some of those recommendations will be. Additionally, the training that the staff will receive in participating in this study will provide us with the opportunity to update this study annually and allow it to become a planning document similar to the five year capital improvement program that is updated annually. Also, the city currently has purchasd approximately $750,000 in computer equipment already and invested three years of staff time in systems development. From the staff perspective this study will allow the city to be able to plan our growth in a more orderly fashion rather than the system we have right now which basically is reactive as opposed to proactive. We would recommend that this study be funded from the fund balances available within the General Fund which can be expended per council directive for one time items. In summation, I would say that the economic axiom that human wants are insatiable has been proven to be true not only in consumption 5 but certainly within the City of Beaumont in the wants and desires of our departments for data processing services. This study will allow us to address those desires in a more orderly framework and also allow a better structure in which to deal with this highly complex issue. k2j i ,ice _ Karl Nollenberger City Manager 6 REQUEST FOR A PROPOSAL SPECIFICATION FOR MANAGEMENT INFORMATION SYSTEMS LANG-RANGE PLAN CITY OF BEAUMONT, TEXAS ♦ - F i (Bea L. �, U •�• P. O, BOX 3827 - 77704 FINANCE march 20, 1 0R4 To: All Proposers From: P. J. P'achlinger, Finance Officer Subject: T,onF Range Information Svstems Studv The City of Beaumont desires to have an independent third party come in and review our current data processing installation. This study in more detail is in the following., pages but essentially the end product desired will be a five year projection of data processing needs and equipment. This will he an organization—wide study which will entail m.anv detailed hours in field work by the consultant. For any auestions, you may contact either myself or John Kroesch, Management Information Systems Director and we will he happy to discuss in greater detail this proposal with vou. Sincerely, P. J. Nachlinger Finance Officer SPECIFICATION FOR PHASE I A. Definition of Information Requirement - Tasks 1 . Review of each Department Environment 2. Review of Current System and Functions 3. Identification of Major Information Requirements for Automated M.I.S 4. Evaluation of Current Systems to determine if they can meet additional information requirements. B. Definition of Phase I - Objectives 1. Gain an understanding of the departments business and develop a profile of the information flow within organizational units. 2. Gain an understanding of current manual and automated systems to conduct directed interviews and perform information gap analysis. 3. Identify all major critical success factors, key decisions, and information requirements necessary to support the departments tactical and operational plans. 4. Assess the capabilities and features of existing systems to meet and identify user information needs. 5. Identify application systems that are candidates for elimination. C. Definition of Outputs I. Departments Organization Charts 2. Matrix of summary and detail information type by departmental units. 3. A systems cross reference schedule. 4. Functional flow diagram of information within departmental units or divisions. 5. Application systems evaluation schedules. 6. Structured interview notes. 7. Document required, identify and catalog all major critical success factors, key decisions, and information requirements. SPECIFICATION PHASE II A. Definition of Application System Processional Tasks. 1 . Review of Current Management Information Systems resources/staff, computer equipment, and communications facilities. 2. Development of application system profiles. 3. Preparation of Project Documentation and definition. B. Definition of Phase II Objectives 1 . Translate information requirements into application system processes. 2. Identify required changes in M.I.S. management practices, organization structure, and resource allocation to support planned application system processes. 3. Prepare application profiles for all system development projects. Information to be gathered includes system development, and operational costs, output reports, displays, processing functions, files and dictionaries, interfaces and transaction volumes. 4. Categorize and develop a documentation of major projects that satisfy the information requirements and required M.I.S. infrastructure (or the underlying foundation of a system) improvements. C. Output and Findings I. Evaluation of M.I.S. staff and equipment resources. 2. Statement of projected M.I.S staff and computer resource requirement. 3. Suggested System Profiles Plan I 4. Catalog of Common and Integrated Application Systems 5. Documentation of Projects. SPECIFICATION PHASE III A. An Estimation of Resources Tasks 1 . Estimation of Personnel Resource Requirements 2. Estimation of Equipment Resource Requirements 3 . Initial Ranking of the Project Documentation B. Define Resources Objectives 1. For each project included in the documentation of major projects. a. Estimate system development, maintenance and operations personnel requirements and cost (USER and M.I.S.) using: 1. The coefficient of similarity technique. 2. The quantitative estimating techniques. 2. Estimate incremental computer equipment and data communications requirements and costs using system plans. a. Range each project based on overall cost and benefits. b. Determine the impact of the major projects in the documentation on the City's Management Information Budget. c. Prepare documentation of ranked system development projects. C. Resources Outputs I. Matrix evaluation of requirements system development resources using Plan 2. 2. Matrix evaluation of requirements impact on computing hardware capacity Plan 3. 3. Ranking scheme for each project using vector analysis technique Plan 4. 4. System development project priority ranking Plan 5. II REVIEW OF ALTERNATIVE STRATEGIES PHASE IV A. Develop task analysis of distributed versus centralized computer processing. I. Determination of the need to use data base management systems. 2. Analysis of communication network needs. B. Define Objectives of New Application Systems 1 . Their potential impact on the City's M.I.S. organization and strategy. 2. Determine how the prospective application system documentation may organizationally affect major M.I.S. activities such as system planning, development and maintenance, operation, etc. 3. Evaluate major M.I.S. strategic issues such as distributed vs. centralized processing: a. Use of data base management b. Use of communications networks. 4. Prepare recommendations based on the previous analysis and evaluation that will support the City's stated strategy and plans. C. Strategies Outputs 1. Application Assessment Plan 6 2. Data Base Management Assessment Plan 7 3. Communication workload Analysis Plan 8 4. Evaluation summary for each major strategic issue addressed. 5. Draft recommendations based on detailed analysis and evaluation. PREPARATION OF LONG-RANGE PLAN PHASE V A. Key tasks in the development of the final M.I.S. plan schedules. 1 . Development of the Final M.I.S. Long-Range Report. B. Final Objective summarize the results of Phase I to IV. 1 . Prepare the following supporting sub-plans of the Long-Range Plan. a. Information systems development and maintenance schedule. b. Information systems programmer and operations personnel staffing plans. C. Information systems financial plan (base on current prices) 2. Prepare Final Plan report and include statement of information and processing requirements a. Systems development plan b. Other sub-plans described above. C. Long-Range Planned Outputs 1. Detail long-range plan comprising sub-plans for major projects system development and maintenance. a. Including staffing requirements and budgets. 2. Final M.I.S. plan report including major findings and recommendations. 3. A statement of information requirements with the long-range plan. r CITY OF BEAUMONT Evaluation Criteria Weieht 1. Qualifications and experience of the firm in governmental long-range planning activities within the technical field, 20% 2. Personnel assigned to the Project (references/resumes) . 20% 3. Proposed methodology, approach to work plan, compliance with standards set in RFP, 20% 4. Technical proficiency in addressing problem, 15% S. Reasonableness of proposed fee. 10% 6. Ability to perform timely and quality work. 7. Time frame for developing solution/documentation. S,. 8. Financial stability of firm, 5"; CITY OF BEAUMONT Evaluation Recap Sheet Long-Range Data Processing Plan Maximum Points Evaluation Criteria C & L LWFW PM&M DH&S E&W 20 1. Qualifications and experience 18 18.83 18.5 16.33 15 16 20 2. Personnel assigned 17 18.33 16.83 16.83 13.5 15 20 3. Proposed methodology 17.16 17.16 16.5 16 16.66 15.66 15 4. Addressing problem 11 .5 10.83 11 .16 9.66 10.16 10.33 10 5. Fee 9.83 6.16 6.66 5.66 6.33 6.83 5 6. Timely and quality 4.16 4.16 3.83 3.83 3.83 3.33 5 7. Time frame 3 3.33 5 4.33 3.5 1 .66 5 8. Financial stability 4.16 4 4.16 4 4.16 4.16 100 Totals 84.83 82.83 82.66 76.66 73.16 73 CITY OF BEAUMONT Automated System Utilization Chart DEMOS COURT FMSO POLICE COURTS TRAFFIC FLEET M13MT WORD PROCESSING WATER DISTRICT INVENTORY SYSTEM A Prime F450-2 WATER UTILITY PLANNING PRIMENET WORD PROCESSING FINANCIAL CENTRAL COLL BUDGET RESEARCH FIRE ARSON ACCOUNTING SYSTEM B AUDITING FLEET mGMT WAREHOUSE INV ACCOUNTS PAYABLE FIXED ASSETS Prim 1-450-2 PURSING PERSONNEL INSURANCE SAFETY WITS PENDING SYSTEMS PAYROLL URBAN TRANS LAND LIBRARY ENGINEERING SANITATION CODE ENFORCEMENT ENVIR HEALTH LWFWG-roup 12700 PARK CENTRAL,SUITE 1805,DALLAS,TEXAS 75251,214-233-5561 April 30, 1984 Mr. R. J. Nachlinger Finance Officer City of Beaumont P.O. Box 3827 Beaumont, TX 77704 Dear Bob: This letter and attached proposal are in response to your March 20, 1984 request for "Development of a Long Range Information Systems Plan" for the City of Beaumont, Texas. LWFW is a twenty-seven-year-old management consulting firm offering services to a broad cross section of local government. The firm has offices in Dallas, Houston, and Fort Worth, Texas. We have a professional staff of experienced consultants representing specialties and disciplines relating to the management sciences, including: data processing, industrial engineering, organizational psychology, economics, and finance. Our firm is the largest member of the national Association of Management Consulting Firms (ACME) based in the Southwest. A major portion of LWFW's business has been working with local governments to assist management in improving the efficiency and effectiveness of internal operations and external services. Over the past decade, we have had the opportunity to become involved in almost every facet of local government operations. Several recent engagements with governments are: The City of Shreveport, Louisiana Police and Courts Information Needs Planning; Customer Information Planning and Software Selection Study Salt Lake County, Utah Management Information Strategic Planning The City of Denton, Texas Financial Review and Planning; Data Processing System Selection The City of La Porte, Texas Data Processing System Requirements, System Selection, and Implementation Management The City of Fort Worth, Texas Water Department: Operations Improvement and Systems Planning IPIROFESSIONALS SERVING MANAGEMENT DALLAS -FORT WORTH - HOUSTON Mr. R. J. Nachlinger April 30, 1984 Page 2 - We believe that our proposed combination of independence, experience, capabilities and expertise in dealing with data processing and financial operations qualifies us to work with the City of Beaumont. Our qualifications include: • Independence from any computer hardware vendor, software vendor, or service bureau. • An experienced project team composed of senior consultants, that has worked on similar engagements. • Recent experience in selecting and planning for data processing systems in both the public and private area. • Dedication to quality services, performed on time and within budget. Bob, LWFW has built a reputation for responsiveness and professionalism by meeting our clients' needs. The attached proposal provides a more in-depth presentation of LWFW and our approach to studies such as the City of Beaumont is about to undertake. Also, we have included an unbound copy of our proposal for any copies you might want to make. We would like to have the opportunity to provide our services to the City of Beaumont and are prepared, if asked, to discuss with you and the City's selection committee any aspect of the proposal. Thank you for your consideration, and if you have any questions regarding our proposal, please call me at (214) 233-5561. Sincerely, Ramond W. (Chip) Collins RWC/kc Enclosures PROPOSAL To Provide Consulting Services For Development of an Information Systems' I i Long - Range Plan i To The City of Beaumont, Texas I Submitted by: LWFW, Inc. Group , i April 30, 1984 i I i f � L-----LWFW Groiip TABLE OF CONTENTS Page I. Background and Objectives . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 II. LWFW Qualifications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 III. LWFW Study Team i . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 IV. Study Approach . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Phase I: Identify Management Information Requirements . . . . . . . . . . . . . . . 19 iPhase II: Review :Management Information Systems (MIS) . . . . . . . . . . . . . . . . 23 I Phase III: Develop Resource Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Phase IV: Review Potential (Alternative) Information Processing Strategies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 j Phase V: Prepare a Long-Range Information Processing Plan . . . . . . . . . . . . . 28 V. Study Time Frame and Cost 29 j Appendices I A: Resumes of Study Team Members B. Summary of Recent Governmental Studies i I i I I I I i -LWFW GVolif) I. BACKGROUND AND OBJECTIVES L.WFW, Inc. Group is pleased to submit our proposal to the City of Beaumont, Texas, for providing consulting services in the development of an information systems long-range plan. The results of this study will provide an objective basis for the City's use in resolving future activities relating to information processing such as budget i authorizations, staffing levels, and technical directions. Approximately three years ago, the City of Beaumont decided to acquire a new, automated financial accounting system. At that time the City maintained an information processing system based on an IBM 360 Model 20 computer. The City anticipated that the new system would be adequate for the next five years. That anticipation proved to be incorrect. The system selected three years ago was a PRIME I - 1000 computer utilizing financial software supplied by the accounting firm Price Waterhouse & Co. The implementation of the system was successful, but one year later another PRIME computer was purchased to satisfy the then current demand upon Management Information Systems (MIS). Today, MIS maintains two PRIME 450 computers with ninety-six (96) devices attached to them. Most of the City's information and word processing needs are achieved with these systems, including software development. Also, the City still maintains the IBM 360/20 for utility billing. The goal of moving the utility billing function to the PRIME systems is October 1, 1984. Since the strong potential exists for another computer Upgrade or acquisition within the next twelve months, the City has decided to develop a long-range information processing plan for the next five years and has requested professional, third party assistance in developing the plan. A primary objective of this long-range plan will be to provide City management with a i formalized approach to information processing. The plan should enable city management to: • Plan for expenditures and resource requirements for information processing. • Identify high priority information needs within the City operations. • Provide guidance to City personnel regarding their various departments/divisions status for information processing. • Plan for the structured/controlled growth of the City's information processing systems. 1 I i —LNVFW Group -1- During this study the consultants will: • Identify the information needs of City departments/divisions. • Evaluate the current data processing situation within the City as regards: - Levels of user satisfaction with data processing service. - Capability of data processing to achieve current and future City information needs (including the policies affecting the utilization of microcomputers). - Cost effectiveness of information processing systems currently in place. • Identify alternative data processing strategies for the City. • Develop and recommend a practical data processing strategy for the City, including the approximate expenditure levels for that strategy over a three - five year period. )We have found that these tasks are best accomplished with active input from City personnel. Accordingly, we have planned for the active involvement of City personnel in collecting needed information and in participating in several workshop sessions to i identify, evaluate, resolve alternatives, and develop the plan. j i In addition to these objectives and tasks, our experience with other municipalities and I discussions, with Messers. Bob Nachlinger and John Kroesch has suggested two additional parameters which, if accepted by the City, will significantly impact the study approach: I 1) A study team consisting of senior, experienced LWFW consultants will be used on this study. 2) The development of information processing alternatives (strategies) will emphasize the retaining of the City's significant investment in the PRIME computers and City developed application software. 1 The remainder of this proposal includes LWFW's qualifications to conduct the study and a i discussion of the proposed study approach. i I I i I -LWFW GI-Olf!) -2- I H. LWFW QUALIFICATIONS LWFW, Inc. Group is a 27-year-old management consulting firm with offices in Dallas, Houston, and Fort Worth, Texas. We have a professional staff of over twenty experienced consultants representing specialties and disciplines relating to the management sciences, including data processing, industrial engineering, organizational psychology, economics, finance, and accounting. LWFW Group is the largest Southwest-based member of the national Association of Management Consulting Firms (ACME), and subscribes to the rigorous ethical standards of the association. We provide services to both the public and private sectors on a national level, and our clients include some of the nation's largest corporations, as well as a broad cross section of local governments. i During the past decade a major portion of LWFW's business has been working with city and county governments to improve efficiency and effectiveness of their internal operations and external services. We believe the experience gained from working with every aspect I i of local governments provides our firm with the following key qualifications to successfully perform this systems planning study: • Development of an experienced project team whose members have worked together on many of the municipal data processing studies presented below in the Relevant Studies subsection. Each member of the team is a senior level consultant and will actively participate in this study. • Significant experience working with municipal and county governments. This experience has provided us with relevant working and practical knowledge of municipal operations. r • Development of data processing plans, including identification of needs and detailed analysis of potential acquisition strategies for several governmental entities. These plans included: I Communication with hired, appointed and elected governmental officials. i - Defining and identifying the costs associated with potential strategies for acquisition and implementation of municipal information and communication systems. • Selection of data processing systems for municipalities from 15,000 to 250,000 in population, each with different needs and levels of data processing capabilities. • Review and analysis of over one hundred vendors of application software for municipalities during the past three years, therefore providing our consultants '—LwFw Groifr) -3- with current, comprehensive knowledge of available software for municipalities of all sizes. Included within the analysis were several vendors using Prime Computers and application software developed to run on Prime. } • Independence from any computer hardware and/or software vendor. i The experience gained from several recent engagements is relevant to this proposed study, and for this reason they are summarized in the following subsection, Relevant Studies. Also, a more comprehensive list of governmental engagements is presented in Appendix B. Relevant Studies I?ach of the following engagement summaries includes contact information for reference purposes. City of Shreveport, Louisiana Police and Courts :Jim Keyes, Finance Director Information Systems Specification (318) 226-6350 and Planning Study o Detailed System Design I LWFW recently completed a study for the City of Shreveport, Louisiana to specify new information systems for police and court activities, including a new computer- j aided dispatch system. Included was an emphasis on utilizing the City's IBM 4300 computer. I I o Development and Assessment of Alternative Data Processing Strategies After specifying the City's needs in these areas, developing detailed alternative data processing strategies, and screening available software packages, LWFW recommended that the city obtain predeveloped software rather than develop the systems in-house. I j o Recommendations Regarding Management and Operational Method During this study, LWFW consultants worked closely with police management to j identify over 200 existing reports in the current record keeping and information systems which require considerable effort to produce and maintain. i o Implementation of System An implementation plan was prepared which will streamline and simplify the existing record keeping system, and provide more timely and useful information to the department. i i —LWFW Group -4- City of Denton, Texas Chris Hartung, City Manager Data Processing System (817) 566-8200 Evaluation and Planning Study o City Government Data Processing Planning LWFW was engaged by the City of Denton, Texas to evaluate their data processing activities and develop a plan to strengthen data processing for the City. The existing applications included financial accounting, payroll, utility billing and collection, tax, inventories, equipment maintenance, and library. o Development and Assessment of Alternative Data Processing Strategies LWFW surveyed all departments to identify deficiencies in the current systems and new applications requirements, and developed alternate strategies to achieve these objectives. I o Mainframe and ;Minicomputer Use During this engagement, the City's Data Processing Departments and equipment were also critiqued and recommendations for improvements developed. o Communication with Non-Technical Management and Officials The data processing plan was accepted by the City Council and implemented with LWFW assistance. I ON Soliciting and Evaluating Bid Proposals This plan included developing a Request for Proposal for a new computer system and selection of new application software. ! o Implementation of System i An IBM 4300 DOS/VSE computer system was selected, a data processing department was created, and the system was implemented. I City of Abilene, Texas Ed Seegmiller, City Manager Data Processing Planning, (915) 676-6000 Systems Selection, and Implementation o Assessment of Needs LWFW was engaged to evaluate the City's automated systems needs and to select and implement systems to meet these needs. Special emphasis was placed on financial and management systems needs, including financial accounting, utility systems, payroll, performance measurement, and tax, although the long-range plan which was developed included engineering analysis, planning and land use, and public safety related systems. 41 Soliciting and Evaluating Bid Proposals During this study LWFW conducted an extensive survey of financial accounting, performance measurement, and payroll system packages, assisted the City in selecting packages, and supervised the implementation of packages developed by American Management Systems. I I —LWFW Groat) -5- • Minicomputer Use and Data Processing Management The study also involved evaluating the organizational and management requirements of the data processing function. • Implementation of System t- LWFW assisted the City with the successful implementation of the new system. Salt Lake County, Utah Bob Boulrice, Director Administration Management Information System (801) 537-7337 Requirements and Data Processing Review 1 i • Mainframe Computer Use and Data Processing Management LWFW completed a major study of the Data Processing Division of Salt Lake I County, Utah. This study included an in-depth review of the management of the division, the hardware and software environment, and user needs. I • Data Processing Planning The result of this study was a three- to five-year plan for county data processing, j which included detailed recommendations and schedules for improving the technical resources available within Data Processing to meet a comprehensive systems plan adopted by the County Commissioners. � s City of Duncanville, Texas Dan Dodson, City Manager Management Information Needs and (214) 296-1401 Data Processing System Selection Study I ' • Assessment of Needs + LWFW was engaged to identify the information needs of the City, prioritize these needs, and present a recommendation to the City. • Soliciting and Evaluating Bid Proposals LWFW prepared a Request for Proposal for a data processing systern capable of achieving the identified needs, evaluated the vendor responses, developed an j implementation plan, and made a recommendation to the City. 1 • Implementation of System This engagement was successfully completed in July 1981. Since then a contract has been negotiated and installation is over 75% complete. ! i i I I i LWFW Group -6- Grayson Governmental Data Center Talmadge Buie, City Manager City of Sherman, Texas Evaluation of Data Center and (214) 892-4545 Development of a Data Processing Plan • Assessment of Needs The Grayson Governmental Data Center is a cooperative effort among the Cities of Sherman and Denison, Denison Independent School District, and Grayson County, Texas. The Data Center has been in existence for eight years, and recently the four owning entities selected LWFW to conduct an evaluation of the Data Center and its major user's needs, plus develop a data processing plan for the Data Center and each owner. to Mainframe Computer Use Consultants from LWFW evaluated the Data Center's staff, documentation, application software, and computer hardware. • Communicating with Non-Technical Staff iIn parallel with the Data Center evaluation, extensive interviewing of management personnel at each owning entity was completed to determine the levels of user I satisfaction and information needs. I j 40 Development of General Data Processing Plans The data gathered was reviewed and integrated, resulting in detailed data processing strategies and plans for each owning entity. o Communicating and Working with Non-Technical :Management Work sessions were held with each of the owning entities to discuss strategies and to review the recommendations for their data processing needs. Based upon those work sessions a data processing plan for the Data Center was developed and presented at I a workshop with all owning entities. • Implementation of System I The plan was accepted and is being implemented. i f Shreveport,City oreveport, Louisiana i Utility Billing Tom Dark, Assistant Chief Administrator Customer Information Needs, Il (318) 226-6014 and Software Selection Study • Evaluation of Automated Systems LWFW was engaged by the City of Shreveport's Department of Water and Sewerage to assist them in evaluating their current Utility Billing and Customer Information i System. • Assessment of Needs During the study the customer information needs of the department were identified and the City's IBM 4300 Computer System reviewed. i —LWFW GYOitp -7- f Preliminary System Design Work sessions were held with the City's software design team, potential strategies were presented, and a recommendation to replace the current system was made. 6 Soliciting and Evaluating Bid Proposals As a result of that study, LWFW was engaged to assist with the selection of a new Utility Billing and Customer Information Software package. a Implementation of System The system was selected and has been successfully installed. City of LaPorte, Texas :Jack Owen City Manager� Y g Data Processing 1;713) 471-5020 Planning and Selection Study 41 Assessment of Needs Recently, LWFW was engaged by the City of La Porte, Texas to identify the City's management information needs, develop a Request for Proposal, and recommend a data processing system capable of achieving both current and future needs. I o Office Automation i I Included within the study was selection of an integrated word processing/office automation system. i o Communicate and Work with Non-Technical Managers The study included working closely with the city management team and the City Council. o Negotiation of Vendor Contracts The Council accepted LWFW's recommendation and a contract has been successfully negotiated with the selected vendor. o Implementation is in process with assistance in project management from LWFW. City of Carrollton, Texas Jack Eades, Assistant City Manager Data Processing (214) 323-5122 Planning and Selection Study i a Assessment of Needs LWFW was engaged by the City of Carrollton, Texas to identify the management information needs of the City, and prioritize these needs. Development of Data Processing Strategies LWFW developed several data processing strategies, including cost/benefits analysis, j that were evaluated with City Management and the City Council. One strategy was 1 selected and implemented. --LWFW Grolip I i -8- • Soliciting and Evaluating Bid Proposals LWFW prepared a Request for Proposal for a data processing system capable of achieving these needs, evaluated the vendor responses, and made a recommendation to the City. • Implementation of System LWFW developed a detailed implementation plan. • Negotiation of Vendor Contracts The engagement was completed and contracts with the recommended vendors were successfully negotiated. City of Bellaire, Texas King Cole, City Manager (713) 677-8315 Data Processing Selection Study 0 Assessment of Needs LWFW worked with the City of Bellaire to identify management information needs and develop a prioritization schedule. III Soliciting and Evaluating Bid Proposals LWFW prepared a request for proposal for computer software and hardware, recommended a data processing system to achieve the information requirements, and developed an implementation plan. OR Implementation of System The project accomplished all of its objectives, and a recommendation and implementation plan were developed. • Communicate to Non-Technical Management and Officials The plan and recommendation were accepted by the City Council. City of Ft. Worth Water Department Richard Sarvey, Director of Water Department -fay Marshall, Director of Data Processing Operations Improvement (817) 870-6000 and Systems Planning Water Department's Field Options and Wastewater Treatment • Evaluated planning and scheduling of crews including backlog of work generated by water service information system. 41 Designed manual management information system to capture and report data on productivity and costs. I • Designed inventory control approach to be automated to reduce inventory investment. li —LWFW ,)Grott! -9- i • Currently assisting in the design and implementation of automated maintenance management system for plant. • Assisted in design and implementation of automated inventory control system for wastewater treatment plant. • Evaluated information systems for tracking service charges for services provided to residents by water department. • Wrote RFP for automated plan maintenance systems and evaluated responses. CITRAN Maintenance Operations Review and John Bartosiewicz, Resident Manager the Design and Implementation (817) 870-62 of an Automated Incentive System 0 Evaluated maintenance information systems and supporting manual processes. 110 Contributed to automated information system design. 'D Currently implementing automated system to track maintenance jobs and individual productivity. ID Designed and implemented automated incentive systems for maintenance workers. 19 Wrote RFP for automation of incentive systems. i I o Assisting City and transit property in modifying scheduling program. I City of Dallas Transit System Development and Implementation lZeg Jones, Maintenance Director of a Management Information (214) 827-3400 Systems Plan o Conducted operations analysis including complete review of manual and automated information systems in maintenance area. o Wrote sections of complete system plan for automation of all transit functions. ju Evaluated existing automated transit systems at other major transit properties. u Identified techniques to reduce manual and improve use of automated systems. I I J —LWFW Group -lo- City of Gainesville, Texas Assistance with Acquisition Bill Gaither, City Manager and Implementation of an 1;817) 665-4323 Automated Information System o Assessment of Needs L LWFW was engaged by the City of Gainesville, Texas to assist City management in identifying the City's administrative management information needs. Our consultants provided guidance during this identification process and then assisted the City's management in prioritizing the defined systems. I to Soliciting and Evaluating Proposals LWFW is currently assisting the City in the selection process. A Request for Proposals was developed and mailed to selected vendors that had a high potential of providing a system capable of achieving the City's information processing needs. The proposals have been received and LWFW is in the process of evaluating the proposed system. o Negotiation of a Contract and Implementation of the Selected System LWFW will assist the City in negotiating a contract with the selected vendor. Once this has been accomplished, LWFW consultants will provide "top level" management assistance during the implementation process. I City of Fort Walton Beach, Florida Computer Systems Requirements Charles Evans, Director of Finance Definition, Specification (904) 243-3141 Development and Acquisition .'Management jLWFW was selected from a group of eight management consulting firms by a Team consisting of city management and a representative of the Florida State University jCenter for Public Management to assist the City of Fort Walton Beach in the acquisition ZLnd implementation of a new computer system. LWFW consultants have provided the City with detailed information needs questionnaires to be completed prior to the interviews which will be conducted to determine the City's information needs. City of Greenville, Texas Mr. Randy Keltner, Data Processing Manager Acquisition of a New Computer System (214) 226-1126 and Implementation Support a Assessment of Needs LWFW was engaged by the City of Greenville, Texas, to identify the management information needs of the City, and prioritize these needs. After the needs were prioritized, a workshop was conducted with the City Council to review the study's progress. � • Soliciting and Evaluating Bid Proposals � LWFW prepared a Request for Proposals for a data processing system capable of achieving the identified needs, evaluated vendor responses, and conducted site visits to cities using the proposed systems. A recommendation will be developed and presented to the City Council. i -------L-xVF W Grotty) -11- III. LWFW STUDY TEAM LWFW's experience indicates that the scope of this study requires a special mix of senior professional expertise, including: Independence of the consulting firm from ties to any particular vendor of computer software or hardware, or service bureau. Expertise with municipal data processing environments, city governments' accounting practices, and operational problems. • Knowledge of and experience with all aspects of automated municipal governmental systems and operations, including operational areas of a municipality such as water treatment, streets, transit, and fire. • In-depth expertise in developing data processing strategies for municipal governmental entities. • Project management experience in controlling a study such as this, to assure quality and on-time delivery, and to work effectively with people representing j i i different functions and viewpoints. j I f , Our project team is composed entirely of senior level personnel with a minimum of ten (10) years experience. The members of this team have worked on most of the studies i presented in the Relevant Studies subsection, and will actively participate during this study. Exhibit I illustrates the Study Team and its members' area of responsibility for interviewing. Engagement Principal It is LWFW's policy to place each engagement under the direction of a principal. The iEngagement Principal will provide overall quality control and technical direction of the engagement, provide staff personnel at the office level, and participate in the engagement as necessary. i i Mr. Gary S. Thompson, P.E., will be the Engagement Principal for this study. Mr. Thompson directs LWFW's work with local governments. Mr. Thompson is a registered Industrial Engineer, and also holds a Masters Degree in Business Administration. He has fourteen years of consulting experience with LWFW, and a significant portion of this i experience is with local government clients. Mr. Thompson has been the Engagement s LWFW Gymp -12- EXHIBIT I STUDY TEAM AND RESPONSIBLE AREAS ��71 C-11 Engagement Principal CO Gary S.Thompson Project Manager Chip Collins Gary Thompson Chip Collins Rick Lentz Bruce Zak Glenn Mason Bill Lloyd City Manager Court Data Processing Data Processing Municipal Utilities Parks do Recreation Planning Building do Housing Office Automation Urban Transportation Fire Health Finance Fleet Maintenance Community Accounting Sanitation Facilities Purchasing Police Utility Billing Data Processing Personnel Budget Library Principal on data processing related management systems and technical studies for a number of local governmental clients, including those described in the Relevant Studies subsection. Mr. Thompson will assist with determining the information needs of the City Manager, City Attorney, planning and the Assistant City Manager's areas of I responsibility. He will also participate in several of the workshops described in Section IV: Study Approach. i Professional Staff I i Mr. Chip Collins will be the day-to-day project manager for this study. Mr. Collins has a Masters Degree in Business Administration and over ten years professional experience with data processing. Mr. Collins has extensive experience with the data processing needs of municipal and county governments. He has directed most of the data processing planning and selection studies presented in the Relevant Studies subsection. Several of these studies involved analyzing data processing systems that utilized PRIME computers and application software. Currently, he is involved with the implementation of the selected systems and the accepted data processing plans. Based upon current and past engagements, Mr. Collins has developed an in-depth understanding of the data processing i needs of local government. Prior to joining LWFW, Mr. Collins worked for a major vendor II of computer systems and an international accounting firm. He will be actively involved with determining user information needs, development of potential information strategies, making the necessary recommendations, and development of the long range plan. He will be responsible for determining the information needs in Courts, Finance, Building & Housing, Personnel, and Planning. Mr. Rick Lentz has fourteen years of professional experience in information processing, 2Lnd is the co-author of a paper on a computer system capacity planning. His specialties include computer performance measurement and modeling, EDP productivity improvement, and long-range planning. Mr. Lentz has managed and participated in projects to evaluate the performance of information systems departments, select packaged software and hardware systems, evaluate service bureaus and facilitates management companies, interpret hardware and software measurement data, design real- time control systems, and establish management reporting systems for EDP operations. Mr. Lentz holds a Masters Degree in Information Science form Harvard University, a i Masters in Computer Science from the University of Houston, and a Bachelors Degree in Chemical Engineering from the University of Texas at Austin. i I -14- Mr. Bruce Zak has ten years of professional consulting experience in information processing. His specialties include information system design and implementation, computer hardware and system software planning, on-line systems, and data base management systems. Mr. Zak has participated in projects to select packaged software and hardware systems, develop long-range information system plans, analyze computer system capacity and performance, and develop and implement on-line applications using data base management systems. Mr. Zak holds the professional credentials of CDP and �CCP conferred by the Institute for Certification of Computer Professionals, a Bachelors Degree in Mathematics from the Massachusetts Institute of Technology, and an MBA in Management Information Systems from the University of Dallas. Mr. Zak will actively i participate in the evaluation of the City's data processing systems and development of the I .long range plan. I I Mr. Bill Lloyd holds a Masters Degree in Business Administration, and has over eleven years professional experience. Mr. Lloyd evaluated user needs, including tax systems, accounting systems, engineering support systems (including Public Works applications), billing systems, payroll systems, and other related systems for three of the major Texas municipalities described in the Relevant Studies subsection. He has conducted Fire Information Seminars for municipalities nationwide and has worked closely with the police departments for each of the cities in the Relevant Studies section. Mr. Lloyd has a sound i understanding of local government operations and management, as well as data processing. Mr. Lloyd will assist in identifying the City's operational management i information needs (e.g., Parks & Recreation, Community facilities, and Fire Department). Mr. Glenn Mason holds Master of Science Degrees from the University of Arizona and is a graduate of the United States Military Academy at West Point. He has over five years consulting experience with LWFW specializing in operations improvements and system development for municipalities and private industry. He is a senior project manager and recently assisted the City of Fort Worth Water Department in the development and implementation of an automated maintenance management system. Currently, he is assisting with an operations analysis of the Dallas Transit Service. Also, he is directing the development and implementation of an incentive system based on productivity gains for a mid-size transit service in the Dallas-Fort Worth Metroplex. Mr. Mason will assist I LW-FW GYOiiv -15- with the identification of the information needs for the Urban Transportation and Municipal Utility Departments, plus Fleet Maintenance. Also, he will participate with the development of the long range systems plan and the various workshops associated with the study. Resumes of the team members are presented in Appendix A. i I I I i r i I i { I I � I i i i 1 I i i i —_—LWFW Groi1�� -16- IV. STUDY APPROACH Given the potential impact this study will have on the future relationship between City Management and all aspects of Data Processing, LWFW recommends a very carefully structure approach to ensure that practical and cost-effective recommended directions are developed. The approach outlined in this proposal relies very heavily upon developing an understanding of management requirements for city departments, current and potential users of data processing, and city management. Prior to the study's beginning, LWFW recommends that the City organize an internal study team composed of senior city managers. This team should be able to meet regularly with LWFW consultants to: • Review the study's progress • Provide input to the study from a senior management perspective • Assist with the prioritization of the City's management information needs j • Review the potential data processing strategies available to the city during the i next three to five years. This team could be the City's data processing Steering Committee, but at a minimum should include the City's Director of Finance, Assistant City Manager, and the I ;Management Information Systems' Director. Based upon the City's March 20th Request for Proposals and experience LWFW has gained iIn similar studies, the work approach for this study will be divided into five (5) phases. Each phase will have major work tasks and objectives. The five phases are: 1) Identify Management Information Requirements, 2) Review Management Information Systems, :3) Develop Resource Requirements, 4) Review Potential (Alternative) Information Processing Strategies, and 5) Prepare a Long-Range Information Processing Plan. The LWFW approach will be to proceed in parallel with the identification of user management information needs and the review of the City's current automated applications, including the management information systems area. Exhibit II presents a synopsis of our approach. I The remainder of this section presents and discusses each of the study's phases and major work tasks. -LWFW GV011p i � I -17- EXHIBIT II PROPOSED LWFW STUDY APPROACH I i Phase 1:Identify Management Information Requirements • Initiation of Study j I - Introductory Meeting j Acquaint Study Team with City Facilities o Identification of Information Needs !I Interviews with Users(Current do Phase II: Review Management Information i i Potential) Systems - Develop Data Flow Diagrams '— — " —— o Interview M.I.S Staff - Document Critical Success Factors a Review M.1.5 Policies/Procedures - Develop Application Matrix a Develop Understanding of Technical Resources • Evaluate Applications Architecture • Discuss Development Plans i I Phase III: Develop Resource Requirements a Develop List of Information Needs i • Conduct Prioritization Workshop with Study Team • Develop Preliminary Alternative Strategies • Estimate Resources i I Phase IV: Review Potential Information Procurring Strategies • Conduct a Study Review with City's Study Team • Define Impact of High Priority Needs on M.I.S. • Evaluate the Two Major Procurring Strategies • Develop Recommendations for City's Infor- mation Procurring Strategy • Conduct a Workshop with Study Team to Present Preliminary Recommendations J i i Phase V: Prepare a Long-Range Information Processing Plan i i • Develop Plan j • Conduct Workshop with Study Team to Present Plan • Present Plan to City Manager i i -LNV-FW Gi'O1tf� -1 s- 1Rhase I: Identify Management Information Requirements In Phase I of the study, LWFW consultants will accomplish the following: • Develop an understanding of each city department's activities, including the information flow within each organizational unit. i • Develop an understanding of each current manual and automated system from the users' perspective. • Identify major critical success factors, key discussions, and information requirements necessary to support each department's short- and long-term operations. I I I • Identify and evaluate the capabilities and features of existing systems to achieve user information needs. i • Identify application systems that are candidates for automation and systems that should remain manual a ual or be eliminated. I I I To accomplish these objectives, Phase I has been divided into two (2) work tasks: 1) Initiation of Study and 2) Identification of Information Needs. Task 1 - Initiation of Study In Task 1, LWFW will become familiar with the personnel and facilities necessary to perform this study. Specifically, we will: • Conduct an introductory meeting with key City personnel who will be important i to the study process. During the meeting we will: - Present an overview of our study approach and schedule. - Distribute an information needs survey previously prepared by LWFW for application specific areas. (The information needs surveys have been prepared based upon LWFW's work with other cities and in-depth analysis of i over fifty vendor application software packages available to municipalities.) - Discuss the types of questions that will be asked. - Present the types of information each person should prepare. I I —LWFW Group -19- - Answer any questions concerning the study. - Review the proposed Study Objectives. - Confirm with senior City management that key City personnel understand the j Study Objectives. • Acquaint ourselves with the facilities maintained by the City, including your +i data processing site. I I j At the completion of this task, we will be prepared to start the identification of the City's ;information needs and the analysis of your data processing (Management Information) system. I i "task 2 - Identification of Information Needs During this task, LWFW will identify the management and operating information needs of the City. To achieve this objective, we will do the following: I • Utilizing any data processing information requirements previously gathered by the City, the needs surveys distributed in Task 1, and information provided by the City determine the current and potential key data processing users to be i interviewed. i • Conduct in-depth interviews with the identified current and potential key data processing users to obtain or further clarify: - Current and projected information needs. - Reports used/not used/needed (collect samples). - Data input responsibilities. - Historical volumes processed and forecasted growth. - Strength/weaknesses of current systems and degree the system is used. - Service levels provided by data processing (development, maintenance, and regular operations). - Ability of personnel to use systems effectively. - Levels of satisfaction with current systems. i i i - Anticipated changes in organizational structure and/or management requirements, which may impact system requirements. —LWFW Gi'Oup -20- ]_xhibit III illustrates the estimated number of personnel to be interviewed. This estimate 1,s based upon City's current organization chart. [n addition to the data supplied by department personnel, LWFW consultants will utilize i previous experience in similar engagements to make observations and to identify additional needs. The analysis of each department's information needs will include but not be limited to: • Objectives and goals. • Critical factors associated with achieving these goals. • New systems or changes in existing systems to be considered. • Special controls which will be exercised by management. • Other special situations with the potential of impacting data processing. Specific outputs from this task will be: • Data flow diagrams illustrating: - Information flows within departmental and/or divisional units. - Information relationships between systems and/or departments. • Departmental organizational charts based upon actual information interactions and use of systems. • Structured interview notes, including the user completed information need surveys. • Documented critical success factors and key decisions that should have a major impact on the long-term plan. • Information needs organized by application and departmental areas. (This output will be utilized for prioritizing in Phase III). i • Preliminary evaluation of the current automated applications from the users and LWFW's perspectives. :Several of these outputs will be directly utilized in other phases of this study. I r � I I--LA)VFW Grout) EXHIBIT III ESTIMATED NUMBER OF PERSONNEL TO BE INTERVIEWED Operational Area Number of Personnel City Attorney 2 Building & Housing 3-5 City Clerk 1 Community Facilities 1-3 Finance 4-6 , 'Management Information Systems 9-10** Fire 3-5 Health 2-5 Library 1-3 Assistant City Manager 5-7 City Manager I j I Municipal Court 2 Municipal Utilities 2-5 Parks & Recreation 2-4 Planning 2 Police 2-4* Urban Transportation 3-6 Total 45-71 i i *These interviews are not in-depth, as our understanding of this study's objectives is not jto critique the Police Department's Datapoint system for the City's long-term information j systems' plan. The interviews will be conducted to create an understanding of the police i system and how or where the Police Department will interact with the City's main approach to information processing. _**Phase II interviews I �—I--N,JV-FW Group -22- Phase II: Review Management Information Systems (MIS) During Phase II, which will occur concurrently with Task 2 in Phase I, LWFW consultants will accomplish the following objectives: • Develop an in-depth understanding of the Management Information Systems' (MIS) function and identify potential areas of improvement. • Prepare application profiles of current systems. i • Define the impact of major development projects, both current and proposed, upon MIS. 1[n analyzing the City's current Management Information Systems area, it is important to develop an in-depth understanding of the data processing function including where management utilizes resources, what capacity exists for system development versus I software maintenance, and what system development backlog exists. This knowledge will j ibe incorporated into the systems planning process. To develop the detailed understanding needed, the Management Information Systems' (MIS) capabilities will be analyzed by: I I • Requesting that each MIS staff member fill out a technical skills/experience i questionnaire, followed up by a personal interview(s). • Reviewing MIS policies/procedures regarding: - Management control, methods used for financial reporting of EDP expenditures, equipment acquisition, project planning and on-going support planning; and how measured performance by project and for the MIS function as a whole is maintained. l - Methods used for allocation of resources and present allocation of resources such as development work in progress and planned, time spent maintaining existing in-house software or training users, and the like. Software development, including project management techniques, system design procedures, package software selection procedures, documentation, and performance track record. - Operating procedures, including job scheduling, back-up procedures, disaster plans, and operator documentation. i —_LWFW Grciip -23- - Organizational analysis, including employee attitudes and job descriptions. • Developing an understanding of the technical resources by: - Analyzing how the system software and equipment configuration is being utilized, through interviews with technical support personnel. • Evaluating the applications architecture of the major system by: Reviewing technical documentation available for selected applications, including: ' On-line transactions (including security). ' Program listings and related documentation (e.g., flow charts). File/record layouts. ' Screen/report designs. Production batch job control. I • Discussing current and near-term system development plans with managers/staff i from technical support and applications. Any written plans/proposals will also be reviewed. I � • Developing an estimation of operational costs associated with each current system. Specific outputs of Phase II will include: • Evaluation of the MIS staff and equipment resources in relation to current systems and defined, near-term projects. • Catalog of current operational and planned application systems. • Listing of current data processing resources (i.e. computer hardware), both utilized and available. i i • Preliminary estimates of projected MIS staff and computer resources requirements. i • Development of preliminary, suggested system profiles capable of achieving both , i current needs and the identified future information needs from Phase I. -24- Phase III: Develop Resource Requirements During the phase, the information gathered in the previous phases wil be integrated to accomplish the following objectives: • Estimate the resources needed to maintain and support the current automated systems and to continue their improvement towards the identified goals in Phase I. Cost estimates will be an integral part of these estimates. • Estimate the resources to accomplish the system development, testing, implementation, maintenance, and operations of the high priority new systems j (systems to be developed during the next five years). Included within these I estimates will be the user costs. • Identify the benefits and assumptions associated with each estimate. I I To accomplish these objectives, several tasks must be performed. These are: • Develop a prioritized list of systems to be implemented during the next five � years. Using the list of needs and systems developed in Phase I, LWFW will conduct a prioritization workshop with the City's Study Team and/or senior management. During this meeting, the Team will be asked to: - Prioritize both current and potential major system information needs for the City. This prioritization will utilize a quantified ranking scheme. - Identify and discuss any practical constraints affecting these prioritized systems to assist our development of potential data processing alternatives. This prioritization will be used to develop the previously mentioned resource and cost estimates. • Develop preliminary alternative strategies for MIS accomplishment of the I p prioritzed systems/goals. The alternatives should include using your current system, utilizing new/different computer systems, and/or a more distributive approach using application oriented minicomputers and/or microcomputers. i These alternatives will be formalized in Phase IV and also will include a static/"do-nothing" alternative. Emphasis will be placed on maintaining the I� i —L-xNFW Groat -25- City's current heavy investment in data processing hardware and software; plus the experience the MIS staff has gained during their development efforts. • Estimate the resources (computer hardware, personnel, and software) and associated costs for each alternative. The preliminary assumptions and benefits would be identified and/or described. Specific outputs of this phase will be a: � i • Priority ranking of information system needs identified in Phase I. • Matrix of the estimated resource requirements for each preliminary system alternative. j i J • Matrix presentation of the estimated computer hardware capacities required j during the next five years to achieve the high priority needs. Phase IV: Review Potential (Alternative) Information Processing Strategies Based upon the information collected and developed during the previous phases, LWFW will conduct a workshop with the City's Study Team to discuss the preliminary information processing strategies identified in Phase III. During the workshop, LWFW will: I • Present and discuss each practical, alternative strategy and where microcomputers could be utilized within the City. • Brief the Study Team on the findings of the study, including: - An assessment of your current data processing situation. - User satisfaction with the data processing division. - Cost effectiveness of data processing versus the City's information needs. i • Request guidance regarding the two alternatives which should be developed in- depth (i.e., distributed versus centralized computer processing using the current data processing equipment). I —L�VFW Groiq) -26- In Phase IV, LWFW will accomplish the following tasks: • Define the impact that the high priority needs identified in Phase III will have upon the MIS organization and primary processing alternatives (strategies). Included within this definition will be an estimation of how the major MIS activities such as system planning, development and maintenance, and operations could be affected. • Development and evaluation of the two major processing strategies agreen upon in the first Phase III workshop and their associated issues such as distributive versus centralized processing. Included will be a discussion regarding the impact of using a data base management system and/or communications networks. • Develop recommendations regarding the best strategy or combination of i strategies to achieve the City's long-term information processing needs. I Using the information developed during these tasks, LWFW will conduct a workshop with the Study Team to present the recommended information processing strategy for the City. During the workshop, the specific outputs of Phase IV will be discussed: • An assessment of the prioritized applications including recommendations for the acquisition of the applications (i.e., development versus purchasing of pre- developed application software). • Acquisition of a data base management system and the associated advantages and disadvantages as related to the City's needs. • An analysis of the potential communication workload for the recommended information processing strategy. I i • An evaluation summary for each major strategic issue presented and discussed. i I • Preliminary recommendations for the City's information processing strategy based upon the detailed analysis performed in previous tasks. i Once this workshop is completed and the recommendation accepted, LWFW will be prepared to develop the long-range information systems plan in Phase V. j i _LNVFW Grolq) -27- Phase V: Prepare a Long-Range Information Processing Plan The objective of Phase V will be to prepare a report presenting the findings from the I previous work tasks and the recommended long range information processing plan. :specifically, this report will include: • The information processing requirements for achieving the recommended strategy. Identified will be: - Resources (i.e. Computer equipment, ers p p onnel, costs) required to implement � the strategy. - Estimated implementation and development schedules. I • Detailed findings regarding the City's current information processing system(s) and user attitudes towards their automated applications. i I • Major recommendations regarding MIS and the long-range processing strategy. i i • Detailed information needs and data flow diagrams developed in Phase I. i This plan will be presented and discussed with the City's Study Team. LWFW will be available, if requested, to present the plan to the City Council and/or the City Manager. i -28- V. Study Time Frame and Cost Based on the study approach described in Section IV of this proposal, we estimate our professional fees to complete this study will be $91,000 to $101,000. If less time than anticipated is required for the engagement, our fee will be adjusted to reflect lower cost. Expenses will be billed to you at cost. Usually, expenses are 10% of our professional fees. Therefore, our not-to-be exceeded proposed cost for this study is $111,000, subject to final negotiation of a contract. Professional fees and out-of-pocket expenses will be submitted on a monthly basis. Presented below is a professional fee estimate by study phase, including professional mandays. We anticipate that the study will take fourteen to sixteen weeks. This time estimate will depend heavily upon the availability of City personnel for interviewing and the workshops. I Study Phase Professional Mandays Professional Fees I 37-51 $26,000 - 35,000 i II 26 16,000 III 21 15,000 IV 31 21,000 V 24 14,000 i Total 139 - 153 $91,000 - 1011000 r r i i —LIArFW Gronip -29- APPENDIX A RESUMES OF THE PROJECT TEAM GARY S. THOMPSON Principal Education: Bachelor of Science in Industrial Engineering, Iowa State University Master of Business Administration, Southern Methodist University Consulting Experience: Eleven years - LWFW, Inc. Group Three years - Texas Instruments, Inc. Areas of Specialization: Municipal Operations Utility Operations Operations Analysis Economic Analysis Facilities Design Project Management Pertinent Experience: Project Director or Manager for a large number of studies for Texas municipalities and other governmental agencies including: - City of Abilene Selection and Implementation of a new financial accounting system Development of a long-range data processing plan - City of Bryan Evaluation of the City's financial and operating system needs Development of a long-range data processing plan - City of Denton Evaluation of the City's financial and operating system needs Long-Range Service Center Facility Study Financial Feasibility Study for Aubrey Reservoir GARY S. THOMPSON Page 2 Pertinent Ex oerience: - City of Dallas (Cent. Water Utilities Department Operations and Management Studies Police Department Civilian Position Evaluation Tax Department Operations and Management Study Urban Planning Department Operations and Management Study Public Works Department Organization and Management Study Parks and Recreation Department Organization and Management Study Office of Economic Development Feasibility Study Aubrey Reservoir Financial Feasibility Study Dallas County Appraisal District Data Processing System Planning and Selection City of Fort Worth Water Utilities Field Operations Productivity Improvement Study City of Garland Space Utilization and Facilities Planning Solid Waste Utilization Study Load Management Study Facilities Needs Analysis City of Austin Water and Wastewater Department Operations and Management Study - City of Houston Wastewater Department Operations Study - City of Sherman Public Works Department Operations and Organization Study - State of Texas Management and Supervisory Training - County of Navarro Accounting Systems and Performance Evaluation Study GARY S. THOMPSON Page 3 Pertinent P)erience: - Texoma Municipal Utility District ont. Regional Landfill Financial of Operational Feasibility Study - Salt Lake County, Utah Data Processing Planning Study Professional Affiliations: Certified Management Consultant (CMC) Member, Institute of Management Consultants, Inc. Public Information Committee, Association of Management Consulting Firms (ACME) Registered Professional Engineer, State of Texas Senior Member, American Institute of Industrial Engineers Texas Society of Professional Engineers American Water Works Association RAMOND W. (CHIP) COLLINS Education: Bachelor of Arts in History, Baylor University Master of Business Administration in Management, Baylor University Consulting Experience: Four years - LWFW, Inc. Group Two years - Fox & Company Other Experience: Four years - Marketing, programming, and installation of computers for a major vendor of computer equipment. Areas of Specialization: Evaluation of computer systems Training of data processing personnel Implementation planning and control of computer systems Management information systems design Computer hardware and software planning Data processing system review Pertinent Experience: Project Manager; City of La Porte - directed a study to select a new management information system for the City. The study included identification of management information needs, prioritization of the needs, preparation of a request for proposal, analysis of vendor responses, and a recommendation with a preliminary implementation plan to the City Council. Project Manager; City of Bellaire - directed a study to identify and select an automated management information system for the City. The study included identifying the major information needs of the City's departments, preparing a request for proposal, and a preliminary implementation plan. Project Manager; City of Shreveport - directed a study to select and install a new utility customer information software package on the City's mainframe computer system. The study included preparation of a request for proposal, analysis of vendor responses, preparation of a recommendation, organization of a project installation control committee and bi-weekly review meetings during the installation. RAMOND W. (CHIP) COLLINS Page 2 Pertinent Experience: Project Manager; City of Shreveport - directed a comprehensive 7Cont. system design and planning study for the City's Police Management Information Computer Aided Dispatch, Criminal Court and Civil Court Systems. Project Manager; City of Carrollton - directed a management information needs study, including developing a comprehensive data processing plan. Departments researched included Police, Fire, Court, Finance, and Public Works. Once the data processing plan was formalized, directed the study to select the new data processing system for the City, including police. Project Manager; City of Duncanville - directed the selection study for the new computer system including hardware and software for all the City's information needs. The study included request for proposal, analysis, vendor site visits and presentation of LWFW's recommendation to the City Council. Project Manager; City of Denton - Assisted the City's personnel with implementation planning and project control of the new data proces- sing shop. The project included preparing a new site, hiring completely new staff, and installing major new application software on a new mainframe computer. Project Director; Cities of Denton and Bryan - directed an engage- ment to select a new computer system for both cities. During the study, a Request for Proposal was developed including the manage- ment information needs of the Cities, and evaluation criteria was developed. Site visits were made and a recommendation including a plan of action was presented and accepted. Also directed the successful effort to negotiate contracts with the various vendors. Project Manager; Grayson Governmental Data Center - directed an engagement to determine user satisfaction with a data center owned by two cities, a county and a school district. During the engagement user needs were identified and prioritized, capabilities of the center were analyzed and a detailed data processing plan was developed. Senior Consultant; City of Shreveport - participated in the evaluation of the City's Utility Billing System, identification of information needs, conceptual design of new system and presentation of report recommended a data processing plan for the Water and Sewerage Department. s RAMOND W. (CHIP) COLLINS Page 3 Pertinent Experience: Consultant; Salt Lake County - analyzed the County's automated (Cont.) appraisal and tax collection system as part of a team identifying the information needs of the County. During the study, a detailed data processing plan was developed, presented and accepted. Project Manager; Dallas County Appraisal District - directed an engagement to determine the tax appraisal needs for a county-wide appraisal district with 41 taxing jurisdictions, developed an RFP, analyzed responses, and made a recommendation for a large-scale automated appraisal system. Consultant; City of Denton - assisted in a review of the City's data processing capabilities and needs, developed strategies and made a recommendation for a new data processing system. Project Director; directed an engagement to assist the owners of a retail department store to identify and define their information requirements. Using this information a Request for Proposal (RFP) was prepared and distributed to qualified vendors. Performed an in- depth analysis of each reply received from the RFP. The analysis resulted in a recommendation. Consultant; conducted an EDP evaluation for a national bank. Reviewed control procedures, interviewed affected bank department heads, developed specific recommendations and designed a plan for system improvements to be implemented over the next five year period. Senior Consultant; performed an in-depth study of the management organization of the client. Individual job functions were identified and formalized; also a current organization chart was prepared and presented to the client. Senior Consultant; conducted an EDP System Review to determine input/output controls, developmental level of software and the objectives of management. Prepared a report identifying problem areas and making recommendations to company management. Consultant; identified the information and reporting requirements that related to possible EDP applications. Structured the system requirements for subsequent implementation to meet the current and future needs of the Firm. Prepared a detailed Request for Proposal (RFP) utilizing the identified information and reporting requirements. Analyzed each reply to the RFP, negotiated with selected vendors and made a recommendation for a specific system. RAMOND W. (CHIP) COLLINS Page 4 Pertinent Experience: Senior Consultant; identified, reviewed and evaluated the internal TCont. controls within a large state bank. The analysis involved interviewing affected department heads and supervisory personnel, evaluating the EDP system and observing the Bank's operations. The final report, prepared for the Bank's president, identified areas of current and potential internal control weaknesses and made recommendations for corrective actions. Consultant; conducted an EDP System review of a new EDP installa- tion to determine the development of input/output controls, progress toward installing various applications and the attitude of company personnel toward the new EDP system. Presented company management with findings and recommendations. Project Manager; directed the identification of the clients' informa- tion requirements and the location of a computer system to perform the required functions. A system was located and successfully implemented. Consultant; participated in the study of the general accounting and production control systems for a manufacturer/wholesaler of specialty grocery items. Performed an in-depth analysis of each reply received from a RFP. The analysis included cost comparison, review of the capabilities of the proposed system, study of computer and software support and negotiation with each vendor. The engagement resulted in a recommendation. Consultant; assisted a client in reviewing a specific computer and software package for use at the client's office. Prepared a recommendation, negotiated with both the hardware and software vendor as regards to purchase price and installation times and assisted the client in installation planning. Senior Consultant; conducted a feasibility study to determine the practicality of acquiring a data processing capability for a multi- state company. Reviewed the current operations, identified areas for potential automation, designed several alternative data processing systems, estimated costs with accompanying benefits and presented a report with the recommendations and justifications. Consultant; determined the best computer system to purchase. Negotiated with vendors, prepared a comparative analysis and recommended one specific vendor. RAMOND W. (CHIP) COLLINS Page 5 Pertinent ' Experience: Consultant; a complete system was designed to perform the data Tcont. processing to convert a mutual savings association to a stock association. The system was designed and flow-charted for a programming team, the required data base was created, and all necessary reports and mailings were produced. The conversion resulted in a successful implementation of the system and several million dollars in new capital for our client. Consultant; assisted in the design of an accounting system for a builder and manager of shopping centers. During the engagement cost centers were identified and work flow analysis was performed. Professional Affiliations: Member, Urban and Regional Information Systems Association Member, Municipal Finance Officers Association Talks/Speeches: "Microcomputers for the Potential User" Dallas Chapter of CPAs "What is a Microcomputer" 1983 Microcomputer Seminar, Fort Worth, Texas -- Sponsored by MFOA "The Computer Implementation Process" 1983 National League of Cities, National Congress - New Orleans, Louisiana "Computers in the Implementation of Government Employee Pension Plans" 1984 MFOA National Conference BRUCE J. ZAK Education: Master of Business Administration in Management Information Systems, University of Dallas Graduate studies, University of Chicago, Massachusetts Institute of Technology, and University of Texas at Dallas Bachelor of Science in Mathematics, Massachusetts Institute of Technology (Scholarship) Consulting Experience: Four years - LWFW, Inc. Group Two years - JCB Enterprises, Ltd. One year - Applied Information Development, Division of System Development Corporation Three years - Independent Consulting Areas of Specialization: Information Systems Design and Implementation Computer Hardware and Systems Software Planning On-Line Systems Data Base Management Systems Data Communications Pertinent Experience: Consultant; provided statistical support for several projects, including a study to determine the effects of certain quality control issues on buying behavior for a major cosmetics manufacturer, a study to determine the relationship between psychological test scores and sales performance for an aircraft manufacturer, and a compensation study for an engineering firm. Consultant; performed detailed analysis and comparison of the structure and implementation of two software systems in preparation for expert witness testimony in a computer trade secrets case. Consultant; prescreened computer system vendors for a manufacturer of industrial electronic equipment and recorders. Consultant; evaluated the existing data processing systems and resources (hardware, software, and personnel) of a city with a population of over 50,000, as part of a needs analysis and system selection study. Departments studied included police, finance, utility billing, and public works. BRUCE J. ZAK Page 2 Pertinent Experience: Consultant; supported the implementation of an IBM 4331 and (C:ont.) application software in a city of about 45,000 population, by evaluating the performance of vendors and City data processing staff, directly training some staff members, and suggesting steps to be taken in the management and productive operation of the data processing facility. Consultant; supervised benchmarks of vendor computer systems in a system selection study for a large real estate development company. Also developed a data communications plan for the firm, and specified and helped acquire the initial configuration. Consultant; evaluated the existing data processing function of a manufacturer of reciprocating pumps and water jetting units, and established data processing plans and recommendations to support the implementation of IBM's MAPICS package as part of a manufacturing/inventory operations improvement study. Consultant; provided support in statistics and data processing for the development of a decision support system to aid a major national convenience store company in setting store staffing levels. Consultant; participated in long-range planning of information/ communication services and in designing an integrated security information system for a two-way cable network serving a planned community. Consultant; supervised the preparation of a request for proposal and selection of a vendor of inventory control application software, system software and hardware for a multi-division industrial supply distribution company. Consultant; wrote a manual for a manufacturer of communication/ security systems, which provides technical documentation about their most advanced security system. Consultant; participated in marketing research and analysis on a potential new product to be offered by a computer vendor. Consultant; participated in preparing a request for proposal, selecting a vendor, and planning the implementation of an automated financial accounting system for a city of 100,000 people and $30 million annual budget. BRUCE J. ZAK Page 3 Pertinent Experience: Consultant; prepared a request for proposal for in-house computer Tcont. hardware and system software sent to data processing vendors, participated in the evaluation of responses, and developed a conversion workplan for a large real estate development company. Consultant; participated in the analysis of capacity and performance of an IBM 370/125 System under DOS for an apparel manufacturer. Consultant; developed a standard office procedures manual and participated in time studies for a geographically dispersed company in the radio-pager and telephone answering service business. Consultant; participated in the design and implementation of an on- line IMS student loan system for a state agency. Consultant; evaluated computer application software, system software and hardware alternatives for cost effective data processing support for a small chemical manufacturer. Consultant; designed and implemented both applications and operating systems software for a major data system on-line network utilized by a large agri-business company. Consultant; participated in the conversion of a large freight rating/ routing system from a service bureau to an in-house computer system and enhanced the performance of total systems software for a chemical fertilizer company. Consultant; participated in the design and implementation of an on- line warehouse inventory control and purchasing system for a large grocery chain. Consultant; produced complete applications and provided all technical programming support for a small college. Consultant; translated the text, audio scripts, and all programming examples of an audio/visual IMS programming course from COBOL to PL/1. BRUCE J. ZAK Page 4 Professional ` Affiliations: Acoustical Society of America American Association for the Advancement of Science American Mathematical Society American Society for Information Science Association for Computing Machinery Association for Symbolic Logic Association for the Use of On-Line Computers in Psychology Data Processing Management Association (Board of Directors, Dallas Chapter, 1981 and 1982) Institute of Electrical and Electronics Engineers International Information/Word Processing Association Mathematical Association of America Sigma Iota Epsilon Sigma Xi Society for Industrial and Applied Mathematics Society of Certified Data Processors Prof essional Credentials: Certificate in Computer Programming (CCP) with Specializations in Systems, Business, and Scientific Programming Certificate in Data Processing (CDP) Technical Experience: Computers - IBM 303X, 4300, 370, and 360; IBM 1130 and 1800; IBM 1401, 1620, and 7040; Xerox 820 and 860; DEC PDP-1, 6, 8, 9, 10, 11, and 12; GE 645; CalComp Plotters; and TI-59. Lan ua es - PL/l, BAL, COBOL, FORTRAN, BASIC, ALGOL, APL, SAS Statistical Analysis System), FOCAL, GPSS, Simscript II.5, SPSS, EASYTRIEVE, IITRAN, LISP, MACRO (DEC PDP-6 and PDP- 10), MAP (IBM 7040), PAL-8 (DEC PDP-8), PAL-11 (DEC PDP-11), Pedagogic Algorithmic Language (GE 645/Multics), and TRANSET. BRUCE J. ZAK Page 5 Technical Experience: Operating Systems - IBM OS-PCP, OS-MFT, OS-VS/l, OS-MVT with (Cont.) HASP, OS-MVS-JES2, and OS-MVS-JES3; IBM DOS, DOS/VS, and DOS/VSE with POWER and GRASP; DEC OS-8, DOS-11, RSTS/E, and RSX-11M; SBC CALL/370; and Multics. Other Software - CICS/VS, IMS, DOS DL/l, TSO with SPF and FSE, DECnet, Roscoe, Wylbur, ETSS, SPAT, DOS/VS Performance Tool, DITTO, DI-Open, TECO (PDP-6 and PDP-10), DDT (PDP-6 and PDP- 10), Panvalet, and On-Line Pan. ERIC LENTZ Education: Bachelor of Science in Chemical Engineering, University of Texas at Austin Master of Science in Computer Science, University of Houston Master of Engineering in Information Science, Harvard University Consulting Experience: Five years - LWFW, Inc. Group One year - Booz, Allen and Hamilton, Inc. One year - Independent Consulting Teaching Experience: Two years - University of Dallas (Graduate School of Management) One year - San Jose State University (Computer Science) Other Experience: Two years - Rockwell International One and one-half years - Bechtel International Four years - Monsanto Areas of Specialization: Management of the Information Resource Data Processing/Word Processing Hardware and System Software Planning and Acquisition Computer Performance 'Measurement and Modeling Management Information Systems Planning and Design EDP Diagnostic Reviews and Productivity Improvements Market Planning/Research for Information Systems Products and Services Pertinent Experience: Project Director/Manager/Consultant for the following types of studies: • Application software acquisition for manufacturers/distributors, financial institutions, and city/county government • Data/word processing equipment acquisition studies for real estate companies, financial institutions, city and county govern- ment, and professional service organizations. ERIC LENTZ Page 2 Pertinent Experience: • Information/data processing department performance evaluation (font.) of people, systems, and equipment for large conglomerates, city and county government, manufacturers, insurance companies, financial institutions, and medical laboratories. • Information systems design and documentation for retail firms, real estate development associations, and communication vendors. • Market planning/research for products/services for equipment vendors, software vendors, financial institutions, and communi- cation vendors. • Systems and equipment planning studies for city and county government, financial institutions, manufacturers/distributors, large conglomerates, two-way cable plant operators. Publications: "Design of A Tool for Computer System Capacity Planning," National T7o-Author Computer Conference, Anaheim, California, June, 1978. Speeches: "Effective Configuration Management," Computer Measurement Group, San Antonio, Texas, May, 1979. "Information Systems for Distributors," Computer and Office Systems EXPO 80, Dallas, Texas, April, 1980. r WILLIAM A. LLOYD Education: Bachelor of Science in Mechanical Engineering, The University of Tennessee Masters in Business Administration, Southern Methodist University Consulting Experience: Five years - LWFW, Inc. Group Other Experience: Two years - Texas Oil and Gas Corp. Four years - Texas Instruments, Inc. Areas of SDecialization: Local Government Operations Improvement Financial and Economic Analysis Law Enforcement Information Systems Strategic Planning of Management Information Systems Pertinent Experience: Project Manager; management study of the Central Garage, including preventive and unscheduled maintenance, organization, parts management, information system, objectives, and policies; City of Olathe, Kansas. Project Manager; design and development of The Work Management System software package for scheduling crews, measuring performance, and improving productivity in public works, water, parks, and facilities maintenance; implementation in Carrollton, Texas, utilities and streets; Richardson, Texas, utilities and facilities maintenance; and Shreveport, Louisiana, parks and utilities. Project Manager; operations and management study of warrant division, including procedures, staffing, priorities, work methods, data processing resources, and interaction with other criminal justice organizations; Dallas County, Texas. Project Manager; conceptual design of a comprehensive Police Management Information System, including calls for service, incident reporting, property records, crime analysis, criminal history, and intelligence; City of Shreveport, Louisiana. Project Manager; management study of water distribution division, including equipment, staffing, records, and organizational structure; City of Dallas. WILLIAM A. LLOYD Page 2 Pertinent Wont.))erience: Consultant; evaluation of financial, management, and operating system needs with emphasis on financial planning and utility management, and development of a long-range data processing strategy, City of Denton, Texas. Senior Consultant; economic evaluation of proposed Aubrey Reservoir project, Dallas and Denton, Texas. Consultant; Economic evaluation of alternative options for solid waste resource recovery project and for facilities needs analysis, Garland, Texas. Consultant; Development of strategic and tactical marketing plans, and financial planning for entrepreneurial businesses in general aviation, recreation, and service industries. Staff Consultant; Development of investment appraisal criterion and procedures, and preparation of economic summaries and projections for top management of major energy company. Professional Affiliations: Associate Member, Municipal Finance Officers Association GLENN M. MASON Education: Bachelor of Science in Engineering, United States Military Academy, West Point, New York Master of Science in Mechanical Engineering, University of Arizona ' Master of Science in Aerospace Engineering, University of Arizona Consulting Experience: Five years - LWFW, Inc. Group Other Experience: Two years - Miller Brewing Company Seven years - United States Army Areas of —pecialization: Operations Analysis Systems Analysis Maintenance Systems Pertinent Experience: Project Manager; conducted an analysis of the management information systems and maintenance operations of a transit property for a city of 400,000. Developed maintenance incentive systems including software specifications for automation on micro- computers. One system has been programmed and trained and is currently in use. Consultant; in conjunction with another consulting firm, engaged to develop and implement an automated management information system for the transit property of a city of over 1,000,000 people. The scope of this project will include assessment of needs for all areas, review and selection of existing software and hardware, programming where necessary, installation, and training of users. Project Manager; responsible for a study of a multi-million dollar maintenance operation including implementation of a micro- computer-based maintenance reporting system. Project :Manager; responsible for an operations analysis of the third largest wastewater treatment plant in Texas. This study included review and evaluation of existing application systems. Currently working with the plant to design, imple nent, and train users on new automated management information systems. Project Manager; responsible for the irnple:nentation of an automated capacity planning system for a $100 million manufacturer. Tasks included in this study were organization and input of data, testing of the system, and training of the users of the system. GLENN M. MASON Page 2 Pertinent Ex perience: Project Manager, conducted a computer software selection study for Cont. the financial, sales, and manufacturing needs of a $40 million electronics firm. This study included the writing of an RFP, evaluation of software and hardware alternatives, and negotiation of the vendor contract. Project Manager; conducted a computer software selection study of the financial and manufacturing needs of a $25 million manufac- turer. The study focused on finding microcomputer-based software systems to meet this client's needs. Consultant; conducted an analysis of opportunities to increase the use of microcomputers as well as other computers, micrographics, telecommunications, and other automated office systems for a $1 billion bank in Colombia, South America. Z APPENDIX B SUMMARY OF RECENT GOVERNMENTAL STUDIES LWFW GOVERNMENTAL CLIENTS s SUMMARY OF GOVERNMENTAL STUDIES CITY OF ABILENE, TEXAS • Financial Accounting System Selection -- Evaluated several financial accounting system packages and ranked them against the city's needs. Developed the recommendation for a specific new system which was approved and obtained. • Data Processing Plan -- Evaluated current data processing applications, defined and prioritized future applications and recommended a three- to five-year hardware and software plan which was subsequently endorsed by the City Council. • Financial Accounting System Implementation -- LWFW served as overall project manager for this effort and was responsible for recommending budgetary appropriation units, planning and control cost and revenue centers, and activity centers for performance measurement. • Fire Department -- LWFW conducted a comprehensive management study for the Abilene Fire Department to identify opportunities to increase the department's effectiveness and productivity. During this assignment, improvement strategies were developed in the areas of fire prevention, fire suppression, and support activities. CITY OF ALICE, TEXAS • Personnel Classification Study -- Developed and installed a new personnel compensation plan and classification system for the city. Developed and installed personnel policies and procedures manual. CITY OF AUSTIN, TEXAS • Personnel Classification System Development -- Provided technical support and guidance to the city's Personnel Department for the development and implementation of a new personnel classification system. • Water and Wastewater Department -- Productivity Improvement Study. This study consisted of a management audit of the department and the development and implementation of specific projects designed to reduce costs and improve department efficiency. CITY OF BRYAN, TEXAS • Data Processing Plan -- Evaluated current data processing applications, defined and prioritized future applications and recommended a three-to five-year hardware and software plan which was subsequently endorsed by the City Council. • Utility Billing Operations Improvement -- Evaluated the management and operations of the city's utility billing activities and developed an improvement program to improve the productivity and level of customer service of the operations. LWFW was retained for implementation support. CITY OF DALLAS, TEXAS • Dallas Water Utilities Department -- General Organization and Management Study. Resulting in a three- to five-year improvement plan, impacting organization, operations, and management systems. • Dallas Water Utilities Department -- Operations Improvement Projects. Developed and implemented improvements in Field Operations, Facilities Maintenance and Customer Services, yielding cost savings in excess of $1,000,000 annually. • Dallas Police Department -- Diagnostic Analysis of Civilian Positions. Evaluated the need for over 500 civilian positions and assisted in the implementation of recommendations, resulting in savings of over $300,000 annually. • Dallas Tax Department -- Management and Operations Study. Audited the organization, management, and operations of the department and assisted in implementing improvements resulting in substantial savings and improved operations. • Dallas Urban Planning Department -- Study of the Entire Urban Planning Process. This study produced recommendations for improving the overall urban planning process, including major organization and operations changes. • Dallas Public Works Department -- Street Lighting Study. This study included the evaluation of the contractual relationship between Dallas and DP&L for street lighting services and the development of alternative arrangements providing economic benefit to the City of Dallas. • Dallas Parks and Recreation Department -- Organization, Management Systems, and Operations Study. This comprehensive study produced recommendations for improvement in the above areas and provided an overall strategy for the implementation of the improvements. • Office of Economic Development -- Development of the most effective role for the City of Dallas to assume in the area of economic development. • Dallas Police Department -- Validation Analysis of Selection Criteria for Entry- level Patrol Officers. Data analyzed included ability tests, psychological tests, physical fitness tests, interview evaluation, and background information. • Dallas Water Utilities Department -- Financial Feasibility Study of the Proposed Aubrey Reservoir. Resulted in the City Council directing the department to contract with the Army Corps of Engineers for this project. CITY OF DENTON, TEXAS • Data Processing Plan -- Evaluated current data processing applications, defined and prioritized future applications and recommended a three-to five-year hardware and software plan. i • Long-range Service Center Facility Study -- LWFW worked with each of the major departments of the City of Denton to develop a master plan for facility requirements through the year 2000. Using this information, LWFW then developed a conceptual design for a single-site service center and developed a block layout of the site. • Lake Aubrey Financial Feasibility Study -- LWFW worked with the Aubrey Steering Committee, composed of representatives from both the cities of Dallas and Denton, to determine the financial feasibility of the proposed Lake Aubrey. The study involved the updating and integration of engineering and financial data and the development of a computerized financial model to evaluate and compare the cost of Aubrey water with other potential new reservoirs in the area. CITY OF DUNCANVILLE, TEXAS • Data Processing Planning Study -- LWFW assisted the City of Duncanville evaluate their information systems needs and developed a multi-year data processing implementation plan to meet their needs. This assignment involved the selection of specific software and hardware for the city. Prior to this study, the city had no data processing systems. CITY OF FORT WORTH, TEXAS • Water Utilities Department -- Management and Operations Improvement Study of the Field Operations Division. Resulted in the justification of additional capital equipment to increase productivity and an improved organization structure for the division. • Parks Department -- LWFW conducted an operations study of the department's grounds and facilities maintenance activities to identify opportunities to increase the division's productivity and effectiveness. Recommendations were presented and accepted in areas of organization structure, personnel deployment, equipment, scheduling, and performance reporting. • CITRAN -- LWFW conducted a training needs analysis and prepared a training manual for telephone operators of CITRAN, Fort Worth's public transportation service. CITY OF GARLAND, TEXAS • Space Utilization and Facilities Planning Study -- Recognizing that current municipal buildings were rapidly becoming inadequate to house its needs, the City of Garland selected LWFW to study the space requirements that would accomodate the city's future growth. An in-depth analysis was made to determine the needs of the Council, Administration, and user departments. The results of the study were a space requirement and utilization plan and a layout for additions to the existing facilities which would accommodate the city's growth. From these plans, the city undertook the necessary construction and relocation to meet its needs. • Solid Waste Utilization Study -- This study provided a market analysis and economic analysis for the utilization of solid waste as a boiler fuel to produce steam for generating electric power. • Load Management Study -- This study involved the design of a pilot management project to demonstrate the attitudinal and economic impact of regulating residential air conditioning and hot water heating units by remote control during periods of peak electrical demand. • Facilities Needs Analysis -- LWFW surveyed the facilities needs of approximately 70 civic, social, cultural, recreational, and human services organizations located within or serving the citizens of Garland. This study resulted in specific plans regarding facility acquisition for the city to obtain their own, as well as community, needs in these areas. CITY OF HOUSTON, TEXAS • Houston Police Department -- Selection and Promotion Criteria Validation. This extensive study resulted in an objective assessment of the validity of the department's selection and promotion criteria. • Houston Wastewater Department -- Inventory Control System Development. This study resulted in material inventory requirements for the department and a system for controlling and accounting for the material inventory. • Houston Police Department -- Development, validation, and implementation of a reading comprehension test to be used in recruiting and selection efforts. CITY OF LAKE JACKSON, TEXAS • Organizational Analysis -- Development of organizational structure, management information systems, and projected staff levels through 1982. CITY OF PORT ARTHUR, TEXAS • A study of the social and economic factors influencing Port Arthur and its growth. CITY OF SAN ANTONIO, TEXAS • San Antonio School Board -- Management Study. Evaluation of school district administration in terms of effectiveness and efficiency. • City Public Service Board -- Review and revision of the executive compensation program. CITY OF SAN ANTONIO, TEXAS (continued) • City Public Service Board -- Job analysis, classification system, and compensation program development for the entire organization. CITY OF SHERMAN, TEXAS • Operations and Organization Study -- Study of Sherman Public Works, Engineering, and Planning activities. Resulted in an organizational realignment and the initiation of a $300,000-per-year cost reduction program. CITY OF SHREVEPORT, LOUISIANA • Data Processing Utility Billing System Evaluation -- LWFW conducted an in- depth review of the effectiveness of the city's utility billing system from the perspective of both the Data Processing Department and the system users. It _ was determined that significant improvements to the system were required to meet user needs and that it was not cost effective to enhance the existing system. The city accepted LWFW's recommendations to acquire a packaged utility billing system, and LWFW prepared the detailed specifics for Request for Proposals. CITY OF TYLER, TEXAS • Tyler Police and Fire Departments -- Job analysis, classification system, compensation and educational incentive program development. CITY OF WACO, TEXAS • Management by Objectives Program Development -- LWFW worked with most of the city's departments to assist in the development of objectives for an MBO program. Also, training was provided to management personnel in the concepts and implementation of the MBO system. CITY OF WEST UNIVERSITY PLACE, TEXAS • Personnel Study -- Development of a compensation plan, classification system, personnel policies, and procedures manual. DALLAS COUNTY, TEXAS • Data Services Division Study -- The objective of this study was to improve the operating performance of the Dallas County Data Services Division. The study focused on all aspects of the division's activities including administration, staff utilization, hardware and software requirements, and user interface. DALLAS COUNTY CENTRAL PROPERTY APPRAISAL DISTRICT • Data Processing Plan -- Evaluated the data needs of the district's 41 taxing entities and selected the most effective data processing strategy for the district to meet these needs. GRAYSON COUNTY GOVERNMENTAL DATA CENTER • Data Processing Planning Study -- The Data Center provides data processing services to the cities of Sherman and Denison, Grayson County, the-Sherman and Denison Independent School Districts, and other governmental entities in Grayson County. LWFW was engaged to assess the city's performance in meeting user needs, to develop additional user needs, and to create a long-range plan for the Data Center. This plan was accepted by the Data Center Board of Directors and is currently being implemented. GREATER TEXOMA MUNICIPAL UTILITY DISTRICT • Solid Waste/Resource Recovery Systems Study -- Working with the engineering firm of Henningson, Durham, and Richardson on short- and long-range plans for Grayson County, Texas in the area of solid waste disposal. LWFW's responsibilities included management and operations planning, as well as financing. HARRIS COUNTY, TEXAS • Review and audit of personnel procedures and practices, including recruiting, selection, training, and promotional systems. Analysis of work force for affirmative action planning. LOWER COLORADO RIVER AUTHORITY • Compensation Study -- Review restructuring of the Lower Colorado River Authority's compensation plan and procedures. • Salary Survey -- Assisted in the development of ongoing annual salary survey. • Job analysis and classification system development. • Development and conduct of an ongoing management training program. NATURAL FOOD FIBERS AND PROTEIN COMMISSION • Assisted in the development of marketing strategy and marketing program emphasis of cotton seed flour production cost and return on investment. NAVARRO COUNTY, TEXAS • Accounting Systems and Performance Evaluation Study -- LWFW developed criteria for performance measurement for each county department and a system for measuring departmental performance on an ongoing basis. In addition, LWFW worked with a CPA firm to develop a financial and accounting procedures manual. SALT LAKE COUNTY, UTAH • Management Information System Requirement Study -- LWFW was engaged to review the city's Data Processing Department, identify user needs, and develop a short- and long-term data processing plan. STATE OF TEXAS • Management and Supervisory Training -- Conducted extensive management and supervisory training programs for the Departments of Public Safety, Parks and Wildlife, Public Welfare, and the Lower Colorado River Authority. • Department of Public Safety -- A validation study for selection and promotion criteria for a large number of positions within the Department. TEXAS INDUSTRIAL COMMISSION • Information Services Study -- Management study of the Information Services Department's data processing systems. • Organizational Analysis -- Developed a plan for integration of the Texas Office of Minority Business Enterprise into the Texas Industrial Commission. • Image Study -- Analysis of the user and potential user awareness of the International Division of Texas Industrial Commission, including the development of effectiveness measurement criteria. • Review and analysis of the organization, operation, and user requirements of the Information Services Department data processing systems. TEXAS MUNICIPAL POWER POOL/TEXAS MUNICIPAL POWER AUTHORITY • Development of organizational structure, personnel procedures, policies, and practices. LWFW GOVERNMENTAL CLIENTS City of Abilene, Texas Harris County, Texas City of Alice, Texas City of Houston, Texas City of Austin, Texas City of Lake Jackson, Texas City of Baytown, Texas City of La Porte, Texas City of Bellaire, Texas Lower Colorado River Authority City of Bryan, Texas Navarro County, Texas CAy of Carrollton, Texas City of Olathe, Kansas City of Cleveland, Ohio City of Port Arthur, Texas City of Dallas, Texas City of Richardson, Texas Dallas County, Texas Salt Lake County, Utah Dallas County Central Property Appraisal District City of San Antonio, Texas City of Denton, Texas City of Scottsdale, Arizona City of Duncanville, Texas City of Sherman, Texas City of Fort Worth, Texas City of Shreveport, Louisiana City of Gainesville, Texas State of Texas City of Garland, Texas Texas Industrial Commission Town of Glastonbury, Connecticut Texas Municipal Power Authority Grayson Governmental Data Center City of Tyler, Texas Greater Texoma Utility District City of Waco, Texas City of Greenville, Texas City of West University Place, Texas CALENDAR *** Tuesday, May 29 - Superior Floors; 1675 Lindbergh @ Washington 12:00 Noon - Ribbon Cutting Ceremonies (Greg Martin) 1 :1.5 P.M. - Council Chambers Council Meeting followed by Work Session * 4:00 P.M. - Judge LeBlanc's Office Private Industry Council Meeting (Laurie Bouillion) * Wednesday, May 30 - Port Arthur Council Chambers 9:00 A.M. - Public Hearing - Drydocks **** 5:30 P.M. - Ridgewood Ribbon Cutting Ceremonies & Reception for Energy Management Consultants (George Matthews) * Thursday, May 31 - Corpus Christi (Thru' June 3rd) **** Leave for Institute for Mayors, Councilmembers and *** Commissioners, sponsored by Texas Municipal League *** Friday, June 1 - Corpus Christi (Thru' June 3rd) Leave for Institute for Mayors, Councilmembers and Commissioners, sponsored by Texas Municipal League * MAYOR ** MAYOR PRO TEM *** COUNCILMEMBER TURNER **** COUNCILMEMBER BRUMLEY ***** COUNCILMEMBER SAMUEL ***** COUNCILMEMBER MOORE