2018年度电商项目经营财务预算分析表

,2018年度电商项目经营预算分析表,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,科目,,,,,公式,2018年1月,2018年2月,2018年3月,2018年4月,2018年5月,2018年6月,2013年12月,2018年7月,2018年8月,2018年9月,2018年10月,2018年11月,2018年12月,2018年1月-2018年12月总合计

,收入,含税销售额,,,A,A,"560,000.0","45,000.0","1,200,000.0","1,450,000.0","1,800,000.0","23,000,000.0","28,055,000.0","5,800,000.0","6,500,000.0","13,000,000.0","13,500,000.0","4,000,000.0","3,800,000.0","74,655,000.0"

,,未税销售额,,,A1,A/1.17,"478,632.5","38,461.5","1,025,641.0","1,239,316.2","1,538,461.5","19,658,119.7","23,978,632.5","4,957,265.0","5,555,555.6","11,111,111.1","11,538,461.5","3,418,803.4","3,247,863.2","63,807,692.3"

,,含税成本,,,A2,A*(1-B),"504,000.0","40,500.0","780,000.0","870,000.0","1,080,000.0","12,650,000.0","15,924,500.0","2,900,000.0","2,600,000.0","3,900,000.0","4,050,000.0","2,000,000.0","1,140,000.0","32,514,500.0"

,,未税成本,,,A3,A2/1.17,"430,769.2","34,615.4","666,666.7","743,589.7","923,076.9","10,811,965.8","13,610,683.8","2,478,632.5","2,222,222.2","3,333,333.3","3,461,538.5","1,709,401.7","974,359.0","27,790,170.9"

,,毛利率,,,B,B,10.0%,10.0%,35.0%,40.0%,40.0%,45.0%,43.2%,50.0%,60.0%,70.0%,70.0%,50.0%,70.0%,56.4%

,,含税毛利额,,,B1,A*B,"56,000.0","4,500.0","420,000.0","580,000.0","720,000.0","10,350,000.0","12,130,500.0","2,900,000.0","3,900,000.0","9,100,000.0","9,450,000.0","2,000,000.0","2,660,000.0","42,140,500.0"

,,未税毛利额,,,B2,B1/1.17,"47,863.2","3,846.2","358,974.4","495,726.5","615,384.6","8,846,153.8","10,367,948.7","2,478,632.5","3,333,333.3","7,777,777.8","8,076,923.1","1,709,401.7","2,273,504.3","36,017,521.4"

,费用,平台费用率,,,C,D/A,0.0%,5.0%,5.0%,5.0%,5.0%,5.0%,5.4%,5.0%,5.0%,5.0%,5.0%,5.0%,5.0%,5.1%

,,保证金率(只支付第一年）,,,C1,C1,0.0%,0.0%,0.0%,0.0%,0.0%,0.0%,0.2%,0.0%,0.0%,0.0%,0.0%,0.0%,0.0%,0.1%

,,平台使用年费率,,,C2,C2,0.0%,0.0%,0.0%,0.0%,0.0%,0.0%,0.2%,0.0%,0.0%,0.0%,0.0%,0.0%,0.0%,0.1%

,,平台佣金扣点率,,,C3,D3/A,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%,5.0%

,,推广费率,,,E1,E2+E3,6.0%,50.4%,9.3%,16.3%,19.9%,7.3%,8.7%,12.9%,10.6%,10.0%,10.1%,20.3%,19.2%,10.8%

,,淘内推广费率,,,E2,F2/A,0.0%,44.4%,3.3%,10.3%,13.9%,1.3%,2.7%,6.9%,4.6%,4.0%,4.1%,14.3%,13.2%,4.8%

,,淘外推广费率,,,E3,E3,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%

,,物流仓储费用率,,物流损耗费率,E4,E5+E6,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%

,,,,物流费率,E5,E5,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%,5.0%

,,,,损耗费率,E6,E6,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%,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%,4.0%

,,管理费用率,,,,,0.0%,222.2%,8.3%,6.9%,5.6%,0.4%,2.1%,4.3%,3.5%,1.8%,1.7%,5.8%,6.1%,2.7%

,,平台费用额,,,D,D1+D2+D3+D4,"138,000.0","2,250.0","60,000.0","72,500.0","90,000.0","1,150,000.0","1,512,750.0","290,000.0","325,000.0","650,000.0","675,000.0","200,000.0","190,000.0","3,842,750.0"

,,保证金(只支付第一年）,,,D1,C1*A,"50,000.0",0.0,0.0,0.0,0.0,0.0,"50,000.0",0.0,0.0,0.0,0.0,0.0,0.0,"50,000.0"

,,平台使用年费,,,D2,C2*A,"60,000.0",0.0,0.0,0.0,0.0,0.0,"60,000.0",0.0,0.0,0.0,0.0,0.0,0.0,"60,000.0"

,,平台佣金扣点,,,D3,D3,"28,000.0","2,250.0","60,000.0","72,500.0","90,000.0","1,150,000.0","1,402,750.0","290,000.0","325,000.0","650,000.0","675,000.0","200,000.0","190,000.0","3,732,750.0"

,,推广费,,,F1,F2+F3,"33,600.0","22,700.0","112,000.0","237,000.0","358,000.0","1,680,000.0","2,443,300.0","748,000.0","690,000.0","1,300,000.0","1,360,000.0","810,000.0","728,000.0","8,079,300.0"

,,淘内推广费,,,F2,F2,0.0,"20,000.0","40,000.0","150,000.0","250,000.0","300,000.0","760,000.0","400,000.0","300,000.0","520,000.0","550,000.0","570,000.0","500,000.0","3,600,000.0"

,,淘外推广费,,,F3,E3/A,"33,600.0","2,700.0","72,000.0","87,000.0","108,000.0","1,380,000.0","1,683,300.0","348,000.0","390,000.0","780,000.0","810,000.0","240,000.0","228,000.0","4,479,300.0"

,,物流仓储费用,,物流损耗费,F4,F5+F6,"33,600.0","2,700.0","72,000.0","87,000.0","108,000.0","1,380,000.0","1,683,300.0","348,000.0","390,000.0","780,000.0","810,000.0","240,000.0","228,000.0","4,479,300.0"

,,,,物流费,F5,E5*A,"28,000.0","2,250.0","60,000.0","72,500.0","90,000.0","1,150,000.0","1,402,750.0","290,000.0","325,000.0","650,000.0","675,000.0","200,000.0","190,000.0","3,732,750.0"

,,,,损耗费,F6,E6*A,"5,600.0",450.0,"12,000.0","14,500.0","18,000.0","230,000.0","280,550.0","58,000.0","65,000.0","130,000.0","135,000.0","40,000.0","38,000.0","746,550.0"

,,,,仓储费,,,"22,400.0","1,800.0","48,000.0","58,000.0","72,000.0","920,000.0","1,122,200.0","232,000.0","260,000.0","520,000.0","540,000.0","160,000.0","152,000.0","2,986,200.0"

,,管理费用,,,,,"100,000.0","100,000.0","100,000.0","100,000.0","100,000.0","100,000.0","600,000.0","250,000.0","230,000.0","230,000.0","230,000.0","230,000.0","230,000.0","2,000,000.0"

,,总费用率,,,,,0%,288%,33%,38%,40%,23%,26%,32%,29%,27%,27%,41%,40%,29%

,,费用总额,,,,,"327,600.0","129,450.0","392,000.0","554,500.0","728,000.0","5,230,000.0","7,361,550.0","1,868,000.0","1,895,000.0","3,480,000.0","3,615,000.0","1,640,000.0","1,528,000.0","21,387,550.0"

,利润,净毛利率（不含后台成本）,,,G,H/A,0.0%,-277.7%,2.3%,1.8%,-0.4%,22.3%,17.0%,17.8%,30.8%,43.2%,43.2%,9.0%,29.8%,27.8%

,,含税净毛利额,,,H,B1-D-F,"-271,600.0","-124,950.0","28,000.0","25,500.0","-8,000.0","5,120,000.0","4,768,950.0","1,032,000.0","2,005,000.0","5,620,000.0","5,835,000.0","360,000.0","1,132,000.0","20,752,950.0"

,,不含税净毛利额,,,I,H/1.17,"-232,136.8","-106,794.9","23,931.6","21,794.9","-6,837.6","4,376,068.4","4,076,025.6","882,051.3","1,713,675.2","4,803,418.8","4,987,