Docstoc

SURF

Document Sample
SURF Powered By Docstoc
					Revised Dec 03
                                                        The Hawaii Section of
Numbers shown                                The American Water Works Association
are for information only                                     SURF
Green areas are for input                          Small Utility Rates & Finances

Your System Name:        Your Water Systems Name

Number of Connections:                 550

Average # of Gallons
 sold each year:                   40,000,000


                          Before you continue, make sure you have read pages 1 - 4 in the User Guide!


INSTRUCTIONS:
  Part 1. set up or modify your water SYSTEM BUDGET below, salaries and capital cost are calculated on another page

  Part 2. Look at your USER RATES

  Part 3. track your water SYSTEM EXPENSES

  If you would like a PRINT OUT of your system's budget and rates, print each page
Enter your budget information below
        Your Water Systems Name                                V = Calculated as Variable Costs
      Drinking Water System Budget                             F = Calculated as Fixed Costs

                                      Monthly                       Annual
Budget Item                 V/F        Budget                       Budget
Salaries and Benefits        V          $2,000.00                   $24,000.00
        To Calculate Salaries, go to Salaries page                                  Enter your info in green areas
Purchased Water              V               $0.00
Loan Payments                F               $0.00
Utilities                    V          $1,000.00                   $12,000.00
Chemicals                    V              $50.00                    $600.00
Repairs                      V              $50.00                    $600.00
Testing                      F            $250.00                    $3,000.00
Spare Parts                  V              $50.00                    $600.00
Transportation               F              $25.00                    $300.00
Insurance                    F            $200.00                    $2,400.00
Office Supplies & Postage F               $100.00                    $1,200.00
Telephone                    F              $33.33                    $400.00
Professional Services        F              $41.67                    $500.00 Recommended
Reserves - O&M               V            $416.67                    $5,000.00 O&M Reserves:
Reserves - Debt Service      F               $0.00                                 $5,700.00
other                        F               $0.00
                             F               $0.00
                             F               $0.00
                             F               $0.00
Go Capital Improvement Reserves Page, (below salaries).
Your budget with the Capital improvements will be shown below. Enter your last years budget for comparison.
Your Water Systems Name
Drinking Water System Budget
 with Capital Improvement Reserves                                Comparison
                                     Annual                        Last Year's
                                     Budget                          Budget
Budget Item                          Amount                         Amount
Salaries and Benefits                $24,000.00                      $25,000.00
Purchased Water                           $0.00                          $50.00         Enter your info in green areas
Loan Payments                             $0.00                       $5,000.00
Utilities                            $12,000.00                      $10,000.00
Chemicals                               $600.00
Repairs                                 $600.00
Testing                               $3,000.00
Spare Parts                             $600.00
Transportation                          $300.00
Insurance                             $2,400.00
Office Supplies & Postage             $1,200.00
Telephone                               $400.00
Professional Services                   $500.00
Reserves - O&M                        $5,000.00
Reserves - Debt Service                   $0.00
other                                     $0.00
                      0                   $0.00
                      0                   $0.00
                      0                   $0.00
Reserves - Capital Improvements      $28,633.33 from work sheet
TOTAL ANNUAL BUDGET:                 $79,233.33                       $40,050.00
uide!




ulated on another page




nfo in green areas
arison.




nfo in green areas
BUDGET ITEM
DEFINITIONS:

Salaries and Benefits




Purchased Water


Loan Payments


Utilities



Chemicals


Repairs


Testing


Spare Parts



Transportation



Insurance



Office Supplies & Postage


Telephone

Professional Services
Reserves - O&M




Reserves - Debt Service




Reserves -
 Capital Improvements
Salaries for all employees, full time or part time, whether
paid by the hour, weekly or monthly. This budget item
is calculated automatically after the information is entered
on the "Salary & Benefit Calculation" screen. This screen
is accessed by pressing CTRL+A.

If applicable, this budget represents the cost of water
purchased from other systems, suppliers, etc.

Any loan payments for prior system expenditures are
budgeted for in this catetgory.

This budget item is for all electricity, natural gas, etc.
that is purchased to operate the system. (Do not include
telephone expense in this category.)

Chlorine and other necessary chemical expenses are
included in this budget item.

Minor repairs, usually those costing less than $250.00,
are accounted for in this budget item.

Water quality sampling and laboratory testing fees are
budgeted for in this item.

This budget item contains funds for miscellaneous parts
needed for system maintenance, such as pipe, valves,
paint, adhesives, lubricants, small tools, etc.

Expenses for vehicles are accounted for in this budget
item. Gasoline, maintenance, insurance and registration
fees are a few examples.

All insurance expenses are contained in this budget item,
including liability, fire, theft, etc. Vehicle insurance may be
accounted for here if not budgeted in "Transportation."

Any office supplies needed as well as postage expenses are
accounted for in this budget item.

Telephone expenses are budgeted for in this category.

This budget item includes the cost of attorneys, accountants,
engineers, consultants, etc.
A budgeted reserve account for O&M will allow the system
to continue operating in the case of financial problems.
A good rule of thumb is to keep at least 1/8 of the total O&M
budget in the reserve account at all times.

Some lenders require loan recipients to maintain a funded
reserve account for debt service. This ensures that loan
payments will be made for a short time in case of financial
problems. (This is not required in many cases.)

This amount is automatically calculated when the required
information is entered on the "Capital Improvements
Reserves" screen. This screen is accessed by pressing
CTRL+C.
Your Water Systems Name
Salaries and Capital Improvement Reserves
                         # Hours        Hourly         Taxes &       Total
                         Worked x        Pay       +   Benefit =   Monthly
Employee                 Monthly         Rate           Costs      Expense
Operator 1                     80           $15.00      $200.00     $1,400.00
Support Operator 2             40           $12.00      $120.00       $600.00
                                                                        $0.00
                                                                        $0.00
                                                                        $0.00
                                                                        $0.00
                                                                        $0.00
                                                                        $0.00
                                                                        $0.00
TOTAL:                                                              $2,000.00


     Description of       Years      Replacement                   Annual
         Major            of Life        Cost                       Budget
       Equipment        Remaining      Estimate                    Amount
WELL PUMP                       10       $5,000.00                    $500.00
TANK                            30     $150,000.00                  $5,000.00
PIPELINE from Well              10     $158,000.00                 $15,800.00
PIPELINE Transmission           30     $220,000.00                  $7,333.33
                                                                        $0.00
                                                                        $0.00
TOTAL:                                $533,000.00                  $28,633.33
NOTE: You must enter your budget information before your rates are calculated.
Your Water Systems Name
Metered Rate Calculation

              Based on                   40,000,000 gallons of water sold per year,
                                             your rate structure looks like this:

         Total Fixed Costs:                                      $36,433.33 per year
         Total Variable Costs:                                   $42,800.00 per year
         Monthly Base Rate:                                           $5.52 per month, per meter
         Unit Rate:                                                   $1.07 per thousand gallons

         In order for       Your Water Systems Name
         to break even, it must charge each user the Monthly Base Rate
         plus the Unit Rate (for each 1,000 gallons consumed) each month.

         Sample Bill:               Mr. Smith                Lot B    Meter #207
                                    Meter Reading 1/1/96:            12,500
                                    Meter Reading 2/1/96:            18,250
                                    Total Gallons Used:              11,000

                                    Base Rate Charge:                 $5.52
                                    Unit Rate Charge:                $11.77 (Unit Rate x Gallons Used)
                                    Total Amount Due:                $17.29


Your Water Systems Name
Non-Metered Rate Calculation


              Based on                          550 user connections,
                                      your rate structure looks like this:

         Total Fixed Costs:                                      $36,433.33 per year
         Total Variable Costs:                                   $42,800.00 per year
         Monthly User Rate:                                          $12.01 per month


         In order for       Your Water Systems Name
         to break even, it must charge each user the
         Monthly User Rate each month.
Your Water Systems Name
Expense Tracking

MONTH 1 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 2 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 3 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 4 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 5 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 6 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 7 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 8 Date (m/d/y):
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 9 Date (m/d/y):                     MONTH 10
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 10 Date (m/d/y):                    MONTH 11
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
MONTH 11 Date (m/d/y):                    MONTH 12
Budget Item            Amount Reference
Salaries and Benefits
Purchased Water
Loan Payments
Utilities
Chemicals
Repairs
Testing
Spare Parts
Transportation
Insurance
Office Supplies & Postage
Telephone
Professional Services
Reserves - O&M
Reserves - Debt Service
other
          0
          0
          0
Reserves - Capital Improvements
Press CTRL+G when finished
                                          Your Water Systems Name
                                          Budget Reconciliation
MONTH 12 Date (m/d/y):
Budget Item            Amount Reference   Budget Item
Salaries and Benefits                     Salaries and Benefits
Purchased Water                           Purchased Water
Loan Payments                             Loan Payments
Utilities                                 Utilities
Chemicals                                 Chemicals
Repairs                                   Repairs
Testing                                   Testing
Spare Parts                               Spare Parts
Transportation                            Transportation
Insurance                                 Insurance
Office Supplies & Postage                 Office Supplies & Postage
Telephone                                 Telephone
Professional Services                     Professional Services
Reserves - O&M                            Reserves - O&M
Reserves - Debt Service                   Reserves - Debt Service
other                                     other
          0                                         0
          0                                         0
          0                                         0
Reserves - Capital Improvements           Reserves - Capital Improvements
Press CTRL+G when finished                TOTAL:
er Systems Name
econciliation
                                       Remaining
       Annual Budget   Y-T-D            Balance
          $24,000.00           $0.00    $24,000.00
               $0.00           $0.00         $0.00
               $0.00           $0.00         $0.00
          $12,000.00           $0.00    $12,000.00
             $600.00           $0.00       $600.00
             $600.00           $0.00       $600.00
           $3,000.00           $0.00     $3,000.00
             $600.00           $0.00       $600.00
             $300.00           $0.00       $300.00
           $2,400.00           $0.00     $2,400.00
           $1,200.00           $0.00     $1,200.00
             $400.00           $0.00       $400.00
             $500.00           $0.00       $500.00
           $5,000.00           $0.00     $5,000.00
               $0.00           $0.00         $0.00
               $0.00           $0.00         $0.00
               $0.00           $0.00         $0.00
               $0.00           $0.00         $0.00
               $0.00           $0.00         $0.00
          $28,633.33           $0.00    $28,633.33
          $79,233.33           $0.00    $79,233.33

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:12/21/2011
language:English
pages:24