Attachment 3 - Table L1-L2-L3.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- J059-PREVENTATIVE & CORRECTIVE SERVICES FOR UNINTERRUPTED POWER SUPPLY (UPS) Federal contract opportunity
- Solicitation number
- N0024424Q0001
About this file
This file contains pricing tables and notes for a solicitation seeking preventative and corrective maintenance services for uninterrupted power supply (UPS) systems. The solicitation is issued by the Department of the Navy Naval Supply Systems Command for J059-PREVENTATIVE & CORRECTIVE SERVICES FOR UNINTERRUPTED POWER SUPPLY (UPS). Table L1 lists 17 installation locations and provides pricing details for planned maintenance including labor hours, rates, and parts. Table L2 includes estimated corrective maintenance trips by location along with associated labor and travel pricing details. Table L3 summarizes total pricing by contract line item number for the base year and two option years. Notes provide parts pricing ceilings and state offerors may propose escalation rates and general and administrative rates.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| AMENDMENTS_10252023.pdf | ||
| Attachment 2 - Offeror Past Performance Data.docx | DOCX document | |
| Attachment 3 - Table L3.xlsx | XLSX spreadsheet | |
| Attachment 1 - Equipment Parts List_Updated.xlsx | XLSX spreadsheet | |
| RFQ N0024424Q0001_Combined SS.pdf | ||
| RFQ N0024424Q0001__Solicitation.pdf | ||
| Attachment 1 - Equipment Parts List.xlsx | XLSX spreadsheet | |
| Attachment 2 - Offeror Past Performance Data.docx | DOCX document |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
TABLE L1 - PM Price Schedule
| A | B | C | D | E | F | G | |||
| # | INSTALLATION | NUMBER OF LABOR-HOURS | |||||||
| ANNUAL | LABOR RATE/HOUR | TOTAL ANNUAL LABOR | |||||||
| (A x B) | PARTS AND CONSUMABLES | ||||||||
| ANNUAL | PM - BASE | ||||||||
| (C + D) | PM - OPT YR 1 | ||||||||
| [E + (E x ESCALTN)] | PM - OPT YR 2 |
[F + (E x ESCALTN)
| 1 | NAWS CHINA LAKE |
| 2 | EL CENTRO |
| 3 | NAS FALLON |
| 4 | NAS LEMOORE |
| 5 | MONTEREY |
| 6 | NAVAL BASE CORONADO (NBC): NAS NORTH ISLAND |
| 7 | NBC: SAN CLEMENTE ISLAND |
| 8 | NAVAL BASE SAN DIEGO (NBSD): RDC COOP |
| 9 | NBSD: RDC 1 |
| 10 | NBSD: RDC 2 |
| 11 | NWS SEAL BEACH (NWS SB) - 1 |
| 12 | NWS SB - 2 |
| 13 | NWS SB DET: FALLBROOK |
| 14 | NWS SB DET: CORONA |
| 15 | NAVAL BASE VENTURA COUNTY (NBVC): PORT HUENEME |
| 16 | NBVC: SAN NICHOLAS ISLAND** |
| 17 | NBSD: Regional HQ |
| TOTAL | |
| PM TOTAL - BASE + 2 OPTION YEARS |
TABLE L2 - CM Price Schedule
| PARAMETERS | BASE YEAR | OPTION YEAR 1 | OPTION YEAR 2 | ||||||||||||
| CLIN | 0002 | 0003 | 1002 | 1003 | 2002 | 2003 | |||||||||
| COLUMN | A | B | C | D | E | F | G | H | I | J | K | L | M | ||
| # | INSTALLATION | EST # TRIPS - ANNUAL | # LABOR HOURS PER TRIP ANNUAL | LABOR RATE/HOUR | TRIP RATE | LABOR ANNUAL | |||||||||
| (A x B x C) | PARTS | ||||||||||||||
| See note 1 | TRAVEL | ||||||||||||||
| (A x D) | LABOR ANNUAL |
[E + (E x %)
| See note 2 | PARTS | TRAVEL |
| {G + (G x %) | LABOR ANNUAL | |
| [H + (H x %) | PARTS | TRAVEL |
[J + (J x %)
| 1 | NAWS CHINA LAKE | 2 | 5 |
| 2 | EL CENTRO | 2 | 5 |
| 3 | NAS FALLON | 2 | 5 |
| 4 | NAS LEMOORE | 2 | 5 |
| 5 | MONTEREY | 2 | 5 |
| 6 | NAVAL BASE CORONADO (NBC): NAS NORTH ISLAND | 3 | 8.75 |
| 7 | NBC: SAN CLEMENTE ISLAND | 2 | 5 |
| 8 | NAVAL BASE SAN DIEGO (NBSD): RDC COOP | 2 | 5 |
| 9 | NBSD: RDC 1 | 2 | 5 |
| 10 | NBSD: RDC 2 | 2 | 5 |
| 11 | NWS SEAL BEACH (NWS SB) - 1 | 2 | 5 |
| 12 | NWS SB - 2 | 2 | 5 |
| 13 | NWS SB DET: FALLBROOK | 2 | 5 |
| 14 | NWS SB DET: CORONA | 2 | 5 |
| 15 | NAVAL BASE VENTURA COUNTY (NBVC): PORT HUENEME | 3 | 5 |
| 16 | NBVC: SAN NICHOLAS ISLAND** | 2 | 5 |
| 17 | NBSD: REGIONAL HQ | 2 | 5 |
| TOTAL | 34 | ||
| CLIN TOTAL | |||
| GRAND TOTAL | |||
| Notes: |
1. Parts ceiling amount is based on historical data. This amount can be found on page 37 of RFQ N0024424Q0001 solicitation attachment . Offeror may add G&A to these amount but the G&A rate shall be declared in the proposal. NOTE 2: The "%" sign is for contract escalation rate. If applicable, offeror may use escalation rate in the proposal. Otherwise, annual Travel price will be the same on base, and option years.
2. The "%" sign is for contract escalation rate. If applicable, offeror may use escalation rate in the proposal. Otherwise, annual Travel price will be the same on base, and option years.
TABLE L3-Price Proposal Summary
| CLIN | POP | MAINTENANCE | CONTRACT TYPE | TOTAL PRICE |
| 0001 | Base Year | PM | FFP | |
| 0002 | Base Year | CM | T&M LABOR | |
| 0003 | Base Year | CM | T&M ODC | |
| 1001 | Option 1 | PM | FFP | |
| 1002 | Option 1 | CM | T&M LABOR | |
| 1003 | Option 1 | CM | T&M ODC | |
| 2001 | Option 2 | PM | FFP | |
| 2002 | Option 2 | CM | T&M LABOR | |
| 2003 | Option 3 | CM | T&M ODC | |
| TOTAL EVALUATED COST/PRICE | ||||
| OTHER DATA | ||||
| PARTS HANDLING CHARGE TO COST OF PARTS (%) - IF USED |
- SEE PWS 5.2.3
| $ | ||
| CM PER TRIP PRICE ($/TRIP) - BASE YEAR | $ | |
| ESCALATION RATE (IF USED) | % |
File details come from the government source that posted it. Updated .