2017年度电商项目经营预算分析表+天猫运营计划预算分析表.xlsx

《2017年度电商项目经营预算分析表+天猫运营计划预算分析表.xlsx》由会员分享，可在线阅读，更多相关《2017年度电商项目经营预算分析表+天猫运营计划预算分析表.xlsx（1页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、2015年度电商项目经营预算分析表 科目2015年1月2015年2月2015年3月2015年4月2015年5月2015年6月2015年7月2015年8月2015年9月2015年10月2015年11月2014年12月2015年1月-2015年12月总合计收入含税销售额0.050,000.0100,000.0450,000.0800,000.01,000,000.01,800,000.01,500,000.03,000,000.03,500,000.04,000,000.03,800,000.020,000,000.0未税销售额0.042,735.085,470.1384,615.4683,760

2、.7854,700.91,538,461.51,282,051.32,564,102.62,991,453.03,418,803.43,247,863.217,094,017.1含税成本0.037,500.065,000.0270,000.0480,000.0550,000.0900,000.0600,000.0900,000.01,050,000.02,000,000.01,140,000.07,992,500.0未税成本0.032,051.355,555.6230,769.2410,256.4470,085.5769,230.8512,820.5769,230.8897,435.91,70

3、9,401.7974,359.06,831,196.6毛利率0.0%25.0%35.0%40.0%40.0%45.0%50.0%60.0%70.0%70.0%50.0%70.0%60.0%含税毛利额0.012,500.035,000.0180,000.0320,000.0450,000.0900,000.0900,000.02,100,000.02,450,000.02,000,000.02,660,000.012,007,500.0未税毛利额0.010,683.829,914.5153,846.2273,504.3384,615.4769,230.8769,230.81,794,871.82

4、,094,017.11,709,401.72,273,504.310,262,820.5费用平台费用率0.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.6%保证金率(只支付第一年）0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.3%平台使用年费率0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.3%平台佣金扣点率5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%推广费率6.0%46.0%46

5、.0%39.3%37.3%36.0%28.2%26.0%23.3%21.7%20.3%19.2%24.0%淘内推广费率0.0%40.0%40.0%33.3%31.3%30.0%22.2%20.0%17.3%15.7%14.3%13.2%18.0%淘外推广费率6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%物流仓储费用率物流损耗费率6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%物流费率5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.

6、0%损耗费率1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%仓储费率4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%管理费用率0.0%200.0%100.0%22.2%12.5%10.0%13.9%15.3%7.7%6.6%5.8%6.1%10.0%平台费用额110,000.02,500.05,000.022,500.040,000.050,000.090,000.075,000.0150,000.0175,000.0200,000.0190,000.01,110,000.0保证金(

7、只支付第一年）50,000.00.00.00.00.00.00.00.00.00.00.00.050,000.0平台使用年费60,000.00.00.00.00.00.00.00.00.00.00.00.060,000.0平台佣金扣点0.02,500.05,000.022,500.040,000.050,000.090,000.075,000.0150,000.0175,000.0200,000.0190,000.01,000,000.0推广费0.023,000.046,000.0177,000.0298,000.0360,000.0508,000.0390,000.0700,000.0760

8、,000.0810,000.0728,000.04,800,000.0淘内推广费0.020,000.040,000.0150,000.0250,000.0300,000.0400,000.0300,000.0520,000.0550,000.0570,000.0500,000.03,600,000.0淘外推广费0.03,000.06,000.027,000.048,000.060,000.0108,000.090,000.0180,000.0210,000.0240,000.0228,000.01,200,000.0物流仓储费用物流损耗费0.03,000.06,000.027,000.048,

9、000.060,000.0108,000.090,000.0180,000.0210,000.0240,000.0228,000.01,200,000.0物流费0.02,500.05,000.022,500.040,000.050,000.090,000.075,000.0150,000.0175,000.0200,000.0190,000.01,000,000.0损耗费0.0500.01,000.04,500.08,000.010,000.018,000.015,000.030,000.035,000.040,000.038,000.0200,000.0仓储费0.02,000.04,000.

10、018,000.032,000.040,000.072,000.060,000.0120,000.0140,000.0160,000.0152,000.0800,000.0管理费用100,000.0100,000.0100,000.0100,000.0100,000.0100,000.0250,000.0230,000.0230,000.0230,000.0230,000.0230,000.02,000,000.0总费用率0%261%161%77%65%61%57%56%46%43%41%40%50%费用总额210,000.0130,500.0161,000.0344,500.0518,000

11、.0610,000.01,028,000.0845,000.01,380,000.01,515,000.01,640,000.01,528,000.09,910,000.0利润净毛利率（不含后台成本）0.0%-236.0%-126.0%-36.6%-24.8%-16.0%-7.1%3.7%24.0%26.7%9.0%29.8%10.5%含税净毛利额-210,000.0-118,000.0-126,000.0-164,500.0-198,000.0-160,000.0-128,000.055,000.0720,000.0935,000.0360,000.01,132,000.02,097,500.0不含税净毛利额-179,487.2-100,854.7-107,692.3-140,598.3-169,230.8-136,752.1-109,401.747,008.5615,384.6799,145.3307,692.3967,521.41,792,735.0注：更多下载，50张表格尽在知识库 1、从2015年8月起开始进入盈亏平衡，前期现金流出1406500元，因此所需现金资本设定为150万元。2、2000万的销售额按年周转率8次计算，货物资本设定为250万。两者合并总投入最大资金规模设定为400万。