HQ0858-21-R-0010_Attachment J-11 Cost Report Template.xlsx
XLSX spreadsheet 50 KB Posted
- Attached to
- TEAMS-Next Facilities, Logistics, Environmental (FLE) Federal contract opportunity
- Solicitation number
- HQ0858-21-R-0010
- Issued by
- DOD Missile Defense Agency
About this file
This cost report template and related solicitation notice provide details for a Facilities, Logistics, and Environmental (FLE) services contract opportunity with the Missile Defense Agency (MDA). The MDA is seeking these advisory and assistance services under the Technical, Engineering, Advisory and Management Support-Next (TEAMS-Next) acquisition on an Agency-wide basis. Interested Service-Disabled Veteran-Owned Small Businesses (SDVOSBs) may submit proposals by April 16, 2021 for the competitively awarded single Cost-Plus Fixed Fee Level of Effort contract, with a total value of $120.688 million over a 3-year base period and five optional periods. The North American Industry Classification System code is 541330. The cost report template outlines labor expenses by category and period of performance for contractor reporting and MDA monitoring of the FLE contract.
View the file
Other files for this federal contract opportunity
Show all 27
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
Labor by CLIN
| DATE | ATTACHMENT J-11 | ||||||||||||||||||||||||||
| HQ0858-21-R-0010 COST REPORT (Labor $M) | |||||||||||||||||||||||||||
| CONTRACT TITLE: | TEAMS-Next Facilities, Logistics, and Environmental | TOTAL LABOR ($M) | 120.688 | ||||||||||||||||||||||||
| TOTAL HOURS | 144,150 | ||||||||||||||||||||||||||
| CONTRACTOR NAME: | Contractor Name TBD | CONTRACT PERIOD OF PERFORMANCE: Day Month Year - Day Month Year | |||||||||||||||||||||||||
| FY 21 | FY 22 | ||||||||||||||||||||||||||
| TITLE | $M | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
| Labor - AB | Budget Baseline ($) | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 | 46.205 |
| Baseline (Hours) | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | 66,320 | ||
| CLIN XXXX | Funds Received | 10.200 | 10.200 | 10.200 | 10.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | 13.200 | |
| Plnd Accruals (Cumulative $) | 1.930 | 3.855 | 5.780 | 7.705 | 9.630 | 11.555 | 13.480 | 15.405 | 17.330 | 19.255 | 21.180 | 23.105 | 25.030 | 26.955 | 28.880 | 30.805 | 32.730 | 34.655 | 36.580 | 38.505 | 40.430 | 42.355 | 44.280 | 46.205 | ||
| Plnd Accruals (Current Period $) | 1.930 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | 1.925 | ||
| Accrued $ (Cumulative) | 0.468 | 2.521 | 4.691 | 6.861 | 9.031 | |||||||||||||||||||||
| Accrued $ (Current Period) | 0.468 | 2.053 | 2.170 | 2.170 | 2.170 | |||||||||||||||||||||
| Variance to plan | 1.462 | 1.334 | 1.089 | 0.844 | 0.599 | |||||||||||||||||||||
| Variance % | 76% | 35% | 19% | 11% | 6% | |||||||||||||||||||||
| Invoiced | 0.000 | 0.468 | 2.521 | 4.691 | 6.861 | |||||||||||||||||||||
| Invoiced - Paid | 0.000 | 0.000 | 0.635 | 2.805 | 4.975 | |||||||||||||||||||||
| Actual Hours (Cumulative) | 3,450 | 25,275 | 47,274 | 71,051 | 95,501 | |||||||||||||||||||||
| Actual Hours (Current Period) | 3,450 | 21,825 | 21,999 | 23,777 | 24,450 |
| Labor - BC | Budget Baseline | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 | 32.483 |
| Baseline (Hours) | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | 39440 | ||
| CLIN XXXX | Funds Received | 3.200 | 3.200 | 10.200 | 10.200 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 14.000 | 15.000 | |
| Plnd Accruals (Cumulative $) | 1.364 | 2.717 | 4.070 | 5.423 | 6.776 | 8.129 | 9.482 | 10.835 | 12.188 | 13.541 | 14.894 | 16.247 | 17.600 | 18.953 | 20.306 | 21.659 | 23.012 | 24.365 | 25.718 | 27.071 | 28.424 | 29.777 | 31.130 | 32.483 | ||
| Plnd Accruals (Current Period $) | 1.364 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | 1.353 | ||
| Accrued $ (Cumulative) | 0.640 | 1.710 | 3.197 | 4.717 | 6.319 | |||||||||||||||||||||
| Accrued $ (Current Period) | 0.640 | 1.070 | 1.487 | 1.520 | 1.602 | |||||||||||||||||||||
| Variance to plan | 0.724 | 1.007 | 0.873 | 0.706 | 0.457 | |||||||||||||||||||||
| Variance % | 53% | 37% | 21% | 13% | 7% | |||||||||||||||||||||
| Invoiced | 0.000 | 0.640 | 1.710 | 3.197 | 4.717 | |||||||||||||||||||||
| Invoiced - Paid | 0.000 | 0.000 | 0.640 | 1.710 | 3.197 | |||||||||||||||||||||
| Actual Hours (Cumulative) | 9,500 | 23,556 | 44,776 | 68,226 | 92,326 | |||||||||||||||||||||
| Actual Hours (Current Period) | 9,500 | 14,056 | 21,220 | 23,450 | 24,100 |
| Labor - DE | Budget Baseline | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 | 42.000 |
| Baseline (Hours) | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | 38,390 | ||
| CLIN XXXX | Funds Received | 5.350 | 5.350 | 10.200 | 10.200 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 13.000 | 14.000 | 15.000 | |
| Plnd Accruals (Cumulative $) | 1.750 | 3.500 | 5.250 | 7.000 | 8.750 | 10.500 | 12.250 | 14.000 | 15.750 | 17.500 | 19.250 | 21.000 | 22.750 | 24.500 | 26.250 | 28.000 | 29.750 | 31.500 | 33.250 | 35.000 | 36.750 | 38.500 | 40.250 | 42.000 | ||
| Plnd Accruals (Current Period $) | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | 1.750 | ||
| Accrued $ (Cumulative) | 0.995 | 2.250 | 5.100 | 7.800 | 9.970 | |||||||||||||||||||||
| Accrued $ (Current Period) | 0.995 | 1.255 | 2.850 | 2.700 | 2.170 | |||||||||||||||||||||
| Variance to plan | 0.755 | 1.250 | 0.150 | -0.800 | -1.220 | |||||||||||||||||||||
| Variance % | 43% | 36% | 3% | -11% | -14% | |||||||||||||||||||||
| Invoiced | 0.000 | 0.995 | 2.250 | 5.100 | 7.800 | |||||||||||||||||||||
| Invoiced - Paid | 0.000 | 0.000 | 0.995 | 2.250 | 5.100 | |||||||||||||||||||||
| Actual Hours (Cumulative) | 4,680 | 20,150 | 42,810 | 64,360 | 84,520 | |||||||||||||||||||||
| Actual Hours (Current Period) | 4,680 | 15,470 | 22,660 | 21,550 | 20,160 | |||||||||||||||||||||
| Total Labor | Budget Baseline | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 | 120.688 |
| Baseline (Hours) | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | 144,150 | ||
| Funds Received | 18.750 | 18.750 | 30.600 | 30.600 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 39.200 | 41.200 | 43.200 | ||
| Plnd Accruals (Cumulative $) | 5.044 | 10.072 | 15.100 | 20.128 | 25.156 | 30.184 | 35.212 | 40.240 | 45.268 | 50.296 | 55.324 | 60.352 | 65.380 | 70.408 | 75.436 | 80.464 | 85.492 | 90.520 | 95.548 | 100.576 | 105.604 | 110.632 | 115.660 | 120.688 | ||
| Plnd Accruals (Current Period $) | 5.044 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | 5.028 | ||
| Accrued $ (Cumulative) | 2.103 | 6.481 | 12.988 | 19.378 | 25.320 | |||||||||||||||||||||
| Accrued $ (Current Period) | 2.103 | 4.378 | 6.507 | 6.390 | 5.942 | |||||||||||||||||||||
| Variance to plan | 2.941 | 3.591 | 2.112 | 0.750 | -0.164 | |||||||||||||||||||||
| Variance % | 58% | 36% | 14% | 4% | -1% | |||||||||||||||||||||
| Invoiced | 0.000 | 2.103 | 6.481 | 12.988 | 19.378 | |||||||||||||||||||||
| Invoiced - Paid | 0.000 | 0.000 | 2.270 | 6.765 | 13.272 | |||||||||||||||||||||
| Actual Hours (Cumulative) | 17,630 | 68,981 | 134,860 | 203,637 | 272,347 | |||||||||||||||||||||
| Actual Hours (Current Period) | 17,630 | 51,351 | 65,879 | 68,777 | 68,710 | |||||||||||||||||||||
| Variance Explanation: Explain a +/- 10% or $100K variance to planned accruals. The format is in the Variance Explanation worksheet | ||||||||||||||||||||||||||
| Cost report should include the entire period of performance for active CLINS | ||||||||||||||||||||||||||
| The spend plan, i.e., planned accruals, for LOE CLINS should be straight-lined based upon number of weeks in each accounting month. | ||||||||||||||||||||||||||
| DEFINITIONS | ||||||||||||||||||||||||||
| Budget Baseline | CLIN value of current period of performance; requires update if change orders are issued | |||||||||||||||||||||||||
| Funds Received | Total dollars (cumulative) obligated on contract | |||||||||||||||||||||||||
| Plnd Accruals (Cumulative $) | Cumulative spend plan; requires update if change orders are issued | |||||||||||||||||||||||||
| Plnd Accruals (Current Period $) | Monthly increment of planned accrual | |||||||||||||||||||||||||
| Accrued $ (Cumulative) | Cumulative amount of invoices submitted for payment plus work performed but not billed | |||||||||||||||||||||||||
| Accrued $ (Current Period) | Monthly increment of actual accruals | |||||||||||||||||||||||||
| Variance to Plan | Difference between planned accruals (cum) and accrued $ (cum) | |||||||||||||||||||||||||
| Variance % | Variance to Plan divided by Planned Accrual (cum) | |||||||||||||||||||||||||
| Invoiced | Cumulative amount of invoices submitted in WAWF | |||||||||||||||||||||||||
| Invoice Paid | Cumulative amount of payment received | |||||||||||||||||||||||||
| Actual Hours (Cumulative) | Cumulative amount of actual hours | |||||||||||||||||||||||||
| Actual Hours (Current Period) | Monthy increment of actual hours |
Approved for Public Release 21-MDA-10725 (4 Mar 21)
Add additional months as necessary to ensure all data is reported at the end of the POP
Variance Explanation
| Variance Explanation: Explain a +/- 10% or $.100M variance to planned accruals | ||||
| CLIN | Stakeholder | Variance Amount ($M) | Variance % | Explanation |
Labor Detail by CLIN
| TEAMS-NEXT LABOR DETAIL COST REPORT | ||
| Contract Title: FLE | ||
| Contractor Name: Contractor Name TBD | ||
| Contract Number: HQ0858-21-R-0010 | ||
| Report Date: Month - Year | ||
| Labor Category | Total Labor Dollars Incurred this Period $M | Cumulative Labor Dollars (Total Labor Expense Incurred) $M |
| Program Manager | 1.020 | 1.020 |
| Engineer - Basic | 1.093 | 1.093 |
| Engineer - Intermediate | 1.450 | 1.450 |
| Engineer - Advanced | 1.780 | 1.780 |
| Analyst - Basic | 0.950 | 0.950 |
| Analyst - Intermediate | 1.650 | 1.650 |
| Analyst - Advanced | 1.050 | 1.050 |
| Subject Matter Expert | 0.000 | 0.000 |
| Fee | 0.038 | 0.038 |
| CLIN XXXX LABOR Subtotal | 9.031 | 9.031 |
| Total Accrued Expenditures | 9.031 | 9.031 |
| Authorized Funded Ceiling | 120.688 | |
| Percent Spent (Based on Authorized Funded Ceiling) | 7.48% | |
| Estimated Date Current Authorized Funded Ceiling is expected to run out: | ||
| DATE: |
File details come from the government source that posted it. Updated .