营销部费用预算（带公式）Excel模板

营销推广计划费用预算,,,,,,,,,,,,,,,,,,,,

序号,项目名称,具体内容,数量,备注,一月,二月,三月,四月,五月,六月,七月,八月,九月,十月,十一月,十二月,一月,二月,合计,

1,办公用品采购,新近员工配备电脑,4,策划1、文案1、销售助理2人（原有ibm或新购替换）,12000,,20000,20000,,,,,,,,,,,"52,000","608,500"

2,,平面设计配备设计电脑,1,新购组装设计平台,11000,,,,,,,,,,,,,,"11,000",

3,,设计用彩色喷墨打印机,1,带外供墨系统、彩喷纸,4000,,,2000,,,,,,,,,,,"6,000",

4,,营销中心激光打印机,1,较高强度打印,4000,,,,,,,,,,,,,,"4,000",

5,,营销中心传真机,1,办公用,500,,,1000,,,,,,,,,,,"1,500",

6,,业务用数码照相机,2,营销中心调研+产品部考察各1部,4000,,,4000,,,,,,,,,,,"8,000",

7,,投影仪,1,,6000,,,,,,,,,,,,,,"6,000",

8,,网站设计制作费首年上线,1,,,300000,,,,,10000,,,,10000,10000,,,"330,000",

9,,设计费部分进度款,2,产品手册、公司手册、vi系统、招商单页,50000,,30000,,30000,,30000,,,,,,,,"140,000",

10,,oa软件采购,1,,50000,,,,,,,,,,,,,,"50,000",

11,posm,3省上市发布、卖场用的大堆头用广告POP，宣传贴、促销品样品、路演道具、posm,3,上市阶段分段、分批量制作,,,150000,160000,350000,,,,,,,,,,"660,000","2,610,000.00"

12,,门头制作,3,,,,80000,150000,150000,80000,150000,150000,100000,80000,50000,,80000,80000,"1,150,000",

13,,企业手册、产品手册、招商单页、三折页制作费,3,上市阶段分段、分批量制作,,,40000,,40000,,50000,,,20000,,,,,"150,000",

14,,西安糖酒会展位装修促进物,1,前期定金、装修、广告物料制作,250000,,,,,200000,,,,,,,200000,,"650,000",

15,宣传与推广,广告--报纸，杂志,3,,,,80000,80000,,30000,80000,80000,30000,30000,30000,10000,30000,30000,"510,000","3,500,000.00"

16,,广告--网络首页广告,3,,,,50000,50000,50000,,100000,132000,50000,18000,25000,,10000,10000,"495,000",

17,,广告--公交车身广告，站台媒体，语音提示,3,,,,180000,180000,100000,100000,200000,200000,80000,80000,,,80000,80000,"1,280,000",

18,,广告--电梯广告,3,分众传媒,,,,,,,100000,100000,100000,,,,,,"300,000",

19,,广告--交通电台,3,,,,30000,30000,30000,30000,50000,30000,30000,30000,30000,10000,30000,30000,"360,000",

20,,推广--公关关系费,3,政府公关关系,,300000,,,,,,,,,,,,,"300,000",

21,,推广--上市发布会,3,户外秀,,,30000,,,,,,30000,,,,,,"60,000",

22,,企业专题片拍摄费,1,企业招商用,,15000,,,,,,,,,,,,,"15,000",

23,,网络推广费基础,3,,,,,,,,20000,20000,20000,20000,,,,,"80,000",

24,,网络活动奖品推广费,3,,,,,,,,50000,50000,,,,,,,"100,000",

25,渠道费用,样板街,3,,,,50000,60000,60000,60000,150000,150000,150000,150000,,,150000,150000,"1,130,000","2,000,000.00"

26,,形象店,3,,,,20000,20000,10000,10000,35000,35000,50000,50000,,,50000,50000,"330,000",

27,,进店费用,3,,,,,,,,50000,100000,,,,,,,"150,000",

28,,陈列费,3,,,,,,,,100000,200000,,,,,,,"300,000",

29,,条码费,3,,,,,,,,30000,60000,,,,,,,"90,000",

30,促销,渠道促销,3,,,,60000,60000,60000,60000,60000,100000,200000,,,,,,"600,000","4,080,000.00"

31,,餐饮进店费,3,,,,300000,300000,300000,70000,70000,70000,70000,70000,70000,70000,70000,70000,"1,530,000",

32,,消费者买赠促销,3,,,,50000,100000,100000,100000,150000,150000,150000,150000,,,150000,150000,"1,250,000",

33,,主题活动促销,3,,,,200000,,,100000,200000,,200000,,,,,,"700,000",

34,差旅与招待,差旅费,3,,30000,10000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,30000,"400,000","518,000"

35,,招待费,3,,3000,3000,5000,3000,3000,3000,10000,3000,10000,15000,15000,15000,15000,15000,"118,000",

36,合计,,,,424500,628000,1405000,1250000,1313000,873000,1725000,1660000,1300000,743000,260000,145000,895000,695000,"￥13,316,500.00",

注：以上预算不含人员工资与提成奖励和电视媒体广告。推广计划整体呈现m型推广，渡过前期3-4个月铺货期后，开始在人流高峰9-12月进行集中投放。,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,,,,,

,制表：审核：批准：,,,,,,