【成本】抢购购利润计算(新版)[4页]

抢购傻瓜利润计算此表为简易抢购利润计算，有底色出可修改数据，在表1完成即可，表2表3为详细计算数据，本表仅供参考，表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.011