Project 655-25-706 - List of End User Devices for Installation.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- 655-25-706 EHRM Installation of DDPo2
- Solicitation number
- 36C25025R0098
About this file
This Excel file is a detailed cost estimate report for Project 655-25-706, focusing on electrical and data infrastructure installation for the Department of Veterans Affairs Veterans Health Administration. The comprehensive estimate, dated 04/29/2025, covers materials and labor for installing network and electrical components in Saginaw, Michigan, with a total estimated cost of $33,977.85. Key line items include Category 6 UTP cable, patch panels, cable supports, electrical metallic tubing, RJ45 jacks, duplex receptacles, outlet boxes, and associated installation labor, with a predictive implementation year of 2027 Quarter 3. The cost breakdown includes material costs of $4,944.11, labor costs of $16,144.85, and overhead and profit margins, with the estimate prepared using the MasterFormat 2018 standard and utilizing the Michigan/Saginaw cost index.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| COST ESTIMATE REPORT |
| DATE: 04/29/2025 |
Estimate Name: EHRM DDPO
ESTIMATE INFORMATION
| Client Name: | Type: | Unit | Notes: | |
| Estimate Address: | Saginaw, MI | Measurement System: | US Standard |
COST DATA
| Estimate Summary: | Catalog: | .....Facilities Construction | ||||
| Material | Labor | Equipment | Total* | Format: | MasterFormat 2018 | |
| Base Total | $ 8,551.43 | $ 15,813.70 | $ - 0 | $ 24,365.13 | Release: | Predictive Year 2027 Quarter 3 as of Year 2025 Quarter 1 |
| Total O&P | $ 9,383.00 | $ 16,144.85 | $ - 0 | $ 33,977.85 | Labor Type: | Repair & Remodeling |
| *"Total" column values include the cost of Exception lines that may not be included in the Material, Labor and Equipment totals. | City Cost Index: | MICHIGAN / SAGINAW (486) |
LEGEND
| Line Source: | U - User defined line item |
| A - Adjustment/Modifier | |
| E - Exception lines |
ESTIMATE
| Quantity | LineNumber | Line Source | SubContracted Ind. | Description | Crew | Daily Output | Labor Hours | Unit | Material | Labor | Equipment | Total | Ext. Mat. | Ext. Labor | Ext. Equip. | Ext. Total | Mat. O&P | Labor O&P | Equip. O&P | Total O&P | Ext. Mat. O&P | Ext. Labor O&P | Ext. Equip. O&P | Ext. Total O&P | Labor Type | Notes | |
| 50 | 271513137240 | Unshielded twisted pair (UTP) cable, solid, PVC jacket, #24, 4 pair, category 6 | 1 Elec | 7 | 1.143 | C.L.F. | $ 75.58 | $ 60.11 | $ - 0 | $ 135.69 | $ 3,779.00 | $ 3,005.50 | $ - 0 | $ 6,784.50 | $ 82.85 | $ 92.36 | $ - 0 | $ 175.21 | $ 4,142.50 | $ 4,618.00 | $ - 0 | $ 8,760.50 | RR | 0 | |||
| 20 | 271119103100 | Patch panel, punch down termination per port | 1 Elec | 107 | 0.075 | Ea. | $ - 0 | $ 3.92 | $ - 0 | $ 3.92 | $ - 0 | $ 78.40 | $ - 0 | $ 78.40 | $ - 0 | $ 6.01 | $ - 0 | $ 6.01 | $ - 0 | $ 120.20 | $ - 0 | $ 120.20 | RR | 1 | |||
| 20 | 270529100110 | Cable support, J-hook, single tier, single sided, 1" diameter | 1 Elec | 68.57 | 0.117 | Ea. | $ 3.48 | $ 6.12 | $ - 0 | $ 9.60 | $ 69.60 | $ 122.40 | $ - 0 | $ 192.00 | $ 3.83 | $ 9.38 | $ - 0 | $ 13.21 | $ 76.60 | $ 187.60 | $ - 0 | $ 264.20 | RR | 2 | |||
| 15 | 260519900940 | Wire, copper, solid, 600 volt, #12, type THWN-THHN, normal installation conditions in wireway, conduit, cable tray | 1 Elec | 11 | 0.727 | C.L.F. | $ 21.80 | $ 38.12 | $ - 0 | $ 59.92 | $ 327.00 | $ 571.80 | $ - 0 | $ 898.80 | $ 24.23 | $ 58.64 | $ - 0 | $ 82.87 | $ 363.45 | $ 879.60 | $ - 0 | $ 1,243.05 | RR | 3 | |||
| 1500 | 260533135020 | Electric metallic tubing (EMT), 3/4" diameter, to 10' high, incl 2 terminations, 2 field bend elbows, 11 beam clamps, and 11 couplings per 100 LF | 1 Elec | 130 | 0.062 | L.F. | $ 1.99 | $ 3.23 | $ - 0 | $ 5.22 | $ 2,985.00 | $ 4,845.00 | $ - 0 | $ 7,830.00 | $ 2.18 | $ 4.95 | $ - 0 | $ 7.13 | $ 3,270.00 | $ 7,425.00 | $ - 0 | $ 10,695.00 | RR | 4 | |||
| 25 | 271513137326 | Shielded twisted pair (UTP) jack, RJ45, category 6 | 1 Elec | 60 | 0.133 | Ea. | $ 11.34 | $ 7.00 | $ - 0 | $ 18.34 | $ 283.50 | $ 175.00 | $ - 0 | $ 458.50 | $ 12.45 | $ 10.74 | $ - 0 | $ 23.19 | $ 311.25 | $ 268.50 | $ - 0 | $ 579.75 | RR | 5 | |||
| 22 | 262726202470 | Duplex receptacle, grounded, 120 volt, 20 amp | 1 Elec | 27 | 0.296 | Ea. | $ 14.73 | $ 15.39 | $ - 0 | $ 30.12 | $ 324.06 | $ 338.58 | $ - 0 | $ 662.64 | $ 16.18 | $ 23.82 | $ - 0 | $ 40.00 | $ 355.96 | $ 524.04 | $ - 0 | $ 880.00 | RR | 6 | |||
| 25 | 260533160350 | Outlet boxes, pressed steel, 4-11/16" square | 1 Elec | 20 | 0.4 | Ea. | $ 7.51 | $ 20.89 | $ - 0 | $ 28.40 | $ 187.75 | $ 522.25 | $ - 0 | $ 710.00 | $ 8.28 | $ 32.25 | $ - 0 | $ 40.53 | $ 207.00 | $ 806.25 | $ - 0 | $ 1,013.25 | RR | 7 | |||
| 25 | 260533160500 | Outlet boxes, pressed steel, plaster rings, 4-11/16" square | 1 Elec | 53 | 0.151 | Ea. | $ 5.43 | $ 7.92 | $ - 0 | $ 13.35 | $ 135.75 | $ 198.00 | $ - 0 | $ 333.75 | $ 5.96 | $ 12.17 | $ - 0 | $ 18.13 | $ 149.00 | $ 304.25 | $ - 0 | $ 453.25 | RR | 8 | |||
| 25 | 260533160450 | Outlet boxes, pressed steel, covers, blank, 4-11/16" square | 1 Elec | 53 | 0.151 | Ea. | $ 2.71 | $ 7.92 | $ - 0 | $ 10.63 | $ 67.75 | $ 198.00 | $ - 0 | $ 265.75 | $ 2.98 | $ 12.17 | $ - 0 | $ 15.15 | $ 74.50 | $ 304.25 | $ - 0 | $ 378.75 | RR | 9 | |||
| 3 | 260533160700 | Outlet boxes, pressed steel, masonry, 1 gang, 2-1/2" deep | 1 Elec | 27 | 0.296 | Ea. | $ 9.79 | $ 15.39 | $ - 0 | $ 25.18 | $ 29.37 | $ 46.17 | $ - 0 | $ 75.54 | $ 10.76 | $ 23.82 | $ - 0 | $ 34.58 | $ 32.28 | $ 71.46 | $ - 0 | $ 103.74 | RR | 10 | |||
| 10 | 260533160750 | Outlet boxes, pressed steel, masonry, 2 gang, 2-1/2" deep | 1 Elec | 20 | 0.4 | Ea. | $ 18.36 | $ 20.89 | $ - 0 | $ 39.25 | $ 183.60 | $ 208.90 | $ - 0 | $ 392.50 | $ 20.35 | $ 32.25 | $ - 0 | $ 52.60 | $ 203.50 | $ 322.50 | $ - 0 | $ 526.00 | RR | 11 | |||
| 3 | 260533161530 | Outlet boxes, cast, duplex receptacle cover, 1 gang, FS | 1 Elec | 64 | 0.125 | Ea. | $ 9.45 | $ 6.56 | $ - 0 | $ 16.01 | $ 28.35 | $ 19.68 | $ - 0 | $ 48.03 | $ 10.42 | $ 10.08 | $ - 0 | $ 20.50 | $ 31.26 | $ 30.24 | $ - 0 | $ 61.50 | RR | 12 | |||
| 10 | 260533161540 | Outlet boxes, cast, duplex receptacle cover, 2 gang, FS | 1 Elec | 53 | 0.151 | Ea. | $ 15.07 | $ 7.92 | $ - 0 | $ 22.99 | $ 150.70 | $ 79.20 | $ - 0 | $ 229.90 | $ 16.57 | $ 12.17 | $ - 0 | $ 28.74 | $ 165.70 | $ 121.70 | $ - 0 | $ 287.40 | RR | 13 | |||
| 1 | 260533169000 | Outlet boxes, minimum labor/equipment charge | 1 Elec | 4 | 2 | Job | $ - 0 | $ 104.82 | $ - 0 | $ 104.82 | $ - 0 | $ 104.82 | $ - 0 | $ 104.82 | $ - 0 | $ 161.26 | $ - 0 | $ 161.26 | $ - 0 | $ 161.26 | $ - 0 | $ 161.26 | RR | 14 | |||
| 2 | 013113200280 | E | Field personnel, superintendent, maximum | 0 | 0 | Week | $ - 0 | $ 2,650.00 | $ - 0 | $ 2,650.00 | $ - 0 | $ 5,300.00 | $ - 0 | $ 5,300.00 | $ - 0 | $ - 0 | $ - 0 | $ 4,225.00 | $ - 0 | $ - 0 | $ - 0 | $ 8,450.00 | RR | 15 |
Grand Total $ 3,173.44 $ 8,551.43 $ 15,813.70 $ - 0 $ 24,365.13 $ 4,944.11 $ 9,383.00 $ 16,144.85 $ - 0 $ 33,977.85 image1.png
File details come from the government source that posted it. Updated .