N3220519R9003 Exhibit A Rate Table.xlsx
XLSX spreadsheet 21 KB Posted
- Solicitation number
- N32205-19-R-9003
About this file
This document contains an Exhibit A Rate Table for the federal solicitation N32205-19-R-9003 seeking Wartsila brand equipment supply and maintenance repair services. The Rate Table specifies estimated labor hours and material kits required over a five year base period for maintenance of seals, propulsion, and other systems on various Navy vessel classes including T-AO, T-AKE, T-AOE, T-ARC, T-AH, T-ARS, T-AS, and T-ATS. Offerors are instructed to provide unit prices for the labor categories and material kits listed. The document also includes instructions for completing the Rate Table and notes that quantities indicated are government estimates subject to adjustment.
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
Instructions
| Instructions - Please Read |
| The spreadsheet is designed so that only one user needs to input data onto any page, thereby reducing the possibility of accidently overwriting someone else's data. |
If macros are disabled in your spreadsheet, select Tools, Macros, Security, and set security level to Medium. This will allow you to enable macros.
All data on the Enclosure Tabs comes from information entered into the Rate Table Tab. No data is to be entered directly into Enclosure Tab except for the Estimate Quantity and/or the Unit of Measure unless a special circumstance requires. The Unit Price will populate from corresponding data entered on the Rate Table Tab. This prevents errors in the price calculations resulting from users mistakenly changing cell values or formulas.
Cells which are colored light gray, are for user input. Please add zero "0" to all cells with no numerical value. Note - Not all light gray cells necessarily need to be filled in.
Filled cells such as this are Government Estimates that can be adjusted for user input.
The cells under Labor - Estimated Quantity are unprotected, user input is required if estimates vary from the quantity prepopulated.
Some cells, or groups of cells, contain helpful information attached as a comment. Cells with comments, such as this one, contain a small red marker in the upper right corner. Just place your cursor in the cell to read the comment.
The Contractor is required to fill in the information on the Rate Table Tab, including all applicable estimated quantities, unit prices and or unit of measure.
Exhibit A Rate Table
| EXHIBIT A LINE ITEM # | PWS Paragraph / CLIN | SUPPLIES / SERVICES | ESTIMATED QUANTITY | UNIT OF MEASURE | UNIT PRICE | AMOUNT | Year 2 | Year 3 | Year 4 | Year 5 | Ext Amount (Full POP) | Pre-priced Options to Extend Qty or Services |
| LABOR | ||||||||||||
| A001 | 2.1.1 / 0001 | PROGRAM MANAGER | 200 |
Willis, Derek L CIV COMSC, N10: Willis, Derek L CIV COMSC, N10:
| This is a Government Estimate; Quantity may be adjusted accordingly | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||
| A002 | 2.1.2 / 0001 | PROJECT MANAGER | 500 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A003 | 2.3 / 0001 | PROPULSION TECH | 5000 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A004 | 2.3 / 0001 | SEALS TECH | 3500 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A005 | 2.3 / 0001 | ENGINE TECH | 500 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A006 | 2.3 / 0001 | CONTROLS TECH | 500 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A007 | 2.2 / 0001 | SENIOR ENGINEER | 100 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A008 | 2.2 / 0001 | ENGINEER | 200 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A009 | 2.2 / 0001 | JUNIOR ENGINEER | 300 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A010 | 2.2 / 0001 | CAD OPERATOR | 300 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A011 | 2.2 / 0001 | QA ENGINEER | 50 | HOURS | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| LABOR TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| MATERIAL | |||||||||||||
| T-AO KITS | |||||||||||||
| A012 | 2.4 / 0001 | Aft Seal O/H Kit (P/N JCL001047-000) | 12 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A013 | 2.4 / 0001 | Fwd Seal O/H Kit (P/N JCL001048-000) | 12 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A014 | 2.4 / 0001 | Air Control Unit Service Kit (P/N JCL001049-000) | 12 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-AKE KITS | |||||||||||||
| A015 | 2.4 / 0001 | Fwd Seal Major O/H Kit (P/N WLP001326-001) | 6 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A016 | 2.4 / 0001 | Rudder Seal O/H Kit (P/N WLP001326-006) | 6 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A017 | 2.4 / 0001 | Bulkhead Seal Overhaul Kit (P/N WLP001327-001) | 6 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A018 | 2.4 / 0001 | FWD Seal Service Kit A (New Seal) (P/N H74985-02-9) | 6 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A019 | 2.4 / 0001 | FWD Seal Service Kit B (New Seal) (P/N H74985-02-10) | 6 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A020 | 2.4 / 0001 | AFT Seal Service Kit A (New Seal) (P/N H73952-01-10) | 6 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A021 | 2.4 / 0001 | AFT Seal Service Kit B (New Seal) (P/N H73952-01-11) | 6 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-AOE KITS | |||||||||||||
| A022 | 2.4 / 0001 | Fwd Seal O/H Kit (P/N WLP001281-001) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A023 | 2.4 / 0001 | Rudder Seal Kit (P/N WLP001280-000) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-ARC KITS | |||||||||||||
| A024 | 2.4 / 0001 | PORT Stern Tube Seal O/H (P/N H73953-03/ORK) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A025 | 2.4 / 0001 | STBD Stern Tube Seal O/H (P/N H73953-04/ORK) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-AH KITS | |||||||||||||
| A026 | 2.4 / 0001 | STERNGUARD 800 Mk II, AFT SEAL KIT(Mercy) (P/N SS-12951AK) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A027 | 2.4 / 0001 | STERNGUARD 800 Mk II, AFT SEAL KIT(Comfort) (P/N SS-18100AK) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A028 | 2.4 / 0001 | STERNGUARD 800 Mk II, FWD SEAL KIT(Mercy) (P/N SS-12951FK) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A029 | 2.4 / 0001 | STERNGUARD 800 Mk II, FWD SEAL KIT(Comfort) (P/N SS-T-AH 20 MKI) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-ARS KITS | |||||||||||||
| A030 | 2.4 / 0001 | Aft Stern Tube Seal O/H (P/N WLP001434-001) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A031 | 2.4 / 0001 | Rudder Seal Kit (P/N JCL001078-000) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-AS KITS | |||||||||||||
| A032 | 2.4 / 0001 | Aft Stern Tube Seal O/H (P/N WLP001368-001) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A033 | 2.4 / 0001 | Rudder Seal Kit (P/N WLP001370-001) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-ATS KITS | |||||||||||||
| A034 | 2.4 / 0001 | Aft Stern Tube Seal O/H (P/N TBD) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A035 | 2.4 / 0001 | Rudder Seal Kit (P/N TBD) | 1 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| T-EPF KITS | |||||||||||||
| A036 | 2.4 / 0001 | Replace Shaft Sleeve (P/N WDI002106-001) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A037 | 2.4 / 0001 | O/H Set Shaft Seal Service Kit B (Non-Split) (P/N WDI002106-002) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A038 | 2.4 / 0001 | O/H Set for Thrust Bearing Box (P/N WDI002106-003) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A039 | 2.4 / 0001 | Replace Shaft Sleeve Thrust Brg (P/N WDI002106-004) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A040 | 2.4 / 0001 | Mount for Stator Bowl (P/N WDI002106-005) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A041 | 2.4 / 0001 | Replace Rubber Bearing (P/N WDI002106-006) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A042 | 2.4 / 0001 | O/H Jetavator Bearing (P/N WDI002106-007) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A043 | 2.4 / 0001 | Replace Sacrificial Anodes (P/N WDI002106-008) | 56 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A044 | 2.4 / 0001 | O/H Steering Cylinder (P/N WDI002106-009) | 23 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A045 | 2.4 / 0001 | O/H Steering Cylinder (P/N WDI002106-010) | 23 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| A046 | 2.4 / 0001 | O/H Shaft Seal Assembly Service Kit C (Split) (P/N WDI002106-011) | 5 | EACH | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| ADDITIONAL PARTS NOT LISTED | |||||||||||||
| A047 | 2.4 / 0001 | Miscellaneous Supplies (Spare Parts and Unknown Parts) | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||
| MATERIALS TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||||||
| Travel | |||||||||||||
| A048 | 4.0 / 0001 | Travel (CONUS and/or OCONUS) | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| TRAVEL TOTAL | $0.00 | ||||||||||||
| A049 | 2.4.4.B / 0001 | Expedited Delivery Surcharge | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| A050 | 2.4.4.A / 0001 | Special Delivery Surcharge | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| CLIN 0001 | Supplies/Products | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| CLIN 0001 | Services | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| CLIN 0001 | Travel | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||
| CLIN 0001 | Contract Data Requirements List | 1 | NSP | NSP | NSP | NSP | NSP | NSP | NSP | NSP | |||
| CLIN 0001 | Option to Increase Qty | 1 | LOT | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Willis, Derek L CIV COMSC, N10: Willis, Derek L CIV COMSC, N10:
Please see solicitation for calculations
CLIN 0001 Option to Extend Services 1 LOT $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Willis, Derek L CIV COMSC, N10: Willis, Derek L CIV COMSC, N10:
Please see solicitation for calculations
Willis, Derek L CIV COMSC, N10: Willis, Derek L CIV COMSC, N10:
This is a Government Estimate; Quantity may be adjusted accordingly TOTAL EVALUATED PRICE $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
File details come from the government source that posted it. Updated .