Attachment 9 - Schedule B_ FS Excel Breakdown 7-5-23.xlsx

XLSX spreadsheet 41 KB Posted Jul 5, 2023

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

View the file

Other files for this federal contract opportunity

Other files attached to CANCELED*** Screening Information Request (SIR)/Request for Proposal (RFP): Financial Support Services, newest first.
File	Type	Posted
Questions and Answers - 07.05.2023.pdf	PDF	Jul 5, 2023
6973GH-23-R-00147-0006.pdf	PDF	Jul 5, 2023
Attachment 06 - 07032023 Labor Category Descriptions.xlsx	XLSX spreadsheet	Jul 3, 2023
Questions and Answers - 07.03.23.pdf	PDF	Jul 3, 2023
Attachment 09 - Schedule B_ FS Excel Breakdown 7-3-23.xlsx	XLSX spreadsheet	Jul 3, 2023
Attachment 01 07032023 SOW - Financial Services.pdf	PDF	Jul 3, 2023
6973GH-23-R-00147-0005.pdf	PDF	Jul 3, 2023
6973GH-23-R-00147-0004.pdf	PDF	Jun 29, 2023
6973GH-23-R-00147-0003.pdf	PDF	Jun 28, 2023
Attachment 9 - Schedule B_ FS Excel Breakdown 6-13-23.xlsx	XLSX spreadsheet	Jun 16, 2023
Attachment 1 06122023 SOW - Financial Services.pdf	PDF	Jun 16, 2023
Attachment 12 _Core_Salary_with_Conversion.xlsx	XLSX spreadsheet	Jun 16, 2023
6973GH-23-R-00147-0002.pdf	PDF	Jun 16, 2023
Questions and Answers - June 16.pdf	PDF	Jun 16, 2023
Questions and Answers.pdf	PDF	Jun 5, 2023
6973GH-23-R-00147-0001.pdf	PDF	Jun 5, 2023
Attachment 8 - Quality Assurance Survelliance Plan.pdf	PDF	May 24, 2023
Attachment 7 Contract Data Requirements List.pdf	PDF	May 24, 2023
Attachment 4i_AMKWI-333-334-335-00010 Financial Statements v22.pdf	PDF	May 24, 2023
Attachment 4e_AMKWI-331-332-00005 FIXED ASSETS DRAFT v09.pdf	PDF	May 24, 2023
Attachment 4c_AMKWI-331-332-00003 AR Management Review Process v10.pdf	PDF	May 24, 2023
Attachment 4a_AMKWI-331-332-00001 Suspense Aging v10.pdf	PDF	May 24, 2023
Attachment 4 11092022 TSOW - Financial Reporting Analysis Branch.doc	DOC document	May 24, 2023
Attachment 3a_Global Deposit Process-FY22.pdf	PDF	May 24, 2023
Attachment 3 11092022 TSOW - Accounts Receivable.doc	DOC document	May 24, 2023
6973GH-23-R-00147.pdf	PDF	May 24, 2023
Attachment 5a E-Travel Post Audit Procedure Requests 11092022.docx	DOCX document	May 24, 2023
Attachment 4h_AMKWI-333-334-335-00006 Customer Focus Work Group v10.pdf	PDF	May 24, 2023
Attachment 2a_AMKWI-310-00002.pdf	PDF	May 24, 2023
Attachment 2 05122023 TSOW - Accounts Payable v2.doc	DOC document	May 24, 2023
Attachment 1 10192022 SOW - Financial Services.docx	DOCX document	May 24, 2023
Attachment 11 - AMS 3.6.2-29 Statement of Equivalent Rates.pdf	PDF	May 24, 2023
Attachment 10_Wage Determination 2015-5315_OKC.pdf	PDF	May 24, 2023
Attachment 6 - 06142022 Labor Category Descriptions.xlsx	XLSX spreadsheet	May 24, 2023
Attachment 5 11092022 TSOW - Travel.doc	DOC document	May 24, 2023
Attachment 4k_AMKWI-333-334-335-00023 Journal Voucher Processing v41.pdf	PDF	May 24, 2023
Attachment 4j_AMKWI-333-334-335-00019 SF-133.pdf	PDF	May 24, 2023
Attachment 4f_AMKWI-331-332-00006 Purchase Orders v08.pdf	PDF	May 24, 2023
Attachment 4d_AMKWI-331-332-00004 Accts Payable Recon v08.pdf	PDF	May 24, 2023
Attachment 4b_AMKWI-331-332-00002 FBwT EDQ Recon v09.pdf	PDF	May 24, 2023
Attachment 2b_FY22 GC DUTIES-WORK INSTRUCTIONS 08242022.xlsx	XLSX spreadsheet	May 24, 2023
Attachment 9 - Schedule B_ FS Excel Breakdown.xlsx	XLSX spreadsheet	May 24, 2023
Attachment 4g_AMKWI-331-332-00010 ACCRUED RECEIPTS RECONCILIATION v04.pdf	PDF	May 24, 2023

Show all 43

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 Sep 2023 - Aug 2024 Regular Rates Base Year Sep 2023 - Aug 2024 Premium Rates Option Year 1 Sep 2024 - Aug 2025 Regular Rates Option Year 1 Sep 2024 - Aug 2025 Premium Rates Option Year 2 Sep 2025 - Aug 2026 Regular Rates Option Year 2 Sep 2025 - Aug 2026 Premium Rates Option Year 3 Sep 2026 - Aug 2027 Regular Rates Option Year 3 Sep 2026 - Aug 2027 Premium Rates Option Year 4 Sep 2027 - Aug 2028 Regular Rates Option Year 4 Sep 2027 - Aug 2028 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

Financial Specialist II

Financial Specialist III

Financial Specialist IV

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.6	$ - 0	1880	$ - 0
Site Supervisor, Level II	1	$ - 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
Business Analyst II	2	$ - 0	1880	$ - 0
Financial Specialist, Level II	2	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	26.6			$ - 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.2	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.3			$ - 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.2	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.6	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.8			$ - 0

Task 4 - Travel (AMK-340)
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.2	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 4 Total	1.3			$ - 0
	Employees
Base Year Total	38.0			$ - 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.6	$ - 0	1880	$ - 0
Site Supervisor, Level II	1	$ - 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
Business Analyst - EDQ	2	$ - 0	1880	$ - 0
Financial Specialist	2	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	26.6			$ - 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.2	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.3			$ - 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.2	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.6	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.8			$ - 0

Task 4 - Travel (AMK-340)
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.2	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.3			$ - 0
	Employees
OY 1 Total	38.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.6	$ - 0	1880	$ - 0
Site Supervisor, Level II	1	$ - 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
Business Analyst - EDQ	2	$ - 0	1880	$ - 0
Financial Specialist	3	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	27.6			$ - 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.2	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.3			$ - 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.2	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.6	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.8			$ - 0

Task 4 - Travel (AMK-340)
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.2	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.3			$ - 0
	Employees
OY 2 Total	39.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.6	$ - 0	1880	$ - 0
Site Supervisor, Level II	1	$ - 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
Business Analyst - EDQ	2	$ - 0	1880	$ - 0
Financial Specialist	3	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	27.6			$ - 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.2	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.3			$ - 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.2	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.6	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.8			$ - 0

Task 4 - Travel (AMK-340)
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.2	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.3			$ - 0
	Employees
OY 3 Total	39.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.6	$ - 0	1880	$ - 0
Site Supervisor, Level II	1	$ - 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
Business Analyst - EDQ	2	$ - 0	1880	$ - 0
Financial Specialist	4	$ - 0	1880	$ - 0
General Clerks, Level II	2	$ - 0	1880	$ - 0
Task 1 Total	28.6			$ - 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.2	$ - 0	1880	$ - 0
Accountant, Level II	1	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 2 Total	2.3			$ - 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.2	$ - 0	1880	$ - 0
Site Supervisor, Level II	0.6	$ - 0	1880	$ - 0
Accountant, Level II	6	$ - 0	1880	$ - 0
Accounting Clerk, Level II	1	$ - 0	1880	$ - 0
Task 3 Total	7.8			$ - 0

Task 4 - Travel (AMK-340)
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.2	$ - 0	1880	$ - 0
Accounting Clerk, II	1	$ - 0	1880	$ - 0
Task 4 Total	1.3			$ - 0
	Employees
OY 4 Total	40.00			$ - 0

For Official Use Only

Roll-up

Tasks	Base Year Sep 2023 - Aug 2024	Option Year 1 Sep 2024 - Aug 2025	Option Year 2 Sep 2025 - Aug 2026	Option Year 3 Sep 2026 - Aug 2027	Option Year 4 Sep 2027 - Aug 2028	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
TOTAL	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

File details come from the government source that posted it. Updated Jul 5, 2023.