I know what I want to calculate. It's just that I'm stuck on what
mathematics to use. We only have 6 employees to process the work and at
times it can be very hectic. But I don't think upper management is taking
into consideration of vacation time, sick time, etc.
Are you in the banking industry, operations?

"HALinNY" wrote:



"vvcano" wrote:

I work in an operations environment (banking). for example yesterday we
processed 38k items. this involves keying, balancing, work prep, etc. what
factors can I use to determine how many employees I actually needed for the
evening.


You probably have work measurement standards for every task in the
department. So you need to derate them, probably by 20%-25%, to determine
the number of employees for each task based on the number of items.

Unfortunately the result will probably be too high because not all tasks are
spread out evenly over the course of a shift. Proofing ops wind down with
time and Balancing goes up. Transit is fairly constant but does not kick in
until halfway into the shift. Things like that.

Then there are seasonal fluctuations, and time of month fluctuations (auto
deposits and withdrawals) and illness fluctuations and skill levels and
competencies of employees (can a transit clerk run an encoder?).

I am not sure there is a template that solves this problem because while the
calculations are quite simple, the external factors are quite complicated and
localized.

So the problem here is not HOW to calculate but WHAT to calculate and WHAT
is not an Excel question because you would have the same problems with paper
and pencil.

Does the ABA have anything that could help?

Standard disclaimer applies.

B+
HALinNY