吉首大学学报(自然科学版) ›› 2021, Vol. 42 ›› Issue (3): 87-91.DOI: 10.13438/j.cnki.jdzk.2021.03.015

• 管理与经济 • 上一篇    下一篇

新零售目标产品的精准需求分析与预测

郎红,常啸,李琴,宋国锋   

  1. (安徽财经大学统计与应用数学学院,安徽 蚌埠 233030)
  • 出版日期:2021-05-25 发布日期:2021-08-30
  • 通讯作者: 常啸(1981—),女,安徽固镇人,安徽财经大学统计与应用数学学院副教授,硕士生导师,主要从事经济统计研究.
  • 基金资助:
    国家自然科学基金资助项目(71974001);安徽财经大学教研项目(ACJYYB2020011)

Accurate Demand Analysis and Prediction for New Retail Target Products

LANG Hong, CHANG Xiao, LI Qin, SONG Guofeng   

  1. (College of Statistics and Applied Mathematics, Anhui University of Finance and Economics, Bengbu 233030, Anhui China)
  • Online:2021-05-25 Published:2021-08-30

摘要:首先,借助SPSS软件、R软件,结合单因素方差分析法和深层次回归分析法研究了零售商品单款单色(SKC)销售量的影响因素及其作用效力;然后,借助R软件灰色预测了某目标小类的销售量,借助Excel软件结合平均绝对百分比误差法得到了预测数据的精准度;最后,将预测模型用于预测某目标小类未来的销售量和库存量.结果表明,销售方式对零售商品SKC销售量具有显著影响;零售商品SKC销售量各影响因素按影响程度由大到小排序为库存、折扣和售价;目标小类各周平均绝对百分比误差大多小于或等于1,最小为0,可认为模型的预测精度较高.对某目标小类未来的销售量和库存量的预测结果显示,该小类存来明显的供大于求现象,需要适当调整库存管理策略.

关键词: 精准零售, 需求预测, 单因素方差分析, 深层次回归分析, 灰色预测

Abstract: Firstly, the factors influencing the sales volume of SKC (Stock Keeping Color) of retail products and their effectiveness are studied with SPSS and R softwares, combined with one-way ANOVA and deep regression analysis. Then, the sales volume of a target subcategory is predicted in grey model with R software, and the accuracy of the prediction data is obtained with Excel software combined with the mean absolute percentage error method. Finally, the prediction model is used to predict the sales and inventory of a target category. The results show that the sales method has a significant effect on the SKC sales volume of retail products; the factors influencing the SKC sales volume of retail products include inventory, discount and selling price; the average absolute percentage error of the target subcategory in each week is mostly less than or equal to 1, and the smallest is 0, which can be considered as a high prediction accuracy of the model. The prediction results of the future sales and inventory of a target subcategory show that the supply of this subcategory is obviously higher than the demand, and the inventory management strategy needs to be adjusted appropriately.

Key words: precise retail, demand prediction, one-way ANOVA, deep regression analysis, grey prediction

公众号 电子书橱 超星期刊 手机浏览 在线QQ