Attachment I-IDIQ Pricing Worksheet (1).xlsx

XLSX spreadsheet 52 KB Posted

Attached to
Precise Time and Astrometry (PTA) Enterprise Systems Security
Solicitation number
N0018926RL015
Issued by

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 CategoryYear 1Year 2Year 3Year 4Year 5Totals
TitleClassFully Burden RateHoursFTEYear 1 Total PriceFully Burden Rate w/ EscalationHoursFTEYear 2 Total PriceFully Burden Rate w/EscalationHoursFTEYear 3 Total PriceFully BurdenRate w/ EscalationHoursFTEYear 4 Total PriceFully Burden Rate w/ EscalationHoursFTEYear 5 Total PriceTotal 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 EngineerJunior19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Senior134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0
Master134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0
Principal38402$0$0.0038402$0$0.0038402$0$0.0038402$0$0.0038402$0$0
RMF AnalystJunior38402$0$0.0038402$0$0.0038402$0$0.0038402$0$0.0038402$0$0
Senior38402$0$0.0038402$0$0.0038402$0$0.0038402$0$0.0038402$0$0
Master38402$0$0.0038402$0$0.0038402$0$0.0038402$0$0.0038402$0$0
Principal38402$0$0.0038402$0$0.0038402$0$0.0038402$0$0.0038402$0$0
Program ManagerJunior4801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0
Senior4801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0
Master19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Principal19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
SCADA Infrastructure EngineerJunior19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Senior19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Master19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Principal19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Physical Security EngineerJunior19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Senior19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Master19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Principal19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Technical WriterJunior4801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0
Senior4801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0.004801/4$0$0
Master19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Principal19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Security OperatorJunior19201$0$0.0019201$0$0.0019201$0$0.0019201$0$0.0019201$0$0
Senior134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0
Master134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0.00134407$0$0
Principal38402$0$0.0038402$0$0.0038402$0$0.0038402$0$0.0038402$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 categoryHours in 1 year1920$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 D653.00%
Col (8): Totals per labor category over 5 years and total for 5 year contract
Travel Estimates
LocationNumber of TripsNumber People per tripHotel costsFlightsPer diemTotal Per TripYear 1Year 2Year 3Year 4Year 5TOTAL
Honolulu, HI2$0$0$0$0$0$0$0
Cerro Tollo, Chile2$0$0$0$0$0$0$0
Albaquerque, NM2$0$0$0$0$0$0$0
Denver, CO2$0$0$0$0$0$0$0
Flagstaff, AZ2$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 NameYear 1Year 2Year 3Year 4Year 5TOTAL
SuppliesUnit PriceEachTotal PriceEachTotal PriceEachTotal PriceEachTotal PriceEachTotal 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 HardwareUnit PriceYear 1Year 2Year 3Year 4Year 5TOTAL
EachTotal PriceEachTotal PriceEachTotal PriceEachTotal PriceEachTotal 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 Name6 Month
SuppliesUnit PriceEachTotal 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 HardwareUnit Price6 Month
EachTotal 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 Category6 Month extension
TitleClassFully BurdenRateHoursFTECost Gov
Col (1)Col (2)Col (3)Col (4)Col (5)Col (6)
PTA IP/RF Transport EngineerJunior9601/2$0
Senior67203 1/2$0
Master67203 1/2$0
Principal19201$0
RMF AnalystJunior19201$0
Senior19201$0
Master19201$0
Principal19201$0
Program ManagerJunior2401/8$0
Senior2401/8$0
Master9601/2$0
Principal9601/2$0
SCADA Infrastructure EngineerJunior9601/2$0
Senior9601/2$0
Master9601/2$0
Principal9601/2$0
Physical Security EngineerJunior9601/2$0
Senior9601/2$0
Master9601/2$0
Principal9601/2$0
Technical WriterJunior2401/8$0
Senior2401/8$0
Master9601/2$0
Principal9601/2$0
Security OperatorJunior9601/2$0
Senior67203 1/2$0
Master67203 1/2$0
Principal19201$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 categoryHours in 1 year1920
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 D653.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

LocationNumber of TripsNumber People per tripHotel costsFlightsPer diemTotal Per Trip6 Months
Honolulu, HI2$0$0
Cerro Tollo, Chile2$0$0
Albaquerque, NM2$0$0
Denver, CO2$0$0
Flagstaff, AZ2$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 .