GRC spreadsheet

Document Sample
GRC spreadsheet Powered By Docstoc
					                                 Traffic Signals and Integrated Traffic Systems


This spreadsheet utilised the number of units from the authority's own inventory and locally derived
rates to create a Gross Replacement Cost (GRC)

The following example is used to illustrate the use of the spreadsheet

                       Example of GRC Calculation                             No of   Illustrative   GRC Value
                                                                              Units    Rate/Unit        (£)

Traffic Signals

The GRC costs per site include: heads, controllers, cables, and civils
required for cables, but excludes civils associated with the c'way or f'way
e.g., anti-skid surface, tactile paving. OMU/OUT and remote comms
included in site costs; installation costs provided elsewhere/ Cost is for
supply and installation.

Traffic Signal Junction
Number of Approaches                                                           75        35,000        2,625,000

Crossings:
OMU/OUT and remote comms included in site costs; installation costs
provided elsewhere. Cost is for supply and installation
(Note - dual crossings count twice)
Puffin Crossing                                                               15         55,000          825,000
Pelican Crossing                                                              85         45,000        3,825,000
Toucan Crossing                                                                5         55,000          275,000
Pegasus Crossing                                                               1         75,000           75,000
Zebra Crossing                                                                35          5,000          175,000
School Crossing (flashing amber lights per sign)                              110         4,000          440,000
Wig Wags                                                                       5         40,000          200,000

Information Systems

GRC cost per site includes: on-site equipment such as controllers and
remote comms, including civils for cabling, but excludes any
reinstatement. Cost is for supply and installation.

Real Time Passenger Information (display and remote comms)                      2         4,500            9,000
Real Time Passenger Information (bus fits)                                     10         3,500           35,000
Variable Message Signs - 50-100mmm x-height                                     3        11,000           33,000
Variable Message Signs - 101-175mmm x-height                                    5        18,000           90,000
Variable Message Signs - 176-225mmm x-height                                    8        25,000          200,000
Vehicle Activated Signs - (VAS)                                                20         5,000          100,000
Safety and Speed Camera Equipment                                              35        15,000          525,000
CCTV (including posts)                                                         10        15,000          150,000
Car Park Monitoring Systems                                                     1         8,000            8,000

InStation


GRC includes the cost of hardware, including instation communications,
plus software required to operate the system. Excludes reinstatement of
the building and any associated environmental systems.

UTC                                                                            1         30,000           30,000
UTMC common database                                                           1         20,000           20,000
RTPI central server                                                            1         30,000           30,000
RTPI bus depot computer instation                                              1         20,000           20,000
ANPR                                                                           1         10,000           10,000
VMS                                                                            1         10,000           10,000

Other Assets

Other assets which are not detailed above                                                                 50,000
The details of which will be calculated separately


GROSS REPLACEMENT COST (GRC)                                                                           9,760,000