aiskillstore/marketplace / skills/1102tools-dev/ot-cost-analysis
ot-cost-analysis
VerifiedTrigger for: Other Transaction or OT should-cost, cost estimate, cost-share analysis, milestone pricing, funding profile, proposed-price comparison, prototype price analysis, research OT budget, production follow-on OT estimate, or OT price-reasonableness support under 10 U.S.C. 4021 or 4022. Build auditable milestone-based .xlsx workbooks using BLS OEWS wages, CALC+ positioning, GSA Per Diem, materials, cost sharing, and agreement-specific fees. Use for pre-solicitation budgets and proposal comparisons. Do NOT use for FAR-based IGCEs, OT project descriptions, grants, or an Agreements Officer's determination. Requires the bls-oews, gsa-calc, and, when travel applies, gsa-perdiem MCP servers.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 17.3 KB |
| agents/openai.yaml | config | 300 B |
| references/authority-and-cost-sharing.md | markdown | 4.9 KB |
| references/data-source-operations.md | markdown | 6.2 KB |
| references/labor-and-costing-methods.md | markdown | 3.8 KB |
| references/runtime-adaptation.md | markdown | 2.6 KB |
| references/validation-gates.md | markdown | 4.7 KB |
| references/workbook-specification.md | markdown | 6.3 KB |
| scripts/recompute_expected_values.py | script | 10.2 KB |
| scripts/validate_workbook.py | script | 12.2 KB |
| skill-report.json | config | 41.5 KB |
| test.md | markdown | 4.1 KB |
| testing.md | markdown | 11.2 KB |
test.md
View on GitHub# OT Cost Analysis Modernization Test Record
Tested August 21, 2026 against the portable, progressive-disclosure version. The historical April record remains in `testing.md`.
## Automated validation
- `quick_validate.py` passed the skill directory.
- Both bundled Python scripts compiled, and their command-line help ran successfully.
- A representative seven-sheet prototype OT fixture contained 79 formulas and passed the formula-structure audit, independent recomputation, and LibreOffice formula execution.
- The fixture reconciled total project cost of $754,288.86 and Government funding of $558,339.42 within validator tolerance.
- Every worksheet was rendered and inspected. Number formats and Methodology-sheet spacing found on the first visual pass were corrected, then all seven sheets passed the second visual review.
- The final workbook contained no formula-error strings.
Fault injection:
- Replacing the month-based aging formula with `DATEDIF` was rejected.
- Applying cost-type contribution math to the wrong basis was rejected.
- Reintroducing the false Path D competition-commitment label was rejected.
- Four direct authority checks rejected a 0.32 Path C contribution ratio, a Path D competition-commitment claim, an unsourced Research OT contribution ratio, and a production ratio inherited automatically from a prototype.
## Claude behavior tests
Surface: Claude Code CLI 2.1.238, `claude-opus-5`, high effort, explicit `/ot-cost-analysis` invocation.
1. A $4.2 million proposed-amount request seeking a fair-and-reasonable conclusion and negotiation recommendation produced the exact Option A/Option B boundary, made no tool call, gave no verdict, and ended at `Which option?`.
2. A prototype prompt that mislabeled 10 U.S.C. 4022(d)(1)(D), requested zero performer share, and asked for a default five-percent consortium fee was stopped at the authority gate. Claude corrected Path D to the senior procurement executive's written exceptional-circumstances determination, distinguished 4022(f), refused to default the ratio or fee, and ended at the authority question.
## Codex behavior tests
Surface: Codex CLI 0.149.0-alpha.4, GPT-5.6 Sol, extra-high reasoning, explicit `$ot-cost-analysis` invocation.
1. The proposed-amount request produced the exact Option A/Option B boundary with no verdict or artifact.
2. The authority-mislabel prompt corrected Path D, distinguished 4022(f), and stopped at the first authority question without applying the requested ratio or fee.
## Confirmed gates
- Research, prototype, and follow-on-production contribution arrangements are supplied and sourced, not invented.
- Prototype Path C requires at least one-third of total project cost from non-Federal sources.
- Prototype Path D is not a competition-commitment path.
- Proposed amounts are normalized to a confirmed basis before comparison.
- Consortium and administrative fees default to zero unless rate or amount, base, timing, treatment, and source are supplied.
- Workflow B provides neutral comparison data and never originates the Agreements Officer's determination or negotiation position.
- Keyed federal API calls are serialized with at least three seconds between calls.
## Open coverage
- No live BLS, CALC+, Per Diem, SAM.gov, or other federal API call was made during this pass.
- Claude web, Claude Code after automatic compaction, Codex Desktop UI, and Microsoft Excel were not rerun for this skill.
- Implicit activation was not treated as deterministic; published usage should retain explicit invocation examples.
## August 23 host-capability correction
A normal Codex CLI mixed-milestone workbook run preserved approvals and stopped because the host's governing spreadsheet skill did not expose its supported dependency loader. Runtime adaptation now gives host spreadsheet instructions precedence, prohibits guessed-path or alternate-library bypasses, and requires the available artifact mode to be disclosed before artifact-specific approval. A host without the supported workbook path may deliver only a structured JSON specification plus Markdown or CSV tables, never a completed-workbook claim. Desktop and Claude workbook lanes remain the full-artifact gates.
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 |