Attachment 1 - CLIN Pricing Worksheet 09262024.xlsx
XLSX spreadsheet 170 KB Posted
- Solicitation number
- HC108424R0005
- Issued by
-
Defense Information Systems Agency
About this file
This document is a pricing worksheet template for a federal contract opportunity. It provides a format for offerors to submit pricing for the various tasks and labor categories required under the contract. The template includes sections for entering labor category details, pricing for the base year and option years, and a summary of the total pricing. The related federal contract opportunity is for a Defense Commissary Agency (DeCA) retail price and promotion optimization tool. The objectives are to provide a cloud-based retail optimization tool that will interface with DeCA's enterprise system to help determine optimal product pricing and understand customer needs and behaviors. The contracting agency is the Defense Information Systems Agency. The solicitation number is HC108424R0005.
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 - FEDRAMP 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
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 - FEDRAMP 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
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 - FEDRAMP 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
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 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 - FEDRAMP 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 |
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 - FEDRAMP 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 |
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 - FEDRAMP 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 .