Sheet1
Number of Trainees 300
YEAR 0 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
2020 2021 2022 2023 2024 2025
Cost of Trainers $18,750.00
Annual Increase in Cost of Trainers (%) 4.0% 4.0% 5.0% 5.0% 6.0%
Equipment
Beginning Annual Value $31,500.00 $0.00 $0.00 $0.00 $0.00
Annual Equipment Depreciation (%) 15.0% 22.0% 21.0% 21.0% 21.0%
Annual Depreciation Amount
Remaing Value – Equipment
Maintenance Costs $750.00
Annual Increase in Maintenance Costs (%) 6.0% 6.0% 7.0% 7.0% 8.0%
Trainee Compensation During Training $54,000.00
Annual Increase in Training Compensation (%) 5.0% 6.0% 6.0% 7.0% 8.0%
Facilities Costs $4,500.00
Annual Increase in Facilities Costs (%) 5.0% 5.0% 5.0% 6.0% 6.0%
Setup/Clean-Up Time $1,500.00
Annual Incease in Setup and Clean-Up (%) 3.0% 3.0% 4.0% 3.0% 5.0%
Training Materials $1,500.00
Annual Increase in Training Materials (%) 2.0% 2.0% 2.0% 3.0% 3.0%
Total Annual Training Costs
Annual Cost Per Trainee
YEAR 0 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
2020 2021 2022 2023 2024 2025
Improved Employee Productivity
Annual Employee Productivity $1,350,000.00
Productivity Increase with no Training (%) 7.0% 7.0% 7.0% 7.0% 7.0%
Productivity Increase with Training (%) 20.0% 20.0% 25.0% 25.0% 30.0%
Incease in Productivity with Training
Turnover Costs $48,000.00
Annual Increase in Turnover Costs 5.0% 6.0% 6.0% 7.0% 8.0%
Decrease in Turnover Due to Training 1.0% 1.0% 1.0% 0.5% 0.5%
Decrease in Turnover Due to Training
Annual Training Benefits
YEAR 0 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5
2020 2021 2022 2023 2024 2025
Annual Benefits
Annual Costs
Annual Value of Training
Total Value of Training
TRAINING EVALUATION AT OPTICITY POWER CORPORATION
TRAINING COSTS
TRAINING BENEFITS
BENEFIT/COST ANALYSIS
Page 1
Sheet1
Page 2