【預(yù)算】電商項(xiàng)目經(jīng)營(yíng)預(yù)算分析表

1、20172017年度電商項(xiàng)目經(jīng)營(yíng)預(yù)算分析表科目20172017年1月20172017年2月20172017年3月20172017年4月20172017年5月20172017年6月20172017年7月20172017年8月20172017年9月20172017年1010月20172017年1111月20172017年1212月20172017年1月20172017年1212月總合計(jì)收入含稅銷售額0.050000.0100000.0450

2、000.0800000.01000000.01800000.01500000.03000000.03500000.04000000.03800000.020000000.0未稅銷售額0.042735.085470.1384615.4683760.7854700.91538461.51282051.32564102.62991453.03418803.43247863.217094017.1含稅成本0.037500.065000.0270

3、000.0480000.0550000.0900000.0600000.0900000.01050000.02000000.01140000.07992500.0未稅成本0.032051.355555.6230769.2410256.4470085.5769230.8512820.5769230.8897435.91709401.7974359.06831196.6毛利率0.0%25.0%35.0%40.0%40.0%45.0%50.0

4、%60.0%70.0%70.0%50.0%70.0%60.0%含稅毛利額0.012500.035000.0180000.0320000.0450000.0900000.0900000.02100000.02450000.02000000.02660000.012007500.0未稅毛利額0.010683.829914.5153846.2273504.3384615.4769230.8769230.81794871.82094017.11

5、709401.72273504.310262820.5費(fèi)用平臺(tái)費(fèi)用率0.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.6%保證金率(只支付第一年）0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.3%平臺(tái)使用年費(fèi)率0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.3%平臺(tái)傭金扣點(diǎn)率5.0%

6、5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%推廣費(fèi)率6.0%46.0%46.0%39.3%37.3%36.0%28.2%26.0%23.3%21.7%20.3%19.2%24.0%淘內(nèi)推廣費(fèi)率0.0%40.0%40.0%33.3%31.3%30.0%22.2%20.0%17.3%15.7%14.3%13.2%18.0%淘外推廣費(fèi)率6.0%6.0%6.0%6.0%6.0%6.0%6.0%

7、6.0%6.0%6.0%6.0%6.0%6.0%物流倉(cāng)儲(chǔ)費(fèi)用率物流損耗費(fèi)率6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%物流費(fèi)率5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%損耗費(fèi)率1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%倉(cāng)儲(chǔ)費(fèi)率4.0%4.0%4.0%4.0

8、%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%管理費(fèi)用率0.0%200.0%100.0%22.2%12.5%10.0%13.9%15.3%7.7%6.6%5.8%6.1%10.0%平臺(tái)費(fèi)用額110000.02500.05000.022500.040000.050000.090000.075000.0150000.0175000.0200000.0190000.01110000.0保證金(只支付第一年）5000

9、0.00.00.00.00.00.00.00.00.00.00.00.050000.0平臺(tái)使用年費(fèi)60000.00.00.00.00.00.00.00.00.00.00.00.060000.0平臺(tái)傭金扣點(diǎn)0.02500.05000.022500.040000.050000.090000.075000.0150000.0175000.0200000.0190000.01000000.0推廣費(fèi)0.023000.046000.0177000.

10、0298000.0360000.0508000.0390000.0700000.0760000.0810000.0728000.04800000.0淘內(nèi)推廣費(fèi)0.020000.040000.0150000.0250000.0300000.0400000.0300000.0520000.0550000.0570000.0500000.03600000.0淘外推廣費(fèi)0.03000.06000.027000.048000.060000.010

11、8000.090000.0180000.0210000.0240000.0228000.01200000.0物流倉(cāng)儲(chǔ)費(fèi)用物流損耗費(fèi)0.03000.06000.027000.048000.060000.0108000.090000.0180000.0210000.0240000.0228000.01200000.0物流費(fèi)0.02500.05000.022500.040000.050000.090000.075000.0150000.017

12、5000.0200000.0190000.01000000.0損耗費(fèi)0.0500.01000.04500.08000.010000.018000.015000.030000.035000.040000.038000.0200000.0倉(cāng)儲(chǔ)費(fèi)0.02000.04000.018000.032000.040000.072000.060000.0120000.0140000.0160000.0152000.0800000.0管理費(fèi)用100000

13、.0100000.0100000.0100000.0100000.0100000.0250000.0230000.0230000.0230000.0230000.0230000.02000000.0總費(fèi)用率0%261%161%77%65%61%57%56%46%43%41%40%50%費(fèi)用總額210000.0130500.0161000.0344500.0518000.0610000.01028000.0845000.01380000.

14、01515000.01640000.01528000.09910000.0利潤(rùn)凈毛利率（不含后臺(tái)成本）0.0%236.0%126.0%36.6%24.8%16.0%7.1%3.7%24.0%26.7%9.0%29.8%10.5%含稅凈毛利額210000.0118000.0126000.0164500.0198000.0160000.0128000.055000.0720000.0935000.0360000.01132000.02097

15、500.0不含稅凈毛利額179487.2100854.7107692.3140598.3169230.8136752.1109401.747008.5615384.6799145.3307692.3967521.41792735.0注：1、從20172017年8月起開始進(jìn)入盈虧平衡，前期現(xiàn)金流出14065001406500元，因此所需現(xiàn)金資本設(shè)定為150150萬(wàn)元。2、20002000萬(wàn)的銷售額按年周轉(zhuǎn)率8次計(jì)算，貨物資本設(shè)定為2502

16、50萬(wàn)。兩者合并總投入最大資金規(guī)模設(shè)定為400400萬(wàn)。20172017年度電商項(xiàng)目經(jīng)營(yíng)預(yù)算分析表科目20172017年1月20172017年2月20172017年3月20172017年4月20172017年5月20172017年6月20172017年7月20172017年8月20172017年9月20172017年1010月20172017年1111月20172017年1212月20172017年1月20172017年1212月總合計(jì)

17、收入含稅銷售額0.050000.0100000.0450000.0800000.01000000.01800000.01500000.03000000.03500000.04000000.03800000.020000000.0未稅銷售額0.042735.085470.1384615.4683760.7854700.91538461.51282051.32564102.62991453.03418803.43247863.2170940

18、17.1含稅成本0.037500.065000.0270000.0480000.0550000.0900000.0600000.0900000.01050000.02000000.01140000.07992500.0未稅成本0.032051.355555.6230769.2410256.4470085.5769230.8512820.5769230.8897435.91709401.7974359.06831196.6毛利率0.0%2

19、5.0%35.0%40.0%40.0%45.0%50.0%60.0%70.0%70.0%50.0%70.0%60.0%含稅毛利額0.012500.035000.0180000.0320000.0450000.0900000.0900000.02100000.02450000.02000000.02660000.012007500.0未稅毛利額0.010683.829914.5153846.2273504.3384615.4769230.

20、8769230.81794871.82094017.11709401.72273504.310262820.5費(fèi)用平臺(tái)費(fèi)用率0.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.6%保證金率(只支付第一年）0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.3%平臺(tái)使用年費(fèi)率0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0

21、%0.0%0.0%0.0%0.3%平臺(tái)傭金扣點(diǎn)率5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%推廣費(fèi)率6.0%46.0%46.0%39.3%37.3%36.0%28.2%26.0%23.3%21.7%20.3%19.2%24.0%淘內(nèi)推廣費(fèi)率0.0%40.0%40.0%33.3%31.3%30.0%22.2%20.0%17.3%15.7%14.3%13.2%18.0%淘外推廣費(fèi)率

22、6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%物流倉(cāng)儲(chǔ)費(fèi)用率物流損耗費(fèi)率6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%物流費(fèi)率5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%5.0%損耗費(fèi)率1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0%1.0

23、%1.0%1.0%倉(cāng)儲(chǔ)費(fèi)率4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%管理費(fèi)用率0.0%200.0%100.0%22.2%12.5%10.0%13.9%15.3%7.7%6.6%5.8%6.1%10.0%平臺(tái)費(fèi)用額110000.02500.05000.022500.040000.050000.090000.075000.0150000.0175000.0200000.01900

24、00.01110000.0保證金(只支付第一年）50000.00.00.00.00.00.00.00.00.00.00.00.050000.0平臺(tái)使用年費(fèi)60000.00.00.00.00.00.00.00.00.00.00.00.060000.0平臺(tái)傭金扣點(diǎn)0.02500.05000.022500.040000.050000.090000.075000.0150000.0175000.0200000.0190000.01000000.

25、0推廣費(fèi)0.023000.046000.0177000.0298000.0360000.0508000.0390000.0700000.0760000.0810000.0728000.04800000.0淘內(nèi)推廣費(fèi)0.020000.040000.0150000.0250000.0300000.0400000.0300000.0520000.0550000.0570000.0500000.03600000.0淘外推廣費(fèi)0.03000.06

26、000.027000.048000.060000.0108000.090000.0180000.0210000.0240000.0228000.01200000.0物流倉(cāng)儲(chǔ)費(fèi)用物流損耗費(fèi)0.03000.06000.027000.048000.060000.0108000.090000.0180000.0210000.0240000.0228000.01200000.0物流費(fèi)0.02500.05000.022500.040000.0500

27、00.090000.075000.0150000.0175000.0200000.0190000.01000000.0損耗費(fèi)0.0500.01000.04500.08000.010000.018000.015000.030000.035000.040000.038000.0200000.0倉(cāng)儲(chǔ)費(fèi)0.02000.04000.018000.032000.040000.072000.060000.0120000.0140000.0160000

28、.0152000.0800000.0管理費(fèi)用100000.0100000.0100000.0100000.0100000.0100000.0250000.0230000.0230000.0230000.0230000.0230000.02000000.0總費(fèi)用率0%261%161%77%65%61%57%56%46%43%41%40%50%費(fèi)用總額210000.0130500.0161000.0344500.0518000.061000

29、0.01028000.0845000.01380000.01515000.01640000.01528000.09910000.0利潤(rùn)凈毛利率（不含后臺(tái)成本）0.0%236.0%126.0%36.6%24.8%16.0%7.1%3.7%24.0%26.7%9.0%29.8%10.5%含稅凈毛利額210000.0118000.0126000.0164500.0198000.0160000.0128000.055000.0720000.09

30、35000.0360000.01132000.02097500.0不含稅凈毛利額179487.2100854.7107692.3140598.3169230.8136752.1109401.747008.5615384.6799145.3307692.3967521.41792735.0注：1、從20172017年8月起開始進(jìn)入盈虧平衡，前期現(xiàn)金流出14065001406500元，因此所需現(xiàn)金資本設(shè)定為150150萬(wàn)元。2、200020