企业销售费用分析与预测

一、使用LOGEST曲线拟合函数预测月份7月8月9月10月11月12月合计目标销量238002400024300250002600027000150100广告费12000.0012000.0012000.0012000.0012000.0012000.0072000.00差旅费6318.826299.656271.016204.696111.166019.0437224.38展览费7148.257131.577106.637048.776966.926886.0342288.18销售部员薪资10605.8810594.0410576.3010535.0310476.3410417.9863205.57运输费4037.124014.073979.753900.813790.743683.7823406.27二、使用GROWTH预测下半年费用月份7月8月9月10月11月12月合计目标销量238002400024300250002600027000150100广告费12000.0012000.0012000.0012000.0012000.0012000.0072000.00差旅费6318.826299.656271.016204.696111.166019.0437224.38展览费7148.257131.577106.637048.776966.926886.0342288.18销售部员薪资10605.8810594.0410576.3010535.0310476.3410417.9863205.57运输费4037.124014.073979.753900.813790.743683.7823406.27其他1807.351803.291797.211783.101763.151743.4110697.50合计41,917.4241,842.6341,730.9041,472.4041,108.3140,750.24248821.91其他1807.351803.291797.211783.101763.151743.4110697.50合计41917.4241842.6341730.9041472.4041108.3140750.24248821.91