全部
搜索
稻壳儿首页 >

表格模板

 >当前作品

年度销售分析总结报表

收藏
  • 年度销售分析总结报表-表格模板序号类别说明,1.0类别列录入产品、销售区域、省市、各网站、销售人员等均可，视分析需要而定2020年环比变动%2019年2018年,2.00.8352821320.5579896240.078170160.0196917280.026398680.003856-0.1618048141.35958351-0.4026982357240.8359289960.5185648440.104337040.1336201680.021810.0026-0.1075912121.5092698361.2960706880.7146670440.153022480.2947080.03535790.0085008-0.2455672242.256759688,3.00.702375190.6327060040.184981680.0197492240.040309480.00198-0.3971877441.184913834-0.1284729291840.7558697160.4608079340.045289120.4136803520.01967920.00087008-0.1952111621.500985241.0740559640.6638623480.06108920.017480040.022319740.0007648-0.1212171.718355092,4.00.5752739220.722097910.170954320.0949906480.046964480.00776992-0.4290350611.1890161390.003462112503280.7060338320.4097768020.076924640.0996472160.034648980.00306752-0.0831272441.2469717461.3165323320.5829525720.110985040.019817320.022910580.00104704-0.1345666481.919678236,5.00.6877826760.602553680.238322320.0359905920.055181920.00220512-0.4988526041.123183704-0.05536715006690.7455247640.6135966840.12030440.0897328640.041339140.00390272-0.2364063581.3779942141.1177743720.6732052720.109306240.052776040.023551660.00920032-0.0344947761.951319128,6.00.8148512220.6591340910.114856080.0622905280.058575380.00370912-0.401422341.3119940810.1681028458010.9998579140.6534543060.145255120.053718680.030590740.00264384-0.222076381.663444221.0661548160.6614348480.07361680.07454720.09973430.01194176-0.0429928161.944436908,7.00.4913452680.4115088890.04270440.0313926960.2600099560.000892-0.2427456360.995107573-0.2415304402580.6714338320.3959509720.066127840.0200808240.016289480.00135808-0.0775426381.093698391.4755562680.4993999440.05026760.221356480.086589880.01441632-0.0487409442.298845548,8.00.4136266520.2583155570.024690160.025580440.1716255280.00073344-0.0855235880.809048189-0.1869741413370.589998670.372527690.77961480.0151388320.01411990.0010896-0.3570268581.4154626341.3643208240.6722588560.069299760.055951120.02749110.00136896-0.0814997282.109190892,0.4103623420.3114552880.524405040.0097218160.032533380.00345824-0.3261426740.9657934320.1937403051280.692651440.3170529160.92095320.0154827680.013913380.00104608-0.2683926681.6927071161.1760200280.7921835160.061479920.016440920.023841620.00160256-0.0610168642.0105517,0.4880140480.3171146710.177366530.0328051280.027998460.01282496-0.1394949020.916628895-0.05090585146990.742652220.5542737860.087627760.0190536960.016182660.00104096-0.165101531.2557295521.098200531.1346153320.5540460.020180880.02318040.00208576-0.3919770082.440331894,0.3696998560.4643732060.22548640.0185735280.015912880.00091328-0.1460718220.9488873280.03519246793980.5231781660.4253665960.193703280.0181775440.01634730.0008976-0.1219363461.055734140.841763770.5421041960.44598640.078915560.02169190.01020064-0.1453656161.79529685,0.0-1.00.42322050.2996130890.422327840.0165686960.013590460.02752368-0.1420790741.0607651910.9732728240.5044538940.45088160.059764440.022091960.00552416-0.16981591.846172978,0.00.9203975680.6106564531.800728080.0432975360.029437540.00777248-1.1360808942.2762087630.8717976680.9202990821.171237040.025508360.036323660.0014016-0.4154375362.611129874,合计5.7886133084.937248921.781937090.3507863280.7355101440.03834208-2.82828118510.804156685合计8.6067476185.6316420724.763193120.9381991760.267948780.05381264-3.11257236417.148971042总计13.6715200848.3614369043.311218080.937446360.44508470.06805472-1.8926920624.902068788,,年度总计近三年销售额月度业绩分析单位：亿元8.0,月份20年同比变动%,1月2.2567596881.5092698361.35958351-0.0991779749582,2月1.7183550921.500985241.184913834-0.210575958762,3月1.9196782361.2469717461.189016139-0.0464770811255,4月1.9513191281.3779942141.123183704-0.184914063797,5月1.9444369081.663444221.311994081-0.211278583781,6月2.2988455481.093698390.995107573-0.0901444291236,7月2.1091908921.4154626340.809048189-0.428421372937,8月2.01055171.6927071160.965793432-0.429438546769,9月2.4403318941.2557295520.916628895-0.270042746434,10月1.795296851.055734140.948887328-0.101206172986,11月1.8461729781.0607651910.0-1.0,12月2.6111298742.2762087630.0-1.0,合计24.90206878817.14897104210.804156685-0.0605516880845,,汇总产品结构分析,类别A类(业绩占比>=2%)B类(1%<业绩占比<2%)C类(0%<业绩占比<1%)合计,SKU（个）16.014.0105.0135.0,SKU占比%0.1185185185190.1037037037040.777777777778,业绩(亿元)9.045706631.8914564361.60032146212.537484528,业绩占比%0.9540215364830.1994858167610.1687807489781.32228810222,8 个3 个,7 个7 个,1 个42 个,21 个,1 个19 个,11 个,说明：使用ABC分类法，归类各品项，分析并改善产品结构。SKU少，业绩占比最高的为金牛产品，SKU多，业绩占比低的为长尾产品。,明细单位：元,序号产品编号产品简称20**年总销售额销售占比归类系列,A0001产品152542675.00.0554150665999,2.0A0002产品220383970.00.021498316466,3.0A0003产品393979200.00.0991168345921,4.0A0004产品4184728950.00.19482767231,5.0A0005产品527568000.00.0290750814652,6.0A0006产品643509060.00.0458876038876,7.0A0007产品769043700.00.0728181660679,8.0A0008产品820279688.00.0213883336001,9.0A0009产品936034521.60.038004449038,10.0A0010产品10123183368.00.129917529736,11.0A0011产品1121853603.20.0230482912561,12.0A0012产品1225116467.20.0264895288,13.0A0013产品1399582175.00.105026111818,14.0A0014产品1443257900.00.045622713527,15.0A0015产品1524084000.00.0254006189063,16.0A0016产品1614718830.00.015523475817,17.0A0017产品1719423385.00.0204852184128,18.0A0018产品1817780880.00.0187529213045,19.0A0019产品1911095500.00.0117020663957,20.0A0020产品2010121100.00.0106743981071,21.0A0021产品2112196560.00.0128633189058,22.0A0022产品2211039881.60.011643407461,23.0A0023产品2312332456.00.013006644039,24.0A0024产品2414657148.00.0154584217987,25.0A0025产品2515656088.00.0165119716347,26.0A0026产品2615086400.00.0159111400543,27.0A0027产品2717025600.00.0179563518207,28.0A0028产品2811670000.00.0123079730375,29.0A0029产品2911239200.00.0118536221563,30.0A0030产品3014526000.00.0153201042282,31.0A0031产品31580.86.12551048861e-07,32.0A0032产品323440.83.62890091067e-06,33.0A0033产品335373394.40.00566714596361,34.0A0034产品3413420.01.41536416593e-05,35.0A0035产品35240.02.53120268124e-07,36.0A0036产品3633580.83.54165879159e-05,37.0A0037产品378962500.00.00945246001276,38.0A0038产品38928720.00.000979491064218,39.0A0039产品393496032.00.00368715232171,40.0A0040产品407131786.00.00752166493552,41.0A0041产品415848224.00.00616793344554,42.0A0042产品422848.03.00369384841e-06,43.0A0043产品435548768.00.00585210684966,44.0A0044产品442021760.00.00213228513868,45.0A0045产品451580400.00.0016667969656,46.0A0046产品462171952.00.00229068780247,47.0A0047产品47919200.00.000969450626916,48.0A0048产品48943776.00.000995370142372,49.0A0049产品492515440.00.00265295353021,50.0A0050产品503700.03.90227080025e-06,51.0A0051产品514549800.00.00479852748296,52.0A0052产品522960435.20.00312227563162,53.0A0053产品532802211.20.00295540187619,54.0A0054产品542250500.00.00237352984756,55.0A0055产品553009284.00.00317379488726,56.0A0056产品561754064.00.00184995479161,57.0A0057产品571075536.00.00113433316957,58.0A0058产品58690560.00.000728311384816,59.0A0059产品59216996.00.000228858690425,60.0A0060产品601321536.00.0013937814444,61.0A0061产品6135424.03.73605515751e-05,62.0A0062产品621044900.00.00110202236735,63.0A0063产品632050600.00.00216270175756,64.0A0064产品64710204.00.000749029278762,65.0A0065产品65192800.00.000203339948726,66.0A0066产品66256.02.69994952666e-07,67.0A0067产品6777376.08.16059744433e-05,68.0A0068产品682688.02.83494700299e-06,69.0A0069产品6956320.05.93988895865e-05,70.0A0070产品70154368.00.000162806956458,71.0A0071产品71344960.00.000363818198717,72.0A0072产品72165760.00.000174821731851,73.0A0073产品73746752.00.000787575276926,74.0A0074产品74680064.00.000717241591757,75.0A0075产品75134624.00.000141983595733,76.0A0076产品76141440.00.000149172211348,77.0A0077产品77530960.00.000559986406513,78.0A0078产品782110720.00.00222610838473,79.0A0079产品791231104.00.00129840572737,80.0A0080产品80116240.00.000122594583195,81.0A0081产品81128384.00.000135402468762,82.0A0082产品82290240.00.000306106777585,83.0A0083产品831382220.00.00145778290419,84.0A0084产品847483920.00.00789304932092,85.0A0085产品851149312.00.00121214233999,86.0A0086产品861829520.00.00192953580391,87.0A0087产品87116240.00.000122594583195,88.0A0088产品881003904.00.00105878520688,89.0A0089产品89130900.00.000138056012906,90.0A0090产品903279040.00.00345829784996,91.0A0091产品91470752.00.000496486968583,92.0A0092产品92315504.00.000332751904476,93.0A0093产品931593312.00.00168041483602,94.0A0094产品94321408.00.000338978663072,95.0A0095产品9572000.07.59360804373e-05,96.0A0096产品9617000.01.79293523255e-05,97.0A0097产品9718000.01.89840201093e-05,98.0A0098产品98280000.00.000295306979478,99.0A0099产品99131600.00.000138794280355,100.0A0100产品1002500.02.63666945963e-06,101.0A0101产品1018080000.00.00852171569352,102.0A0102产品1022111200.00.00222661462527,103.0A0103产品1036504000.00.00685955926617,104.0A0104产品104492000.00.000518896549655,105.0A0105产品1052560.02.69994952666e-06,106.0A0106产品106640.06.74987381665e-07,107.0A0107产品1072155200.00.00227302000776,108.0A0108产品108819240.00.000864026035242,109.0A0109产品109336600.00.000355001176044,110.0A0110产品110296190.00.000312382050899,111.0A0111产品111108315.00.000114236341008,112.0A0112产品112804600.00.000848585698886,113.0A0113产品1137004800.00.00738773689232,114.0A0114产品1144122000.00.00434734060503,115.0A0115产品1151086800.00.00114621294749,116.0A0116产品1162172800.00.00229158216075,117.0A0117产品1172647600.00.00279233842452,118.0A0118产品1181904960.00.00200909994152,119.0A0119产品1196773040.00.00714330708673,120.0A0120产品1201505120.00.00158740157483,121.0A0121产品1213248080.00.00342564533537,122.0A0122产品122119328.00.000125851397311,123.0A0123产品12379520.08.38671821718e-05,124.0A0124产品124117216.00.000123623938952,125.0A0125产品12578064.08.23315858785e-05,126.0A0126产品12692800.09.78731703414e-05,127.0A0127产品12784000.08.85920938435e-05,128.0A0128产品12897632.00.000102969325073,129.0A0129产品129148800.00.000156934566237,130.0A0130产品1302808000.00.00296150713705,131.0A0131产品131182400.00.000192371403774,132.0A0132产品13249200.05.18896549655e-05,133.0A0133产品1334009920.00.00422913343982,134.0A0134产品1341128000.00.00118966526018,135.0A0135产品135187520.00.000197771302828, 合计 948165873.0,,使用说明,1、基础表中，维护产品，可按类别，也可按单品，视实际需要而定；,2、基础表中，将要分析对比的三年销售数据维护进去。产品名称或类别,保持一致；,3、业绩变动分析表中，无需录入，自动引用基础数据，点击按钮即可查,看各品项三年的销售变化；,4、品项分析中，将各品项的销售信息录入后，自动计算占比并ABC分级,汇总及可视化图表自动变化,5、注意公式部分不要随意修改，表格结构勿随意删减，移动。
  • 年度销售分析总结报表-表格模板
  • 年度销售分析总结报表-表格模板
模板介绍：
这个模板还没有相关介绍

关注稻壳领福利

相关推荐 查看更多
销售数据分析表.xlsx
销售数据分析表.xlsx

销售数据分析表

销售数据分析表.xlsx
销售数据分析表.xlsx

销售数据分析表

营销年度数据分析图表.xlsx
营销年度数据分析图表.xlsx

营销年度数据分析图表

销售总结业绩分析报表.xlsx
销售总结业绩分析报表.xlsx

销售总结业绩分析报表

销售数据统计分析表.xlsx
销售数据统计分析表.xlsx

销售数据统计分析表

产品业绩销售分析完成表.xlsx
产品业绩销售分析完成表.xlsx

产品业绩销售分析完成表

各地区部门销售数据分析.xlsx
各地区部门销售数据分析.xlsx

各地区部门销售数据分析

产品销售年终报表.xlsx
产品销售年终报表.xlsx

产品销售年终报表

公司年度销售报表.xlsx
公司年度销售报表.xlsx

公司年度销售报表

各部门年度销售业绩表-数据图表.xlsx
各部门年度销售业绩表-数据图表.xlsx

各部门年度销售业绩表-数据图表

公司年度销售报表及计划.xlsx
公司年度销售报表及计划.xlsx

公司年度销售报表及计划

销售业绩分析表.xlsx
销售业绩分析表.xlsx

销售业绩分析表

模板单价：￥9.99
开通会员可免费下载任意模板与19项权益包
登录后使用
以9.99元购买此模板
  • 页数：4页
  • 时间：2020-12-09
  • 编号：20521271
  • 类型：VIP模板
  • 格式：et
  • 提示：数字产品不支持退货
    数字产品本身（包括但不限于文字模板、表格模板、演示模板等）及其包含的全部素材 （包括但不限于字体、图片、图标、文本框、艺术字等）均不支持商用，仅能为个人学习、研究或欣赏目的使用。

逆风而舞

设计作品150 独家高品质原创文档

举报

猜你在找

    我的

    关注稻壳领福利

    福利

    反馈

    微信咨询在线客服

    客服