FTE Calculation Excel Template
Are you ready for 2012?
Assemble your staffing
models and plans now and guarantee
that you will achieve every one of your 2012 goals.
FTE Definition: (full time equivalent definition)
- The definition of FTE (full time equivalent) is the number of working hours that represents one full-time employee during a fixed time period, such as one month or one year. FTE simplifies work measurement by converting work load hours into the number of people required to complete that work.
FTE Calculation
- FTE calculation is a two step process that determines how many hours of work there are in a department and how many hours one full time employee works. The total workload hours are then divided by the working hours of one employee. This calculates the number of full time equivalents that are needed.
- Modifications to the workload will precisely forecast how many FTEs will be required.
FTE Analysis
- FTE analysis is the methodical analysis of current work activities with related time and cost measures. This helps managers understand the root causes and drivers of workload levels, organizational performance, and productivity improvement opportunities.
FTE Models
-
FTE Models assemble and relate
workload data to job positions, processes, products, customer segments, and
other performance drivers that an organization may use.
FTE models are
constructed with statistical tools and methods, and are organized
as data models with data charts and graphs. Data models are used because they accurately measure
workloads and required FTEs while also making scenario forecasting (what if
analysis) easy and accurate.
FTE Management -
FTE
management is the analysis, decision making, and change implementation processes that determine:
- how many employees are needed
- the skills each job position needs and the total available skill hours the department needs
- how work will be assigned to employees
- how organizational and staff performance will be measured
FTE Analysis Models guarantee that you will:
Reduce
and optimize
staffing costs
Increase and optimize productivity
Meet
and exceed service quality levels
Define and maintain the skills that your processes need
Utilize
all of your human resource capacity and skills in the most productive ways
Provide
rewarding work and careers to your employees
Rationalize and optimize your organization with the right balance of generalists and
specialists
Learn about
our free pilot
FTE Models Webinar
Learn about our free pilot
FTE Calculation Excel Template
FTE Analysis Exhibit
This FTE Analysis chart is from an automobile insurance company. It provides the number of Policy Administrators needed in 2004 and those predicted in 2005. The new policy volumes are in red.
This FTE chart was used by the department manager to determine her 2005 staffing budget and her request for three additional staff employees.
AIM-Activity Information ModelingTM, a new FTE management methodology and tool
We invented AIM-Activity Information ModelingTM, a powerful new approach and methodology that quickly builds comprehensive and accurate Staffing Models with FTE calculations. We're experts at building FTE Analysis Models and we've delivered them to over 300 organizations. We guarantee our models will help you solve your toughest staffing problems.
"AIM is a
unique and valuable tool for us. It delivers new information needed to make
better decisions and achieve our goals."
Larry Agoglia, Managing Director & COO Citigroup Private Bank
The AIM-Activity Information Modeling FTE Analysis Project
The FTE Analysis Models we deliver to our clients include extensive charts and graphs that show the amount of time spent on each activity, process, product, and customer. Other data is often collected such as "re-work" which is the time spent re-doing activities when the first transaction fails. We can include any data dimension you can imagine in your FTE Models.
Project Phases & Deliverables
An FTE Analysis Model Project takes between 3 and 8 weeks.
-
FTE Model Design: We work with you to design your FTE models. This usually requires three meetings.
-
Data Collection: Our Internet systems collect data from your staff as they work. The data collection spans 2 to 5 weeks and depends on the nature of the work.
-
FTE Model Preparation: We prepare your final staffing models as Microsoft Excel reports and files. Preparation usually requires 2 to 7 days.
-
Review: We review each chart and graph with you and your management team. Your project is not concluded until you and your team understand how to best use your new FTE Models to solve your problems and achieve your goals.
Scenario Planning & Predictive FTE Staffing Models
The last files you receive are specifically designed to help you analyze how changes to things such as processes and product features will change your staffing (FTE) requirements. You simply enter changes to product volume, job design, etc. and the worksheets predict the staffing requirements for that scenario.
With AIM FTE Models you will play the best, most accurate "what if" you have ever imagined.
The Business Case for FTE Models
Our clients always discover new ways to reduce staffing costs. They frequently realign areas of their organization for their strategic goals. Often this is accomplished by changing the mix of specialists and generalists and establishing new Shared Services Centers.
Additionally, the FTE Models allow them to get "in-front" of their staffing problems and solve them before they occur. They predict future staffing costs and conduct scenario planning; playing "what if" on paper (data models) with various scenarios until the optimal costs are achieved. Their new designs are then implemented quickly and precisely.
Our clients tell us they always recover a multiple of the project cost within 3 months.
Our No-cost 5 Day Evaluation Pilot
We offer a No-cost Evaluation Pilot that allows you to evaluate our methodology, technology, and deliverables. This pilot usually spans 5 days and delivers a set of FTE Analysis Models that are related to your processes, products and customers.
Are you frustrated because your efforts to improve productivity and organizational effectiveness take too long, cost too much and produce questionable results? New, accurate, easy to use FTE Analysis Models are the solution you need.
In weeks you could be implementing FTE models that reduce your staffing costs, increase productivity, and rationalize job responsibilities for your most critical goals.
Learn about our no-cost FTE Model evaluation pilot
Register for a FTE Model/Staffing Model Webinar
