L2 Forensic-Scheduler-IDIQ_Proposal Breakdown v2.xlsx

XLSX spreadsheet 24 KB Posted Jan 13, 2025

Attached to: BIL Funded - Program and Project Schedule Analysis (Forensic Scheduler)
Solicitation number: 697DCK-25-R-00037
Issued by: Department of Transportation Federal Aviation Administration Southwestern Region

About this file

Written by GovTribe AI · Jan 13, 2025

This is a pricing template spreadsheet for a forensic scheduling services contract with the FAA. The template breaks down labor categories and rates across multiple project components including Design Build Best Value Selection Assistance, Program Scheduling Monitoring and Analysis (48 months), Project Support, and Electronic Equipment Installation Schedule Monitoring.

The template requires pricing for four key labor categories: Senior Forensic Scheduler, Journeyman Scheduler, Entry Level Scheduler, and Admin support. It includes sections for various project phases like design (6 months), construction (18 months), and installation (6 months), as well as specific tasks for ATCT/TRACON construction (42 months) and COM LOOP work (16 months). The template factors in travel costs for 2 travelers, materials, overhead, and profit margins. A specific task order section (TO 0001) for Pocatello, ID ATCT with a 30-month period of performance is included.

View the file

Other files

File	Type	Posted
RFI Set 2 v2- Forensic Scheduler IDIQ.pdf	PDF	Jan 24, 2025
RFI Set 2 - Forensic Scheduler IDIQ.pdf	PDF	Jan 23, 2025
697DCK-25-R-00037 0001.pdf	PDF	Jan 13, 2025
RFI Set 1 - Forensic Scheduler IDIQ.pdf	PDF	Jan 13, 2025
697DCK-25-R-00037.pdf	PDF	Nov 27, 2024
J3 SCA WD 2015-5509 07.22.24.pdf	PDF	Nov 27, 2024
J2 BIL Uniform Report.xlsx	XLSX spreadsheet	Nov 27, 2024
L1 Past Performance Questionnaire.pdf	PDF	Nov 27, 2024
L2 Forensic-Scheduler-IDIQ_Proposal Breakdown.xlsx	XLSX spreadsheet	Nov 27, 2024
J1 Program and Project Analysis Scheduler - SOW.pdf	PDF	Nov 27, 2024

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.

Bid Sheet & 5yr Rates (General)

BID SHEET & 5 YEAR RATES (GENERAL)
2.1 Design Build Best Value Selection Assistance	Base Year 1	Out Years**

Description Hourly Rate Months HR/Month Hours Subtotal Year 2 Year 3 Year 4 Year 5

Proposal and Schedule Review

Senior Forensic Scheduler (Senior)	$0.00	1	0	$0.00
Journeyman Scheduler (Mid)	$0.00	1	0	$0.00
Entry Level (Working)	$0.00	1	0	$0.00
Admin (Other)	$0.00	1	0	$0.00
Subtotals				$0.00

Analysis and Recommendations

Senior Forensic Scheduler	$0.00	1	0	$0.00
Journeyman Scheduler	$0.00	1	0	$0.00
Entry Level	$0.00	1	0	$0.00
Admin	$0.00	1	0	$0.00
Subtotals				$0.00

Best Value Meeting(s)
Senior Forensic Scheduler	$0.00	1	0	0	$0.00
Journeyman Scheduler	$0.00	1	0	0	$0.00
Subtotals				0	$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00	* Travel is Cost Reimbursable No Fee (CRNF). OH & Profit must not be applies to Travel.
				** Labor Rates must be provided for all out years for each labor categories.
Materials			$0.00	*** Do not fill out the grayed out columns/rows.

Travel Assume 2 Travelers*
Generic Location	$0.00	4	$0.00

Subtotal $0.00

Overhead	0.00%	$0.00
Profit	0.00%	$0.00
Total:		$0.00

2.2 Program Scheduling Monitoring and Analysis - 48 Months

Description Hourly Rate Months HRS Subtotal

Monthly Update All Meetings

Senior Forensic Scheduler	$0.00	48	0	$0.00
Journeyman Scheduler	$0.00	48	0	$0.00
Entry Level	$0.00	48	0	$0.00
Admin	$0.00	48	0	$0.00
Subtotals				$0.00

Monthly Briefings
Senior Forensic Scheduler	$0.00	48	0	0	$0.00
Journeyman Scheduler	$0.00	48	0	0	$0.00
Entry Level	$0.00	48	0	0	$0.00
Admin	$0.00	48	0	0	$0.00
Subtotals		0	0	0	$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00

Travel Assume 2 Travelers*
Generic Location	$0.00	0	$0.00
Misc Materials			$0.00
Subtotal			$0.00

Overhead	0.00%	$0.00
Profit	0.00%	$0.00
Total:		$0.00

2.3 Project Support

Description Hourly Rate Months HRS Subtotal

Design

Senior Forensic Scheduler	$0.00	6	$0.00
Journeyman Scheduler	$0.00	6	$0.00
Entry Level	$0.00	6	$0.00
Admin	$0.00	6	$0.00
Subtotals			$0.00

Construction

Senior Forensic Scheduler	$0.00	18	$0.00
Journeyman Scheduler	$0.00	18	$0.00
Entry Level	$0.00	18	$0.00
Admin	$0.00	18	$0.00
Subtotals			$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00

Travel Assume 2 Travelers*
Generic Location	$0.00	4	$0.00
Misc Materials			$0.00
Subtotal			$0.00

Overhead	0.00%	$0.00
Profit	0.00%	$0.00
Total:		$0.00

2.4 Electronic Equipment Installation Schedule Monitoring and Analysis

Description Hourly Rate Months HRS Subtotal

Installation

Senior Forensic Scheduler	$0.00	6	$0.00
Journeyman Scheduler	$0.00	6	$0.00
Entry Level	$0.00	6	$0.00
Admin	$0.00	6	$0.00
Subtotals			$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00

Travel Assume 2 Travelers*
Generic Location	$0.00	0	$0.00
Misc Materials			$0.00
Subtotal			$0.00

Overhead	0.00%	$0.00
Profit	0.00%	$0.00
Total:		$0.00

Generic Replace ATCT and TRACON

Description Hourly Rate Months HRS Subtotal

Construction ATCT TRACON

Senior Forensic Scheduler	$0.00	42	$0.00
Journeyman Scheduler	$0.00	42	$0.00
Entry Level	$0.00	42	$0.00
Admin	$0.00	42	$0.00
Subtotals			$0.00

COM LOOP

Senior Forensic Scheduler	$0.00	16	$0.00
Journeyman Scheduler	$0.00	16	$0.00
Entry Level	$0.00	16	$0.00
Admin	$0.00	16	$0.00
Subtotals		0	$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00

Travel Assume 2 Travelers*
Generic Location	$0.00	20	$0.00
Misc Materials			$0.00
Subtotal			$0.00

Overhead	0.00%	$0.00
Profit	0.00%	$0.00
Total:		$0.00

Generic MOD Sustain Project

Description Hourly Rate Months HRS Subtotal

Generic MOD Sustain Project

Senior Forensic Scheduler	$0.00	18	$0.00
Journeyman Scheduler	$0.00	18	$0.00
Entry Level	$0.00	18	$0.00
Admin	$0.00	18	$0.00
Subtotals			$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00

Travel Assume 2 Travelers*
Generic Location	$0.00	2	$0.00
Misc Materials			$0.00
Subtotal			$0.00

Overhead	0.00%	$0.00
Profit	0.00%	$0.00
Total:		$0.00

TO 0001 PIH ATCT

Task Order 0001: Pocatello, ID
PoP:	30 months from TO award
2.3 Project Support

Description Hourly Rate Months HRS Subtotal

Design

Senior Forensic Scheduler	$0.00	$0.00
Journeyman Scheduler	$0.00	$0.00
Entry Level	$0.00	$0.00
Admin	$0.00	$0.00
Subtotals		$0.00

Construction

Senior Forensic Scheduler	$0.00	$0.00
Journeyman Scheduler	$0.00	$0.00
Entry Level	$0.00	$0.00
Admin	$0.00	$0.00
Subtotals		$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00

Travel Assume 2 Travelers*
Pocatello (PIH)	$0.00	4	$0.00
Misc Materials			$0.00
Subtotal			$0.00

Task Total: $0.00

2.4 Electronic Equipment Installation Schedule Monitoring and Analysis

Description Hourly Rate Months HRS Subtotal

Installation

Senior Forensic Scheduler	$0.00	$0.00
Journeyman Scheduler	$0.00	$0.00
Entry Level	$0.00	$0.00
Admin	$0.00	$0.00
Subtotals		$0.00

Allowance for Schedule Resubmittal	0%		$0.00
Total Labor		0	$0.00

Travel Assume 2 Travelers*
Pocatello	$0.00	0	$0.00
Misc Materials			$0.00
Subtotal			$0.00

Task Total $0.00

Overhead	0.00%	$0.00	$0.00
Profit	0.00%	$0.00	$0.00
Task Order Total:			$0.00

File details come from the government source that posted it. Updated Jan 13, 2025.