品类管理-品类单品数分析

上传人：1*** IP属地：北京上传时间：2024-01-25 格式：XLS 页数：35 大小：149.50KB 积分：1.2 举报 版权申诉

已阅读5页，还剩30页未读，继续免费阅读

版权说明：本文档由用户提供并上传，收益归属内容提供方，若内容存在侵权，请进行举报或认领

文档简介

数量,SKU,销售金额,单品销售占品类比,单品累计销售占比,,,,,,,

1,41141033,57789.52,3.76%,3.76%,,,,,,,

2,41141022,56068.37,3.65%,7.41%,,,,,,,

3,41152002,55634.1,3.62%,11.03%,,,,,,,

4,41151024,52590.15,3.42%,14.45%,,,,,,,

5,41143022,47436.7,3.09%,17.53%,,,,,,,

6,41144003,43964.69,2.86%,20.39%,,,,,,,

7,41141039,42756.78,2.78%,23.17%,,,,,,,

8,41141025,42065.9,2.74%,25.91%,,,,,,,

9,41153009,39787.93,2.59%,28.50%,,,,,,,

10,41144005,38039.69,2.47%,30.97%,,,,,,,

11,41143007,32317.28,2.10%,33.08%,,,,,,,

12,41153053,27299.7,1.78%,34.85%,,,,,,,

13,41141026,25733.6,1.67%,36.53%,,,,,,,

14,41151018,24820.1,1.61%,38.14%,,,,,,,

15,41153063,24630.7,1.60%,39.74%,,,,,,,

16,41141027,23921.4,1.56%,41.30%,,,,,,,

17,41143023,23622,1.54%,42.83%,,,,,,,

18,41151001,21411,1.39%,44.23%,,,,,,,

19,41143010,20602.58,1.34%,45.57%,,,,,,,

20,41141007,19964.9,1.30%,46.87%,,,,,,,

21,41153016,18815.74,1.22%,48.09%,,,,,,,

22,41141038,18514.94,1.20%,49.29%,,,,,,,

23,41143020,17755.5,1.15%,50.45%,,,,,,,

24,41153065,16713,1.09%,51.54%,,,,,,,

25,41141024,16651.2,1.08%,52.62%,,,品类SKU数,销售占比80%SKU数,占比,销售占比90%SKU数,占比

26,41151021,15734.4,1.02%,53.64%,,,206,67,32.52%,97,47.09%

27,41141004,15519.9,1.01%,54.65%,,,,,,,

28,41151026,15239.22,0.99%,55.64%,,,,,,,

29,41151007,14500.8,0.94%,56.59%,,计算公式,,,,,

30,41148004,14347.9,0.93%,57.52%,,单品销售占比=单品销售除品类销售,,,,,

31,41153057,13502.2,0.88%,58.40%,,累计销售占比=单品销售占比降序后累计相加,,,,,

32,41141014,13143.57,0.85%,59.25%,,,,,,,

33,41143003,12186.9,0.79%,60.05%,,,,,,,

34,41141011,12139.52,0.79%,60.84%,,,,,,,

35,41143016,11533.9,0.75%,61.59%,,,,,,,

36,41123002,11412.6,0.74%,62.33%,,,,,,,

37,41151005,11377.2,0.74%,63.07%,,,,,,,

38,41143029,11297.9,0.73%,63.80%,,,,,,,

39,41141012,10862.1,0.71%,64.51%,,,,,,,

40,41153056,10487.3,0.68%,65.19%,,,,,,,

41,41148001,10325.7,0.67%,65.86%,,,,,,,

42,41141001,10309.95,0.67%,66.54%,,,,,,,

43,41151033,10149.8,0.66%,67.20%,,,,,,,

44,41151036,9919.9,0.65%,67.84%,,,,,,,

45,41153058,9590.6,0.62%,68.46%,,,,,,,

46,41153014,9109.8,0.59%,69.06%,,,,,,,

47,41141040,8966.2,0.58%,69.64%,,,,,,,

48,41145001,8951.6,0.58%,70.22%,,,,,,,

49,41151015,8594.3,0.56%,70.78%,,,,,,,

50,41151016,8528.4,0.55%,71.34%,,,,,,,

51,41133004,8446.1,0.55%,71.89%,,,,,,,

52,41151048,8236.8,0.54%,72.42%,,,,,,,

53,41151020,8010.61,0.52%,72.94%,,,,,,,

54,41153022,7942.7,0.52%,73.46%,,,,,,,

55,41141010,7883.1,0.51%,73.97%,,,,,,,

56,41133003,7799,0.51%,74.48%,,,,,,,

57,41143014,7664.5,0.50%,74.98%,,,,,,,

58,41151045,7614.1,0.50%,75.47%,,,,,,,

59,41143024,7555.5,0.49%,75.97%,,,,,,,

60,41151023,7422.6,0.48%,76.45%,,,,,,,

61,41148003,7380.1,0.48%,76.93%,,,,,,,

62,41153064,7276.5,0.47%,77.40%,,,,,,,

63,41153044,7273.5,0.47%,77.87%,,,,,,,

64,41143030,7107.3,0.46%,78.34%,,,,,,,

65,41141037,7099.8,0.46%,78.80%,,,,,,,

66,41133007,7087.2,0.46%,79.26%,,,,,,,

67,41151054,6936,0.45%,79.71%,,,,,,,

68,41151002,6769.3,0.44%,80.15%,,,,,,,

69,41143012,6540.3,0.43%,80.58%,,,,,,,

70,41141034,6296.7,0.41%,80.99%,,,,,,,

71,41151027,5961.9,0.39%,81.37%,,,,,,,

72,41151014,5868.2,0.38%,81.76%,,,,,,,

73,41123003,5811.01,0.38%,82.13%,,,,,,,

74,41153051,5779.8,0.38%,82.51%,,,,,,,

75,41133008,5710.1,0.37%,82.88%,,,,,,,

76,41153042,5665.5,0.37%,83.25%,,,,,,,

77,41153062,5596.2,0.36%,83.61%,,,,,,,

78,41151044,5572.6,0.36%,83.98%,,,,,,,

79,41144023,5493.7,0.36%,84.33%,,,,,,,

80,41153020,5355,0.35%,84.68%,,,,,,,

81,41144015,5317.2,0.35%,85.03%,,,,,,,

82,41143008,5305.04,0.35%,85.37%,,,,,,,

83,41141030,5297.4,0.34%,85.72%,,,,,,,

84,41141029,5248.1,0.34%,86.06%,,,,,,,

85,41156017,5135.8,0.33%,86.39%,,,,,,,

86,41143015,5065.2,0.33%,86.72%,,,,,,,

87,41151037,4976.2,0.32%,87.05%,,,,,,,

88,41144002,4953.6,0.32%,87.37%,,,,,,,

89,41153047,4626.9,0.30%,87.67%,,,,,,,

90,41141036,4549,0.30%,87.97%,,,,,,,

91,41143011,4478.23,0.29%,88.26%,,,,,,,

92,41143004,4457.1,0.29%,88.55%,,,,,,,

93,41131003,4396.3,0.29%,88.83%,,,,,,,

94,41141006,4286.56,0.28%,89.11%,,,,,,,

95,41151046,4246.2,0.28%,89.39%,,,,,,,

96,41153023,4120.03,0.27%,89.66%,,,,,,,

97,41131002,4083.5,0.27%,89.92%,,,,,,,

98,41151043,4072.9,0.26%,90.19%,,,,,,,

99,41153048,4067.7,0.26%,90.45%,,,,,,,

100,41151008,3976.3,0.26%,90.71%,,,,,,,

101,41151047,3971.1,0.26%,90.97%,,,,,,,

102,41131001,3955.9,0.26%,91.23%,,,,,,,

103,41151012,3831.3,0.25%,91.47%,,,,,,,

104,41153045,3766.5,0.25%,91.72%,,,,,,,

105,41145002,3752.4,0.24%,91.96%,,,,,,,

106,41143001,3653.3,0.24%,92.20%,,,,,,,

107,41153046,3618,0.24%,92.44%,,,,,,,

108,41141016,3586.2,0.23%,92.67%,,,,,,,

109,41143019,3575.9,0.23%,92.90%,,,,,,,

110,41143018,3562,0.23%,93.13%,,,,,,,

111,41153011,3532.5,0.23%,93.36%,,,,,,,

112,41141003,3531.6,0.23%,93.59%,,,,,,,

113,41153007,3370,0.22%,93.81%,,,,,,,

114,41123008,3342.3,0.22%,94.03%,,,,,,,

115,41143028,3225.1,0.21%,94.24%,,,,,,,

116,41144006,3114,0.20%,94.44%,,,,,,,

117,41143017,3096.3,0.20%,94.64%,,,,,,,

118,41123004,2981.4,0.19%,94.84%,,,,,,,

119,41151040,2864,0.19%,95.02%,,,,,,,

120,41151049,2714.1,0.18%,95.20%,,,,,,,

121,41142002,2636.4,0.17%,95.37%,,,,,,,

122,41151019,2562.72,0.17%,95.54%,,,,,,,

123,41144004,2520.7,0.16%,95.70%,,,,,,,

124,41153001,2432,0.16%,95.86%,,,,,,,

125,41141019,2420,0.16%,96.02%,,,,,,,

126,41153050,2380.8,0.15%,96.17%,,,,,,,

127,41153002,2336,0.15%,96.33%,,,,,,,

128,41153054,2275,0.15%,96.47%,,,,,,,

129,41141018,2256.9,0.15%,96.62%,,,,,,,

130,41123009,2219.3,0.14%,96.76%,,,,,,,

131,41153061,2118.3,0.14%,96.90%,,,,,,,

132,41156024,2094.3,0.14%,97.04%,,,,,,,

133,41151051,2091.57,0.14%,97.17%,,,,,,,

134,41153010,2074,0.13%,97.31%,,,,,,,

135,41144019,2057,0.13%,97.44%,,,,,,,

136,41153004,1912.5,0.12%,97.57%,,,,,,,

137,41153013,1904.1,0.12%,97.69%,,,,,,,

138,41153003,1900.9,0.12%,97.82%,,,,,,,

139,41144001,1848,0.12%,97.94%,,,,,,,

140,41151042,1840.7,0.12%,98.06%,,,,,,,

141,41152001,1807.9,0.12%,98.17%,,,,,,,

142,41133006,1777.5,0.12%,98.29%,,,,,,,

143,41144016,1755,0.11%,98.40%,,,,,,,

144,41148002,1682.6,0.11%,98.51%,,,,,,,

145,41141035,1639,0.11%,98.62%,,,,,,,

146,41153019,1584,0.10%,98.72%,,,,,,,

147,41144024,1556.37,0.10%,98.82%,,,,,,,

148,41153052,1530.9,0.10%,98.92%,,,,,,,

149,41133002,1312.5,0.09%,99.01%,,,,,,,

150,41133001,1312.3,0.09%,99.09%,,,,,,,

151,41143009,1292,0.08%,99.18%,,,,,,,

152,41143027,1248.9,0.08%,99.26%,,,,,,,

153,41153021,1081.6,0.07%,99.33%,,,,,,,

154,41143021,1026,0.07%,99.40%,,,,,,,

155,41123007,779,0.05%,99.45%,,,,,,,

156,41142001,777.4,0.05%,99.50%,,,,,,,

157,41151055,647.59,0.04%,99.54%,,,,,,,

158,41151006,594,0.04%,99.58%,,,,,,,

159,41151013,588.6,0.04%,99.62%,,,,,,,

160,41153043,580,0.04%,99.65%,,,,,,,

161,41143002,574.6,0.04%,99.69%,,,,,,,

162,41144017,479.7,0.03%,99.72%,,,,,,,

163,41144022,464,0.03%,99.75%,,,,,,,

164,41151010,450.3,0.03%,99.78%,,,,,,,

165,41151050,388.6,0.03%,99.81%,,,,,,,

166,41151030,348.3,0.02%,99.83%,,,,,,,

167,41153055,342.7,0.02%,99.85%,,,,,,,

168,41151011,293.7,0.02%,99.87%,,,,,,,

169,41153008,231.2,0.02%,99.89%,,,,,,,

170,41143026,194.7,0.01%,99.90%,,,,,,,

171,41151031,168.3,0.01%,99.91%,,,,,,,

172,41144021,158.4,0.01%,99.92%,,,,,,,

173,41141002,142.8,0.01%,99.93%,,,,,,,

174,41151004,117.3,0.01%,99.94%,,,,,,,

175,41141028,90,0.01%,99.94%,,,,,,,

176,41141005,76.5,0.00%,99.95%,,,,,,,

177,41141032,75.9,0.00%,99.95%,,,,,,,

178,41141021,71.1,0.00%,99.96%,,,,,,,

179,41153060,64.9,0.00%,99.96%,,,,,,,

180,41143025,58.8,0.00%,99.97%,,,,,,,

181,41141008,52.2,0.00%,99.97%,,,,,,,

182,41141023,41.3,0.00%,99.97%,,,,,,,

183,41151022,39,0.00%,99.97%,,,,,,,

184,41151034,35.7,0.00%,99.98%,,,,,,,

185,41141017,31.6,0.00%,99.98%,,,,,,,

186,41123001,27,0.00%,99.98%,,,,,,,

187,41151025,26.4,0.00%,99.98%,,,,,,,

188,41141015,26,0.00%,99.98%,,,,,,,

189,41141031,23.4,0.00%,99.99%,,,,,,,

190,41151003,20.7,0.00%,99.99%,,,,,,,

191,41151029,19,0.00%,99.99%,,,,,,,

192,41151053,15.2,0.00%,99.99%,,,,,,,

193,41151028,14.6,0.00%,99.99%,,,,,,,

194,41153015,14.6,0.00%,99.99%,,,,,,,

195,41143006,14,0.00%,99.99%,,,,,,,

196,41123006,13.6,0.00%,99.99%,,,,,,,

197,41144014,13,0.00%,99.99%,,,,,,,

198,41153005,12.3,0.00%,99.99%,,,,,,,

199,41123005,11,0.00%,99.99%,,,,,,,

200,41151017,10.5,0.00%,100.00%,,,,,,,

201,41141020,9.9,0.00%,100.00%,,,,,,,

202,41153018,8.5,0.00%,100.00%,,,,,,,

203,41153059,4.9,0.00%,100.00%,,,,,,,

204,41141013,0,0.00%,100.00%,,,,,,,

205,41143005,0,0.00%,100.00%,,,,,,,

206,41153006,0,0.00%,100.00%,,,,,,,

,,,,,,,,,,,

,,,,,,,,

人人文库> 全部分类> 教育资料 > 辅导培训

温馨提示

1. 本站所有资源如无特殊说明，都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2. 本站的文档不包含任何第三方提供的附件图纸等，如果需要附件，请联系上传者。文件的所有权益归上传用户所有。
3. 本站RAR压缩包中若带图纸，网页内容里面会有图纸预览，若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 人人文库网仅提供信息存储空间，仅对用户上传内容的表现方式做保护处理，对用户上传分享的文档内容本身不做任何修改或编辑，并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容，请与我们联系，我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

品类管理-品类单品数分析

文档简介

温馨提示

最新文档

评论

品类管理-品类单品数分析

文档简介

温馨提示

最新文档

评论

相关文档