Formulate on a spreadsheet and solve using solver, Explain formulas used in cells.
Carco has a $150,000 advertising budget. In order to increase automobile sales, the firm is considering advertising in newspapers and on television. The more Carco uses a particular medium, the less effective is each additional ad. Table 26 shows the number of new customers reached by ad. Each newspaper ad costs $1000, and each television ad costs $10,000. At most 30 newspaper ads and at most 15 television ads can be placed. How can Cargo maximize the number of new customers created by advertising?
NO. OF ADS NEW CUSTOMERS
Newspaper 1 – 10 900
11 – 20 600
21 – 30 300
Television 1 – 5 10,000
6 – 10 5,000
11 – 15 2,000