PLEASE SHOW THIS IN THE SAME FORMAT I HAVE AND SHOW FORMULAS AND SOLVER. PLEASE HELP I AM HAVING SO MUCH TROUBLE. DO NOT WORRY ABOUT A REVIEW I WILL GIVE AN AMAZING ONE!!.

J&J has given you $12 million to spend on advertising Huggys diapers during the next 12 months. At the beginning of January, Huggys has a 30% market share. During any month, 10% of the people who purchase Huggys defect to brand X, and a fraction 0.2a12 of customers who usually buy brand X switch to Huggys, where a is the amount spent on advertising in millions of dollars. For example, if you spend $4 million during a month, 40% of brand X's customers switch to Huggys. Your goal is to maximize J&J's average market share during the next 12 months, where the average is computed from each month's ending share. Determine an appropriate advertising policy. (Hint: Make sure you enter a nonzero trial value for each month's advertising expense or Solver might give you an error message.) A C D E F G H I J K L M N o P 6 B All dollar amounts must be $1000! Huggy's beginning mkt share 7 8 9 Percent who switch to brand X 10 11 C*va % of non-huggy's customers who switch to Huggy's = C= where a = amount of advertising ($Million) and, C = 0.2 presently. 12 13 14 Months 15 1 2 3 4 5 6 7 8 9 9 10 11 12 Advertising plan Amount spent (in $1000s) 16 17 18 19 20 Beginning market share Market share for X X Gain in market share Loss in marker share Ending market share 21 22 23 24 Total spent on advertising Budget 25 26 27 Average ending mkt share J&J has given you $12 million to spend on advertising Huggys diapers during the next 12 months. At the beginning of January, Huggys has a 30% market share. During any month, 10% of the people who purchase Huggys defect to brand X, and a fraction 0.2a12 of customers who usually buy brand X switch to Huggys, where a is the amount spent on advertising in millions of dollars. For example, if you spend $4 million during a month, 40% of brand X's customers switch to Huggys. Your goal is to maximize J&J's average market share during the next 12 months, where the average is computed from each month's ending share. Determine an appropriate advertising policy. (Hint: Make sure you enter a nonzero trial value for each month's advertising expense or Solver might give you an error message.) A C D E F G H I J K L M N o P 6 B All dollar amounts must be $1000! Huggy's beginning mkt share 7 8 9 Percent who switch to brand X 10 11 C*va % of non-huggy's customers who switch to Huggy's = C= where a = amount of advertising ($Million) and, C = 0.2 presently. 12 13 14 Months 15 1 2 3 4 5 6 7 8 9 9 10 11 12 Advertising plan Amount spent (in $1000s) 16 17 18 19 20 Beginning market share Market share for X X Gain in market share Loss in marker share Ending market share 21 22 23 24 Total spent on advertising Budget 25 26 27 Average ending mkt share