Capstone
Project description
Are the HR productivity improvements worthwhile?
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?
see the Round 0
Round: 0
Dec. 31, 2014
C65027
Andrews
Lucas Gorjan
Qiqing Hu
Melissa Kadow
Caitlin McClarty
Akeyla Roberts
Baldwin
Kofi Afari
Abdulrahman Alhassan
Belal Khelwaty
Michael Penny
Delmy Ramirez
Chester
Deanna Harriss
Joshuah Hofmaier
Fatemeh Khodadadi
Sarah North
Emma Trenwith
Digby
Rania Alshikhe
Grace Forgione
Kelly Guest
Karl Paterson
Hao Wang
Erie
Amy Hallam
Matt Hansen
Rebecca Karutz
talia monaghan
Ma Ting Fung
Ferris
Selected Financial Statistics
Andrews
Baldwin
Chester
Digby
Erie
Ferris
ROS
4.1%
4.1%
4.1%
4.1%
4.1%
4.1%
Asset Turnover
1.05
1.05
1.05
1.05
1.05
1.05
ROA
4.4%
4.4%
4.4%
4.4%
4.4%
4.4%
Leverage
(Assets/Equity)
2.0
2.0
2.0
2.0
2.0
2.0
ROE
8.7%
8.7%
8.7%
8.7%
8.7%
8.7%
Emergency Loan
$0
$0
$0
$0
$0
$0
Sales
$101,073,437
$101,073,437
$101,073,437
$101,073,437
$101,073,437
$101,073,437
EBIT
$11,996,365
$11,996,365
$11,996,365
$11,996,365
$11,996,365
$11,996,365
Profits
$4,188,507
$4,188,507
$4,188,507
$4,188,507
$4,188,507
$4,188,507
Cumulative Profit
$4,188,507
$4,188,507
$4,188,507
$4,188,507
$4,188,507
$4,188,507
SG&A / Sales
8.9%
8.9%
8.9%
8.9%
8.9%
8.9%
Contrib. Margin %
28.3%
28.3%
28.3%
28.3%
28.3%
28.3%
CAPSTONE® COURIER
Page 1
Stock & Bonds
C65027
Round: 0
Dec. 31, 2014
Stock Market Summary
Company
Close
Change
Shares
MarketCap
($M)
Book Value
EPS
Dividend
Yield
P/E
Andrews
$34.25
$0.00
2,000,000
$69
$23.97
$2.09
$2.00
5.8%
16.4
Baldwin
$34.25
$0.00
2,000,000
$69
$23.97
$2.09
$2.00
5.8%
16.4
Chester
$34.25
$0.00
2,000,000
$69
$23.97
$2.09
$2.00
5.8%
16.4
Digby
$34.25
$0.00
2,000,000
$69
$23.97
$2.09
$2.00
5.8%
16.4
Erie
$34.25
$0.00
2,000,000
$69
$23.97
$2.09
$2.00
5.8%
16.4
Ferris
$34.25
$0.00
2,000,000
$69
$23.97
$2.09
$2.00
5.8%
16.4
Bond Market Summary
Company
Series#
Face
Yield
Close$
S&P
Company
Series#
Face
Yield
Close$
S&P
Andrews
Digby
11.0S2016
$6,950,000
11.1%
99.49
B
11.0S2016
$6,950,000
11.1%
99.49
B
12.5S2018
$13,900,000
12.1%
103.70
B
12.5S2018
$13,900,000
12.1%
103.70
B
14.0S2020
$20,850,000
12.6%
111.32
B
14.0S2020
$20,850,000
12.6%
111.32
B
Baldwin
Erie
11.0S2016
$6,950,000
11.1%
99.49
B
11.0S2016
$6,950,000
11.1%
99.49
B
12.5S2018
$13,900,000
12.1%
103.70
B
12.5S2018
$13,900,000
12.1%
103.70
B
14.0S2020
$20,850,000
12.6%
111.32
B
14.0S2020
$20,850,000
12.6%
111.32
B
Chester
Ferris
11.0S2016
$6,950,000
11.1%
99.49
B
11.0S2016
$6,950,000
11.1%
99.49
B
12.5S2018
$13,900,000
12.1%
103.70
B
12.5S2018
$13,900,000
12.1%
103.70
B
14.0S2020
$20,850,000
12.6%
111.32
B
14.0S2020
$20,850,000
12.6%
111.32
B
Next Year’s Prime Rate 7.00%
CAPSTONE® COURIER
Page 2
PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂