How to solve this question on Excel using Solver.

follow the problem solution to understand the porcess of dynamic programming then work the solution using solver Add-in in excel to generate similar resutls, Problem 11-1: A company is planning its advertising strategy for next year for its three major products. Since the three products are quite different, each advertising effort will focus on a single product. In units of millions of dollars, a total of 6 is available for advertising next year, where the advertising expenditure for each product must be an integer greater than or equal to 1 . The vice-president for marketing has established the objective: Determine how much to spend on each product in order to maximize total sales. The following table gives the estimated increase in sales (in appropriate units) for the different advertising expenditures. Use dynamic programming to solve this