销量费用预算表带公式

20XX年度营销费用预算表XX有限公司营销中心,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

分类,项目,,"预定

年度

目标",比率%,合计费用,月度分配,,,,,,,,,,,,,,,,,,,,,,,,合计,

,,,,,,1月,,2月,,3月,,4月,,5月,,6月,,7月,,8月,,9月,,10月,,11月,,12月,,,

,,,,,,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用,目标,费用

固定费用,销售人员费用,基本薪资,3000,2.956%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,综合绩效,3000,0.124%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,住宿补贴,3000,1.224%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,出差餐补,3000,0.136%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,公交补贴,3000,0.136%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,通讯补贴,3000,0.142%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,区间费用,3000,0.324%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,月度提成,3000,1.237%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,年度提成,3000,0.507%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,固定经费,保险费,3000,,94680,80,,96,,166,,166,,226,9994,315,9994,288,9994,288,9994,290,9994,375,9994,350,9994,360,9994,,

,,物流费用,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,保险费,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,其他,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,小计,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

变动费用,销售佣金,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,运费,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,包装费,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,保险费,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,燃料费,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,广告宣传费,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,促销费,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,消费品费,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,其他,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,小计,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

合计,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,基本薪资,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,月度提成,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,年度提成,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,综合绩效,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,住宿补贴,,,,,,,,,,,,,,,,,,,,,,,,,,,,,