Attachment_0020,_TRM_Fielding_Plan_Estimate.xlsx

20 KB Posted

Attached to
Modular Fuel System Tank Rack Module
Solicitation number
W56HZV-18-R-0096
Issued by

About this file

From the source

TRM Fielding Plan Estimate

View the file

Other files

File Type Posted
W56HZV18R0096_conformed.pdf PDF
Tank_Rack_Module_Solicitation_Questions_and_Answers_amd_0003.docx DOCX document
W56HZV18R0096-0003.pdf PDF
Attachment_0021_Request_for_Waiver_of_First_Article_Testing_Requirements_-_v.R.2...docx DOCX document
Tank_Rack_Module_Solicitation_Questions_and_Answers_amd_0002.docx DOCX document
Attachment_0021_Request_for_Waiver_of_First_Article_Testing_Requirements_-_v.R.1...docx DOCX document
W56HZV18R0096-0002.pdf PDF
TRM_Pricing_Attachment_0017_rev_02.xlsx XLSX spreadsheet
W56HZV18R0096-0001.pdf PDF
TRM_Pricing_Attachment_0017_rev_01.xlsx XLSX spreadsheet
0016_LORA_Candidates_Sustainment_Level_Reparable_Item_Summary.xlsx XLSX spreadsheet
0001_ATPD_2336E_-_Modular_Fuel_System_(MFS)_GPM_12_AUG_2011.pdf PDF
Attachment_0018_Technical_Performance_Factor_Matrix.docx DOCX document
Attachment_0006_-_Request_for_Use_of_Prohibited_Materials.docx DOCX document
TRM_Pricing_Attachment_0017_.xlsx XLSX spreadsheet
Attachment_0019__IMI_Appendix_A.PDF PDF
0014_TRM_General_Publications_Requirements_for_Page-Based_TMs.doc DOC document
0010_TM_Crosswalk_Form.xls XLS spreadsheet
0011_DE_Style_Guide.pdf PDF
0008_TRM_TABLE_A-II_-_TM_Requirements_Matrix_-10.docx DOCX document
W56HZV18R0096.pdf PDF
Attachment_0022_Request_for_Waiver_of_Integrated_Product_Support_and_IMI.docx DOCX document
0004_Abbreviated_FAT_Plan_R1.docx DOCX document
0003_Full_FAT_plan_R1.docx DOCX document
Attachment_0021_Request_for_Waiver_of_First_Article_Testing_Requirements_.docx DOCX document
0013_Transaction_Format.docx DOCX document
0012_Packaging_Data_Products.docx DOCX document
0007_How_To_Access_AMPS_to_Request_WebFLIS_RoleV3.pdf PDF
0005_CARC_Paint_Drawing_12585018.pdf PDF
0009_TRM_TABLE_A-IV_-_TM_Requirements_Matrix_-23&P.docx DOCX document
0015_TRM-_TPG_2016-01_Source_Data.pdf.pdf PDF
Show all 31

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

New Assumptions

Year 1Year 2Year 3Year 4Year 5Year 6Year 7TOTAL
Total QTY1531692063852241501161403
Shipping Location
Alabama20
Alaska2120
Arizona132
Arkansas184
California246
Colorado264
Connecticut78
Delaware1
Florida2410
Georgia493
Hawaii64
Idaho33
Illinois16
Indiana2414
Iowa25
Kansas53
Kentucky231012
Louisiana1824
Maine6
Maryland103
Massachusetts56
Michigan108
Minnesota566
Mississippi53
Missouri13
Montana961
Nebraska2
Nevada1
New Hampshire
New Jersey19
New Mexico6
New York1864
North Carolina3130
North Dakota4
Ohio617
Oklahoma826
Oregon11
Pennsylvania1428
Rhode Island12
South Carolina1213
South Dakota7
Tennessee45
Texas659310
Utah58
Vermont
Virginia4
Washington28
West Virginia99
Wisconsin31
Wyoming
OCONUS
Germany22
Guam4
PR9

Total Fielding 153 169 206 385 224 150 116

Sheet1

Order Based on Funding Year
FY18FY19FY20FY21FY22FY23FY24TOTAL
TRM Unit Cost$0.062$0.064$0.066$0.068$0.070$0.072$0.074
Total QTY182309360266247187401591
Total $’s in Millions$11.3$19.7$23.7$18.0$17.2$13.4$3.0$106.36
Delivery Based on Ordering
ORDERERROR:#REF!FY18FY19FY20FY21FY22FY23TOTALYear 11821000000062,000.0161.09,982,000.011,284,000.00.06200.0620
182309360266247187401591Year 23091700000063,860.0266.016,986,760.019,732,740.00.06390.0639
Year 33601980000065,775.8301.019,798,515.823,679,288.00.06580.0658
15.1666666667303022.166666666720.583333333315.58333333333.3333333333Year 42661570000067,749.1232.015,717,785.218,021,253.70.06770.0677
Year 52471470000069,781.5211.014,723,906.317,236,041.90.06980.0698
205.794239.76177.156164.502124.54226.64Year 61871390000071,875.0193.013,871,873.613,440,623.60.07190.0719
182102.9897119.98888.657882.325162.327113.332Year 7401850000074,031.2227.016,805,092.02,961,249.70.07400.0740
15911591
DELIVERY491491397284187401591
MAX360360360360360360107,885,932.8
CARRY OVER13113137-76-173-320
ACT DELV360360360284187401591
10
FY of DeliveryFY19FY20FY21FY22FY23FY24FY25TOTAL17
Total Quantity9036036030724718740159119.8
Quantity924141000015.7
14.7
13.9
16.8
107.9
Order Based on Funding Year
FY18FY19FY20FY21FY22FY23FY24TOTAL
Total QTY182309360266247187401591
TRM Unit Cost$0.062$0.064$0.066$0.068$0.070$0.072$0.074
TRM $’s in Millions$11.28$19.73$23.68$18.02$17.24$13.44$2.96$106.36
PCA COST$0.10Year 11821000000073,000.0161.011,753,000.013,286,000.00.07300.0730
Total Cost$106.46Year 23091700000075,190.0266.020,000,540.023,233,710.00.07520.0752
Year 33601980000077,445.7301.023,311,155.727,880,452.00.07740.0774
Year 42661570000079,769.1232.018,506,424.521,218,572.90.07980.0798
Year 52471470000082,162.1211.017,336,212.220,294,049.40.08220.0822
Year 61871390000084,627.0193.016,333,012.415,825,250.40.08460.0846
Year 7401850000087,165.8227.019,786,640.63,486,632.70.08720.0872
IGCE15911591
Year 1Year 2Year 3Year 4Year 5Year 6Year 7TOTAL1591
Total QTY360360266247187131401591127,026,985.4
Unit Price*$0.073$0.075$0.077$0.080$0.082$0.085$0.087
Total Price*$26.28$27.07$20.60$19.70$15.36$11.09$3.49$123.59
PCA COST$0.10
Total Cost$123.69
Budgeting and Funding Chart
Year 1Year 2Year 3Year 4Year 5Year 6Year 7TOTAL
Total QTY360360266247187131401591
Unit Price*$0.073$0.075$0.077$0.080$0.082$0.085$0.087
Total Price*$26.28$27.07$20.60$19.70$15.36$11.09$3.49$123.59
PCA COST$0.10
Total Cost$123.69
MFS TRM Numbers Based on D Hill's PB 19 sheet
FY18FY19FY20FY21FY22FY23FY24TOTAL
Total QTY182309360266247187401591
TRM Unit Cost$0.062$0.064$0.066$0.068$0.070$0.072$0.074
TRM $’s in Millions$11.28$19.73$23.68$18.02$17.24$13.44$2.96$106.36
26.18613.83216.6624.97318.22199.872
12.486
Camel & Hippo13.7
358.7123287671189.4794520548228.2191780822342.095890411249.6027397261368.10958904111591
222.8904109589

File details come from the government source that posted it.