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 proposals. The spreadsheet is designed to calculate total evaluated pricing (TEP) for a contract covering a base year plus four option years, with an additional six-month extension period. Contractors are instructed to input data only in yellow-highlighted cells across multiple tabs, including labor categories, hourly rates, full-time equivalent (FTE) staffing levels, and other direct costs (ODC) where applicable. The worksheet automatically generates pricing calculations based on inputs and displays the total evaluated price in a designated summary cell.

The pricing structure is organized by Contract Line Item Numbers (CLINs), with CLIN 0001 representing the 12-month base year, CLINs 1001-4001 representing four 12-month option years, and a separate section for a six-month extension. Each CLIN tab requires contractors to specify labor rates, number of FTEs, hours, and labor category details, with the spreadsheet calculating line-item totals and rolling them up to a final TEP. Contractors may document any adjustments or deviations from standard pricing in a "Contractor Changes and Explanations" textbox. The template includes no pre-populated data and serves solely as a pricing calculation framework for the Media and Social Media Analysis Support Tool Service solicitation (FA701426R0020) issued by the Department of the Air Force.

View the file

Other files

File Type Posted
ATTACH 2 SOW.pdf PDF
ATTACH 1 Instructions to Offerors (ITO) -- Commercial Items.pdf PDF
ATTACH 5 -Solicitation Amendment FA701426R00200001.pdf PDF
ATTACH 3 PP.pdf PDF
Attachment 4 - QA Responses.pdf PDF
Attachment 5 Solicitation FA701426R0020 Revised (2).pdf PDF
Attachment 2 - SOW.pdf PDF
Attachment 4- Past Performance Questionnaire.docx DOCX document
Attachment 5 Solicitation FA701426R0020 Revised (2).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 3 - Pricing Worksheet (002).xlsx XLSX spreadsheet
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 .