J-13_Attachment____InvoiceWorksheets_2014_PMO.xls

XLS spreadsheet 103 KB Posted Sep 30, 2013

Attached to: PROJECT MANAGEMENT OVERSIGHT SUPPORT SERVICES Federal contract opportunity
Solicitation number: DTFT60-13-R-00003
Issued by: Department of Transportation Federal Transit Administration

About this file

From the source

J-13 INVOICE WORKSHEETS

View the file

Other files for this federal contract opportunity

Other files attached to PROJECT MANAGEMENT OVERSIGHT SUPPORT SERVICES, newest first.
File	Type	Posted
DTFT60-13-R-00003_Amendment_005.pdf	PDF	Dec 6, 2013
PMO_Acquisition_Pre-Proposal_Conference_Report__REV_12_5_2013.pdf	PDF	Dec 6, 2013
J_1_PROPOSAL_CHECKLIST_Rev___PMO___REV__12-5-13.pdf	PDF	Dec 5, 2013
J_8_Attachment_Fully_Loaded_Rate.xlsx	XLSX spreadsheet	Dec 5, 2013
RFP_PMO_2014_qA_12-5-13.pdf	PDF	Dec 5, 2013
PMO_Acquisition_Pre-Proposal_Conference_Report.pdf	PDF	Dec 5, 2013
J_4_Attachment_FTA_Subcontracting_Plan.pdf	PDF	Dec 5, 2013
J-7_2014_PMO_Contract_Pricing_Summary_Templates.xlsx	XLSX spreadsheet	Dec 5, 2013
DTFT60-13-R-00003_Amendment_004.pdf	PDF	Dec 5, 2013
J_8__Attachment_Final___Fully_Loaded_Rate___2014_PMO.xls	XLS spreadsheet	Nov 18, 2013
SF30_Amendment_003.pdf	PDF	Nov 18, 2013
SF30_AMENDMENT_002.pdf	PDF	Nov 17, 2013
J-7__Attachment_Form____2014_Procurement_Contract_Pricing_Summary_IDIQ___estimate_of_60k(1).xls___REV_11_14_2013.xls	XLS spreadsheet	Nov 15, 2013
J_8__Attachment___Fully_Loaded_Rate___2014_PMO.xls	XLS spreadsheet	Nov 15, 2013
J_3_Attachment__Past_Performance_Questionnaire_PMO_2014 1 .docx___REV_11_14_2013.pdf	PDF	Nov 15, 2013
J-10_Attachment_Oversight_Procedures.pdf_REV__11_14_2013.pdf	PDF	Nov 15, 2013
REV_PMO_2014_Admendment___002___REV_11_15.pdf	PDF	Nov 15, 2013
J_2_Attachment___Personnel_Resume_Format 1 .docx__REV__11_14_2013.pdf	PDF	Nov 15, 2013
J_4_Attachment___FTA_Subcontracting_Plan___Rev_11_14_2013.pdf	PDF	Nov 15, 2013
J_1_PROPOSAL_CHECKLIST_Rev___PMO 1 .docx___REV__11_14_2013.pdf	PDF	Nov 15, 2013
Amendment_001.pdf	PDF	Oct 23, 2013
J-6_Attachment___Modified_Pre-Award_Survey_SF1408_Checklist_.pdf	PDF	Sep 30, 2013
J_1_PROPOSAL_CHECKLIST_Rev___PMO.pdf	PDF	Sep 30, 2013
J_4_Attachment___FTA_Subcontracting_Plan___Rev_PMO_2014.pdf	PDF	Sep 30, 2013
J-5_Attachment___Labor_Category_Table.pdf	PDF	Sep 30, 2013
J_2_Attachment___Personnel_Resume_Format.pdf	PDF	Sep 30, 2013
J-12_Attachment____BILLING_INSTRUCTIONS.pdf	PDF	Sep 30, 2013
J-11_Attachment___2014_PMOC__Conflict_of_Interest_Matrix____OIC_Chart.xlsx	XLSX spreadsheet	Sep 30, 2013
J_8__Attachment___Fully_Loaded_Rate___2014_PMO.xls	XLS spreadsheet	Sep 30, 2013
J_3_Attachment__Past_Performance_Questionnaire_PMO_2014.pdf	PDF	Sep 30, 2013
J_9_Attachment___Disclosure_of_Lobbying_Activities.pdf	PDF	Sep 30, 2013
RFP_PMO_2014____DTFT60-13-R-00003.pdf	PDF	Sep 30, 2013
J-7__Attachment_Form____2014_Procurement_Contract_Pricing_Summary_IDIQ___estimate_of_60k.xls	XLS spreadsheet	Sep 30, 2013
J-10_Attachment___Oversight_Procedures_FY_2014.pdf	PDF	Sep 30, 2013

Show all 34

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.

Invoice Overview

INVOICE OVERVIEW
Contractor:		XYZ Co.
Address:		2304 Maple St. San Francisco, CA 900…
Taxpayer I.D. Number:		2339408
Bank info for deposit:		Citibank account……324999999
Invoice Contact:		J. Smith, 415-999-9999, jsmith@xyz.net
PMO CONTRACT No.:		DTFT60-04-D-0000X
FTA CO:		J.W. Brown
FTA COR:		A. B. Kim
Invoice period of performance:		March 1 – March 31, 2014
Invoice No.		12
Invoice Date:		04/05/14
Task Order Number	Task Order Description		Project Number	Task Order Expiration Date	FTA Task Order Manager		Initial / Date Invoice Approved
1	Perris Valley (Regional)		DC-03-XXXX	2/13/13	M. Jones
Work Order Number	Work Order Description			FTA Work Order Manager	Hours Billed this Invoice	Billed this Invoice	Initial / Date Invoice Approved
1	Perris Valley - On-site Monitoring / Reporting			M. Davis	625	$94,264
2	Perris Valley - Readiness Reviews			M. Davis	100	$5,000
3	Perris Valley - Special Tasks			C. Lewis	175	$50,000
Total Billed This Period					900	$149,264
NOTE: Invoice Overview Format Applies to both Headquarter's and Regional Task Orders

&CRev. 2, March 2010

Task Order Summary

INVOICE BREAKDOWN
Contractor	XYZ Co.
Invoice No.:	12
Invoice Date:	04/05/14
Task Order Number	Task Order Description	Task Order Dollars Not-to-Exceed Authorized	Task Order Hours Not-to-Exceed Authorized	Task Order Funded to Date	Task Order Hours to Date	Work Order Authorized to Date	Work Order Hours Authorized to Date	Work Order Dollars Billed to Date	Work Order Hours Billed to Date	Funded Balance Available			Hours Balance Available	Small Business Sub-Contracting Participation
1	Perris Valley (Regional)	$1,000,000	56400	$650,000	43000	$420,000	2100	$359,264	1475	$230,000			40900	Billed to Date
														23%
Work Order Number	Work Order Description	Not-to-Exceed Dollars Authorized	Not-to-Exceed Hours Authorized	Dollars Billed Previously	Hours Billed Previously	Dollars Billed This Period	Hours Billed This Period	Total Dollars Billed to Date	Total Hours Billed to Date	Fund Balance Remaining	Fund Balance Remaining	Funds Billed To Date (%)	Hours Billed To Date (%)	SB	SB	SB
														Billed Previously	Billed this Period	Billed to Date
1	Perris Valley - On-site Monitoring / Reporting	$200,000	1000	$80,000	275	$94,264	625	$174,264	900	$25,736	100	87%	90%	$16,000	$4,900	$20,900
2	Perris Valley - Readiness Reviews	$160,000	800	$120,000	200	$5,000	100	$125,000	300	$35,000	500	78%	38%	$30,000	$500	$30,500
3	Perris Valley - Special Tasks	$60,000	300	$10,000	100	$50,000	175	$60,000	275	$0	25	100%	92%	$2,000	$10,000	$12,000
Total		$420,000	2100	$210,000	575	$149,264	900	$359,264	1475	$60,736	625	86%	70%	$48,000	$15,400	$63,400

&RRev. 2, March 2010

Work Order Detail

	COST BREAKDOWN
	NOTE: This format can be used for Work Order cost proposals, invoices, and independent government estimates.
	Contractor:	XYZ Co.
	Date:	04/05/14
	Task Order:	1
	Work Order:	1
	WO Descr:	Sample Project
	G&A	Applies to PMOC labor only; does not apply to PMOC overhead or fee, subcontractor costs, or expenses.					5.00%
	Overhead	PRIME OVERHEAD RATE						130.00%
	Fee	Applies to PMOC labor, PMOC overhead, and G & A only.								8.00%
	SUB CLIN Number and Name		PERSONNEL	HOURS	HOURLY RATE (Fully Loaded Rate for CLIN 4)	LABOR	G&A	PRIME OVERHEAD	LABOR + OVERHEAD +G&A	Fee on LABOR + OH + G&A	TOTAL with fee	Small Business Sub-contracting Participation
	1A
Special Tasks	Name, Firm, Title per contract	40.0	$85.00	$3,400	$170	$4,420	$7,990	$639
			Name, Firm, Title per contract	80.0	$75.00	$6,000	$300	$7,800	$14,100	$1,128
			Name, Firm, Title per contract	0.0	$65.00	$0	$0	$0	$0	$0
			Name, Firm, Title per contract	0.0	$55.00	$0	$0	$0	$0	$0
			Name, Firm, Title per contract	0.0	$50.00	$0	$0	$0	$0	$0
			Name, Firm, Title per contract	20.0	$30.00	$600	$30	$780	$1,410	$113
			Prime Totals	140.0		$10,000			$23,500	$1,880	$25,380
			Sub 1 - Name, Title	70.0
			Sub 1 - Name, Title	50.0
			Sub 2 - Name, Title	60.0
			Subcontractor Totals	180.0							$11,433
			Total for this Product								$36,813
	2B
On-site Monitoring and Reporting	Name, Firm, Title per contract	10.0	$85.00	$850	$43	$1,105	$1,998	$160
			Name, Firm, Title per contract	20.0	$75.00	$1,500	$75	$1,950	$3,525	$282
			Name, Firm, Title per contract	20.0	$65.00	$1,300	$65	$1,690	$3,055	$244
			Name, Firm, Title per contract	10.0	$55.00	$550	$28	$715	$1,293	$103
			Name, Firm, Title per contract	40.0	$50.00	$2,000	$100	$2,600	$4,700	$376
			Name, Firm, Title per contract	10.0	$30.00	$300	$15	$390	$705	$56
			Prime Totals	110.0		$6,500			$15,275	$1,222	$16,497
			Sub 1 - Name, Title	40.0
			Sub 1 - Name, Title	40.0
			Sub 2 - Name, Title	50.0
			Subcontractor Totals	130.0							$16,304
			Total for this Product								$32,801
	4A

Other Reports, Reviews,

and Plans	Name, Firm, Title per contract	10.0	$185.00	$1,850
			Name, Firm, Title per contract	20.0	$175.00	$3,500
			Name, Firm, Title per contract	20.0	$165.00	$3,300
			Name, Firm, Title per contract	20.0	$165.00	$3,300
			Total for this Product	70.0		$11,950		$11,950
	5A Travel Expenses/ Other Direct Expenses	city 1 - city 2	Staff	2	Trips at	$1,000	$2,000
			Subcontractor	2	Trips at	$1,000	$2,000
		city 3 - city 2	Staff	2	Trips at	$2,000	$4,000
			Subcontractor	2	Trips at	$2,000	$4,000
		Total Travel Expenses						$12,000
			Staff	printing, phone charges			$500
			Subcontractor	printing, phone charges			$200
		Total Other Direct Expenses						$700
	% SB Participation
	Total Proposed							$94,264

&CRev. 2, March 2010

Work Order Detail Sub 1

	SUBCONTRACTOR COST BREAKDOWN
	NOTE: This format can be used for Work Order cost proposals, invoices, and independent government estimates.
	Subcontractor:	Sub 1
	Date:	04/05/14
	Task Order:	1
	Work Order:	1
	WO Descr:	Sample Project
	G&A	Applies to PMOC labor only; does not apply to PMOC overhead or fee, subcontractor costs, or expenses.					0.00%
	Overhead	PRIME OVERHEAD RATE						125.00%
	Fee	Applies to PMOC labor, PMOC overhead, and G & A only.								8.00%
	SUB CLIN Number and Name		PERSONNEL	HOURS	HOURLY RATE	LABOR	G&A	Sub 2 OVERHEAD	LABOR + OVERHEAD +G&A	Fee on LABOR + OH + G&A	TOTAL with fee
	1A
Special Tasks	Name, Firm, Title per contract	30.0	$70.00	$2,100	$0	$2,625	$4,725	$378
			Name, Firm, Title per contract	20.0	$50.00	$1,000	$0	$1,250	$2,250	$180
			Sub Labor	50.0		$3,100			$6,975	$558	$7,533
	2B
On-site Monitoring and Reporting	Name, Firm, Title per contract	40.0	$70.00	$2,800	$0	$3,500	$6,300	$504
			Name, Firm, Title per contract	0.0	$50.00	$0	$0	$0	$0	$0
			Sub Labor	40.0		$2,800			$6,300	$504	$6,804
	4A Other Reports, Reviews,
and Plans	Name, Firm, Title per contract	20.0	$70.00	$1,400
			Name, Firm, Title per contract	0.0	$50.00	$0
			Sub Labor	20.0		$1,400					$1,400
	5A Travel Expenses/ Other Direct Expenses	city 1 - city 2	Subcontractor 1	2	Trips at	$1,000			$2,000
		city 3 - city 2	Subcontractor 1	2	Trips at	$2,000			$4,000
			Total Travel Expenses								$6,000
		city 1 - city 2	Subcontractor 1	2	Trips at	$1,000			$2,000
		city 3 - city 2	Subcontractor 1	2	Trips at	$2,000			$4,000
			Total Travel Expenses								$6,000
			Subcontractor	printing, phone charges					$100
			Total Other Direct Expenses								$100
	Total Billed This Period										$27,837

&CRev. 2, March 2010

Work Order Detail Sub 2

	SUBCONTRACTOR COST BREAKDOWN
	NOTE: This format can be used for Work Order cost proposals, invoices, and independent government estimates.
	Subcontractor:	Sub 2
	Date:	04/05/14
	Task Order:	1
	Work Order:	1
	WO Description:	Sample Project
	G&A	Applies to PMOC labor only; does not apply to PMOC overhead or fee, subcontractor costs, or expenses.					0.00%
	Overhead	PRIME OVERHEAD RATE						0.00%
	Fee	Applies to PMOC labor, PMOC overhead, and G & A only.								0.00%
	SUB CLIN Number and Name		PERSONNEL	HOURS	HOURLY RATE	LABOR	G&A	Sub 2 OVERHEAD	LABOR + OVERHEAD +G&A	Fee on LABOR + OH + G&A	TOTAL with fee
	1A
Special Tasks	Name, Firm, Title per contract	30.0	$190.00	$5,700	$0	$0	$5,700	$0
			Name, Firm, Title per contract	20.0	$50.00	$1,000	$0	$0	$1,000	$0
			Sub Labor	50.0		$6,700			$6,700	$0	$6,700
	2B

On-site Monitoring and

Reporting	Name, Firm, Title per contract	50.0	$190.00	$9,500	$0	$0	$9,500	$0
			Name, Firm, Title per contract	0.0	$50.00	$0	$0	$0	$0	$0
			Sub Labor	50.0		$9,500			$9,500	$0	$9,500
	4A

Other Reports, Reviews,

and Plans	Name, Firm, Title per contract	20.0	$70.00	$1,400
			Name, Firm, Title per contract	0.0	$50.00	$0
			Sub Labor	20.0		$1,400		$1,400
	5A Travel Expenses/ Other Direct Expenses	city 1 - city 2	Subcontractor 2	0	Trips at	$1,000	$0
		city 3 - city 2	Subcontractor 2	0	Trips at	$2,000	$0
			Total Travel Expenses					$0
			Subcontractor	printing, phone charges			$100
			Total Other Direct Expenses					$100
	Total Billed This Period							$17,700

&CRev. 2, March 2010

CLIN Summary

COST BREAKDOWN BY CLIN AND SUBCLIN
Contractor:	XYZ Co.
Invoice No.	12
Invoice Date:	04/05/14
CLIN	CLIN Description	T.O. Dollars Billed Previously	T.O. Hours Billed Previously	T.O. Dollars Billed This Period	T.O. Hours Billed This Period	T.O. Dollars Billed To Date	T.O. Hours Billed To Date
	TOTAL	$320,000	575	$150,000	900	$470,000	1475
1	Contract and Program Support	$120,000	275	$5,000	625	$125,000	900
0001A	Special Tasks	$120,000	275	$5,000	625	$125,000	900
2	Project Management Review Services	$80,000	200	$90,000	100	$170,000	300
0002A	Project Management Reviews
0002B	On-Site Monitoring and Reporting	$80,000	200	$90,000	100	$170,000	300
3	Technical Review Services	$120,000	100	$5,000	175	$125,000	275
0003A	Scope, Cost, Schedule Characterization Reviews
0002B	Vehicle Reviews
0003C	Risk and Contingency Reviews
0003D	Readiness Reviews	$120,000	100	$5,000	175	$125,000	275
0003E	Small Starts Reviews
0003F	Special Project Reviews
4	Other Reports, Reviews, and Plans	$0	0	$0	0	$0	0
0004A	Other Reports, Reviews, and Plans
5	Other Direct Costs	$0	0	$50,000	0	$50,000	0
0005A	Travel Expenses / Other Direct Expenses			$50,000		$50,000
G & A can apply to PMOC labor and overhead; does not apply to PMOC fee, subcontractor costs or expenses.						$0	0

&CRev. 2, March 2010

File details come from the government source that posted it. Updated Nov 14, 2017.