2018年度电商项目经营财务预算分析表

Sheet12018年度电商项目经营预算分析表科目公式43,10143,13243,16043,19143,22143,25241,61043,28243,31343,34443,37443,40543,4352018年1月-2018年12月总合计收入含税销售额AA560,000.045,000.01,200,000.01,450,000.01,800,000.023,000,000.028,055,000.05,800,000.06,500,000.013,000,000.013,500,000.04,000,000.03,800,000.074,655,000.0未税销售额A1A/1.17478,632.538,461.51,025,641.01,239,316.21,538,461.519,658,119.723,978,632.54,957,265.05,555,555.611,111,111.111,538,461.53,418,803.43,247,863.263,807,692.3含税成本A2A*(1-B)504,000.040,500.0780,000.0870,000.01,080,000.012,650,000.015,924,500.02,900,000.02,600,000.03,900,000.04,050,000.02,000,000.01,140,000.032,514,500.0未税成本A3A2/1.17430,769.234,615.4666,666.7743,589.7923,076.910,811,965.813,610,683.82,478,632.52,222,222.23,333,333.33,461,538.51,709,401.7974,359.027,790,170.9毛利率BB10.0%10.0%35.0%40.0%40.0%45.0%43.2%50.0%60.0%70.0%70.0%50.0%70.0%56.4%含税毛利额B1A*B