《Excel-电子表格制作案例教程》商品促销折算表(计算).xlsx

《《Excel-电子表格制作案例教程》商品促销折算表(计算).xlsx》由会员分享，可在线阅读，更多相关《《Excel-电子表格制作案例教程》商品促销折算表(计算).xlsx（14页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、凡凡购购买买A类类商商品品享享受受6折折的的折折扣扣，凡凡购购买买B类类商商品品享享受受7折折的的折折扣扣，凡凡购购买买C类类商商品品享享受受8折折的的折折扣扣，凡凡购购买买D类类商商品品享享受受9折折的的折折扣扣，购购买买其其他他商商品品（用用代代码码N表表示示）没没有有折折扣扣。乐玛超市十一促销活动价目折算表序序号号品品名名类类别别单单位位销销售售量量原原价价原原价价总总额额1鸡蛋A公斤421￥6.10￥2,568.102精猪肉A公斤53￥15.50￥821.503面食B公斤195￥8.30￥1,618.504可口可乐B瓶256￥7.60￥1,945.605百事可乐C瓶558￥7.50￥4

2、,185.006海藻N包266￥6.00￥1,596.007花生油C瓶(6L)122￥102.00￥12,444.008海尔洗衣机A台5￥2,699.00￥13,495.009三洋电视机B台10￥1,299.00￥12,990.0010九阳豆浆机C台20￥399.00￥7,980.0011自行车C辆15￥199.00￥2,985.0012面粉N包(10KG)352￥30.00￥10,560.0013苹果N公斤125￥6.80￥850.0014雪梨C公斤234￥5.60￥1,310.4015蒙牛酸奶C瓶558￥2.50￥1,395.0016伊莱克斯冰箱ADCD19124￥1,849.00￥44,

3、376.0017格兰仕微波炉BWD800TL2153￥399.00￥21,147.0018富土宝饮水机D2005195￥158.00￥30,810.0019海尔冷柜CBCBD7￥980.00￥6,860.0020冰箱洗衣机套装Nkg22e188￥5,998.00￥47,984.0021依立紫沙锅C25L53￥99.00￥5,247.0022王中皇水壶A3L195￥49.00￥9,555.0023海鸥照相机BSC118256￥179.00￥45,824.0024明珠星闹钟C558￥7.50￥4,185.0025科皇热水器DJSYD785￥298.00￥25,330.0026电饭锅DCFXB405

4、3￥66.00￥3,498.0027华裕电熨斗AYPF2188195￥38.00￥7,410.0028厦新家庭影院BDH903087￥799.00￥69,513.0029康佳彩电B21英寸53￥939.00￥49,767.0030松下洗衣机CXQB458￥1,399.00￥11,192.0031压力锅D20CM53￥79.00￥4,187.0032佳能打印机CS100SP5￥529.00￥2,645.0033夏普复印机DAL12405￥7,499.00￥37,495.0034能达佳考勤钟BTIMMY53￥1,699.00￥90,047.0035小燕子长袖T恤A件195￥15.90￥3,100.

5、5036龙达飞男装B件256￥129.00￥33,024.0037忘不了西裤B件558￥89.00￥49,662.0038达菲亚弹力衫C件421￥15.80￥6,651.8039丝兰收腹裤N件53￥9.90￥524.7040女式休闲夹克C件195￥38.00￥7,410.0041赤金金笛童面巾A包421￥2.90￥1,220.9042伊蝶文胸B件53￥6.90￥365.7043雅丽水晶袜C包421￥6.90￥2,904.9044娜娇婷连裤袜C包53￥7.90￥418.7045力国绅土袜D包195￥9.90￥1,930.5046鳄鱼恤男式牛皮鞋N双57￥295.00￥16,815.0047杰尊男

6、式绅土鞋A双53￥49.00￥2,597.0048求足女式运动鞋B双195￥35.90￥7,000.5049嘉顿女式布胶鞋B双256￥6.50￥1,664.0050飞腾女式凉拖鞋C双558￥4.90￥2,734.2051男式夹克D件421￥89.00￥37,469.0052百一森精品衬衫C件53￥38.00￥2,014.0053女式时装弹力裤A件195￥49.90￥9,730.5054男式休闲裤B件421￥29.90￥12,587.9055儿童T恤A件53￥19.90￥1,054.7056富土达男内裤3条B盒421￥8.90￥3,746.9057胭脂红女式时装鞋B件53￥39.90￥2,114

7、.7058佳妮女式休闲皮鞋C双195￥49.00￥9,555.0059淑女牛仔包N个421￥28.90￥12,166.9060尔夫男式丝光棉袜C包53￥7.90￥418.7061女式牛仔衬衫A件195￥39.90￥7,780.5062女式长袖T恤B件256￥49.90￥12,774.4063路易老爷真丝领带C条558￥39.90￥22,264.2064花花公子休闲男鞋D双421￥59.90￥25,217.9065飞鹿牛皮男鞋N双53￥79.90￥4,234.7066康妮达牛皮女鞋A双195￥99.90￥19,480.5067卡帝乐鳄鱼女包B个421￥189.00￥79,569.0068D牌牛皮

8、皮带B条53￥29.90￥1,584.7069海鸣牛皮男手包C个7￥129.00￥903.0070德天腊排骨N500g53￥12.50￥662.5071卤牛肉C500g195￥14.80￥2,886.0072水晶梨Akg421￥2.80￥1,178.8073腰芒限长沙店Bkg421￥11.60￥4,883.6074下饭菜腊子排A350g53￥8.80￥466.4075百家乐水饺买一送一B360g421￥4.90￥2,062.9076盛湘靓晶米B5kg53￥12.50￥662.50775L天天旺旺调和油C5L195￥36.50￥7,117.5078正旺桶装剁辣椒D瓶47￥4.90￥230.307

9、9味好美果酱系列C瓶53￥3.50￥185.5080300g可字野山椒A瓶195￥2.50￥487.508168g百味林小花银耳B瓶421￥4.90￥2,062.9082220g甘竹豆豉鲮鱼C瓶53￥5.50￥291.5083500ml味莼园陈醋C瓶195￥2.90￥565.5084吉百利系列巧克力N包421￥6.90￥2,904.9085170g正林纸袋瓜子A包53￥1.90￥100.7086150g奥利奥B瓶195￥4.20￥819.0087280g君王笑口夏果B包421￥11.90￥5,009.908860g锦湖迷你派C包53￥2.60￥137.8089100g味美思系列梅子N包74￥1

10、.90￥140.6090正旺麻辣香干340gC包53￥14.90￥789.7091康师傅32四联包A包195￥8.80￥1,716.0092120g冠辉日本蛋卷B包421￥3.90￥1,641.9093统一奶礼盒装C包53￥22.50￥1,192.5094卡夫果珍系列C包195￥7.30￥1,423.5095伊力全脂甜奶粉D包256￥8.90￥2,278.4096智强三合一核桃粉A包558￥8.50￥4,743.0097雀巢香橙粉B包74￥10.70￥791.8098必圣黄豆奶粉B包53￥8.90￥471.7099金味低糖加钙麦片C包195￥16.50￥3,217.50100美年达厅装葡萄味N

11、瓶421￥1.70￥715.70101397g雀巢鹰唛炼乳C瓶53￥6.70￥355.10102水森活矿泉水A瓶45￥0.80￥36.00103开心果B500g53￥20.80￥1,102.40104冻带鱼C500g195￥4.98￥971.10105鲫鱼C500g78￥4.20￥327.60106炸春鸡A只47￥9.90￥465.30107鸡全翅B500g53￥7.80￥413.40108仔水鸭B只421￥12.80￥5,388.80109猪肉切丝片D500g53￥6.80￥360.40110唐人神百合花N500g195￥10.80￥2,106.00111长肉松条C380ml421￥5.00

12、￥2,105.00112太子奶A瓶53￥2.50￥132.50113100ml5乐百氏B瓶195￥4.50￥877.50114150g岳阳毛尖C包421￥12.90￥5,430.90115100g民兴金梅姜C包195￥1.20￥234.00116100g民兴桂花杨梅N包256￥1.90￥486.40117散装扭一扭果冻A500g55￥15.60￥858.00118脑轻松6盒装B盒57￥87.50￥4,987.50119维亭礼盒B盒53￥136.00￥7,208.00120400g长旺桂圆D盒195￥12.60￥2,457.0012110kg秀龙猫芽米N包54￥17.50￥945.00122西湖

13、味精A包53￥5.60￥296.80123陶华碧老干妈豆豉B瓶421￥4.80￥2,020.80124旺旺冰绿、红茶B瓶53￥0.90￥47.70125王朝爽口红葡萄酒C瓶195￥10.50￥2,047.50126王朝半甜红葡萄酒N瓶256￥13.50￥3,456.00127申牛牌酱牛肉C280g袋558￥7.70￥4,296.60128长方火腿块A250g块421￥14.50￥6,104.50129剥皮前、后蹄鲜肉B500g53￥4.30￥227.90130去骨纯精后腿A500g195￥6.10￥1,189.50131蕃茄B500g421￥0.80￥336.80132新土豆B500g53￥1

14、.00￥53.00133茄子（整盒起售）C500g421￥1.10￥463.10134黄瓜（整盒起售）N500g53￥1.30￥68.90135新奇土橙C500g195￥6.20￥1,209.00136牛蛙D500g421￥10.90￥4,588.90137鳝片B500g53￥11.90￥630.70138雅片鱼头A500g195￥15.50￥3,022.50139目鱼花B1kg袋256￥19.50￥4,992.00140目鱼B500g256￥15.90￥4,070.40141鲜肉小笼C500g袋558￥4.90￥2,734.20142统一鲜橙多N500ml421￥6.50￥2,736.501

15、43旺仔牛奶A245ml2453￥71.50￥3,789.50144台尚沙琪玛系列B450g袋195￥6.90￥1,345.50145迷你无糖高钙饼干B1kg盒421￥8.50￥3,578.50146700ml贝莉姿洗发水C瓶53￥18.90￥1,001.70147芙蓉露洗发水N瓶421￥39.90￥16,797.90148300ml喜肤沐浴露C瓶53￥9.20￥487.60149200g飘影啫哩水A瓶195￥8.90￥1,735.50150100g高露洁牙膏B支256￥31.00￥7,936.00151125g两面针牙膏D支558￥2.40￥1,339.20153洁尔丝护翼卫生巾B包53￥2

16、.40￥127.20154舒而美超薄B包195￥6.90￥1,345.50155心相印8送2卷纸C包421￥11.20￥4,715.20156125g夏士莲香皂N盒53￥3.40￥180.20157利盛行快乐雨伞C把421￥20.80￥8,756.80158振兴浸塑衣架1A个99￥168.00￥16,632.00159宏剑排插B个89￥23.80￥2,118.201601100家家好纸杯A36cm53￥6.70￥355.10161汇丰豪华盆B个195￥4.00￥780.0016218头圆晒架D个58￥6.00￥348.00163振兴学生水壶C个53￥5.50￥291.50164雕牌超能洗衣粉N

17、包421￥8.90￥3,746.90165雕牌透明皂C盒53￥2.00￥106.00166佳洁土茶爽牙膏A支195￥7.90￥1,540.50167光辉桶装洗衣粉B桶44￥19.80￥871.20168舒肤佳柠檬香皂C盒53￥3.60￥190.80169牛皮纸文件袋A包195￥9.90￥1,930.50170易尔利1032包式记事本B本256￥9.90￥2,534.40171罗氏129细枪钢笔B支256￥5.90￥1,510.40172索尼144软盘C盒558￥39.00￥21,762.00173开普特健康跑步机N台85￥988.00￥83,980.00175多用休闲枕C个53￥69.00￥3

18、,657.00176休闲座垫A个195￥19.90￥3,880.50177纯棉双人四件套B套421￥16.90￥7,114.90178迪斯尼印花浴巾C张53￥79.90￥4,234.70179双层不锈钢杯C个58￥9.90￥574.20180索芙特瘦脸洗面奶N瓶53￥12.90￥683.70181喜肤面膜N盒195￥24.90￥4,855.50182强生婴儿润肤露C瓶256￥12.50￥3,200.00183无芯卷筒卫生纸D30卷袋317￥14.20￥4,501.40原价总额与折后总额合计￥1,354,722.60折扣总额￥301,368.16折折后后价价折折后后总总额额￥3.66￥1,540

19、.86￥9.30￥492.90￥5.81￥1,132.95￥5.32￥1,361.92￥6.00￥3,348.00￥6.00￥1,596.00￥81.60￥9,955.20￥1,619.40￥8,097.00￥909.30￥9,093.00￥319.20￥6,384.00￥159.20￥2,388.00￥30.00￥10,560.00￥6.80￥850.00￥4.48￥1,048.32￥2.00￥1,116.00￥1,109.40￥26,625.60￥279.30￥14,802.90￥142.20￥27,729.00￥784.00￥5,488.00￥5,998.00￥47,984.00￥79.

20、20￥4,197.60￥29.40￥5,733.00￥125.30￥32,076.80￥6.00￥3,348.00￥268.20￥22,797.00￥59.40￥3,148.20￥22.80￥4,446.00￥559.30￥48,659.10￥657.30￥34,836.90￥1,119.20￥8,953.60￥71.10￥3,768.30￥423.20￥2,116.00￥6,749.10￥33,745.50￥1,189.30￥63,032.90￥9.54￥1,860.30￥90.30￥23,116.80￥62.30￥34,763.40￥12.64￥5,321.44￥9.90￥524.70￥3

21、0.40￥5,928.00￥1.74￥732.54凡凡购购买买A类类商商品品享享受受6折折的的折折扣扣，凡凡购购买买B类类商商品品享享受受7折折的的折折扣扣，凡凡购购买买C类类商商品品享享受受8折折的的折折扣扣，凡凡购购买买D类类商商品品享享受受9折折的的折折扣扣，购购买买其其他他商商品品（用用代代码码N表表示示）没没有有折折扣扣。￥4.83￥255.99￥5.52￥2,323.92￥6.32￥334.96￥8.91￥1,737.45￥295.00￥16,815.00￥29.40￥1,558.20￥25.13￥4,900.35￥4.55￥1,164.80￥3.92￥2,187.36￥80.10

22、￥33,722.10￥30.40￥1,611.20￥29.94￥5,838.30￥20.93￥8,811.53￥11.94￥632.82￥6.23￥2,622.83￥27.93￥1,480.29￥39.20￥7,644.00￥28.90￥12,166.90￥6.32￥334.96￥23.94￥4,668.30￥34.93￥8,942.08￥31.92￥17,811.36￥53.91￥22,696.11￥79.90￥4,234.70￥59.94￥11,688.30￥132.30￥55,698.30￥20.93￥1,109.29￥103.20￥722.40￥12.50￥662.50￥11.84￥2

23、,308.80￥1.68￥707.28￥8.12￥3,418.52￥5.28￥279.84￥3.43￥1,444.03￥8.75￥463.75￥29.20￥5,694.00￥4.41￥207.27￥2.80￥148.40￥1.50￥292.50￥3.43￥1,444.03￥4.40￥233.20￥2.32￥452.40￥6.90￥2,904.90￥1.14￥60.42￥2.94￥573.30￥8.33￥3,506.93￥2.08￥110.24￥1.90￥140.60￥11.92￥631.76￥5.28￥1,029.60￥2.73￥1,149.33￥18.00￥954.00￥5.84￥1,138

24、.80￥8.01￥2,050.56￥5.10￥2,845.80￥7.49￥554.26￥6.23￥330.19￥13.20￥2,574.00￥1.70￥715.70￥5.36￥284.08￥0.48￥21.60￥14.56￥771.68￥3.98￥776.88￥3.36￥262.08￥5.94￥279.18￥5.46￥289.38￥8.96￥3,772.16￥6.12￥324.36￥10.80￥2,106.00￥4.00￥1,684.00￥1.50￥79.50￥3.15￥614.25￥10.32￥4,344.72￥0.96￥187.20￥1.90￥486.40￥9.36￥514.80￥61.2

25、5￥3,491.25￥95.20￥5,045.60￥11.34￥2,211.30￥17.50￥945.00￥3.36￥178.08￥3.36￥1,414.56￥0.63￥33.39￥8.40￥1,638.00￥13.50￥3,456.00￥6.16￥3,437.28￥8.70￥3,662.70￥3.01￥159.53￥3.66￥713.70￥0.56￥235.76￥0.70￥37.10￥0.88￥370.48￥1.30￥68.90￥4.96￥967.20￥9.81￥4,130.01￥8.33￥441.49￥9.30￥1,813.50￥13.65￥3,494.40￥11.13￥2,849.28￥

26、3.92￥2,187.36￥6.50￥2,736.50￥42.90￥2,273.70￥4.83￥941.85￥5.95￥2,504.95￥15.12￥801.36￥39.90￥16,797.90￥7.36￥390.08￥5.34￥1,041.30￥21.70￥5,555.20￥2.16￥1,205.28￥1.68￥89.04￥4.83￥941.85￥8.96￥3,772.16￥3.40￥180.20￥16.64￥7,005.44￥100.80￥9,979.20￥16.66￥1,482.74￥4.02￥213.06￥2.80￥546.00￥5.40￥313.20￥4.40￥233.20￥8.90

27、￥3,746.90￥1.60￥84.80￥4.74￥924.30￥13.86￥609.84￥2.88￥152.64￥5.94￥1,158.30￥6.93￥1,774.08￥4.13￥1,057.28￥31.20￥17,409.60￥988.00￥83,980.00￥55.20￥2,925.60￥11.94￥2,328.30￥11.83￥4,980.43￥63.92￥3,387.76￥7.92￥459.36￥12.90￥683.70￥24.90￥4,855.50￥10.00￥2,560.00￥12.78￥4,051.26￥1,053,354.44伊莱克斯冰箱DCD1911849格兰仕微波炉WD8

28、00TL213399富土宝饮水机2005158海尔冷柜BCBD68980冰箱洗衣机套装kg22e18s6005998依立紫沙锅25L99王中皇水壶3L49海鸥照相机SC118179明珠星闹钟7.5科皇热水器JSYD7B1298电饭锅CFXB405M66华裕电熨斗YPF218838厦新家庭影院DH9030SA961799康佳彩电21英寸939松下洗衣机XQB4584601399压力锅20CM79佳能打印机S100SP529夏普复印机AL12407499能达佳考勤钟考勤卡TIMMYP169919（100张）小燕子长袖T恤15.9龙达飞男装129忘不了西裤89达菲亚弹力衫15.8丝兰收腹裤9.9女式

29、休闲夹克38赤金金笛童面巾2.9伊蝶文胸6.9雅丽水晶袜包69元娜娇婷连裤袜7.9力国绅土袜包99元鳄鱼恤男式牛皮鞋245265cm295杰尊男式绅土鞋245265cm49求足女式运动鞋225245cm35.9嘉顿女式布胶鞋225245cm6.5飞腾女式凉拖鞋22525cm4.9男式夹克89百一森精品衬衫38女式时装弹力裤49.9男式休闲裤29.9儿童T恤19.9富土达男内裤3条8.9胭脂红女式时装鞋39.9佳妮女式休闲皮鞋49淑女牛仔包28.9尔夫男式丝光棉袜3双7.9女式牛仔衬衫连帽背心开襟T恤39.9女式长袖T恤灯心绒衬衫49.9路易老爷真丝领带39.9花花公子休闲男鞋59.9飞鹿牛皮男

30、鞋79.9康妮达牛皮女鞋99.9卡帝乐鳄鱼女包小189大199D牌牛皮皮带29.9海鸣牛皮男手包黑、棕129德天腊排骨500g12.5卤牛肉500g14.8水晶梨限常德、长沙、岳阳kg2.8腰芒限长沙店kg11.6下饭菜腊子排350g8.8百家乐水饺买一送一360g4.9盛湘靓晶米5kg12.55L天天旺旺调和油5L36.51500g正旺桶装剁辣椒4.9170g味好美果酱系列3.5300g可字野山椒2.568g百味林小花银耳4.9220g甘竹豆豉鲮鱼5.5500ml味莼园陈醋2.984g吉百利系列巧克力6.9170g正林纸袋瓜子1.9150g奥利奥4.2280g君王笑口夏果11.960g锦湖迷

31、你派2.6100g味美思系列梅子1.960g3正旺麻辣香干340g四洲紫菜14.9460g康师傅32四联包8.8120g冠辉日本蛋卷3.9240ml9统一奶礼盒装送双层饭盒一个22.5500g卡夫果珍系列7.3400g伊力全脂甜奶粉8.9400g智强三合一核桃粉8.5500g雀巢香橙粉10.7必圣黄豆奶粉8.9600g金味低糖加钙麦片16.5355ml美年达厅装葡萄味1.7397g雀巢鹰唛炼乳6.7596ml水森活矿泉水0.8开心果500g20.8冻带鱼500g4.98鲫鱼500g4.2炸春鸡只9.9鸡全翅500g7.8仔水鸭只12.8猪肉切丝片500g6.8唐人神百合花500g10.8长肉松

32、条380ml5太子奶2.5100ml5乐百氏4.5150g岳阳毛尖12.9100g民兴金梅姜1.2100g民兴桂花杨梅1.9散装扭一扭果冻（15g装）买二送一500g15.6脑轻松6盒装87.5维亭礼盒136400g长旺桂圆12.610kg秀龙猫芽米17.5西湖味精5.6300g陶华碧老干妈豆豉4.8旺旺冰绿、红茶0.9王朝爽口红葡萄酒10.5王朝半甜红葡萄酒13.5申牛牌酱牛肉280g袋7.7长方火腿块250g块14.5剥皮前、后蹄鲜肉500g4.3去骨纯精后腿10kg起售500g6.1蕃茄500g0.8新土豆500g1茄子（整盒起售）500g1.1黄瓜（整盒起售）500g1.3新奇土橙50

33、0g6.2牛蛙500g10.9鳝片500g11.9雅片鱼头500g15.5目鱼花1kg袋19.5目鱼500g15.9鲜肉小笼500g袋4.9统一鲜橙多500ml6.5旺仔牛奶245ml2471.5台尚沙琪玛系列450g袋6.9小迷你无糖高钙饼干1kg盒8.5700ml贝莉姿洗发水18.9800ml芙蓉露洗发水39.9300ml喜肤沐浴露9.2200g飘影啫哩水8.9100g高露洁牙膏31125g两面针牙膏2.4家润多百货类1.25P洁尔丝护翼卫生巾舒而美超薄4010清香护垫6.9心相印8送2卷纸11.2125g夏士莲香皂3.4利盛行快乐雨伞20.8振兴浸塑衣架11066宏剑排插23.81100家家好纸杯6.7汇丰豪华盆36cm418头圆晒架6振兴学生水壶5.5雕牌超能洗衣粉8.9雕牌透明皂2120g佳洁土茶爽牙膏7.9光辉桶装洗衣粉19.8舒肤佳柠檬香皂3.6牛皮纸文件袋25个装9.9易尔利1032包式记事本9.9罗氏129中细枪灰钢笔5.9索尼144软盘十片装39开普特12功能健康跑步机988麦德龙百货类多用休闲枕19.9休闲座垫16.9纯棉双人被套四件套被套1条、床单1条、枕套两只79.9各式迪斯尼印花浴巾9.9双层不锈钢杯12.9索芙特瘦脸洗面奶24.9喜肤面膜12.5100ml强生婴儿润肤露14.2洁云无芯卷筒卫生纸30卷袋12.5