成本盈亏预测模型.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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 成本 盈亏 预测 模型