Cost load an XER project file using the cost from SOV file , both files are attached on here but key note don't change logic or dates on the baseline schedule .
Project:Boyle Heights/Cesar Chavez - Great Streets - Brittania Street to Evergreen Ave Contractor: Access Pacific, Inc. ____________________________________ ____________________________________ Owner: City of Los Angeles - BOE Submitted by Date Approved by Date
Pay Estimate Period From TO
Subcontractor Subcontract
Amount API Amount Qty Amount
Percent Complete
Qty Amount Percent
Complete Qty Amount
Percent Complete
Qty Amount Percent
Remaining
1 Mobilization Per General Requirements Sections 01292 and 01721 LS 1 PCI 6,310.00$ 316,690.00$ 323,000.00$ 2 Allowance for Differing Site Conditions (General Requirements, Sections
01212, 01253, & 01254) LS 1 20,520.00$
20,520.00$ 3 Allowance for Permits required to perform the contract work per General
Requirements, Section 01212 LS 1 10,000.00$
10,000.00$ 4 Allowance to Protect unknown and/or relocated utilities per General
Requirements, Section 01212, 01253, and 01732 LS 1 30,780.00$
30,780.00$ 5 Allowance for Additional Potholing of unknown substructures per General
Requirements, Sections 01253, 01254, and 01732 LS 1 20,520.00$
20,520.00$ 6 Worksite Temporary Traffic Control, Including Traffic Control Plans Approved
by LADOT, Signage, Temporary Striping and Restoration, and Traffic Signal Modifications LS 1
1,000,000.00$
PCI 22,200.00$ 977,800.00$ 1,000,000.00$ 7 Prepare and Implement Stormwater Pollution Prevention Plan per GR 01571
LS 1 50,000.00$
50,000.00$ Removals
8 Concrete Curb Type A LF 1281 20.00$ 25,620.00$ 9 Type C Integral Curb & Gutter LF 7174 25.00$ 179,350.00$
10 Concrete Driveway SF 6106 25.00$ 152,650.00$ 11 Concrete Intersection Gutter LF 121 50.00$ 6,050.00$ 12 Concrete Bus Pad SF 8223 25.00$ 205,575.00$ 13 Concrete Sidewalk Including Curb Ramp SF 81462 12.00$ 977,544.00$ 14 Asphalt Concrete Pavement TON 1576 200.00$ 315,200.00$ 15 Decorative Crosswalk SF 2479 20.00$ 49,580.00$ 16 Coldmilling/Grinding SF 99842 5.00$ 499,210.00$ 17 Unclassified Excavation CY 2824 200.00$ 564,800.00$
Construction 18 Crushed Miscellaneous Base CY 3229 200.00$ 645,800.00$ 19 Concrete Driveway SF 7143 25.00$ 178,575.00$ 20 Concrete Bus Pad SF 6474 25.00$ 161,850.00$ 21 Type C Integral Curb & Gutter LF 9084 100.00$ 908,400.00$ 22 Concrete Intersection Gutter LF 117 100.00$ 11,700.00$ 23 Concrete Sidewalk SF 78473 17.00$ 1,334,041.00$ 24 Curb Ramp (Including DWS) EA 57 12,000.00$ 684,000.00$ 25 Concrete Curb Type A LF 895 70.00$ 62,650.00$ 26 Asphalt Concrete Pavement TON 1425 325.00$ 463,125.00$ 27 Variable Asphalt Concrete Pavement TON 1455 375.00$ 545,625.00$ 28 Traffic: Signal, Striping, and Signage LS 1 1,550,000.00$ 1,055,304.38$ 494,695.62$ 1,550,000.00$
Traffic Signal - Cesar Chavez & Evergreen ILB 66,202.00$ 31,033.55$ 97,235.55$
TS-28.1 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.1 Pothole Utilities LS 1 2,000.00$ ILB 2,000.00$ 937.54$ 2,937.54$ TS-28.1 Install Conduit LF 70 125.00$ ILB 8,750.00$ 4,101.74$ 12,851.74$ TS-28.1 Install Pull boxes/Terminations EA 3 2,500.00$ ILB 7,500.00$ 3,515.78$ 11,015.78$ TS-28.1 Install Foundation EA 1 2,800.00$ ILB 2,800.00$ 1,312.56$ 4,112.56$ TS-28.1 Install Signal Gear EA 1 9,500.00$ ILB 9,500.00$ 4,453.32$ 13,953.32$ TS-28.1 Install Type 7 Pole EA 1 2,500.00$ ILB 2,500.00$ 1,171.93$ 3,671.93$ TS-28.1 Install Wire LS 1 2,000.00$ ILB 2,000.00$ 937.54$ 2,937.54$ TS-28.1 Install Loops EA 4 750.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.1 Turn On EA 1 1,500.00$ ILB 1,500.00$ 703.16$ 2,203.16$ TS-28.1 Restoration LS 1 3,500.00$ ILB 3,500.00$ 1,640.70$ 5,140.70$ SS-28.1 Striping Removals SF 1340 3.75$ PCI 5,025.00$ 2,355.57$ 7,380.57$ SS-28.1 Thermo Plastic Striping - 12 " SF 108 4.00$ PCI 432.00$ 202.51$ 634.51$ SS-28.1 Thermo Plastic Striping - 24" SF 1230 4.00$ PCI 4,920.00$ 2,306.35$ 7,226.35$
Traffic Signal - Cesar Chavez & Forest ILB 75,585.00$ 35,432.02$ 111,017.02$
TS-28.2 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.2 Pothole Utilities LS 1 1,500.00$ ILB 1,500.00$ 703.16$ 2,203.16$
Qty Unit Price
General
Schedule of Values
PREVIOUS PAYMENT THIS PERIOD TO DATE REMAINING
WO No. E1908099 AP JOB #: 123700
Amount SUBCONTRACT AMOUNT(S)
Bid Item Description Unit
TS-28.2 Install Conduit LF 30 125.00$ ILB 3,750.00$ 1,757.89$ 5,507.89$ TS-28.2 Install Pull boxes/Terminations EA 2 2,500.00$ ILB 5,000.00$ 2,343.85$ 7,343.85$ TS-28.2 Install Foundation EA 2 3,800.00$ ILB 7,600.00$ 3,562.66$ 11,162.66$ TS-28.2 Install 17-3-100 Pole w/ RSNS EA 1 15,000.00$ ILB 15,000.00$ 7,031.56$ 22,031.56$ TS-28.2 Install Rapid Flashing Beacon System EA 1 16,500.00$ ILB 16,500.00$ 7,734.71$ 24,234.71$ TS-28.2 Install Wire LS 1 1,700.00$ ILB 1,700.00$ 796.91$ 2,496.91$ TS-28.2 Turn On EA 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.2 Restoration EA 1 2,800.00$ ILB 2,800.00$ 1,312.56$ 4,112.56$ SS-28.2 Striping Removals SF 270 12.00$ PCI 3,240.00$ 1,518.82$ 4,758.82$ SS-28.2 Thermoplastic Striping - Red Curb SF 100 16.40$ PCI 1,640.00$ 768.78$ 2,408.78$ SS28.2 Thermoplastic Striping - 24" SF 270 4.00$ PCI 1,080.00$ 506.27$ 1,586.27$
Traffic Signal - Cesar Chavez & Mott ILB 108,198.20$ 50,720.13$ 158,918.33$
TS-28.3 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.3 Pothole Utilities LF 1 8,000.00$ ILB 8,000.00$ 3,750.16$ 11,750.16$ TS-28.3 Install Conduit LF 280 125.00$ ILB 35,000.00$ 16,406.97$ 51,406.97$ TS-28.3 Install Pull boxes/Terminations EA 7 2,500.00$ ILB 17,500.00$ 8,203.48$ 25,703.48$ TS-28.3 Install Foundation EA 1 2,800.00$ ILB 2,800.00$ 1,312.56$ 4,112.56$ TS-28.3 Install Signal Gear EA 1 5,760.00$ ILB 5,760.00$ 2,700.12$ 8,460.12$ TS-28.3 Install Type 7 Pole EA 1 2,500.00$ ILB 2,500.00$ 1,171.93$ 3,671.93$ TS-28.3 Install Wire LS 1 4,600.00$ ILB 4,600.00$ 2,156.34$ 6,756.34$ TS-28.3 Install Loops EA 4 750.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.3 Turn On EA 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.3 Restoration LF 1 5,600.00$ ILB 5,600.00$ 2,625.12$ 8,225.12$ SS-28.3 Striping Removals SF 930 4.24$ PCI 3,943.20$ 1,848.46$ 5,791.66$ SS-28.3 Thermoplastic Striping - 12" SF 60 4.00$ PCI 240.00$ 112.50$ 352.50$ SS-28.3 Thermoplastic Striping - 24" SF 870 4.00$ PCI 3,480.00$ 1,631.32$ 5,111.32$
Traffic Signal - Cesar Chavez & Fickett ILB 85,524.40$ 40,091.32$ 125,615.72$
TS-28.4 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.4 Pothole Utilities LS 1 5,000.00$ ILB 5,000.00$ 2,343.85$ 7,343.85$ TS-28.4 Install Conduit LF 130 125.00$ ILB 16,250.00$ 7,617.52$ 23,867.52$ TS-28.4 Install Pull boxes/Terminations EA 2 2,500.00$ ILB 5,000.00$ 2,343.85$ 7,343.85$ TS-28.4 Install Foundation EA 1 3,200.00$ ILB 3,200.00$ 1,500.07$ 4,700.07$ TS-28.4 Install Signal Gear LS 1 10,060.00$ ILB 10,060.00$ 4,715.83$ 14,775.83$ TS-28.4 Install Type 16-3-100 Pole EA 1 13,000.00$ ILB 13,000.00$ 6,094.02$ 19,094.02$ TS-28.4 Install Wire LS 1 3,600.00$ ILB 3,600.00$ 1,687.57$ 5,287.57$ TS-28.4 Install Loops EA 2 750.00$ ILB 1,500.00$ 703.16$ 2,203.16$ TS-28.4 Turn On EA 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.4 Restoration LS 1 5,800.00$ ILB 5,800.00$ 2,718.87$ 8,518.87$ SS-28.4 Striping Removals SF 580 6.93$ PCI 4,019.40$ 1,884.18$ 5,903.58$ SS-28.4 Thermoplastic Striping - 12" SF 40 4.00$ PCI 160.00$ 75.00$ 235.00$ SS-28.4 Thermoplastic Striping - 24" SF 540 4.00$ PCI 2,160.00$ 1,012.54$ 3,172.54$
Traffic Signal - Cesar Chavez & Mathews ILB 164,272.10$ 77,005.92$ 241,278.02$
TS-28.5 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.5 Pothole Utilities LS 1 7,800.00$ ILB 7,800.00$ 3,656.41$ 11,456.41$ TS-28.5 Install Conduit LF 240 125.00$ ILB 30,000.00$ 14,063.12$ 44,063.12$ TS-28.5 Install Pull boxes/Terminations EA 5 2,500.00$ ILB 12,500.00$ 5,859.63$ 18,359.63$ TS-28.5 Install Foundation EA 4 2,800.00$ ILB 11,200.00$ 5,250.23$ 16,450.23$ TS-28.5 Install Signal Gear LS 1 9,820.00$ ILB 9,820.00$ 4,603.33$ 14,423.33$ TS-28.5 Install Type 7 Pole EA 3 2,500.00$ ILB 7,500.00$ 3,515.78$ 11,015.78$ TS-28.5 Install Type 1 Pole EA 1 1,500.00$ ILB 1,500.00$ 703.16$ 2,203.16$ TS-28.5 Install Wire LS 1 3,300.00$ ILB 3,300.00$ 1,546.94$ 4,846.94$ TS-28.5 Install Loops EA 2 750.00$ ILB 1,500.00$ 703.16$ 2,203.16$ TS-28.5 Install Transit Loop EA 1 2,500.00$ ILB 2,500.00$ 1,171.93$ 3,671.93$ TS-28.5 Turn On EA 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.5 Restoration LS 1 5,500.00$ ILB 5,500.00$ 2,578.24$ 8,078.24$ SS-28.5 Striping Removals SF 750 5.32$ PCI 3,990.00$ 1,870.39$ 5,860.39$ SS-28.5 Red Bulb-Out SF 2266 21.35$ PCI 48,379.10$ 22,678.70$ 71,057.80$ SS-28.5 Thermoplastic Striping - 12" SF 62 4.00$ PCI 248.00$ 116.26$ 364.26$ SS-28.5 Thermoplastic Striping - 24" SF 690 4.00$ PCI 2,760.00$ 1,293.81$ 4,053.81$
Traffic Signal - Cesar Chavez & Soto ILB 255,007.68$ 119,540.09$ 374,547.77$
TS-28.6 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.6 Pothole Utilities LS 1 30,000.00$ ILB 30,000.00$ 14,063.12$ 44,063.12$ TS-28.6 Install Conduit LF 730 125.00$ ILB 91,250.00$ 42,775.31$ 134,025.31$ TS-28.6 Install Pull boxes/Terminations EA 6 2,500.00$ ILB 15,000.00$ 7,031.56$ 22,031.56$ TS-28.6 Install Foundation EA 1 2,800.00$ ILB 2,800.00$ 1,312.56$ 4,112.56$ TS-28.6 Install Signal Gear LS 1 21,130.00$ ILB 21,130.00$ 9,905.12$ 31,035.12$ TS-28.6 Install Wire LS 1 46,950.00$ ILB 46,950.00$ 22,008.78$ 68,958.78$ TS-28.6 Turn On EA 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.6 Restoration LS 1 15,000.00$ ILB 15,000.00$ 7,031.56$ 22,031.56$ SS-28.6 Striping Removals SF 2219 3.72$ PCI 8,254.68$ 3,869.55$ 12,124.23$ SS-28.6 Thermoplastic Striping - 12" SF 112 4.00$ PCI 448.00$ 210.01$ 658.01$
SS-28.6 Thermoplastic Striping - 24" SF 2100 4.00$ PCI 8,400.00$ 3,937.67$ 12,337.67$ Traffic Signal - Cesar Chavez & Breed ILB 260,570.00$ 122,147.54$ 382,717.54$
TS-28.7 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.7 Pothole Utilities LS 1 21,000.00$ ILB 21,000.00$ 9,844.18$ 30,844.18$ TS-28.7 Install Conduit LF 550 125.00$ ILB 68,750.00$ 32,227.98$ 100,977.98$ TS-28.7 Install Pull boxes/Terminations EA 6 2,500.00$ ILB 15,000.00$ 7,031.56$ 22,031.56$ TS-28.7 Install Foundation EA 6 3,100.00$ ILB 18,600.00$ 8,719.13$ 27,319.13$ TS-28.7 Install Signal Gear LS 1 61,820.00$ ILB 61,820.00$ 28,979.40$ 90,799.40$ TS-28.7 Install Type 17-3-100 Pole w/20 & 10 EA 1 15,000.00$ ILB 15,000.00$ 7,031.56$ 22,031.56$ TS-28.7 Install Type 7 Pole EA 4 2,500.00$ ILB 10,000.00$ 4,687.71$ 14,687.71$ TS-28.7 Install Type 1 Pole EA 1 1,500.00$ ILB 1,500.00$ 703.16$ 2,203.16$ TS-28.7 Install Wire LS 1 15,000.00$ ILB 15,000.00$ 7,031.56$ 22,031.56$ TS-28.7 Install Loop EA 3 750.00$ ILB 2,250.00$ 1,054.73$ 3,304.73$ TS-28.7 Install Transit Loop EA 1 2,500.00$ ILB 2,500.00$ 1,171.93$ 3,671.93$ TS-28.7 Install Bike Loop EA 2 437.50$ ILB 875.00$ 410.17$ 1,285.17$ TS-28.7 Turn On EA 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.7 Restoration LS 1 12,500.00$ ILB 12,500.00$ 5,859.63$ 18,359.63$
Traffic Signal - Cesar Chavez & St. Louis ILB 39,945.00$ 18,725.04$ 58,670.04$
TS-28.8 Mobilization LS 1 12,775.00$ ILB 12,775.00$ 5,988.54$ 18,763.54$ TS-28.8 Pothole Utilities LS 1 1,500.00$ ILB 1,500.00$ 703.16$ 2,203.16$ TS-28.8 Install Conduit LF 40 125.00$ ILB 5,000.00$ 2,343.85$ 7,343.85$ TS-28.8 Install Pull boxes/Terminations EA 1 2,500.00$ ILB 2,500.00$ 1,171.93$ 3,671.93$ TS-28.8 Install Foundation EA 1 2,800.00$ ILB 2,800.00$ 1,312.56$ 4,112.56$ TS-28.8 Install Signal Gear LS 1 7,370.00$ ILB 7,370.00$ 3,454.84$ 10,824.84$ TS-28.8 Install Type 7 Pole EA 1 1,500.00$ ILB 1,500.00$ 703.16$ 2,203.16$ TS-28.8 Install Wire LS 1 500.00$ ILB 500.00$ 234.39$ 734.39$ TS-28.8 Turn On EA 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$ TS-28.8 Restoration LS 1 3,000.00$ ILB 3,000.00$ 1,406.31$ 4,406.31$
29 Street and Pedestrian Lighting (Including Preparation and Implementation of Temporary Street Lighting System Plans Approved by BSL
LS 1 420,000.00$ ILB 299,517.00$ 120,483.00$ 420,000.00$ 29.1 Mobilization LS 1 21,033.86$ ILB 15,000.00$ 6,033.86$ 21,033.86$ 29.2 Pothole Utilities LS 1 14,022.58$ ILB 10,000.00$ 4,022.58$ 14,022.58$ 29.3 Install Conduit (Approx) LF 825 175.28$ ILB 103,125.00$ 41,482.82$ 144,607.82$ 29.4 Install #2 Pullboxes/Terminations EA 24 2,524.06$ ILB 43,200.00$ 17,377.53$ 60,577.53$ 29.5 Install #3 Pullboxes/Terminations EA 2 2,804.52$ ILB 4,000.00$ 1,609.03$ 5,609.03$ 29.6 Install Foundations EA 9 2,103.39$ ILB 13,500.00$ 5,430.48$ 18,930.48$ 29.7 Install Wire LS 1 46,754.07$ ILB 33,342.00$ 13,412.07$ 46,754.07$ 29.8 Install 15' Octagon Classic King Coachman w/ 3'LMA EA 5 7,572.19$ ILB 27,000.00$ 10,860.96$ 37,860.96$ 29.9 Install King 25W Luminaire EA 5 1,121.81$ ILB 4,000.00$ 1,609.03$ 5,609.03$ 29.1 Install 28'' Decorative Arm w/ Clamp on arm bracket for CD814E Per Detail F
EA 4 4,206.77$
ILB 12,000.00$ 4,827.09$ 16,827.09$ 29.11 Install Replica of Lumen Z65A Teardrop w/ Mogul Base Per Detail F EA 4 3,505.64$ ILB 10,000.00$ 4,022.58$ 14,022.58$ 29.12 Install 10,500-12,000 Lumen LED Luminaire EA 1 2,524.06$ ILB 1,800.00$ 724.06$ 2,524.06$
Cesar Chavez & Louis - Street LTG 29.13 Install CD953C w/ 6' LMA EA 1 4,697.56$ ILB 3,350.00$ 1,347.56$ 4,697.56$ 29.14 Install 200W Luminaire EA 1 1,262.03$ ILB 900.00$ 362.03$ 1,262.03$
Cesar Chavez & Forest - Street LTG 29.15 Install CD953C w/ 8' LMA EA 1 4,907.90$ ILB 3,500.00$ 1,407.90$ 4,907.90$ 29.16 Install 200W Luminaire EA 2 1,262.03$ ILB 1,800.00$ 724.06$ 2,524.06$
Cesar Chavez & Soto - Street LTG 29.17 Install CD953C w/ 8' LMA EA 1 4,907.90$ ILB 3,500.00$ 1,407.90$ 4,907.90$ 29.18 Install 200W Luminaire EA 2 1,262.03$ ILB 1,800.00$ 724.06$ 2,524.06$
Cesar Chavez & Breed - Street LTG 29.19 Install CD953C w/8' LMA EA 1 4,907.90$ ILB 3,500.00$ 1,407.90$ 4,907.90$ 29.2 Install 250W Luminaire EA 4 1,472.37$ ILB 4,200.00$ 1,689.48$ 5,889.48$
Utility Relocation 30 Adjust to Grade and/or Replace Water Meter Box/Cover (Includes Water
Service Reconnection) EA 33 5,000.00$
165,000.00$ 31 Adjust to Grade and/or Replace Electrical Box/Cover EA 122 2,500.00$ 305,000.00$ 32 Adjust to Grade and/or Replace Pull Box/Cover (Except for LA Department of
Water and Power EA 17 2,500.00$
42,500.00$ 33 Adjust Maintenance Hole to Grade EA 9 1,500.00$ 13,500.00$ 34 Remove and Reconstruct Side Opening Catch Basin EA 9 15,000.00$ West Pacific Concrete 105,696.00$ 29,304.00$ 135,000.00$ 35 Adjust to Grade Gas Valve Box/Cover EA 1 1,500.00$ 1,500.00$
Miscellaneous 36 Tree Well EA 99 4,500.00$ 445,500.00$ 37 Remove Tree EA 3 4,000.00$ Treesmith 7,200.00$ 4,800.00$ 12,000.00$ 38 Trim Canopy EA 94 2,000.00$ Treesmith 126,900.00$ 61,100.00$ 188,000.00$ 39 Root Prune EA 92 1,000.00$ Treesmith 59,800.00$ 32,200.00$ 92,000.00$ 40 Relocate Guy Wire EA 3 15,000.00$ 45,000.00$
41 Catch Basin Remodel EA 2 15,000.00$ West Pacific Concrete 23,600.00$ 6,400.00$ 30,000.00$ 42 Handrail LF 72 400.00$ 28,800.00$ 43 Telephone EA 15 2,500.00$ 37,500.00$ 44 Relocate/Remove/Reinstall Bus Shelter EA 4 5,000.00$ 20,000.00$ 45 Relocate/Remove/Reinstall Bus Bench EA 7 1,500.00$ 10,500.00$ 46 Relocate/Remove/Reinstall Metal Panels EA 6 1,500.00$ 9,000.00$
SUBTOTAL -$ -$ -$ -$ -$ -$ -$ -$ $0.00
TOTAL TO DATE -$ 1,706,527.38$ 631,796.92$ 12,976,965.00$ -$ -$ -$ -$ -$
-$