[See Solution] A TV station is selling slots on its Sunday local news program special for October 2018 (we are in March 2018) in the up-front market. There


Question: A TV station is selling slots on its Sunday local news program special for October 2018 (we are in March 2018) in the up-front market. There are 5 slots of 30 seconds for each of the four Sundays in October (7,14,21,28 October).

Currently, it has the following offers from local businesses interested in the slots. Each row corresponds to one potential advertiser with their willingness to pay (based on salesperson's assessment) and the days they are interested (the request is for only one slot per day, for each of the days of interest).

For example, the company's assessment is that Client 7 is willing to pay $425 for one time slot in each of the four Sundays (i.e., $425 × 4= $1,700 for the whole package).

  1. The station manager has the task of informing the sales representative which customers to focus on and seal a contract at the estimated prices (these contracts are privately negotiated so the price can be different for each customer). What deals should be accepted? What is the expected revenue?
    Note 1: that signing a client means serving all the time slots the client is interested Note 2: you could formulate an optimization problem
  2. Given the demand data in the above table, what is the bid price of an additional time slot for each of the four Sundays?

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in