Load context
On first use: Read ../../CLAUDE.md to obtain scenario-level configuration (KPI thresholds/budget variance standards/industry reference values).
/profit-analysis — Profit and Loss Statement Analysis
Examples
→ Example: The user says "Help us analyze the main changes in this month's profit and loss statement, and which line items have the greatest impact," and the system should invoke this skill to perform profit and loss statement change analysis.
→ Example: The user says "The gross margins of different product lines differ a lot; help me analyze the reasons," and the system should invoke this skill to perform product line gross margin variance analysis.
→ Example: The user says "Help us analyze the impact of price adjustments on profit; how much more can we earn with a 5% increase," and the system should invoke this skill to evaluate the sensitivity of profit to price changes.
Step 1: Obtain profit and loss statement data
Obtain profit and loss statement data from [ERP]:
□ 本期数据:[YYYY年MM月]
□ 上期数据:[YYYY年MM月]
□ 去年同期:[YYYY年MM月]
□ 预算数据:[YYYY年]全年预算
获取字段:
收入 | 成本 | 毛利 | 毛利率 | 费用 | 费用率 | 营业利润 | 净利率
Step 2: Revenue analysis
Three-dimensional revenue comparison:
| 本期 | 上期 | 去年同期 | 预算 |
|--------|----------|----------|----------|----------|
收入 | [XXX万] | [XXX万] | [XXX万] | [XXX万] |
环比变化| — | [±X万] | — | — |
同比变化| — | — | [±X万] | — |
预算差异| — | — | — | [±X万] |
Anomaly identification:
□ 收入同比下降 > [X]% → ⚠️ 须分析原因
□ 收入环比下降 > [X]% → ⚠️ 区分季节性/趋势性
□ 收入低于预算 > [X]% → ⚠️ 须分析预算偏差
Attribution analysis (by product/department/customer):
□ 哪个产品线收入变化最大?
□ 哪个部门收入变化最大?
□ 哪个客户贡献了主要变化?
□ 是否有一次性因素(季节性/促销/退货)?
Step 3: Cost analysis
Three-dimensional cost comparison:
| 本期 | 上期 | 去年同期 | 预算 |
|--------|----------|----------|----------|----------|
成本 | [XXX万] | [XXX万] | [XXX万] | [XXX万] |
毛利 | [XXX万] | [XXX万] | [XXX万] | [XXX万] |
毛利率 | [X%] | [X%] | [X%] | [X%] |
Gross profit anomaly identification:
□ 毛利率低于目标值 [X%] → ⚠️ 须分析原因
□ 毛利率同比下降 > [X%] → 🔴 结构性恶化
□ 毛利率环比下降 > [X%] → ⚠️ 短期波动/季节性
□ 毛利率低于预算 [X%] → ⚠️ 须解释偏差
Gross profit variance decomposition:
□ 销量变化贡献:[+,X万](量增/量减)
□ 价格变化贡献:[+,X万](价升/价降)
□ 成本变化贡献:[+,X万](成本升/成本降)
□ 结构变化贡献:[+,X万](产品/客户组合变化)
→ 合计差异:[+,X万] vs 预算/同期
Step 4: Expense analysis
Three-dimensional expense comparison:
| 本期 | 上期 | 去年同期 | 预算 |
|--------|----------|----------|----------|----------|
销售费用| [XXX万] | [XXX万] | [XXX万] | [XXX万] |
管理费用| [XXX万] | [XXX万] | [XXX万] | [XXX万] |
研发费用| [XXX万] | [XXX万] | [XXX万] | [XXX万] |
财务费用| [XXX万] | [XXX万] | [XXX万] | [XXX万] |
费用合计| [XXX万] | [XXX万] | [XXX万] | [XXX万] |
费用率 | [X%] | [X%] | [X%] | [X%] |
Expense anomaly identification:
□ 费用增长率 > 收入增长率 → ⚠️ 费用失控
□ 某项费用率高于目标 → ⚠️ 须分析
□ 费用超预算 > [X]% → ⚠️ 须解释
Expense attribution (by department/account):
□ 哪个部门费用超支最多?
□ 哪个费用科目变化最大?
□ 是否有战略性投入(主动扩张)?
□ 是否有失控性增长(须控制)?
Step 5: Profit analysis
Three-dimensional profit comparison:
| 本期 | 上期 | 去年同期 | 预算 |
|--------|----------|----------|----------|----------|
营业利润| [XXX万] | [XXX万] | [XXX万] | [XXX万] |
营业利润率| [X%] | [X%] | [X%] | [X%] |
净利润 | [XXX万] | [XXX万] | [XXX万] | [XXX万] |
净利率 | [X%] | [X%] | [X%] | [X%] |
Profit anomaly identification:
□ 单月亏损 → 🔴 须立即分析原因
□ 净利润低于预算 > [X]% → ⚠️ 须解释偏差
□ 利润率持续下降趋势 → ⚠️ 结构性恶化信号
Step 6: Generate profit analysis report
═══════════════════════════════════════
利润表分析报告
分析期间:[YYYY年MM月]
报告日期:[YYYY-MM-DD]
═══════════════════════════════════════
【收入分析】
□ 本期收入:[XXX万]
□ 环比:[±XXX万]([±X%])
□ 同比:[±XXX万]([±X%])
□ 预算差异:[±XXX万]([±X%])
异常识别:[✅ 正常 / ⚠️ 须关注 / 🔴 异常]
收入变化归因:
□ 销量贡献:[±XXX万]
□ 价格贡献:[±XXX万]
□ 结构贡献:[±XXX万]
TOP 变化产品/部门:
□ [产品/部门A]:收入变化 [±XXX万]
□ [产品/部门B]:收入变化 [±XXX万]
【成本分析】
□ 本期成本:[XXX万]
□ 本期毛利:[XXX万]
□ 毛利率:[X%](目标 [X%])
异常识别:[✅ 正常 / ⚠️ 须关注 / 🔴 异常]
毛利变化归因:
□ 销量贡献:[±XXX万]
□ 价格贡献:[±XXX万]
□ 成本贡献:[±XXX万]
□ 结构贡献:[±XXX万]
毛利率异常原因:
□ [描述]
【费用分析】
□ 本期费用合计:[XXX万]
□ 费用率:[X%](目标 [X%])
各费用明细:
□ 销售费用:[XXX万]([±X%])
□ 管理费用:[XXX万]([±X%])
□ 研发费用:[XXX万]([±X%])
□ 财务费用:[XXX万]([±X%])
费用异常项:[无/描述]
费用超支归因:
□ [部门/科目A]:[XXX万] 超支
□ [部门/科目B]:[XXX万] 超支
【利润分析】
□ 营业利润:[XXX万](目标 [XXX万])
□ 营业利润率:[X%](目标 [X%])
□ 净利润:[XXX万](目标 [XXX万])
□ 净利率:[X%](目标 [X%])
异常识别:[✅ 正常 / ⚠️ 须关注 / 🔴 异常]
【TOP 异常项】
□ [毛利异常项]:[描述] — 影响利润 [±XXX万]
□ [费用异常项]:[描述] — 影响利润 [±XXX万]
□ [其他异常项]:[描述] — 影响利润 [±XXX万]
【改善建议】
□ 毛利改善:
- [建议1]
- [建议2]
□ 费用控制:
- [建议1]
- [建议2]
□ 收入增长:
- [建议1]
- [建议2]
【下月关注】
□ [关注事项1]
□ [关注事项2]
═══════════════════════════════════════
置信度:[✅ 高 / ⚠️ 中 / 🔴 低]
数据截止:[YYYY-MM-DD]
═══════════════════════════════════════
Escalation trigger conditions
- Gross margin below the warning value for 2 consecutive months
- Revenue year-over-year decline > [X]%
- Single-month loss > [XXX万]
- Expenses exceed budget > [X]%
Finance Skills — profit-analysis atomic skill