销售数据清单.xls

《销售数据清单.xls》由会员分享，可在线阅读，更多相关《销售数据清单.xls（15页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、求和项:销售金额￥品名销售人员销售年份销售季度按摩椅跑步机微波炉显示器液晶电视白露2005/3/6134,5002215,0003170,000413,5002005 汇总48,000385,0002006/2/10112,000222,400336,0002005 汇总58,40012,000白露 汇总58,40060,000385,000毕春艳2006/2/10111,00036,000460,000219,500114,000120,000338,00073,50045,000467,20079,500225,0002005 汇总67,20068,500303,000850,000毕春艳

2、 汇总67,20068,500303,000850,000高伟2006/2/101187,0009,50043,500340,00022,40074,8009,500374,400100,5004162,800106,50090,0002005 汇总76,800424,60019,000250,500430,000高伟 汇总76,800424,60019,000250,500430,000何庆2006/2/10194,6002123,200366,0002005 汇总217,80066,000何庆 汇总217,80066,000李兵2006/2/101228,800266,0003132,00

3、0415,4002,5002005 汇总442,2002,500李兵 汇总442,2002,500林茂2006/2/101354,200218,0005,0003169,500437,40012,00022,5002005 汇总391,60030,000192,0005,000林茂 汇总391,60030,000192,0005,000苏珊2005/3/61114,0005,000210,40049,5003147,000265,000473,500235,0002005 汇总10,400384,000505,000苏珊 汇总10,400384,000505,000杨光2006/2/10113

4、5,000278,000334,500300,0004157,5002005 汇总34,500235,500435,000杨光 汇总34,500235,500435,000赵琦2006/2/10154,400270,0002175,500332,500205,000416,00078,0002005 汇总70,40032,500253,500475,000赵琦 汇总70,40032,500253,500475,000总计283,2001,476,200247,0001,684,5003,085,000总计34,500215,000170,00013,500433,00012,00022,400

5、36,00070,400503,400507,000253,500156,500371,7001,288,7001,288,700580,00086,700174,900359,3001,200,9001,200,90094,600123,20066,000283,800283,800228,80066,000132,00017,900444,700444,700354,20023,000169,50071,900618,600618,600119,00059,900412,000308,500899,400899,400135,00078,000334,500157,500705,00070

6、5,000324,400175,500237,50094,000831,400831,4006,775,900品名(全部)数量(全部)销售年份(全部)销售地区(全部)数据销售人员销售季度 数量 销售金额￥求和项:销售金额￥白露19346500465002712374002374003792060002060004271350013500白露 汇总270503400503400毕春艳1138507000507000213925350025350031341565001565004182371700371700毕春艳 汇总59312887001288700高伟1201580000580000256

7、867008670031601749001749004163359300359300高伟 汇总58012009001200900何庆14394600946002561232001232003446600066000何庆 汇总143283800283800李兵110422880022880023066000660003601320001320004121790017900李兵 汇总206444700444700林茂1161354200354200237230002300031131695001695004567190071900林茂 汇总367618600618600苏珊177119000119

8、00024659900599003151412000412000496308500308500苏珊 汇总370899400899400杨光127135000135000252780007800031293345003345004105157500157500杨光 汇总313705000705000赵琦1122324400324400211717550017550031062375002375004729400094000赵琦 汇总417831400831400(空白)(空白)(空白)汇总总计325967759006775900销销售售地地区区销销售售人人员员品品名名数数量量单单价价￥销销售售金

9、金额额￥销销售售年年份份销销售售季季度度北京苏珊按摩椅1380010,40020052北京苏珊显示器981,500147,00020053北京苏珊显示器491,50073,50020054北京苏珊显示器761,500114,00020051北京苏珊显示器331,50049,50020052北京苏珊液晶电视535,000265,00020053北京苏珊液晶电视475,000235,00020054北京苏珊液晶电视15,0005,00020051北京白露液晶电视435,000215,00020052北京白露液晶电视345,000170,00020053北京白露微波炉2750013,50020054

10、北京白露微波炉6950034,50020051北京白露微波炉2450012,00020061北京白露按摩椅2880022,40020062北京白露按摩椅4580036,00020063北京赵琦按摩椅2080016,00020064北京赵琦按摩椅6880054,40020061北京赵琦显示器771,500115,50020062北京赵琦液晶电视415,000205,00020063北京赵琦显示器521,50078,00020064北京赵琦液晶电视545,000270,00020061北京赵琦显示器401,50060,00020062北京赵琦微波炉6550032,50020063北京李兵微波炉55

11、002,50020064北京李兵跑步机522,200114,40020061北京李兵跑步机302,20066,00020062北京李兵跑步机602,200132,00020063北京李兵跑步机72,20015,40020064北京李兵跑步机522,200114,40020061杭州毕春艳显示器761,500114,00020062杭州毕春艳显示器491,50073,50020063杭州毕春艳显示器531,50079,50020064杭州毕春艳显示器241,50036,00020061杭州毕春艳液晶电视455,000225,00020064杭州毕春艳液晶电视925,000460,00020061

12、杭州毕春艳液晶电视245,000120,00020062杭州毕春艳液晶电视95,00045,00020063杭州毕春艳微波炉2250011,00020061杭州毕春艳微波炉3950019,50020062杭州毕春艳微波炉7650038,00020063杭州毕春艳按摩椅8480067,20020064南京高伟按摩椅38002,40020062南京高伟按摩椅6180048,80020063南京高伟按摩椅3280025,60020063南京高伟显示器711,500106,50020064南京高伟液晶电视685,000340,00020061南京高伟显示器671,500100,50020063南京高伟

13、液晶电视185,00090,00020064南京高伟显示器291,50043,50020061南京高伟微波炉195009,50020062南京高伟微波炉195009,50020061南京高伟跑步机742,200162,80020064南京高伟跑步机852,200187,00020061南京高伟跑步机342,20074,80020062山东何庆跑步机412,20090,20020061山东何庆跑步机142,20030,80020062山东何庆跑步机22,2004,40020061山东何庆跑步机422,20092,40020062山东何庆显示器441,50066,00020063山东杨光液晶电视2

14、75,000135,00020061山东杨光显示器521,50078,00020062山东杨光微波炉6950034,50020063山东杨光显示器911,500136,50020064山东杨光液晶电视605,000300,00020063山东杨光显示器141,50021,00020064上海林茂微波炉3650018,00020062上海林茂显示器421,50063,00020063上海林茂液晶电视15,0005,00020062上海林茂显示器711,500106,50020063上海林茂微波炉2450012,00020064上海林茂跑步机822,200180,40020061上海林茂跑步机17

15、2,20037,40020064上海林茂跑步机792,200173,80020061上海林茂显示器151,50022,50020064求和项:销售金额￥品名销售人员销售年份销售季度按摩椅跑步机微波炉显示器白露2005134,50023413,5002005 汇总48,0002006112,000222,400336,0002006 汇总58,40012,000白露 汇总58,40060,000毕春艳2006111,00036,000219,500114,000338,00073,500467,20079,5002006 汇总67,20068,500303,000毕春艳 汇总67,20068,5

16、00303,000高伟20061187,0009,50043,50022,40074,8009,500374,400100,5004162,800106,5002006 汇总76,800424,60019,000250,500高伟 汇总76,800424,60019,000250,500何庆2006194,6002123,200366,0002006 汇总217,80066,000何庆 汇总217,80066,000李兵20061228,800266,0003132,000415,4002,5002006 汇总442,2002,500李兵 汇总442,2002,500林茂20061354,20

17、0218,0003169,500437,40012,00022,5002006 汇总391,60030,000192,000林茂 汇总391,60030,000192,000苏珊20051114,000210,40049,5003147,000473,5002005 汇总10,400384,000苏珊 汇总10,400384,000杨光20061278,000334,5004157,5002006 汇总34,500235,500杨光 汇总34,500235,500赵琦2006154,4002175,500332,500416,00078,0002006 汇总70,40032,500253,50

18、0赵琦 汇总70,40032,500253,500总计283,2001,476,200247,0001,684,500液晶电视总计34,500215,000215,000170,000170,00013,500385,000433,00012,00022,40036,00070,400385,000503,400460,000507,000120,000253,50045,000156,500225,000371,700850,0001,288,700850,0001,288,700340,000580,00086,700174,90090,000359,300430,0001,200,900

19、430,0001,200,90094,600123,20066,000283,800283,800228,80066,000132,00017,900444,700444,700354,2005,00023,000169,50071,9005,000618,6005,000618,6005,000119,00059,900265,000412,000235,000308,500505,000899,400505,000899,400135,000135,00078,000300,000334,500157,500435,000705,000435,000705,000270,000324,40

20、0175,500205,000237,50094,000475,000831,400475,000831,4003,085,0006,775,900品名(全部)数量(全部)销售年份(全部)销售地区(全部)数据销售人员销售季度 数量 销售金额￥求和项:销售金额￥白露19346500465002712374002374003792060002060004271350013500白露 汇总270503400503400毕春艳1138507000507000213925350025350031341565001565004182371700371700毕春艳 汇总59312887001288700高伟

21、1201580000580000256867008670031601749001749004163359300359300高伟 汇总58012009001200900何庆14394600946002561232001232003446600066000何庆 汇总143283800283800李兵110422880022880023066000660003601320001320004121790017900李兵 汇总206444700444700林茂1161354200354200237230002300031131695001695004567190071900林茂 汇总367618600618600苏珊17711900011900024659900599003151412000412000496308500308500苏珊 汇总370899400899400杨光127135000135000252780007800031293345003345004105157500157500杨光 汇总313705000705000赵琦1122324400324400211717550017550031062375002375004729400094000赵琦 汇总417831400831400总计325967759006775900苏珊