Question: Please help!!! I do not know how to do this and I can not find my Analyst toolPak on my excel Specifically, you must address

Please help!!! I do not know how to do this and Ican not find my Analyst toolPak on my excel Specifically, you must

Please help!!! I do not know how to do this and I can not find my Analyst toolPak on my excel

Specifically, you must address the critical elements listed below. External Competitiveness: A. Calculate the weighted means of base pay for each of the following benchmark jobs: administrative assistant, operations analyst, production worker, and benefits manager from the six companies listed in Appendix B of the final project case study. B. Calculate the predicted base pay for each of the following benchmark jobs: administrative assistant, operations analyst, production worker, and benefits manager. C. Create a market pay line using the following benchmark jobs: administrative assistant, operations analyst, production worker, and benefits manager. Clearly label your job evaluation points and salaries. D. Calculate the adjusted pay rates for each benchmark job based on your company's decision to lead in base pay by 3%. E. Create pay grades by combining benchmark jobs that are substantially comparable for pay purposes. Clearly label your pay grades and explain why you combined any benchmark jobs to form a grade. F. Create pay ranges including minimum and maximum for each of the pay grades based on pay grades created in item E above. \begin{tabular}{|l|r|r|} \multicolumn{1}{|c}{ A } & \multicolumn{1}{|c|}{ B } & \multicolumn{2}{|c|}{ C } \\ \cline { 3 - 3 } & Weighted Pay & Job Evaluation Points \\ \hline Administrative Assistant & $35,750 & 145 \\ \hline Operations Analyst & $63,325 & 215 \\ \hline Payroll Assistant & $34,000 & 175 \\ \hline Benefits Manager & $62,000 & 245 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!