This question relates to the Hudson Readers Example and assumes that the value

of the advertising budget is equal to $$195$ million. You may use the Excel Solver to

answer this question. $($use Excel Solver and please screenshot$)1.$ Consider all of

the constraints in the Hudson case are maintained as original. In addition to that,

the management make a requirement of advertising spending for enhanced

product in India at least $$3$ million. How much advertising spending for the

enhanced product in China should be spent to reach the objective of maximizing

the net sales? $($round to two digits after a decimal$)2.$ Suppose that the company

decides to change the requirement on the minimum net sales increase in China

from the current value of $$4$ million to $$4\mathrm{.}2$ million. The other constraints remain

unchanged. What is the new value of the optimal total net sales increase, in $

millions? $($round to two digits after a decimal$)3.$ Assumed that other constraints

remain the same except for the value of advertising budget, what is the optimal

value of the total net sales increase $($in $ millions$)$ for such a problem? $($round to

two digits after a decimal$)$