Beerco 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 x i thousand dollars in market i is given in the...

Beerco 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 x_i
thousand dollars in market i is given in the file P07_56.xlsx.

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

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