Suppose you are the ad manager for Fox NFL football. Thirty bids for ads on today’s game between the Packers and the Colts have been submitted. Information on these ads is given in the file...

Suppose you are the ad manager for Fox NFL football. Thirty bids for ads on today’s game between the Packers and the Colts have been submitted. Information on these ads is given in the file P08_39.xlsx. For example, ad 1 is 23 seconds in length and will bring in $53,000 in revenues. During the game, 14 one-minute slots are available for ads. Determine how Fox can maximize the revenue earned from game ads.