Devonshire 1-CS130201 T H E • C 1 T Y • O F
CÔFFELI
F R A;5.� , is 9
MEMORANDUM
TO: Jennifer Miller, Director of Finance
FROM: Ken Griffin, P. E., Director of Engineering and Public Works
DATE: February 1,2013
REF: Escrow#12 for Coppell Road (ST00-03)
On January 9, 1991, Pulte Homes escrowed $72,990.00 to the City of Coppell for the future
construction of Coppell Road adjacent to Devonshire. On June 24, 2003, the City of Coppell
awarded a design contract to Huitt-Zollars, Inc. in the amount of $200,000.00. And, on April 8,
2008, the City of Coppell awarded a construction contract to Tieso Paving in the amount of
$3,057,846.30.
The original escrow amount was based on a fee of$100 per adjacent front foot. Devonshire has
729.90 feet adjacent to Coppell Road. Therefore, the escrow amount of$72,990 was arrived at by
multiplying the adjacent front foot times $100.00(729.90 x 100= $72,990).
The front foot cost is made up of several cost components. Those are: excavation; subgrade
preparation; lime; paving; sidewalk; drainage; incidentals; and engineering. The final construction
cost of the project was $2,966,679.36 (a slight savings). Of that amount, $380,682.90 was for a
new water line. Therefore, the total construction cost to be apportioned to the adjacent property is
$2,585,996.60. In addition to that, the engineering cost $191,023.90. The percentage of the water
line cost versus the total project cost is 12.83% (380,023.90/2,966,679.36). Therefore, 12.83% of
the engineering cost was deleted making the engineering cost associated with the paving
$166,511.80 (191,023.90 - .1283 x 191,023.90).
The question has been raised as to whether or not the original escrow would have exceeded the cost
to design and construct the road if the construction had been performed in a timelier manner. To try
to determine the effect of the time delay on the cost, I reviewed the consumer price index (CPI) and
the producer price index (PPI) from the time the escrow was placed with the city until such time as
the city let a design and a construction contract. The CPI was used for the design since it's a service
and the PPI was used for the construction since a large component of any construction cost is the
actual supplying of materials.
A to Z Index 1 FAQs 1 About BLS 1 Contact Us Subscribe to E-mail Updates GO
Follow Us ) I What's New I Release Calendar I Site Map
Search BLS.gov L
Home I Subject Areas Databases&Tools Publications I Economic Releases I Beta
Databases, Tables & Calculators by Subject FONT SIZE: _
•
Change Output Options: From: 1989 To: 2010
include graphs
More Formatting Options
Data extracted on: May 1,2013(11:38:43 AM)
Producer Price Index Industry Data
Series Id: NDUBHWY--BHWY--
Industry: Material and supply inputs to highway and street construction
Product: Material and supply inputs to highway and street construction
Base Date: 198606
250-
6 200- f'At/
7
x150-
r.�.�`�--�Y'Y"��..
100-
1989 1991 1993 1995 1997 1999 2001 2003 2005 2007 2009
Month
Download: iJJ .xls
Year Jan ; Feb Mar Apr • May Jun Jul Aug Sep ` Oct 11, Nov Dec .Annual
19891105.0 1 105.41 105.9 107.4' 108.1!107.8; 107.4 106.7`107.2!107.6;107.5 107.4 L 107.0
19901109.4 108.4 j 108.2 108.4:108.6 108.4 l 108.3 110.4 113.1 115.9,114.2 110.7
1991,113.3112.0110.3110.1
i ' 110.5� 1104109.9;110.3 110.4 110.1 1102109.3- 110.6
1992,108.81 109.1 109.3 109.4; 109.9;110.51110.4,110.4 110.6 110.5 110.6 110.1 110.0
;1993.11041107111.2 111.7, 112.0 112.1 111.81 111.7 112.1 1126;1125 111.7 111.7
1994 112.1 112.7112.8'113.2! 113.51114.1! 114.8 115.7115.5! 115.3' 115.9115.6 114.3
119951116.5; 1168'!117.1 118.5 119.0 j 119.3 118.9 119.0 119.2 118.7 118.7 119.11 118.4
19961 119.9 119.8 120.6. 122.0!122.6 122.0 122.0 122.3!123.0 123.5 123.87,124.0 122.1
1997 124.6 j 124.7 124.2 124.3 1 124.5 124.4 124.2 1 124.9,125.0 124.9 124.9 124.3 124.6
,1998; 123.8; 123.4' 123.0 123.6'124.0 123.9 1 124.0 123.4`123.6;123.6 123.3 122.3 123.5
1999! 122.8;122.6 123.3 125.4 125.9 126.0 126.9 128.1 129.0 128.8 129.6 130.7 126.6
2000 132.0 134.0 136.0!135.6 135.8 137.6 137.1 136.6 138.9 138.5! 138.4, 137.3 136.5
2001±137.8 138.2 137.4 138.5 139.9.138.8_136.6.137.0 138.4,135.4_134.1 1 132.4 137.0
Year ; Jan ' Feb Mar Apr May Jun Jul Aug Sep Oct Nov ' Dec I Annual
- L
2002 j 132.9 132.4 132.7 133.3 133.8 133.9 134.1 134.2!134.4 134.4 133.9 133.7 133.7
20031134.7 135.7! 136.8 137.1 137.0 136.9 136.7 136.9 136.8 136.7,137.1 137.2 1 136.6
!2004 i 140.5 i 141.2 i 142.5 i 145.2 147.9 i 147.0;149.2 i 150.5 151.8 155.5.155.4;152.0, 148.2
2005, 154.3 156.5 160.4 162.9-162.4 1 163 7 167.6 170.0 j 176.1 180.8 173.1 i 173.4 166.8
2006 177.5 175.9 179.4 185.4 187.9'190.4 191.8 192.9 185.9 183.2 182.9 184.1 184.8
2007 183.1 185.2. 190.0 194.6 197.6 196.8 200.0 195.9 197.5 197.5 204.9!202.7 195.5
2008 204.7 205.9.213.8 218.5 227.3 i 234.4 243.5 239.3 241.1'226.9!212.0 201.5 222.4 •
2009 1 202.9 199.3 198.2 200.8 204.1 ;208.7 i 206 1 209.0 208.1 207.5 209.5 209.3 205.3
2010 212.6 211.6 215.0 217.5 218.9 217.1
TOOLS CALCULATORS HELP INFO RESOURCES
Areas at a Glance Inflation Help&Tutorials What's New Inspector General(OIG)
Industries at a Glance Location Quotient FAQs Careers @ BLS Budget and Performance
Economic Releases Injury And Illness Glossary Find It!DOL No Fear Act
Databases&Tables About BLS Join our Mailing Lists USA.gov
Maps Contact Us Linking&Copyright Info Benefits.gov
Disability-gov
Freedom of Information Act I Privacy&Security Statement I Disclaimers I Customer Survey I Important Web Site Notices
U.S.Bureau of Labor Statistics I Postal Square Building,2 Massachusetts Avenue,NE Washington,DC 20212-0001
www.bls.gov I Telephone: 1-202-691-5200 I TDD: 1-800-877-8339 I Contact Us
a4°I1
O O p O O O O \ O O O O O O O O O O O O O O O O O O O O
CA vi r r 0o C1 N` b 1 iA 00 t` N: 40 C1 N 1n M O 7 7 - 0 l 't 4/ ti .i z bA
. Q e KM .y N N N rl' 7 N N N N N 4 4 N 4 M .-i N 4 M N .� rh Q G M N O
a
a
2 t o g ' e o 0 0 0 0 o a o o � ' o o a o 0 0 0 0 0 � v
N N N 0\ 00 VD 00 O ti N M ti t: o co N o0 N M M 7 M M 00 O O 0. d
* 1; 44 C Tr N N N N e+1 N N M ,-I C 4 7 N 4 H N 4 C `d' ,4 4 C 4 ,-1 Z"
..
_ j
c M N 0, 0, — .) — 00 01 M N C\ 00 4. O l� 4 0- N N• N " 4014N M N .M-.
4 06 C\ \0 a1 vi O M N ,-. �t 00 -. M 00 d' 0 N \0 06 ' O N t` VI \0 01 N Q O O
Q 0 0 0 " " " N M M M f 7 7 h n vi 0- N N N OO cp, p, 888 N N Z C N
N N N NN )I b
. ,-.
0
V 4 00 M C1 N 41 V O \O 00 01 v1 O 41 g 7�
W N 01 Cr: M N O 00 N 4 00 .. v) O N 0 Q
= 00 O ,~. " ,N. ,N. ,M. * ,M. —. - ,,4/ 441 O
vi EW
›' p ,--100 N \0 C1 01 00 d; v1 V01 \00 000 0 Q
X001 .-+ No,
Z � e "0 N� NNN0000 000 \00 ,-• o1N U �
-. .-. ,� -. ,� — C 000 0
N N N N N F
[ , M o. 0..„. v1 .. „ ,. . ..0 N o0 .,,
( \0 01 64r-: —. o;,. m1/460,; (-4 ,46 O N
000 -. ,N. ,N-+ .M. M M Ct - V1 v1
N M N N 441M
Fy v1 00 01 0o N O N 01 0400000 v1 M
00 0 00 00 N O
Uj kr)i '0 N N N N 000 00 V1 0.,
N N N NN
41 L ,i O u ,-. v1 v1 N O O ,--i 7 -. N ,-• v1 N
v 0; O c N, O \O -. 7 06 N vi 01 -.
m D mO 11 Q 00 -. ,-. N N M M M �t4 441/
a, � 3 .� — � —, � � � � r. - - - -
d 4
X00
eUo .ocg a \0M MN 0N.0
N M N v� a1 v1 ,--� M 00 ,-. m N N S
y p v, .-I 0 N b a\ 7 N V \0 N \O N
C ..r h v1 '0 N� IN N, .N. 00 O\ ' O O co O ~ �.
O O
7. %C ,-. ~ ~ ,-. ~ ~ * N N N N N O y
_ O
00 M 01 C1 \O O 00 " N N V d' 71' 4. .4 U
M 00 O1 N N O M O 7 ,-• 4 o1 �--, 6' `'
. 0 O ,-. " N N M M M44 4V1
'T4 H
"0 0 y0
01S " 00,. '1- \0 L' 0 t,
O N N "I' O1 O1 -. v1 N N— v1 0 CAN 0 0 0
Q M S C/ O1 N 'O 01 M ,--+ (� M M ,-' NN .O
X v1 v1 VO VD N N� N� oo C1 N N 01 N 00 N_ 0 E
,-, ,-. ,-, ,-. ,--i ,--i ,-, ,--, ,-. C1 O 01 0 O 0 .ti 4)
" N " N N N ,5 r,.
° z
g M O 00 N V N C1 4/1 V1 O M O v1 \0 0\ 0d
01 -0 d M 0 N � 00 N D1 N N O v0 O - -0- - - — —
, ,..0 -
\0 \0 01 N N 0O h C
g O 7 -, C\ ,-. 00 N- M Nt 41 C> M 00 \O ,--i \0 i+ . .'�'..,
'. 41 O a\ 01 \O 0: &
X 411 4111 \MO \00 Cl N N 00 000 O 00 O ,-. \0 N \0 N C. 0
/-. ,-. r, ,-. ,. .. .-. ,-. ,-. ,-. o' O1 0 0 N N N C .m 4
$., O 0
O 1.,
N
lti a m O1 N \O 01 O v1 N 4 44N M N S
w N \0 664r- N C N v1 O1 M \C O 1~ H
,N-+ ,M-. ,M. ,M� ,7r. ,7h-, .tr). 0 0 0 00
o
.-, 0 M \O O N O 1/40010- NO 00 � N l00 d ." 0
Q7 N
ti v1 v1 \0 \0 ON N N 00 00 00 N� 00 N M o1 M V E
— ,-. -. . . . . . ,-, 00 C\ 01 O O O ,-.
N N N N I 0 O
N c. O z
1 of V1 t` 00 CA CD N M7w \D N 00 O ry NM 4 V) N00 O tiNM
›-IM ID
00 00 00 00 00 00 C1 C1 01 C\ C1 C1 C\ C1 C1 C1 O O O O O O O O O O .-1 H ,-1 " id N
W C1 C1 C1 C1 C1 01 C1 C1 C1 C1 C1 C1 C1 C1 C\ C1 0 O O O O O O O O O O O O O () +'
y " „".i H .0 H " - . . . . . H - N 4.0 N N N N N N N N N N N N N N ,, 0 O1