Attachment__J.9_FLS_TO_Cost_&_Fee_Invoice.xlsx

XLSX spreadsheet 56 KB Posted Nov 3, 2017

Attached to: Fire Life Safety Engineering and Consulting Services
Solicitation number: DTRT5717R20007
Issued by: Department of Transportation Immediate Office of the Secretary Transportation

About this file

From the source

Attachment J.9 Cost & Fee Invoice Template for solicitation 6913G618R200007.

View the file

Other files

File	Type	Posted
Amendment_A000006.pdf	PDF	Dec 6, 2017
Amendment_A000005.pdf	PDF	Nov 20, 2017
FLS_Attendance.xlsx	XLSX spreadsheet	Nov 16, 2017
FLS__6193G618R200001_Amendment_0001.pdf	PDF	Nov 7, 2017
Attachment_J.10_FLS_TAR.xls	XLS spreadsheet	Nov 3, 2017
6913G618R200001_Solictation_11-3-17.pdf	PDF	Nov 3, 2017
Attachment_J_6_FLS_Schedules_1-10.xlsx	XLSX spreadsheet	Nov 3, 2017

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.

1. T01 Cost Invoice

TO#______ COST INVOICE SUM *Enter mm/yy invoice is for

Prime Contract Number: __________________________ Invoice Date: *Enter date invoice is submitted

Contractor name: COST Funding Source#: Invoice No. *Enter Invoice #

Task	Program IAA	Project	Task	Current Invoice Amount	Cumulative Invoice Amount
				$
				$
				$
				$
				$
			TOTAL		$ - 0

&"Arial,Bold"&14T3013 May 2014 Invoice Summary

2. T01 Fee Invoice TO #______ FEE INVOICE SUMMARY *Enter mm/yy of invoice

Prime Contract Number: _______________________ Invoice Date: *Enter date invoice is submitted

Contractor name:	FEE Funding Source#:			Invoice No.	*Enter Invioce #			This is out of printable area
							Hit the negative sign above and Group these columns (HIDE)
							****Do not change the headings of any columns*******
Task	Program IAA	Project	Task	Current Invoice Amount	Cumulative Invoice Amount		Data is entered here and is fed into columns D:G
				$
				$		Prior Cum. Billed Fee to Date

deepthy.s.nair: deepthy.s.nair:

Once the month is over, paste values from Cum Billed column Prior Incurred to Date Fee deepthy.s.nair: deepthy.s.nair:

Once the month is over paste values from the "Cum.Incurred Fee" column Curr. Month Incurred Fee (frm Cost invoice) deepthy.s.nair: deepthy.s.nair:

This comes from the Cost Invoice coverpage P.Code C. Fee Funding deepthy.s.nair: deepthy.s.nair:

This info is available in the invoice under Funded value- remember to update every month	Available	FUNDING NEEDS
				$		$ 528.26	$ 621.49	$ - 0	0	$ 763.32	ERROR:#REF!
				$		$ 371.42	$ 416.24	$ - 0	ERROR:#REF!	$ 2,648.00	ERROR:#REF!
				$	$ - 0	$ 5,322.33	$ 6,261.56	$ - 0	ERROR:#REF!	$ 6,267.43	ERROR:#REF!
			TOTAL		$ - 0	$ 1,786.77	$ 1,786.77	$ - 0	ERROR:#REF!	$ 2,800.00	ERROR:#REF!
						$ 715.82	$ 819.11	$ - 0	ERROR:#REF!	$ 1,678.40	ERROR:#REF!
						$ 41.82	$ 41.82	$ - 0	ERROR:#REF!	$ 225.00	ERROR:#REF!
						$ 1,734.01	$ 1,985.73	$ - 0	ERROR:#REF!	$ 3,539.26	ERROR:#REF!
						$ 168.84	$ 168.84	$ - 0	ERROR:#REF!	$ 5,876.00	ERROR:#REF!
						$ 303.88	$ 357.51	$ - 0	ERROR:#REF!	$ 459.68	ERROR:#REF!
						$ 851.02	$ 898.00	$ - 0	ERROR:#REF!	$ 1,639.79	ERROR:#REF!
						$ 12,662.88	$ 14,571.96	$ - 0	ERROR:#REF!	$ 14,961.00	ERROR:#REF!
						$ 133.54	$ 136.67	$ - 0	ERROR:#REF!	$ 1,457.00	ERROR:#REF!
						$ 4,306.82		$ - 0	ERROR:#REF!	$ 5,250.00	ERROR:#REF!
						$ 9,385.09	$ 10,679.17	$ - 0	ERROR:#REF!	$ 9,840.83	ERROR:#REF!
						$ 750.00	$ 806.04	$ - 0	ERROR:#REF!	$ 11,946.00	ERROR:#REF!
						$ 89.45	$ 105.24	$ - 0	ERROR:#REF!	$ 105.91	ERROR:#REF!
						$ 262.93	$ 288.85	$ - 0	ERROR:#REF!	$ 1,551.00	ERROR:#REF!
						$ 56.81	$ 66.84	$ - 0	ERROR:#REF!	$ 69.94	ERROR:#REF!
						$ 608.76	$ 695.89	$ - 0	ERROR:#REF!	$ 2,718.36	ERROR:#REF!
						$ 581.86	$ 665.67	$ - 0	ERROR:#REF!	$ 1,161.79	ERROR:#REF!
						$ 312.74	$ 348.68	$ - 0	ERROR:#REF!	$ 599.86	ERROR:#REF!
						$ 132.37	$ 132.87	$ - 0	ERROR:#REF!	$ 1,536.00	ERROR:#REF!
						$ 379.15	$ 429.50	$ - 0	ERROR:#REF!	$ 1,995.85	ERROR:#REF!
						$ 241.54	$ 265.10	$ - 0	ERROR:#REF!	$ 846.89	ERROR:#REF!
						$ 352.08	$ 392.55	$ - 0	ERROR:#REF!	$ 788.74	ERROR:#REF!
						$ 167.26	$ 196.76	$ - 0	ERROR:#REF!	$ 310.00	ERROR:#REF!
						$ 444.71	$ 502.84	$ - 0	ERROR:#REF!	$ 4,452.34	ERROR:#REF!
						$ 35.67	$ 41.97	$ - 0	ERROR:#REF!	$ 652.00	ERROR:#REF!
						$ 408.67	$ 456.82	$ - 0	ERROR:#REF!	$ 699.56	ERROR:#REF!
						$ 69.05	$ 78.97	$ - 0	ERROR:#REF!	$ 160.00	ERROR:#REF!
						$ 355.45	$ 389.74	$ - 0	ERROR:#REF!	$ 2,358.00	ERROR:#REF!
						$ 122.63	$ 134.31	$ - 0	ERROR:#REF!	$ 135.00	ERROR:#REF!
						$ 38.27	$ 44.00	$ - 0	ERROR:#REF!	$ 65.00	ERROR:#REF!
						$ 130.80	$ 132.51	$ - 0	ERROR:#REF!	$ 1,283.00	ERROR:#REF!
						$ 86.20	$ 87.90	$ - 0	ERROR:#REF!	$ 4,411.00	ERROR:#REF!
						$ 105.44	$ 107.15	$ - 0	ERROR:#REF!	$ 733.00	ERROR:#REF!
						$ 22.88	$ 22.88	$ - 0	ERROR:#REF!	$ 290.00	ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0		$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0				ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
						$ - 0	$ - 0	$ - 0			ERROR:#REF!
								$ - 0	ERROR:#REF!		ERROR:#REF!

$ 44,067.23	$ 45,137.95	$ - 0	$ 96,274.95	ERROR:#REF!
cum	$ 45,137.95

Prior Cum. Billed Fee to Date deepthy.s.nair: deepthy.s.nair:

Once the month is over, paste values from Cum Billed column Prior Incurred to Date Fee deepthy.s.nair: deepthy.s.nair:

Once the month is over paste values from the "Cum.Incurred Fee" column Curr. Month Incurred Fee (frm Cost invoice) S.Fee Funding Available deepthy.s.nair: deepthy.s.nair:

This shoudnt be a negative number. Adjust the Incurred from Cost invoice number to keep it a positive number and create PSUs deepthy.s.nair: deepthy.s.nair:

Once the month is over, paste values from Cum Billed column deepthy.s.nair: deepthy.s.nair:

Once the month is over paste values from the "Cum.Incurred Fee" column deepthy.s.nair: deepthy.s.nair:

This comes from the Cost Invoice coverpage deepthy.s.nair: deepthy.s.nair:

This info is available in the invoice under Funded value- remember to update every month deepthy.s.nair: deepthy.s.nair:

Once the month is over, paste values from Cum Billed column deepthy.s.nair: deepthy.s.nair:

Once the month is over paste values from the "Cum.Incurred Fee" column	$ 14,003.01	$ 16,474.13	$ - 0	0	$ 17,749.68	ERROR:#REF!
							$ 24,841.04	$ 28,726.43	$ - 0	ERROR:#REF!	$ 62,192.00	ERROR:#REF!
							$ 10,287.13	$ 11,871.50	$ - 0	ERROR:#REF!	$ 13,796.57	ERROR:#REF!
							$ 1,122.55	$ 1,122.55	$ - 0	ERROR:#REF!	$ 6,892.00	ERROR:#REF!
							$ 27,967.07	$ 32,281.78	$ - 0	ERROR:#REF!	$ 39,028.60	ERROR:#REF!
									$ - 0	ERROR:#REF!	$ 5,590.00	ERROR:#REF!
							$ 55,083.07	$ 64,829.86	$ - 0	ERROR:#REF!	$ 67,699.74	ERROR:#REF!
							$ 43,027.53	$ 47,946.59	$ - 0	ERROR:#REF!	$ 82,083.00	ERROR:#REF!
							$ 6,447.88	$ 7,556.68	$ - 0	ERROR:#REF!	$ 8,363.32	ERROR:#REF!
							$ 13,428.45	$ 15,708.07	$ - 0	ERROR:#REF!	$ 24,529.21	ERROR:#REF!
							$ 16,594.74	$ 19,346.88	$ - 0	ERROR:#REF!	$ 28,654.00	ERROR:#REF!
							$ 664.30	$ 689.26	$ - 0	ERROR:#REF!	$ 3,661.00	ERROR:#REF!
									$ - 0	ERROR:#REF!	$ 20,920.00	ERROR:#REF!
							$ 148,324.80	$ 174,376.03	$ - 0	ERROR:#REF!	$ 198,299.17	ERROR:#REF!
							$ 74,603.65	$ 80,935.07	$ - 0	ERROR:#REF!	$ 122,156.00	ERROR:#REF!
							$ 1,988.90	$ 2,339.88	$ - 0	ERROR:#REF!	$ 2,462.09	ERROR:#REF!
							$ 8,311.07	$ 9,517.02	$ - 0	ERROR:#REF!	$ 20,984.00	ERROR:#REF!
							$ 1,343.85	$ 1,581.00	$ - 0	ERROR:#REF!	$ 1,626.06	ERROR:#REF!
							$ 17,173.77	$ 19,799.32	$ - 0	ERROR:#REF!	$ 43,561.64	ERROR:#REF!
							$ 69,270.57	$ 79,475.75	$ - 0	ERROR:#REF!	$ 102,303.21	ERROR:#REF!
							$ 11,068.17	$ 13,021.38	$ - 0	ERROR:#REF!	$ 13,938.14	ERROR:#REF!
							$ 11,616.44	$ 12,436.67	$ - 0	ERROR:#REF!	$ 26,814.00	ERROR:#REF!
							$ 11,134.15	$ 12,393.88	$ - 0	ERROR:#REF!	$ 28,777.15	ERROR:#REF!
							$ 5,627.62	$ 6,511.67	$ - 0	ERROR:#REF!	$ 14,661.11	ERROR:#REF!
							$ 7,541.77	$ 8,742.77	$ - 0	ERROR:#REF!	$ 12,295.26	ERROR:#REF!
							$ 1,522.99	$ 1,791.75	$ - 0	ERROR:#REF!	$ 2,113.00	ERROR:#REF!
							$ 45,422.64	$ 49,483.23	$ - 0	ERROR:#REF!	$ 60,728.66	ERROR:#REF!
							$ 6,739.61	$ 7,343.62	$ - 0	ERROR:#REF!	$ 7,102.00	ERROR:#REF!
							$ 10,300.16	$ 11,398.59	$ - 0	ERROR:#REF!	$ 16,262.44	ERROR:#REF!
							$ 2,707.22	$ 3,184.97	$ - 0	ERROR:#REF!	$ 3,717.00	ERROR:#REF!
							$ 18,164.72	$ 19,745.45	$ - 0	ERROR:#REF!	$ 28,658.00	ERROR:#REF!
							$ 1,340.42	$ 1,576.97	$ - 0	ERROR:#REF!	$ 1,635.00	ERROR:#REF!
							$ 470.35	$ 553.35	$ - 0	ERROR:#REF!	$ 710.00	ERROR:#REF!
							$ 7,205.80	$ 7,205.80	$ - 0	ERROR:#REF!	$ 13,983.00	ERROR:#REF!
							$ 3,626.98	$ 3,626.98	$ - 0	ERROR:#REF!	$ 48,067.00	ERROR:#REF!
							$ 1,288.96	$ 1,288.96	$ - 0	ERROR:#REF!	$ 7,990.00	ERROR:#REF!
							$ 1,159.40	$ 1,159.40	$ - 0	300	$ 1,212.00	ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	ERROR:#REF!		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
									$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
									$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!
							$ - 0	$ - 0	$ - 0	0		ERROR:#REF!

$ 681,420.80	$ 776,043.25	$ - 0	$ 1,161,215.05	ERROR:#REF!
Cum.	$ 776,043.25

&"Arial,Bold"&14T3013 May 2014 Fee Invoice Summary

INSTRUCTIONS

For ENGILITY only How to update and navigate through these spreadsheets?

T3013 Fee Invoice- Summarizes the Fee for Engility and Sub Invoices

T3013 Cost Invoice - Summarizes the Cost for Engility and Sub Invoices

Billed Fee -Summary of Sub and Engility Fee that is send to Wyatt at the completion of cost tables and invoice coverpages, also goes to the customer

(Once there is a new funding cite, add it to the Lookup tab along with the P.Code and you can drag down the P.Code columns in the Cost anf Fee invoice page)

	Step 1:
1	Prior to filling up the Fee invoice coverpage, the Cost Invoice cover page needs to filled in
2	Column I (hidden) in the fee invoice coverpage is pulling the "Fee incurred" from the Cost invoice coverpage via formulae
3	Columns C:F are calculated columns and no need to update anything
4	Billed Fee - This tab is linked to the Fee Invoice Coverpage and do check for accuracy, if you add, delete columns in the Fee Invoice Cover Page
	Step 2:

**	Once the invoices are received from Billing (Wyatt)
1	Enter the Invoice number for E and F invoices separately into the T4016 Fee Invoice and couble check the amounts
2	Once that is done, it is safe to let Wyatt know that E & F invoices are accurate
3	Wyatt will confirm the same through an email once the invoices are finalized - Analyst will need to update the PO numbers in the invoice at that time
4	Wyatt will then send the invoices to the customer Cc'ing the Analyst on it.

***	A 9% Fee on the total Engility Cost invoice is calculated as Engility Fee and 6.5% on the total Sub Invoice total is calculated as Sub Fee
***	15% of retainage is calculated on Fee for Engility and Sub separately
***	Billed amount is 85% of the total Fee for Egl and Sub Fee separately
	SETTING UP FOR NEXT MONTH
!!!!!!!!!!	Set up the FEE INVOICE COVERPAGE 1st BEFORE WORKING ON THE COST INVOICE COVERPAGE !!!!!!!!!!!!!
**	Set up the template for the future period- A macro is being developed to do the set up efficiently
1	Cost Invoice Coverpage:
		Curr Cost is pasted into prio cum cost
		Curr cost column is cleared after that for next month input
		when you add a funding cite, just drag the formulas down after inseting a line; Remember to update the Lookup tab with the funding cite name and project code before you drag the formulas down
2	Fee Invoice Coverpage: Column H & I is copied and pasted From Columns D & E respectively when setting up the template from prior period.
		Curr Billed Amount is pasted into Prior Billed Amount;
		Cum Incurred Amt is pasted into prior incurred amount
		when you add a funding cite, just drag the formulas down after inseting a line; Remember to update the Lookup tab with the funding cite name and project code before you drag the formulas down
3	Billed Fee Page:	This page is autopopulated based on all the formulas and updates from the Cost and Fee Invoice Coverpage

Sheet1

FA17B1LJ456	$ 7,364.00
FAY6B3LTC81	$ 5,661.00	FA17B1LJ456	$ 1,125.00
FA22A9LJ514	$ 4,978.86	FAY6B3LTC81	$ 250.00
FA22A9MJ514	$ 904.00	FAW3A5LLA85	$ 157.00
FA22AAMY055	$ 20,501.00	FA22A9LJ514	$ 2,567.14
FA22AAMY057	$ 9,655.00	FA22A9MJ514	$ 39.00
FAY6A4LLE43	$ 472.00	FA22AAMY055	$ 878.00
FAT6B2LTB69	$ 8,276.00	FA22AAMY057	$ 7,323.00
FAT6B1LJ331	$ 747.00	FAY6A4LLE43	$ 50.00
FAT6B3MY128	$ 10,637.00	FA4HA5LJ345	$ 2,515.00
FAW3A9LLD30	$ 4,148.00	FB09A1MJ881	$ 2,515.00
FAW3ABLJ635	$ 7,242.00	FAT6B2LTB69	$ 351.00
FA4HA6LJ569	$ 7,540.00	FAT6B1LJ331	$ 60.00
FA4HA6MJ659	$ 6,018.00	FAT6B3MY128	$ 446.00
FAY4C3LTC09	$ 16,090.00	FAW3A9LLD30	$ 605.00
FAY4C3MTC09	$ 1,507.00	FAW3ABLJ635	$ 304.00
FAY4C4MTE86	$ 12,492.00	FA4HA6LJ569	$ 320.00
FA4MA3LLH55	$ 6,000.00	FA4HA6MJ659	$ 270.00
FA4MA3MLH55	$ 48,699.00	VHB2MSAL02	$ 295.00
FA4MB2LJ617	$ 6,000.00	VHB2MMA26	$ 81.00
FA4MB2MJ617	$ 56,045.00	FAP3ATMJ876	$ 380.00
FA4MB3MJ896	$ 40,109.00	FAY4C3LTC09	$ 700.00
FAY6ABLTC20	$ 8,208.00	FAY4C3MTC09	$ 65.00
FA01B1LJ636	$ 9,535.00	FAY4C4MTE86	$ 525.00
FA8EADMTB64	$ 4,222.00	FA4MA3LLH55	$ 288.00
FA8EAJMTE55	$ 19,852.00	FA4MA3MLH55	$ 1,638.00
FAP3ARMY127	$ 8,265.00	FA4MB2LJ617	$ 288.00
FA63A5MJ600	$ 10,890.00	FA4MB2MJ617	$ 1,003.00
FA63A6MTE51	$ 9,052.00	FAY6ABLTC20	$ 344.00
FAI1A1LJ507	$ 40,953.00	FA01B1LJ636	$ 400.00
FAI1A1MJ507	$ 16,476.00	FA8EADMTB64	$ 180.00
FAI1A1MJ813	$ 16,566.00	FA8EAJMTE55	$ 135.00
FAY3A5LJ512	$ 7,534.00	FAP3ARMY127	$ 350.00
FAY3C6MJ903	$ 7,545.00	FA63A5MJ600	$ 460.00
FA0ZB2LLJ79	$ 50.00	FA63A6MTE51	$ 380.00
FA0ZB3LLJ80	$ 6,568.00	FAP3ATMJ875	$ 380.00
FA0ZB1LLJ85	$ 14,049.00	FAS6A5MJ199	$ 178.00
FA0ZB4MJ794	$ 1,809.00	FAI1A1LJ507	$ 738.00
FA0ZB5MJ855	$ 10,599.00	FAI1A1MJ507	$ 691.00
FA0ZB1LLJ84	$ 12,469.00	FAI1A1MJ813	$ 695.00
FA0ZB1MLJ84	$ 7,491.00	FAP3A5MJ577	$ 190.00
FA0ZB4MJ795	$ 7,103.00	FAP3APMJ873	$ 254.00
FA0ZB5MJ856	$ 23,118.00	FA8EAGMY096	$ 360.00
FA0ZB1LLJ83	$ 3,620.00	FA8EAGMVA21	$ 271.00
FA0ZB1MLJ83	$ 2,692.00	FAP3ALMJ841	$ 203.00
FA0ZB4MJ793	$ 2,744.00	FAP3ANMLJ68	$ 40.00
FB01A1MMF27	$ 9,535.00	FAY3A5LJ512	$ 326.00
FB01A2MY151	$ 15,446.00	FAY3C6MJ903	$ 315.00
FAM8A1LJ517	$ 4,647.00	FA0ZB2LLJ79	$ 9,099.00
FAM8B1MY161	$ 4,285.00	FA0ZB3LLJ80	$ 280.00
FA63C2LTC97	$ 4,222.00	FA0ZB1LLJ85	$ 590.00
FA63C2MTC97	$ 6,250.00	FA0ZB4MJ794	$ 77.00
FA63C3MTE64	$ 7,966.00	FA0ZB5MJ855	$ 405.00
FA0JZ1MJ719	$ 1,444.00	FA0ZB1LLJ84	$ 5,056.00
FA4UA8MJ378	$ 3,014.00	FA0ZB1MLJ84	$ 3,262.00
		FA0ZB4MJ795	$ 675.00
		FA0ZB5MJ856	$ 1,237.00
		FA0ZB1LLJ83	$ 153.00
		FA0ZB1MLJ83	$ 90.00
		FA0ZB5MY198	$ 315.00
		FB01A1MMF27	$ 400.00
		FB01A2MY151	$ 650.00
		FAM8A1LJ517	$ 195.00
		FAM8B1MY161	$ 180.00
		FA63C2LTC97	$ 180.00
		FA63C2MTC97	$ 195.00
		FA63C3MTE64	$ 334.00
		FA0JZ1MJ719	$ 65.00
		FAV1B1MTC52	$ 15,720.00
		FAV1B2MLL16	$ 9,432.00
		FA4UA8MJ378	$ 130.00
		FA7GA8MTC26	$ 3,144.00

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