Material Requirements Explosion

We need to produce a weekly report listing ingredients required to produce items
for order fulfillment the following week.  There aren't a lot of orders/items
involved.  Our users find setting up a full MRP run to be time-comsuming and
overkill versus their needs.

Items and quantities to be produced would be input.  Referencing the BOM, the
process needs to account for ingredient quantity on-hand, committed and on-order
then calculate the variance to requirements.  This will allow the user to
quickly review the listing and determine if purchasing is needed to meet
production.

Does anyone know of a quasi-quick and dirty way to address this?  What approach
would you use?

We're running v6.0.2MM on an AS/400.

TIA,

Eric Stevens
Snr. Systems Analyst
Supply Chain Organization
Allied Domecq Retailing, USA
Baskin-Robbins/Togos/Dunkin' Donuts


+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---