| Nebraska Department of Roads | |
|---|---|
| Estimate Summary to Contractor | |
| Vendor ID: | 2122 WATTS ELECTRIC COMPANY |
| Contract ID: | 4152 |
| Estimate Number: | 0007 |
| Pay Period End Date: | 05.23.2002 |
| Contract Location: | ||
| WACO INTERCHANGE | Estimate Type: | FINL |
| Contractor: | ||
| WATTS ELECTRIC COMPANY | Date Let: | 07.27.2000 |
| 3211 NW 39th St Bldg 1476 | Date Awarded: | 08.03.2000 |
| Date Contract Executed: | 08.10.2000 | |
| Date Notice to Proceed: | 08.10.2000 | |
| Lincoln NE 68524 | Date Work Began: | 10.09.2001 |
| Phone: | Date Physical Work Completed: | |
| (402)470-2775 | Date Accepted: | |
| Escrow Agent: | ||
| Surety Co: | ||
| MERCHANTS BONDING COMPANY (MUTUAL) |
| Counties |
|---|
| YORK |
| Project Number | PCT | Fed State Project Number | Description | ||||
|---|---|---|---|---|---|---|---|
| 42152 000 | 0.000 | ELEC-80-8(1024) | ELECTRICAL |
| Total to Date | Prev to Date | This Estimate | ||
| Current Contract Amt | Total Earnings | $103,126.81 | $103,126.81 | $.00 |
| $103,581.60 | Stockpiled Materials | $.00 | $.00 | $.00 |
| Original Contract Amt | Gross Earnings | $103,126.81 | $103,126.81 | $.00 |
| $103,581.60 | Retainage | $.00 | $-1,031.27 | $1,031.27 |
| Escrow Amount | $.00 | $.00 | $.00 | |
| Percent Complete | Securities Encumbered | $.00 | $.00 | $.00 |
| 99.56% | Net Earnings | $103,126.81 | $102,095.54 | $1,031.27 |
| Liquidated Damages | $.00 | $.00 | $.00 | |
| Incentives | $.00 | $.00 | $.00 | |
| Disincentives | $.00 | $.00 | $.00 | |
| Other Contract Adj | $.00 | $.00 | $.00 | |
| Appl of Training Adj | $.00 | $.00 | $.00 | |
| Training Rates Adj | $.00 | $.00 | $.00 | |
| Fuel Adj | $.00 | $.00 | $.00 | |
| Bituminous Adj | $.00 | $.00 | $.00 | |
| Autopay Adj | $.00 | $.00 | $.00 | |
| Gasoline Adj | $.00 | $.00 | $.00 | |
| Other Adj | $.00 | $.00 | $.00 | |
| Price Adj | $.00 | $.00 | $.00 | |
| Substandard Item Adj | $.00 | $.00 | $.00 | |
| Asphalt Adj | $.00 | $.00 | $.00 | |
| Diesel Fuel Adj | $.00 | $.00 | $.00 | |
| Petrol Adj | $.00 | $.00 | $.00 | |
| Total for Adjustments | $.00 | $.00 | $.00 | |
| Payment | $103,126.81 | $102,095.54 | $1,031.27 | |
| Project Manager | Div. Head/Dist. Eng. | |||
| Anderson, Tom | 05.31.2002 | Meyer, Keith | 06.05.2002 | |
| Constr. Estimate Eng. | Materials Eng. | |||
| Davis, Carl | 06.07.2002 | Hall, David | 06.07.2002 | |
| Controller Div. Processed | ||||
| Harring, Joyce | 06.19.2002 |
| Detailed breakdown of stockpiled materials | ||||
|---|---|---|---|---|
| Est Nbr: | 0001 | |||
| Item Nbr | Item Cd | Item Desc | Adj Amt | Invoice Nbr |
| 0002 | A010.20 | LUMINAIRE, TYPE HML-A-1KW | ||
| S.P. Initial Payment | 4,059.00 | 01392/39 | ||
| luminare, type HML-A-1KW | ||||
| Total for estimate 0001: | 4,059.00 | |||
| Est Nbr: | 0002 | |||
| Item Nbr | Item Cd | Item Desc | Adj Amt | Invoice Nbr |
| 0003 | A018.26 | HIGH MAST LIGHTING UNIT, TYPE T-120 | ||
| S.P. Initial Payment | 24,864.46 | 01920338 | ||
| Lowering devices | ||||
| Total for estimate 0002: | 24,864.46 | |||
| Est Nbr: | 0003 | |||
| Item Nbr | Item Cd | Item Desc | Adj Amt | Invoice Nbr |
| 0003 | A018.26 | HIGH MAST LIGHTING UNIT, TYPE T-120 | ||
| S.P. Initial Payment | 18,261.40 | 01991119 | ||
| HMP-120 Galv Pole | ||||
| Total for estimate 0003: | 18,261.40 | |||
| Est Nbr: | 0005 | |||
| Item Nbr | Item Cd | Item Desc | Adj Amt | Invoice Nbr |
| 0002 | A010.20 | LUMINAIRE, TYPE HML-A-1KW | ||
| S.P. Adjustment | -3,247.20 | 01392/39 | ||
| luminare, type HML-A-1KW | ||||
| 0003 | A018.26 | HIGH MAST LIGHTING UNIT, TYPE T-120 | ||
| S.P. Adjustment | -24,864.46 | 01920338 | ||
| Lowering devices | ||||
| S.P. Adjustment | -18,261.40 | 01991119 | ||
| HMP-120 Galv Pole | ||||
| Total for estimate 0005: | -46,373.06 | |||
| Est Nbr: | 0006 | |||
| Item Nbr | Item Cd | Item Desc | Adj Amt | Invoice Nbr |
| 0002 | A010.20 | LUMINAIRE, TYPE HML-A-1KW | ||
| S.P. Adjustment | -811.80 | 01392/39 | ||
| luminare, type HML-A-1KW | ||||
| Total for estimate 0006: | -811.80 | |||
| Total remaining for contract: | 0.00 |
| 1. Contracted | |||
|---|---|---|---|
| 2. Current | |||
| 3. To date | |||
| Item Nbr Item Code | Unit Price | 4. This Est | |
| Item Description | Units | Qty | Amount |
| GROUP 8B ELECTRICAL | |||
| 0001 A001.16 | 360.00 | 8.000 | 2,880.00 |
| PULL BOX, TYPE PB-6 | EACH | 8.000 | 2,880.00 |
| 8.000 | 2,880.00 | ||
| 0.000 | 0.00 | ||
| 0002 A010.20 | 700.00 | 20.000 | 14,000.00 |
| LUMINAIRE, TYPE HML-A-1KW | EACH | 20.000 | 14,000.00 |
| 20.000 | 14,000.00 | ||
| 0.000 | 0.00 | ||
| 0003 A018.26 | 14,230.00 | 4.000 | 56,920.00 |
| HIGH MAST LIGHTING UNIT, TYPE T-120 | EACH | 4.000 | 56,920.00 |
| 4.000 | 56,920.00 | ||
| 0.000 | 0.00 | ||
| 0004 A018.81 | 1,050.00 | 4.000 | 4,200.00 |
| FOUNDATION DESIGN | EACH | 4.000 | 4,200.00 |
| 4.000 | 4,200.00 | ||
| 0.000 | 0.00 | ||
| 0005 A018.82 | 65.00 | 60.000 | 3,900.00 |
| CONCRETE FOR FOUNDATION | CY | 60.000 | 3,900.00 |
| 44.000 | 2,860.00 | ||
| 0.000 | 0.00 | ||
| 0006 A018.83 | 0.55 | 4,852.000 | 2,668.60 |
| REINFORCING STEEL | LB | 4,852.000 | 2,668.60 |
| 6,101.480 | 3,355.81 | ||
| 0.000 | 0.00 | ||
| 0007 A020.30 | 1,385.00 | 2.000 | 2,770.00 |
| LIGHTING CONTROL CENTER, TYPE R | EACH | 2.000 | 2,770.00 |
| 2.000 | 2,770.00 | ||
| 0.000 | 0.00 | ||
| 0008 A070.10 | 2.00 | 2,540.000 | 5,080.00 |
| 1 1/2-INCH CONDUIT IN TRENCH | LF | 2,540.000 | 5,080.00 |
| 2,577.000 | 5,154.00 | ||
| 0.000 | 0.00 | ||
| 0009 A074.12 | 14.00 | 70.000 | 980.00 |
| 1 1/2-INCH CONDUIT, JACKED | LF | 70.000 | 980.00 |
| 73.000 | 1,022.00 | ||
| 0.000 | 0.00 | ||
| 0010 A080.10 | 1.10 | 5,220.000 | 5,742.00 |
| STREET LIGHTING CABLE, NO. 2 USE | LF | 5,220.000 | 5,742.00 |
| 5,300.000 | 5,830.00 | ||
| 0.000 | 0.00 | ||
| 0011 A080.22 | 0.60 | 2,610.000 | 1,566.00 |
| STREET LIGHTING CABLE, NO. 6 BARE | LF | 2,610.000 | 1,566.00 |
| 2,650.000 | 1,590.00 | ||
| 0.000 | 0.00 | ||
| 0012 0001.90 | 1.50 | 50.000 | 75.00 |
| SIGN DAY | EACH | 50.000 | 75.00 |
| 30.000 | 45.00 | ||
| 0.000 | 0.00 | ||
| 0013 0003.10 | 30.00 | 10.000 | 300.00 |
| FLAGGING | DAY | 10.000 | 300.00 |
| 0.000 | 0.00 | ||
| 0.000 | 0.00 | ||
| 0014 0030.81 | 2,500.00 | 1.000 | 2,500.00 |
| MOBILIZATION | LS | 1.000 | 2,500.00 |
| 1.000 | 2,500.00 | ||
| 0.000 | 0.00 | ||
| GROUP 8B ELECTRICAL | Contracted | 103,581.60 | |
| Current | 103,581.60 | ||
| In place | 103,126.81 | ||
| This Estimate | 0.00 | ||
| Totals for contract | Contracted | 103,581.60 | |
| Current | 103,581.60 | ||
| In place | 103,126.81 | ||
| This Estimate | 0.00 |