电商抢购购利润计算表(新版)

此 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 为简易抢购利润计算，有底色出可修改数据，在表1完成即可，表2表3为详细计算数据，本表仅供参考宝贝名称宝贝ID采购价最低价9折活动价报名库存货值预估销量销售额人工+运费天猫佣金（5%）利润(10%购买2件)抢购佣金奖励金额额外损耗（5%退货+5%换货）净利润351009050300015000026601330008399018952.53990104431928824.5501009080125010000010008000084000219604000900120013660501009090110099000700630008315022333.5315046884015661.5501009010010001000004004000082000167402000100480123605010090110900990001001100085505179.599001203519.5抢购佣金计算表：表格有底色和佣金处直接在表1修改即可，其余为公式计算，仅供参考活动价报名件数类目佣金率货值保底佣金实际销售销售额天猫扣费（不计入抢购）售罄率支出佣金奖励金额收支总和售罄时天猫扣费大于70%大于50%大于30%小于30%50.030003%150000.0900.02660133000.03990.088.67%39901044.0-2,946.04,500.001,044.00876.00528.000.0080.012505%100000.01000.0100080000.04000.080.00%4000900.0-3,100.05,000.00900.00800.00500.000.0090.011005%99000.0990.070063000.03150.063.64%3150468.0-2,682.04,950.00405.00468.00333.000.00100.010005%100000.01000.040040000.02000.040.00%2000100.0-1,900.05,000.00-300.000.00100.000.00110.09005%99000.0990.010011000.0550.011.11%9900.0-990.04,950.00-1,155.00-572.00-187.000.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#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!#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!#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!#VALUE!00.000.000.000.000.000.000.000.000.000.000.000.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000宝贝图片宝贝名称宝贝ID宝贝链接品牌名称货号一口价现售价近30天最低价采购价额外扣费成本利润活动价活动成本库存利润10%购买2件货值50%售罄率10%购买2件的利润80%售罄率10%购买2件的利润100%售罄率10%购买2件的利润税点5.5%运费包装合计日常参照表一1件的成本报N件预估销量500.00250.00250.0035.013.758.0021.75$56.75193.2550.0$45.753000.002,66018,953150,0008,21313,14016,425250.00100.00100.0050.05.508.0013.50$63.5036.5080.0$62.401250.001,00021,960100,00012,60020,16025,200100.0080.0080.0050.04.408.0012.40$62.4017.6090.0$62.951100.0070022,33499,00016,80526,88833,6111000.00500.00500.0050.027.508.0035.50$85.50414.50100.0$63.501000.0040016,740100,00020,47532,76040,9501000.00500.00500.0050.027.508.0035.50$85.50414.50110.0$64.05900.001005,18099,00023,10536,96846,211