You are an HR manager responsible for organizing the company's new sales training course. This one weeklong (44 work hours) training course was attended by 296 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 st At that time the EURCAD rate (Euro(C) to Canadian Dollar) was 1.21684 instead of 1.42852 today. Most of the material related to the training was only available for purchase from the UK when the exchange rate for GBPCAD On average, within the first 2 months, employees only delivered 40% of the benefits. Starting in month 3 , the employees were fully competent with the new sales training and the company was able to reap the fu The average ROI for all company initiatives (not just HR) is 36%. It has been 12 months since the training occurred and you are required to provide an update to the company cEO about the effe Training Program Details (pay attention to the currency symbol per line item): Part A-ROI ROl Report Part B-VT Reduction All Divisions Main Office Government Part A: Return on Investment Refer to the sheet labelled, "Port A-Ror for the mini case and details. 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 ROt, indicate If you would you recommend that this training continue and why? You are an HR manager responsible for organizing the company's new sales training course. This one weeklong (44 work hours) training course was attended by 296 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 st At that time the EURCAD rate (Euro(C) to Canadian Dollar) was 1.21684 instead of 1.42852 today. Most of the material related to the training was only available for purchase from the UK when the exchange rate for GBPCAD On average, within the first 2 months, employees only delivered 40% of the benefits. Starting in month 3 , the employees were fully competent with the new sales training and the company was able to reap the fu The average ROI for all company initiatives (not just HR) is 36%. It has been 12 months since the training occurred and you are required to provide an update to the company cEO about the effe Training Program Details (pay attention to the currency symbol per line item): Part A-ROI ROl Report Part B-VT Reduction All Divisions Main Office Government Part A: Return on Investment Refer to the sheet labelled, "Port A-Ror for the mini case and details. 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 ROt, indicate If you would you recommend that this training continue and why