Engine_TOC_WkBk_QSB6.7_420HP_19Oct16.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
U. S. Navy Patrol Boat (PB-X)
Solicitation number
N00024-17-R-2209
Issued by

About this file

Engine TOC Excel Worksheet

View the file

Other files

File Type Posted
Attachment_L-9_Offeror's_Question_and_Answers_19Apr17.pdf PDF
N00024-17-R-2209-0009.pdf PDF
Attachment_L-9_Offeror's_Question_and_Answers_11Apr17.pdf PDF
N00024-17-R-2209-0008.pdf PDF
Attachment_L-9_Offeror's_Question_and_Answers_04_April_2017.pdf PDF
PB(X)_Industry_Day_Companies.pdf PDF
Attachment_L-4a_PB-X_CLIN_Price_Sht_Mar_2017.xlsx XLSX spreadsheet
N00024-17-R-2209_(PB-X)_Amend_03.pdf PDF
PB-X_Specification_Rev(B)_31Mar17.pdf PDF
Attachment_L-9_Offeror's_Question_and_Answers_09_March_2017.pdf PDF
N00024-17-R-2209-0002.pdf PDF
Attachment_L-9_Offeror's_Questions_and_Answers_08_March_2017.pdf PDF
N00024-17-R-2209-0001.pdf PDF
PB-X_L_Attachments.zip ZIP file
N00024-17-R-2209_FBO.pdf PDF
PB-X_Technical_Guidance_documents.zip ZIP file
PB-X_Draft_RFP_QandA_02-17-17.pdf PDF
DRAFT_PB-X_J&L_Attachments.zip ZIP file
(DRAFT)_N00024-17-R-2209.pdf PDF
Draft_PB-X_DRL_-_(Revision)_Dec_2016.docx DOCX document
PB-X_Industry_Day_Brief_--_ver_C_(FINAL).pptx PPTX presentation
PBX_draft_GFI_Attachment_J-4_28Oct2016.docx DOCX document
PBX_draft_GFE_Attachment_J-3_Rev_A.docx DOCX document
PB-X_Draft_RFP_Questions_and_Answers_11-29-16.docx DOCX document
Attachment_2_PB-X_Draft_Section_L_and_M_11-9-16.docx DOCX document
Attachment_1_PB-X_Draft_SOW_11-9-16.docx DOCX document
Attachment_3_PB-X_draft_Specification_11-9-16.doc DOC document
Attachment_5_Use_and_Nondisclosure_(NDA).docx DOCX document
2016-11-02_PB-X_Industry_Day_Flyer_R1.pdf PDF
PB-X_Sources_Sought_--_ATT_1_Rev_A--_19Oct2016.docx DOCX document
Engine_TOC_Workbook_Instructions_(19OCT16).docx DOCX document
PB-X_Sources_Sought_--_ATT_1_--_091016.docx DOCX document
Show all 32

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

Fuel Consumption

Fuel Life-Cycle Cost based on 2000 operating hours per year (15 Year Service Life)
***Please fill in Orange Cells only
Engine ModelCummins QSB-6.7
Engine Rated Brake Horsepower420
Fuel Tank Capacity (gallons)400
Cruise Speed (knots)25
OPTEMPO Hours2000
Service Life (years)15
Required Range (NM)200
Fuel Tank Capacity Minus 10% Reserve (gallons)360
Total Harbor Patrol Fuel LCC$ 525,596.45
Total HVU Escort Fuel LCC$ 1,287,676.22
Operating Profile SpeedsSpeed DefinitionsCraft Forward Speed (kts)Single Engine
Fuel Consumption (GPH)Comments
IdleMinimum Power (in gear)3.60.6
Patrol10 kts10.06.6
CruiseMost fuel efficient speed above or equal to 25 knots25.012.3
Sprint100% Power37.220.7
Operating Profile SpeedsHarbor Patrol
Profile PercentageHarbor Patrol
Yearly Fuel Consumption (gallons)Harbor Patrol

Life Cycle Fuel Consumption (gallons)

Idle82%196829520
Patrol11%290443560
Cruise5%246036900
Sprint2%165624840
Total Fuel Consumption8988134820
Operating Profile SpeedsHVU Escort
Profile PercentageHVU Escort
Yearly Fuel Consumption (gallons)HVU Escort

Live Cycle Fuel Consumption (gallons)

Idle56%134420160
Patrol19%501675240
Cruise15%7380110700
Sprint10%8280124200
Total Fuel Consumption22020330300
Fuel Capacity Check
Mission (12 hrs)Fuel Consumed (gallons)Capacity Check
Harbor Patrol54OK
HVU Escort132OK
Range Check
Boat Range (NM) @ CruiseRange Check
366OK
201720182019202020212022202320242025202620272028202920302031
Diesel Fuel Cost^$ 3.50$ 3.53$ 3.61$ 3.67$ 3.74$ 3.82$ 3.87$ 3.92$ 3.98$ 4.02$ 4.08$ 4.12$ 4.16$ 4.20$ 4.25
Harbor Patrol Yearly Fuel Burn898889888988898889888988898889888988898889888988898889888988
HVU Escort Yearly Fuel Burn220202202022020220202202022020220202202022020220202202022020220202202022020
^ Projected Diesel Fuel Cost (EIA, AEO2014)

Engine Maintenance

Engine Maintenance Life-Cycle Cost based on 2000 operating hours per year (15 Year Service Life)
***Please fill in Orange Cells only unless adding Maintenance Tasks or Material items
Engine ModelQSB-6.7
Engine Rated Horsepower550
Overall Reliability: Mean Time Between Failures (MTBF) (hours)*1500
Mean Time To Repair (MTTR) (hours)20
*Optional: Provide additional supportability analysis documentation in a separate document
OPTEMPO Hours2000
Service Life (years)15

Total Engine Maintenace Life Cycle Cost $ 659,122.20

Life Cycle Labor Cost
Maintenance TaskFrequency of Maintenance Task
MRC #Task*Estimated labor hours per task per engineLife Cycle labor hours per task/twin engineFrequency (hours)# times/service lifeComment
A98EYNNLubricate Pedestal Bearing0.296125240
959SPYNTest Propulsion Engine Neutral Safety Switch1480125240
95H0RENTest Cooling System Coolant0.3144125240
858EMBNLubricate and Test Mechanical Emergency Shutdown Device0.248250120
958EZPYChange Engine Lube Oil. Replace Engine Lube Oil Filter Element3720250120
852YKVNInspect Governor Operation. Inspect Air Box Drains0.496250120
858EYVYClean Transmission Oil Strainer336050060
Replace Transmission Oil Filter Element
Change Transmission and Reduction Gear Lube Oil
Clean and Inspect Transmission Breather
732LWQNClean and Inspect Air Intake Screen0.33650060
858EYXYClean Fuel Strainer(s). Replace Fuel Oil Filter Element(s)112050060
858EZUNClean Crankcase Breather. Clean Reduction Gear Breather Cap0.636100030
854JACYReplace Coalescer Filter Element0.56050060
858EZTUPerform Engine Tuneup24000Accomplish when directed as result of engine operating conditions
856MVKUInspect Blower and Measure Clearances1.4000Accomplish when directed as result of engine operating conditions
858EZVNClean and Preserve Engine for Inactivity5000Accomplish when directed as result of engine operating conditions
268EZDNRemove Fuel From Boat; Clean Fuel Tank(s). Move Boat to Storage Area6000Accomplish when directed as result of engine operating conditions
856MVPNTurn Engine Over 1-1/4 Turns0.3000Accomplish when directed as result of engine operating conditions
868EZFNRemove Boat From Storage; Fuel Boat3000Accomplish when directed as result of engine operating conditions
958EZWNPrepare Engine For Operation22000Accomplish when directed as result of engine operating conditions
Maintaner Labor Rate ($/hr)$28.40
Total Life Cycle Maintenance Labor hours2196
Total Life Cycle Labor Cost$ 62,366.40
*Add/Modify maintenance task matrix as appropiate
Engine Overhaul Cost
Frequency (months)# times/service lifeCost
Overhaul Engine-Full365$ 30,000.00
Total Life Cycle Overhaul Cost$ 300,000.00
Life Cycle Material Cost
MRC #Maintenance TaskItemPart No.QuantityUnit of IssueUnit CostTotal Item Cost# times/service lifeMaint. Task Life Cycle Material CostComments
A98EYNNLubricate Pedestal Bearing$ 72.58240$ 17,419.20
Lubricate Pedestal BearingGrease1372K121oz$ 6.78$ 6.78
Lubricate Pedestal BearingFitting, LubricatingNo NSN - W/C Provided$ - 0
Lubricate Pedestal BearingRag, Wiping63485T941pkg$ 6.21$ 6.21
Lubricate Pedestal BearingTag, Safety15455T211pkg$ 13.59$ 13.59
Lubricate Pedestal BearingGrease, Ball and Roller Bearing DOD-G-245081ea$ 46.00$ 46.00
959SPYNTest Propulsion Engine Neutral Safety Switch$ 27.18240$ 6,523.20
Test Propulsion Engine Neutral Safety SwitchRag, Wiping63485T941pkg$ 6.21$ 6.21
Test Propulsion Engine Neutral Safety SwitchTag, Safety15455T211pkg$ 13.59$ 13.59
Test Propulsion Engine Neutral Safety SwitchTag, Shipping1547T211pkg$ 6.32$ 6.32
Test Propulsion Engine Neutral Safety SwitchWatch, WristNo NSN - W/C Provided$ - 0
Test Propulsion Engine Neutral Safety SwitchWater, FreshNo NSN - W/C Provided$ - 0
Test Propulsion Engine Neutral Safety SwitchChalk, Marking1648T91pkg$ 1.06$ 1.06
95H0RENTest Cooling System Coolant$ 607.86240$ 145,886.40
Pen, Ball-Point, Black16805T41pkg$ 1.65$ 1.65
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Watch, WristNo NSN - W/C Provided$ - 0
858EMBNLubricate and Test Mechanical Emergency Shutdown Device$ 300.00120$ 36,000.00
Lubricating Oil, Engine, SAE-40, MIL-PRF-9000J(SH)15-gallons$ 300.00$ 300.00
958EZPYChange Engine Lube Oil, Replace Engine Lube Oil Filter Element$ 413.51120$ 49,621.20
Cloth, Cleaning7089T31140-pkg$ 11.93$ 11.93
Container (all types)No NSN - W/C Provided$ - 0
Lubricating Oil, Engine, SAE-40, MIL-PRF-9000J(SH)15-gallons$ 300.00$ 300.00
Tag, Safety15455T211pkg$ 13.59$ 13.59
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
Filter Element, Fluid (04021)1ea$ 17.00$ 17.00
Filter Element, Fluid (04858)1ea$ - 0$ - 0
Filter Element, Fluid (08168)1ea$ - 0$ - 0
852YKVNInspect Governor Operation. Inspect Air Box Drains$ 13.59120$ 1,630.80
Tag, Safety15455T211pkg$ 13.59$ 13.59
858EYVYClean Transmission Oil Strainer$ 393.4860$ 23,608.80
Replace Transmission Oil Filter ElementContainer (all types)No NSN - W/C Provided$ - 0
Change Transmission and Reduction Gear Lube OilLubricating Oil, Engine, SAE-40, MIL-PRF-9000J(SH)15-gallons$ 300.00$ 300.00
Clean and Inspect Transmission BreatherRag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
Filter Element, Fluid1ea$ 2.69$ 2.69
Gasket$ - 0
Gasket$ - 0
732LWQNClean And Inspect Air Intake Screen$ 90.0060$ 5,400.00
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Pail, Utility, Plastic, 3 GL40015T411ea$ 14.44$ 14.44
Brush, Plater's Hand1ea$ 5.44$ 5.44
Gloves, Disposable, Nitrile, 8 Mil52555T67150-pkg$ 12.64$ 12.64
Filter Cleaning KitDDF 90001ea$ 37.68$ 37.68
858EYXYClean Fuel Strainer(s). Replace Fuel Oil Filter Element(s)$ 165.4230$ 4,962.60
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
Element, Fuel Filter (MFR Part No.)From Engine1ea$ 74.63$ 74.63
858EZUNClean Crankcase Breather. Clean Reduction Gear Breather$ 95.0660$ 5,703.60
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag,Safety15455T211pkg$ 13.59$ 13.59
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
Wire, Nonelectrical, 0.063"1ft$ 4.27$ 4.27
854JACYReplace Coalescer Filter Element$ 95.060$ - 0Accomplish when directed as result of engine operating conditions
Container (all types)No NSN - W/C Provided$ - 0
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
Wire, Nonelectrical, 0.063"1ft$ 4.27$ 4.27
858EZTUPerform Engine Tuneup$ 434.430$ - 0Accomplish when directed as result of engine operating conditions
Dowel, Wood (1/4" X 12")112-pkg$ 14.38$ 14.38
Lubricating Oil, Engine, SAE-40, MIL-PRF-9000J(SH)15-gallons$ 300.00$ 300.00
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Diesel Fuel, Marine, No NSN1gallon$ 1.84$ 1.84
Pad, Writing Paper12945T21112-pkg$ 14.05$ 14.05
Pencil1653T22112-pkg$ 3.66$ 3.66
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
Wire, Nonelectrical, 0.063"1ft$ 4.27$ 4.27
Brush, Plater's Hand1ea$ 5.44$ 5.44
856MVKUInspect Blower and Measure Clearance$ 97.070$ - 0Accomplish when directed as result of engine operating conditions
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Buffing Compound, MIL-B-16909, GR B1ea$ 77.27$ 77.27
858EZVNClean and Preserve Engine for Inactivity$ 1,145.990$ - 0Accomplish when directed as result of engine operating conditions
Container (all type)No NSN - W/C Provided$ - 0
Corrosion Preventive Compound, MIL-C-16173, GR 3 SFT1ea$ 50.75$ 50.75
Lubricating Oil, Engine, SAE-40, MIL-L-21260, SYM PE 10-11ea$ 260.21$ 260.21
Lubricating Oil, Engine, MIL-L-21260, SYM PE 10-11ea$ 260.21$ 260.21
Lubricating Oil, Engine, MIL-L-21260, SYM PE 30-11ea$ 302.17$ 302.17
Paper, Kraft, Treated1ea$ 152.64$ 152.64
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Tag, Shipping1547T211pkg$ 6.32$ 6.32
Plywood, Fire Retardant1125T411ea$ 10.67$ 10.67
Wire, Nonelectrical, 0.063"1ft$ 4.27$ 4.27
Tape, Pressure Sensitive, Adhesive (Mfr Part No. FRD-60, Cage 012651ea$ 78.95$ 78.95
268EZDNRemove Fuel From Boat; Clean Fuel Tank(s). Move Boat to Storage Area$ 601.920$ - 0Accomplish when directed as result of engine operating conditions
Cloth, Cleaning7089T31140-pkg$ 11.93$ 11.93
Container (all types)No NSN - W/C Provided$ - 0
Tarpaulin7882T5811ea$ 519.00$ 519.00
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
856MVPNTurn Engine Over 1-1/4 Turns$ 1.060$ - 0Accomplish when directed as result of engine operating conditions
Chalk Assortment, Marking, Colored1648T91pkg$ 1.06$ 1.06
868EZFNRemove Boat From Storage; Fuel Boat$ 6.210$ - 0Accomplish when directed as result of engine operating conditions
Rag, Wiping63485T941pkg$ 6.21$ 6.21
958EZWNPrepare Engine For Operation$ 298.990$ - 0Accomplish when directed as result of engine operating conditions
Can, Ash, and Garbage4011T11ea$ 18.77$ 18.77
Container (all types)No NSN - W/C Provided$ - 0
Detergent, General Purpose, Water Soluble, MIL-D-167911gallon$ 31.67$ 31.67
Rag, Wiping63485T941pkg$ 6.21$ 6.21
Tag, Safety15455T211pkg$ 13.59$ 13.59
Cleaning Compound, Solvent, MIL-PRF-680 Type III, A-A-5960115 gallon$ 70.99$ 70.99
Sodium Metasilicate, Anhydrous, Technical, ASTM-D-5371ea$ 157.76$ 157.76
Water, FreshNo NSN - W/C Provided
Total Life Cycle Material Cost$ 296,755.80

File details come from the government source that posted it. Updated .