13,100 - 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 $415,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 rep/month - Monthly labour savings/rep (months 4-12): Sales reps are now more efficient at work which resulted in labour cost savings $219/sales rep/month - Monthly productivity increases/rep (months 4-12): Sales reps are now more productive which has resulted in more revenue per sales rep $148,157 - Total other one-time cost savings

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 250 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.29819 instead of 1.39205 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.82864.

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 57% 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 50%

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