60 likes | 196 Vues
This document details the optimization of sequencing orders for producing end panels in manufacturing. It outlines key algorithms utilized to streamline setup processes while minimizing waste and overproduction. The scheduling challenges faced due to variable shipping schedules and inventory management are discussed. An MRP system (AS400) is employed to predict demand, and Excel is used to visualize and report the algorithm's outcomes. Constraints such as color demand variability and cabinet type quantities are also analyzed, ensuring efficient production alignment.
E N D
Sequencing Orders • What order do I go in??? • Due Date • Similarity Set-ups • Demand Associated to it • Algorithm • Optimization
End Panel Example Bases - 106” or Vanities - 97” Length 61” Both Products Upper Strip s Base End Panel
End Panel Algorithm • Constraints • 1 strip per 6 base cabinets • 97” strip could make: • 3- 30” upper end panels • 2 – 42” upper end panels and 1- 12” • 106” strips could make: • 3- 30” upper end panels and 1 -12” • 2 – 42” upper end panels and 1 – 18” • 2 – 42” upper end panels and 1 – 12”
End Panel Ex. Continued • Constraints: • Volume and Usage varied by color • Maples and Cherries tend to have more 42” cabinets • Oak tended to have more 30” cabinets • Some colors were less popular and could be ran less often (12 day inventory versus a 3-day inventory) • Set-up was not short • Operators & Supervisors used to doing whatever made numbers look better • Supervisors did not like to follow a scheduling system or turn in inventory numbers. • Shipping Schedule varied by day (20 trucks scheduled on Saturday versus 8 on Friday) • Staffing different by day.
End Panel Algorithm • Used a Min/Max system with orders • Used MRP system (AS400) to generate quantities based on # of days looked in the future for orders • Downloaded Information into Excel • Used an Algorithm to maximize the set-up without overproducing one size of upper end panels. • Excel printed out report • Supervisors reported what they actually did to feed it back into the system.