Getting Started with CUPSS A Workbook for Users ------- I 5 EPA 816-R-10-002 February 2010 Office of Water (4606M) epa.gov/safewater 11 ------- Contents Getting Started with CUPSS I Before you Begin I Step I -Why am I here? 3 Step 2 -What assets do I have? 5 Step 3 - What do I do every day? 9 Step 4 - Where is the money going? 12 Step 5 - What now? 15 Glossary 16 Printable Forms Inventory List (Drinking Water) 8 Inventory List (Wastewater) 9 New Task 10 Finances 13 ------- Getting Started with CUPSS This workbook is designed to give you five easy steps to get ready for using the Check Up Program for Small Systems (CUPSS) for drinking water and wastewater utilities—the new asset management software developed by the U.S. Environmental Protection Agency (EPA). By completing several pencil-and-paper exercises, you will have a head start on 'doing asset management' and adding your information into CUPSS. Let's get started! For step-by-step instructions on installing and using CUPSS, consult your User's Guide. Before you Begin Before you begin using this workbook, you might have a few questions about CUPSS. Maybe your state regulator or a technical assistance provider handed you this workbook and said, "Go for it!" In this section, we'll give you a little bit of information about the CUPSS software and how you might find it beneficial. We'll even tell you what asset management really means for your utility. The first thing you may ask is "What is CUPSS?" CUPSS is 'desktop software,' meaning it is a program that runs on your PC at no cost to the user. Because CUPSS is desktop software, all of your CUPSS data will be stored on your computer and is not accessible by EPA. You do not need an Internet connection to use CUPSS, just a computer to load the software. If you are connected, the program can use the Internet so that you can register your copy and update your version when necessary. If you have questions about technical specifications, consult your User's Kit. The User's Kit is a binder that contains everything you need to know about CUPSS. It includes the CUPSS Installation CD, helpful fact sheets like the Asset Management Best Practices Guide as well as the CUPSS User's Guide. CUPSS is asset management software; its purpose is to help you organize and develop a plan for the physical and financial health of your drinking water or wastewater utility. If you are effectively managing your assets, you should be able to successfully meet customers' expectations at an appropriate cost. Like other types of computer software, there are two key components—input (what goes in), and output (what comes out). CUPSS relies on a combination of specific information entered by the user and general information provided by EPA. The information entered by EPA has been inserted to provide additional assistance—such as the life expectancy of 6" mains—to provide simple, eye-opening reports. You only need to enter in a couple of important assets and last year's financial statement to generate a targeted action plan. You are likely most intrigued by what CUPSS can actually do for you. We think CUPSS will help you do these tasks: • Communicate with the decision makers in your community ------- • Make more informed, proactive choices • Improve the efficiency and focus of your operations • Maximize limited financial resources Like anything worth doing, integrating CUPSS and asset management into your utility's culture will take time and effort. These are certainly high goals, but we think taking the simple approach used in CUPSS will result in great strides forward for your community. Helpful Tip: Don't forget to check out http://www.epa.gov/cupss to register your copy of CUPSS, find training events near you and learn more about asset management. ------- Step 1 - Why am I here? Your discovery of CUPSS might have been by accident, on purpose or by recommendation. It might even have been a condition of a loan or grant agreement. Regardless of the how, it is time to think about the why. Ask yourself, "Why should I or anyone else use CUPSS? How can this program help me operate and manage my utility more efficiently?" These exercises will answer these and many other questions you might have. Also start thinking about who helps you manage your utility—whether it be with operations or financial records. Having your team in mind will help you with the exercises included in this workbook. Let's begin by identifying what you are doing well. We will start by listing three areas of your utility where you see yourself already succeeding. For example, if you have someone, perhaps a town clerk or someone else, who keeps your accounting records organized and up-to- date, this would be great to include below. Keeping these strengths in mind will help you leverage opportunities for making changes as needed. I. 2. 3. Helpful Tip: A map will help your utility understand the current service capacity. Use Internet-based mapping tools (try Google Maps or Google Earth) to visually designate the boundary of your utility's service area and important features. You can also do this by hand using a regular or topographic map! ------- Now, think about and list three areas in your management strategy that could be improved to facilitate your customer service interactions and relationships. For example, having a comprehensive list of aging fire hydrants that need to be rehabilitated or repaired is beneficial to the safety of a community. 2. 3. CUPSS will help improve these areas! CUPSS also provides additional information addressing other potential areas of improvement. These areas can be as simple as improving customer relations or as detailed as developing a long-term maintenance strategy. What would you like to improve and how would you do it? Select one of the areas you just listed, create a target goal and date. What is your first step toward reaching your goal? Think about it and write it below. Here is an example: You have an issue area of "leak or break response time" Your current response time is 24 hours. Specific Goal: Reduce the leak or break response time by 50% Goal Date: One year First Step: Convene a meeting of all utility staff to discuss why the response time is currently 24 hours Area Selected # Specific Goal: Goal Date: First Step: Goal and milestone tracking is crucial in asset management applications. CUPSS will allow you to establish and keep track of both while conducting normal activities and following your established maintenance plan. For now, just keep thinking about these important issues. When you start using the software, it will automatically prompt you to formally begin the goal-setting process. Helpful Tip: Get a head start on data entry by getting your files organized! ------- Step 2 - What assets do I have? Now that you have figured out where you are and why you are here, let's examine your utility's assets. We will use a drinking water chlorination system as an example. How much do you know about the chlorination system? Can you answer the following questions about this chlorination system? Do you know how your responses make the difference between having safe, disinfected water and potentially health-hazardous water? • When was it installed? • How much did it cost? • When was the last major repair? • What maintenance will you perform on it this year? • What and when are the typical routine maintenance actions performed? • When are the major components scheduled to be replaced? • Will you be financially prepared to replace a major component if it fails? If you knew the answers to all these, you are already on the fast track to success. It is more likely, however, that you knew some of the answers and knew where or how to find the rest. CUPSS helps you identify your assets; allowing all of your important asset information to be stored in one place. While entering information about each of your assets is the most time-consuming part of CUPSS, it is not difficult. In fact, this workbook has been developed to make it an easier process. The inventory forms at the end of this workbook are similar to what you will see in CUPSS within the "My Inventory" section. You can make copies of it, attach it to a clipboard and start digging out those records. Taking baby steps—like planning 30 minutes every day to add one of the major assets in your system—will have you in great shape in no time. Once you have mastered this process, you can start using CUPSS to inventory and manage your assets. Just copy the information you collected on the forms and putting it into CUPSS. Because CUPSS contains dropdown features and help tools, you'll find it more efficient to use the software. But for now, let's focus on thinking about the most important assets you have. Helpful Tip: Start with what you know and don't worry about leaving blanks. You can always come back later! ------- Once you have a few assets documented, begin thinking about how you'll enter your assets in CUPSS! I st Start by entering the most important assets you have. Let's use a chlorination system (like the previous asset example). You'll type Chlorination System into the box beside Asset Name. 2nd Where is your chlorination system located? You'll type this information in the Location box on this form. 3rd What is the Asset Category for your chlorination system? Not sure what an Asset Category is? Any time you're not sure what to type in the form, click the red circle with a question mark, and help text appears to guide you along the way. Next Go through the rest of the boxes to enter all the information you have available about your chlorination system. Done! Do you want to add another asset to CUPSS? If so, click the "Save and Add Another Asset" button. If you want to wait to add more assets, click the "Save and Return Home" button. Whatever you decide, be sure to click one of these buttons! You want to save all the information you entered. Wasn't starting your inventory list easy? You'll be ready for CUPSS in no time! t Check Up Program for Small Systems Beauty View Acres Subdivision - DW | print B,ank Worksheet The asset inventory Form allows you to enter information about your assets, This information will then0 be used in several of the CUP55 reports and to generate your pi iwitized asset list. (*) Indicates required Reids Basic Inform * Asset Name * Location * Asiel Category ID Latitude Notes Storage Capacity Days Status and C f Condition jtion 0 Select Associated Asset v 0 0 Select Associated Location v 0 Add Select Category v 0 * Asset Type Select Asset Type v0 O Size 0 0 Longitude Q o 0 LFJ 0 Acres |0 edition - Required to Calculate Priority Select Condition Rating v 0 *CoF 5elect CoF Rating v 0 "Redundancy Select Redundancy V 0 Can this asset be repaired? Q yes 0 No 0 "Asset Status select Status v|0 Can this asset be rehabilitated? Q Ye-; No0 Select Asset Replaced * Capacity Select Asset Being Replace, v sho» asset in the schematic? Q Yes 0 No Select Capacity Rating v 0 Cost and Maintenance Date f Enpected Useful Life 0 Original Cost 0 |0 "Replacement Cost 0 Maintenan^Co™ Delect Frequei v 0 D Maintained According to Factory Recommendation 0 Create a task Manufacture Model Number Supplier Address City, State, Zip Phone, Fax and Supplier - Optional 0 Select Existing Supplier v 0 Manufacturer Select Existing Manufacturer v 0 | |select state II 1 mammmmimm ^^mm^^m Asset Risk Matrix j £• Inventoried Asset List Well#l pump well property - Pumping Facility Security Chlorinator - Treatment Chlorine testing - Storage Storage Tank - Distribution Water Production Meter Tank Distribution For specific details on "My Inventory," see Chapter 5 of the CUPSS User's Guide. ------- Step 3 - What do I do every day? Do you often feel like saying, "I barely remember what I did yesterday, let alone two years ago!" You are not alone! Recalling the service history of important parts of your utility is as critical as planning how you will get things done in the future. CUPSS allows you to do both. It is important to develop habits that make and keep record-keeping super easy. Reminder! For help with record-keeping procedures, see Record Keeping Rules: A Quick Reference Guide. September 2006, EPA 8I6-F-06-033. Let's practice developing a service record to see how easy it can be. When maintaining a service record, you must begin by entering in all necessary information into the task list shown at the end of this workbook. Use it over the next few days to plan and track both routine and unexpected maintenance tasks. You can print this form from the "My Inventory" section. Don't forget that you'll be entering your information into CUPSS when you're done! Pretty soon, you'll be using CUPSS without relying on these paper versions. But for now, let's get started with tracking the tasks you can think of right now. Helpful Tip: Institutional knowledge is valuable! If you already keep service records, it is well worth spending time each week entering them into CUPSS! Remember the bigger picture!! We understand that operating a water or wastewater utility is a tough job that requires a lot of brain power. To get ahead of the curve, it helps to plan. What preventive actions do you routinely take? Write down three important tasks you complete routinely, say, every quarter. 2. 3. Are these written down anywhere else? Is there a record of these tasks? How do you ensure that they are completed? The next form looks very similar to CUPSS. Begin filling it out, starting with the three tasks above. ------- You can take these tasks that you've listed on the last form and enter them into your CUPSS tasks list. Just select "Add a Task" in the "My O&M" section. Enter the Task Name and specific details about the task For an asset-specific task, such as pressure testing your pipes, you can pick from one of the assets you've already entered into CUPSS or you can enter a new asset. It's best to put as much information as you can into the system because it saves it for you. Now your tasks are in your CUPSS calendar! CUPSS recommends many preventive maintenance tasks and allows you to enter your own, all on this central calendar. This screen allows you to schedule one-time and recurring tasks within the 0&M section. J (*) Required Fields rTask (*) Required If Recurrence Exists Asset Information - Asset Associated Tasks Only Select Existing Asset Select Existing Asset Asset Category Select Asset Category * Task Start Length of Task Completion Date Staff Completed Frequency * Recurrence End Date * Select Recurrence Every ll Every |l Day fl | The Selec | 09/11/2009 v 0 Pop-u p Reminder ^jf 1 t day(s) O Empty v| Time |l2:OOPM | Q Select Staff Select Frequency Empty v 0 o & day(s) [ 1 I times/day week(s) on Select Day of every 1 mo Select Day every 1 Every Select Month 1 The Sele< | Select Day of Se nth(s) rnonth(s) ect Month 10 ------- r Optional Parts Information Manufacturer/Supplier OR Parts Name Parts Number Parts Cost Labor Malnt Cost Select Manufacturer Supplier V o Add new Manufacturer / Supplier 0.00 * 0.00 J Add 0 0 0 o For specific details on "My O&M," see Chapter 6 of the CUPSS User's Guide. 11 ------- Step 4 - Where is the money going? As you've been learning, CUPSS is intended to make your job easier. Financial decisions are one of the most important and most difficult aspects of managing a utility. Do you know what you will need to spend in the next 5 years? CUPSS will help. However, before CUPSS can give you indicators of your future financial health, it needs some information from you. Use the next form to summarize last year's financial statement or this year's budget. You can use the revenue and expense categories listed or add your own. Helpful Tip: Customer rates and service related fees should recover the full cost of service, offset by any grants the system receives for capital improvements. Using "My Finances" keeps track of all your budgeted and actual revenues and expenses that you expect to occur this year. It also keeps track of what your revenues and expenses were for past years. You'll even be able to graphically display how your finances change each year by simply clicking the "Graph It" button at the top right of this section. In addition, you'll be able to see your actual expenses and revenues in relation to your current interest rate—without having to figure out any tough calculations. This is a simple, yet crucial, preparation step for understanding how to recover the full cost of doing business. Coupled with several completed asset records, you will be well on your way to harnessing the full powers of CUPSS and long-term success of your utility. 12 ------- Check Up Program for Small Systems Set-upiSwitchUlilil»iCreate{lseriHe|piTraininaiE*'« -^ "'7 ! Home Check Up Beauty View Acres Subdivision - DW Finances J Export Data | Print Blank Worksheet The My Finances section allows you to enter expense and revenue information in multiple common categories, Q (*) Indicates required Fields General Year Information Select Previous Year Select a year v Or' Enter a new year Select a year V Impart Data Fran Enter total cash-on-hand and interest rate Graph It Year Expenses and Revenue * Type of Cost O Select a type of cost f Budgeted Amount O Actual Amount ~i*r Inflation and Select Type of Coil Select a type of cost Expense Budgeted Actual Inflation Rate I Revenue Budgeted Actual Inflation Rate Total Enpenses: Total Revenues: Save and Add Another Year For specific details on "My Finances," see Chapter 7 of the CUPSS User's Guide. 13 ------- Step 5 - What now? It is likely that you needed to do some searching for the information we requested in this workbook. Maybe you needed to ask others for help or sell your decision makers on the process. Before you open the User's Kit, take a few moments to list potential members of your CUPSS Team. Most members of your team will not use CUPSS on a day- to-day basis but will need to be kept informed of your progress. You might not have the ultimate authority to make decisions, especially financial ones. Anyone who does should be a member of your team. List names and phone numbers of three key team members you would like to recruit. Bonus points for already bringing them on board! Helpful Tip: Don't forget to include any administrative personnel as team members. If you are lucky to have these professionals in your water utility, you've got a leg up on many others! 2. 3. For more information on creating your asset management team, see Building an Asset Management Team Factsheet. December 2007, EPA 8I6-F-07-OI3. To gain decision makers' interest in being a part of your asset management team, set up a meeting to view the CUPSS and Us presentation available in the User's Kit. For more information on asset management and CUPSS, see http://www.epa.gov/cupss Your CUPSS User's Guide, the CUPSS Training Module, and any in-person training will complement this workbook and provide additional tips and tricks. However, completing the five easy steps in this workbook should give you the confidence to add CUPSS to your utility's 'best practices.' Ready? et! Go! 14 ------- Glossary Term Annual Debt Payment Annual Operating Expenses Asset Asset Category Asset Inventory Asset Management Asset Name Asset Status Asset Type Associated Asset Associated Location Capital Improvement (Expense) Capital Improvement Program (CIP) Plan Capital Reserve Definition The dollar amount that must be paid each year toward retiring existing debt. Total annual cost of operating and maintaining the water or wastewater utility service. This does not include savings or future draws from capital savings accounts. A component of a facility with an independent physical and functional identity and age (e.g. pump, motor, sedimentation tank, main). Where the asset best fits within your system (e.g., source water, distribution or collection), for organizational purposes. A list of assets with details about each one (installation date, original cost, condition, and such). Also known as an asset register. A process for maintaining a desired level of customer service at the best appropriate cost. The name of the technology or equipment that is used for your system to properly function (for example, "5th Street Pumping Station"). See Asset. This is how your utilities view an asset. Assets can be active (most assets), not in use or a future investment. You would designate an asset a "future investment" if you would like it added to your capital improvement plan. The asset's functional purpose for a specific asset category (for example, intake structure, pumping station, transmission main, storage tank, and the like). Assets that are directly related to a primary asset's function. A location that complements an associated asset. Funds required for the future purchase, repair and/or alteration to or for an asset, structure, or major pieces of equipment. A plan that projects and assesses which projects (including asset improvements, repairs, replacements, and such) need to be completed in the future. Funds set aside to fund capital improvements (i.e. future 15 ------- Term Contribution Cash on Hand Condition Consequence of Failure Debt Payment Debt Ratio Emergency Reserve Contribution Expected Useful Life Expense Expense Ratio Financial Assets Growth Inflation Definition purchase, repair and/or alteration to or for an asset, structure, or major pieces of equipment). The amount of cash that is available to the system within a 24 hour period. The current condition, in your opinion, of an asset based on age and physical functionality (ranging from poor to excellent). The real or hypothetical results associated with the failure of an asset. The dollar amount that must be paid each year toward paying down or retiring existing debt. Debt Ratio =Total Liabilities / Total Assets The debt ratio measures the amount of debt being used by the organization. A ratio of 0.6 means that 60% of operations have been financed with debt and the remaining 40% has been financed by equity. Funds set aside for unexpected repairs and replacements. CUPSS recommends that utilities work towards an emergency reserve balance of 25% of its annual operating expenses. The average amount of time, in years, that a system or component is estimated to function when installed new. Money spent by the utility to continue its ongoing operations. Expense Ratio = Operating Expense / Total Expense The expense ratio measures the amount of operating expenses compared to total expenses. A high ratio indicates that most expenditures are for operations - leaving the remaining balance for non-operating costs (such as debt service, capital improvements, etc.). If the non-operating balance is small, then the utility is not likely to meet all of its capital-related expenses, which may cause the system to deteriorate more rapidly. Intangible assets such as cash and bank balances. The amount, as a percent, a community's demand for water or wastewater treatment has increased or decreased. This value will be used to adjust future revenues and expenses. The anticipated rate of increase in the price level of goods and services. 16 ------- Term Interest Rate Level of Service Liabilities Maintained According to Factory Recommendation Operating Expenses Operating Ratio Original Cost Probability of Failure Redundancy Replacement Cost Revenue Revenue Surplus/Deficit Risk Definition A rate which is charged or paid for the use of money. Note: Do not include a percentage sign. The characteristics of system performance such as how much, of what nature, and how frequently, with regard to the system's service. The financial obligations for which the utility is responsible. The frequency of routine maintenance as recommended by the manufacturer. Total annual cost of operating and maintaining the water or wastewater utility service. This does not include savings or future funds withdrawal from capital savings accounts. Operating expenses include maintenance, equipment, salaries, wages, benefits, supplies, chemicals, contracts, utilities, monitoring, testing, emergency, rent, mortgage, insurance, services, training costs, billing costs, fees, and security costs. Operating Ratio = Operating Revenue / Operating Expense The operating ratio demonstrates the relationship between operating revenues and operating expenses. A high ratio indicates that the organization has operating efficiency by keeping expenses low relative to revenue. The amount paid for the initial purchase of an asset. The chance an asset will fail based on the percent of effective life consumed and redundancy. Spare assets that have the ability to do the same job, if a failure of the primary asset were to occur. How much will it cost to replace the asset, if required today? Funds earned by the system through the sale of water or by other means. The difference between the total cost of doing business and the funds received from fees, loans and grants, and interest earned from any accounts. If the result is zero or greater, the utility is taking in enough money to fully recover its costs and have a surplus. If the result is less than zero, the utility will not cover all costs and therefore will have a deficit. The potential for realization of unwanted adverse consequences or events. 17 ------- Term Routine Maintenance Cost Sales Ratio Savings Withdrawal Total Annual Cost of Doing Business Definition How much does it cost for a single routine maintenance activity to be performed on the asset? Sales Ratio = Sales / Total Revenue The sales ratio measures the percentage of total revenue that is made up of sales from operations. A low ratio indicates that the organization is overly reliant on outside funding. A fixed amount of money removed from the savings account of the utility to help pay for capital improvement items or other planned or unplanned maintenance. The total annual operating expenses plus the required total annual reserve contributions to reserve funds. 18 ------- Inventory List (Drinking Water) Asset Name Location Associated Asset Associated Location Asset ID (optional) Asset Size (optional) Storage Capacity in Days (optional) LF (optional) Acres (optional) Asset Category Source a Pumping Facility Q Treatment Q Storage Distribution Other Asset Type Wells and Springs Intake Structures Pumping Equipment Disinfection Equipment Hydropneumatic Tanks Concrete & Metal Storage Tanks Transmission Mains Distribution/ Collection Mains Valves Computer Equipment/ Software Transformers/ Switchgears/ Wiring Motor Controls/Drives Sensors Buildings Service Lines a Hydrants Treatment Equipment Lab/Monitoring Equipment Tools and Shop Equipment Transportation Equipment Security Equipment Land Q Galleries and Tunnels Q Meters a Raw Water Reservoirs Q Generators Q Liquid Waste Handling & Disposal a Solid Waste Handling & Disposal a Wells a Springs a Other Asset Status Active Not in Use - Abandoned [3 Not in Use - Back Up [3 Future Investment Can this Asset be Repaired? Q Yes No Can this Asset be Rehabilitated? a Yes a No Asset Replaced (optional): Show asset in schematic? Q Yes No Condition Excellent Good Fair (Average) Q Poor Very Poor Is the asset maintained according to manufacturer's recommendations? [3 Yes No Capacity Fullsized Oversized Undersized Consequence of Failure Insignificant - CoF of 2 Q Minor - CoF of 4 Major - CoF of 8 a Catastrophic - CoF of 10 Moderate - CoF of 6 Redundancy 0% Backup a 50% Backup a 100% Backup a 200% Secondary Backup Installation Date Expected Useful Life Original Cost Replacement Cost Routine Maintenance Costs Timeframe $ Q per/day Q per/week Q per/month Q per/year Q lifetime Optional Information Frequency of Routine Maintenance Model Number Supplier Name City, State, Zip Fax Number Start Date Manufacturer Address Phone Number Asset Latitude/Longitude Notes 19 ------- Inventory List (Wastewater) Asset Name Location Associated Asset Asset ID (optional) Storage Capacity in Days (optional) Acres (optional) Associated Location Asset Size (optional) LF (optional) Asset Category Pumping Facility Q Treatment Q Storage Q Collection Q Other Asset Type Pumping Equipment Disinfection Equipment Concrete & Metal Storage Tanks Transmission Mains Valves I Computer Equipment/ Software Transformers/ Switchgears/ Wiring Motor Controls/Drives Sensors Buildings Service Lines Treatment Equipment Distribution/ Collection Mains Q Lab/ Monitoring Equipment Q Tools and Shop Equipment Q Transportation Equipment LI Security Equipment a Land LI Sewers Q Pressure Pipework a Galleries and Tunnels Q Meters a Generators Q Liquid Waste Handling & Disposal a Solid Waste Handling & Disposal Q Digester a Other Asset Status Active Q Not in Use - Abandoned Q Not in Use - Back Up Q Future Investment Can this Asset be Repaired? a Yes a No Can this Asset be Rehabilitated? a Yes a No Asset Replaced (optional): Show asset in schematic? Q Yes No Condition Excellent Good Fair (Average) U Poor U Very Poor Is the asset maintained according to manufacturer's recommendations? Yes a No Capacity Fullsized Oversized Undersized Consequence of Failure Q Insignificant - CoF of 2 Q Minor - CoF of 4 Q Major - CoF of 8 Q Catastrophic - CoF of 10 Moderate - CoF of 6 Redundancy 0% Backup a 50% Backup a 100% Backup a 200% Secondary Backup Installation Date Expected Useful Life Original Cost Replacement Cost Routine Maintenance Costs Timeframe $ Q per/day Q per/week Q per/month Q per/year Q lifetime Optional Information Frequency of Routine Maintenance Model Number Supplier Name City, State, Zip Fax Number Start Date Manufacturer Address Phone Number Asset Latitude/Longitude Notes 20 ------- New Task Staff Assigned Task Name Task Type Q Monitoring Q Routine Maintenance Q Repair Q Rehabilitation Q Replacement Q Other Is this task planned? Q Yes Q No Is this a Capital Improvement Project? Q Yes Q No Task Details Task Notes Cost of the Task Percent of Task Deferred Maintenance $ % For Asset-related Tasks ^ ~-^^^^^^^^^^^^^^^^^^^^— Asset Name Condition Q Excellent Q Good Q Fair (Average) Q Poor Q Very Poor Is the asset maintained according to manufacturer's recommendations? Q Yes Q No For Monitoring Tasks Chemicals Amount Unit Date Time Schedule Task Start-End Date Frequency Q Daily a Weekly QMonthly Recurs every day(s) time(s) / day Day of every month (s) (Month) (Day of month) Recurrence End Date Optional Parts Information Manufacturer/Supplier Parts Name Parts Number Parts Cost Labor Maintenance Costs Completed Date \ Time Staff Completed Length (days) Q Annually week(s) on (Day of week) (Week of month) (Day of week) every month(s) (Week of month) (Day of week) of (Month) $ $ 21 ------- Finances Year Revenue Cash on Hand Interest Rate Revenue from user rates Revenue from grants Revenue from loans/bonds Transfer from reserve fund Interest Other Revenues (Total) $ $ $ $ $ $ Q One-time fees $ Q Contract sales $ Q Bulk sales $ Q Product sales $ Q Ad Valorem tax $ Other Total Revenue $ $ Expenses Operating Expenses (Total) $ Q Maintenance $ Q Equipment Q Salaries, Wages, Benefits $ Q Supplies Q Chemicals $ Q Contracts Q Utilities $ a Monitoring & Testing Q Emergency $ Q Rent or Mortgage Q Insurance $ Q Services Q Training Costs $ Q Billing Costs Q Fees $ a Security a 2 Post Office Boxes $ a Publications and Elections Q Taxes $ Capital Improvements Q Storage Tank Debt Payment Capital Reserve Contribution Emergency Reserve Contribution Other Total Expenses $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 22 ------- |