銷量費(fèi)用預(yù)算表帶公式

20XX年度營(yíng)銷費(fèi)用預(yù)算表XX有限公司營(yíng)銷中心,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

分類,項(xiàng)目,,"預(yù)定

年度

目標(biāo)",比率%,合計(jì)費(fèi)用,月度分配,,,,,,,,,,,,,,,,,,,,,,,,合計(jì),

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

,,,,,,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用,目標(biāo),費(fèi)用

固定費(fèi)用,銷售人員費(fèi)用,基本薪資,3000,2.956%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,綜合績(jī)效,3000,0.124%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,住宿補(bǔ)貼,3000,1.224%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,出差餐補(bǔ),3000,0.136%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,公交補(bǔ)貼,3000,0.136%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,通訊補(bǔ)貼,3000,0.142%,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,,區(qū)間費(fèi)用,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,,,

,固定經(jīng)費(fèi),保險(xiǎn)費(fèi),3000,,94680,80,,96,,166,,166,,226,9994,315,9994,288,9994,288,9994,290,9994,375,9994,350,9994,360,9994,,

,,物流費(fèi)用,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,,,

,,保險(xiǎn)費(fèi),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,,,

,,小計(jì),3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

變動(dòng)費(fèi)用,銷售傭金,,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,運(yùn)費(fèi),,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,包裝費(fèi),,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,保險(xiǎn)費(fèi),,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,燃料費(fèi),,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,廣告宣傳費(fèi),,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,促銷費(fèi),,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

,消費(fèi)品費(fèi),,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,,,

,小計(jì),,3000,,,80,,96,,166,,166,,226,,315,,288,,288,,290,,375,,350,,360,,,

合計(jì),,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,基本薪資,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

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

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

,綜合績(jī)效,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

,住宿補(bǔ)貼,,,,,,,,,,,,,,,,,,,,,,,,,,,,,