Use Excel to Solve : SOLVER

LCP company has engaged the services of Xellent Adcorp to plan an advertising campaign to achieve the highest possible exposure rating ( exposure rating is a measure of demand produced per rupee spent on advertising) LCP company is prepared to spend up to Rs. 200 lakhs but does not want to spend more than RS. 120 lakhs on advertising in newspaper, and does not want to spend more than RS. 150 lakhs on television advertising and but does not want to spend more than RS. 100 lakhs on advertising in magazines. The objective of this restriction is to prevent overexposing a particular audience to the advertising message while not reaching the other audiences. The advertising expenses and exposure rates are given for each media in the table below Media by Type Expenses per unit of advertising Exposure rating per unit (in rupees lakhs) 8 15 120 180 Magazines Literary Topical Newspapers Morning Evening Television Evening Daytime 24 16 300 100 36 20 350 130 The LCP Company has to decide how many units of advertising to be placed in each type of media viz. Magazines, newspapers and television