利润预测表

观测值销售预测12预测实际销售额残差341562.378219431.8523077440782.30523-9243.789123541267.3333458.81419586742492.22986014-4505.86986842421.9539160843637.386083991045621.56123-981.15642351142281.402027972-1912.2720281242211.1260839167456.713916143263.15612-6921.6701442070.5741958043260.625804242000.298251748-67.0582517543261.56562-123.3823077目标利润预测模型单位：元项目实际数值预测数值销售量5500056250单价65105.909090909091变动成本2524.0909090909091固定成本13000001250000目前利润900000目标利润950000利润敏感性分析模型项目实际数值变化后数值变化率控制条单位：元销售量550006600020值单价6552-2070变动成本25302030固定成本13000001040000-2070利润90000041200030-0.54222222单因素利润敏感性模型单位：元项目变化率利润利润变化量利润变化率销售量单价20412000-488000-0.54222222变动成本固定成本-20412000-488000-0.5422222220412000-488000-0.54222222-20412000-488000-0.54222222