Business Intelligence System using Simple Moving Average Method (Case Study : Sales Medical Equipment at PT. Semangat Sejahtera Bersama)

Abstract

Business Intelligence is a technique or method for transforming raw data into useful and meaningful information for a company. There are the various utilization of BI such as for product pricing determination, placement of goods, or sales forecasting. Some problems that often occur in a company, especially in a company engaged in the sale of goods is the difficulty of processing data with an equal form and the amount of data to be analyzed, as happened at PT. Semangat Sejahtera Bersama. One of the problems that occur in the company is the difficulty of forecasting stock of goods that must be stored in the warehouse. Limited warehouse capacity causes each branch is required to wisely perform demand for stocks of goods that must be stored in warehouses that have limited capacity. The process on this study is building a dashboard to generate reports and sales trends. Through this report, it can be seen sales trend by month, or season in Indonesia, given the season is one factor that determines the type and number of items sold in a period. The system will generate the forecast type of goods that must be prepared in each branch based on sales data in some determined data range. Sales prediction is generated through computation process using a simple moving average method. This method works by doing the calculation of the average value of sales value by the number of previous periods so it is able to display sales trends that occur.