A brewing company has $100,000 to spend on advertising in four markets. The sales revenue (in thousands of dollars) that can be created in each market by spending xi thousand dollars in market i is...

A brewing company has $100,000 to spend on advertising in four markets. The sales revenue (in thousands of dollars) that can be created in each market by spending xi thousand dollars in market i is given in the file P07_55.xlsx.

a. To maximize its sales revenue, how much money should the company spend in each market?

b. Use SolverTable to see how a change in the advertising budget affects the optimal sales revenue.