Hello Everyone;
I want to prepaire an excel sheet which has some constraints, first af all weekly number of products which will be produced are defined by Production Planning department each product has a different St. (production) time and each belongs different carline. (astra, meriva, corsa). Totaly 250 product have to be produced in a day.
<table style="width: 4px; height: 144px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl77" style="height:12.75pt;width:66pt" height="17" width="88">
</td><td class="xl77" style="border-left:none;width:80pt" width="107">
</td><td class="xl76" style="border-left:none;width:66pt" width="88"> <table border="0" cellpadding="0" cellspacing="0" width="372"><colgroup><col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl77" style="height:12.75pt;width:66pt" height="17" width="88">Product Num</td> <td class="xl77" style="border-left:none;width:80pt" width="107">Plan quantity</td> <td class="xl76" style="border-left:none;width:66pt" width="88">Carline</td> <td class="xl76" style="border-left:none;width:67pt" width="89">ST</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364349</td> <td class="xl76" style="border-top:none;border-left:none">56</td> <td class="xl76" style="border-top:none;border-left:none">Meriva</td> <td class="xl76" style="border-top:none;border-left:none">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364542</td> <td class="xl76" style="border-top:none;border-left:none">9</td> <td class="xl76" style="border-top:none;border-left:none">Meriva</td> <td class="xl76" style="border-top:none;border-left:none">0,804572</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13365107</td> <td class="xl76" style="border-top:none;border-left:none">29</td> <td class="xl76" style="border-top:none;border-left:none">Astra</td> <td class="xl76" style="border-top:none;border-left:none">0,753855667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364510</td> <td class="xl76" style="border-top:none;border-left:none">55</td> <td class="xl76" style="border-top:none;border-left:none">Astra</td> <td class="xl76" style="border-top:none;border-left:none">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364544</td> <td class="xl76" style="border-top:none;border-left:none">4</td> <td class="xl76" style="border-top:none;border-left:none">Corsa</td> <td class="xl76" style="border-top:none;border-left:none">0,673205</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13359968</td> <td class="xl76" style="border-top:none;border-left:none">8</td> <td class="xl76" style="border-top:none;border-left:none">Corsa</td> <td class="xl76" style="border-top:none;border-left:none">0,651970667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13359960</td> <td class="xl76" style="border-top:none;border-left:none">89</td> <td class="xl76" style="border-top:none;border-left:none">Corsa</td> <td class="xl76" style="border-top:none;border-left:none">0,641393667</td> </tr> </tbody></table>
To produce those products I have 18 boards, ı want to balance the st times and decide which product will be produced after which product and I also has to consider the type of boards I have (meriva, astra,corsa). If st of one product is longer the another product's st should be short and the other one is little bit longer again. As in the graph.
<table border="0" cellpadding="0" cellspacing="0" width="251"><colgroup><col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> </colgroup><tbody><tr style="height:13.5pt" height="18"> <td class="xl76" style="height:13.5pt;width:119pt" height="18" width="159">product num</td> <td class="xl76" style="width:69pt" width="92">st</td> </tr> <tr style="height:13.5pt" height="18"> <td class="xl76" style="height:13.5pt" height="18">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:13.5pt" height="18"> <td class="xl76" style="height:13.5pt" height="18">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13365107</td> <td class="xl76">0,753855667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13365107</td> <td class="xl76">0,753855667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> </tbody></table>
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">Would you help me to prepaire a daily plan in which order to produce?
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr></tbody></table>
I want to prepaire an excel sheet which has some constraints, first af all weekly number of products which will be produced are defined by Production Planning department each product has a different St. (production) time and each belongs different carline. (astra, meriva, corsa). Totaly 250 product have to be produced in a day.
<table style="width: 4px; height: 144px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl77" style="height:12.75pt;width:66pt" height="17" width="88">
</td><td class="xl77" style="border-left:none;width:80pt" width="107">
</td><td class="xl76" style="border-left:none;width:66pt" width="88"> <table border="0" cellpadding="0" cellspacing="0" width="372"><colgroup><col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:3913;width:80pt" width="107"> <col style="mso-width-source:userset;mso-width-alt:3218;width:66pt" width="88"> <col style="mso-width-source:userset;mso-width-alt:3254;width:67pt" width="89"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl77" style="height:12.75pt;width:66pt" height="17" width="88">Product Num</td> <td class="xl77" style="border-left:none;width:80pt" width="107">Plan quantity</td> <td class="xl76" style="border-left:none;width:66pt" width="88">Carline</td> <td class="xl76" style="border-left:none;width:67pt" width="89">ST</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364349</td> <td class="xl76" style="border-top:none;border-left:none">56</td> <td class="xl76" style="border-top:none;border-left:none">Meriva</td> <td class="xl76" style="border-top:none;border-left:none">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364542</td> <td class="xl76" style="border-top:none;border-left:none">9</td> <td class="xl76" style="border-top:none;border-left:none">Meriva</td> <td class="xl76" style="border-top:none;border-left:none">0,804572</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13365107</td> <td class="xl76" style="border-top:none;border-left:none">29</td> <td class="xl76" style="border-top:none;border-left:none">Astra</td> <td class="xl76" style="border-top:none;border-left:none">0,753855667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364510</td> <td class="xl76" style="border-top:none;border-left:none">55</td> <td class="xl76" style="border-top:none;border-left:none">Astra</td> <td class="xl76" style="border-top:none;border-left:none">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13364544</td> <td class="xl76" style="border-top:none;border-left:none">4</td> <td class="xl76" style="border-top:none;border-left:none">Corsa</td> <td class="xl76" style="border-top:none;border-left:none">0,673205</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13359968</td> <td class="xl76" style="border-top:none;border-left:none">8</td> <td class="xl76" style="border-top:none;border-left:none">Corsa</td> <td class="xl76" style="border-top:none;border-left:none">0,651970667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt;border-top:none" height="17">13359960</td> <td class="xl76" style="border-top:none;border-left:none">89</td> <td class="xl76" style="border-top:none;border-left:none">Corsa</td> <td class="xl76" style="border-top:none;border-left:none">0,641393667</td> </tr> </tbody></table>
To produce those products I have 18 boards, ı want to balance the st times and decide which product will be produced after which product and I also has to consider the type of boards I have (meriva, astra,corsa). If st of one product is longer the another product's st should be short and the other one is little bit longer again. As in the graph.
<table border="0" cellpadding="0" cellspacing="0" width="251"><colgroup><col style="mso-width-source:userset;mso-width-alt:5814;width:119pt" width="159"> <col style="mso-width-source:userset;mso-width-alt:3364;width:69pt" width="92"> </colgroup><tbody><tr style="height:13.5pt" height="18"> <td class="xl76" style="height:13.5pt;width:119pt" height="18" width="159">product num</td> <td class="xl76" style="width:69pt" width="92">st</td> </tr> <tr style="height:13.5pt" height="18"> <td class="xl76" style="height:13.5pt" height="18">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:13.5pt" height="18"> <td class="xl76" style="height:13.5pt" height="18">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13365107</td> <td class="xl76">0,753855667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13365107</td> <td class="xl76">0,753855667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13359960</td> <td class="xl76">0,641393667</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364349</td> <td class="xl76">1,170833</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl76" style="height:12.75pt" height="17">13364510</td> <td class="xl76">0,729281667</td> </tr> </tbody></table>
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">Would you help me to prepaire a daily plan in which order to produce?
</td></tr><tr style="height:12.75pt" height="17"><td class="xl76" style="height:12.75pt;border-top:none" height="17">
</td><td class="xl76" style="border-top:none;border-left:none">
</td><td class="xl76" style="border-top:none;border-left:none">
</td></tr></tbody></table>