Attachment I-IDIQ Pricing Worksheet (1).xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- N0018926RL015
About this file
This is an Indefinite Delivery/Indefinite Quantity (IDIQ) pricing worksheet for a federal contract opportunity supporting the United States Naval Observatory (USNO) Precise Time and Astrometry (PTA) Enterprise Systems Security initiative. The worksheet is a template document designed to capture pricing information for supplies and services that would be delivered under an IDIQ contract vehicle with the Department of the Navy Naval Supply Systems Command.
The pricing worksheet serves as a standard template for contractors to submit cost proposals and establish unit prices or labor rates applicable to the indefinite quantity ordering structure. This type of pricing mechanism allows the government to issue task orders or delivery orders against the established pricing without requiring repricing for each individual order, subject to minimum and maximum contract values. The IDIQ vehicle is commonly used for enterprise-level systems support requiring flexibility in ordering quantities and delivery schedules while maintaining cost certainty through pre-negotiated rates.
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
5-Year Ordering Period Price Wo
| Labor Category | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Totals | ||||||||||||||||
| Title | Class | Fully Burden Rate | Hours | FTE | Year 1 Total Price | Fully Burden Rate w/ Escalation | Hours | FTE | Year 2 Total Price | Fully Burden Rate w/Escalation | Hours | FTE | Year 3 Total Price | Fully BurdenRate w/ Escalation | Hours | FTE | Year 4 Total Price | Fully Burden Rate w/ Escalation | Hours | FTE | Year 5 Total Price | Total Gov Price |
| 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) |
| PTA IP/RF Transport Engineer | Junior | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | |
| Senior | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0 | ||
| Master | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0 | ||
| Principal | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0 | ||
| RMF Analyst | Junior | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0 | |
| Senior | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0 | ||
| Master | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0 | ||
| Principal | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0 | ||
| Program Manager | Junior | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0 | |
| Senior | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0 | ||
| Master | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Principal | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| SCADA Infrastructure Engineer | Junior | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | |
| Senior | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Master | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Principal | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Physical Security Engineer | Junior | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | |
| Senior | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Master | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Principal | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Technical Writer | Junior | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0 | |
| Senior | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0.00 | 480 | 1/4 | $0 | $0 | ||
| Master | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Principal | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | ||
| Security Operator | Junior | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0.00 | 1920 | 1 | $0 | $0 | |
| Senior | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0 | ||
| Master | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0.00 | 13440 | 7 | $0 | $0 | ||
| Principal | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0.00 | 3840 | 2 | $0 | $0 | ||
| Travel |
Totals 72960 38 $0 72960 38 72960 38 $0 72960 38 72960 38
| Col (1): Labor Category | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| Col (2): Labor Category Experience Class | ||||||||
| Col (3): Hourly labor rates | ||||||||
| Col (4): Annual hours required per labor category | Hours in 1 year | 1920 | $0.00 | |||||
| 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 |
| Travel Estimates | ||||||||||||
| Location | Number of Trips | Number People per trip | Hotel costs | Flights | Per diem | Total Per Trip | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL |
| Honolulu, HI | 2 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Cerro Tollo, Chile | 2 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Albaquerque, NM | 2 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Denver, CO | 2 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| Flagstaff, AZ | 2 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||
| $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0 |
| Supplies: Security Monitoring Kits and Transport Hardware | ||||||||||||
| Product Name | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL | ||||||
| Supplies | Unit Price | Each | Total Price | Each | Total Price | Each | Total Price | Each | Total Price | Each | Total Price | |
| Cybersecurity Infrastructure System (CIS)-A | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Cybersecurity Infrastructure System (CIS)-B | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Cybersecurity Infrastructure System (CIS)-C | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| NEC Cybersecurity Field Deployable System (CFDS)-A | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| NEC Cybersecurity Field Deployable System (CFDS)-B | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| NEC Cybersecurity Field Deployable System (CFDS)-C | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Multi-Classification-Domain-Infrastructure System-20-12-A | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Multi-Classification-Domain-Infrastructure System-20-12-B | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| TOTAL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Transport Hardware | Unit Price | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | TOTAL | |||||
| Each | Total Price | Each | Total Price | Each | Total Price | Each | Total Price | Each | Total Price | |||
| Time Dissemination Premise Edge Transport | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Time Dissemination Firewall Outer | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Time Dissemination Management Switch and Core Distribution | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Time Dissemination Switches | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Time Dissemination Out of Band System | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Time Dissemination Firewall Inner | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| Time Dissemination Aggregator | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||
| TOTAL | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
TOTAL $ - 0 $ - 0 $ - 0 $0.00 $ - 0 $0.00
&"Helvetica Neue,Regular"&12&K000000&P
Supplies FAR 52.217-8
| Product Name | 6 Month | ||
| Supplies | Unit Price | Each | Total Price |
| Cybersecurity Infrastructure System (CIS)-A | $ - 0 | ||
| Cybersecurity Infrastructure System (CIS)-B | $ - 0 | ||
| Cybersecurity Infrastructure System (CIS)-C | $ - 0 | ||
| NEC Cybersecurity Field Deployable System (CFDS)-A | $ - 0 | ||
| NEC Cybersecurity Field Deployable System (CFDS)-B | $ - 0 | ||
| NEC Cybersecurity Field Deployable System (CFDS)-C | $ - 0 | ||
| Multi-Classification-Domain-Infrastructure System-20-12-A | $ - 0 | ||
| Multi-Classification-Domain-Infrastructure System-20-12-B | $ - 0 | ||
| TOTAL | $ - 0 |
| Transport Hardware | Unit Price | 6 Month | |
| Each | Total Price | ||
| Time Dissemination Premise Edge Transport | $ - 0 | ||
| Time Dissemination Firewall Outer | $ - 0 | ||
| Time Dissemination Management Switch and Core Distribution | $ - 0 | ||
| Time Dissemination Switches | $ - 0 | ||
| Time Dissemination Out of Band System | $ - 0 | ||
| Time Dissemination Firewall Inner | $ - 0 | ||
| Time Dissemination Aggregator | $ - 0 | ||
| TOTAL | $ - 0 |
TOTAL $ - 0
Services FAR 52.217-8
| Labor Category | 6 Month extension | ||||
| Title | Class | Fully BurdenRate | Hours | FTE | Cost Gov |
| Col (1) | Col (2) | Col (3) | Col (4) | Col (5) | Col (6) |
| PTA IP/RF Transport Engineer | Junior | 960 | 1/2 | $0 | |
| Senior | 6720 | 3 1/2 | $0 | ||
| Master | 6720 | 3 1/2 | $0 | ||
| Principal | 1920 | 1 | $0 | ||
| RMF Analyst | Junior | 1920 | 1 | $0 | |
| Senior | 1920 | 1 | $0 | ||
| Master | 1920 | 1 | $0 | ||
| Principal | 1920 | 1 | $0 | ||
| Program Manager | Junior | 240 | 1/8 | $0 | |
| Senior | 240 | 1/8 | $0 | ||
| Master | 960 | 1/2 | $0 | ||
| Principal | 960 | 1/2 | $0 | ||
| SCADA Infrastructure Engineer | Junior | 960 | 1/2 | $0 | |
| Senior | 960 | 1/2 | $0 | ||
| Master | 960 | 1/2 | $0 | ||
| Principal | 960 | 1/2 | $0 | ||
| Physical Security Engineer | Junior | 960 | 1/2 | $0 | |
| Senior | 960 | 1/2 | $0 | ||
| Master | 960 | 1/2 | $0 | ||
| Principal | 960 | 1/2 | $0 | ||
| Technical Writer | Junior | 240 | 1/8 | $0 | |
| Senior | 240 | 1/8 | $0 | ||
| Master | 960 | 1/2 | $0 | ||
| Principal | 960 | 1/2 | $0 | ||
| Security Operator | Junior | 960 | 1/2 | $0 | |
| Senior | 6720 | 3 1/2 | $0 | ||
| Master | 6720 | 3 1/2 | $0 | ||
| Principal | 1920 | 1 | $0 |
Totals 52800 19 $0.00
| Col (1): Labor Category | ||
| Col (2): Labor Category Experience Class | ||
| Col (3): Hourly labor rates | ||
| Col (4): Annual hours required per labor category | Hours in 1 year | 1920 |
| 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 |
| 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
Travel FAR.217-8
| Location | Number of Trips | Number People per trip | Hotel costs | Flights | Per diem | Total Per Trip | 6 Months |
| Honolulu, HI | 2 | $0 | $0 | ||||
| Cerro Tollo, Chile | 2 | $0 | $0 | ||||
| Albaquerque, NM | 2 | $0 | $0 | ||||
| Denver, CO | 2 | $0 | $0 | ||||
| Flagstaff, AZ | 2 | $0 | $0 | ||||
| $0 | $0 | ||||||
| $0 | $0 | ||||||
| TOTAL | $0.00 |
Total
| Contract | |
| Year 1 | $0 |
| Year 2 | $0 |
| Year 3 | $0 |
| Year 4 | $0 |
| Year 5 | $0 |
| 6 Month Option | $0 |
| Total | $0 |
File details come from the government source that posted it. Updated .