Marketing Excel Template

Marketing Excel Template - 12/16/2009

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
12/16/2009 fbd546932d07612e1463c69bf892a5904c4ddda5.xls Confidential Page 1 Sales Source Analysis [ ] Use this form to track your marketing effectivity by summarizing sales revenue generated by each activity. You can use the Source Code Master List template to organize your marketing activities. Then, transfer the Source name and source code to the spaces provided below. Enter your data into the unprotected cells in blue. Enter the month that the activity took place, or the month the publication was released. Enter the sales revenues generated and their appropriate expenses. Sales Source A Vehicle Month Code Jan Feb Mar Apr May Jun Advertising Publication #1 Dec-90 1078 $372 $400 $244 $288 $0 $0 Feb-91 1098 $0 $0 $8,272 $1,584 $369 $0 May-91 1065 $0 $0 $0 $0 $0 $0 Total Revenue $372 $400 $8,516 $1,872 $369 $0 Expenses $3,750 $0 $0 $3,750 $0 $0 Net Income ($3,378) $400 $8,516 ($1,878) $369 $0 Publication #2 May-91 1120 $0 $0 $0 $0 $0 $0 Total Revenue $0 $0 $0 $0 $0 $0 Expenses $0 $0 $0 $0 $0 $0 Net Income $0 $0 $0 $0 $0 $0 Publication #3 Feb-91 1106 $0 $129 $1,012 $0 $0 $0 Total Revenue $0 $129 $1,012 $0 $0 $0 Expenses $1,000 $0 $0 $0 $0 $0 Net Income ($1,000) $129 $1,012 $0 $0 $0
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
12/16/2009 fbd546932d07612e1463c69bf892a5904c4ddda5.xls Confidential Page 2 Sales Source A Vehicle Month Code Jan Feb Mar Apr May Jun Radio Spot #1 Jan-91 1111 $0 $1,250 $1,025 $0 $0 $0 Total Revenue $0 $1,250 $1,025 $0 $0 $0 Expenses $2,625 $0 $0 $0 $0 $0 Net Income ($2,625) $1,250 $1,025 $0 $0 $0 TV Spot #1 May-91 1175 $0 $4,300 $5,600 $0 $0 $0 Total Revenue $0 $4,300 $5,600 $0 $0 $0 Expenses $10,000 $0 $0 $0 $0 $0 Net Income ($10,000) $4,300 $5,600 $0 $0 $0 Total Advertising Revenue $372 $6,079 $16,153 $1,872 $369 $0 Total Advertising Expense $17,375 $0 $0 $3,750 $0 $0 Total Advertising Net Income ($17,003) $6,079 $16,153 ($1,878) $369 $0
Background image of page 2
12/16/2009 fbd546932d07612e1463c69bf892a5904c4ddda5.xls Confidential Page 3 Sales Source A Vehicle Month Code Jan Feb Mar Apr May Jun Alliances Company 1 Jan-91 N/A $0 $8,969 $2,315 $0 $0 $0 Feb-91 N/A $0 $0 $13,913 $158 $198 $653 Total Revenue $0 $8,969 $16,228 $158 $198 $653 Expenses $0 $8,340
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

Marketing Excel Template - 12/16/2009

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online