Attach_3_-_Pricing_Workbook.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- FA2823-19-Q-0013
About this file
Pricing Workbook
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFIs_as_of_02_April_2019.pdf | ||
| RFIs_as_of_27_March_2019.pdf | ||
| Attach_1_PWS.pdf | ||
| Attach_4_-_WD_15-4531_Rev_9.pdf | ||
| Attach_5_-_PPQ.pdf | ||
| Attach_2_QASP.pdf | ||
| FA2823-19-Q-0013_RFQ.pdf | ||
| Attach_6_-_Site_Visit_Map.pdf |
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
Instructions
| Fillable Cell | Will calculate Automatically | Locked Cell |
| Offerors are to complete the lime green cells in worksheets titled 'Section B' and 'X002 Scenario' with their proposed unit prices. |
1. Offerors are to add their base year monthly preventative maintenance costs to Cell E3 in Worksheet 'Section B'
2. Offerors are to add their base year hourly rate in Cell I2 in Worksheet 'Section B'
3. Offerors are to add their base year service fee in Cell I3 in Worksheet Section B'
4. Offerors are to add their base year first stage filter cost in Cell I5 in Worksheet 'Section B'
5. Offerors are to add their base year second stage filter cost in Cell I6 in Worksheet 'Section B'
6. Offerors are to add their base year third stage filter cost in Cell I7 in Worksheet 'Section B'
7. Offerors are to add their option year 1 monthly preventative maintenance costs to Cell E12 in Worksheet 'Section B'
8. Offerors are to add their option year 1 hourly rate in Cell I11 in Worksheet 'Section B'
9. Offerors are to add their option year 1 service fee in Cell I12 in Worksheet 'Section B'
10. Offerors are to add their option year 1 first stage filter cost in Cell in I14 Worksheet 'Section B'
11. Offerors are to add their option year 1 second stage filter cost in Cell I15 in Worksheet 'Section B'
12. Offerors are to add their option year 1 third stage filter cost in Cell in I16 Worksheet 'Section B'
13. Offerors are to add their option year 2 monthly preventative maintenance costs to Cell E21 in Worksheet 'Section B'
13. Offerors are to add their option year 2 hourly rate in Cell I20 in Worksheet 'Section B'
14. Offerors are to add their option year 2 service fee in Cell I21 in Worksheet 'Section B'
15. Offerors are to add their option year 2 first stage filter cost in Cell I23 in Worksheet 'Section B'
16. Offerors are to add their option year 2 second stage filter cost in Cell I24 in Worksheet 'Section B'
17. Offerors are to add their option year 2 third stage filter cost in Cell I25 in Worksheet 'Section B'
18. Offerors are to add their mileage for the scenario in Cell B22 of Worksheet 'X002 Scenario'
19. Offerors are to add their # of Days for Lodging in Cell B23 of Worksheet 'X002 Scenario'
20. Offerors are to add their # of Days for M&IE in Cell B24 of Worksheet 'X002 Scenario'
21. Offerors are to add their base year # of travel hours for the first worker in Cell B33 in Worksheet 'X002 Scenario'
22. Offerors are to add their base year # of travel hours for the second worker in Cell B34 in Worksheet 'X002 Scenario'
23. Offerors are to add their option year 1 # of travel hours for the first worker in cell B43 in Worksheet 'X002 Scenario'
24. Offerors are to add their option year 1 # of travel hours for the second worker in cell B44 in Worksheet 'X002 Scenario'
25. Offerors are to add their option year 2 # of travel hours for the first worker in cell B53 in Worksheet 'X002 Scenario'
26. Offerors are to add their option year 2 # of travel hours for the second worker in cell B54 in Worksheet 'X002 Scenario'
Section B
| BASE YEAR - 01 May 2019 – 30 April 2020 | Price Inputs | Rate | |||||||
| CLIN | Description | Qty | Unit of Issue | Unit Price | Extended Price | Hourly Rate: | |||
| 0001 | Preventative Maintenance Program for Corrosion Control Paint Booth In Accordance With (IAW) Performance Work Statement dated 07 March 2019. | 12 | Months | $0.00 | Service Call (flat rate not to exceed two hours of contracted labor rate): | ||||
| 0002 | Additional/Miscellaneous IAW PWS dated 07 March 2019. This is a Not To Exceed (NTE) CLIN. The service provider shall complete all required non-scheduled maintenance to maintain operational readiness. All maintenance not associated with preventative program (i.e. component replacement due to failure) will be covered under this CLIN. Once a problem is identified the Vendor will notify the Government and provide a proposal for repair to include 2 quotes from 2 separate parts distributors. The Vendor will not perform maintenance unless directed by the Contracting Office. | 1 | Job | $30,000.00 | Rate | Qty | Labor | ||
| 0003 | 1st STAGE FILTERS |
Remove and Replace 1st Stage Filters.
| Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019. Every 9 months; First change is 01 January 2020. | 1 | Each | $0.00 | $0.00 | First Stage Filter Cost: |
| 2 techs x 8 hours | 42 | $0.00 | |||
| 0004 | 2nd STAGE FILTERS |
Remove and Replace 2nd Stage Filters. Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019.
| Every 18 months; First change is February 2020. | 1 | Each | $0.00 | $0.00 | Second Stage Filter Cost: | |
| 2 techs x 8 hours | 612 | $0.00 | ||||
| 0005 | 3rd STAGE FILTERS | |||||
| Remove and Replace 3rd Stage Filters. Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019. Every 24 months; First change is May 2019. | 1 | Each | $0.00 | $0.00 | Third Stage Filter Cost: | |
| 2 techs x 8 hours | 612 | $0.00 | ||||
| Base Year Total: | $30,000.00 | NTE |
| OPTION YEAR 1 - 01 May 2020 – 0 April 2021 | Price Inputs | Rate | |||||||
| CLIN | Description | Qty | Unit of Issue | Unit Price | Extended Price | Hourly Rate: | |||
| 1001 | Preventative Maintenance Program for Corrosion Control Paint Booth In Accordance With (IAW) Performance Work Statement dated 07 March 2019. | 12 | Months | $0.00 | Service Call (flat rate not to exceed two hours of contracted labor rate): | ||||
| 1002 | Additional/Miscellaneous IAW PWS dated 07 March 2019. This is a Not To Exceed (NTE) CLIN. The service provider shall complete all required non-scheduled maintenance to maintain operational readiness. All maintenance not associated with preventative program (i.e. component replacement due to failure) will be covered under this CLIN. Once a problem is identified the Vendor will notify the Government and provide a proposal for repair to include 2 quotes from 2 separate parts distributors. The Vendor will not perform maintenance unless directed by the Contracting Office. | 1 | Job | $30,000.00 | Rate | Qty | Labor | ||
| 1003 | 1st STAGE FILTERS |
Remove and Replace 1st Stage Filters.
Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019.
| Every 9 months; First change is October 2020. | 1 | Each | $0.00 | $0.00 | First Stage Filter Cost: |
| 2 techs x 8 hours | 42 | $0.00 | |||
| 1004 | 2nd STAGE FILTERS |
Remove and Replace 2nd Stage Filters. Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019.
| Every 18 months; first change is August 2021; therefore the Gov’t does not anticipate use of this CLIN in the base year. This CLIN is for the event that paint booth use increases and filters must be changed prior to scheduled date. | 1 | Each | $0.00 | $0.00 | Second Stage Filter Cost: |
| 2 techs x 8 hours | 612 | $0.00 | |||
| 1005 | 3rd STAGE FILTERS |
Remove and Replace 3rd Stage Filters. Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019.
| Every 24 months; first change is May 2021; therefore the Gov’t does not anticipate use of this CLIN in the base year. This CLIN is for the event that paint booth use increases and filters must be changed prior to scheduled date. | 1 | Each | $0.00 | $0.00 | Third Stage Filter Cost: | |
| 2 techs x 8 hours | 612 | $0.00 | ||||
| Option Year 1 Total: | $30,000.00 | NTE |
| OPTION YEAR 2 - 01 May 2021 – 30 April 2022 | Price Inputs | Rate | |||||||
| CLIN | Description | Qty | Unit of Issue | Unit Price | Extended Price | Hourly Rate: | |||
| 2001 | Preventative Maintenance Program for Corrosion Control Paint Booth In Accordance With (IAW) Performance Work Statement dated 07 March 2019. | 12 | Months | $0.00 | Service Call (flat rate not to exceed two hours of contracted labor rate): | ||||
| 2002 | Additional/Miscellaneous IAW PWS dated 07 March 2019. This is a Not To Exceed (NTE) CLIN. The service provider shall complete all required non-scheduled maintenance to maintain operational readiness. All maintenance not associated with preventative program (i.e. component replacement due to failure) will be covered under this CLIN. Once a problem is identified the Vendor will notify the Government and provide a proposal for repair to include 2 quotes from 2 separate parts distributors. The Vendor will not perform maintenance unless directed by the Contracting Office. | 1 | Job | $30,000.00 | Rate | Qty | Labor | ||
| 2003 | 1st STAGE FILTERS |
Remove and Replace 1st Stage Filters.
Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019.
| Every 9 months; First change is July 2021. | 1 | Each | $0.00 | $0.00 | First Stage Filter Cost: |
| 2 techs x 8 hours | 42 | $0.00 | |||
| 2004 | 2nd STAGE FILTERS |
Remove and Replace 2nd Stage Filters. Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019.
| Every 18 months; First change is August 2021. | 1 | Each | $0.00 | $0.00 | Second Stage Filter Cost: |
| 2 techs x 8 hours | 612 | $0.00 | |||
| 2005 | 3rd STAGE FILTERS |
Remove and Replace 3rd Stage Filters. Provide maintenance In Accordance With (IAW) Performance Work Statement (PWS) dated 07 March 2019.
| Every 24 months; First change is May 2021. | 1 | Each | $0.00 | $0.00 | Third Stage Filter Cost: | |
| 2 techs x 8 hours | 612 | $0.00 | ||||
| Option Year 2 Total: | $30,000.00 | NTE | ||||
| Total Contract: | $90,000.00 | NTE |
X002 Scenario
| SAMPLE CLIN X002 REPAIR SCENARIO |
| 1.0 SCOPE: 96 MXG requires the replacement of an existing non-functioning exhaust fan soft start on the #1 AMU in Building 72, and an igniter repair on # 1 AMU in Bldg 72. Troubleshooting took 4 hours and 2 workers. Repair took 2 workers and 14 hours. The repair is taking place in April of 2019. *Note: For the purposes of this evaluation the current JTR mileage rate, and the April 2019 JTR rates for Okaloosa/Walton County will be used for option years 1 and 2. |
In accordance with paragraph 1.5.4.2 of the Performance Work Statement (PWS) dated 07 March 2019 the travel and per diem for troubleshooting is covered in the service fee.
In accordance with paragraph 1.5.4.6 of the PWS dated 07 March 2019 the Contractor will be authorized travel expenses consistent with and no higher than the substantive provisions of the Joint Travel Regulation (JTR) and the limitation of funds specified in this contract. Mileage and per diem will not be allowed unless travel is 50 miles or more from Eglin AFB, FL. In no case will the total travel reimbursement for any repair exceed the travel dollars estimated in the proposal and no profit is allowed on travel costs.
| Material (to include shipping, taxes, overhead and profit) | |||||
| Item | Qty | Unit Price | Extended Price | ||
| #1 Soft start | 1 | $3,000.00 | $3,000.00 | ||
| Ignition Switch & Wire | 1 | $150.00 | $150.00 | ||
| Material Subtotal | $3,150.00 | ||||
| Travel* | |||||
| Item | Qty | Daily Rate | Extended Price | ||
| Mileage | $0.58 | $0.00 | |||
| Lodging Per Diem | $162.00 | $0.00 | |||
| M&IE Per Diem | $66.00 | $0.00 | |||
| Travel Subtotal | $0.00 | ||||
| Base Year Repair Cost Inputs | |||||
| Labor (Fully burdened and including overhead/profit) | |||||
| Item | Qty (Hours) | Unit Price | Extended Price | ||
| Troubleshooting – Worker 1 | 4 | $0.00 | $0.00 | ||
| Troubleshooting - Worker 2 | 4 | $0.00 | $0.00 | Description | Amount |
| Repair – Worker 1 | 14 | $0.00 | $0.00 | Material Subtotal | $3,150.00 |
| Repair – Worker 2 | 14 | $0.00 | $0.00 | Labor Subtotal | $0.00 |
| Repair Travel Hours – Worker 1 | $0.00 | $0.00 | Travel Subtotal | $0.00 | |
| Repair Travel Hours – Worker 2 | $0.00 | $0.00 | Flat Service Fee | $0.00 | |
| Labor Subtotal | $0.00 | Base Year Repair Total | $3,150.00 | ||
| Option Year 1 Repair Cost Inputs | |||||
| Labor (Fully burdened and including overhead/profit) | |||||
| Item | Qty (Hours) | Unit Price | Extended Price | ||
| Troubleshooting – Worker 1 | 4 | $0.00 | $0.00 | ||
| Troubleshooting - Worker 2 | 4 | $0.00 | $0.00 | Description | Amount |
| Repair – Worker 1 | 14 | $0.00 | $0.00 | Material Subtotal | $3,150.00 |
| Repair – Worker 2 | 14 | $0.00 | $0.00 | Labor Subtotal | $0.00 |
| Repair Travel Hours – Worker 1 | $0.00 | $0.00 | Travel Subtotal | $0.00 | |
| Repair Travel Hours – Worker 2 | $0.00 | $0.00 | Flat Service Fee | $0.00 | |
| Labor Subtotal | $0.00 | Option Year 1 Repair Total | $3,150.00 | ||
| Option Year 2 Repair Cost Inputs | |||||
| Labor (Fully burdened and including overhead/profit) | |||||
| Item | Qty (Hours) | Unit Price | Extended Price | ||
| Troubleshooting – Worker 1 | 4 | $0.00 | $0.00 | ||
| Troubleshooting - Worker 2 | 4 | $0.00 | $0.00 | Description | Amount |
| Repair – Worker 1 | 14 | $0.00 | $0.00 | Material Subtotal | $3,150.00 |
| Repair – Worker 2 | 14 | $0.00 | $0.00 | Labor Subtotal | $0.00 |
| Repair Travel Hours – Worker 1 | $0.00 | $0.00 | Travel Subtotal | $0.00 | |
| Repair Travel Hours – Worker 2 | $0.00 | $0.00 | Flat Service Fee | $0.00 | |
| Labor Subtotal | $0.00 | Option Year 2 Repair Total | $3,150.00 |
TEP
| Preventative Maintenance | |||||||
| Extended Price | X002 Scenario Amt | First Stage Filters | |||||
| Extended Price | Second Stage Filters | ||||||
| Extended Price | Third Stage Filters | ||||||
| Extended Price | Extended Totals | ||||||
| Base Year | $0.00 | $3,150.00 | $0.00 | $0.00 | $0.00 | $3,150.00 | |
| Option Year 1 | $0.00 | $3,150.00 | $0.00 | $0.00 | $0.00 | $3,150.00 | |
| Option Year 2 | $0.00 | $3,150.00 | $0.00 | $0.00 | $0.00 | $3,150.00 | |
| 6 Month Extension | |||||||
| This price will be half the price of your extended total for CLIN 2001 | $0.00 | $1,575.00 | $0.00 | $0.00 | $0.00 | $1,575.00 | |
| Total Evaluated Price (TEP) | $11,025.00 |
File details come from the government source that posted it.