Most BPCS users have an established policy where the BOM is created by
engineering or a manufacturing engineer.

All of the data elements are checked thoroughly by all of the related
departments for accuracy.

The data elements are Item master, facility planning, BOM's and routings.

Once they are found to be accurate and signed-off. MPS/MRP are generated and

This is where you would find any discrepancies for the planned shop orders
and planned purchase orders.

It is recommended not to have a BOM in an excel spreadsheet that is
perceived to be accurate.

You should always have the ERP system be the "gospel".

Please remember that if the BOM and routings are incorrect that it will
cause inaccurate standard costs.

Running MPS/MRP normally occurs daily not monthly.

Hope that this helps!

-----Original Message-----
[] On Behalf Of
Larenzo Alexander
Sent: Tuesday, February 05, 2008 9:29 AM
To: BPCS Forum Post
Subject: [BPCS-L] 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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.