Attachment 2 CLIN Pricing Worksheet.xlsx
XLSX spreadsheet 162 KB Posted
- Solicitation number
- HC108424R0015
- Issued by
-
Defense Information Systems Agency
About this file
This document is a CLIN Pricing Worksheet template that is part of a Request for Proposal (RFP) for a federal contract opportunity from the Defense Commissary Agency (DeCA). The objective of the contract is to develop a Digital Loyalty Registration Capability (DLRC) that will modernize DeCA's Reward Card Program and provide a simplified, digital registration process for customers.
The worksheet provides instructions for contractors to complete labor category details, pricing for the base year and two option years, and a price summary table. Key requirements include integrating the DLRC with DeCA's existing software systems and collaborating with NCR Voyix. The RFP solicitation number is HC108424R0015, and questions are due by October 16, 2024. The contract will be awarded by the Defense Information Systems Agency.
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 | ||
| Attachment 2 - CLIN Pricing Worksheet 11062024.xlsx | XLSX spreadsheet | |
| HC108424R0015 AMD0001.pdf | ||
| DD254.pdf | ||
| 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 |
| Task 2 - Program Features | 6.2 | Tester | 5 | ||
| Task 3 - Milestones | 6.3 | Program manager | 10 | ||
| Task 4 - Program Management | Program manager | 5 | |||
| Task 1 - Integration | Tester | 10 |
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 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $0.00 |
&F &P &D
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 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 |
| 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 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
&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 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 |
| 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 | |
| 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 - Intergration | $ - 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 |
| FFP TOTALS | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTALS $ - 0 $ - 0 $ - 0 $ - 0
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 |
Note: Do not edit image1.png image2.png image3.png
File details come from the government source that posted it. Updated .