Store net sales and contribution
Compare six stores after refunds and merchandise costs, beyond headline sales.
992,200 CNYNet sales
355,200 CNYContribution
35.8%Contribution margin
Synthetic operational data · fixed-result walkthrough · Chinese synthetic narration with bilingual subtitles. Runtime is not generation latency. Healthcare cases contain no real patient data. Outputs and chart labels are in Chinese.
净销售额(元)
- Net sales: 992,200元, traceable row by row to the input file.
- Net sales = gross sales − refunds; contribution = net sales − merchandise costs, excluding rent and staff.
Inputs & prompt
Read the full prompt
Analyze store net sales and contribution. Net sales = gross sales − refunds; contribution = net sales − merchandise costs, excluding rent and staff. Preserve inputs and calculated values by 门店, reconcile totals, and export a table, chart, Excel and offline HTML. Do not infer causation from descriptive changes.
Inspect calculated rows
| 门店 | 销售毛额(元) | 退款(元) | 商品成本(元) | 净销售额(元) | 贡献毛利(元) |
|---|---|---|---|---|---|
| 滨江店 | 185000 | 4500 | 113000 | 180500 | 67500 |
| 中央店 | 230000 | 11000 | 144000 | 219000 | 75000 |
| 西城店 | 142000 | 3200 | 94000 | 138800 | 44800 |
| 北站店 | 178000 | 7000 | 105000 | 171000 | 66000 |
| 大学城店 | 163000 | 6000 | 102000 | 157000 | 55000 |
| 社区店 | 128000 | 2100 | 79000 | 125900 | 46900 |