年度项目经营预算分析表.xlsx

《年度项目经营预算分析表.xlsx》由会员分享，可在线阅读，更多相关《年度项目经营预算分析表.xlsx（6页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、20152015年年度度科科目目1 1月月2 2月月3 3月月收收入入含税销售额0.0 50,000.0 100,000.0 未税销售额0.0 42,735.0 85,470.1 含税成本0.0 37,500.0 65,000.0 未税成本0.0 32,051.3 55,555.6 毛毛利利率率0.0%25.0%35.0%含税毛利额0.0 12,500.0 35,000.0 未税毛利额0.0 10,683.8 29,914.5费费用用平平台台费费用用率率0.0%5.0%5.0%保证金率(只支付第一年）0.0%0.0%0.0%平台使用年费率0.0%0.0%0.0%平台佣金扣点率5.0%5.0%5

2、.0%推推广广费费率率6.0%46.0%46.0%淘内推广费率0.0%40.0%40.0%淘外推广费率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%200.0%100.0%平平台台费费用用额额110,000.0 2,500.0 5,000.0 保证金(只支付第一年）50,000.0 0.0 0.0 平台使用年费60,000.0 0.0 0.0 平台佣金扣点0.0 2,500.0 5,000.0 推推广广费费0.

3、0 23,000.0 46,000.0 淘内推广费0.0 20,000.0 40,000.0 淘外推广费0.0 3,000.0 6,000.0 物物流流仓仓储储费费用用物物流流损损耗耗费费0.0 3,000.0 6,000.0 物流费0.0 2,500.0 5,000.0 损耗费0.0 500.0 1,000.0 4 4月月5 5月月6 6月月7 7月月8 8月月9 9月月450,000.0 800,000.0 1,000,000.0 1,800,000.0 1,500,000.0 3,000,000.0 384,615.4 683,760.7 854,700.9 1,538,461.5 1,

4、282,051.3 2,564,102.6 270,000.0 480,000.0 550,000.0 900,000.0 600,000.0 900,000.0 230,769.2 410,256.4 470,085.5 769,230.8 512,820.5 769,230.8 40.0%40.0%45.0%50.0%60.0%70.0%180,000.0 320,000.0 450,000.0 900,000.0 900,000.0 2,100,000.0 153,846.2 273,504.3 384,615.4 769,230.8 769,230.8 1,794,871.8 5.0%

5、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%39.3%37.3%36.0%28.2%26.0%23.3%33.3%31.3%30.0%22.2%20.0%17.3%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%22.2%12.5%10.0%13.9%15.3%7.7

6、%22,500.0 40,000.0 50,000.090,000.0 75,000.0 150,000.0 0.0 0.0 0.00.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 22,500.0 40,000.0 50,000.0 90,000.0 75,000.0 150,000.0 177,000.0 298,000.0 360,000.0 508,000.0 390,000.0 700,000.0 150,000.0 250,000.0 300,000.0 400,000.0 300,000.0 520,000.0 27,000.0 48,000.0 60,00

7、0.0 108,000.0 90,000.0 180,000.0 27,000.048,000.0 60,000.0 108,000.0 90,000.0 180,000.0 22,500.0 40,000.0 50,000.0 90,000.0 75,000.0 150,000.0 4,500.0 8,000.0 10,000.0 18,000.0 15,000.0 30,000.0 20152015年年度度1010月月1111月月1212月月1 1月月-12-12月月总总合合计计3,500,000.0 4,000,000.0 3,800,000.0 20,000,000.0 2,991,4

8、53.0 3,418,803.4 3,247,863.2 17,094,017.1 1,050,000.0 2,000,000.0 1,140,000.0 7,992,500.0 897,435.9 1,709,401.7 974,359.0 6,831,196.6 70.0%50.0%70.0%60.0%2,450,000.0 2,000,000.0 2,660,000.0 12,007,500.0 2,094,017.1 1,709,401.7 2,273,504.3 10,262,820.5 5.0%5.0%5.0%5.6%0.0%0.0%0.0%0.3%0.0%0.0%0.0%0.3%

9、5.0%5.0%5.0%5.0%21.7%20.3%19.2%24.0%15.7%14.3%13.2%18.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%1.0%1.0%1.0%1.0%4.0%4.0%4.0%4.0%6.6%5.8%6.1%10.0%175,000.0 200,000.0 190,000.0 1,110,000.0 0.0 0.0 0.0 50,000.0 0.0 0.0 0.0 60,000.0 175,000.0 200,000.0 190,000.0 1,000,000.0 760,000.0 810,000.0 7

10、28,000.0 4,800,000.0 550,000.0 570,000.0 500,000.0 3,600,000.0 210,000.0 240,000.0 228,000.0 1,200,000.0 210,000.0 240,000.0 228,000.0 1,200,000.0 175,000.0 200,000.0 190,000.0 1,000,000.0 35,000.0 40,000.0 38,000.0 200,000.0 仓仓储储费费0.0 2,000.0 4,000.0 管管理理费费用用100,000.0 100,000.0 100,000.0 总总费费用用率率0%

11、261%161%费费用用总总额额210,000.0 130,500.0 161,000.0 利利润润净净毛毛利利率率（不不含含后后台台成成本本）0.0%-236.0%-126.0%含含税税净净毛毛利利额额-210,000.0-118,000.0-126,000.0 不不含含税税净净毛毛利利额额-179,487.2-100,854.7-107,692.3 注注：1 1、从从20152015年年8 8月月起起开开始始进进入入盈盈亏亏平平衡衡，前前期期现现金金流流出出14065001406500元元，因因此此所所需需现现金金资资本本设设定定为为150150万万元元。2 2、20002000万万的的销

12、销售售额额按按年年周周转转率率8 8次次计计算算，货货物物资资本本设设定定为为250250万万。两两者者合合并并总总投投入入最最大大资资金金规规模模设设定定为为400400万万。18,000.0 32,000.0 40,000.0 72,000.0 60,000.0 120,000.0 100,000.0 100,000.0 100,000.0 250,000.0 230,000.0 230,000.0 77%65%61%57%56%46%344,500.0 518,000.0 610,000.0 1,028,000.0 845,000.0 1,380,000.0-36.6%-24.8%-16

13、.0%-7.1%3.7%24.0%-164,500.0-198,000.0-160,000.0-128,000.0 55,000.0 720,000.0-140,598.3-169,230.8-136,752.1-109,401.7 47,008.5 615,384.6 1 1、从从20152015年年8 8月月起起开开始始进进入入盈盈亏亏平平衡衡，前前期期现现金金流流出出14065001406500元元，因因此此所所需需现现金金资资本本设设定定为为150150万万元元。140,000.0 160,000.0 152,000.0 800,000.0 230,000.0 230,000.0 230,000.0 2,000,000.0 43%41%40%50%1,515,000.0 1,640,000.0 1,528,000.0 9,910,000.0 26.7%9.0%29.8%10.5%935,000.0 360,000.0 1,132,000.0 2,097,500.0 799,145.3 307,692.3 967,521.4 1,792,735.0