Cost Model Variables

Many variables are referenced in numerous places throughout the cost model. Table C.1 summarizes the variable names and tables used in the cost model as well as their original input location. Table C.1 also provides the spreadsheet in which the value of each variable is originally defined. The user can make original definitions by entering a numerical value for the variable or by calculating the value of the variable as a function of previously defined variables. Table C.2 summarizes the list of look-up tables used in the cost model. The purpose of providing Tables C.1 and C.2 is to simplify the process of making changes to the driving variables of the model and to ensure that variables are changed only at their original output location.

Table C.1 NIBRS Cost Estimating Model

Variable Name Definition Original Input Location Worksheets Where Used C_USERS Number of concurrent users Assumptions

Users NIBRS SW DB SW Hardware Q_DE Number of data entry clerks Assumptions Users Q_QUERY Number of personnel using the _{system for queries at any one time} Assumptions Users Q_DAYS Average number of working days per _month Internal Users Q_HOURS Average number of working hours _{per month} Internal Users

I_HOURS Average number of incidents per _{hour by a data entry clerk} Internal Users

PERCENT _ SO Percent of sworn officers making _{concurrent queries} Internal Users

PERCENT_CUSER Concurrent user escalation factor _(percent) Internal Users _Assumptions SW Total purchase price of software NIBRS SW SW Maint _{NIBRS SW} SW_COTS Cost of COTS software license NIBRS SW NIBRS SW SW_CUSTOM Cost of custom software _development NIBRS SW NIBRS SW

146 147

Cost Model (Cont’d)

Variable Name Definition Original Input Location Worksheets Where Used SM Staff months needed to develop _{custom software} NIBRS SW NIBRS SW

UC_SM Unit cost of a staff month Internal NIBRS SW

UC_L_1 Cost of 1 month of NIBRS SW _license Internal NIBRS SW UC_L_10 Cost of 10 NIBRS SW license Internal NIBRS SW UC_L_100 Cost of 100 NIBRS SW license Internal NIBRS SW UC_FIELD_SER Unit cost of a field mobile server _license Internal NIBRS SW UC_FIELD_USER Unit cost of laptop license Internal NIBRS SW

Q_MOBILE The number of mobile users RMS NIBRS SW

FIELD_RPT Field reporting requirement (Yes or _No) RMS NIBRS SW DBSW Total purchase price of database _{software licenses} DB SW DB SW UC_DATABASE Base cost of software license Internal DB SW UC_DBSWUSER Cost of additional concurrent user _{licenses (after first five)} Internal DB SW UC_SER1 Unit cost of a stand-alone RMS _server Internal Hardware

UC_WKS Unit cost of a high-end desktop PC (includes Windows NT operating

system, network card, and monitor) Internal

Tables Hardware UC_LAP Unit cost of a mid-level notebook _{with active matrix screen} Internal Tables_Hardware UC_LAPR Unit cost of a ruggedized laptop Internal Tables_Hardware UC_ROUTER Unit cost of a router for the _{headquarters or a remote site} Internal Tables_Hardware UC_PTR Unit cost of the average stand-alone _printer Internal Tables_Hardware UC_PTRN Unit cost of the average stand-alone _{networked printer} Internal Hardware

Cost Model (Cont’d)

Variable Name Definition Original Input Location Worksheets Where Used UC_HUB Unit cost of the average network _{hub port} Internal Tables_Hardware TRAIN Total program cost of training Training Training TRAIN_EU Cost of training the trainers for end _users Training Training TRAIN_SL Cost of training the trainers for _{system level staff} Training Training UC_CLASS Daily cost of class (Max.: 10 _students) Internal Training UC_STUDENT Daily cost of training one trainer Internal Training INST Total cost of NIBRS installation Install Install INST_HW Cost of hardware installation Install Install INST_SW Cost of software installation Install Install INST_CIR Cost of circuit installation Install Install UC_PORT Unit cost for installation of cabling _{and wall ports} Internal Install Q_WKS Number of additional RMS _{workstations needed for the NIBRS RMS} Assumptions_Install

Q_PTR Number of additional printers required for RMS/NIBRS

participation RMS

Assumptions Install Q_RSC Number of remote sites with _{insufficient connectivity} RMS Assumptions_Install

UC_SW_INST Per day cost for installing COTS _software Internal Install

Q_RS Number of Remote Sites that will _{participate in the RMS/NIBRS} RMS AssumptionsInstall Data Conv CIR_SITE Cost of circuit installation at remote _site Install Install CIR_HQ Cost of circuit installation at _{headquarters site} Install Install

148 149

Cost Model (Cont’d)

Variable Name Definition Original Input Location Worksheets Where Used

Q-RSC

Number of additional remote sites with no existing connectivity, or sites which require additional bandwidth for RMS/NIBRS

RMS Install_Telecom

DATACON Total cost of data conversion Data Conv Data Conv UC_DCS One-time cost of data conversion for _{a small agency (stand-alone PC)} Internal Data Conv

UC_DCM One-time cost of data conversion for a medium agency (LAN but no

WAN) Internal Data Conv

UC_DCL One-time cost of data conversion for _{a large agency (LAN and WAN)} Internal Data Conv

LEVEL Support service on a 8 x 5 basis _{(level=1) or a 24 x 7 basis (level=2)} RMS_Assumptions SW Maint_{HW Maint} LAN Corresponds to Multi-user (Yes or _No) RMS_Internal Hardware

CER_SW8 The CER used to estimate the cost of 8 x 5 maintenance support for

software Internal SW Maint

CER_SW24 The CER used to estimate the cost of 24 x 7 maintenance support for

software Internal SW Maint

SOLUTION 1=COTS_2=Custom RMS_Assumptions SW Maint

HW Total purchase price of equipment _{(system hardware)} Hardware HW Maint

CER_HW8 The CER used to estimate the cost of 8 x 5 maintenance support for

HW Internal HW Maint

CER_HW24 The CER used to estimate the cost of 24 x 7 maintenance support for

HW Internal HW Maint

COM Annual cost of telecommunications Telecom Telecom COM_SITE The annual cost of telecommunications of the remote

Cost Model (Cont’d)

Variable Name Definition Original Input Location Worksheets Where Used COM_HQ The annual cost of _{telecommunications of headquarters Telecom} Telecom RMS SERVER Annual cost of RMS Server Tables_Hardware Tables_Hardware

YEAR

Current four-digit year; used to escalate labor cost from year 1999, when original cost model was completed

150 151 Table Name Purpose

Original Input

Location Worksheets Where Used Bounds on Data

TB_STATE

Determines the number of staff months for custom SW development, based on the state of the current system

NIBRS SW NIBRS SW

No bounds. State refers to current status of reporting system. Possible states are RMS, non-IBR RMS, or RMS IBR.

TB_SERVER Determines server cost, based on

concurrent users Hardware Hardware

The number of concurrent users ranges from 1-500 (inclusive). This table is used if the current system is a multi-user system, incidents per month and/or number of sworn officers are large, or if the concurrent user escalation factor is high.

TB_CIRCUIT Determines the circuit charge for

telecommunications Telecom

Install Telecom

The breakpoint ranges from 0-769, while circuit size ranges from 64-1024