1、2018年度电商项目经营预算分析表科目 2018年1月 2018年2月 2018年3月 2018年4月收入含税销售额 560,000.0 45,000.0 1,200,000.0 1,450,000.0未税销售额 478,632.5 38,461.5 1,025,641.0 1,239,316.2含税成本 504,000.0 40,500.0 780,000.0 870,000.0未税成本 430,769.2 34,615.4 666,666.7 743,589.7毛利率 10.0% 10.0% 35.0% 40.0%含税毛利额 56,000.0 4,500.0 420,000.0 580,0
2、00.0未税毛利额 47,863.2 3,846.2 358,974.4 495,726.5费用平台费用率 0.0% 5.0% 5.0% 5.0%保证金率(只支付第一年） 0.0% 0.0% 0.0% 0.0%平台使用年费率 0.0% 0.0% 0.0% 0.0%平台佣金扣点率 5.0% 5.0% 5.0% 5.0%推广费率 6.0% 50.4% 9.3% 16.3%淘内推广费率 0.0% 44.4% 3.3% 10.3%淘外推广费率 6.0% 6.0% 6.0% 6.0%物流仓储费用率物流损耗费率 6.0% 6.0% 6.0% 6.0%物流费率 5.0% 5.0% 5.0% 5.0%损耗费率
3、 1.0% 1.0% 1.0% 1.0%仓储费率 4.0% 4.0% 4.0% 4.0%管理费用率 0.0% 222.2% 8.3% 6.9%平台费用额 138,000.0 2,250.0 60,000.0 72,500.0保证金(只支付第一年） 50,000.0 0.0 0.0 0.0平台使用年费 60,000.0 0.0 0.0 0.0平台佣金扣点 28,000.0 2,250.0 60,000.0 72,500.0推广费 33,600.0 22,700.0 112,000.0 237,000.0淘内推广费 0.0 20,000.0 40,000.0 150,000.0淘外推广费 33,6
4、00.0 2,700.0 72,000.0 87,000.0物流仓储费用物流损耗费 33,600.0 2,700.0 72,000.0 87,000.0物流费 28,000.0 2,250.0 60,000.0 72,500.0损耗费 5,600.0 450.0 12,000.0 14,500.0仓储费 22,400.0 1,800.0 48,000.0 58,000.0管理费用 100,000.0 100,000.0 100,000.0 100,000.0总费用率 0% 288% 33% 38%费用总额 327,600.0 129,450.0 392,000.0 554,500.0利润净毛利
5、率（不含后台成本） 0.0% -277.7% 2.3% 1.8%含税净毛利额 -271,600.0 -124,950.0 28,000.0 25,500.0不含税净毛利额 -232,136.8 -106,794.9 23,931.6 21,794.9注：1、从2018年8月起开始进入盈亏平衡，前期现金流出1406500元，因此所需现金资本设定为150万元。2、2000万的销售额按年周转率8次计算，货物资本设定为250万。两者合并总投入最大资金规模设定为400万。2018年5月 2018年6月 2018年7月 2018年8月 2018年9月 2018年10月 2018年11月1,800,000.
6、0 23,000,000.0 5,800,000.0 6,500,000.0 13,000,000.0 13,500,000.0 4,000,000.01,538,461.5 19,658,119.7 4,957,265.0 5,555,555.6 11,111,111.1 11,538,461.5 3,418,803.41,080,000.0 12,650,000.0 2,900,000.0 2,600,000.0 3,900,000.0 4,050,000.0 2,000,000.0923,076.9 10,811,965.8 2,478,632.5 2,222,222.2 3,333,3
7、33.3 3,461,538.5 1,709,401.740.0% 45.0% 50.0% 60.0% 70.0% 70.0% 50.0%720,000.0 10,350,000.0 2,900,000.0 3,900,000.0 9,100,000.0 9,450,000.0 2,000,000.0615,384.6 8,846,153.8 2,478,632.5 3,333,333.3 7,777,777.8 8,076,923.1 1,709,401.75.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%
8、0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%5.0% 5.0% 5.0% 5.0% 5.0% 5.0% 5.0%19.9% 7.3% 12.9% 10.6% 10.0% 10.1% 20.3%13.9% 1.3% 6.9% 4.6% 4.0% 4.1% 14.3%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%1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 1.0%4.0% 4.0% 4.0% 4.0%
9、4.0% 4.0% 4.0%5.6% 0.4% 4.3% 3.5% 1.8% 1.7% 5.8%90,000.0 1,150,000.0 290,000.0 325,000.0 650,000.0 675,000.0 200,000.00.0 0.0 0.0 0.0 0.0 0.0 0.00.0 0.0 0.0 0.0 0.0 0.0 0.090,000.0 1,150,000.0 290,000.0 325,000.0 650,000.0 675,000.0 200,000.0358,000.0 1,680,000.0 748,000.0 690,000.0 1,300,000.0 1,36
10、0,000.0 810,000.0250,000.0 300,000.0 400,000.0 300,000.0 520,000.0 550,000.0 570,000.0108,000.0 1,380,000.0 348,000.0 390,000.0 780,000.0 810,000.0 240,000.0108,000.0 1,380,000.0 348,000.0 390,000.0 780,000.0 810,000.0 240,000.090,000.0 1,150,000.0 290,000.0 325,000.0 650,000.0 675,000.0 200,000.018
11、,000.0 230,000.0 58,000.0 65,000.0 130,000.0 135,000.0 40,000.072,000.0 920,000.0 232,000.0 260,000.0 520,000.0 540,000.0 160,000.0100,000.0 100,000.0 250,000.0 230,000.0 230,000.0 230,000.0 230,000.040% 23% 32% 29% 27% 27% 41%728,000.0 5,230,000.0 1,868,000.0 1,895,000.0 3,480,000.0 3,615,000.0 1,6
12、40,000.0-0.4% 22.3% 17.8% 30.8% 43.2% 43.2% 9.0%-8,000.0 5,120,000.0 1,032,000.0 2,005,000.0 5,620,000.0 5,835,000.0 360,000.0-6,837.6 4,376,068.4 882,051.3 1,713,675.2 4,803,418.8 4,987,179.5 307,692.32018年度电商项目经营预算分析表2018年12月 2018年1月-2018年12月总合计3,800,000.0 74,655,000.03,247,863.2 63,807,692.31,140
13、,000.0 32,514,500.0974,359.0 27,790,170.970.0% 56.4%2,660,000.0 42,140,500.02,273,504.3 36,017,521.45.0% 5.1%0.0% 0.1%0.0% 0.1%5.0% 5.0%19.2% 10.8%13.2% 4.8%6.0% 6.0%6.0% 6.0%5.0% 5.0%1.0% 1.0%4.0% 4.0%6.1% 2.7%190,000.0 3,842,750.00.0 50,000.00.0 60,000.0190,000.0 3,732,750.0728,000.0 8,079,300.0500,000.0 3,600,000.0228,000.0 4,479,300.0228,000.0 4,479,300.0190,000.0 3,732,750.038,000.0 746,550.0152,000.0 2,986,200.0230,000.0 2,000,000.040% 29%1,528,000.0 21,387,550.029.8% 27.8%1,132,000.0 20,752,950.0967,521.4 17,737,564.12018年度电商项目经营预算分析表
