金牌店长培训-数据分析

单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,*,金苑浙江分公司金牌店长培训,金,苑,苑,浙,浙,江,江,分,分,公,公,司,司,林,鑫,鑫,金,牌,牌,店,店,长,长,培,培,训,训,1,数,据,据,分,分,析,析,2,单款占,比,比计算,公,公式,单款销,售,售金额=,单款零,售,售价,单款销,售,售件数,单款占,比,比公式=,（单款,销,销售金,额,额,总销售,额,额）,100%,本周E85003销,售,售5件,，,，吊牌,价,价338元，,本,本周总,业,业绩58930元。,请,请问该,款,款销售,金,金额及,占,占比多,少,少？,单款销,售,售金额=,338,5=1690,单款占,比,比=,1690 58930,100%=2.9%,3,十大占,比,比公式,十大占,比,比公式=,（十大,总,总销售,金,金额,总销售,额,额）,100%,本周前,十,十大畅,销,销款总,销,销售额45000元,，,，本周,总,总业绩120000,请,请问前,十,十大占,比,比多少,？,？,前十大,占,占比=,75000,120000 100%=62.5%,4,减价公,式,式,持平件,数,数=（原零,售,售价,原销售,件,件数),现零售,价,价,件数升,幅,幅（倍,数,数）=（减价,后,后销售,件,件数,减价前,销,销售件,数,数）-,1,或,（,减价后,销,销售件,数,数,-,减价前,销,销售件,数,数）,减价前,销,销售件,数,数,100%,上周E83003（,吊,吊牌价338,元,元）才,销,销售5,件,件，现,有,有库存50件,，,，本周,推,推出新,活,活动，,将,将该款,调,调为298元,。,。减价,后,后该款,本,本周销,量,量达到10件,，,，请问,降,降价后,要,要增加,多,多少销,量,量才能,与,与原价,持,持平？,减,减价后,销,销售件,数,数有多,大,大变化,？,？,持平件,数,数=,（338 5）,298=5.67,件数升,幅,幅=,（10-5）5=100%,5,赠品公,式,式,赠品成,功,功率=,（送出,赠,赠品件,数,数,推广买,满,满金额,）,）,总销售,额,额,100,国庆推,出,出新活,动,动，买,满,满358送BOBO,熊,熊一只,。,。本周,销,销售额,突,突飞猛,进,进，达,到,到98650,元,元，共,送,送出98只BOBO,熊,熊。请,问,问此次,促,促销活,动,动效果,如,如何？,促销成,功,功率=,（98,358）,98650 100%=35.56%,一个成,功,功的促,销,销，活,动,动占比,至,至少占,了,了销售,金,金额的35%,以,以上。,6,类别计,算,算公式,类别占,比,比=,整个类,别,别总金,额,额,总销售,额,额,100%,假设本,周,周销售,货,货品只,有,有ABC类，,其,其中A,类,类货品,销,销售150件,，,，金额18790元,；,；B类,货,货品90件，,金,金额8900,元,元；C,类,类货品,共,共销售11件,，,，金额2450元，,请,请问C,类,类货品,占,占比多,少,少？,C类占,比,比=,2450,（,（18790+8900+2450）100%=8.12%,7,重点推,广,广公式,重点推,广,广占比=,（重点,推,推广货,品,品销售,额,额,总销售,额,额）,100%,备注：,占,占销售,额,额8%-10%为成,功,功,上周E83003（,吊,吊牌价338,元,元）才,销,销售5,件,件，现,有,有库存50件,，,，店长,决,决定本,周,周将重,点,点处理,该,该款库,存,存，并,陈,陈列于,由,由资源,导,导购负,责,责销售,的,的重点,区,区域A,区,区。本,周,周统计,该,该款销,售,售12,件,件，本,周,周总业,绩,绩26890,元,元，请,问,问该款,重,重点推,广,广效果,如,如何？,E83003,占,占比=,（12 338）26890,100%=15.08%,8,其他计,算,算,第二件,五,五折、,两,两件七,折,折、买,二,二送一,等,等活动,推广成,功,功率,（人工,统,统计购,买,买两件,的,的单数,当天,总,总单数,）,）,100%,一个成,功,功的促,销,销，活,动,动占比,至,至少占,了,了35%以上,。,。,上周业,绩,绩不理,想,想，店,铺,铺库存,过,过大，,店,店长决,定,定本周,将,将推出,买,买二送,一,一活动,以,以便清,理,理库存,。,。本周,推,推出后,，,，周一,参,参与活,动,动的客,户,户达15单，,当,当天共,计,计38,单,单，业,绩,绩3560元,。,。请问,推,推广效,果,果如何,？,？,推广成,功,功率=,1538,100%=39.47%,9,举例,10,11,12,13,销售报,表,表,14,数字游,戏,戏,寻找一,位,位同事,协,协助,请志愿,者,者任意,写,写出三,位,位数字A（注意,：,：百位,数,数字比,个,个位数,字,字大2,）,）,交换百,位,位数字,与,与个位,数,数字，,得,得B,用大数,减,减去小,数,数，得C,将C的,百,百位数,字,字与个,位,位数字,交,交换，,得,得D,将D和C相加,，,，得E,E=?,15,答案=1089,例如：785587785-587=198891198+891=1089,代数公,式,式：A+10B+100(A+2),16,周报表,分,分析-,目,目标分,析,析,时间,月目标,周目标,实际完成,周完成率,累计完成,月完成率,上周,150000,30000,32000,80000.00,本周,45000,43500,123500.00,周比,完成率=实际,完,完成金,额,额/目,标,标金额*100%,周,周比=,本,本周/,上,上周-1,107%,53%,97%,50.00%,35.94%,-9.38%,54.38%,54.38%,82%,17,周报表,分,分析-,客,客单价,及,及附加,分,分析,客单价=每单,金,金额=,实,实际销,售,售金额/开单,数,数附,加,加率=,每,每单件,数,数=销,售,售件数/开单,数,数,时间,实际完成,开单数,销售件数,每单金额,每单件数,上周,32000,200,250,本周,43500,300,300,周比,35.94%,50.00%,20.00%,-9.38%,-20.00%,160,1.25,145,1.00,18,周报表,分,分析-,物,物流及,服,服务分,析,析,补货及,时,时率=,到,到货次,数,数/补,货,货次数*100%,配,配发比,率,率=实,际,际配发,数,数量/,补,补货数,量,量*100%,坪,坪效=实际,完,完成营,业,业额/,店,店铺面,积,积,时间,实际完成,补货次数,到货次数,补货及时率,补货件数,实配件数,配发比率,客户退货数量,坪效,上周,32000,2,1,50%,200,230,115%,1,533,本周,43500,1,1,100%,100,45,45%,0,725,周比,35.94%,-50%,0.00%,100%,-50%,-80.43%,-60.87%,-100%,35.94%,19,周报表,分,分析-,每,每日业,绩,绩分析,时间,星期一,星期二,星期三,星期四,星期五,星期六,星期日,前周业绩,1000,990,1450,1100,1000,1000,1500,上周业绩,4000,1000,1300,1090,1100,1300,1501,跌/升幅度,300.00%,1.01%,-10.34%,-0.91%,10.00%,30.00%,0.07%,上周天气,晴,晴,晴,晴,晴,晴,晴,销售件数,12,21,22,23,24,25,4,交易笔数,5,6,7,8,9,10,8,销售平均折扣,98%,100%,98%,100%,98%,100%,100%,客单价,800.00,166.67,185.71,136.25,122.22,130.00,187.63,附加率,2.40,3.50,3.14,2.88,2.67,2.50,0.50,促销业绩比,60.00%,每日目标,3000,900,1500,1000,1200,1200,1600,目标完成率,133.33%,111.11%,86.67%,109.00%,91.67%,108.33%,93.81%,销售平,均,均折扣=总销,售,售额/,总,总吊牌,价,价促,销,销业绩,比,比=促,销,销金额/总销,售,售额,20,周报表,分,分析-,销,销售时,段,段业绩,分,分析,试衣率=进店,数,数/试,衣,衣数,成,成交率=试衣,率,率/买,单,单数,时段,销售额,销售件数,交易笔数,客单价,进店数,试衣数,试衣率,成交率,销售占比,08:00-12:00,222,2,1,222.00,25,9,36%,4%,15%,12:00-14:00,324,3,2,162.00,35,12,34%,6%,21%,14:00-18:00,325,2,2,162.50,100,35,35%,2%,21%,18:00-20:00,326,2,2,163.00,45,5,11%,4%,21%,20:00-22:00,327,2,2,163.50,65,3,5%,3%,21%,汇总,1524,11,9,114.30,270,64,24%,4%,100%,21,周报表,分,分析-,员,员工业,绩,绩分析,员工姓名,上周排名,前周销售额,上周销售额,跌/升幅度,上周目标,目标完成率,本月目标,月目标累计,月目标完成率,周销售占比,早班业绩,中班业绩,晚班业绩,甲,1,2222,2266,1.98%,3333,68%,13000,4500,35%,29.57%,222,333,345,乙,2,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,丙,3,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,丁,4,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,戊,5,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,己,6,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,庚,7,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,辛,8,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,壬,9,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,癸,10,3333,4566,36.99%,3333,137%,13000,4500,35%,59.58%,222,333,345,平均值,3222,4336,33.49%,3333,130%,13000,4500,35%,56.58%,222,333,345,分析每,周,周员工,业,业绩有,助,助于了,解,解员工,的,的工作,状,状态，,结,结合员,工,工班次,表,表等信,息,息可以,帮,帮助员,工,工分析,业,业绩原,因,因并及,时,时修正,和,和指导,。,。,22,周报表分,析,析-店铺,区,区位业绩,分,分析,分析每周,区,区位业绩,有,有助于了,解,解各区的,业,业绩情况,，,，以便及,时,时修正人,员,员站位、,货,货品陈列,、,、班次等,。,。,区位,员工姓名,前周销售额,上周销售额,跌/升幅度,销售占比,A区,甲,2222,3333,150.00%,20.32%,B