1、此表为简易抢购利润计算，有底色出可修改数据，在表1完成即可，表2表3为详细计算数据，本表仅供参考， 表3最好别看，我自己看了都晕 狼灰宝贝名称宝贝ID采购价最低价9折活动价报名库存货值预估销量351009050300015000026605010090801250100000100050100909011009900070050100901001000100000400501009011090099000100销售额人工+运费天猫佣金（5%）利润(10%购买2件)抢购佣金 奖励金额额外损耗 （5%退货+5%换货）净利润1330008399018952.53990104431928824.580
2、00084000219604000900120013660630008315022333.5315046884015661.54000082000167402000100480123601100085505179.599001203519.5此表为简易抢购利润计算，有底色出可修改数据，在表1完成即可，表2表3为详细计算数据，本表仅供参考， 表3最好别看，我自己看了都晕 狼灰抢购佣金计算表：表格有底色和佣金处直接在表1修改即可，其余为公式计算，仅供参考活动价报名件数类目佣金率货值保底佣金实际销售销售额50.030003%150000.0900.02660133000.080.012505%100
3、000.01000.0100080000.090.011005%99000.0990.070063000.0100.010005%100000.01000.040040000.0110.09005%99000.0990.010011000.0天猫扣费 （不计入抢购）售罄率支出佣金奖励金额收支总和3990.088.67%39901044.0-2,946.04000.080.00%4000900.0-3,100.03150.063.64%3150468.0-2,682.02000.040.00%2000100.0-1,900.0550.011.11%9900.0-990.0#VALUE!#VALU
4、E!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VAL
5、UE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!抢购佣金计算表：表格有底色和佣金处直接在表1修改即可，其余为公式计算，仅供参考#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE
6、!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALU
7、E!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VAL
8、UE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VA
9、LUE!#VALUE!#VALUE!#VALUE!00.000.000.000.000.000.000.000.000.000.000.000.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
10、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000抢购佣金计算表：表格有底色和佣金处直接在表1修改即可，其余为公式计算，仅供参考售罄时天猫扣费4,500.005,000.004,950.005,000.004,950.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALU
11、E!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!大于70%大于50%大于30%小于30%1,044.00876.00528.000.00900.00800.00500.000.00405.00468.00333.000.00-300.000.00100.000.00-1,155.00-572.00-187.000.00#VALUE!#VALUE!#VALUE!#VALUE!#
12、VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#V
13、ALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#V
14、ALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#V
15、ALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#V
16、ALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!0.00#VALUE!宝宝贝贝图图片片宝宝贝贝名名称称宝宝贝贝IDID宝宝贝贝链链接接品品牌牌名名称称货货号号一一口口价价现现售售价价500.00250.00250.00100.00100.0080.001000.00500.001000.00500.00近近3030天天最最低低价价采采购购价价额额外外扣扣费费成成本本利利润润活活动动价价活活动动成成本本税税点点5.5%5.5%运运费费包包装装合合计计
17、日日常常参参照照表表一一1 1件件的的成成本本250.0035.013.758.0021.75$56.75$56.75193.25193.2550.0$45.75$45.75100.0050.05.508.0013.50$63.50$63.5036.5036.5080.0$62.40$62.4080.0050.04.408.0012.40$62.40$62.4017.6017.6090.0$62.95$62.95500.0050.027.508.0035.50$85.50$85.50414.50414.50100.0$63.50$63.50500.0050.027.508.0035.50$85
18、.50$85.50414.50414.50110.0$64.05$64.05库库存存利利润润10%10%购购买买2 2件件货货值值50%50%售售罄罄率率10%10%购购买买2 2件件的的利利润润80%80%售售罄罄率率10%10%购购买买2 2件件的的利利润润100%100%售售罄罄率率10%10%购购买买2 2件件的的利利润润报报N N件件预预估估销销量量3000.002,66018,953150,0008,21313,14016,4251250.001,00021,960100,00012,60020,16025,2001100.0070022,33499,00016,80526,88833,6111000.0040016,740100,00020,47532,76040,950900.001005,18099,00023,10536,96846,211
