Assignment 3 Part 2: Business Plan – Draft

profileaveclem
wefit_budget.xlsx
Home>Business & Finance homework help>Assignment 3 Part 2: Business Plan – Draft

Sheet2

Marketing Budget Year: 2016-2017
WeFit Diet Drink
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 TOTAL
STAFF OR SERVICES (I.E. CONSULTING)
Salaries $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $7,000 $7,000 $7,000 $7,000 $68,000
Benefits $700 $700 $700 $700 $700 $700 $700 $700 $1,200 $1,200 $1,200 $1,200 $10,400
STAFF SUBTOTAL $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $5,700 $8,200 $8,200 $8,200 $8,200 $78,400
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 TOTAL
BRAND
Letterhead $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $480
Envelopes $12 $12 $12 $12 $12 $12 $12 $12 $12 $12 $12 $12 $144
Business Cards $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $40 $480
Presentation Folders $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $600
BRAND SUBTOTAL $142 $142 $142 $142 $142 $142 $142 $142 $142 $142 $142 $142 $1,704
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 TOTAL
MARKETING MATERIALS (COLLATERAL)
Brochures/Datasheets Printing $0 $800 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $800
Content Development (Whitepapers/Brochures) $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000
White Papers $0 $40 $0 $40 $0 $40 $0 $40 $0 $40 $0 $40 $240
Collateral Design $600 $0 $0 $600 $0 $0 $600 $0 $0 $600 $0 $0 $2,400
MARKETING MATERIALS SUBTOTAL $1,100 $1,340 $500 $1,140 $500 $540 $1,100 $540 $500 $1,140 $500 $540 $9,440
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 TOTAL
WEBSITE
Hosting $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $30 $360
Design/Development $4,500 $4,500
Enewsletter Distribution $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $1,200
Search Engine Submission $0 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $66
WEBSITE SUBTOTAL $4,630 $136 $136 $136 $136 $136 $136 $136 $136 $136 $136 $136 $6,126
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 TOTAL
PUBLIC RELATIONS
Press Releases $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $1,200
Media Relations $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,400
Wire Fees $80 $80 $80 $80 $80 $80 $80 $80 $80 $80 $80 $80 $960
Press Kits $250 $0 $250 $0 $250 $0 $250 $0 $250 $0 $250 $0 $1,500
PUBLIC RELATIONS SUBTOTAL $630 $380 $630 $380 $630 $380 $630 $380 $630 $380 $630 $380 $6,060
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 TOTAL
PROMOTIONS
Advertising $400 $0 $1,200 $800 $1,200 $900 $1,100 $1,000 $1,200 $1,200 $1,200 $1,200 $11,400
Events $0 $0 $900 $0 $0 $700 $0 $0 $0 $0 $0 $0 $1,600
Promo Items $0 $0 $300 $0 $0 $0 $0 $0 $0 $0 $0 $0 $300
Direct Mail (print and email) $60 $60 $130 $130 $100 $250 $0 $80 $400 $250 $0 $100 $1,560
Webinar $0 $0 $50 $0 $0 $0 $300 $0 $0 $0 $300 $0 $650
Social Media $0 $0 $55 $55 $55 $55 $55 $55 $55 $55 $55 $55 $550
Telemarketing $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $6,000
Prospect Lists $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Google Adwords $0 $100 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $2,100
PROMOTIONS SUBTOTAL $960 $660 $3,335 $1,685 $2,055 $2,605 $2,155 $1,835 $2,355 $2,205 $2,255 $2,055 $24,160
Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 TOTAL
TOTAL $13,162 $8,358 $10,443 $9,183 $9,163 $9,503 $9,863 $8,733 $11,963 $12,203 $11,863 $11,453
Annual Total $125,890

Sheet3