【成本】盈亏预测模型.xlsx
《【成本】盈亏预测模型.xlsx》由会员分享,可在线阅读,更多相关《【成本】盈亏预测模型.xlsx(48页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、XX旗舰店2016年支出费用表JanFeb1st2nd3rd4th1st2nd3rd4th天猫平台固定费用技术服务年费1000000000000服务保证金600000000000商城扣点2053.12538.23023.33508.43993.55105.86218.17330.4固定费用合计1620532538.23023.33508.43993.55105.86218.17330.4营运费用【硬性】模特拍摄费用70000000000模特费25000000000造型师5000000000摄影师15000000000影棚租赁15000000000不可预计10000000000房租费用20000
2、0000000押金50000000000房租150000000000办公费用508801680168016802880168016801680电脑400000000000家具50000000000纸张耗材100100100100100100100100水电12000001200000货架30000000000员工福利10801080108010801080108010801080不可预计500500500500500500500500营销费用857.51102.51347.51592.51837.52327.52817.53307.5包装盒514.5661.5808.5955.51102.51
3、396.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.516771
4、.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软运营费用合计24
5、15027650311503465038150451505215059150人员成本设计师数量11111111薪资80000008000000合计80000008000000设计助理数量11111111薪资35000003500000合计35000003500000采购及跟单数量11111111薪资50000005000000合计50000005000000仓库管理数量11111111薪资40000004000000合计40000004000000运营及数据分析数量11111111薪资1000000010000000合计1000000010000000推广专员数量11111111薪资60000
6、006000000合计60000006000000平面设计数量11111111薪资40000004000000合计40000004000000客服数量22222222薪资30000003000000合计60000006000000人员成本合计4650000046500000MarAprMayJun1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th1st2nd00000000000000000000000000008442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.711105.9117
7、33.112360.38442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.711105.911733.112360.300007000000000000000025000000000000000500000000000000015000000000000000150000000000000001000000000000000015000000000000000000000000000000150000000000002880168016801680288016801680168028801680168016
8、802880168000000000000000000000000000001001001001001001001001001001001001001001001200000120000012000001200000000000000000108010801080108010801080108010801080108010801080108010805005005005005005005005005005005005005005003797.54287.54287.54287.54532.54532.54532.54532.53797.54042.54287.54532.54777.55022
9、.52278.52572.52572.52572.52719.52719.52719.52719.52278.52425.52572.52719.52866.53013.51519171517151715181318131813181315191617171518131911200900000000000000000000000000000000000000000000000000000000000000000000001215213720137201372014504145041450414504121521293613720145041528816072121521372013720137
10、20145041450414504145041215212936137201450415288160723%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.5455005250052500525005250052500525005250042000455004900052500560005
11、95003%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%1.
12、51.51.51.51.51.51.51.51.51.51.51.51.51.500000000000000000000000000006615073150731507315080850808508085080850703507385077350808508435087850111111111111118000000800000080000008000080000008000000800000080000111111111111113500000350000035000003500035000003500000350000035000111111111111115000000500000050
13、000005000050000005000000500000050000111111111111114000000400000040000004000040000004000000400000040000111111111111111000000010000000100000001000001000000010000000100000001000001111111111111160000006000000600000060000600000060000006000000600001111111111111140000004000000400000040000400000040000004000
14、00040000222222222222223000000300000030000003000060000006000000600000060000465000004650000046500000465000JulAugSep3rd4th1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th000000000000000000000000000012987.512360.313073.21244611818.811191.610564.49937.29623.610740.81185812975.216042.61911012987.512360.313073.2124461
15、1818.811191.610564.49937.29623.610740.81185812975.216042.619110007000000000000000025000000000000000500000000000000015000000000000000150000000000000001000000000000000015000000000000000000000000000000150000000000000016801680288016801680168028801680468016802880168016801680000000000000000000000000000010
16、0100100100100100100100100100100100100100Jun0012000001200000120000000000000300000000108010801080108010801080108010801080108010801080108010805005005005005005005005005005005005005005005267.55022.54532.54287.54042.53797.53552.53307.52508.82822.431363449.64076.847043160.53013.52719.52572.52425.52278.5213
17、1.51984.51724.81940.421562371.62802.832342107200918131715161715191421132378488298010781274147000000000000000000000000000000000000000000000000000000000000000000000001685616072145041372012936121521136810584627270567840862410192117601685616072145041372012936121521136810584627270567840862410192117603%3%
18、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.5
19、1.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.50000000000000000
20、000000000000913508785076650731506965066150626505915063000665007000073500805008750011111111111111008000000800000080000000080000008000000800000011111111111111003500000350000035000000035000003500000350000011111111111111005000000500000050000000050000005000000500000011111111111111004000000400000040000000
21、040000004000000400000011111111111111001000000010000000100000000010000000100000001000000011111111111111006000000600000060000000060000006000000600000011111111111111004000000400000040000000040000004000000400000022222222222222003000000300000030000000060000006000000600000000465000004650000046500000OctNov
22、Dec1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th合计0000000000000010000000000000000-60000029272.638190.649058.857976.85909460211.261328.462445.661328.460211.251293.242375.2984871029272.638190.649058.857976.85909460211.261328.462445.661328.460211.251293.2-17625108487100070000000000000028000250000000000000100005
23、000000000000020001500000000000006000150000000000000600010000000000000040000150000000000000065000000000000000500015000000000000006000002880168016801680288016801680168028801680168016801460400000000000004000000000000000050001001001001001001001001001001001001004800120000012000001200000144000000000000006
24、000108010801080108010801080108010801080108010801080518405005005005005005005005005005005005002400005644.87212.89094.410662.41097611289.611603.211916.811603.211289.69721.68153.62501163880.84958.86252.47330.475467761.67977.28192.87977.27761.66683.65605.61623081764225428423332343035283626372436263528303
25、825488780800000000000009600000000000000000000000000600000000000000360000000000000001411218032227362665627440282242900829792290082822424304203847024641411218032227362665627440282242900829792290082822424304203847024643%3%3%3%3%3%3%3%3%3%3%3%1.44012001200120012001200120012001200120012001200120057600458
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 成本 盈亏 预测 模型
限制150内