Attachment 3 - Pricing Worksheet.xlsx
XLSX spreadsheet 36 KB Posted
- Attached to
- SAF/PA - Media Analysis Tool (Amendment 0001)
- Solicitation number
- FA701425R0045
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 Structure | Total Price CLIN 0001 (Base Year) | Period of Performance | Total Price CLIN 1001 (OY1) | Period of Performance | Total Price CLIN 2001 (OY2) | Period of Performance | Total Price CLIN 3001 (OY3) | Period of Performance | Total Price CLIN 4001 (OY4) | Period of Performance |
| Total CLIN X001 | $ - 0 | 12 Months | $ 200.00 | 12 Months | $ 1.00 | 12 Months | $ 600.00 | 12 Months | $ 3.00 | 12 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 Categories | Labor Rates | # of FTE | HRS | Total Estimate (BY) | Labor Rates | # of FTE | HRS | Total Estimate (OY1) | Labor Rates | # of FTE | HRS | Total Estimate (OY2) | Labor Rates | # of FTE | HRS | Total Estimate (OY3) | Labor Rates | # of FTE | HRS | Total Estimate (OY4) |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | $ - 0 | 0 | 0 | $ - 0 | |
| Labor Total | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | 0 | $ - 0 | ||||||||||
| ODC (if applicable) | ODC (if applicable) | $ 200.00 | ODC (if applicable) | $ 1.00 | ODC (if applicable) | $ 600.00 | ODC (if applicable) | $ 3.00 | ||||||||||||
| CLIN Total | $ - 0 | CLIN Total | $ 200.00 | CLIN Total | $ 1.00 | CLIN Total | $ 600.00 | CLIN Total | $ 3.00 |
| FTE Hours |
| 0 |
6 month extension
| 6 month extension | ||||
| Labor Categories | Labor Rates | # of FTE | HRS | Total Estimate (6 month extension) |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| $ - 0 | 0 | 0 | $ - 0 | |
| Labor Total | 0 | $ - 0 | ||
| ODC (if applicable) | $ - 0 | |||
| CLIN Total | $ - 0 |
| FTE Hours |
| 0 |
File details come from the government source that posted it. Updated .