Spreadsheet: 94459d1294262216-excel-2007-return-max-date-in-column-based-on-lookup-in-adjacent-column-proj-135030-mvsis-dec-10-draft
Sheet: INVOICE

City of San Diego, Field Engineering Div., 9485 Aero Drive, SD CA 92123 |  |  |  |  |  | Contractor's Name: |  | HPS Mechanical, Inc.
Project Name:  Mission Bay Sewage Interceptor System |  |  |  |  |  | Contractor's Address: |  | [NAME]
Work Order No/J. O. No. 135030 |  |  |  |  |  |  |  | Bakersfield, CA  93386
CIP (WBS) No.  13-503.0 (S-01095) |  |  |  |  |  | Contractor's Phone #: |  | (661) 397-2121 |  | Invoice No. | 6
Resident Engineer (RE): [NAME] |  |  |  |  |  | Contractor's fax #: |  | (661) 396-2589 |  | Invoice Date: | 2011-01-10 00:00:00
RE Phone#: (858) 495-4720     Fax#: (619) 533-7477 |  |  |  |  |  | Contact Name: |  | Justice [NAME] |  | Billing Period: 12/01/10 To 12/31/10
Item # | Item Description | Contract Authorization |  |  |  | Previous Estimate |  | This Estimate |  | Totals to Date
 |  | Unit | Price | Qty | Extension | %/QTY | Amount | % / QTY | Amount | % / QTY | Amount | Balance
1 | Certified Payroll | LS | 1500 | 1 |  |  | 1050
2 | Preconstruction Performance Test | LS | 2000 | 1 |  |  | 2000
3 | Maintain & Update Water Pollution Control Document (WPCP) | LS | 800 | 1 |  |  | 800
4 | Erosion Control | LS | 3500 | 1 |  |  | 2800 | 0.15
5 | Sediment Control | LS | 8400 | 1 |  |  | 6720 | 0.15
6 | SD Inlet Protection | LS | 2800 | 1 |  |  | 2240 | 0.15
7 | Non-Stormwater & Materials Management BMP's | LS | 1200 | 1 |  |  | 960 | 0.15
8 | Street Sweeping | LS | 5000 | 1 |  |  | 4000 | 0.15
9 | Weather Trigger Action Plan | LS | 450 | 1 |  |  | 450
10 | Inlet Markers | EA | 34 | 20 |  |  | 0 | 20
11 | Land/Surface Improvement/Restoration | LS | 5700 | 1 |  |  | 5700
12 | Traffic Control | LS | 15000 | 1 |  |  | 14250 | 0.05
13 | Video Tape Pre-Existing Conditions | LS | 2500 | 1 |  |  | 2500
14 | Mobilization/Survey | LS | 20000 | 1 |  |  | 20000
15 | Performance & Payment Bonds | LS | 9350 | 1 |  |  | 9350
16 | Pump Rail Bracket and Hardware | Sets | 4000 | 4 |  |  | 16000
17 | [NAME] (5'x7') (HS-20) | EA | 17000 | 13 |  |  | 221000
18 | [NAME] (5'x7') (Non-Traffic Related) | EA | 12000 | 3 |  |  | 36000
19 | Access Hatch Vault Ring | EA | 8000 | 8 |  |  | 64000
20 | Replace Access Hatch Hydraulic Lifting Mechanism | EA | 3000 | 1 |  |  | 3000
21 | Replace Access Hatch Spring Assembly | EA | 800 | 2 |  |  | 1600
22 | Protection Post | EA | 400 | 4 |  |  | 1200 | 1
23 | 6" Suction Piping Bend | EA | 1000 | 2 |  |  | 2000
24 | 8" Gate Valve | EA | 4000 | 8 |  |  | 32000
25 | 14" Sluice Gate | EA | 11000 | 5 |  | 1 | 11000 | 4
26 | 15" Flap Gate | EA | 6000 | 2 |  |  | 0 | 2
27 | 18" Flap Gate | EA | 8000 | 8 |  |  | 0 | 7
28 | 36" Flap Gate | EA | 17000 | 1 |  |  | 0
29 | 42" Flap Gate | EA | 18000 | 3 |  |  | 18000 | 1
30 | 48" Flap Gate | EA | 20000 | 2 |  |  | 40000
31 | 60" Flap Gate | EA | 23000 | 2 |  |  | 23000
32 | Ventilation Fan | LS | 6400 | 1 |  |  | 6400
33 | [NAME] and Telemetry Connection | LS | 5400 | 1 |  |  | 5400
34 | Asphalt Pavement Replacement | SF | 11 | 700 |  |  | 1870
35 | Concrete Pavement and Slab Replacement | SF | 17 | 500 |  |  | 0 | 376
36 | Concrete Vault | EA | 12500 | 7 |  |  | 87500
37 | Concrete Vault Electrical | EA | 14000 | 2 |  |  | 28000
38 | Concrete Diversion Berm | LS | 6000 | 1 |  |  | 0 | 1
39 | Shoring | LS | 20000 | 1 |  |  | 20000
40 | Additional Pavement Removal | SF | 10 | 100 |  |  | 0
41 | Imported Backfill | CY | 12 | 100 |  |  | 0
42 | Foundation Rock | CY | 50 | 100 |  |  | 2500
43 | Dewatering | LS | 55000 | 1 |  |  | 55000
44 | Metro Wastewater Discharge Permit | AL | 50000 | 1 |  |  | 0 | 0.006
45 | Repair PVC Lining | EA | 3500 | 5 |  |  | 0 | 2
50 | Field Orders | AL | 20000 | 1 |  |  | 0
FO1 | Field Order # 1 |  | 6109.5 | 1 |  |  | 6109.5
 | Total
 | A.  Original Contract Amount |  |  |  |  |  | Retention and Escrow Payment Schedule:
 | B.  Approved Change Order #00 Thru #00 |  | 0 |  |  |  | Total Retention Required as of this billing
 | C.  Total Authorized Amount (A+B) |  |  |  |  |  | Less Previous Retention Withheld in PO/Escrow
 | D.  Total Billed to Date |  |  |  |  |  | Add'l Amt to Withhold in PO/Transfer in Escrow:
 | E.  Less Total Retention (5% of D)
 | F.  Less Total Previous Payments |  | 716679.53 |  |  |  | Signature:
 | G. Payment Due Less Retention |  |  |  |  |  |  | Contractor/Date
 | [NAME]