Attachment 9 Schedule B_FS Excel Breakdown 10-23-23.xlsx

XLSX spreadsheet 41 KB Posted Oct 27, 2023

Attached to: Screening Information Request (SIR)/Request for Proposal (RFP): Financial Services Federal contract opportunity
Solicitation number: 6973GH-24-R-00020
Issued by: Department of Transportation Federal Aviation Administration Franchise Acquisition Services

About this file

Written by GovTribe AI · Dec 21, 2023

This spreadsheet contains proposed labor rates for a financial services contract with the Department of Transportation Federal Aviation Administration. Labor categories include Program Manager, Site Supervisor, various levels of Accountants, Business Analysts, Financial Specialists, and Administrative Clerks. Rates are provided for the base year and four option years, with regular and premium hourly rates included. Task areas consist of Administrative Payments, Accounts Receivable, Financial Reporting Analysis, Travel, and Requirements Analysis. Staffing levels and estimated costs are listed by labor category and task for each contract period. The total proposed contract value is not provided as the labor rates are blank, suggesting this is a template or sample rate sheet included with Solicitation Number 6973GH-24-R-00020 for financial services.

View the file

Other files for this federal contract opportunity

Other files attached to Screening Information Request (SIR)/Request for Proposal (RFP): Financial Services, newest first.
File	Type	Posted
6973GH-24-R-00020-0005.pdf	PDF	Nov 15, 2023
AMD 0004_Attachment 10 11032023 Contract Data Requirements List.pdf	PDF	Nov 6, 2023
Questions and Answers - 11.06.2023.pdf	PDF	Nov 6, 2023
6973GH-24-R-00020-0004.pdf	PDF	Nov 6, 2023
AMD 0004_Attachment 7 11062023 Labor Category Descriptions.pdf	PDF	Nov 6, 2023
AMD 0004_Attachment 1 11032023 SOW - Financial Services.pdf	PDF	Nov 6, 2023
Questions and Answers - 11.03.2023.pdf	PDF	Nov 3, 2023
6973GH-24-R-00020-0003.pdf	PDF	Nov 3, 2023
Questions and Answers - 11.01.2023.pdf	PDF	Nov 1, 2023
6973GH-24-R-00020-0002.pdf	PDF	Nov 1, 2023
Questions and Answers dated 10.30.2023.pdf	PDF	Oct 30, 2023
6973GH-24-R-00020-0001.pdf	PDF	Oct 30, 2023
Attachment 5a 11092022 E-Travel Post Audit Procedure Requests.pdf	PDF	Oct 27, 2023
Attachment 1 10232023 SOW Financial Services.pdf	PDF	Oct 27, 2023
6973GH-24-R-00020.pdf	PDF	Oct 27, 2023
Attachment 10 Contract Data Requirements List.pdf	PDF	Oct 27, 2023
Attachment 7 10182023 Labor Category Descriptions.pdf	PDF	Oct 27, 2023
Attachment 6 10182023 TSOW 5 Requirements Analysis and Process Improvement.pdf	PDF	Oct 27, 2023
Attachment 5 11092022 TSOW 4 Travel.pdf	PDF	Oct 27, 2023
Attachment 4g_AMKWI-331-332-00010 ACCRUED RECEIPTS RECONCILIATION v04.pdf	PDF	Oct 27, 2023
Attachment 4 03012023 TSOW 3 - Financial Reporting Analysis Branch.pdf	PDF	Oct 27, 2023
Attachment 3 03012023 TSOW 2 - Accounts Receivable.pdf	PDF	Oct 27, 2023
Attachment 2b_FY22 GC DUTIES-WORK INSTRUCTIONS 08242022.xlsx	XLSX spreadsheet	Oct 27, 2023
Attachment 2b_FY22 GC DUTIES-WORK INSTRUCTIONS 08242022.pdf	PDF	Oct 27, 2023
Attachment 2 10162023 TSOW 1 - Accounts Payable.pdf	PDF	Oct 27, 2023
Attachment 13 - Wage Determination 5315-2015_OKC.pdf	PDF	Oct 27, 2023
Attachment 11-AMS 3.6.2-29 StatementofEquivalentRates.pdf	PDF	Oct 27, 2023
Attachment 8 - Quality Assurance Surveillance Plan 10242023.pdf	PDF	Oct 27, 2023
Attachment 4j_AMKWI-333-334-335-00019 SF-133.pdf	PDF	Oct 27, 2023
Attachment 4i_AMKWI-333-334-335-00010 Financial Statements v22.pdf	PDF	Oct 27, 2023
Attachment 4h_AMKWI-333-334-335-00006 Customer Focus Work Group v10.pdf	PDF	Oct 27, 2023
Attachment 4d_AMKWI-331-332-00004 Accts Payable Recon v08.pdf	PDF	Oct 27, 2023
Attachment 4a_AMKWI-331-332-00001 Suspense Aging v10.pdf	PDF	Oct 27, 2023
Attachment 3a_Global Deposit Process-FY22.pdf	PDF	Oct 27, 2023
Attachment 2a_AMKWI-310-00002.pdf	PDF	Oct 27, 2023
Attachment 4k_AMKWI-333-334-335-00023 Journal Voucher Processing v41.pdf	PDF	Oct 27, 2023
Attachment 4e_AMKWI-331-332-00005 FIXED ASSETS DRAFT v09.pdf	PDF	Oct 27, 2023
Attachment 12_Core_Salary_with_Conversion.xlsx	XLSX spreadsheet	Oct 27, 2023
Attachment 4f_AMKWI-331-332-00006 Purchase Orders v08.pdf	PDF	Oct 27, 2023
Attachment 4c_AMKWI-331-332-00003 AR Management Review Process v10.pdf	PDF	Oct 27, 2023
Attachment 4b_AMKWI-331-332-00002 FBwT EDQ Recon v09.pdf	PDF	Oct 27, 2023

Show all 41

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

Try for free Login

Text version

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

Hourly Rate w Escalation Financial Services - Schedule B

Labor Category/Level Base Year Mar 2024 - Feb 2025 Regular Rates Base Year Mar 2024 - Feb 2025 Premium Rates Option Year 1 Mar 2025 - Feb 2026 Regular Rates Option Year 1 Mar 2025 - Feb 2026 Premium Rates Option Year 2 Mar 2026 - Feb 2027 Regular Rates Option Year 2 Mar 2026 - Feb 2027 Premium Rates Option Year 1 Mar 2027 - Feb 2028 Regular Rates Option Year 1 Mar 2027 - Feb 2028 Premium Rates Option Year 1 Mar 2028 - Feb 2029 Regular Rates Option Year 1 Mar 2028 - Feb 2029 Premium Rates

Program Manager*

Site/Task Supervisor II

Accountant I (exempt)

Accountant II (exempt)

Accountant III (exempt)

Accountant IV (exempt)

Business Analyst I (exempt)

Business Analyst II (exempt)

Business Analyst III (exempt)

Financial Specialist I (exempt)

Financial Specialist II (exempt)

Financial Specialist III (exempt)

Financial Specialist IV (exempt)

Accounting Clerk I (SCA)

Accounting Clerk II (SCA)

Accounting Clerk III (SCA)

General Clerk I (SCA)

General Clerk II (SCA)

General Clerk III (SCA)

*Key Personnel

For Official Use Only

Base Yr

Task 1 - Administrative Payments Branch (AMK-310)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.55	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.55	$ - 0	1880	$ - 0
Accountant, Level II	3	$ - 0	1880	$ - 0
Accountant, Level III	3	$ - 0	1880	$ - 0
Accounting Clerk, Level II	11	$ - 0	1880	$ - 0
Accounting Clerk, Level III	2	$ - 0	1880	$ - 0
Financial Specialist, Level II	2	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	24.1			$ - 0
Task 2 - Accounts Receivable Billing & Revenue Branch (AMK-320)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.1	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.1	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.2			$ - 0
Task 3 - Financial Reporting Analysis Branch (AMK-330)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.25	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.25	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.5			$ - 0

Task 4 - Travel (AMK-340)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 4 Total	1.1			$ - 0

Task 5 - Requirements Analysis and Process Improvement (AMK-350)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Business Analyst, Level II	2	$ - 0	1880	$ - 0
Task 5 Total	2.1			$ - 0
	Employees
Base Year Total	37.0			$

For Official Use Only

Opt Yr 1

Task 1 - Administrative Payments Branch (AMK-310)
Labor Category/Level	Employees	Hourly Rates	Option Year 1	Option Year 1 Costs
Program Manager	0.55	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.55	$ - 0	1880	$ - 0
Accountant, Level II	3	$ - 0	1880	$ - 0
Accountant, Level III	3	$ - 0	1880	$ - 0
Accounting Clerk, Level II	11	$ - 0	1880	$ - 0
Accounting Clerk, Level III	2	$ - 0	1880	$ - 0
Financial Specialist, Level II	2	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	24.1			$ - 0

Task 2 - Accounts Receivable Billing & Revenue Branch (AMK-320)
Labor Category/Level	Employees	Hourly Rates	Option Year 1	Option Year 1 Costs
Program Manager	0.1	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.1	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.2			$ - 0
Task 3 - Financial Reporting Analysis Branch (AMK-330)
Labor Category/Level	Employees	Hourly Rates	Option Year 1	Option Year 1 Costs
Program Manager	0.25	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.25	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.5			$ - 0

Task 4 - Travel (AMK-340)
Labor Category/Level	Employees	Hourly Rates	Option Year 1	Option Year 1 Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.1			$ - 0

Task 5 - Requirements Analysis and Process Improvement (AMK-350)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Business Analyst, Level II	2	$ - 0	1880	$ - 0
Task 5 Total	2.1			$ - 0
	Employees
OY 1 Total	37.0			$ - 0

For Official Use Only

Opt Yr 2

Task 1 - Administrative Payments Branch (AMK-310)
Labor Category/Level	Employees	Hourly Rates	Option Year 2	Option Year 2 Costs
Program Manager	0.55	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.55	$ - 0	1880	$ - 0
Accountant, Level II	3	$ - 0	1880	$ - 0
Accountant, Level III	3	$ - 0	1880	$ - 0
Accounting Clerk, Level II	11	$ - 0	1880	$ - 0
Accounting Clerk, Level III	2	$ - 0	1880	$ - 0
Financial Specialist	3	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	25.1			$ - 0

Task 2 - Accounts Receivable Billing & Revenue Branch (AMK-320)
Labor Category/Level	Employees	Hourly Rates	Option Year 2	Option Year 2 Costs
Program Manager	0.1	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.1	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.2			$ - 0
Task 3 - Financial Reporting Analysis Branch (AMK-330)
Labor Category/Level	Employees	Hourly Rates	Option Year 2	Option Year 2 Costs
Program Manager	0.25	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.25	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.5			$ - 0

Task 4 - Travel (AMK-340)
Labor Category/Level	Employees	Hourly Rates	Option Year 2	Option Year 2 Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.1			$ - 0

Task 5 - Requirements Analysis and Process Improvement (AMK-350)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Business Analyst, Level II	2	$ - 0	1880	$ - 0
Task 5 Total	2.1			$ - 0
	Employees
OY 2 Total	38.00			$ - 0

For Official Use Only

Opt Yr 3

Task 1 - Administrative Payments Branch (AMK-310)
Labor Category/Level	Employees	Hourly Rates	Option Year 3	Option Year 3 Costs
Program Manager	0.55	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.55	$ - 0	1880	$ - 0
Accountant, Level II	3	$ - 0	1880	$ - 0
Accountant, Level III	3	$ - 0	1880	$ - 0
Accounting Clerk, Level II	11	$ - 0	1880	$ - 0
Accounting Clerk, Level III	2	$ - 0	1880	$ - 0
Financial Specialist	3	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	25.1			$ - 0
Task 2 - Accounts Receivable Billing & Revenue Branch (AMK-320)
Labor Category/Level	Employees	Hourly Rates	Option Year 3	Option Year 3 Costs
Program Manager	0.1	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.1	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.2			$ - 0
Task 3 - Financial Reporting Analysis Branch (AMK-330)
Labor Category/Level	Employees	Hourly Rates	Option Year 3	Option Year 3 Costs
Program Manager	0.25	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.25	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.5			$ - 0

Task 4 - Travel (AMK-340)
Labor Category/Level	Employees	Hourly Rates	Option Year 3	Option Year 3 Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.1			$ - 0
Task 5 - Requirements Analysis and Process Improvement (AMK-350)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Business Analyst, Level II	2	$ - 0	1880	$ - 0
Task 5 Total	2.1			$ - 0

	Employees
OY 3 Total	38.00	$ - 0

For Official Use Only

Opt Yr 4

Task 1 - Administrative Payments Branch (AMK-310)
Labor Category/Level	Employees	Hourly Rates	Option Year 4	Option Year 4 Costs
Program Manager	0.55	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.55	$ - 0	1880	$ - 0
Accountant, Level II	3	$ - 0	1880	$ - 0
Accountant, Level III	3	$ - 0	1880	$ - 0
Accounting Clerk, Level II	11	$ - 0	1880	$ - 0
Accounting Clerk, Level III	2	$ - 0	1880	$ - 0
Financial Specialist	4	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	26.1			$ - 0

Task 2 - Accounts Receivable Billing & Revenue Branch (AMK-320)
Labor Category/Level	Employees	Hourly Rates	Option Year 4	Option Year 4 Costs
Program Manager	0.1	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.1	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.2			$ - 0
Task 3 - Financial Reporting Analysis Branch (AMK-330)
Labor Category/Level	Employees	Hourly Rates	Option Year 4	Option Year 4 Costs
Program Manager	0.25	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.25	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.5			$ - 0

Task 4 - Travel (AMK-340)
Labor Category/Level	Employees	Hourly Rates	Option Year 4	Option Year 4 Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.1			$ - 0

Task 5 - Requirements Analysis and Process Improvement (AMK-350)
Labor Category/Level	Employees	Hourly Rates	Base Year Hours	Base Year Estimated Costs
Program Manager	0.05	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.05	$ - 0	1880	$ - 0
Business Analyst, Level II	2	$ - 0	1880	$ - 0
Task 5 Total	2.1			$ - 0
	Employees
OY 4 Total	39.00			$ - 0

For Official Use Only

Roll-up

Tasks	Base Year Mar 2024 - Feb 2025	Option Year 1 Mar 2025 - Feb 2026	Option Year 2 Mar 2026 - Feb 2027	Option Year 3 Mar 2027 - Feb 2028	Option Year 4 Mar 2028 - Feb 2029	Contract Total
Task 1 - Administrative Payments Branch (AMK-310)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Task 2 - Accounts Receivable Billing & Revenue Branch (AMK-320)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Task 3 - Financial Reporting Analysis Branch (AMK-330)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Task 4 - Travel (AMK-340)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Task 5 - Requirements Analysis and Process Improvement (AMK-350)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
TOTAL	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

File details come from the government source that posted it. Updated Oct 27, 2023.