## Answered: - ABC is a small engineering firm. A salary survey was completed

ABC is a small engineering firm. ?A salary survey was completed and the results averaged. ?The results?for the Benchmark jobs is presented below. These are mid-level professional jobs.

JOB ? ? ? ? ? ? ?SALARY ? ? ? ? ? ? ? ? ? ? ? ? J.E. POINTS (job evaluation points)

A ? ? ? ? ? ? ? ? ?\$95,000 ? ? ? ? ? ? ? ? ? ? ? ? ? ? 340

B ? ? ? ? ? ? ? ? ? ?90,000 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?289

C ? ? ? ? ? ? ? ? ? ?85,000 ? ? ? ? ? ? ? ? ? ? ? ? ? ? 262

D ? ? ? ? ? ? ? ? ? ?77,500 ? ? ? ? ? ? ? ? ? ? ? ? ? ? 262

E ? ? ? ? ? ? ? ? ? ?85,000 ? ? ? ? ? ? ? ? ? ? ? ? ? ? 250

F ? ? ? ? ? ? ? ? ? ?77,500 ? ? ? ? ? ? ? ? ? ? ? ? ? ? 215

G ? ? ? ? ? ? ? ? ? ?62,600 ? ? ? ? ? ? ? ? ? ? ? ? ? ? 231

H ? ? ? ? ? ? ? ? ? ? 61,200 ? ? ? ? ? ? ? ? ? ? ? ? ? ?220

I ? ? ? ? ? ? ? ? ? ? ?56,400 ? ? ? ? ? ? ? ? ? ? ? ? ? ?169

1.......plot the jobs using a scatter diagram with the Salary Scale on the verticle?axis and the JE Points on the horizontal axis. ?(Use landscape view and utilize the whole page)

2.......draw a trend or best fit line through the middle of all the jobs. ?If you can you can use EXCEL for this and do the plots as well as the trend line. ?If you do not know how to this in EXCEL, it probably?is not worth the time learning as most corporations would use consultants or IT people to do this for you. ?You can utilize a free hand drawing of a trend line with a ruler.

3......Construct a set of pay boxes. ?No broad banding. Justify the number of boxes...i.e. explain the rationale behind the width of the grades as well as the number of boxes. Also explain the "overlap" utilized.

Define both grade and range.?There could be jobs with lower point values that are paid more than a job in the same grade with a higher point value. ?Is this a concern? ?Explain your answer

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Oct 07, 2020

Solution~0002198530.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Oct 07, 2020

EXPERT

Tutor

### Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.