HomeMy WebLinkAboutPACKET Light and Power 1992-05-14AGENDAi Light and Power Committee May 14, 1992 2:00 p.m., Board Room i L Mainframe Computer Replacement 7-J /512 j ifLAc, 2GL_j / Authorization to Purchase 2. Underfrequency Relay Project „ Authorization to Purchase D«ket CM-0 3. Hand Held Meter Reading Equipment Authorization to Bid -_ 4. Current Transformer Tester Authorization to Bid- // 5. Reports A. Financial Report B. Telephone Service Availability in Estes Park C. Project Updates NOTE: The Light and Power Committee reserves the right to consider other appropriate items not available at the time the agenda was prepared.
(1 MEMORANDUM TO: Light & Power Committee Gary Klaphake FROM: Monte L. Vavra, Finance Officer DATE: May 12, 1992 SUBJECT: Computer Software and Hardware Purchase 1. Financial Management Software During the past 18 months, members of my staff and I have been looking for a fully-integrated software package to meet the needs of the financial management and utility billing functions for the Town of Estes Park. Based upon recommendations by other users and demonstrations we have seen, we have narrowed the choice to HTE, Inc. software. HTE Software is designed to be flexible for the governmental entity without requiring programming to customize it to fit our needs. This is a change from the packages that are currently being used as it seems that every time we want to change something, we need to call in a programmer to further customize the programs to accomodate the new change. A demonstration was performed by HTE representatives on April 22, 1992, for the software modules that we are currently considering purchasing. After the demonstration, the staff have indicated they feel the software would perform satisfactorily in the modules we are concerned about. As with any software, we may want to change our current policies or practices to take advantage of its efficiencies. Those changes can be implemented as we become accustomed to the software. The HTE Software we would be purchasing is the same package that any of their other clients (Loveland) are using. The maintenance plans provide us with updates when available. The modules that I propose the Town purchase at this time are: GMBA (Government Management and Budgetary Accounting) $ 17,500 Utility Billing w/Electric' 35,000 Purchasing/Inventory 17,500 Payroll/Personnel 12.500 Total Licensing Fees 82,500 1 Cash receipts and Land Management software is included with Utility Billing.
, Training_is estimated to cost approximately2 20.400 . Total Software and Training --11025900-j HTE has quoted that the Utility Billing conversion would be billed at $85 an hour, not to exceed $17,000. I am in the process of negotiating with HTE to determine what we are getting out of this conversion and how much we will do in-house. $120,000 was budgeted for in 1992 for software. HTE will extend the warranty through December 31, 1992; annual maintenance would then cost $10,850 for 1993. Prices are subject to change on an annual basis. HTE-does offer additional modules which I would like to purchase after the initial conversion is accomplished and we are up and running, such as Fixed Assets at a current cost of $5,000. Other modules offered by HTE that may be of interest to other departments would be Building Permits and Occupational Licenses. 19, ·do 2. Hardware & Operating Software After consultation with representatives from IBM, HTE, and Mr. Bill Westbrook, MIS Director for the City of Loveland, the following hardware configuration for the Finance Office was priced. Gov't. Net Count Description List Price Discount Cost 1 E-10 CPU $47,735 20% $38,188 1 Modem 1,415 15% 1,203 5 Terminals 1,590 22% 6,200 1 475 LPM Printer 11,080 15% 9,418 Total IBM Hardware $55,009 IBM Operating Software: 1 Operating System 7,715 15% 6,558 1 RPG (programming tool) 1,745 10% 1,571 1 Development tool (works w/RPG) 1,745 10% 1,571 1 Performance tools 1,380 10% 1,242 1 Language Dictionary 472 0% 472 1 Query 1,110 10% 999 1 Office 3,425 10% 3,083 1 PC Support 1,650 15% 1,403 Total Operating Software 16,899 TOTAL IBM HARDWARE & OPERATING SOFTWARE $ 71,908 2 Travel costs are billed separately. Most training will be conducted on site in Estes Park; however, some initial training may be at HTE in Orlando, Florida. Annual update training would be conducted at HTE in Orlando. Estimated cost $1,100 plus travel.
3. Additional Costs to Consider PC Communications Boards; have been recommended to purchase from Connecting Point in Greeley. 4 @ $600 each (estimate) 2,400 Cabling to connect workstations & PC's to CPU's, estimated at $300 to $500 each. estimated 12 at this point @ $500 6,000 Connection of PC's to CPU and configure to properly communicate estimated at $400 to $600 each x 4 2,400 Smooth Start - this is the physical installation, connection of terminals, printers, etc. by an IBM systems engineer 2,000 Uninterruptible Power Supply (UPS) 1/2 hour run time w/5-year warranty 4,000 Point of Sale Devices includes mica encoder 9,170 25,970 Software Support Series: System extra - 24-hour/7-day software -S- Support service 175/monthj Service to load program updates/new releases, etc. 4- (physical loading by SE) 330/months When the numbers were gathered for the 1992 budget, we were looking at the D-10 model. In March, IBM announced a system enhancement to the E series, approximately a 33% enhancement in power. HTE representatives feel that an Elo model will meet our needs. IBM representatives indicate the Town should purchase an E20 model. Mr. Bill Westbrook, MIS Director from the City of Loveland, reviewed both proposals and feels that the Town should get satisfactory performance from the Elo model. If the acceptance of the system by Town staff is greater than anticipated and demands computing capacity larger than the Elo allows, we can always upgrade to the E20 model; however, I do not forsee this demand for at least a year or two. IBM also enhances the systems about once a year. Assuming past history repeats itself, within a year or two the enhancement should be compatible to the current E20 model. Bottom line is that purchasing a smaller system today may mean an upgrade down the road. 1-3
1, , The 1992 budget planned for $75,000 of hardware. Recap of HTE Software and IBM Hardware: HTE License Fees $ 82,500 ~ Training 20,400 1 Utility Billing Conversion by HTE 17,000 IBM Hardware & Operating Software 71,908·/ Estimated Additional Costs 25,970/ 1992 IBM Maintenance (5 months) 2.525 Total Costs 220,303 1992 Budget 195.000 Difference in Budget $ 25,303 As of the April 30, 1992, Light & Power financial statement, the data processing line item in the customer services department has $37,000 that will be used to offset the budget overrun. 1-4
MEMORANDUM TO: Light & Power Committee Gary Klaphake, Town Administrator FROM: Monte L. Vavra, Finance Officer DATE: May 12, 1992 SUBJECT: Reference Check on HTE Software and IBM AS/400 Computer Greg Demco, Adminstrative Services Director - City of Loveland: Mr. Demco was one of the individuals that introduced me to HTE Software. Loveland has been using HTE for six or seven years and feels that there is no better integrated package out there. Loveland personnel have been extremely helpful in answering any questions we have had and in demonstrating how they use the system. Mr. Demco has also said that they would help with the pre-implementation/planning process, which would help us take full advantage of the software. Mr. Bill Westbrook, the MIS Director for Loveland, spent a day with Debbie Parrack and me to help determine the proper size of hardware. Ed Castle, MIS Director - City of Sioux Falls: The City of Sioux Falls has some HTE modules in place and is currently implementing other modules. To date, they have not found anything the HTE software can not do that they wanted. Mr. Castle feels that the HTE support has been very responsive; their personnel have been very patient. Sioux Falls made no modification to the GMBA modules and modified payroll to accomodate Union Contracts only. He said the technical people are very good and knowledgable on their product. Mr. Castle also said to spend time and money on HTE training; it will pay us benefits in the long run. HTE has made many improvements to their software the past few years and they are continuing to make improvements. It will be our choice whether we want to take advantage of the improvements. Mr. Castle said it is a "wise choice to go to HTE". As far as the IBM AS/400, he really likes the machine. He did say that they have had some problems making PC's work properly. PC's will be trial and error based upon brand and configuration. Lauren Gieser - City of Gillette: HTE Software actually works; the GMBA module works well for them. He felt the Purchasing module was a bit of an overkill for their city. Mr. Gieser was satisfied with HTE support; he felt they used it a lot the first six months. Gillette has dropped the HTE software maintenance. Mr. Gieser feels there
.. . . is no need for programming unless we want an add-on that the base package does not offer. He feels the GMBA module does everything they need and that the budgeting function is very good. Mike Erie - City of Broomfield: Likes HTE software pretty well. The first year was hell, but now the staff is up to speed. He felt the budgeting feature was good. Broomfield basically uses the canned reports by HTE. They like the Utility Billing program, but have customized it to meet uniqueness to Broomfield. Therefore, they have dropped HTE support on Utility Billing. Broomfield uses ITRON handheld meter devices; they work wonderfully. Broomfield is 90% happy with the system. If there is a downturn, it is the software documentation being on-line. Mr. Erie would prefer a manual as opposed to on-line. He has offered that we could come down and look at the system if we wish. Claude Priest, Controller - Estes Park Medical Center: The E.P.M.C. uses an IBM AS/400 for their financial operations. They are happy with their system. The Town and Medical Center could serve as backup facilities in the event of hardware malfunction. Bob Cook - Laramie County: Feels so far, so good, about HTE Software; however, it is a chore to install. The Payroll is complex because of the number of codes to get all this information into the machine which does take time. Mr. Cook said the chart of accounts is user defined; uses format suggested by GAAFR. Mr. Cook was not pleased by lack of written documentation; he felt there were holes in the on-line documentation. Mr. Cook felt that some HTE trainers were better than others. He did say to have their worksheets ready when they come on site, or else they spend valuable time preparing work rather than training. Mr. Cook also warned not to take too fast; do only one or two modules at a time. Many report modifications can be done through IBM Query, but plan to train up front. The GMBA module is great the way it is laid out; very logical.
Boudreaux & Jacks on, CPA's A Professional Corporation 146 Certified Public Accountants Professional Menilierships ·Jerry Bondreatix (Jolorado Society of CPX:. Sleve Jackson .·Uncrican Instituc of CPA *, April 23, 1992 To The Mayor and Board of Trustees Town of Estes Park P.O. Box 1200 Estes Park, Colorado 80517 Gentlemen, I am writing to report my favorable impression of the HTE accounting software presented to the staff on April 22nd. I attended some of the actual demonstrations and met with the company representatives over lunch. The software as presented will provide a great improvement in both the efficiency and the effectiveness of the Finance department as well as other administrative functions in the Town. The approach used is one where many types of information are brought together and stored in one central location. This information base is then accessible to system users in many different ways. The great advantage of this arrangement over the present system is that once any information is entered to the system, it can be used over and over. Currently, the financial records require a great deal of duplicate effort to arrive at the end result because each use has to have the basic information entered into the computer first. The HTE company representatives were all very knowledgeable about the product and also about the needs of a governmental organization such as the Town. This is very important because of the differences between the Town accounting system and the accounting systems used by private businesses. The system proposed by HTE would serve the needs of the Town for many years as it has the ability to grow with the Town. I feel that this would be a very good investment for the Town in this day and age of growing complexity and increasing demands for reliable and accurate information. I would be pleased to discuss this matter with you further. Please feel free to contact me. Sincerely, *--- 9/0~ Steve j'ackson, CPA SJ:je (:30:3) 78(1- .53f)4 • :Wi:J 1~ 1:1: ' i,q·it Knlic 81(-1 • 1'(1 11, ir 9.777 • 1'41<·4 1·':i,·1{ C '< 11, irn<11, ROF;17
TOWN OF ESTES PARK May 12, 1992 OFFICE MEMORANDUM TO: Light and Power Committee FROM: Richard E. Matzke743<5271 SUBJECT: Underfrequency Relay Project Authorization to Purchase The Estes Park Light and Power Department participates with other Platte River member utilities in the Colorado/Wyoming off-normal frequency study group. The purpose of this group is to co-ordinate underfrequency load shedding among regional utilities. Our obligation is to shed two circuits at Estes Substation during certain system-wide emergency conditions. We do have an existing underfrequency relay at Estes Substation. This relay is obsolete and has been out of service for at least a year. The Light and Power Department recommends that this relay be replaced with an ABB (formerly Westinghouse) MDF underfrequency relay. This is the relay currently used by other Platte River utilities in their substations. This relay is available from WESCO for $3745. We anticipate installing the relay using department personnel. The 1992 Light and Power Department budget includes $5,000 for this project. REM
TOWN OF ESTES PARK May 12, 1992 OFFICE MEMORANDUM TO: Light and Power Committee FROM: Richard E. Matzke .-2€ 227>- SUBJECT: Hand Held Meter Reading Equipment Authorization to Bid The Light and Power Department included $25,000 in the 1992 budget for purchase of hand held meter reading equipment. This equipment will replace the paper meter books which we currently use. The hand held device is actually a portable computer for electronic storage of customer meter reads. The system is designed to download customer account information from the main billing computer in route order into the hand held device. The meter readers record customer meter reads on the hand held device which are then uploaded to the billing computer at the end of the day. The hand held devices are durable, weather-proof, and easier to handle in the field than the present meter books. Since meter reads are electronically transferred to the billing computer, much tedious data entry is eliminated, and there is less chance for error. There are several suppliers who provide equipment which compatible with the proposed mainframe billing computer. The Light and Power Department requests authorization to obtain price quotes for hand held meter reading equipment. Since the requests for quotes cannot be distributed until after the meeting of the Town Board on May 26, 1992, we will probably not bring a recommendation to purchase this equipment until the July meeting of the Light and Power Committee. REM
TOWN OF ESTES PARK May 12, 1992 OFFICE MEMORANDUM TO: Light and Power Committee FROM: Richard E. Matzke i SUBJECT: Current Transformer Tester Authorization to Bid The Light and Power Department included $9,500 in the 1992 budget for purchase of a current transformer tester. Metering transformers are generally used in installations where the size of customer's electric service exceeds 200 amps. These accounts have a multiplier which is applied to the customer's meter reads in determining kWh consumption and kW demand. When current transformers fail, the amount registered is below actual usage or none at all. As these installations meter our larger customers, it is important to ensure their accuracy. The proposed equipment would allow meter department personnel to test the accuracy of installed current transformers without interruption of service to the customer. The Light and Power Department requests authorization to solicit bids for this equipment. REM
1 11 1 1 1 1 1 11 1 N toi <D I 10050%%001 LOI •-11 1 1 00 11 16101011 O 41(OCIOC, IC}I m 1 1 1 0111 Albr,1411 0, Metolomtol el 1 1 0 It -1 1 ••1 •1 lilli. 1 .1 .1 1 1 016-1105/bl M 01 to & -1 4 I to I 04 1 1 1 10 . it CIlIN•-llc)1 C) C,1 -1 m (9 I tO i 1 1 1 1 0-1 11 "-1 >44 1 0 C, 1 01) 1 O -1 41 1 & 1 OIl 1 1 011 1 .1 .1 . Ill 1 1 -1 U 1 ¥-1 1 -1 1 .4 1 . 1 1 1 . 1 li 1 11 11 11 1 1 1 11 1 1 1 1 1 11 1 11 11 11 1 1 1 (31 0 1 0 1 40lori t-• co C) 11 1 11 1 1 1 Clt•• I toi < tO C) h O •-1 1 '-4 | 1 1 1 11 RIS•o lai (D 01 O •-1 •-1 41 1 xii i 1 1 1 11 -1 11 ..1.1 ..1 .1 M E-• 1 -1 0 1 10 1 ,-1 too*1ml•111 1 1 1 11 C,IIMMI(DI tr) CD -1 0) 101 1 1 1 11 1 1 1 11 -1%10*11,1 CV 1 41 1 1 1 1 0 1 1 1 1 1 1 1 1 1 -11 111 11 11 1 1 1 11 11 11 1 1 111 1 1 It 1 11 1 1,0 el 1 5 1 I O m (0 10 W c, 1 5 1 01.1 1 11 IM=111 & 1 04 10 •-1 0 <D tO 1 04 1 lo toi I il AICOIDIQI 00 0 41 5 (C) 10 1 -1 1 101(41 1 11 01 1 1 ..1 .1 . .....1.1 -1 .1 1 1 C, 9 1 00 t- 1 (D I (D C) to to m •11 I r, 1 10101 0,110)0101 O 04 4, CO toirn I &101 1 1 1 11 rl>' 1 0}C, 101 O -1 44 1 $ I elli t It 1 .1 -1 . 1 .1 1 1 1 0 1 I r-1 1 eli .1 1 .-1 1 1 1 1 11 1 11 1 1 1 1 1 It M m . m Z E-4 0 <Dze 1 1 1 1 1 1 1 1 11 04 [14 m 100101 00(9041*10101 It 1 M 11 E 6-1 I r-1 -1 1 04 1 OMOC•IMIMI It 1 1.- 11 U} 0< m •-1 016101611 r, .Nhe).101 1 1 1 m 11 01 M E-1 04 elli..1.1 11 1 -11 E-1&40-1 . E-1 I tool (0 1 (9 M •-1 M H OIOI It I N U co O 6-1 < C)11(4bIC)1 * M .1.4 0 1 .1 1 1 1 1 (D 11 D-1 0, 0 ri Z 1 0 •11 1 41 1 04 .1 1 + 1 1 1 91• 1 (Dll 0 1 1 1 11 1 1 1 1 1 D. '8 DJ Z 1 1 1 Illilli O Z 1-1 1 1 1 1 1 1 1 11 El O A 25% O Z Sozoil O )-1 H D ,-1 0 E 1 11 1 1 1 1 1 -- It llc)01'01 0000}10(DMINI 0101 : r• 1 1 0,0 1 6,1 0000%•-100141 toi toi 1 C) 11 O +J INOI MI OO61bvum Ir-11 .1 1 toi 1 ~ !1 E (4111.-1 -1 ... ....1 -1 .1 -1 1 . It 0, 0, 1 00 •-1 1 C) 1 (D -1 (D M 41 tO b I f 1 10 1 0 1 1 .1 1 C, '0 10- 1 - 1 .1 01 tri tO 0 0 1 4 1 e-•1001 0 1 .4 11 •-1 21 1 Mto la) 1 1041¥-INMI.1 , b I (D i r. 11 mio> .i .1 - .1.1 1 1 .1 011 1 10 1 9,1 m '-1 1 10 1 1 1 (D I - 11 111 It 1 1 1 11 1 1 1 1 1 1 1 1 11 CO 01 U} 0 W I E. 5 · 0 0 H Z CC A W 0 {13 Z > ..4 C W Di 4-1 43 04 0< 01 e >4 D-1 0 4) M /4 U •rl O [LI 0 04 10 0 W S a O E + 4 4 4 14 C - E-4 6)11¤G) UU) 1 0 0> 0 01 C El ¤ 03 OCCU·rl 01 0< C) 014040004-, •-1 D A. U 4, 4 91 4 0 0 6-1 X 0 CD C C '0 4-1 4-' 14 1-1 - Dll HI 01 03 6) 4, P S :4 +J DI 0 ELI W •-1 0 0 .0.0 O 0 M Z ri D •-1 (0 -1 - G r.1 ADd (0 e U O.C 14 :4 O R -04 4-1 - .-1 0 .4 0 +1 +J 4., er-1 T 71 0: 0 01 k 0 0 0 E com O. Of) 01 24 -1 >, 0 -1 -1 0 00 CO (13 CO > 21 11 81 t:]Et[~04¤Ao< D-1 W U Dd O 04 0 01 0 >4 >4> 05 01 01 0 01 E A-1 *OL'9yI I 96 68 80€'EZ 86L'I06 99€'*6: TEE'ZIB'I LDE.88 Z6L'O (L66'8Z 9fE'96I S~HA~IGNEdXS 996'09 I8I'98 'IV.LIdVO S FOR THE 1992 & 1991 SEANEASH TOTAL REVENUE tion isctllcn:nurgy Sales NUES
111 1/lilli 1 e) 91 1 $ 1 C,1 Or, a.,.1 0 0 1 + 1 5 1 e.11 01 1 9, 1 1 01 (9 1 tf) 1 4 0 H 01 0001 (111 bllol (9 1 C,1 11 Cllcirilot c.1 (n r., •P 1· Ch I WI M|th' 7/ (D U - 11.-1-1 . .....1 .1 .1 -1 -1 .11 Ch E-, I t• 4 1 N I C. t.,0 Ul M t·• U) t o i .,Iu.)1 1-41 . 11 Ch I 1 .r a) I m 1 M 0 r, 2, M 1 10 1 001101 01 Cl It r, >1 1 4, 941 1 1,) 1 00 01 1 01 1 -1 1 1 . 1 .1 li 1 -1.1 1-1 1 1 -1 WIt 1 .1 1 Ptl 1 ./ 1 1 1 .1 1 11 1 11 It 1 1 ll 111 It 11 1 11 1 1 -/.1 1 1 -- 11 1 •-1 10 1 Lf) 1 M O t• 91' 01 •-1 41 1 rl 1 U) 1 U) 1 U' 1 0 1 1 00 1,1 1 M I M r• M O, 41 0, la) 1 ./ 1 0, 1 U., 1 M 11 011. Ul lot (9 01 U O .1 1 61 1 CD i •1 1 .1 1 r 1 11 r' It.-1-1 .....1 .1 .1 -1 .1 -11 Cl E-1 tomt Mt M r-1 W Ul M I t• 1 M toll .1 1 r• li Ch I 1 01 01 1 -1 1 b M .1 Ch | r' | -- 101 MI C.1 It r i El{,r} m 1 11 01 1 . 1 1 1 + 1 011 1 1 1 1 1 -·- 11 1 1 11 1 ll 1 1 1 0 111 1 1 1 1 1 11 I lf) C·1 I r• 1 * 0 0 u rl ¢4 + 1 00 1 014,1 MI MI 1 04 01 1 U) 1 I tn a] 0 4 rj I cu l ul I C, 1 a) I r-• 1 ! 01 [1 1 (Da) IMI 1.0 .1 .1 O M r• toi eNtail 01 . 1 C} C411•-1.1 . .....1.1 -1 .1 -1 . li r. 0 6, I cir· 1 0 1 en (D q (4 rl M I rl I 611(01 51 M 1' 61 1 1 r• e) tri I lf) Ch (9 r, U) 1 01 1 collot r.l m 11 45 rl >4 1 04'l 10 1 5 MI M I r, 1 I (9 1 .4 1 1 .1 .1 1.1 1 1 -1 01 C; I eli .1 1 lili 1 1 .1 1 It M Ill It lilli 0 r1 b< Cl D; Z E, r, <DZ(9 111 1 1 111 04 04 0 1 I r I * I Ul I (0 0 0 10 0 01 A I l I ., It, 1 .1 1 . 11 1 00 01 1 1·' 1 (1040 CO hlril (DIC41 ll (9 11 0 0< M O 0 1 00 0 1 6,1 0, r• U) H e.1 01 1 .1 1 a) 1 4 1 to i . U 01 01 6 1 0; C.11 .-1 -1 -1 .1 -1 -1 -11 PX<< CD D I to to I r, 1 (9 0 (9 "1 Cl I a} 1 (9 1 41 1 O.1 1 . 11 u] O t• I 0, It (9.1 1 8 1 1 M -1 04 0 I r, I (9 1 1 04 1 C, 11 thi 0, 01 rl Il {De l 4 1 04 •11 1 1 1 1 M 1 011 0 1 1 1 1 1 1 1 1 r, D, t:$ 1,1 Z 111 1 1 1 1 1 1, O 1. H 1 11 1 1 1 1 1 1 9 0 0 Z 3: O 2% 3 0 Z m O.1 '-1 1 1 1 It 1 1 1 -.11 I u ) O I lf) 1 0 0 0 0 10 4' C, 1 (9 1 MIC,1 C.1 1 r. li Icl 0 1 01 1 0000(9 •-1 a, 111 10 1 10 1 C, 1 0 It 4, 1 .' O 1 C.1 1 0 0 c.1 r. . f en tri I r, I toi 5 1 . 11 CIWI .-I .I ..... . .1 .1 -1 .1 -1 -11 m tn I cori 1 0, I l,0 4 (D (9 + 10 6 1 9 1 1014)1 01 .1 11 00[3 1 O A I .1 1 ri 01 LO M al 0, 1 4 1 5 1 00 1 MI r 1 11 r{ 71 1 M (D Icil to H .1 01 a I a) 1 tril lei r• 11 al 1 0 -1.1 - .1.1 1 - 1 01! 1 (0 1 .-- 1~ 1 10 1 toi Crl •-1 1 '0 1 1 11 1! 11 It 1 11 U, 6-1 bl 01 < 0, 0} 0 1 6 1 8 b 1 61 Cl KI El 53 bl 61 li :; 0, H 21 2 f: c: 01 < 2 21 ./ 00 >0 .> Al ·,1 fo t:1 1,1 bl 0 > P N 0; t,1 0, 0: 0) DI M *i 01 U X r 1 01 11 f: 0,O 6, 1, ] Di 113 0) ·r 1 O Di [4 0 U) 1! c: O I v ..*m 4.1 e -- Ed 04 01 0 01 0 61 0 E., O 14 t: >I ·· 1 9 >4 0: 1 0 4, C) t 1 :1 0) O 0 v O 0 D 0 14 61 0 W 3 0 :, 21 b I f, E- 4 21 E i 0 0 :1 0 0 N [: U ..1 DI 06 0 DI kt O C 0 " 04 0 0 l) +J H :) C 1. F , Cl CJ D 1 G) CJ .r,./1 < 0 o H X O 2% U} h f; 'U *' 4·';I tl •-1 c,1 kt W 01 0 M M U 0, U :3 h 4, Dll Cl [14 0, -1 ..1 M r I O 0 .O A 61 W 01 Z rt bl >t 5 .1 M ·r 1 7 1 H -, 1 0 DI M Cl M U) C) 4, 6, 0 0 1: il h O i; - 01 4 - 01 0 0 k 1 0 34 0 4.' 4-, 4.1 ..1 X : 1 01 Cl 0 01 O 0 00 1. 0 61 0 If ul b i jj (/1 0 1 0 01 > 91 2: to . I X 0, A C, O 4 bl 0. t.') D 1 0 01 0 t.1 2 b 1 X 0; b 1 01 c ) b 1 614- PJ FOR THE MONTHS
- 030 -- AON - 100 - d]S - on¥ -- 10£ - NAP - AVA - hld¥ - UVR - 833 NVP AAN MliSAS 5A-3 9091 KW.XLC 5/13/92 - 1990 L661 0 2661, T TOWN OF ESTES PARK PURCHASE POWER - DEMAND 21000 - 19000 - 17000 - , 0009L - 000£L 0O0LL
T 030 AON d]S DAY WHI -Ill:H..6 lAp NAr 1¥n blvn em„m,ammm422: 83J a; : U.1 1 1 L u 1 . u..-I LLW % ¢Lh~.U.L LAULI L L .L.L.LL LU L. 11,1~ NVf 1.Tr$FurIwiT#fr,5-Fuifiwit~~..~ry EldV & 111 1 HMM MJISAS 5A-4 9091KWH.XLC 5/13/92 E 1990 166 L . 000009L Z66 L ¤ TOWN OF ESTES PARK PURCHASE POWER - ENERGY 9500000 - 9000000 - 8500000 - 8000000 000000L 0000009 / 1 1 1 0000095
- 030 4 - AON 4 -100 - d]S Z >. 1- e Z 00 * - On¥ Z U.1 >- 1. 0¢ O - lof 1.1.1 1- 2 0 Ul 1- * - NOf 2 5 O 4 -1901 1- - 8dV - 8¥n - 833 NVr B HMM I'(31SAS 5A-5 9091 KWHA.XLC 5/13/92 1661 Z66L - 1990 OF ESTES PARK PURCHASE ACCUMU 95,500,000 - 85,500,000 - 75,500,000 - 65.500,000 - - 000'009'99 - 000'009'9* - 000'009'de - 000'009'91 - 000'009'9 L 000'009'9
I I 99 - \ \ \ \\ 11 - \ 4\IR\ - \\ .40 4 - ON - - /\ t pi \\\ U 0 31¥0 01 8¥31 (1) S]-IVS 5A-6 9091 SALY.XLC 5/13/92 ._ 01,4 066 1 -·c- 01* 1 66 1 --0- 030 AON 130 d)S DAV inr Nnr AVIA' bldV . EIVVy 83=1 NVr al* 166 L v - 000'000' L ELECTRIC SALES ACCUMULATED BY MONTH 6,000,000 - 5,000,000 - 4,000,000 - - 000'000'E - 000'000'Z
PHONHELD.XLS 5/14/92 U S WEST HELD SERVICE ORDERS 1990 SAMPLE COMPARISON OF LOCAL EXCHANGE AREAS LOCAL # OP # HELD %HELD VS. EXCHANGE CIRCUITS ORDERS # CIRCUITS BOULDER 51,000 79 0.15 % ESTES PARK 6,000 39 0.65% FORT MORGAN 6,100 1 0.02% LAMAR 5,100 5 0.10% LEWISVILLE 14,000 18 0.13% MONUMENT 5,700 6 0.11% HELD SERVICE ORDER IS DEFINED AS FAILURETO PROVIDE SERVICE APPLIED FOR WITHIN 10 DAYS
b j . 2.- i c~~ ic# 5 -lop TOWN OF ESTES PARK SHEET NO <td 9>k . of 170 MacGregor Avenue P.O. Box 1200 CALCULATED BY DAT. ESTES PARK, COLORADO 80517 CHECKED RY DATF SCAI F 1 1 t... .19 95 MOUC ..1.- f .l +411 1 ||11 lei 1 1 lilli 1-4-···4·.. ..4.. ...i.. ....i··· ···, i... ...,.. ..·F··· ····· ·· ··········· ····· ···· ··········· ··········· ·· 'll 1 1 11 1 1 1 1 210 1 11 lilli 10 1 1 1 i 1 1 1 1 1 t er 1 I 0 .. U ·z |·· T ···· 11 1 i , 1 ' ;Vl i ···i ·· ·~·~ · ···i·i·· 1 .i. ..i .. 1. ...~.... i~.. ...... .... ..1 e i| ird ' i i: · J/ h. , 74 Z I : .,1, 1 h ···r/-<1-1\ 1 1. . :11/1 iii +11 1 0 1: 1 : U 1 + . 1 : 1 \ hr:\ 1 : : i : 9 \ 11\. 3 : 1 1 i 1 4-0\ 34/..4 il I li j" .1 5/ 11! i ..i... Er' 1 ···i· · 1-'& 1"' i ,/ '. t* i.e ' 4 4 1 111 2, 1 1 1 1 1 1 1 ! 1 i j J« fi 1 1 ~.1 >2,1....1.. ....~.. ..1. ...~. ..~.. ...I.F... ..1.. ....................................,......... 111 1 1 : PHODUct ;0$·thie-;Ine . Grolon, 11,35 01•11 to Olde, PHONE 1Oll FREE 1 80&275 611 LUEST
TOWN OF ESTES PARK May 13, 1992 OFFICE MEMORANDUM TO: Town Board Trustees FROM: Richard E. Matzke .g22-771, SUBJECT: Electric Rate Modifications A public hearing is scheduled at the May 26, 1992 Town Board to consider raising the allowable annual consumption on the Residential Electric Rate from 15,000 kWh to 20,000 kWh. A packet of information from the April 9, 1992 Light and Power Committee meeting is attached explaining the reasons for recommending this change. The other change to be considered is renaming the "general service" rates as "commercial". Also, I have attached a copy of the Notice of Proposed Rate Modifications which was mailed to all affected customers. Finally, I have included copies of the revised tariff sheets and the proposed ordinance to implement these changes. I will contact each of you prior to May 26 to answer any questions you might have. REM
. - 009'89 - 009* - 009'9£ - 009'9[ - 009'K - 00*f - 009'ZE - 009'19 - 009'0[ - 009'6Z - 009'91 - 009'LE - 009'E - 009'SE - 009'172 - 009'CE - 009'ZE - 009' 1Z - 009'01 - 009'61 - 009'91 - 009'L 1 - 005'91 - 009'91 I l l 094 k 1 0880 g N (t) SONIAVS 39¥3]AV DMDRTAVG.XLC 3/30/92 ESTIMATED SAVINGS ON DEMAND RATE (HAAN) NOildIAIRSNOO lVANNV 600 - 500 - 400 - - 00 1-
. TOWN OF ESTES PARK March 24, 1992 OFFICE MEMORANDUM TO: Light and Power Committee FROM: Richard E. Matzke-72 3,7- SUBJECT: Proposed Schedule for Changing 15,000 kWH Electric Rate Threshold Following are proposed milestones and dates for increasing the 15,000 kWh threshold to 20,000 kWh in the Town's electric rates: 4/9/92 Present justification for changes at regular meeting of the Light and Power Committee. 4/14/92 Town Board set public hearing for consideration of electric rate changes (threshold only) at regular Town Board Meeting on May 26, 1992. 4/24/92 Publish notice of public hearing with proposed rate changes and mail notification of public hearing and rate changes to residential customers affected by these changes. 5/26/92 Public hearing to present proposed changes to electric rates. Consider ordinance to implement changing 15,000 kWh threshold to 20,000 kwh as described in the Residential and General Service Small Rate Schedules. 6/26/92 Changes to rate schedules take effect. I do not anticipate needing the services of a rate consultant, but we will need some legal help from the Town Attorney. REM
. i APPENDIX A Proposed Rate Schedules Rate Page 1. Residential Service 1 2. Residential Service - Demand Metered 2 3. Residential Service - Time of Day 3 4. Small Commercial Service 4 5. Large Commercial Service 5 6. Large Commercial Service - Time of Day 6,7 7. Municipal Service 8 8. Purchased Power Rider 9
. TOWN OF ESTES PARK March 30, 1992 OFFICE MEMORANDUM TO: Light and Power Committee FROM: Richard E. Matzke,A- cr-3- SUBJECT: Recommendation to Increase 15,000 kWh Demand Rate Threshold On December 10, 1991 the Town Board approved an ordinance requiring existing Light and Power Department residential customers on the Residential Rate using electric heat and having annual consumptions exceeding 15,000 kWh to transfer to the Residential Demand Rate by 1/1/94. The same ordinance requires residential customers on the General Service Small rate using over 15,000 kWh annually to transfer to the Residential Demand Rate by 1/1/93. At the December loth public hearing, the Light and Power Department committed to study to possibility of raising the 15,000 kWh threshold. The Light and Power Department recommends that we change the 15,000 kWh threshold to 20,000 kWh for the following reasons: 1. Number of Customers Impacted. As the rate is written, approximately 575 customers would be required to transfer to the demand rate. If the threshold were raised to 20,000 kWh, only 325 customers would be affected. Our original intention was to transfer approximately 350 customers. 2. Average consumption in Rate Class. In 1991, customers on the Residential Rate averaged 6193 kWh annual consumption and customers on the Residential Demand Rate averaged 20,500 kWh annual consumption. After these 350 electric heat customers transfer to the Residential Demand Rate, average annual consumption on the Residential Rate will drop to approximately 5200 kWh and consumption on the Residential Demand Rate will rise to approximately 21,400 kWh. 3. Economic Impact on Customers Transferred to Demand Rate. After performing some 75 rate comparisons, we have determined that 15,000 kWh annual consumption is the break-even point between the residential and residential demand rate for customers with demand controllers. The
2 average savings for customers with annual consumptions of 20,000 kWh is $150. (See attached graph.) This would provide a payback period of slightly less than 5.5 years for a controller with an installed cost of $800. These proposed changes do not change the intent of 1991 rate study recommendations. The changes are based on more complete information which has been developed since the December 10, 1991 rate hearing. Raising the threshold to 20,000 kWh will make the Residential Demand Rate applicable to customers who will benefit the most as well as focus on those who have the greatest impact on our system peak. The Light and Power Department requests approval to proceed with implementing this change as outlined on the attached memorandum. REM
ELECTRIC RATES RESIDENTIAL SERVICE APPLICABILITY Applicable in Estes Park service territory. AVAILABILITY This schedule is available to residential consumers for all domestic uses in individually metered single-family private dwellings or individually metered apartments except new electric space heating consumers. Effective January 1, 1994, existing consumers in this schedule having electric heat as a primary or auxiliary energy source for space heating with annual consumptions 4 greater than 20,000 kWh will be transferred to the Residential Demand rate. This rate is not available for resale service. MONTHLY RATE Customer Charge $3.00 Energy Charge per kWh $ .06501 MONTHLY MINIMUM BILL The Monthly Minimum Bill shall be the Customer Charge. PAYMENT The above rates are net. Bills for electric service are due and payable within ten (10) days subsequent to mailing or delivery of the bill. CONDITIONS OF SERVICE Service provided under this rate schedule shall be subject to all Light and Power Department general and specific Rules and Regulations and extension policies and such rules and regulations as set forth in appropriate tariff sheets on file. PURCHASED POWER RIDER This schedule is subject to the conditions set forth on the Purchased Power Rider. 1
. ELECTRIC RATES RESIDENTIAL SERVICE - DEMAND METERED APPLICABILITY Applicable in Estes Park service territory. AVAILABILITY This schedule is available to residential consumers having electric heat as a primary or auxiliary energy source for space heating in individually metered single-family private dwellings or individually metered apartments. This schedule is also available for those residential consumers who do not have electric heat as a primary or auxiliary energy source for space heating, but whose annual energy consumption is over 15,000 kWh. This schedule is not available for resale service. MONTIILY RATES Customer Charge $3.00 Demand Charge per kW of billing demand: Winter Season Oct. 1- March 31 $7.00 Summer Season April 1 - Sept. 30 $5.00 Energy Charge per kWh $.03 DETERMINATION OF BILLING DEMAND The billing demand shall be determined by suitable meter measurement of the highest 15-minute . integrated demand occurring during the monthly billing period. MONTHLY MINIMUM BILL The Monthly Minimum Bill shall be the Customer Charge. PAYMENT The above rates are net. Bills for electric service are due and payable within ten (10) days subsequent to mailing or delivery of the bill. CONDITIONS OF SERVICE Service provided under this rate schedule shall be subject to all Light and Power Department general and specific Rules and Regulations and extension policies and such rules and regulations as set forth in appropriate tariff sheets on file. Any account provided service under this schedule shall be required to remain on this schedule for not less than twelve (12) months. PURCHASED POWER RIDER This schedule is subject to the conditions set forth on the Purchased Power Rider. 2
ELECTRIC RATES SMALL COMMERCIAL SERVICE APPLICABILITY Applicable in Estes Park service territory. AVAILABILITY This schedule is available for business lighting and small power loads of 35 kW maximum demands or less. All service will be supplied only through a single meter. This service is available at single or three phase at the established voltage of either the Town's primary or secondary distribution system. Effective January 1, 1993, residential consumers in this schedule utilizing electric space heating with annual consumption exceeding 20,000 kWh will be transferred to the Residential Service - Demand Metered rate. Effective January 1, 1993, residential consumers in this schedule utilizing electric space heating with annual consumption less than 20,000 kWh will be transferred to the Residential Service rate. This schedule is not available to new residential consumers. This schedule is not available for resale service. MONTHLY RATE Customer Charge $7.25 Energy Charge per kWh $ .07044 MONTHLY MINIMUM BILL The Monthly Minimum Bill shall be the Customer Charge. PAYMENT The above rates are net. Bills for electric service are due and payable within ten (10) days subsequent to mailing or delivery of the bill. The foregoing schedule shall be net where service is metered at secondary voltage of the Town's distribution system. Where service is metered under this schedule at primary voltage, the consumer shall receive a credit of two percent (2%) of the monthly bill, less the Customer Charge. CONDITIONS OF SERVICE Service provided under this rate schedule shall be subject to all Light and Power Department general and specific Rules and Regulations and extension policies and such rules and regulations as set forth in appropriate tariff sheets on file. PURCHASED POWER RIDER This schedule is subject to the conditions set forth on the Purchased Power Rider. 4
. ELECTRIC RATES LARGE COMMERCIAL SERVICE APPLICABUITY Applicable in Estes Park service territory. AVAILABILITY This schedule is required for electric lighting and power requirements of consumers having maximum demands exceeding 35 kW in any two (2) consecutive months. All service will be supplied only through a single meter. This service is available at single or three phase at the established voltage of either the Town's primary or secondary distribution system. This schedule is not available for resale service. MONTHLY RATE Demand Charge per kW $9.65 Energy Charge per kWh $ .02875 DETERMINATION OF BILLING DEMAND The billing demand shall be determined by suitable meter measurement of the highest 15-minute integrated demand occurring during the monthly billing period, but shall not be less than the Monthly Minimum Billing Demand. MONTHLY MINIMUM BILLING DEMAND 60% of the highest demand established during the immediately preceding months of November through March. MONTHLY MINIMUM BILL $9.65 times the Monthly Minimum Billing Demand or $55.00, whichever is greater, plus the monthly energy charge. PAYMENT The above rates are net. Bills for electric service are due and payable within ten (10) days subsequent to mailing or delivery of the bill. CONDITIONS OF SERVICE Service provided under this rate schedule shall be subject to all Light and Power Department general and specific Rules and Regulations and extension policies and such rules and regulations as set forth in appropriate tariff sheets on file. The consumers shall be required to properly balance their loads. If the power factor during the time the billing demand is established falls below 95 % lagging, adjustment may be made by increasing the measured demand for each month by 1 % for each 1 % or major fraction thereof by which the power factor during the billing period is less than 95 % lagging. The foregoing schedule shall be net where service is metered at the secondary voltage of the Town's distribution system. Where service is metered under this schedule at primary voltage, the consumer shall receive a credit of two percent (296) of the monthly bill for service. Where service is taken at the Town's established primary voltage and the consumer furnishes the transformers and substations converting to secondary voltage, the consumer shall receive a credit of four percent (496) of the monthly bill. Any account requesting service under this schedule shall be required to remain on this schedule for not less than twelve (12) months. PURCHASED POWER RIDER This schedule is subject to the conditions set forth on the Purchased Power Rider. 5
ELECTRIC RATES LARGE COMMERCIAL SERVICE - TIME OF DAY APPLICABILITY Applicable in Estes Park service territory. AVAILABILITY This schedule is required for electric light and power requirements of consumers having maximum demands exceeding 35 kW in any two consecutive months. All service will be supplied only through a single meter. This service is available at single or three phase at the established voltage of either the Town's primary or secondary distribution system. This schedule is not available for resale service. MONTHLY RATE Demand Charge: On-Peak Period: All kW of Maximum Demand (including Power Factor $10.70 Cost Adjustment) in the Billing Period per kW Off-Peak Period: All kW of Maximum Demand (including Power Factor $5.35 Cost Adjustment) in excess of On-Peak kW (including Power Factor Cost Adjustment) in the Billing Period per kW Energy Charge: On-Peak Period: All kWh used On-Peak in the Billing Period, per kWh $ .02875 Off-Peak Period: All kWh used Off-Peak in the Billing Period, per kWh $ .02444 TIME OF DAY HOURS The on and off peak periods are defined as follows: (a) All hours from 12 midnight to 6 a.m. and from 10:01 p.m. to 12 midnight are Off-Peak. (b) All other time periods are considered On-Peak hours. DETERMINATION OF BILLING DEMAND The billing demand shall be determined by suitable meter measurement of the highest 15-minute integrated demand occurring during the monthly time of day period. MONTIILY MINIMUM ON PEAK BILLING DEMAND 60% of the highest demand established during the immediately preceding months of November through March. 6
ORDINANCE NO. AN ORDINANCE AMENDING CHAPTER 13.12 LIGHT AND POWER RATE SCHEDULES OF THE MUNICIPAL CODE OF THE TOWN OF ESTES PARK, COLORADO WHEREAS, the Board of Trustees has determined that it is necessary to amend Chapter 13.12 of the Municipal Code of the Town of Estes Park; and WHEREAS, notice to the public of the proposed rate adjust- ments and of the public hearing thereon, was duly given in compliance with the requirements of C.R.S. § 40-3.5-104; and WliEREAS, a public hearing was held by the Estes Park Board of Trustees on May 26, 1992, as is required under C.R.S. §40-3.5-104; and WHEREAS, the proposed rate adjustments are necessary to ensure the continued reliable, stable, viable and efficient operation of the Town's electric utility system; and WHEREAS, the proposed rate adjustments are just and reason- able in light of the Town's present and anticipated needs; and WHEREAS, the proposed rate adjustments are to be uniformly applied to all customers, without regard to whether they are located inside or outside of Town limits. The proposed rate adjustments are non-discriminatory to any customer or class of customers. BE IT ORDAINED BY TIIE BOARD OF TRUSTEES OF TIIE TOWN OF ESTES PARK, COLORADO. Section 1. Section 13.12.020 B., is hereby amended to read as follows: B. AVAILABILITY: This schedule is available to residential consumers for all domestic uses in individually metered single- family private dwellings or individually metered apartments except new electric space heating consumers. Effective January 1, 1994, existing consumers in this schedule having electric heat as a primary or auxiliary energy source for space heating with annual consumptions greater than 20,000 kWh Will be transferred to the Residential Demand rate. This rate is not available for resale service.
Section 2. Section 13.12.030 G., is hereby amended to read as follows: G. CONDITIONS OF SERVICE: Service provided under this rate schedule shall be subject to all Light and Power Department general and specific Rules and Regulations and extension policies and such rules and regulations as set forth in appropriate tariff sheets on file. Any account provided service under this schedule shall be required to remain on this schedule for not less than twelve (12) months. Section 3. The title of Section 13.12.050 is hereby amended to read as follows: 13.12.050 Small Commercial Service. Section 4. Section 13.12.050 B., is hereby amended to read as follows: B. AVAILABILITY: This schedule is available for business lighting and small power loads of 35 kW maximum demands or less. All service will be supplied only through a single meter. This service is available at single or three phase at the established voltage of either the Town's primary or secondary distribution system. Effective January 1, 1993, residential consumers in this schedule utilizing electric space heating with annual consumption exceeding 20,000 kWh will be transferred to the Residential Service - Demand Metered rate. Effective January 1, 1993, residential consumers in this schedule utilizing electric space heating with annual consumption less than 20,000 kWh will be transferred to the Residential Service rate. This schedule is not available to new residential consumers. This schedule is not available for resale service. Section 5. The title of Section 13.12.060 is hereby amended to read as follows: 13.12.060 Large Commercial Service. Section 6. The title of Section 13.12.070 is hereby amended to read as follows: 13.12.070 Large Commercial Service - Time of Day. Section 7. This Ordinance shall take effect as of July 1, 1992. -2-
.. PASSED AND ADOPTED BY THE BOARD OF TRUSTEES OF THE TOWN OF ESTES PARK, COLORADO, THIS DAY OF , 1992. TOWN OF ESTES PARK, COLORADO By: Mayor ATTEST: TOWN CLERK I hereby certify that the above Ordinance was introduced and read at a meeting of the Board of Trustees on the day of , 1992, and published in a newspaper of general circulation in the Town of Estes Park, Colorado on the day of , 1992. Town Clerk -3-
MEMORANDUM TO: Light & Power Committee Gary Klaphake FROM: Monte L. Vavra, Finance Officer DATE: May 12, 1992 SUBJECT: Computer Software and Hardware Purchase 1. Financial Management Software During the past 18 months, members of my staff and I have been looking for a fully-integrated software package to meet the needs of the financial management and utility billing functions for the Town of Estes Park. Based upon recommendations by other users and demonstrations we have seen, we have narrowed the choice to HTE, Inc. software. HTE Software is designed to be flexible for the governmental entity without requiring programming to customize it to fit our needs. This is a change from the packages that are currently being used as it seems that every time we want to change something, we need to call in a programmer to further customize the programs to accomodate the new change. A demonstration was performed by HTE representatives on April 22, 1992, for the software modules that we are currently considering purchasing. After the demonstration, the staff have indicated they feel the software would perform satisfactorily in the modules we are concerned about. As with any software, we may want to change our current policies or practices to take advantage of its efficiencies. Those changes can be implemented as we become accustomed to the software. The HTE Software we would be purchasing is the same package that any of their other clients (Loveland) are using. The maintenance plans provide us with updates when available. The modules that I propose the Town purchase at this time are: GMBA (Government Management and Budgetary Accounting) $ 17,500 Utility Billing w/Electric' 35,000 Purchasing/Inventory 17,500 Payroll/Personnel 12.500 Total Licensing Fees 82,500 1 Cash receipts and Land Management software is included with Utility Billing. 1-1
Training is estimated to cost approximately2 20.400 Total Software and Training $102,900 HTE has quoted that the Utility Billing conversion would be billed at $85 an hour, not to exceed $17,000. I am in the process of negotiating with HTE to determine what we are getting out of this conversion and how much we will do in-house. $120,000 was budgeted for in 1992 for software. HTE will extend the warranty through December 31, 1992; annual maintenance would then cost $10,850 for 1993. Prices are subject to change on an annual basis. HTE does offer additional modules which I would like to purchase after the initial conversion is accomplished and we are up and running, such as Fixed Assets at a current cost of $5,000. Other modules offered by HTE that may be of interest to other departments would be Building Permits and Occupational Licenses. 2. Hardware & Operating Software After consultation with representatives from IBM, HTE, and Mr. Bill Westbrook, MIS Director for the City of Loveland, the following hardware configuration for the Finance Office was priced. Gov't. Net Count Description List Price Discount Cost 1 E-10 CPU $47,735 20% $38,188 1 Modem 1,415 15% 1,203 5 Terminals 1,590 22% 6,200 1 475 LPM Printer 11,080 15% 9.418 Total IBM Hardware $55,009 IBM Operating Software: 1 Operating System 7,715 15% 6,558 1 RPG (programming tool) 1,745 10% 1,571 1 Development tool (works w/RPG) 1,745 10% 1,571 1 Performance tools 1,380 10% 1,242 1 Language Dictionary 472 0% 472 1 Query 1,110 10% 999 1 Office 3,425 10% 3,083 1 PC Support 1,650 15% 1.403 Total Operating Software 16.899 TOTAL IBM HARDWARE & OPERATING SOFTWARE $ 71,908 2 Travel costs are billed separately. Most training will be conducted on site in Estes Park; however, some initial training may be at HTE in Orlando, Florida. Annual update training would be conducted at HTE in Orlando. Estimated cost $1,100 plus travel. 1-2
3. Additional Costs to Consider PC Communications Boards; have been recommended to purchase from Connecting Point in Greeley. 4 @ $600 each (estimate) 2,400 Cabling to connect workstations & PC's to CPU's, estimated at $300 to $500 each. estimated 12 at this point @ $500 6,000 Connection of PC's to CPU and configure to properly communicate estimated at $400 to $600 each x 4 2,400 Smooth Start - this is the physical installation, connection of terminals, printers, etc. by an IBM systems engineer 2,000 Uninterruptible Power Supply (UPS) 1/2 hour run time w/5-year warranty 4,000 Point of Sale Devices includes mica encoder 9.170 25,970 Software Support Series: System extra - 24-hour/7-day software Support service 175/month Service to load program updates/new releases, etc. (physical loading by SE) 330/month When the numbers were gathered for the 1992 budget, we were looking at the D-10 model. In March, IBM announced a system enhancement to the E series, approximately a 33% enhancement in power. HTE representatives feel that an Elo model will meet our needs. IBM representatives indicate the Town should purchase an E20 model. Mr. Bill Westbrook, MIS Director from the City of Loveland, reviewed both proposals and feels that the Town should get satisfactory performance from the Elo model. If the acceptance of the system by Town staff is greater than anticipated and demands computing capacity larger than the Elo allows, we can always upgrade to the E20 model; however, I do not forsee this demand for at least a year or two. IBM also enhances the systems about once a year. Assuming past history repeats itself, within a year or two the enhancement should be compatible to the current E20 model. Bottom line is that purchasing a smaller system today may mean an upgrade down the road. 1-3
The 1992 budget planned for $75,000 of hardware. Recap of HTE Software and IBM Hardware: HTE License Fees $ 82,500 Training 20,400 Utility Billing Conversion by HTE 17,000 IBM Hardware & Operating Software 71,908 Estimated Additional Costs 25,970 1992 IBM Maintenance (5 months) 2.525 Total Costs 220,303 1992 Budget 195.000 Difference in Budget $ 25,303 As of the April 30, 1992, Light & Power financial statement, the data processing line item in the customer services department has $37,000 that will be used to offset the budget overrun. 1-4
4 744, i TOWN OF ESTES PARK 0-- -5*91*2 f £'68/~1.4.·. /47,4191 41#Fra-. ~ ~ ~ 4*%'¢i¢t'it·I.)29* - 1 fY'AL [4'i'A;·~14~ i ev . x irx ······· :· I -Al, 211/ C.2%4.80 1 2 7 -)2-t : 4.79 ..\ ..,.1 " .1 A -1 5,43 ty 21#m -4, f / : ,-e»<- A,4.2~~~.72 -,1.-1- NOTICE OF PROPOSED RATE MODIFICATIONS TO THE ELECTRIC RATES OF THE TOWN OF ESTES PARK, COLORADO April 24, 1992 Dear Electric Customer: A proposed modification of the Town of Estes Park's (the "Town") rate schedules, resulting in an increase in the allowable annual consumption for customers on the Residential Rate will be considered by the Town's Board of Trustees at a Public Hearing on May 26, 1992, at 7:30 P.M., in the Board Room located in the Municipal Building, 170 MacGregor Avenue, Estes Park, Colorado. Any electric customer of the Town may appear, either personally or through counsel, at the public hearing to provide testimony or comment regarding the proposed modifications. The revised rates and classifications are proposed to become effective with the first billing period after July 1, 1992, and will affect the rate classifications of certain residential electric customers. The purpose of the modifications are to raise the allowable annual consumption for customers on the Residential Rate from 15,000 kWh to 20,000 kWh. Residential customers on the General Service Small Rate using over 20,000 kWh annually will transfer to the Residential Demand Rate by January 1, 1993. Customers on the Residential Rate using over 20,000 kWh annually will transfer to the Residential Demand Rate by January 1, 1994. Additionally, we propose to rename the General Service Small Rate as Small Commercial Service, the General Service Large Rate as Large Commercial Service, and the General Service Large-Time of Day Rate as Large Commercial Service-Time of Day. You are hereby also advised that the entire proposed modified rate schedules and existing rate schedules are available for public inspection at the offices of the Light and Power Department, Estes Park Municipal Building, 170 MacGregor Avenue, Estes Park, Colorado, between the hours of 8:00 A.M. and 5:00 P.M., Monday through Friday. Enclosed is a Light and Power Rate Summary, which is a comparison of the existing rates and the proposed modifications. If you have any questions or need any further information, please contact the Light and Power Department at the Estes Park Municipal Building or call 586-5331 from 8:00 A.M. to 5:00 P.M., Monday through Friday. TOWN OF ESTES PARK By: 76~c,aut- 2 -2>,tz~ Richard E. Matzke Light & Power Director
TOWN OF ESTES PARK, COLORADO LIGHT & POWER RATE SUMMARY RESIDENTIAL RATES EXISTING RATES RESIDENTIAL Available for electric heat prior to 8/1/81 (using under 15,000 kWh annually) and new services not utilizing electric space heat. Existing electric heat customers using over 15,000 kWh annually will have a grace period until 1/1/94 to transfer to the Residential Demand Rate. Customer charge $3.00/month Energy charge $0.06501/kwh Minimum $3.00/month GENERAL SERVICE SMALL Available for any residential service until 1/1/93. Existing residential customers using under 15,000 kWh annually will transfer to the Residential Rate by 1/1/93. Existing residential customers using over 15,000 kWh annually will transfer to the Residential Demand Rate by 1/1/93. Customer charge $7.25/month Energy charge $0.07044/kwh Minimum $7.25/month PROPOSED RATES RESIDENTIAL Available for electric heat prior to 8/1/81 (using under 20,000 kWh annually) and new services not utilizing electric space heat. Existing electric heat customers using over 20,000 kWh annually will have a grace period until 1/1/94 to transfer to the Residential Demand Rate. Customer charge $3.00/month Energy charge $0.06501/kwh Minimum $3.00/month SMALL COMMERCIAL (Formerly General Service Srnall) Available for any residential service until 1/1/93. Existing residential customers using under 20,000 kWh annually will transfer to the Residential Rate by 1/1/93. Existing residential customers using over 20,000 kWh annually will transfer to the Residential Demand Rate by 1/1/93. Customer charge $7.25/month Energy charge $0.07044/kwh Minimum $7.25/month NOTE: All rates are subject to the additional Purchase Power Rider. Purchase Power Rider is currently $0.00234/kWh based on a Platte River rate increase of 5.94% effective 4/1/92. TOWN OF ESTES PARK BULK RATE U.S. POSTAGE P. O.Box 1200 PAID BOARD OF TRUSTEES Estes Park, CO 80517 80517 ESTES PARK CO 303-586-5331 PERMIT NO. 126 H. "Bernie" Dannels, Mayor Norbert L. Aldrich David Barker Robert L. Dekker Stephen W. Gillette David Habecker George J. Hix Meetings: 2nd & 4th Tuesdays 7:30 p.m. ~ RECYCLED PAPER