Attachment I-Pricing Spreadsheet.xlsx
XLSX spreadsheet 32 KB Posted
- Solicitation number
- N0018925Q0204
About this file
The file is a Pricing Spreadsheet for a scientific research support services contract with the United States Naval Observatory. The document outlines a 5-year Indefinite-Delivery, Indefinite-Quantity (IDIQ) contract with a total 5-year ordering ceiling of $6,222,632.15, plus a 6-month option. The pricing template includes labor categories such as Astronomer, Atomic Clock and Particle Physicist, and Electrical/Mechanical Optics Engineer, with various academic ranks (Scientific Research Associate, Postdoctoral Research Associate, Associate Professor, Full Professor). Each labor category has specified annual hours and full-time equivalent (FTE) allocations, with a consistent annual travel budget of $25,000.
The solicitation (N0018925Q0204) is issued by the Department of the Navy Naval Supply Systems Command, seeking commercial scientific research support services. The contract period runs from 01 June 2025 to 31 December 2030, with performance located at the United States Naval Observatory in Washington, DC. The procurement is classified under NAICS code 541715 with a small business standard of 1000 employees. Proposals are due by 22 April 2025 and must be submitted via email to Caitlin King and Cody Witz. The contract will be awarded as a Firm, Fixed-Price (FFP) single-award IDIQ type agreement.
View the file
Other files
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
Base 5-year
| **DO NOT CHANGE THE VERBIAGE IN THE SPREADSHEET | ||||||||||||||||||||||
| ** DO NOT DELETE, ADD OR MOVE ROWS & COLUMNS IN THIS SPREADSHEET (TO DO SO INTERFERES WITH THE FORMULAS IN THE SPREADSHEET AND CREATES PROBLEMS WITH THE CALCULATIONS | ||||||||||||||||||||||
| Instructions | ||||||||||||||||||||||
| Col (3) Contractor to fill in fully burden Rates | ||||||||||||||||||||||
| Col (7): Contractor to fill in Escalation rate of per year in cell D34 | ||||||||||||||||||||||
| 5 Year Ordering Ceiling: $6,222,632.15 FAR 52.217-8 Ceiling - $678,272.93 | ||||||||||||||||||||||
| Labor Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals | ||||||||||||||||
| Title | Class | Rate | Hours | FTE | Cost Gov | Rate w/ Escalation | Hours | FTE | Cost Gov | Rate w/ Escalation | Hours | FTE | Cost Gov | Rate w/ Escalation | Hours | FTE | Cost Gov | Rate w/ Escalation | Hours | FTE | Cost Gov | Cost Gov |
| Col (1) | Col (2) | Col (3) | Col (4) | Col (5) | Col (6) | Col (7) | Col (4) | Col (5) | Col (6) | Col (7) | Col (4) | Col (5) | Col (6) | Col (7) | Col (4) | Col (5) | Col (6) | Col (7) | Col (4) | Col (5) | Col (6) | Col(8) |
| Astronomer | Scientific Research Associate | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0 | |
| Postdoctoral Research Associate | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0 | ||
| Associate Professor | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0 | ||
| Full Professor | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0 | ||
| Atomic Clock and Particle Physicist | Scientific Research Associate | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0 | |
| Postdoctoral Research Associate | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0 | ||
| Associate Professor | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0 | ||
| Full Professor | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0 | ||
| Electrical, Mechanical Optics Engineer | Scientific Research Associate | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0.00 | 956 | 1/2 | $0 | $0 | |
| Postdoctoral Research Associate | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0.00 | 1912 | 1 | $0 | $0 | ||
| Associate Professor | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0.00 | 478 | 1/4 | $0 | $0 | ||
| Full Professor | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0.00 | 239 | 1/8 | $0 | $0 | ||
| Travel | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $125,000 | ||||||||||||||||
| Totals | 9799 | 5 1/8 | $25,000 | 9799 | 5 1/8 | $25,000 | 9799 | 5 1/8 | $25,000 | 9799 | 5 1/8 | $25,000 | 9799 | 5 1/8 | $25,000 | $125,000 |
| Col (1): Labor Category | |
| Col (2): Labor Category Experience Class | |
| Col (3): Hourly labor rates | |
| Col (4): Annual hours required per labor category | |
| Col (5): Total number of FTE in each labor category projected to be required for each year over the duration of the contract | |
| Col (6): Total cost for each labor category based on the number of hours projected to be required each year and the estimated cost per hour for each labor category | |
| Col (7): Contractor to fill in Escalation rate of per year in cell D65 | 3.00% |
| Col (8): Totals per labor category over 5 years and total for 5 year contract |
&"Helvetica Neue,Regular"&12&K000000&P
6 month option
| **DO NOT CHANGE THE IN THE SPREADSHEET |
| ** DO NOT DELETE, ADD OR MOVE ROWS & COLUMNS IN THIS SPREADSHEET (TO DO SO INTERFERES WITH THE FORMULAS IN THE SPREADSHEET AND CREATES PROBLEMS WITH THE CALCULATIONS |
| Instructions |
| Labor Category | 6 Month extension | ||||
| Title | Class | Rate | Hours | FTE | Cost Gov |
| Col (1) | Col (2) | Col (3) | Col (4) | Col (5) | Col (6) |
| Astronomer | Scientific Research Associate | - 0 | 478 | 1/4 | $0 |
| Postdoctoral Research Associate | - 0 | 478 | 1/4 | $0 | |
| Associate Professor | - 0 | 239 | 1/8 | $0 | |
| Full Professor | - 0 | 119.5 | 1/16 | $0 | |
| Atomic Clock and Particle Physicist | Scientific Research Associate | - 0 | 478 | 1/4 | $0 |
| Postdoctoral Research Associate | - 0 | 956 | 1/2 | $0 | |
| Associate Professor | - 0 | 239 | 1/8 | $0 | |
| Full Professor | - 0 | 119.5 | 1/16 | $0 | |
| Electrical, Mechanical Optics Engineer | Scientific Research Associate | - 0 | 478 | 1/4 | $0 |
| Postdoctoral Research Associate | - 0 | 956 | 1/2 | $0 | |
| Associate Professor | - 0 | 239 | 1/8 | $0 | |
| Full Professor | - 0 | 119.5 | 1/16 | $0 | |
| Travel | $12,500 | ||||
| Totals | 4899.5 | 2 9/16 | $12,500 |
| Col (1): Labor Category |
| Col (2): Labor Category Experience Class |
| Col (3): Hourly labor rates |
| Col (4): Annual hours required per labor category |
| Col (5): Total number of FTE in each labor category projected to be required for each year over the duration of the contract |
| Col (6): Total cost for each labor category based on the number of hours projected to be required each year and the estimated cost per hour for each labor category |
| Col (8): Totals per labor category over 5 years and total for 5 year contract |
&"Helvetica Neue,Regular"&12&K000000&P
Total
| **DO NOT CHANGE THE VERBIAGE IN THE SPREADSHEET |
| ** DO NOT DELETE, ADD OR MOVE ROWS & COLUMNS IN THIS SPREADSHEET (TO DO SO INTERFERES WITH THE FORMULAS IN THE SPREADSHEET AND CREATES PROBLEMS WITH THE CALCULATIONS |
| Contract | |
| Year 1 | $25,000 |
| Year 2 | $25,000 |
| Year 3 | $25,000 |
| Year 4 | $25,000 |
| Year 5 | $25,000 |
| 6 Month Option | $12,500 |
| Total | $137,500.00 |
File details come from the government source that posted it. Updated .