Jeff, 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" <jeffreygsnyder@h otmail.com> To Sent by: mapics-l@xxxxxxxxxxxx mapics-l-bounces@ cc midrange.com Subject master scheduling - aggregate 08/16/2004 03:37 PM Please respond to MAPICS ERP System Discussion <mapics-l@midrang e.com> 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.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM 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 here. If you have questions about this, please contact