当前位置:文档之家› 店铺盈亏预测模型Excel模板

店铺盈亏预测模型Excel模板

店铺盈亏预测模型Excel模板
店铺盈亏预测模型Excel模板

XX旗舰店2016年支出费用表

Jan Feb

1st2nd3rd4th1st2nd3rd4th 天猫平台固定费用

技术服务年费1000000000000

服务保证金600000000000

商城扣点2053.12538.23023.33508.43993.55105.86218.17330.4固定费用合计1620532538.23023.33508.43993.55105.86218.17330.4营运费用【硬性】

模特拍摄费用70000000000

模特费25000000000

造型师5000000000

摄影师150********

影棚租赁150********

不可预计10000000000房租费用200000000000

押金50000000000

房租150000000000办公费用508801680168016802880168016801680

电脑400000000000

家具50000000000

纸张耗材100100100100100100100100

水电12000001200000

货架30000000000

员工福利10801080108010801080108010801080

不可预计500500500500500500500500营销费用857.51102.51347.51592.51837.52327.52817.53307.5

包装盒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.58539.59568.511797.512655.514713.516771.5营运费用【软性】

直通车爆款35007000105001400017500245003150038500

转化率3%3%3%3%3%3%3%3%

PPC 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5直通车常规1540015400154001540015400154001540015400

转化率2%2%2%2%2%2%2%2%

PPC 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2钻展52505250525052505250525052505250

转化率1%1%1%1%1%1%1%1%

PPC 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5淘宝客00000000

硬广00000000软运营费用合计2415027650311503465038150451505215059150人员成本

设计师数量11111111

薪资80000008000000

合计80000008000000设计助理数量11111111

薪资35000003500000

合计35000003500000采购及跟单数量11111111

薪资50000005000000

合计50000005000000仓库管理数量11111111

薪资40000004000000

合计40000004000000

运营及数据分析数量11111111

薪资1000000010000000

合计1000000010000000推广专员数量11111111

薪资60000006000000

合计60000006000000平面设计数量11111111

薪资40000004000000

合计40000004000000客服数量22222222

薪资30000003000000

合计60000006000000人员成本合计4650000046500000

Mar Apr May Jun 1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th1st2nd 00000000000000 00000000000000 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 000015000000000000 00000000000000 000015000000000000

28801680168016802880168016801680288016801680168028801680 00000000000000 00000000000000 100100100100100100100100100100100100100100

12000001200000120000012000 00000000000000 10801080108010801080108010801080108010801080108010801080 500500500500500500500500500500500500500500

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 00000000000000 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.521916.520029.519858.520887.521916.524145.523974.5 4550052500525005250052500525005250052500420004550049000525005600059500 3%3%3%3%3%3%3%3%3%3%3%3%3%3% 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1540015400154001540023100231002310023100231002310023100231002310023100 2%2%2%2%2%2%2%2%2%2%2%2%2%2%

2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2

52505250525052505250525052505250525052505250525052505250 1%1%1%1%1%1%1%1%1%1%1%1%1%1% 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5

00000000000000

00000000000000

6615073150731507315080850808508085080850703507385077350808508435087850 11111111111111 80000008000000800000080000 80000008000000800000080000 11111111111111 35000003500000350000035000 35000003500000350000035000 11111111111111 50000005000000500000050000 50000005000000500000050000 11111111111111 40000004000000400000040000 40000004000000400000040000

11111111111111 100000001000000010000000100000 100000001000000010000000100000

11111111111111 60000006000000600000060000 60000006000000600000060000

11111111111111 40000004000000400000040000 40000004000000400000040000 22222222222222 30000003000000300000030000 60000006000000600000060000

465000004650000046500000465000

Jun Jul Aug Sep 3rd4th1st2nd3rd4th1st2nd3rd4th1st2nd3rd4th 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 00150000000000000 00100000000000000 001500000000000000 00000000000000 001500000000000000

16801680288016801680168028801680468016802880168016801680 00000000000000 00000000000000 100100100100100100100100100100100100100100

00120000012000001200000 00000000300000000 10801080108010801080108010801080108010801080108010801080 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 00000000000000 00000000000000 00000000000000 00000000000000 168561607214504137201293612152113681058462727056784086241019211760 168561607214504137201293612152113681058462727056784086241019211760 3%3%3%3%3%3%3%3%3%3%3%3%3%3%

12001200120012001200120012001200120012001200120012001200 25003.523974.545116.520887.519858.518829.519000.516771.514660.812758.41505614953.617148.819344 63000595005600052500490004550042000385003500700010500140002100028000 3%3%3%3%3%3%3%3%3%3%3%3%3%3% 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 2310023100154001540015400154001540015400385003850038500385003850038500 2%2%2%2%2%2%2%2%2%2%2%2%2%2%

2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2

52505250525052505250525052505250210002100021000210002100021000 1%1%1%1%1%1%1%1%1%1%1%1%1%1% 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5

00000000000000

00000000000000

9135087850766507315069650661506265059150630006650070000735008050087500 11111111111111 00800000080000008000000 00800000080000008000000 11111111111111 00350000035000003500000 00350000035000003500000 11111111111111 00500000050000005000000 00500000050000005000000 11111111111111 00400000040000004000000 00400000040000004000000

11111111111111 00100000001000000010000000 00100000001000000010000000

11111111111111 00600000060000006000000 00600000060000006000000

11111111111111 00400000040000004000000 00400000040000004000000 22222222222222 00300000030000003000000 00600000060000006000000

00465000004650000046500000

1st

2nd

3rd

4th

1st

2nd

3rd

4th

1st

2nd

3rd

4th

合计000000000000001000000

00

-60000

029272.638190.649058.857976.85909460211.261328.462445.661328.460211.251293.242375.2984871029272.638190.649058.857976.8

59094

60211.261328.462445.661328.460211.251293.2

-176251084871

000

7000000000000002800025000000000000010000500000000000002000150000000000000600015000000000000060001000000000000004000015000000000000006500000000000000050001500000000000000600000288016801680168028801680168016802880168016801680146040000000000000400000000000000005000100

100

100

100

100

100

100

100

100

100

100

100

4800

Nov

Dec

Oct

12000001200000120000014400 0000000000006000 10801080108010801080108010801080108010801080108051840 50050050050050050050050050050050050024000

0 5644.87212.89094.410662.41097611289.611603.211916.811603.211289.69721.68153.6250116 3880.84958.86252.47330.475467761.67977.28192.87977.27761.66683.65605.6162308 17642254284233323430352836263724362635283038254887808

0 000000000000960 0000000000000 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.440198.44249642393.643491.244588.844691.242393.636905.631417.61250180

0 3850056000735009100094500980001015001050001015009800080500630002355500 3%3%3%3%3%3%3%3%3%3%3%3% 1.44 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.572

0 3850038500462004620046200462004620046200462004620046200462001324400 2%2%2%2%2%2%2%2%2%2%2%2%0.96

2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2 2.2105.6

0 210002100021000210002100021000210002100021000210002100021000535500 1%1%1%1%1%1%1%1%1%1%1%1%0.48 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.572

0 0000000000000

0 0000000000000

0 980001155001407001582001617001652001687001722001687001652001477001302004215400

0 11111111111148 80000008000000800000096000 80000008000000800000096000

0 11111111111148 35000003500000350000042000 35000003500000350000042000

0 11111111111148 50000005000000500000060000 50000005000000500000060000

0 11111111111148 40000004000000400000048000 40000004000000400000048000

0 11111111111148 100000001000000010000000120000 100000001000000010000000120000

0 11111111111148 60000006000000600000072000 60000006000000600000072000

0 11111111111148 40000004000000400000048000 40000004000000400000048000

0 22222222222296 30000003000000300000036000 60000006000000600000072000

0 465000004650000046500000558000

相关主题
文本预览
相关文档 最新文档