Sugar High Grain: Advertising Mix Using Excel

The corresponding blog post and a work-along version of the spreadsheet can be found here: http://wp.me/p1TVs6-kVIn this video I walk you though how to set up and solve a simple advertising mix problem in Microsoft Excel using the Solver Add-In. The goal is to select the most efficient mix of advertising outlets in a fashion which maximizes the number of ad exposures in certain target demographics while adhering to budget constraints, minimum ad exposure constraints, a coupon redemption constraint, and a maximum number of TV commercial constraint.This problem comes from the book "Introduction to Management Science 3/e" by Hiller and Hiller. For my complete video library organized by playlist, please go to my video page here:http://www.youtube.com/user/BCFoltz/videos?flow=list&view=1&live_view=500&sort=dd