ASSET MANAGEMENT WORKSHEET, Study notes of Investment Management and Portfolio Theory

ASSET MANAGEMENT WORKSHEET. Date: 12/20/2010. System ID No.: System Name: Service Connections: 1. MONTHLY. *Enter information only in shaded cells.

Typology: Study notes

2022/2023

Uploaded on 05/11/2023

tomcrawford
tomcrawford 🇺🇸

4.2

(15)

257 documents

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
ASSET MANAGEMENT WORKSHEET Date: 12/20/2010
System ID No.:
System Name: Service Connections: 1 MONTHL
Y
*Enter information only in shaded cells AVG RESERVE
UNIT INSTALLED LIFE,
A
NNUAL MONTHL
Y
PER
QT
Y
COMPONENT COST COST YEARS RESERVE RESERVE CUSTOME
R
Gravel Packed Well, 6" Depth: 0 25 0.00 0.00 0.00
Drilled Well, 6", steel casin
g
Depth: 0 25 0.00 0.00 0.00
Drilled Well, 8", steel casin
g
Depth: 0 25 0.00 0.00 0.00
Drilled Well, 12", steel casin
g
Depth: 0 25 0.00 0.00 0.00
Wellhead Electrical Controls 0 25 0.00 0.00 0.00
Submersible Pump, 20 HP
(
1 standb
y
spare
)
0 7 0.00 0.00 0.00
Electric Pump, HP
Submersible Pump, 2 HP 0 7 0.00 0.00 0.00
Submersible Pump, 7 HP 0 7 0.00 0.00 0.00
Booster Pump Station, 25 HP, complete 0 5 0.00 0.00 0.00
Booster Pump Station Electrical Controls 0 5 0.00 0.00 0.00
Pressure Tank Gallons: 0 10 0.00 0.00 0.00
Pressure Tank Gallons: 0 10 0.00 0.00 0.00
Storage Tank, Plastic Gallons: 0 10 0.00 0.00 0.00
Storage Tank, Other Gallons: 0 40 0.00 0.00 0.00
Storage Tank, Other Gallons: 0 40 0.00 0.00 0.00
Storage Tank, Steel Gallons: 0 50 0.00 0.00 0.00
Storage Tank, Steel Gallons: 0 50 0.00 0.00 0.00
Storage Tank, Steel Gallons: 0 50 0.00 0.00 0.00
Storage Tank, Concrete Gallons: 0 80 0.00 0.00 0.00
Master Meter, 2" 0 10 0.00 0.00 0.00
Master Meter, 3" 0 10 0.00 0.00 0.00
Master Meter, 4" 0 10 0.00 0.00 0.00
H
pochlorinator w/ Tank & Pump, Complete 0 10 0.00 0.00 0.00
Pipe w/ sand beddin
g
, 1"
(
Enter linear feet for quantit
y)
0 50 0.00 0.00 0.00
Pipe w/ sand beddin
g
, 2"
(
Enter linear feet for quantit
y)
0 50 0.00 0.00 0.00
Pipe w/ sand beddin
g
, 3"
(
Enter linear feet for quantit
y)
0 50 0.00 0.00 0.00
Pipe w/ sand beddin
g
, 4"
(
Enter linear feet for quantit
y)
0 50 0.00 0.00 0.00
Pipe w/ sand beddin
g
, 6"
(
Enter linear feet for quantit
y)
0 50 0.00 0.00 0.00
Standpipe H
y
drant, 1-1/2
"
0 20 0.00 0.00 0.00
Standpipe H
y
drant, 2-1/2
"
0 20 0.00 0.00 0.00
Customer Meter w/ Box & Shutoff, Complet
e
0 20 0.00 0.00 0.00
Distribution Valve, 2" 0 10 0.00 0.00 0.00
Distribution Valve, 3" 0 10 0.00 0.00 0.00
Distribution Valve, 4" 0 20 0.00 0.00 0.00
Distribution Valve, 6" 0 20 0.00 0.00 0.00
A
ir & Vacuum Relief Valve, T
y
pical 0 20 0.00 0.00 0.00
TOTALS: $0.00 $0.00 $0.00 $0.00
Report Prepared by (Title): ______________________________________________________ Date: ____________________
NOTE: Installed costs are averages, and include all materials and contracted labor and equipment.
YES 2/3/2009
YES NO
YES NO
Comprehensive Report Reviewed
Sanitary Survey Reviewed
Enforcement Action Reviewed
Date of CR
Date of SS
Date of EA
pf2

Partial preview of the text

Download ASSET MANAGEMENT WORKSHEET and more Study notes Investment Management and Portfolio Theory in PDF only on Docsity!

ASSET MANAGEMENT WORKSHEET

Date: 12/20/

System ID No.:

System Name: Service Connections: 1

MONTHLY

*Enter information only in shaded cells AVG RESERVE

UNIT INSTALLED LIFE, ANNUAL MONTHLY PER

QTY COMPONENT COST^ COST YEARS RESERVE RESERVE CUSTOMER

Gravel Packed Well, 6" Depth: 0 25 0.00 0.00 0. Drilled Well, 6", steel casing Depth: 0 25 0.00 0.00 0. Drilled Well, 8", steel casing Depth: 0 25 0.00 0.00 0. Drilled Well, 12", steel casing Depth: 0 25 0.00 0.00 0. Wellhead Electrical Controls 0 25 0.00 0.00 0. Submersible Pump, 20 HP (1 standby spare) 0 7 0.00 0.00 0. Electric Pump, HP Submersible Pump, 2 HP 0 7 0.00 0.00 0. Submersible Pump, 7 HP 0 7 0.00 0.00 0. Booster Pump Station, 25 HP, complete 0 5 0.00 0.00 0. Booster Pump Station Electrical Controls 0 5 0.00 0.00 0. Pressure Tank Gallons: 0 10 0.00 0.00 0. Pressure Tank Gallons: 0 10 0.00 0.00 0. Storage Tank, Plastic Gallons: 0 10 0.00 0.00 0. Storage Tank, Other Gallons: 0 40 0.00 0.00 0. Storage Tank, Other Gallons: 0 40 0.00 0.00 0. Storage Tank, Steel Gallons: 0 50 0.00 0.00 0. Storage Tank, Steel Gallons: 0 50 0.00 0.00 0. Storage Tank, Steel Gallons: 0 50 0.00 0.00 0. Storage Tank, Concrete Gallons: 0 80 0.00 0.00 0. Master Meter, 2" 0 10 0.00 0.00 0. Master Meter, 3" 0 10 0.00 0.00 0. Master Meter, 4" 0 10 0.00 0.00 0. Hypochlorinator w/ Tank & Pump, Complete 0 10 0.00 0.00 0. Pipe w/ sand bedding, 1" (Enter linear feet for quantity) 0 50 0.00 0.00 0. Pipe w/ sand bedding, 2" (Enter linear feet for quantity) 0 50 0.00 0.00 0. Pipe w/ sand bedding, 3" (Enter linear feet for quantity) 0 50 0.00 0.00 0. Pipe w/ sand bedding, 4" (Enter linear feet for quantity) 0 50 0.00 0.00 0. Pipe w/ sand bedding, 6" (Enter linear feet for quantity) 0 50 0.00 0.00 0. Standpipe Hydrant, 1-1/2" 0 20 0.00 0.00 0. Standpipe Hydrant, 2-1/2" 0 20 0.00 0.00 0. Customer Meter w/ Box & Shutoff, Complete 0 20 0.00 0.00 0. Distribution Valve, 2" 0 10 0.00 0.00 0. Distribution Valve, 3" 0 10 0.00 0.00 0. Distribution Valve, 4" 0 20 0.00 0.00 0. Distribution Valve, 6" 0 20 0.00 0.00 0. Air & Vacuum Relief Valve, Typical 0 20 0.00 0.00 0.

TOTALS: $0.00^ $0.00^ $0.00^ $0. Report Prepared by (Title): ______________________________________________________ Date: ____________________ NOTE: Installed costs are averages, and include all materials and contracted labor and equipment.

YES 2/3/

YES NO

YES NO

Comprehensive Report Reviewed Sanitary Survey Reviewed Enforcement Action Reviewed

Date of CR Date of SS Date of EA

FIVE YEAR BUDGET PROJECTIONNoncommunity Water System

INFLATION FACTOR (%) -

System Name:

PWS I.D. Number:

*Enter information only in shaded cells

LINE

EXPENSES

Current Year

Year 2

Year 3

Year 4

Year 5

OPERATIONS & MAINTENANCE

Salaries and benefits

Contract operation and maintenance

Power and other utilities

Fees

Treatment chemicals

Coliform monitoring

Chemical monitoring

Transportation

Materials, supplies, and parts

Miscellaneous

Total Operation and Maintenance

GENERAL & ADMINISTRATIVE

Engineering and professional services

Depreciation and amortization

CIP Reserve (from Sheet 2, Column J Total)

Insurance

Total General and Administrative

TOTAL EXPENSES

Report Prepared by: ____________________________________________

Date: ____________________

Title: ____________________________________________