Marketing Excel Template

Marketing Excel Template - Advertising Costs Planning...

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

View Full Document Right Arrow Icon
Advertising Costs Planning Worksheet A. Cost per thousand: Magazines B. Cost per thousand estimates refined: Magazines Magazine 1 Magazine 2 Scenario 1: Without pass-along rate Per page cost $0 $0 Target market 18-49 Circulation 0 0 Magazine circulation 4,500,000 Cost Per Thousand #DIV/0! #DIV/0! Circulation to target market 65% Cost per page $135,000 C. TV ads: Cost per ratings point Cost per thousand $30.00 Show 1 Show 2 Cost per thousand for actual target market $46.15 Cost per spot ad $0.00 $0.00 Rating 0 0 Scenario 2: With pass-along rate Reach (total persons) 0 0 Target market 18-49 Cost Per Ratings Point #DIV/0! #DIV/0! Magazine circulation 4,500,000 Cost per page $135,000 D. Milline rate comparison - Newspapers Pass-along rate 3 Newspaper 1 Newspaper 2 % of households for pass-along rate 33% Cost per page $0.00 $0.00 Cost per thousand (based on readers per copy) $15.08 Cost per line $0.00 $0.00 Circulation 0 0 Milline rate #DIV/0! #DIV/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
Sheet2 Page 2 Operation Revenues and Cost Planning Worksheet
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/15/2009 for the course UGBA 106 taught by Professor Robinson during the Fall '07 term at Berkeley.

Page1 / 2

Marketing Excel Template - Advertising Costs Planning...

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

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