Attachment_4_Pricing_Template.xls
XLS spreadsheet 182 KB Posted
- Solicitation number
- USM-HQ-13-0018
About this file
Attachment 4 - Pricing Template
View the file
Other files
Show all 32
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
Pricing Instructions
| Instructions for Pricing Template: |
| A. Pricing Template Assumptions: |
| The purpose of the Pricing Template is for each offeror to itemize all costs associated with delivering the end-to-end solution as proposed. |
| The solution, for costing purposes, are all tasks identified in your technical approaches to fulfill a particular phase. |
| For the purposes of completing the price template the following instructions shall be considered: |
| 1. Offeror may add rows of data above the summary total line within each worksheet (highlighted). |
| 2. Offeror shall ensure additional rows flow into the worksheet total (Total Estimated Price). |
| 3. Offerors shall use the following costs in the ODC worksheet if travel and supplies is applicable. If no travel and/or supplies are applicable, state "NA". |
| a. Travel - $300,000 per annum (12 month contract period of performance, prorated for anything less) |
| b. Supplies (Supplies that is in direct support of the USM operations.) $200,000 per annum (12 month contract period of performance, prorated for anything less) |
| 4. Pricing will be based on phases as identified in the SOO. The defined phases are: |
| a. Logical Design Phase |
| b. Physical Design Phase |
| c. Operations and Maintenance Phase |
| 5. Each phase shall include any activities associated with Program and Project Management. |
| 6. Contract life shall not exceed 10 years. The period of performance is defined as follows: |
| a. Base period is equal to the proposed period of performance for Logical Design Phase |
| b. Option 1 is equal to the proposed period of performance for Physical Design Phase and shall not extend beyond October 2014 |
| c. Option 2 is Operations and Maintenance Phase, 5 year period |
| d. Option 3 is Operations and Maintenance Phase, 1 year period |
| e. Option 4 is Operations and Maintenance Phase, 1 year period |
| f. Option 5 is Operations and Maintenance Phase, 1 year period |
| g. Option 6 is Operations and Maintenance Phase, 1 year period |
| 7. Capital (leased or purchased) and other up-front costs required for Go-Live (e.g. hardware, software, telecommunications infrastructure, physical space) may be priced by one of two alternatives: |
| a. Alternative 1 – Priced in the year purchased |
| b. Alternative 2 – Amortize costs over the effective life or the contract. This alternative shall include an amortization schedule or disclosure statement that state amortized costs are included in O&M transactional rates. |
| 8. The contractor shall provide the basis for labor escalation (e.g Consumer Price Index) for each Government Fiscal Year (GFY), if applicable. |
| 9. For pricing purposes the offeror shall use 1932 for Full-Time Equivalency (FTE). The offeror shall disclose internal FTE in the Basis of Estimate. |
| B. Pricing Template and Instructions: |
| 1. Summary Rollup Worksheet – Provides summarized total price for Logical Design Phase, Physical Design Phase and ODCs associated with each phase. DO NOT EDIT SPREADSHEET FORMULAS. TOTALS WILL AUTOMATICALLY POPULATE. |
| 2. Logical Design Worksheet – Provide full itemized price for completing logical design phase. Price shall itemize per task proposed (e.g. gap analysis, design, project management). |
| 3. Physical Design Worksheet – Provide full itemized price for completing physical design. Price shall be itemized per task required to reach Go-Live (e.g., configuration, project management and testing). |
| 4. Operations and Maintenance – Provide Operations and Maintenance prices, using pricing models that are in accordance with standard business price model for these services. |
| a. Offerors are permitted to propose a combination of both transactional and flat-rate pricing. |
| b. An example of transactional pricing is any item that is charged per unit of measure such as per call, per order or per minute. |
| c. Flat rate pricing consist of fees that are reoccurring such as monthly or annually. All proposed flat rate prices shall include the methodology (itemized components with price) used to arrive at the proposed flat rate price. |
| d. Operations and Maintenance prices shall be provided for each applicable GFY. |
| e. Operations and Maintenance pricing shall be provided in the O&M worksheet only. Additional workbooks with pricing will not be accepted. |
| 5. Other Direct Cost (ODC) Worksheet – ODC includes all costs (other than labor) used to satisfy the requirement. For the purposes of this requirement ODCs are materials or supplies that are directly charged to this effort in support of fulfilling contract requirements. Identify if the material or supply will be provided by the Prime or Subcontractor. If Subcontractor, identify the applicable markup. |
| 6. Optional Features Worksheet (Separately Priced) (Reference SOO Appendix A, Section 4.0) – DO NOT COMPLETE UNTIL AFTER COMPETITIVE RANGE. |
| 7. Labor Worksheet – Provide labor category accompanied by a labor category description and a corresponding labor rate . This worksheet is for Prime and Subcontractor labor. The labor categories and descriptions provided in this worksheet will be incorporated into the resultant contract. |
| a. Labor rates shall be provided for all GFYs. |
| b. Labor categories and descriptions shall be identical to the categories and descriptions provided in the Staffing and Personnel Plan in the Management Volume. |
| 8. Basis of Estimate Worksheet – Provide narrative detailing methodology and/or supporting documentation that captures how the estimate was built (such as Full-Time Equivalency (FTE/Hours), subcontractor markup application and labor escalation) |
| 9. Assumptions Worksheet – Assumptions are the parameters in which the price proposal is built. |
&CATTACHMENT 4 - PRICING TEMPLATE
Summary Roll-Up
| Company Name | |||
| RFP Number: | |||
| Summary Roll-Up | |||
| Nomenclature | Supplies/Services | Period | Total Cost / Price |
| 0001 | Logical Design | $ - 0 | |
| 0002 | Physical Design | $ - 0 | |
| 0003 | Operations and Maintenance | ||
| 0004 | Logical Design Materials, ODCs, and Travel | $ - 0 | |
| 0005 | Physical Design Materials, ODCs, and Travel | $ - 0 |
&C&A
DO NOT EDIT SPREADSHEET FORMULAS. TOTALS WILL AUTOMATICALLY POPULATE.
Operations and Maintenance costs will not contain a summarized total. Operations and Maintenance will be itemized and incorporated in Section B of the contract.
Sample for Logical and Physical
| Company Name | ||||||||
| RFP Number | ||||||||
| Sample for Logical/Physical Design Worksheets | ||||||||
| Task: Requirements Gap Analysis | ||||||||
| Period of Performance: October 01, 2013 - October 30, 2013 | ||||||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Fully-Burdened Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Total Cost |
| PWS 9.1 | 2013 | Program Management | Program Manager | Contractor | $ 185.00 | 39 | 0.02 | $ 7,215.00 |
| PWS 9.2 | 2013 | Systems Engineer | NA | Government Site | $ 125.00 | 156 | 0.08 | $ 19,500.00 |
| PWS 9.2 | 2013 | Data Warehouse Specialist | NA | Government Site | $ 85.00 | 156 | 0.08 | $ 13,260.00 |
| PWS 9.2 | 2013 | Enterprise Architect | NA | Government Site | $ 100.00 | 78 | 0.04 | $ 7,800.00 |
| Total | $ 495.00 | 429 | 0.23 | $ 47,775.00 | ||||
| Next Task (Replicate for each task activity within each phase) | ||||||||
| Task: xxxx | ||||||||
| Period of Performance: yyyyy - yyyyy | ||||||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Fully-Burdened Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Total Cost |
| Total | $ - 0 | - 0 | - 0 | $ - 0 |
&C&A &L&F&C&A&R&P of &N
Logical Design
| Company Name | |||||||||
| RFP Number: | |||||||||
| Logical Design, PWS Section X | |||||||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Total Cost | |
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Total Cost | |
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Total Cost | |
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Total Cost | |
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| Total Estimated Cost | $ - 0 | ||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Total Cost | |
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| $ - 0 | |||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | |||||
| $ - 0 |
&C&A &L&F&C&A&R&P of &N Labor Categories and rates used shall map to Labor worksheet.
Physical Design
| Company Name | ||||||||||
| RFP Number: | ||||||||||
| Physical Design, PWS Section X | ||||||||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Sut-Total Cost | Total Cost | |
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Sut-Total Cost | Total Cost | |
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Sut-Total Cost | Total Cost | |
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Sut-Total Cost | Total Cost | |
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | $ - 0 | |||||
| Task Activity | Contract Year | Labor Category | Key Personnel Title (if applicable) | Site (Contractor vs. Government) | Burdened Hourly Labor Rate | Labor Hours | Full-Time Equivalents (FTEs) | Sut-Total Cost | Total Cost | |
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | $ - 0 | |||||
| Total Estimated Cost | $ - 0 |
&C&A &L&F&C&A&R&P of &N Labor Categories and rates used shall map to Labor worksheet.
O&M
| Company Name | |||||||||
| RFP Number: | |||||||||
| O&M, PWS Section X | |||||||||
| The tables below are provided as examples only. Offerors shall propose O&M transaction and flat rate prices based on the offerors standard pricing practices. | |||||||||
| Example 1: Flat Rate Call Center Monthly Operating Fee | |||||||||
| Contract Year | Item Description | Unit of Measure | Unit Cost | Quantity | Total Cost | 2020 | 2021 | 2022 | 2023 |
| 2014 -2019 | Call Center Labor | Monthly | NSP | $ 12,000.00 | |||||
| 2014 -2019 | • Proportional facility and facility based expenditures | Monthly | NSP | $ 1,000.00 | |||||
| 2014 -2019 | • Proportional electronic security system and monitoring | Monthly | NSP | $ 550.00 | |||||
| 2014 -2019 | • Telephony and IT installation and maintenance | Monthly | NSP | $ 350.00 | |||||
| 2014 -2019 | • Administrative costs, equipment, and furniture | Monthly | NSP | $ 125.00 | |||||
| 2014 -2019 | • Monthly cost of T3 data line | Monthly | NSP | $ 1,064.00 | |||||
| $15,089.00 | $18,861.25 | $23,576.56 | $29,470.70 | $36,838.38 | |||||
| Example 2: Flat Rate Software Licensing Fee | |||||||||
| Contract Year | Item Description | Unit of Measure | Unit Cost | Quantity | Total Cost | 2014 | 2015 | 2016 | 2017 |
| 2013 | Licensing Fee | Monthly | NSP | 1 | $ 5,500.00 | $6,875.00 | $8,593.75 | $10,742.19 | $13,427.73 |
| Example 3: Transactional Fee for Bulk Shipments | |||||||||
| Contract Year | Item Description | Unit of Measure | Unit Cost | Quantity | Total Cost | 2014 | 2015 | 2016 | 2017 |
| 2013 | Bulk Shipments (weight > 150 pounds) |
• Non-exempt labor categories Forklift operators Inventory clerks Gift wrappers Shipping handlers Material handlers
• Packaging Consumables Labels Tape Boxes Per Shipment NSP 1 $4.27 $5.34 $6.67 $8.34 $10.42
&C&A &L&F&C&A&R&P of &N
Materials_ODCs
| Company Name | ||||||||||
| RFP Number: | ||||||||||
| Materials and ODCS | ||||||||||
| The table below do not have to be completed if there are no Materials or Other Direct Costs. Materials and Other Direct Costs shall be priced in the appropriate phase. | ||||||||||
| Add lines as required to adequately capture costs. Summary total for Logical and Design Phase flow to Summary Tab. Operations and Maintenance ODCs are not summarized. | ||||||||||
| Materials/Other Direct Costs | ||||||||||
| Phase | Contract Year | Item Description | Manufacturer | Part/Product # | Unit of Measure | Unit Price (No Profit or Indirect burdens) | Markup (Indirect or Fee) | Fully Burdened Price | Quantity | Total Cost |
| Logical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Logical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Logical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Logical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Logical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Logical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Logical Design | $ - 0 | $ - 0 | ||||||||
| Total | $ - 0 | |||||||||
| Contract Year | Item Description | Manufacturer | Part/Product # | Unit of Measure | Unit Price (No Profit or Indirect burdens) | Markup (Indirect or Fee) | Fully Burdened Price | Quantity | Total Cost | |
| Physical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Physical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Physical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Physical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Physical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Physical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Physical Design | $ - 0 | $ - 0 | $ - 0 | |||||||
| Physical Design | Total | $ - 0 | ||||||||
| Additional ODCs for the use on the contract | ||||||||||
| Contract Year | Item Description | Manufacturer | Part/Product #/ | Unit of Measure | Unit Price (No Profit or Indirect burdens) | Markup (Indirect or Fee) | Fully Burdened Price | Quantity | Total Cost | |
| $ - 0 | $ - 0 | |||||||||
| $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 | ||||||||
| $ - 0 | $ - 0 | $ - 0 |
&C&A &L&F&C&A&R&P of &N
Optional Features
| Company Name | |||||||||||||||||||
| RFP Number: | |||||||||||||||||||
| Optional Features | |||||||||||||||||||
| Offeror is not required to complete until after the Government establishes competitive range. | |||||||||||||||||||
| Contract Year | Item Description | Manufacturer | Part/Product # | Unit of Measure | Unit Price (No Profit or Indirect burdens) | Markup (Indirect or Fee) | Fully Burdened Price | Quantity | Base Total Price | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | Option Year 5 | Option Year 6 | Option Year 7 | Option Year 8 | Option Year 9 | Option Year 10 |
Labor
| Company Name | |||||||||||||||
| RFP Number: | GFY = Government Fiscal Year, October - September | ||||||||||||||
| Labor Category and Rate Table | |||||||||||||||
| GFY 2013 | |||||||||||||||
| Labor Category | Description | Subcontractor/Prime | Prime/Subcontractor Labor Rate | Prime Markup (Profit, Fee or Indirects added to Subcontract Labor) | Fully Burdened Labor Rate | GFY 2014 | GFY 2015 | GFY 2016 | GFY 2017 | GFY 2018 | GFY 2019 | GFY 2020 | GFY 2021 | GFY 2022 | GFY 2023 |
| insert description for applicable labor categories from applicalbe schedule |
This Labor Category and Rate table will be incorporated into Contract.
BOE
| Contractor Name: |
| RFP Number: |
| Sample BOE |
| Provide price proposal narrative that addresses at a minimum the below areas: |
| 1. Identify markups and its application |
| 2. Rationale for labor escalation rates |
| 3. Methodology for determining Full-time equivalency |
| 4. Process for purchase of materials and ODCs |
| 5. Define development and application of amortization schedule |
| 6. Markup for fixed price and time and materials. If the markup is the same the contractor shall disclose that there are no variances. |
&C&A &L&F&C&A&R&P of &N
Assumptions
| Contractor Name |
| RFP Number |
| Assumptions |
| The Contractor shall use this worksheet to clearly list all pricing notes and assumptions used in the derivation of its pricing proposal. |
&C&A &L&F&C&A&R&P of &N
File details come from the government source that posted it. Updated .