Excel BOM vs BPCS BOM & Requirement Checking

Hello All,

I was curious of how others are using BPCS to handle checking BPCS BOM for accuracy and checking the Planned Order requirements. Any recommendations would be greatly appreciated.

Currently our Planning Department maintains the BOM in BPCS. And our Supply Chain department puts togheter their BOM in an excel sheet and it calcultes the total quantiy required for each component that we create purchase orders for. Then IT runs MPS/MRP once per month. Once MRP is finished Supply Chain then checks BPCS BOM & Planned Requirements for each component against the BOM in Excel. And sometimes there are issues with the lack of communication with the two BOMs. I may be wrong but it seems to me that we are doubling our work by maintianing a two seperate BOMs but our users have very little trust in the BPCS system so almost everything in BPCS is checked against some type of excel sheet. I think BPCS does a good job but having to explain the proper way to use the system to its maximum capabilities for them to beleive. :-) And I am pretty new to BPCS myself.

So I was just looking for feedback on how this is handle for others. How do you check the BOM for accuracy? And how do you check the planned order quantities for accuracy before releaseing to purchase orders or shop orders?

Thanks in Advance


____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping