【精选】本量利分析图模型构建Excel模板

盈亏平衡点889 827

销售量销售收入总成本销售利润

300 35,550 74,300 -38,750

400 47,400 78,800 -31,400

500 59,250 83,300 -24,050

600 71,100 87,800 -16,700

700 82,950 92,300 -9,350

800 94,800 96,800 -2,000

900 106,650 101,300 5,350

1,000 118,500 105,800 12,700

1,100 130,350 110,300 20,050

1,200 142,200 114,800 27,400

1,300 154,050 119,300 34,750

1,400 165,900 123,800 42,100

1,500 177,750 128,300 49,450

1,600 189,600 132,800 56,800

1,700 201,450 137,300 64,150

1,800 213,300 141,800 71,500

1,900 225,150 146,300 78,850

2,000 237,000 150,800 86,200

2,100 248,850 155,300 93,550

2,200 260,700 159,800 100,900

2,300 272,550 164,300 108,250

2,400 284,400 168,800 115,600

2,500 296,250 173,300 122,950

2,500 296,250 173,300 122,950

2,700 319,950 182,300 137,650

827 -38,750

827 98,000

827 319,950 基本数据

绘图数据

-100,000

-50,000 - 50,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 300 600 金额

本量利分析图

盈亏平衡线, 827

900 1,200 1,500 1,800 2,100 2,400 2,700

销售量

销售收入总成本销售利润盈亏平衡线