Part A: Return on Investment You are an HR manager responsible for organizing the company's new sales training course. This one week long (44 work hours) training course was attended by 250 of the company's salespeople. You felt "lucky" that the trainer you were able to book is considered a guru and is sought after worldwide and isn't cheap. You are thankful that you fully paid the invoice for the training when it took place last year when the Canadian Dollar was stronger in relation to the Euro since the sales trainer billed your company in Euros. At that time the EURCAD rate (Euro(€) to Canadian Dollar) was 1.26819 instead of 1.46913 today. Most of the material related to the training was only available for purchase from the UK when the exchange rate for GBPCAD rate (British Pound Sterling (£) to Canadian Dollar) was 1.71864. It has been 12 months since the training occurred and you are required to provide an update to the company CEO about the effectiveness of the training to-date. The full benefits of the program were only realized three months after the training week. On average, within the first three months, employees only delivered 67% of the benefits. Starting in month 4, the employees were fully competent with the new sales training and the company was able to reap the full benefits as indicated below. The average ROl for all company initiatives (not just HR) is 34%. Training Program Details (pay attention to the currency symbol per line item): $13,400 Training program design and development Promotion of training to employees via intranet, posters and printed pamphlets Administration of employee registration and training program logistics Cost for the best international professional sales trainer Professional sales trainer travel expenses $980 $2,750 €32,400 €7,500 £65/sales rep £26,500 $9,250 Imported study guides per sales rep sold to the company Additional training reference materials sold to the company for the training session Conference centre rental location to host the training sessions $315,808 $1,450 Salary of sales reps attending the training Evaluation and feedback of training program from sales reps (data collected by an outside company) Monthly labour savings/rep (months 4-12): Sales reps are now more efficient at work which resulted in labour cost savings $87/sales rep/month $162/sales rep/month $148.157 Monthly productivity increases/rep (months 4-12): Sales reps are now more productive which has resulted in more revenue per sales rep Total other one-time cost savings Deliverables for Part A 1. In the Excel file, create a professional looking report outlining both the costs and benefits. Formatting should be set to "Currency" and rounded to the nearest dollar. 2. Underneath the report, calculate the Return on Investment (ROI) of this training course. Write your answer to 1 decimal place. 3. Based on your ROI calculation and taking into consideration the company average ROI, indicate if you would you recommend that this training continue and why? HR Metrics: Assignment 3 2 Page

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

Part A: Return on Investment You are an HR manager responsible for organizing the company's new sales training course. This one week long (44 work hours) training course was attended by 250 of the company's salespeople. You felt "lucky" that the trainer you were able to book is considered a guru and is sought after worldwide and isn't cheap. You are thankful that you fully paid the invoice for the training when it took place last year when the Canadian Dollar was stronger in relation to the Euro since the sales trainer billed your company in Euros. At that time the EURCAD rate (Euro(€) to Canadian Dollar) was 1.26819 instead of 1.46913 today. Most of the material related to the training was only available for purchase from the UK when the exchange rate for GBPCAD rate (British Pound Sterling (£) to Canadian Dollar) was 1.71864. It has been 12 months since the training occurred and you are required to provide an update to the company CEO about the effectiveness of the training to-date. The full benefits of the program were only realized three months after the training week. On average, within the first three months, employees only delivered 67% of the benefits. Starting in month 4, the employees were fully competent with the new sales training and the company was able to reap the full benefits as indicated below. The average ROI for all company initiatives (not just HR) is 34%. Training Program Details (pay attention to the currency symbol per line item): $13,400 Training program design and development $980 Promotion of training to employees via intranet, posters and printed pamphlets $2,750 Administration of employee registration and training program logistics €32,400 Cost for the best international professional sales trainer €7,500 Professional sales trainer travel expenses £65/sales rep Imported study guides per sales rep sold to the company £26,500 Additional training reference materials sold to the company for the training session $9,250 Conference centre rental location to host the training sessions $315,808 Salary of sales reps attending the training $1,450 Evaluation and feedback of training program from sales reps (data collected by an outside company) $87/sales Monthly labour savings/rep (months 4-12): Sales reps are now more efficient at rep/month work which resulted in labour cost savings $162/sales Monthly productivity increases/rep (months 4-12): Sales reps are now more rep/month productive which has resulted in more revenue per sales rep $148, 157 Total other one-time cost savings Deliverables for Part A 1. In the Excel file, create a professional looking report outlining both the costs and benefits. Formatting should be set to "Currency" and rounded to the nearest dollar. 2. Underneath the report, calculate the Return on Investment (ROI) of this training course. Write your answer to 1 decimal place. 3. Based on your ROI calculation and taking into consideration the company average ROI, indicate if you would you recommend that this training continue and why? 

Part A: Return on Investment
You are an HR manager responsible for organizing the company's new sales training course. This one
week long (44 work hours) training course was attended by 250 of the company's salespeople. You felt
"lucky" that the trainer you were able to book is considered a guru and is sought after worldwide and
isn't cheap. You are thankful that you fully paid the invoice for the training when it took place last year
when the Canadian Dollar was stronger in relation to the Euro since the sales trainer billed your
company in Euros. At that time the EURCAD rate (Euro(€) to Canadian Dollar) was 1.26819 instead of
1.46913 today. Most of the material related to the training was only available for purchase from the UK
when the exchange rate for GBPCAD rate (British Pound Sterling (£) to Canadian Dollar) was 1.71864.
It has been 12 months since the training occurred and you are required to provide an update to the
company CEO about the effectiveness of the training to-date.
The full benefits of the program were only realized three months after the training week. On average,
within the first three months, employees only delivered 67% of the benefits. Starting in month 4, the
employees were fully competent with the new sales training and the company was able to reap the full
benefits as indicated below.
The average ROl for all company initiatives (not just HR) is 34%.
Training Program Details (pay attention to the currency symbol per line item):
$13,400
Training program design and development
Promotion of training to employees via intranet, posters and printed pamphlets
Administration of employee registration and training program logistics
Cost for the best international professional sales trainer
Professional sales trainer travel expenses
$980
$2,750
€32,400
€7,500
£65/sales rep
£26,500
$9,250
Imported study guides per sales rep sold to the company
Additional training reference materials sold to the company for the training session
Conference centre rental location to host the training sessions
$315,808
$1,450
Salary of sales reps attending the training
Evaluation and feedback of training program from sales reps (data collected by an
outside company)
Monthly labour savings/rep (months 4-12): Sales reps are now more efficient at
work which resulted in labour cost savings
$87/sales
rep/month
$162/sales
rep/month
$148.157
Monthly productivity increases/rep (months 4-12): Sales reps are now more
productive which has resulted in more revenue per sales rep
Total other one-time cost savings
Deliverables for Part A
1. In the Excel file, create a professional looking report outlining both the costs and benefits.
Formatting should be set to "Currency" and rounded to the nearest dollar.
2. Underneath the report, calculate the Return on Investment (ROI) of this training course. Write
your answer to 1 decimal place.
3. Based on your ROI calculation and taking into consideration the company average ROI, indicate
if you would you recommend that this training continue and why?
HR Metrics: Assignment 3
2 Page
Transcribed Image Text:Part A: Return on Investment You are an HR manager responsible for organizing the company's new sales training course. This one week long (44 work hours) training course was attended by 250 of the company's salespeople. You felt "lucky" that the trainer you were able to book is considered a guru and is sought after worldwide and isn't cheap. You are thankful that you fully paid the invoice for the training when it took place last year when the Canadian Dollar was stronger in relation to the Euro since the sales trainer billed your company in Euros. At that time the EURCAD rate (Euro(€) to Canadian Dollar) was 1.26819 instead of 1.46913 today. Most of the material related to the training was only available for purchase from the UK when the exchange rate for GBPCAD rate (British Pound Sterling (£) to Canadian Dollar) was 1.71864. It has been 12 months since the training occurred and you are required to provide an update to the company CEO about the effectiveness of the training to-date. The full benefits of the program were only realized three months after the training week. On average, within the first three months, employees only delivered 67% of the benefits. Starting in month 4, the employees were fully competent with the new sales training and the company was able to reap the full benefits as indicated below. The average ROl for all company initiatives (not just HR) is 34%. Training Program Details (pay attention to the currency symbol per line item): $13,400 Training program design and development Promotion of training to employees via intranet, posters and printed pamphlets Administration of employee registration and training program logistics Cost for the best international professional sales trainer Professional sales trainer travel expenses $980 $2,750 €32,400 €7,500 £65/sales rep £26,500 $9,250 Imported study guides per sales rep sold to the company Additional training reference materials sold to the company for the training session Conference centre rental location to host the training sessions $315,808 $1,450 Salary of sales reps attending the training Evaluation and feedback of training program from sales reps (data collected by an outside company) Monthly labour savings/rep (months 4-12): Sales reps are now more efficient at work which resulted in labour cost savings $87/sales rep/month $162/sales rep/month $148.157 Monthly productivity increases/rep (months 4-12): Sales reps are now more productive which has resulted in more revenue per sales rep Total other one-time cost savings Deliverables for Part A 1. In the Excel file, create a professional looking report outlining both the costs and benefits. Formatting should be set to "Currency" and rounded to the nearest dollar. 2. Underneath the report, calculate the Return on Investment (ROI) of this training course. Write your answer to 1 decimal place. 3. Based on your ROI calculation and taking into consideration the company average ROI, indicate if you would you recommend that this training continue and why? HR Metrics: Assignment 3 2 Page
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Ethics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education