Attachment J-12 - Appendix F - 2023 FTA PMOC Invoice Template V1.2.0 - Final.xlsx

XLSX spreadsheet 231 KB Posted

Attached to
Request for Proposal (RFP) Project Management Oversight (PMO) Requirement
Solicitation number
FTA_2024_PMO_0005
Issued by

About this file

This document is an Excel template for invoicing under a Project Management Oversight (PMO) contract with the Federal Transit Administration. The template requires entry of contract and task order details, labor categories and rates, project information, and cost breakdowns by cost line item and CLIN. Conditional formatting is built in to validate data. Sections include entry of direct labor hours and costs by employee, overhead and G&A rates by firm, fee calculations, and a summary of expenditures. Invoices are to include a declaration of completion and certification signed by an authorized official. The template standardizes and streamlines the invoice preparation process for PMO contracts while allowing automated validation and checks of invoiced costs against contract terms and prior invoices.

View the file

Other files

File Type Posted
Attachment J-6 - Modified Pre-Award Survey SF1408 Checklist - Final.pdf PDF
Attachment J-9 - Disclosure of Lobbying Activities - Final.pdf PDF
Attachment J-10 - Combined 2024 Final OPs - Final.pdf PDF
Attachment J-11 - Conflict of Interest Matrix for 2024 - Final.xlsx XLSX spreadsheet
Attachment J-12 - Appendix D - DELPHI eInvoice Checklist - Final.pdf PDF
Attachment J-12 - Appendix E - Delphi User Access Request Form for External Users - Final.xlsx XLSX spreadsheet
Attachment J-13 Tables B.24, B.25, B.28 and B.29 - Final.pdf PDF
Attachment J-12 - Appendix A - Declaration of Completion - Final.pdf PDF
FTA PMO RFP_Final_11.09.23_Executed.pdf PDF
Attachment J-4 Small Business Subcontracting Plan - Final.pdf PDF
Attachment J-5 Labor Category Table 2024 - Final.pdf PDF
Attachment J-8 2024 PMO Firm Fixed Price Form - Final.xlsx XLSX spreadsheet
Attachment J-11 - Conflict of Interest Matrix for 2024 - Final.pdf PDF
Attachment J-12 - Appendix A - Declaration of Completion - Final.xlsx XLSX spreadsheet
Attachment J-12 - Appendix C - Summary of Expenditures - Final.pdf PDF
Attachment J-12 - Appendix E - Delphi User Access Request Form for External Users - Final.pdf PDF
Attachment J-13 Tables B.24, B.25, B.28 and B.29 - Final.xlsx XLSX spreadsheet
Attachment J-14 - Small Business Certification - Letter of Intent - Final.pdf PDF
Attachment J-2 - Resume Format - Final.pdf PDF
Attachment J-7 - 2024 PMO J-7 Cost Proposal (Fee_Profit) - Final.pdf PDF
Attachment J-7 - 2024 PMO Contract Pricing Summary Workbook - Final.xlsx XLSX spreadsheet
Attachment J-8 PMO FFP Form - Final.pdf PDF
Attachment J-1 - Proposal Checklist - Final.pdf PDF
Attachment J-3 Past Performance Questionnaire - Final.pdf PDF
Attachment J-12 - 2024 PMOC Billing Instructions PMO Program - Final.pdf PDF
Attachment J-12 - Appendix B - SF 1034 - Final.pdf PDF
Attachment J-12 - Appendix C - Summary of Expenditures - Final.xlsx XLSX spreadsheet
Attachment J-12 - Appendix F - 2023 FTA PMOC Invoice Template V1.2.0 - Final.pdf PDF
Show all 28

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Contract

Enter Yellow Highlighted columns first Orange columns are dropdown selections Green columns are populated automatically

STEP 1 : Enter Contract Information below.STEP 4: Enter Approved FTA Labor CategoriesSTEP 5: Select Firm Name and Enter applicable G&A OH, Fringe, FCCM, & Fee Rates.
Contract and PMOC InformationLabor CategoryFirmFirm AcronymPrime/Sub/ConsultantModIndirect Cost #G&A RateOH RateFringeFCCMFee Rate
Contractor:--0.00%
Address:
Taxpayer I.D. Number:
Bank info for deposit:
Invoice Contact Name:
Invoice Contact Email:
PMO CONTRACT No.:
FTA CO:
Contract Period of Performance Start Date:
Contract Period of Performance End Date:
STEP 2: Enter Firm Name, Firm Acronym, Sub/Prime
FirmPrime/Sub/ConsultantFirm Acronym
-
STEP 3: Enter Approved Personnel and Select Firm
Personnel Names MUST be Unique!!
PersonnelFirmFirm Acronym
-

Add Row at Bottom of Table Delete Selected Row Add Row at Bottom of Table Delete Selected Row Add Row at Bottom of Table Delete Selected Row Add Firm (If not in list) Delete Selected Row Add Row at Bottom of Table Add New Labor Category

Task Order

Enter Yellow Highlighted columns firstOrange columns are dropdown selectionsGreen columns are populated automatically
Rates are Invoiced Rates (Either Labor Category Threshold rates or audited employee rates, generally the lower of these rates)06/23/2021v1.2.0
STEP 6: Enter Task Order Information below.STEP 8: Enter Fee Rate, Select Labor Rate Year, and complete Labor Rate table below for any employee or subcontractor that will appear on the current invoice.Enter Fee Rate
Task Order InformationSelect Labor RateYR1 Rate
Task Order Number:Invoice Labor Rates and Firm Info Summary Table
Task Order Description:LaborCategoryPersonnelFirmAcronymPrime/Sub/ConsultantYR1 RateYR2 RateYR3 RateYR4 RateYR5 Rate
Invoice Period of Performance Start Date:---
Invoice Period of Performance End Date:---
Invoice No.1
PMOC Invoice #
Invoice Revision
Invoice Date:
FTA COR:
FTA ACOR
Region / HQ
Task Order Period of Performance Start Date:
Task Order Period of Performance End Date:Default Directory:
STEP 7: Add projects as required and enter project name.C:\Users\Aaron\OneDrive - EBI Management Group, Inc\Desktop
Project NumberProject Name
1Project 1

Add Project Create New Invoice Select Default Invoice Directory Add Row at Bottom of Table Delete Selected Row Sort by Labor Category Sort by Personnel Remove Last Project RESET Workbook Turn OFF Single Digit Task Orders Turn ON Single Digit Task Orders

H.2 & B

Enter Yellow Highlighted columns firstOrange columns are dropdown selectionsGreen columns are populated automatically
STEP 9: Enter Fixed Fee Withholding.
Fixed Fee Withholding DetailsH.2 Table SummaryB Table Summary
Order/Mod No.Withholding of Fixed Fee ThresholdAwardCLINLabor HoursAllotted to CostAllotted to FeeCPFFNotesAwardCLINLabor HoursAllotted to CostAllotted to FeeCPFFNotes
BaseH.2 TOTAL1- 0$ - 0$ - 0$ - 0B TOTAL1- 0$ - 0$ - 0$ - 0
Total$ - 0H.2 TOTAL2- 0$ - 0$ - 0$ - 0B TOTAL2- 0$ - 0$ - 0$ - 0
H.2 TOTAL3- 0$ - 0$ - 0$ - 0B TOTAL3- 0$ - 0$ - 0$ - 0
H.2 TOTAL4- 0$ - 0$ - 0$ - 0B TOTAL4- 0$ - 0$ - 0$ - 0
H.2 TOTAL5- 0$ - 0$ - 0$ - 0B TOTAL5- 0$ - 0$ - 0$ - 0
TOTALALL CLINS- 0$ - 0$ - 0$ - 0TOTALALL CLINS- 0$ - 0$ - 0$ - 0
STEP 10: Complete H.2 Table Information as awards are approved.STEP 11: Complete B Table Information as awards are approved.
AwardCLINLabor HoursAllotted to CostAllotted to FeeCPFFNotesAwardCLINLabor HoursAllotted to CostAllotted to FeeCPFFNotes
BASE1$ - 0BASE1$ - 0
BASE2$ - 0BASE2$ - 0
BASE3$ - 0BASE3$ - 0
BASE4$ - 0BASE4$ - 0
BASE5$ - 0BASE5$ - 0
SUBTOTALALL CLINS- 0$ - 0$ - 0$ - 0SUBTOTALALL CLINS- 0$ - 0$ - 0$ - 0

Delete Last Row Add H.2 Modification Add B Modification Delete Last H.2 Modification Delete Last B Modification

Proj1

PROJECT LEVEL COST BREAKDOWNCLIN 1-5 SUMMARY TABLEUnbilled LOE for Fixed Fee
1Invoice #:1CLINLOE (Hours)LOE for Fixed Fee (Hours)LaborG&AOverheadFringeSubtotalBilled Fixed FeeWithholding of Fixed FeeFee Withholding AdjustmentFCCMNet InvoiceChange in (Billed)/Unbilled Fixed FeeUnbilled LOE for Fixed Fee HoursUnbilled LOE for Fixed Fee Dollars
Contractor:0CLIN 10.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00$ - 0
Billing Period Start Date:12/31/99CLIN 20.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00$ - 0
Billing Period End Date:12/31/99CLIN 30.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00$ - 0
Invoice Date:12/31/99CLIN 40.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00$ - 0
FALSECLIN 5$ - 0$ - 00.00$ - 0
Task Order:0CLIN 1 - 5 Totals0.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.00$ - 0
Project Number:1Prime Totals0.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Project Name:Project 1Subcontractor Totals0.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Project Phase:Project DevelopmentConsultant Totals0.00$ - 0$ - 0$ - 0$ - 0
Travel and ODC$ - 0$ - 0
Labor Rate:YR1 RateTOTALS0.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
SECTION A: CLIN 1-4 DETAILS
Drop DownFirm DetailsEntry CellsDrop DownEntry CellsCost ComponentsSubtotalsFixed Fee & RetainageFCCMInvoice Totals
TrackingNumPersonnelLCATCLINFirmPrime/Sub/ ConsultantDescriptionLOE (Hours)LOE for Fixed Fee (Hours)Indirect Cost #Override Labor RateRateLaborG&AOverheadFringeSubtotalBilled Fixed FeeWithholding of Fixed FeeFee Withholding AdjustmentFCCMNet InvoiceChange in (Billed)/Unbilled Fixed Fee
--$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN 1 - 4 TOTALS0.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
00
SECTION A: CLIN 1-4 FEE FROM PRIOR INVOICE
Drop DownEntry CellsDrop DownEntry CellsEntry Cells
Column1Prior Invoice NumberOP Number (Optional)CLINFirmPrime/SubDescription/Report Name/DeliverableACOR ApprovalLOE for Fixed Fee (Hours)Billed Fixed FeeWithholding of Fixed FeeFee Withholding AdjustmentNet Fee BillingChange in (Billed)/Unbilled Fixed Fee
-$ - 0$ - 0$ - 0
FEE FROM PRIOR INVOICE TOTALS0.00

Aaron: Cannot Exceed Previously Unbilled LOE for Fixed Fee Hours less Consultant Hours for Project.

Ignore if only consultant hours billed in Project LOE Hours for this invoice.

CLIN Summ: Column AS - Column AU $ - 0 Aaron: Cannot Exceed Previously Unbilled LOE for Fixed Fee Dollars for project.

CLIN Summ: Column AX $ - 0 $ - 0 $ - 0 $ - 0

SECTION B: CLIN 5 DETAILS
Drop DownEntry CellCLIN 5Firm DetailsEntry CellsDrop DownEntry Cells
TrackingNumPersonnelTAR NumberCLINFirmPrime/Sub/ ConsultantTravel Date OR Non-Travel ODC DescApproval DateCityStateTrip#/ODCTAR or ODCs Estimated AmountAmount
1.1.5.1CLIN 5--
Totals$ - 0$ - 0

Add Row at Bottom of Table Delete Selected Row Add Row Above Selected Add Row Above Selected Add Row at Bottom of Table Delete Selected Row Add Row Above Selected

Inv Summ

INVOICE OVERVIEWFEE BILLING DETAILS
Contractor:0FEE BILLING DETAILSInvoiceBilled LOE (Hours)Billed LOE for FF (Hours)Billed FeeWithholding of FFNet Fee BilledUnbilled LOE for FF (hours)Unbilled Fixed Fee (Dollars)
Address:0$ - 0
0Total0.0
Aaron: Must equal Total LOE this Invoice: Column E0.0

Aaron: Must equal Total LOE for Fixed Fee (Hours)

CLIN Summ: AF12$ - 0
Aaron: Must eqal Total Fixed Fee: Column G$ - 0
Aaron: Must equal Total Withholding of Fixed Fee: Column H$ - 00.0

Aaron: Must eqal Total Unbilled Hours by Prime

Accumulated Fixed Fee: Column K $ - 0 Aaron: Must equal Total Change in (Billed)/Unbilled Fixed Fee (excludes fixed fee withhold).

Accumulated Fixed Fee: Column G

Taxpayer I.D. Number:00ERROR:#REF!$ - 0
Bank info for deposit:0
Invoice Contact Name:0
Invoice Contact Email:0
PMO CONTRACT No.:0
FTA CO:0
FTA COR:0
Invoice Period of Performance Start Date:12/31/1899
Invoice Period of Performance End Date:12/31/1899
Invoice No.1
Invoice Date:12/31/1899
Task Order DescriptionTask Order NumberTask Order Expiration DateFTA COR
0012/31/9912/31/99
Project NumberProject NameFTA ACORLOE this InvoiceSubtotal Billed this InvoiceFixed FeeWithholding of Fixed FeeFee AdjustmentFCCMNet Invoice Amount
1Project 10- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Billed This Period- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

NOTE: Invoice Overview Format Applies to both Headquarter's and Regional Task Orders

EINVOICING RECAPCLIN 1CLIN 2CLIN 3CLIN 4CLIN 5Total
eInvoice Entry$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

TO Summ

INVOICE BREAKDOWN
Contractor0
Invoice No.:1
Invoice Date:12/31/99
B TableH.2 TableIIP
Task Order NumberTask Order DescriptionTask Order Dollars Not-to-Exceed AuthorizedTask Order Hours Not-to-Exceed AuthorizedTask Order Dollars Funded to DateTask Order Hours Funded to DateBudgetary Dollars Allocated From H.2 TableBudgetary Hours Allocated From H.2 TableDollars Billed to
Date *Hours Billed to DateH.2 Balance AvailableH.2 Hours AvailableFunds Billed To Date (%)Hours Billed To Date (%)
00$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0ERROR:#DIV/0!ERROR:#DIV/0!
Project NumberProject NameIIP/Budgetary Dollars Allocated From H.2 TableIIP/Budgetary Hours Allocated From H.2 TableDollars Accrued Previously *Hours Billed PreviouslyDollars Accrued This Period *Hours Billed This PeriodTotal Dollars Accrued to Date *Total Hours Billed to DateIIP/Budgetary Balance RemainingIIP/Budgetary Hours RemainingFunds Billed To Date (%)Hours Billed To Date (%)
1Project 1$0.000.00$0.000.00$ - 00.00$ - 00.000.00%0.00%
Total$ - 00.00$0.000.00$ - 00.00$ - 00.00$ - 00.000.00%0.00%
Fee SummaryNot-to-Exceed (Allotted to Fee)Billed PreviouslyBilled This PeriodBilled to DateBalance RemainingBilled To
Date (%)* includes fixed fee regardless of deliverable acceptance and does not include associated withholding of fixed fee.
Level of Effort Fee$ - 0$ - 0$ - 0$ - 0
Withholding of Fixed Fee$ - 0$ - 0$ - 0$ - 0
Fee Less Withholding$ - 0$ - 0$ - 0$ - 00.00%

CLIN Summ

COST AND HOURS BREAKDOWN BY CLIN* includes fixed fee regardless of deliverable acceptance and does not include associated withholding of fixed fee.COST AND HOURS BREAKDOWN BY CLIN
Invoice No.1Invoice No.1.
Invoice Date:12/31/1899Invoice Date:12/31/1899
Combined ProjectsCLIN Summary with Fixed FeeWithholding of Fixed FeeCombined ProjectsCLIN Summary - Cash BasisFixed Fee AccumulationWithholding of Fixed Fee AccumulationHOURS AND COST BY CLIN FOR ALL PROJECTS ON THIS INVOICEUnbilled Hours For All ProjectsUnbilled Fee for All ProjectsCLIN Summ Conditional Formats
CLINCLIN DescriptionT.O. Dollars Accrued Previously *T.O. Hours Billed PreviouslyT.O. Dollars Accrued This Period *T.O. Hours Billed This PeriodT.O. Dollars Accrued to Date *T.O. Hours Billed to DateTO Withholding Billed to DateTO Billed to Date with Fixed Fee (less Withholding to date)CLINCLIN DescriptionT.O. Dollars Billed PreviouslyT.O. Hours Billed PreviouslyT.O. Dollars Billed This PeriodT.O. Hours Billed This PeriodT.O. Dollars Billed to DateT.O. Hours Billed to DateFF Previously Earned To DateFF Earned This PeriodFF Earned To DateT.O. Previously Withheld To DateT.O. Dollars Withheld This PeriodT.O. Dollars Withheld To DateCLINLOE (Hours)LOE for Fixed Fee (Hours)LaborG&AOverheadFringeSubtotalBilled Fixed FeeWithholding of Fixed FeeFee Withholding AdjustmentFCCMNet InvoiceChange in (Billed)/Unbilled Fixed FeePreviously UnbilledCurrent UnbilledConsultant Hours
(Reconciling Fee Hours)Unbilled LOE for Fixed Fee HoursPreviously Unbilled FeeCurrent Unbilled FeeUnbilled LOE for Fixed Fee Dollars.9 g.75g.9h.75h
1Program Support and Lessons Learned$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 01Program Support and Lessons Learned$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 10.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 00.0010.001
2On-Site Monitoring and Reporting$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 02On-Site Monitoring and Reporting$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 20.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 00.0010.001
3Baseline Oversight$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 03Baseline Oversight$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 30.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 00.0010.001
4Optional Oversight$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 04Optional Oversight$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 40.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 00.0010.001
5Travel and Other Direct Costs$ - 00.00$ - 00.00$ - 00.00$ - 05Travel and Other Direct Costs$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 5$ - 0$ - 00.0010.001
Combined Total$ - 00.00$ - 00.00$ - 00.00$ - 0$ - 0Combined Total$ - 0- 0$ - 0- 0$ - 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0TOTALS- 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 00.0010.001
Project 1:Project 1CLIN Summary with Fixed FeeWithholding of Fixed FeeProject 1:Project 1CLIN Summary - Cash BasisFixed Fee AccumulationWithholding of Fixed Fee AccumulationProject 1Project 1Project 1
CLINCLIN DescriptionT.O. Dollars Accrued Previously *T.O. Hours Billed PreviouslyT.O. Dollars Accrued This Period *T.O. Hours Billed This PeriodT.O. Dollars Accrued to Date *T.O. Hours Billed to DateTO Withholding Billed to DateTO Billed to Date with Fixed Fee (less Withholding to date)CLINCLIN DescriptionT.O. Dollars Billed PreviouslyT.O. Hours Billed PreviouslyT.O. Dollars Billed This PeriodT.O. Hours Billed This PeriodT.O. Dollars Billed to DateT.O. Hours Billed to DateFF Previously Earned To DateFF Earned This PeriodFF Earned To DateT.O. Previously Withheld To DateT.O. Dollars Withheld This PeriodT.O. Dollars Withheld To DateCLINLOE (Hours)LOE for Fixed Fee (Hours)LaborG&AOverheadFringeSubtotalBilled Fixed FeeWithholding of Fixed FeeFee Withholding AdjustmentFCCMNet InvoiceChange in (Billed)/Unbilled Fixed FeePreviously UnbilledCurrent UnbilledConsultant Hours
(Reconciling Fee Hours)Unbilled LOE for Fixed Fee HoursPreviously Unbilled FeeCurrent Unbilled FeeUnbilled LOE for Fixed Fee Dollars
1Program Support and Lessons Learned$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 01Program Support and Lessons Learned$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 10.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 0
2On-Site Monitoring and Reporting$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 02On-Site Monitoring and Reporting$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 20.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 0
3Baseline Oversight$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 03Baseline Oversight$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 30.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 0
4Optional Oversight$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 04Optional Oversight$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0CLIN 40.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 0
5Travel and Other Direct Costs$ - 0$ - 0$ - 0$ - 05Travel and Other Direct Costs$ - 0$ - 0$ - 0CLIN 5$ - 0$ - 0
Project Total$ - 00.00$ - 00.00$ - 0- 0$ - 0$ - 0Project Total$ - 00.00$ - 0- 0$ - 0- 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0TOTALS0.000.00$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 00.000.000.000.00$ - 0$ - 0$ - 0

Accumulated Fixed Fee

Fee Summary Not-to-Exceed (Allotted to Fee) Billed Previously Billed This Period Billed to Date Balance Remaining Billed To Date (%)

Level of Effort Fee$ - 0$0.00$ - 0$ - 0$ - 0
Withholding of Fixed Fee$ - 0$0.00$ - 0$ - 0$ - 0
Fee Less Withholding$ - 0$0.00$ - 0$ - 0$ - 00.00%

Current Invoice: 1

Invoice NumberDescriptionLOE Billed (Hours)LOE for Fixed Fee Billed (Prime & Subs)Consultant Hours (Reconciling Fee Hours)Change in (Billed)/Unbilled Fixed Fee (excludes fixed fee withhold)Billed Fixed FeeWithholding of Fixed FeeFee Withholding AdjustmentUnbilled Hours by PrimeNet Invoice Total
1ERROR:#REF!0.000.00$ - 0$ - 0$ - 0$ - 0ERROR:#REF!$ - 0
TotalERROR:#REF!0.000.00$ - 0$ - 0$ - 0$ - 0ERROR:#REF!$ - 0

Update Current Invoice Information

Drawdown

B Table Appropriation - Consumption of Funds
Task Order NTEAccrued to DateB REMAINING% Billed to Date
AwardCLINLabor HoursCPFFT.O. Hours Billed to DateT.O. Dollars Accrued to Date *Labor HoursCPFFLabor HoursCPFF
B TOTAL10$ - 00.00$ - 00.00$ - 00%0%
B TOTAL20$ - 00.00$ - 00.00$ - 00%0%
B TOTAL30$ - 00.00$ - 00.00$ - 00%0%
B TOTAL40$ - 00.00$ - 00.00$ - 00%0%
B TOTAL50$ - 00.00$ - 00.00$ - 00%0%
TOTALALL CLINS0$ - 00.00$ - 00.00$ - 00%0%
H.2 Table Obligations - Consumption of Funds
Task Order AuthorizedAccrued to DateH.2 REMAINING% Billed to Date
AwardCLINLabor HoursCPFFT.O. Hours Billed to DateT.O. Dollars Accrued to Date *Labor HoursCPFFLabor HoursCPFF
H.2 TOTAL10$ - 00.00$ - 00.00$ - 00%0%
H.2 TOTAL20$ - 00.00$ - 00.00$ - 00%0%
H.2 TOTAL30$ - 00.00$ - 00.00$ - 00%0%
H.2 TOTAL40$ - 00.00$ - 00.00$ - 00%0%
H.2 TOTAL50$ - 00.00$ - 00.00$ - 00%0%
TOTALALL CLINS0$ - 00.00$ - 00.00$ - 00%0%

Deliverable Schedule

Enter Yellow Highlighted columns first Orange columns are dropdown selections Green columns are populated automatically

ProjectCLINTask NameOP ResponsibilityTask Start DateTask End DateDue DateReport Submittal DateDays Since SubmittedApproval DateFTA approverStatusNotes
01/31/000

Add Row at Bottom of Table Delete Selected Row Add Row Above Selected

Standard Form 1034VOUCHER NO.
Revised October 1987 Department of the TreasuryPUBLIC VOUCHER FOR PURCHASES AND
1 TFM 4-2000
1034-119-01SERVICES OTHER THAN PERSONAL1
U.S. DEPARTMENT, BUREAU, OR ESTABLISHMENT AND LOCATIONDATE VOUCHER PREPAREDSCHEDULE NO.:
12/31/99
Federal Transit AdministrationCONTRACT NUMBER AND DATEPAID BY:
Accounting Division TBP-50001/00/1900 - 01/00/1900
1200 New Jersey Ave, SEREQUISTION NUMBER AND DATE
Washington, DC, 20590
PAYEE:0DATE INVOICE RECEIVED:
PAYEE ADDRESS:0
0DISCOUNT TERMS:
PAYEE CONTACT NAME:0
PAYEE PAYMENT INFORMATION:PAYEE ACCOUNT NUMBER:
0
SHIPPED FROMTO WEIGHT(4)GOVERNMENT B/L NUMBER
NUMBER AND
DATE OF ORDERDATE OF

DELIVERY

OR SERVICEARTICLES OR SERVICES
(Enter description, item number of contract or Federal supply schedule, and other information deemed necessary)QUANTITYUNIT PRICEAMOUNT
COSTPER(1)
Task Order Number01/00/1900 - 01/00/1900For details see attached pages$ - 0
0
Task Order DescriptionCOST REIMBURSABLE-PROVISIONAL PAYMENT-INTERIM VOUCHER (OR COMPLETION VOUCHER, OR FINAL VOUCHER) AS APPLICABLE

“I certify that all payments requested are for appropriate purposes and in accordance with the agreements set forth in the contract.”

Invoice Date:Region:
12/31/990Type Name & Signature of OfficialTitleDate
(Use continuation sheet(s) if necessary)(Payee must NOT use the space below)TOTAL$ - 0
Payment:APPROVED FOREXCHANGE RATE
=$=$1.00Differences
BY
AMOUNT VERIFIED CORRECT PER
TITLE(Signature or initials)

Pursuant to authority vested in me, I certify that this voucher is correct and proper for payment.

(Date)(Authorizing Certifying Officer)3(Title)
ACCOUNTING CLASSIFICATION

Paid By CHECK NO. ON ACCOUNT OF US TREASURY CHECK NUMBER ON (NAME OF BANK)

CASHDATEPAYEE3
$
1. When stated in foreign currency, insert name of currency.PER
2. If the ability to certify and authority to approve are combined in one person, one signature only is necessary. Otherwise, the approving officer will sign in the space provided over his actual title.

3. When a voucher is received in the name of a company or corporation, the name of the person writing the company or corporate name, as well as the capacity in which he signs, must appear. For example: "John Doe Company, per John Smith, "Secretary," or "Treasurer," as the case may be. TITLE

Previous edition usableNSN 7540-00-900-2234
PRIVACY ACT STATEMENT
The information requested on this form is required under the provisions of 31 U.S.C. 82b and 82c, for the purpose of disbursing Federal money. The information
requested is to identify the particular creditor and the amounts to be paid. Failure to furnish this information will hinder discharge of the payment obligation.

Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Provisional Complete Partial Progress Advance Provisional Complete Partial Final

Sum of Exp

0
SUMMARY OF EXPENDITURES
SUPPORT OF REIMBURSEMENT CLAIM
Expenditure CategoryCurrent Contract BudgetAmount Claimed PreviouslyAmount Claimed This PeriodCumulative Total
Direct Labor$ - 0$ - 0$ - 0$ - 0
Premium Pay$ - 0$ - 0$ - 0$ - 0
Fringe Benefits$ - 0$ - 0$ - 0$ - 0
Materials/Supplies$ - 0$ - 0$ - 0$ - 0
Staff Travel$ - 0$ - 0$ - 0
Consultant Travel$ - 0$ - 0$ - 0$ - 0
Consultant Fees$ - 0$ - 0$ - 0$ - 0
Subcontract$ - 0$ - 0$ - 0$ - 0
Equipment$ - 0$ - 0$ - 0$ - 0
Other Direct$ - 0$ - 0$ - 0$ - 0
Overhead$ - 0$ - 0$ - 0$ - 0
Total Est. Cost$ - 0$ - 0$ - 0$ - 0
G&A$ - 0$ - 0$ - 0$ - 0
Total Costs$ - 0$ - 0$ - 0$ - 0
Fee$ - 0$ - 0$ - 0$ - 0
Fee Withholding$ - 0$ - 0
FCCM$ - 0$ - 0$ - 0$ - 0
Total$ - 0$ - 0$ - 0$ - 0

The Undersigned certifies that the cost of services reimbursable to the Contractor and the amount of fees earned by the Contractor up to the date of this certificate are not more than the total costs incurred and/or paid as claimed by the Contractor under the contract (including the payment claimed herewith) and that the Contractor to the best of his knowledge and belief has fully complied with the terms and conditions of the contract.

(Typed Name of Certifying Official) (Signature)

(Title) (Date)

DOC

Contractor’s Declaration of Completion

This notice is given in support of the request to invoice for the *Direct Productive Labor Hours (DPLH) for work completed under Task Order . The voucher represents reimbursable costs for the billing period from through . Direct Labor consists of salaries and wages paid (or Billed Previously) for direct performance of the contract itemized as follows:
Direct Labor consists of salaries and wages paid (or Billed Previously) for direct performance of the contract itemized as follows: Labor Hours | Rate | Total Dollars | Cumulative Category Hours Billed.
SUPPORTING INFORMATION:
Cost Elements
1)Direct Labor
Labor CategoryStaff AssignedHours BilledRateTotalCumulative Category Hours Billed
$ - 0
$ - 0
$ - 0
$ - 0
Total- 0$ - 0

2) Consultants' Fee $ - 0

3)General and Administrative (G&A) ExpenseTotal G&A Expense$ - 0
Prime - G&A XXX.XX% of Total Direct Costs =$ - 0
Sub - G&A XXX.XX% of Total Direct Costs =$ - 0
Sub - G&A XXX.XX% of Total Direct Costs =$ - 0
Sub - G&A XXX.XX% of Total Direct Costs =$ - 0
4)Overhead ExpenseTotal Overhead Expense$ - 0
Prime - Overhead XXX.XX% of Total Direct Costs =$ - 0
Sub - Overhead XXX.XX% of Total Direct Costs =$ - 0
Sub - Overhead XXX.XX% of Total Direct Costs =$ - 0
Sub - Overhead XXX.XX% of Total Direct Costs =$ - 0
5)Fringe ExpenseTotal Fringe Expense$ - 0
Prime - Fringe XXX.XX% of Total Direct Costs =$ - 0
Sub - Fringe XXX.XX% of Total Direct Costs =$ - 0
Sub - Fringe XXX.XX% of Total Direct Costs =$ - 0
Sub - Fringe XXX.XX% of Total Direct Costs =$ - 0
Subtotal (before FCCM)$ - 0
6)FCCM Expense$ - 0
7)Fixed Fee (8.5%)ERROR:#N/A
Fixed Fee WithholdingERROR:#N/A
Fixed-Fee Calculations:
i. Total contract fixed-fee$ - 0
ii. 85% allowable fee$ - 0
iii. Total Cumulative fee billed on prior invoices$ - 0
iv. Fee due this invoice (not to exceed 85% of fee earned )
Total Fee Less WithholdingERROR:#N/A
Total DOC Claim AmountERROR:#N/A
“I hereby certify that the above Declaration of Completion is correct and just, that payment therefore has not been received, and that the information is presented with the knowledge that the amount requested is passable to invoice the United States Government for payment."

Authorized Signature Name (Please Print)

Email Number/Extension

Validation Tables

DO NOT LOCK THIS WORKSHEETABCDEFGHIJKLMNOPQRSTUVWXYZ
CLINCLINCLINCLINCLINerin
CLIN 1CLIN 2CLIN 3CLIN 4CLIN 5
Trip#/ODCTrip#/ODCTrip#/ODCTrip#/ODCTrip#/ODCTrip#/ODCTrip#/ODCTrip#/ODCTrip#/ODCTrip#/ODCTrip#/ODC
Non-Travel ODCs12345678910

Default Directory: C:\Users\Aaron\OneDrive - EBI Management Group, Inc\Desktop

StatesDescFIRMFirm AcronymsAddByLCATUnique_Sorted-
ALAlabamaADS SYSTEM SAFETY CONSULTING, LLCADSEBIBuy America Expert I
AKAlaskaALBERT RISK MANAGEMENT CONSULTANTARMCEBIBuy America Expert II
ASAmerican SamoaANIL VERMA ASSOCIATES INCAVAEBICivil/Environmental Eng I
AZArizonaAPTIM FEDERAL SERVICES, LLCAFSEBICivil/Environmental Eng II
ARArkansasARCADISARCEBIClerical Support
CACaliforniaATKINS NORTH AMERICA INCATKEBICommunications Eng I
COColoradoATN & ASSOCIATESATNPMOCCommunications Eng II
CTConnecticutB&GBAGEBIContract Procurement Manager
DEDelawareBOWMAN ENGINEERING AND CONSULTINGBECEBICost Estimator Manager
DCDist. of ColumbiaBOYD CATON GROUP, INC.BCGEBIElectrical/Power Distribution Eng I
FLFloridaBURNS ENGINEERING INCBURNEBIElectrical/Power Distribution Eng II
GAGeorgiaBURTON ENGINEERING, INC.BURPMOCMechanical Engineer
GUGuamCAPITAL GCSCGCSEBIProgram Manager
HIHawaiiCDM SMITHCDMEBIProject Scheduling Manager
IDIdahoCEDARVILLE ENGINEERING GROUP, INC.CEGEBIQA/QC Manager
ILIllinoisCLIFTON WEISS & ASSOCIATES, INC.CWAEBIRail Transit Signal/Control Systems Eng I
INIndianaCORNERSTONE CONCILIUM, INC.CCIEBIRail Transit Signal/Control Systems Eng II
IAIowaCTC, INC.CTCEBIReal Estate Manager
KSKansasDAVID EVANS AND ASSOCIATES INCDEAEBIRisk Assessment Mgr I
KYKentuckyDAVID SILLARS CONSULTINGDSCEBIRisk Assessment Mgr II
LALouisianaDELOITTEDELEBIStructural Engineer I
MEMaineDELON HAMPTON & ASSOCIATES CHARTEREDDHAEBIStructural Engineer II
MDMarylandDIVERSITY MATTERS 2 USDMUEBISystems Integr. Engr I
MHMarshall IslandsDKH CONSULTINGDKHEBISystems Integr. Engr II
MAMassachusettsDOVETAIL CONSULTING GROUP, LLCDOVEBISystems Safety Manager
MIMichiganDQP ENTERPRISES, INC.DQPEBITask Order Manager I
FMMicronesiaDRM INTERNATIONAL, INC.DRMEBITask Order Manager II
MNMinnesotaELCON ASSOCIATES, INC.EAIEBITransit Operations Manager
MSMississippiENVISION CONSULTANTS LTDENVIEBIVehicle Engineer
MOMissouriGANNETT FLEMING INCGFIEBI
MTMontanaGARG CONSULTING SERVICES, INC.GCSEBI
NENebraskaGOLDER ASSOCIATES, INC.GAIEBI
NVNevadaH.C. PECK & ASSOCIATES, INC.HCPAEBI
NHNew HampshireHILL INTERNATIONAL INCHILLEBI
NJNew JerseyHNTB CORPORATIONHNTBEBI
NMNew MexicoINTERACTIVE ELEMENTS INCORPORATEDIEIEBI
NYNew YorkINTERGRATED STRATEGIC RESOURCES, LLCISREBI
NCNorth CarolinaINTUEOR CONSULTING INC.ICIEBI
NDNorth DakotaINVICTUS ENGINEERING, P.C.IEPCEBI
MPNorthern MarianasJACOBS ENGINEERING GROUP INCJACOEBI
OHOhioJBC & ASSOCIATES, INC.JBCEBI
OKOklahomaJCMS, INC.JCMSEBI
OROregonK2 CONSTRUCTION CONSULTANTS, INC.KCCEBI
PWPalauKAL KRISHNAN CONSULTING SERVICES INCKKCSEBI
PAPennsylvaniaKCI TECHNOLOGIES, INC.KCITEBI
PRPuerto RicoKEVILLE ENTERPRISES, INC.KEIEBI
RIRhode IslandKS ENGINEERING INC.KSEEBI
SCSouth CarolinaLEA+ELLIOT, INC.LEIEBI
SDSouth DakotaDONALD SCHNECK, LLC.DSNEBI
TNTennesseeLONGI ENGINEERING D.P.C.LEDEBI
TXTexasLS GALLEGOS & ASSOCIATES INCLSGEBI
UTUtahLTK CONSULTING SERVICES, INC.LTKEBI
VTVermontM. LEE CORPORATIONMLCEBI
VAVirginiaMACDONALD BEDFORD LLCMDBEBI
VIVirgin IslandsMANAGEMENT CONCEPT SYSTEM SERVICES, INC.MCSSEBI
WAWashingtonMCDONOUGH BOLYARD PECKMBPEBI
WVWest VirginiaMCKISSACK-LIRO JOINT VENTUREMCKEBI
WIWisconsinMCKISSACK-LIRO JOINT VENTURE (LIRO)MCKIEBI
WYWyomingMCKISSACK-LIRO JOINT VENTURE (MCKISSACK)MCKLEBI
MCKNIGHT INTERNATIONALMKIEBI
MOTT MACDONALD GROUP LIMITEDMOTTEBI
NAIK CONSULTING GROUP, P.C.NCGEBI
NAVIGATOR CS, LLCNCSEBI
O.R. COLAN ASSOCIATES, INC.ORCAEBI
OMNI STRATEGY LLCOMNIEBI
OVERLAND PACIFIC & CUTLER, LLCOPCEBI
PACIFIC RAILWAY ENTERPRISES, INC.PREEBI
PMA CONSULTANTS LLCPMAEBI
PMO PARTNERSHIP JV LLCPMOPEBI
PMO PARTNERSHIP JV LLC (Allen Group)PMOPAEBI
PMO PARTNERSHIP JV LLC (Brindley Pieters)PMOPBEBI
PMO PARTNERSHIP JV LLC (EAC)PMOPEEBI
RAIL PROS, INC.RPEBI
RAUL V. BRAVO & ASSOCIATES, INC.RVBEBI
SCHNABELSCHEBI
SHANNON & WILSON, INC.SWIEBI
SOL ENGINEERING SERVICES, LLCSOLEBI
SPITZER AND ASSOCIATES, INC.SAAEBI
STATESIDE RIGHT OF WAY SERVICES, LLCSRWEBI
SUMMERLIN CONTRACTINGSUMPMOC
SYSTRA CONSULTING, INC.SCIEBI
TALSON SOLUTIONS, LLCTSLEBI
THE MCKISSACK GROUP, INC.MKGEBI
TRANSIT SYSTEMS ENGINEERING, INC.TSEEBI
TRANSPORTATION RESOURCE ASSOCIATES, INC.TRAEBI
TRANSYSTEMS CORPTSYSEBI
TRIUNITY ENGINEERING & MANAGEMENT, INC.TRIEBI
URBAN ENGINEERS INCURBEBI
VANASSE HANGEN BRUSTLIN, INC.VHBEBI
VIRGINKAR & ASSOCIATES, INC.VIREBI

RESET Workbook Turn OFF Single Digit Task Orders Turn ON Single Digit Task Orders

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .