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.firstname.lastname@example.org -----Original Message----- From: Tom Wood [mailto:email@example.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: firstname.lastname@example.org +--- +--- | 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: email@example.com +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.