Attachment 3 - Pricing Worksheet (002).xlsx

36 KB Posted

Attached to
Media and Social Media Analysis Support Tool Service
Solicitation number
FA701426R0020
Issued by

About this file

Written by GovTribe AI ·

This is a Pricing Worksheet template for federal contract pricing submission. The spreadsheet is designed to calculate total evaluated pricing (TEP) across multiple contract line items (CLINs) representing a base year and four option years, plus a potential six-month extension. Contractors must input data only in yellow-highlighted cells across multiple tabs, with the spreadsheet automatically generating pricing calculations based on labor category inputs, labor rates, full-time equivalent (FTE) hours, number of FTEs, and other direct costs (ODC) where applicable.

The CLIN structure includes CLIN 0001 for the base year (12 months), CLINs 1001-4001 for option years one through four (each 12 months), and a six-month extension period. Each CLIN tab requires contractors to specify labor categories, corresponding labor rates, number of FTEs, hours, and total estimated costs for that period. The pricing tab automatically populates with calculated totals for each CLIN and displays the overall total evaluated price in cell N5. Contractors may explain any pricing adjustments or deviations in a designated "Contractor Changes and Explanations" textbox. The template currently displays all fields as zero values, indicating it requires completion with actual pricing data for the Media and Social Media Analysis Support Tool Service solicitation (FA701426R0020) for the Department of the Air Force.

View the file

Other files

File Type Posted
ATTACH 2 SOW.pdf PDF
ATTACH 3 PP.pdf PDF
Attachment 4 - QA Responses.pdf PDF
ATTACH 1 Instructions to Offerors (ITO) -- Commercial Items.pdf PDF
ATTACH 5 -Solicitation Amendment FA701426R00200001.pdf PDF
Attachment 5 Solicitation FA701426R0020 Revised (2).pdf PDF
Attachment 3 - Pricing Worksheet (002).xlsx XLSX spreadsheet
Attachment 4- Past Performance Questionnaire.docx DOCX document
Attachment 5 Solicitation FA701426R0020 Revised (2).pdf PDF
Attachment 2 - SOW.pdf PDF
Attachment 2 Solicitation FA701426R0020 Revised (2).pdf PDF
Attachment 5 - Past Performance Questionnaire.docx DOCX document
Attachment 1 - Instructions to Offerors.pdf PDF
Attachment 2 -Solicitation - FA701426R0020.pdf PDF
Attachment 4 - Questions Matrix.xlsx XLSX spreadsheet
Show all 15

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Pricing Instructions

Please only input data in the YELLOW highlighted areas in the Pricing and CLIN Tabs. The spreadsheet will generate a price based on inputs, which will be shown on the pricing Tab. If you need to make an adjustments to the Pricing Worksheet, please explain in detail in "Contractor Changes and Explanations" textbox below.

Pricing Tab

The numbers in this tab will populate based on the data put in the CLIN(s) tabs. Please do not change any formulas in this tab. This Tab will show you your Total Evaluated Price in cell N5.

CLIN(s) Tabs

Please enter the applicable proposed FTE Hours, Labor Categories, Labor Rates, # of FTE and ODC information (if applicable).

Please only input data in the YELLOW highlighted areas. The spreadsheet will generate a price based on inputs, which will be shown on the pricing Tab.

CONTRACTOR CHANGES AND EXPLANATIONS:

Pricing

Pricing Summary
CLIN StructureTotal Price CLIN 0001 (Base Year)Period of PerformanceTotal Price CLIN 1001 (OY1)Period of PerformanceTotal Price CLIN 2001 (OY2)Period of PerformanceTotal Price CLIN 3001 (OY3)Period of PerformanceTotal Price CLIN 4001 (OY4)Period of Performance
Total CLIN X001$ - 012 Months$ - 012 Months$ - 012 Months$ - 012 Months$ - 012 Months
Base Year/Option Year Sub-Total$ - 0$ - 0$ - 0$ - 0$ - 0
Total Evaluated Price (TEP)$ - 0
6 month extension$ - 0
Total Evaluated Price plus 6 month extension$0.00

CLIN 0001 - CLIN 4001

Base Period (CLIN 0001)OY1 (CLIN 1001)OY2 (CLIN 2001)OY3 (CLIN 3001)OY4 (CLIN 4001)
Labor CategoriesLabor Rates# of FTEHRSTotal Estimate (BY)Labor Rates# of FTEHRSTotal Estimate (OY1)Labor Rates# of FTEHRSTotal Estimate (OY2)Labor Rates# of FTEHRSTotal Estimate (OY3)Labor Rates# of FTEHRSTotal Estimate (OY4)
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0$ - 000$ - 0
Labor Total0$ - 00$ - 00$ - 00$ - 00$ - 0
CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0CLIN Total$ - 0
FTE Hours
0

6 month extension

6 month extension
Labor CategoriesLabor Rates# of FTEHRSTotal Estimate (6 month extension)
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
$ - 000$ - 0
Labor Total0$ - 0
CLIN Total$ - 0
FTE Hours
0

File details come from the government source that posted it. Updated .