商场营销策略之“薄利多销”原则分析  

Analysis of the Principle of "Small Profits but Quick Turnover" in Shopping Mall Marketing Strategies

作　　者：毕丽萍 BI Li-ping(Shandong University of Engineering and Vocational Technology,Ji'nan 250000,China)

机构地区：[1]山东工程职业技术大学,济南250000

出　　处：《价值工程》2020年第28期105-107,共3页Value Engineering

基　　金：信息技术环境下高等数学课程教学模式改革研究。

摘　　要：本文从商场营销策略的数据分析和处理出发,运用EXCEL的数据分析功能和VLOOKUP函数,分别从销售额和打折力度两个角度进行研究,通过计算每天的利润率以及单个商品的折扣,进而求出此时间段内每一类目商品的折扣,目的是寻求一种降低单位商品的利润来增加销售数量,使商家获得更多盈利的扩大销售的策略。This article starts from the data analysis and processing of the shopping mall marketing strategy,uses the data analysis function of EXCEL and the VLOOKUP function to study from the two perspectives of sales and discount strength,and calculates the daily profit rate and the discount of a single product,and then finds the discount of each category of goods in this time period.The purpose is to find a strategy to increase sales by reducing the profit per unit of goods to increase the number of sales,so that the business can obtain more profits.

关 键 词：VLOOKUP函数 sumif函数 数据透视图 加权平均法 

分 类 号：F274[经济管理—企业管理]