2018年度電商項目經營財務預算分析表.pdf
下載文檔
上傳人:地**
編號:1290062
2024-12-17
54頁
429.68KB
1、2018 年 1月2018 年 2月2018 年 3月560,000.045,000.01,200,000.0478,632.538,461.51,025,641.0504,000.040,500.0780,000.0430,769.234,615.4666,666.710.0%10.0%35.0%56,000.04,500.0420,000.047,863.23,846.2358,974.40.0%5.0%5.0%0.0%0.0%0.0%0.0%0.0%0.0%5.0%5.0%5.0%6.0%50.4%9.3%0.0%44.4%3.3%6.0%6.0%6.0%物流損耗費率6.0%6.0%6.2、0%物流費率5.0%5.0%5.0%損耗費率1.0%1.0%1.0%倉儲費率4.0%4.0%4.0%0.0%222.2%8.3%138,000.02,250.060,000.050,000.00.00.060,000.00.00.028,000.02,250.060,000.033,600.022,700.0112,000.00.020,000.040,000.033,600.02,700.072,000.0物流損耗費33,600.02,700.072,000.0物流費28,000.02,250.060,000.0損耗費5,600.0450.012,000.0倉儲費22,400.01,800.3、048,000.0100,000.0100,000.0100,000.00%288%33%327,600.0129,450.0392,000.00.0%-277.7%2.3%-271,600.0-124,950.028,000.0-232,136.8-106,794.923,931.6注:1、從2018 年 8月起開始進入盈虧平衡,前期現金流出1406500元,因此所需現金資本設定為150 萬元??颇亢愪N售額未稅銷售額含稅成本未稅成本毛利率管理費用率平臺費用額保證金(只支付第一年)含稅毛利額未稅毛利額平臺費用率保證金率(只支付第一年)平臺使用年費率平臺傭金扣點率含稅凈毛利額不含稅凈毛利額收入4、費用利潤平臺使用年費平臺傭金扣點推廣費淘內推廣費淘外推廣費物流倉儲費用率物流倉儲費用總費用率費用總額凈毛利率(不含后臺成本)管理費用推廣費率淘內推廣費率淘外推廣費率 2、2000 萬的銷售額按年周轉率8次計算,貨物資本設定為250 萬。兩者合并總投入最大資金規模設定為400 萬。2018 年 4月2018 年 5月2018 年 6月2018 年 7月2018 年 8月2018 年 9月1,450,000.01,800,000.023,000,000.05,800,000.06,500,000.013,000,000.01,239,316.21,538,461.519,658,119.74,955、7,265.05,555,555.611,111,111.1870,000.01,080,000.012,650,000.02,900,000.02,600,000.03,900,000.0743,589.7923,076.910,811,965.82,478,632.52,222,222.23,333,333.340.0%40.0%45.0%50.0%60.0%70.0%580,000.0720,000.010,350,000.02,900,000.03,900,000.09,100,000.0495,726.5615,384.68,846,153.82,478,632.53,333,3336、.37,777,777.85.0%5.0%5.0%5.0%5.0%5.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%5.0%5.0%5.0%5.0%5.0%5.0%16.3%19.9%7.3%12.9%10.6%10.0%10.3%13.9%1.3%6.9%4.6%4.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%5.0%5.0%5.0%5.0%5.0%5.0%1.0%1.0%1.0%1.0%1.0%1.0%4.0%4.0%4.0%4.0%4.0%4.0%6.9%5.6%0.4%4.3%7、3.5%1.8%72,500.090,000.01,150,000.0290,000.0325,000.0650,000.00.00.00.00.00.00.00.00.00.00.00.00.072,500.090,000.01,150,000.0290,000.0325,000.0650,000.0237,000.0358,000.01,680,000.0748,000.0690,000.01,300,000.0150,000.0250,000.0300,000.0400,000.0300,000.0520,000.087,000.0108,000.01,380,000.0348,000.8、0390,000.0780,000.087,000.0108,000.01,380,000.0348,000.0390,000.0780,000.072,500.090,000.01,150,000.0290,000.0325,000.0650,000.014,500.018,000.0230,000.058,000.065,000.0130,000.058,000.072,000.0920,000.0232,000.0260,000.0520,000.0100,000.0100,000.0100,000.0250,000.0230,000.0230,000.038%40%23%32%29%29、7%554,500.0728,000.05,230,000.01,868,000.01,895,000.03,480,000.01.8%-0.4%22.3%17.8%30.8%43.2%25,500.0-8,000.05,120,000.01,032,000.02,005,000.05,620,000.021,794.9-6,837.64,376,068.4882,051.31,713,675.24,803,418.8此所需現金資本設定為150 萬元。2018 年度電商項目經營預算分析表2018 年 10 月2018 年 11 月2018 年 12 月2018 年 1月-2018年 12 月總10、合計13,500,000.04,000,000.03,800,000.074,655,000.011,538,461.53,418,803.43,247,863.263,807,692.34,050,000.02,000,000.01,140,000.032,514,500.03,461,538.51,709,401.7974,359.027,790,170.970.0%50.0%70.0%56.4%9,450,000.02,000,000.02,660,000.042,140,500.08,076,923.11,709,401.72,273,504.336,017,521.45.0%5.0%11、5.0%5.1%0.0%0.0%0.0%0.1%0.0%0.0%0.0%0.1%5.0%5.0%5.0%5.0%10.1%20.3%19.2%10.8%4.1%14.3%13.2%4.8%6.0%6.0%6.0%6.0%6.0%6.0%6.0%6.0%5.0%5.0%5.0%5.0%1.0%1.0%1.0%1.0%4.0%4.0%4.0%4.0%1.7%5.8%6.1%2.7%675,000.0200,000.0190,000.03,842,750.00.00.00.050,000.00.00.00.060,000.0675,000.0200,000.0190,000.03,732,750.012、1,360,000.0810,000.0728,000.08,079,300.0550,000.0570,000.0500,000.03,600,000.0810,000.0240,000.0228,000.04,479,300.0810,000.0240,000.0228,000.04,479,300.0675,000.0200,000.0190,000.03,732,750.0135,000.040,000.038,000.0746,550.0540,000.0160,000.0152,000.02,986,200.0230,000.0230,000.0230,000.02,000,000.027%41%40%29%3,615,000.01,640,000.01,528,000.021,387,550.043.2%9.0%29.8%27.8%5,835,000.0360,000.01,132,000.020,752,950.04,987,179.5307,692.3967,521.417,737,564.1