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$)$