Need all the formulas and steps in excel.

Jim Hill is the manager of subscriber accounts for the prosper company. The results of job analysis indicate that Jim's job includes four principal activities. A summary of Jim's superior ratings of the activities and Jim's performance of each of them follows:

Principal Activity	Frequency	Importance	Jim's Performance
1	4.5	3	1.00
2	3.0	5	2.00
3	6.0	2	0.50
4	1.0	7	1.00

Assuming Jim is paid 90,000 per year, use CREPID to estimate the overall economic value of his job performance. Please show your work. Need all the formulas and steps in excel.

What did you find when you used the CREPID method to estimate the overall economic value of Jim Hills job performance in the exercise?