PASS Cost Template Updated.xlsx

XLSX spreadsheet 77 KB Posted

Attached to
Program And Staff Support (PASS) Federal contract opportunity
Solicitation number
W911SR25RA002
Issued by
Department of the Army Materiel Command Army Contracting Command Aberdeen Proving Ground

About this file

This file is a cost template for the Program and Staff Support (PASS) Indefinite Delivery/Indefinite Quantity (IDIQ) contract solicitation W911SR25RA002. The template details 35 distinct labor categories with specific job descriptions, minimum education requirements, and experience levels, ranging from Contract Program Manager to Travel and Timekeeping Clerk. Labor categories span multiple professional domains including administrative services, communications, safety, technology transfer, financial analysis, operations, and risk management.

The cost template includes sections for calculating Cost-Plus-Fixed-Fee (CPFF) and Firm Fixed Price (FFP) labor rates across a five-year contract period, with provisions for fringe rates, overhead, and escalation. The contract is for the U.S. Army Combat Capabilities Development Command Chemical Biological Center (DEVCOM CBC), supporting mission areas such as chemical and biological detection, information systems technology, protection and decontamination sciences, chemical and biological sciences, toxicology, and related technical services. The template allows contractors to input proposed rates, markup percentages, and calculate total evaluated pricing, with a maximum fixed fee of 5% of estimated labor costs.

View the file

Other files for this federal contract opportunity

Other files attached to Program And Staff Support (PASS), newest first.
File Type Posted
Solicitation Amendment - W911SR25RA002 - 0003.pdf PDF
Solicitation Questions and Answers V2.xlsx XLSX spreadsheet
Solicitation Questions and Answers.xlsx XLSX spreadsheet
PASS Evaluation Task PWS Updated.docx DOCX document
Solicitation Amendment - W911SR25RA002.pdf PDF
PASS Base IDIQ PWS.docx DOCX document
Wage Determinations Maryland Harford County Revision No 30.pdf PDF
PASS GFP List.xlsx XLSX spreadsheet
PASS Draft Solicitation Question Spreadsheet_Government Responses.xlsx XLSX spreadsheet
Solicitation - W911SR25RA002.pdf PDF
Solicitation Question Template.xlsx XLSX spreadsheet
PASS Cost Template.xlsx XLSX spreadsheet
Solicitation - W911SR25RA002.pdf PDF
PASS Base IDIQ CDRL.docx DOCX document
PASS Evaluation Task PWS.docx DOCX document
PASS Base IDIQ PWS.docx DOCX document
PASS Evaluation Task Order CDRL.docx DOCX document
PASS DD 254 Draft.pdf PDF
Wage Determinations Maryland Harford County.pdf PDF
Show all 19

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

IDIQ LCAT Definitions

Labor CategoryLabor Category DescriptionMinimum Education and Experience
Contract Program Manager11-3012 Administrative Services Managers. Plan, direct, or coordinate one or more administrative services of an organization.Bachelor's Degree with 10 years experience.
Contract Site Supervisor43-1011. First-Line Supervisors of Office and Administrative Support Workers. Directly supervise and coordinate the activities of clerical and administrative support workers.Bachelor's Degree with 5 years experience.
Contract Administrative Specialist43-6011 Executive Secretaries and Executive Administrative Assistants. Provide high-level administrative support by conducting research, preparing statistical reports, and handling information requests, as well as performing routine administrative functions such as preparing correspondence, receiving visitors, arranging conference calls, and scheduling meetings. May also train and supervise lower-level clerical staff.High School Diploma with 1-3 years experience.
Contract Accounting Technician43-3031 Bookkeeping, Accounting, and Auditing Clerks. Compute, classify, and record numerical data to keep financial records complete. Perform any combination of routine calculating, posting, and verifying duties to obtain primary financial data for use in maintaining accounting records. May also check the accuracy of figures, calculations, and postings pertaining to business transactions recorded by other workers.High School Diploma with 1-3 years experience.
Senior Communication Specialist27-3031. Public Relations Specialists. Promote or create an intended public image for individuals, groups, or organizations. May write or select material for release to various communications media. May specialize in using social media.Bachelor's Degree with at least 7 years experience.
Communication Specialist27-3031. Public Relations Specialists. Promote or create an intended public image for individuals, groups, or organizations. May write or select material for release to various communications media. May specialize in using social media.Bachelor's Degree with at least 5 years experience.
Photographer/Videographer27-4021 Photographers. Photograph people, landscapes, merchandise, or other subjects. May use lighting equipment to enhance a subject's appearance. May use editing software to produce finished images and prints. Includes commercial and industrial photographers, scientific photographers, and photojournalists. 27-4032 Film and Video Editors. Edit moving images on film, video, or other media. May work with a producer or director to organize images for final production. May edit or synchronize soundtracks with images. 27-4031 Camera Operators, Television, Video, and Film. Operate television, video, or film camera to record images or scenes for television, video, or film productions.Associate's Degree with at least 3 years experience.
Graphic Designer27-1024. Graphic Designers. Design or create graphics to meet specific commercial or promotional needs, such as packaging, displays, or logos. May use a variety of mediums to achieve artistic or decorative effects.Bachelor's Degree with at least 5 years experience.
Congressional Affairs Advisor11-2032. Public Relations Managers. Plan, direct, or coordinate activities designed to create or maintain a favorable public image or raise issue awareness for their organization or client.Bachelor's Degree with at least 5 years experience.
Senior Technology Transfer Specialist13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 10 years experience.
Junior Technology Transfer Specialist13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 3 years experience.
Senior Business Development Analyst13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 7 years experience.
Acquisition Specialist - Midlevel13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 5 years experience.
Acquisition specialist - Senior Level13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 7 years experience.
Cost Analyst - Junior Level13-1051. Cost Estimators. Prepare cost estimates for product manufacturing, construction projects, or services to aid management in bidding on or determining price of product or service. May specialize according to particular service performed or type of product manufactured.Bachelor's Degree.
Cost Analyst - Senior Level13-1051. Cost Estimators. Prepare cost estimates for product manufacturing, construction projects, or services to aid management in bidding on or determining price of product or service. May specialize according to particular service performed or type of product manufactured.Bachelor's Degree with at least 7 years experience.
Decision Analysis Analyst - Junior Level13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree.
Decision Analysis Analyst- Senior Level13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 7 years experience.
Financial Analyst - Junior Level13-2051. Financial and Investment Analysts. Conduct quantitative analyses of information involving investment programs or financial data of public or private institutions, including valuation of businesses.Bachelor's Degree with at least 3 years experience.
Financial Analyst - Senior Level13-2051. Financial and Investment Analysts. Conduct quantitative analyses of information involving investment programs or financial data of public or private institutions, including valuation of businesses.Bachelor's Degree with at least 7 years experience.
GFEBS Senior Consultant13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 10 years experience.
Program Analyst - Junior Level13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 3 years experience.
Program Analyst - Senior Level13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 7 years experience.
Emergency Coordinator (Emergency Management)11-9161 Emergency Management Directors. Plan and direct disaster response or crisis management activities, provide disaster preparedness training, and prepare emergency plans and procedures for natural (e.g., hurricanes, floods, earthquakes), wartime, or technological (e.g., nuclear power plant emergencies or hazardous materials spills) disasters or hostage situations.Bachelor's Degree with at least 5 years experience.
Risk Communications Specialist (Safety and Risk Management Support)13-1111. Management Analysts. Conduct organizational studies and evaluations, design systems and procedures, conduct work simplification and measurement studies, and prepare operations and procedures manuals to assist management in operating more efficiently and effectively. Includes program analysts and management consultants.Bachelor's Degree with at least 5 years experience.
Administrative Specialist (Safety and Risk Management Support)43-6011 Executive Secretaries and Executive Administrative Assistants. Provide high-level administrative support by conducting research, preparing statistical reports, and handling information requests, as well as performing routine administrative functions such as preparing correspondence, receiving visitors, arranging conference calls, and scheduling meetings. May also train and supervise lower-level clerical staff.High School Diploma with 1-3 years experience.
SOP Coordinator (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.High School Diploma with 1-3 years experience.
Radiation Specialist (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.Bachelor's Degree with at least 7 years experience.
Engineering Controls Certification Specialist (Hazardous Work Protection)17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.High school diploma with at least 5 years experience.
Safety Specialist (Hazardous Work Protection)17-2111. Health and Safety Engineers, Except Mining Safety Engineers and Inspectors. Promote worksite or product safety by applying knowledge of industrial processes, mechanics, chemistry, psychology, and industrial health and safety laws. Includes industrial product safety engineers.Bachelor's Degree with at least 2 years experience.
Senior Operations Analyst13-1199. Business Operations Specialists, All Other. All business operations specialists not listed separately.Bachelor's Degree with at least 7 years experience.
Operations Specialist13-1199. Business Operations Specialists, All Other. All business operations specialists not listed separately.Bachelor's Degree with at least 5 years experience.
Security Specialist13-1199. Business Operations Specialists, All Other. All business operations specialists not listed separately.Bachelor's Degree with at least 3 years experience.
Technical Writer27-3042. Technical Writers. Write technical materials, such as equipment manuals, appendices, or operating and maintenance instructions. May assist in layout work.Associate's Degree with at least 3 years experience.
Travel and Timekeeping Clerk43-3031. Bookkeeping, Accounting, and Auditing Clerks. Compute, classify, and record numerical data to keep financial records complete. Perform any combination of routine calculating, posting, and verifying duties to obtain primary financial data for use in maintaining accounting records. May also check the accuracy of figures, calculations, and postings pertaining to business transactions recorded by other workers.High School Diploma with 1-3 years experience.

Y1 CPFF Labor

Company NameCAGELCAT_TitleDirect RateFringe RateFringeOverhead RateOverheadSubcontractor RateSubcontractor Handling RateSubcontractor HandlingG&A RateG&AFCCOM if ApplicableProposed_Cost_per_HourEvaluation_Weight
Contract Program Manager<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Contract Site Supervisor<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Contract Administrative Specialist<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.3%
Contract Accounting Technician<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Senior Communication Specialist<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Communication Specialist<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Photographer/Videographer<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Graphic Designer<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Congressional Affairs Advisor<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Senior Technology Transfer Specialist<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Junior Technology Transfer Specialist<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Senior Business Development Analyst<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Acquisition Specialist - Midlevel<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.4%
Acquisition specialist - Senior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.4%
Cost Analyst - Junior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.4%
Cost Analyst - Senior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.4%
Decision Analysis Analyst - Junior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Decision Analysis Analyst- Senior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Financial Analyst - Junior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Financial Analyst - Senior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
GFEBS Senior Consultant<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Program Analyst - Junior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.4%
Program Analyst - Senior Level<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.006.6%
Emergency Coordinator (Emergency Management)<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Risk Communications Specialist (Safety and Risk Management Support)<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Administrative Specialist (Safety and Risk Management Support)<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
SOP Coordinator (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Radiation Specialist (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.000.5%
Engineering Controls Certification Specialist (Hazardous Work Protection)<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.3%
Explosives Safety Specialist (Hazardous Work Protection)<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Senior Operations Analyst<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Operations Specialist<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.4%
Security Specialist<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%
Technical Writer<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.004.4%
Travel and Timekeeping Clerk<Rate><Rate><Formula><Rate><Formula><Rate><Rate><Formula><Rate><Formula><Formula>$0.002.2%

FFP Labor

Company NameCAGELCAT_Title↓Optional↓ENTER PROPOSED ESCALATION HERE -->
Estimated CostMarkup PercentageYear 1 FFP_per_Hour

Gilson, Benjamin C Mr CIV: Govt:

This column contains formulas to calculate Firm Fixed Prices per hour based on estimated costs and a markup. Using these formulas is not required, and offerors may use different formulas or paste hard numbers (rounded to 2 decimal places) instead.

Year 2 FFP per HourYear 3 FFP per HourYear 4 FFP per HourYear 5 FFP per HourFFP_Evaluation_Weight
Contract Program Manager$0.00$0.00$0.00$0.00$0.00$0.002.2%
Contract Site Supervisor$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Contract Administrative Specialist$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.3%
Contract Accounting Technician$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Senior Communication Specialist$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Communication Specialist$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Photographer/Videographer$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Graphic Designer$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Congressional Affairs Advisor$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Senior Technology Transfer Specialist$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Junior Technology Transfer Specialist$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Senior Business Development Analyst$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Acquisition Specialist - Midlevel$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.4%
Acquisition specialist - Senior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.4%
Cost Analyst - Junior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.4%
Cost Analyst - Senior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.4%
Decision Analysis Analyst - Junior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Decision Analysis Analyst- Senior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Financial Analyst - Junior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Financial Analyst - Senior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
GFEBS Senior Consultant$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Program Analyst - Junior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.4%
Program Analyst - Senior Level$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!6.6%
Emergency Coordinator (Emergency Management)$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Risk Communications Specialist (Safety and Risk Management Support)$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Administrative Specialist (Safety and Risk Management Support)$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
SOP Coordinator (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Radiation Specialist (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!0.5%
Engineering Controls Certification Specialist (Hazardous Work Protection)$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.3%
Explosives Safety Specialist (Hazardous Work Protection)$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Senior Operations Analyst$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Operations Specialist$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.4%
Security Specialist$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%
Technical Writer$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!4.4%
Travel and Timekeeping Clerk$0.00ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!2.2%

Prop. Non-Labor

RateTotal
$1 of Direct Materials$1.00
Material Handling<Rate><Formula>
Subtotal, Materials$1.00
G&A on Materials<Rate><Formula>
FCCOM on Materials<Rate><Formula>
Prop_Mat_Mult$1.00
$1 of Travel$1.00
G&A on Travel<Rate><Formula>
FCCOM on Travel<Rate><Formula>
Prop_Travel_Mult$1.00
$1 of ODCs$1.00
G&A on ODCs<Rate><Formula>
FCCOM on ODCs<Rate><Formula>
Prop_ODC_Mult$1.00
***Add/Remove Rows as needed for accurate multiplier calculations

IDIQ Eval Price

Proposed Fixed Fee (% of Estimated CPFF Labor Cost):←Must be 5% or less.
Escalation4.0%←Do not change. Will be 4% for all Offerors (excludes FFP labor).
Labor (CPFF)Labor (FFP)Materials (Cost)Travel (Cost)ODCs (Cost)Total
Weighted Avg. Total Cost per HourEvaluation HoursProposed Evaluation Labor CostProposed Evaluation Fixed FeeProposed Evaluation CPFFWeighted Avg. FFP per HourEvaluation HoursProposed Evaluation FFPPlug NumberMaterial MultiplierEvaluation PricePlug NumberTravel MultiplierEvaluation PricePlug NumberODC MultiplierEvaluation PriceEvaluation Price
Year 1$0.0020,000$0$0$0ERROR:#VALUE!55,000ERROR:#VALUE!$15,0001.000$15,000$100,0001.000$100,000$15,0001.000$15,000ERROR:#VALUE!
Year 2$0.0020,000$0$0$0ERROR:#VALUE!55,000ERROR:#VALUE!$15,7501.000$15,750$105,0001.000$105,000$15,7501.000$15,750ERROR:#VALUE!
Year 3$0.0020,000$0$0$0ERROR:#VALUE!55,000ERROR:#VALUE!$16,5381.000$16,538$110,2501.000$110,250$16,5381.000$16,538ERROR:#VALUE!
Year 4$0.0020,000$0$0$0ERROR:#VALUE!55,000ERROR:#VALUE!$17,3641.000$17,364$115,7631.000$115,763$17,3641.000$17,364ERROR:#VALUE!
Year 5 (6 months)$0.0010,000$0$0$0ERROR:#VALUE!27,500ERROR:#VALUE!$9,1161.000$9,116$60,7751.000$60,775$9,1161.000$9,116ERROR:#VALUE!
Proposed Evaluation Price$0ERROR:#VALUE!$73,768$491,788$73,768ERROR:#VALUE!

Task Order Hours Labor Category Title Base Period of Performance Misc. Contract Management and Administration Misc. Employee Training & Ancillary Compliance (e.g. obtain CAC) 3.2.2 Strategic Planning, Communications and Business Development Services 3.2.3 Financial Management Services 3.3.3 Safety and Risk Management Services 3.3.5 Environmental Activities (Waste/Materiel Disposal and Handling) Services 3.3.6 Hazardous Work Protection Services 3.3.8 Safety, Surety, Health, Chemical Security, and Environmental Planning, Audits, and Inspections Services. Each Option Year Misc. Contract Management and Administration Misc. Employee Training & Ancillary Compliance (e.g. obtain CAC) 3.2.2 Strategic Planning, Communications and Business Development Services 3.2.3 Financial Management Services 3.3.3 Safety and Risk Management Services 3.3.5 Environmental Activities (Waste/Materiel Disposal and Handling) Services 3.3.6 Hazardous Work Protection Services 3.3.8 Safety, Surety, Health, Chemical Security, and Environmental Planning, Audits, and Inspections Services.

Task Order Cost

Labor Category
(Add Rows and extend formulas as Needed)Base PeriodOption Year 1Option Year 2Option Year 3Option Year 4Total
HoursRateTotalHoursRateTotalHoursRateTotalHoursRateTotalHoursRateTotal
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Estimated Labor Cost$0$0$0$0$0
Fixed Fee (Equals IDIQ Fee Percentage)0.0%$00.0%$00.0%$00.0%$00.0%$0
Labor, CPFF$0$0$0$0$0
Gov't PlugMultiplierGov't PlugMultiplierGov't PlugMultiplierGov't PlugMultiplierGov't PlugMultiplier
Materials$01.000$0$01.000$0$01.000$0$01.000$0$01.000$0
Travel$25,0001.000$25,000$26,0001.000$26,000$27,0401.000$27,040$28,1221.000$28,122$29,2461.000$29,246$135,408
ODCs$3,0001.000$3,000$3,1201.000$3,120$3,2451.000$3,245$3,3751.000$3,375$3,5101.000$3,510$16,249
Materials, Travel & ODCs, Cost (no-fee)$28,000$29,120$30,285$31,496$32,756$151,657

Task Order Total $28,000 $29,120 $30,285 $31,496 $32,756 $151,657

Task Order Labor Info Proposed Labor Categories for Task Order Employee Makup If "Current Workforce", add years with company;

if "Subcontracts", briefly describe B2B historical relationship with subcontractor (only once for each subcontractor)

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
**Prefills based on "Task Order Hours" tab. Feel free to copy above and paste as values instead so updates to "Task Order Hours" don't inadvertantly change this sheet.

Section B Attachment, CPFF

Year 1, Per Hour ValuesYear 2, Per Hour ValuesYear 3, Per Hour ValuesYear 4, Per Hour ValuesYear 5, Per Hour Values
Est. CostFixed FeeCPFFEst. CostFixed FeeCPFFEst. CostFixed FeeCPFFEst. CostFixed FeeCPFFEst. CostFixed FeeCPFF
Contract Program Manager$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Site Supervisor$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Administrative Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Contract Accounting Technician$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Communication Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Communication Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Photographer/Videographer$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Graphic Designer$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Congressional Affairs Advisor$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Technology Transfer Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Junior Technology Transfer Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Business Development Analyst$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Acquisition Specialist - Midlevel$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Acquisition specialist - Senior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Cost Analyst - Junior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Cost Analyst - Senior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Decision Analysis Analyst - Junior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Decision Analysis Analyst- Senior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Financial Analyst - Junior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Financial Analyst - Senior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
GFEBS Senior Consultant$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Program Analyst - Junior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Program Analyst - Senior Level$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Emergency Coordinator (Emergency Management)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Risk Communications Specialist (Safety and Risk Management Support)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Administrative Specialist (Safety and Risk Management Support)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
SOP Coordinator (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Radiation Specialist (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Engineering Controls Certification Specialist (Hazardous Work Protection)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Explosives Safety Specialist (Hazardous Work Protection)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Senior Operations Analyst$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Operations Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Security Specialist$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Technical Writer$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Travel and Timekeeping Clerk$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00

Section B Attachment, FFP

FFP Per Hour
Year 1Year 2Year 3Year 4Year 5
Contract Program Manager$0.00$0.00$0.00$0.00$0.00
Contract Site SupervisorERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Contract Administrative SpecialistERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Contract Accounting TechnicianERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Senior Communication SpecialistERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Communication SpecialistERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Photographer/VideographerERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Graphic DesignerERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Congressional Affairs AdvisorERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Senior Technology Transfer SpecialistERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Junior Technology Transfer SpecialistERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Senior Business Development AnalystERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Acquisition Specialist - MidlevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Acquisition specialist - Senior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Cost Analyst - Junior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Cost Analyst - Senior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Decision Analysis Analyst - Junior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Decision Analysis Analyst- Senior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Financial Analyst - Junior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Financial Analyst - Senior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
GFEBS Senior ConsultantERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Program Analyst - Junior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Program Analyst - Senior LevelERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Emergency Coordinator (Emergency Management)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Risk Communications Specialist (Safety and Risk Management Support)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Administrative Specialist (Safety and Risk Management Support)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
SOP Coordinator (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Radiation Specialist (Safety, Surety, Health, Security, and Environmental Planning, Audits, and Inspections)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Engineering Controls Certification Specialist (Hazardous Work Protection)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Explosives Safety Specialist (Hazardous Work Protection)ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Senior Operations AnalystERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Operations SpecialistERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Security SpecialistERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Technical WriterERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!
Travel and Timekeeping ClerkERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!ERROR:#VALUE!

lists

Employee_Makeup
Current Workforce
Subcontracts
New Hires
Approx. 50/50 mix of Current Workforce and Subcontracts
Approx. 50/50 mix of Current Workforce and New Hires
Approx. 50/50 mix of Subcontracts and New Hires

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