The file's text, extracted by GovTribe without its formatting.
0. Instructions
| Attachment 5: Pricing Matrix |
| Instructions: The Contractor shall provide all personnel, labor, equipment, supplies, tools, materials, supervision, travel, periodic inspection, minor repair, and other items/services necessary to provide maintenance of Air Force vehicle barrier systems as defined in the Vehicle Barriers Maintenance and Repair (VB M&R) Performance Work Statement (PWS) at Attachment 1 to the Request for Proposal (RFP). |
This Pricing Matrix is required from all Offerors who wish to submit proposals in response to RFP No. FA8003-18-R-0001, per the Addendum to FAR 52.212-1, Instructions to Offerors. Offerors are to provide pricing for two different areas: 1) Not-to-Exceed (NTE) markup rates (percentage) that will be binding at the MAC IDIQ level and apply to all subsequent Task Orders issued against the MAC IDIQ for each ordering period; and 2) a sample Task Order for Wright-Patterson AFB, OH (for evaluation purposes only) for which the Offeror will indicate the required types of labor (categories, rates, and hours) which will be combined with materials for minor repair costs (pre-populated per the amounts stipulated in the PWS) to determine a Total Evaluated Price (TEP) that will not be binding at the MAC IDIQ level but will be used for evaluation purposes at the MAC IDIQ level. Along with the notes/instructions provided at the top of each worksheet, the following guidelines have been established to assist Offerors in the completion of this Pricing Matrix:
1. Complete each worksheet ("2. NTE Markup Rates", "3. Wages", and "4-9. Sample TO" (for each Ordering Period and the 6-Month Extension) within this Pricing Matrix in order to ensure the necessary information will be auto-populated into the final worksheet ("10. Total Evaluated Price"). Be sure to click the right arrow in the bottom left-hand corner to be able to view all worksheets - there are a total of 10 worksheets not including the instructions.
2. The Offeror shall only fill out the required cells highlighted in blue; all other cells do not require Offeror fill-ins. All cells highlighted in blue must be completed, except for those as specifically indicated. Within worksheets 2-9, complete all blue cells (no other cells require fill-ins by the Offeror). The Offeror may leave some blue cells blank if not needed under Labor Category and Hourly Rate in worksheet "3. Wages" and Quantity in worksheets "4-9. Sample TO".
3. Review the worksheet titled “10. Total Evaluated Price” to ensure the total evaluated price (TEP) is reflecting the Offeror's proposed TEP for the sample Task Order. If incorrect, review the entire Pricing Matrix to locate errors.
4. On any of the worksheets within this Pricing Matrix, the Offeror shall not tamper with the provided rows, columns, or formulas or add/remove any information other than what is requested in this worksheet.
FA8003-18-R-0001 Vehicle Barriers Maintenance and Repair Attachment 5: Pricing Matrix
&9Tab 0 of 10
FA8003-18-R-0001
Attachment 5: Pricing Matrix
1. Sample TO Info
| Sample Task Order Information |
| Note: On this worksheet, the Government has provided details on a sample Task Order to include a list of vehicle barrier systems for the Offeror to provide all personnel, labor, equipment, supplies, tools, materials, supervision, travel, periodic inspection, repair, and other items and services necessary to perform vehicle barriers maintenance and repair as defined in the PWS. The Task Order is representative of work at one base/location covering a base period of one (1) base year with four (4) one-year option periods and one (1) six-month extension. The Offeror will price the sample Task Order on worksheets “4-9. Sample TO” (one worksheet per ordering period and 6-month extension). |
Project Specifics:
| Project Title: | Vehicle Barrier Maintenance and Repair |
| Location: | Wright-Patterson AFB, OH |
| Period of Performance: | Base Year, Option Year 1, Option Year 2, Option Year 3, Option Year 4, and 6-Month Extension |
| Scope of Work: |
| IAW the MAC IDIQ’s PWS found at RFP Attachment 1, the Contractor shall provide all personnel, labor, equipment, supplies, tools, materials, supervision, travel, periodic inspection, minor repair, and other items and services necessary to provide maintenance for the vehicle barrier systems identified in the chart below for a sample Task Order at Wright-Patterson AFB (Note: This sample Task Order is for evaluation purposes only, and the information below is not representative of Wright-Patterson AFB's or actual barrier systems). In this evaluation scenario, Wright-Patterson AFB has a total of three (3) gates with five (5) vehicle barrier systems. All vehicle barrier systems identified in the chart below are currently in green status (see RFP Attachment 1: PWS, Appendix I for definition). For the Routine and Emergency Service Call CLINs (X002 and X003 respectively), the Contractor shall provide two (2) Routine Service Calls and four (4) Emergency Service Calls for the Base Year and each Option Year (1-4), and one (1) Routine Service Call and one (1) Emergency Call for the 6-Month Extension of Services. |
| Required CLINs: | | | |
| Base Year | | | |
| Item No. | Supplies/Services | Quantity | Unit |
| CLIN 0001 | Preventive Maintenance | 1 | LOT |
| CLIN 0002 | Routine Service Call | 2 | EACH |
| CLIN 0003 | Emergency Service Call | 4 | EACH |
| Option Year 1 | | | |
| Item No. | Supplies/Services | Quantity | Unit |
| CLIN 1001 | Preventive Maintenance | 1 | LOT |
| CLIN 1002 | Routine Service Call | 2 | EACH |
| CLIN 1003 | Emergency Service Call | 4 | EACH |
| Option Year 2 | | | |
| Item No. | Supplies/Services | Quantity | Unit |
| CLIN 2001 | Preventive Maintenance | 1 | LOT |
| CLIN 2002 | Routine Service Call | 2 | EACH |
| CLIN 2003 | Emergency Service Call | 4 | EACH |
| Option Year 3 | | | |
| Item No. | Supplies/Services | Quantity | Unit |
| CLIN 3001 | Preventive Maintenance | 1 | LOT |
| CLIN 3002 | Routine Service Call | 2 | EACH |
| CLIN 3003 | Emergency Service Call | 4 | EACH |
| Option Year 4 | | | |
| Item No. | Supplies/Services | Quantity | Unit |
| CLIN 4001 | Preventive Maintenance | 1 | LOT |
| CLIN 4002 | Routine Service Call | 2 | EACH |
| CLIN 4003 | Emergency Service Call | 4 | EACH |
| 6-Month Extension | | | |
| Item No. | Supplies/Services | Quantity | Unit |
| CLIN 5001 | Preventive Maintenance | 1 | LOT |
| CLIN 5002 | Routine Service Call | 1 | EACH |
| CLIN 5003 | Emergency Service Call | 2 | EACH |
Statement of Need:
CLIN X001:
The Contractor shall conduct preventive maintenance IAW the basic contract’s PWS Section 1.3 for the five (5) barrier types identified in the chart below. Specifically, the Contractor shall provide a total of four (4) quarterly maintenance, inspections, and repair services to include those actions required to preserve and maintain the five (5) vehicle barrier systems in such a condition to function efficiently. For each of the five (5) vehicle barrier systems, the Contractor shall provide the following elements of preventive maintenance as identified in the basic contract’s PWS Section 1.3:
| Technical Data (OEM O&M information) | |
| Barrier Pits (maintain cleanliness) | |
| Contractor Hotline (telephone call log for Task Order) | |
| Telephone Support (after notification from CO/COR, Lead Technician needs to be able to attempt to resolve situation over telephone) | |
| Annual Training (performed by Lead Technician and/or crew for each barrier system) | |
| Paint/Corrosion Control (repaint entire barrier during summer session of quarterly PM; pressure wash, remove corrosion, apply primer) | |
| Minor Repairs (labor only, parts allowance provided at $50 per barrier per quarter IAW PWS) | |
| Applicable Contract Data Requirements List (CDRL) Items: | |
| CDRL A001: Maintenance and Repair Log (record that covers duration of Task Order and is provided to Government at completion of Task Order; includes equipment repair costs, deficiencies, problem areas, warranty information, non-serviceable equipment, per PWS Section 6.3) |
Monthly Project Meetings (via teleconference to discuss Task Order issues, work schedule, traffic control plans, coordination plans, per PWS Section 5.2)
Preventive Maintenance (PM) In/Out Briefs (upon completion of work; includes items such as status of completed work, operational status, PM checklist, etc., per PWS Section 5.3)
Quarterly Reports (related to PM only; includes items such as condition and work completed on all barriers, separate sections for PM at each gate location, dates/times/locations of PM performed, etc., per PWS Section 7.1)
CDRL A002: Annual Training (provide one (1) copy of recorded training to Government on DVD and provide laminated placards (for each guard house where barrier(s) is located), per PWS Section 1.3.1.5)
CLIN X002:
Routine service calls shall be conducted IAW PWS Sections 8.1.1, 8.1.3, and 8.3.1. Starting from approval by the CO, the Lead Technician shall be on-site within 24 hours or by 1000hrs the next business day (whichever is greater). The number of instances of routine service calls are identified in the CLIN tables above.
CLIN X003:
Emergency service calls shall be conducted IAW PWS Section 8.1.1, 8.1.2, and 8.3.1. Starting from approval by the CO, the Lead Technician shall be on-site within six (6) hours. The number of instances of emergency service calls are identified in the CLIN tables above.
| Sample Task Order – Wright Patterson AFB sample Barrier/Equipment Information: | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| Gate Name | Active Vehicle Barrier | | | | | | Main Control Panel | | | Slave (secondary) Control Panels | | | | Stand-alone EFO Panel/Button | | | | Lanes In | Lanes Out | AVB Traffic Controls System | Warning Systems | Vehicle Detection System @ AVB | | Wrong Way Detection | Over speed destection | Overspeed Detection | Wrong way detection | Condition/Comments |
| Type | Power | Model # | Year | Pit Heater | Qty | Type | Model # | Year | Type | Model # | Year | Qty | Type | Model # | Year | Qty | Qty | Qty | Type | Type | Y/N | Type | Y/N | Type | Y/N | Type | |
| North Gate | Net | ELEC | USR GRAB-300 | 2011 | N | 2 | S&B | GRAB Part # 100841025018762 | 2011 | S&B | GRAB Part # 100841025018763 | 2011 | 2 | S&B | GRAB Part # 1008310210751 | 2011 | 2 | 2 | 2 | Overhead traffic lights over each lane | Horn/wig wag safety beacon | Y | Induction Loop | Y | Radar | Y | Radar | All equipment is operational. |
South Gate Wedge HYDR Delta Scientific DSC 501 2007 Y 4 S&B Delta Scientific DSC 501 2007 S&B Delta Scientific DSC 501 2007 2 S&B Dayton push button control station #36UX19 2007 5 2 2 overhead mounted traffic signals over each lane Wig wag lights Y Induction Loop Y Radar Y Radar All are fully operational.
| East Gate | Wedge | HYDR | Delta DSC 501 | 2007 | Y | 4 | S&B | Delta DSC 501 | 2003 | S&B | Delta DSC 501 | 2003 | 2 | S&B | UNK | 2003 | 3 | 2 | 2 | Overhead mast arm with traffic signals over each lane plus two pole mounted traffic signals to the right of roadway | Wig wag lights and annunciator | Y | Induction Loop | Y | Radar | Y | Radar | All equipment is operational. |
| East Gate | Bollard | HYDR | Delta DSC 701 | 2014 | N | 2 | S&B | | | | | | | | | | | | | | | | | | | | | All equipment is operational. Each DSC 701 barrier include 3 bollards per barier used to create serpentine traffic flow on inbound lane. |
| East Gate | Drop Arm | ELEC | DoorKing 1601 | 2001 | N | 4 | S&B | | | | | | | | | | | | | | | | | | | | | |
| HYDR | Hydraulic |
| ELEC | Electric |
| S&B | Switch and button human machine interface |
| TS | Touch screen human interface |
| PLC | Programmable Logic Control |
FA8003-18-R-0001 Vehicle Barriers Maintenance and Repair Attachment 5: Pricing Matrix
Tab 1 of 10
2. NTE Markup Rates Binding Not-To-Exceed (NTE) Markup Rates for Service Contract Labor Standards Labor Categories Required by the Performance Work Statement (PWS) (will be binding at MAC IDIQ level)
| Note: Offeror shall complete all blue cells on this worksheet, to include their company information and their proposed NTE markup rates for each ordering period and each CLIN (X001-X003). Company information includes the Offeror’s Name in cell B6, Preparer’s Name in cell B7, DUNS Number in cell B8, and CAGE Code in cell B9, and the proposed NTE markup rates for CLINs X001-X003 for each ordering period and the 6-month extension in cells B13 through D18. The NTE markup rate should be represented as a percentage with no decimals. Offeror shall propose a NTE markup rate (percentage) for Preventive Maintenance (CLIN X001), Routine Service Call (CLIN X002), and Emergency Service Call (CLIN X003) for each ordering period of the MAC IDIQ, to include the Base Year, all Option Years, and the 6-Month Extension of Services. A markup rate is expressed as a percentage and is added to the cost/price incurred by the producer of a good/service in order to cover the costs of doing business and create a profit. The NTE markup rate should be represented as a percentage with no decimals. The NTE markup rate shall be inclusive of all necessary elements per the description of work for Preventive Maintenance, Routine Service Calls, and Emergency Service Calls as described in RFP Attachment 1: PWS, as required for performance at all potential locations per the Addendum to FAR 52.212-1, Tables 1 and 2. The NTE markup rate percentages shall be binding as maximum markup rates on all Task Orders proposed in the corresponding MAC IDIQ ordering period, and is to be applied to the base hourly labor rates for each labor category proposed per the minimum wages as established for the specific Task Order location IAW FAR 52.222-41, Service Contract Labor Standards, using the wage determinations as attached to the MAC IDIQ contract for that ordering period. The proposed NTE markup rates will auto-populate from this worksheet into worksheets “4-9. Sample TO” as part of the Offeror’s pricing for the sample Task Order. | | | |
| Offeror's Name: | | | |
| Preparer's Name: | | | |
| DUNS Number: | | | |
| CAGE Code: | | | |
| Required Service Contract Labor Standards Wage Rate Binding NTE Markup Rates | | | |
| Ordering Period | NTE Markup Rates per CLIN | | |
| CLIN X001 Preventive Mainenance | CLIN X002 Routine Service Call | CLIN X003 Emergency Service Call |
| Base Year | | | |
| Option Year 1 | | | |
| Option Year 2 | | | |
| Option Year 3 | | | |
| Option Year 4 | | | |
| 6-Month Extension of Services* | | | |
| *Offerors are to assume (for evaluation purposes only) that the total 6-month extension shall be incorporated after Option Year/Ordering Period 4 has expired; however, IAW FAR Clause 52.217-8, Extension of Services (up to six (6) months), the Government reserves the right to exercise this clause during any ordering period. If the clause is exercised, pricing will be determined at the time of exercise, based upon current unit pricing. | | | |
FA8003-18-R-0001 Vehicle Barriers Maintenance and Repair Attachment 5: Pricing Matrix
Tab 2 of 10
3. Wages
| Wages for Service Contract Labor Standards Labor Categories Required by the PWS (will not be binding at MAC IDIQ level -- for evaluation purposes only) | |
| Note: Offeror shall complete the blue cells on this worksheet for all labor categories (starting in cell A8) as well as a base hourly labor rate (starting in cell B8) for each identified labor category for all types of labor required to accomplish the work on the sample Task Order per the requirements of the PWS, for each ordering period. Not all blue cells need to be filled out on this worksheet depending on the number of labor categories the Offeror determines to be necessary to complete the work. For purposes of this evaluation, the sample Task Order will take place at Wright-Patterson AFB, OH. The base hourly labor rates shall be reflective of the exact wages for the selected labor categories as established for the area of Wright-Patterson AFB IAW FAR 52.222-41, Service Contract Labor Standards, using the wage determinations as attached to the RFP (see Attachments 8-13). The labor categories and base hourly labor rates will auto-populate from this worksheet to worksheets “4-9. Sample TO” for the Offeror to select from when developing their sample Task Order pricing. | |
| Base Location: | Wright-Patterson AFB, OH |
| Project Title/Description: | Vehicle Barriers Maintenance and Repair |
| Period of Performance: | Base Year, 4 One (1) Year Options, and 6-Month Extension |
| Base Year | |
| Labor Category | Base Hourly Labor Rate |
| Option Year 1 | |
| Labor Category | Base Hourly Labor Rate |
| Option Year 2 | |
| Labor Category | Base Hourly Labor Rate |
| Option Year 3 | |
| Labor Category | Base Hourly Labor Rate |
| Option Year 4 | |
| Labor Category | Base Hourly Labor Rate |
| 6-Month Extension | |
| Labor Category | Base Hourly Labor Rate |
Attachment 5: Pricing Matrix
Tab 3 of 10
4. Sample TO - Base Year
| Sample Task Order Pricing (will not be binding at MAC IDIQ level -- for evaluation purposes only) | | | | |
| Note: This worksheet is to be used for pricing the sample Task Order. Specifics of the sample Task Order can be found in worksheet "1. Sample TO Info." For each CLIN, Offeror shall complete the blue cells in the “Quantity” column beginning in cell B20 with the number of hours for each identified labor category required to accomplish the work on the sample Task Order for all three CLINs (X001-X003). The labor categories and base hourly labor rates will auto-populate from worksheet “3. Wages” for the Offeror to choose from when developing their sample Task Order pricing, and the NTE markup rates will auto-populate from worksheet “2. NTE Markup Rates.” For each labor category utilized, the worksheets will automatically multiply the base hourly labor rate by the NTE markup rate to determine the fully burdened hourly labor rate, which will then automatically multiply by the quantity (number) of labor hours in order to determine a total for that individual labor category. The total of all labor categories utilized will be added together to determine the total price for labor for each CLIN. The material quantities and unit prices applicable to the sample Task Order have been pre-populated based on the minor repair NTE amounts as provided in the PWS, and the Offeror’s proposed NTE markup rate will not apply to material (no Offeror fill-ins are required for materials). The worksheet will automatically add the Total Labor and Total Material for each CLIN to determine the overall Total Price per CLIN in cells E5-E7, and the Total Price will be automatically divided by the quantity to determine the Unit Price per CLIN in cells D5-D7. The Total Price by year will auto-calculate in cell E16. The cells in gray (B-8 - E-15) are not priced at the basic MAC IDIQ level and are provided only for reference purposes, and do not require fill-ins from the Offeror. | | | | |
| Base Year | | | | |
| CLIN Number/Description | Quantity | Unit | Unit Price (Total Price / Quantity) | Total Price (Labor + Materials) |
| 0001 Preventive Maintenance | 1 | Lot | $1,000.00 | $1,000.00 |
| 0002 Routine Service Calls | 2 | Visit | $100.00 | $200.00 |
| 0003 Emergency Service Calls | 4 | Visit | $100.00 | $400.00 |
| 0004 Additional In-Scope Work | | | | |
| 0005 Barrier System Controls Schematic | | | | |
| 0006 CDRL A001 - Status Reports (Task Order Level) | | | | |
| 0007 CDRL A002 - Training Materials (Task Order Level) | | | | |
| 0008 CDRL A003 - Status Reports (MAC IDIQ Level) | | | | |
| 0009 CDRL A004 - Barrier System Controls Schematic (Task Order Level) | | | | |
| 0010 Program Management Review | | | | |
| 0011 Post Award Orientation | | | | |
| Total Price Base Year | | | | $1,600.00 |
| Base Year - Labor Applicable to This Project | | | | | | |
| CLIN 0001 - Preventive Maintenance Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 0001 | | | | | | $0.00 |
| Base Year - Material Applicable to This Project | | | | | |
| CLIN 0001 - Preventive Maintenance Material | Quantity | Unit | Unit Price | Visits per PoP | Total (Qty x Unit Price x Visits) |
| Material per PWS | 5 | Each | $50.00 | 4 | $1,000.00 |
| Total Material CLIN 0001 | | | | | $1,000.00 |
| Base Year - Labor Applicable to This Project | | | | | | |
| CLIN 0002 - Routine Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 0002 | | | | | | $0.00 |
| Base Year - Material Applicable to This Project | | | | |
| CLIN 0002 - Routine Service Calls Material | Quantity | Unit | Unit Price | Total (Qty x Unit Price) |
| Material per PWS | 2 | Each | $100.00 | $200.00 |
| Total Material CLIN 0002 | | | | $200.00 |
| Base Year - Labor Applicable to This Project | | | | | | |
| CLIN 0003 - Emergency Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | $0.00 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 0003 | | | | | | $0.00 |
| Base Year - Material Applicable to This Project | | | | |
| CLIN 0003 - Emergency Service Calls Material | Quantity | Unit | Unit Price | Total (Qty x Unit Price) |
| Material per PWS | 4 | Each | $100.00 | $400.00 |
| Total Material CLIN 0003 | | | | $400.00 |
Attachment 5: Pricing Matrix
Tab 4 of 10
5. Sample TO - Option Year 1
| Sample Task Order Pricing (will not be binding at MAC IDIQ level -- for evaluation purposes only) | | | | |
| Note: This worksheet is to be used for pricing the sample Task Order. Specifics of the sample Task Order can be found in worksheet "1. Sample TO Info." For each CLIN, Offeror shall complete the blue cells in the “Quantity” column beginning in cell B19 with the number of hours for each identified labor category required to accomplish the work on the sample Task Order for all three CLINs (X001-X003). The labor categories and base hourly labor rates will auto-populate from worksheet “3. Wages” for the Offeror to choose from when developing their sample Task Order pricing, and the NTE markup rates will auto-populate from worksheet “2. NTE Markup Rates.” For each labor category utilized, the worksheets will automatically multiply the base hourly labor rate by the NTE markup rate to determine the fully burdened hourly labor rate, which will then automatically multiply by the quantity (number) of labor hours in order to determine a total for that individual labor category. The total of all labor categories utilized will be added together to determine the total price for labor for each CLIN. The material quantities and unit prices applicable to the sample Task Order have been pre-populated based on the minor repair NTE amounts as provided in the PWS, and the Offeror’s proposed NTE markup rate will not apply to material (no Offeror fill-ins are required for materials). The worksheet will automatically add the Total Labor and Total Material for each CLIN to determine the overall Total Price per CLIN in cells E5-E7, and the Total Price will be automatically divided by the quantity to determine the Unit Price per CLIN in cells D5-D7. The Total Price by year will auto-calculate in cell E15. The cells in gray (B-8 - E-15) are not priced at the basic MAC IDIQ level and are provided only for reference purposes, and do not require fill-ins from the Offeror. | | | | |
| Option Year 1 | | | | |
| CLIN Number / Description | Quantity | Unit | Unit Price (Total Price / Quantity) | Total Price (Labor + Materials) |
| 1001 Preventive Maintenance | 1 | Lot | $1,000.00 | $1,000.00 |
| 1002 Routine Service Calls | 2 | Visit | $100.00 | $200.00 |
| 1003 Emergency Service Calls | 4 | Visit | $100.00 | $400.00 |
| 1004 Additional In-Scope Work | | | | |
| 1005 Barrier System Controls Schematic | | | | |
| 1006 CDRL A001 - Status Reports (Task Order Level) | | | | |
| 1007 CDRL A002 - Training Materials (Task Order Level) | | | | |
| 1008 CDRL A003 - Status Reports (MAC IDIQ Level) | | | | |
| 1009 CDRL A004 - Barrier System Controls Schematic (Task Order Level) | | | | |
| 1010 Program Management Review | | | | |
| Total Price Option Year 1 | | | | $1,600.00 |
| Option Year 1 - Labor Applicable To This Project | | | | | | |
| CLIN 1001 - Preventative Maintenance Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Mark Up Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 1001 | | | | | | $0.00 |
| Option Year 1 - Material Applicable To This Project | | | | | |
| CLIN 1001 - Preventative Maintenance Material | Quantity | Unit | Unit Price | Visits per PoP | Total Price (QTY x Unit Price x Visits) |
| Material per PWS | 5 | Each | 50 | 4 | $1,000.00 |
| Total Material CLIN 1001 | | | | | $1,000.00 |
| Option Year 1 - Labor Applicable To This Project | | | | | | |
| CLIN 1002 - Routine Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 1002 | | | | | | $0.00 |
| Option Year 1 - Material Applicable To This Project | | | | |
| CLIN 1002 - Routine Service Calls Material | Quantity | Unit | Unit Price | Total Price (Qty x Unit Price) |
| Material per PWS | 2 | Each | $100.00 | $200.00 |
| Total Material CLIN 1002 | | | | $200.00 |
| Option Year 1 - Labor Applicable To This Project | | | | | | |
| CLIN 1003 - Emergency Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 1003 | | | | | | $0.00 |
| Option Year 1 - Material Applicable To This Project | | | | |
| CLIN 1003 - Emergency Service Calls Material | Quantity | Unit | Unit Price | Total (Qty x Unit Price) |
| Material per PWS | 4 | Each | $100.00 | $400.00 |
| Total Material CLIN 1003 | | | | $400.00 |
Attachment 5: Pricing Matrix
Tab 5 of 10
6. Sample TO - Option Year 2
| Sample Task Order Pricing (will not be binding at MAC IDIQ level -- for evaluation purposes only) | | | | |
| Note: This worksheet is to be used for pricing the sample Task Order. Specifics of the sample Task Order can be found in worksheet "1. Sample TO Info." For each CLIN, Offeror shall complete the blue cells in the “Quantity” column beginning in cell B19 with the number of hours for each identified labor category required to accomplish the work on the sample Task Order for all three CLINs (X001-X003). The labor categories and base hourly labor rates will auto-populate from worksheet “3. Wages” for the Offeror to choose from when developing their sample Task Order pricing, and the NTE markup rates will auto-populate from worksheet “2. NTE Markup Rates.” For each labor category utilized, the worksheets will automatically multiply the base hourly labor rate by the NTE markup rate to determine the fully burdened hourly labor rate, which will then automatically multiply by the quantity (number) of labor hours in order to determine a total for that individual labor category. The total of all labor categories utilized will be added together to determine the total price for labor for each CLIN. The material quantities and unit prices applicable to the sample Task Order have been pre-populated based on the minor repair NTE amounts as provided in the PWS, and the Offeror’s proposed NTE markup rate will not apply to material (no Offeror fill-ins are required for materials). The worksheet will automatically add the Total Labor and Total Material for each CLIN to determine the overall Total Price per CLIN in cells E5-E7, and the Total Price will be automatically divided by the quantity to determine the Unit Price per CLIN in cells D5-D7. The Total Price by year will auto-calculate in cell E15. The cells in gray (B-8 - E-15) are not priced at the basic MAC IDIQ level and are provided only for reference purposes, and do not require fill-ins from the Offeror. | | | | |
| Option Year 2 | | | | |
| CLIN Number / Description | Quantity | Unit | Unit Price (Total Price / Quantity) | Total Price (Labor + Materials) |
| 2001 Preventive Maintenance | 1 | Lot | $1,000.00 | $1,000.00 |
| 2002 Routine Service Calls | 2 | Visit | $100.00 | $200.00 |
| 2003 Emergency Service Calls | 4 | Visit | $100.00 | $400.00 |
| 2004 Additional In-Scope Work | | | | |
| 2005 Barrier System Controls Schematic | | | | |
| 2006 CDRL A001 - Status Reports (Task Order Level) | | | | |
| 2007 CDRL A002 - Training Materials (Task Order Level) | | | | |
| 2008 CDRL A003 - Status Reports (MAC IDIQ Level) | | | | |
| 2009 CDRL A004 - Barrier System Controls Schematic (Task Order Level) | | | | |
| 2010 Program Management Review | | | | |
| Total Price Option Year 2 | | | | $1,600.00 |
| Option Year 2 - Labor Applicable To This Project | | | | | | |
| CLIN 2001 - Preventative Maintenance Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Mark Up Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 2001 | | | | | | $0.00 |
| Option Year 2 - Material Applicable To This Project | | | | | |
| CLIN 2001 - Preventative Maintenance Material | Quantity | Unit | Unit Price | Visits per PoP | Total Price (QTY x Unit Price x Visits) |
| Material per PWS | 5 | Each | 50 | 4 | $1,000.00 |
| Total Material CLIN 2001 | | | | | $1,000.00 |
| Option Year 2 - Labor Applicable To This Project | | | | | | |
| CLIN 2002 - Routine Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 2002 | | | | | | $0.00 |
| Option Year 2 - Material Applicable To This Project | | | | |
| CLIN 2002 - Routine Service Calls Material | Quantity | Unit | Unit Price | Total Price (Qty x Unit Price) |
| Material per PWS | 2 | Each | $100.00 | $200.00 |
| Total Material CLIN 2002 | | | | $200.00 |
| Option Year 2 - Labor Applicable To This Project | | | | | | |
| CLIN 2003 - Emergency Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 2003 | | | | | | $0.00 |
| Option Year 2 - Material Applicable To This Project | | | | |
| CLIN 2003 - Emergency Service Calls Material | Quantity | Unit | Unit Price | Total (Qty x Unit Price) |
| Material per PWS | 4 | Each | $100.00 | $400.00 |
| Total Material CLIN 2003 | | | | $400.00 |
Attachment 5: Pricing Matrix
Tab 6 of 10
7. Sample TO - Option Year 3
| Sample Task Order Pricing (will not be binding at MAC IDIQ level -- for evaluation purposes only) | | | | |
| Note: This worksheet is to be used for pricing the sample Task Order. Specifics of the sample Task Order can be found in worksheet "1. Sample TO Info." For each CLIN, Offeror shall complete the blue cells in the “Quantity” column beginning in cell B19 with the number of hours for each identified labor category required to accomplish the work on the sample Task Order for all three CLINs (X001-X003). The labor categories and base hourly labor rates will auto-populate from worksheet “3. Wages” for the Offeror to choose from when developing their sample Task Order pricing, and the NTE markup rates will auto-populate from worksheet “2. NTE Markup Rates.” For each labor category utilized, the worksheets will automatically multiply the base hourly labor rate by the NTE markup rate to determine the fully burdened hourly labor rate, which will then automatically multiply by the quantity (number) of labor hours in order to determine a total for that individual labor category. The total of all labor categories utilized will be added together to determine the total price for labor for each CLIN. The material quantities and unit prices applicable to the sample Task Order have been pre-populated based on the minor repair NTE amounts as provided in the PWS, and the Offeror’s proposed NTE markup rate will not apply to material (no Offeror fill-ins are required for materials). The worksheet will automatically add the Total Labor and Total Material for each CLIN to determine the overall Total Price per CLIN in cells E5-E7, and the Total Price will be automatically divided by the quantity to determine the Unit Price per CLIN in cells D5-D7. The Total Price by year will auto-calculate in cell E15. The cells in gray (B-8 - E-15) are not priced at the basic MAC IDIQ level and are provided only for reference purposes, and do not require fill-ins from the Offeror. | | | | |
| Option Year 3 | | | | |
| CLIN Number / Description | Quantity | Unit | Unit Price (Total Price / Quantity) | Total Price (Labor + Materials) |
| 3001 Preventive Maintenance | 1 | Lot | $1,000.00 | $1,000.00 |
| 3002 Routine Service Calls | 2 | Visit | $100.00 | $200.00 |
| 3003 Emergency Service Calls | 4 | Visit | $100.00 | $400.00 |
| 3004 Additional In-Scope Work | | | | |
| 3005 Barrier System Controls Schematic | | | | |
| 3006 CDRL A001 - Status Reports (Task Order Level) | | | | |
| 3007 CDRL A002 - Training Materials (Task Order Level) | | | | |
| 3008 CDRL A003 - Status Reports (MAC IDIQ Level) | | | | |
| 3009 CDRL A004 - Barrier System Controls Schematic (Task Order Level) | | | | |
| 3010 Program Management Review | | | | |
| Total Price Option Year 3 | | | | $1,600.00 |
| Option Year 3 - Labor Applicable To This Project | | | | | | |
| CLIN 3001 - Preventative Maintenance Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Mark Up Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 3001 | | | | | | $0.00 |
| Option Year 3 - Material Applicable To This Project | | | | | |
| CLIN 3001 - Preventative Maintenance Material | Quantity | Unit | Unit Price | Visits per PoP | Total Price (QTY x Unit Price x Visits) |
| Material per PWS | 5 | Each | 50 | 4 | $1,000.00 |
| Total Material CLIN 3001 | | | | | $1,000.00 |
| Option Year 3 - Labor Applicable To This Project | | | | | | |
| CLIN 3002 - Routine Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 3002 | | | | | | $0.00 |
| Option Year 3 - Material Applicable To This Project | | | | |
| CLIN 3002 - Routine Service Calls Material | Quantity | Unit | Unit Price | Total Price (Qty x Unit Price) |
| Material per PWS | 2 | Each | $100.00 | $200.00 |
| Total Material CLIN 3002 | | | | $200.00 |
| Option Year 3 - Labor Applicable To This Project | | | | | | |
| CLIN 3003 - Emergency Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 3003 | | | | | | $0.00 |
| Option Year 3 - Material Applicable To This Project | | | | |
| CLIN 3003 - Emergency Service Calls Material | Quantity | Unit | Unit Price | Total (Qty x Unit Price) |
| Material per PWS | 4 | Each | $100.00 | $400.00 |
| Total Material CLIN 3003 | | | | $400.00 |
Attachment 5: Pricing Matrix
Tab 7 of 10
8. Sample TO - Option Year 4
| Sample Task Order Pricing (will not be binding at MAC IDIQ level -- for evaluation purposes only) | | | | |
| Note: This worksheet is to be used for pricing the sample Task Order. Specifics of the sample Task Order can be found in worksheet "1. Sample TO Info." For each CLIN, Offeror shall complete the blue cells in the “Quantity” column beginning in cell B19 with the number of hours for each identified labor category required to accomplish the work on the sample Task Order for all three CLINs (X001-X003). The labor categories and base hourly labor rates will auto-populate from worksheet “3. Wages” for the Offeror to choose from when developing their sample Task Order pricing, and the NTE markup rates will auto-populate from worksheet “2. NTE Markup Rates.” For each labor category utilized, the worksheets will automatically multiply the base hourly labor rate by the NTE markup rate to determine the fully burdened hourly labor rate, which will then automatically multiply by the quantity (number) of labor hours in order to determine a total for that individual labor category. The total of all labor categories utilized will be added together to determine the total price for labor for each CLIN. The material quantities and unit prices applicable to the sample Task Order have been pre-populated based on the minor repair NTE amounts as provided in the PWS, and the Offeror’s proposed NTE markup rate will not apply to material (no Offeror fill-ins are required for materials). The worksheet will automatically add the Total Labor and Total Material for each CLIN to determine the overall Total Price per CLIN in cells E5-E7, and the Total Price will be automatically divided by the quantity to determine the Unit Price per CLIN in cells D5-D7. The Total Price by year will auto-calculate in cell E15. The cells in gray (B-8 - E-15) are not priced at the basic MAC IDIQ level and are provided only for reference purposes, and do not require fill-ins from the Offeror. | | | | |
| Option Year 4 | | | | |
| CLIN Number / Description | Quantity | Unit | Unit Price (Total Price / Quantity) | Total Price (Labor + Materials) |
| 4001 Preventive Maintenance | 1 | Lot | $1,000.00 | $1,000.00 |
| 4002 Routine Service Calls | 2 | Visit | $100.00 | $200.00 |
| 4003 Emergency Service Calls | 4 | Visit | $100.00 | $400.00 |
| 4004 Additional In-Scope Work | | | | |
| 4005 Barrier System Controls Schematic | | | | |
| 4006 CDRL A001 - Status Reports (Task Order Level) | | | | |
| 4007 CDRL A002 - Training Materials (Task Order Level) | | | | |
| 4008 CDRL A003 - Status Reports (MAC IDIQ Level) | | | | |
| 4009 CDRL A004 - Barrier System Controls Schematic (Task Order Level) | | | | |
| 4010 Program Management Review | | | | |
| Total Price Option Year 4 | | | | $1,600.00 |
| Option Year 4 - Labor Applicable To This Project | | | | | | |
| CLIN 4001 - Preventative Maintenance Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Mark Up Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 4001 | | | | | | $0.00 |
| Option Year 4 - Material Applicable To This Project | | | | | |
| CLIN 4001 - Preventative Maintenance Material | Quantity | Unit | Unit Price | Visits per PoP | Total Price (QTY x Unit Price x Visits) |
| Material per PWS | 5 | Each | 50 | 4 | $1,000.00 |
| Total Material CLIN 4001 | | | | | $1,000.00 |
| Option Year 4 - Labor Applicable To This Project | | | | | | |
| CLIN 4002 - Routine Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 4002 | | | | | | $0.00 |
| Option Year 4 - Material Applicable To This Project | | | | |
| CLIN 4002 - Routine Service Calls Material | Quantity | Unit | Unit Price | Total Price (Qty x Unit Price) |
| Material per PWS | 2 | Each | $100.00 | $200.00 |
| Total Material CLIN 4002 | | | | $200.00 |
| Option Year 4 - Labor Applicable To This Project | | | | | | |
| CLIN 4003 - Emergency Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 4003 | | | | | | $0.00 |
| Base Year - Material Applicable To This Project | | | | |
| CLIN 4003 - Emergency Service Calls Material | Quantity | Unit | Unit Price | Total (Qty x Unit Price) |
| Material per PWS | 4 | Each | $100.00 | $400.00 |
| Total Material CLIN 4003 | | | | $400.00 |
Attachment 5: Pricing Matrix
Tab 8 of 10
9. Sample TO - 6-Month Ext
| Sample Task Order Pricing (will not be binding at MAC IDIQ level -- for evaluation purposes only) | | | | |
| Note: This worksheet is to be used for pricing the sample Task Order. Specifics of the sample Task Order can be found in worksheet "1. Sample TO Info." For each CLIN, Offeror shall complete the blue cells in the “Quantity” column beginning in cell B19 with the number of hours for each identified labor category required to accomplish the work on the sample Task Order for all three CLINs (X001-X003). The labor categories and base hourly labor rates will auto-populate from worksheet “3. Wages” for the Offeror to choose from when developing their sample Task Order pricing, and the NTE markup rates will auto-populate from worksheet “2. NTE Markup Rates.” For each labor category utilized, the worksheets will automatically multiply the base hourly labor rate by the NTE markup rate to determine the fully burdened hourly labor rate, which will then automatically multiply by the quantity (number) of labor hours in order to determine a total for that individual labor category. The total of all labor categories utilized will be added together to determine the total price for labor for each CLIN. The material quantities and unit prices applicable to the sample Task Order have been pre-populated based on the minor repair NTE amounts as provided in the PWS, and the Offeror’s proposed NTE markup rate will not apply to material (no Offeror fill-ins are required for materials). The worksheet will automatically add the Total Labor and Total Material for each CLIN to determine the overall Total Price per CLIN in cells E5-E7, and the Total Price will be automatically divided by the quantity to determine the Unit Price per CLIN in cells D5-D7. The Total Price by year will auto-calculate in cell E15. The cells in gray (B-8 - E-15) are not priced at the basic MAC IDIQ level and are provided only for reference purposes, and do not require fill-ins from the Offeror. | | | | |
| 6-Month Extension | | | | |
| CLIN Number / Description | Quantity | Unit | Unit Price (Total Price / Quantity) | Total Price (Labor + Materials) |
| 5001 Preventive Maintenance | 1 | Lot | $500.00 | $500.00 |
| 5002 Routine Service Calls | 1 | Visit | $100.00 | $100.00 |
| 5003 Emergency Service Calls | 2 | Visit | $100.00 | $200.00 |
| 5004 Additional In-Scope Work | | | | |
| 5005 Barrier System Controls Schematic | | | | |
| 5006 CDRL A001 - Status Reports (Task Order Level) | | | | |
| 5007 CDRL A002 - Training Materials (Task Order Level) | | | | |
| 5008 CDRL A003 - Status Reports (MAC IDIQ Level) | | | | |
| 5009 CDRL A004 - Barrier System Controls Schematic (Task Order Level) | | | | |
| 5010 Program Management Review | | | | |
| Total Price 6-Month Extension | | | | $800.00 |
| 6-Month Extension - Labor Applicable To This Project | | | | | | |
| CLIN 5001 - Preventative Maintenance Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Mark Up Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 5001 | | | | | | $0.00 |
| 6-Month Extension - Material Applicable To This Project | | | | | |
| CLIN 5001 - Preventative Maintenance Material | Quantity | Unit | Unit Price | Visits per PoP | Total Price (QTY x Unit Price x Visits) |
| Material per PWS | 5 | Each | 50 | 2 | $500.00 |
| Total Material CLIN 5001 | | | | | $500.00 |
| 6-Month Extension - Labor Applicable To This Project | | | | | | |
| CLIN 4002 - Routine Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 5002 | | | | | | $0.00 |
| 6-Month Extension - Material Applicable To This Project | | | | |
| CLIN 5002 - Routine Service Calls Material | Quantity | Unit | Unit Price | Total Price (Qty x Unit Price) |
| Material per PWS | 1 | Each | $100.00 | $100.00 |
| Total Material CLIN 5002 | | | | $100.00 |
| 6-Month Extension- Labor Applicable To This Project | | | | | | |
| CLIN 5003 - Emergency Service Calls Labor Categories | Quantity | Unit | Base Hourly Labor Rate | NTE Markup Rate | Fully Burdened Hourly Labor Rate (Base Hourly Labor Rate x NTE Markup Rate) | Total (Qty x Fully Burdened Hourly Labor Rate) |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| 0 | | Hours | 0 | 0.00% | $0.00 | $0.00 |
| Total Labor CLIN 5003 | | | | | | $0.00 |
| 6-Month Extension - Material Applicable To This Project | | | | |
| CLIN 5003 - Emergency Service Calls Material | Quantity | Unit | Unit Price | Total (Qty x Unit Price) |
| Material per PWS | 2 | Each | $100.00 | $200.00 |
| Total Material CLIN 5003 | | | | $200.00 |
Attachment 5: Pricing Matrix
Tab 9 of 10
10. Total Evaluated Price
| Total Evaluated Price (will not be binding at MAC IDIQ level -- for evaluation purposes only) | | | | | | |
This is the start of the file's text. The full file is on GovTribe.