Supply vs.Demand

Looking for a process to determine Sales Order requirements, inventory
status, and net requirements for a multi level BOM linked to a specific or
group of Sales Orders. Example as follows:

INPUT:

Part A
Multi-Level BOM

L0 PartA QtyPer
L1 Sub1.1 1
L2 Sub1.2 5
L3 Sub1.3 10
L4 Sub1.4 1

Sales Order# 123 for Part A for quantity = 25 pieces

OUTPUT:

L0 PartA QtyTotal FG WIP DELTA
L1 Sub1.1 25 0 10 -15
L2 Sub1.2 125 0 100 -25
L3 Sub1.3 1,250 0 1,000 -250
L4 Sub1.4 1,250 0 1,650 +400

Does anyone out there have a report or program that they are using that
will reach this requirement?

Regards,

Travis Late
Divisional IT Manager
+1 619 216 2217 Office
+1 920 960 0062 Mobile
tlate@...

Doncasters GCE Industries, Inc.
1891 Nivana Avenue, Chula Vista, CA 91911


************************************************************************

This e-mail is sent on behalf of Doncasters. Its contents are confidential to the recipient and may be legally privileged.

If you are not the intended recipient:

(1) You must not disclose, copy or distribute its contents to any other person nor use its contents in any way;

(2) Please contact Doncasters IT on +44 (0) 1332 694143 quoting the name and sender and the addressee then delete it from your system.

For general enquiries please contact +44 (0) 1332 864900

Doncasters has scanned this e-mail for viruses but does not accept any responsibility for viruses once this e-mail has been transmitted. You should scan attachments (if any) for viruses.

************************************************************************

Doncasters Limited, registered in England no. 321992 at Millennium Court, First Avenue, Burton-upon-Trent, Staffordshire, DE14 2WH, UK


[Non-text portions of this message have been removed]