Publicação
Two-level hierarchical framework for short-term production planning and scheduling
| Resumo: | This study aims to develop a two-level hierarchical production planning framework for a medium-sized Portuguese company that operates as a tier 2 supplier within the automotive production supply chain. The framework is designed to assist the decision-making process during the short-term planning of four progressive hydraulic presses used to produce cold-stamped parts for exhaust systems. The two hierarchical levels of the framework are: (i) a Mixed-Integer Linear Programming (MILP) model to determine the optimal quantities to be produced in a single machine while minimizing the total costs; and (ii) a dynamic production sequencing rule that defines the machine schedule based on three criteria that are relevant for the company. Both framework levels have been combined and implemented in Excel; in the first level, the MILP model is solved using the add-in Solver; then, the second level uses the optimal quantities to be produced as inputs to determine the production sequence through a mathematical procedure. The spreadsheet features a dashboard for intuitive use and presentation of results. The framework was validated by comparing it to a real plan executed by the company, and it was found that the plan proposed by the framework could save up to 20,6% of the total cost observed in reality. The framework requires a week-to-week rolling planning horizon in order to absorb uncertainties. |
|---|---|
| Autores principais: | Zanella, Fernando |
| Assunto: | Mixed integer linear programming Short-term production planning Hierarchical production planning |
| Ano: | 2023 |
| País: | Portugal |
| Tipo de documento: | dissertação de mestrado |
| Tipo de acesso: | acesso restrito |
| Instituição associada: | Instituto Politécnico de Bragança |
| Idioma: | inglês |
| Origem: | Biblioteca Digital do IPB |
| _version_ | 1867173244561260544 |
|---|---|
| author | Zanella, Fernando |
| author_facet | Zanella, Fernando |
| author_role | author |
| contributor_name_str_mv | Vaz, Clara B. Trentin, Robson Gonçalves Biblioteca Digital do IPB |
| country_str | PT |
| creators_json_txt | [{\"Person.name\":\"Zanella, Fernando\"}] |
| datacite.contributors.contributor.contributorName.fl_str_mv | Vaz, Clara B. Trentin, Robson Gonçalves Biblioteca Digital do IPB |
| datacite.creators.creator.creatorName.fl_str_mv | Zanella, Fernando |
| datacite.date.Accepted.fl_str_mv | 2023-01-01T00:00:00Z |
| datacite.date.available.fl_str_mv | 2023-04-17T14:26:29Z |
| datacite.date.embargoed.fl_str_mv | 2023-04-17T14:26:29Z |
| datacite.rights.fl_str_mv | http://purl.org/coar/access_right/c_16ec |
| datacite.subjects.subject.fl_str_mv | Mixed integer linear programming Short-term production planning Hierarchical production planning |
| datacite.titles.title.fl_str_mv | Two-level hierarchical framework for short-term production planning and scheduling |
| dc.contributor.none.fl_str_mv | Vaz, Clara B. Trentin, Robson Gonçalves Biblioteca Digital do IPB |
| dc.creator.none.fl_str_mv | Zanella, Fernando |
| dc.date.Accepted.fl_str_mv | 2023-01-01T00:00:00Z |
| dc.date.available.fl_str_mv | 2023-04-17T14:26:29Z |
| dc.date.embargoed.fl_str_mv | 2023-04-17T14:26:29Z |
| dc.format.none.fl_str_mv | application/pdf |
| dc.identifier.none.fl_str_mv | http://hdl.handle.net/10198/28192 |
| dc.language.none.fl_str_mv | eng |
| dc.rights.cclincense.fl_str_mv | http://creativecommons.org/licenses/by-nc/4.0/ |
| dc.rights.none.fl_str_mv | http://purl.org/coar/access_right/c_16ec |
| dc.subject.none.fl_str_mv | Mixed integer linear programming Short-term production planning Hierarchical production planning |
| dc.title.fl_str_mv | Two-level hierarchical framework for short-term production planning and scheduling |
| dc.type.none.fl_str_mv | http://purl.org/coar/resource_type/c_bdcc |
| description | This study aims to develop a two-level hierarchical production planning framework for a medium-sized Portuguese company that operates as a tier 2 supplier within the automotive production supply chain. The framework is designed to assist the decision-making process during the short-term planning of four progressive hydraulic presses used to produce cold-stamped parts for exhaust systems. The two hierarchical levels of the framework are: (i) a Mixed-Integer Linear Programming (MILP) model to determine the optimal quantities to be produced in a single machine while minimizing the total costs; and (ii) a dynamic production sequencing rule that defines the machine schedule based on three criteria that are relevant for the company. Both framework levels have been combined and implemented in Excel; in the first level, the MILP model is solved using the add-in Solver; then, the second level uses the optimal quantities to be produced as inputs to determine the production sequence through a mathematical procedure. The spreadsheet features a dashboard for intuitive use and presentation of results. The framework was validated by comparing it to a real plan executed by the company, and it was found that the plan proposed by the framework could save up to 20,6% of the total cost observed in reality. The framework requires a week-to-week rolling planning horizon in order to absorb uncertainties. |
| dirty | 0 |
| eu_rights_str_mv | restrictedAccess |
| format | masterThesis |
| fulltext.url.fl_str_mv | https://bibliotecadigital.ipb.pt/bitstreams/67d8bf30-a29a-457d-b7c6-4c52110e6ad3/download |
| id | ipb_f85dafaa2777fba608bb984d85f2a897 |
| identifier.url.fl_str_mv | http://hdl.handle.net/10198/28192 |
| instacron_str | ipb |
| institution | Instituto Politécnico de Bragança |
| instname_str | Instituto Politécnico de Bragança |
| language | eng |
| network_acronym_str | ipb |
| network_name_str | Biblioteca Digital do IPB |
| oai_identifier_str | oai:bibliotecadigital.ipb.pt:10198/28192 |
| organization_str_mv | urn:organizationAcronym:ipb |
| person_str_mv | Zanella, Fernando |
| publishDate | 2023 |
| reponame_str | Biblioteca Digital do IPB |
| repository_id_str | urn:repositoryAcronym:ipb |
| service_str_mv | urn:repositoryAcronym:ipb |
| spelling | engpt_PTThis study aims to develop a two-level hierarchical production planning framework for a medium-sized Portuguese company that operates as a tier 2 supplier within the automotive production supply chain. The framework is designed to assist the decision-making process during the short-term planning of four progressive hydraulic presses used to produce cold-stamped parts for exhaust systems. The two hierarchical levels of the framework are: (i) a Mixed-Integer Linear Programming (MILP) model to determine the optimal quantities to be produced in a single machine while minimizing the total costs; and (ii) a dynamic production sequencing rule that defines the machine schedule based on three criteria that are relevant for the company. Both framework levels have been combined and implemented in Excel; in the first level, the MILP model is solved using the add-in Solver; then, the second level uses the optimal quantities to be produced as inputs to determine the production sequence through a mathematical procedure. The spreadsheet features a dashboard for intuitive use and presentation of results. The framework was validated by comparing it to a real plan executed by the company, and it was found that the plan proposed by the framework could save up to 20,6% of the total cost observed in reality. The framework requires a week-to-week rolling planning horizon in order to absorb uncertainties.application/pdfpt_PTTwo-level hierarchical framework for short-term production planning and schedulingZanella, FernandoVaz, Clara B.Trentin, Robson GonçalvesHostingInstitutionOrganizationalBiblioteca Digital do IPBe-mailmailto:dspace@ipb.ptdspace@ipb.ptURNurn:tid:2032720302023-04-17T14:26:29Z20232023-01-01T00:00:00ZHandlehttp://hdl.handle.net/10198/28192http://purl.org/coar/access_right/c_16ecrestricted accessMixed integer linear programmingShort-term production planningHierarchical production planning6165301 bytesliteraturehttp://purl.org/coar/resource_type/c_bdccmaster thesis2023http://creativecommons.org/licenses/by-nc/4.0/http://purl.org/coar/access_right/c_16ecapplication/pdffulltexthttps://bibliotecadigital.ipb.pt/bitstreams/67d8bf30-a29a-457d-b7c6-4c52110e6ad3/download |
| spellingShingle | Two-level hierarchical framework for short-term production planning and scheduling Zanella, Fernando Mixed integer linear programming Short-term production planning Hierarchical production planning |
| status | SINGLETON |
| subject.fl_str_mv | Mixed integer linear programming Short-term production planning Hierarchical production planning |
| title | Two-level hierarchical framework for short-term production planning and scheduling |
| title_full | Two-level hierarchical framework for short-term production planning and scheduling |
| title_fullStr | Two-level hierarchical framework for short-term production planning and scheduling |
| title_full_unstemmed | Two-level hierarchical framework for short-term production planning and scheduling |
| title_short | Two-level hierarchical framework for short-term production planning and scheduling |
| title_sort | Two-level hierarchical framework for short-term production planning and scheduling |
| topic | Mixed integer linear programming Short-term production planning Hierarchical production planning |
| topic_facet | Mixed integer linear programming Short-term production planning Hierarchical production planning |
| url | http://hdl.handle.net/10198/28192 |
| visible | 1 |