aiskillstore/marketplace / skills/1102tools-dev/igce-builder-lh-tm
igce-builder-lh-tm
VerifiedTrigger for: Labor-Hour IGCE, LH estimate, Time-and-Materials IGCE, T&M estimate, burdened hourly rate, burden multiplier, labor-category ceiling hours, materials estimate, proposed LH/T&M rate validation, price-reasonableness memo, or fair-and-reasonable analysis. Build auditable LH/T&M estimates using BLS OEWS wages, explicit burden multipliers, GSA CALC+ positioning, GSA Per Diem travel, and separately priced T&M materials. Do NOT use for FFP, cost-reimbursement, grants, or cooperative agreements. Requires the bls-oews, gsa-calc, and gsa-perdiem MCP servers.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 15.7 KB |
| agents/openai.yaml | config | 297 B |
| references/data-source-operations.md | markdown | 13.4 KB |
| references/runtime-adaptation.md | markdown | 2.7 KB |
| references/validation-gates.md | markdown | 3.9 KB |
| references/workbook-specification.md | markdown | 5.9 KB |
| references/wrap-rate-presets.md | markdown | 2.8 KB |
| scripts/recompute_expected_values.py | script | 8.4 KB |
| scripts/validate_workbook.py | script | 22.3 KB |
| skill-report.json | config | 51.5 KB |
| test.md | markdown | 3.8 KB |
| testing.md | markdown | 31.6 KB |
references/workbook-specification.md
View on GitHub# LH/T&M Workbook Specification
Build one `.xlsx` workbook with seven sheets in this order:
1. `IGCE Summary`
2. `Scenario Analysis`
3. `Rate Validation`
4. `Travel Detail`
5. `Materials Detail`
6. `Methodology`
7. `Raw Data`
Keep `Materials Detail` in an LH workbook and mark it `Not Applicable` with numeric zero. This preserves a stable structure without implying that LH reimburses materials.
## 1. IGCE Summary
### Assumption cells
| Cell | Label or value |
|---|---|
| A1:B1 | `IGCE Assumptions (LH/T&M)` |
| A2 / B2 | Low Burden Multiplier / input |
| A3 / B3 | Mid Burden Multiplier / input |
| A4 / B4 | High Burden Multiplier / input |
| A5 / B5 | Escalation Rate / input |
| A6 / B6 | Productive Hours per FTE / input |
| A7 / B7 | Base Year Months / input |
| A8 / B8 | BLS Vintage / `YYYY-MM` text |
| A9 / B9 | Contract Start / `YYYY-MM` text |
| A10 / B10 | Months Gap / formula below |
| A11 / B11 | Aging Factor / formula below |
| A12 / B12 | Contract Type / `LH` or `T&M` |
| A13 / B13 | Total Ceiling Price / user input or blank |
Use:
```excel
B10 =MAX(0,(VALUE(LEFT(B9,4))-VALUE(LEFT(B8,4)))*12+VALUE(MID(B9,6,2))-VALUE(MID(B8,6,2)))
B11 =(1+B5)^(B10/12)
```
Format B11 as `0.0000`. Never use `YEAR` on the text cells or rely on `DATEDIF`.
### Labor and period table
Start below row 15. Include:
- Labor category and SOC
- Location and level
- FTE
- Productive hours per FTE
- Estimated hours by period
- Labor-category ceiling hours by period
- Low, mid, and high burdened hourly rates
- Low, mid, and high labor totals
- Travel and materials as separate rows
- Mid IGCE total
- Total ceiling-price input
- Difference between the mid IGCE and ceiling input
Ceiling hours and total ceiling price are inputs or procurement decisions. Do not overwrite them with calculated estimates.
## 2. Scenario Analysis
Use a fixed 13-row block per labor category. Block `N` begins at:
```text
base row = 1 + (N - 1) * 13
```
| Offset | Label | Formula or input |
|---:|---|---|
| 0 | `Scenario Analysis: <LCAT>` | header |
| 1 | BLS Base Annual Wage | source input |
| 2 | Aging Factor | `='IGCE Summary'!$B$11` |
| 3 | Aged Annual Wage | base wage times aging factor |
| 4 | Direct Labor Rate Hourly | aged wage divided by 2,080 |
| 5 | blank | separator |
| 6 | Low Multiplier | `='IGCE Summary'!$B$2` |
| 7 | Low Burdened Rate | direct rate times low multiplier |
| 8 | Mid Multiplier | `='IGCE Summary'!$B$3` |
| 9 | Mid Burdened Rate | direct rate times mid multiplier |
| 10 | High Multiplier | `='IGCE Summary'!$B$4` |
| 11 | High Burdened Rate | direct rate times high multiplier |
| 12 | blank | block separator |
In the first block, Direct Labor Rate Hourly is row 5. Cross-sheet formulas must not use row 4, which is Aged Annual Wage.
Below the blocks, show period totals using the Summary productive-hours and month assumptions. Add travel and materials after labor, never inside burden multiplication.
## 3. Rate Validation
Use columns for labor category, BLS direct rate, multiplier, BLS burdened low/mid/high, CALC+ P25/P50/P75/P90, sample size, divergence from P50, and neutral note. Add title-match and experience-match columns when pools are thin or ambiguous.
Do not use `reasonable`, `acceptable`, `competitive`, `outlier`, or negotiation recommendations.
## 4. Travel Detail
Use a 17-row block per destination. Calculate zero-night trips with zero lodging and one discounted first/last-day M&IE amount. Sum travel into the Summary without burden.
For T&M, label travel as a materials-category ODC. For LH, state the separate reimbursement or CLIN basis supplied by the user. If no basis exists, show the estimate separately and flag that it is not part of the LH labor amount.
## 5. Materials Detail
For T&M, include one row per item:
- Category and description
- Vendor or estimate source
- Base-year actual or estimated cost
- Credits or discounts
- Applicable material-handling indirect cost
- Escalation by period
- Total
Material handling must be a supported indirect cost clearly excluded from labor rates. It is not fee or profit. Do not apply the labor multiplier, G&A, or a default handling percentage.
Use numeric zero when no supported basis was supplied. When a user supplies a supported accounting or solicitation basis, record every nonzero material-handling cell in the validation sidecar under `material_handling_assertions` with the exact cell, numeric value or formula, and basis text. The bundled validator rejects nonzero or formula-driven material handling that is not disclosed there.
For LH, show `Materials Not Applicable to Labor-Hour Contract` and numeric zero.
## 6. Methodology
Include:
- LH or T&M selection and user confirmation
- FAR 16.601 limitations and the fact that the D&F is outside the skill
- Fixed-hourly-rate content
- Productive and ceiling hours by category
- Total ceiling-price input and comparison with the IGCE
- SOC, BLS vintage, location, aging, and escalation
- Multiplier source and any sensitivity convention
- CALC+ pool construction and limitations
- Travel treatment
- T&M materials and material-handling basis, if applicable
- Coverage calculations
- Exclusions and user overrides
- Validation layers actually run
Do not state that the workbook itself establishes the D&F, fair and reasonable pricing, or the binding contract ceiling.
## 7. Raw Data
Record compact, reproducible parameters and result summaries, not full JSON. Include BLS series inputs and percentiles, CALC+ pool terms and statistics, Per Diem locality and rates, multiplier source, material-cost sources, and every fallback.
## Formatting and safety
- Blue font for inputs; black for formulas.
- Currency: `$#,##0.00`; percentage: `0.0%`; aging factor: `0.0000`; multiplier: `0.00x`.
- Freeze panes below assumption and header blocks.
- Escape text beginning with `=`, `+`, `-`, or `@`.
- Use numeric zero, not text `TBD`, inside formula ranges.
- Wrap long notes and cap column widths at readable sizes.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |