Copy of Firetruck Annual Inspection Pricing Matrix.xlsx

XLSX spreadsheet 32 KB Posted Apr 29, 2025

Attached to: Annual Mobile Fire Emergency Inspection IAW NFPA 1910
Solicitation number: W911S725QA002
Issued by: Department of the Army Materiel Command Mission and Installation Contracting Command Fort Eustis

About this file

Written by GovTribe AI · Apr 29, 2025

The file is a Firetruck Annual Inspection Pricing Matrix Excel spreadsheet for a solicitation by the US Army Fort Leonard Wood Fire Department. The document outlines a comprehensive pricing structure for annual fire truck inspections across five years, covering multiple inspection types including Bumper-to-Bumper (B2B) inspections, Annual Pump Tests, and Annual Aerial Services for various fire trucks with specific VIN numbers. Inspection quarters are divided into 2nd (February), 3rd (May), 4th (August), and annual periods in June and February/March.

The solicitation (W911S725QA002) requires inspection of 9 fire trucks from manufacturers including Pierce, Ferrara, Oshkosh, KME International, Ford, and E-One, following NFPA 1910 Standard guidelines. Incidental costs are included for round-trip travel to Fort Leonard Wood, Missouri, with set rates for lodging ($110/night), meals ($63/day), and incidental expenses ($5/day). The pricing matrix is structured to capture unit prices for each truck and inspection type across the base year and subsequent four years, with a consistent per-mile travel rate that slightly decreases from $0.70 to $0.67 in subsequent years.

View the file

Other files

File	Type	Posted
Updated - Firetruck Annual Inspection Pricing Matrix.xlsx	XLSX spreadsheet	Jul 3, 2025
Solicitation Amendment W911S725QA0020003 SF 30 1.pdf	PDF	Jul 3, 2025
Solicitation Amendment W911S725QA0020002 SF 30.pdf	PDF	May 21, 2025
Questions and Answers Posting to W911S725QA0002 (FIRETRUCK SOLICITATION).pdf	PDF	May 21, 2025
Solicitation Amendment Notice ID W911S725QA0002 2.pdf	PDF	May 13, 2025
Copy of Firetruck Annual Inspection Pricing Matrix 1.xlsx	XLSX spreadsheet	May 13, 2025
PUMP PERFORMANCE TEST WORKSHEET.pdf	PDF	Apr 29, 2025
ANN INSPECTION BUMPER-TO-BUMPER (B2B) WORKSHEET.pdf	PDF	Apr 29, 2025
Solicitation - W911S725QA002.pdf	PDF	Apr 29, 2025

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.

Summary

FIRETRUCK ANNUAL INSPECTION PRICING SUMMARY
Quarter	Truck/VIN	Base Year	Year 1	Year 2	Year 3	Year 4	5 Year Total Per Truck
2nd (FEB)	Bumper 2 Bumper (B2B) Inspections
	Engine 1753 VIN: 4P1BAAFF1MB023506	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Hazmat 1785 VIN: 4ENRAAA89V1008078	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Rescue 1781 VIN: 4P1BBAFF5GA015853	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
3rd (May)	Bumper 2 Bumper (B2B) Inspections
	Ladder 1759 VIN: 4P1BBAFF5GA015853	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Engine 1750 VIN: 1F93142259H140630	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
4th (Aug)	Bumper 2 Bumper (B2B) Inspections
	Engine 1752 VIN: 4P1BAAFF9NB024548	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Squad 1782 VIN: 1FDAF57F42EC47209	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	ARFF 1758 VIN: 10TBKAK124S080051	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Annual (June)	Annual Pump Test
	Engine 1750 VIN: 1F93142259H140630	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Engine 1752 VIN: 4P1BAAFF9NB024548	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Engine 1753 VIN: 4P1BAAFF1MB023506	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Ladder 1759 VIN: 4P1BBAFF5GA015853	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Annual (Feb/Mar)	Annual Aerial Service
	Ladder 1759 VIN: 4P1BBAFF5GA015853	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Incidentals	Per Service Request
	Round trip travel (To Ft. Leonard Wood, MO)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Lodging Rate per Night	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Meal Rate per Day	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Incidental Rate per Day	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

$ - 0

Base Year

FIRETRUCK ANNUAL INSPECTION PRICING BASE YEAR
Quarter	Truck/VIN	Quantity (Unit)		Unit Price	Total	Cannot Perform
2nd (FEB)	Bumper 2 Bumper (B2B) Inspections
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Hazmat 1785 VIN: 4ENRAAA89V1008078	1	Truck		$ - 0
	Rescue 1781 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
3rd (May)	Bumper 2 Bumper (B2B) Inspections
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
4th (Aug)	Bumper 2 Bumper (B2B) Inspections
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Squad 1782 VIN: 1FDAF57F42EC47209	1	Truck		$ - 0
	ARFF 1758 VIN: 10TBKAK124S080051	1	Truck		$ - 0
Annual (June)	Annual Pump Test
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
Annual (Feb/Mar)	Annual Aerial Service
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
Incidentals	Per Service Request
	Round trip travel (To Ft. Leonard Wood, MO)		Miles	$ 0.70	$ - 0
	Lodging Rate per Night		Nights	$ 110.00	$ - 0
	Meal Rate per Day		Days	$ 63.00	$ - 0
	Incidental Rate per Day		Days	$ 5.00	$ - 0

Total $ - 0

Year 1

FIRETRUCK ANNUAL INSPECTION PRICING YEAR 1
Quarter	Truck/VIN	Quantity (Unit)		Unit Price	Total	Cannot Perform
2nd (FEB)	Bumper 2 Bumper (B2B) Inspections
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Hazmat 1785 VIN: 4ENRAAA89V1008078	1	Truck		$ - 0
	Rescue 1781 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
3rd (May)	Bumper 2 Bumper (B2B) Inspections
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
4th (Aug)	Bumper 2 Bumper (B2B) Inspections
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Squad 1782 VIN: 1FDAF57F42EC47209	1	Truck		$ - 0
	ARFF 1758 VIN: 10TBKAK124S080051	1	Truck		$ - 0
Annual (June)	Annual Pump Test
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
Annual (Feb/Mar)	Annual Aerial Service
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
Incidentals	Per Service Request
	Round trip travel (To Ft. Leonard Wood, MO)		Miles	$ 0.67	$ - 0
	Lodging Rate per Night		Nights	$ 110.00	$ - 0
	Meal Rate per Day		Days	$ 63.00	$ - 0
	Incidental Rate per Day		Days	$ 5.00	$ - 0

Total $ - 0

Year 2

FIRETRUCK ANNUAL INSPECTION PRICING YEAR 2
Quarter	Truck/VIN	Quantity (Unit)		Unit Price	Total	Cannot Perform
2nd (FEB)	Bumper 2 Bumper (B2B) Inspections
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Hazmat 1785 VIN: 4ENRAAA89V1008078	1	Truck		$ - 0
	Rescue 1781 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
3rd (May)	Bumper 2 Bumper (B2B) Inspections
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
4th (Aug)	Bumper 2 Bumper (B2B) Inspections
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Squad 1782 VIN: 1FDAF57F42EC47209	1	Truck		$ - 0
	ARFF 1758 VIN: 10TBKAK124S080051	1	Truck		$ - 0
Annual (June)	Annual Pump Test
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
Annual (Feb/Mar)	Annual Aerial Service
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
Incidentals	Per Service Request
	Round trip travel (To Ft. Leonard Wood, MO)		Miles	$ 0.67	$ - 0
	Lodging Rate per Night		Nights	$ 110.00	$ - 0
	Meal Rate per Day		Days	$ 63.00	$ - 0
	Incidental Rate per Day		Days	$ 5.00	$ - 0
				Total	$ - 0

Year 3

FIRETRUCK ANNUAL INSPECTION PRICING YEAR 3
Quarter	Truck/VIN	Quantity (Unit)		Unit Price	Total	Cannot Perform
2nd (FEB)	Bumper 2 Bumper (B2B) Inspections
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Hazmat 1785 VIN: 4ENRAAA89V1008078	1	Truck		$ - 0
	Rescue 1781 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
3rd (May)	Bumper 2 Bumper (B2B) Inspections
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
4th (Aug)	Bumper 2 Bumper (B2B) Inspections
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Squad 1782 VIN: 1FDAF57F42EC47209	1	Truck		$ - 0
	ARFF 1758 VIN: 10TBKAK124S080051	1	Truck		$ - 0
Annual (June)	Annual Pump Test
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
Annual (Feb/Mar)	Annual Aerial Service
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
Incidentals	Per Service Request
	Round trip travel (To Ft. Leonard Wood, MO)		Miles	$ 0.67	$ - 0
	Lodging Rate per Night		Nights	$ 110.00	$ - 0
	Meal Rate per Day		Days	$ 63.00	$ - 0
	Incidental Rate per Day		Days	$ 5.00	$ - 0
				Total	$ - 0

Year 4

FIRETRUCK ANNUAL INSPECTION PRICING YEAR 4
Quarter	Truck/VIN	Quantity (Unit)		Unit Price	Total	Cannot Perform
2nd (FEB)	Bumper 2 Bumper (B2B) Inspections
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Hazmat 1785 VIN: 4ENRAAA89V1008078	1	Truck		$ - 0
	Rescue 1781 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
3rd (May)	Bumper 2 Bumper (B2B) Inspections
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
4th (Aug)	Bumper 2 Bumper (B2B) Inspections
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Squad 1782 VIN: 1FDAF57F42EC47209	1	Truck		$ - 0
	ARFF 1758 VIN: 10TBKAK124S080051	1	Truck		$ - 0
Annual (June)	Annual Pump Test
	Engine 1750 VIN: 1F93142259H140630	1	Truck		$ - 0
	Engine 1752 VIN: 4P1BAAFF9NB024548	1	Truck		$ - 0
	Engine 1753 VIN: 4P1BAAFF1MB023506	1	Truck		$ - 0
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
	Tanker 1761 VIN: 1HTGSSNT3EH799002	1	Truck		$ - 0
Annual (Feb/Mar)	Annual Aerial Service
	Ladder 1759 VIN: 4P1BBAFF5GA015853	1	Truck		$ - 0
Incidentals	Per Service Request
	Round trip travel (To Ft. Leonard Wood, MO)		Miles	$ 0.67	$ - 0
	Lodging Rate per Night		Nights	$ 110.00	$ - 0
	Meal Rate per Day		Days	$ 63.00	$ - 0
	Incidental Rate per Day		Days	$ 5.00	$ - 0

Total $ - 0

File details come from the government source that posted it. Updated Apr 29, 2025.