RE: master scheduling - aggregate

Jeff:

You might want to check into Systems Plus's OTTO  (www.ottorpm.com).  One of
the package's many functions is a Master Schedule Summary query that reports
the Demand versus Supply for Master Scheduled items over a 10 week period.

For example:
                             PAST
ITEM     DESCRIPTION   BOH    DUE   11/15   11/22   11/29   12/06   12/13
12/20   12/27   01/03   01/10  TOTAL

0113003   DEMAND                               25                      25
14       2       2     68
          SUPPLY                               25              26
14                     65

0213653   DEMAND                        8                      56
6     70
          SUPPLY                                8              56
64

0231132   DEMAND                2               2       2
5                             11
          SUPPLY         1      1               2       2               5

The query, and its available report, can be all Master Scheduled items, a
family of items, a range or even items based on a number of criteria.

Because OTTO is driven by sales orders everything you are trying to
accomplish, and substantially more, is supported by OTTO.  In your client's
case they'd probably select a family and explode down just one level,
providing sales the information they need at the item level.

If you'll  contact me off list I will send you some real-life examples of
the report from a few OTTO users - this list strips attachments.

Or you can read more about OTTO's underlying concept, Rapid Priority
Management (RPM), in Carol Ptak's book "ERP Tools, Techniques and
Applications for Integrating the Supply Chain; Second Edition" - the
discussion starts on page 188.


Roy Luce
Systems Plus

Main:   847-540-9635
Cell:   847-910-0884
Fax:    208-330-9032
Email:  lwl@xxxxxxxxxxxxx

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]On
Behalf Of Jeff Snyder
Sent: Monday, August 16, 2004 2:38 PM
To: mapics-l@xxxxxxxxxxxx
Subject: master scheduling - aggregate

   Hey Group

   I have a customer who can determine an aggregate volume of a family to be
   produced,  but can not determine the family part number breakdown.
   They may have hundreds of part numbers in a family, and can only produce
   say 400 a month of the entire family.  They cannot master schedule to the
   individual part number, would never guess the right mix.  Nor will
   percentages work 'i.e. planning bills.

   They do not schedule any production,or purchasing activities until the
   customer order is in hand, i.e. the customer order is quoted outside of
   std CMLT.

   The question, concern is how to stop sales from overbooking the
'aggregate
   volume' for a family of final assembly  parts ?

   In the above example of 400 a month,  they would like sales to have the
   visibility of knowing what was booked on all sales orders for any item
   participating in that family so they will not over commit the 400 a
   month.  They would like the sales rep to be able to perform the ATP on
the
   phone, to insure a good promise date, but not based on the part number,
   but aggregate demand compared to aggregate schedule for that family of
   parts.

   Has anyone written any such code, or is there a 3rd party pkg available.
   Otherwise we will probably write something. Just wanted to check first.

   Thanks for your attention, and look fwd to your input.


   Jeff Snyder,  CPIM
   Mapics Consultant
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.