当前位置：文档之家 › 销售数据统计分析表Excel模板

销售数据统计分析表Excel模板

  • 格式：xlsx
  • 大小：43.81 KB
  • 文档页数：7

序号日期销售人员产品编号产品名称规格数量单位单价销售金额备注排名姓名销售金额12022/1/5XX1QK001产品A1*110个1201,200.00排名姓名销售金额占比6XX111591022022/1/16XX2QK002产品B1*16个60360.001XX420967023%4XX213402532022/1/16XX3QK003产品C1*125个1002,500.002XX617748520%3XX314316042022/1/16XX4QK004产品D1*118个651,170.003XX314316016%1XX420967052022/1/21XX5QK005产品E1*120个801,600.004XX213402515%5XX512476062022/1/22XX6QK006产品F1*120个45900.005XX512476014%2XX617748572022/1/23XX6QK001产品A1*165个1207,800.006XX111591013%82022/1/26XX5QK005产品E1*193个807,440.0092022/1/27XX1QK006产品F1*183个453,735.00102022/1/29XX3QK002产品B1*184个605,040.00112022/1/30XX5QK002产品B1*126个601,560.00排名产品编号产品名称销售金额122022/2/3XX4QK005产品E1*155个804,400.001QK001产品A249360排名产品编号产品名称销售金额132022/2/3XX3QK004产品D1*120个651,300.002QK003产品C1891001QK001产品A249360142022/2/7XX4QK003产品C1*188个1008,800.003QK002产品B1335603QK002产品B133560152022/2/7XX3QK006产品F1*123个451,035.004QK005产品E1252002QK003产品C189100162022/2/8XX5QK001产品A1*161个1207,320.005QK004产品D1052355QK004产品D105235172022/2/9XX4QK001产品A1*128个1203,360.006QK006产品F1025554QK005产品E125200182022/2/10XX6QK006产品F1*171个453,195.006QK006产品F102555192022/2/10XX6QK001产品A1*150个1206,000.00202022/2/10XX3QK006产品F1*186个453,870.00212022/2/11XX6QK005产品E1*132个802,560.00按销售人员统计销售人员排行榜

产品销售排行榜按产品统计销售数据统计分析Statisticalanalysistableofsalesdata

2096701774851431601340251247601159100150000300000450000

XX4XX6XX3XX2XX5XX1销售排名对比图

0300006000090000120000

1月2月3月4月5月6月7月8月9月10月11月12月各月销售情况对比图

第 1 页，共 7 页222022/2/14XX6QK001产品A1*186个12010,320.00232022/2/14XX3QK001产品A1*172个1208,640.00242022/2/19XX2QK005产品E1*176个806,080.00月份金额备注252022/2/19XX2QK002产品B1*136个602,160.001月33305262022/2/20XX2QK004产品D1*147个653,055.002月83155272022/2/21XX1QK002产品B1*165个603,900.003月92010282022/2/22XX1QK002产品B1*160个603,600.004月86940292022/2/22XX3QK006产品F1*130个451,350.005月68985302022/2/28XX2QK004产品D1*134个652,210.006月61825312022/3/2XX4QK005产品E1*137个802,960.007月109600322022/3/2XX6QK002产品B1*188个605,280.008月47200332022/3/3XX6QK001产品A1*171个1208,520.009月75585342022/3/3XX5QK002产品B1*176个604,560.0010月113020352022/3/3XX4QK005产品E1*165个805,200.0011月59240362022/3/5XX4QK003产品C1*172个1007,200.0012月74145372022/3/7XX4QK005产品E1*163个805,040.00382022/3/8XX6QK001产品A1*138个1204,560.00392022/3/11XX2QK004产品D1*141个652,665.00402022/3/12XX4QK006产品F1*136个451,620.00412022/3/14XX3QK003产品C1*134个1003,400.00422022/3/16XX5QK002产品B1*186个605,160.00432022/3/17XX4QK005产品E1*195个807,600.00442022/3/17XX5QK006产品F1*130个451,350.00452022/3/22XX4QK006产品F1*188个453,960.00462022/3/25XX4QK006产品F1*199个454,455.00472022/3/27XX1QK005产品E1*187个806,960.00482022/3/29XX4QK001产品A1*196个12011,520.00492022/4/2XX6QK006产品F1*158个452,610.00502022/4/3XX4QK005产品E1*179个806,320.00512022/4/5XX2QK002产品B1*134个602,040.00522022/4/6XX2QK002产品B1*170个604,200.00532022/4/7XX6QK004产品D1*145个652,925.00542022/4/8XX6QK002产品B1*155个603,300.00552022/4/10XX5QK006产品F1*140个451,800.00按月份统计2022年

第 2 页，共 7 页562022/4/11XX2QK004产品D1*173个654,745.00572022/4/11XX3QK001产品A1*173个1208,760.00582022/4/12XX5QK003产品C1*135个1003,500.00592022/4/18XX5QK003产品C1*124个1002,400.00602022/4/19XX5QK002产品B1*162个603,720.00612022/4/20XX4QK003产品C1*159个1005,900.00622022/4/21XX5QK006产品F1*177个453,465.00632022/4/22XX1QK002产品B1*131个601,860.00642022/4/22XX6QK005产品E1*134个802,720.00652022/4/24XX2QK003产品C1*192个1009,200.00662022/4/25XX5QK003产品C1*135个1003,500.00672022/4/25XX3QK006产品F1*139个451,755.00682022/4/27XX6QK004产品D1*166个654,290.00692022/4/30XX3QK004产品D1*135个652,275.00702022/4/30XX4QK004产品D1*187个655,655.00712022/5/1XX6QK004产品D1*148个653,120.00722022/5/2XX3QK006产品F1*193个454,185.00732022/5/2XX1QK006产品F1*199个454,455.00742022/5/4XX5QK004产品D1*177个655,005.00752022/5/5XX6QK002产品B1*155个603,300.00762022/5/6XX4QK006产品F1*145个452,025.00772022/5/10XX6QK002产品B1*167个604,020.00782022/5/14XX4QK003产品C1*180个1008,000.00792022/5/19XX2QK006产品F1*199个454,455.00802022/5/20XX6QK004产品D1*164个654,160.00812022/5/20XX6QK001产品A1*159个1207,080.00822022/5/21XX2QK005产品E1*135个802,800.00832022/5/23XX3QK002产品B1*151个603,060.00842022/5/26XX5QK001产品A1*171个1208,520.00852022/5/30XX6QK002产品B1*180个604,800.00862022/6/3XX3QK004产品D1*129个651,885.00872022/6/4XX4QK002产品B1*182个604,920.00882022/6/4XX4QK001产品A1*162个1207,440.00892022/6/5XX2QK004产品D1*120个651,300.00第 3 页，共 7 页902022/6/7XX3QK003产品C1*154个1005,400.00912022/6/8XX2QK003产品C1*140个1004,000.00922022/6/9XX1QK001产品A1*124个1202,880.00932022/6/11XX3QK005产品E1*151个804,080.00942022/6/12XX4QK001产品A1*176个1209,120.00952022/6/19XX3QK005产品E1*156个804,480.00962022/6/22XX5QK002产品B1*150个603,000.00972022/6/28XX6QK001产品A1*191个12010,920.00982022/6/29XX5QK001产品A1*120个1202,400.00992022/7/4XX1QK003产品C1*137个1003,700.001002022/7/4XX2QK001产品A1*189个12010,680.001012022/7/4XX3QK006产品F1*190个454,050.001022022/7/5XX6QK005产品E1*155个804,400.001032022/7/5XX1QK003产品C1*164个1006,400.001042022/7/6XX1QK002产品B1*157个603,420.001052022/7/6XX6QK006产品F1*197个454,365.001062022/7/6XX4QK005产品E1*149个803,920.001072022/7/8XX1QK004产品D1*128个651,820.001082022/7/12XX4QK006产品F1*135个451,575.001092022/7/13XX3QK004产品D1*186个655,590.001102022/7/13XX1QK004产品D1*124个651,560.001112022/7/14XX1QK005产品E1*196个807,680.001122022/7/16XX6QK002产品B1*148个602,880.001132022/7/18XX5QK003产品C1*168个1006,800.001142022/7/20XX2QK002产品B1*176个604,560.001152022/7/23XX4QK005产品E1*149个803,920.001162022/7/26XX2QK003产品C1*156个1005,600.001172022/7/27XX3QK003产品C1*185个1008,500.001182022/7/28XX6QK005产品E1*171个805,680.001192022/7/30XX4QK003产品C1*155个1005,500.001202022/7/31XX6QK003产品C1*170个1007,000.001212022/8/4XX3QK006产品F1*168个453,060.001222022/8/5XX2QK003产品C1*173个1007,300.001232022/8/12XX5QK002产品B1*141个602,460.00第 4 页，共 7 页

合集下载

年度销售数据分析表excel模板

年度销售数据分析表excel模板

季度20X120X220X320X420X5小计修改"B4:H9"数据,图表一季度1,4541,4281,0891,6181,4827,071

二季度2743193704383741,775

三季度3173913395114942,052234, 230,211四季度4575914746644802,666

合计2,5022,7292,2723,2312,83013,564年度销售数据分析表

05001,0001,5002,0002,5003,0003,500

20X120X220X320X420X5年度销售&季度情况一季度二季度三季度四季度一季度52%二季度13%三季度15%四季度20%总度占比%

05001,0001,5002,0002,5003,0003,500

20X120X220X320X420X5各年份业绩情况

01,0002,0003,0004,0005,0006,0007,0008,000

一季度二季度三季度四季度总分季度情况20X118%

20X220%20X317%20X424%20X521%年度占比%

02,0004,0006,0008,000

一季度二季度三季度四季度季度&年份情况20X120X220X320X420X5

进销存统计分析表excel模板

进销存统计分析表excel模板

98.21%2800万顺序上季销售本季销售对比升跌销售件数库存件数新货占比一32102854-11.09%1807119872.70%二188519855.00%1608118272.70%三21111568-25.72%2075114672.60%四2047254024.08%1514113172.40%五32142854-11.20%2115111672.80%六1597185416.09%1953110372.70%七16971520-10.43%1141109272.60%1576115175-3.72%

排行款号销售件数库存占比库存件数周转期备注排行款号销售件数库存占比库存件数周转期备注1302-53937734.52%560.151302-539512.10%3857.552302-67137133.97%470.132302-671650.70%2053.153602-19932629.85%170.053602-199702.50%1892.704302-50732029.30%990.314302-507770.33%2873.735201-36830527.93%560.185201-368790.17%3304.186302-58829927.38%180.066302-588890.21%4074.577602-20129126.65%960.337602-201900.17%2542.828302-54825623.44%920.368302-548980.30%2582.639202-08724222.16%100.049202-0871050.23%3653.4810602-20521519.69%280.1310602-2051200.18%2692.24目标(元)实际销售额（元）2766.3万备注：

23-35岁年龄的顾客比较多， 其中学生也有，大部分都是一些年轻女孩。 本季销售白色类产品销售较好， 因为白色比较好搭配，而且尺码较齐全。 本季虽然比上季的销售额多，但上升比例不大，店铺的活动在商场同时进行的销售好些，过了那段时间后，人流量也明显减少，店铺的货品也有很多不是齐色齐码了。苹果绿、珊瑚红销售情况较差，尺码不全本季促销方式2800万

周销售业绩统计分析表excel模板

周销售业绩统计分析表excel模板

编号姓名部门星期一星期二星期三星期四星期五总销售额排名百分比排名

A01程小萍销售（1）部66,50092,50095,50098,00086,500439,000480%

A02张丽销售（1）部73,50091,50064,50093,50084,000407,0001133%

A03卢奔销售（1）部75,50062,50087,00094,50078,000397,5001413%

A04刘月销售（1）部79,50098,50068,000100,00096,000442,000293%

A05杜鸣销售（1）部82,05063,50090,50097,00065,150398,2001320%

A06张成汉销售（2）部82,50078,00081,00096,50096,500434,500573%

A07卢红销售（2）部84,50071,00099,50089,50084,500429,000760%

A08李佳佳销售（2）部87,50063,50067,50098,50078,500395,500156%

A09杜月兰销售（2）部88,00082,50083,00075,50062,000391,000160%

A10李成斌销售（2）部92,00064,00097,00093,00075,000421,000946%

A11张利军销售（3）部93,00071,50092,00096,50087,000440,000386%

A12李诗奇销售（3）部93,05085,50077,00081,00095,000431,550666%

A13杜乐月销售（3）部96,00072,500100,00086,00062,000416,5001040%

A14刘大维销售（3）部96,50086,50090,50094,00099,500467,0001100%

A15唐艳菊销售（3）部97,50076,00072,00092,50084,500422,500853%A15唐艳菊销售（3）部87,50076,00072,00082,50084,500402,5001226%周销售业绩统计分析工具

销售数据统计分析表

销售数据统计分析表

010,00020,00030,00040,00050,00060,00070,00080,000

2010 2011 2012 2013 2014 总销售量65950.00 70400.00 72830.00 74290.00 63180.00

计划销售量59000.00 64500.00 68000.00 68500.00 67000.00

年度历史平均销售量

月均销售量5495.83 5866.67 6069.17 6190.83 5265.00

销售量完成率111.78%109.15%107.10%108.45%94.30%2010-2014年度销售统计分析表-2(销售量)

总销售量

计划销售量

年度历史平均销售量

月均销售量

销售量完成率

2010 65950.00

2011 70400.00

2012 72830.00 2013 74290.00 2014 63180.00 2010-2014年度销售统计分析表-2（销售量）

2010

2011

2012

2013

2014

1月份2月份3月份4月份5月份6月份7月份8月份9月份10月份11月份12月份

20105500.006000.006100.005000.005000.005000.005800.005850.006800.004900.005000.005000.0020116000.006100.006300.005500.005500.005500.006100.006200.006300.005900.005500.005500.0020126250.006380.006420.005750.005750.005750.006300.006250.006300.006180.005750.005750.0020136750.006350.006000.005950.005950.005950.005990.006400.006250.006800.005950.005950.0020145250.005100.005200.004900.005650.005650.005600.004980.005450.005750.004750.004900.004500.00 4750.00 5000.00 5250.00 5500.00 5750.00 6000.00 6250.00 6500.00 6750.00 2010-2014年12月度销售量统计分析