Attachment 3 - Pricing Worksheet.xlsx

36 KB Posted

Attached to
SAF/PA - Social Media Monitoring and Management Tool (Amendment 0001)
Solicitation number
FA701425R0048
Issued by

About this file

Written by GovTribe AI ·

The document is a Pricing Worksheet for the SAF/PA Social Media Monitoring and Management Tool solicitation (FA701425R0048). The Excel spreadsheet provides detailed pricing instructions for bidders, requiring data entry only in yellow-highlighted cells across multiple Contract Line Item Number (CLIN) tabs. The pricing structure covers a base year and four option years, with a total evaluated price of $804.00, including a potential 6-month extension.

The pricing template breaks down costs by CLIN periods, allowing contractors to input labor categories, labor rates, number of full-time equivalents (FTEs), and other direct costs (ODC). The worksheet is designed to automatically calculate total prices based on contractor inputs, with the Total Evaluated Price (TEP) displayed in cell N5. The pricing structure supports the Air Force Office of Public Affairs requirement for a web-based social media management and monitoring tool, with pricing tabs for the base year (CLIN 0001) and subsequent option years (CLIN 1001-4001).

View the file

Other files

File Type Posted
Attach 1 -Instructions to Offerors FA701425R0048P0001 rev 08082025v2.pdf PDF
Attachment 5 - Past Performance Questionnairev2.docx DOCX document
Attachment 5 - Past Performance Questionnaire.docx DOCX document
Attach 1 -Instructions to Offerors FA701425R0048P0001 revised 08082025.pdf PDF
Attachment 4 - Questions and Answers - Amend 0001.pdf PDF
Attachment 1 - Instructions to Offerors - Amend 0001.pdf PDF
Solicitation Amendment FA701425R00480001 SF 30.pdf PDF
Attachment 1 - SAFPA - Instructions to Offerors.pdf PDF
Attachment 4 - Questions Matrix.xlsx XLSX spreadsheet
Solicitation - FA701425R0048.pdf PDF
Attachment 2 - SAFPA Social Media Monitoring and Management Tool - SOW.pdf PDF
Show all 11

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$ 200.0012 Months$ 1.0012 Months$ 600.0012 Months$ 3.0012 Months
Base Year/Option Year Sub-Total$ - 0$ 200.00$ 1.00$ 600.00$ 3.00
Total Evaluated Price (TEP)$ 804.00
6 month extension$ - 0
Total Evaluated Price plus 6 month extension$804.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
ODC (if applicable)ODC (if applicable)$ 200.00ODC (if applicable)$ 1.00ODC (if applicable)$ 600.00ODC (if applicable)$ 3.00
CLIN Total$ - 0CLIN Total$ 200.00CLIN Total$ 1.00CLIN Total$ 600.00CLIN Total$ 3.00
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
ODC (if applicable)$ - 0
CLIN Total$ - 0
FTE Hours
0

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