Attachment_1_Pricing_Spreadsheet.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
F-16 Mission Tactics Trainer Training System Support Center
Solicitation number
ID07180027
Issued by

About this file

Pricing Spreadsheet

View the file

Other files

Show all 15

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

F-16 TSSC

ID07180027 - Attachment 1 Pricing Spreadsheet
Blue Cells = Vendor Input Required
Green Cells = Government Suggested Labor Levels, Vendor May Change As Necessary to Create FFP, Total Solution Pricing
Tan Cells = Autocalculated or Government Pre-Filled Data, No Vendor Input Required
White Cells = Autocalculated or Government Pre-Filled Data, No Vendor Input Required
LABOR
Base Year Hour QuantityBase Year Labor RateBase Year TotalOption Year 1 Hour QuantityOption Year 1 Labor RateOption Year 1 TotalOption Year 2 Hour QuantityOption Year 2 Labor RateOption Year 2 TotalOption Year 3 Hour QuantityOption Year 3 Labor RateOption Year 3 TotalOption Year 4 Hour QuantityOption Year 4 Labor RateOption Year 4 TotalBase + All Option Year LaborTotal
CLIN (ANG FFP)CLIN 0001CLIN 0001CLIN 0001CLIN 1001CLIN 1001CLIN 1001CLIN 2001CLIN 2001CLIN 2001CLIN 3001CLIN 3001CLIN 3001CLIN 4001CLIN 4001CLIN 4001
TSSC Manager2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
Depot Manager2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
Configuration Manager2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
Logistics Support Lead2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
Admin Assistant / Data Manager0.00$ - 01040.00$ - 01040.00$ - 01040.00$ - 01040.00$ - 0
Technical Writer2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
Help Desk2080.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 0
Hardware Engineer2080.00$ - 00.00$ - 00.00$ - 00.00$ - 00.00$ - 0
Software Engineer2080.00$ - 00.00$ - 00.00$ - 00.00$ - 00.00$ - 0
Cybersecurity2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
Scenario Generation Developer0.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 0
Facility Security Manager2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
COMS Technical Manager2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
COMS Personnel16640.00$ - 016640.00$ - 016640.00$ - 016640.00$ - 016640.00$ - 0
Admin Assistant (Program Management Support)2080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 02080.00$ - 0
Program Management2080.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 0
TOTAL21.00Base Year$0.0023.50Option Year 1$0.0023.50Option Year 2$0.0023.50Option Year 3$0.0023.50Option Year 4$0.00
CLIN (AFRC FFP)CLIN 0002CLIN 0002CLIN 0002CLIN 1002CLIN 1002CLIN 1002CLIN 2002CLIN 2002CLIN 2002CLIN 3002CLIN 3002CLIN 3002CLIN 4002CLIN 4002CLIN 4002
Courseware/ Instructor16640.00$ - 016640.00$ - 016640.00$ - 016640.00$ - 016640.00$ - 0
Cybersecutiry4160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 0
Field Service Engineer4160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 0
Software Engineer4160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 04160.00$ - 0
TOTAL14.00Base Year$0.0014.00Option Year 1$0.0014.00Option Year 2$0.0014.00Option Year 3$0.0014.00Option Year 4$0.00
CLIN (ANG T&M Labor Surge)CLIN 0003CLIN 0003CLIN 0003CLIN 1003CLIN 1003CLIN 1003CLIN 2003CLIN 2003CLIN 2003CLIN 3003CLIN 3003CLIN 3003CLIN 4003CLIN 4003CLIN 4003
COMS Personnel0.00$ - 010400.00$ - 010400.00$ - 010400.00$ - 010400.00$ - 0
TOTAL0.00Base Year$0.005.00Option Year 1$0.005.00Option Year 2$0.005.00Option Year 3$0.005.00Option Year 4$0.00
LABOR TOTAL35.00$0.0042.50$0.0042.50$0.0042.50$0.0042.50$0.00$0.00
OTHER DIRECT COSTS (ODCs)
OTHER DIRECT COSTS [include materials/services per the PWS]Anticipated ODC Value - Base YearBase Year TotalAnticipated ODC Value - OY1OY1 TotalAnticipated ODC Value - OY2OY2 TotalAnticipated ODC Value - OY3OY2 TotalAnticipated ODC Value - OY4OY4 TotalBase + All Option Year ODC Total
CLIN (ANG)0004*$1,050,000.001004*$1,050,000.002004*$1,050,000.003004*$1,050,000.004004*$1,050,000.00
CLIN (AFRC)0005*$100,000.001005*$100,000.002005*$100,000.003005*$100,000.004005*$100,000.00
ODCs (NTE) * DO NOT ADJUST THESE FIGURES. SEE ADDITIONAL NOTE # 1 BELOW$1,150,000.00$1,150,000.00$1,150,000.00$1,150,000.00$1,150,000.00$5,750,000.00
TRAVEL
TRAVEL PERIOD OF PERFORMANCEAnticipated Travel Value - Base YearBase Year TotalAnticipated Travel Value - OY1OY1 TotalAnticipated Travel Value - OY1OY1 TotalAnticipated Travel Value - OY3OY3 TotalAnticipated Travel Value - OY4OY4 TotalBase + All Option Year Travel Total
CLIN (ANG)0006*$88,000.001006*$88,000.002006*$88,000.003006*$88,000.004006*$88,000.00
CLIN (AFRC)0007*$36,000.001007*$36,000.002007*$36,000.003007*$36,000.004007*$36,000.00
TRAVEL (NTE) * DO NOT ADJUST THESE FIGURES.$124,000.00$124,000.00$124,000.00$124,000.00$124,000.00$620,000.00
240
TOTALS
GRAND TOTAL PRICE ALL CLINS, ALL OPTION YEARS$6,370,000.00
NOTE # 1 PERTAINING TO ODC CLIN:
Any labor necessary for the oversight and management of the ODC material requirement should be included in labor CLIN pricing.

File details come from the government source that posted it.