Atch 5-Pricing Sheet-Well Automation BLANK-NO FORMULA.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- Repair Wells 3 SCADA Automation Federal contract opportunity
- Solicitation number
- FA480325B0002
About this file
This is a pricing sheet template for a Well Automation project and ARCENT Marquee project, divided into three CLINs. CLINs 0001 and 0002 are blank pricing templates for the Well Automation project, requiring contractors to provide material and labor costs for items including chemical analyzers, eye wash stations, TVs, Studio 5000 installation, Factory Talk installation, Allen Bradley VFD, stripper level systems, ultrasonic level sensors, flow meters, PLC programming, chemical feed pumps, and sample tables. Both CLINs include spaces for superintendent, project manager, and design costs.
CLIN 3 contains completed pricing for an ARCENT Marquee project totaling $164,881.34, with detailed line items including 1,600 LF of duct work ($16,432), 35 CY of concrete ($8,686), 2,400 LF of 15kV cable ($42,924), transformer and sectionalizing cabinet installation, and associated labor costs. The pricing structure includes 10% overhead, 10% profit, and a 2.5% bond rate applied to the base costs of $132,942.02 in materials, labor, and direct costs.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Atch 6-Air Force Form 66-Blank.xlsx | XLSX spreadsheet | |
| Atch 3-HMI Screen Reference.pdf | ||
| Atch 1-Statement of Work- VLSB 18-0010 Repair Well 3 with SCADA Upgrade.pdf | ||
| Atch 4-Site Pictures CLIN 0001.pdf | ||
| Atch 2-Shaw AFB Well Utility Controls Schematic.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
CLIN0001
| Project: | Well Automation | Project Engineer: | Christopher Smith | |
| Location: | Department: | 20 CES | ||
| Contractor: | Date: | 12/18/24 | ||
| Address: | Total | |||
| PR No.: |
Line No. Item Units Quantity Material Costs Labor Costs Direct Cost Line Total
| Unit Cost | Total | Labor Hours per Unit | Labor Hours | Avg. Rate ($/hr) | Total | |||
| 1 | Chem Analyzers | LS | ||||||
| 2 | Eye wash stations | EA | ||||||
| 3 | 65'' TV | EA | ||||||
| 4 | 55'' TV | EA | ||||||
| 5 | Studio 5000 Purchase and install | EA | ||||||
| 6 | Factory Talk Purchase and install | EA | ||||||
| 7 | Allen Bradley VFD | EA | ||||||
| 8 | Stripper level system upgrade | EA | ||||||
| 9 | Demo | LS | ||||||
| 10 | Ultrasonic Level sensors | EA | ||||||
| 11 | Flow Meters | EA | ||||||
| 12 | PLC Programing | EA | ||||||
| 13 | PLC Automation setup Testing | EA | ||||||
| 14 | Chemical Feed Pumps | EA | ||||||
| 15 | Sample table | Ea | ||||||
| 16 | Labeling | EA | ||||||
| 17 | ||||||||
| 18 | ||||||||
| 19 | ||||||||
| 20 | ||||||||
| 21 | Superintendent | WK | ||||||
| 22 | Project Manager | WK | ||||||
| 23 | Design | EA | ||||||
| Total: |
| Total Material Cost: |
| Total Labor Cost: |
| Direct Cost: |
| Total Line Item Cost: |
| Overhead: |
| Subtotal: |
| Profit: |
| Subtotal: |
| Bond: |
| Total Contract Price: |
CLIN0002
| Project: | Well Automation | Project Engineer: | Christopher Smith | |
| Location: | Department: | 20 CES | ||
| Contractor: | Date: | 12/18/24 | ||
| Address: | Total | |||
| PR No.: |
Line No. Item Units Quantity Material Costs Labor Costs Direct Cost Line Total
| Unit Cost | Total | Labor Hours per Unit | Labor Hours | Avg. Rate ($/hr) | Total | |||
| 1 | Chem Analyzers | LS | ||||||
| 2 | Eye wash stations | EA | ||||||
| 3 | Allen Bradley VFD | EA | ||||||
| 4 | Stripper level system upgrade | EA | ||||||
| 5 | Demo | LS | ||||||
| 6 | Ultrasonic Level sensor | EA | ||||||
| 7 | Flow Meters | EA | ||||||
| 8 | PLC Programing | EA | ||||||
| 9 | PLC Automation setup Testing | EA | ||||||
| 10 | Chemical Feed Pumps | EA | ||||||
| 11 | Sample table | Ea | ||||||
| 12 | Labeling | EA | ||||||
| 13 | ||||||||
| 14 | ||||||||
| 15 | ||||||||
| 16 | ||||||||
| 17 | Superintendent | WK | ||||||
| 18 | Project Manager | WK | ||||||
| 19 | Design | EA | ||||||
| Total: |
| Total Material Cost: |
| Total Labor Cost: |
| Direct Cost: |
| Total Line Item Cost: |
| Overhead: |
| Subtotal: |
| Profit: |
| Subtotal: |
| Bond: | 2.5% |
| Total Contract Price: |
Marquee CLIN3
| Project: | ARCENT Marquee | Project Engineer: | Tony Satcher | ||
| Location: | Department: | 20 CES | |||
| Contractor: | Date: | 6/3/21 | |||
| Address: | Total | $164,881.34 | |||
| PR No.: |
Line No. Item Units Quantity Material Costs Labor Costs Direct Cost Line Total
| Unit Cost | Total | Labor Hours per Unit | Labor Cost per Unit | Labor Hours | Avg. Rate ($/hr) | Total | ||||||
| 1 | Duct | LF | 1600 | $6.00 | $9,600.00 | 0.0378 | $2.27 | 60.5 | $60.05 | $3,632.00 | $3,200.00 | $16,432.00 |
| 2 | Concrete | CY | 35 | $155.00 | $5,425.00 | 0.55 | $33.00 | 19.3 | $60.00 | $1,155.00 | $2,106.00 | $8,686.00 |
| 3 | Cable(15 kV) | LF | 2400 | $15.88 | $38,100.00 | 0.0334 | $2.01 | 80.2 | $60.18 | $4,824.00 | $42,924.00 | |
| 4 | Transformer (1 phase) including all hardware | EA | 1 | $10,850.00 | $10,850.00 | 48 | $2,400.00 | 48.0 | $50.00 | $2,400.00 | $13,250.00 | |
| 5 | Sectionalizing Cabinets | EA | 1 | $5,000.00 | $5,000.00 | 35 | $1,750.00 | 35.0 | $50.00 | $1,750.00 | $6,750.00 | |
| 6 | Mobilization/Demobilization | LS | 1 | $5,000.00 | $5,000.00 | |||||||
| 7 | Testing | LS | 1 | $7,000.00 | $7,000.00 | |||||||
| 8 | Boring | LF | 100 | $92.00 | $9,200.00 | $5,000.00 | $14,200.00 | |||||
| 9 | Superintendent | WK | 3 | 40 | $2,175.00 | 120.0 | $54.38 | $6,525.00 | $6,525.00 | |||
| 10 | Project Manager | WK | 2 | 40 | $2,325.00 | 80.0 | $58.13 | $4,650.00 | $4,650.00 | |||
| 11 | Design | EA | 1 | $7,525.02 | $7,525.02 | |||||||
| Total: | $78,175.00 | $24,936.00 | $29,831.02 | $132,942.02 |
| Total Material Cost: | $78,175.00 |
| Total Labor Cost: | $24,936.00 |
| Direct Cost: | $29,831.02 |
| Total Line Item Cost: | $132,942.02 |
| Overhead: | 10% | $13,294.20 |
| Subtotal: | $146,236.22 |
| Profit: | 10% | $14,623.62 |
| Subtotal: | $160,859.84 |
| Bond: | 2.5% | $4,021.50 |
| Total Contract Price: | $164,881.34 |
File details come from the government source that posted it. Updated .