某电商成本利润计算表(新版)-

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

宝贝名称宝贝ID采购价最低价9折活动价报名库存货值3510090503000150000501009080125010000050100909011009900050100901001000100000501009011090099000此表为简易抢购利润计算,有底色出可修改数据,在表1完成即可,表2表3为详细计算数据,本表仅供参考,表3最好别看,我自己看了都晕————阿狼的思维预估销量销售额人工+运费天猫佣金(5%)利润(10%购买2件)抢购佣金奖励金额26601330008399018952.53990104410008000084000219604000900700630008315022333.5315046840040000820001674020001001001100085505179.59900此表为简易抢购利润计算,有底色出可修改数据,在表1完成即可,表2表3为详细计算数据,本表仅供参考,表3最好别看,我自己看了都晕————阿狼的思维额外损耗(5%退货+5%换货)净利润31928824.512001366084015661.5480123601203519.5此表为简易抢购利润计算,有底色出可修改数据,在表1完成即可,表2表3为详细计算数据,本表仅供参考,表3最好别看,我自己看了都晕————阿狼的思维活动价报名件数类目佣金率货值保底佣金实际销售50.030003%150000.0900.0266080.012505%100000.01000.0100090.011005%99000.0990.0700100.010005%100000.01000.0400110.09005%99000.0990.0100抢购佣金计算表:表格有底色和佣金处直接在表1修改即可,其余为公式计算,仅供参考——阿狼的思维销售额天猫扣费(不计入抢购)售罄率支出佣金奖励金额收支总和133000.03990.088.67%39901044.0-2,946.080000.04000.080.00%4000900.0-3,100.063000.03150.063.64%3150468.0-2,682.040000.02000.040.00%2000100.0-1,900.011000.0550.011.11%9900.0-990.0#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!抢购佣金计算表:表格有底色和佣金处直接在表1修改即可,其余为公式计算,仅供参考——阿狼的思维#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!#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抢购佣金计算表:表格有底色和佣金处直接在表1修改即可,其余为公式计算,仅供参考——阿狼的思维售罄时天猫扣费大于70%大于50%大于30%小于30%4,500.001,044.00876.00528.000.005,000.00900.00800.00500.000.004,950.00405.00468.00333.000.005,000.00-300.000.00100.000.004,950.00-1,155.00-572.00-187.000.00#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!#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!#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!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!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!#VALUE!0.00#VALUE!#VALUE!0.00#VALUE!宝贝图片宝贝名称宝贝ID宝贝链接品牌名称货号一口价500.00250.00100.001000.001000.00现售价近30天最低价采购价成本利润活动价税点5.5%运费包装合计日常参照表一250.00250.0035.013.758.0021.75$56.75193.2550.0100.00100.0050.05.508.0013.50$63.5036.5080.080.0080.0050.04.408.0012.40$62.4017.6090.0500.00500.0050.027.508.0035.50$85.50414.50100.0500.00500.0050.02

1 / 522
下载文档,编辑使用

©2015-2020 m.777doc.com 三七文档.

备案号:鲁ICP备2024069028号-1 客服联系 QQ:2149211541

×
保存成功