The usage of decision support systems in aggregate production planning and and application in a company that has production with no inventory

The purpose of Aggregate Production Planning is to evaluate and balance the workforce size/level and consequently the recruitment and firing quantity, inventory stock level,regular time production quantity, overtime production quantity and subcontract requirementas a whole in the process of taking mid-term planning decisions. The study was performed adecision support systems that provide interactive information support to manager during thedecision-making process for solving aggregate production planning. The purpose of DecisionSupport Systems is assist to manager to improve the effectiveness of decision making aboutsemi-structured and unstructured problems. The main purpose of this study to get a practicaland useful tool with good user interface and optimization capability for developing anAggregate Production Planning.At the beginning of the study, information about decision support systems andaggregate production planning was examined. At the same time, purpose and scope of thestudy were determined and a decision support system running in MS Excel that provide someof the model building, linear programming, analytical modeling, tables, database managementand dialogue management tools. The Decision Support system is supply analysis tools toevaluate planning scenarios to user with linear programming and tabling methods.At the end of the study, proposals about future advancements of study are taking place.