You are an HR manager responsible for organizing the companys new sales training course. This one week long (44 work hours) training course was attended by 290 of the companys salespeople. You felt lucky that the trainer you were able to book is considered a guru and is sought after worldwide and isnt 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.23330 instead of 1.36902 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.62864.

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 four months after the training week. On average, within the first five months, employees only delivered 73% of the benefits. Starting in month 6, 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 50%.

$13,000	Training program design and development
$1,000	Promotion of training to employees via intranet, posters and printed pamphlets
$2,750	Administration of employee registration and training program logistics
32,505	Cost for the best international professional sales trainer (in Euros)
7,500	Professional sales trainer travel expenses (in Euros)
72	Imported study guides per sales rep sold to the company (in British Pounds)
26,000	Additional training reference materials sold to the company for the training session (in British Pounds)
$9,250	Conference centre rental location to host the training sessions
$315,808	Salary of sales reps attending the training
$1,440	Evaluation and feedback of training program from sales reps (data collected by an outside company)
$70/sales rep/month	Monthly labour savings/rep (months 6-12): Sales reps are now more efficient at work which resulted in labour cost savings
$154/sales rep/month	Monthly productivity increases/rep (months 6-12): Sales reps are now more productive which has resulted in more revenue per sales rep
$148,157	Total other one-time cost savings

Question: Show the FORMULA in excel for all computation.

1. 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?