CD-ROM

Perancangan Aplikasi Data Penjualan Sales Forecast Rokok di Perusahaan Distributor XYZ Berbisnis MS Excel dan VBA (CD + Cetak)

---

Forecasting (Forecast) is a method for estimating a value in the future using past data. This research was conducted at Xyz Cigarette Distributor Company. In this study, the author discusses the analysis and application of sales forecasting for cigarette sales using cigarette sales data, forecasting is carried out using two methods, namely the Moving Average method and the Exponential Smoothing Adapter Parameter method by comparing the smallest error rate, as well as the level of graphic precision. diagram, the chosen forecasting method is the Moving Average method, with an MSE value of 4286267.8. From the data processing analysis that has been carried out based on the selected forecasting method, forecasting sales of the most sold cigarette products is in January with a forecast of 15022, meaning that the xyz cigarette distributor company sells the most cigarettes in January. And by utilizing Visual Basic for Applications (VBA) Macro information can be available quickly when needed as a basis for decision making. With the application of applications in business processes, it makes it easier for admins and employees in xyz cigarette distributor companies to carry out a more optimal recording process.
Keywords: Forecast, VBA Macros, Ms. Excel

---

Ketersediaan

Informasi Detail

Judul Seri

-

No. Panggil

003 DMI2020 IVA p

Penerbit

Malang : Program D-3 Sistem Informasi Fakultas Teknologi Informasi Universitas Merdeka Malang., 2020

Deskripsi Fisik

PDF, 2.960 KB

Bahasa

Indonesia

ISBN/ISSN

-

Klasifikasi

003 DMI 2020

Tipe Isi

-

Tipe Media

-

Tipe Pembawa

-

Edisi

-

Subjek

FORECAST
VBA MACROS
MS. EXCEL

Info Detail Spesifik

-

Pernyataan Tanggungjawab

-

Versi lain/terkait

Lampiran Berkas

Komentar

---

Anda harus masuk sebelum memberikan komentar