Burn_Rate_Analysis_Template_-Attachment_3.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Modernization Program of HM&E Systems Services Federal contract opportunity
Solicitation number
N64498-17-R-4004
Issued by
Department of the Navy Naval Sea Systems Command

About this file

Attachment 3

View the file

Other files for this federal contract opportunity

Other files attached to Modernization Program of HM&E Systems Services, newest first.
File Type Posted
N6449817R40040006.pdf PDF
N6449817R40040005.pdf PDF
N6449817R40040004.pdf PDF
Attachment_5_Cost_Summary_Format_Amend_0004.xls XLS spreadsheet
Attachement_5_Cost_Summary_Format.xls XLS spreadsheet
N6449817R40040003.pdf PDF
N6449817R40040002.pdf PDF
N6449817R40040001.pdf PDF
Contract_Data_Requirements_Lists_A001-L001.pdf PDF
DD_254.pdf PDF
N64498-17-R-4004.pdf PDF
Labor_Rate_Substantiation_Table_-_Attachment_4.xls XLS spreadsheet
Incurred_Cost_Report-_Attachment_2.xls XLS spreadsheet
Cost_Summary_Format_Attachment_5.xls XLS spreadsheet
NSWCPD_SBPCD_Attachment_6_.xlsx XLSX spreadsheet
Show all 15

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

Text version

Sheet1

BURN RATE ANALYSIS

PRIME CONTRACTOR:XYZ CompanyCONTRACT/ORDER #:N00178-12-D-000X
ADDRESS:123 ABC STREETPERIOD COVERED BY THIS ANALYSIS:2/1/2012-2/29/2012
Hollywood, CA 90210
BURN RATE ANALYSIS TABLE (PER IDIQ ORDER/SEAPORT TI)CONTRACTOR 75% LETTER TRACKING (SEND TO PCO AND COR)
DATE SUBMITTED:
MONTHLY REPORT TOTALSDATE SUBMITTED:
TOTAL AWARDED AMOUNT:$3,000,000.00DATE SUBMITTED:
TOTAL FUNDED TO DATE:$100,000.00DATE SUBMITTED:
TOTAL PLANNED TO DATE:$83,333.33DATE SUBMITTED:
TOTAL EXPENDED TO DATE:$75,000.00
TOTAL AWARD AMOUNT:$3,000,000.00INPUT
TOTAL POP (MONTHS):36
PLANNED PER MONTH:$83,333.33
TOTAL AWARDEDTOTAL FUNDED TO DATETOTAL PLANNEDTOTAL EXPENDED TO DATE
Jan-12$3,000,000.00$100,000.00$83,333.33$75,000.00
Feb-12$3,000,000.00$300,000.00$166,666.67$150,000.00
Mar-12$3,000,000.00$500,000.00$250,000.00$400,000.00
Apr-12$3,000,000.00$600,000.00$333,333.33$500,000.00
May-12$3,000,000.00$750,000.00$416,666.67$600,000.00
Jun-12$3,000,000.00$750,000.00$500,000.00$650,000.00
Jul-12$3,000,000.00$750,000.00$583,333.33$675,000.00
Aug-12$3,000,000.00$800,000.00$666,666.67$700,000.00
Sep-12$3,000,000.00$900,000.00$750,000.00$725,000.00
Oct-12$3,000,000.00$1,000,000.00$833,333.33$750,000.00
Nov-12$3,000,000.00$1,000,000.00$916,666.67$800,000.00
Dec-12$3,000,000.00$1,000,000.00$1,000,000.00$820,000.00
Jan-13$3,000,000.00$1,200,000.00$1,083,333.33$900,000.00
Feb-13$3,000,000.00$1,300,000.00$1,166,666.67$1,200,000.00
Mar-13$3,000,000.00$1,400,000.00$1,250,000.00$1,250,000.00
Apr-13$3,000,000.00$1,500,000.00$1,333,333.33$1,275,000.00
May-13$3,000,000.00$1,600,000.00$1,416,666.67$1,300,000.00
Jun-13$3,000,000.00$1,700,000.00$1,500,000.00$1,400,000.00
Jul-13$3,000,000.00$1,800,000.00$1,583,333.33$1,500,000.00
Aug-13$3,000,000.00$1,900,000.00$1,666,666.67$1,600,000.00
Sep-13$3,000,000.00$2,000,000.00$1,750,000.00$1,700,000.00
Oct-13$3,000,000.00$2,000,000.00$1,833,333.33$1,800,000.00
Nov-13$3,000,000.00$2,000,000.00$1,916,666.67$1,900,000.00
Dec-13$3,000,000.00$2,000,000.00$2,000,000.00$2,000,000.00
Jan-14$3,000,000.00$2,500,000.00$2,083,333.33$2,000,000.00
Feb-14$3,000,000.00$2,500,000.00$2,166,666.67$2,100,000.00
Mar-14$3,000,000.00$2,500,000.00$2,250,000.00$2,200,000.00
Apr-14$3,000,000.00$2,500,000.00$2,333,333.33$2,300,000.00
May-14$3,000,000.00$2,600,000.00$2,416,666.67$2,400,000.00
Jun-14$3,000,000.00$2,700,000.00$2,500,000.00$2,500,000.00
Jul-14$3,000,000.00$2,800,000.00$2,583,333.33$2,600,000.00
Aug-14$3,000,000.00$3,000,000.00$2,666,666.67$2,700,000.00
Sep-14$3,000,000.00$3,000,000.00$2,750,000.00$2,800,000.00
Oct-14$3,000,000.00$3,000,000.00$2,833,333.33$2,900,000.00
Nov-14$3,000,000.00$3,000,000.00$2,916,666.67$3,000,000.00
Dec-14$3,000,000.00$3,000,000.00$3,000,000.00$3,000,000.00

TOTAL AWARDED 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 3000000 TOTAL FUNDED TO DATE 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 100000 300000 500000 600000 750000 750000 750000 800000 900000 1000000 1000000 1000000 1200000 1300000 1400000 1500000 1600000 1700000 1800000 1900000 2000000 2000000 2000000 2000000 2500000 2500000 2500000 2500000 2600000 2700000 2800000 3000000 3000000 3000000 3000000 3000000 TOTAL PLANNED 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 83333.333333333328 166666.66666666666 250000 333333.33333333331 416666.66666666663 500000 583333.33333333326 666666.66666666663 750000 833333.33333333326 916666.66666666663 1000000 1083333.3333333333 1166666.6666666665 1250000 1333333.3333333333 1416666.6666666665 1500000 1583333.3333333333 1666666.6666666665 1750000 1833333.3333333333 1916666.6666666665 2000000 2083333.3333333333 2166666.6666666665 2250000 2333333.333333333 2416666.6666666665 2500000 2583333.333333333 2666666.6666666665 2750000 2833333.333333333 2916666.6666666665 3000000 TOTAL EXPENDED TO DATE 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 75000 150000 400000 500000 600000 650000 675000 700000 725000 750000 800000 820000 900000 1200000 1250000 1275000 1300000 1400000 1500000 1600000 1700000 1800000 1900000 2000000 2000000 2100000 2200000 2300000 2400000 2500000 2600000 2700000 2800000 2900000 3000000 3000000

Sheet2

Sheet3

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