Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Information strategy and management

Authors: Lynda M. Applegate, Robert D. Austin, Deborah L. Soule

8th edition

73402931, 73402932, 978-0073402932

More Books

Students also viewed these General Management questions