Attachment 3 Pricing Spreadsheet.xlsx

XLSX spreadsheet 83 KB Posted

Attached to
Security Services
Solicitation number
89233120RNA000078
Issued by

About this file

This document contains a pricing template and labor categories crosswalk for a federal security services contract. The scope of work includes professional security services such as security program planning, physical security, protective force, alarm monitoring and response, security management and supervision, quality assurance, access control, security officer and visitor control specialist training, security patrols, implementing and maintaining appropriate staffing for all positions, non-security emergency response, plans and procedures development and implementation, alarm monitoring station, monitoring and dispatch, visitor control and Homeland Security Presidential Directive 12 credential issuance and control, performance testing, report writing and other duties as required by DOE/NNSA orders and directives to implement an effective security program. Offerors must propose fully burdened hourly rates for labor categories aligned with the collective bargaining agreement and associated hours to satisfy the performance work statement requirements. The contract will have a five-year period of performance from December 2020 to November 2025 with an optional six-month extension and is issued by the Department of Energy National Nuclear Security Administration.

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

SUMMARY

SUMMARY OF PROPOSED COSTS
Contract # - TBD
Company Name:

COST ELEMENT SUMMARY OF ALL COSTS

CLIN Year 1 Year 2 Year 3 Year 4 Year 5 Option to Extend

CLIN 0001 - Labor (T&M)$ -$ -$ -$ -$ -$ -
CLIN 0002 - ODCs/Materials (T&M)$ 18,000$ 18,000$ 18,000$ 18,000$ 18,000$ 9,000

TOTAL PROPOSED COSTS $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 9,000

5 YR TOTAL $ 90,000

Labor Rate Pricing

National Nuclear Security Administration
Contract # - TBD
Company Name:
Time & Material
The following tables are examples of the required cost proposal format, but may be revised as necessary to be consistent with your establishing accounting and estimating systems.
For pricing purposes, assume a contract start date of December 1, 2020. The period of performance is 5 years from contract award. Propose all costs in accordance with each
contract fiscal year (CFY) as shown below. If composite direct and/or indirect rates are used due to differences in fiscal periods, then revise the templates to show how the
composite CFY rates are developed. Keep all spreadsheet formulas and cell references intact. Offerors are responsible for the accuracy of data throughout this Excel spreadsheet.
Additional supporting cost information may be requested if necessary to determine cost/price reasonableness.
INSTRUCTIONS - LABOR RATES
1. Provide a complete breakdown by cost element for each proposed labor rate (i.e., direct labor, O/H, G&A, profit and taxes). Show how the indirect rates and profit are applied to the base
labor rates to arrive at the fixed fully burdened hourly rates. For each cost element, provide a narrative explanation describing your estimating methodology and basis for the proposed costs.
2. Labor Rates: Identify base labor rates (unburdened) for each labor category and the source of the rates (e.g., actual rates for named individuals, FPRA, average category rates, etc.).
If the labor rates are escalated, separately identify the escalation rate and show how escalation is applied to the base rates in order to arrive at the proposed rates.
3. Indirect Rates: Show the proposed indirect rates by CFY for all applicable burdens. Identify the application bases and the major cost elements included in each indirect rate pool. Provide
a narrative explanation regarding the basis of estimate for the proposed rates (i.e., FPRA, billing rates, historical rates, budget estimates, DCAA audited rates, etc.).
Change formulas below as necessary to adhere to your established accounting and estimating practices.

4. Profit: Show the proposed profit applied to each labor category. Although not required, the contractor is encouraged to provide substantiation for the proposed profit.

5. New Mexico Gross Receipts Tax (NMGRT): This represents the applicable NMGRT for the NM location in which services are rendered.

6. Fixed Rate: This represents the offered fixed price for each fully burdened hourly labor rate. Agreed-upon rates will be incorporated into the contract.

7. Fiscal Years: Please provide fully burdened labor rates for all five (5) years.

8. The Contractor shall provide a price quote for the Option to Extend Services clause under Tab 3. 52.217-8 Option to Extend Services. (NOV 1999) - The Government may require continued performance of any services within the limits and at the rates specified in the contract. These rates may be adjusted only as a result of revisions to prevailing labor rates provided by the Secretary of Labor. The option provision may be exercised more than once, but the total extension of performance hereunder shall not exceed 6 months. The Contracting Officer may exercise the option by written notice to the Contractor within 30 days of contract expiration. The option to extend services for the 6 month period following year five (5) will be utilized for evaluation purposes, but will not be included in the contract award ceiling.

9. The Offeror must specify that it has thoroughly reviewed the current Collective Bargaining Agreement (CBA) and/or applicable Wage Determination(s) (WD), and the proposed rates for covered employees and include at least the minimum requirements to include starting pay, wages, health and welfare, qualification pay, bonus/incentive allowances and any/all other requirements for compliance.

Please add another Excel tab(s) to fully narrate basis and methodology as necessary.
*Enter all information as required in the yellow highlighted cells for each contract period.
**The below proposed fully burdened labor rates will link directly into the "T&M Rates" and "Labor Hours and Summary Dollars" sheet.
*** Categories marked with (Sub) are subcontractor labor categories, Base Rate is the subcontractor's fully burdened rate.
Non-SCA EmployeesBase Labor (Unburdened)Year 1 - Indirect RatesYear 2 - Indirect RatesYear 3 - Indirect RatesYear 4 - Indirect RatesYear 5 - Indirect RatesYear 6 - Indirect Rates - Option to Extend - 6 Months
For Non-SCA Employees - OfferorsEscalation0.00%0.00%0.00%0.00%0.00%0.00%
need only to provide fully burdenedFringe0.00%0.00%0.00%0.00%0.00%0.00%
labor rates, however, thisOH0.00%0.00%0.00%0.00%0.00%0.00%
spreadsheet has been providedG&A0.00%0.00%0.00%0.00%0.00%0.00%
to assist offerors in rate buildup ifProfit0.00%0.00%0.00%0.00%0.00%0.00%
necessary.NMGRT0.00%0.00%0.00%0.00%0.00%0.00%
Labor Categories (non-SCA) - See Labor Crosswalk TabBase Rate - Year 1Year 1 - Fully Burdened RateYear 2 - Fully Burdened RateYear 3 - Fully Burdened RateYear 4 - Fully Burdened RateYear 5 - Fully Burdened RateYear 6 - Fully Burdened Rate
Project Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CBA/SCA EmployeesBase Rate - Year 1Year 1 - Fully Burdened RateYear 2 - Fully Burdened RateYear 3 - Fully Burdened RateYear 4 - Fully Burdened RateYear 5 - Fully Burdened RateYear 6 - Indirect Rates - Option to Extend - 6 Months
Escalation0.00%0.00%0.00%0.00%0.00%0.00%
Either Fringe, H&W, or both can beFringe0.00%0.00%0.00%0.00%0.00%0.00%
used to illustrate proposed amountsH&W ($)$0.00$0.00$0.00$0.00$0.00$0.00
OH0.00%0.00%0.00%0.00%0.00%0.00%
G&A0.00%0.00%0.00%0.00%0.00%0.00%
Profit0.00%0.00%0.00%0.00%0.00%0.00%
NMGRT0.00%0.00%0.00%0.00%0.00%0.00%
Labor Categories (CBA/SCA) - See Labor Crosswalk TabBase Rate - Year 1Year 1 - Fully Burdened RateYear 2 - Fully Burdened RateYear 3 - Fully Burdened RateYear 4 - Fully Burdened RateYear 5 - Fully Burdened RateYear 6 - Fully Burdened Rate
Training Manager / Trainer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Shift Supervisor / Lieutenant$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Security Guard II / Security Officer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Alarm Monitor II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Badge Specialist / Badging Officer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
1. All offered hourly prices should be fully burdened.

&"Arial,Regular"&9Chenenage Professional & Technical Services, LLC Proposal in Response to Solicitation Depart of Energy (DOE), National Nuclear Security Administration (NNSA)

RFP # DE-NA0003754

September 15, 2017

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

T&M Rates

National Nuclear Security Administration
Contract # - TBD
Company Name:
Time & Material
The following tables are the proposed labor rates for Year 1 through Year 5 (including the Option to Extend 6 months), applicable to this contract.
CLIN 0001 - Labor T&M rates
T&M Rates (Fully Burdened)Year 1 - T&M RatesYear 2 - T&M RatesYear 3 - T&M RatesYear 4 - T&M RatesYear - T&M RatesOption to Extend - 6 month extension T&M Rates
Non-SCA Employees
Project Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 2$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 3$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 4$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 5$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CBA/SCA Employees
Training Manager / Trainer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Shift Supervisor / Lieutenant$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Security Guard II / Security Officer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Alarm Monitor II$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Badge Specialist / Badging Officer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 6$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Labor Category 7$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

&"Arial,Regular"&9Chenenage Professional & Technical Services, LLC Proposal in Response to Solicitation

National Nuclear Security Administration (NNSA)

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

Labor Hours and Summary Dollars

PRICE QUOTE INSTRUCTIONS- LABOR HOUR
Enter all information as required in the yellow highlighted cells for each contract order period. If applicable.
Keep formulas and links intact and DO NOT protect cells. You may add supporting information or insert rows or columns if required.
Column (1): This column dilineates between non-SCA/CBA employees and CBA employees proposed under this contract.
Column (2): Represents the labor categories exactly as filled out under Labor Rate Pricing. Do not combine different labor categories!
Column (3): Represents the Labor Rate as established under T&M Rates Proposed. Do not use composite or averaged rates!
Column (4): Represents the total Government estimated labor hours requirement for the effort. See Labor Crosswalk
Column (5): This column shows the extended price quoted for each labor category.
A separate tab for determining the offeror's Direct Productive Labor Hour (DPLH) per each Full Time Equivalent (FTE) has been provided.
Continued Columns - These columns repeat columns 3 through 5 for performance Years 2 through 5 and through the 6 month option period (TBD by the Contractor)
Company Name:
Contract # - TBD
CLIN NUMBER:
PERIOD OF PERFORMANCE (POP): 12/01/2020 - 11/30/2025POP: 6 Month Extension
(1) Contract Areas - CLIN 0001(2) Contract Labor Categories(3) Labor Rate Year 1(4) Hours Year 1(5) Price Year 1Labor Rate Year 2Hours - Year 2Price Year 2Labor Rate Year 3Hours - Year 3Price Year 3Labor Rate Year 4Hours - Year 4Price Year 4Labor Rate Year 5Hours - Year 5Price Year 5Labor Rate - 6 Month Option PeriodHours - Option PeriodPrice Option Period
Non-SCA Employees
Project Manager$ - 02,080$ -$ - 02,080$ -$ - 02,080$ -$ - 02,080$ -$ - 02,080$ -$ - 01,040$ -
Labor Category 2$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -
Labor Category 3$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -
Labor Category 4$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -
Labor Category 5$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -
CBA/SCA Employees
Training Manager / Trainer$ - 02,080$ -$ - 02,080$ -$ - 02,080$ -$ - 02,080$ -$ - 02,080$ -$ - 01,040$ -
Shift Supervisor / Lieutenant$ - 03,120$ -$ - 03,120$ -$ - 03,120$ -$ - 03,120$ -$ - 03,120$ -$ - 01,560$ -
Security Guard II / Security Officer$ - 023,712$ -$ - 023,712$ -$ - 023,712$ -$ - 023,712$ -$ - 023,712$ -$ - 011,856$ -
Alarm Monitor II$ - 017,472$ -$ - 017,472$ -$ - 017,472$ -$ - 017,472$ -$ - 017,472$ -$ - 08,736$ -
Badge Specialist / Badging Officer$ - 06,240$ -$ - 06,240$ -$ - 06,240$ -$ - 06,240$ -$ - 06,240$ -$ - 03,120$ -
Labor Category 6$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -
Labor Category 7$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -$ - 00$ -
Non-SCA Employeessub Totals2,080$ -2,080$ -2,080$ -2,080$ -2,080$ -1,040$ -
CBA/SCA Employeessub Totals52,624$ -52,624$ -52,624$ -52,624$ -52,624$ -26,312$ -

TOTAL LABOR HOURS & PRICE - CLIN's 0001, 0003, 0005, 0007 & 0009 54,704 $ - 54,704 $ - 54,704 $ - 54,704 $ - 54,704 $ - 27,352 $ -

Materials/ODCs CLIN's 0002, 0004, 0006, 0008 & 0010 - Proposed (Baselined) $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 9,000

TOTALS BY YEAR $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 18,000 $ 9,000

Grand Total - Excluding 6 Month Option to Extend273,520.0$ 90,000*See Note 10 below
HoursDollars
NOTES:
1. PWS = Performance Work Statement
2. DPLH = Direct Productive Labor Hours. Direct Productive Labor Hours are defined as actual direct labor hours exclusive of vacation, holiday, sick leave and other absences.
DPLH Calculator Tab is included if needed to determine hours per FTE
3. FTE = Full-Time Equivalent. The Government estimates 1 FTE = 1860 per year under this quotation as it relates to PWS Labor
The Government will not dictate requirements in hours under Labor, the contractor should propose labor consistent with their standard business and estimating practices as it relates to DPLH.
4. ODC/Material CLIN ceiling amount will be established based on negotiated amounts and shall be included as part of the total price under this contract.
5. Travel amounts are Not to Exceed (NTE) amounts as determined by the Government and shall be included as part of the total price under this contract.
6. Keep all of your Formulas and Links Intact and DO NOT Protect Cells
7. Offerors are solely responsible for verifying the accuracy of the formulas and amounts contained in this spreadsheet
8. Grand Total consists of proposed hours and dollars for Year 1 through 5.
9. The six month option to extend period price will be proposed by the contractor and evaluated for reasonableness, but will not be included in the awarded contract price.

&"Arial,Regular"&9Chenenage Professional & Technical Services, LLC Proposal in Response to Solicitation

National Nuclear Security Administration (NNSA)

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

DPLH Calculator

Team Member 1:
DPLH CALCULATION for ONE FTE
Available Hours (52 wks x 40 hrs/wk)2,080
Less Vacation Leave0
Less Sick Leave0
Less Admin/Holiday/All Other Leave0
Team Member DPLH2,080
NOTES:
1. Fill out in accordance with your company's practice to determine DPLH
2. The leave types listed above outline typical leave provided by companies, but is not all inclusive. Change as needed to reflect your company's practices.

&"Arial,Regular"&9Chenenage Professional & Technical Services, LLC Proposal in Response to Solicitation Depart of Energy (DOE), National Nuclear Security Administration (NNSA)

&"Arial,Regular"&9Use or disclosure of the data contained on this sheet is subject to the restriction on the title page of this proposal.

ODCs Baselined Other Direct Costs (Baselined)

Total Yearly Costs
Year 1$ 18,000
Year 2$ 18,000
Year 3$ 18,000
Year 4$ 18,000
Year 5$ 18,000
Year 6 - Option to Extend$ 9,000
$ 99,000
Amounts determined above are baselined costs.
During performance, ODCs shall be reimbursed up to the NTE amounts
ODCs, which may include travel shall be reimbursed at actual costs only.

Labor Crosswalk

INSTRUCTIONS: The below are estimated Government Labor Categories and Hours
Vendors shall propose Labor Categories consistent with the CBA and associated hours in order to satisfy requirements under the PWS.
GOVERNMENT ESTIAMTED LABOR CATEGORIES - CLIN 1 (Labor)LABOR CATEGORIES Provide proposed CBA Labor Category
Project Manager
Training Manager / Trainer
Shift Supervisor / Lieutenant
Security Guard II / Security Officer
Alarm Monitor II
Badge Specialist / Badging Officer

*KEY PERSONNEL - CAN ONLY BE FILLED BY ONE INDIVIDUAL.

The Government estimates the following full-time equivalents for Labor for each year of the period of performance.
The below FTE count is the maximum anticipated amount of FTEs that may be needed at any one given time under this contract.
FTE counts can and will fluctuate based on programmatic needs as directed by the Contracting Officer. See the PWS for initial FTE needs.
Offerors are requested to propose to the equivalent CBA Labor Categories below as well as the Government Estimated Annual Equivalent Hours by category.
PWS Labor CategoriesGOVT. ESTIMATED FTEs - based on 1860 Hours per FTEGOVT. ESTIMATED ANNUAL EQUIVALENT HOURS
Project Manager1.122,080
Training Manager / Trainer1.122,080
Shift Supervisor / Lieutenant1.683,120
Security Guard II / Security Officer12.7523,712
Alarm Monitor II9.3917,472
Badge Specialist / Badging Officer3.356,240
Total29.4154704
NOTES:
1. FTE = Full-Time Equivalent. The Government estimates 1 FTE = 1860 hours per year under this quotation as it relates to PWS Labor

Labor Descriptions

GOVERNMENT LABOR CATEGORY COMPETENCIES:

Project Manager: Serves as the Contractor’s principal point of contact and the authorized interface with the Contracting Officer (CO) and/or the Contracting Officer’s Representative (COR). Is responsible for formulating and enforcing work standards; assigning schedules; reviewing work discrepancies; supervising personnel; all project management task performance; preparing, reviewing, and submitting required reports; communicating policies, purpose, and goals of the organization to personnel; and instituting quality assurance programs to insure the attainment of all project performance objectives. Must have a minimum of five years of DOE Protective Force (or comparable) experiences in management, supervision, and implementation or a protective forces contracts. Training Manager / Trainer: Serves as the assistant to the Project Manager and the Contractor’s point of contact and authorized interface with the CO and/or the COR in the absence of the Project Manager. Is responsible for assisting in formulating and enforcing work standards; assigning schedules; reviewing work discrepancies; supervising personnel; all project management task performance; preparing, reviewing, and submitting required reports; communicating policies, purpose, and goals of the organization to personnel; developing task analyses, training plans, and course material; and providing initial, annual, and ancillary training to personnel. Must have a minimum of three years of DOE Protective Force (or comparable management, supervision and training experience and current NTC PF Basic Security Officer Trainer certification or easily obtainable.

Security Guard II / Security Officer: Securitiy Officer - Patrols buildings, property, and/or stands post. Performs surveillance and alerts/reports to appropriate authority. Carries out instructions primarily oriented toward insuring that emergencies and security violations are readily discovered and reported to appropriate authority. Intervenes directly only in situations which require minimal action to safeguard property or persons. Shift Supervisor / Lieutenant: Responsible for execution of operational functions of site security program. Provides oversight to security operations and establishes, promotes, and maintains site security and property protection programs in compliance with directives and policies. Directs activities of personnel in adhering to security measures to comply with federal regulations. Inspects security guard uniforms and appearance for compliance with established standards. Inspects security posts, provides direction and guidance to personnel on shift and reviews reports for accuracy and completeness. Directs security personnel during emergencies and incidents. Provides relief to personnel on shift on a temporary basis in an emergency situation. Responsible for day-to day oversight of property to include government furnished equipment, keys, controlled government forms, etc.

Badge Specialist / Badge Officer: Functions as administrative support for visitor center/badge office. Performs all administrative support functions required by the activity. Prepares reports and other published material; prepares visitor briefing material; establishes and maintains program files; operates and maintains computerized identification and badging programs and issues passes and badges as required at access control points. Alarm Monitor II: Monitors constantly and manually operate the security systems for possible intrusions; maintain radio contact with officers to monitor their safety. Dispatches security patrols to actual or suspected unauthorized entry to facilities; resets alarm as necessary. Maintains log of activity in legible, understandable manner. Reports malfunctions of equipment to proper authority.

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