Manage meetings

profileJasjeet
Meetingpaperexample4-marketingbudget1.xlsx
Home>Business & Finance homework help>Management homework help>Manage meetings

Channel Marketing Budget

La Bonne Assiette Marketing Budget
Rate Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Total
ANTICIPATED SALES TOTAL $(000) 750 200 500 1,500 1,200 1,500 1,500 1,800 2,000 2,000 2,000 2,000 16,950
PERSONNEL (% OF TOTAL SALES) 110% 110% 110% 110% 110% 110% 110% 110% 85% 85% 85% 85%
Human Resources - Headcount 5 5 5 5 5 5 5 5 5 5 5 5 5
Human Resources - Cost 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 25.00 300.00
Commission 0.10% 0.75 0.20 0.50 1.50 1.20 1.50 1.50 1.80 2.00 2.00 2.00 2.00 16.95
Personnel Total $(000) 25.75 25.20 25.50 26.50 26.20 26.50 26.50 26.80 27.00 27.00 27.00 27.00 316.95
DIRECT MARKETING (% OF TOTAL SALES) 100% 100% 75% 40% 33% 25% 20% 10% 5% 5% 5% 5%
Telemarketing (% of Direct Sales) 100% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50% 50%
Human Resources - Headcount 3 3 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5 19.50
Infrastructure Support 25 10 25 10 25 10 25 10 25 10 25 10 210.00
Commission 0.10% 0.75 0.10 0.19 0.30 0.20 0.19 0.15 0.09 0.05 0.05 0.05 0.05 2.16
Training 25 10 25 10 25 10 25 10 25 10 25 10 210.00
Telemarketing Total $(000) 53.75 21.60 51.69 21.80 51.70 21.69 51.65 21.59 51.55 21.55 51.55 21.55 441.66
Internet Marketing (% of Direct Sales) 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25% 25%
Human Resources - Headcount 1 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 3.00
Website Development (one-time cost) 500 500.00
Hosting 10 10 10 10 10 10 10 10 10 10 10 10 120.00
Support & Maintenance 25 25 50.00
Internet Marketing Total $(000) 535.25 10.25 10.25 10.25 10.25 10.25 10.25 10.25 10.25 10.25 35.25 10.25 673.00
Direct Mail (% of Direct Sales)
Human Resources - Cost 0.00
Material 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 12,000.00
Postage 250 250 250 250 250 250 250 250 250 250 250 250 3,000.00
Direct Mail Total $(000) 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 1,250.00 15,000.00
Direct Marketing Total $(000) 1,839.00 1,281.85 1,311.94 1,282.05 1,311.95 1,281.94 1,311.90 1,281.84 1,311.80 1,281.80 1,336.80 1,281.80 16,114.66
AGENT/BROKER (% OF TOTAL SALES) 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10% 10%
Communication 50 50 50 50 50 50 50 50 50 50 50 50 600.00
Training 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00
Promotions 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 7,200.00
Discounts 10.00% 7.50 2.00 5.00 15.00 12.00 15.00 15.00 18.00 20.00 20.00 20.00 20.00 169.50
Commission (% of Agent's Sales) 10.00% 7.50 2.00 5.00 15.00 12.00 15.00 15.00 18.00 20.00 20.00 20.00 20.00 169.50
Agent/Broker Total $(000) 915.00 904.00 910.00 930.00 924.00 930.00 930.00 936.00 940.00 940.00 940.00 940.00 11,139.00
DISTRIBUTORS (% OF TOTAL SALES) 0% 0% 0% 0% 0% 15% 20% 40% 40% 40% 40% 40%
Communication 50 50 50 50 50 50 50 50 50 50 50 50 600.00
Training 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00
Promotions 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 7,200.00
Commission/Discounts (% of Distributors' Sales) 15.00% 0 0 0 0 0 33.75 45 108 120 120 120 120 666.75
Distributor Total $(000) 900.00 900.00 900.00 900.00 900.00 933.75 945.00 1,008.00 1,020.00 1,020.00 1,020.00 1,020.00 11,466.75
RETAILER (% OF TOTAL SALES) 0% 0% 25% 60% 67% 60% 60% 50% 30% 30% 30% 30%
Communication 50 50 50 50 50 50 50 50 50 50 50 50 600.00
Training 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00
Promotions 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 600.00 7,200.00
Commission/Discounts (% of Retail Sales) 10.00% 0 0 12.5 90 80.4 90 90 90 60 60 60 60 692.90
Retailer Total $(000) 900.00 900.00 912.50 990.00 980.40 990.00 990.00 990.00 960.00 960.00 960.00 960.00 11,492.90
CUSTOMER ACQUISITION & RETENTION (CAR)
Human Resources 50 50 50 50 50 50 50 50 50 50 50 50 600.00
Communications 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00
Promotions/Coupons 600 600 600 600 600 600 600 600 600 600 600 600 7,200.00
CAR Total $(000) 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 10,800.00
OTHER EXPENSES
Travel 50 50 50 50 50 50 50 50 50 50 50 50 600.00
Infrastructure (computer, telephone, etc.) 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 250.00 3,000.00
Channel Support 600 600 600 600 600 600 600 600 600 600 600 600 7,200.00
Other Expenses Total $(000) 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 900.00 10,800.00
TOTAL MARKETING BUDGET: 6,379.75 5,811.05 5,859.94 5,928.55 5,942.55 5,962.19 6,003.40 6,042.64 6,058.80 6,028.80 6,083.80 6,028.80 72,130.26