【财务】电商所有现金统计规划流量表

1、某某网店2017年支出成本预估天猫平台固定成本Jan1st2nd3rd4th技术服务年费60,000保证金100,000商城扣点480540600660固定成本合计160,480540600660运营成本（硬）办公电脑数量4单价3000合计12000000办公家具数量4单价300合计1200000拍摄费用6,000纸张及办公耗材50505050打印机及网络设备1,200办公室水电100100100100仓库货架等用品2,000服装辅料及周边10,000购买软件成本1,000办公室租金及押金12,000运营成本（软）直通车6,0006,7507,5008,250运营成本合计51,5506,900

2、7,6508,400人员成本Jan1st2nd3rd4th运营及推广数量1111工资8000合计0008000设计师及打版数量1111工资5000合计0005000跟单及产品数量1111工资4000合计0004000平面设计及美工数量1111工资5000合计0005000客服及售后数量2222工资3000合计0006000人员成本合计00028000总支出成本合计212,0307,4408,25037,060FebMarApr1st2nd3rd4th1st2nd3rd4th1st5606307007705606307007703205606307007705606307007703200000

3、0000000000000050505050505050505010010010010010010010010010090006,0006,7507,5008,2506,0006,7507,5008,2506,0006,1506,9007,6508,4006,1506,9007,6508,40015,150FebMarApr1st2nd3rd4th1st2nd3rd4th1st1111111118000000000080000111111111某某网店2017年支出成本预估5000000000050000111111111400000000004000011111111150000000000

4、50000222222222300000000006000000000002800006,7107,5308,3509,1706,7107,5308,35037,17015,470更多电商资料添加微信：FL-450MayJun2nd3rd4th1st2nd3rd4th1st2nd3604004403203604004403203603604004403203604004403203600000000000000000005050505050505050501001001001001001001001001002,0006,7507,5008,2506,0006,7507,5008,2506,0

5、006,7506,9007,6508,4006,1506,9007,6508,4008,1506,900MayJun2nd3rd4th1st2nd3rd4th1st2nd11111111180008000008000000800000111211111某某网店2017年支出成本预估AprApr500050000050000005000111111111400040000040000004000001111111115000500000500000050000022222222230003000006000000600000002800000028000007,2608,05036,8406,4

6、707,2608,05036,8408,4707,260JulAug3rd4th1st2nd3rd4th1st2nd3rd40044032036040044040045050040044032036040044040045050043000000000120000043000000001200005050505050505050501001001001001001001001001001000090007,5008,2506,0006,7507,5008,2506,0006,7507,5007,6508,40015,1506,9007,6508,40029,3506,9007,650JulAu

7、g3rd4th1st2nd3rd4th1st2nd3rd11111111180008000080000008000000111111111某某网店2017年支出成本预估JunJun5000500050000005000000111111111400040000400000040000001111111115000500005000000500000022222222230003000060000006000000028000000280000008,05036,84015,4707,2608,05036,84029,7507,3508,150SepOct4th1st2nd3rd4th1st2n

8、d3rd4th550640720800880880990110012105506407208008808809901,1001,21000000000000000000050505050505050505010010010010010010010010010090008,2506,0006,7507,5008,2506,0006,7507,5008,2508,4006,1506,9007,6508,40015,1506,9007,6508,400SepOct4th1st2nd3rd4th1st2nd3rd4th111111111800080008000800000080000008000111

9、111111某某网店2017年支出成本预估AugAug50005000500050000005000000500011111111140004000400040000004000000400011111111150005000500050000005000000500022222222230003000300060000006000000600028000000280000002800036,9506,7907,6208,45037,28016,0307,8908,75037,610NovDec合计1st2nd3rd4th1st2nd3rd4th-60,0000100,000128014401

10、6001760152017101900209036,10001,2801,4401,6001,7601,5201,7101,900-57,910136,1006,0000000000024,000600000000002,4006,00050505050505050502,4001,2001001001001001001001001004,8004,00020,0001,00039,0006,0006,7507,5008,2506,0006,7507,5008,2506,1506,9007,6508,4006,1506,9007,6508,400446,800NovDec1st2nd3rd4t

11、h1st2nd3rd4th11111111800080000008000000800088,00011111111某某网店2017年支出成本预估500050000005000000500055,00011111111400040000004000000400044,00011111111500050000005000000500055,00022222222300030000006000000600066,00000002800000028000308,0007,4308,3409,25038,1607,6708,6109,550-21,510890,900某某网店2017年收入及直接成本营业

12、收入JanFeb1st2nd3rd4th1st投入100000推广流量数量809010011080平均单价120120120120140小计960010800120001320011200自然流量数量8010012014080平均单价120120120120140小计960012000144001680011200总收入总计960010800120001320011200直接成本推广流量成本率30%30%30%30%30%直接成本28803240360039603360自然流量成本率30%30%30%30%30%直接成本00000运费成本取均值8元12801520176020001280直接成

13、本合计41604760536059604640直接成本现金流1054406040664072406560JanFeb1st2nd3rd4th1stMarApr2nd3rd4th1st2nd3rd4th1st2nd90100110809010011080901401401401401401401408080126001400015400112001260014000154006400720010012014080100120140801001401401401401401401408080140001680019600112001400016800196006400800012600140001

14、5400112001260014000154006400720030%30%30%30%30%30%30%30%30%37804200462033603780420046201920216030%30%30%30%30%30%30%30%30%000000000152017602000128015201760200012801520530059606620464053005960662032003680730080408780656073008040878032003520MarApr2nd3rd4th1st2nd3rd4th1st2nd某某网店2017年收入及直接成本FebFebMayJun

15、3rd4th1st2nd3rd4th1st2nd3rd1001108090100110809010080808080808080808080008800640072008000880064007200800012014080100120140801001208080808080808080809600112006400800096001120064008000960080008800640072008000880064007200800030%30%30%30%30%30%30%30%30%24002640192021602400264019202160240030%30%30%30%30%3

16、0%30%30%30%000000000176020001280152017602000128015201760416046403200368041604640320036804160384041603200352038404160320035203840MayJun3rd4th1st2nd3rd4th1st2nd3rd某某网店2017年收入及直接成本AprAprJulAug4th1st2nd3rd4th1st2nd3rd4th110809010011080901001108080808080100100100100880064007200800088008000900010000110001

17、4080100120140801001201408080808080100100100100112006400800096001120080001000012000140008800640072008000880080009000100001100030%30%30%30%30%30%30%30%30%26401920216024002640240027003000330030%30%30%30%30%30%30%30%30%0000000002000128015201760200012801520176020004640320036804160464036804220476053004160

18、32003520384041604320478052405700JulAug4th1st2nd3rd4th1st2nd3rd4th某某网店2017年收入及直接成本JunJunSepOctNov1st2nd3rd4th1st2nd3rd4th1st809010011080901001108016016016016022022022022032012800144001600017600176001980022000242002560080100120140801001201408016016016016022022022022032012800160001920022400176002200026

19、400308002560012800144001600017600176001980022000242002560030%30%30%30%30%30%30%30%30%38404320480052805280594066007260768030%30%30%30%30%30%30%30%30%000000000128015201760200012801520176020001280512058406560728065607460836092608960768085609440103201104012340136401494016640SepOctNov1st2nd3rd4th1st2nd3r

20、d4th1st某某网店2017年收入及直接成本Dec合计2nd3rd4th1st2nd3rd4th90100110809010011032032032038038038038028800320003520030400342003800041800722000100120140801001201403203203203803803803803200038400448003040038000456005320002880032000352003040034200380004180072200030%30%30%30%30%30%30%86409600105609120102601140012540

21、30%30%30%30%30%30%30%000000015201760200012801520176020001016011360125601040011780131601454029532018640206402264020000224202484027260Dec2nd3rd4th1st2nd3rd4th某某网店2017年收入及直接成本NovNov某某网店现金流量表JanFeb1st2nd3rd4th1st注入资金300000营业收入推广流量960010800120001320011200自然流量960012000144001680011200营业总收入19200228002640030

22、00022400直接成本推广流量28803240360039603360自然流量00000直接成本总计28803240360039603360毛利润1632019560228002604019040总支出成本212,0307,4408,25037,0606,710现金流量104,290116,410130,960119,940132,270净利润-195,71012,12014,550-11,02012,330MarApr2nd3rd4th1st2nd3rd4th1st2nd126001400015400112001260014000154006400720014000168001960011

23、200140001680019600640080002660030800350002240026600308003500012800152003780420046203360378042004620192021600000000003780420046203360378042004620192021602282026600303801904022820266003038010880130407,5308,3509,1706,7107,5308,35037,17015,4707,260147,560165,810187,020199,350214,640232,890226,100221,510

24、227,29015,29018,25021,21012,33015,29018,250-6,790-4,5905,780某某网店现金流量表FebMayJun3rd4th1st2nd3rd4th1st2nd3rd800088006400720080008800640072008000960011200640080009600112006400800096001760020000128001520017600200001280015200176002400264019202160240026401920216024000000000002400264019202160240026401920216

25、024001520017360108801304015200173601088013040152008,05036,8406,4707,2608,05036,8408,4707,2608,050234,440214,960219,370225,150232,300212,820215,230221,010228,1607,150-19,4804,4105,7807,150-19,4802,4105,7807,150某某网店现金流量表AprJulAug4th1st2nd3rd4th1st2nd3rd8800640072008000880080009000100001120064008000960

26、011200800010000120002000012800152001760020000160001900022000264019202160240026402400270030000000000026401920216024002640240027003000173601088013040152001736013600163001900036,84015,4707,2608,05036,84029,7507,3508,150208,680204,090209,870217,020197,540181,390190,340201,190-19,480-4,5905,7807,150-19,4

27、80-16,1508,95010,850某某网店现金流量表JunSepOct4th1st2nd3rd4th1st2nd3rd110001280014400160001760017600198002200014000128001600019200224001760022000264002500025600304003520040000352004180048400330038404320480052805280594066000000000033003840432048005280528059406600217002176026080304003472029920358604180036,9506,7907,6208,45037,28016,0307,8908,750185,940200,910219,370241,320238,760