Have you found the sample you need?

Save your time and order an original essay now!


Design Of Decision Support System Determination Of Inventory Inventory Using Single Exponential Smoothing Forecasting Method

Download PDF

Abstract. The development of information and communication technology at this time has touched all sides of life. Almost no side of human life is not touched by this information technology, which is more synonymous with the world of computerization. No exception also with the computerization that is popular in the corporate environment and government agencies. If in ancient times everything was still done manually. However, at this time all leaders and management have realized the importance of this information technology products that can facilitate them in carrying out the day-to-day corporate functions. Decision Making System of goods purchasing is one of the determinants of the accumulation of goods. If the decision is taken right then stockpiling of goods can be avoided. In this thesis the authors designed a web-based system that helps Management in making the decision of the purchase amount of goods. the system was developed by using Microsoft Visual Studio 2010 and using SQL Server database processing applications. The end result of system design is expected to help minimize the accumulation of goods.

Essay due? We'll write it for you!

- any subject

- min. 3-hour delivery

- pay if satisfied

Get your price


Many tools supported as DSS are actually science-based models that do not address basic issues and decision-making issues[1]. The Decision Support System can be used in a number of fields such as prefabricated prefinished volumetric construction[2], social justice[3], children with special needs[4], retinopathy identification[5], Determining the best lecturer[6], and identification male fertility[7]. The development of decision support systems follows the development of information and communication technology that has been used in a number of fields such as: understanding level of soft skills[8], fostering character of children[9], and legal protection for children[10]. A number of studies in this field have been produced: Benchmarking problems with artificial neural networks[11], slack measurements on benchmarking processes[12], diversity problems[13], K-Means model optimization[14]. The purchase of goods is a routine activity that occurs in the company in increasing inventory. Appropriate decision making in purchasing goods can prevent losses to the company, such as avoiding excessive stockpiling. Determination of purchase of goods can be done by analyzing the sales data then, forecasting future sales to be able to determine the number of purchases of goods that are suitable.

Medan Permai Folding Gate is a company engaged in the sale of iron and the manufacture of iron doors. In its operational activities Medan Permai Folding Gate often experience the hoarding of goods because there is a mistake in determining the number of purchases of goods as appropriate as inventory. So far, the company has not been supported by applications that can analyze past sales data and present information on the appropriate purchase amounts for each item in order for the company to minimize the costs incurred and avoid the occurrence of losses. For that Permai Folding Gate Field requires an information system capable of presenting how much the purchase in the future so that stockpiling of goods can be avoided

Related Works

Tratar et al. Has conducted research on Demand forecasting with four-parameter exponential smoothing[15]. Oliveira and Oliveira[16] have conducted research on Forecasting mid-long-term electric energy ARIMA consumption through bagging and exponential smoothing methods. Simple exponential smoothing is commonly used in predicting economic time series. This is because it calculates them quickly and generally provides accurate forecasts. On the other hand, its multivariate version received little attention due to the complications resulting from the estimate. Of course, standard multivariate maximal probability methods are influenced by numerical convergence and poor complexity issues, increasing with model dimensions[17].

Research Methodology

System Design can be seen in the following Context Diagram.

Figure 1. Research Method


1) The warehouse will provide data on goods owned by the company.

2) The sales department will provide sales statistics.

3) In making purchasing decisions, software uses single exponential smoothing forecasting.

4) The analysis process carried out by the system will produce a report on determining the purchase of goods to the leader.

Results and Discussion

To run applications that have been built requires software or hardware that supports. The hardware or software needed is as in the following picture:

A. Hardware (Hardware)

Here are the minimum hardware required

1) Pentium IV 1.8 Ghz

2) 128 Mb memory

3) Empty capacity Hard Disk 2 GB

4) CD-RW / CD-Room.

5) 32MB VGA card.

6) Switch (Port as needed)

7) Mouse.

8) Keyboard.

B. Software (Software)

The following is the minimum required software

1) Operating System (Windows XP SP2)

2) Microsoft SQL Server 2005.

The system design results can be seen in Figure 2.

Figure 2. System Design


The conclusions obtained after completing this research are as follows:

a. Systems designed using previous period sales data to determine future purchasing needs.

b. The computerized decision-making system proposed is a computerized based system that can present sales forecast data and the need to purchase goods automatically.

c. The application of the Single Exponential Smoothing method in the computerized system of decision making to determine the purchase of goods can reduce the occurrence of stockpiling.

d. By using a computerized decision-making system based on computerization, the calculation of the number of purchases of goods can be done quickly and accurately.

Disclaimer: This essay has been submitted by a student. This is not an example of the work written by our professional essay writers. You can order our professional work here.

Download essay
73 editors online and ready to help you with your essay

Sorry, copying is not allowed on our website. If you’d like this or any other sample, we’ll happily email it to you.

By clicking “Send”, you agree to our Terms of service and Privacy statement. We will occasionally send you account related emails.



Your essay sample has been sent.

Want us to write one just for you? We can custom edit this essay into an original, 100% plagiarism free essay.

thanks-icon Order now

Newest essays & research papers

O’neill states that Famine is said to be inevitable if people do not curb their fertility, alter their consumption patterns, and avoid pollution and consequent ecological catastrophes. O’neill argues that…
The wedding day can be marked as a red letter day in anyone’s life. It has to be a big affair for a couple, and destination wedding being the talk…
India newest pride, Hima Das has taken the world by storm by becoming the first Indian woman to win a gold medal during the recent IAAF World Under-20 Championships in…
Every day more and more people are getting dependent on online to gather resources, additional knowledge and to buy all sorts of things that they can’t find near their places.…
As technology is overpowering our thinking ability, one without reasoning any particular event is likely to fall prey to the misinformation which is in front of our eyes. This misinformation…
In recent globalizing society, we use language as a communication tool. The more and more tools you can use, we can contribute to the society, or we can success in…
We can view human society as a macro-organization, as an identifier of serious problems and a continuous producer of change, but also as a generator of organizations that bring social…
White, heterosexual men dominate the directing field and always have, and as a result cinema well over the past century has been decidedly male-oriented. My Major Work focuses on girl(hood)s…
The 21st century is earmarked as a great revolution in the history of women with the advent of globalization. The past has seen women living in oppression for simply being…
Skyways Travel is one of the leading traveling companies. We provide a wide range of travel services includes, airport transfer, corporate travel, Hire wedding cars in Wales and so on.…
The process of analyzing a new communication protocols is a time intensive task that includes studying data formats, developing prototype parser, testing prototypes and repeating the cycle until a robust…
Howdy Guys, In this Article we are discussing about The Worlds Most Unique World Records. Today India is recognized for its new technology, knowledge, power in the whole world. He…
Load More

Eduzaurus.com uses cookies to offer you the best service possible.By continuing we’ll assume you board with our cookie policy.

Do not miss your deadline waiting for inspiration! Our writers will handle essay of any difficulty in no time. Want to get a custom essay from scratch?
Do not miss your deadline waiting for inspiration! Our writers will handle essay of any difficulty in no time. Want to get a custom essay from scratch?
Do not miss your deadline waiting for inspiration! Our writers will handle essay of any difficulty in no time. Want to get a custom essay from scratch?