Ivey Publishing
Professional Media Inc.
Product Number:
9B13E004
Publication Date:
02/26/2013
Revised Date:
02/26/2013
Length:
4 pages (3 pages of text)
Product Type:
Case (Gen Exp)
Source:
Ivey
A media planner at a specialized media buying firm was in the process of planning the spring 2012 television campaign for a customer with a recognizable brand name. The campaign budget of $7 million was to be spent on seven weeks of advertising during the first 20 weeks of the year. Each week of advertising involved a carefully selected series of advertisements on network and local television, and each week of advertising cost $1 million. Which seven of the 20 weeks should the planner choose? Is the $7 million budget the correct amount?
Learning Objective:
This case provides a good introduction to Excel modelling in a fairly simple business situation where building the model is more difficult than it looks initially. It has been used successfully at undergraduate, MBA and EMBA levels and provides strong motivation for the student to develop some proficiency in Excel and modelling.
Issues:
Disciplines:
Management Science
Industries:
Information, Media & Telecommunications
Setting:
Canada, 2012
Intended Audience:
Undergraduate/MBA
Price:
$4.25 CAD / $4.25 USD Printed Copy
$3.75 CAD / $3.75 USD Permissions
$3.75 CAD / $3.75 USD Digital Download
You Might Also Like...

Save In: