2013-2014销售对比表_财务管理_经管营销_专业资料.xls

《2013-2014销售对比表_财务管理_经管营销_专业资料.xls》由会员分享，可在线阅读，更多相关《2013-2014销售对比表_财务管理_经管营销_专业资料.xls（88页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、20132013年年20142014年年功功率率品品牌牌数数量量金金额额平平均均单单价价数数量量零零售售机机1 1匹匹松下8225972824.632格力15457393049.2734美的255002750.00奥克斯7大金293604680.00海信380972699.001TCL2小小计计303091293912933043.1046461.51.5匹匹松下10374383743.802格力2498697.54112.4023三菱2150007500.00三星-1-26502650.00美的266503325.0015大金4191784794.50奥克斯3澳柯玛6132382206.33

2、海信1TCL1小小计计4747187551.5187551.53990.4645452 2匹匹松下185008500.002格力161428818930.0615三菱3三星1美的12797706647.5010大金185008500.00日立11230012300.00澳柯玛140004000.00海信2108995449.50TCL1小小计计34342668502668507848.5332323 3匹匹松下1012268712268.703格力2122887610898.8617三菱35099016996.67美的6547809130.0015大金34348914496.331澳柯玛153

3、005300.00TCL小小计计444450612250612211502.773636合合 计计1551551051816.51051816.56785.911591595 5匹匹机机格力8746999337.3815美的2170008500.00小计10916999169.9015中中央央空空调调格力14604704319.2912大金10460004600.001小小计计24241064701064704436.251313工工程程机机1匹格力8200002500.00711.5匹美的格力15435002900.00102匹美的2格力3匹美的1格力7455006500.0012小小 计计

4、30301090001090003633.339696空空 调调 类类 合合 计计2192191358985.51358985.56205.41283283配配 件件 类类33503350350035001.0448624862总总 计计356935691362485.51362485.5381.76381.7651455145绝绝对对值值对对比比金金额额平平均均单单价价数数量量金金额额平平均均单单价价85804290.00-6-140171465.38744812190.621928742-858.651770-2-3730-2750.00116381662.577116381662.57-

5、2-9360-4680.0028492849.00-2-5248150.0034981749.00234981749.001028161028162235.131611523-807.97103005150.00-8-271381406.20899373910.30-1-8760.5-202.09-2-15000-7500.0012650-2650.00556343708.931348984383.93-4-19178-4794.5058001933.33358001933.33-6-13238-2206.3330493049.00130493049.0028002800.0012800280

6、0.001675201675203722.67-2-20031.5-267.792200011000.001135002500.00961896412.60-1-46692-2517.463430011433.3333430011433.3358005800.00158005800.00740547405.40-2-5716757.90-1-8500-8500.00-1-12300-12300.00-1-4000-4000.00-2-10899-5449.5053995399.00153995399.002377422377427429.44-2-29108-419.095450018166.

7、67-7-681875897.971280977535.12-4-100779-3363.74-3-50990-16996.671119967466.40957216-1663.601860018600.00-2-248894103.67-1-5300-5300.0010701070.003133003133008702.78-8-192822-2799.998213788213785165.904-230438.5-1620.011287408582.67754041-754.71-2-17000-8500.001287408582.67537041-587.23310002583.33-2

8、-29470-1735.951630016300.00-9-2970011700.0047300473003638.46-11-59170-797.7920142014年年1109001561.976390900-938.03000.00197501975.00-5-23750-925.0084004200.00284004200.00000.0052005200.00152005200.00681005675.00522600-825.002123502123502211.9866103350-1421.35120976812097684274.8064-149217.5-1930.610.

9、001512-3500-1.0412097681209768235.13235.1315761576-152717.5-152717.5-146.62-146.62百百分分比比对对比比数数量量金金额额平平均均单单价价-75.00%-62.03%51.88%126.67%62.84%-28.16%-100.00%-67.82%-100.00%-100.00%-100.00%-100.00%-66.67%-64.81%5.56%53.33%12.62%-26.55%-80.00%-72.49%37.56%-4.17%-8.88%-4.91%-100.00%-100.00%-100.00%-100.

10、00%-100.00%-100.00%650.00%736.60%11.55%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-4.26%-10.68%-6.71%100.00%158.82%29.41%-6.25%-32.68%-28.19%-16.67%-7.17%11.40%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-100.00%-5.88%-10.91%-5.34%-70.00%-55.58%48.07%

11、-19.05%-44.03%-30.86%-100.00%-100.00%-100.00%150.00%104.45%-18.22%-66.67%-57.23%28.31%-100.00%-100.00%-100.00%-18.18%-38.10%-24.34%2.58%-21.91%-23.87%87.50%72.35%-8.08%-100.00%-100.00%-100.00%50.00%40.39%-6.40%-14.29%-48.73%-40.19%-90.00%-64.57%254.35%-45.83%-55.57%-17.98%787.50%454.50%-37.52%-33.33

12、%-54.60%-31.90%71.43%49.67%-12.69%220.00%94.82%-39.12%29.22%-10.98%-31.11%45.13%-100.00%-100.00%44.16%44.16%-11.21%-11.21%-38.41%-38.41%20132013年年20142014年年功功率率品品牌牌数数量量金金额额平平均均单单价价数数量量金金额额零零售售机机型型1 1匹匹格力257982899.00818995美的37200海信253982699.00小小计计4 411196111962799.00111126195261951.51.5匹匹松下13999格力313

13、2984432.6728998三星127002700.00美的412029奥克斯28799澳柯玛-1-21002100.00海信128992899.00TCL27000小小计计4 416797167974199.25111140825408252 2匹匹松下182008200.00格力5335976719.40220399三星16999美的638789小小计计6 641797417976966.179 966187661873 3匹匹格力193999399.00434339三菱11680016800.00美的216599大金-500三星113500小小计计2 2256992569912849.

14、507 76443864438合合 计计161695489954895968.0638381976451976455 5匹匹机机格力2177008850.00217100中中央央空空调调格力302190007300.00工工程程机机格力159005900.00空空 调调 类类 合合 计计49493380893380896899.784040214745214745配配 件件 类类3983984800480012.06527527总总 计计447447342889342889767.09767.09567567214745214745绝绝对对值值对对比比百百分分比比对对比比平平均均单单价价数数量

15、量金金额额平平均均单单价价数数量量金金额额2374.38613197-524.63300.00%227.61%2400.00372002400.00-2-5398-2699.00-100.00%-100.00%2381.36714999-417.64175.00%133.97%3999.00139993999.004499.00-1-430066.33-33.33%-32.34%-1-2700-2700.00-100.00%-100.00%3007.254120293007.254399.50287994399.5012100-2100.00-100.00%-100.00%-1-2899-28

16、99.00-100.00%-100.00%3500.00270003500.003711.36724028-487.89175.00%143.05%-1-8200-8200.00-100.00%-100.00%10199.50-3-131983480.10-60.00%-39.28%6999.00169996999.006464.836387896464.837354.11324390387.9450.00%58.35%8584.75324940-814.25300.00%265.35%-1-16800-16800.00-100.00%-100.00%8299.502165998299.500

17、5000.00-100.00%13500.0011350013500.009205.43538739-3644.07250.00%150.74%5201.1822102156-766.88137.50%106.98%8550.000-600-300.000.00%-3.39%-30-219000-7300.00-100.00%-100.00%-1-5900-5900.00-100.00%-100.00%5368.63-9-123344-1531.15-18.37%-36.48%0.00129-4800-12.0632.41%-100.00%378.74378.74120120-128144-1

18、28144-388.35-388.3526.85%26.85%-37.37%-37.37%平平均均单单价价-18.10%-100.00%-14.92%1.50%-100.00%-100.00%-100.00%-11.62%-100.00%51.79%5.57%-8.66%-100.00%-28.36%-12.85%-3.39%-100.00%-100.00%-22.19%-100.00%百百分分比比对对比比-50.63%-50.63%20132013年年20142014年年功功率率品品牌牌数数量量金金额额平平均均单单价价数数量量1 1匹匹松下251992599.505零零售售机机型型格力174

19、66642744.9417美的6167582793.00105奥克斯#DIV/0!8大金#DIV/0!2TCL#DIV/0!1澳柯玛15271901812.67海信128992899.00小小计计414198710987102407.561381381.51.5匹匹松下4152983824.509格力351242293549.4055三菱#DIV/0!3美的#DIV/0!42大金2103005150.00澳柯玛371002366.67海信#DIV/0!TCL#DIV/0!小小计计44441569271569273566.521091092 2匹匹奥克斯#DIV/0!3格力15130091867

20、2.7336三菱33210010700.001美的4247996199.7541TCL#DIV/0!1澳柯玛139003900.00小小计计23231908901908908299.5782823 3匹匹松下35629918766.332格力1616279310174.5622三菱11430014300.005美的4299907497.5022TCL#DIV/0!10日立#DIV/0!1大金11160011600.00小小计计252527498227498210999.286262合合 计计1331337215097215095424.883913915 5匹匹机机格力6548009133.3

21、3中中央央空空调调格力23168015840.0045工工程程机机格力1匹33561001700.002匹145004500.0023匹#DIV/0!-1美的1.5匹242002100.00合合 计计36648001800.001工工业业用用空空调调艾默生5748960149792.00空空 调调 类类 合合 计计182182162174916217498910.71437437配配 件件 类类296029603603600.1263966396总总 计计3142314216221091622109516.2768336833绝绝对对值值对对比比百百分分比比对对比比金金额额平平均均单单价价数数

22、量量金金额额平平均均单单价价数数量量223004460.003171011860.50150.00%484932852.5301829107.590.00%2247652140.6299208007(652.38)1650.00%139431742.88813943147007350.0021470018001800.0011800-15-27190(1812.67)-100.00%-1-2899(2899.00)-100.00%3260013260012362.3397227291(45.23)236.59%423394704.33527041879.83125.00%2280264145.

23、9320103797596.5357.14%224707490.003224701284753058.9342128475-2-10300(5150.00)-100.00%-3-7100(2366.67)-100.00%00004213104213103865.2365264383298.71147.73%115483849.333115482962838230.0821166192(442.65)140.00%1390013900.00-2-182003200.00-66.67%2817196871.2037256920671.45925.00%48004800.0014800-1-3900

24、(3900.00)-100.00%6082506082507417.6859417360(881.88)256.52%3720018600.00-1-19099(166.33)-33.33%1920338728.77629240(1445.79)37.50%8493016986.004706302686.00400.00%2065249387.45181765341889.95450.00%460004600.0010460001150011500.00111500-1-11600(11600.00)-100.00%5781875781879325.6037303205(1673.68)148

25、.00%193374819337484945.652581212239(479.23)193.98%-6-54800(9133.33)-100.00%1522003382.2243120520(12457.78)2150.00%-33-56100(1700.00)-100.00%92004600.0014700100.00100.00%-57005700.00-1-5700-2-4200(2100.00)-100.00%35003500.00-35-613001700.00-97.22%-5-748960(149792.00)-100.00%208944820894484781.3525546

26、7699(4129.36)140.11%0.003436-360(0.12)116.08%20142014年年20894482089448305.793691467339(210.48)117.47%金金额额平平均均单单价价328.93%71.57%3.92%3.92%1241.24%-23.36%-100.00%-100.00%-100.00%-100.00%230.26%-1.88%176.76%23.01%83.55%16.81%-100.00%-100.00%-100.00%-100.00%168.48%8.38%127.75%-5.10%-56.70%29.91%1036.01%10

27、.83%-100.00%-100.00%218.64%-10.63%-33.92%-0.89%17.96%-14.21%493.92%18.78%588.64%25.21%-100.00%-100.00%110.26%-15.22%168.01%-8.83%-100.00%-100.00%380.43%-78.65%-100.00%-100.00%104.44%2.22%-100.00%-100.00%-94.60%94.44%-100.00%-100.00%28.84%-46.34%-100.00%-100.00%百百分分比比对对比比28.81%-40.77%20132013年年201420

28、14年年功功率率品品牌牌数数量量金金额额平平均均单单价价数数量量零零售售机机1 1匹匹松下10277962779.607格力34982012888.2659美的8222582782.25108奥克斯15大金293604680.002海信6163942732.331TCL3澳柯玛15271901812.67小小计计75752011992011992682.651951951.51.5匹匹松下14527363766.8612格力62236224.53810.0780三菱2150007500.003三星50美的266503325.0061大金6294784913.00奥克斯3澳柯玛818238227

29、9.75海信128992899.001TCL3小小计计9595361275.5361275.53802.901631632 2匹匹松下2167008350.002格力363065698515.8153三菱33210010700.004三星2美的161045696535.5657大金185008500.00奥克斯5澳柯玛279003950.00海信2108995449.50TCL2小小计计62624872374872377858.661251253 3匹匹松下1317898613768.155格力3840106810554.4243三菱58209016418.005三星1美的1084770847

30、7.0039日立11230012300.001大金45458913647.251澳柯玛153005300.00TCL10小小计计727281910381910311376.43105105合合 计计3043041868814.51868814.56147.425885885 5匹匹机机格力161471999199.9420美的2170008500.00小计181641999122.1720中中央央空空调调格力463111506764.1354大金10460004600.001小小计计56563571503571506377.685555工工程程机机1匹格力41761001856.10711.5

31、匹美的242002100.00格力15435002900.00102匹美的2格力145004500.0023匹美的1格力8514006425.0011小小 计计67671797001797002682.099797工工业业用用空空调调艾默生5748960149792.00空空 调调 类类 合合 计计4504503318823.53318823.57375.16760760配配 件件 类类67086708866086601.291178511785总总 计计715871583327483.53327483.5464.86464.861254512545绝绝对对值值对对比比百百分分比比对对比比金金

32、额额平平均均单单价价数数量量金金额额平平均均单单价价数数量量金金额额308804411.43-330841631.83-30.00%11.10%1419692406.252543768-482.0173.53%44.57%2337352164.21100211477-618.041250.00%950.12%255811705.4015255811705.40147007350.00053402670.000.00%57.05%28492849.00-5-13545116.67-83.33%-82.62%52981766.00352981766.00-15-27190-1812.67-100.

33、00%-100.00%4550124550122333.39120253813-349.26160.00%126.15%566384719.83-23902952.98-14.29%7.40%3269614087.011890736.5276.9429.03%38.41%224707490.0017470-10.0050.00%49.80%0-500.00-100.00%1961383215.3859189488-109.622950.00%2849.44%-6-29478-100.00%-100.00%58001933.33358001933.33-8-18238-2279.75-100.0

34、0%-100.00%30493049.000150150.000.00%5.17%98003266.67398003266.676208566208563808.9368259580.56.0371.58%71.85%2200011000.00053002650.000.00%31.74%4128717790.0217106302-725.7947.22%34.67%4820012050.001161001350.0033.33%50.16%127996399.502127996399.503945626922.1441289993386.58256.25%277.32%-1-8500-850

35、0.00-100.00%-100.00%203474069.405203474069.40-2-7900-3950.00-100.00%-100.00%-2-10899-5449.50-100.00%-100.00%101995099.502101995099.509209789209787367.8263433741-490.84101.61%89.02%9170018340.00-8-872864571.85-61.54%-48.77%3544698243.475-46599-2310.9613.16%-11.62%8493016986.0002840568.000.00%3.46%135

36、0013500.0011350013500.003351198592.7929250349115.79290.00%295.33%1150011500.000-800-800.000.00%-6.50%1860018600.00-3-359894952.75-75.00%-65.93%-1-5300-5300.00-100.00%-100.00%461074610.7010461074610.709559259559259104.0533136822-2272.3845.83%16.70%295277129527715021.722841083956.5-1125.7093.42%58.00%

37、1715408577.00424341-622.9425.00%16.54%-2-17000-8500.00-100.00%-100.00%1715408577.0027341-545.1711.11%4.47%20142014年年1575002916.678-153650-3847.4617.39%-49.38%1630016300.00-9-2970011700.00-90.00%-64.57%1738001738003160.00-1-183350-3217.68-1.79%-51.34%1109001561.973034800-294.1373.17%45.73%-2-4200-210

38、0.00-100.00%-100.00%197501975.00-5-23750-925.00-33.33%-54.60%52002600.00252002600.0092004600.0014700100.00100.00%104.44%1360013600.0011360013600.00624005672.73311000-752.2737.50%21.40%2210502210502278.873041350-403.2244.78%23.01%-5-748960-149792.00-100.00%-100.00%351916135191614630.48310200337.5-274

39、4.6968.89%6.04%0.005077-8660-1.2975.69%-100.00%35191613519161280.52280.5253875387191677.5191677.5-184.34-184.3475.26%75.26%5.76%5.76%平平均均单单价价58.71%-16.69%-22.21%57.05%4.27%-100.00%-13.02%25.30%7.27%-0.13%-3.30%0.00%-100.00%5.17%0.16%31.74%-8.52%12.62%5.91%-100.00%-100.00%-100.00%-6.25%33.21%-21.90%3

40、.46%1.37%-6.50%36.29%-100.00%-19.97%-18.31%-6.77%-100.00%-5.98%百百分分比比对对比比-56.88%254.35%-50.45%-15.85%-100.00%-31.90%2.22%-11.71%-15.03%-100.00%-37.22%-100.00%-39.65%-39.65%20132013年年20142014年年功功率率品品牌牌数数量量金金额额平平均均单单价价数数量量零零售售机机1 1匹匹松下133993399.0016格力11325972963.3627三菱143004300.00美的12301192509.9236奥克斯

41、10180941809.407日立151805180.00澳柯玛20360331801.65海信127992799.00TCL119991999.00小小计计58581345201345202319.3186861.51.5匹匹松下16530413315.0622格力281102603937.8644三菱#DIV/0!美的24687832865.9645奥克斯#DIV/0!3澳柯玛20400512002.55海信130003000.00小小计计89892751352751353091.401141142 2匹匹松下162906290.002格力141207928628.0024三菱330700

42、10233.33美的171142836722.5336大金4376009400.002奥克斯#DIV/0!1澳柯玛5209464189.202小小计计44443306113306117513.8967673 3匹匹松下11020010200.002格力1010969310969.3026三菱11160011600.004美的191579958315.5326大金45570013925.00奥克斯#DIV/0!4澳柯玛5268995379.80TCL#DIV/0!3小小计计40403720873720879302.186565合合 计计231231111235311123534815.38332

43、3325 5匹匹机机格力121086209051.677美的#DIV/0!5松下11280012800.00小计131214209340.0012中中央央空空调调格力332157006536.3651大金88148410185.501小小计计41412971842971847248.395252工工程程机机1匹格力#DIV/0!121.5匹格力699#DIV/0!2美的124002400.0042匹格力#DIV/0!23匹格力1798#DIV/0!小小 计计1 1489748974897.002020空空 调调 类类 合合 计计286286153585415358545370.12416416

44、配配 件件 类类48064806107010700.2262926292总总 计计5092509215369241536924301.8367086708工工程程机机绝绝对对值值对对比比百百分分比比对对比比金金额额平平均均单单价价数数量量金金额额平平均均单单价价数数量量金金额额平平均均单单价价505423158.881547143-240.131500.00%1386.97%-7.06%843403123.701651743160.34145.45%158.74%5.41%#DIV/0!-1-4300-100.00%-100.00%738222050.612443703-459.31200.0

45、0%145.10%-18.30%115561650.86-3-6538-158.54-30.00%-36.13%-8.76%#DIV/0!-1-5180-100.00%-100.00%0.00%#DIV/0!-20-36033-100.00%-100.00%0.00%#DIV/0!-1-2799-100.00%-100.00%0.00%#DIV/0!-1-1999-100.00%-100.00%2202602202602561.162885740241.8548.28%63.74%10.43%857713898.68632730583.6237.50%61.71%17.61%173372394

46、0.2716631122.4257.14%57.24%0.06%#DIV/0!001511003357.782182317491.8287.50%119.68%17.16%57001900.0035700#DIV/0!-20-40051-100.00%-100.00%#DIV/0!-1-3000-100.00%-100.00%4159434159433648.6225140808557.2228.09%51.18%18.02%155007750.00192101460.00100.00%146.42%23.21%1881847841.001067392-787.0071.43%55.79%-9

47、.12%#DIV/0!-3-30700-100.00%-100.00%2769097691.9219162626969.39111.76%142.30%14.42%2080010400.00-2-168001000.00-50.00%-44.68%10.64%43004300.001430081994099.50-3-12747-89.70-60.00%-60.86%-2.14%5138925138927670.0323183281156.1452.27%55.44%2.08%2500012500.001148002300.00100.00%145.10%22.55%26883710339.8

48、816159144-629.42160.00%145.08%-5.74%6340015850.003518004250.00300.00%446.55%36.64%2283268781.77770331466.2436.84%44.51%5.61%#DIV/0!-4-55700-100.00%-100.00%0.00%210005250.00421000#DIV/0!-5-26899-100.00%-100.00%0.00%138004600.003138006203636203639544.0525248276241.8762.50%66.73%2.60%177045817704585332

49、.70101658105517.3243.72%59.16%10.74%616008800.00-5-47020-251.67-41.67%-43.29%-2.78%398007960.00539800-1-12800-12800.00-100.00%-100.00%-100.00%1014008450.00-1-20020-890.00-7.69%-16.49%-9.53%1563503065.6918-59350-3470.6854.55%-27.52%-53.10%1580015800.00-7-656845614.50-87.50%-80.61%55.12%17215017215033

50、10.5811-125034-3937.8126.83%-42.07%-54.33%214001783.33122140020142014年年37601880.0023061437.91%76001900.0035200-500.00300.00%216.67%-20.83%90004500.0029000#DIV/0!0-1798-100.00%41760417602088.001936863-2809.001900.00%752.77%-57.36%208576820857685013.87130549914-356.2545.45%35.81%-6.63%56560.011486-101