We master schedule to the model (could be considered family).  Each model
has from 4 to 16 different part numbers (plain, heater, reefer,
heater/reefer combo, hot water, other options, and the whole thing repeated
between US and Canadian).  In MPSP/MRP planning we use a percentage mix,
based on historical percentages of what we actually end up building.  When
it's time to actually release the orders, Sales meets with the Master
Scheduler (usually one week ahead, when we have the actual orders in hand)
and they adjust the mix for the actual orders to be released.

We wrote an MPSP off-line load to assist the Master Scheduler with loading
the schedule due to the bazillion or so entries every week.

We carry some safety stock through overplanning the options to handle
mis-guesses.  It's not the best of all possible solutions, but it works.
Oddly enough, we rarely get caught short on the optional stuff.  Purchasing
usually gets caught with shortages for common parts that are used on EVERY
configuration.  That puzzles me.....

Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA  15501

             "Jeff Snyder"                                                 
   >                                                To 
             Sent by:                  mapics-l@xxxxxxxxxxxx               
             mapics-l-bounces@                                          cc 
                                       master scheduling - aggregate       
             08/16/2004 03:37                                              
             Please respond to                                             
             MAPICS ERP System                                             

   Hey Group

   I have a customer who can determine an aggregate volume of a family to
   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
   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
   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
   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

   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,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page