Question

In: Advanced Math

Did any of your previous assignments involve math calculations for premium and or salary analysis and...

Did any of your previous assignments involve math calculations for premium and or salary analysis and adjustments? Please provide detailed example(s).

Solutions

Expert Solution

Determining Salary Range & Calculate Range Spread:-

The market survey data is to determine the salary range for a position,by using the 10th, 50th, and 90th percentiles as your minimum, mid-point, and maximum for the range. One of the problems with either of those options, though, is that those points tend to fluctuate with the survey data so your range spread varies from position to position.

Instead, you may want to calculate a consistent range spread based on the mid-point of the salary data. We have to decide which mid-point to use—the mean or the 50th percentile. Either way, there is a simple method for determining the min, mid, and max of a salary range when only the mid-point of the survey data is known.

Let us consider the range spread to be 25%, 50%, 75%, or even more It’s important to be consistent that range spread is calculated across job types.

For example, A non-exempt jobs could have a range spread of 25% or 30% and exempt jobs could have a range spread of 40% or 50%. The sample of one way to designate range spread for all jobs within an organization:

  • Manufacturing or service jobs – 20% to 30%
  • Clerical or technical jobs – 30% to 40%
  • Supervisory or professional jobs – 40% to 50%
  • Management or executive jobs – 50% or more

The key is to pick one range spread rate for each job type in your organization, document it, and be consistent in how it is applied when setting the salary range for each of the jobs in a given job type

Let’s use 50% as our range spread. In this case, the midpoint of our rage is $135,500. To find the minimum, divide the market rate by 1.00 + ½ of the range spread.

To find the maximum, multiply the minimum times 1 plus the range spread.

This creates a salary range that has a minimum of $108,000, a mid-point of $135,500, and a maximum of $162,000.

The simple formula can be used to establish a salary range for any job based on the mid-point of available salary market data.


Related Solutions

Complete a technical analysis on Ollie's stock. Your analysis may involve any one or more of...
Complete a technical analysis on Ollie's stock. Your analysis may involve any one or more of the technical measures listed below: Dow Theory Moving averages Candlestick charts Odd-Lot Theory Put-Call Ratio Short Sales Volume indicators Advance-decline lines Bollinger bands Complete the following tasks: Assess the current price in relation to the technical indicator(s). Assess whether corporation's stock price reflects a "random walk" or if there are patterns in its time series of prices. Review three to five years of data....
Did you come across any notable data analysis tools during your research for the activity submission?...
Did you come across any notable data analysis tools during your research for the activity submission? Share with your fellow classmates any interesting or useful hardware or software tools that you have come across. Discuss your thoughts on the applicability of this tool in your context or field of interest, as well as any ways in which you think this tool could be beneficial to a specific industry or job role.
Using the internet, find the annual salary of the CEO of any company of your choosing....
Using the internet, find the annual salary of the CEO of any company of your choosing. Do you believe the CEO of the company you chose is being compensated for being an excellent manager? Do you feel that this salary is fair, or that the salary should be higher or lower? Why? If you were the CEO of company, how much would you think is a fair salary, and what would be your philosophy in compensating your employees?
Using the same MNC and host country as you did in your previous discussion forum, create...
Using the same MNC and host country as you did in your previous discussion forum, create a PESTLE analysis of the host country. Restate the host country, industry, and company name in your initial post. The PESTLE should be a visual such as a table or a chart with a 100- to 200-word analysis. Support your answer with at least one credible, recent source in addition to the course textbook.
Question 3. Given your analysis in Questions 1 and 2, and the electoral math in Georgia,...
Question 3. Given your analysis in Questions 1 and 2, and the electoral math in Georgia, is it likely that Democrats will be able to flip Georgia from Republican to Democrat in the upcoming presidential election? What happens if Trump can parlay the improved economic condition of Blacks into a modest improvement in the number of Blacks voting Republican? Explain.
QUALITATIVE ANALYSIS: It is advisable to document all your work and calculations as applicable. The following...
QUALITATIVE ANALYSIS: It is advisable to document all your work and calculations as applicable. The following are data available for Blue Grass & High Weed for the month of June: Sales 1200 units Beginning Inventory 300 units @ 2.00 Purchases in Chronological order 600 units @ 2.10 400 units @ 2.20 500 units @ 2.30 A) Calculate cost of goods sold and ending inventory under the following cost flow assumptions: 1) Weighted average 2) FIFO 3) LIFO B) Assume net...
2. Investing in the market portfolio: Your analysis suggest that the risk premium of the market...
2. Investing in the market portfolio: Your analysis suggest that the risk premium of the market is 6.2% and the standard deviation of stocks is 16.4%. You analyze the risk and return possibilities of a 1-year investment in the stock market and the risk-free asset. a. Given the historical experience of stocks, what is the slope of the CML (the Sharpe ratio of stocks)? b. The risk-free rate is 0.9%; this is the intercept of the CML. Using the slope...
Elaborate a list of personal pitfalls-the aspects (any) of your previous problem set that you wish...
Elaborate a list of personal pitfalls-the aspects (any) of your previous problem set that you wish to work on in the near future
Within your current or previous organization, identify and discuss any form of bias and provide what...
Within your current or previous organization, identify and discuss any form of bias and provide what you think could be a remedy.
QUANTITATIVE ANALYSIS: It is advisable to document all your work and calculations as applicable. (1) Consider...
QUANTITATIVE ANALYSIS: It is advisable to document all your work and calculations as applicable. (1) Consider the following account balances in thousands for the Yankee Company for the year ended December 31, 2019: Direct Materials Inventory, Beginning $58,000 Direct Material Inventory, Ending $32,000 Work in Process, Beginning $38,000 Work in Process, Ending $16,000 Finished Goods Inventory, Beginning $29,000 Finished Goods Inventory, Ending $12,000 Direct Materials Purchased $99,000 Direct Labor $94,000 Indirect Labor $14,000 Plant insurance $29,000 Other insurance $18,000 Salaries...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT