TL CDRL A006 Consol Cost Lbr Fund Samplev2.xlsx
XLSX spreadsheet 109 KB Posted
- Solicitation number
- FA461027R0001
About this file
This file is a consolidated cost and labor funding template in spreadsheet format supporting the FRAME contract proposal.
The template is designed to consolidate labor costs and funding allocations across contract line items, presenting cost data in a structured format for proposal submission. It appears to function as a sample or example document demonstrating how proposers should organize and present labor hour projections, labor rates, and associated funding requirements for the Facility Readiness and Maintenance Execution (FRAME) contract at Vandenberg Space Force Base. The document serves as a Cost Data Requirements List (CDRL) deliverable item, specifically CDRL A006, and is intended to support cost proposal development for this 100% small business set-aside, non-personal services contract providing maintenance, repair, modification, and modernization support for over 130 facilities and equipment at VSFB and geographically-separated locations.
View the file
Other files
Show 40 more
Latest 50 of 124 listed here. See the rest on GovTribe.
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
CDRL A006 Instructions
| Tab # | Tab Title | Description |
| Tab 1 | Instructions | |
| Tab 2 | IDIQ Master Summary (Executive Dashboard) | Provides a high-level administrative list of all active Task Orders , showing: |
1) Period of Performance (PoP) Start and End dates.
2) Total Task Order Contract Value vs. Funded Amount.
3) Total Payments Received
This Tab should have a Direct, automatic link to the detailed worksheets to prevent discrepancies.
| Tab 3 | Funding Status | Segregates Funding, Actual Cost, ETC, EAC, and Additional Funding requirements per SLIN/JON//OPS/WBS under each specific Task Order. |
| Tab 4 | Labor & Expenditures | Organize labor categories, applicable baseline, current-period, and cumulative hours/costs grouped by Task Order. |
Variance & Sufficiency: The Contractor must include explicit statements for each Task Order on whether remaining hours and funds are sufficient to complete the work, accompanied by a detailed narrative explaining all cost and man-hour variances.
| Tab 5 | Purchases & ODCs | Itemize IT, travel, and miscellaneous material purchases per Task Order. |
| Tab 6 | Invoicing & Payments | Details billings, ACRN assignments, performance deductions, and payments received broken down by Task Order. |
| Tab 7 | Cost Adjustments Tracing | Lists adjustments (e.g., rate reconciliations, material transfers) prefixed by Task Order. Reconciles adjustments directly to prior-FY balances for that specific Task Order, maintaining absolute auditability. |
&22CDRL A006 Consolidated Cost, Labor, and Funding Status Report (CCLFSR)
SAMPLE
Summary Tab 1: IDIQ_Master_Summary (Executive Dashboard)
0 0
Task Order ID Task Order Title PoP Start PoP End Funding FY Total Contract Value ($) CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: Total amount awarded at the TO level Funded Amount ($) CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: Total funded amount at the TO Level
| Actual Cost | Cumulative Invoiced ($) | ||
| CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: Total amount invoiced in WAWF to include invoices awaiting payment | Remaining Funds ($) | Percent Invoiced (%) | Payments Received ($) |
CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: Total payment actually received. There may be invoices that is still awaiting payment from DFAS.
CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: Total amount awarded at the TO level Total - 0 - 0 - 0 - 0 - 0 ERROR:#DIV/0! - 0
Funding Status
| Tab 3: Funding Status | |
| Prefixed with a **Task Order ID** column. | |
| * segregates funding, accrued expenditures, commitments, and carryover per CLIN/WBS *under each specific Task Order*. | |
| - 0 | |
| Tracks the overall funding profile, open commitments, carryover, and net funds required per Task Order/CLIN. |
Task Order ID CLIN SLIN ACRN JON WBS OPS # CLIN Type Funding FY Appropriation Funding Actual Cost CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: This includes incurred cost up to this reporting period but may or may not have been invoiced in WAWF.
| This is a sum from the following Tabs (Labor & Exp; Purch & ODC, & Cost Adj) | Addt'l Incurred Cost | |
| CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: Forecasted cost for the next reporting period | Total Expense | ETC ($) |
| CUI, SHARONJOY S CIV USSF SSC SLD 30/PMD: Forecasted Cost beyond the next reporting period | EAC ($$) | Addt'l Funds Req |
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| - 0 | - 0 | - 0 | |||||
| Total | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
Labor & Exp
| Tab 4: Labor & Expenditures |
| Organizes labor categories, baseline, current-period, and cumulative hours/costs grouped by Task Order. |
| * Contains **Task-Order-specific sufficiency statements** and variance calculations, ensuring that an overrun on one Task Order is clearly flagged and not masked by underruns on another. |
| Breaks down labor categories, hours, and rates per Task Order. Includes variance and sufficiency remarks. | |||||||||||
| Task Order ID | CLIN | SLIN | ACRN | JON | WBS | OPS | CLIN Type | Labor Category / Cost Element | Charge Date | Labor code (RG, OT, | |
| SUB RG, SUB OT) | Baseline Hours | Baseline Dollars ($) | Current Period Hours | Current Period Dollars ($) | Cumulative Hours | Cumulative Dollars ($) | Status & Sufficiency Remarks |
| $0.00 | 32.45 | |||
| Fringe | 60.1% | $0.00 | 51.95 | |
| PM % | 6.6% | $0.00 | 3.43 | 55.38 |
| Prj OH | 5.0% | $0.00 | 2.60 | 57.98 |
| G & A | 9.5% | $0.00 | 63.49 | |
| Fee | 5.0% | $0.00 | 66.66 |
Purch & ODC
| Tab 5: Purchases & ODCs | ||||||||||||||||
| Itemizes IT, travel, and miscellaneous material purchases per Task Order. | ||||||||||||||||
| * Calculates ODC percentages relative to the *specific Task Order's labor costs* for the month, preventing cross-funding violations. | ||||||||||||||||
| Logs actual current-month purchases per Task Order and calculates the ratio of ODCs compared to that Task Order's direct labor. | ||||||||||||||||
| Task Order ID | Transaction Date | CLIN | SLIN | JON | OPS | WBS | PWS Paragraph | CLIN Type | SubCategory | Invoice Number | Vendor | Description | QTY | UOM | Unit Cost | Amount ($) |
TOTAL ODCs - 0
INV & Pymts
| Tab 6: Invoicing & Payments | ||||||||||||||||
| Details billings, ACRN assignments, performance deductions, and payments received *broken down by Task Order*. | ||||||||||||||||
| $ - 0 | ||||||||||||||||
| Tracks actual billing progress, deductions, and collections down to the CLIN and funding ACRN under each Task Order. | ||||||||||||||||
| Task Order ID | CLIN | SLIN | ACRN | JON | WBS # | WBS Description | OPS # | CLIN Type | Total Value ($) | Funded Amount ($) | Cumulative Invoiced ($) | Funds Remaining ($) | Percent Invoiced (%) | Current Invoice | Current WAWF Invoice # | Payment Received ($) |
Total $0.00 $0.00 $0.00 $0.00 ERROR:#DIV/0! $0.00 $0.00
Cost adj
| Tab 7: Cost Adjustments Tracing | ||||||||||||||
| Lists adjustments (e.g., rate reconciliations, material transfers) prefixed by Task Order (e.g., `TO-0001`, `TO-0002`). | ||||||||||||||
| * Reconciles adjustments directly to prior-FY balances for that specific Task Order, maintaining absolute auditability. | ||||||||||||||
| Reconciles adjustments from prior fiscal years back to their original Task Order, ACRN, and historical balance registers. | ||||||||||||||
| Task Order ID | Adjustment Date | Source FY | Target SLIN | ACRN Affected | JON | OPS | WBS | WBS Description | Adjustment ID | Original Bal ($) | Adjustment Amount ($) | Adjusted Bal ($) | Ledger ID | Narrative Explanation |
| $0.00 |
| $0.00 |
| $0.00 |
File details come from the government source that posted it. Updated .