Question
Need help with ROI calculation using EXCEL spreadsheet. Thank you!! 27 data analyst for the ABCD company have spent 5 hours per week on correcting
Need help with ROI calculation using EXCEL spreadsheet. Thank you!!
27 data analyst for the ABCD company have spent 5 hours per week on correcting data errors per week. Data analyst are paid $9.50 per hour. After attending the Data Error Reduction Training for Data Analyst, correcting data errors have been reduced by 15% for the year. The president of the company was happy to see that errors were reduced. However, the president of the ABCD company would like to see the ROI on Training before scaling the training throughout the other company locations.
The training department has provided this information to you:
Trainer Salary has a fixed cost of $7,000.00
Time used/spent on training is 4 hours
Variable costs needs to be calculated
ROI per year needs to be calculated
There are 52 weeks in a year
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started