This chapter is about the structure of a decision tool for job loading. The program can be used to assign job for each machine in each day. Parts to be produced in each machine can be classified into two groups. Some parts can be produced in a specific machine; we will call “Fix part”. Another that can be produced in more than one machine, we will call “Independent part”.
The program is based on Microsoft Excel. The functions and formulas were used to link between tables to make the thinking step, which needs a source code but it is simpler to write source code or VBA in Microsoft Excel. Besides, solver is used to find the best answer. The objective in the project is to minimize flow time in each day.