Decision Support System for Determining Number of Depot to udDistribute Material in the Rattan Furniture Industry by udConsidering the Location-Allocation Problem

摘要

In this paper we will develop a spreadsheet-based Decision Support System (DSS) to uddetermine the number of rattan depot and supply allocation to meet the production centers uddemand with case study in Solo Raya. The DSS incorporates database, model base, analysis udtool, and Graphical User Interface (GUI) and user. Databases for storing data, the model base udto keep models, analysis tool is required for solving the model and GUI allows users to interact udwith the database, model base and analysis tool. Data base, the base model and analysis tool udare developed using the spreadsheet. The basic idea of the proposed approach is the udspreadsheets can be used to build data-driven, model-driven DSS and solver-driven DSS. The udmodel was developed by consider two stages of distribution network, multi commodities of raw udrattan, and multi-periods of production plan. The DSS development approaches used in order to udgovernment can efficiently make the policy. DSS software interface is designed so user-friendly udwith point and click application so that users can operate quickly and easily. Users do not need udto formulate a mathematical model despite they want to change index values or parameters udrepeatedly. The test results of case examples provided also give good results, where the software udis capable for processing data based on selected model. The DSS is capable for providing udlocation results and the allocation of raw or processed rattan at the depot on minimal total udsupply chain cost. The result may be a consideration for the policy makers to determine the udright location of rattan depot