Answer Happy

9. This problem comes from the text book. This problem involves the allocation of advertising budget. A company is trying to decide the best way to allocate a $1,000 per month budget between newspaper and radio advertising. management wants at least 25% of the budget to be spent on each type of media and that the budget for newspaper be at least that of radio. Newspaper advertising has an exposure index of 50 and radio advertising exposure index of 80. Management wants to allocate the budget such that total audience exposure is maximized. a. Formulate a linear programming model that can be used to determine the optimal budget for newspaper and radio advertising to maximize audience exposure. b. Using the model from part a develop a spreadsheet model and use Excel Solver to determine the optimal budget for newspaper and radio advertising.