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 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
Get step-by-step solutions from verified subject matter experts
