【成本】盈虧預測模型_第1頁
【成本】盈虧預測模型_第2頁
【成本】盈虧預測模型_第3頁
【成本】盈虧預測模型_第4頁
【成本】盈虧預測模型_第5頁
已閱讀5頁,還剩43頁未讀 繼續免費閱讀

下載本文檔

版權說明:本文檔由用戶提供并上傳,收益歸屬內容提供方,若內容存在侵權,請進行舉報或認領

文檔簡介

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

溫馨提示

  • 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯系上傳者。文件的所有權益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網頁內容里面會有圖紙預覽,若沒有圖紙預覽就沒有圖紙。
  • 4. 未經權益所有人同意不得將文件中的內容挪作商業或盈利用途。
  • 5. 人人文庫網僅提供信息存儲空間,僅對用戶上傳內容的表現方式做保護處理,對用戶上傳分享的文檔內容本身不做任何修改或編輯,并不能對任何下載內容負責。
  • 6. 下載文件中如有侵權或不適當內容,請與我們聯系,我們立即糾正。
  • 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論