COMPUTER AIDED ASSEMBLY PLANNING USING MS EXCEL SOFTWARE – A CASE STUDY

The issue of planning assembly operations remains crucial decision-making area for many of manufacturing companies. It becomes particularly significant in case of small and medium enterprises that perform unit or small-scale production, where the option of applying specialized software is often very limited – both due to high purchase price, but also due to its applicability to single unit manufacturing, that is executed based on individual customer orders. The present article describes the possibility of applying the MS Excel spreadsheet in the planning of machine assembly processes. It emphasises, in particular, the method for using the spreadsheet in subsequent stages of the process, and the identification of possible causes that have impact on problems with the planning process. We performed our analysis on the basis of actual data from one of the machine industry enterprises that manufactures in central Poland

Optimal control of production and maintenance operations in smart custom manufacturing systems with multiple machines

Enterprises equipped with IoT (Internet of Things) are the new generation of manufacturing industry. There is a need for new optimization models which incorporate the advantages of IoT. In this paper, a new mathematical model and heuristic algorithm are developed to minimize the total cost in a multiple machine environment which enables the industries to take economically better decisions and effectively use their resources. A heuristic algorithm is developed for identical machines which process with the same tool. A system in which jobs with stochastic workloads arrive randomly and upon arrival, their workload is facilitated by IoT. The proposed algorithm determines the assignment of workload to the machine and processing speed. The algorithm works for both online and offline frameworks