Skip to content

Exception Tracking Spreadsheet (TicklerTrax™)
Downloaded by more than 1,000 bankers. Free Excel spreadsheet to help you track missing and expiring documents for credit and loans, deposits, trusts, and more. Visualize your exception data in interactive charts and graphs. Provided by bank technology vendor, AccuSystems. Download TicklerTrax for free.

Click Now!

Calculating the Cost of Training

Calculating the cost of training is a difficult task. The benefits of training are unpredictable because of the many influencing factors such as the trainer, the students' retention, their understanding and many more variables.

Only a part of this quantifiable equation is known, the hard costs to train. This equation helps you use these known costs to calculate the effectiveness of training one person, five, ten, or more. There is an economies of scale which you need to find to be effective. A mass of employees being trained would have a diminishing return when the student-teacher ratio is excessive, so be careful. Determining how to train and how many is up to you.

TRC Interactive has sent us a calculator to help on the known factors of this equation. Using some hard costs and depreciation, you can calculate the costs and see the benefits of training greater numbers of staff.

The average cost per participant per day for training is calculated based on your input of these variables:

  1. Annual Trainer Salary/Benefits/Travel
  2. Annual Participant Salary & Benefits
  3. Overhead, Depreciation, Other
  4. Annual Number of Working Days

Average Cost Per Participant Per Day = ATSB + APSB + O/D ANWD

You can download the Excel spreadsheet and use your own variables to see what your costs are, and how to maximize the return on your training dollars. Note that to preserve the integrity of the formulas, the worksheet is protected. Data may be entered only into the yellow cells unless you unprotect the sheet. There is no password used.

First published on 01/01/2001

Filed under: 
Filed under compliance as: 
Filed under lending as: 
Filed under operations as: 
Filed under security as: 
Filed under technology as: 

Banker Store View All

From training, policies, forms, and publications, to office products and occasional gifts, it’s available here:

Banker Store

hot right now

image description

Looking for effective, convenient training on a particular subject?

BOL Learning Connect offers more than 200 courses ON-DEMAND or on CD ROM from AML to Reg Z and every topic in between.

Search Tools