(1) Mathmatical Formula & Goal Seek Job satisfaction (points) 5 Increase in 1401k contribution by company (%) slAverage # of years for promotioin to MGR (# years) 10 | Other hygien factors (%) The total job satisfaction score will be determined by: " 40% of increase rate in annual salary (%): default value:S -30% of 401K contribution by company (%)default values -20% of average of # of years for promotion to MGR (# years) salary(%) :default value:5. Minimum is 3 years -10% of other factors ( assume it is fixed as 10) Given the information above, (1) Run goal seek analysis, aiming at 8 for total job satisfaction score (2) Sensitivity Analysis (Data Table in Excel) Increase in salary [) 9 10 by changing 401K contribution. (2) Run sensitivity analysis, salary increase ranging from 5-10%, and 401K contribution ranging from 4-8% (1) Mathmatical Formula & Goal Seek Job satisfaction (points) 5 Increase in 1401k contribution by company (%) slAverage # of years for promotioin to MGR (# years) 10 | Other hygien factors (%) The total job satisfaction score will be determined by: " 40% of increase rate in annual salary (%): default value:S -30% of 401K contribution by company (%)default values -20% of average of # of years for promotion to MGR (# years) salary(%) :default value:5. Minimum is 3 years -10% of other factors ( assume it is fixed as 10) Given the information above, (1) Run goal seek analysis, aiming at 8 for total job satisfaction score (2) Sensitivity Analysis (Data Table in Excel) Increase in salary [) 9 10 by changing 401K contribution. (2) Run sensitivity analysis, salary increase ranging from 5-10%, and 401K contribution ranging from 4-8%