OPIM 101 - Spring 2012 - Session 7

OPIM 101 - Spring 2012 - Session 7 - Introduction to the...

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

View Full Document Right Arrow Icon

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

View Full Document Right Arrow Icon

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

View Full Document Right Arrow Icon

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

View Full Document Right Arrow Icon

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

View Full Document Right Arrow Icon

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

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Introduction to the Computer as an Analysis Tool Session 7 1 m Introduction to Decision Models m Toy Industries Linear Programming Model Session 7: Modeling Business Decisions Introduction to the Computer as an Analysis Tool Session 7 2 Course Overview m Lecture slides and additional notes will be posted on Canvas m Software Ø MS Excel with the following Add-ins • Solver • Crystal Ball (to be installed later) Introduction to the Computer as an Analysis Tool Session 7 3 Course Workload m Optimization Homework 1 m Optimization Homework 2 m Simulation Homework m Recitations m Exam 2 Introduction to the Computer as an Analysis Tool Session 7 4 NBC Universal Ø One of the world's leading media and entertainment companies in the development, production, and marketing of entertainment, news, and information to a global audience Ø Formed in May 2004 through the combining of NBC and Vivendi Universal Entertainment Ø Currently, NBC Universal is 51%-owned by Comcast, with 49% controlled by GE Decision Modeling Example 1: Selling Advertising Slots at NBC Universal* Introduction to the Computer as an Analysis Tool Session 7 5 NBC TV Network Ø Comprises 14 NBC television stations in major U.S. television markets, along with 15 stations affiliated with the Telemundo Network. Ø These stations cover approximately 30% of the nation's viewing households, and annually generate more than $2 billion in revenue from advertising sales Ø Hundreds of advertising clients Introduction to the Computer as an Analysis Tool Session 7 6 Ø Television broadcast year starts in the third week of September Ø Programming schedules for the new broadcast year are announced in the middle of May Ø Starting at the end of May, in a period of 2-3 weeks NBC sells 60-80% of its advertising slots (“up-front market”) Advertising Market Season Introduction to the Computer as an Analysis Tool Session 7 7 Ø Clients submit (through advertising agencies) their annual advertising requests Demand for advertising Budget Demographics Weekly allocation Program preferences Introduction to the Computer as an Analysis Tool Session 7 8 Ø NBC develops sales plans in response to client requests. A sales plan contains a complete schedule of commercials to be aired for the client during the broadcast year. Sales Plan Introduction to the Computer as an Analysis Tool Session 7 9 Ø NBC wants to allocate minimum possible premium airtime while still satisfying the following requirements: q airtime availability constraints q product conflict constraints q client requirement constraints: q budget constraints q show-mix constraints q weekly weighting constraints q unit-mix constraints How should NBC go from a customer request to a sales plan?...
View Full Document

{[ snackBarMessage ]}

Page1 / 41

OPIM 101 - Spring 2012 - Session 7 - Introduction to the...

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

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