Forecasting of pharmaceutical products using arima model and exponential smoothing / Nur Hayatul Afza Mohamed Fishal

Mohamed Fishal, Nur Hayatul Afza (2021) Forecasting of pharmaceutical products using arima model and exponential smoothing / Nur Hayatul Afza Mohamed Fishal. Degree thesis, Universiti Teknologi MARA Perlis.

Abstract

The pharmaceutical industry creates, manufactures, and sells vaccines or pharmaceutical drugs as medications to be prescribed (or self-administered) by patients for healing, vaccinating, or alleviating symptoms. The expiry date is the most important thing to be aware of to avoid consumer purchasing an expired product. It would harm their well-being where the customer then may take legal actions. Therefore, it is crucial to know how much to stock up the product. In this research, the selected methods include a single and double exponential smoothing model and the ARIMA model. Data on two types of pharmaceutical products, Paracap 500mg and Bena Expectorant 120ml, were collected from a pharmacy’s database in Kangar from January 2015 to December 2019. Microsoft Excel and R Programming were used to analyze the data. As the result, between both exponential smoothing models, single exponential smoothing is the best model to forecast the demand of Paracap 500mg and Bena Expectorant 120ml. For the ARIMA model, depending on the smallest value of MSE, ARIMA (2,1,1) is the best model to forecast the demand of Paracap 500mg, while ARIMA (1,1,2) for Bena Expectorant120ml. Finally, for the final and the best option, a comparison of MSE, RMSE and MAPE values was made between single exponential smoothing and ARIMA model for Paracap 500mg and Bena Expectorant 120ml. The result indicates that single exponential smoothing has been selected for both product as the best model to forecast the demand starting from January 2020.

Metadata

Item Type: Thesis (Degree)
Creators:
Creators
Email / ID Num.
Mohamed Fishal, Nur Hayatul Afza
2017399635
Subjects: Q Science > QA Mathematics > Time-series analysis
Divisions: Universiti Teknologi MARA, Perlis > Arau Campus > Faculty of Computer and Mathematical Sciences
Programme: Bachelor of Science (Hons.) Management Mathematics
Keywords: Time Series ; Exponential Smoothing ; ARIMA Models ; Pharmaceutical Products ; Expiration Date
Date: 30 March 2021
URI: https://ir.uitm.edu.my/id/eprint/44469
Edit Item
Edit Item

Download

[thumbnail of 44469.pdf] Text
44469.pdf

Download (115kB)

Digital Copy

Digital (fulltext) is available at:

Physical Copy

Physical status and holdings:
Item Status:

ID Number

44469

Indexing

Statistic

Statistic details