You do not need to understand formulas, and you do not need to run any scripts. Just tell Claude your data, and Claude will guide you step by step, providing calculation results and an analysis report in real time.
Conversational calculation mode (recommended)
Claude can complete the ROI calculation interactively with you directly, without any tools or scripts:
- Tell Claude which Skill you want to evaluate (or just paste the data directly)
- Claude will guide you step by step to fill in the missing information
- Claude performs all the math directly in the conversation
- Output a complete report that can be used directly for reporting
Example trigger methods:
- "Help me calculate whether this Skill is worth it"
- "I want to ask my boss to approve developing a Skill; help me do an ROI analysis"
- "We have been using our Skill for 3 months; help me calculate the ROI"
- "Which should be done first, Skill A or Skill B?"
Script tool (
scripts/calculate_roi.py) is optional and suitable for batch calculations or automation scenarios. Claude itself can do all the math.
Applicable scenarios
| Scenario | Question | Output |
|---|---|---|
| Reporting upward | "Is it worth putting this much effort into making a Skill?" | ROI report |
| Budget request | "How much cost is needed to develop this Skill?" | Cost estimate + projected ROI |
| Effect evaluation | "How is this Skill being used?" | Usage statistics + benefit accounting |
| Solution comparison | "Which Skill should be done first?" | Priority ranking + comparison report |
Workflow
Step 1: Collect basic information
Claude will guide you to fill in the following information (you do not need to provide it all at once; Claude will ask item by item):
Skill basic information
- Skill name
- Function description
- Target user group
Development cost(If it is a new Skill or an existing Skill being evaluated)
- Developers: Who is involved in development? (technical/business experts)
- Development time: How many hours are expected to be needed?
- Labor cost: Labor cost calculated by hour
Usage data(If it is an existing Skill)
- Number of uses: How many times was it used in the past N days/months?
- Number of users: How many people are using it?
- Time saved: On average, how much time is saved per use?
Step 2: Calculate cost
Claude calculates directly (or uses a script):
Cost composition:
- Development cost = development time × hourly wage
- Expert cost = expert time × expert hourly wage
- Maintenance cost = development cost × 20% (annual)
- Total Cost = Development Cost + Expert Cost + Maintenance Cost
Optional script method:
python scripts/calculate_roi.py --mode cost \
--dev-hours <开发小时数> \
--hourly-rate <时薪> \
--experts <专家参与小时数>
Step 3: Calculate Benefits
Benefit Composition:
- Time Savings = Usage Count × Time Saved per Use
- Labor Cost Savings = Time Savings × Average Hourly Wage
- Quality Improvement(Optional) = Cost savings from error reduction
- Total Benefits = Labor Cost Savings + Quality Improvement
Optional script method:
python scripts/calculate_roi.py --mode benefit \
--usage-count <使用次数> \
--time-saved <每次节省分钟> \
--user-count <使用人数> \
--hourly-rate <用户时薪>
Step 4: Calculate ROI
ROI Formula(calculated directly by Claude):
ROI = (总收益 - 总成本) / 总成本 × 100%
回本周期 = 总成本 / 月均收益
年化收益 = 月均收益 × 12
Optional script method:
python scripts/calculate_roi.py --mode roi \
--cost <总成本> \
--benefit <总收益> \
--period <周期月数>
Step 5: Generate Report
Generate a complete ROI analysis report, including:
- Cost Breakdown
- Benefit Breakdown
- ROI Calculation Results
- Visualization and comparison suggestions (suitable for reporting)
- Conclusions and Recommendations
Output Format
ROI Analysis Report
📊 Skill ROI 分析报告
━━━━━━━━━━━━━━━━━━━━━━
Skill:[Skill 名称]
分析周期:[开始日期] ~ [结束日期]
💰 投入成本:
┌────────────────────────────────────┐
│ 项目 │ 金额 │ 占比 │
├────────────────────────────────────┤
│ 开发成本 │ ¥X,XXX │ XX% │
│ 专家成本 │ ¥X,XXX │ XX% │
│ 维护成本 │ ¥X,XXX │ XX% │
├────────────────────────────────────┤
│ 总计 │ ¥X,XXX │ 100% │
└────────────────────────────────────┘
📈 使用数据:
- 使用次数:XXX 次
- 使用人数:XX 人
- 平均每次节省:XX 分钟
- 总节省时间:XX 小时
💵 产出价值:
┌────────────────────────────────────┐
│ 项目 │ 金额 │ 说明 │
├────────────────────────────────────┤
│ 人力成本节省 │ ¥X,XXX │ │
│ 质量提升收益 │ ¥X,XXX │ 可选 │
├────────────────────────────────────┤
│ 总计 │ ¥X,XXX │ │
└────────────────────────────────────┘
📊 ROI 分析:
- 投资回报率:XXX%
- 回本周期:X.X 个月
- 年化收益:¥XX,XXX
📉 可视化建议(适合 PPT / 汇报):
- 柱状图:开发成本 vs 累计收益(按月)
- 折线图:ROI 随时间的增长趋势
- 饼图:成本构成分解
- 对比表:多个 Skill 的 ROI 横向对比
💡 结论与建议:
[根据 ROI 数据给出建议]
ROI Evaluation Criteria
| ROI | Rating | Recommendation |
|---|---|---|
| > 200% | ⭐⭐⭐⭐⭐ Excellent | Strongly recommended, can be rolled out to other departments |
| 100-200% | ⭐⭐⭐⭐ Good | Worth investing in, recommend continuous optimization |
| 50-100% | ⭐⭐⭐ Fair | Acceptable, needs to increase usage rate |
| 0-50% | ⭐⭐ Low | Needs reassessment, consider optimizing or abandoning |
| < 0% | ⭐ Loss | Recommend stopping investment and analyzing the reasons for failure |
Payback Period Evaluation
| Payback Period | Rating | Description |
|---|---|---|
| < 1 month | Fast payback | Takes effect immediately, prioritize investment |
| 1-3 months | Normal | Reasonable investment cycle |
| 3-6 months | Relatively long | Requires management support |
| > 6 months | Long-term investment | Requires strategic-level decision-making |
Cost Estimation Reference
Development Cost Reference
| Skill Complexity | Development Time | Expert Time | Reference Cost |
|---|---|---|---|
| Simple (plain text guidance) | 2-4 hours | 1-2 hours | ¥500-1,500 |
| Medium (includes scripts) | 8-16 hours | 4-8 hours | ¥3,000-8,000 |
| Complex (multiple scripts + integration) | 24-40 hours | 8-16 hours | ¥10,000-25,000 |
Hourly Wage Reference
| Role | Reference Hourly Wage |
|---|---|
| Junior Employee | ¥50-100 |
| Mid-level Employee | ¥100-200 |
| Senior Employee | ¥200-400 |
| Expert/Management | ¥400-800 |
Example
Example 1: Contract Review Skill (Existing Skill Evaluation)
Input:
- Development time: Legal expert 8 hours + Technical 4 hours
- Usage data: 156 uses within 3 months, 12 users
- Time saved per use: 15 minutes
Claude calculates and outputs directly:
📊 Skill ROI 分析报告
━━━━━━━━━━━━━━━━━━━━━━
Skill:contract-reviewer
分析周期:2026-01 ~ 2026-03(3个月)
💰 投入成本:
- 法务专家:8h × ¥300 = ¥2,400
- 技术支持:4h × ¥150 = ¥600
- 总计:¥3,000
📈 使用数据:
- 使用次数:156 次
- 使用人数:12 人
- 每次节省:15 分钟
- 总节省:39 小时
💵 产出价值:
- 人力成本节省:39h × ¥200 = ¥7,800
📊 ROI 分析:
- 投资回报率:160%
- 回本周期:1.2 个月
- 年化收益:¥31,200
📉 可视化建议:
- 月度累计收益 vs 开发成本柱状图(第2月即超回本线)
- 12个月 ROI 增长折线图(年底达 940%)
💡 结论:
⭐⭐⭐⭐ 良好
该 Skill 效果显著,建议:
1. 推广到其他部门
2. 增加「合同模板生成」功能
Example 2: Sales Talk Track Skill (Estimated for a New Skill)
Input:
- Planned development: Sales Talk Track Skill
- Estimated development: Sales expert 16 hours + technical 8 hours
- Estimated usage: 50 people, 3 times per person per day, saving 5 minutes each time
Claude calculates and outputs directly:
📊 Skill ROI 预估报告
━━━━━━━━━━━━━━━━━━━━━━
Skill:sales-script(规划中)
💰 预计投入:
- 销售专家:16h × ¥250 = ¥4,000
- 技术支持:8h × ¥150 = ¥1,200
- 总计:¥5,200
📈 预计使用(月):
- 使用次数:50人 × 3次 × 22天 = 3,300 次
- 每次节省:5 分钟
- 月节省:275 小时
💵 预计月收益:
- 人力成本节省:275h × ¥100 = ¥27,500
📊 预计 ROI:
- 月 ROI:429%
- 回本周期:0.2 个月(约 4 天)
- 年化收益:¥330,000
📉 可视化建议:
- 成本 vs 收益对比饼图(收益是成本的 63 倍)
- 回本时间线(第4天即回本)
💡 结论:
⭐⭐⭐⭐⭐ 优秀
强烈建议立即开发,预计 4 天即可回本。
Notes
- Data accuracy: ROI calculation depends on accurate usage data, and regular statistics are recommended
- Intangible benefits: Some benefits are difficult to quantify (such as employee satisfaction), and can be included as supplementary explanations
- Long-term value: The value of some Skills can only be demonstrated through long-term observation
- Comparison benchmark: When calculating time saved, it is necessary to clarify what is being compared (manual operation vs. using the Skill)
- Reporting suggestions: When reporting to management, it is recommended to attach visual charts, highlighting the payback period and annualized returns