Attachment_J.9_TO_Invoice_Cover_Sheet.xlsx

63 KB Posted

Attached to
Transportation, Planning, Measurement, Modeling, and Assessment (TPMMA)
Solicitation number
DTRT5716R20007
Issued by

About this file

From the source

Attachment J.9 TO Invoice Cover Sheet

View the file

Other files

File Type Posted
Attachment_J_6_Schedules_1-10_(Revision_4).xlsx XLSX spreadsheet
Amendment_A00006.pdf PDF
Amendment_A00005.pdf PDF
Attachment_J_6_Schedules_1-10_(Revision_3).xlsx XLSX spreadsheet
Amendment_A00004.pdf PDF
Attachment_J_6_Schedules_1-10_(Revision_2).xlsx XLSX spreadsheet
TPMMA_Amendment_A000003.pdf PDF
Attachment_J_6_Schedules_1-10_(revised).xlsx XLSX spreadsheet
TPMMA_Amendment_A000002.pdf PDF
DTRT5716R20006_A000001.pdf PDF
TPMMA_Pre-Proposal_Attendees_List_5-13-16.pdf PDF
TPMMA_Pre-Proposal_Slides_5-10-16.pdf PDF
Revised_TPMMA_Pre-Proposal_Slides_5-10-16.pdf PDF
Attachment_J_6_Schedules_1-10.xlsx XLSX spreadsheet
Attachment_J.11_TAR.xls XLS spreadsheet
DTRT5716R20007_Solicitation.pdf PDF
TPMMA_Pre-Proposal_Slides.pdf PDF
Show all 17

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
This is out of printable area
Contractor name:COSTInvoice No.*Enter Invoice #
Hit the negative sign above and Group these columns (HIDE)
******Do not change the headings of any columns***************
TaskProgram IAAProjectTaskCurrent Invoice AmountCumulative Invoice AmountEgl Fee%7.00%
$ERROR:#VALUE!ERROR:#VALUE!
$ERROR:#VALUE!
$ERROR:#VALUE!
$ERROR:#VALUE!
$ERROR:#VALUE!
TOTAL$ - 0ERROR:#VALUE!
SubContractor Cost - Prior
******Do not change the headings of any columns*****
Sub Fee%5.00%
ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 329,482.690ERROR:#REF!ERROR:#REF!
$ 574,528.65ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 237,429.97ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 22,451.03ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 645,635.54ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 1,296,597.18ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 958,931.72ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 151,133.69ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 314,161.31ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 386,937.65ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 13,785.16ERROR:#REF!ERROR:#REF!ERROR:#REF!
ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 3,487,520.64ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 1,618,701.34ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 46,797.61ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 190,340.46ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 31,620.00ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 395,986.45ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 1,589,515.07ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 260,427.59ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 248,733.47ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 247,877.53ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 130,233.40ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 174,855.45ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 35,834.95ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 989,664.54ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 146,872.38ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 227,971.89ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 63,699.38ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 394,908.94ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 31,539.41ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 11,067.00ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 144,115.95ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 72,539.64ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 25,779.26ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ 23,188.00300ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!$ - 0ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!ERROR:#REF!

ERROR:#REF! ERROR:#REF! ERROR:#REF!

&"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:FEEInvoice 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*********
TaskProgram IAAProjectTaskCurrent Invoice AmountCumulative Invoice AmountData 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 monthAvailableFUNDING NEEDS
$$ 528.26$ 621.49$ - 00$ 763.32ERROR:#REF!
$$ 371.42$ 416.24$ - 0ERROR:#REF!$ 2,648.00ERROR:#REF!
$$ - 0$ 5,322.33$ 6,261.56$ - 0ERROR:#REF!$ 6,267.43ERROR:#REF!
TOTAL$ - 0$ 1,786.77$ 1,786.77$ - 0ERROR:#REF!$ 2,800.00ERROR:#REF!
$ 715.82$ 819.11$ - 0ERROR:#REF!$ 1,678.40ERROR:#REF!
$ 41.82$ 41.82$ - 0ERROR:#REF!$ 225.00ERROR:#REF!
$ 1,734.01$ 1,985.73$ - 0ERROR:#REF!$ 3,539.26ERROR:#REF!
$ 168.84$ 168.84$ - 0ERROR:#REF!$ 5,876.00ERROR:#REF!
$ 303.88$ 357.51$ - 0ERROR:#REF!$ 459.68ERROR:#REF!
$ 851.02$ 898.00$ - 0ERROR:#REF!$ 1,639.79ERROR:#REF!
$ 12,662.88$ 14,571.96$ - 0ERROR:#REF!$ 14,961.00ERROR:#REF!
$ 133.54$ 136.67$ - 0ERROR:#REF!$ 1,457.00ERROR:#REF!
$ 4,306.82$ - 0ERROR:#REF!$ 5,250.00ERROR:#REF!
$ 9,385.09$ 10,679.17$ - 0ERROR:#REF!$ 9,840.83ERROR:#REF!
$ 750.00$ 806.04$ - 0ERROR:#REF!$ 11,946.00ERROR:#REF!
$ 89.45$ 105.24$ - 0ERROR:#REF!$ 105.91ERROR:#REF!
$ 262.93$ 288.85$ - 0ERROR:#REF!$ 1,551.00ERROR:#REF!
$ 56.81$ 66.84$ - 0ERROR:#REF!$ 69.94ERROR:#REF!
$ 608.76$ 695.89$ - 0ERROR:#REF!$ 2,718.36ERROR:#REF!
$ 581.86$ 665.67$ - 0ERROR:#REF!$ 1,161.79ERROR:#REF!
$ 312.74$ 348.68$ - 0ERROR:#REF!$ 599.86ERROR:#REF!
$ 132.37$ 132.87$ - 0ERROR:#REF!$ 1,536.00ERROR:#REF!
$ 379.15$ 429.50$ - 0ERROR:#REF!$ 1,995.85ERROR:#REF!
$ 241.54$ 265.10$ - 0ERROR:#REF!$ 846.89ERROR:#REF!
$ 352.08$ 392.55$ - 0ERROR:#REF!$ 788.74ERROR:#REF!
$ 167.26$ 196.76$ - 0ERROR:#REF!$ 310.00ERROR:#REF!
$ 444.71$ 502.84$ - 0ERROR:#REF!$ 4,452.34ERROR:#REF!
$ 35.67$ 41.97$ - 0ERROR:#REF!$ 652.00ERROR:#REF!
$ 408.67$ 456.82$ - 0ERROR:#REF!$ 699.56ERROR:#REF!
$ 69.05$ 78.97$ - 0ERROR:#REF!$ 160.00ERROR:#REF!
$ 355.45$ 389.74$ - 0ERROR:#REF!$ 2,358.00ERROR:#REF!
$ 122.63$ 134.31$ - 0ERROR:#REF!$ 135.00ERROR:#REF!
$ 38.27$ 44.00$ - 0ERROR:#REF!$ 65.00ERROR:#REF!
$ 130.80$ 132.51$ - 0ERROR:#REF!$ 1,283.00ERROR:#REF!
$ 86.20$ 87.90$ - 0ERROR:#REF!$ 4,411.00ERROR:#REF!
$ 105.44$ 107.15$ - 0ERROR:#REF!$ 733.00ERROR:#REF!
$ 22.88$ 22.88$ - 0ERROR:#REF!$ 290.00ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!
$ - 0ERROR:#REF!ERROR:#REF!
$ 44,067.23$ 45,137.95$ - 0$ 96,274.95ERROR:#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$ - 00$ 17,749.68ERROR:#REF!
$ 24,841.04$ 28,726.43$ - 0ERROR:#REF!$ 62,192.00ERROR:#REF!
$ 10,287.13$ 11,871.50$ - 0ERROR:#REF!$ 13,796.57ERROR:#REF!
$ 1,122.55$ 1,122.55$ - 0ERROR:#REF!$ 6,892.00ERROR:#REF!
$ 27,967.07$ 32,281.78$ - 0ERROR:#REF!$ 39,028.60ERROR:#REF!
$ - 0ERROR:#REF!$ 5,590.00ERROR:#REF!
$ 55,083.07$ 64,829.86$ - 0ERROR:#REF!$ 67,699.74ERROR:#REF!
$ 43,027.53$ 47,946.59$ - 0ERROR:#REF!$ 82,083.00ERROR:#REF!
$ 6,447.88$ 7,556.68$ - 0ERROR:#REF!$ 8,363.32ERROR:#REF!
$ 13,428.45$ 15,708.07$ - 0ERROR:#REF!$ 24,529.21ERROR:#REF!
$ 16,594.74$ 19,346.88$ - 0ERROR:#REF!$ 28,654.00ERROR:#REF!
$ 664.30$ 689.26$ - 0ERROR:#REF!$ 3,661.00ERROR:#REF!
$ - 0ERROR:#REF!$ 20,920.00ERROR:#REF!
$ 148,324.80$ 174,376.03$ - 0ERROR:#REF!$ 198,299.17ERROR:#REF!
$ 74,603.65$ 80,935.07$ - 0ERROR:#REF!$ 122,156.00ERROR:#REF!
$ 1,988.90$ 2,339.88$ - 0ERROR:#REF!$ 2,462.09ERROR:#REF!
$ 8,311.07$ 9,517.02$ - 0ERROR:#REF!$ 20,984.00ERROR:#REF!
$ 1,343.85$ 1,581.00$ - 0ERROR:#REF!$ 1,626.06ERROR:#REF!
$ 17,173.77$ 19,799.32$ - 0ERROR:#REF!$ 43,561.64ERROR:#REF!
$ 69,270.57$ 79,475.75$ - 0ERROR:#REF!$ 102,303.21ERROR:#REF!
$ 11,068.17$ 13,021.38$ - 0ERROR:#REF!$ 13,938.14ERROR:#REF!
$ 11,616.44$ 12,436.67$ - 0ERROR:#REF!$ 26,814.00ERROR:#REF!
$ 11,134.15$ 12,393.88$ - 0ERROR:#REF!$ 28,777.15ERROR:#REF!
$ 5,627.62$ 6,511.67$ - 0ERROR:#REF!$ 14,661.11ERROR:#REF!
$ 7,541.77$ 8,742.77$ - 0ERROR:#REF!$ 12,295.26ERROR:#REF!
$ 1,522.99$ 1,791.75$ - 0ERROR:#REF!$ 2,113.00ERROR:#REF!
$ 45,422.64$ 49,483.23$ - 0ERROR:#REF!$ 60,728.66ERROR:#REF!
$ 6,739.61$ 7,343.62$ - 0ERROR:#REF!$ 7,102.00ERROR:#REF!
$ 10,300.16$ 11,398.59$ - 0ERROR:#REF!$ 16,262.44ERROR:#REF!
$ 2,707.22$ 3,184.97$ - 0ERROR:#REF!$ 3,717.00ERROR:#REF!
$ 18,164.72$ 19,745.45$ - 0ERROR:#REF!$ 28,658.00ERROR:#REF!
$ 1,340.42$ 1,576.97$ - 0ERROR:#REF!$ 1,635.00ERROR:#REF!
$ 470.35$ 553.35$ - 0ERROR:#REF!$ 710.00ERROR:#REF!
$ 7,205.80$ 7,205.80$ - 0ERROR:#REF!$ 13,983.00ERROR:#REF!
$ 3,626.98$ 3,626.98$ - 0ERROR:#REF!$ 48,067.00ERROR:#REF!
$ 1,288.96$ 1,288.96$ - 0ERROR:#REF!$ 7,990.00ERROR:#REF!
$ 1,159.40$ 1,159.40$ - 0300$ 1,212.00ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 0ERROR:#REF!ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ - 0$ - 0$ - 00ERROR:#REF!
$ 681,420.80$ 776,043.25$ - 0$ 1,161,215.05ERROR:#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:
1Prior to filling up the Fee invoice coverpage, the Cost Invoice cover page needs to filled in
2Column I (hidden) in the fee invoice coverpage is pulling the "Fee incurred" from the Cost invoice coverpage via formulae
3Columns C:F are calculated columns and no need to update anything
4Billed 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)
1Enter the Invoice number for E and F invoices separately into the T4016 Fee Invoice and couble check the amounts
2Once that is done, it is safe to let Wyatt know that E & F invoices are accurate
3Wyatt 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
4Wyatt 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
1Cost 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
2Fee 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
3Billed 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.00FA17B1LJ456$ 1,125.00
FA22A9LJ514$ 4,978.86FAY6B3LTC81$ 250.00
FA22A9MJ514$ 904.00FAW3A5LLA85$ 157.00
FA22AAMY055$ 20,501.00FA22A9LJ514$ 2,567.14
FA22AAMY057$ 9,655.00FA22A9MJ514$ 39.00
FAY6A4LLE43$ 472.00FA22AAMY055$ 878.00
FAT6B2LTB69$ 8,276.00FA22AAMY057$ 7,323.00
FAT6B1LJ331$ 747.00FAY6A4LLE43$ 50.00
FAT6B3MY128$ 10,637.00FA4HA5LJ345$ 2,515.00
FAW3A9LLD30$ 4,148.00FB09A1MJ881$ 2,515.00
FAW3ABLJ635$ 7,242.00FAT6B2LTB69$ 351.00
FA4HA6LJ569$ 7,540.00FAT6B1LJ331$ 60.00
FA4HA6MJ659$ 6,018.00FAT6B3MY128$ 446.00
FAY4C3LTC09$ 16,090.00FAW3A9LLD30$ 605.00
FAY4C3MTC09$ 1,507.00FAW3ABLJ635$ 304.00
FAY4C4MTE86$ 12,492.00FA4HA6LJ569$ 320.00
FA4MA3LLH55$ 6,000.00FA4HA6MJ659$ 270.00
FA4MA3MLH55$ 48,699.00VHB2MSAL02$ 295.00
FA4MB2LJ617$ 6,000.00VHB2MMA26$ 81.00
FA4MB2MJ617$ 56,045.00FAP3ATMJ876$ 380.00
FA4MB3MJ896$ 40,109.00FAY4C3LTC09$ 700.00
FAY6ABLTC20$ 8,208.00FAY4C3MTC09$ 65.00
FA01B1LJ636$ 9,535.00FAY4C4MTE86$ 525.00
FA8EADMTB64$ 4,222.00FA4MA3LLH55$ 288.00
FA8EAJMTE55$ 19,852.00FA4MA3MLH55$ 1,638.00
FAP3ARMY127$ 8,265.00FA4MB2LJ617$ 288.00
FA63A5MJ600$ 10,890.00FA4MB2MJ617$ 1,003.00
FA63A6MTE51$ 9,052.00FAY6ABLTC20$ 344.00
FAI1A1LJ507$ 40,953.00FA01B1LJ636$ 400.00
FAI1A1MJ507$ 16,476.00FA8EADMTB64$ 180.00
FAI1A1MJ813$ 16,566.00FA8EAJMTE55$ 135.00
FAY3A5LJ512$ 7,534.00FAP3ARMY127$ 350.00
FAY3C6MJ903$ 7,545.00FA63A5MJ600$ 460.00
FA0ZB2LLJ79$ 50.00FA63A6MTE51$ 380.00
FA0ZB3LLJ80$ 6,568.00FAP3ATMJ875$ 380.00
FA0ZB1LLJ85$ 14,049.00FAS6A5MJ199$ 178.00
FA0ZB4MJ794$ 1,809.00FAI1A1LJ507$ 738.00
FA0ZB5MJ855$ 10,599.00FAI1A1MJ507$ 691.00
FA0ZB1LLJ84$ 12,469.00FAI1A1MJ813$ 695.00
FA0ZB1MLJ84$ 7,491.00FAP3A5MJ577$ 190.00
FA0ZB4MJ795$ 7,103.00FAP3APMJ873$ 254.00
FA0ZB5MJ856$ 23,118.00FA8EAGMY096$ 360.00
FA0ZB1LLJ83$ 3,620.00FA8EAGMVA21$ 271.00
FA0ZB1MLJ83$ 2,692.00FAP3ALMJ841$ 203.00
FA0ZB4MJ793$ 2,744.00FAP3ANMLJ68$ 40.00
FB01A1MMF27$ 9,535.00FAY3A5LJ512$ 326.00
FB01A2MY151$ 15,446.00FAY3C6MJ903$ 315.00
FAM8A1LJ517$ 4,647.00FA0ZB2LLJ79$ 9,099.00
FAM8B1MY161$ 4,285.00FA0ZB3LLJ80$ 280.00
FA63C2LTC97$ 4,222.00FA0ZB1LLJ85$ 590.00
FA63C2MTC97$ 6,250.00FA0ZB4MJ794$ 77.00
FA63C3MTE64$ 7,966.00FA0ZB5MJ855$ 405.00
FA0JZ1MJ719$ 1,444.00FA0ZB1LLJ84$ 5,056.00
FA4UA8MJ378$ 3,014.00FA0ZB1MLJ84$ 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 .