An input and output Excel file for a material supply assignment model

Abstract

Objective 1: To develop a work tool for companies that are using the mathematical model designed by dr. Veronique Limère. This tool has to targets: On the one hand, it has to be able to obtain different results depending on the values of the parameters in order that the employees can compare them. On the other hand it has to be easy to use and it must give the results in a comfortable way in order to the employee can understand the necessary information faster. Moreover, this thesis has a second objective in orther to put in practice the work tool mentioned in the first objective. It consists on: Objective 2: Studying a particular company data. We will consider possible changes in the way to supply parts, from the moment that parts are in the warehouses to the moment that they are picket to be assembled. Results will be obtained and analysed for each modification considered. vii To achieve these objectives the thesis follows the next structure: Firstly, in Chapter 1, an introduction of the sector and a brief explication of the thesis of dr. Veronique Limère are presented. In Chapter 2 is developed the tool for the companies and is explained how it has been developed. In Chapter 3 an extended analysis is realized and finally, in Chapter 4, conclusions are given.