Attachment 9 - NMCC PECP Pricesheet.xlsx

XLSX spreadsheet 64 KB Posted

Attached to
NMCC Facility Maintenance Services Federal contract opportunity
Solicitation number
FA701424R0069
Issued by
Department of the Air Force Headquarters District Washington

About this file

This document appears to be an attachment containing a price sheet template for a federal contract opportunity. The template is for a proposal to provide facility maintenance services for the National Military Command Center (NMCC) under Solicitation FA701424R0069. The template includes instructions for completing the price sheet, which requires offerors to provide labor category titles, estimated hours, unburdened salaries, fringe costs, and fully burdened labor rates. The template covers a five-year base period and one six-month option period. The total proposed price for the labor and materials is $150,000 per year for the base period and option years, with a six-month extension option priced at $75,000. The key labor categories mentioned include Senior Subject Matter Expert, Master Subject Matter Expert, Journeyman Subject Matter Expert, Project Manager, Technician, and Journeyman Subject Matter Expert with AutoCAD expertise. The document provides a brief job description for each labor category.

View the file

Other files for this federal contract opportunity

Show all 13

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

Instructions V2.0

FINAL

Instructions: This format shall be used for all Price Proposals . As a minimum, offerors shall fill in the items in blue (blue text or text box filled in blue), as applicable to the requirement.

1. General:

a. It is the offeror's responsibility to ensure all columns and rows with formulas calculate correctly and provide a true representation of the proposed effort.

b. The Core FTE sheet will only include proposed pricing for all FTEs required by the effort (i.e., those other than optional).

c. The Optional FTE sheet will only include proposed pricing for all optional FTEs.

2. Labor Category: Insert the titles of applicable labor categories and, in parentheses, include the task(s) to which they apply and the number of FTEs in the labor category working on that task(s). For example: Program Manager (task 3.2 (2 FTEs), task 3.5 (1 FTE)) as an example. If there are more than four labor categories proposed, copy one of the previous grouping of rows (for example rows 31-39) and insert at the bottom. Repeat as many times as required. If less that four labor categories are required, offers may delete additional rows not required.

3. Est. Hrs (separate columns for each PoP): Each FTE should add up to 1920 hours for each labor category, unless otherwise specified. The Government normally uses 1920 or 1880 hrs. for each person proposed when planning.

4. Salary: Insert your proposed cost elements for each of the labor categories for the solicited effort. ENSURE the Total Cost and Loaded Rate columns will automatically calculate

Note: The information provided on this spreadsheet to include the Unburdened Labor and fringe as updated in the tabs. This information will be used to review and evaluate the Employee Compensation Plan (ECP).

FTEs BASE

FA701419RA022
PECP Proposal for - NMCC ATTACHMENT 2
FTEs Total15 Dec 2019 - 14 Dec 2020
LABOR CATEGORY (Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert, EngineerPara 4.1 Task 1 of the PWS:1,920.0$ 100,000.00$ 32,000.00$ (2,000.00)$ 131,920.00
Senior Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert
w/AutoCad Expertise$ - 0
Project Manager
Technician$ - 0
Technician$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

Job Skill Description

Facilities IGCE - With FTE Designations
Workload Data shows 9 FTEs
SkillsetBrief Job Description
1. Senior Subject Matter Expert

2. Master Subject Matter Expert

3. Master Subject Matter Expert

4. Journeyman Subject Matter Expert

5. Journeyman Subject Matter Expert

6. Journeyman Subject Matter Expert ~ Provide Project Management of Renovation and Reconfiguration of Operations and Support Spaces ~ Maintain AutoCAD drawings and other configuration data ~ Maintain SCIF Accreditation and Access Control Facilities Systems O&M ~ Maintain & Operate MAXIMO Maintenance Software ~ Maintain HEMP Enclosures ~ Operate & Maintain NMCC Emergency Mechanical and Electrical Systems O&M ~ Maintain & Operate Metasys System ~ Emergency Response to Mission System Outages ~ Design & Configuration of Office and Mission Environments ~ Escort Duties ~ Security/Mission Assurance Checks ~ Access Control Badge Encoding ~ Maintain NMCC AMAG System

7. Subject Matter Expert w/AutoCad Expertise ~ Provide Project Management of Renovation and Reconfiguration of Operations and Support Spaces ~ Build and Maintain AutoCAD drawings and other configuration data ~ Maintain & Operate MAXIMO Maintenance Software ~ Maintain & Operate Metasys System ~ Emergency Response to Mission System Outages ~ Design & Configuration of Office and Mission Environments ~ Escort Duties ~ Security/Mission Assurance Checks ~ Access Control Badge Encoding

10. Project Manager ~ Provide program and project support ~ Processing of requirements (e.g., projects, routine requirements) ~ Adhere to standard project management best practices, such as the current PMBOK Guide ~ Record requirement information in the Government-approved tracking system

8. Technician
9. Technician~ Security/Mission Assurance Checks

~ Maintain NMCC AMAG System ~ Access Control Badge Encoding ~ Escort Duties ~ Security/Mission Assurance Checks

FTEs OY1

FA701419RA022
PECP Proposal for - NMCC ATTACHMENT 2
FTEs Total15 Dec 2020 - 14 Dec 2021
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0$ 100,000.00$ 32,000.00$ (2,000.00)$ 131,920.00
Senior Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert
w/AutoCad Expertise$ - 0
Project Manager
Technician$ - 0
Technician$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTEs OY2

FA701419RA022
PECP Proposal for - NMCC ATTACHMENT 2
FTEs Total15 Dec 2021 - 14 Dec 2022
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0$ 100,000.00$ 32,000.00$ (2,000.00)$ 131,920.00
Senior Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert
w/AutoCad Expertise$ - 0
Project Manager
Technician$ - 0
Technician$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTEs OY3

FA701419RA022
PECP Proposal for - ATTACHMENT 2
FTEs Total15 Dec 2022 - 14 Dec 2023
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0$ 100,000.00$ 32,000.00$ (2,000.00)$ 131,920.00
Senior Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert
w/AutoCad Expertise$ - 0
Project Manager
Technician$ - 0
Technician$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

FTEs OY4

FA701419RA022
PECP Proposal for - NMCC ATTACHMENT 2
FTEs Total15 Dec 2023 - 14 Dec 2024
LABOR CATEGORY (Offeror's Proposed Labor Category)PWS Task Area and summary of functions or tasks associated with this LCATEst. HrsUnburdened Salary per LCAT ProposedFringe CostFFP Discount AppliedLCAT Cost
EXAMPLE: Subject Matter Expert IITask Area 3 of the PWS:1,920.0$ 100,000.00$ 32,000.00$ (2,000.00)$ 131,920.00
Senior Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Master Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert$ - 0
Journeyman Subject Matter Expert
w/AutoCad Expertise$ - 0
Project Manager
Technician$ - 0
Technician$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
$ - 0
Note: The Government does not need to see G&A, Overhead or Profit but an accurate fringe cost or percentage.
Each Offeror will determine the hours proposed but for planning purposes the Government is using 1920 hrs for 1 FTE

Total Proposal Price sheet

FA701419RA022
Total Proposal Price Sheet
Performance PeriodLaborMaterials
15 Dec 2019 - 14 Dec 2020$150,000.00Base
15 Dec 2020 - 14 Dec 2021$150,000.00OY1
15 Dec 2021 - 14 Dec 2022$150,000.00OY2
15 Dec 2022 - 14 Dec 2023$150,000.00OY3
15 Dec 2023 - 14 Dec 2024$150,000.00OY4
6 Month Extension$75,000.00-8
TOTAL

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