## HR Capsim Assignment

HR Capsim Assignment
Capstone: HR MODULE – ARE HR INVESTMENTS WORTHWHILE?Assignment:Are the HR productivity improvements worthwhile?Provide an excel spreadsheet with formulas to determine accuracy.

Prepare a policy position that addresses the issue, “Does it make sense
to invest in the productivity improvements offered by the HR module?”

Suppose that you apply the maximums to recruiting and training. Here
are the costs:

Recruiting costs per new worker are \$5000.

Each employee trains 80 hours per year at \$20 per training hour

Workforce complement increases by 4.2% to cover the 80 hours people are in training.
For this exercise you need a spreadsheet and both the Capstone Courier
and Annual Report. Use the Round 0 reports for the analysis. Human
Resources statistics like workforce complement and turnover are on
Courier page 12. Use Annual Report Income Statement’s total Labor cost
to estimate payroll costs.
Assume the following productivity payoffs:

Round 1 – 102%
Round 2 – 105%
Round 3 – 108%
Round 4 – 112%
Round 5 – 115%
Round 6 – 118%

Therefore, in Round 6 each worker would be 1.18 times as effective as the beginning worker, and your workforce complement would fall to 1/1.18 or 85% of its current level.

For a quick evaluation, assume your total labor expenditure from the Annual Report Income Statement will stay flat for the next six years.

How much of a cost savings might you expect in the sixth year? For example, if the total labor costs on the Income Statement says
\$29M, and costs stay the same for six years, then in the last year your costs would fall to \$29/1.18 M.

Apply the same approach to years one through five to get a total savings over time.

Would this justify the necessary expenditures in recruiting and training made over time? Assume a turnover of 10% and no increase in workforce size. Since you are sending workers to training for 80 hours
or two weeks each year, you also need to expand the workforce enough to cover the workers that are in training. We are looking for a ballpark
answer, not a precise answer, so that you can decide whether or not a payoff in HR productivity justifies the expense.

So far we have assumed our workforce and labor contracts are constant. In practice the market is growing at about 14%, and your
labor contract has a 5% wage escalator. How does this affect the numbers?

At what level, if any, would you recommend that your company invest in recruiting and training? Are there any factors beyond the
simple numbers that should be considered?

File #1
HR Capsim Assignment

Place a Bid
Amount you will charge(\$) A 10% transaction fee will be added to your bid
Submit
Bids Placed by Scholars
Scholar Rating Bid Amt + 10% fee
Penina 403 reviews \$88.00
Actions
Bookmark Project
Details
Posted By View Student Profile
Deadline (Pacific Time) 04/04/2017 01:30 pm
Budget \$10-\$30
Capstone: HR MODULE – ARE HR INVESTMENTS WORTHWHILE?Assignment:Are the HR productivity improvements worthwhile?Provide an excel spreadsheet with formulas to determine accuracy.

Prepare a policy position that addresses the issue, “Does it make sense
to invest in the productivity improvements offered by the HR module?”

Suppose that you apply the maximums to recruiting and training. Here
are the costs:

Recruiting costs per new worker are \$5000.

Each employee trains 80 hours per year at \$20 per training hour

Workforce complement increases by 4.2% to cover the 80 hours people are in training.
For this exercise you need a spreadsheet and both the Capstone Courier
and Annual Report. Use the Round 0 reports for the analysis. Human
Resources statistics like workforce complement and turnover are on
Courier page 12. Use Annual Report Income Statement’s total Labor cost
to estimate payroll costs.
Assume the following productivity payoffs:

Round 1 – 102%
Round 2 – 105%
Round 3 – 108%
Round 4 – 112%
Round 5 – 115%
Round 6 – 118%

Therefore, in Round 6 each worker would be 1.18 times as effective as the beginning worker, and your workforce complement would fall to 1/1.18 or 85% of its current level.

For a quick evaluation, assume your total labor expenditure from the Annual Report Income Statement will stay flat for the next six years.

How much of a cost savings might you expect in the sixth year? For example, if the total labor costs on the Income Statement says
\$29M, and costs stay the same for six years, then in the last year your costs would fall to \$29/1.18 M.

Apply the same approach to years one through five to get a total savings over time.

Would this justify the necessary expenditures in recruiting and training made over time? Assume a turnover of 10% and no increase in workforce size. Since you are sending workers to training for 80 hours
or two weeks each year, you also need to expand the workforce enough to cover the workers that are in training. We are looking for a ballpark
answer, not a precise answer, so that you can decide whether or not a payoff in HR productivity justifies the expense.

So far we have assumed our workforce and labor contracts are constant. In practice the market is growing at about 14%, and your
labor contract has a 5% wage escalator. How does this affect the numbers?

At what level, if any, would you recommend that your company invest in recruiting and training? Are there any factors beyond the
simple numbers that should be considered?

File #1