Hello,
I have been using Epicor 1 year. Our previous controller left 3 years ago, and apparently took most of our cost process knowledge with her. We only have material, at average cost, in our Epicor costs, so it would seem this is as simple as it could be. That said, we are confused.
I am in Supply Chain and am being asked to explain BOM cost changes from 2 years ago to now.
Part Advisor and Completed Jobs show a similar “high cost” over the past year
I have a BAQ with Issued Matieral, that gets within 5% of the Job Cost and Part Advisor.
Method Tracker View Costs has three fields, which confuse me:
- Part Cost is a total only, and it matches the Job Cost and Part Advisor
- Total Cost has detail, but is low by 5%
- Unit cost has detail, but is low by 5% and matches Total
What is the difference between these three?
If there as detail for Part, I could review component differences.
I believe that whatever cost from two years ago that has been used as a reference, was not accurate.
The costs we are reviewing are for a final assembly of 1200 parts/assemblies.
This final assembly is newly developed over the past two years, so the BOM has changed continually. Further, our interface with Solid Works leads to components and assemblies “disappearing” at times, so the chances that the old reference cost was different from today are virtually 100%.
Bottom line:
I would personally like to understand how Epicor cost is being derived and where that amount appears. I would like extract a full BOM (like the Method Tracker View Costs or a BAQ) to excel, so that I can fill in current component costs, future component costs, etc.
We started down the Costing Dashboard path, but I am leery of doing much, even if I have to post to do any damage. However, perhaps that is the answer.
Or, maybe Projects is the answer...we use it at an extremelhy basic level, but are looking to do more with it.
Any advice would be appreciated. 🙂