【成本】盈亏预测模型

1、,XX旗舰店2016年支出费用表,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,1st,2nd,3rd,4th,合计,0,天猫平台固定费用,0,技术服务年费,100000,0,0,0,0,0,0,0

2、,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100000,服务保证金,60000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-60000,0,商城扣点,2053.1,2538.2,3023.3,3508.4,3993.5,5105.8,6218.1,7330.4,8442.7,9555,9697.1,9839.2,10111.15,102

3、53.25,10395.35,10537.45,9224.25,9851.45,10478.65,11105.85,11733.05,12360.25,12987.45,12360.25,13073.2,12446,11818.8,11191.6,10564.4,9937.2,9623.6,10740.8,11858,12975.2,16042.6,19110,29272.6,38190.6,49058.8,57976.8,59094,60211.2,61328.4,62445.6,61328.4,60211.2,51293.2,42375.2,984870.6,0,固定费用合计,162053

4、.1,2538.2,3023.3,3508.4,3993.5,5105.8,6218.1,7330.4,8442.7,9555,9697.1,9839.2,10111.15,10253.25,10395.35,10537.45,9224.25,9851.45,10478.65,11105.85,11733.05,12360.25,12987.45,12360.25,13073.2,12446,11818.8,11191.6,10564.4,9937.2,9623.6,10740.8,11858,12975.2,16042.6,19110,29272.6,38190.6,49058.8,5797

5、6.8,59094,60211.2,61328.4,62445.6,61328.4,60211.2,51293.2,-17624.8,1084870.6,0,营运费用【硬性】,0,0,模特拍摄费用,7000,0,0,0,0,0,0,0,0,0,0,0,7000,0,0,0,0,0,0,0,0,0,0,0,7000,0,0,0,0,0,0,0,0,0,0,0,7000,0,0,0,0,0,0,0,0,0,0,0,28000,模特费,2500,0,0,0,0,0,0,0,0,0,0,0,2500,0,0,0,0,0,0,0,0,0,0,0,2500,0,0,0,0,0,0,0,0,0,0,0,25

6、00,0,0,0,0,0,0,0,0,0,0,0,10000,造型师,500,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0,0,0,0,0,0,0,0,500,0,0,0,0,0,0,0,0,0,0,0,2000,摄影师,1500,0,0,0,0,0,0,0,0,0,0,0,1500,0,0,0,0,0,0,0,0,0,0,0,1500,0,0,0,0,0,0,0,0,0,0,0,1500,0,0,0,0,0,0,0,0,0,0,0,6000,影棚租赁,1500,0,0,0,0,0,0,0,0,0,0,0,1500,0,

7、0,0,0,0,0,0,0,0,0,0,1500,0,0,0,0,0,0,0,0,0,0,0,1500,0,0,0,0,0,0,0,0,0,0,0,6000,不可预计,1000,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,0,0,0,0,4000,0,房租费用,20000,0,0,0,0,0,0,0,0,0,0,0,15000,0,0,0,0,0,0,0,0,0,0,0,15000,0,0,0,0,0,0,0,0,0,0,0,15000,0,0,0,

8、0,0,0,0,0,0,0,0,65000,押金,5000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,房租,15000,0,0,0,0,0,0,0,0,0,0,0,15000,0,0,0,0,0,0,0,0,0,0,0,15000,0,0,0,0,0,0,0,0,0,0,0,15000,0,0,0,0,0,0,0,0,0,0,0,60000,0,办公费用,50880,1680,1680,1680,2880,1680,1680,1680,28

9、80,1680,1680,1680,2880,1680,1680,1680,2880,1680,1680,1680,2880,1680,1680,1680,2880,1680,1680,1680,2880,1680,4680,1680,2880,1680,1680,1680,2880,1680,1680,1680,2880,1680,1680,1680,2880,1680,1680,1680,146040,电脑,40000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

10、0,0,0,0,40000,家具,5000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5000,纸张耗材,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,10

11、0,100,100,100,100,4800,水电,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,1200,0,0,0,14400,货架,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6000,员工福利,1080,1080,1080,1080,1

12、080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,1080,51840,不可预计,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,50

13、0,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,500,24000,0,营销费用,857.5,1102.5,1347.5,1592.5,1837.5,2327.5,2817.5,3307.5,3797.5,4287.5,4287.5,4287.5,4532.5,4532.5,4532.5,4532.5,3797.5,4042.5,4287.5,4532.5,4777.5,5022.5,5267.5,5022.

14、5,4532.5,4287.5,4042.5,3797.5,3552.5,3307.5,2508.8,2822.4,3136,3449.6,4076.8,4704,5644.8,7212.8,9094.4,10662.4,10976,11289.6,11603.2,11916.8,11603.2,11289.6,9721.6,8153.6,250115.6,包装盒,514.5,661.5,808.5,955.5,1102.5,1396.5,1690.5,1984.5,2278.5,2572.5,2572.5,2572.5,2719.5,2719.5,2719.5,2719.5,2278.5,2

15、425.5,2572.5,2719.5,2866.5,3013.5,3160.5,3013.5,2719.5,2572.5,2425.5,2278.5,2131.5,1984.5,1724.8,1940.4,2156,2371.6,2802.8,3234,3880.8,4958.8,6252.4,7330.4,7546,7761.6,7977.2,8192.8,7977.2,7761.6,6683.6,5605.6,162307.6,小礼物,343,441,539,637,735,931,1127,1323,1519,1715,1715,1715,1813,1813,1813,1813,151

16、9,1617,1715,1813,1911,2009,2107,2009,1813,1715,1617,1519,1421,1323,784,882,980,1078,1274,1470,1764,2254,2842,3332,3430,3528,3626,3724,3626,3528,3038,2548,87808,0,软件费用,960,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,960,量子,0,0,0,0,0,0,0,0,0,0,0,0,0,0,

17、0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,生E经,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,600,数据魔方,360,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,360,老A工具箱,0,0,0,0,0,0

18、,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,物流费用,2744,3528,4312,5096,5880,7448,9016,10584,12152,13720,13720,13720,14504,14504,14504,14504,12152,12936,13720,14504,15288,16072,16856,16072,14504,13720,12936,12152,11368,10584,6272,7056,7840,8624,10192,11760,1

19、4112,18032,22736,26656,27440,28224,29008,29792,29008,28224,24304,20384,702464,快递费,2744,3528,4312,5096,5880,7448,9016,10584,12152,13720,13720,13720,14504,14504,14504,14504,12152,12936,13720,14504,15288,16072,16856,16072,14504,13720,12936,12152,11368,10584,6272,7056,7840,8624,10192,11760,14112,18032,2

20、2736,26656,27440,28224,29008,29792,29008,28224,24304,20384,702464,换货率,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,1.44,0,其他不可预计费用,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,

21、1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,57600,硬运费费用合计,83641.5,7510.5,8539.5,9568.5,11797.5,12655.5,14713.5,16771.5,20029.5,20887.5,20887.5,20887.5,45116.5,21916.5,21916.5

22、,21916.5,20029.5,19858.5,20887.5,21916.5,24145.5,23974.5,25003.5,23974.5,45116.5,20887.5,19858.5,18829.5,19000.5,16771.5,14660.8,12758.4,15056,14953.6,17148.8,19344,45836.8,28124.8,34710.4,40198.4,42496,42393.6,43491.2,44588.8,44691.2,42393.6,36905.6,31417.6,1250179.6,0,营运费用【软性】,0,直通车爆款,3500,7000,10

23、500,14000,17500,24500,31500,38500,45500,52500,52500,52500,52500,52500,52500,52500,42000,45500,49000,52500,56000,59500,63000,59500,56000,52500,49000,45500,42000,38500,3500,7000,10500,14000,21000,28000,38500,56000,73500,91000,94500,98000,101500,105000,101500,98000,80500,63000,2355500,转化率,3%,3%,3%,3%,3

24、%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,3%,1.44,PPC,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,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,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,

25、1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,72,0,直通车常规,15400,15400,15400,15400,15400,15400,15400,15400,15400,15400,15400,15400,23100,23100,23100,23100,23100,23100,23100,23100,23100,23100,23100,23100,15400,15400,15400,15400,15400,15400,38500,38500,38500,38500,38500,38500,38500,38500,46200,46200,46200,46200,46200

26、,46200,46200,46200,46200,46200,1324400,转化率,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%,2%,2%,2%,2%,2%,2%,0.96,PPC,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,2.2,2.2,2.2,2.2,2.2,

27、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,2.2,105.6,0,钻展,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,5250,21000,21000,21000,21000,21000,21000,21000,21000,210

28、00,21000,21000,21000,21000,21000,21000,21000,21000,21000,535500,转化率,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,1%,0.48,PPC,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,1.5,1.5,1.5,1.5,1.5,1.5

29、,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,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,72,0,淘宝客,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,硬广,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

30、,0,0,0,0,0,0,0,0,0,0,0,0,软运营费用合计,24150,27650,31150,34650,38150,45150,52150,59150,66150,73150,73150,73150,80850,80850,80850,80850,70350,73850,77350,80850,84350,87850,91350,87850,76650,73150,69650,66150,62650,59150,63000,66500,70000,73500,80500,87500,98000,115500,140700,158200,161700,165200,168700,172

31、200,168700,165200,147700,130200,4215400,0,人员成本,0,0,设计师,数量,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,48,薪资,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,96000,合计

32、,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,8000,0,0,0,96000,0,设计助理,数量,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,48,薪资,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,

33、0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,42000,合计,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,3500,0,0,0,42000,0,采购及跟单,数量,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1

34、,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,48,薪资,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,60000,合计,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0,0,0,5000,0

35、,0,0,5000,0,0,0,60000,0,仓库管理,数量,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,48,薪资,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,48000,合计,4000,0,0,0,4000,0,0,0,400

36、0,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,4000,0,0,0,48000,0,运营及数据分析,数量,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,48,薪资,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,

37、10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,120000,合计,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,10000,0,0,0,120000,0,推广专员,数量,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1