电商运营- 日常运营-173销售预算表

流量及销售数据,1月,2月,3月,1季度,4月,5月,6月,2季度,7月,8月,9月,3季度,10月,11月,12月,4季度,年度合计

UV,346470,633926,512361,"1,492,757",451940,247555,411698,"1,111,193",286565,660352,477011,"1,423,928",731578,1375562,1108145,"3,215,285","7,243,163"

订单转化率,0.51%,1.63%,1.44%,1.19%,2.01%,1.35%,1.59%,1.65%,0.99%,1.42%,0.87%,1.09%,1.52%,1.69%,1.51%,1.57%,1.38%

月订单数,1767,10333,7378,"19,478",9084,3342,6546,"18,972",2837,9377,4150,"16,364",11120,23247,16733,"51,100","105,914"

天订单数,59,344,246,649,303,111,218,632,95,313,138,545,371,775,558,1703,"105,914"

平均客单价,395,178,203,259,170,221,154,182,224,234,370,276,417,353,359,376,273

退款率,11%,15%,13%,13%,13%,10%,13%,12%,9%,16%,13%,13%,16%,25%,18%,20%,17%

退款金额,68355,234810,169227,"472,392",174658,66424,114014,"355,096",51995,294663,173768,"520,427",623217,1540099,885666,"3,048,983","4,396,898"

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

总收入,621408,1565402,1301745,"3,488,555",1343523,664241,877033,"2,884,797",577725,1841646,1336678,"3,756,049",3895109,6160396,4920369,"14,975,874","25,105,274"

总毛利额,217493,407005,364488,"988,986",403057,232484,306961,"942,503",202204,644576,467837,"1,314,617",1363288,1724911,1476111,"4,564,310","7,810,415"

平均毛利率,35%,26%,28%,30%,30%,35%,35%,33%,35%,35%,35%,35%,35%,28%,30%,31%,32%

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

费用,8%,6%,5%,6%,5%,5%,5%,5%,5%,6%,8%,6%,5%,6%,5%,5%,5.8%

市场推广营销,49713,93924,65087,"208,724",67176,33212,43852,"144,240",28886,110499,106934,"246,319",194755,369624,246018,"810,398","1,409,681"

品牌建设,6214,15654,13017,"34,886",13435,6642,8770,"28,848",5777,18416,13367,"37,560",38951,61604,49204,"149,759","251,053"

仓储物流配送,14136,82664,59024,"155,824",72672,26736,52368,"151,776",22696,75016,33200,"130,912",88960,185976,133864,"408,800","847,311"

人员开支,100000,130000,100000,"330,000",100000,100000,100000,"300,000",100000,100000,100000,"300,000",100000,130000,100000,"330,000","1,260,000"

场地办公,15000,20000,15000,"50,000",15000,15000,15000,"45,000",15000,15000,15000,"45,000",15000,20000,15000,"50,000","190,000"

水电网费,3000,3000,3000,"9,000",3000,3000,3000,"9,000",3000,3000,3000,"9,000",3000,3000,3000,"9,000","36,000"

合计,188063,345242,255129,"788,433",271283,184590,222990,"678,864",175359,321931,271501,"768,792",440666,770204,547086,"1,757,956","3,994,045"

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

净利,29430,61762,109360,"200,552",131773,47894,83972,"263,639",26844,322645,196336,"545,825",922622,954707,929025,"2,806,353","3,816,370"

投入产出比（总收入）,1:3.3,1:4.53,1:5.1,1:4.42,1:4.95,1:3.6,1:3.93,1:4.25,1:3.29,1:5.72,1:4.92,1:4.89,1:8.84,1:8,1:8.99,1:8.52,1:6.29

投入产出比（毛利）,1:1.16,1:1.18,1:1.43,1:1.25,1:1.49,1:1.26,1:1.38,1:1.39,1:1.15,1:2,1:1.72,1:1.71,1:3.09,1:2.24,1:2.7,1:2.6,1:1.96

投入产出比（净利）,1:0.16,1:0.18,1:0.43,1:0.25,1:0.49,1:0.26,1:0.38,1:0.39,1:0.15,1:1,1:0.72,1:0.71,1:2.09,1:1.24,1:1.7,1:1.6,1:0.96

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