Anyone else do this?

Yahoo Archive
1
Bob,
We have developed an incentive system using MS Access to pay our operators
and setup employees a bonus based on their labor captured in Vantage. We
use the ODBC driver to query the Progress database. We also use a VB form
in the job at the operation level to set our standards of time and cost.
The issue of calculating efficiency when an employee is clocked onto more
than one job is a difficult one. We break down the time periods by payroll
date and look to see what jobs 'overlap' one another for an operator. Our
system adjusts the incentive bases on how many jobs are being run. The more
jobs being run the lower the efficiency needed to make the incentive and the
incentive also increases with each additional job being run. In all it took
several weeks to program and even longer to perfect. It is possible to do
but not a small task to be taken lightly.

Hop ethios helps

John

-----Original Message-----
From: Bob Goss [mailto:bobg@...]
Sent: Wednesday, December 13, 2000 3:36 PM
To: 'vantage@egroups.com'
Subject: [Vantage] Anyone else do this?


We are in the process of trying to implement a pay system based on various
elements. One of the elements is the productivity associated with the
position of Operators and Set up Staff. We plan on measuring performance
through Vantage for specific jobs that have been run before. i.e., Jobs that
have proven times. I am going to try and get a custom report built to
produce the employee efficiency report, but have added filters to only
include those Jobs that have been tagged as "measurable" My question to the
group is, are any of you using Vantage as a tool to measure the employee
efficiency over a period of 2 or 3 months. If so,(1) how do you deal with
those employees who may be running more than one work centre at the same
time? (2), how do you deal with jobs that you have not run before whereby
the estimated set up and production times may not be realistic?

I doubt that this is a unique question, but would love to hear from any of
you with your thoughts on this.

Bob Goss
Controller
BC Instruments


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
2
We are in the process of trying to implement a pay system based on various
elements. One of the elements is the productivity associated with the
position of Operators and Set up Staff. We plan on measuring performance
through Vantage for specific jobs that have been run before. i.e., Jobs that
have proven times. I am going to try and get a custom report built to
produce the employee efficiency report, but have added filters to only
include those Jobs that have been tagged as "measurable" My question to the
group is, are any of you using Vantage as a tool to measure the employee
efficiency over a period of 2 or 3 months. If so,(1) how do you deal with
those employees who may be running more than one work centre at the same
time? (2), how do you deal with jobs that you have not run before whereby
the estimated set up and production times may not be realistic?

I doubt that this is a unique question, but would love to hear from any of
you with your thoughts on this.

Bob Goss
Controller
BC Instruments
3
Hi Bob,

You wrote "My question to the group is, are any of you using Vantage as a
tool to measure the employee efficiency over a period of 2 or 3 months."

The word "efficiencies" rings a bell. We did some analysis recently on how
we did in reality (actual), compared to how we were supposed to do
(standard). But we did most of it in Excel. Our Excel guru did a simple
Report Builder report to dump gobs of date from the time clock tables. Then
he wrote macros in Excel to categorize how the jobs did. For instance, jobs
WAY OVER standard (by percentage) were flagged for possible clocking errors.
Jobs SOMEWHAT OVER standard were noted to see how we could improve our
times. Jobs UNDER standard were graphed to see if we actually really did a
good job, or was it another clocking problem.

It took hours of 'programming' in excel, but I think he has it mostly
automated now to group the various categories and do some graphs (along with
real data).

I don't know if his Excel program is shareable at this point, but it might
give you some ideas on how to proceed. (I actually have NO CLUE how he
actually did it, by the way.)

Troy Funte
Liberty Electronics
----- Original Message -----
From: "Bob Goss" <bobg@...>
To: <vantage@egroups.com>
Sent: Wednesday, December 13, 2000 12:36 PM
Subject: [Vantage] Anyone else do this?


> We are in the process of trying to implement a pay system based on various
> elements. One of the elements is the productivity associated with the
> position of Operators and Set up Staff. We plan on measuring performance
> through Vantage for specific jobs that have been run before. i.e., Jobs
that
> have proven times. I am going to try and get a custom report built to
> produce the employee efficiency report, but have added filters to only
> include those Jobs that have been tagged as "measurable" My question to
the
> group is, are any of you using Vantage as a tool to measure the employee
> efficiency over a period of 2 or 3 months. If so,(1) how do you deal with
> those employees who may be running more than one work centre at the same
> time? (2), how do you deal with jobs that you have not run before whereby
> the estimated set up and production times may not be realistic?
>
> I doubt that this is a unique question, but would love to hear from any of
> you with your thoughts on this.
>
> Bob Goss
> Controller
> BC Instruments
>
>
> We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
>