办公必备excel模板-根据量本利分析绘制产品的盈亏图表

单位可变成本V单位售价P保本销售量保本销售收入

盈亏平衡线销售量284211284211￥270,000.00销售量总成本

收入

￥1.550￥270,000.00￥0.00

￥2.50￥25.0050000￥347,500.00￥125,000.00284211100000￥425,000.00￥250,000.00￥710,526.32150000￥502,500.00

￥375,000.00200000￥580,000.00￥500,000.00250000￥657,500.00￥625,000.00300000￥735,000.00

￥750,000.00350000￥812,500.00￥875,000.00收入/利润400000￥0,000.00

￥1,000,000.00￥-500,000450000￥967,500.00￥1,125,000.00￥2,000,000500000￥1,045,000.00

￥1,250,000.00

收入/利润盈亏分析图￥2,000,000￥1,500,000￥1,000,000￥500,000￥00 100000 200000 300000 400000 500000￥-500,000总成本收入利润盈亏平衡线盈亏平衡线销售量收入/利润

284210.5263-500000284210.52632000000

利润

￥-270,000.00￥-222,500.00￥-175,000.00￥-127,500.00￥-80,000.00￥-32,500.00￥15,000.00￥62,500.00￥110,000.00￥157,500.00￥205,000.00

销售量00000