《电商运营-【成本】盈亏预测模型.xlsx》由会员分享，可在线阅读，更多相关《电商运营-【成本】盈亏预测模型.xlsx（48页珍藏版）》请在三一文库上搜索。
1、XX旗舰店2016年支出费用表 JanFeb 1st2nd3rd4th1st2nd3rd4th 天猫平台固定费用 技术服务年费1000000000000 服务保证金600000000000 商城扣点2053.12538.23023.33508.43993.55105.86218.17330.4 固定费用合计162053.12538.23023.33508.43993.55105.86218.17330.4 营运费用【硬性】 模特拍摄费用70000000000 模特费25000000000 造型师5000000000 摄影师15000000000 影棚租赁15000000000 不可预计1000
2、0000000 房租费用200000000000 押金50000000000 房租150000000000 办公费用508801680168016802880168016801680 电脑400000000000 家具50000000000 纸张耗材100100100100100100100100 水电12000001200000 货架30000000000 员工福利10801080108010801080108010801080 不可预计500500500500500500500500 营销费用857.51102.51347.51592.51837.52327.52817.53307.5 包
3、装盒514.5661.5808.5955.51102.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
4、.58539.59568.511797.512655.514713.516771.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
5、.51.51.51.51.51.51.5 淘宝客00000000 硬广00000000 软运营费用合计2415027650311503465038150451505215059150 人员成本 设计师数量11111111 薪资80000008000000 合计80000008000000 设计助理数量11111111 薪资35000003500000 合计35000003500000 采购及跟单数量11111111 薪资50000005000000 合计50000005000000 仓库管理数量11111111 薪资40000004000000 合计40000004000000 运营及数据分析
6、数量11111111 薪资1000000010000000 合计1000000010000000 推广专员数量11111111 薪资60000006000000 合计60000006000000 平面设计数量11111111 薪资40000004000000 合计40000004000000 客服数量22222222 薪资30000003000000 合计60000006000000 人员成本合计4650000046500000 MarAprMayJun 1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th1st2nd 00000000000000 000000000000
7、00 8442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.711105.911733.112360.3 8442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.711105.911733.112360.3 00007000000000000 00002500000000000 0000500000000000 00001500000000000 00001500000000000 00001000000000000 0000
8、15000000000000 00000000000000 000015000000000000 28801680168016802880168016801680288016801680168028801680 00000000000000 00000000000000 100100100100100100100100100100100100100100 12000001200000120000012000 00000000000000 10801080108010801080108010801080108010801080108010801080 5005005005005005005005
9、00500500500500500500 3797.54287.54287.54287.54532.54532.54532.54532.53797.54042.54287.54532.54777.55022.5 2278.52572.52572.52572.52719.52719.52719.52719.52278.52425.52572.52719.52866.53013.5 15191715171517151813181318131813151916171715181319112009 00000000000000 00000000000000 00000000000000 0000000
10、0000000 00000000000000 1215213720137201372014504145041450414504121521293613720145041528816072 1215213720137201372014504145041450414504121521293613720145041528816072 3%3%3%3%3%3%3%3%3%3%3%3%3%3% 12001200120012001200120012001200120012001200120012001200 20029.520887.520887.520887.545116.521916.521916.5
11、21916.520029.519858.520887.521916.524145.523974.5 4550052500525005250052500525005250052500420004550049000525005600059500 3%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.5 1540015400154001540023100231002310023100231002310023100231002310023100 2%2%2%2%2%2%2%2%2%2%2%2%2%2% 2.22.22
12、.22.22.22.22.22.22.22.22.22.22.22.2 52505250525052505250525052505250525052505250525052505250 1%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.5 00000000000000 00000000000000 6615073150731507315080850808508085080850703507385077350808508435087850 11111111111111 8000000800000080000
13、0080000 80000008000000800000080000 11111111111111 35000003500000350000035000 35000003500000350000035000 11111111111111 50000005000000500000050000 50000005000000500000050000 11111111111111 40000004000000400000040000 40000004000000400000040000 11111111111111 100000001000000010000000100000 100000001000
14、000010000000100000 11111111111111 60000006000000600000060000 60000006000000600000060000 11111111111111 40000004000000400000040000 40000004000000400000040000 22222222222222 30000003000000300000030000 60000006000000600000060000 465000004650000046500000465000 JulAugSep 3rd4th1st2nd3rd4th1st2nd3rd4th1st
15、2nd3rd4th 00000000000000 00000000000000 12987.512360.313073.21244611818.811191.610564.49937.29623.610740.81185812975.216042.619110 12987.512360.313073.21244611818.811191.610564.49937.29623.610740.81185812975.216042.619110 00700000000000000 00250000000000000 0050000000000000 00150000000000000 0015000
16、0000000000 00100000000000000 001500000000000000 00000000000000 001500000000000000 16801680288016801680168028801680468016802880168016801680 00000000000000 00000000000000 100100100100100100100100100100100100100100 00120000012000001200000 00000000300000000 Jun 108010801080108010801080108010801080108010
17、80108010801080 500500500500500500500500500500500500500500 5267.55022.54532.54287.54042.53797.53552.53307.52508.82822.431363449.64076.84704 3160.53013.52719.52572.52425.52278.52131.51984.51724.81940.421562371.62802.83234 21072009181317151617151914211323784882980107812741470 00000000000000 00000000000
18、000 00000000000000 00000000000000 00000000000000 168561607214504137201293612152113681058462727056784086241019211760 168561607214504137201293612152113681058462727056784086241019211760 3%3%3%3%3%3%3%3%3%3%3%3%3%3% 12001200120012001200120012001200120012001200120012001200 25003.523974.545116.520887.5198
19、58.518829.519000.516771.514660.812758.41505614953.617148.819344 63000595005600052500490004550042000385003500700010500140002100028000 3%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.5 2310023100154001540015400154001540015400385003850038500385003850038500 2%2%2%2%2%2%2%2%2%2%2%2%
20、2%2% 2.22.22.22.22.22.22.22.22.22.22.22.22.22.2 52505250525052505250525052505250210002100021000210002100021000 1%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.5 00000000000000 00000000000000 9135087850766507315069650661506265059150630006650070000735008050087500 11111111111111 0
21、0800000080000008000000 00800000080000008000000 11111111111111 00350000035000003500000 00350000035000003500000 11111111111111 00500000050000005000000 00500000050000005000000 11111111111111 00400000040000004000000 00400000040000004000000 11111111111111 00100000001000000010000000 0010000000100000001000
22、0000 11111111111111 00600000060000006000000 00600000060000006000000 11111111111111 00400000040000004000000 00400000040000004000000 22222222222222 00300000030000003000000 00600000060000006000000 00465000004650000046500000 OctNovDec 1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th合计 0 0 000000000000100000 0000000
23、0000-600000 29272.638190.649058.857976.85909460211.261328.462445.661328.460211.251293.242375.2984870.6 0 29272.638190.649058.857976.85909460211.261328.462445.661328.460211.251293.2-176251084871 0 0 0 70000000000000028000 25000000000000010000 500000000000002000 1500000000000006000 1500000000000006000
24、 1000000000000004000 0 150000000000000065000 0000000000005000 150000000000000060000 0 288016801680168028801680168016802880168016801680146040 00000000000040000 0000000000005000 1001001001001001001001001001001001004800 12000001200000120000014400 0000000000006000 108010801080108010801080108010801080108
25、01080108051840 50050050050050050050050050050050050024000 0 5644.87212.89094.410662.41097611289.611603.211916.811603.211289.69721.68153.6250115.6 3880.84958.86252.47330.475467761.67977.28192.87977.27761.66683.65605.6162307.6 17642254284233323430352836263724362635283038254887808 0 000000000000960 0000
26、000000000 000000000000600 000000000000360 0000000000000 0 141121803222736266562744028224290082979229008282242430420384702464 141121803222736266562744028224290082979229008282242430420384702464 3%3%3%3%3%3%3%3%3%3%3%3%1.44 0 12001200120012001200120012001200120012001200120057600 45836.828124.834710.440
27、198.44249642393.643491.244588.844691.242393.636905.631417.61250180 0 0 3850056000735009100094500980001015001050001015009800080500630002355500 3%3%3%3%3%3%3%3%3%3%3%3%1.44 1.51.51.51.51.51.51.51.51.51.51.51.572 0 3850038500462004620046200462004620046200462004620046200462001324400 2%2%2%2%2%2%2%2%2%2%
28、2%2%0.96 2.22.22.22.22.22.22.22.22.22.22.22.2105.6 0 210002100021000210002100021000210002100021000210002100021000535500 1%1%1%1%1%1%1%1%1%1%1%1%0.48 1.51.51.51.51.51.51.51.51.51.51.51.572 0 0000000000000 0 0000000000000 0 980001155001407001582001617001652001687001722001687001652001477001302004215400
29、 0 0 0 11111111111148 80000008000000800000096000 80000008000000800000096000 0 11111111111148 35000003500000350000042000 35000003500000350000042000 0 11111111111148 50000005000000500000060000 50000005000000500000060000 0 11111111111148 40000004000000400000048000 40000004000000400000048000 0 111111111
30、11148 100000001000000010000000120000 100000001000000010000000120000 0 11111111111148 60000006000000600000072000 60000006000000600000072000 0 11111111111148 40000004000000400000048000 40000004000000400000048000 0 22222222222296 30000003000000300000036000 60000006000000600000072000 0 46500000465000004
31、6500000558000 阿狼的思维 Jan 1st2nd3rd 主营业务收入 直通车销量 数量140140140 平均单价128128128 小计179201792017920 钻展 数量353535 平均单价128128128 小计448044804480 自然流量销量 数量707070 平均单价128128128 小计896089608960 主营业务收入合计313603136031360 其他业务收入（爆款） 直通车销量（春）数量70140210 平均单价999999 小计69301386020790 直通车销量（夏）数量000 平均单价128128128 小计000 直通车销量（秋
32、）数量000 平均单价228228228 小计000 直通车销量（冬）数量000 平均单价398398398 小计000 自然流量销量（春）数量285684 平均单价999999 小计277255448316 自然流量销量（夏）数量000 平均单价128128128 小计000 自然流量销量（秋）数量000 平均单价228228228 小计000 自然流量销量（冬）数量000 平均单价398398398 小计000 活动销量数量000 平均单价000 小计000 淘宝客销量数量000 平均单价000 小计000 其他业务收入合计97021940429106 总收入合计4106250764604
33、66 直接成本 投入300000 主营业务收入直接成本 直通车成本率39%39%39% 直接成本6988.86988.86988.8 钻展成本率39%39%39% 直接成本1747.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% 直接成本138627
34、724158 自然流量（夏）成本率47%47%47% 直接成本000 自然流量（秋）成本率61%61%61% 直接成本000 自然流量（冬）成本率40%40%40% 直接成本000 活动销量成本率000 直接成本000 淘宝客成本率000 直接成本000 直接成本合计17081.421932.426783.4 库存金额282918.60260986.20234202.80 XX旗舰店收入及直接成本报表 FebMar 4th1st2nd3rd4th1st2nd 140140140140140140140 128128128128128128128 179201792017920179201792
35、01792017920 35353535353535 128128128128128128128 4480448044804480448044804480 70707070707070 128128128128128128128 8960896089608960896089608960 31360313603136031360313603136031360 280350420490560630700 99999999999999 27720346504158048510554406237069300 0070140210280350 128128128128128128128 00896017
36、920268803584044800 0000000 228228228228228228228 0000000 0000000 398398398398398398398 0000000 112140168196224252280 99999999999999 11088138601663219404221762494827720 Jan 00285684112140 128128128128128128128 0035847168107521433617920 0000000 228228228228228228228 0000000 0000000 3983983983983983983
37、98 0000000 0000000 0000000 0000000 0000000 0000000 0000000 38808485107075693002115248137494159740 7016879870102116124362146608168854191100 300000 39%39%39%39%39%39%39% 6988.86988.86988.86988.86988.86988.86988.8 39%39%39%39%39%39%39% 1747.21747.21747.21747.21747.21747.21747.2 39%39%39%39%39%39%39% 34
38、94.43494.43494.43494.43494.43494.43494.4 50%50%50%50%50%50%50% 13860173252079024255277203118534650 47%47%47%47%47%47%47% 004211.28422.412633.616844.821056 61%61%61%61%61%61%61% 0000000 40%40%40%40%40%40%40% 0000000 50%50%50%50%50%50%50% 5544693083169702110881247413860 47%47%47%47%47%47%47% 001684.48
39、3368.965053.446737.928422.4 61%61%61%61%61%61%61% 0000000 40%40%40%40%40%40%40% 0000000 0000000 0000000 0000000 0000000 31634.436485.447232.0857978.7668725.4479472.1290218.8 202568.40166083.00118850.9260872.16292146.72212674.60122455.80 AprMay 3rd4th1st2nd3rd4th1st 140140210210210210210 128128999999
40、9999 17920179202079020790207902079020790 35353535353535 1281289999999999 4480448034653465346534653465 70709898989898 1281289999999999 8960896097029702970297029702 31360313603395733957339573395733957 6305604904203502800 99999999999999 6237055440485104158034650277200 420490560630700770840 128128128128
41、128128128 537606272071680806408960098560107520 0000000 228228228228228228228 0000000 0000000 398398398398398398398 0000000 2522241961681401120 99999999999999 2494822176194041663213860110880 Mar 168196224252280308336 128128128128128128128 21504250882867232256358403942443008 0000000 228228228228228228
42、228 0000000 0000000 398398398398398398398 0000000 0000000 0000000 0000000 0000000 0000000 0000000 162582165424168266171108173950176792150528 193942196784202223205065207907210749184485 300000300000300000100000 39%39%20%20%20%20%20% 6988.86988.841584158415841584158 39%39%20%20%20%20%20% 1747.21747.269
43、3693693693693 39%39%20%20%20%20%20% 3494.43494.41940.41940.41940.41940.41940.4 50%50%50%50%50%50%50% 3118527720242552079017325138600 47%47%47%47%47%47%47% 25267.229478.433689.637900.84211246323.250534.4 61%61%61%61%61%61%61% 0000000 40%40%40%40%40%40%40% 0000000 50%50%50%50%50%50%50% 124741108897028
44、316693055440 47%47%47%47%47%47%47% 10106.8811791.3613475.8415160.3216844.818529.2820213.76 61%61%61%61%61%61%61% 0000000 40%40%40%40%40%40%40% 0000000 0000000 0000000 0000000 0000000 91263.4892308.1687913.8488958.5290003.291047.8877539.56 31192.32238884.16450970.32662011.80672008.60580960.72503421.1
45、6 Jun 2nd3rd4th1st2nd3rd 210210210210210210 999999999999 207902079020790207902079020790 353535353535 999999999999 346534653465346534653465 989898989898 999999999999 970297029702970297029702 339573395733957339573395733957 000000 999999999999 000000 9109801050112011901260 128128128128128128 1164801254
46、40134400143360152320161280 000000 228228228228228228 000000 000000 398398398398398398 000000 000000 999999999999 000000 May 364392420448476504 128128128128128128 465925017653760573446092864512 000000 228228228228228228 000000 000000 398398398398398398 000000 000000 000000 000000 000000 000000 000000
47、 163072175616188160200704213248225792 197029209573222117234661247205259749 2000000 20%20%20%20%20%20% 415841584158415841584158 20%20%20%20%20%20% 693693693693693693 20%20%20%20%20%20% 1940.41940.41940.41940.41940.41940.4 50%50%50%50%50%50% 000000 47%47%47%47%47%47% 54745.658956.86316867379.271590.47
48、5801.6 61%61%61%61%61%61% 000000 40%40%40%40%40%40% 000000 50%50%50%50%50%50% 000000 47%47%47%47%47%47% 21898.2423582.7225267.226951.6828636.1630320.64 61%61%61%61%61%61% 000000 40%40%40%40%40%40% 000000 000000 000000 000000 000000 83435.2489330.9295226.6101122.28107017.96112913.64 419985.92330655.0
49、0235428.40134306.1227288.161914374.52 JulAug 4th1st2nd3rd4th1st 210140140140140140 99248248248248248 207903472034720347203472034720 353535353535 99248248248248248 346586808680868086808680 987070707070 99248248248248248 97021736017360173601736017360 339576076060760607606076060760 000000 999999999999 000000 119011201050980910840 128128128128128128 152320143360134400125440116480107520 000000 228228228228228228 000000 000000 398398398398398398 000000 000000 999999999999 000000 Jun 476448420392364336 128128128128128128 609285734453760501764659243008 000000 22822822822