module 4: winslamm v 9.1 control practice cost analysis

Module 4: WinSLAMM v 9.1 Module 4: WinSLAMM v 9.1

Control Practice Cost Control Practice Cost AnalysisAnalysis

Arvind NarayananArvind NarayananDept. of Civil, Construction and Environmental EngineeringDept. of Civil, Construction and Environmental Engineering

Univ. of AlabamaUniv. of Alabama

John Voorhees, PE, PHJohn Voorhees, PE, PHEarth Tech, Inc.Earth Tech, Inc.

$$We will cover . . .We will cover . . .

Cost Analysis Cost Analysis OverviewOverview

Sources of Cost DataSources of Cost Data Entering Cost DataEntering Cost Data Running the model Running the model

with Cost Data and with Cost Data and Reviewing Cost Reviewing Cost OutputOutput

Cost Analysis OverviewCost Analysis Overview

Calculates the cost of the control practices Calculates the cost of the control practices listed in a model runlisted in a model run

Allows you to compare the cost of different sets Allows you to compare the cost of different sets of practicesof practices

Provides the option of applying either pre-Provides the option of applying either pre-determined costs or user-defined costsdetermined costs or user-defined costs

Doesn’tDoesn’t evaluate the cost reductions due to the evaluate the cost reductions due to the use of control practices, ie, no asphalt use of control practices, ie, no asphalt pavement reduction determined if porous pavement reduction determined if porous pavement is used.pavement is used.

What Does the Cost Analysis Program Do?


How are the Cost Values Normalized?

Total Present Worth = Capital Cost + Land Cost +

Present Worth of Annual Maintenance Cost

P

A AA A AA

1 2 43 n


How are the Cost Values Normalized?

Uniform Series Worth = Annual Value of (Capital Cost + Land Cost) +

Annual Maintenance Cost

P

A AA A AA

1 2 43 n


Edit and Save the Edit and Save the Cost Template.csv Cost Template.csv FileFile

Select the Cost Data Select the Cost Data File for a Model RunFile for a Model Run

Run the ProgramRun the Program Review the Cost Review the Cost

OutputOutput

What is the General Cost Evaluation Process?

Sources of Cost DataSources of Cost Data Pre-Determined CostsPre-Determined Costs

SEWRPC 1991 Cost SEWRPC 1991 Cost ReportReport

Costs Updated Using Costs Updated Using ENR Cost IndicesENR Cost Indices

Cost Indices Available Cost Indices Available for 20 Citiesfor 20 Cities

Atla

nta,

GA

Bal

timor

e, M

DB

irmin

gham

, AL

Bos

ton,

MA

Chi

cago

, IL

Cin

cinn

ati,

OH

Cle

vela

nd, O

HD

alla

s, T

XD

enve

r, C

OD

etro

it, M

IK

ansa

s C

ity, M

OLo

s A

ngel

es, C

AM

inne

apol

is, M

NN

ew O

rlean

s, L

AN

ew Y

ork,

NY

Phi

lade

lphi

a, P

AP

ittsb

urgh

, PA

San

Fra

ncis

co, C

AS

eattl

e, W

A

St.L

ouis

, MO

0

2000

4000

6000

8000

10000

12000

Co

st In

dex

Val

ue

Construction Cost Index by City

1989

2005

Sources of Cost DataSources of Cost Data Pre-Determined CostsPre-Determined Costs

Costs Available for – Costs Available for – • Wet DetentionWet Detention• Porous PavementPorous Pavement• Grass SwalesGrass Swales• Street CleaningStreet Cleaning• CatchbasinsCatchbasins• Infiltration TrenchesInfiltration Trenches

Wet Detention Pond Costs - SEWRPC 1989

1

10

100

1000

10 100 1000

Wet Detention Basin Water Volume (1000 cf)

Ca

pit

al

Co

st

in 1

98

9 D

oll

ars

($

10

00

's)

Low Cost

Med. Cost

High Cost

O&M Cost

Sources of Cost DataSources of Cost Data User-Defined Costs for User-Defined Costs for

Each PracticeEach Practice Enter Items that Define Enter Items that Define

the Practicethe Practice Select UnitSelect Unit Enter Cost per UnitEnter Cost per Unit Enter QuantityEnter Quantity Program Calculates Program Calculates

CostCost Program Determines Program Determines

Total Unit CostTotal Unit Cost Enter Routine Enter Routine

Maintenance CostMaintenance Cost

Edit and Save the Cost Template.csv FileEdit and Save the Cost Template.csv File

On the Summary Data PageOn the Summary Data Page Enter project life and interest rate informationEnter project life and interest rate information Enter Land CostsEnter Land Costs Select Cost IndexSelect Cost Index

For Each Control PracticeFor Each Control Practice Select either Pre-Determined or User-Defined Select either Pre-Determined or User-Defined

CostsCosts For Pre-Determined Costs, select Cost RangeFor Pre-Determined Costs, select Cost Range For User-Defined Costs, enter Cost DataFor User-Defined Costs, enter Cost Data Enter Land Use MultiplierEnter Land Use Multiplier

Re-name and Save Cost Data FileRe-name and Save Cost Data File


From the Main Menu go to the Options/Access Cost Data Summary Tab . . .


Control Practice Cost Tabs and

Summary Data Tab

Cost File Management

Summary Data Tab


Land Use CostsInterest Rate and

Project Life

Cost Index Selection

Summary Data Tab


Pre-Determined Cost Table

Pre-Determined Capital Cost

Range

Wet Detention Pond Cost Data


User-Defined

Cost Table

Maintenance Cost Data - Sediment Removal Costs

- Routine Maintenance Cost

Wet Detention Pond Cost Data

Total Unit Cost

per 1000 cubic feet

Land Area Multiplier




Range

Porous Pavement Cost Data


User-Defined

Cost Table

Maintenance Cost Data - Routine Maintenance Cost

Porous Pavement Cost Data

Total Unit Cost

per square foot





Range

Street Cleaning Cost Data


User-Defined

Cost Table


Street Cleaning Cost Data

Total Unit Cost

per curb mile



Crushed Stone Fill Cost

Biofiltration Cost Data


User-Defined

Cost Table


Biofiltration Cost Data

Total Unit Cost

per cubic yard



Pre-Determined Cost Data

Catchbasin Cleaning Cost Data


Range


User-Defined

Cost Table


Catchbasin Cleaning Cost Data

Total Unit Cost

per unit


Pre-Determined Cost Tables

Grass Swale Cost Data


User-Defined

Cost Table


Grass Swale Cost Data

Total Unit Cost

per foot




Sources of Cost DataSources of Cost Data Entering Cost DataEntering Cost Data Running the Model Running the Model


Two Types of Cost OutputTwo Types of Cost Output

1.1. Capital, Land, and Maintenance Capital, Land, and Maintenance Costs on the Summary Tab of a Costs on the Summary Tab of a WinSLAMM Model RunWinSLAMM Model Run

2.2. Capital, Land, and Maintenance Capital, Land, and Maintenance Costs included with the output when Costs included with the output when you run a set of .dat files using the you run a set of .dat files using the Batch ProcessorBatch Processor

Enter the Cost Data File Name in the Current File Data Window

1. Output on a Model Run Summary Tab1. Output on a Model Run Summary Tab

Total Control Practice Costs

1. Output on a Model Run Summary Tab1. Output on a Model Run Summary Tab

Enter the Cost Data File Name by checking the box and pressing the ‘Select Cost Data File’ Window

2. Output from a Set of .dat Files2. Output from a Set of .dat Files

Import the output file ‘DATSetOutput.CSV’ into Excel


Cost Output for each .dat file

Import the output file ‘DATSetOutputCostDetail.CSV’ into Excel


Cost Information for each control

practice



Additional Detention Pond Sediment and Biofilter Volume Information



Present Value and Annual Value Cost Information

$$We covered . . .We covered . . .




Questions?Questions?

module 4: winslamm v 9.1 control practice cost analysis

Documents

cost values

cost outputwhat

cost reportcosts

cost reductions

cost analysis program

cost data file

sources of cost datapre

mikansas city