Analisis dan Implementasi Simulasi Monte Carlo untuk Prediksi Kebutuhan Gula berdasarkan Penjualan Bumbu Tabur XYZ

Abstract

The sales activity is a very important activity for the development and
sustainability of a company. The sales are closely related to the requirement of
raw material. By knowing the number of sales, a company can do estimate the
amount of raw material required for production. However, so far still be found
as a company that has its policies to determine a requirement of raw material as
impact not use a raw material control method. The research purpose to determine
the amount of sugar raw material requirement based on results number of sales
seasoning XYZ with Monte Carlo simulation. Based on the analysis of data
processing results. It was found that the number of sales from the simulation
results in 2019 was quite high compared to the sales results during 2018 where
the difference in sales simulation in 2019 and real data in 2018 was 62,334 kg.
In terms of sugar supply, the total requirement for sugar in 2019 is also quite
high, namely 186,756 kg, or the difference in requirement between simulation
results and real data is 21,818 kg. This shows that the amount of requirement is
directly proportional to sales.