品类管理 品类单品数分析.xls

SKU个数--品类管理分析 累计销售占比 .00 .00 0 1.00 数量 SKU 销售金额 单品销售占品类比 单品累计销售占比 品类SKU数 销售占比80%SKU数 占比 销售占比90%SKU数 计算公式 单品销售占比=单品销售 除 品类销售 累计销售占比=单品销售占比降序后累计相加 1.0000 57789.52 .04 1537288.56 .04 2.00 1.0000 56068.37 .04 .07 3.0000 55634.10 .04 .11 4.0000 52590.15 .03 .14 5.0000 47436.70 .03 .18 6.0000 43964.69 .03 .20 7.0000 42756.78 .03 .23 8.0000 42065.90 .03 .26 9.0000 39787.93 .03 .29 10.0000 38039.69 .02 .31 11.0000 32317.28 .02 .33 12.0000 27299.70 .02 .35 13.0000 25733.60 .02 .37 14.0000 24820.10 .02 .38 15.0000 24630.70 .02 .40 16.0000 23921.40 .02 .41 17.0000 23622.00 .02 .43 18.0000 21411.00 .01 .44 19.0000 20602.58 .01 .46 20.0000 19964.90 .01 .47 21.0000 18815.74 .01 .48 22.0000 18514.94 .01 .49 23.0000 17755.50 .01 .50 24.0000 16713.00 .01 .52 25.0000 16651.20 .01 .53 26.0000 15734.40 .01 .54 206.00 67.00 0.8 .33 97.00 0.9 .47 27.0000 15519.90 .01 .55 28.0000 15239.22 9.91E-03 .56 29.0000 14500.80 9.43E-03 .57 30.0000 14347.90 9.33E-03 .58 31.0000 13502.20 8.78E-03 .58 32.0000 13143.57 8.55E-03 .59 33.0000 12186.90 7.93E-03 .60 34.0000 12139.52 7.90E-03 .61 35.0000 11533.90 7.50E-03 .62 36.0000 11412.60 7.42E-03 .62 37.0000 11377.20 7.40E-03 .63 38.0000 11297.90 7.35E-03 .64 39.0000 10862.10 7.07E-03 .65 40.0000 10487.30 6.82E-03 .65 41.0000 10325.70 6.72E-03 .66 42.0000 10309.95 6.71E-03 .67 43.0000 10149.80 6.60E-03 .67 44.0000 9919.90 6.45E-03 .68 45.0000 9590.60 6.24E-03 .68 46.0000 9109.80 5.93E-03 .69 47.0000 8966.20 5.83E-03 .70 48.0000 8951.60 5.82E-03 .70 49.0000 8594.30 5.59E-0