電商店鋪年度電商項目經營預算分析表.xlsx
下載文檔
上傳人:地**
編號:1300881
2024-12-18
1頁
20.63KB
該文檔所屬資源包:
天貓淘寶電商公司店鋪運營數據績效考核記錄合作計劃表格模板
1、2017年度電商項目經營預算分析表科目2017年1月2017年2月2017年3月2017年4月2017年5月2017年6月2017年7月2017年8月2017年9月2017年10月2017年11月2017年12月2017年1月-2017年12月總合計收入含稅銷售額0.050,000.0100,000.0450,000.0800,000.01,000,000.01,800,000.01,500,000.03,000,000.03,500,000.04,000,000.03,800,000.020,000,000.0未稅銷售額0.042,735.085,470.1384,615.4683,760.2、7854,700.91,538,461.51,282,051.32,564,102.62,991,453.03,418,803.43,247,863.217,094,017.1含稅成本0.037,500.065,000.0270,000.0480,000.0550,000.0900,000.0600,000.0900,000.01,050,000.02,000,000.01,140,000.07,992,500.0未稅成本0.032,051.355,555.6230,769.2410,256.4470,085.5769,230.8512,820.5769,230.8897,435.91,7093、,401.7974,359.06,831,196.6毛利率0.0%25.0%35.0%40.0%40.0%45.0%50.0%60.0%70.0%70.0%50.0%70.0%60.0%含稅毛利額0.012,500.035,000.0180,000.0320,000.0450,000.0900,000.0900,000.02,100,000.02,450,000.02,000,000.02,660,000.012,007,500.0未稅毛利額0.010,683.829,914.5153,846.2273,504.3384,615.4769,230.8769,230.81,794,871.82,4、094,017.11,709,401.72,273,504.310,262,820.5費用平臺費用率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%平臺使用年費率0.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%平臺傭金扣點率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%推廣費率6.0%46.0%46.5、0%39.3%37.3%36.0%28.2%26.0%23.3%21.7%20.3%19.2%24.0%淘內推廣費率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%淘外推廣費率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%物流倉儲費用率物流損耗費率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%物流費率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.06、%損耗費率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%倉儲費率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%管理費用率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%平臺費用額110,000.02,500.05,000.022,500.040,000.050,000.090,000.075,000.0150,000.0175,000.0200,000.0190,000.01,110,000.0保證金(只7、支付第一年)50,000.00.00.00.00.00.00.00.00.00.00.00.050,000.0平臺使用年費60,000.00.00.00.00.00.00.00.00.00.00.00.060,000.0平臺傭金扣點0.02,500.05,000.022,500.040,000.050,000.090,000.075,000.0150,000.0175,000.0200,000.0190,000.01,000,000.0推廣費0.023,000.046,000.0177,000.0298,000.0360,000.0508,000.0390,000.0700,000.0760,8、000.0810,000.0728,000.04,800,000.0淘內推廣費0.020,000.040,000.0150,000.0250,000.0300,000.0400,000.0300,000.0520,000.0550,000.0570,000.0500,000.03,600,000.0淘外推廣費0.03,000.06,000.027,000.048,000.060,000.0108,000.090,000.0180,000.0210,000.0240,000.0228,000.01,200,000.0物流倉儲費用物流損耗費0.03,000.06,000.027,000.048,09、00.060,000.0108,000.090,000.0180,000.0210,000.0240,000.0228,000.01,200,000.0物流費0.02,500.05,000.022,500.040,000.050,000.090,000.075,000.0150,000.0175,000.0200,000.0190,000.01,000,000.0損耗費0.0500.01,000.04,500.08,000.010,000.018,000.015,000.030,000.035,000.040,000.038,000.0200,000.0倉儲費0.02,000.04,000.010、18,000.032,000.040,000.072,000.060,000.0120,000.0140,000.0160,000.0152,000.0800,000.0管理費用100,000.0100,000.0100,000.0100,000.0100,000.0100,000.0250,000.0230,000.0230,000.0230,000.0230,000.0230,000.02,000,000.0總費用率0%261%161%77%65%61%57%56%46%43%41%40%50%費用總額210,000.0130,500.0161,000.0344,500.0518,000.11、0610,000.01,028,000.0845,000.01,380,000.01,515,000.01,640,000.01,528,000.09,910,000.0利潤凈毛利率(不含后臺成本)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%含稅凈毛利額-210,000.0-118,000.0-126,000.0-164,500.0-198,000.0-160,000.0-128,000.055,000.0720,000.0935,000.0360,000.01,132,000.02,097,500.0不含稅凈毛利額-179,487.2-100,854.7-107,692.3-140,598.3-169,230.8-136,752.1-109,401.747,008.5615,384.6799,145.3307,692.3967,521.41,792,735.0注:1、從2017年8月起開始進入盈虧平衡,前期現金流出1406500元,因此所需現金資本設定為150萬元。2、2000萬的銷售額按年周轉率8次計算,貨物資本設定為250萬。兩者合并總投入最大資金規模設定為400萬。