(Mathmatical Farmule& The total job satisfaction score will be determined by & Goal Seek ob satisfaction (points) increase in salary (%1 s|401k contributionbYcompany(%) 40% of increase rate in annual salary (%): default value:5 -30% of 401K contribution by company (%).default values 20% of average of # of years for promotion to MGR (# years) age 8 of years for promotioin to MGR (years) default value:5.. Minimum is 3 years 10% of other factors o Other hygien factors C) assume it is fixed as 10, 2) Sensitwity Analysis (Dato Table in Excel Given the information above, (1) Run goal seek analysis, aiming at 8 for total job satisfaction score [2) Run sensitivity analysis, salary increase ranging from 5-10%, by changing 401K contribution. and 401K contribution ranging from 4.8% (Mathmatical Farmule& The total job satisfaction score will be determined by & Goal Seek ob satisfaction (points) increase in salary (%1 s|401k contributionbYcompany(%) 40% of increase rate in annual salary (%): default value:5 -30% of 401K contribution by company (%).default values 20% of average of # of years for promotion to MGR (# years) age 8 of years for promotioin to MGR (years) default value:5.. Minimum is 3 years 10% of other factors o Other hygien factors C) assume it is fixed as 10, 2) Sensitwity Analysis (Dato Table in Excel Given the information above, (1) Run goal seek analysis, aiming at 8 for total job satisfaction score [2) Run sensitivity analysis, salary increase ranging from 5-10%, by changing 401K contribution. and 401K contribution ranging from 4.8%