1、XX旗艦店2016年支出費用表JanFeb1st2nd3rd4th1st2nd3rd4th天貓平臺固定費用技術服務年費1000000000000服務保證金600000000000商城扣點2053.12538.23023.33508.43993.55105.86218.17330.4固定費用合計162053.12538.23023.33508.43993.55105.86218.17330.4營運費用【硬性】模特拍攝費用70000000000模特費25000000000造型師5000000000攝影棚租可預計10000000000房租費用200

2、000000000押金50000000000房租150000000000辦公費用508801680168016802880168016801680電腦400000000000家具50000000000紙張耗材100100100100100100100100水電12000001200000貨架30000000000員工福利10801080108010801080108010801080不可預計500500500500500500500500營銷費用857.51102.51347.51592.51837.52327.52817.53307.5包裝盒514.5661.5808.5955.51102.

3、51396.51690.51984.5小禮物34344153963773593111271323軟件費用9600000000量子00000000生E經6000000000數據魔方3600000000老A工具箱00000000物流費用274435284312509658807448901610584快遞費274435284312509658807448901610584換貨率3%3%3%3%3%3%3%3%其他不可預計費用12001200120012001200120012001200硬運費費用合計83641.57510.58539.59568.511797.512655.514713.5167

4、71.5營運費用【軟性】直通車爆款35007000105001400017500245003150038500轉化率3%3%3%3%3%3%3%3%PPC1.51.51.51.51.51.51.51.5直通車常規1540015400154001540015400154001540015400轉化率2%2%2%2%2%2%2%2%PPC2.22.22.22.22.22.22.22.2鉆展52505250525052505250525052505250轉化率1%1%1%1%1%1%1%1%PPC1.51.51.51.51.51.51.51.5淘寶客00000000硬廣00000000軟運營費用合計

5、2415027650311503465038150451505215059150人員成本設計師數量11111111薪資80000008000000合計80000008000000設計助理數量11111111薪資35000003500000合計35000003500000采購及跟單數量11111111薪資50000005000000合計50000005000000倉庫管理數量11111111薪資40000004000000合計40000004000000運營及數據分析數量11111111薪資1000000010000000合計1000000010000000推廣專員數量11111111薪資600

6、00006000000合計60000006000000平面設計數量11111111薪資40000004000000合計40000004000000客服數量22222222薪資30000003000000合計60000006000000人員成本合計4650000046500000MarAprMayJun1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th1st2nd00000000000000000000000000008442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.711105.91

7、1733.112360.38442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.711105.911733.112360.3000070000000000000000250000000000000005000000000000000150000000000000001500000000000000010000000000000000150000000000000000000000000000001500000000000028801680168016802880168016801680288016801680

8、16802880168000000000000000000000000000001001001001001001001001001001001001001001001200000120000012000001200000000000000000108010801080108010801080108010801080108010801080108010805005005005005005005005005005005005005005003797.54287.54287.54287.54532.54532.54532.54532.53797.54042.54287.54532.54777.550

9、22.52278.52572.52572.52572.52719.52719.52719.52719.52278.52425.52572.52719.52866.53013.515191715171517151813181318131813151916171715181319112009000000000000000000000000000000000000000000000000000000000000000000000012152137201372013720145041450414504145041215212936137201450415288160721215213720137201

10、3720145041450414504145041215212936137201450415288160723%3%3%3%3%3%3%3%3%3%3%3%3%3%1200120012001200120012001200120012001200120012001200120020029.520887.520887.520887.545116.521916.521916.521916.520029.519858.520887.521916.524145.523974.54550052500525005250052500525005250052500420004550049000525005600

11、0595003%3%3%3%3%3%3%3%3%3%3%3%3%3%1.51.51.51.51.51.51.51.51.51.51.51.51.51.515400154001540015400231002310023100231002310023100231002310023100231002%2%2%2%2%2%2%2%2%2%2%2%2%2%2.22.22.22.22.22.22.22.22.22.22.22.22.22.2525052505250525052505250525052505250525052505250525052501%1%1%1%1%1%1%1%1%1%1%1%1%1%

12、1.51.51.51.51.51.51.51.51.51.51.51.51.51.5000000000000000000000000000066150731507315073150808508085080850808507035073850773508085084350878501111111111111180000008000000800000080000800000080000008000000800001111111111111135000003500000350000035000350000035000003500000350001111111111111150000005000000

13、500000050000500000050000005000000500001111111111111140000004000000400000040000400000040000004000000400001111111111111110000000100000001000000010000010000000100000001000000010000011111111111111600000060000006000000600006000000600000060000006000011111111111111400000040000004000000400004000000400000040

14、0000040000222222222222223000000300000030000003000060000006000000600000060000465000004650000046500000465000JulAugSep3rd4th1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th000000000000000000000000000012987.512360.313073.21244611818.811191.610564.49937.29623.610740.81185812975.216042.61911012987.512360.313073.21244

15、611818.811191.610564.49937.29623.610740.81185812975.216042.6191100070000000000000000250000000000000005000000000000000150000000000000001500000000000000010000000000000000150000000000000000000000000000001500000000000000168016802880168016801680288016804680168028801680168016800000000000000000000000000000

16、100100100100100100100100100100100100100100Jun0012000001200000120000000000000300000000108010801080108010801080108010801080108010801080108010805005005005005005005005005005005005005005005267.55022.54532.54287.54042.53797.53552.53307.52508.82822.431363449.64076.847043160.53013.52719.52572.52425.52278.52

17、131.51984.51724.81940.421562371.62802.832342107200918131715161715191421132378488298010781274147000000000000000000000000000000000000000000000000000000000000000000000001685616072145041372012936121521136810584627270567840862410192117601685616072145041372012936121521136810584627270567840862410192117603%

18、3%3%3%3%3%3%3%3%3%3%3%3%3%1200120012001200120012001200120012001200120012001200120025003.523974.545116.520887.519858.518829.519000.516771.514660.812758.41505614953.617148.819344630005950056000525004900045500420003850035007000105001400021000280003%3%3%3%3%3%3%3%3%3%3%3%3%3%1.51.51.51.51.51.51.51.51.51

19、.51.51.51.51.523100231001540015400154001540015400154003850038500385003850038500385002%2%2%2%2%2%2%2%2%2%2%2%2%2%2.22.22.22.22.22.22.22.22.22.22.22.22.22.2525052505250525052505250525052502100021000210002100021000210001%1%1%1%1%1%1%1%1%1%1%1%1%1%1.51.51.51.51.51.51.51.51.51.51.51.51.51.500000000000000

20、000000000000009135087850766507315069650661506265059150630006650070000735008050087500111111111111110080000008000000800000000800000080000008000000111111111111110035000003500000350000000350000035000003500000111111111111110050000005000000500000000500000050000005000000111111111111110040000004000000400000

21、00040000004000000400000011111111111111001000000010000000100000000010000000100000001000000011111111111111006000000600000060000000060000006000000600000011111111111111004000000400000040000000040000004000000400000022222222222222003000000300000030000000060000006000000600000000465000004650000046500000OctN

22、ovDec1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th合計0000000000000010000000000000000-60000029272.638190.649058.857976.85909460211.261328.462445.661328.460211.251293.242375.2984870.6029272.638190.649058.857976.85909460211.261328.462445.661328.460211.251293.2-1762510848710007000000000000002800025000000000000010

23、000500000000000002000150000000000000600015000000000000060001000000000000004000015000000000000006500000000000000050001500000000000000600000288016801680168028801680168016802880168016801680146040000000000000400000000000000005000100100100100100100100100100100100100480012000001200000120000014400000000000

24、0006000108010801080108010801080108010801080108010801080518405005005005005005005005005005005005002400005644.87212.89094.410662.41097611289.611603.211916.811603.211289.69721.68153.6250115.63880.84958.86252.47330.475467761.67977.28192.87977.27761.66683.65605.6162307.617642254284233323430352836263724362

25、63528303825488780800000000000009600000000000000000000000000600000000000000360000000000000001411218032227362665627440282242900829792290082822424304203847024641411218032227362665627440282242900829792290082822424304203847024643%3%3%3%3%3%3%3%3%3%3%3%1.440120012001200120012001200120012001200120012001200

26、5760045836.828124.834710.440198.44249642393.643491.244588.844691.242393.636905.631417.612501800038500560007350091000945009800010150010500010150098000805006300023555003%3%3%3%3%3%3%3%3%3%3%3%1.441.51.51.51.51.51.51.51.51.51.51.51.57203850038500462004620046200462004620046200462004620046200462001324400

27、2%2%2%2%2%2%2%2%2%2%2%2%0.962.22.22.22.22.22.22.22.22.22.22.22.2105.602100021000210002100021000210002100021000210002100021000210005355001%1%1%1%1%1%1%1%1%1%1%1%0.481.51.51.51.51.51.51.51.51.51.51.51.57200000000000000000000000000000980001155001407001582001617001652001687001722001687001652001477001302

28、004215400000111111111111488000000800000080000009600080000008000000800000096000011111111111148350000035000003500000420003500000350000035000004200001111111111114850000005000000500000060000500000050000005000000600000111111111111484000000400000040000004800040000004000000400000048000011111111111148100000

29、0010000000100000001200001000000010000000100000001200000111111111111486000000600000060000007200060000006000000600000072000011111111111148400000040000004000000480004000000400000040000004800002222222222229630000003000000300000036000600000060000006000000720000465000004650000046500000558000Jan1st2nd3rd主營

30、業務收入直通車銷量數量140140140平均單價128128128小計179201792017920鉆展數量353535平均單價128128128小計448044804480自然流量銷量數量707070平均單價128128128小計896089608960主營業務收入合計313603136031360其他業務收入（爆款）直通車銷量（春）數量70140210平均單價999999小計69301386020790直通車銷量（夏）數量000平均單價128128128小計000直通車銷量（秋）數量000平均單價228228228小計000直通車銷量（冬）數量000平均單價398398398小計000自然

31、流量銷量（春）數量285684平均單價999999小計277255448316自然流量銷量（夏）數量000平均單價128128128小計000自然流量銷量（秋）數量000平均單價228228228小計000自然流量銷量（冬）數量000平均單價398398398小計000活動銷量數量000平均單價000小計000淘寶客銷量數量000平均單價000小計000其他業務收入合計97021940429106總收入合計410625076460466直接成本投入300000主營業務收入直接成本直通車成本率39%39%39%直接成本6988.86988.86988.8鉆展成本率39%39%39%直接成本174

32、7.21747.21747.2自然流量成本率39%39%39%直接成本3494.43494.43494.4爆款直接成本直通車（春）成本率50%50%50%直接成本3465693010395直通車（夏）成本率47%47%47%直接成本000直通車（秋）成本率61%61%61%直接成本000直通車（冬）成本率40%40%40%直接成本000自然流量（春）成本率50%50%50%直接成本138627724158自然流量（夏）成本率47%47%47%直接成本000自然流量（秋）成本率61%61%61%直接成本000自然流量（冬）成本率40%40%40%直接成本000活動銷量成本率000直接成本000淘

33、寶客成本率000直接成本000直接成本合計17081.421932.426783.4庫存金額282918.60260986.20234202.80XX旗艦店收入及直接成本報表FebMar4th1st2nd3rd4th1st2nd140140140140140140140128128128128128128128179201792017920179201792017920179203535353535353512812812812812812812844804480448044804480448044807070707070707012812812812812812812889608960896

34、089608960896089603136031360313603136031360313603136028035042049056063070099999999999999277203465041580485105544062370693000070140210280350128128128128128128128008960179202688035840448000000000228228228228228228228000000000000003983983983983983983980000000112140168196224252280Jan999999999999991108813

35、8601663219404221762494827720002856841121401281281281281281281280035847168107521433617920000000022822822822822822822800000000000000398398398398398398398000000000000000000000000000000000000000000000000038808485107075693002115248137494159740701687987010211612436214660816885419110030000039%39%39%39%39%3

36、9%39%6988.86988.86988.86988.86988.86988.86988.839%39%39%39%39%39%39%1747.21747.21747.21747.21747.21747.21747.239%39%39%39%39%39%39%3494.43494.43494.43494.43494.43494.43494.450%50%50%50%50%50%50%1386017325207902425527720311853465047%47%47%47%47%47%47%004211.28422.412633.616844.82105661%61%61%61%61%61

37、%61%000000040%40%40%40%40%40%40%000000050%50%50%50%50%50%50%554469308316970211088124741386047%47%47%47%47%47%47%001684.483368.965053.446737.928422.461%61%61%61%61%61%61%000000040%40%40%40%40%40%40%0000000000000000000000000000000000031634.436485.447232.0857978.7668725.4479472.1290218.8202568.40166083

38、.00118850.9260872.16292146.72212674.60122455.80AprMay3rd4th1st2nd3rd4th1st1401402102102102102101281289999999999179201792020790207902079020790207903535353535353512812899999999994480448034653465346534653465707098989898981281289999999999896089609702970297029702970231360313603395733957339573395733957630

39、560490420350280099999999999999623705544048510415803465027720042049056063070077084012812812812812812812853760627207168080640896009856010752000000002282282282282282282280000000000000039839839839839839839800000002522241961681401120Mar999999999999992494822176194041663213860110880168196224252280308336128

40、12812812812812812821504250882867232256358403942443008000000022822822822822822822800000000000000398398398398398398398000000000000000000000000000000000000000000000000016258216542416826617110817395017679215052819394219678420222320506520790721074918448530000030000030000010000039%39%20%20%20%20%20%6988.8

41、6988.84158415841584158415839%39%20%20%20%20%20%1747.21747.269369369369369339%39%20%20%20%20%20%3494.43494.41940.41940.41940.41940.41940.450%50%50%50%50%50%50%311852772024255207901732513860047%47%47%47%47%47%47%25267.229478.433689.637900.84211246323.250534.461%61%61%61%61%61%61%000000040%40%40%40%40%

42、40%40%000000050%50%50%50%50%50%50%12474110889702831669305544047%47%47%47%47%47%47%10106.8811791.3613475.8415160.3216844.818529.2820213.7661%61%61%61%61%61%61%000000040%40%40%40%40%40%40%0000000000000000000000000000000000091263.4892308.1687913.8488958.5290003.291047.8877539.5631192.32238884.16450970.

43、32662011.80672008.60580960.72503421.16Jun2nd3rd4th1st2nd3rd2102102102102102109999999999992079020790207902079020790207903535353535359999999999993465346534653465346534659898989898989999999999999702970297029702970297023395733957339573395733957339570000009999999999990000009109801050112011901260128128128

44、128128128116480125440134400143360152320161280000000228228228228228228000000000000398398398398398398000000000000May999999999999000000364392420448476504128128128128128128465925017653760573446092864512000000228228228228228228000000000000398398398398398398000000000000000000000000000000000000000000163072

45、175616188160200704213248225792197029209573222117234661247205259749200000020%20%20%20%20%20%41584158415841584158415820%20%20%20%20%20%69369369369369369320%20%20%20%20%20%1940.41940.41940.41940.41940.41940.450%50%50%50%50%50%00000047%47%47%47%47%47%54745.658956.86316867379.271590.475801.661%61%61%61%6

46、1%61%00000040%40%40%40%40%40%00000050%50%50%50%50%50%00000047%47%47%47%47%47%21898.2423582.7225267.226951.6828636.1630320.6461%61%61%61%61%61%00000040%40%40%40%40%40%00000000000000000000000000000083435.2489330.9295226.6101122.28107017.96112913.64419985.92330655.00235428.40134306.1227288.161914374.52

47、JulAug4th1st2nd3rd4th1st210140140140140140992482482482482482079034720347203472034720347203535353535359924824824824824834658680868086808680868098707070707099248248248248248970217360173601736017360173603395760760607606076060760607600000009999999999990000001190112010509809108401281281281281281281523201

48、43360134400125440116480107520000000228228228228228228000000000000398398398398398398000000000000Jun9999999999990000004764484203923643361281281281281281286092857344537605017646592430080000002282282282282282280000000000003983983983983983980000000000000000000000000000000000000000002132482007041881601756

49、1616307215052824720526146424892023637622383221128820%46%46%46%46%46%415815971.215971.215971.215971.215971.220%46%46%46%46%46%6933992.83992.83992.83992.83992.820%46%46%46%46%46%1940.47985.67985.67985.67985.67985.650%50%50%50%50%50%00000047%47%47%47%47%47%71590.467379.26316858956.854745.650534.461%61%

50、61%61%61%61%00000040%40%40%40%40%40%00000050%50%50%50%50%50%00000047%47%47%47%47%47%28636.1626951.6825267.223582.7221898.2420213.7661%61%61%61%61%61%00000040%40%40%40%40%40%000000000000000000000000000000107017.96122280.48116384.8110489.12104593.4498697.761807356.561685076.081568691.281458202.1613536

51、08.721254910.96Sep2nd3rd4th1st2nd3rd140350350350350350248248248248248248347208680086800868008680086800351401401401401402482482482482482488680347203472034720347203472070196196196196196248248248248248248173604860848608486084860848608607601701281701281701281701281701280000009999999999990000007700000012

52、812812812812812898560000000701402102803502282282282282282280159603192047880638407980000000703983983983983983980000027860000000Aug999999999999000000308000001281281281281281283942400000028568411214022822822822822822806384127681915225536319200000028398398398398398398000001114400000000000000000000000000

53、00000000001379842234444688670328937615072419874419247221481623716025950432085246%46%46%46%46%46%15971.2399283992839928399283992846%46%46%46%46%46%3992.815971.215971.215971.215971.215971.246%46%46%46%46%46%7985.622359.6822359.6822359.6822359.6822359.6850%50%50%50%50%50%00000047%47%47%47%47%47%46323.2

54、0000061%61%61%61%61%61%09735.619471.229206.838942.44867840%40%40%40%40%40%000001114450%50%50%50%50%50%00000047%47%47%47%47%47%18529.280000061%61%61%61%61%61%03894.247788.4811682.7215576.9619471.240%40%40%40%40%40%000004457.600000000000000000000000092802.0891888.72105518.56119148.4132778.24162009.681

55、162108.881070220.16964701.60845553.20712774.96550765.28OctNov4th1st2nd3rd4th1st2nd35035035042042042042024839839839839839839886800139300139300167160167160167160167160140140140140140140140248398398398398398398347205572055720557205572055720557201961961962242242242242483983983983983983984860878008780088

56、915289152891528915217012827302827302831203231203231203231203200000009999999999999900000000000000128128128128128128128000000042049056063070077084022822822822822822822895760111720127680143640159600175560191520140280560840112011201120398398398398398398398557201114402228803343204457604457604457600000000

57、Sep999999999999990000000000000012812812812812812812800000001681962242522803083362282282282282282282283830444688510725745663840702247660856112224336448448448398398398398398398398222884457689152133728178304178304178304000000000000000000000000000000000000000000212072312424490784669144847504869848892192

58、382200585452763812981176115953611818801204224300000046%40%40%40%40%40%40%3992855720557206686466864668646686446%40%40%40%40%40%40%15971.222288222882228822288222882228846%40%40%40%40%40%40%22359.6831203.231203.235660.835660.835660.835660.850%50%50%50%50%50%50%000000047%47%47%47%47%47%47%000000061%61%6

59、1%61%61%61%61%58413.668149.277884.887620.497356107091.6116827.240%40%40%40%40%40%40%22288445768915213372817830417830417830450%50%50%50%50%50%50%000000047%47%47%47%47%47%47%000000061%61%61%61%61%61%61%23365.4427259.6831153.9235048.1638942.442836.6446730.8840%40%40%40%40%40%40%8915.217830.435660.85349

60、1.271321.671321.671321.60000000000000000000000000000191241.12267026.48343062.72434700.56510736.8524366.64537996.48359524.1692497.682749434.962314734.401803997.601279630.96741634.48Dec3rd4th1st2nd3rd4th合計0000420420420420420420120403983983983983983981047616716016716016716016716016716016716031438400014