精品表格-电商财务月度数据汇总分析表

1、janfeb1st2nd3rd4th1st2nd3rd天猫平台固定费用技术服务年费100000000000服务保证金60000000000商城扣点2053.12538.23023.33508.43993.55105.86218.1固定费用合计162053.12538.23023.33508.43993.55105.86218.1运营成本【硬性】模特拍摄费用7000000000模特费2500000000造型师500000000摄影师1500000000影棚租赁1500000000不可预计1000000000房租费用20000000000押金5000000000房公费用5

2、0880168016801680288016801680电脑40000000000家具5000000000纸张耗材100100100100100100100水电1200000120000货架3000000000员工福利1080108010801080108010801080不可预计500500500500500500500营销费用857.51102.51347.51592.51837.52327.52817.5包装盒514.5661.5808.5955.51102.51396.51690.5小礼物3434415396377359311127软件费用960000000量子0000000生e经60

3、0000000数据魔方360000000老a工具箱0000000物流费用2744352843125096588074489016快递费2744352843125096588074489016换货率0.030.030.030.030.030.030.03其他不可预计费用1200120012001200120012001200合计83641.57510.58539.59568.511797.512655.514713.5运营成本【软性】直通车爆款350070001050014000175002450031500转化率0.030.030.030.030.030.030.03ppc1.51.51.51

4、.51.51.51.5直通车常规15400154001540015400154001540015400转化率0.020.020.020.020.020.020.02ppc2.22.22.22.22.22.22.2钻展5250525052505250525052505250转化率0.010.010.010.010.010.010.01ppc1.51.51.51.51.51.51.5淘宝客0000000硬广0000000运营成本【硬性】合计24150276503115034650381504515052150人力成本设计师数量1111111薪资8000000800000合计800000080000

5、0设计助理数量1111111薪资3500000350000合计3500000350000采购及跟单数量1111111薪资5000000500000合计5000000500000仓库管理数量1111111薪资4000000400000合计4000000400000运营及数据分析数量1111111薪资100000001000000合计100000001000000推广专员数量1111111薪资6000000600000合计6000000600000平面设计数量1111111薪资4000000400000合计4000000400000客服数量2222222薪资3000000300000合计60000

6、00600000合计465000004650000人力成本maraprmay4th1st2nd3rd4th1st2nd3rd4th1st2nd3rd0000000000000000000000007330.48442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.77330.48442.795559697.19839.210111.210253.310395.410537.59224.259851.4510478.7000007000000000000002500000000000005000000000000

7、015000000000000015000000000000010000000000000015000000000000000000000000001500000000016802880168016801680288016801680168028801680168000000000000000000000000010010010010010010010010010010010010001200000120000012000000000000000010801080108010801080108010801080108010801080108050050050050050050050050050

8、05005005003307.53797.54287.54287.54287.54532.54532.54532.54532.53797.54042.54287.51984.52278.52572.52572.52572.52719.52719.52719.52719.52278.52425.52572.5132315191715171517151813181318131813151916171715feb00000000000000000000000000000000000000000000000000000000000010584121521372013720137201450414504

9、14504145041215212936137201058412152137201372013720145041450414504145041215212936137200.030.030.030.030.030.030.030.030.030.030.030.0312001200120012001200120012001200120012001200120016771.520029.520887.520887.520887.545116.521916.521916.521916.520029.519858.520887.538500455005250052500525005250052500

10、52500525004200045500490000.030.030.030.030.030.030.030.030.030.030.030.031.51.51.51.51.51.51.51.51.51.51.51.51540015400154001540015400231002310023100231002310023100231000.020.020.020.020.020.020.020.020.020.020.020.022.22.22.22.22.22.22.22.22.22.22.22.252505250525052505250525052505250525052505250525

11、00.010.010.010.010.010.010.010.010.010.010.010.011.51.51.51.51.51.51.51.51.51.51.51.500000000000000000000000059150661507315073150731508085080850808508085070350738507735011111111111108000000800000080000008000000800000080000011111111111103500000350000035000003500000350000035000011111111111105000000500

12、000050000005000000500000050000011111111111104000000400000040000004000000400000040000011111111111101000000010000000100000001000000010000000100000011111111111106000000600000060000006000000600000060000011111111111104000000400000040000004000000400000040000022222222222203000000300000030000006000000600000

13、0600000046500000465000004650000jun4th1st2nd3rd4th合计00000100000000006000011105.911733.112360.312987.512360.3202703.211105.911733.112360.312987.512360.3362703.20000014000000005000000001000000003000000003000000002000000000350000000050000000030000016802880168016801680955200000040000000005000100100100100

14、100240001200000720000000300010801080108010801080259205005005005005001200004532.54777.55022.55267.55022.5867302719.52866.53013.53160.53013.55203818131911200921072009346920may0000096000000000000600000003600000000145041528816072168561607227753614504152881607216856160722775360.030.030.030.030.030.720120

15、012001200120012002880021916.524145.523974.525003.523974.55385460052500560005950063000595009870000.030.030.030.030.030.721.51.51.51.51.536023100231002310023100231004620000.020.020.020.020.020.482.22.22.22.22.252.80525052505250525052501260000.010.010.010.010.010.241.51.51.51.51.53600000000000000080850843508785091350878501575000111112408000000480000800000048000011111240350000