【电商】成本抢购购利润计算

宝贝名称宝贝ID采购价最低价9折活动价报名库存货值预估销量销售额35100905030001500002660133000501009080125010000010008000050100909011009900070063000501009010010001000004004000050100901109009900010011000此表为简易抢购利润计算，有底色出可修改数据，在表1完成即可，表2表3为详细计算数据，本表仅供参考，表3最好别看，我自己看了都晕人工+运费XX佣金（5%）利润(10%购买2件)抢购佣金奖励金额额外损耗（5%退货+5%换货）净利润8399018952.53990104431928824.5840002196040009001200136608315022333.5315046884015661.5820001674020001004801236085505179.599001203519.5此表为简易抢购利润计算，有底色出可修改数据，在表1完成即可，表2表3为详细计算数据，本表仅供参考，表3最好别看，我自己看了都晕活动价报名件数类目佣金率货值保底佣金实际销售销售额50.030003%150000.0900.02660133000.080.012505%100000.01000.0100080000.090.011005%99000.0990.070063000.0100.010005%100000.01000.040040000.0110.09005%99000.0990.010011000.0抢购佣金计算表：表格有底色和佣金处直接在表1修改即可，其余为公式计算，仅供参考XX扣费（不计入抢购）售罄率支出佣金奖励金额收支总和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!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#VALUE!#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!00.000.000.000.000.000.000.000.000.000.000.000.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000售罄时XX扣费大于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宝贝链接品牌名称货号一口价现售价近30天最低价500.00250.00250.00250.00100.00100.00100.0080.0080.001000.00500.00500.001000.00500.00500.00采购价成本利润活动价活动成本库存税点5.5%运费包装合计日常参照表一1件的成本报N件预估销量35.013.758.0021.75$56.75193.2550.0$45.753000.002,66050.05.508.0013.50$63.5036.5080.0$62.401250.001,00050.04.408.0012.40$62.4017.6090.0$62.951100.0070050.027.508.0035.50$85.50414.50100.0$63.501000.0040050.027.508.0035.50$85.50414.50110.0$64.05900.00100额外扣费货值18,953150,000