The URL can be used to link to this page

Home My WebLink About181494 01/20/2010 CITY OF CARMEL, INDIANA VENDOR: 359662 Page 1 of 1 ONE CIVIC SQUARE A T T CUSTOM WORK ORDER CENTER !s t s: �a CARMEL, INDIANA 46032 220 WISCONSIN AVE CHECK AMOUNT: $95,317.69 WAUKESHA WI 53186 CHECK NUMBER: 181494 CHECK DATE: 1/20/2010 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 920 4470305 CR124252 95,317.69 116 /CARMEL DR UTIL RE KD2842z9 Highway Relocation Cost Estimate Page 1 of 13 KM2842 c &t 10/12/2009 Project Number AT &T INDIANA Customer Request Number 124252 Date 10/12/2009 Customer ID 112206 Project Number 7254906 CR Description: Billing Information Billing Party's Name CITY OF CARMEL Phone (317) 571 -2438 Billing Address ONE CIVIC SQUARE CITY OF CARMEL CARMEL, IN 46032 Contact Name AMBER TOLLE /MIKE MCBRIDE Phone (317) 571 -2438 Work Description RELOCATE CROSSBOX AT INTERSECTION OF 116TH STREET AND KEYSTONE AVENUE, CARMEL, IN Engineering Remarks SUBMIT PAYMENT TO: AT &T, 220 WISCONSIN AVENUE, WAUKESHA, WI 53186. NOTE: ADDTIONAL TASKS FOR THE TEMPORARY RELOCATION. Expenses Quantity Amount Total Plant Labor: 218 17,928.51 Total Engineering Labor: 5,405.94 Material Cost 11,854.84 'Contractor Cost 60,128.40 Right Of Way Cost: 0.00 Sub -Total Estimated Costs 95,317.69 Less Plant Betterment Credits 0.00 Less OSP Depreciation Credits 0.00 Total Estimated Costs 95,317.69 OSPE Representative: KIMBERLY MARSHALL Title: AT &T MANAGER Phone 262- 970 -8424 Note: Hours are rounded to the nearest whole hour value. imniums ocfo 0 i0 ODo CITY" OF ARIVIEL _JAMES BRAINARD, 1VIAYOR May 21, 2009 Kimberly Marshall AT&T Custom Work Order Center 220 Wisconsin Avenue, Floor #2 Waukesha, WI 53186 RE: 116 Street and Keystone Parkway CWO Approval, CR# 124252 The City of Carmel is in receipt of the detailed "Cost Estimate Invoice" for the reimbursable AT &T facility relocations necessary to accommodate the City's reconstruction of the 116 Street Keystone Parkway intersection. I have reviewed the "Cost Estimate Invoice" that was sent to the Department of Engineering on May 18, 2009 in the amount of $90,110.98, and find it to be consistent with the scope of work that it defines. Therefore, with this letter the City wishes to convey its approval of, and accept responsibility for reimbursement of the costs described in the afore mentioned estimate. At this time the City requests that AT &T release this project (CR# 124252) for construction in order to facilitate a timely relocation and allow the City's interchange project to proceed as scheduled. The City also understands that there will be some additional fees associated with temporary AT &T relocations (estimated at approximately $5,000.00) at the southeast corner of the intersection near the existing apartment building. These temporary relocations are necessary in order to allow the City's road construction contractor to continue with retaining wall construction. The retaining wall construction is currently on hold due to conflicts with existing AT &T facilities. It is also the understanding of the City that AT &T is in the processing of preparing a Utility Reimbursement Agreement to submit to the City for approval in order to formalize the details of this reimbursement. I look forward to the receipt of this document and the expeditious completion of these necessary relocations. Sincerely, Michael T. McBride, P.E. Director of Engineering cc: File DEPAIITNWNT 01F ENc,INEERING ONE Civic: SQUARE. CA1.M1eL, IN 46032 OFrlc:i: 317.57 1.24 41 FAX 317.571.2439 ENIA1L en[;ineerin,g ttarmrLin.gov atsa Custom Work Order Center 220 Wisconsin Avenue, Floor #2 Waukesha, WI 53186 PHONE (888) 901 -2779 FAX (888) 901 -2821 DATE: 10/12/09 TO: City Of Carmel PHONE: 317 571 2438 ATTN: Michael McBride FAX: 317 571 2439 FROM: Kimberly Marshall PHONE: 888 521 3740 RE: CR# 124252 LEGAL MANDATE Project# 7254906 Job# Requesting relocate fiber crossbox and temporary relocation costs Location 116` Street and Keystone Avenue Carmel, IN NOTE: Enclosed is the "Cost Estimate Invoice." AT &T must receive a signed contract or a letter of approval to start construction. Please assign the CR# 124252 on your correspondence. When Project is complete a final invoice will be prepared. Please mail payment to the above address. If you have any questions, please feel free to contact me. Thank You, CWO Manager Customer Contract Specialist CM2842 Highway Relocation Cost Estimate Page 2 /2 13 KM2842 10/12/2009 Project Number AT &T INDIANA Detail Material Report Customer Request Number: 124252 Date 10/12/2009 CR Name RELOCATE CROSSBOX Project Number: 7254906 Customer Name CITY OF CARMEL Material Placed Reference Number Material Quantity Cost Per Unit Unit Total 0001994693 1- PC -4 -C 42 0.83 FT 34.69 0001994696 1- PC -4 -C 14 0.83 FT 11.56 0001994698 1- PC -4 -C 16 0.83 FT 13.21 0001994868 1- PC -4 -C 20 0.83 FT 16.52 0001994873 1- PC -4 -C 6 0.83 FT 4.96 0001994876 1- PC -4 -C 75 0.83 FT 61.94 0001994887 1- PC -4 -C 534 0.83 FT 441.03 0001994890 1- PC -4 -C 30 0.83 FT 24.78 0002032236 5092MT -024 353 0.31 FT 109.54 0002032238 ANMW -600 271 6.29 ET 1,703.55 0002032331 ANMW -600 44 6.29 FT 276.59 0002032333 ANMW -900 124 9.59 FT 1,189.08 0002032347 ANMW -300 55 3.25 FT 178.92 0'002033516 ANMw -300 55 3.25 FT 178.92 0002034765 BXCNNL2700 1 2,765.02 FT 2,765.02 0002039455 ANMW -900 145 9.59 FT 1,390.46 0002039469 BEGNNSM *14 1 139.62 FT 139.62 Sub -Total Material Cost 8,540.39 Exempt Material Overhead 3,314.45 Total Material Cost 11.854.84 CDSR0024 Page 3 of 13 KM2842 cat &t Highway Relocation Cost Estimate 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL Depreciation (Material Removed) 'Reference Number Material Quantity Cost Per Unit Unit Total 0001994900 11- PC -4 -C 100 8.20 FT 820.15 0001994901 11- 12C -4 -C 245 8.20 FT 2,009.37 0001994902 2- PC -4 -C 40 8.20 FT 328.06 0001994903 11- PC -4 -C 14 8.20 FT 114.82 0001994904 2- PC -4 -C 244 8.20 FT 2,001.17 0001994905 2- PC -4 -C 90 8.20 FT 738.14 0001994906 2- PC -4 -C 87 8.20 FT 713.53 0001994907 1- PC -4 -C 15 8.20 FT 123.02 0001994908 1- PC -4 -C 20 8.20 FT 164.03 0001994909 2- PC -4 -C 30 8.20 FT 246.05 0001994911 1- PC -4 -C 12 8.20 FT 98.42 0002033688 ANMW -300 480 10.76 FT 5,165.86 Detail Contractor Report Customer Request Number: 124252 Date 10/12/2009 CR Name RELOCATE CROSSBOX Project Number: 7254906 Customer Name CITY OF CARMEL Contractor Cost Reference Number FTI Description Quantity Total 0001994694 TRENCH PLACE ONE ITEM BY BACKHOE 21 106.68 13 TO 24 IN. WIDTH 0001994695 PLACE ADDITIONAL ITEM IN OPEN TRENCH 21 13.65 (NOT IN IBPLACE ADDITIO 0001994697 TRENCH PLACE ONE ITEM BY BACKHOE 14 51.52 UP TO 12 IN. WIDTH 0001994699 TRENCH PLACE ONE ITEM BY BACKHOE 16 58.88 UP TO 12 IN. WIDTH 0001994701 TRENCH PLACE ONE ITEM BY BACKHOE 14 71.12 13 TO 24 IN. WIDTH 0001994702 PLACE ADDITIONAL ITEM IN OPEN TRENCH 28 18.20 (NOT IN IBPLACE ADDITIO 0001994869 TRENCH PLACE ONE ITEM BY BACKHOE 5 25.40 13 TO 24 IN. WIDTH 0001994870 BACKHOE WIDTH ADDITIONAL 12 IN. 5 8.40 KM284224 Highway Relocation Cost Estimate Page 4 of 13 KM2892 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL WIDTH INCREMENT OVER 24 IN 0001994871 BACKHOE DEPTH ADDITIONAL 12 IN. X 15 36.75 12 IN. DEPTH INCREMENT B 0001994872 PLACE ADDITIONAL ITEM IN OPEN TRENCH 15 9.75 (NOT IN IBPLACE ADDITIO 0001994874 TRENCH PLACE ONE ITEM BY BACKHOE 6 22.08 UP TO 12 IN. WIDTH 0001994875 BACKHOE DEPTH ADDITIONAL 12 IN. X 6 14.70 12 IN. DEPTH INCREMENT B 0001994877 BORE PLACE HDPE TWO 4 IN. PIPE 25 450.00 1 -100 FT DIRT 0001994878 PLACE HDPE ADDITIONAL 4 IN. IN BORE 25 225.00 1 -100 FT DIRT 0001994879 TRENCH PLACE ONE ITEM BY BACKHOE 42 154.56 UP TO 12 IN. WIDTH 0001994880 PLACE PEDESTAL /APP CASE DIRT 12 1 75.00 IN. AND OVER IN CONJUN 0001994881 POUR -IN -PLACE CABINET PAD DIRT W 84 2,940.00 OR W/0 TEMPLATE (SAT /F 0001994882 PLACE VRAD CABINET, PAD, POWER PED 1 5,139.00 GROUND GRID DIRT 0001994883 PLACE POWER METER PEDESTAL (FREE 1 180.00 STANDING) IN CONJUNCTION 0001994884 PLACE GROUND FIELD (3 GROUND RODS 1 280.00 W /WIRE AND BONDING) DI 0001994888 BORE PLACE HDPE TWO 4 IN. PIPE 178 3,168.40 OVER 100 FT DIRT 0001994889 PLACE HDPE ADDITIONAL 4 IN. IN BORE 178 1,566.40 OVER 100 FT DIRT 0001999891 TRENCH PLACE ONE ITEM BY BACKHOE 10 50.80 13 TO 24 IN. WIDTH 0001994892 BACKHOE WIDTH ADDITIONAL 12 IN. 20 33.60 WIDTH INCREMENT OVER 24 IN 0001994893 BACKHOE DEPTH ADDITIONAL 12 IN. X 80 196.00 12 IN. DEPTH INCREMENT B 0001994894 PLACE ADDITIONAL ITEM IN OPEN TRENCH 20 13.00 (NOT IN IBPLACE ADDITIO 0001994895 PREMIUM GRANULAR PER YARD 7 189.00 24 Highway Relocation Cost Estimate Page 5 of 13 KM2842 KM2892 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL 0001994896 CORE DRILLING TO ACCEPT UP TO 4 IN. 1 300.00 PIPE INITIAL IN CONJ 0001994897 CORE DRILLING TO ACCEPT UP TO 4 IN. 2 260.00 PIPE ADDITIONAL IN C 0001994898 PLUG DUCTS UP TO 6 EACH IN 1 50.00 CONJUNCTION WITH OTHER WORK 0001994912 REMOVE PG /FIBER CABINET (INCLUDES 1 525.00 PAD) IN CONJUNCTION WITH 0001994913 EXTRA COSTS 250 250.00 0001995000 EXTRA COSTS 32216 32,216.00 0002032234 PLACE TWO (2) ITEMS NO RODDING 240 300.00 REQUIRED 1 -1000 FT PER DU 0002032235 PLACE ONE (1) ITEM NO RODDING 353 345.94 REQUIRED 1 -1000 FT PER DUC 0002032237 PLACE ONE (1) ITEM NO RODDING 271 265.58 REQUIRED 1 -1000 FT PER DUC 0002032330 PLACE ONE (1) ITEM NO RODDING 44 43.12 REQUIRED 1 -1000 FT PER DUC 0002032332 PLACE ONE (1) ITEM NO RODDING 124 121.52 REQUIRED 1 -1000 FT PER DUC 0002032346 PLACE ONE (1) ITEM NO RODDING 55 53.90 REQUIRED 1 -1000 FT PER DUC 0002033467 REMOVE FIBER CABLE PLACE PULL 495 396.00 ROPE /TAPE 1 -1000 FT 0002033469 REMOVE COPPER CABLE 2 IN. O.D. 430 709.50 PLACE PULL ROPE /TAPE 1 -1 0002033500 HAND DIG PIT EXISTING CABLE UP TO 1 640.00 36 CUBIC FEET (4 FT.W X 0002033501 PLACE PEDESTAL /APP CASE DIRT UP 1 31.00 TO 10 IN. IN CONJUNCTI 0002033513 PLACE PEDESTAL /APP CASE DIRT 12 1 75.00 IN. AND OVER IN CONJUN 0002033514 HAND DIG PIT EXISTING CABLE UP TO 1 640.00 36 CUBIC FEET (4 FT.W X 0002033515 BORE PLACE ONE CABLE OR INNERDUCT 240 1,308.00 0 IBORE PLACE ONE CAB 0002033517 PLACE ONE (1) ITEM NO RODDING 55 53.90 REQUIRED 1 -1000 FT PER DUC CDSR0029 Page 6 of 13 KM2842 cat &t Highway Relocation Cost Estimate 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL 0002033518 PLACE SAI, APP CASE OR NEUTRALIZER 1 275.00 CABINET (EXCLUDES PAD) 0002033684 REMOVE COPPER CABLE 2 IN. O.D. 42 69.30 PLACE PULL ROPE /TAPE 1 -1 0002033685 REMOVE PEDESTAL /APP CASE 12 IN. AND 1 120.00 OVER IN CONJUNCTION 0002033686 REMOVE COPPER CABLE 2 IN. 0.D. 170 280.50 PLACE PULL ROPE /TAPE 1 -1 0002033687 REMOVE PEDESTAL /APP CASE 12 IN. AND 1 120.00 OVER IN CONJUNCTION 0002033692 HAND DIG PIT EXISTING CABLE UP TO 1 640.00 36 CUBIC FEET (4 FT.W X 0002033693 PLACE PEDESTAL /APP CASE DIRT UP 1 31.00 TO 10 IN. IN CONJUNCTI 0002033694 PLACE DROP OR WIRE 18 INCH DEPTH 110 88.00 FIRST 100 FT IN DIRT IN 0002033695 ADDER PLACE DROP OR WIRE 18 INCH 110 82.50 DEPTH FOOTAGE AFTER 0002033696 ADDITONAL DROP OR WIRE IN SAME TRENCH 110 66.00 0002033697 TRENCH PLACE ONE ITEM BY BACKHOE 250 895.00 UP TO 12 IN. WIDTH 0002033698 PLACE ADDITIONAL ITEM IN OPEN TRENCH 125 81.25 (NOT IN IBPLACE ADDITIO 0002033699 REMOVE PEDESTAL /APP CASE 12 IN. AND 1 120.00 OVER IN CONJUNCTION 0002034551 PLACE ONE (1) ITEM NO RODDING 55 53.90 REQUIRED 1 -1000 FT PER DUC 0002034588 BORE PLACE ONE CABLE OR INNERDUCT 195 1,062.75 0 IBORE PLACE ONE CAB 0002034592 REMOVE SAT, APP CASE OR NEUTRALIZER 1 1,600.00 CABINET (INCLUDES PAD) 0002034640 REMOVE COPPER CABLE 2 IN. 0.D. 24 39.60 PLACE PULL ROPE /TAPE 1 -1 0002034641 REMOVE COPPER CABLE 2 IN. O.D. 65 107.25 PLACE PULL ROPE /TAPE 1 -1 0002034642 PLACE DROP OR WIRE 18 INCH DEPTH 100 80.00 FIRST 100 FT IN DIRT IN 0002034649 ADDER PLACE DROP OR WIRE 18 INCH 10 7.50 24 Highway Relocation Cost Estimate Page 7 of 13 KM2842 KM2842 CLRI 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL DEPTH FOOTAGE AFTER 0002034703 PLACE PEDESTAL /APP CASE DIRT UP 1 31.00 TO 10 IN. IN CONJUNCTI 0002039454 TRENCH PLACE ONE ITEM BY BACKHOE 125 447.50 UP TO 12 IN. WIDTH 0002039468 REMOVE PEDESTAL /APP CASE 12 IN. AND 1 120.00 OVER IN CONJUNCTION 0002039472 REMOVE PEDESTAL /APP CASE UP TO 10 1 28.00 IN. IN CONJUNCTION WIT Total Contractor Cost 60,128.40 Detail Labor Report Customer Request Number: 124252 Date 10/12/2009 CR Name RELOCATE CROSSBOX Project Number: 7254906 Customer Name CITY OF CARMEL Engineering Labor Qty Rate Amount CDSR0024 Page 8 of 13 KM2842 .dtA Highway Relocation Cost Estimate g 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL Engineering Labor Qty Rate Amount Placement Direct Cost Salary Wages Dir Eng Labor 23 S 20.85 .4 7.naa QS Dir Eng Other 23 S 1.96 s as 12 Benefits Benefits (Clearances) 23 S 0_23 S 6.2(1 Payroll Taxes (Clearances) 23 S 0.98 s 1 Rn Operating Expenses Eng G &S Labor (Capital) 23 S 11.32 S ?SF Eng G &S Other (Capital) 23 S 0.71 S 1S QR Asi Staff Loading Asi G &S Eng (Capital) 23 S 18.99 S 477 45 Direct Cost Totals 23 $121.26 2,796.98 Indirect Cost Corporate Loadings Executive (Capital) 23 5 3.71 4 15 2R Planning (Capital) 23 S 0_52 S 1'Z 2R Accounting Finance (Capital) 23 S 3.52 S An Al External Relations (Capital) 23 S 11_nn s n nn Human Resources (Capital) 23 3 4.68 S 14S 24 Information Management (Capital) 23 S 73.66 R Fa 11 Legal (Capital) 23 S 2.74 S F1 F Procurement (Capital) 23 S 1.52 S '2a 2 1 Research Development (Capital) 23 5 (1.30 s n nn Other General. Administrative (Capital) 23 S 8.35 s 19Q 71 Indirect Cost Totals 23 51.34 1,155.61 Placement Totals 23 $175.60 3,952.59 CDSRoo24 Highway Relocation Cost Estimate Page 9 of 13 KM2842 t CC 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL Engineering Labor Qty Rate Amount Rearrangement and Maintenance Direct Cost Salary wages Dir Eng Labor 0 S 90 -85 fi 7 74 Dir Eng Other 0 S 1 96 fi n 71 Benefits Benefits (Clearances) 0 S 0.25 4 n.n Payroll Taxes (Clearances) 0 8 0.07 4 0 n1 Direct Cost Totals 0 93.13 9.98 Indirect Cost Corporate Loadings Executive (Expense) 0 S 0-63 .4 n 07 Planning (Expense) 0 5 0 -54 4 n 0 Accounting Finance (Expense) 0 8 3.].9 5 0 44 External Relations (Expense) 0 8 0.00 S n nn Human Resources (Expense) 0 8 4.16 5 n aH Information Management (Expense) 0 S 25.46 fi 2 77 Legal (Expense) 0 8 2.43 fi n 7 Procurement (Expense) 0 8 1.35 fi n 14 Research Development (Expense) 0 5 0.00 s n nn Other General Administrative (Expense) 0 8 7.87 s n R4 Indirect Cost Totals 0 45.63 4.89 Rearrangement and Mainte Totals 0 $138.76 14.87 KM284229 Highway Relocation Cost Estimate Page 10 of 13 KM2892 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL Engineering Labor Qty Rate Amount Removal Direct Cost Salary Wages Dir Eng Labor 8 S 90.85 S 744 77 Dir Eng Other 8 S 1.96 s 1 n ti Benefits Benefits (Clearances) 8 S n.28 S 7 70 Payroll Taxes (Clearances) 8 8 0.08 S n tiF Operating Expenses Eng G &S Labor (Capital) 8 8 11.19 S 02 '10 Eng G &S Other (Capital) 8 S 0.71 S 5 07 Asi Staff Loading Asi G &S Eng (Capital) 8 8 18.00 S 175 56 Direct Cost Totals 8 $124.26 1,017.91 Indirect Cost Corporate Loadings Executive (Capital) 8 8 n.71 s 5 09 Planning (Capital) 8 8 0.50 0 a 02 Accounting Finance (Capital) 8 S 3.50 .4 70 41 External Relations (Capital) 8 S 0.00 s n nn Human Resources (Capital) 8 S 4.80 s `10 05 Information Management (Capital) 8 S 28.66 s 724 70 Legal (Capital) 8 S 2.74 s 9? 45 Procurement (Capital) 8 S 1.52 s 17 SR Research Development (Capital) 8 S n.nn 0 n nn Other General Administrative (Capital) 8 8 8.8.5 S 7, 5n Indirect Cost Totals 8 51.34 420.57 Removal Totals 8 $175.60 1,438.48 CDSR0024 Highway Relocation Cost Estimate Page 11 of 13 KM2842 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 Date 10/12/2009 CR Name RELOCATE CROSSBOX Project Number: 7254906 Customer Name CITY OF CARMEL Plant Labor Qty Rate Amount Placement Direct Cost Salary Wages Dir Plnt Lab 173 S 36.79 S 6.262 77 Dir Plnt Othe 173 S 1.17 .4 7n7 29 Benefits Benefits (Clearances) 173 10.54 4 1.922.1 Payroll Taxes (Clearances) 173 8 3.1.6 S 54(1 F Operating Expenses Plant G &S Lab (Capital) 173 S 2.24 S 2(1 a(1 Plant G &S Oth (Capital) 173 S 2.32 R ant -n Asa. Staff Loading Asi G &S Pint (Capital) 173 S 0.90 S 169 29 Direct Cost Totals 173 57.02 9,863.06 Indirect Cost Indirect Expense Nantf G &S Lab (Capital) 173 S 0.00 S n nn Nantf G &S Oth (Capital) 173 8 0.00 S n nn Reg Travel Time G &S Labor (Capital) 173 S 0.00 S n nn Reg Travel Time G &S Other (Capital) 173 S 0.00 S n nn Asi Nantf G &S Other (Capital) 173 S 0.00 4 n nn Asi Reg Travl G &S Other (Capital) 173 S 0.00 fi n nn Corporate Loadings Executive (Capital) 173 S 0.27 fi• 46 7n Planning (Capital) 173 S 0.23 .4 29 7R Accounting Finance (Capital) 173 S 1.37 s 22(1 9R External Relations (Capital) 173 S 0.00 s n nn Human Resources (Capital) 173 8 1.79 S 209 tin Information Management (Capital) 173 S 10.93 S 1_94n 47 Legal (Capital) 173 S 1.04 S 179 R9 Procurement (Capital) 173 S 0.58 4 Inn 42 Research Development (Capital) 173 S 0.00 S n nn Other General Administrative (Capital) 173 S 3.38 S 5f14 FF Overhead Investment Related Cost Other Work Equip 173 S 2.40 S 415 14 Plant My 173 S 2.92 S 5n5 09 Pool My 173 S 0.24 s 41 51 Indirect Cost Totals 173 25.15 4,350.33 Placement Totals 173 82.17 14,213.39 CDSP.0024 Page 12 of 13 KM2a42 Highway Relocation Cost Estimate 10/12/2009 e Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL Plant Labor Qty Rate Amount Rearrangement and Maintenance Direct Cost Salary Wages Dir Pint Lab 3 S 36.79 8 q1 02 Dir Plnt Othe 3 0 1 -17 0 9 an Benefits Benefits (Clearances) 3 S 9.93 S 2a R? Payroll Taxes (Clearances) 3 S 2.98 s 7 a Direct Cost Totals 3 50.87 127.18 Indirect Cost Corporate Loadings Executive (Expense) 3 0 n -26 0 n 00 Planning (Expense) 3 0 0.21 s n 52 Accounting Finance (Expense) 3 0 1.20 0 2 72 External Relations (Expense) 3 8 0.00 s n nn Human Resources (Expense) 3 S 1.69 8 a 2"2 Information Management (Expense) 3 S 10.31 8 20 "72 Legal (Expense) 3 S 0.98 S 9 1 Procurement (Expense) 3 S 0.55 S 1 22 Research Development (Expense) 3 0 0.90 8 n nn Other General Administrative (Expense) 3 S 3.1.9 8 7 72 Overhead Investment Related Cost Other Work Equip 3 S 2.49 8 ti nn Plant NIv 3 S 2.92 S 7 2n Pool My 3 8 0.24 G n Fn Indirect Cost Totals 3 24.01 60.10 Rearrangement and Mainte Totals 3 74.91 187.28 w Highway Relocation Cost Estimate Page 13 of 13 KM2842 KM2842w 10/12/2009 Project Number AT &T INDIANA Customer Request Number: 124252 CR Name RELOCATE CROSSBOX Customer Name CITY OF CARMEL Plant Labor Qty Rate Amount Removal Direct Cost Salary Wages Dir Pint Lab 43 S 36.79 S 1 .57Q 57 Dir Pint Othe 43 S 1.17 fi 5n 77 Benefits Benefits (Clearances) 43 S 101.54 4 452 57 Payroll Taxes (Clearances) 93 S 3.16 4 175 fi Operating Expenses Plant G &S Lab (Capital) 43 S 2.24 S 06 17 Plant G &S Oth (Capital) 43 S 2.32 S 70 6 1 Asi Staff Loading Asi G &S Pint (Capital) 43 S O.RO 6 74 75 Direct Cost Totals 43 57.02 2,448.06 Indirect Cost Indirect Expense Nantf G &S Lab (Capital) 43 S 0.00 S n nn Nantf G &S Oth (Capital) 43 S 0.00 S n nn Reg Travel Time G &S Labor (Capital) 43 S 0.00 S n no Reg Travel Time G &S Other (Capital) 43 S 0.00 S n nn Asi Nantf G &S Other (Capital) 43 S 01.00 S n nn Asi Reg Travl G&S Other (Capital) 43 S 0.00 s n nn Corporate Loadings Executive (Capital) 93 S 0.27 R 11 52 Planning (Capital) 43 S 0.23 S 2 67 Accounting Finance (Capital) 43 S 1.37 S 5A 62 External Relations (Capital) 43 S 0.00 R n nn Human Resources (Capital) 43 S 1.74 S 76 65 Information Management (Capital) 93 S 10.93 S 4fia 7 6 Legal (Capital) 43 S 1.04 S 44 fi5 Procurement (Capital) 43 S 0_5R 0 74 an Research Development (Capital) 43 S 0.00 4 n nn Other General Administrative (Capital) 43 S 3.38 S 145 11 Overhead Investment Related Cost Other Work Equip 43 S 2.40 S 177 74 Plant My 43 S 2.92 4 125 77 Pool My 43 S 0.24 S 1n 7n Indirect Cost Totals 43 25.15 1,079.78 Removal Totals 43 82.17 3,527.84 Prescribed by State Board of Accounts City Form No 201 (Rev. 1995) ACCOUNTS PAYABLE VOUCHER CITY OF CARMEL An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc. Payee AT &T Purchase Order No. NA 220 Wisconsin Avenue, Floor #2 Terms Waukesha WI 53186 Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 10/12/09 CR124252 Keystone Reconstruction Project $95,317.69 116th Street Crossbox Relocation Project 07 -08 Total $95,317.69 I hereby certify that the attached invoice(s), or bills(s), is (are) true and correct and I have audited same in accordance I with IC 5- 11- 10 -1.6. 20 Clerk- Treasurer P VOUCHER NO. WARRANT NO. AT &T ALLOWED 20 220 Wisconsin Avenue, Floor #2 IN THE SUM OF Waukesha WI 53186 95,317.69 ON ACCOUNT OF APPROPRIATION FOR AT&T tO)jiy_ PO# or INVOICE NO. ACCT /TITLE AMOUNT Board Members DEPT.# NA l j I 4,253) 4470305 $95,317.69 I hereby certify that the attched invoice(s), or bill(s) is (are) true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except January 19, 20 10 Total $95,317.69 Signature Cost distribution ledger classification if City Engineer claim paid motor vehicle highway fund Title