资源描述：
《2018年度电商项目经营财务预算分析表.xls》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
2018年科目2018年1月2018年2月2018年3月含税销售额560,000.045,000.01,200,000.0未税销售额478,632.538,461.51,025,641.0含税成本504,000.040,500.0780,000.0收未税成本430,769.234,615.4666,666.7入毛利率10.0%10.0%35.0%含税毛利额56,000.04,500.0420,000.0未税毛利额47,863.23,846.2358,974.4平台费用率0.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.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.0用保证金(只支付第一年）50,000.00.00.0平台使用年费60,000.00.00.0平台佣金扣点28,000.02,250.060,000.0推广费33,600.022,700.0112,000.0淘内推广费0.020,000.040,000.0淘外推广费33,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.048,000.0管理费用100,000.0100,000.0100,000.0总费用率0%288%33%费用总额327,600.0129,450.0392,000.0净毛利率（不含后台成本）0.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万元。
2、2000万的销售额按年周转率8次计算，货物资本设定为250万。两者合并总投入最大资金规模设定为400万。
2018年度电商项目经营预算分析表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,957,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,333.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%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.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%27%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.81、从2018年8月起开始进入盈亏平衡，前期现金流出1406500元，因此所需现金资本设定为150万元。
2018年度电商项目经营预算分析表2018年10月2018年11月2018年12月2018年1月-2018年12月总合计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%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.01,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
