Attachment 3 - Pricing Worksheet.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
SAF/PA - Media Analysis Tool (Amendment 0001)
Solicitation number
FA701425R0045
Issued by

About this file

The document is a Pricing Worksheet Excel template for the SAF/PA Media Analysis Tool solicitation (FA701425R0045). The spreadsheet provides a structured pricing format with instructions for bidders to input data only in yellow-highlighted areas across multiple Contract Line Item Number (CLIN) tabs, covering a base year and four option years. The total evaluated price is calculated automatically, with the current total coming to $804.00, which includes various periods of performance, each spanning 12 months. The pricing structure allows for input of labor categories, labor rates, number of full-time equivalents (FTEs), hours, and other direct costs (ODC), with a 6-month extension option also built into the template. Bidders are required to explain any modifications to the pricing worksheet in a dedicated text box, ensuring transparency in their pricing approach.

View the file

Other files

Show all 12

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

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 .