盈亏平衡分析模型

经济保正点 分析 定性数据统计分析pdf销售业绩分析模板建筑结构震害分析销售进度分析表京东商城竞争战略分析 项目数值输入列1列2坐标点产销量固定成本变动成本总成本销售收入利润固定成本F2.57x000.002.570.02.570.0-2.57单位变动成本V38.24x110.1416042.571,590,952.611,590,955.181,396,660.02-194,295.16单位产品价格P33.57x220.1832092.573,181,905.223,181,907.792,793,320.03-388,587.75盈亏平衡量Q0-1x330.21248132.574,772,857.834,772,860.404,189,980.05-582,880.34盈亏平衡额S0-18x440.31664182.576,363,810.436,363,813.005,586,640.07-777,172.93销售量Q627695x550.32080222.577,954,763.047,954,765.616,983,300.09-971,465.53销售额R21071721.15x660.42496262.579,545,715.659,545,718.228,379,960.10-1,165,758.12总成本C24003059.37x770.42912312.5711,136,668.2611,136,670.839,776,620.12-1,360,050.71利润E-2931338.22x880.53328352.5712,727,620.8712,727,623.4411,173,280.14-1,554,343.301、输入固定成本、单位变动成本、单价产品价格、销售量，可即时进行量本利分析；各种特征线关系明确。2、滚动条控制(1)增大固定成本，保本点上移,反之下移；(2)增大变动成本，保本点上移,反之下移；(3)增大产品价格，保本点下移,反之上移；(4)增大销售量，安全余量增加，否则减少。3、以销售量约为保本量2倍，图形最为清楚。x990.63744402.5714,318,573.4814,318,576.0512,569,940.16-1,748,635.89x10100.64160442.5715,909,526.0915,909,528.6613,966,600.17-1,942,928.48x11110.74576492.5717,500,478.6917,500,481.2615,363,260.19-2,137,221.07x12120.84992532.5719,091,431.3019,091,433.8716,759,920.21-2,331,513.66x13130.85408572.5720,682,383.9120,682,386.4818,156,580.23-2,525,806.25x14140.95824622.5722,273,336.5222,273,339.0919,553,240.24-2,720,098.84x15150.96240662.5723,864,289.1323,864,291.7020,949,900.26-2,914,391.44x16161.06656712.5725,455,241.7425,455,244.3122,346,560.28-3,108,684.03保本点指示线保本额指示线-10.00.0-18.47-1(18)-0.55-18.47-121071721.15利润辅助线安全余量安全余量(627696)6276950-0.5521,071,721.15627695-2931338.22627,695.0021,071,721.1562769524003059.3762769521071721.151.05倍销售业绩633971.95销售实绩指示线2.12倍保本点-1627,695.000.0取较大值633972627,695.00-2,931,338.22627,695.0024,003,059.37627,695.0021,071,721.15QO=Sheet1!$D$6(即保本点),SO=Sheet1!$D$7,是定义的名称.量本利关系分析模版项目数值输入列1列2坐标点产销量固定成本变动成本总成本销售收入利润固定成本F30000x000.00300000.0030000.000.00(30000.00)单位变动成本V10x110.114733000014727.6944727.6923564.31(21163.38)单位产品价格P16x220.129463000029455.3959455.3947128.62(12326.77)盈亏平衡量Q05000x330.244183000044183.0874183.0870692.93(3490.15)盈亏平衡额S080000x440.358913000058910.7888910.7894257.245346.47销售量Q22220x550.373643000073638.47103638.47117821.5514183.08销售额R355520x660.488373000088366.16118366.16141385.8623019.70总成本C252200x770.41030930000103093.86133093.86164950.1731856.31利润E103320x880.51178230000117821.55147821.55188514.4840692.931、输入固定成本、单位变动成本、单价产品价格、销售量，可即时进行量本利分析；各种特征线关系明确。2、滚动条控制(1)增大固定成本，保本点上移,反之下移；(2)增大变动成本，保本点上移,反之下移；(3)增大产品价格，保本点下移,反之上移；(4)增大销售量，安全余量增加，否则减少。3、以销售量约为保本量2倍，图形最为清楚。x990.61325530000132549.24162549.24212078.7949529.55x10100.61472830000147276.94177276.94235643.1058366.16x11110.71620030000162004.63192004.63259207.4167202.78x12120.81767330000176732.33206732.33282771.7276039.40x13130.81914630000191460.02221460.02306336.0384876.01x14140.92061930000206187.71236187.71329900.3493712.63x15150.92209230000220915.41250915.41353464.65102549.24x16161.02356430000235643.10265643.10377028.96111385.86保本点指示线保本额指示线50000.00800005000800005000800005000355520利润辅助线安全余量安全余量(17220)2222005000355520222201033202222035552022220252200222203555201.05倍销售业绩22442.2销售实绩指示线2.12倍保本点8000222200取较大值22442222201033202222025220022220355520