PLEASE READ AND FOLLOW INSTRUCTIONS. Do not make up your own INSTRUCTIONS!!!!!

profilesunnyday62
bus599assignment_wk6msexcelworksheet_2ndtime.xlsx
Home>Business & Finance homework help>PLEASE READ AND FOLLOW INSTRUCTIONS. Do not make up your own INSTRUCTIONS!!!!!

Sheet1

ANNUAL MARKETING BUDGET SHIRLEY'S BEVERAGE COMPANY
DEPARTMENT OF MARKETING
JAN FEB MARCH APRIL MAY JUNE JULY AUG SEPT OCT NOV DEC
MARKETING RESEARCH & MEMBERSHIP
ANALYST FEE
Analist member#1 $100 $100 $0 $100 $0 $100 $100 $100 $100 $0 $0 $0
Analist member#2 $100 $100 $0 $100 $0 $100 $100 $100 $100 $0 $0 $0
INDUSTRIAL ORG. FEES
Industrial org#1 $0 $0 $0 $300 $0 $0 $100 $0 $0 $0 $0 $500
MARKETING COMMUNICATION
Corporate brand development
Brand framework $500 $0 $0 $0 $0 $500 $0 $0 $0 $0 $0 $500
corporate identity standards $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $800
Sales presentation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $800
MARKETING AGENCY
Management fees $0 $0 $0 $600 $0 $0 $0 $0 $800 $0 $0 $400
PUBLIC RELATIONSHIP
Agency fee $300 $0 $0 $0 $0 $300 $0 $0 $0 $0 $0 $0
Annalyst tour $500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Article reprinting/usage rights $800 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Pr compaign support $800 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
BRAND ASWARENES
Print advertisement
Bronchure $200 $0 $0 $0 $0 $200 $0 $0 $0 $0 $0 $0
Fliers $0 $0 $150 $0 $0 $150 $0 $0 $0 $0 $0 $0
Newspapers $300 $0 $0 $0 $0 $300 $0 $0 $0 $0 $0 $0
Magazines $0 $0 $0 $0 $0 $0 $0 $100 $0 $0 $0 $0
Letters $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Online advertisement
Facebook $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Twitter $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Blogging $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
You Tube $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
e-mail $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Exhibitions $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Events
Event#1 $0 $0 $300 $0 $0 $0 $0 $0 $0 $0 $0 $0
Event#2 $0 $0 $0 $0 $0 $0 $300 $0 $0 $0 $0 $300
Others
Radio $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Television $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
MONTHLY TOTALS $4,700 $1,300 $1,600 $2,200 $1,100 $2,750 $1,700 $1,400 $2,100 $1,200 $1,100 $4,450
T0TAL ANNUAL COST $25,600