學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Professional Media Inc.
內容大綱
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?
學習目標
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.