BEAR Staffing Matrix - Attachment 4.xlsx

XLSX spreadsheet 30 KB Posted Dec 1, 2023

Attached to: Amendment 1 Simplified Acquisition Proposal Request (SAPR), Solicitation #FA445224R0001, Follow-On Basic Expeditionary Airfield Resources (BEAR) Technical Support.
Solicitation number: 4452
Issued by: Department of the Air Force Air Mobility Command

About this file

Written by GovTribe AI · Dec 21, 2023

This document contains a staffing matrix template and instructions for a contractor to complete for a federal contract opportunity. The staffing matrix templates are to be filled out for a base period and four option periods to provide technical support services to the Basic Expeditionary Airfield Resource program managed by the Air Force Air Mobility Command. Contractors are instructed to fill in company names, labor categories, and the number of hours per period that each category will work on eight tasks related to project management, technical evaluations, assessments, integration and testing, technical reviews, logistics support, resolving equipment deficiencies, and technical support.

View the file

Other files

File	Type	Posted
Updated BEAR Instructions to offeror and Basis of Award-Attachment1..pdf	PDF	Dec 15, 2023
BEAR Question and Answer Matrix.xlsx	XLSX spreadsheet	Dec 15, 2023
BEAR SAPR Cover letter (Updated 15 Dec 2023).pdf	PDF	Dec 15, 2023
BEAR SAPR Cover letter_Redacted.pdf	PDF	Dec 1, 2023
BEAR DD Form 254 - Attachment 8.pdf	PDF	Dec 1, 2023
BEAR Base Support Performance Work Statement - Attachment 2.pdf	PDF	Dec 1, 2023
BEAR Provisions and Clauses - Attachment 6 .pdf	PDF	Dec 1, 2023
BEAR CDRL 001-009 - Attachment 5.pdf	PDF	Dec 1, 2023
BEAR Question and Answer Matrix - Attachment 7.xlsx	XLSX spreadsheet	Dec 1, 2023
BEAR Pricing Worksheet - Attachement 3 .xlsx	XLSX spreadsheet	Dec 1, 2023
BEAR Instructions to offeror and Basis of Award- Attachment 1.pdf	PDF	Dec 1, 2023

Show all 11

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Base Period

Instructions for Contractor's

- Remove instructions in red when completing.

- Fill in / Complete all cells highlighted in blue.

(BEAR -Follow-on FA445224R0001) - Staffing Plan Matrix for Base Period
TASK/CLIN Labor Hours
Company (Prime/Sub-contractor)	(Insert Company Name and whether it is the Prime or Sub for each labor category)	i.e. ABC Corp (Prime)	i.e. Xyz Corp (Sub)	Total Hours per Task
Labor Categories	(Insert the labor categories planned to be used in this column. If needed, add additional columns)	i.e Office asssistant	i.e Sr analyst
Tasks/CLINS
Basic Expeditionary Airfield Resource (BEAR) Base Systems Support Flight (SSF) PWS Tasks 1 thru 8.	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)	i.e. 100	i.e. 50	i.e. 150
Task 1- Project Management	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Task 2 - Tehcnical Evaluation Reports	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Task 3 - Weekly Assesments	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Task 4 - Integration, Testing, and Implementation	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Task 5 - Technical Review	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Task 6 - Life Cycle Logistic Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Task 7 - Resolving Equipment Deficencies	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Task 8 - Technical Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)			(Insert total hours for this Task)
Total Hours - Task	(Insert here the total number of hours for the proposed labor category)			(Insert Total Hours for entire Base Period)

Option Period 1

- Remove instructions in red when completing.

- Fill in / Complete all cells highlighted in blue.

	(BEAR -Follow-on ) - Staffing Plan Matrix for Option Period 1
	TASK/CLIN Labor Hours
	Company (Prime/Sub-contractor)	(Insert Company Name and whether it is the Prime or Sub for each labor category)	i.e. ABC Corp (Prime)	i.e. Xyz Corp (Sub)		Total Hours per Task
	Labor Categories	(Insert the labor categories planned to be used in this column. If needed, add additional columns)	i.e Office asssistant	i.e Sr analyst
	Tasks/CLINS
	Basic Expeditionary Airfield Resource (BEAR) Base Systems Support Flight (SSF)
- PWS Tasks 1 thru 8.	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)	i.e. 100	i.e. 50		i.e. 150
	Task 1- Project Management	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 2 - Tehcnical Evaluation Reports	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 3 - Weekly Assesments	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 4 - Integration, Testing, and Implementation	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 5 - Technical Review	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 6 - Life Cycle Logistic Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 7 - Resolving Equipment Deficencies	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 8 - Technical Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Total Hours - Task	(Insert here the total number of hours for the proposed labor category)				(Insert Total Hours for entire Base Period)

Option Period 2

- Remove instructions in red when completing.

- Fill in / Complete all cells highlighted in blue.

	(BEAR -Follow-on ) - Staffing Plan Matrix for Option Period 2
	TASK/CLIN Labor Hours
	Company (Prime/Sub-contractor)	(Insert Company Name and whether it is the Prime or Sub for each labor category)	i.e. ABC Corp (Prime)	i.e. Xyz Corp (Sub)		Total Hours per Task
	Labor Categories	(Insert the labor categories planned to be used in this column. If needed, add additional columns)	i.e Office asssistant	i.e Sr analyst
	Tasks/CLINS
	Basic Expeditionary Airfield Resource (BEAR) Base Systems Support Flight (SSF)
- PWS Tasks 1 thru 8.	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)	i.e. 100	i.e. 50		i.e. 150
	Task 1- Project Management	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 2 - Tehcnical Evaluation Reports	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 3 - Weekly Assesments	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 4 - Integration, Testing, and Implementation	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 5 - Technical Review	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 6 - Life Cycle Logistic Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 7 - Resolving Equipment Deficencies	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 8 - Technical Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Total Hours - Task	(Insert here the total number of hours for the proposed labor category)				(Insert Total Hours for entire Base Period)

Option Period 3

Instructions for Schedule Contractor's

- Remove instructions in red when completing.

- Fill in / Complete all cells highlighted in blue.

	(BEAR Follow-on ) - Staffing Plan Matrix for Option Period 3
	TASK/CLIN Labor Hours
	Company (Prime/Sub-contractor)	(Insert Company Name and whether it is the Prime or Sub for each labor category)	i.e. ABC Corp (Prime)	i.e. Xyz Corp (Sub)		Total Hours per Task
	Labor Categories	(Insert the labor categories planned to be used in this column. If needed, add additional columns)	i.e Office asssistant	i.e Sr analyst
	Tasks/CLINS
	Basic Expeditionary Airfield Resource (BEAR) Base Systems Support Flight (SSF)
- PWS Tasks 1 thru 8.	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)	i.e. 100	i.e. 50		i.e. 150
	Task 1- Project Management	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 2 - Tehcnical Evaluation Reports	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 3 - Weekly Assesments	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 4 - Integration, Testing, and Implementation	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 5 - Technical Review	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 6 - Life Cycle Logistic Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 7 - Resolving Equipment Deficencies	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 8 - Technical Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Total Hours - Task	(Insert here the total number of hours for the proposed labor category)				(Insert Total Hours for entire Base Period)

Option Period 4

- Remove instructions in red when completing.

- Fill in / Complete all cells highlighted in blue.

	(BEAR -Follow-on ) - Staffing Plan Matrix for Option Period 4
	TASK/CLIN Labor Hours
	Company (Prime/Sub-contractor)	(Insert Company Name and whether it is the Prime or Sub for each labor category)	i.e. ABC Corp (Prime)	i.e. Xyz Corp (Sub)		Total Hours per Task
	Labor Categories	(Insert the labor categories planned to be used in this column. If needed, add additional columns)	i.e Office asssistant	i.e Sr analyst
	Tasks/CLINS
	Basic Expeditionary Airfield Resource (BEAR) Base Systems Support Flight (SSF)
- PWS Tasks 1 thru 8.	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)	i.e. 100	i.e. 50		i.e. 150
	Task 1- Project Management	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 2 - Tehcnical Evaluation Reports	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 3 - Weekly Assesments	(Insert here, and in each labor category proposed, the number of hours for this Task/CLIN. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 4 - Integration, Testing, and Implementation	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 5 - Technical Review	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 6 - Life Cycle Logistic Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 7 - Resolving Equipment Deficencies	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Task 8 - Technical Support	(Insert here, and in each labor category proposed, the number of hours for this Task. Hours shall be for the entire Base Period for this row.)				(Insert total hours for this Task)
	Total Hours - Task	(Insert here the total number of hours for the proposed labor category)				(Insert Total Hours for entire Base Period)

File details come from the government source that posted it. Updated Dec 1, 2023.