company's ROI 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