Attachment 1 - CLIN Pricing Worksheet 10022024.xlsx
XLSX spreadsheet 194 KB Posted
- Solicitation number
- HC108424R0005
- Issued by
-
Defense Information Systems Agency
About this file
This document appears to be an attachment titled "CLIN Pricing Worksheet" related to a federal contract opportunity for the Defense Commissary Agency (DeCA). The worksheet provides instructions and pricing templates for bidders to complete labor category information, hourly rates, and material costs for various tasks under the contract, including price optimization, promotion module development, cloud services, program analyst support, training, testing, sustainment, and cybersecurity compliance. The contract opportunity, titled "DeCA Retail Price and Promotion Optimization Tool", is a solicitation (HC108424R0005) issued by the Defense Information Systems Agency to implement a cloud-based retail price and promotion optimization capability for DeCA's commissary operations worldwide. The objectives are to provide a tool that interfaces with DeCA's Enterprise Business Solution to analyze product details, determine optimal pricing, and understand customer needs and behaviors.
View the file
Other files
Show all 24
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 | $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 |
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 |
| 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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
&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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $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 | $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 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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $0.00 |
&F &P &D
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 | |||||||
| $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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
&F &P &D
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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
Labor Category Ref (OY3)
| Labor Category Cross Reference Details | |||
| Labor Category Reference | Option Year 3 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 3 Labor Price
| Firm Fixed Price (Labor) | |||||
| Option Year 3 | |||||
| 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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $0.00 |
Option Year 3 Materials Price
| Firm Fixed Price (Materials) | |||||||
| Option Year 3 | |||||||
| 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 - Price Optimization Tool | $0.00 | |
| Task 2 - Promotion Module | $0.00 | |
| Task 3 - SOC2 Type 2 Cloud and Services | $0.00 | |
| Task 4 - Program Analyst Support | $0.00 | |
| Task 5 - Training | $0.00 | |
| Task 6 - Testing | $0.00 | |
| Task 7 - Sustainment | $0.00 | |
| Task 8 - Cyber Security Compliance | $0.00 | |
| Note: This is a calculated table. Do not edit. | TOTAL | $ - 0 |
Price Summary
| Price Summary | ||||||
| CLIN | Description | Base Year | OY1 | OY2 | OY3 | Totals |
| x001 | Task 1 - Price Optimization Tool | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x002 | Task 2 - Promotion Module | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x003 | Task 3 - SOC2 Type 2 Compliant Cloud and Services | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x004 | Task 4 - Program Analyst Support | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x005 | Task 5 - Training | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x006 | Task 6 - Testing | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x007 | Task 7 - Sustainment | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| x008 | Task 8 - Cyber Security Compliance | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| FFP TOTALS | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Materials | Base Year | OY1 | OY2 | OY3 | Totals |
| Material Totals | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTALS $ - 0 $ - 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 Refrence tables for lookup fields
| Task - Lookup |
| Select dropdown |
| Task 1 - Price Optimization Tool |
| Task 2 - Promotion Module |
| Task 3 - SOC2 Type 2 Cloud and Services |
| Task 4 - Program Analyst Support |
| Task 5 - Training |
| Task 6 - Testing |
| Task 7 - Sustainment |
| Task 8 - Cyber Security Compliance |
Note: Do not edit image1.png image2.png image3.png
File details come from the government source that posted it. Updated .