L2 Forensic-Scheduler-IDIQ_Proposal Breakdown.xlsx

XLSX spreadsheet 23 KB Posted Nov 27, 2024

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 · Nov 27, 2024

This is a pricing template spreadsheet for a forensic scheduling services contract, structured to capture labor rates and hours across multiple labor categories (Senior Forensic Scheduler, Journeyman Scheduler, Entry Level, and Admin) for various project components over a 5-year period. The template includes sections for Design Build Best Value Selection Assistance, Program Scheduling Monitoring and Analysis (48 months), Project Support, Electronic Equipment Installation Schedule Monitoring, and specific projects including ATCT/TRACON replacement and MOD Sustain projects.

The template allows for input of hourly rates, hours per month, overhead rates, and profit margins, with separate calculations for travel costs (assuming 2 travelers) and materials. It includes a specific task order (TO 0001) for Pocatello, ID ATCT with a 30-month period of performance. The spreadsheet is designed to capture comprehensive pricing for both base and option years, with provisions for schedule resubmittal allowances and travel to various locations. All sections include formulas for calculating subtotals, overhead, and profit to arrive at total costs for each component.

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
L2 Forensic-Scheduler-IDIQ_Proposal Breakdown v2.xlsx	XLSX spreadsheet	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
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

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 Nov 27, 2024.