The URL can be used to link to this page

08/10/1993 - Special tf? 't ??1 a ?'? ??,' .1 ?'•y ? , s. ? . IaS1a1 ??.. , ` ' - :?Y.Y,a?„t'..=}'y'.J. e.;?' 't ?` ? ' ?,i ;, ,r: ,r, + _'. :p'' ' ?. .!'.ar, '!' ' °i- C hri 1- ?: tf '. ':r ?i A7F•-??? ii• :i; ,r,5?,<.? `?>• '?S?iif'•?%;:"=3. ?"?'+??`{? . ' ; ?. ? ' • ? . .e , s . b, `s. , . i. ? - . , r f.. . o ..y,, , 4 y ? ls> ,C • A.it ; ?.? .,Y a l r r .rs' a r ? 1 r' n ?' 6 • . ,t • y ?? ' ` r , ?, I•?, to ' I + - f f .. -. .. , •• r '4M Y'' - 5 • is ?,. . i• ? -.. '• .., r, ,I. e ? . , k,,tt6°'.?.?f 6': s' sJ?i ..! ?'r .! _ +• 1'• ? 1 . r'e . t ' i ? f ?I" e`a't r? x•11 t? , t? U ?. r ? ? , f.. .4 .. ., f . ? ? ? r ? , ts'F'' ?t.+ 'J. °r` r ! ' f ! :v ' s? _ a ?'.r •; ri Vi , 4?.• •i, ' r, Y. .. ? ??1,'.?t p' ., t »I. ..i r '+ .F i' , t 3 ` e ` • ? fi ` : ? ';.e`?! _ ,.? ?l' s . t • ? r' .. .? .: b+" , + < r r l^ , - x .. t I. • ' - r '??? ' a I Y f ` i I ;'I' AGENDA ^ City Commission Special Meeting . ' '.Tuesday w August 10, 1993 Countryside' Library , 9:00 1. Call to order , 2. Role of Budget Advisory , Committee t , .': '•; Il. 3.. Gas Strategic Plan ?. , t ' ;` 4 ?s Capital Im rovement Project . p Budget• 5. -Police Department Operating ;' Budget l' .. -, 6. Other Departmental Operating ' Bud et g F.. 7: Adjournment. ?=': -}e .. a +' •? S ? ` r , ' ? + ? ` ?? r t r , , . s ` , •L• a .a .. ' a, I , • a 1 I r C I T Y C F C L"E A R W A T E R C -is interoffice Correspondenee'Sheet TO: Copy Recipients of CGS Strategic Plan Dated July 12th FROM: Chuck Warrington; Gas System Managing-Director COPIES: File SUBJECT: CGS Strategic Plan & Annual Budget Book. DATE: July 21, 1993 In.the haste of meeting the July 15th target date for getting the CGS Budget Plan to the commission we pulled together a number of sources of the budget, goals & objectives and income statement projections which had been prepared'at slightly different points along the, process. The unfortunate result was some relatively small but aggravating differences between some of the numbers in the CGS Budget Book which we would like to correct before the budget hearings. 'In total, these corrections are -actually favorable to the bottom line as they make the income statement expense numbers' slightly lower and the profitability numbers slightly higher.. We regret that' this occurred, but hope that everyone will understand that pulling this Plan together was a. big job and the timing was tight: We also feel th;tt this is important'to correct these figures prior to the budget •.iearings with the-Commission to avoid confusion. We are attaching replacement CGS Budget Books with a revision date of July 19th. We would appreciate your destroying any CGS Budget Books you may have dated July 12th. Thanks in,advance for your, cooperation and understanding on this! CSW/sh ,Copy.Recipients: Cyndie Goudeau (15) Mike Laursen Dan Deignan (2) Karen Miles Tina Wilson (7) Ross Sollosy, Coopers & Lybrand r,^ < r 1 , r k' i rr Clearwater Gas' System 1993 - 1994 ANNUAL OPERATING AND CAPITAL. BUDGET Our. Mission To serve the, natural and LP gas needs of the customers in the Clearwater and surrounding Florida SunCoast area in the most ?. safe, reliable and economical manner possible while maximizing load growth, customer satisfaction, - financial. return to the . City of ` Clearwater and the equity value of the Clearwater Gas System. Fr PRELIMINARY Revised: July 19, 1993 ors'. r r -2000 993 2Ia04 1 - 1993 STRATEGIC PLAN r , , r TABLE OF CONTENTS ftm Release CGS Plans for Future Growth. ........................... ' ....... iii Strategic Plan Executive summary ....... . ................ • ................. 1 Business Scope and Ownership ........ ........ , ... ' ............ 2 History ............. .............................:,.., 2 Market Area and Growth Potential .. ' . • ..... .......... . . :..... ... 2 . r Our Mission ........................... . . . . . ............. 3 .., Key Result Areas .............:............................ 4 Our Vision ................. . ...... ' .... . • ......:, .... ... . 5 ..: Key Customers/Commitment Areas ........... ........... . ....... 6 Environmental Scan .................. • . , ......... ... ..... . 7 Business Climate ....... ................................. 8 CGS Strengths ............................................ 10 CGS Weaknesses/Threats . , ................ •..... , . , . • • ......... Strategic Opportunities ................... . .................... 11 12 Key Approval Issues for the City Commission ....... ............ . 13 Program Budget & Goals ,. Departmental Summary ..:.................. • ........ , ....... 14 Administration & Supply Program ....... .................. .. 19 Dispatch Program ........................ . • ............. , .. 23 . . 26 ..... .. Distribution Program .. , ........ .... .... . ...... Service Program .. ........... . .......... ...... , ....... 31 f . Sales Program ................ .... • ......... ............ • . 35 Expansion Program ..................................... Pasco 38 , Marketing & Planning Program ............... ..:............... 42 Income/Revenues/Customers .. Projected Income Statement ............... • .........:........... 46 . ..:... Projected Financials for FY 92193 47 ' . .......... ............ Income to the City • • ......... . ... .............. .. Summary of 48 , Projected Strategic Revenues .... .... . ........... ....... 49 Natural Gas Sales Projections , ........ .................' ........ ,. 51 LP Sales Projections . ............. ......... , .... ; ........... .52 Projected Strategic Customer Growth .. , . .. • ... ................... , . 53 . l s ??? I • ' ' 1 r I J ' ? I r . TABU OF CONTENTS - Continucd . ' , Capital Improvements Strategic Bonding Requirements ......................... ' . '....... 54 Pasco County Expansion Plan :... • ......... : ..... .. ....... ; . 55 Capital Improvement Programs ...... '. . . ........ • • • ....... , ..' : - . 57,' s• OrganixationlSW&g Organization Chart ........ . ........ .:.......... , . .......... 63 ; Staffing Summary for FY 93194 ....................... , ... , .... . 64 Additional Employees Required by FY 99/00.......... ...... ,.. . 65 Appetldix ' ..." .......r , . , ..... '. Summary of Strategies ................... 66 Ten Largest Gas. Customers . , ......... `... , ..... , .. .. , . ' ... 70 Summary of Interruptible Accounts ................... ..... , .. .. ,• • 71 ., . June,, 1993 Financial Statement .... ................ .......... , .. 72 r- • Program Budget Detail ; 74 9 QAdministration & Supply Program .......... , .... ......., ... . . oDispatch Program ....... ............ ............... ... 76 QDistribution Program .... , ......... , .... , ............. 78 Service Program ' ........................ , ..... •........... 81 oSales Program .. . ..... . . ....................... .. , ... 83 f.` oPasco Expansion Program ..................... , ............ 85 QMarketing & Planning Program ..... , , ... , ................. 87 ; . CGS Revenue Budget ............... . ........ . ....... ...... 89 Accounting Treatment ........... .. . '...... ' .... ? 90 ' rw . ............... . . . . .......... . , ....... CGS Overview Data 91. Overview of CGS ... , ........ ... ....... , .: . .............:. 92 r ii •'. fir, : ._ ? to. SEAL++? , cl ATE Public Information Ott" C I T Y 4 F C LE A R W A T E R POST OFF ICE BOX 4748 CLEARWATER. FLORIDA 34 618.4748 NEWS NEWS NEWS NEWS NEWS NEWS IMMEDIATE RELEASE: July 20, 1993 - 11:00 AM For more information: Clearwater Gas System a Chuck Warrington, Managing Director B13-462-6630 n, .N CLEARWATER GAS SYSTEM PLANS FOR FUTURE GROWTH t ,?. The Clearwater Gas System has released to the Clearwater City Commission an aggressive strategic plan which proposes to extend underground natural gas service pipelines into west Pasco County as N well as nearly double the rate of growth of gas service in north Pinellas County. The city commission is scheduled to review this proposal at its budget hearing on Aug. 10, 1993. w The Clearwater gas system is a municipally owned, full-service natural and propane (LP) gas utility. It currently.serves all of `'`xY'i?'f} North Pinellas County from Ulmerton Road to the Pasco county line. It began service in this area in 1923 and has grown to 11,700 customers today. The last major expansion was completed in 1987 € and extended the gas service pipelines north from curlew Road to Tarpon Springs and west into Oldsmar. r? A gas service pipeline was also just completed on the beach + extending service from Sand Key south through the cities of Belleair Beach, Belleair Shores and Indian Rocks Beach.- The gas system is currently adding about 450 new customers per year and has built 472 miles of underground gas main in the service area. The expansion plan proposes to increase the rate ofgrowth to 930 new customers per year by building 46 miles of new lines in the next year in North Pinellas County and'into West Pasco County. as far north as New Port Richey. Chuck Warrington, Managing Director and, Executive Officer of the. Clearwater Gas System, said, '.'We are excited at the prospect of ''Equal Employment and Affirmative Action Employer'' iii 1 f J ' ._' During 1994, the Clearwater Gas System,plans to begin conversion of >,:. . city vehicles, install a public natural _ gas filling station and assist local companies with fleets of vehicles to convert them from, 'gasoline and diesel to natural gas. Florida 'Power -Corp. and Neighborly-Senior Services are already operating.some•vehicles on natural •gas. y Additionally, gas air conditioning technology is now available and economical for office and other commercial buildings. Excellent ?J residential gas. air conditioning equipment is expected to become Yt commercially available in 1994. This plan will enable :the', Clearwater Gas. System to offer these services to customers in North Pinellas and West Pasco counties. Warrington., said, "This is an exciting time for'the. natural and propane gas industries 'as gas technology is improving rapidly'. The prices are. right and there are at'least, two new transmission . f pipelines scheduled to be built into West'Florida'which will make additional-quantities of natural gas available for our customers. "We look forward to aggressively expanding our services, improving ' our quality,,,and satisfying our customer's energy needs as we build together toward the 21st.century", Warrington said. -3 0•? rP / offering additional customers the opportunity of being served with economical, environmentally clean, natural and LP gas - America's fuels of choice. We also are looking forward to, providing an increased level of service to our customers." The seven-year strategic plan proposes to add nearly 7,300 new customers and bury 230 miles of new pipeline by the year 2ao0. City Manager Michael Wright, in his 1993-94 annual budget proposal to the city commission said, "I am recommending the City Commission take a bold step toward improving the long term profitability of the gas system." He emphasized to the commission that the plan would nearly triple the income to the city from $1.2 million this year to.$3.3 million by the year 2000. The Gas System's contribution to the city's budget offsets ad valorem taxes. It is one of the factors'that has allowed the City to hold the ad valorem tax rate constant for the past two years. In fiscal, year 1993/94 the Clearwater Gas System has budgeted to provide nearly $2.1 million of contributions to the city's general fund. This is an increase of, almost $•900,000 from the current fiscal year and offsets 0.5637 mills, or about 11% of the proposed City of Clearwater ad valorem tax rate of 5.1158 mills. That means that a citizen in•Clearwater, with a home assessed at $75,000 and homestead exemption, saves nearly $30 per year as a result of the city's ownership of the gas system. . The Clearwater Gas System's plan proposes a new $12 million bond issue to fund the expansion over the next two years and nearly $25 million in total bonding requirements by the year 2000. This compares to the current growth rate, 'which would have required only about $11 million in capital construction expenses over this same seven-year period. The strategic plan accelerates capital requirements by about $14 million over the next seven years. The plan also would require 24 additional personnel and an increase in annual operating. expenses of about $1.5 million per year (net of fuel costs) in order to support this expansion and provide an increased level of service to the customers of North Pinellas and West Pasco counties. The payback to the City, of Clearwater would be a projected increase in the gas system's contributions to the general fund of $2.1 million above current levels by the year 2000: The Gas System's plan also provides funding for beginning a Natural Gas Vehicle Program in the service area in support of the 1992 National Energy Policy Act and the 1990 Federal Clean Air Act. Both the President and the Governor have taken aggressive action to convert the federal and state vehicle fleets over to this economical, clean-burning and domestically secure energy source. iv ?T l• r .? c. r 'y • r C• i L I- : r r' ¦ ?Y • EXECUTIVE SUMMARY .4 The Clearwater Gas System is well positioned for growth, both within our northern Pinellas County ' existing territory and northward expanding into western Pasco County. Increasing natural gas supply .. into West Florida, enhancements in natural gas technology, and governmental environmental regulations are all external forces which will support this growth opportunity. We have analyzed our current situation, focused our mission and vision, studied the business climate including our strengths and weaknesses and developed four (4) very aggressive strategic opportunities ' that we recommend simultaneously implementing as our road map toward the year 2000. We are requesting the City of Clearwater Commission's support in adopting these as follows:' ' Strategy #1: Continue the Existing Level of Gas Service Operations in Pinellas County (Base Plan gY g GPI ty ) This will allow us to continue our current growth rate which will add 2,800 new customers by the year 2000. Strategy #2: Accelerate Existing Gas Services in Pinellas County This will allow us to add 2,500 additional customers by the year 2000 and provide a level of F services and installation work commensurate with our customers' demand. Strategy #3: Expand Existing Gas Services into Pasco County This will allow us to add 1,900 additional customers by the year 2000. Strategy #4: Develop New Gas Markets for Pinellas and Pasco Counties This will allow us to expand our services into new market. opportunities like Natural Gas .. Vehicles and Gas Air Conditioning. The bottom line from the City's perspective is to allow the Clearwater Gas System to grow by 60% to approximately 19,000 customers and expand the annual dividend to the City from $1.0 Million per year -E to a projected $2.2 Million by the year 2000. In total, Clearwater Gas System currently contributes $1.2 Million in total revenues to the City including Dividends, Payment in Lieu of Taxes and Administrative Interfund Transfer. Implementation of this Strategic Plan should allow our total interfund contributions to grow to $3.3 Million by the year ' ' 2000. f• n CLEARWATER GAS SYSTEM STRATEGIC PLAN 1993 -2000. " Bjjs1nps;,ScoW, ' The Clearwater Gas System (CGS) is a municipally-owned natural gas and liquid petroleum (LP) distribution utility owned by and operating under the Charter of the City of Clearwater, Florida. CGS also operates an appliance showroom and sells gas appliances, installs customer gas house-piping, and services domestic and commercial gas equipment, History The Clearwater Gas System has been serving customers in the Clearwater area since 1923 when we first began with a manufactured gas operation from coal. In 1959 we' discontinued the manufacturing of gas and began receiving piped natural gas from the Florida Gas Transmission pipeline. ' Market Area and Grgk,,vth Potential f Clearwater Gas System serves nearly 12,000 customers in eleven (11) municipalities as well 'as the unincorporated areas of northern Pinellas County as follows: Mul3igipalities Served ell Q6unly Ar Belleair Indian Rocks Beach Crystal Beach Highpoint Belleair Beach Largo East Lake Ozona Belleair Bluffs Oldsmar Harbor Bluffs Palm Harbor Belleair Shores Safety Harbor Harbor Hills Top of the World Clearwater Tarpon Springs Dunedin Our service territory generally extends from UlmertonlWalsingham Road on the South to the Pasco County line on the North and'from the Gulf of Mexico on the West to the Hillsborough County line on the East. We are bordered on the south and east-by Peoples Gas System, Inc., an investor-owned gas utility. Within our current service boundaries, we have significant opportunity to grow as we already have over 450 miles of gas main installed in our current service area but have less than a 5 % customer saturation. We also have significant opportunity to expand northward to the developing areas of western Pasco and, Hernando Counties and even potentially into Citrus County as these areas are not currently served by natural gas utilities. 2 OUR MIS -N The foundation of the Strategic Plan is provided by the Mission Statement. The Mission 'Statement Statement' defines CGS's fundamental reason for being and establishes an'appropriate scope fe Or Our activities. ,From our Mission Statement flows K Result Areas upon which we can focus our objectives and S measure our success. :j . -J I f .7 s `F. x. k 7 F k' 1 t M-.11 KEY RMULTS AREAS Financial PerforMance - Defined as budget performance, growth in dividend returns to the City of Clearwater and growth in the equity value of the CGS. Safety - Defined as conducting our work in compliance with Federal, State and local regulations to insure the safety of both the public and our employees. Municipal/Community Relations - Defined as conducting our work with a high regard for community improvement and a sensitivity for community social needs to foster a spirit of cooperation and pride between CGS, our employees and the communities we serve. Rfm - Defined as insuring competitively priced products and service costs as compared to the industry, alternate energy sources and surrounding utilities. Reliability - Defined as insuring adequate and dependable supply from our pipeline supplier(s) and excellence in the delivery of gas to our ultimate consumer. Lmd CXowth - Defined as customer and load retention, additions and increased gas usage to improve system utilization and enhance profitability. i - Defined as: Customer Service - the speed, accuracy, dependability and overall quality of execution of our construction, maintenance, service, installation, sales and customer support functions. New Customer Programs and Services - the ongoing identification of external customer needs and the development of new programs and services to meet these needs and build profitability. Organizational Effectiveness - The maximizing of organizational responsiveness and the minimizing of operational and regulatory barriers to efficient and' effective customer service execution. Employee Quality - the development of service quality through work force training, education and attitudes. 4 ' MP OUR VISION An important responsibility of executive leadership is to provide a yisi9n for the future of, the Clearwater Gas System to clarify management's picture of what CGS should look like when we reach the 21st century. The Vision portrays the character and spirit of the organization and provides a " foundation for growth. ,i 5 ,. t r A clear understanding of all of our ,Key_CUstame and a balanced commitment to serve the needs of each of these constituencies is vital to our long term health. Each customer group depends on the others and their bond is clear and ongoing communications between all Key Customer groups. To this end, we recognize the following as our Key Customers and Commitment Areas, r 14. , It =4 r Z._ KEY ClINTOMERSICOMMITMENT AREAS 1. The External Customer is our daily service focus. It is our objective to meet and exceed all the reasonable needs of our external customers and to continuously expand so as to lower the incremental cost of our services and make possible expandedlenhanced services through a bigger, more professional, and more cost effective system. 2. Our Employees are the key to our success. It is our objective to select the best personnel, compensate them fairly, provide the best training, communicate our business philosophy and objectives, and build them into a cohesive team who are capable and empowered to serve our external customers' needs and to build our System to meet their future needs and challenges, 3. The Citizens of the City of Clearwater are our owners and the body we answer to ultimately. The City Commission, serves as their trustees and as our Board of Directors. It is our objective to provide safe, dependable and competitively-priced gas service in a manner which our citizens can be proud to own and which provides a public return to offset the tax structure of the City of Clearwater to the benefit of its citizens. 4. Our Internal Customers are vital elements in the successful execution of our mission for our external customers. Other City departments, vendors, suppliers, industry associations, etc., play important roles in assuring our daily and long term success. It is our objective to effectively communicate our needs, build healthy relationships, and demand excellence in all products and services which our internal customers provide which ultimately impacts the quality of our products and services which we provide our external customers. 5. Communications is the linkage between these key customer groups. Adequate communications is the key to understanding and successful execution of our business objectives. Only when all customer groups understand the differing viewpoints and reasonable needs of the others can a balance be reached which meets the objectives of all involved. Communications tools include bill messages and inserts, surveys, focus groups, workshops, interviews, benchmarking, etc. 6. Quality - It will be the fundamental commitment of the Clearwater Gas System to provide quality in our external services, excellence in our internal execution and engender a positive community pride and spirit for our utility. 6 1 ti f F. r` 4 S ENYIRO MENTAL_ SCAN The following trends and issues which will impact our industry were recently developed by the Southern Gas Association through an environmental scan analysis.. T S AND ISSUES IMPACTING-NAUBAL GAS INDUSIBY 1. Restructuring of the gas industry will continue. The process of refining the traditional roles of producers, transporters, and distributors will continue as will efforts to bridge the understanding gap and bring about industry unity. 2. Management emphasis on cost control, efficiency, automation and productivity will intensify. 3.' FERC will diligently pursue policies designed to foster a market responsive environment: The scnpo of state regulations will expand at an increasing rate. 4. The level and volatility,of gas prices will have it significant impact on member companies. 5. An adequate natural gas resource base is available. Seasonal ind peak requirements will increasingly be met by storage service, 6. Increasing competition for gas supply will cause changes in relationships. 7. Capitalizing on research and development results, particularly end-use technology, will require significant financial resources. 8. The effect on the natural gas industry of growing environmental concerns will be positive, and complying with environmental laws will have a broad impact on industry operations. 4. Soft economy with 1-2% GNP growth rate; inflation 2-3%; interest rates stable to +3%. Taxes likely to increase. Globalization will add competitive pressures to U.S. business and industry. 10. Social issues will include health care, the disabled, AIDS, substance abuse, crime, the homeless, child care, education, continuing decline of the nuclear family, aging and economic stratification of the population. 11, To retain a qualified work force, training and re-training programs will increase. 12. Different work ethic and value system of younger employees will produce changers in the workplace. 13. Global change will give added prominence to natural gas as a domestic energy source. M. Gas consumption will be impacted by continued emphasis on conservation, high efficiency equipment, improved building construction techniques and codes and standards issues. 15. Competition among energy sources will intensify, 7 West Florida Ruional 1. New transmission gas pipelines are being built into our area, namely: Florida Gas Transmission (FGT) Company's Phase III and the SunShine Pipeline (owned by Coastal, Florida Power Corporation (FPC) and TransCanada). 2. Pasco County is an obvious growth opportunity for us, but the window of opportunity will probably end when the new pipelines are completed in 1995-96. Unless we are established in our expansion area by then it is likely that competition will provide natural gas service in that area. 3. Peoples Gas System has already opened a Pasco LP office and operations and is actively seeking natural gas franchises in Pasco, Hernando and Citrus Counties. They are aggressively positioning themselves for the availability of the new transmission lines. 4. Traffic remains the area's #1 problem which will result in a continued high level of road work and relocation requirements. A new major expressway is proposed for mid Pasco County which could bring expanded growth to this less populated mid-county area. City of Clearwater 1. The CGS has recently been reorganized after a 1991 decision by the City Commission to not sell the Gas Department. An outside Managing Director was brought into CGS in 1992 and given the charge to run CGS like a business and maximize profitability and return to the City. FY 91192 Net Income before Dividends was $2.0 Million as compared to $450,000 for FY 90191. 2. 3. 4. Two (2) of the five (5) Commissioners have since changed providing some uncertainty on our part as we request final approval to implement our Strategic Business Plan. A City-wide hiring freeze was imposed in June producing further uncertainty and complexity in obtaining approval and implementing a growth plan. There is'increased competition between energy sources in our area namely electric, propane (other providers), and fuel oil. A "discounting" provision approved by the City Commission in February, 1993, has provided a "bandaid" solution. A full rate study was authorized by the Commission in March, 1993, and is in process with Coopers & Lybrand. This should provide the longer term rate tools to insure our rate competitiveness. 9 I r BUSIMS CLIMATE The Clearwater Gas System's business climate is influenced by Federal and State issues as well as t regional and City forces. We recognize these as follows: ' Edual 1. The 1992 Energy Policy Act and the 1990 Clean Air Act provide impetus to increase the use of .5 natural gas --- American's clean burning, environmentally friendly, and domestically secure "fuel of choice". These also provide Federal leadership and mandates for Natural Gas Vehicles (NGVs). 2. The Federal Energy Regulatory Commission (FERC) has issued Order 636 restructuring our industry and, in particular, imposing major changes for our provider, the Florida Gas ? i Transmission Company (FGT). This will require us to purchase and manage our own supply gas. This will increase our fuel costs as will several other aspects of the Order; namely: straight fixed variable (SFV) rate design, transition cost recovery (TCR), and a basic shift in the industry , to tighter supply balance in line with demand. 3. Federal elections have shifted party control of the Executive Branch and created even more change and uncertainty. A major Energy or BTU tax appears likely to pass which could increase our fuel costs even more. 4. The Department of Energy (DOE) is mandating more testing programs and job proficiency requirements which will require formal training and documentation. Alcohol intoxication testing may become a requirement. I . 5. Competitive Natural. Gas Air Conditioning is already available for the commercial market and the technology will be ready for the residential market by 1994. Desiccant cooling is also becoming commercially available for dehumidification to offset A/C needs. ?ta"( Florida ` 1. The State Energy Office is increasingly imposing new Energy Standards and Building Codes which we must stay abreast of and participate actively to influence. 2. The Florida Public Service Commission (FPSC) is requiring more safety regulations and the Florida Department of Insurance/LP Division is requiring more testing and employee competency requirements for propane. 3. The Governor has issued an Executive Order encouraging NGVs and requiring State agencies to take the lead in converting the State Fleet. He is chairing a Southern Governors Alliance# which will encourage NGVs and other energy conversions in support of Federal legislation. . • i 4. Tice Municipal Gas Authority of Florida (MGAF) has been created with much support from Clearwater to provide capacity management and supply acquisition services for the anticipated FERC restructured world under Order 636. Fifteen (15) municipals have joined in this interlocal group. 8 r S5STREMIUS 1. We are the third largest municipally-owned natural gas system in Florida and one of the few municipal "full service" gas utilities, also providing propane (LP) gas,. appliance sales and service, and house-piping installation services. :• 2. We have over 472 miles of existing natural gas mains plus three (3) 30,000 gallon storage tanks for LP gas. Our personnel are well trained to provide the full range of gas services and our staff is motivated. 3. We have only about a 5% saturation in our Northern Pinellas County 'service area and an obvious significant growth potential in our existing territory. 4. The western portion of Pasco County immediately north of our service territory has no natural, gas service. No natural gas service exists even north of this into Hernando and Citrus Counties. Hence, we have obvious growth potential northward. 5. The City is financially sound and has bonding ability to support a major system expansion, 6. We have an excellent track record with gas buying, code enforcement and system safety. 7. We are in the process of a Rate Study which should allow us to be more competitive and our ,. City Commission recently gave us a discounting provision which allows us to compete with alternative fuels. i s 8. The area economy is heavily supported by northern immigration predominantly from the mid- western states and international tourism, in particular from Canada, England, Japan, Germany ' and Greece. Natural gas is well received as a source of energy by these people as it has been more historically dominant in the northern climates. 9. Our largest users of gas are hospitals, health care facilities, hotels, motels, restaurants, and - laundries. These are growth industries in our. service area. 10 s ^t 1. Our current service area is fairly built-up requiring costly expansion opportunities in many cases. 2. Our area is predominantly residential and , service industry dominated. We have little local industrial load opportunity. " 3. We have Peoples Gas on both our southern and eastern borders and the Gulf of Mexico on our west. We have only northward to grow or become blocked on all sides. 4.. There are numerous LP competitors in our area; namely: Peoples, Suburban, Empire, True Gas, Ferrell Gas, Synergy, Bay City, and others, 5. We have two (2) aggressive electric companies in our area; namely: Florida Power Corporation (FPC) and Tampa Electric - (TECO). 6: We have a number of aggressive fuel oil providers in our area; namely: McMullen, Jet Age, and ..x others. 7. We have only one (1) pipeline supplier (FGT) with a second in the planning stage (SunShine). 8. Our window of growth opportunity because of these two (2) pipelines plans to the north is short. We must establish our expansion territory by late 1994/early 1995. 9. We have no marketing staff and virtually no technical expertise in-house to develop the new Natural Gas Vehicle (NGV) and Natural Gas Cooling markets, ' 10. Our weather pattern, while excellent to live in, provides little opportunity, for heating load (ten , year average heating degree days = 532) while we have high cooling opportunity (ten year f , average cooling degree days = 3,613) but the cooling technology particularly in the residential ' sector has not allowed us to exploit this as of yet. i • VI y? r r" STRAIEGGC, OPPORTUNITIES Asa result of our preceding assessment, we simultaneously propose the following four (4) strategies r= designed to accomplish our Key Result Areas and better fulfill our Mission. k ' Shategy #1: Continue the Existing Level of Gas Service Operations in Pinellas County (Base Plan) This strategy will allow us to continue our current growth rate of 450 new customers/year and allow us to generate $800,000 in FY 93194 annual dividends to the City which should grow to $1,1 Million by the year 2000. t Shategy #2: Accelerate Existing Gas Services in Pinellas County This strategy recognizes that we have only a 5% saturation in Pinellas County and have the potential to. grow to at least 10 15%, from about 11,800 customers today to ultimately at least 20;000 - 30,000 customers. This strategy will require 14 additional personnel and $570,000 in first year operating expense to add 400 additional customers/year. This will increase FY 93/94 revenues by $390,000 and generate added annual dividends of $200,000 by the year 2000. This strategy also includes monies for the relocation of the Sales Section to a "shopping center" environment to provide an adequate appliance showroom to support this growth. Strategy #3: Expand Existing Gas Services into Pasco County 1 This strategy will require a very aggressive three (3) year growth schedule to build the 48 mile trunkline, $10 Million in capital bond issues and 7 added employees to build a total of 91.6 miles of new main and connect nearly 1,300 new customers within the first five (5) years. This should generate added annual net revenues of $3.2 Million and annual dividends of $500,000 by the year 2000 and preserve our growth opportunities to the north. This strategy includes the opening of a Pasco field office to support the operations, sales and customer service needs of Pasco County and requires a FY 93/94 ' operating budget of $398,130. t Strategy #4: Develop New Gas Markets for Pinellas and Pasco Counties t _. This strategy recognizes the powerful opportunities available in the emerging Natural Gas Vehicle and Gas Air Conditioning markets and would provide a minimum staff of 3 to begin developing programs to exploit this opportunity. This will require a FY 93/94 t operating budget of $192,960 but is projected to produce annual net revenues of $1.6 Million and added annual dividends of $400,000 by the year 2000. Adoption of all four (4) of the above strategies will require 24 additional employees, allow us to grow. to nearly 19,000 customers by the year 2000 and increase our annual dividend to the City from a current level of $1.0 Million to a projected $2.2 Million by the year 2000. This will require additional i FY 93/94 net operating expense outlay of just over $1.5 Million and the sale of approximately $25 ?.. Million in Bonds over the next seven (7) years. A $12 Million initial bond issue is needed for the first two (2) years expansion requirements. This will produce first year added Net Revenues of $1.7 Million t which are projected to grow to nearly $8.7 Million above current levels by the year 2000. t 12 ;. 1 • r r I I 1. Approve an overall Clearwater Gas System budget for FY 93194 as follows: ' Increase ` JEY 9312A from FY 92193 Revenue Budget* $16,335,000 $3,587,460 Operating Budget $15,008,480 $3,223,330 Employees 91.7 FTE 24 .PTE *Note: Coopers & Lybrand is currently engaged in doing a Rate Study for the Clearwater R ,. ' Gas System which should be completed by late August/early September. For the purposes of this Budget Plan we have assumed that Gas Sales Revenues in total will not change; however, we'do expect some shifts between the classes. We did project in this Budget Plan an increase of $500,000 in Installation and Service •a . Charges to reflect expected increases in labor rates since our current rates were set in the early 1980's. ' 2. Approve in concept $25 Million in Bonding requirements over the next seven (7) years and, in specific, a Bond Issue to Net $12 Million for FY 93194 which is designed to cover the first two ..' (2) years of capital expansion requirements. Future year bond issues will be supported by revisions to the Strategic Plan. 1 ' •. 4 3. Approve in concept a levelized interfund contribution plan such that the Gas Fund will contribute to the City's General Fund as follows: Y.Y Future Yeaars# c ?.k Dividend from Net Income $1,010,000 $1,000,000 Payment in Lieu•of Taxes 508,720 508,720 Administrative Interfund Transfer 522,52 572,520 ' Total Interfund Transfer $2,091,240 $21081,240 , I #Note: Future years to be planned at this level until one-half of the Net Income catches with the Million Divide level. up th $1.0 Dividend At this point the City Commission should reconsider the transfer formulas applicable to the Clearwater Gas System. 13 •I. f i 7 t Y 1 r Z GAS SYSTEM . WSSION STATEMENT . ie $iA x r To serve the natural and LP gas needs of the customers in the Clearwater and surrounding Florida Suncoast area ,in the most safe, reliable and economical manner possible while maximizing load growth, customer satisfaction, financial return to the City of Clearwater and the equity value of the Clearwater Gas System (CGS). The Gas System Department budget consists of seven programs as indicated below. There are currently 67.7 employees (full time equivalent) in the department, and this budget request proposes the addition of 24 employees to accomplish four very aggressive strategic proposals. DEPAMEELREVENUES AND EXPENDITURES- R E E U E S .?? .` ? .?? ? ? V N : ;? ?? : '. :- .. l At W-l'. .B u . d g e C-: ' ` . A? ?-: usted' um a t ed ? . :... : ::.. .:..: : . :: . . : .:: .; ::: : ;. .: 9 .. ,192 : : : : 92 9 3 1 .. . ' • . 92193 . . 4 ; 1 9 93 :Change" ..: :`Gaa,OperxtinB Rcwenues;. .:',10,643;806; 66'4' ::11;016,690.: ,. 180000. ::. 1196 ;'friar Woiking,Capital :.::.; •:..; .; .371;810: 124;290: ::.224.290.:': ,.: ': : :..... ..:. :...1;Q10;000 : 350% Matnri:[s'&;Seryice Cliarges.. 57125 • '.:262;500 177,090:. . .. :490,000:. :. 177% . ` ':a :.. :.., : nstalla on, Charges... .. 2 0,739 -.125;520= .. ;169,060 :. ?.:' ..: .:700000:::: :`. 3 <; Fianchise Fas:` • . ' :: . '162;919 : . ..:140;000' , :I72;120 :App, liduce:S as :. 133547.. .':170;000:.: 270.;-:: - .250;000: .::'..7395 :Other lEautciprise' Fuidds ? : ,:91,Q60 : :...79,260 : :79;260 :: :92,000 :; :16 % ' ;`,Othti`Ravenue :' 287,409: ` 389,0Q0 '.' 314,?6 783;OW:; 149 :T&AL 12,362,55312;360,570 12,747,540 16,335;000 .. 18% ::=,,EXPENDITURES-.' Actual Budget ' Adjusted Requested .. Recommended:' - Percent 91192 92193 ' = 92193 .. . 93194 .: ...:93194: , Chan&:- Administration &'Supply 92952,27,0 9,94.3,2:80 ' .. n/a Sales; 3?3,087, 444,440 437,570, 808,210 $05,150' 8496 `Distribution :. 9,676,481 9,610,410 ' 10;182,450 2,349,450 2,319,380 : -7796 Service 996;848 1,013,560 .11029,630 1,214,290 .' : 1;194;$80':° .'''1696 Dispatch:; :. 140,592' .135,010'' 135,500 157,290 154,700 14% `Marketing &,'Planning ' 195,760 192,960' n/a :::Pasco Gns'Expansion 402,020 398,130 n/a TOT4L` :. .:. 11,187,008 11,204,020 11,785,150 IS,079,240 15,008,480 27% 14 ! r • GAS SYSTEM DEPARTMENTAL = I&OULT AREAS TO MEASURE CLEAR?TFR !AA SYSTEM'S SUCCESS ?.. Defined as: Budget performance, growth in dividend returns to the City of Clearwater and growth %. . in the equity value of the Clearwater Gas System (CGS). Goal: I ' 1. To produce net income before dividends of at least $1.26 million in FY 93194 in order to insure at least a $1.01 million dividend to the City for FY 95196. Total Revenues paid to the City General Fund including Payment in Lieu of Taxes and Administrative Interfund Transfer are projected to be $2.09 million for FY 93194. Measures: Monthly CGS financial statements. SAFETY ` Defined as: Conducting our work in compliance with Federal, State and local regulations to,insure . t.. ; the safety of both the public and our employees. Goals: 2. To replace at least 1.0 mile of old cast iron, xtrube or galvanized main in FY 93194, . r . above and b$yond a budgeted 2.0 miles of highway relocation and main replacement work. f Measures: Butler reports. 3. To repair at least 95% of all outside gas leaks within one (1) work day of discovery in FY 93/94. Measures: Leak reports. MUNICIPAL/COMMUNITY RELATIONS Defined as: Conducting work with a high regard for 'community improvement and a sensitivity for i community social needs 16 foster a spirit of cooperation and pride between CGS, our employees and the communities we serve. ?.fr 5! I 15 1 ! } ! f Goals: 4. To enhance the City's economic vitality by beginning the cost effective focus of CGS resources to maximize gas utilization versus alternative energy sources by providing gas to new structures and installing gas appliances to replace other fuel sources in the North Greenwood community as follows: a CGS performance reports to the City Manager and o Develop opportunities for the focusing of resources by February 1, 1994. o Begin implementing cost effective programs and services by April 1, 1994. Measures: CGS performance reports to the City Manager and indicator . { tracking report. 5. To conduct a CGS awareness program for at least eight (8) city/county commission or major public forum meetings (outside of the City of Clearwater) during FY 93194 and work with local media to obtain favorable coverage of same to showcase CGS. programs and services and build community awareness., Measures: CGS performance reports to the City Manager on outside Commission/major public presentations, newspaper articles, and TV appearances. ERtCE Defined as: ? (• Insuring competitively Priced products and service costs as compared to the industry, :?,.... alternate energy sources and surrounding utilities. Goals: . J 6. To develop a quarterly update of per therm prices for natural. gas, per gallon prices i for LP and customer/service charges vs. competitive fuels by November 1, 1993, and initiate in a timely manner ongoing rate enhancements to maintain an appropriate competitive advantage. To update same by February 1, 1994; May 1, 1994; and August 1, 1994. . Measures: Rate reports. IffiLIABILI_TY Defined as: Insuring adequate and dependable supply from our pipeline supplier(s) and excellence in the delivery of gas to our ultimate consumer. Goals: 7. To implement the Federal Energy Regulatory Commission (FERC) Order 636 by the Florida Gas Transmission (FGT) effective date of October 1, 1993, in as smooth and cost effective a manner as possible while taking a leadership role in the Municipal Gas Authority of Florida (MGAF). 4_. Y ' Measures: FERC report and MGAF minutes. 6 ?. w I6 i ' . .. ?J 8. To develop a customer main line outage indicator by January 1, 1994; begin recording outage data by April 1, 1994; and developing improvement objectives forthe remainder of FY 93194 as well as FY 94195 by July 1, 1994. Measures: Indicator tracking report: LOAD GR WTH Defined as: Customer and load retention, additions and increased gas usage to improve system utilization and enhance profitability. Goals: 9. To increase customer saturation in Pinellas County by connecting at least 850 new customers (150 commercial and 700 residential) and installing at least 15 miles of new main in Pinellas County in FY 93194. Measures: Sales commission reports, Butler reports. 10.. To expand CGS gas mains into Pasco County by installing at least 20 miles of new main and connecting at least 225 new customers (200 commercial and 25 residential) in Pasco County in FY 93194. Measures. Sales commission reports, Butler reports. CUSTQMER N,TISFACTION Defined as: Customer _Se rvyics_ The speed, accuracy, dependability and overall quality of execution of our construction, maintenance, service, installation, sales and customer support functions. New Qustomgr •,Projzram,5_ and Services: The ongoing. identification of external customer needs and the development of new programs and services to meet these needs and build profitability'. Qrganlzational Effectiveness: The maximizing of organizational responsiveness .and the minimizing of operational and regulatory barriers to efficient and effective customer service execution. Employee Ouali jam: The development of service quality.through work force training, education and attitudes. Al 17 j f e ' ' Goals. y . 11. To develop internal departmental service measures and begin measurement of same by no later than October 1, 1993, and work with Utility Customer Support to identify and develop improved cross-functional processes and external gas customer service indicators with improvement targets for the remainder of FY 93194 as , well as . FY 94195 by June 1, 1994. Measures: Indicator tracking report. 12. To complete at least 95% of customer connect requests taken by 3:00 p.m: daily within one (1) working day of the customer's request or by a later date.as requested ' by the customer during FY 93/94., Measures: Service order reports. 13. To identify our largest 25 customers as well as all of our customers who consume a total of 18,000 therms annually. -Make personalized management contacts at "least . semi annually for the first group and personalized employee contacts at least annually with the.rest followed up by management correspondence in FY 93194.. The purpose of these contacts will be to express gratitude for our business relationship, and to obtain customer feedback on our level of service and any'custome'r needs which we might be able to serve better. :. Measures: Indicator tracking report. M. To train at least eight (8) team leaders and initiate at least four (4) employee problem solving quality teams by September 30, 1994. Measures: Team reports. 18 _ ' F • r . CS ` r GAS SYSTEM Administration and Supply DESCRIPTION: Gas Administration and Supply responsibilities include: overall general management and clerical support for tho Clearwater Gas System; long range planning of gas supplies and securing imd transporting these supplies of both natural and LP gas to our bulk transfer points; financial planning and tracking; and storeroom operations to insure the availability of adequate operating, construction and sales materials. Functions of this program include budgeting, payroll, computer systems, facilities/equipment control, environn=W, safety training, regulatory contact, legal/risk issues management, contracting and licensing control. The Gas Administration and Supply Program includes no additional cost centers. PERSONNEL: - Position Title Actual 91/92 Budgeted 92193 Adjusted 92193 Requested 93/94 Recommended 93/94 Gas System Managing Director - - - 1 1 Gas Manager 1 1 1 - - Gas System Controller - - - 1 1 Gas Superintendent 1 1 l i 1 Assistant Gas Superintendent ] 1 X 1 ' 1 Administrative Support Manager - 1 l - - Technical Specialist - - - l 1 Staff Assistant 2 2 2 2 2 Accounting Clerk 1 1 1 1 1 Storeskeeper 1 1 l 1 1' TOTALS 7 8 8 91, 9 19 ., , GAS SYSTEM Administration & Supply PROGRAM REVEMM AND E ENDI IJ$>aS x'ROGRAM-REVS. WES." .`;::... .. .., :.. ;` Bud?et?.: :. Adjusted .? ? Estimated. '. Percertt ........::: .:. ;::'.: ?: 9119Z?a.• .:92193 ?:: ... `.92193: 3194 Change Gas: ritin Revenue oe S 9'309 800 :: . blhii Revenues 770 000 Prior.Working::Cagifal `- 1;010,000 ? Finachi xc'Fers':' 'w? 18 ?000 TOTAY:-REVEiVLTFS ;I1t26 800 1 kb6ilAM'EXE'ENDrWRFSr.':. . At fuel Bt et::' dB A' 'usted ' . ' Re9nested : Recbmtneiided ::Percent ' d1 ::...... 91192';':. :.. ,...: 92193 '.:92193.::93194 93194 C e s Persbfid ?Scrvicd .:: . :39;650:::: .. 385,710 , Other OpeTatimg.::..:::: b,2b8,97U :. .. . .:::b,268;470 .: : ctla .: . Iateriial'Scrvices..:: 327,260 ;:::. 327;260:; ' .:' nla Capital ., •<....': ' .. ' ' ::.. '.:..' . .:: 18,204 '... 18,200: nls ... . :Debt Service :..'1;44;420 ` ; 1,424,420, ..: n/a ' 1;518,720 ,:: 1;518;720 'n1a:::.: T0TA3L:EXPENDrruRES, 909521220` 9;943,260 nla PROGRAM A DGET HIr;HLIGHTS: Personal Services cost reflects the increased cost of one Technical Specialist position to support the Gas Department's training requirements being imposed by regulatory agencies. A Transfers to the General fund have increased $878,010 to cover increases in Payments in Lieu of Taxes, General Fund Dividend, and the Administrative Interfund Transfer. • Inventory . Purchase expenditures increased $752,880 over 1;Y 92193 to cover the projected demand for gas for FY 1993194. A Computer Information Services costs have increased $16,290 over FY 92193 to cover the maintenance of computer equipment. t ., Debt Service Expenses have been increased by $765,000 to cover ten months servicing on? a proposed $12 Million bond issue. This is offset by a $400,000 increase in Interest on Investments (Other Revenues) to reflect the earning power of the unused bond funds prior to their use. 20 ,w. 4 7"T f" r. , { i? r GAS SYSTEM ADMINISTRATION and SUPPLY FMANCIa Goals: L PERFORMANCE 1. To continually manage a department budget which is realistic, adequately funded, done on time and maintained within expenditure limits while. insuring a high level of service l- , to our customers. Authorized departmental budget levels for FY 93194 are: .0 Total Revenues $14.14 Million o Operating -Budget $ 9.94 Million j o Authorized Employees 9 FTE Measures: Monthly CGS financial statement. 1 i Goals: 2. To review our compliance requirements and develop a comprehensive CGS safety plan r by April, 1, 1994, to insure our ongoing compliance with all federal, state and local regulatory requirements for the safety of the public and our employees. . ,, Measures: Safety plan progress report -- technical specialist. Ea MMNjQPA , L/CQMMQNlTY REL,AIIQNS .. Goals: 3. To enhance the City's economic vitality by beginning the cost effective focus of CGS resources in the North Greenwood community by April 1, 1994, as follows: o Identify the current level of effort and coverage by December 1, 1993 o Develop opportunities for the focusing of resources by' February 1, 1994 o Begin implementing cost effective programs and services by, ?.. April 1,, 1994 Measures: North Greenwood indicator report - controller, Goals: 4. To submit a monthly report by the lath of the following month to the managing director which compares the FERC index for natural and LP gas prices with CGS's ' ?I purchase price during FY 93194. . F . Measures: Natural gas month report - superintendent. 21 . l RELIABILIT Y Goals: 5. To implement the Federal Energy Regulatory Commission (FERC) Order 636 by the Florida Gas Transmission (FGT) effective date of October 1, 1993, in a smooth and cost effective manner while taking a leadership role in the Municipal Gas Authority of Florida (MGAF). ' Measures: Progress report -- superintendent or managing director., 6. To develop a long-range supply plan by April 1, 1994, to insure the cost effective availability of pipeline through-put capacity to serve the long-range load project of the CGS. Measures: Develop a supply report - superintendent. 7. To insure adequate supplies of natural and LP gas by monitoring daily gas consumptions and submitting a monthly report by the 20th of the following month to the managing director during FY 93194. Measures: Monthly gas report - superintendent. CIISTQMER I Goals: 8. To develop internal departmental service measures and begin measurement of same by no later than October 1, 1993, and work with utility customer support to identify and develop improved cross-functional processes and external gas customer service indicators by June 1, 1994. Measures: Monthly indicator report - assistant superintendent. 9. To develop a more effective employee suggestion motivation and resolution process which ties to the City Suggestion Program by February 1, 1994, and identify and improve at least two (2) processes which will significantly improve CGS organizational effectiveness and customer service in FY 93194. Measures: Monthly progress report - superintendent. 10. To develop an employee survey and needs assessment mechanism and initiate same by March 1, 1994, , and develop improvement opportunities by June 1, 1994, to build identified needs in the FY 94/95 planning process. Measures: Monthly progress report - assistant superintendent. 11. To train at least eight (8) team leaders and initiate at least four (4) employee problem solving teams by September 30, 1994. Measures: Monthly progress report -- assistant superintendent. 22 GAS SYSTEM Dispatch DESCRIPTION: Gas Dispatch is responsible for monitoring the gas and water telemetry system, and the control and coordination of all communications on tho City's utilities radio network. The Service Dispatchers am. responsible ,for: the handling of all emergency calls on a 24 hour basis and the handling of all other City R emergency calls except police, fire, and traffic signals after normal hours; dispatching all gas service orders and some water, sewer, and stormwater orders; and securing the gas system facilities after working hours. ' The Gas Dispatch Program includes no additional cost centers. PERSONNEL: r Actual Budgeted Adjusted Requested Recommended Position Title 91192 92193 92193 93194 93194 Senior Service Dispatcher 1 1 1 1 1 Property Guards 3.5*' 3.5* 3.7* 3.7* 3.7* TOTAIS 4.5* 4.5* 4.7* 4.7*1 4.7* Overtime .2* .1* .2* .2* .2* *Full Time Equivalent r I • :.. • .23 , r ? .1 I ? I I r GAS SYSTEM Dispatch, • r, PR GRAM ?REVEN'UES.' :'?:'. dg ..........:.. dl .. ?Fstiam?ted '?Pei=?eint 1 e. ... :...:... . ... r- .aim. li inp venue 62 !M 4V ..Othar. Entc rp 000. .. :TOTAL:RE VENV1F.&;:`` 4 7 X15 40' .::. PROGkAM: E7fPENDITURE.S. Bridget;' Acusteti Requested. Recommended:::: -Percent ::.. 92193 .'..: :93194 °_: .' .. :.93194 C11ii PersonsiScivice :49,340 :.. , 108,420::.' . `:.. 1277C10 125,1Y0::. :. '.:1556 ::......:: '1733( : 9;980'; .. Other'Operating : : . : ...::. 12;190'.• -g-050., - .:8:050"°' . -34%,"': :. . :...::'.:a11547:'`:' ..14,290.:'. '12,890 20,540'::.. : 20,540... ...'5996'.:' ... Capital.-:;:::.:..> .::.::.:...::: :.. ::::.'.•'.:0:::.'. :: 2;000 2,QQ0 ,.. , .. ::Debt Service' :0 :..: 0: , D 0 : 0 u7a Trattsfcr{ .0'.::. :,`~:' p' ' p ..p... . . 0 'a!a ::;.TOTAL EXPEENDITIJRES:, : 140,592 :: :135;610... 135,560 157,290: .154,7(10' .14?:':':': .., ROGRAM BUDGET HIGHLIGHTS: A Radio Dispatch costs reflect a 14% overall increase duo to converting two part-time Property Guard positions to full-time to provide adequate shift coverage. Also the fixed charges for Radio and Computer Information Services have increased $8,740. js ?,I f I' of t 1 24 • GAS SYSTEM DISPATCH ' FINANCIA Goals: L PERFORMAhM ` 1. To continuallymanage a department. budget which is realistic, adequately funded, done on time and maintained within expenditure limits while'insuring a high level of service to our customers. Authorized dispatch budget levels for FY 93194 are: f ' ' o Total Revenues, $ 92,000 o Operating Budget $154,700 >:. o Authorized Employees 4.7 FTE Measures: Monthly. financial statements. CUSTOME R SATISEACTION 'Goals: ' .. 2. system by To identify dispatch related problems by developing a tracking ' December 1, 1993, and to provide appropriate user training by June,4, 1994, in order to eliminate any identified problem areas. Measures: Monthly tracking report. 25 GAS SYSTEM Distribution DESCRIPTION ' Gas Distribution is responsible for the delivery of natural and LP gas to the end users in Northern Pinellas County; the construction of all gas mains and service lines; the design and engineering of all gas mains and services; the securing of construction permits and attending construction meetings for gas mains and ' services; the maintenance of all gas main and service lines and setting of all LP tanks and services; system cathodic protection; repairing gas meters and regulators; purchasing and. inventorying of all gas parts and fittings; and assuring compliance with Federal and Florida Public Service Commission and Florida State Natural Gas and LP regulations. The costs centers in this program are: • Gas Construction Gas Miintenauce PERSONNEL: Position Title Actual 91192 Budgeted 92193 Adjusted 92193 Requested 93194 Recommended . 93194 Gas Distribution Supervisor 2 2 2. 2 2 Gas Pipeline Welder 4 4 4 4 4 Gas Corrosion Technician 1 1 1 1 1. Gas Distribution Pipefitter 18 18 18 IS 18 Utility Service. Technician I 1 1 - - Meter Repair Technician 1 1 I, 2 2 Drafting Technician 3 3 3 A 4. Accounting Clerk. 2 2 2 2 2 Pipefitter Helper - - - 3 3 TOTALS 32 32 32 36 36 Overtime .8* 1.3* 1.3* 1* 1* 1 GAS SYSTEM, Distribution PROGJ&AM REVENUE AND EXPENDITURES: PROGRAM REVEN[1ES: ; ` :::::.: ?. ?.:: '; . :: • .: .:..:...:.... :: .: . :. . :::Actual ':Budget,; ::::: Estimated : :Percent _.92193 .' .:. ' : ', 92193,...:: .. ...: .:....:: : ..:. 93194' : Change 'Gas Operatiiig Roveaucs . . 1;666,380 .:. . '..65t7,000 .: .::. .. 3,000 `:.TOTAL REVENUES: :. :24319,380 .. . -::PROGRAM EXPENDITURES: Actual . . Budget ..::Adjusted'..: . Requested :. . Recommended, . Percent ..91192 . .. . 92193 :.':.92193 93194. :. '93194.; 'Charcge. ..: -: Personal Service.' :, '. :'1;249,601' ' 1,297,610.- : 1;304;870: ..: 1,289,110 . 1,259,040 4% `. Oth'ei:Operating 5,210,979, 5,524,370 .. 5,773;620: 241,440 241,440 -96% Inteinal':5ervices- ..'491,403 518;620 ' . 525,220: ,. .266,830 • 266,830 -4996. Ca Pita l.> A0,726. , 57,600,. .. - '61,190 26,500. 26,500. 57% . :Debt Service' :.::: :... 516;901 . 524;830.. 530;170 4,570 4;570 -9996 :Transfer ...... ;,; :. , 2;166,871.. 1;687;380 ....1,987,380.. ' 521;000 521,000 -7496 TOTAL EXPENDITURES 9,6'16;481 9,610;410 10,182,450 2,349,450 2,319,380 77% PROGRAM BUDGET_HIGHUGHTS: • Maintenance Personal Services costs have increased due to the addition of one Pipefitter Helper, which will complete a two-person crew for LP tank installation. Annual increase in LP revenues are projected to be $160,000. • Construction Personal Services costs reflect the increased cost of one additional Drafting Technician and two Pipefitter Helpers to support customer demands for new gas services. Projected increases in Natural Gas Sales and Capitalized Labor & Materials Revenues are $380,000. • Other Operating Expenses - Contractual Services costs have. increased by $78,180 to perform a required cathodic protection survey, a gas leak survey and gas line locating services by outside contractors. • Computer Information Services fixed costs have increased $31,070 over the FY 92193 budget, This charge is for the maintenance of computer equipment. 27 • Construction Capital items include purchase of a Drafting AutoCad Station to support the additional Drafting Technician, This is in the Computerization Long Range Plan for FY 94195, which we propose to move to FY 93194. IL, 1 t 1 r. s a:. r GAS SYSTEM FINANCIA DISTRIBUTION L PERFORMANCE Goals: 1. To continually manage a division budget which is realistic, adequately funded, done on time and maintained within expenditure, limits while insuring a high level of service et levels for FY 93194 are to our customers Authorized division bud : , . g o Total Revenues $653,000 01 Operating Budget $2.32, Million o Authorized Employees 36 FTE. Measures: Monthly budget printouts. 2. To change-out, rebuild and test 1,200 gas meters (a 10-year program of 10% per year) in FY 93194 in order to maintain unaccountable gas losses at less than I% as measured on our annual U.S. Department of Energy Report and Supplemental Gas Supply. and Disposition report for the calendar year 1993 and future years. This # report will be done by April 1, 1994. ' o To change out 1,000 resident gas meters. o To change out 200 commercial gas meters. o To rebuild 1,000 residential gas meters (500 in-house and 500 outside contract). o To rebuild 60 commercial regulators. o To test 1,000 residential gas meters. o To.test 200 commercial gas meters. ' o To maintain' and test 2 BPIIEmcorrectors bimonthly (20% of the total 10). ` o To maintain and test or change 2 rotary meters bimonthly (4% of the . total 50). Measures: Performance reports. SAFETY r Goals. 3. To replace at least 1.0 miles of old cast iron, xtrube or galvanized main in FY 93194, above and beyond a budgeted 2.0 miles of highway relocation and main replacement ' work. w Measures: Butler reports. v ' 4, , ery To repair at least 95% of all outside gas leaks within one (1) work day of disco in FY 93194 and to monitor and recheck 98% of the repaired gas leaks within 35 days to assure permanent repair has been achieved. Measures: Leak reports. I 28 . I I r ?. 5. To complete 214 miles of business section leak survey (100% of total) and 47 miles of residential leak survey (20% of total 233 miles).during FY 93194. Measures: Indicator tracking report. RELIABILI TY k 6. To assist in developing a customer main line outage indicator by January 1, 1994; ,r begin recording outage data by April 1,4994; and assist in developing improvement objectives for FY 94195 by July 1, 1994. r 'r,(j$ OM Measures: Indicator tracking report. R_SATISFACTION , Goals: 7. To install 95% of LP tanks within one week of receipt of tap order and to track LP ' .,., outages'due to lack of delivery, then improve 25 % annually on failure rate of total LP accounts: Measures: Indicator tracking report. 8. To complete new constructions 95% of the time as follows: o On line service, no permit -- 10 working days after receipt of tap order. o On line service, with permit - 30 working days after receipt of tap order. o Main extension under 2,000 feet, no permit --, 10 working days after rf' receipt of tap, order. o Main extension under 2,000 feet, with permit -- 30 working days afte r : receipt of tap order, (Note: Mains over 2,000 feet will require these measures plus additional time for construction of the footage over the standard.) Measures: Indicator tracking report. 9. To create a one-year data base of construction complaints and' make a 10% improvement in the last half of the year below the first half of the year and then improve 10% annually, Measures: Indicator tracking report. 29 t A ?S. I f yi r?= r i r 10. , To prepare construction permits 95% of the time as follows: o Service lines 3 working days. a Gas-mains under 1,000. - b working days. (Nate: ' Mains over 1,000 feet` will require these measures. plus additional time for footage over the standards.) Measures: Indicator tracking report, .11. To keep interruptible billing errors to 2% or less of interruptible bills rendered .. annually. Measures: Indicator tracking report. r' 12. To complete demolition cut and caps within one working day and standard cut and } ° caps within 10 working days after the receipt of service order, or on date requested if later 95 %. tracking re rt. Measures: Indicator tr pn r - 30- t r ' • - :n .-r,.?.. _.r ,fl.•3`.'er 1f7YY`i:1.k:l,Lr.3 k??• v.v sel• ? fY ' .. , • '1 0 ? r ' ' t t 4 f, r GAS SYSTEM' Service DESCRIPTION: + Gas Service is responsible for all commercial and domestic gas service requests including turn-ons and turn-offs of gas meters; the repair service for residential and commercial customer owned gas appliances; the installation of customer owned house piping and appliances; and the securing of necessary gas permits to install gas appliances. The costs centers in this program are: • Gas Commercial & Domestic Repair 0 Gas Installation ! PERSONNEL: Position Title Actual. 91/92 Budgeted 92193 Adjusted 92193 Requested 93194 Recommended 93194 Gas Service Supervisor 2 2 2 2 2 Staff Assistant 1 1 i 1 1 Utility Service Technician 16 16 lb 21 21 Installation Cleric - - - 1 1 TOTALS 19 19 19 25 25 Overtime .9* .9* .9* 1.2* 1.2* * Full Time Equivalent 31 7• I .. I j •i ;'i ?.. ? ''' - ? ' ? ? • 1. i.fr.rl.e .. r , F GAS SYSTEM . Service EROGRAM REVENUE AND EXPENDITURES: PROGRAM .REVENUES: .:' . ' :. . Adu st ?Estirniited ercent :::.. ..::.:' ....::. : .::,. 9119Z';: ` .: .92193 92193,1" .: : •'.:: " '. :: :..::.. ": ;93194 :. Cl?e` . Qas:Operstting Rcyeuues '.= ::.' . a,ssti :'. ' :<Mrteiitls:8i` Soivicti :Charges 490'000"" .. : 700;000 . .:..:. ::TOTAL REVENUES' '. :1;194,88D. :. ?, PROGRAM EXPENDITURES:.. :. dual :Bud et g A trusted ' :; . Requested, . Recommended.': . Percent :.91192 :::92193 :: ' .'92/93 : -93194' : . '. 93194 ? Change :'Personas Servicea^ ::' • °'724,282' '770-890"-.", .. .:752;650: :. : 848 99D :829,580. .: 10%. . Othcc t]peratmg ; :.. :160,974': ° : Z3b;900 `:. :• 152,770 176,970 176,970:.. . ' 9 % Intexnal Services 92;460'.. 200,970 253,780 153,780. '. '. b296 7,54b 4;100 4;090 ' 9,700. '9700 :13796 ' Debt Service :::::. M1: ,. . •: '. ,' :: <1;725: . .9,210. °.: . 0 14,850 14,850..' :. n/a :. Transfer .'D: r0, 0 40096: .TOTAL: EXPENDITURES . : 996148' 1013,S60 ' . 1,029,630 - 1,214,290 1,294,880 :.1696 OG BUDG91 IGHL G TS: • Commercial & Domestic Repair Personal Services costs reflect the increase of one Utility Service Technician to perform commercial and domestic repair services. Projected increase in revenue by hiring this person is $42,000. • Radio Service fixed costs have increased $23,320 over the FY 92193 budget, • Building and Maintenance fixed costs : for Commercial and Domestic Repair have increased $16,140 over the FY 92193 budget, Lust year, the Water Department funded part of these costs which are now fully charged to this cost center. • Installation Personal Services costs are up due to the addition of an Installation Clerk and four Utility Service Technicians. Anticipated increase in Installation Sales in FY 93194 is $166,000 as a result of the additional Utility Service Technicians. • Installation and Service revenues have been increased by $500,000 based on preliminary rate case projections of the' increase in labor hour charges. • Capital items include a PC Workstation and Software for the Installation Clerk. ? r. t. l .. ' r:. 4 f 32 GAS SYSTEM, SERVICE . FINANCIAL PERFORMANCE Goals: r 1. To continually manage a division budget which is realistic, adequately funded, done j on time and maintained within expenditure limits while insuring a high level or service to our customers. Authorized division budget. levels for FY 93194 are: o Total Revenues $1,19 Million o Operating Budget $1.19 Million o Authorized Employees 25 FTE Measures: Monthly budget printouts. 2. To support the departmental goal of producing net income before dividends of at least $2.0 million in FY 93194 in order to insure at least a $1.0 million dividend to the City for FY 94195 by the following: o To increase installation revenues 116% over the previous year to $366,000. o To provide installation estimates to 757o of new service line connections sold by gas sales, o To secure installation work on 70% of the estimates provided to new service line connections sold by gas sales. o To install 50% of the water heaters provided in the marketing program. o To install 50% of the water heaters sold by gas sales. o To increase overall service revenues by 37 % over the previous year to $242,000, to be broken down as: $70,000, Code #212; $10,000, Code #214; and $152,000 - Code #221, Measures: Monthly CGS financial statements. QUNTOMER SATISFACTION Goals: 3. To limit service callbacks on all commercial and domestic repairs to 5% or less during { FY 93194. Measures: Indicator tracking report. 4. To complete at least 95% of all appliance repairs within three (3) working days of the customer's request or by a later date as requested by the customer during FY 93194, _ Measures: Indicator tracking report. 5. To complete at least 95% of customer connect requests taken by 3:00 p.m. daily within one (1) working day of the customer's request or by a later date as requested by the customer during FY 93194. Measures Indicator tracking report. 133 iii ' .' s ? j . r , i - ''• • . ? ! 'y'• ,. _ -F. ? x 1, ,' r. ,' ? . ?r" `.y?` 'dl's •*);. "4_ , `!. , - .s I sr , ' 11 ? ?, 5?'t` f, t. 1.?•.?! ?y' .. '•1: ,-.?'e,'??i To comp,, 956 of domestic conversions ' propane to natural, within 15 working p days after the meter has been set, with customer approval and.to complete 95% of commercial conversions, propane to-natural, within 20 working days .after the meter: t" has. been set, with customer approvalt Measures: Indicator tracking report. ' 7. To maintain a'5% or less customer•complaint,on service and/or* repair work total. Measures: Indicator tracking report. `. . I , a ,R .`a7j . _ , ' -• , t r Lam, o '''? 3Q j ? ' ? ? • S,',;'] :d, r?.:!°ri,t ?i7'1P'r?3'r xlfr:S•t:? N?i•t s e ?'.f-l.' -; .le iii ?4',1'?•??"F:.?Ika?a' T GAS SYSTEM Sales DESCR ON: Gas Sales is responsible for the sale of natural and LP gas to commercial and residential customers; the axle of natural and LP commercial and residential gas appliances; the estimating of natural and LP gas house piping installations; appliance inventory management; deposit collection, appliance invoicing, and contract billing; administration of gas sales programs and follow-up advertising programs. The Sales Representatives assist customers in the selection of gas appliances in the show room, at the customers' premises and at area sales and trade shows. ` The Gas Sales Program. includes no additional cost centers. J PERSONNEL: Actual Budgeted Adjusted Requested Recommended Position Title 91192 92193 92193 93194 93194 Gas Sales Manager 1 I 1 1 I Gas Sales Assistant - - ' - I 1 Gas Sales Representative 2 2 2 4 4 Staff' Assistant 1 I' 1 I 1 'T'OTALS 4 4 4 7 7 35 f . A•, I' f , f f r• GAS SYSTEM Sales REVENUE P.BQQRAM ES• PROGRAM REVENUES: .: . ActtW Budget ` ..... Ac usted: _ .Estimated . Percent. :. .. . : .;_92193'<, ,. 92193.. ..:`.:.93194 "C e .. d".Qperatuig Revenues :; 545;150.: .. ..; Appliance Sales ;. 250000 .::': Otbbr `Revwties.:. ;: ..:. :. :... . ".TOTAL REVEN?]ES: >::::: ' " . ..... ,:, : .., ..... ::: ..:..:. °: . 805,iSQ:.', ...:.. i x ; PROGRAM >;.:.•.AetuW.:. .;:Budget . ., Adjusted: ` .. Requested: Recommended :Percent :, ...:. ::.:.::.:.:.::.: ..... ,.: 91192;, :'92193.. - 92193 93194 :, ". 93194 Change .Personal•Service.,:;::..;::: 131,735. :. 146;670 146,400 `, : : 241,930•. • ,.. ;238,870. '.. 6396. `.: ;'..Other Operating;.::::. , .:. ; 238,333 . ::.28x;450 . " :.,277;850 : 545 ,040:::. .: : ??.::545..9696' 2,919;: '.',.::'12,320 . -12,320 .15;040 :2291; Gpit?I: ~::: ' 1fl0.° 6921H3.. ::' 52U9b..... 6;200 6i bi. Service.::: ;:.! 0 : > :.::.0: .. ... 0 . ala ., .. . :. ' '':Transfer . :.. 0 TOTAL `EXPENDITURES: ' 73,087 444,44Q:. : 437;570. . 808;214 : . .' :SQ5;150 849n . . i.. r .. . . PROGRAM BUDGEl 14T HUGHTS: 4. A Personal Services costs are anticipated to . Additional funds of $35,400 were included in the 4 increase due to the addition of one Sales Sales Budget for the opening of a sales appliance Assistant and two Sales Representatives. showroom within our gas service area. This is projected increase in Appliance and Parts Sales over and above what we currently pay for space is $115,051. Natural and LP Gas Sales revenue and maintenance at the Utility Customer Support increases are projected to be $340,000 annually. Building. A Other Operating - Inventory purchases have t Internal Services costs have increased $6,500 clue ' increased $90,000 over FY 92193 to cover the to higher Computer Information Services and S , anticipated increases in customer demand in FY Radio Services fixed charges. j 93194. A Advertising and Other Promotions have increased • Capital items include a PC Workstation to $117,000 to cover anticipated radio, newspaper process Sales billing and inventory, speeding up and TV commercials and the Water Heater Sales customer billings and reducing time required to ; Program. receive payment, 36 t ! GAS SYSTEM SALES., Goals: 1. To continually manage a sales division budget which is realistic, adequately funded, done on time, and maintained within expenditure limits while insuring a high level of service to our customers. Authorized sales budget levels for FY 93194 are: o Total Revenues $260,000 o Operating Budget $805,150 o Authorized Employees 7 FTE Measures: Monthly CGS financial statements. MUNICIPA Goals: L/COMMUNITY RELATIONS ' 2. s economic vitality by beginning the cost effective To support enhancement of the city focus of CGS resources in the North .Greenwood community by April), 1994, as follows: o Identify the current level of effort and coverage by December 1, 1993. o Develop opportunities for focusing resources and replacing . other energy sources by February 1, 1994. o Assist implementing cost effective programs and services by April 1, 1994. Measures: Performance reports. .. Goals. 3. To increase customer saturation in Pinellas County by connecting at least 850 new customers and adding 1.5 million commercial/industrial annual therm sales (CATS) in FY 93194. Measures: Sales commission reports and indicator tracking report. 4. To install at least 500 new water heaters (475 in Pinellas and 25 in Pasco) for new home builders and electric conversions in FY 93/94. Measures: Sales commission reports and indicator tracking report. 5. To maintain inventories and sales programs to sell at least $250,000 of new appliance and parts while maintaining an average gross sales.profit of 30% in FY 93194. Measures: Sales commission reports and indicator tracking report. 6., To ir;stall at least 200 new gas lights in Pinellas County in FY 93194. Measures: Sales commission reports and indicator tracking report. .¦ GAS SYSTEM Pasco Gas Expansion DESCRIPTION: The Pasco Gas Expansion Program will be responsible for capturing all of the costs and revenues associated , with the extension of the Clearwater Gas System into Pasco County. A strategic plan is being concluded which recommends system expansion to the north. This program will enable the manpower and operating budget to accomplish same. The overall goal of this expansion is long range growth and profitability. The Pasco Gas Expansion includes no additional cost centers. PERSONNEL; . Iw o • Position Title Actual 91192 Budgeted 92193 Adjusted 92193 Requested 93194 Recommended 93/94 Operations Manager - - - 1 1 Customer Service Representative 1 1 Utility Service Technician - - 1 1 Pipefitter Helper - - - 2 2 Gas Sales Representative - - - 2 2 TOTALS - - - 7 7 Overtime - - - .3* .3* .. - * Full Time Equivalent E ?. 38 GAS SYSTEM Pasco Gas Expansion S• , "GR, 7K .7 V ,.: ' j: v: :.' Bu c A?cteal- t .: :......: .::. 'A hated`: `+' Estiat " `Percent' 91l9Z?;? ? ':92193 '92193 ?; 93194: :C futfige C1ia Revenues " 398 130::: 1- REVENUES- r :'?398I3U; . l PROGRAM"EXPJE:NDTTURF.S. - Actual:-.: =Bti et: 'As>justed • :., Requested Recoiniiiended Percent:. ....:........:..:.:.:. r ; Pe sonsil ftVice: `x215'590 212100'- /a " OffieT,.t lCrilting :. 0:': 163 ,36 . ' . ' 63,360 I n1a' InteiI:Services 14,970' 14970 `Capital:':;> 1,700 ' 7,700.. n/a ;Dcbt'Scrvicd . 0. 0 n/ :. .. r EXPENDITURES .442,020:. .. ; . 398;130 :..:.n/a ::..: GET HIGHLIGHTS: A This is a new program to expand natural gas services to Pasco County. The anticipated impact to. the Gas Department budget is $398,130. Projected first year natural gas revenues.are $400,000. Net revenues of $3,2 Million annually are projected once the project is fully complete. 39 r' 3 r J r GAS SYSTEM PASCO GAS WMANSION FINANCIA L PERFORMANCE :. Goals: 1. To continually manage a. Pasco Gas Expansion program budget which is realistic; adequately funded, done on time and maintained within expenditure limits while insuring a high level of service to our customers. Authorized division budget levels for FY 93194 are: o Operating Budget $398,130 o Authorized Employees 7 FTE Measures: Monthly budget printouts. 2. To support the department's objectives'by developing a proactive Pasco Gas Expansion Program contribution to the CGS business plan for FY 94195 by July 1, 1994., Measures: Clearwater Gas System business plan. ' MUNICIP ALXOMMUNITY RELATIONS Goals: 3. To conduct a CGS awareness program for at least four city/county commission meetings during FY 93194 and to work with local media to obtain favorable coverage of same to showcase CGS programs and services and to build community awareness within Pasco County. Measures: Commission presentations, newspaper articles, and TV appearances. LOAD GR OWTH Goals: 4. To expand CGS gas mains into Pasco County by installing at least 20 miles of new + main and connecting at least 225 new customers in Pasco County in FY 93194. ' Measures: Indicator tracking report. 5. To install at least 25 new water heaters in Pasco County for new home builders and electric conversions in FY 93194. Measures: Indicator tracking report. 6. To support the department's objectives by being a sales conduit for Pasco County ( developers and customers to make them aware of new appliances and parts availability !.? through CGS in FY 93194. Measures: Indicator tracking report. _ 40 ?f I - 1 r , `. .. I ?'f•ir? ?3 '?? jt r t " , l 1 -` •. c { . . .,t 3 .. ` • • - . . . I. C=MER SATISFACTION Goals: 1 7. : > To support the department's objectives by identifying those customers in Pasco Coun tY. who fall among our largest 25 customers as'well as all customers who consume a total -! of 1$,000 therms annually. 'l'ake the lead for-making the personalized management contacts for'the Pasco County customers at least semi-annually for the first,group'and °' > personalized employee. contacts at least annually with the rest followed up by" management correspondence in FY 93194. The purpose of ,these-contacts will be to express gratitude for our business relationship and to obtain customer feedback on our.,, level of service and any customer, needs which we might be able to service better.-, Measures: Indicator tracking reports. ,i. • i r? ? ' '; . ' ' r' • . f : a., : 1. 41. r , kr ,• J ;? f R,' ,ir i. ? ?} ,f`fta11. ,I Y. {SF • i ff ? GAS SYSTEM Marketing'& Planning DESCRIPTION: Ga' s Marketing & Planning is responsible for planning, feasibility assessment and development of marketing progtama to build load and improve system profitability; designing new systems to make the gas system more effective and responsive to customer needs; advertising strategy to improve the marketing of sales programs; building better governmental relations; measurement of customer satisfaction levels and the design of programs to increase service levels to meet customer expectations; and the applications engineering and sale of large commercial and industrial end use projects to build load and improve load factor. _ Ilse Gas Marketing & Planning Program includes no additional cost centers. PERSONNEL: Position Title Actual 91192 Budgeted 92193 Adjusted 92193 Requested 93194 Recommended 93194 Director of Gas Marketing & Planning - - - 1 I Gas Marketing Engineer - - - l 1 Staff Assistant ' - - - I 1 TOTALS - - - 3 3 f J 42 f' F 1 r 1 1 1 il. ? 4 GAS SYSTEM Marketing & Planning PROGRAM REVENUE ND EXPENDITURES: 1 PROGRAM f:. 1 ?.i.. <' A :ea1'. d B et A?ust u ed dS :stiiita ted?° . P t? :r.. .?:' 9119Z`?'•: ....... ......... :.:.: :: ... ..... . ..9x 93:?' ;92193: 1 ?9 3194 .: C e . Claa` Revenues : < . } • . 92 '1 960. , .? . TOTAi `R1E >`? VENUFS?? ? .. ' 19 9G0?. 2 .. '.. .. '•, is . OGI[tAM'EXPENDrrURES: , Adl 'usted :Re4nes ted; . . Recommended:,, :Percent'' ;:.91191: ;'. 92193:92193'. :93194..:' .. 93l94:: 'Clui e :. .:.. ':::.Personal Service °..::=:':•::=::..::: ;: r '°;..:,::': 113' 10 : 110 910: er:'. i$itui :... 8 <. 67 550 67 554 nla' :>:::'?teTnal:.Se1V1CC&::: • 5;200 2 .:. . . •. Capital .:......:. • .'..: ' :. '. 9,300 9,3.00' ` •ia7a: Dobt Sarvrca •::: F N l?• nla' ;T(?TAIi:11"ENDITUREB :..: °. :::: • :.<. :.: ;. .::', ::..:: ':. . ' ... a95,764 192;960A:::' JI OGRAM BUDGET 14TGHLTGHTS: A This is a new program to market new technologies such as' Natural Gas' Vehicles, Cogeneration and Gas Air Conditioning. The initial impact to the Gas Department is'$192,960. Additional not revenues of $1.6 Million are projected by FY 99100. 43 GAS SYSTEM ` MARKETWG AND PLANNING FINANCIA L PERFORMANCE r Goals: 1. To continually manage a gas marketing and planning program. budget which is realistic, adequately funded, done on time and maintained within expenditure limits while insuring a high level of service to our customers. Authorized 'prograrn budget ; ' levels for FY 93194 are: r o Operating Budget $192,960 o Authorized Employees 3 FTE , ? MUNICIPA Measures: Monthly budget report. L/COMMUNITY RELATIQ?S , ? Goals: 2. ' r , To support the department's objectives to enhance the city's economic vitality by considering how to cost effectively focus gas 'marketing resources in the North Greenwood community by April 1, 1994, as follows: f + o Identify the current level of effort and coverage by December 1, 1993. i o Develo ' ' f p opportunities or the focusing of resources by February 1, 1994. a Begin implementing cost effective programs and services by April 1,. . 1994. ^ Measures: Performance reports. 3, To conduct a CGS awareness program for at least ten city commission meetings during FY 93/94 and to work with local media to obtain favorable coverage of same to showcase CGS programs and services and build community awareness. Measures: Commission presentations, newspaper articles, and TV PRICE appearances, `. Goals: 4. To support the department's price objectives by pro-actively, seeking out how other utilities price their products and building these findings into new and . enhanced marketing programs during FY 93194, Measures: Rate reports. i j .,,. - 44, , F , E ? • 1 • ' 1 • _ r• , 4 CUSTOME R SATIS.EACTION . Goals: ; F 5 . To take the leadership role in developing an external customer service survey and assessment•mechanism and"administer same by February 1, 1994. Develop needs j . improvement opportunities by May 1, 1994, to build identified needs into the FY 94195 planning process. Measures: Performance reports. 6. To take the leadership role,in identifying our largest 25 customers and all of our customers, who consume a total of 18,000 therms annually. Take the lead in 1 scheduling personalized management contacts at least semi-annually for the first group ` 'and personalized employee contacts at least annually with the rest followed up by management correspondence in FY 93194: the purpose, of these contacts will be to express gratitude for our business relationship and to obtain customer feedback on our '.: level of service and any customer needs which we might be able to serve better.. 1 7 Measures: Performance reports. 7. To develop and implement at least two (2) new and innovative programs during I FY 93194 - a natural gas vehicle. Program by March' 1, 1994, and another by : -' , July 1, 1994. ' Measures: New programs and associated budget reports. a ' 45 FI ? ,'d r CSw; 07/19/93 CLEARWATER GAS SYSTEM P ROJECTED INCOME ST ATEMENT ($ MILLIONS) MM E93/94 FY94195 FY951W 96 7 C±Y97/96 FY98/99 D29/00 RE1LENUES Sales of Gas (NG & LP) 11,45 12.31 14.37 16.08 . 17.90 19.94 21.39 22.85 Less Gas Commodity, -3.82 -4.12 -4.83 -5,41 -6.04 -8.74 .-7.23 -7.73 Gas Sales Margin 7.63 8,19 9.54 10.65 11.86 13.20 14.16 - 15.12 µ Other Revenues 1.03 1.79 1.86 1,92 1.99 2.04 2,10 2,15 ! Bond Interest Earned 0.00 0.40 0,12 0.27 0.11 0.15 0.12 0.05 Net Revenues' 6.66 10.39 11.52 12.84 13.96 15.39 16,38 17.32 • EXPENSES Gas Reservatlon Charges 0,61 0.86 0.86 0,86 0.8B 0.86 0,86 , 0,86 ' Admin. & Supply 4t 3.43 2.64 2.67 2.70 2.72 2.75 2.78 2,80 Dispatch 0.13 0.15 0.16 0.16 6.17 0.17 0,18 0.19 - Disflbution In Admin, 1.14 1.17 1.21 1.24 1.27 1.31 1.34 ' Service # 1.05 1.18 1.18 1.16 1,18 1.18 1.18 1.1B Sales # 0.52 0.81 0,8i 0.81 0.81 0,81 0.81 0.81 Pasco NA 0.40 0.44 0.47 0.50 0,54 0.57 0.60, Marketing NA 0.19 0.19 0.19. 0.19 0.19 0.19 0.19 Depreciation 0.54 0.59 0.88 1.07., 1.20 1.32 1.42 1.42 Interest Expenses 0.50 - - - - 1.10 1.21 1.60 1.60 1.63 i.83 1.83 Total Expenses - - 6.96 - - - - - - 9.06 - - - - - - - 9,57 - - - - - - 10.25 - - - - - 10.47 - - - - - - 10.92 - - - - - - - 11.13 - - - - - 11.22 Net Income 1,68 1.32 1,95 2.59 3.49 4.47 5.25 6.10 Dividends* -0.22 --1.01 -1,00 -1.00 -1.00 -1.00 -1.52 -2.24 Net Change in Equity ------ 1.46 ------ 0,31 ----.--- - 0,95 --..... - - 1.59 ---..._... 2.49 ------ 3.47 ------ - 3.73 ----- 3.86 Beginning Equity Balance • 6.23 7,69 8,00 8,95 10.54 13.03 16.50 20.23 Ending Equity Balance 7.69 0.00 8.95 10.54 13,03 16.50 -- 20,23 - 24.09 Notes: * Assumes levelized $1 Million dividends beginn ing for FY 94195 until halt of Not Income catches up. Dividends may be offset by higher, City assessments for payment In Lieu of Taxes and Administrative Interfund charges. • . 4t Assumes addition of 24 employees in FY 93/94 which is ail 4 Strategies and addition of 15 additlonal employees (12 in CGS and 3 In UCS) to meet the growth in customer maintenance workload. 46 % in 1 n !W n? I nn I iv aa{gr 1+{ Z r: 1 o1C4 1 v ia.-nnParo I t? ?n i o nnID VIt id ? i e ? 1! k 1 ?'.: U 1r0f? i 'itz n , 1? 0N?QY3?f GY ? ? r? f n -00 0 a .•.JN b 1 r? I ?f qNwT o.i? , P" nN I NrP i a a r V I1Phh Nh hNr , r p l ?? h l ?. r M?? I qq I r!'f ngwr,r i !- r 1 R I r, I? n 1 P. I'I ^ I r 1 r l ' ?? r I I I I , ..: ..in npp I in o I in in in I b oy dry In ?01 ? 1 p M ?FQ.. ?f o I$ S I ?a q? ?n i a tlN I ?f N?II Nr r 1 h w 11 1 h r l q A? 1 4 r, I r I r 0.Q .• 1 i ? I , , , ? ..i , ' ? 1 k I I i w n? I ?y 00 1 0 00!h .- 1 n , fir , fw qnY Inh , „ ??rNpf'it , tF r ( r I/VNrw 1 P Iff?l 'E I a I 1 i I p p4 hN I n g r O n` t I h P N I h N r N I R Q?? 1f1 n l? f hNIj.rn jn N j I j Ir a I ? I I I I Val -3 n 1 N I p rrrpp0 n n N I h n o I n aoIO r n.- I ' "w? 0?? 'f rNgY1 ? , N 1 N - Il?f Nr r I " ?I7 NQrQ 1 ?• N I d r p0nnN 1 h O M I rC 40 f) N 1 N 1 to I to V rN O'?Y?f I I?b r ? I .. rI!'f Nr r! r 1 r 1 l I I U?j n?.tl I I tl 1 I I I of oN I R ! ONh f lflr 1 a1 Nr I osss 1 h ? A ?VY1A `"' " r^ i3 J ad I uih^ I n ? ?he'7r1? ?? TN'I T N hrr ? r 1' I n I 1 1 1 N r I I I I 4 0 r i ' ' lug • z 4l p 3 O w O wOZZ 0 ?w Za U a aNz x 2ayio xw ?z O N w 2° 11 U?x y yz w 0zxW, ?, xaj o a, . it w P- yzV c' z yz ??tanF ?? a ?2In y 0 ? Q wOyq ', w uL'i a ??csi?s c0ic0iz z Uw a ' h wyC7 ?ww ¢ooavWiv?Qm a zza U'??.?? ate . 0 W V) a, E zc z vaiogugvo za z Z .47 ' ' te S t r • f ti i CSW: 07/19/93 CL.EARWATER GAS SYSTEM SU OF INCOME TO MMARY CIT`1 THE _ (S MIWONS) _ FY9 93 93 4 94 5 FY95198 96 9 FY97/98 MB M 99 00 HEVENUES Gross Revenues 12.48 14.50 18.35 18.25 20,00 22.13 23,61 25.05 Gas Costa -4.63 -4.98 -5.69 -6.27 -6.90 -7.60 -8.09 -8.59 Bond Interest ' 0100 -0.40 -0.12 -0.27 -- -0,11 - ` -0.15 -0,12 -0.05 ' i44 Gab Related Ravoriua6 --- 7.FZ - -- V.12 - --10.54 - --11,71 12.99 --14.38 -- 16AU ---1ti.41' - EXPENSES Gross Budget 10.80 13,18 14,40 15.66 16,51 17.66 18,36 18,95 ?? • Gas Costs -4.63 -4.98 -5.69 -6.27 -6.90 -7.60 -8.09 -8,59 Depreciation -0.54 -0.59 -0.88 -1.07 -1.20 -1.32 -1.42 --1,42 Payment In Ueu • -0.43 -0.51 -0,51 -0.51 -0.51 -0.51 -0.51 -0.51 ? Admin. Inforfund * -0.56 -0,57 -0.57 -0.57 -0,57 -0.57 -0,57 -0.57 . Not Gas Related Expenses ------ - 4.64 ----- - 6,53 ----- - 6,75 ----- -- 7.24 ---- - 7.33 ----- 7.66 ------ 7.77 ------ 7,86 SCENARIO #1 CITY INCOME _ Dividends 0,22 1.01 1.00 1.00 1.00 1.00 1.52 2.24 r - Payment in Ueu * 0.49 0.51 0.51 0.51 0,51 0.51 0,51 0151 l Admin. Interfund • 0.56 0.57 o.57 0.57 0.57 0.57 0.57 0.57 Subtotal Income 1.21 2.09 2,08 2.08 2.08 2.08 2.60 3.32 of Net Revenues 15.4% 22.9% 19.7% 17.8% 16.0% 14.5% 16.9% 20.2% % of Gross Revenues 9.7% 14.4% 12.7% 11.4% 10.4% 9.4% 11.0% 13.3% Utilitles Cust. Support 0,25 0,24 0,27 0.30 0.32 0.35 0.38 0.40 Garage Interfund 0116 0,22 0.22 0.23 0.23 0.24 0.24 0.25 Other Interfund 0.14 0.36 0.36 0.35 0.36 0.36 0,36 0.36 ----- Subtotal Support ------ - 0 55 ----- - 0.82 ----- 0.85 -------- 0.89 ---- - 0.91 ----- 0.95 ------ 0,98 - 1.01 ?.._ Total - - » - 1.76 - w- 2.91 - -- 2.93 --- 2.97 ' -- -2.99 - -- 3A3 --- 3.58 .. ~- 4.33 - % of Not Revenues 22.4% 31,9% 27.8% 25,4% 23,00/6 21.1% 23.2% 26.4% M ALTERNATE- SCENARIO 02 CITY INCOME „ Payment in Lieu 0,43 0.51 0.65 0.74 0.82 0.90 1.00 1,06 Admin. Interfund - 56 - 57 0.79 0.86 - 9l n 9- 0? - 1 -- - - ------ 0.99 -- - - 1.08 ----- 1.44 ---- -- 1.60 - - - 1.73 - -- 1.87 --- - 2,01 --- 2.10 . Increase from Scenario #1 0.00 0.00 0.38 0.52 0.65 0,79 0.93 1.02 Adjusted Net Income 1.68 1.32 1.59 2.07 2.84 3.68 4,32 4.08 Adjusted Dividend 0,22' 1.01. 0,B4 0.66 0.80 1.04 1.42 1.84 Total City Income ------ - 1.21 ----- - 2.09 ----- 2.28 ------ -- 2.26 ---- - 2.53 ----- 2.91 ------ 3.43 ------ 3.94 %ofNetRovenues 15.4% 22.9% 21.6% 19.3% 19.4% 20.2% 22Z% 24,0% %of Gross Revenues 9.7% 14.4% 13.9% 12.4% 12.6% 13.1% 14.5% 15.7% NOTES: " Assumes Waked payments to the City In these areas horn FY 93194 through FY 99100 so as to C - recover Increasing Gas Fund c ontributiana to the City through the Dividend. # Assumes Payment In Ueu of Taxes Increases as 4.5% of prior year Gro se Revenues and Administrative Interfund charges'lncrease as 5.5% of current year Gross.Budget. ..: 48 1_I IJ I_I I_ i O mth?lry t7 I r a) ?04t I w aN aw I - N N W Ct O Q w0 00 I 0000 I Cl D 17 gC4w I 0d000 1 to 0 r t7 I 00 cio 1 0 1 to r0 0 0 I D w DNw I IQ Nr V) I D j' rn c o 0 o I o 0 0 0 00 1 0 0 0 0 o I o' ID N a tbvaao N In 0r 0U) N t7 N O J r000 I tSc;c; t7 o w4O w I otitaoo I o w w I 00 oo I o I ~ ?O ?4 GNO cm N? V 0) ?Z t7 I OQ v! It! ) n 0000 I o 00 C; I O 00 ci I o ,• ? N ¢ , ? I I I . N (?} W z 0 E 0 to N .- I to to It v O O` I t'0 O ti 0 0 ( O ?. ??ll 0 0 0 x000 I N wODNO I In Nr W D I t• r ? U o o o o I o 0 0 0 0 0 I o 0 0 0 0 1 0 w¢ i . I I I F- 0 I I I Y N Ol -1 (D C5 I ti CbvVOqr I r ON 00m I t7 r000 I N w O O N O I tB N w-t70 I !? U LJL m 0000 0 00000 o cC m00 O I U a 1 I I 1 I I 0 I I I ¢ m U . , a w •t 0 tri 0 0 I to o V V 0 N I o f* o m I 0 O th . x-000 I N . +-CSgC4R I V , Nw 0) 0 I ti' r,T 0 OOOO I O 00,000 I O Oo OO I O P I I I ?.l 1. W W ail F- W N W aa D W } cc } N ? W z v 0 ! H z ¢ w a ?' .. .? cW ? 7 a 07 tn N r- a N s 0 m ¢ N ? W o? i . N a . Q a w ? w N t'r] [a: ' ' ' D w - F - - N t?3 Q (x ' ' 0) ? CM V) ? U a (7 Q Ik It Ik a to U) ?k Ik Ik IL ¢ rn Ik ?k ?k ¢ a w to • 49 •1 I M co a •+ W p .,?, OI O O D C N J „ OI 'a O m Q u s p r [p O. O. _ C O c Q [V m p 0 Z G co U7 m CD «. r O '? O L' fs m Z I p O C O m Q N "r m m U m m [ { W m .. G CD O p 1d G Lt" W O O Q m r m up O L O O t .- b . q " W ~ ; N U W m ' CD a c to E m m 10 p .- o to o 0 o rn" y, : e ; Q Ln 41 d o 0 a o o C d •- ?o IM - C, ? 11 < co © C Z Q.. a 7 a a O p C ° m d (1? 01 o O O m 00 O CD O a a r m JJ V b 7 13 fC E V ^ m O m m K D p C N ¢ w c M O O O h .G p V al) O O o d m a i ca a CD L: ~ Cr_ 2 m5 5m m U m CD o 1! ? ma ern. m CD a O1 >+ ? IL m? mm- o . n a ?V r ? ? ? ?? Q W Y ? n U1 V) m 2 _ C co r O O y V > m m y N N w Z 0 W ? G' M COD N3 0 LL W W F W N 0 O N [L m.c m ^' a o m C O O cn w a "~ O - c ~w w a ? ^ z .. W -. . ?. I ? Q UJ M a w a r c + N4 0. Q O r ? r N I -• Z O ? Q ? ? > ? O O ? h cu N O u . C Z " ID a i J r .. ll . .. . V . .. (n . 0 . O Z a 50 ' i ' 1 1 I ' ° 1 t ' r ) J CO N Im in CD U o Q'7 I N O CD d Q l q d: co It I R z r N i1rJ Q r to N Of CV C! ( LID d: I d h O w w w v M d' I O O to co 1 [? it v O M 1n QI T cr) CO r r r- 0 0) " ?' 6.2 600 Cki O 1 T 1 N N 1 i I T ,,. i O co NOco TN I co to v • 01 M 0) t It 1- 1- I N N t, 0 o C1[ T UI CV 0 0 C4, N N t 1 r O i I o CD M O CO M N r- v q'ONWto tD 1 14 4 W M' LID I I T O 1 O C'7 ! ,1 , " CVTinrOC I G ui 6 tD I ? . W U 1 1 Q Q I J_ . V h O N Ott O (- M [Q r 1 0 GJ M T O iD I *" cD to • + ? t ?-?1? N CO t) CO O r: C J v TO?TOO I I h M CV h M I I r ? T - uj U H W E 1 1 N T I I T U T U Q J W ?-- CO U CID QQ p ¢ 0 O to Co T tD to O to {V CO I T I CD T tD M CD N N 1 I tD V 0 tw 7WW M T6 M000 tD O to tp O T CC V W n I i cm +" I T CL U0z I I -U C O,. LA O 0 tD O M T d O M 0 C*) T N I N th N M 0 0 to tD I O s!' 00 CM' y" c; c; CV OOc; M 6 T C - ?r-pOr N - N T f O T O w T tD O ' I " T M 1 JI 0 0 o v o c 1 ,; to tai v I ad c E I l ` O m i l9v CID ry IN ?.i.. i s in LU T _j ci ^ U i W N T T co W a: Q IiJ f' S 1 ? ¢ _ ? _ ..:? W 6 ¢ o? F . z J z cr. ? ; 2, co N M " z ° ° v Z n ?Q z ? 51 r) ° ?n n rn I rn I M +-: a o Z Z Z C6 ci 0. N I . 0 co d' N N to ( (D O U I u? N 0 CM 0CM (DOf I (D N cr) I M O O O r 0 0 0 O O O O O rn I I I I c mmn I *- LO N I M ?t ? ? N ao (D I cD M I M o cooo0 o 0 0 o cs I I co c) N v co I ?t ca rn I rn d j 07 N n w r- I to LO . N I N O I- n o00o0 o 0 0 0 0 n (D (D o M qr I (n. rn et I us (D } U m r tt] r- N V N N O //? co U' J to rn 00000 o l O I C I O O CO UJ J i l I Ur Q 69 IZ W = ?- CO ,(D N O (D d' O I It a) O . I O to -:. CD w rn ,- ? v ,-- .- I M co t-- i O. -j L 6 000o 0 I © o I 0 0 I i i I ' U J Q w w J ' L/ p m cD I d' W d' I n ? z 0 N000 N N r r ''o U ICT ooOOO o O O 0 0 CF) I l I a i i It V co ,-- N N I p M (D i n LO rn ovovO io o f 0 0 " C 00000 0 I 0 0 I. 0 0 I I I (*i ca Q Q i o Cr3 C'3 CL U- tty n v Z _j 0 , a: ' L 0 t ^ h c Z U) I- wcmCoC LU 0 000 o _3 z L) z r 52 , e+ 4 ` }' 1 r' f' J r , 00 00 00 0 1 oo LO tn 00 1 en en I o ¢¢ i ¢.;' Ct..I ow oo 0O w ! wen 1-t+ C?en N w zZ 1 Z ?. t? EQ- co j °' co I c(n CM aO CD h 0 I co °D I h I o ,r ro I I I l i I I l w K" r• F- I I I I ?;; 00 80 00 0 108 00 00 loo I'o en to 1 0 C7 0 en 0 O en ,- v- 00 0 en T U) Ca CO N CD 0 NN c7 I G7 co NN T I, 1 0 ! 0 0C) I m' I I I 1 ,? l r- CD I co eci I 1 I I 00 00 00 0 1 00 to oo 1 en en I o end I p rn Tr c°v c0\[ co T I ? C0 rr-- ??• p u7 ! Im 1 0 o c"o 1 O0j i ' ..+ 'm i I I ' I I*- ? IT ? . rn I I I I 00 00 00 0 1 0 0 0 0 0 0.l 00 1 0 00 10 l I I I l CD I to CG I I I s 0 00 o 0 1} 00 wen 80 1 enen 1 0 og I v' ) in U') 7-0 C%l CM to CO C'J (D CO j V COV N 0 T cn o T T r I Gil T 1 0 0 1%. 1 I I I I r I ?? ti vs C'3 ? I I I 1' .? • . ?Ucn .'. ?(??j g0 00 00, o f°00 00 go l 00 1 o WLO I o ? UJ ? m v `n cov " m en 1 0) 0 ° ° to I T- I o ? 1 ti ar? CC F- Lan) ! ! I ¢? N U ; ?w 00 0o aw w 1 in en Lnm oo 100 l 0 ent l o. ' 2 U Ln 0 en 00 N N o t? t? t- 0? co w Cr) o N cn CM cv ImN ?'ti? O CD T i I I T I 00 00 0 en en 1 en en 00 00 1 en ua 1 0 en en 1 0 0 'ct o w 0.0 Cl N O n en a o en us ti m en ?? CO rn N N N 1 co N 1 ,- 1 1 r• I rn N 1 ti en I 1 ! I N I N• 1. #' ' I I I I. p i 0 O QS cn }? T ?: ; • r.. 1 T , i ' r T 1 ?- U-1 ¢ f 4. z? zg z? z z°? zg z? •zg ¢ 023 cr) w ¢ D Q ~ O ? ? U U (D ? °. z a ' n m 53 ' r. . 1 , t , • r • r , Qi CSW. i/OZ%3 CLEARWATER GAS SYSTEM STRATEGIC BONDING REQUIREMENTS (S MILLIONS) PASCO EXPANSION PLAN (STRATEGY ##3) 7 YEAR . DESCRIPTION FY93194 FY94/95 FY95/96 FY96 7 FY97 FY98 FY99 00 TOTAL TRUNK MAIN LINE 4.20 1,70 0.60 0.30 0.00 0,00 0,00 6.80 COML MAIN EXTENSIONS 0.30 0130 0.30 0,30 0.30 0.00 0.00 1.50 RESL MAIN EXTENSIONS 0.20 0.60 0,30 0.20 0.20 0,00 0100 ' 1.50 PRELIMINARY ENG.JCONSULT. 0,20 0,00 0.00 0.00 0.00 0.00 0.00 0.2D VEHICLES (3) 0.05 0.00 0.00 0.00 0.00 0.00 0.00 0.05 COMPUTERS (2) 0.01 - 0,00 0.00 0.00 0.00 , 0,00 0.00 0.01 SUBTOTAL #r3 4.96 2.60 1.20 0.60 0.50 0.00 0.00 10.06 PINELLAS COUNTY PLAN 7 YEAR DESCRIPTION FY93104 FY945 FY95 96 FY96 7 FY97 8 FY98 FY99 TOTAL #1 CIP 0.87 1.51 1.54 1.57 1.60. 1.63 1.66. 10.38 #1 VEHICLES (4) 0.05 0.00 0.00 0.00 - 0.00 ----- -- 0.00 -_ 0.00 -? 0.05 SUBTOTAL #`1 -- 0.92 1.51 -- 1.54 -- 1.57 1.60 1.63 1.66 10.43 #2 CEP 0.70 0.20 0.20 0.20 0,20 0.20 0.20 1.90 #2VEHICLES (4) 0.07 0,00 0.00 0.00 0.00 0,00 0.00 0.07 #E2 COMPUTERS (7) 0.03 0.00 0.00 0.00 0.00 0.00 0.00 0.03 r' SUBTOTAL #2 ----- 0.60 ----- 0.20 ---- 0.20 0.20 0.20 0.20 0.20 2.00 #F4 CNG 0.50 0.40 0.40 0.30 0.20 0,20 0.20 2.20 #f4 VEHICLES (2) 0.03 0.00 0.00 0.00 0.00 0.00 0100 0.03 #E4 COMPUTERS (3) 0.01 0.00 0.00 0.00 0.00 0.00 0.00 0.01 , ----- ----- ----- ----- ------ ----- ----- ----- SUBTOTAL #F4 0.54 0.40 0.40 0.30 0,20 0.20 0.20 2.24 TOTAL 7.22 4.71 3.34 2.87 2.50 2.03 2.06 24.73 i BOND PURCHASES 12.00 0.00 7.00 0.00 5.00 0.00 0.73 24.73 PHASE 1 li III IV BALANCES 1 BEGINNING BOND BALANCE 0.0D 4.78 0.07 3.73 0.86 3.36 1.33 NA NEW BONDS 12.00 0.00 7.00 0.00 5.00 0.00 0.73 NA p BOND $ SPENT --7.22 ----- -4.71 ----- -3.34 ----- -2.87 ----- -2.50 ----- -2.03 ----- -2.06 ----- NA ----- REMAINING BOND BALANCE 4.78 0.07 3.73 0.86 3,36 1.33 0.00 NA ?Y . Nate: A strategic plan update will be done in FY94/95 and reforecasts will be done for FY95196 r and out year's capital requirements before the Phase II bonds are requested. This process will also be followed before Phase III bonds are requested. ` 54 CLEARWATER GAS SYSTEMµ PROPOSED GS PASCO COUNTY EXPANSION Black Aria nal Territo y (Ulmerton Road to Curlew,Road) Miles of Main: 417 Annual Revenues:?$9.4 Million # of Customers: 11,2,00 Yellow Nort"jnella - argon Snri?,ners ExWansion (Curlew Road to Pinellas/Pasco County line) t Approx. Construction cost: $6.0 Million Backbone Miles: 37 r'. Bonds Issued: 1983, $7.1 Million Additional Miles:13 Initial Construction: 1984 - 1987 # of Customers: 500 Annual Revenues: $1.4 Million Red Vasco Phase I (U.S. 19 North from Beckett Tray to S.R. 54, S.R. 54 East from U.O" 19 to West Pasco Airpark) Approx. Construction Cost: $1,400,000 Miles of Main: 13 Projected Annual Revenue: $1,006,000 # of Customers: 53 Projected Construction Timing: 1993-1994 Orange Pasco Phase II, (U.S. 19 North from S.R. 54 to 1/2 mile North of S.R. 52) Approx. Construction Cost: $1,500,000 Miles of Main: 9.3 Projected Annual Revenue: $612,775 # of Customers: 96 Projected Construction Timing: 1994 Green Pasco Phase III (With FGT Gate Station) (S.R& 52 East from U.S. 19 to Serenova Development) Approx.-Construction,Cost: $1,300,000 Miles of Main: 8 Projected Annual Revenue: $207,485 # of•Customers. 32 Projected Construction Timing: 1994-1995 F each Pasco---Rhase V (Little Road South from S.R. 52 to S.R. 54) Approx. Construction Cost: $1,300,000 Miles of Main: 8.3: Projected Annual Revenue: $92,825 # of Customers: 23 Projected Construction Timing: 1994-1996 55 t . 4 ' 1 ' i t., Pink Pgsco ase (Seven Springs Blvd. /East Lake Road South from S.R..54 to John Chestnut Park) Approx. Construction Cost: $1,300,000 'Miles of Main: 9 Projected Annual Revenue: $103,4+85 of Customers: 26 Projected Construction Timing: 1994--1997 Pasco County Main Line Expansion SubTotal' Approx. Construction Cost: $6,800,000 Miles of Main: 47.6 i Projected Annual Revenue: $2,022,570 # of Customers: 230 ` Pasco Expansion Engineering and consultant Services . Approx. Cost: $200,000 4'! and 2" Distribution Main Extensions. Commercial Approx. Construction Cost: $1,500,000 Miles,of Main: .22 Projected Annual Revenue: $1,,300,000 of Customers: 160 ' Projected Construction Timing: 1994-1997 &xtensions, Residential 411 and 211 Distribution Main . r. Approx. Construction Cost: $1,500,000 Miles of Main: 22- Projected Annual Revenue: $600,000` of customers: 900 Projected Construction Timing: 1994-1997 Pasco Count E ansion Project Total Approx. Construction Cost: $10,000,000 Miles of Main: 91.6 Projected Annual Revenue: $3,922,570 of Customers: 1,290 Return on investment 6.9 Year Payback " . 56 ,F , J 1" • ' Y PROJECT DESCRIPTION Estimated Estimated ' t Starling Completion Date Dale n GAS SYSTEM '• ' New Mains - Chas Main Extension Oct, 1993 Sept. 1999 This is an on-going project which extends the natural gas mains to new residential and commercial customers throughout the gas service area. Funds for this project for FY 1994195 through 1998199 are included in the Pasco and Pinellas expansion bond issue. -The $300,000 of gas revenue funding in FY 1993194 is for start up costs of constructing new mains while waiting for the bond to be sold, Annual Operating Costs: No significant increase of existing operating costs. ' . ' Comprehensive Plan Objective: To provide utility service in the coastal zone consistent with consumer demand and sound principles of environmental management, Additional Service Lines Oct. 1996 Nov. 1999 ? In order to meet increasing demands for gas service, additional service lines are extended to new customers. FundsTor this project for the next seven years are included in the Pasco and Pinellas expansion bond issue . Annual Operating Costs: No significant increase of existing operating costs. Comprehensive Plan Objective: To provide utility service in the coastal zone consistent with consumer demand and sound principles of environmental management. Line Relocation - Maintenance Oct, 1996 Nov. 1999 This project is used for the removal of, gas mains as required by State Department of Transaportation, When gas lines, are relocated and the system is not upgraded, it is ? considered maintenance, and falls under this project. Funds for this project for the next seven years are included in the Pinellms and Pasco expansion bond issue. ' Annual Operating Costs: No significant increase of existing operating costs. ' Comprehensive Plan Objective: Where local improvements are proposed, the City shall, where applicable, coordinate these improvements with the County and neighboring jurisdictions. t . I 1 57 'X, ?* f `rk' J. ` - k "^ ', . .. /', ... .1 T: .. .1 .ail' .i ? 1:i' •I Jl:j?i i:..??t r{?'?? , . J , , r . i r J .i. ' . , ' . r,• F • J • .'?4 i •. I • ,! .: .. I ,. •ys ' ' 'r ' ° Tee. .: • J. ,!_ I. rr F / S '' ' ' i . rJ ? ? " • , J. 'i ' : I" ' ? # Y`. , r.'' ., ? ,1r, i _ J I r "' . , . , _ " • ' • f y ! A " 7.r. • ". `k ',k "r . f" .? "f' r ' ' r s ,° 1: .. ft.f •.j,, i r }lr'x'I>;;??fi7 t ''? ? . p f ./ ., r •, ?.ti .` , -,r?? .", .1., ?,'+ "'J•` • •1 `?j.?. }?' ? 1 . , ?' •, ?' J'/ . r i .r :'e..,?. :. : . .• •, .. , :, r _ r .v 7 r FY 1493-44 THROUGH FY 1998.99 CAPITAL IMPROVDIENT PROGRAM' -AND FY 1943-94 CAPITAL'SUOGET > :• n1' ' w. •w.-. w.. . +rw r .............. ... --•--•------rrw.-..- --.--.r----... rr: ----- - ..w------ ........... " `. . r , f J ' Schedule of Planned CIP Expenditures Pro) Function/Program' •'Funding -- -------. ----------- .------. ............................ - -------- J -------- Code Pro)ect:Neme source 1493.94 1994-95 1995-96 1996.97 1997-98 1998.99' ", Total' r' .. '-----.......- -------- •, .. ....----- ...... ---- ----............................. - - ...._. GAS SYSTEM :6341 Mew Meins". CBS Rev 000, 300 300,000 , , r Gas Main Extension 4. ?. sJr? 5' I l 1 , , S , , l a l ,! ?, E J y,.,A '6334 Additional,Service Lines , Gas Rev ff .:??r ; • 1, ; '! 1. - ' r ' • l ' • F • F ! i 'l,i, J F < i ! ; t ' 1 ' 1 . . Line Relocation - 6348 ' , MaIntanance . " ' Gen Rev 5$ 1. '' • 1' r. f r E t. " 1 • : :? ': G iii ' Ff. r 7 . . •iF P-4 ?` 'f ?.v ''?}p L•i?f i?2 rs °4, ' ?7` .1_•r Jir':3. F `It •l? L • 1 „ I "r ?li: .fit' •,ii r. f". ;Is. r [v lf? ? , i'PlR. {j. ,r• 7r ?rf+{ .4'1 ,1.'1'1 PROJECT DESCRIPTION Estimated Estimated ' Starting Completion Date Date GAS SYSTEM Line Relocatjpn _ Qpitalized Oct. 1996 Nov. 1999 This project is for the relocation of gas mains for local, County, State, and Federal public works projects. Funds for this project for the next seven years are included in the " Pinellas and Pasco expansion bond issue. Annual Operating Costs: No significant increase of existing operating costs, Comprehensive Plan Objective: Where local improvements are proposed, the City shall, where applicable, coordinate these improvements with the County and. neighboring . jurisdictions. and System er1 wal Re lace eat - a te ance C ti l F di _ _ L n nuous Annua on un ng . This is a continuing project to maintain gas system, such as conducting cathodic protection and leak surveys, as required by State and Federal specifications. The maintenance portion of this project involves work that is not capitalized. .Annual Operating Costs: No increase of existing operating costs, ' ? Comprehensive Plata Objective: To provide for a safe and efficient gas system that meets .. State and Federal regulations. Systm-Renewal.and Replacement _ a ita 'zed Continuous Annual Funding e This is a continuing project to maintain the gas'system, including replacement of original cast iron pipes with plastic pipe, to State and Federal specifications. This portion of the project involves, work that adds to the value of the gas system and is therefore capitalized. Additional funding, replacing gas revenue funds, for this project for the next seven years are included in the Pinellas and Pasco expansion bond issue, Annual Operating Costs: No increase of existing operating costs, , Comprehensive Plan Objective: To provide for a safe and efficient gas system that meets State and Federal regulations. 'y Gas ter' a e-Ou Oct. 1996 Nov. 1999 This is a continuing project to maintain accurate gas meters to maximize gas revenues. - ' Funds for this project far the next seven years are included in the Pinellas and Pasco expansion bond issue. Annual Operating Costs: No increase of existing operating costs. Comprehensive Plan Objective:, To provide for the systematic improvement of the City's physical plant and to increase efficiency in governmental operations. 59 , { ?fklr, •f•' i 'r , ,'j 1. f' ,4, i . ' a. Fr 1993.94 THROUGH'FY 1997-98 CAPITAL IMPROVEMENT PROGRAM . AND ' FY 1993-94 CAPITAL BUDGET , r , r l., .. . _r ...........................---..._......_....................----- --............ ..... .. ......... ?f Schedule of Planned CiP Expenditures r' . a`,' ? pro] Function/Program Funding --------------------------------------------=--------........................ `Code Protect Name Source 1993-94 1944.95 1495,-96 1996-97 1997.48 1998-99 `Total !'+ ` .................................. ------...--- -------- --- ........... . ..S SYSTEM ???»»» (Continued?: ' t,.l, y 6340 Line Relocation - Gas Rev -1 1 r;?! Capitalized r• r 6349 system R,& R Gas R &,R 53,00D 56,000 57,000 58,000 59,000 •60,000 343,000 `. ' Maintenance : Y.. 6342 System R 6 R - .? Gas R i R ''168,000 177,000 180,000 183,000 190,000. 197,00 1,095,000 capitalized ,5 1. • .. + ' ? , 6352 Gas 'Neter Gas Re'v ; ,: - 'Change-Out r r ' r?3??f•?' r ! ., , e '' ,' ,' , 1:' I - -- ', _, ?'! 'rte . '?,+''?C?a`h?•'1, ?..5;.?? tilt!: i,;•?i? • r. ' PROJECT DESCRIMON ?.. r Estimated Estimated Starting Completion .' Date. Date ?. ? GAS SYSTEM ..'' (Qnflnugd); Liguid Propane Vas Service Continuous Annual Funding This project will provide tanks, regulators and appurtenances which will be used to provide ? L.P. Gas Service to new customers where existing natural gas mains are not present. This will be an ongoing project to meet the increasing demands for gas service and to increase new customer load. Funds for this project for the next seven years are included in the F Pinellas and Pasco expansion bond issue. Annual Operating Costs: No increase in existing operating costs. Comprehensive Plan Objective: To provide utility service in the coastal zone consistent with consumer demand and sound principles of environmental management. .; G Inventory g_ontrol S ste Oct. 1994 Sept. 1995 The Gas Inventory Control System will insure accurate inventory control.of all gas parts, fitting, and appliances. Presently Clearwater Gas System inventory is valued at approximately $500,000. This system will interface with the Ross Financial system currently being used by the City. All parts when received will be entered into inventory using a r scanner and a bar code type system. The system will be more accurate and provide timely , information. This is included in the CIS Long Range Plan #9342. Annual Operating Costs: Yearly debt service, plus the software costs estimated at $5,000. ' - ` xa L l Pasco & Pinellas Expansion Proiect Oct. 1993 Nov. 1996 i This project will provide funding for the extension of gas mains and services within Upper Pinellas and West Pasco Counties, It will also fund various activities such as gas main relocation for roid construction, capital replacement of obsolete cast iron mains, L.P. services and gas teeter change outs. Annual Operating Costs: $402,020 plus annual debt.service. Comprehensive Plan Objective: To provide utility service in the coastal zone consistent with consumer demand and sound environmental management, l' 61 u ? S : ' ?'.:tY: ?'{ k .. ' ,. .. .? s F? •}. i ..1:5r .`,. ?. .???' . `11 F7e ;s`1},{t • '?.; .il ' , . . . "' ? ' p l a • . . l ' a • FJ I 7t f FY 1993-94 THROUGH FY 1 997.98 CAPITAL IMPROVEMENT PROGRAM , AND r FY 1993-94 CAPITAL BUDGET ' . Sehedute of Planned CIP Expenditures .Y 1 Pro) Function/Program Funding ----------- ----------- ----------- -----------••---------- -------.----------- "'`:: "Coda' Project NOW t.: Source 1993-94 1994.95 1995-96 1996-97 1997-98 1998.99 -Total 1 --------------------------- GAS SYSTEM" -------•- -•----...- ----------- ------....-- ------------------.-.- .--..------_-_--- (Continued). " 63561 Liquid Propane Gas Rev Gas Service ' 67xx Gas Inventory Control r , n . System L/P' 25,000 25,000 " ` 67xx Pasco i Pinellas Bond Issue 7,219,800, 4,708,200. ,3,340,500 2,870,000 2,500,000 '2,030,000 .22,668,500 Expansion Project Subtotal: -----.._ ----------- -------=---- ----- r. -------_--- -.... ._ ....... „ Gas system 7,740,800 4,966,20D 3,577,500 3,111,000 2,749,000 2,287,000 24,431;500 t ........... ........... ............ ................. . .._...--- ---- --- . ' l r 1 r? s, 62 , ° ??f .1=F z its 5.4 71 1 k` a z o' Q ;. L o 0 oc (Y & (n Cl c 0) W cy- r 1 W ? Q .. r w U , 1. i + V n ?f fv S 63 . j r r f e z 1 r V I V V V' » r ' c sA •u ? r 1? teee, L H, v v - ?ou, a r° 1-. u u IN r3 v n s C7 #A J -? CO t') ?- ?- N 41 C i1 CL in a u p 'ii u~ r h u n n a g rn a o a a a ? rym1? n pep , p p n C9 i9 C7 O ? O ? v v u v v vv . ?a a g a c g ?' ... . .. ., 1 .. , . _ r ? std ' 'O S SYSTEM ST FF TE W ND 8 CLEAR A R Actual Budgeted Requested Gas Admiaiatratiaa & Su?ly 9f /?J2 93194 Gas System Managing Director 1 ] 1 _ Gas System Controller 0 1 1 Gas Superintendent I 1 1, Assistant Gas Superintendent 1 1 I Staff Assistants 2 2 2 Accounting Clerks 1 1 1 '. Storukeeper . 1 1 1 Admin Support Manager (Technical/Safety Training) ' 0 0 1 Subtotal 7 8 9 . Senior Service Dispatcher 1 I 1 Property Guards „2,.5 3.5 4.5 4.5 4.7. Gas E&M''ha d Gas Distrib, Supervisors 0 in Coast. & I in Maint.) 2 2 2 .Gas Pipeline Welders (3 in Coast. & 1 is Maim.) 4 4 4 Gas Corrosion Technician (1 in Maint.) 1 1 1 Gas Distrib. Pipefitters (818110 in Const. & I0/10111 in Maint,) 18 18 21 _.; Util. Service Technician ' (1 in Maint.) 1 1 I Meter Repair Technician (1 in Maint.) 1 1 I Accounting.Clerks (I in Const. & I in Maint.) 2 2 2 Drafting Technicians (31314 in Coast.) '3 3 4 subtotal (16/16/19 in Coast. & 16/16117 in Maint.) 32 32 36 7 G S i -: ce as erv Gas Service Supervisors (1 in Repair & 1 in Installation) 2 2 2 Util. Service Technicians (51516 in Repair, & 11/11/15 in Install.) 16 16 21 Staff Assistants (0.5 in Repair & 0.510.511.5 in Install.) Subtotal (6.516.517.5 in Repair & 12.5112.5117.5 in Install.) 19 19 25 Gas Sales Manager 1 I 1 Gas Sales Representatives 2 2 4 Gas Sales Assistant, 0 0 1 Stalk' Assistant 1 l 1 Subtotal 4 4 7 Director of Gas Marketing & Planning 0 0 1 Gas Marketing Engineer, 0 0 1 Staff Assistant Subtotal 0 0 0 0 I 3 , Pasco Gas Buaarsiaa Operations Manager 0 0 1 Customer. Service Representative'- 0 0 1 Utility Service Technician 0 0 1 r Gas Distribution Pipefitters 0 0 .21 Gas Sales Representatives 0 0 3 Subtotal 0 0 7 Total 66.5 67.5 91.7 64 c i.' CLEARWATER GAS SYSTEM C Additional Employee Requirements Due to ustomer Growth Between FY 94195 - FY 99100 Administration/Supply 1 Accounting Clerk Dispatch 1 Dispatcher ..r Construction 4 Accounting Clerk .2 Pipefitters , Maintenance 1 Pipefitter (LP) t 1 Pipefitter (Maintenance) ; Repair 0 Installation 0 Sales 0 a Pasco 1 Construction Inspector' 1 Pipefitter (LP/Maintenance), 1 Supervisor 1 Staff Assistant 11 1 Customer Service Rep./Cashier Marketing .,,Q Subtotal CGS Employees 12 (5 for Strategy #3, 3.5 each for Strategies #1 & #2) UCS ** 1 Meter Reader 1 Collector 1 Customer Service Rep. 3 TOTAL CGS & UCS EMPLOYEES ' 15 (6 for Strategy #3, 4.5 each for Strategies #1 & #2) * Would'only request additional employees in this area as justified by added revenues. ** Expenses added to the Administration' & Supply Program to account for these costs. i 65 1. tie , . , 1 • r t r SUMMARY OF STRATEGY #1 t Continue the Esisting Lev el Pinellas n , r Customers. 11,800 Projected at end of FY 92/93 (11,700 NG and 100 LP) Adding 450 New Customers/Year (400 NG and 50 LP) ` 2,800 Net Additional Customers by the Year 2000 Net Revenues: $9.32 Million Projected for FY 93194 $11.19 Million Projected by FY 99100 Net Operating Expenses: $6.23 Million Projected for FY 93194 0.59 Projected Depreciation 0.53 Million Projected Net Interest Expense ,_. $7.35 Million Projected Total Operating Expenses for FY 93194 Net of Bond Interest $8.33 Million Projected by FY 99100 ' Net Income; $1,97 Million Projected for FY 93194 $2.86 Million Projected for FY 99100 Capital Budget Requirements: $0.92 Million from Bond Sales $Q,M Million from CIP Funds $1.44 Million Total, for FY 93194 ^ $12.19 Million Total for Next 7 Years Personnel Requirements: 67.7 Full Time Equivalent in CGS plus Contractors and Employees Assigned to other City Departments +3.5 By FY 99/00 (Pius 1 in UCS)* ' 71.2 Total by FY 99100 Vehicles: 37 Existing Trucks/Vans + 4 in FY 93194 for Supervisors 7 Existing Sedans Computers: 11 Existing PC Workstations 3 Existing AutoCad Workstations Telephones: i 3 Existing Mobile Phones- See Separate Listing for Additional Employee Requirements 66 • r , ' 4 SUMMARY OF STRATEGY #2 A ccelerate Existing Gas Services in Pinellas Countv Customers: Adding 400 Additional New Customers/Year (200 NG and 200 LP) 2,500 Net Additional Customers by the Year 2000 Net Revenues: $390,000 Projected for FY 93194 $1.32 Million Projected by FY 99100 Net Operating Expenses: $554,080 Projected for FY 93194 -0- Projected Depreciation , 20.000 Projected Net Literest Expense $574,080 Projected Total Operating Expenses for FY 93194 Net of Bond Interest $910,000 Projected by FY 99100 Net Income; 080) Projected for FY 93194 ($184 ` , $410,000 Projected for FY 99100 ~ Capital Budget Requirements: $805,000 from Bond Sales in FY 93/94, f " $2.0'Million Total'for Next 7 Years t " Personnel Requirements:. 14.0 Additional Full Time for FY 93/94, +3•S By FY 99100 (Plus 1 in UCS)* 17.5 Total by FY 99100 EY 93194 Additions Trucks P? Gas Admin. & Supply: 1 Training Specialist 3 Gas Distribution: 2 Pipefitter Helpers (Construction Crew) l 1 Drafting Technician 1 1 Pipefitter Helper (LP) 1 Gas Service: 1 Service Technician (Repair) 1 , 4 Service Technicians (Installation) 2 1 Installation Clerk 1 Gas Sales: 2 Sales Representatives 1 1 Sales Assistant 1 Total 14 4, 8 * i ! See Separate Listing for Additional Employee Requ rements. 67 ' . 4• 1 r , ! } SUMMARY OF STRATEGY #3 .' Fzpand Existing 'Gas Services into Pasco Countv Customers: Add, 225 Additional New Customers/Year (200 NG and 25 LP) 1,900 Net Additional Customers by the Year 2000 Net Revenues: $270,000 Projected for FY 93194 E : $3.16 Million Projected by FY x99100 Net Operating Expenses: $398,130 Projected for FY 93194 -0- Projected Depreciation i 140.000 Projected Net Interest Expense $538,130 Projected Total Operating Expenses for FY 93194 Net of Bond interest ?'..' $1.56 Million Projected by FY 99100 Net Income: .($268,130) Projected for FY 93194 $1.60 Million Projected for FY 99100 Capital Budget Requirements: $ 4.96 Million from Bond Sales in FY 93194 $10.06 Million Total for Next 7 Years Personnel Requirements: 7.0 Additional Full Time for FY 93/94 ±5.0 By FY 99/00 (Plus 1 in UCS)* 12.0 Total by FY 99/00 9312LAOditims Trucks Sedans Cam' 1 1 Operations Manager 1 1 Customer Service Rep. 1 2 Sales Reps. 2 Pipefitter Helpers (Construction) 1 1 Service Technician (Repair) 1 Total: 7 2 1 2 See Separate Listing for Additional Employee Requirements. , 68 , • SUMMARY 'OF STRATEGY #4. n i P' P Develop w for . Customers: ' . Add 5 New Customers in FY 93194 (NGV & Gas A/C) 60 Net Additional Customers by the Year 2000 .. Net Revenues: $-0- Projected for FY 93194 • $1.60 Million Projected by FY 99100 . F Net Operating Expense: $192,960 Projected for FY 93194 -0- Projected Depreciation Net Interest Expense 10.000 Projected , $202,960 Projected Total Operating Expenses for FY 93194 Net of ' ' Band Interest . $370,000 Projected by FY 99100 Net Income: ($202,960) Projected Loss for FY 93194 $1.23 Million Projected for FY 99100 Capital Budget Requirements: $540,000 from Bond Sales in FY 93194 " .: $2.24 Million Total for Next 7 Years Personnel Requirements: 3.0 Additional Full Time for FY 93194 Future Needs would be Justified with Added Revenues FY 93194 Additions Sedans Ms ? 1 Director of Gas Marketing & Planning 1 1 ?r. f 1 Gas Marketing Engineer Jr 1 y 1 Staff Assistant II 1 f E Total: 3 2 3 69 t ?. s , 1 .-1 A op dp dp dp dp dp dp dp dp dp OP O W d to 0 r-i (•7 H H v N O co w w In .-I O 41 b H • n jP 0 r? N to N H H r4 o 0 0 r N H O Q d' N r4 co d' 01 LA A r %D Ln w in to cm N 01 m. N to b v o Iqr to Ln r a r w w O o A co co l? in r co co rn co co 0 d r-1 QI N d' N N d' N o co w Ln In C7 0 cn N N N r-I ri r-1 0 a x? a in cn o co to r 0, e oa oo g o A o in r o .•? ?D rn Oti rt ?•+ rn ? Ai H to %D cn N N N e-1 ri r-I O 3 M m rQ! eal r•1 r--i r-i r?•I r-i rj +-? H 10 A %0 -H r4 ?o 4J 41 V 41 41 41 D n p. W W m W m w cull 44 41 rj 14 1040 Wp W 04 $4 $4 64 W Q) W (1) Q) 4) 4J 0 P4 to ?i E? 14r' H H H H r-i H H H W W H H 1 la ea T-1 t7= ( 1 I I+ I I I I I I i In A T-I N r-) 9-1 N H r•i N m H H+ LoG lot ? .0 l j Gti •? o Q to a? X H R1 W X gn $4 %4 P4 a ° ? 4 N 44 4 0 N 134 w 04 0) P4 41 >1 to 41 p 4-J -: a x° r-I to m a EO x° x° fri v 14 d, w ° W 41 -4) > x b 4i N lC •,? b rCi U x •r0•{ N a p a 44 •?r•! . b w to o •' m a 'd b r?•i 4?l ?i N cn U O r? t p r-I C al al O O O W E. ? r H 44 r4 0 •rl x V O x I ao o b o .) (0 ro i 14 as . V 0) O o r-r m A •? u x a ,-i N tn ?r 1?1 ?D n oo rn ? 70 F w? ?w Cl)O Q=rn ? U w r- ? J CF) W m } aW J FEW z LL -i N N d: N r O CD Ln M Ln O [? ' ?? O {+ } CV N r r r ?- O O G1 O O r WU' tD ?h r CC) 00 in M O O? O N r A r O CV N CO Ca M 6 PIZ N W O d 0) r- N ?- N Z r 0 W ^ N r r Ct 00 r! n C7 M it, co z CD LO LA U) O O M Lc) d O M CD O CD 00 O CO N 19t 00 e- r r r 00 00 1- LC3 co O 00 00 N f- Q N 00 N Rt N qtt N r O Ln Ln M Ln Cn M N N r r r r Z p CA d' N CD t- C) O C}] N Cn M O co 0 o co 00 CV 00 4 to Cn O'i vi st O} N O M CD Lr) X CD et tt N N N n 2 U N o? U tm C {7] 'C 0 a u .a C i +J m vi w cCU _` d Ln 7 M E E o c o Z` C t o . ?. `+° ? + m m a v Q W b •M cv C 0 ? . .? . a C M a . L n r U tr ? C n Z r = 2 . i 0 co c ar o t m !-' r C Cu N O W tq C • o w U N U co L > = C fG Z C = IL , C y O C 0 cc .1 .O ) O s O -0 [U +- G i ?`+ cn 0 0 2' z s ? w Y m {") = 0 m CA to 0_ C O cd Cu '- O .L 4-0 C Z O 3 C 1 '0 U w r O O _m r00) O` O) 2- 0- m - 0 N r U Z L LL U .? _ -j U- 2 LL y- 0 Z T j .r :2 ? p r N M d L r, co M - T-- ' 1 71 O m V O O E m m t c 0 CJ a N y a N cn s y O 'L3 cp O r?s ?F ?F 1 all E . / r • 1. r I, x i, ,, 1 t. , - • !. ! , t r S '. ! , , ! r . Clearwater Gas System k+ s Monthly Financial Slatememt , June 1993 ' . Current Begot FY Net Change 9b Change { Cash 51,011,288 (310,549) 1,321,837 N/A Accounts Receivable ., 543,134 528,425 16,709 3.17% (''t Restricted Assets 2,498,285 `2,498,285 0 0.00% r ... Inventories 655,789 658.067 (2,298) '. -0.35% Fixed Assets . 12,713,343 12,482,777 ' 230.566. 1.85016, Due from other Funds 1,851,501 1,499,961 351,540 23.444+? ' Total Assets $19,273,320' $17,354,966 $1,918,354 11.0596 Liabilities and Eaulty . + Accounts Payable $1,350,409 904,345 446,084 49.32% Accrued Payroll F 203,765' 161.553'; 42,212 , 26.1396 Bonded Debt. 7,241,920 7,241,920 (0) -0.00% pY Customer Deposits 814,083 .742,607 71,476 9.6396 Fund Equity 9,663,143 8,304,541 1,358,602 18.360A Total Liabilities & Equity $19,273,320 :17.354,966 1,918,354 11,05% ' -' • , 9 • , awn. , ' ! I ' • All '?f' •• r • v . l,ti.l.J yr F Prior Year Results of Operations Curr Month Yr To Dale TD Budget Yr To Dale Sales of Gas $884,937 9,144,925 $8,772,118 8,548,538 Less Gas Commodity Charges (328,528) (3,040,817) ($2,715,265) (2,426,943) Grass Margin 556,409 6,104,108 6,056,853 • 6,121,695 Gross Margin Percentage 62.680,6 66.75% 69.05% 71.61% Other Revenues 54,130 837,064 676,467 591,448 Total Revenues 610,538 6,941,173 6,733,320 6,713,043 Gas Demand Charges 42,490 672,033 682,415 810,660 Dispatch Division 12,847 102,689 102,946 . 98,986 ". Distribution Division 302135 2,613,481 2,732,175 2,430,463 Service Division 98,948 625,731 798,783 740,37 5 Gas Sales Division 30,147 373,882 398,825. 290,734' i. , Depreciation 44,443 399,983 399,983 .354,330 Interest 41,420 372,780 372,780 372,780 Total Expenses 572,430 5,360,580 5,487,907 4,896,328 Net Income (Loss) Before Dividends 38,109. 1,580,593 1,814,715 Dividends Paid to General Fund 10,812 221,991 278.858' Net Change In Fund Equity 27,297 1,358,602 1,535,857 } Fund Equity Beginning of Period ' 9,635,846 8,304,541 Fund Equity End of Period $9,663,143 9,663.143 Summary of Paymenls to City General Fund Dividend $10,812 221,991 Payment In Lieu of Taxes 57,638 325,568 General Fund Admin Overhead 46,232 '416,088 Utility Customer Support 20,547 184,919 ' Garage Charges 12,958 119,098 Other Interfund Charges 12.814 i08,537 Total Pmts to Other City Funds $161,001 1,376,201 , 'J r r 5 r ' l DEPARTMENT: CAS SYSTEM PROGRAM: ADMINISTRATION/SUPPLY CODE: 423-2064 MAJOR Actual Budget Adjusted Requested % Recommended % CLASSIFICATION 91/92 92/93 92/93 93/94 Change' 93/94. Change Personal Services 0 0 0 394,650 n/a 385,710 n/a other Operating Expense 0 0 0 6,268,970 n/a 6,268,970 iz/a Internal Services 0 0 0 327,260 n/a 327,260 ' n/a Capital, 0 0 0 18,200 n/a 18,200 n/a Debt Service 0 0 0' 1,424,420 " n/a 1,424,420 n/a ' Transfer 0 0 0 1,518,720 n/a 1,518,720 n/a TOTAL 0 0 0 9,952,220 n/a 9,943,280 We Actual Budget Adjusted Requested % Hanagerls 91/92 92/93 92/93 93/94 Change. Recommended PERSONAL SERVICE ------ ------ ........ ......... ------ ---------- 101 Salaries i Wages FT 331,630 NO 325,190 102 Saleries.i Wages PT 0 n/a 0 105 Overtiiee 0 n/a 0 115 Sales, Commission 0 n/a 0 201 Emp Life insurance 4,090 n/a 4,090 204 Esp Major Medical 22,050 n/a 22,050 , 206 Esp Social Security 8,220 n/a 8,220 ? 207 Esp Pension 18,380 n/a 16,080 209 Yorkers Cospensation . 9,570 We 9,570 210 Disability Insurance 0 n/a 0 211 Urwsaployment Comp 350 n/a 350 215 Medical Examinations 160 n/a 160 TOTAL 0 0 0 394,650 n/a 385,710 OTHER OPERATING EXPENSE 301 Professional Services 50,000 n/a 50,000 f 303 Contractual Services 1,300 n/a 1,300 (.. 311 inventory Purchase 4,777,700 n/a 4,977,700 421 Utility Charge-Phone 0 n/a 0 422 Utility Charge-Power 11,000 n/e 11,000 423 utility Charge-Other 12,000 n/a 12,000 425 Postage 1,000 n/a 1,000, 428 Interfund-other Charge 53,950 n/a 53,950 429 Interfund-Admin. Charge. 572,520 n/a 572,520 ' 434 Printing i Binding 1,000 We 1,000• 436 Taxes 500,000 No 500,000 441 Rental-Equipment 5,160, n/a 5,160 451 Insurance 0 n/a 0 452 Insurance Reserve 0 Ma 0 461 Equip Svc 9 Rep-Office 500 n/a 500. 462 Equip Svc.& Rep-Other 0• n/a 0 74 i , DEPARTMENT: GAS SYSTEM PROGRAM: AOMINISTRATIONAUPPLY CODE: 423.2 0 MAJOR CLASSIFICATION Actual Budget Adjusted Requested % Manager a 91/92 92/93 92/93 93/94 Change Recommended OTHER OPERATING EXPENSE CCont) ....... ------ ........ ......... ...... .......... r 471 Emp Exp-Uniforms 1,870 n/a 1,870 472 Emp Exp-Travel 42,440 We 42,440 ". 473. Emp Exp-Auto Allowance 0 No 0 474 Emp Exp-Masts 300 n/a 300 480 other Svc' or Charges 0 n/a 0 .;" 501, Office-supplies 2,500 n/a 2,500 503 Meter Repair 504 Operating Supplies 0 6,800 We n/a 0 6,800 ' 520 Computer Software 0 n/a 0 571 Memberships A Subs 21,040 n/a 21,040 573 Training i Reference 7,890 We 7,890 TOTAL 0 0 . 0. 6,268,970 n/a 6,268,970 ' INTERNAL SERVICE 401 Garage Service 2,060 n/a 2,060 , 402 Document Reproduction 3,000 n/a 3,000 ^{ 403 Telephone Svc/Variable 404 Messenger Service 18,900 1,290 We n/a 18,900 1,290 r' 405 Radio Service 5,490 n/a 5,490 . 406 Telephone Svc/Fixed 12,770 n/a 12,770 407 Postal Service 3,600 No 3,600 r 410 Data Processing Svc 20,710 n/a 20,710 : 411 Building Maintenance 0 We 0 412 Custodial Service '2,340 n/a 2,340 ; 413 Print Shop 3,600 n/a 3,600 i 416 Bldg i Point-Variable 10,000 n/a 10,000 418 Administrative service 243,020 n/a 243,020 420 Employee Benefits 480 n/a 480 TOTAL 0 0 0 327,260 n/a 327,260. CAPITAL 640 Machinery i Equipment 7,200 We 7,200 6 643 Computer Software 5,000 n/a 5,000 658 Construction Materials 6,000 n/a 6,OO0 . i 910 Contribution to Garage 0 n/a 0 TOTAL 0 0 0 18,200 n/a 18,200 DEBT SERVICE 712. Principal-Other 104,270 n/a 104,270 713 Principal-leased Equip 30,870, n/a 30,870 ! } 723 Interest-Leased Equip 4,850 n/e 4,850 ' 921 Sinking Fund-Principal 193,980 n/o 193,980 922 Sinking Fund-Interest 1,090,450 n/a 1,090,450 TOTAL 0 0 0 ' 1,424,420 We 1,424,420 TRANSFE R ' 902 Interfund Transfer 1,518,720 n/a 1,518,720 908 Capital improvements 0 n/a .0 TOTAL 0 0 0 1,518;720 n/a 1,518,720 "PROGRAM TOTAL 0 0 0 9,952,220 n/e 9,943,280 1 ?ws . 75 .. ? , u • 11 . DEPARTMENT: GAS SYSTEM PROGRAM: OAS DISPATCH CODE: 423.2069 . • je MAJOR Actual Budget Adjusted Requested % Recommended % - CLASSIFICATION 91/92 ...... 92/93 ------ 92/93 -------- 93/94 --------- Change -----• 93/94 ---------- ' Change ------ 1 Personal Services 111,915 99,340 108,420 127,700 16% 125,110 15% Other operating Expense 17,130 19,980 12,190 8,050 -34% 8,050 -34% Internal Services 11,547 14,290 12,890 20,540 59% 20,540 59% •_ Capital 0 2,000 2,000 1,000 -50% 1,000 -50% Debt Service 0 0 0 0 n/a 0, n/a Transfer 0 0 0 0 n/a 0 n/a TOTAL 140,592 135,610 135,500 157,290 16% 154,700 14% Actual Budget Adjusted Requested % Manager's , 91/92 92/93 92/93 93/94 Change Recmmended PERSONAL SERVICE ------ . ------ -------- --------- ...... ........... 101 Salaries I Uages FT 61,048 48,010 65,030 86,460 33% 84,730 102 Salaries i Wages PT' 34,018 36,880 20,230 11,820 -42% 11,820 105 Overtime 4,724 2,600 5,430 4,870 -10% 4,870 201 Esp Life Insurance, 105 110 130 170 31% 170 204 Esp Major Medical 4,362 4,200 4,880 9,800 101% 9,800 206 Eap Social Security 5,063 4,450 3,430 1,430 -58% 1,430 207 Eap Pension 2,030 2,180 8,460 6,920 -18% 6,060 209 Yorkers Compensation 330 740 740 5,980 708% 5,980 210 Disability Insurance 145 170 90 0 -100% 0 211 Un Wtoyment cow 0 0 0 170 n/a 170 215 'Medical Examinations 90 0 0 80 n/a 80 TOTAL 111,915 99,340 108,420 127,700 18% 125,110 - OTHER OPERATING EXPENSE 301 Professional Services 0 0 0 0 n/s 0 303 Contractual Services 1,680 0 390 0 •-100% 0 422 Utility charge-Power 12,337 12,000 9,780 5,000 -49% 5,000. 423 Utility Charge-Other 2,242 5,000 0 1,000, n/a 1,000 425 Postage 0 0 0 50 n/a 50 441 Rental-Equipment 76 150 0 0 n/a 0 451 Insurance 0 0 0 0 n/a 0 452 Insurance Reserve 0 0 0 0 n/a 0 { 461 Equip Svc i Rep-Office 97 500 350 150 -57% 150 { 462 Equip Svc A Rep-other 0 500 250 0 -100% ' 0 76 1. r 4 .. , a , DEPARTMENT: GAS SYSTEM PROGRAM: OAS DISPATCH CODE: 423.2069 ' MAJOR CLASSIFICATION Actual Budget Adjusted Requested X Menager s ; r 91/92 92/93 92/93 93/94 Change Recommended OTHER OPERATING EXPENSE (Coot) ...... ...•.. ........ --------- ------ ---------- '. 471 Emp Exp-Uniform 0 0 0 0 n%a 0 472 Emp Exp-Travek 0 0 0 0 n/a 0 473 Emp Exp-Auto Allowence 474 Emp Exp-Meals 0 10 0 30 0 20 0 0 We -100X. 0 0 480 Other Svcs or Charges 0 0 0 0 We 0 301 Office Supplies 0 10D 100 100 0% . 100 503 Mater Repair 504 Operating'Supplies 0 688 0 1,450 0 1,050 0 1,500 n/a 43% 0 1,500 520 Computer Software 0 0' 0 0 n/a 0 571 Memberships 9 Suns 573 Training i Reference 0 0 250 0 250 0 250 0 0% n/a 250 0 TOTAL 17,130 19,980 12,190 8,050 -34% 8,050 INTERNAL SERVICE 4 401 Garage Service 0 0 0 0 n/a 0 ;., 402 Document Reproduction 0 50 50 200 300% 200 403 Telephone Svc/Veriable 3,029 4,20D.' 1,93D 1,840 -5X 1,840 ` 404 Messenger Service 0 0 0 0 n/a 0 405 Radio Service 3,736 3,740. 3,740 10,830 190% ,10,83D' ..4 406 'Telephone Svc/Fixed 832 480 1,400 1,060 -24% 1,060' 407 Postal Service 0 100 50 0 -10D% 0 YV 408 Bullding Service 0 0 0 0 n/a 0 r.c . 409 Insurance Admin 440 1,080 1,080 0 -100% 0 410 Data Processing Svc 3,510 3,630 3,630 5,170 42% 5,170 ' 411 Building Maintenance 0 0 0 0 n/a 0 412 Custodial service 0 0 0 0 n/a 0 413 Print Shop 0 100 100 200 100% 200 414 'Purchasing Service 0 0 0 0 n/a 0' 415 Garage-Veriable 0 0 0 0 We 0 416 Bldg A Maint-Variable 0 600 600 1,000 67% 1,000 418 Administrative Service 0 0 0 0 We 0 420 Employee Benefits 0 310 310 240 -23% 240 TOTAL 11,547 14,290 12,890 20,540 59% 20,540 CAPITAL 640 Machinery & Equipment 0 0 0 0 n/a 0 ... ' 642 Furniture &,Equipment 0 0 0 0 n/a 0 658 Construction Materials 0 2,000 2,000 1,000 -50% 1,000 910 'Contribution to Garage 0 0 0 0 We 0 sE, TOTAL 0 2,000 f 2,000 1,000 -50X 1,000 • "PROGRAM TOTAL 140,592 135,610 135,500 157,290 16% 154,700 f ' 77 s F+ DEPARTMENT: GAS SYSTEM MAJOR CLASSIFICATION Personal Services Other Operating Expense inte rnal services r capital r Debt Service Transfer r TOTAL PERSONAL SERVICE 101 Salaries i Wages FT 102 Salaries i Wages PT 105 Overtime 115 Sales Commission 201 Emp Life Insurance 204 Emp Major Medical 206 Esp Social Security 207 Esp Pension 209 Workers Compensation 210 bleabllity Insurance 211 Unemployment Comp 215 Medical Examinations TOTAL OTHE R OPERATING EXPENSE i 301 Professional Services 303 Contractual Services 311 Inventory Purchases { 421 Utility Charge-phone w. 422 Utility Charge-Power 423 Utility Charge-Other 424 Utility Charge-Other 425 Postage 427 Interfund-Other Fund 428 lnterfund-Other Charge 429 Interfund-Adein Charge 430 Document Recording 431 Advertising 432 Promotional Activity 433 Freight Charges 434 Printing i Binding PROGRAM: GAS DISTRIBUTION COOE:423.2065 L 2066 Actual Budget Adjusted Requested % Recommended % 91/92 92/93 92/93 93/94 Change 93/94 Change 1,249,601 1,297,610 1,304,870 11289,110 -1% 1,259,040 -4% 5,210,979 5,524,370 5,773,620 241,+440 -96% 241,440 -96% 491,403 518,620 525,220 266,830 -49% 266,830 -49% 40,726 57,600 61,190 26,500 -57% 26,500 -57% 516,901 524,830 530,170 4,570 .-99% 4,570 -99% 2,166,871 1,687,3BO 1,987,380 521,000 -74% 521,000 -74% 9,676,481 9,610,410 10,182,450 2,349,450 -77% 2,319,380 -77% Actual Budget Adjusted Requested % Manager's 91/92 92/93 92/93 93/94 Change Recommended 999,740 1,046,670 1,044,700 1,020,940 -2% 1,000,520 2,842. 0 4,880 0 -100% 0 33,724 52,500 52,500 43,400 -17% 43,400 0 0 0 0 n/a 0 5,454 4,800 7,250 5,490 -24% 5,490 73,467 75,600 75,600 88,200 17% 88,200 11,276 11,960 13,390 8,600 -36% 8,600 81,130 74,760 78,940 77,200 -2% 67,550 39,820 26,260 26,260 43,080 64% 43,080 813 460 Sao 1,000 100% 1,000 0 3,000 0 0 n/a 0 1,315 1,600 850 1,200 41% 1,200 1,249,601 1,297,610 1,304,870 1,289,110 -1% 1,259,040 43,621 45,000 132,680 0 -100% 0 5,700 6,220 19,820 98,000 394% 98,000 3,750,751 4,290,000 4,224,820 0 -100% 0 12,661 9,000 14,380 0 -100% 0 11,815 12,000 10,020 0 -100% 0 17,465 10,000 12,200 0 -100% 0 0 0 0 0 n/a 0 218 200 570 0 -100% 0 0 0 0 0 n/a . 0 35,790 27,290 27,290 0 -100% 0 519,020 554,850 554,850 0 -100% 0 0 0 0 0 n/a 0 93 6,000 0 0 n/a 0 -646 0 0 0 n/a 0 0 0 0 0 n/a 0 0 0 0 0 n/a 0 78 DEPARTMENT: GAS SYSTEM PROGRAM: GAS DISTRIBUTION CODE:423-2065 A 2066 Actual Budget Adjusted Requested % Manager's j ; 91/92 92/93 92/93 93/94 Change Recortmended OTHER OPERATING EXPENSE (Cont'd) 436 Taxes 410,533 300,000 510,460 0 -100% 0 441 Rental-Equipment 3,993 3,000 3,000 4,000 33% 4,000 451 Insurance 94,320 106,670 106,670 44,150 -59% 44,150 452 Insurance Reserve 147,370 0 0 0 n/s 0 461 Equip Svc i Rep-office' 1,012 1,000 1,000 2,200 120% 2,200 462 Equip Svc i Rep-Other 18,685 6,000 4,000 2,000 -50% 2,000 471 Eap Exp-Uniform 8,905 9,300 9,300. 7,430 -20% 7,430 472 Esp Exp-Travel 27,598 15,880 25,340 5,260 -79% 5,260 473 fop Exp-Auto Allowance 146 . 0 150 0 -100% 0 .474 Emp Exp-Masts 423 300 300 600 10D% 600 480 Other Svcs or Charges 1,911 0 600 0 -100% 0 501 Office Supplies 4,256 3,500 3,000 500 -83% 500 503 Meter Repair- 4,818 12,000 6,000 8,000 33X• 8,000 504 Operating Supplies 70,088 75,000 75,000 68,200 -9% 68,200 520 Computer Software 2,154 10,000 8,00D 0 -100% 0 571 Memberships i Subs 11,060 16,430 16,430 350 -98% 350 573 Training i Reference 7,219 4,730 7,740 750 -90% 750 TOTAL 5,210,979 5,524,370 5,773,620 241,440 -96% 241,440 INTERNAL SERVICE . 401 Garage Service 167,453 153,890 156,890 147,780 -6% 147,780 402 Document Reproduction 751 500 5,OOD 0 -100% 0 403 Telephone Service 1,862 3,000 3,000 0 -100% 0 404 Messenger Service 1,340 1,280 1,280 0 -100% 0 405 Radio Service 38,481 38,270 38;270 35,700 -7% 35,700 406 Switchboard Service 6,251 5,780 5,780 0 -100% 0 407 Postal Service 0 300 1,500 0 -100% 0 408 Building Servic 0 0 0 0 n%a 0 409 Insurance Admin 9,920 6,960 6,960 6,220 -11% 6,220 410 Data Processing Svc 4,280 4,420 4,420 31,070 603%' 31,070 411 Building Maintenance 6,214 22,770 22,770 9,640 -58% 9,640 412 Custodial Service 4,570 3,380 3,380 0 -100% 0 413 Print Shop 982 1,000 2,500 0 -100% 0 414 Purchasing Service 8,150 11,970 11,970 9,380 -22% 9,380 415 Garage-Variable 204 13,600 10,000 25,200 152X 25,200 416 Bldg A Maint-Variable 3,995 3,000 3,000 0 -100% 0 418 Administrative Service 236,950 246,560 246,550 0 -100% 0 } 420 Employee Benefits 0 1,940 1,940 1,840 -5%? 1,840 TOTAL 491,403 $18,620 525,220 266,830 -49% 266,830 CAPI TAL 640 Machinery i Equipment 25,962 46,100 46,100 12,500 -73% 12,500 641 Motorized Equipment 2,746 0 0 0 NO 0 642 furniture i Equipment 6,254 4,500 4,500 0 -100% 0 t '643 Computer Software 0 . 0 1,000 11,500 1050% 11,500 656 Construction Materials 4,294 2,000 4,000 0 -100% 0 910 'Contribution to Garage 1,470 5,000 5,590 2,500 -55% 2,500 :. TOTAL 40,726 57,600 61,190 26,500 -57% 26,500 79 s DEPARTMENT OAS SYSTEM PROGRAM: OAS DISTRIBUTION } CODE: 423.2065 b 2066 r. .: Actual Budget Adjusted Requested X" Manager's 91/92 ------ 92/93 ------ 92/93 ........ 93/94, ......... Change, ...... , Recarnuended ........... . i DEBT SERVICE '713 Principal-Leased Equip' 9,153 ' 28,560 •28,560 3,550 -8a% 3,550 ,-' 723 Interest-Leassd Equip 845 8,250 6,250 1,020 -88%. 18020 921 Sinking Fund-Principal 9,903 0 5,340 0 -100% 0 922 Slinking Furid-Interest, 497,000 4B8,020 488,020 0 7100% 0 TOTAL 516,901 524,830 530,170 4,570 4,570 TRANSFER 902 Interfuxl Transfer 792560 658,380 658,380 0 -100% 0 908 Capital improvements 1,174,311 819,000 1,119,000 300,000 300,000 931 Renewal i Replacement" 200,000 210,000 210,000 221,000 . 5% 221,000 TOTAL 2,166;871 1,687,380 1,987,380 521,000 -74% • 521,000 , "PROGRAM TOTAL 9,676,481 ' .9,610,410 10,162,450 2,349,450 -M 2,319,380 I 7 . . .i'tlaa ? ' , •x 8o , r a x e •I r• s r , (s a', ???lr€"?, is S •? r Y`• r. A . ? Lt: of ,:. ,}?r •'r, .:,4? DEPARTMENT: GAS SYSTEM MAJOR CLASSIFICATION Personal Services Other Operating Expense Internal Services capital Debt service Transfer TOTAL PERSONAL SERVICE 101 Salaries R Wages FT 105 overtime 201 Eep Life Insurance 204 Eep Major Medical 206 Esp Social Security 207 Emp Pension 209 Uorkers Compensation 210 Disability Insurance 215 Medical Examinations TOTAL OTHER OPERATING EXPENSE 303 Contractual Services 311 inventory Purchases 421 utility charge-Phone 422 Utility Charge-Power 423 Utility Charge-other 425 Postage 431 Advertising 434 Printing i Binding 441 Rental Equipment 451 Insurance , 461 Equip Svc i Rep-Office 462 Equip Svc i Rep-Other 471 Emp Exp-Uniforms i.• 472 Eap Exp-Trovel 473 Auto Allowance 474 Emp Exp-Meals 480 other Services 501 Office Supplies PROGRAM: GAS SERVICE CODE: 423-2067 d 2068 Actual Budget Adjusted Requested % Recommended % 91/92 92/93 92/93 93/94 Change 93/94 Change 724,282 770,890 752,650 848,990 13% 829,580 10% 160,974 136,900 162,770 176,970 9% 176,970 9% 102,321 92,460 100,970 163,780 62% 163,780 62% 7,546 4,100 4,090 9,700 137% 9,700 137% 1,725 9,210 0 14,850 n/a 14,850 n/a 0 0 9,150 0 -100% 0 -100% 996,848 1,013,560 1,029,630 1,214,290 18% 1,194,880. 16% Actual Budget. Adjusted Requested % Manager's 91/92 92/93 92/93 93/94 Change Recommended 572,839 613,700 597,800. 645,270 8% 632,360 40,936 39,300 39,240 53,370 36% 53,370 3,223 2,450 3,430 2,760 -20% 2,760 43,515 48,300 43,310 61,260 41%. 61,260 5,305 6,090 5,820 5,400 -7% 5,400 47,306 45,730 48,060 49,620 3% 43,120 9,890 13,920 13,920 29,910 115% 29,910 403 400 420 420 0% 420 865 1,000 650 980 51% 980 724,282 770,890 752,650 848,990 13% 829,580 483 0 7,170 0 -100% 0 109,220 100,000 99,020 90,000 -9% 90,000 0 0 0 0 n/a 0 6,363 5,50D 5,150 5,000 -3% 5,000 0 0 D 0 n/a 0 148 200 100 0 -100% 0 0 0 0• 0 n/a 0 0 0 0 0 n/a 0 996 S00 660 1,000 52% 1,000 0 0 44,140 n/a 44,140 i 265 300 100 200 100% 200 i 4,056 1,000 100 0 -100% 0 5,487 6,100 3,600 5,150 43% 5,150 3,277 2,500 8,090 4,400 -46% 4,400 0 0 40 0 -100% 0 i 351 30D 220 350 59% 350 I} 195 . 0 11,300 D -100% 0 120 500 250 50D 100% SOD 81 Actual Budget Adjusted Requested % Manager1s 5 91/92 92/93 92/93 93/94 Change Recommended ----- •----- ........ --------- ------ ........... ? OTHER OPERATING EXPENSE (continued) 504 'Operating supplies 28,663 20,000 26,010 ' 25,000 -4% 25,000 ; 571 Mw*erehip/subs 65 0 BO 0 -100% 0 573 Training i Reference 1,285 0 880 1,230 40% 1,230 TOTAL 160,974 136,900 162,770 176,970 9% 176,970 INTERNAL SERVICE 401 Garage service 72,162 59,450 69,790 70,020 0% 70,020 r 402 Document Reproduction 215 300 300 300 0% 300 403 Telephone service 170 400 200 400 100% 400. 405 Radio Service 0 0 0 23,320 n/a 23,320 406 Switchboard Service 1,946 3,370 3,370 2,000 -41% 2,000 407 Postal Service 0 S0 50 50 O% 50 409 insurance Admin 4,460 4,510 4,510 6,220 38% 6,220 410 Data Processing Svc 9,000 9,300 9,300 5,180, -44% 5,180 411 Guildin % Maintenance 0 0 0 16,140 n/a 16,140• 412 Custodial service 5,608 4,300 4,300 3,010 -30% 3,010 . 11 413 Print Shop 969 1,500 1,480 1,500 1% 1,500 t 414 Purchasing service 3,410 0 0 9,380 n/a 9,380 415 Garage-Variable 4,179 5,000 3,400 20,000 488% 20,000 .: ' 416 Bldg i Maint-Variable 0 3,000 2,990 5,000 67% 5,000 420 Employee Benefits 0 1,280 1,280 1,260 .2% 1,260 TOTAL 102,321 92,460 100,970 163,780 62% 163,780 CAPI TAL ? 640 Machinery i Equipment 7,350 2,100 2,100 4,700 124% 4,700 642 Furniture 9 Equipment 0 0 0 0 n/a 0 643 Computer So ` ' 0 0 0 1,000 n/a •1,000 658 Construction Materials 196 2,000 1,990 4,000 101% 4,000 910 Contribution to Garage 0 0 0 0 n/a 0 TOTAL 7,546 4,100 4,090 9,700 137% 9,700 DEBT SERVICE 713 Principal-Leased Equip 1,565 7,150 7,130 12,270 72% 12,270 723 Intereat-Lensed Equip 160 2,060 2,020 2,580 28% 2,580 u{ TOTAL 1,725 9,210 9,150 14,850 62% 14,85D **PROGRAM TOTAL 996,848 1,013,560 1",029,630 1,214,290 18% 1,194,8$0 82 r! r DEPARTMENT: GAS SYSTEM PROGRAM: SALES CODE: 423.2063 < < MAJOR Actual Budget Adjusted Requested % Recommended X' ' CLASSIFICATION 91/92 ...... 92/93 ...... 92/93 ........ 93/94 --------- Change ...... 93/94 --------- Change ------ Personal Services 131,735 146,670 146,400 241,930 65%, 738,870 63% Other operating Expense 238,333 284,450 277,850 545,040 96% 545,040 96% ' Internal services 2,919 12,320 12,320 15,040 22% 15,040 22% . Capital 100 1,000 1,000 6,200 520% 6,200 520% ]f Debt Service 0 0 0 0 n/a 0 n/a ] Tranifer 0 0 0 0 n/a 0 n/a TOTAL 373,087 444;440 437,570 808,210 85% 805,150 84% : Actual Budget Adjusted Requested % Manager's 91/92 92/93 92/93 93/94 ,Change Recommended PERSONAL SERVICE ------ ------ ........ --------- ------ ---- ----- 101 Salaries i Wages FT 78,587 94,720 100,600 153,130 52% f 150,070 - 102 Salaries i Wages PT 0 0 610 0 -100% 0 ? 105 Overtismt 0 0 0 0 We 0 115 Sales commission 33,316 32,000 25,500 50,000 96% 50,000 201 Epp Life Insurance 363 490 630 910 44% 910 204 Epp Major Medical 8,412 8,400 8,000 17,150 114% 17,150 206 Emp Social Security 9,259 9,770 9,770 11,540 18% 11,540 207 Emp Pension 0 0 0 0 n/a 0 209 Workers Compensation 1,000 490 490 8,380 1610% 8,380 210 Disability Insurance 798 800 800 820 3% 820 211 Unemployment Comp 0 0 0 0 n/a 0 215 Medical Examinations 0 0 0 0 n/a 0 TOTAL 131,735 146,670 146,400 241,930 65% 238,870 OTHER OPERATING EXPENSE 301 Professional Services 0 0 0 0 n/a 0 303 Contractual Services 34,031 45,000 36,000 50,200 39% 50,200 311' Inventory Purchases 101,876 119,000 100,000 190,000 90% 190,000 421 Utility Charge-phone 0 0 0 0 n/a 0 422 Utility Charge-Poser 0 2,000 2,000 7,600 280% 7,600 423 Utility Charge-City 0 0 0 0 n/a 0 424. Utility charge-other 0 0 5,200 n/a' 5,200 425 Postage 253 . 500 500 750 50% 750 42a Interfund-Other charge 0 0 0 0 n/a 0 429 Interfund-Adman Charge 0 0 0 0 n/a 0 430 Document Recording ' 830 1,000 600 1,000 67% 1,000 u 431, Advertising 65,719 50,000 86,000 120,000 40% 120,000 432 Pro wtional Activity 21,609 50,000 37,000 120,000 224% 120,000 433 Freight Charges 441 Rental-Equipment 130 359 0 150 0 150 0 1,200 n/a 700% 0 1,200 442 Rental-Building 0 0 0 25,000 25,000 451 Insurance 0 0 0 0 n/a 0 452 Insurance Reserve 0 0 0 0• n/a 0 461 Equip Svc i Rep-Office 0 100 100 100 0% 100 462 Equip Svc & Rep-Other 100 0 0 0 n/a 0 83 r' Fe' I' '1 • Y r DEPARTMENT: GAS SYSTEM PROGRAM: SALES CODE: 423.2063 r , MAJOR CLASSIFICATION Actual Budget Adjusted Requested % Manager0a 91/92 92/93 92/93 93/94 Change Recanmended ' OTHER OPERATING EXPENSE (Copt) ------ ...... -------- --------- .----.. .......... 471 Esp Exp-Uniforms 0 0 0 0 n/a 0 472 Emp Exp-Travel 2,022 1,620 1,620 4,170 157% 4,170 473 Esp Exp-Auto Allowanco 7,635 10,580 9,580 13,220 38% 13,220 474 Eap Exp-Meals 109 70 0 0 n/a 0 ? 480 Other Svcs 'or Charges 647 1,000 1,000 •1,500 50% 1,500 501 Office Supplies 272 700 500 700 40% 700 503 " Meter Repair 0 0 0 0 We 0 504 Operating Supplies 395 SDO 500 800 60% BOD 520 Computer Software 0 0 370 0 -100% 0 571 Memberships i tubs 1,270 900 900 1,270 41% 1,270 573 Training 9 Reference' 1,076 1,030 1,030 2,330 126% 2,330 TOTAL 238,333 284,450 277,850 545,040 96% 545,040 INTERNAL SERVICE 401 Garage Service 0 0 0 0 n/a 0 402 Docurent Reproduction 180 200 200 200 0% 200 403 Telephone Svc/Variable 0 1,500 1,500 750 -50%- 750 404 Messenger Service 0 0 0 0 n/a 0 405 Radio Service 0 0 0 4,120 We 4,120 406 Telephone Svc/Fixed 1,666 2,520 2,520 2,230 -12% 2,230 407 Postal Service 0 3D0 300 300 0% 300 , 408 Building Service 27 0 0 " 0 n/a 0 409 Insurance Admin 0 780 780 .. 0 -100% 0 410 Data Processing Svc 0 2,800 . 2,800 5,180 85% 5,180 7 411 Building Maintenance 0 0 0 0 n/a, 0 412 Custodial service 0 0 0 0 n/a 0 413 Print Shop 1,046 1,000 1,000 1,000 0% 1,000 414 Purchasing Service 0 0 0 0 We 0 415 Garage-Variable 0 0 0 0 n/a 0 416 Bldg i Maint-Variable 0 3,000 3,000 1,000 -67% 1,000 418 Administrative Service 0 0 0 0 n/a 0 420 Employee Benefits 0 220 220 260 18% 260 TOTAL 2,919 12,320 12,320 15,040 22% 15,040 CAPITAL 640 Machinery 4 Equipment 640 0 0 0 2,200 n/a 2,200 I 642 Furniture i Equipment 100 0 0 0 n/a 0 , i 643 Computer Software 0 0 1,000 n/a 1,000 658 Construction Materials 0 ' 1,000 1,000 3,000 200% 3,000 i ..: 910 Contribution to Garage' 0 0 0 0 n/a 0 TOTAL 100 1,000 1,000 6,200 520% 6,200 DEBT SERVICE 713 Principal-Leased Equip' 0 0 0 0 n/a 0 723 Interest-Leased Equip 0 0 0 0 n/a 0 921 Sinking Fund-Principal 0 0 0 0 n/a D 922 Sinking Fund interest 0 0 0 0 n/a 0 TOTAL 0 0 0 0 We 0 TRANSFER 902 Interfund Transfer 0 0 0 0 n/a 0 90B Capital Improvements 0 0 0 0 n/a 0 .931 Renewal i Replacement 0 0 0 0 We 0 TOTAL **PROGRAM TOTAL 0 373,087 0 444,440 0 437,570 0 806,210 n/a 85% 0 805,150 94 'rh ` V r k ' DEPARTMENT: GAS SYSTEM PROGRAM: PASCO GAS EXPANSION CODE: 473-2072 HAJOR Actual Budget Adjusted Requested % Recommended % CLASSIFICATION 91/92 ------ 92/93 --- . 92/93 ........ 93/94 ......... Change ...... 93/44 .......... Change ------ 1... Parsonal Services 0 0 D 215,990 n/a 212,100 n/a Other operating Expense 0 0 0 163,360 n/a 163,360 n/a , Internal services 0 0 0 14,970 n/a 14,970 n/a Capital 0 0 0 .7,700 n/a , 7,700 n/a Debt Service 0 10., 0 0 n/a 0 n/a 1...' Transfer 0 0 0 O n/a 0. n/e TOTAL 0 0' .0 402,020 n/e 398,130 n/a Actual Budget Adjusted Requested % Manager"s 91/92 92/93 92/93 93/94 Change Recommended PERSONAL SERVICE ...... ...... -------- ......... ...... - --------- 101 Salaries i Wages FT 141,420 We 138,590 102 salaries i Wages PT 0 n/a 0 ' 105 Overtime 6,000 n/a 6,000 113 Sales Commission 30,000 n/a 30,000 201 Emp Life Insurance 320 n/a 320 204 Esp Major Medical 17,150 n/a .17,150 J 206 Esp Social Security 4,250 n/a 4,250 207 Eep Pension 8,480 n/a 7,420 209 Workers Coapensetion 8,370 n/s 8,370 ' 210 Disability insurance 0 n/a 0 ' 211 Unemployment Comp 0 n/s 0 215 Medical Examinations' 0 n/a 0 TOTAL 0 0 0 215,990 n/a 212,100 OTHER OPERATING EXPENSE 301 Professional Services 70,000 n/s 70,OOD 303 Contractual Services 1,500 n/a 1,500 311 Inventory Purchases 0 n/a 0 421 Utility Charge-Phone 0 n/a 0 422 Utility Charge-Power 6,000 r"a, -.6,000 473 'Utility Ch3rge-City 2,400 n/a 2,400 424 Utility Charga-Other 1,000 n/a 1,000 425 Postage 250 n/a 250 .. 431 Advertising 0 n/a 0 432 Promotional Activity 0 n/a 0 433 Freight charges 0 , n/a, 0 434 Printing i Binding 2,000 n/a 2,000 436 Taxes 0 n/a 0 441 Rental-Equipment 1,200 n/a 1,200 442 Rental-Building 40,000 n/a 40,000 451 Insurance 0 n/a 0 452 Insurance Reserve 0 n/a 0 ? & Rep-Office' 461, Equip Svc 300 n/a, 300 . , 462 Equip Svc i Rep-Other 0 n/a 0, 467 Repair/Maint-Structural Fac 15,000 n/a 15,000 85 o-' `4. 3 423.2072 COOE DEPARTMENT: GAS SYSTEM PROGRAM: PASCO GAS EXPANSION t MAJOR CLASSIFICATION Actual Budget Adjusted Requested % Manager's 91/92 92/93 92/93 93/94 Change Recommended ' OTHER OPERATING EXPENSE (font) ...... ........ ......... ...... . __________ 471 Eap Exp-Uniforms 670• We 670 472 Emp Exp-Travel. 0 n/e 0 473 Emp Exp-Auto Allowance 6,290 n/a 6,290 474 Eap Exp-Keels 200 n/a 200 480 Other Svcs or Charges 0 n/a 0 501 office Supplies 1,000 n/a 1,000 ' 503' Meter Repair 0 n/a 0 504 Operating Supplies 15,200 n/a 15,200 •520 Computer $oftwere 0 n/a 0 571 Memberships i Subs 350 We 350 573 Training EI Reference 0` n/e 0 r TOTAL 0 0 0 163,360 n/a 163,360 ? .. INTERNAL SERVICE .401 Garage Service 0 n/a 0 402 Document Reproduction 1,000 n/a 1,000 .403 Telephone Svc/Variable `720 n/a 720 404 Messenger Service Q n/a 0 405 Radio Service 0 n/a 0 406 Telephone Svc/Fixed 0 n/a 0 f 407• Postal Service 300 n/a 300 408 bullding Service 0 We 0 ` 409 ,Insurance Admin 0 n/a 0 ; 410 Date,Processing Svc 0 n/a 0 411 Building Maintenance 0 n/a 0 412 Custodial Service 0 n/a 0 413 Print Shop 2,000 NO 2,000 `." 414, Purchasing Service 0 n/a 0 '. 415 Garage-Variable 10,950 We 10,950 416 Bldg 4 Maint-Variable 0 n/a 0 418 Administrative Service 0 n/a 0 420 Employee Benefits 0 n/a .0 TOTAL 0 Q 0 14,970 n/a 14,970 CAPITAL , 640 Machinery t Equipment 7,200 n/a 7,200. ° 642 Furniture A Equipment 0 n/s 0 643• Computer Software 500 n/s 500 656 Construction Materiels 0 n/a 0 910 Contribution to Garage D We 0 ,. TOTAL 0 0 0 7,700 n/a 7,700 DEBT, SERVICE 713 Principal-Leased Equip •0 n/a 0 723 Interest-Leased Equip 0 n/a 0 # 921 Sinking Furl-Principal 0 n/a 0 922 Sinking Fund-Interest 0 n/a 0 .r TOTAL 0 0 0 0 n/a 0 TRANSFER 902 Interfund Transter 0 n/e 0 908 Capital Improvements 0 n/a 0 > & Replacement 931 Renewal •0 n/a 0 + , TOTAL 0 0 0 0 n/a 0' **PROGRAM TOTAL 01 0 0 , 86 .402,020 Wa. 398,130 S ' tr, • , w n . ?': 1, S" a , • z i "`! /1.. I • . d .d - DEPARTMENTs GAS SYSTEM PROGRAM: GAS MARKETI NG iC PLANNING CODE: 423-2071 MAJOR Actual Budget Adjusted Requested % Recommended % CLASSIFICATION 91/92 92/93 92/93 93/94 Change 93/94 ' Change :I ------ ------ -------- --------- ---- , ---------- ------ Personal services 0 0 0. 113,710 n/a •110,910 n/a Other Operating Expense 0 0 0 67,550 n/a 67,550 n/a Internet Services 0 0 0 5,200 n/e 5,200' n/s '. Capital 0 0 0 9,300 n/a 9,300 Iva Debt Service 0 0 0 0 n/a 0 n/a Transfer 0 0 0 0 No 0 n/a ' TOTAL 0 0 0 195,760 n/a 192,960 n/a . Actual- Budget Adjusted Requested % Manager's 1 91/92 92/93 92/93 93/94 Change ReconitnmxW PERSONAL SERVICE ----- ------ -------- •-------- ...... ---------- 101 Salaries i Wages FT 93,380 n/a 91,510 102 Salaries i Wages PT 0 n/a 0 105 Overtime 0 n/a 0 ' 115'. Sales Commission 0 n/a 0 . 201. Emp Life Insurance 560 n/a 560 204 Emp Major Medical 7,350 n/a 7,350 206 Esp Social Security 1,360 n/a 1,360 207 Emp Pension 7,470 n/a 6,540 209 Yorkers Compensation 3,590 On 3,590 210 Disability Insurance 0 n/a 0 211 Urmployment Comp 0 n/a 0, 215 Medical Examinations 0 n/a 0 TOTAL 0 0 0 . 113,710 n/a 110,910 OTHER OPERATING EXPENSE 301 Professional Services 0 n/a 0 303 Contractual Services 0 n/a 0 311 Inventory Purchases 0 n/a 0 421 Utility" Charge-Phone 0 n/a 0 ' 422 Utility Charge-Power 0. n/a' 0 423, Utility Charge-other 0 n/a 0 475 Postage 42E Interfund-Other Charge 300 0 n/a n/a 300' 0 429 Interfund-Admin. Charge 0 n/a 0 , 430 Document Recording 0 n/a 0 431 Advertising 20,000 n/a 20,000 432 Promotional Activity 10,000 n/s 10,000 . 433 Freight Charges 0 n/a 0 434 Printing L Binding 0 ' n/o 0 436 Taxes 0 n/a 0 441 Rental-Equipment 0 n/a. 0 451 Insurance 0 n/a 0 452 insurance Reserve 0 n/a 0 - 461, Equip Svc i Rep office 0 n/a 0 462 Equip Svc i Rep-Other' 0 On 0 87 • ir' ? f ?,t ? _, ' Y t Ile:.. ' - . ! i.... I t t DEPARTMENT: GAS SYSTEM PROGRAM: GAS MARKETING i PLANNING CODE: 423-2071 y MAJOR CLASSIFICATION Actual Budget ; Adjusted Requested X Managerfs , 91/92 92/93 92/93 93/94 Change Recommended . ' OTHER OPERATING EXPENSE (Cant) ------ ...... -------- '----<---- ------ ... ...... 471 Emp Exp-Uniforms 0 We 0 472 Emp Exp-Traval 3,900 We' '3,900 473 Emp Exp-Auto Allowance 3,000 n/a 3,000 474 Emp Exp-heals 300 We 300 480 Other Svcs or Charges 0 n/a 0 t , 501 Office Supplies 1,000 n/a .1,000 503 Meter Repair 0 n/a 0 .• 504 Operating supplies 27,000 We 27,000 520 Computer Software 0 n/a 0 571 Memberships i subs 250 We 250 573 Training i Reference 1,800 n/a 1,800 TOTAL 0 0 0 67,550 n/a 67,550 .-: INTERNAL SERVICE "t 401 -Garage Service 0 n/a 0 . ' 402 Document Reproduction 200 We 200 403 Telephone Svc/Variable 0 We 0 404 Messenger service 0 We 0 405 Radio Service 0 We 0 406 Telephone Svc/Fixed 0 n/a 0 ' 407 Postal Service 0 n%e 0 408 Building Service 0 n/a 0 ,., 409 Insurance Admin 0 n/a 0 410, Data Processing Svc 0 n/a 0 nr 411 Building Maintenance 0 n/a 0 412 Custodial Service 0 n/e 0 ` 413 Print Shop 2,000' n/a 2,000 ; 414 Purchasing Service 0 n/a 0 , 415 Garage-Variable '3,000 We 3,000 416 Bldg i Meint-Variable 0 Na 0 418 Administrative Service 0 n/a 0 420 Employee Benefits 0 n/a 0 TOTAL 0 0 0 5,200 n/a 5,200 CAPITAL 640 Machine R Equipment 8,300 n/a 8,300 642 Furniture i Equipment 0 We 0 643 Computer Software 1,000 We 1,000• 658 Construction Materials 0 We 0 .. 910 Contribution to Garage 0 n/a 0 TOTAL 0. 0 0 9,300 n/a 9,300 DEBT SERVICE 713 Principal-Leased Equip '0, n/a 0 ' 723 Interest-Leased Equip 0 n/a 0 921 Sinking Fund-Principal 0 n/a 0 922 Sinking fund-Interest 0, n/o 0 TOTAL 0 0 0 0 n/e 0 TRANSFER 902 Interfund Transfer 0 We 0 908 Capital Improvements 0 We 0 931 Renewal '& Replacement 0 n/a 0 , TOTAL **PROGRAM TOTAL 0 0 0 0 0 ` 0 0 195,760 n/a n/a 0 192,960 88 4 I GAS FUND . (A23) C RY OF CLEARWATER PROJECTED REVENUE - NEXT BUDGET YEAR 23 94 DEPARTMENT: GAS SYSTEM r REVISED 93194 f , 90191 91192 92/93 "3 ESTIMATED % OF ` CODE REVENUESOURCETRLE ACTUAL ACTUAL BUDGET BUDGET BUDGET CHANGE PROGRAM 00000-343211 Gas sales 8975037 10643806 10400000 11016690 12180000 10,6% Admin. & Supply 00000-343212 Gras Service Charge 106906 57125 110000 69570 147800 112.4% Service ' .. ii 00000-343213 Franchise Fee 123377 162919 140000 172120 180000 4.6% , Admin. & Supply 00000-349214 Cos Transportation Service 33719 2111 10000 0 0 0.0% . Admin. & Supply 00000-343216 Appliance sales 140805 133547 170000 144270 250000 73.3% Sales 00000-343221 Mslerials & Service Charges 40946 0 152500 .107520 342200 218.3% Service 00000-343222 Inspection Fees 903 3381 1000 6580 3000 -54.4% Distribution 00000-343223 Other Gars Raverx^V Gas 22522 19243 90000 41870 130000 210.5% Admin. & Supply 00000-343224 Finance ChargesAw Appliances 7152 1559 9000 3990 4000 0.3% Sales t 00000-343225 Installation Charges 142120 210739 225520 169060 700000 314.1% Installation 00000-343226 Recording Fees/Gas Appliances 660 996 1000 1440 1000 -30.6% Sales 00000-343251 Other Gas Appliarm Revenue 7355 4983 9000 880 5000 635.3% Sales 00000-354104 late Payment Foes 53010 64416 69000 60200 70000 16.3% Admin. & Supply 00000-369415 Caphalized Laborfrmnaler CIP 426364 404138 470000 450000 65WW 44.4% Distrbution 00000-389902 Prior Working CaPhal 371810 224290 224290 1010000 350.396 Admin. & Supply 00000-361101 Interest on Investments 207657 166507 200000 200000 570000 185.096 Admin. & Supply _ 00000-361102 Interest on Earnings - Other .0 24213 0 0 0 0.0% 00000-369010 Svc, Charge - Public Service 0 14410 13670 0 16000 100.0% Dispatch 00000-369410 Svc, Charge - General Furl 0 1290 0 0 0 0,0% 00000-369421 Svc. Charge - Water Division 0 69080 60120 73790 76000 3.0% Dispatch 00000-369424 Svc. Charge - Solid Waste 0 6280 5470 5470 - - _0 - -100 -0% TOTALS _-_- _ 10288535 --- 12362553 --- 12360570 _ _ 12747540 16335000 28.1% 1 93194 f ESTIMATED SUBTOTALS SY PROQW BUDGET Administration & Supply 14140000 Dispatch 92000 Distribution 653000 Service 1190000 Sales 260000 TOTAL 16335000 89 • t. / f ? I? :' ¦ I .I 1 LS , r I ' = ACCOUNTINra.ZBEATMENI Please note that the City Budget is done on a "Cash Basis". which includes Capital . :.. Improvement`Expenditures and Debt Principal Repayment. We also include a revenue' Item to.offset the Dividend Payment as this is paid from Prior'Year Working Capital. The Financial Income Statements are done on an "Accrual Basis" which does not include the above listed items but includes Depreciation expense an capital assets "instead. This is consistent with the City's '"Proforma" 'fund statements. and typical ; business accounting. This provides the basis for the Gas System's Net Income, one- half of which currently is paid as a ',Dividend to the City in the second fiscal year after it is'.earned. i . , r r tJ3 JJ, Jt e q t? ?l . ?'1 i CLEARWATER GAS SYSTEM O E V E$ DATA f,. xemarxsiQuaiir ers hiervice Area in Square Miles 135 North Pinellas Co. Only Population 410,000 Per PEDC Data towelling Units 188,000 @ 2.18 occupants/Dwelling 3ustomers --Total NG+LP 11,677 June 1993.Billigs F Residential Firm NG 91588 to Commercial Firm NG 11944 Interruptible NG 12 " -Liquid Propane NG 83 11(71 res/12 com) A of Dwelling Units Using CGS Gas 5.1% June, 1993 Billing Month •Ailes of Natural Gas Main 472.15 June 30, 1993• Actual Natural Gas Customers/Mile of Main •24.7 June 30, 1993 Actual of Residential Firm Customers: With Water Heating 751% Estimated With Gas Cooking 40% of With Gas Heating 30% " ['Annual Heating Degree Days 532 10 Yr. avg. NOAA Data @ Tampa,.. Annual Cooling Degree Days 3,613 er 1Contract Demand (MMBtu/Day) 10,219 November 1992 - April 1993 All Time Peak Load (MMBtu/Day) 10,661 January 21, 1985 Actual• L annual Peak Load (MMBtu/Day) 81885 FY 91/92.(January 16, 1992) 71834 FY 92/93 (February 19, 1993) Annual Gas Sales (Therms) 15,117,789. FY 91/92 Actual ?•Annual Load Factor vs. Peak 46.5% FY 91/92 Actual Annual Load Factor vs. Contract 53.9% FY 91/92 Actual. ad Factor thl M L Av 79 6% FY 91/92 Actual y o on erage . Avg. Single,Family Home Consumption 273 FY 91/92 Actual, (Therms) Annual Gas Revenues $11.34M FY 91/92 Actual Employees (Full--time Equivalent) 67.7 FY 92/93 Budget Authorized "Customers Served/Employee 172.5 June 1993 Billings. 91 t i OVERVIEW OF CLEARWATER GAS SYSTEM (A DIVISION OF THE CITY OF CLEARWATER) ........ •:? /?AS?co co. uN?•. . . TANiPQN ' 'r. f1F].IEA1R, • ,?:: •• •' •:TIWPk . ee?cri '. •• .,. . , . t' :•: • .BAY. . NOW LARGO now SUCH wAl s "mw/uulvnvi? Ratio -CGS CURRENT SERVICE; AREA- ' POTENTIAL :EXPANSION th 'AREA 'COUNT;: 4: NTY-- • PEOP CLEARWATER CIS SYSTEM U PINEUlAS PEOPLES COUNTY GAS -TAMPA BAY/SUNCOAST AREA- - KEY SERVICE CHARACTERISTICS & DATA - NATURAL & PROPANE GAS SERVICE -- GAS APPLIANCE SALES do SERVICE - INSTALLATION OF CUSTOMER GAS PIPING - DOMESTIC AND COMMERCIAL GAS EQUIPMENT SERVICE - 135 SQUARE MILES OF SERVICE TERRITORY - 472 MILES OF MAIN PIPELINES - SERVE 11 MUNICIPAL AREAS: BELLFAIR BELL FAIR BEACH AELLUR BLUFF'S BE I I FAIR SHORES CLEARWATER- DUNEDiN INDIAN ROCKS BEACH LARGO OLDSMAR SAFETY HARBOR TARPON SPRINGS AND UNINCORPORATED NORTH PINELLAS COUNTY: CRYSTAL BEACH HIGHPOINT EAST LAKE OZONA HARBOR BLUFF'S PALM HARBOR HARBOR HILLS TOP OF THE WORLD f f i I I I I 12,000 CUSTOMERS - $ 12.5 MILLION ANNUAL GAS REVENUES 10,661 MMBTU/DAY PEAK DEMAND (1/21/85) 10,219 MMBTU/DAY PEAK CONTRACT (FGT) SUPPLIER: FLORIDA GAS TRANSMISSION 411 92 TAMPA E3AY/ SUNCOASr AREA -- FLORIDA= E r is I 't'?rY, r . r .,1"^"x'tT,'f#:: i`!.. .. : • ' f ...:t'' •;+: ' ?''..?• ?f:?~ i?>?,r?.r. r1 ..?,,« ?,II f . o z r cn V ._ Z LU 'Sti.!,j .y'js '"SJt?yif• _1•,lih , ,. .. ' -'i 1., ro. 11b... , ?'',• ?° '??• '' ? • 'Y???'.'t?.;r'r.i ,ice •? >?? , CY) i°`??+,f>rt,ri, r. ?:?..'`'?y &+rt,;::y rig=•, `Ti ^E::,.., O' i:!:rr...:?M1-R.J+.??y:rty! , fu>J. y'r\IrJ4 i''r'r+\!•r'`ul n./n;r r.w ti' s.r .. •. ¦ ¦ 4JJ . ?a r' ? ttirti?r •.?.<."Jy. wait. ''' ... ?. .. .' ? ? T i •1\, ?.T: ?RLa.tr:.t 4.??r?ry??y,•yr?n r'':n .S,..'.w ?./ ?. I', A'1.4ti fJiJti\r,.?_,•s?.. .'? ?\Z o •?"` :V jI'1::.'r+R'w ?•?Clt;'P •L?• '?1.":'.!-?.. ,J,, >??i. •i?,: ,,i ?r.,.o,.:6 '! t 'CSRC:.:: :. cn jS.." '??.AS't•'• ?'°4??:.°.:.:?r, ;sl.'?1 ?'''?11`'. "?k '''?:'? C. .. O ? + _ fi?frY'••?'..?.t?h;i•,-1ni?,'^lur•..l?:S.i`rr.. 4'??ren'.::;:s. .y .. ?{[?i';tt>,I.{?,c'si'?.ey'-t?'?'`s~:?.=i?'V.".•'T-??r?'1:?7i?iU'i+':1f,•:,?_,: ?• :- O ,? S ?lrpi lr•iuaGti;?-''.S, r s ;Y:,??;?,r , .. ..... _ ? '? .r 'lesl?j.4-r'=sru•?i ? ti.14 .T:y. r C:7 In ` LL .MNY-Iar .+?wr 1 ?/? r`?A Ir ere ?aS i•R?t•rF _'e. t ,:S...Y •ih..K r+.i4. M3':?fAq. ?/..? ??_? o ' :Zv Nd CL • ? ?.••'?'•?f c• rte. .. .,'..' ?v,???"•q..(•?.{• f• ..,?: ??._?, 't7,yv', "? W H 'i?f 'y l? ? ••'? 'Y' a•' Y?a?s?.:q'iy ??"'•• ?,.' i•.' ? : .. ... _ .. . , ' a wn• ]er: .. ?.hr f.. a... .ru w L :plf i'.?i ??+: 4 •. f.r. i of ll: `r??'[YS:ds ? ..? 1'?S^ ??IIi..:a ... . ... , • o A rY kY?:c?l.?+.:.l.w ?N???-!•LS'; :r?;. ?;'. `: O i Is ?:j f-1: ..-?..i:??-riRi..;l'?i:r•? 'x?Rir:a;y re•,r.•,.. .. ? ?' O 1'? . Pl+\!• .. • •:Nfw Hs w.«: -..7.'.:: w?y{?..: f1 il..k 5,..'.. •., ?`.•. L ? , 1 WO 13, k ice' r•.•. .-:• •?:? tyrrM Iv rYiy ?,1z: '1 nr'r.,,?. ? ... ? r? F..y ?? f 'b.: S'•3 ? ' r r -{7?n` y7e ld, r:r.N •'??.?•?•. f r?s,.r.`•. ,::"f . "Y. .•.Y•` ? ? . u ut.?'Liwr{rky.W. +?••N+.Yi..L7 ??, T?:r ?•.•:. "i^, r£ 71t. `: rt t.?,?:''~rs, i r,`y:[4-' ?~?.??•.,rl',r,: . ; r RR" ;sit ,::??ilfNF-i?? •\3,1.. .? ua;+ y .. ? '? ' 7? LL . , ..,.:,fit, .k a ., ? . • i', tel.' - 1 .. ? r f - , • r r TABLF. OF CONTENTS OVERVIEW ' T2ge .. Key CGS Data . '. ......... . . .... ..... ...... iii Map & Key Service Characteristics ............................ . I. Population & Dwelling Units .... :.......... ................. 2 CUSTOMERS Total Customers (Natural & LP) . , . , ..... ' . ........ . ....' .. ' 3 Residential Firm Natural Gas Customers ............ . ........... 4 Non-Residential Firm Natural Gas Customers ... ............... 5 Interruptible Natural Gas Customers ......... , .. ............ . .. 6 Propane (LP) Customers ........... . ................... '. . 7 Ten Largest Customers . . . .... . ............... ..... 8 New Customers Connected ............... . . . . . .... . „ , . , .. , 9 ....... . ............. . .. ' .. Net New Customers ... ' ' 10 Customers Vs. Revenues bss .............::.......... * 61a 11 Customer Equivalency ............................... . ; 12 Jurisdictional Breakdown ....... ....................... 13 Jurisdictional Breakdown (Outside of Clearwater) ...... . .......... 14 Customer Saturation in Pinellas County ........ . ......... , .. '.. 15 DISTRIBUTION MAIN LINE STATISTICS System Miles of Main ....... ....... . ..... . ............. 16 New Miles of Main ............. .. ............. , ... 17 Miles of Main Replaced 18 ............................... Natural Gas Customers Per Mile of Main ...................... 14 WEATHER EFFECTS " Residential Equipment & Degree Days ..:.. . ............ '...... 20 Annual Weather Data (20 years) .... . .................. ...... 21 Heating Degree Days ...................... , ............ 22 Natural Gas CCF Billed .....:..... " ....................... 23 Natural Gas. CCF Consumption Billed .......... ...:. . ........ 24 Analysis of CCF & Budget Effects ........ .......... .... ... 25 + TRANSMISSION PIPELINE CAPACITY & DEMAND Peak Contract Demand (MMBTUIDay) ........... . .......... , . 26 Peak Load (MMBTU/Day) .. . ............................ 27 Therms Sold (Millions) ...... ............ ............ • ..... 28 .. ` ... ... '. . Load Factor Data 29 . ... . ................, ... .. i t f? , ?jr v { • f I f f 1 • ` • ,i y. f I • " • .r i,,' ?. .. f Y+:M fir.. s r 1' J • ? . . , A ' A ' EMPLO 1 EES . 1 ' ' • ' , Rage, , .. Authorized Employees .........: ... ' ..... . : .......... '.... 30 Customers Served Per Employee ....... , . .' ..... ...:... 31 PROGRAMS Meter Change-Out Program ............ ................ 32 Water Heater Promotion Program .. ......... ..... ....... 33 .: . REVENUES Total Revenues Overview ........ ............ ... .. 34 Gas Revenues Overview ................................ 35 Other Revenues' Overview . , ........... .. ..... .. - 36 Total Revenues ....................... .. ..... ' ... ; . 37 Gas Sales (Natural & LP) ......... . ...... : ........ , , .. ; . -, . 38 ' Installation Revenues .............. ...... . ......... 39 Service Revenues ..... 40 Appliance Related-Sales ... ................... ... ....: 41 OPERATING BUDGET Operating Budget Overview ..............:.............. 42 Total Operating Budget ...........• ..................:. . . 43 Cost of Fuel & Appliances ........... ..: ........... .. 44 Personnel Related Services ... .... .. , , ...... , . '....... 45 Payments to City ......... ..... . :............ . ......... 46 Debt Service Principal & Interest . , .... ... • . .......... , .. .47 ,. Internal City Services ......................:.... ..... , 48 Taxes & Insurance ................. '. , ............ ..., ... 49 Capital Improvement, Renewals & Replacements , ......... ....:.. 50 , Advertising & Promotion ....... ` . ' ........ . ........ . . ..... 51 NET BUDGET & NET INCOME , t Accounting Treatment ....... .... ...::............ ' ' 52 (Cash Basis) .:.......... . . . . , ..... ..... Net Budget 53 Net Income (Accrual Basis) ... .......................... . . 54' ACTION ITEMS ' Action Items .............. ..... • ... .. , ; ...... 55 f • f q s.a ai. , E •f ?f r I ? • Service Area in Square Miles 135 North Pinellas Co. only Population 410,000 Per PEDC Data Dwelling Units 188,000 @ 2.18 Occupants/Dwelling Customers - Total NG+LP 11,677 June 1993 Billigs Residential Firm NG 9,588 " Commercial Firm NG 11944 " Interruptible NG 12 rr Liquid Propane NG 83 "(71 res/12 com) of Dwelling Units Using CGS Gas 5.1% June, 1993 Billing Month Males of Natural Gas Main 472.15 June 30, 1993 Actual.., Natural Gas Customers/Mile of Main 24.7 June 30, 1993 Actual; of Residential Firm Customers: With Water Heating 75% Estimated. With Gas Cooking. 40% " With Gas Heating 30* " ' Annual Heating Degree Days 532 10 Yr. avg. NOAA Data @ Tampa Annual Cooling Degree Days 31613 rr Peak Contract Demand (MMBtu/Day) 10,219 November 1992 - April 1993 All Time Peak'Load (MMBtu/Day) 10,661 January 21, 1985 Actual Annual Peak Load.(MMBtu/Day) 8,885 FY 91/92 (January 16, 1992) " 7,834 FY 92/93 (February 19, 1993) • Annual Gas Sales (Therms) -15,117,789. FY 91/92 Actual Annual Load Factor vs. Peak 46.5% FY 91/92 Actual Annual Load Factor vs. Contract 53.9% FY 91/92 Actual Average Monthly Load Factor 79.6% FY 91/92 Actual Avg. Single Family'Home Consumption 273 FY 91/92 Actual ' (Therms) ' Annual Gas Revenues $11.34M FY 91/92 Actual Employees (Full-time Equivalent) 67.7 FY 92/93 Budget Authorized Customers Served/Employee 172.5 June 1993 Billings' ti .a ?yf a 1 1 I OVERVIEW OF . CLEARWATER GAS SYSTEM (A DIVISION OF THE CITY OF CLEARWATER) KEY SERVICE I . . . . . TARPQN • ' •:Q • . ?PR1Ha . r PALM ; • HARBOR •o • ': : : 'EJlST'LAXE PA. • ??•• ti0LD5AWi . ?bo • DUIJEDIN';.;'. SAY g .. ,. }IAFteDa• :To j ' B?LLF?VR' •Cl EAF . . BE CH TAMPA 9AY. . INDIAIJ BAH IMGO.', , WALSING1iM/UU1WMN, ROAD -CGS CURRENT SERVICE AREA- POTENTIAL EXPANSION :?rt?us;:' :•, AREA ....: ,cour{rr;: COUNTY: PEOPLES CLEARWATER N1 0 0 GASH COU PINELLAS PEOPLES C0UHrY cAS i / -TAMPA BAY/SUNCOAST AREA- CHARACTERISTICS & DATA NATURAL do PROPANE GAS SERVICE GAS APPLIANCE SALES & SERVICE INSTALLATION OF CUSTOMER GAS PIPING DOMESTIC AND COMMERCIAL GAS EQUIPMENT SERVICE -- 135 SQUARE MILES OF SERVICE TERRITORY - 472 MILES OF MAIN PIPELINES - SERVE 11 MUNICIPAL AREAS: BELLEAIR INDIAN ROCKS BEACH BE;LLEAIR BEACH LARGO BE UZAIR BLUFFS OLDSMAR BELLFAIR SHORES SAFETY HARBOR CLEARWATER TARPON SPRINGS DUNEDIN AND UNINCORPORATED NORTH PINELLAS COUNTY: CRYSTAL BEACH HIGHPOINT EAST LAKE OZONA HARBOR BLUFFS PALM HARBOR HARBOR HEELS TOP OF THE WORLD 12,000 CUSTOMERS $ 12.5 MILLION ANNUAL GAS REVENUES 10,661 MMBTU/DAY PEAK DEMAND (1/21/85) 10,219 MMBTU/DAY PEAK CONTRACT (FGT) SUPPLIER: FLORIDA GAS TRANSMISSION 'TAMPA BAY/ SUNCOAST AREA - FLORIDA=- I , '.0 ?. a? a •-1 00(z 00 C15 W. Minna CZ W. u) ? it r... ...... Minna W ? CO ui 10 r ?r_ N D CO a Nor L }4t i r ^ . i' ?' i S V r 06 S , J a? ' It Y cn r, cn C? r i A r .5 i i 1 i i P 1 i 0 L 1 Cn " J C J CF) -? W N 0) L- Cn in G) LJ- Z C1) W 00 00 00 A D W 1-- U W O J Q F- U Q I? V X w 0 Fcr) E J - CD ra U LL. J f i z w 0 i U) w ?o LO 0 a-, 0 0 ?- , CD , w co U N C/) C N O r O O O O O O. O O O O O O O O O O O O O . o O O c? c O 0 .0 O C4 I t N O co co d' N O r r r-• r- O W F - G W O It - J Q U Q 4 W Q l V? Q? as LL Q i i r^? 1 32 i .wimnvl 0 0 0 O C7 O O C? N O' 1 CY) ? C . W L- Cl) N LL N t O? O O O O ?- O D W U W O a 0 J Q H U Q 5 U m- . W S 0 Z rzzFF `fyy„ iY 0? r V C 1 C ;[ s , W C J LY] CL kf K r t t ° a Hij: MI: .. NM ` M r M Mi: "MM CM: :NMMIHM w' N L T HiM, U O rn a? ao 0) co co a Lo O LO ?./ LO Q co If- L a w U w 3 O cr CL El Q D C) Q i? w O c? ?a U? ?U ?a 0 L / co a . O 0) V/ m? co 0 N = 0) W N 0) '- ca 0 cu T . cn 0) 0) Q co 0) co 87 co 0 O O 0 0 O 0 0 Q 0 0 0 co (D r ,. a 'r:.,,.•._,, a% r•) dA dP CIP dQ cw 0 OP de aw 0 e 0 44 Is 0 0 P'1 m H T-4 cr N O co co w Ln H O I 0 a 0 c4 N N N r-1 rl 1-4 O o O U; aP E4 M N V-1. O O et' N H co 'd' 0% In Cf n %0 1n w in Ln N N m ci N u 10 q:r %0 Ln n O n kD . 0 m m q co co n Ln n co co a% co o0 o n ed i-4 4) n? w, _ N N er N ' r'' co 00 in 11+ Q T5 W P C1 N N N r-i ri rl ?O to 41 . ? yr od 1n to m r-1 O co in n 0) co . . . . . . .. . . . . b m ? o ui n o P'I la ? Ol c"7 ,•? al a .0 is o th W Kr n co 10 O N H 0 0 H' to to V' d' C1 N N N H r-1 r-i O M Q1 a) al a1 N Q) N al a! CQ r •1 r•I H H r-i r•1 r-1, P•1 r-I r•1 a A A A A A , A A A A w W ••i •ri -f-1 •ri 11 •H •ri •r1 •r1 •PI to 4J -P v a0 a a a a a .0d P4 P4 P P411 H `W -W 0 0 0 z p O 0 0 0 :3 W W 0 b N N I•i f•1 •ri w k 3-1 P 14 0 H D m P w k ?-1 W 3.1 I.1 1.i P , N, ra V m O t a) al O 41 J I a) J m m I~ N P 4) •r1 0 W .'a >' E. ? W V -P 0 V O - O 4 9 4 ~ -P O •V 0 la • •I • ? - ~ b E 1 r . 1 In x E 4' H H H 1-1 H. H H H W rX4 H H N , C7 = 1 I 1 I I I I I ( I I %0 ? + ? r•i N r•I r•1 N ? r-1 r-1 N .-1 a ? ? Tq + 94 EA P z p 4 E-4 U) l 0 U) tn 4) to u 4? r4 • O M }-1 4-1 O W v x k U x M i>a W rti O H O :3 4 (d '?•e o b W a N Z r^1 4 44, 4-) N m 10, H rd • y w ° a c ? w • ? ' a a N 10 41 f•'1 V H id H m O Id 4 O O 10 ri m a x a cn x x u Ia Q m a a? , ? x b ta m • a C ( r a 4 H m N . 4 • U1 0 $4 ? a 0 ''O rd p fd 04 U] r-1 ra r•i 4) b r• r-1 m J%4 V3 L) O El H 1~ N W 4J X O G O 14 O . id H •r1 rd 1 x 'O 44 x 0 43 44 H 4J 0 ul O H m O k 4-) al M r•I 'r7 •ri (d w 41 ra N 11) 1-I >4 P4 Id v 4-1 41 0 u (1) co ad al 41 4-) rd (L) O O H r-1 a) • ,L' r -l 0 x u a in u x E1 - ' a r'i N ri ? to to 1 oo ai ? ! ?i 31 • R% . * x.. • 1 -' , 25, . i CD CD U) cz 0 CD c cz w s ?• Y 1 i C\l O V V NI : CID N L O CU N as U TT / '. ' L T O mmj T O T V/ 00 0) o O O O O O O O N 0 O O 0 191- ' 0 - N 'd CD 0 0 T T T D W H- V. W O El' J Q U Q r? I r, r iCO CO 1 U) CCJ C1 L i W T UJ n O . Q in; Ct) un nm 11 t; XN z:; H; ? T3 w FNI: L N «S N . T ;ntz C] MIRI a a a a o a a /?? 0 0 0 o Y• a ?/? N a Od (Q d' N ? r w U w ?O J Q h- U' Q 10 U) U 0 i f >- U w D (i) 0 i z Y ? J?J LJJ Vh W CD 35 i i 1 ? U) w C) w 0 U) D (D I A6 ? ac ?f-"s (v V) Q) .Ir c W W W w A Z 0 co ? rV a a) N CL T 0 U- n ? r A O z ll. 0 O 11 U Z W J Q E a w 0 ?U U + f r? r .? Q. i L W G ? w Q co w E u_ ..?, o •M c w m N Z Z ? J 0 w Z 12 i D 0 O r O O T- r- 0 s F W W ?r CO 00 C6 6 ? v 4 1 W 3 Cf) 7 t Z w? 1 t i I } 0 CE5 Lf) a) W CES Z? (0 1.n d} Ca LO U) N W VI •? < O / U) LL O I III O-OR Q I f? V / E ? v (v U6 (D ti.I J N W Q U) Cn v """` cu 0 / CD ON r 13 F W H C t ? O O a W U co p J Q 'r c LL Y o W N• aCl) U . W • J Q { a co E cii _0 0 L , 1 Ir W •r m 0 cn a? o a L Q .0 2 00 as i ma cn ?lx C? a .. o ` as J r p o 0 0, _ cr) m o Q O Cu Cl) (D i U) C pj 0 0 cn a o a? ?, N o v - Co C*) CL N o ~ O c n CL ? 4 - I 1 es , O LO 10 r ? p l > cz co -?. .boom" Ll f co i 4-0 p .. cu. CT 'r 15 V f 1 `s 1 t r; 'r s a :q uj I• L Y LU fi c/o F 3 C/) 1 f I f 0 CD V 0 :lit OT: t: co D co Nit i? N ? . Z3 W N L MiM. T N nm ti rV co co 0 O O 0 0 0 0 0 0 O V im/ 1"*-- ? H ,/ to ' * 0 N W W 3 0 ^t CL J 16 1 .4 3 ?I i i 5 E O a l? i °o O a? Co Hit; Z:; is is ij:c I is; C\j still sgi!i: r Q) O pc? O is., list: O 00 O Co 00 0 Ca ?O ?t C N O O ? II W H U W, O J Q U Q 17 J ? au Lij ? cn a ? F i r cz C? a w i ( LL, 0 W c) t t i ? S s i d' JHH -M N /r T T T 11 HMI! N:M: 0 T Ct) In d' C'7 N r C? O W f-- U W O J Q H U Q 2 Ma W N r? U 18 z O U. co 0 co w Ljj 7 m E U a U) OC W w fr C/) ? IU }. U) I Nd- CIO N ? W N T as T N LL l gi l! rV ------- - --------- O C,? lw/ 0 4 Q O L6 6 V- O ?O co e D W H U W O J Q D I-- U Q BREHM 19 1 ' i A W o° LUC: CD E w o? 7 co C cz a E 0' a v) C/) o LO ? ?--? . 0 ° CZ cz c? ) ? a ' CJ cD E Z C: CU CU 0 E CD " F C? cm C lt? UL. 0, 0 c? CD c: < C: c? III / R 11? ` . OI?I^R\.1 CD cz T3 CD CD 0 M 0 CO CD W CCU r C', Z It 0 a C: 0 20 w >PON 0 C\1 00 <a) oco R W 3 W ? J Q Z Z Q N co - cwv a 0 0 0 LO LO U) LO ' ' yr T" ? ` co (D 12 r it ? a e m 4 _ ( a e is. 2 N R. * Q mi; 11i H-H .1H R D O lllii.L is. j. H.H i.im ¢ N slarsiz: Pill- m ° ,r- ZM; H?flilli a Hfiii. L O is 1. a LC . a !'Kill RHiHHNHls* N Lo C6 ?s I.' NI i fl, is Nil is ' ¢ '? I1 sit ill; o Cl) 1. 51 iiii: is { Q. a r W ffill. I. Hill C N His, i f .1 is I Q ] Q w: M:i:t (D C C\j CD - _ co j O f I '_ 0) r- 21 •k (D?0?N?000000 Q I TNT to ` CO Q W I inN C4 Go U; ooaaa q 0 T t U) M r- N +- co ' ?gt (DNr NM CO 0000 N CO C!7 ti O in m ` W I • T T T LO w I a11- coco Nmt a0 ' oCOLOCOCON 3g? 0,r * ? I I W Q ? '- :W cc 3., I `noaoo °rnrn? °? N N I a c O *.' U) ?m w I Ll0 N 00 LCi C7 z z a mo r- co MT N w, v rn co 0 tm ?enoooao rNa ?. )ir-mO J I ,? ' J ?• i 0 , t,J. ? ? r J • 41 41 ' ' rJ J ?o a`• E. . ' I E E 5 00 to- mm r oc km :3 o - - e ??11. , ,Qua H. 3 22 .. Nti, ' L.. 5yJ Y. .J ? ," W 1?OR w(9) etNCr1 Q1rr tt ter CO) N 1 WQ I N.tr to i oiC6(d co NN 10 mo i c; o? I t I 1 a° j I ' 1 ' I 1 1 , . W •r O0 --0) 00 h to 1nr%O ?,N0 ? r hW co N On N U . et of ci i i oeta 0 0 h. O ti vi ti W i ZZ ! 0a I r r T , I I to Lr) 0N N N C+?fD000 O O n 0, I (ND 00 CCD 7f co CD 1 !-- I et D "" v- n0 M II?G(] 000 I r 00 h O O I NU I x-040 Itt,0 7000 - h CA N h 03 CD co I Lf1 O CD N et N I ?a 1 r r O C71 C+J?c?3CD l(1NO COO) I et N N 1 01 #" 1 cn rrrrrrr I r r ,- W 0 I I 1 I n NCf r?0 (D,t"SCD Nor I C') coo (D r ti I W f 6 6 6 6 O N t` 6 C r: L6 ,= I O r N 4 N (D U I 1[ I I I I I I I 1 ?, I 0= tnotnOC(nOLnootnul f o u1 0 I I 00CO CO r:(D(D (O r-CO C I C; (d ' N0• ; J T o M c . I U. Q I 1 T o f-- I 1 I I 00000000bOC] 0 10 01- O 0 I v] I 000 70[000)000 I o Oy, O .O O1 1 '? I 0 0 0 0 0 0 0 0 0 0 0 0 O 1 O n O 0' 00000000000o 0 O o 0 1 OCC 1 ' o0NmtW 0 gtNrONN 1 40'1 le N N 1 o1 a 1 TTrrrTrrr 1 O W Q1 T I E r r k, I W I Lq 47 tQ 03 Ln (D n -f; o t, Ln Co , 'CO N N W CO .. I Vr I 0 n0(D N 4h600 - 6 I r 00(6 of O N I u-,Z I ( Tr N NrrT I r r T T E O ¢' we, V I I O co ¢¢ t M O Y•' et co (D ? ' r I O N co O CD r (D T O0 h to N 1 (D co C) m co 4'1 1 N I r O0 r CD co a) CD tt 0 C7 C9 I r D) h co N I I T h(DOCDOCC1r4}0 ao 4'1 O O et CA (D 1A O 0 T t (D n Co U7 M 4} 0 1 r t OO O co (!'1 CD 0 r O O 00 0) t rY 4) o d ' I ( T T r T r T T r E 0 (l1 rn T T r I W I N7 4?(D(DNLQC4C, l11 co Or (n O (D I C?.I WaNCf)nCD0 qt 0C m1.4, *' I in NCO ui N N 4 1 t I t l l l I I I j 0 1 a U E I aa) I I I 0 co 00) w't e7 hrn N 0 o i I m d 0 to 01 . r M rCOT-WC4Cn IDr.(Dho T 0 I r I rh N to qt P. r* CO T- o N OD I 00 0 O O I I N' N I CO 0' ( r m 1 O I co MCDDnM0to mo co 0 N co co et N rn rn co co oo t rn u 1 rn ( D et 4] ' I I T T T r T T 1 N ? • d' co w . T I r I 0 W0 nNI,.gtMM01r -Cm0V-wM , W M ? r1 I 0 00 O N ? d W N 0 1 O I r 0vM"0N n NwC ? m0 r 1 0) 0 Ow N r h 1 I °' I c ? 0x700 CO04MNtirnNG 1 1 0 tom. CC*1 nZ I O I Q1 o 9t w N N N r 0) co Co 0 I qt N n h 0 0 _ _ I 00 E T T T T- T T T I M M co Z p I? w Go D) LL L) a. '- a. c D cq (D I f I Z g ?r N (L 0 ? LL w J? I I as I LlJ WO Co U a: W a: ?o I ?f aEE?(° ym Nc I I H ( Z I ".E > 7 y v A ?Q. F^ WLL W I-- h-Z Z F QN I. 0 I 0 . 1 % tsaalr 'nar?r D=Mw 1O QU ¢m U? N w z0 1 ? E 0zo-?L_ <CO o 23 •t r ;fit. .. • .. i Z i a v 1 Cf) r S 1.? ii { r , M (A .o H , ------------------ : r v? r CY) J C\l ? T a 0) Q (3) Cl) T ¦ CY) Q T CC T W W U- yy W Li T CL W W 0 ? E 0 _ co > M 00 0) T r ?, o w O O 0 0 0 O E - 0 r%_ 0 co r-- ?. ? _ _ w T T T T 0 ? 24 CSW: .6/30/93 ` CLEARWATER GAS SYST EM ANALYSIS OF CCF' & BUDGET- EFFECTS FROM WINTER OF PY 92 /93 'Current Year vs. Previous Year J Heating Degree Days last year - 562 Heating Degree.Days this year _ 4433 Difference -- (1l9) (21.2%) ; Multiply by HDD Factor X4,600 CCF Impact _ (547,400) (3.8%) Multiply by Price/CCF x:79 , Impact"on Revenues = ($430,000) ,Multiply by Margin Factor x.667 Impact on Net Income - ($290,•000) (16.7%) .Current Year vs. 10 Year Average Heating Degree Days'- 10'year avg. = 532 Heating Degree Days this year 443 Difference -- (89) (16.7%) ..Multiply by HDD'Factor x4'600 . CCF- Impact _ (4091400). (2', 8$) Multiply by Price/CCF. x.79 Impact on Revenues ($325,000) (2.8%) Multiply by Margin Factor x.667 Impact on Net income'' ($215,000) (12.4%) 25 ' , .. it t i i S .r x b 7 t 4 r?^ ? ? V I fi C/) L? Lli ? ` V 1 V I ? T T VI CF) `r v/ ? rn V / r TR V/ 00 a ° 0 0 00 o 00 0 00 0 0 0 0 0 0 /? Y /? 0 d= ni o Co cQ 'd" N 0 T_ T_ T_ VI r C\l O Q CC Q U F-- w 26 U i 't s' c 7 S ? fir/ K V t O O CF) ce) 0) 1 N tS? W T T N L) RR. M N N T 1 Cf) N 1 N 0 0 0 0 0 0 00 ' 1 00 0 0 ' 0 0 0 0 0 0 0 0 d' CV 0 w -W '1t N 0 T' ?- T" 00 !W F-- C3 N LLI >- 3 cr M :D IL z El J z Q rl.._. T V o ? w 0 W IL w 2 F-- J J 27 Q Cl) Z O J J E J ? 0 u)cU G w a cr) tt! d' 1 C\j N N r T C? Mina. fm ?t' Q LL tt: W CC) T LL a o. a o a a O 0 Ca CO L6 o 16 o E6 o u6 c; z C'7 0 N N r r a J 28 • r. CY) r L, . o c? LJJ cu LL" > ?o cz a LU Ii M !fir cl) 0 ..e 0 p (D cz, 4-a °' U) 0 E cz a L (D L a a J co LL. LL. c z as ....? a a v? a) a ' cn . r m m .? a :3 :3 W co C: 1: CD a) N C.. > Q) ? . 29 U. r ! 1 Lmu r, a f Cn 1 ?/ s 1 4 Lij v i j ui f i A $f /rte J } ?I j S, Z cr) :It vi "ifiT .. CO C\j fln T it.Mi Hi C) Tin co H?l 00 FM? Q ] co LV 0 Co . (D ,° N a T r D w N O Z H CO z 0 CO 0 IL Z D I w Ill D LL L. 0 cc: w co 30 z w w O w ? E w v 4-0 T 0 N U' N UJ 3 CD U ui0, G C/) U f° N L6 0 0 0) M 0) T T CF) 0 1 cr) Co W 0 W t? w 0 IL ElrI,-•- V 31 0 0 0 0 0 LO 0 LO D w U Q J OL W H W 9 ? r ? ? W i m Z r-o-e, °o 75 ac c? O x O LU Z W LL1 2i z O CV) O CF) CY) CIO cli r r O O cr) O O 00 r D W H U W O IL J H E M A - 1 Q 0. O O O O O O O O O LO O L N .r-. T-- vi 0 0 L L (Ts 32 V i 1 'J ? J ? Q 4 3 7 o o Lu? A 0 Qa. W it w w CC w w d w z LL ° 0 :D ui t 0 z 0 0 co CD U 0 0) m? c I N ;N Mmn t. MM: H r T w a rn lt:ml /? OD M/ T 0 O C.a. Q + Y w U w 0 aC CL El Q U Q .°' i .,a N V L .;-.6 to co 33 0 o (1) Lo E 1 1 e f (D e ' 1 I +-4 0 ?r Y ? ? e e U) IBM.: w e > r L CC jr I ' ?- C: 10 0) °' 'co co Co. 34 '1 r z i w y? II ? 5 c ?' W CO z 4-J W M W c? 'A t Z k ,Y 1 } 0) 1 r r--4 • r--1 1 ° Cis ct cn •0 N U ca ? c? r? ?I CCS ?! bo 00 T Cl) N as 9 4- O ,O 0 L 35 (] ¦,,... j G a N .....? T- ti. ? ti ?} o 0 V O N >1 N 4 co ?. LL . a) a) N o a3i o ? oc co co E a) (? N a) U) N T- Cw a 0 - C Cf) N Z a w (D f CD _ a Ecr) LO (ts Cv Q, 0 0 N d- o ? o -M ?- 0) M C J (0 " o .? a) N N M 3G s ¦k Cn W E Z N W cn' W 0 J 3 Q `° U O O 0 o. b- rn CY) rn 1 t... Ill! HIM "U. MNIM ,-_ wwu O HIHNH, MT 11iiffl-M, m. MM P OD co O LO o LO `/ LO Q CO. C1! N Y- T D W F- U w O J Q F_ C) Q CO z 0 J 2 z CI) Lr 0 37 J -01 0 Q O T?T VJ CY) € ? ] " k i Y i ) ( ' C \j l E U) N 0) . s T O i Mul T { a? s c t ° ao co 00 CA f ? ? a o o O a O o 0 o a o 0 t CM -- f? D W H U W O d J Q H U Q U) z C] J J_ . z J 38 . >_ ? 41 1 1 5 1 v CD cn >' co a) 4 ? 1V "'r U 3 1 O O O C\1 lit Mill :MH V/ CY) .. Mi ml. it: r Hl !Ili"' lift Nit '?. CY) CD lit O O O O O O O O O O 00 . ? (C) LO d' CO N T- O O' 0 0 0 0 0 0 0 0 w U 3 O rr CL F-1 J U Q CO Z O J J 2 Z U) J O 39 [] 0'.. W E W i ? vI t r? i ^ «) W? W? { E s, . F 0 0 tiE CD 1 HH. T TT Vi tRIll 1; ; Ill a a? liz:l aD. Y/ CW ..1 CC) C? LO mot- Cr} N T O 0 o . a o 0 0 W H U w O a J Q U Q CO z 0 J J_ z C f) Ir J 0 40 0 II i 1 U3 r. F7 > Cl) ? W L t a \V :i V .t J r 1 } E Q Y 00 CY) CD C\j rn as r e T?T LJ W \+\./ co /^ W C') LO C\1 LO ,-- LO Q O C\! 0 r C? C? Q O 0 D W H U w O J Q H U a Cl) z 0 S C/) 41 0 0 Va U z o J CO a Q 06 L6 J w D LL 0 CV j CD z O m U) W J X W _ W c V W (D < co C/) N J' WCj+1n?a ? W(D CL "t z cm O -- ? .J o O C; .Z 00 w w Q I- E<- z ? O ' O o .0 z 0 O N CC r °) ) [ _ i- T- p6 0 [' W o w L ? U) z O J J z OC O 42 ' uj 0 m J H E Ucn 0 Z 3 ? a Q U ui CL 0 J Q F- I . 3 O O L V) ? U U- T C) LO 0, LO 0 LO Cit . CV ,r-- 7 - 1 D W. F- U w O a U Q Cf) z O. . J z CO J J . O ? 43, i CA W U Q J ? E IMMill OZ5 W LL ? ? U ip,m n 0 0 0) 0) CY) CY) N U EL. N d?7 HiM .. o a? E r ? , o Qa co mot" cv 0 5 b ' 1 .a I r D ? w t-- U W 0 a J Q H U Q CO ,z. 0 z , o 44 tj 5 yy? •i Cf) d ' ca, ro ? W r, w • J O O 'Tr 0) CT) 0} CY) C\j CY) C l) LL N C? C37 D W H U w O Q F-- U Q z O J I Cf) J 0 45 ? • E' 4 J F 1 1 fi • f? W W? r i. • r r m? ) 0) W V! C\j {..L N 0) ¦ . z r J J o? J . 46 r 0 w F - C) W i ? O a J Q U ui i r ' LLJ o le, + z ` V cr) ' 'I •R 0 CL LLJ ct$ ' U crm O 1 cf) CY) ? -co CO U CZi NI. -.I. ,I. IHIHIII l5il LIE C? IC) N to w CV r O t.l.I F- V 7) O cr CL J Q i ? Q CO z Q z U) J • a, 47 C) r , t EyF ? , i L Q? Fmm Ns } f• 0 L? 0 ? U cn LL N 0) a C? C11 LO ?- LO O ? CD- 0) D W H U w O a J Q U Q ¦ J J .Z . J 48 ? E 0 co t L i ?? tJ r ii A , I, i t 7 i ?S O 0 C) CY3 0) co (3) _ N 0 U CO LL N Ir- CY) O O D W F- U w O CL E- U Q Z Q _J U) cc 0 49 () (D qql- \ V 0 O Q {t CIS i z w 2 !.l.1 U J CL w cc 06 Cf) .J E Q? N CO W cn z W - Z U w C w 0 cr CL J 0 0 0) a? CY) 0) O w H U w O J ElE- Q U i Q CV) >T C)) . iz C\l CY) .-- 0 50 CD _z z 0 m z J C) X W CO z 0 J Z J k? 11 N LO r- LO ,-- C7 i i 1 i 3 L F 7 s a t? v } C J? V 06 ? to I.z 1 Y I? 5 1 t O a let z CO G) CF) C\j O C\l O 1 T T G ?0 LJ LO C\j LO LO O CV T T O O O C; O O 51 A? ¦ww? O CL cu 4-. S , 63 4-? +--? 4.4 Cd C003 4--b CO En con 03 a> 73 LU 03 a ..co .'" •• n LU 4-4 rn ?' aJ_ U_ 43 .?..? Q 4a r? 's -?r CD CD = CAD CIC3 C C.? o C 1?11 C) CL> .11 9 4--b S-4 va b •--1 F? 1 w va co con CO v CD 03 W2 p v -" C:) o 4 ,0 a 03 IU rgc?:3 52 t 'S :y 4 i 3 r ?• V L i J (w Lam/ i; ? L cz •? rid, a t ? W S Cpryp k t O' O O O CY) N r °O CF) O ('rM) G. H W Z LLI rV U) w D z w W M M cli C\f r-- 53 I S? i 3 i U) x { i' 1 i 9 1 t$ 00 i f qR S z e : 7 i i 1 t W r; Y 54 :I' tI: 1 ............ :ii ii. i iii.i' iii. .iii ii. i ii ;}ii . •?i Ei. iii i.i l iiiiia: .ii i? : ' : t. 1. i• .1.. ::i. ii.. ii .li .i.... i ;'ii 1. :.i •I: .'.ii ili 'iii i. ii:t.. :i.: i. .M ':. '. i'i :3. .I: i..i.i ....... .'1: il: '. i'.::•'::::::::::::::•............. .ii ii..................... i ii .... i i. iii iiiiii iii:.ii..iii...!.i...iii.ii.i•,y,;;I:1EE.iiii:::ii::::;:iii;.iiiiiiiiiiii i...... iii iii iii '_• ;ii iii iFi. i:. ... :i. i iii ..... ... ....:.y :.... ................... t. ii. iii ii:i i. ..i ........ .i......i. :ii.i r'iiiii i:.i i i.. ..ii i'r.. ;ii Q ce) 0) C\j V/ N V/ T z Q, X W Cl) CD W T CY) CY) 0 0 O © 0 0 Q 6 L6 6 L6 c; L6 'c:5 (Y) Cv CV r T r 4 I 1 I f' r 1 I r CLEARWATER GAS SYSTEM KEY ACTION ITEMS FOR SMTEGIC PLAN IMPLEMENTATION ,1. FINANCIAL Initiate $12 million Net Bond Request with City's Financial Advisor and Bond Counsel. 2. Prepare RFP to select Independent Consultant for Bonds. 3. Finalize Rate Case 4. Retain 'a Commercial Realtor to assist with locating a Pinellas Sales Office and Appliance Showroom. POLITICAL 1. Retain Pasco legal ' counsel, to assist with development of interlocal and franchise agreements, 2.. Initiate discussion with Pasco County, New Port Richey and Port Richey re interlocal and/or franchise agreements. 3. Obtain a'Pasco natural gas specialty license. QQNSTRUCTION 1. Retain a Pasco Engineering Consultant to finalized our route, determine environmental impacts and obtain DOT'Permitting in Pasco County. 2. Prepare and solicit Construction Bids to maximize available workforce. 3. Prepare and solicit bids for pipe and related materials for Pasco work. 4. Retain a commercial realtor to assist in locating a Pasco operations center and business office. 5. Complete formal process for FGT Phase III Gate Station. 6. Negotiate supply opportunities with Sunshine Pipeline. 7. Determine best means to accomplish Radio/Telephone Field Communications for Pasco s 55 s `t ' r I I I County. VEHICLES 1. Place orders for required new vehicles and determine timing. :. HUMAN RF, MCES 1. Prepare position description for 9 new positions (including 4 Sales Representatives)' and strategy for locating personnel and timing. 2. Select the Director of Marketing & Planning position. 3. Select the 4 Sales Representatives and Sales Assistants., r . 4. Place orders for computer hardware and software to support personnel. hMA P PQSITIQNN EXISTING POSITIONS 1 Director & Marketing & Planning 5 Pipe Fitter Helpers 1- Gas Marketing Engineer 6 Utility Service Technicians 1 Pasco, Operations Manager • 1 Drafting Technician 1 Gas Training Specialist 1 Customer Service Representative 4 Gas Sales Representatives 1 Staff Assistant II Gas Sales Assistant 1 Staff Assistant III 9 Total New Positions 15 Total Existing Positions, I I 1 , 56 . F,