Attachment 2 - CLIN Pricing Worksheet 11062024.xlsx
XLSX spreadsheet 178 KB Posted
- Solicitation number
- HC108424R0015
- Issued by
-
Defense Information Systems Agency
About this file
This document is an Excel pricing worksheet attachment related to a federal contract opportunity for the Defense Commissary Agency's (DeCA) Digital Loyalty Registration Capability (DLRC). The worksheet provides instructions and templates for the contractor to complete labor category details, labor pricing for the base year and option years, and material pricing. The pricing is organized by specific tasks such as integration, program features, milestones, program management, and training. The overall objective of the DLRC effort is to modernize and enhance DeCA's Reward Card Program by developing a more user-friendly and accessible digital registration process that integrates with DeCA's existing enterprise systems, including EBS Emerald, Fastlane SelfServ, and CLICK2GO/Freshop. The contract requires the contractor to collaborate with NCR Voyix and utilize their APIs. Questions on this opportunity are due by October 16, 2024.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| HC108424R0015 0003.docx | DOCX document | |
| AMD 0003 Questions Answers HC108424R0015 .xlsx | XLSX spreadsheet | |
| AMD 0002 Questions Answers - HC108424R0015.pdf | ||
| HC108424R0015 AMD 0002.pdf | ||
| HC108424R0015 AMD0001.pdf | ||
| DD254.pdf | ||
| Attachment 2 CLIN Pricing Worksheet.xlsx | XLSX spreadsheet | |
| HC108424R0015.pdf | ||
| Attachment 1 Example PWS 4c.docx | DOCX document |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Instructions | |
| Step 1 | Complete the Labor Category Reference table in the "Labor Category Ref" tab of the workbook. |
Overwrite the first entry with a labor category short reference description in the first column.
Enter the associated labor rate, title, and duties.
To add additional labor categories to the table, press the <tab> key at the last row and column.
This is the same for all the tables.
Step 2 Complete the base year labor
Begin with selecting the applicable task area from the dropdown box.
Then enter the PWS paragraph number as a cross walk.
Select the labor category from the dropdown of the labor categories entered in Step 1. The rate will be entered automatically.
Then enter the number of hours.
The subtotals by task table is calculated automatically.
Step 3 Repeat Step 2 for each of the option year tabs
Labor Category Ref (Base)
| Labor Category Cross Reference Details | |||
| Labor Category Reference | Labor Rate | Labor Category Title | Labor Category Description and Duties |
| Col1 | Col2 | Col3 | Col4 |
| Enter Labor Category Reference | Enter a title | Enter description and duties |
| To add a row, press <tab> in the last column of the last row above. |
| Note: Overwrite the first entry |
Base Year Price
| Firm Fixed Price (Labor) | |||||
| Base Year | |||||
| Task | PWS Cross Walk | Labor Category | Rate | Hours | Price Totals |
| Select dropdown | Enter PWS paragraph # | Enter Labor Category Reference | $0.00 | 1 | $0.00 |
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 |
| Select dropdown | |
| Total | $0.00 |
| To add a row, press <tab> in the last column of the last row above the Total row | |
| Note: Overwrite the first entry |
| Subtotals by Task Table | ||
| Task | Subtotals | |
| Task 1 - Integration | $0.00 | |
| Task 2 - Program Features | $0.00 | |
| Task 3 - Milestones | $0.00 | |
| Task 4 - Program Management | $0.00 | |
| Task 5 - Training | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $0.00 |
&F &P &D
Base Year Materials Price
| Firm Fixed Price (Materials) | |||||||
| Base Year | |||||||
| Task | PWS Cross Walk | Proposed Item | Description | Part Number | Unit Cost | Quantity | Total Amount |
| Select dropdown | Enter PWS paragraph # | Enter Proposed Item | Enter Description | Enter Part Number | 1 | $0.00 | |
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 |
| Total | $0.00 |
| To add a row, press <tab> in the last column of the last row above the Total row | |
| Note: Overwrite the first entry |
| Subtotals by Task Table | ||
| Task | Subtotals | |
| Task 1 - Integration | $0.00 | |
| Task 2 - Program Features | $0.00 | |
| Task 3 - Milestones | $0.00 | |
| Task 4 - Program Management | $0.00 | |
| Task 5 - Training | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
Labor Category Ref (OY1)
| Labor Category Cross Reference Details | |||
| Labor Category Reference | Option Year 1 Labor Rate | Labor Category Title | Labor Category Description and Duties |
| Col1 | Col2 | Col3 | Col4 |
| Enter Labor Category Reference | Enter description and duties |
| To add a row, press <tab> in the last column of the last row above. |
| Note: Overwrite the first entry |
Option Year 1 Materials Price
| Firm Fixed Price (Materials) | |||||||
| Option Year 1 | |||||||
| Task | PWS Cross Walk | Proposed Item | Description | Part Number | Unit Cost | Quantity | Total Amount |
| Select dropdown | Enter PWS paragraph # | Enter Proposed Item | Enter Description | Enter Part Number | 1 | $0.00 | |
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 |
| Total | $0.00 |
| To add a row, press <tab> in the last column of the last row above the Total row | |
| Note: Overwrite the first entry |
| Subtotals by Task Table | ||
| Task | Subtotals | |
| Task 1 - Integration | $0.00 | |
| Task 2 - Program Features | $0.00 | |
| Task 3 - Milestones | $0.00 | |
| Task 4 - Program Management | $0.00 | |
| Task 5 - Training | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
Option Year 1 Price
| Firm Fixed Price (Labor) | |||||
| Option Year 1 | |||||
| Task | PWS Cross Walk | Labor Category | Rate | Hours | Price Totals |
| Select dropdown | Enter PWS paragraph # | Enter Labor Category Reference | $0.00 | 1 | $0.00 |
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 |
| Total | $0.00 |
| To add a row, press <tab> in the last column of the last row above the Total row | |
| Note: Overwrite the first entry |
| Subtotals by Task Table | ||
| Task | Subtotals | |
| Task 1 - Integration | $0.00 | |
| Task 2 - Program Features | $0.00 | |
| Task 3 - Milestones | $0.00 | |
| Task 4 - Program Management | $0.00 | |
| Task 5 - Training | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $0.00 |
&F &P &D
Labor Category Ref (OY2)
| Labor Category Cross Reference Details | |||
| Labor Category Reference | Option Year 2 Labor Rate | Labor Category Title | Labor Category Description and Duties |
| Col1 | Col2 | Col3 | Col4 |
| Enter Labor Category Reference | $0.00 | Enter a title | Enter description and duties |
| To add a row, press <tab> in the last column of the last row above. |
| Note: Overwrite the first entry |
Option Year 2 Materials Price
| Firm Fixed Price (Materials) | |||||||
| Option Year 2 | |||||||
| Task | PWS Cross Walk | Proposed Item | Description | Part Number | Unit Cost | Quantity | Total Amount |
| Select dropdown | Enter PWS paragraph # | Enter Proposed Item | Enter Description | Enter Part Number | 1 | $0.00 | |
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 | |||||||
| $0.00 |
| Total | $0.00 |
| To add a row, press <tab> in the last column of the last row above the Total row | |
| Note: Overwrite the first entry |
| Subtotals by Task Table | ||
| Task | Subtotals | |
| Task 1 - Integration | $0.00 | |
| Task 2 - Program Features | $0.00 | |
| Task 3 - Milestones | $0.00 | |
| Task 4 - Program Management | $0.00 | |
| Task 5 - Training | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
Option Year 2 Price
| Firm Fixed Price (Labor) | |||||
| Option Year 2 | |||||
| Task | PWS Cross Walk | Labor Category | Rate | Hours | Price Totals |
| Select dropdown | Enter PWS paragraph # | Enter Labor Category Reference | $0.00 | 1 | $0.00 |
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 | |||||
| $0.00 |
| Total | $0.00 |
| To add a row, press <tab> in the last column of the last row above the Total row | |
| Note: Overwrite the first entry |
| Subtotals by Task Table | ||
| Task | Subtotals | |
| Task 1 - Integration | $0.00 | |
| Task 2 - Program Features | $0.00 | |
| Task 3 - Milestones | $0.00 | |
| Task 4 - Program Management | $0.00 | |
| Task 5 - Training | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
&F &P &D
Price Summary
| Price Summary | |||||
| CLIN | Description | Base Year | OY1 | OY2 | Totals |
| x001 | Task 1 - Integration | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x002 | Task 2 - Program Features | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x003 | Task 3 - Milestones | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x004 | Task 4 - Program Management | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x005 | Task 5 - Training | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FFP TOTALS | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Travel / ODC | Base Year | OY1 | OY2 | Totals |
| Travel | $10,000 | $10,000 | $10,000 | $ 30,000.00 |
| Material Total | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Travel / ODC TOTALS | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 30,000.00 |
| TOTALS | $ 10,000.00 | $ 10,000.00 | $ 10,000.00 | $ 30,000.00 |
Note: There is no input on this sheet. All values are calculated from the other tabs in this workbook volume.
Reference Reference tables for lookup fields
| Task - Lookup |
| Select dropdown |
| Task 1 - Integration |
| Task 2 - Program Features |
| Task 3 - Milestones |
| Task 4 - Program Management |
| Task 5 - Training |
Note: Do not edit image1.png image2.png image3.png
File details come from the government source that posted it. Updated .