The Software Development for Job Shop Production Planning and Inventory Control on Spreadsheet

This research aims to develop a software to solve the job shop production planning which is integrated to the inventory control and management. The significance of this software is applying the concepts of forecasting, raw material planning, and production planning. The inventory control function supports various decisions which are economic order quantity, joint ordering, and truck load limitation for multiple products. The developed algorithm is validated by solving the known solutions for various problems.