BEQ WRALC Production Overhead Pricing.xlsx

XLSX spreadsheet 23 KB Posted Nov 10, 2021

Attached to: Production Overhead Manpower Services
Solicitation number: FA857122R0001
Issued by: Department of the Air Force Materiel Command Air Force Sustainment Center

View the file

File	Type	Posted
Solicitation Amendment FA857122R00010004 SF 30.pdf	PDF	Nov 15, 2021
Solicitation Amendment - FA857122R00010004.pdf	PDF	Nov 15, 2021
BEQ WRALC Production Overhead Pricing.xlsx	XLSX spreadsheet	Nov 15, 2021
Questions Answers Final.pdf	PDF	Nov 10, 2021
PWS WRALC Production Overhead 10 Nov 21.pdf	PDF	Nov 10, 2021
Solicitation Amendment - FA857122R00010003.pdf	PDF	Nov 10, 2021
Wage Determination No. 2015-4495 (Rev. 16) 10202021.pdf	PDF	Nov 10, 2021
Pre-Proposal Conference Agenda.pdf	PDF	Oct 22, 2021
Solicitation DD254.pdf	PDF	Oct 14, 2021
PWS WRALC Production Overhead 5 Oct 21.pdf	PDF	Oct 14, 2021
Wage Determination No. 2015-4495 (Rev. 15) 07212021.pdf	PDF	Oct 14, 2021
ADDENDUM FOR FAR PROVISIONS 52.212-1__5 Oct 2021.pdf	PDF	Oct 14, 2021
Final BEQ WRALC Production Overhead.xlsx	XLSX spreadsheet	Oct 14, 2021
Exhibit A (CDRL A001 - A004).pdf	PDF	Oct 14, 2021
QASP WRALC Production Overhead 20 September 2021 Rev.pdf	PDF	Oct 14, 2021
Appendix C for Safety And Health Requirements.pdf	PDF	Oct 14, 2021
DFARS 252.223-7999 (Class Dev 2021-O0009).pdf	PDF	Oct 14, 2021
Solicitation - FA857122R0001.pdf	PDF	Oct 14, 2021

Show all 18

On GovTribe

Try for free Login

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

BEQ

		Best Estimated Quantity
	CLIN	Description	BEQ FTEs	Total Quantity (BEQ Months = FTEs multiplied by 12)
	0001	Production Control Clerks I	12	168
	0002	Schedulers	6	72
	0003	Material Subject Matter Expert
Part-Time Employee	1	12
	0004	Planners	13	156
	0005	Supervisors	2	24
	1001	Production Control Clerks I	12	168
	1002	Schedulers	6	72
	1003	Material Subject Matter Expert
Part-Time Employee	1	12
	1004	Planners	13	156
	1005	Supervisors	2	24
	2001	Production Control Clerks I	12	168
	2002	Schedulers	6	72
	2003	Material Subject Matter Expert
Part-Time Employee	1	12
	2004	Planners	13	156
	2005	Supervisors	2	24

Price List

CLIN	Labor Category	Monthly Rate, per person/FTE *
0001	Production Control Clerks I
0002	Schedulers
0003	Material Subject Matter Expert

Part-Time Employee

0004	Planners
0005	Supervisors
1001	Production Control Clerks I
1002	Schedulers
1003	Material Subject Matter Expert

Part-Time Employee

1004	Planners
1005	Supervisors
2001	Production Control Clerks I
2002	Schedulers
2003	Material Subject Matter Expert

Part-Time Employee

2004	Planners
2005	Supervisors

* a FTE is equal to 1880 hours per year

* a PTE is equal to 1600 hours per year

BEQ Total Evaluated Price

BEQ Contract Line Item Structure
CLIN	Description	Total Quantity (BEQ Months = FTEs multiplied by 12)	Monthly Rate per FTE (from Price List Tab)	CLIN Total Value

(multiply columns C and D)

	0001	Production Control Clerks I	168
	0002	Schedulers	72
	0003	Material Subject Matter Expert
Part-Time Employee	12
	0004	Planners	156
	0005	Supervisors	24
	1001	Production Control Clerks I	168
	1002	Schedulers	72
	1003	Material Subject Matter Expert
Part-Time Employee	12
	1004	Planners	156
	1005	Supervisors	24
	2001	Production Control Clerks I	168
	2002	Schedulers	72
	2003	Material Subject Matter Expert
Part-Time Employee	12
	2004	Planners	156
	2005	Supervisors	24

Total Evaluated Price (Sum of column E)

Example Only
CLIN	Description	Total Quantity (BEQ Months = FTEs multiplied by 12)	Monthly Rate per FTE (from Price List Tab)	CLIN Total Value

(multiply columns C and D)

0001	Production Control Clerks I	144	$1,000.00	$144,000.00
0002	Schedulers	72	$1,500.00	$108,000.00
0003	Material Subject Matter Expert	12	$2,500.00	$30,000.00
0004	Planners	156	$2,000.00	$312,000.00
0005	Supervisors	24	$3,000.00	$72,000.00
			Total Evaluated Price (Sum of column E)	$666,000.00

File details come from the government source that posted it. Updated Nov 10, 2021.