盈亏平衡点分析

产品 售价 变动成本 固定成本 固定成本A 30 15 50000 70000 15B 26 21 18000 31000固定成本 保本点18000 263919300 282920600 3020 1052.63221900 321123200 340124500 359225800 378227100 397328400 416429700 435431000 4545价格变动率2 6 3 92 8 2 93 0 2 03 2 1 13 4 0 13 5 9 23 7 8 23 9 7 34 1 6 44 3 5 44 5 4 51 8 0 0 0 1 9 3 0 0 2 0 6 0 0 2 1 9 0 0 2 3 2 0 0 2 4 5 0 0 2 5 8 0 0 2 7 1 0 0 2 8 4 0 0 2 9 7 0 0 3 1 0 0 02 6 3 93 1 3 93 6 3 94 1 3 94 6 3 9+ 7 %18-10% -0.1-9% -0.09-8% -0.08-7% -0.07-6% -0.06-5% -0.05-4% -0.04-3% -0.03-2% -0.02-1% -0.010% 0+1% 0.01+2% 0.02+3% 0.03+4% 0.04+5% 0.05+6% 0.06+7% 0.07+8% 0.08+9% 0.09+10% 0.12 6 3 92 8 2 93 0 2 03 2 1 13 4 0 13 5 9 23 7 8 23 9 7 34 1 6 44 3 5 44 5 4 51 8 0 0 0 1 9 3 0 0 2 0 6 0 0 2 1 9 0 0 2 3 2 0 0 2 4 5 0 0 2 5 8 0 0 2 7 1 0 0 2 8 4 0 0 2 9 7 0 0 3 1 0 0 02 6 3 93 1 3 93 6 3 94 1 3 94 6 3 9+ 7 %31%1 1312 171.613 224.80914 294.49995 385.79496 505.39137 662.06268 867.3029 1136.16610 1488.37711 1949.77412 2554.2041 3 5 7 9 1 105 0 01 0 0 01 5 0 02 0 0 02 5 0 03 0 0 0S e r i e s 231a 30 15 50000 70000 -10.00%b 26 21 18000 30000 -9.00%-8.00%-7.00%50000 3144.654 -6.00%52000 3270.44 -5.00%54000 3396.226 -4.00%56000 3522.013 -3.00%58000 3647.799 -2.00%60000 3773.585 -1.00%62000 3899.371 0.00%64000 4025.157 1.00%66000 4150.943 2.00%68000 4276.73 3.00%70000 4402.516 4.00%5.00%6.00%7.00%8.00%9.00%10.00%3 .0 0 %3 1 4 4 . 6 5 4 0 8 83 2 7 0 . 4 4 0 2 5 23 3 9 6 . 2 2 6 4 1 53 5 2 2 . 0 1 2 5 7 93 6 4 7 . 7 9 8 7 4 23 7 7 3 . 5 8 4 9 0 63 8 9 9 . 3 7 1 0 6 94 0 2 5 . 1 5 7 2 3 34 1 5 0 . 9 4 3 3 9 64 2 7 6 . 7 2 9 5 64 4 0 2 . 5 1 5 7 2 350000520005400056000580006000062000640006600068000700002 0 0 03 0 0 04 0 0 05 0 0 0143 1 4 4 . 6 5 4 0 8 83 2 7 0 . 4 4 0 2 5 23 3 9 6 . 2 2 6 4 1 53 5 2 2 . 0 1 2 5 7 93 6 4 7 . 7 9 8 7 4 23 7 7 3 . 5 8 4 9 0 63 8 9 9 . 3 7 1 0 6 94 0 2 5 . 1 5 7 2 3 34 1 5 0 . 9 4 3 3 9 64 2 7 6 . 7 2 9 5 64 4 0 2 . 5 1 5 7 2 350000520005400056000580006000062000640006600068000700002 0 0 03 0 0 04 0 0 05 0 0 0