运营 2-店铺日常报表 年度项目经营预算分析表

2015年度,,,,2015年度,,,,,,,,,,,,

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

收入,含税销售额,,,0.0,"50,000.0","100,000.0","450,000.0","800,000.0","1,000,000.0","1,800,000.0","1,500,000.0","3,000,000.0","3,500,000.0","4,000,000.0","3,800,000.0","20,000,000.0"

,未税销售额,,,0.0,"42,735.0","85,470.1","384,615.4","683,760.7","854,700.9","1,538,461.5","1,282,051.3","2,564,102.6","2,991,453.0","3,418,803.4","3,247,863.2","17,094,017.1"

,含税成本,,,0.0,"37,500.0","65,000.0","270,000.0","480,000.0","550,000.0","900,000.0","600,000.0","900,000.0","1,050,000.0","2,000,000.0","1,140,000.0","7,992,500.0"

,未税成本,,,0.0,"32,051.3","55,555.6","230,769.2","410,256.4","470,085.5","769,230.8","512,820.5","769,230.8","897,435.9","1,709,401.7","974,359.0","6,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.0,"12,500.0","35,000.0","180,000.0","320,000.0","450,000.0","900,000.0","900,000.0","2,100,000.0","2,450,000.0","2,000,000.0","2,660,000.0","12,007,500.0"

,未税毛利额,,,0.0,"10,683.8","29,914.5","153,846.2","273,504.3","384,615.4","769,230.8","769,230.8","1,794,871.8","2,094,017.1","1,709,401.7","2,273,504.3","10,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.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.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.0","2,500.0","5,000.0","22,500.0","40,000.0","50,000.0","90,000.0","75,000.0","150,000.0","175,000.0","200,000.0","190,000.0","1,110,000.0"

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

,平台使用年费,,,"60,000.0",0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0.0,"60,000.0"

,平台佣金扣点,,,0.0,"2,500.0","5,000.0","22,500.0","40,000.0","50,000.0","90,000.0","75,000.0","150,000.0","175,000.0","200,000.0","190,000.0","1,000,000.0"

,推广费,,,0.0,"23,000.0","46,000.0","177,000.0","298,000.0","360,000.0","508,000.0","390,000.0","700,000.0","760,000.0","810,000.0","728,000.0","4,800,000.0"

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

,淘外推广费,,,0.0,"3,000.0","6,000.0","27,000.0","48,000.0","60,000.0","108,000.0","90,000.0","180,000.0","210,000.0","240,000.0","228,000.0","1,200,000.0"

,物流仓储费用,,物流损耗费,0.0,"3,000.0","6,000.0","27,000.0","48,000.0","60,000.0","108,000.0","90,000.0","180,000.0","210,000.0","240,000.0","228,000.0","1,200,000.0"

,,,物流费,0.0,"2,500.0","5,000.0","22,500.0","40,000.0","50,000.0","90,000.0","75,000.0","150,000.0","175,000.0","200,000.0","190,000.0","1,000,000.0"

,,,损耗费,0.0,500.0,"1,000.0","4,500.0","8,000.0","10,000.0","18,000.0","15,000.0","30,000.0","35,000.0","40,000.0","38,000.0","200,000.0"

,,,仓储费,0.0,"2,000.0","4,000.0","18,000.0","32,000.0","40,000.0","72,000.0","60,000.0","120,000.0","140,000.0","160,000.0","152,000.0","800,000.0"

,管理费用,,,"100,000.0","100,000.0","100,000.0","100,000.0","100,000.0","100,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%,261%,161%,77%,65%,61%,57%,56%,46%,43%,41%,40%,50%

,费用总额,,,"210,000.0","130,500.0","161,000.0","344,500.0","518,000.0","610,000.0","1,028,000.0","845,000.0","1,380,000.0","1,515,000.0","1,640,000.0","1,528,000.0","9,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.0","55,000.0","720,000.0","935,000.0","360,000.0","1,132,000.0","2,097,500.0"

,不含税净毛利额,,,"-179,487.2","-100,854.7","-107,692.3","-140,598.3","-169,230.8","-136,752.1","-109,401.7","47,008.5","615,384.6","799,145.3","307,692.3","967,521.4","1,792,735.0"

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

注：,,,,,,,,,,,,,,,,

1、从2