RE: Time Apportionment Puzzler

Tom,
        We have a similar situation in which we need to calculate labor
efficiencies for multi-pallet machines.  We have written a program which is
called from the PMC CL AMJPCJ, Select and Edit.  The program does the
following calculations:
1.  Calculate elapsed job time for each concurrently running job by taking
the ON/OFF transactions in the TRDATA file and the ADJDT and ADJTM fields.  
2.   Calculate standard job time for each job running => elapsed job time *
standard hours / piece
3.   Calculate total standard time by adding standard job time for each job
(total of all #2's)
4.   Calculate % of total job time =>  Standard time for each job (#2) /
total standard time (#3)
5.   Calculate each apportioned time => elapsed time * % of total job time
(#3) 
We then calculated employee efficiency % by dividing the apportioned time
per job (#5) by the standard job time (#2).
I know this is rather vague.  If this is indeed what you are looking for, I
can further review the program to get more specifics for you.
        Another alternative for you would be the MAPICS Manufacturing Data
Collection and Communication module which I believe can be set up to
apportion time in the same manner.  We are currently in the process of
migrating from DBY2K to XA5.5, and will be installing the MDCC module in the
process so time will tell on that one!

Good Luck!

Barb
Barb.nash@phbcorp.com




 -----Original Message-----
From:   Tom Wood [mailto:tomw@fortrecoveryindustries.com] 
Sent:   Tuesday, August 29, 2000 10:39 AM
To:     MAPICS-L@midrange.com
Cc:     Barry Hounshell; Larry Holmes; Nate Pfeffer; Steve Reier
Subject:        Time Apportionment Puzzler

Facts:
MAPICS XA Release 4
Job Off transactions
Data Collection Connection w/IBM 7526 terminals
PMC,PCC,IM

Background:
I work for a company that makes die castings and have encountered a problem
with apportioning or allocating actual labor and machine time.  The problem
occurs since MAPICS allocates or apportions time strictly accross
concurrently running MO's.  In our environment, we may have three or four
MO's running concurrently on the same machine, which is not a problem ....
however, each MO for a particular item may have a different number of
inserts or cavities which affects the allocation.

Example:
Think of it as a muffin pan that holds 8 muffins ... depending on
scheduling, the workcenter (muffin pan) may be running 4 blueberry, 2 raisin
and 2 plain muffins represented by 3 MO's.  In this example, MAPICS would
allocate 33% labor to each MO, when in reality we need 50% allocated to
blueberry, 25% to raisin and 25% to plain.

It sounds like a minor problem, but since we have 20 die cast  machines, it
has become a bigger issue than anticipated.  We hope to resolve within
MAPICS and without having the operators jump through too many reporting
hoops to accomplish this.  Also would like to keep mods and customization to
a minimum, if at all.  Keep in mind, we are using barcode data collection
terminals using DCC, scanning shop packet turnaround #'s.

Any input is appreciated, thanks.

+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---