ot-cost-analysis - OT Milestone Cost Analysis
Builds auditable, formula-driven milestone cost workbooks and neutral proposed-amount comparisons for Research, Prototype, and follow-on Production OTs.
Tags
Updated: 2026-10-03Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Build milestone cost workbooks
- Calculate labor and materials
- Model cost-sharing scenarios
- Compare proposed amounts
- Apply agreement-specific fees
- Validate workbook formulas
- Record market benchmarks
- Estimate travel costs
Inputs
- OT authority type
- Approved milestone table
- Milestone cost inputs
- Performer contribution ratio
- Cash and in-kind composition
- Performer structure and locations
- Proposed amount basis
- Fee rate or fixed amount
- Travel requirements
- BLS wage data
- CALC+ benchmarks
- GSA Per Diem data
- Determination text
Outputs
- Auditable .xlsx workbook
- Milestone cost analysis
- Cost-sharing scenarios
- Funding requirement calculations
- Proposed-amount comparison tables
- Methodology record
- Controlled draft memo section
Requirements
- bls-oews MCP server
- gsa-calc MCP server
- gsa-perdiem MCP server when travel applies
- Authenticated required MCP operations
- Python 3.10 or later
- openpyxl
- Spreadsheet formula engine preferred