Burn_Rate_Analysis_Report.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- Compressed Gas Systems
- Solicitation number
- N65540-14-R-5041
About this file
Attachment 3 of 4
View the file
Other files
| File | Type | Posted |
|---|---|---|
| N65540-14-R-5041-0001.pdf | ||
| N65540-14-R-5041.pdf | ||
| CostSummaryFormat.xls | XLS spreadsheet | |
| Incurred_Cost_Report.xls | XLS spreadsheet | |
| A10_-_Section_J_-_CDRLs_A001-A008.XLSX | XLSX spreadsheet |
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
Sheet1
BURN RATE ANALYSIS
| PRIME CONTRACTOR: | XYZ Company | CONTRACT/ORDER #: | N00178-12-D-000X |
| ADDRESS: | 123 ABC STREET | PERIOD 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 TOTALS | DATE SUBMITTED: | ||
| TOTAL AWARDED AMOUNT: | $3,000,000.00 | DATE SUBMITTED: | |
| TOTAL FUNDED TO DATE: | $100,000.00 | DATE SUBMITTED: | |
| TOTAL PLANNED TO DATE: | $83,333.33 | DATE SUBMITTED: | |
| TOTAL EXPENDED TO DATE: | $75,000.00 | ||
| TOTAL AWARD AMOUNT: | $3,000,000.00 | INPUT | |
| TOTAL POP (MONTHS): | 36 | ||
| PLANNED PER MONTH: | $83,333.33 |
| TOTAL AWARDED | TOTAL FUNDED TO DATE | TOTAL PLANNED | TOTAL 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 .