Now I'm admittedly not a cost accountant nor an operations analyst but
wouldn't the times associated with any end item shop order for a quantity
greater than, say, 10 yield a pretty good representative time for 1 unit?
Total of the runtimes for each operation / shop order quantity = average
time for 1 unit.
Replace runtimes with setup times in the formula for those averages.
Roy Luce
Systems Plus - Midwest
Direct: 847-540-9635
800-913-PLUS (7587)
Cell: 847-910-0884
Email: rluce@xxxxxxxxxxxxxxxxxxx
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Joe Perrault
Sent: Friday, March 06, 2009 12:08 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
The Averages calculated in the ROUTNG file are for operation steps, not
production facility. I don't believe that there is an average hours
calculated for a finished item. You could probably calculate something
by using the Run Labor Hours to date fields in the MOHRTG file, summing
by item for a given time period and dividing by the total complete
quantity. You may have to account for incomplete ops, scrap, cancelled
jobs, etc depending on what your objective is.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Ioffe, Jane
[BUL/LAK]
Sent: Friday, March 06, 2009 11:11 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
Still, the question was on the Average hours per item , not work center.
Work center or Production facility could have multiple items. We need to
know Per One item how much we spent on average...
Thank you and Regards,
Jane Ioffe
847-295-4593
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Perrault
Sent: Friday, March 06, 2009 10:29 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
From the knowledgebase:
This can be caused by any of the following:
1) The last Order Close and Purge in IM may have said NO to Update
routing averages. If that happened, no averages would have changed.
2) The manufacturing order was force closed and the operation in
question was at a status 10, 20, or 30. Only status 40 operations
update averages in the PDM file. If the order had a status of 50 or 55,
the operation would be at a status 40 and would have updated the average
in the ROUTNG file, unless 3) is true.
3) If the operation is at a status 40, but the qty reported complete is
0.0, MAPICS could not convert the actual time back to the unit TBC times
in the routing file, so did not update the averages.
4) Someone has changed the TBC factor in the standard routing in PDM
since the last order close and purge. Changing the TBC factor will zero
the routing averages and set the NOTIM (number of times the averages
have been updated) field to zero.
5) Average run times are updated only when the actual work center for
the operation in the MOROUT file is the same as the standard work center
defined in the ROUTNG file. If a work center override was entered
during shop activity update, averages in the standard routing are not
updated.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Ioffe, Jane
[BUL/LAK]
Sent: Friday, March 06, 2009 10:04 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
For some reason it's not updated in our ROUTNG. Is there a set up we
should've done?
Thank you and Regards,
Jane Ioffe
847-295-4593
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Perrault
Sent: Friday, March 06, 2009 8:57 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] PCC reporting - run labor hours per machine
There is a running average calculated and stored in the ROUTNG file for
each operation.
Joe Perrault
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Ioffe, Jane
[BUL/LAK]
Sent: Friday, March 06, 2009 8:48 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] PCC reporting - run labor hours per machine
Hello All,
I wonder if anybody knows if there is a report available in PCC or PMC
to calculate average hours spent for building any finished good item.
It could be using a range criteria for an item or completion date.
We are at R5.5 , but would think it should be a pretty basic function
of any manufactured shop.
I imagine it could be done separately, in Query or any reporting tool,
using MOHRTG and MOHMST with calculation of total hours spent per
operation divided by total qty completed this period, but still curious
if anybody else needed that in their workshop.
Thank you in advance,
Jane Ioffe
Applications System Analyst
Buehler LTD
41 Waukeegan Rd. Lake Bluff, IL 60044
(847) 295-4593
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
midrange.com
