ESM_Attachment 6 Pricing Template Final.xlsx
XLSX spreadsheet 139 KB Posted
- Attached to
- Enterprise Sales and Marketing Solution Federal contract opportunity
- Solicitation number
- 2031JG22R00025
About this file
This document package includes a pricing template and instructions for a federal contract opportunity to provide an enterprise sales and marketing solution to the United States Mint. Key requirements include an end-to-end turnkey retail service solution comprising hardware, software, hosting, operations and maintenance, staffing for a contact center and fulfillment warehouse, all contact center functions and equipment, physical fulfillment warehouse management, receiving and shipping, business and system performance analytics, sales fraud detection, and physical product security with system cybersecurity. Offerors must price logical design, physical design, and operations and maintenance phases, including labor rates escalating annually from FY2023 to FY2033. Pricing templates require itemizing costs by task, phase, and labor category at the prime and subcontractor level, and include materials/other direct costs and assumptions.
View the file
Other files for this federal contract opportunity
Show all 23
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
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 September 30, 2024 |
| c. Option 2 is Operations and Maintenance Phase, 4 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 |
| h. Option 7 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. |
ATTACHMENT 4 - PRICING TEMPLATE
Summary Roll-Up
| Company Name |
| RFP Number: |
| Summary Roll-Up |
Nomenclature Supplies/Services Period Total Cost / Price Hughes, Rachel R: DO NOT EDIT SPREADSHEET FORMULAS. TOTALS WILL AUTOMATICALLY POPULATE.
0001 Logical Design $ - 0
0002 Physical Design $ - 0
0003 Operations and Maintenance
Hughes, Rachel R: Operations and Maintenance costs will not contain a summarized total. Operations and Maintenance will be itemized and incorporated in Section B of the contract.
0004 Logical Design Materials, ODCs, and Travel $ - 0
0005 Physical Design Materials, ODCs, and Travel $ - 0
&A
Sample for Logical and Physical
| Company Name |
| RFP Number |
| Sample for Logical/Physical Design Worksheets |
| Task: Requirements Gap Analysis |
| Period of Performance: October 01, 2023 - October 30, 2023 |
| 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 | 2023 | Program Management | Program Manager | Contractor | $ 185.00 | 39 | 0.02 | $ 7,215.00 |
| PWS 9.2 | 2023 | Systems Engineer | NA | Government Site | $ 125.00 | 156 | 0.08 | $ 19,500.00 |
| PWS 9.2 | 2023 | Data Warehouse Specialist | NA | Government Site | $ 85.00 | 156 | 0.08 | $ 13,260.00 |
| PWS 9.2 | 2023 | 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
&A
&F &A &P of &N
Logical Design
| Company Name |
| RFP Number: |
| Logical Design, PWS Section X |
Task Activity Contract Year Labor Category Hughes, Rachel R: Labor Categories and rates used shall map to Labor worksheet.
| 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 |
&A
&F &A &P of &N
Physical Design
| Company Name |
| RFP Number: |
| Physical Design, PWS Section X |
| Task Activity | Contract Year | Labor Category | |||||||||
| Hughes, Rachel R: Labor Categories and rates used shall map to Labor worksheet. | 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) | Sub-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) | Sub-Total Cost | Total Cost | |
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| $ - 0 | ||||||||||
| Total | $ - 0 | - 0 | - 0 | $ - 0 | $ - 0 | |||||
| Total Estimated Cost | $ - 0 |
&A
&F &A &P of &N
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 | 2029 | 2030 | 2031 | 2032 | 2033 |
| 2024-2028 | Call Center Labor | Monthly | NSP | $ 12,000.00 | ||||||
| 2024-2028 | • Proportional facility and facility based expenditures | Monthly | NSP | $ 1,000.00 | ||||||
| 2024-2028 | • Proportional electronic security system and monitoring | Monthly | NSP | $ 550.00 | ||||||
| 2024-2028 | • Telephony and IT installation and maintenance | Monthly | NSP | $ 350.00 | ||||||
| 2024-2028 | • Administrative costs, equipment, and furniture | Monthly | NSP | $ 125.00 | ||||||
| 2024-2028 | • 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 | $46,047.97 | |||||
| Example 2: Flat Rate Software Licensing Fee | ||||||||||
| Contract Year | Item Description | Unit of Measure | Unit Cost | Quantity | Total Cost | 2029 | 2030 | 2031 | 2032 | 2033 |
| 2023 | Licensing Fee | Monthly | NSP | 1 | $ 5,500.00 | $6,875.00 | $8,593.75 | $10,742.19 | $13,427.73 | $16,784.67 |
| Example 3: Transactional Fee for Bulk Shipments | ||||||||||
| Contract Year | Item Description | Unit of Measure | Unit Cost | Quantity | Total Cost | 2029 | 2030 | 2031 | 2032 | 2033 |
| 2023 | 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 $13.03
&A
&F &A &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 |
&A
&F &A &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 |
Hughes, Rachel R: This Labor Category and Rate table will be incorporated into Contract.
| GFY 2023 | |||||||||||||||
| Labor Category | Description | Subcontractor/Prime | Prime/Subcontractor Labor Rate | Prime Markup (Profit, Fee or Indirects added to Subcontract Labor) | Fully Burdened Labor Rate | GFY 2024 | GFY 2025 | GFY 2026 | GFY 2027 | GFY 2028 | GFY 2029 | GFY 2030 | GFY 2031 | GFY 2032 | GFY 2033 |
| insert description for applicable labor categories from applicable schedule |
BOE
| Contractor Name: |
| RFP Number: |
| Sample BOE (Basis of Estimate) |
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. |
&A
&F &A &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. |
&A
&F &A &P of &N
File details come from the government source that posted it. Updated .