Skip to main content

METHODS article

Front. Med., 03 August 2022
Sec. Regulatory Science
This article is part of the Research Topic Drug Shortages View all 5 articles

Forecasting Model: The Case of the Pharmaceutical Retail

  • Department of Business Technology and Entrepreneurship, Business Management Faculty, Vilnius Gediminas Technical University, Vilnius, Lithuania

Introduction: Many forecasting methods are used to predict sales, such as the moving average method, naive method, exponential smoothing methods, Holt's linear method, and others. The results brought by these models are quite different. Forecast delivered by the naive method is entirely accurate for an extended period, like 3–5 years, Holt's methods are bringing accurate one-year period forecasts. The planning decisions have several levels, meaning different forecasting results. However, the authors that are testing various forecasting methods are not discussing results researched in different planning levels (retail chain and different pharmacies). The study is given to the construction of the forecasting model covering both planning levels, which later is empirically tested for the Lithuania retail case:

Purpose: The development of the forecasting model for reduction of shortages in drug supply. To achieve this goal, the author revises the improvement of drug availability weekly.

Research Methodology: The construction of the forecasting model is incorporating outliers' detection methods and sales by pharmacies to minimize shortage. In the forecasting model, the author uses Theil's U2 test to evaluate forecasting accuracy.

Findings: During analysis, the author constructs the model application for forecasting drug sales where weekly availability is highly recommended. The results show that forecasting on individual pharmacies level using the integration of these plans approach leads to higher accuracy.

Research Limitations: The research covers 3 months of sales data. Das and Chaudhury suggest for short-sales period products use 36 days' time horizon. Ayati et al. discuss short and long-term time horizons for planning sales of drugs. Kanyalkar and Adil analyzed multi-site production and suggest that the time horizon should cover the longest lead time required for delivery of raw material, which is 12 weeks, and select 3 months (i.e., 13 weeks) as short-term time period horizon. Wongsunopparat and Chaveesuk forecast drug sales for 1-month and 12-month periods and compare the results. In this study, the focus is on short-term time-horizon, which is considered as 3 months period and also represents the longest lead-time. In the future, the study could review other periods. The author has incorporated the review of eight forecasting methods into the study by leaving other forecasting methods unresearched. Future studies could also incorporate different ARIMA methods into shortage reduction case analysis.

Practical Implications: Presented forecasting model could be useful for practitioners, which analyze the reduction of the shortage of prescribed drugs. There the revision of repeated purchases is recommended for national authorities, wholesalers, and pharmacies aiming to minimize shortage.

Originality/Value: The analysis to reach the highest forecast accuracy and identification of a forecasting approach which responds to the fluctuation of weekly sales for the whole pharmacy chain and separate pharmacies. The study contributes to drug sales review, where most authors analyze the total volume, which is not separated by pharmacies.

Introduction

The supply chain of pharmacies often deals with forecasting questions. The construction of the forecasting model (1), which covers the sales of pharmacies and incorporates the drug supply aspects, and minimizes drug shortage cases is essential to the research question. In other words, forecasting sales helps to plan drugs' supply and respond to actual patients' demand which has weekly patterns (2). Drug shortage could be differed by medicine access level, retail and hospital-only. Ayati et al. (3) notify that the induced demand for stocking medication, which is, may cause periodic shortages in the pharmacies. Among the forecasting techniques, researchers are dealing with naive forecasting, average moving (4), and more sophisticated methods such as exponential smoothing and others.

In general, one of ten products is not available in pharmacy due to a shortage in supply. The occurrence of shortage disbalances supply and its recovery period is too long (5). Usually, pharmacies do not record count missed sales when forecasting (6). The author builds the forecasting model by incorporating missing data and extraordinary cases to it to get proper sales data for planning supply.

To improve supply, the author proposes using the prediction of average sales per week, which helps to protect the data from being downwards or upwards. To avoid the events of shortage and to shorten the recovery period, missing sales data must be set up. For high uncertain cases, the author applies the Grubbs' test for the outlier detection method.

The research is laid down for several drugs, which have a different historical pattern: one with shortage and another one without it. The author uses 13 weeks' time frame to predict the forecast and improve its accuracy. The author detects that products with uncertain sales have outliers.

The author tests four various approaches: the first approach uses aggregated sales of pharmacy chain for forecasting; the second approach uses aggregated sales for a pharmacy chain and response to outliers; the third approach uses sales by pharmacies for forecasting; the fourth method–sales by pharmacies and response to outliers.

The author tested four approaches for the pharmacy chain, which consists of 8 pharmacies and eight methods, which have seasonal and not seasonal patterns. The author delivers 280 tests to prove the forecasting method and its accuracy.

The other sections of this document are set out as follows: Sections Literature Review, Forecasting with Exponential Smoothing Methods, and Planning Levels provide a literature overview of different demand patterns, time series characteristics (6), and forecasting methods. Section Forecasting model presents the forecasting model, its structure, techniques for missing sales data and outlier detection, and the revision of forecasting accuracy. The application of the model is provided in Section Methodology. Later on, the tests and practical results are described in Section Test and Results. And finally, the relevant concluding remarks are presented in Section Discussion.

Literature Review

There are many forecasting methods provided by the authors. Among those methods, priority is given to the adoption of forecasting methods, such as the Holt-Winters Multiplicative method [(7) p. 530], in medical care cases, especially in forecasting future events with seasonal and other causal changes. In Holt–Winters Multiplicative method, the components of the initial value are defined.

Thus, to combat a dynamic but uncertain environment, pharmacies have no choice but to accelerate their actions to meet the needs of patients in a timely and effective manner [(8), p. 375]. In this respect, the revision of forecasting methods must be taken into account.

Recently, many forecasting methods have been proposed, where the biggest group of methods belongs to quantitative methods. By using a qualitative approach, sophisticated mathematical methods are used for making the decision [(9) p. 404]. Among the quantitative techniques, scientists have shown an interest in exponential leveling methods which are simple, robust, and easy to use [(10) p. 619]. As a result, the researchers have developed several exponential equalization methods aiming to improve the accuracy of forecasts. All methods with the exponential procedure, follow the main principle which is applicable in constructing a forecast–it assesses future events by extrapolation of historical values [(11) p. 447]. However, in the case of similarities in principles, these exponential equalization methods also show specific distinguishing characteristics in their calculation processes, parameter calculations, and response to different time series components [(12) p. 245, (13) p. 67, (14, 15) p. 451]. For example, the single exponential leveling technique is perfect for time series that exhibit a changing average that does not have a seasonal component (16). Because, with a trend component, varying levels, and growth rates, Holt's trend correction method shows its superiority. Meanwhile, the overcomes the two above-stated Holt-Winters methods in time series, having a changing seasonality, level, and trend [(15) p. 451, (17) p. 395, (18) p. 380, (19) p. 34].

Nevertheless, the Holt–Winters methods incorporating such parameters, i.e., at a constant rate or increasing amount, are further classified as multiplicative and additive [(12) p. 245, (15) p. 451, (17) p. 395, (18) p. 380, (19) p. 34, (20) p. 284]. In the 1960s Winter [(21) p. 330] proposed a multiplicative Holt-Winter method, which was foreseen for seasonal variations, which swing around average values [(22) p. 32]. In addition, the average values will grow, as many Western European countries will undergo a major demographic transformation, driven by the retirement of the baby boomers and the possibility of a sudden increase in life expectancy and the drug consumption will grow in long-term perspective (23). Contrary to the method described before additive Holt-Winters method is chosen for time series where seasonal fluctuations do not swing at the same time as the mean value [(20) p. 284].

There are discussions among the authors about the seasonality aspect from a shorter-term perspective (calendar season or year). Rossignol et al. (24) suggested the method to identify seasonality. They propose to test if the seasonality exists by using the Google trend tool. They analyzed multiple time series of pharmaceuticals sales and Google search data seeking (1) to test if the seasonality in drugs sales exists or not, and (2) to determine its magnitude if seasonality exists. During the research, the author by comparing winter and summer search data identified an average increase of 8.7 per cent, which according to Mann-Whitney's test, shows that the p-value was lower than 0.01. Ayati et al. (3) reported that the increase in global demand for pharmaceuticals due to COVID-19 was evaluated as plus 8.9% in the March of 2020 with no seasonal effect consideration. Buxey (25) tells that sales peak is in November and December when public induced demand.

However, for incorporating level, trend, and seasonality in delivering forecasting, both forms of the Holt-Winters method have several equations, the suitability of which follows these components [(18) p. 380; (7) p. 360]. In this respect, the initial level and trend values are calculated using the smallest squares regression technique, the reading of still average changes adversely affects the accuracy of forecasts [(26) p. 56].

Upfront the forecast, the set of historical values is used for the calculation of components in a step-by-step way [(27) p. 3261]. In general, it is used in science, engineering, telecommunications, meteorology, finance, and economics [(28) p. 3860]. The exponential equalization methods are mostly used due to their strength [(12) p. 245; (29) p. 638], simplicity [(12) p. 245], and the low number of variables required [(8) p. 375, (12) p. 245]. Justifying the simplicity and easy application of this group of forecasting techniques [(8) p. 375; (11) p. 652; (4) p. 720] has attracted researchers to work on improvements [(30) p.1080].

Among these exponential equalization methods, the three most commonly accepted and literary techniques can be referred to as Holt's linear method [(14) p. 9], single exponential leveling [(13) p. 67], double or triple exponential leveling [(21) p. 330]. A single exponential one is known as a simple or easy application, and Holt's linear method provides forecasts for data with the trend. Although Holt's linear method has the highest quality, it misses its accuracy for data with seasonal patterns [(31) p. 750]. In such a case, the Holt–Winters additive and multiplicative methods bring forecasts which incorporate seasonality aspects [(32) p. 180].

There are two forms of Holt–Winters technique (i.e., addition and multiplication), the first one fits in a situation where is a stable pattern throughout the seasonal demand time frame, and another one with a dynamic adjustment feature is perfect for dynamic changes during the period. However, the application of these methods poses the challenges in setting the components for time series: level, trend, and seasonality; also finding the values for equalization constants, as well as using complex recursive calculation processes [(30) p. 1080, (32) p. 180, (33) p. 80]. Therefore, like other methods used for forecasting time series, several approaches were provided seeking higher accuracy of the usually applied Holt-Winters additive and multiplicative methods, and appropriate application cases.

For example, Grubb and Mason [(34) p. 80] adopted the Holt-Winter method to reach the forecast of United Kingdom air passengers and the results improved the level of accuracy (exactly, MSE). Lepojevic' and Andelkovic'-Pešic' [(35) p. 230] performed research where MSE is prioritized. On the other hand, Chatfield and Yar [(22) p. 32] applied components of level, trend, and seasonality, expecting to improve the accuracy of forecasts. Bermúdez et al. [(30, 32) p. 1080] also calculated the initial values for these three-time series parameters by reducing the forecast error.

Furthermore, Arora and Taylor [(36) p. 3240] apply the average historical data to be the starting values for the main components of the time series. Sudheer and Suseelatha [(37) p. 342] suggest using the average historical data for identifying the level, and the average historical data for the early two days for identifying the trend. Primary seasonal components shall be calculated by revising annual historical information. Costantino et al. [(38) p. 315] take average historical data to estimate the initial values of time series components.

The prediction of sales that is essential for drug supply (39), the Holt-Winters multiplicative method must be subject to research, when during the forecasting procedure its level, growth rate, and seasonal index are defined. The accuracy of the forecast depends on historical data [(7) p. 360; (26, 40)] and the results of other methods.

The author revised the papers applying forecasting methods for drug sales forecasting and provided the summary of results under Table 1. The papers were identified by using Google Scholars and OAister tools, the retrieved papers were printed in journals published by Elsevier, Taylor & Francis, IOP Science, IEEE, and IOP conferences, and hospital reports.

TABLE 1
www.frontiersin.org

Table 1. The summary of methods applied for drugs sales forecasting.

The author identified that both Holt's linear and Holt-Winters no trend methods were not applied for forecasting drugs sales.

Restyana et al. (41) applied Single exponential smoothing and moving average for prescriptive drugs: paracetamol and vitamins, however, do not provide MAPE value.

Nikolopoulos et al. (40) prove the application of the naïve method for long-period forecasts which are built for generic pharmaceuticals and suggest applying non-seasonal ARIMA for branded drugs seeking to build one-year forecasts.

The seasonal part of the ARIMA model consists of terms that are similar to the non-seasonal components of the model, but involve backshifts of the seasonal period. However, ARIMA has a lot of model modifications: White noise ARIMA, Random walk ARIMA with no constant, Random walk ARIMA with a constant, Autoregression ARIMA, and Moving average ARIMA.

Ribeiro et al. (47) stay that Holt's linear forecasting function tends to overestimate that's why it is suggested to use its modification and use SMAPE to present the error size, which vary for alfa = 0.2 from to 1.27 to 1.29.

Newberne (44) analyses Holt–Winters additive model for pharmaceuticals and reaches MAPE which is equal for alfa = 0.2 to 14.59%.

Bon and Ng (45) used Holt-Winters multiplicative to forecast inventory demand at the healthcare center. And reached the lowest RMSE.

Zahra et al. (42) compared SARIMA with single exponential smoothing and presented that MAPE values are 13 and14 percent accordingly.

Exponential smoothing and ARIMA models are the two most widely used approaches to time series forecasting (49). Further on, the author revises forecasting with exponential smoothing.

Forecasting With Exponential Smoothing Methods

Being reliable, the exponential smoothing methods are quite simple forecasting techniques that are used to smooth time series without the need of becoming a parametric model. It is based on a recursive calculation scheme, in which forecasts will be revised for each new observation. Although exponential smoothing sometimes serves as a simple prediction method (i.e., naive), it performs well in practice. Therefore, these methods are often used in business practice to forecast inventory requirements. Besides, compared to more sophisticated techniques forecasting techniques, these exponential smoothing methods have also performed remarkably well in the forecasting process (50, 51).

In general, single exponential, trend-corrected exponential, and Holt–Winters methods with seasonal are considered three basic types of exponential smoothing (13, 14, 21). The main feature of this type of forecasting method is as such: (i) time series are revised to create the equation of unobserved three components (i.e., level, trend, and seasonality); and (ii) these components need to be changed over time if the demand pattern has some structural changes. According to Hyndman et al. [(15) p. 440], the addition or multiplication operators can serve for a combination of these components up to 24 variations of exponential smoothing methods.

Producing short-range forecasts is the best way of simple smoothing application, usually only one or two forthcoming months. The assumption that the data fluctuates around a relatively stable mean (no trend or consistent growth pattern) is the critical point in the model. A weighted average of the present time series and the previous smoothed ones serve as a new smoothed forecasted evaluation; the last smoothed observation is derived from the previously observed value and the smoothed evaluation before the previous one, and so on.

A trend usually is a subject of double exponential smoothing which is quite similar to simple smoothing, thought two components–level and direction–thereof need to be updated each period. In the initial stage, it is a smooth estimate of the value of the data that should be performed at the end of each period. But in the case of trend estimation, it goes like a smooth estimation of average growth.

The method that deals with trend and seasonality at the same time is named Triple Exponential Smoothing. To cope with seasonality, it includes one more parameter–a third component that deals with seasonality.

To construct the forecast, most of the techniques require the stationarity requirements to be satisfied. Time series are the first-order stationary if the expected value of Y(t) remains the same for all t. For example, a process is first-order stationery when we eliminate any sort of the trend by some operations such as differencing. A time series is a second-order stationery if it is first-order stationary and covariance between Y(t) and Y(i) is a function of length (i-t) only. Also, a process is a second-order stationary when we also stabilize its variance by some transformation, for example, such as taking a logarithmic scale.

The exponential smoothing approach is often used for data forecasting that includes seasonality, changing trends, and seasonal correlation. Also, being developed as an extension of exponential smoothing for directions and annual time series, this method might be referred to as double exponential smoothing.

There are various forecasting methods. Two of them relate to the concept of pharmacies: space-driven and demand-driven. Demand-driven forecast involves the prognosis of the number of patients, penetration of drugs and average quantity.

The equations for demand forecasts are usually such as

Yt+1 = Pt+1 × D × Yt_

where P is the forecast of the number of patients visiting the pharmacy (% of number of patients treated as a part of a number of patients prescribed), coefficient D—penetration of drug, Y – average sales quantity.

If we know the number of patients and the penetration of drugs, such a method could be applied. In the case of prescribed medications, there is essential to understand how many patients are defined and how many of them have medical treatment.

In this particular case, the number of patients, which are registered with Hemophilia A, Hemophilia B, von Willebrand disease, and Factor VII deficiency is growing. Still, the number of patients treated for the above-mentioned disease is almost stable.

However, in other categories, the sales of drugs are increasing or decreasing from a year-to-year perspective. By using statistics reported by the State Medicines Control Agency of Lithuania (52) for the Baltic countries, it is evident that sales in some categories are increasing:

– Sales for drugs prescribed for alimentary tract and metabolism (1st level, anatomical main group): drugs for acid-related disorders, drugs for peptic ulcer and gastro-esophageal reflux disease, antiemetics, and antinauseants are increasing by 6% 2018 year. By using historical consumption to forecast sales it is recommended to add safety stock to cover the increase rate, which is 6%.

– Sales for drugs prescribed for the respiratory system: nasal preparations and throat preparations are increasing by 4% in 201. By using historical consumption to forecast sales it is recommended to add safety stock to cover the increase rate, i.e., 4 percent.

– Sales for drugs prescribed for the cardiovascular system are increasing by 1% in 2018 year. By using historical consumption to forecast sales it is recommended to add safety stock to cover the increase rate, i.e., 1%.

– Sales for prescribed dermatological: antifungals for dermatological use and anti-acne preparations are increasing by 10% 2018 year. By using historical consumption to forecast sales it is recommended to add safety stock to cover the increase rate, i.e., 10 percent.

However, if there is no information mentioned above, it is better to apply forecast methods incorporating sales data of previous historical periods.

The demand aggregation level is also especially important. Herein, the demand pattern of drugs fits unimodal statistical distribution, and the Jarque–Bera normality test shows (exactly probability which is 0.1) that the hypothesis that data of drugs are distributed according to the normal distribution, cannot be rejected. Even though, it is still a question at which level in pharmacy chain generated forecast is the most accurate one.

Planning Levels

It is very important to anticipate the right demand at every pharmacy as it helps to plan inventory and better distribution of products in all selling points.

In order to show some of the key differences in pharmacy chains the aggregated demand (for pharma chain) and disaggregated demand (for individual pharmacies) is considered. In the aggregation case, the sales of multiple selling locations are summed and demand is forecasted on the chain level.

According to Kanyalkar and Adil (53), the number of studies on aggregation/disaggregation in the context of planning is limited. Kanyalkar and Adil (53) suggest applying hierarchical planning approach covering the integration of planning decisions. The authors highlighted that the type of aggregation used in a chain case and parallel multiple outlets case may be different. When it is planned in a disaggregated way further the integration of plans generated at multiple selling locations level is necessary, in terms of time horizon (54), time periods, and volumes per product. This integration could be weighted and these weights could be specified by experts but the weight represent average value across all products, not the values that focus on separate product specifics and sales distribution across different pharmacies. In general, the naive forecast also often outperforms more complicated point aggregation schemes, such as weighted combinations (55). The average could be selected between the lowest and the highest sales numbers which are represented by different pharmacies. The forecast generated by taking their average performs better than choosing one of the two experts at random; when the estimates of experts perform equally as well as the average expert. Only when the crowd of forecasts being combined has a high degree of dispersion in expertise, some individuals in the crowd might stand out, and in such cases, there could be some benefits to chasing a single expert forecaster instead of relying on the entire crowd. When it is better to select the minimum level of experts or search for other solutions (Table 2) (55).

TABLE 2
www.frontiersin.org

Table 2. The summary of studies on hierarchical planning approach.

The author provides the summary of studies dedicated to the hierarchical planning approach, where the most dominating dimensions used by the authors are product and time. Most of these studies apply hierarchical planning integration in other industries than the pharmaceutical one, herein dominates production industry cases. Kanyalkar and Adil (53) specify that aggregated plan could be prepared on the country level and later on, could be separated between individual selling locations. Or vice versa first could be generated disaggregated forecasting plans and later they could be integrated.

Two planning levels mean that the first level is dedicated to a single pharmacy and the second level shows the integration of plans on the pharmacy chain level. For disaggregated and aggregated level planning Kanyalkar and Adil (53) suggest using weekly demand forecasting both for selling locations and for the country level cases. Based on these investigations, the author builds a forecasting model.

Forecasting Model

The proposed forecasting model consists of several successive steps such as setup of historical data, selection of product for testing when the application of approaches, detection of outliers and missing sales data, the application of methods, and the estimation of accuracy of forecasts. All the above-mentioned steps are presented in the following subsections.

Below, in Section The Structure of the Model, the author presents possible approaches, further on, in the chapter Techniques for Handling Missing Data author gives information on missing data setup, and in Outliers Detection–provides information on outlier detection, Section Forecasting Methods describes forecasting methods, and finally, in Section Forecasting Accuracy there is the presentation of the evaluation of forecasting accuracy.

The Structure of the Model

The forecasting model consists of four approaches, which in the model are applied sequentially.

1. The first approach uses aggregated sales of pharmacy chain for forecasting:

Yt=i=1nYi(t)

2. The second approach uses aggregated sales for the pharmacy chain and responds to outliers:

Yt=i=1nYi(t), Ytϵ(Yt,3×s)

3. The third approach uses sales by pharmacies for forecasting and aggregated forecasts for the pharmacy chain:

Yi={Yij,jϵt,iϵn}

Forecasts are calculated according to formulas placed under Figure 2, and later these forecasts are summed:

Yt+τ=i=1nYi(t+τ)

4. Fourth approach–sales by pharmacies, responses to outliers and aggregated forecasts for pharmacy chain:

Yi={Yij,Yϵ(Yt_,3×s),jϵt,iϵn}

Forecasts are calculated according to formulas placed under Figure 2, and later these forecasts are summed to get Yt.

Where n is the number of pharmacies and is equal to 8, t—week number and is the same as 13, τindex of the upcoming week, s—standard deviation.

Before the application of the third and fourth approaches for a product with shortage, missing data (i.e., data sets with zero values) are replaced with Mean values. The placement of missing values is mandatory action before applying outlier detection tests.

Techniques for Handling Missing Data

Missing data reduces the representativeness of the sample and may skew conclusions about the demand. In general, there are three main ways to handle missing data: (1) allegation—when values are filled in place of missing data, (2) omission —when samples with invalid data are excluded from further analysis, and (3) report—by direct application of methods not affected by missing data values.

With some practical applications, experimenters can control the level of missing data and prevent missing values before making a decision. For example, it is often not possible to step to outlier detection until the missing data is not handled. The allegation must be selected. Otherwise, the next step cannot be processed; thus, a period with missing data can be removed because one product in the pharmacy chain was in shortage and was not timely supplied to patients. In research studies, it is common to reduce the negative impact of missing data.

In cases where values are likely to be missing, the researcher is often advised to plan to use data analysis techniques that will cause little or no biased conclusion about the potential demand. Further on, the missing data is inputted for shortage and recovery period upfront the outlier detection procedure setup.

Outliers Detection

The presence of outliers in the sales data can significantly bias a forecast. Outlier detection is especially critical for making predictions based on historical data where the size of sales is important and could lead to overestimation or underestimation. This especially is the case in panic buying of popular product which was under the shortage for some period. The literature review points to several studies using outlier detection methods for drug sales data cleaning. The demand change, which leads to a shortage, in the case of induced demand has to be reviewed and evaluated from the significance of sales point of view. The cleaning of sales data for each product by using the outlier detection method has to be performed before the application of the forecasting methods. Ribeiroa et al. (47) use the Dixon outlier detection method seeking to avoid abnormal sales and out-of-stocks in pharmacies.

There are various outlier test methods, like Grubbs' test (1950), Dixon test (1953), David test (1961), Barnett and Lewis test (1994), and Rosner's analysis (2011). Some of these tests face the problem of misleading situations.

The Grubbs' test is used to detect deviations above the normal distribution limits [(61) p. 5]. The result is a probability indicating the basic data of actual sales. Using the outliers test method, the difference between the sample mean and the extreme data concerning the standard deviation can be plotted. The test determines one external value simultaneously with different probabilities than a data set with an assumed normal distribution.

Luo and Cisler (54) tried the Grubbs test for detecting outliers for drugs helping to prevent cancer disease and had positive outcomes [(54) p. 213].

Based on approximate data, the author uses this test to reduce the number of extraordinary sales and to evaluate outliers according to the Grubbs' test method.

The application of the Grubbs' test has practical value and could be used for the definition of potential demand data sets to avoid under-supply cases.

The detection of outliers using the Grubbs test and the evaluation of data points helps to streamline historical sales data. In case an outlier is detected for sales points outside healthy distribution boundaries, sales data inside healthy distribution boundaries are taken.

There is a test for the null hypothesis that the data has no outliers vs. the alternative hypothesis that the minimum or maximum value is an outlier. There are three steps to proceed with outlier detection:

Step 1. Sorting of data points from smallest to largest;

Step 2. Finding the mean (Yt) and standard deviation (s) of the data set;

Step 3. Calculating the G test statistic for a two-tailed test using one of the following equations:

G=max i=1,,N |YiYt_|s

The G test statistic for maximum value in the data set may be an outlier; it is better to use the test statistic (right-tailed test): G=|YmaxYt_|s.

In case, the minimum value in the data set may be an outlier; it is better to use the test statistic (left-tailed test):

G=|Yt_Ymin|s

The critical value for the test is

Gcrit=N-1Ntα/(2N),N-22N-2+tα/(2N),N-22

Where tα/(2N), N−2 is the upper critical value of a t-distribution with N-2 degrees of freedom, when the alpha (α) representing significance level is equal to 0.05.

If calculated G is more significant than Gcrit, the data point is not an outlier, and the null hypothesis H0 is accepted. Overwise, if G is lower than Gcrit, the second hypothesis is accepted.

After the procedure of outlier detection (Figure 1), it is necessary to set up a 3s value instead of an outlier value. The process helps to avoid upstream and downstream demand, which is represented by historical data points or oversupply and undersupply cases, which are present in case of wrong forecasts.

FIGURE 1
www.frontiersin.org

Figure 1. Grubbs test.

Forecasting Methods

In this paper author applies forecasting methods and research their accuracy, to define which of those methods per each approach must be recommended for practical applications.

There is a variety of more sophisticated methods concerning seasonality: no, additive, or multiplicative.

Eight methods are separated into two categories: (1) methods with no seasonality and (2) methods with seasonality.

From the methods mentioned in Table 1, the author uses five methods with no seasonality: single exponential smoothing, moving average, naive, Holt's linear, and Holt-Winters no trend. These are shortly presented below:

1. Single exponential smoothing method applies weighted averages, where the lowest weights are associated with the oldest observations, and these weights decrease exponentially. The setup of weights also lowers the increase in variability [(62) p. 269].

2. Moving average method is applicable for trend-based estimation. It is used to estimate the expected value of demand and the standard deviation [(39) p. 8934].

3. The naive method assumes that all predictions are the value of the last observation. The prediction of a random walk, called naive here, is a primary benchmark that does not require parameter identification and should be surpassed by more sophisticated methods for added complexity [(63) p. 28].

4. Holt‘s Linear method is developed based on single exponential smoothing and is taken to predict trend data. This method includes a predicted equation and two smoothing equations (one for the level, the other for the trend). The very small value of the trend component means that it is near to the flat. So, usually, this component must be higher.

5. Holt-Winters no trend method has seasonal variation but has no trend. However, it uses more than just one parameter, although the trend component in this method is not taken into account.

From the methods mentioned in Table 1, the author uses three methods with seasonality components: (1) Holt-Winters additive; (2) Holt-Winters multiplicative; and (3) double exponential smoothing. These are shortly presented below:

1. Holt-Winters Additive method has additive seasonal variation and a linear time trend. This method handles more effectively additive seasonality [(64) p. 162].

2. Holt-Winters Multiplicative Method Has Multiplicative Seasonal Variation and Linear Time Trend. It Is the Assumption That the Time Series Is Formed From Unattended Components: Level, Direction, and Seasonality (65). These Components Need to be Adapted Over Time, as They Must Follow the Demand Pattern [(66) p. 162].

3. Double Exponential Smoothing Method Is Developed for Time Series With Multiplicative Seasonal Variation. Herein, the Components Were Smoothed Using Different Parameters Separately, Namely a and c.

Below author defines the mathematics of forecasting methods and displays it in Figure 2.

FIGURE 2
www.frontiersin.org

Figure 2. Selection of appropriate forecasting methods.

Where at denotes the value of the level component (intercept) at time t, bt - an estimate of the trend (slope) at time t, α is the smoothing parameter and represents values between 0 ≤ α ≤ 1, ct-a multiplicative or additive seasonal factor; k>0 and is equal to 1,2…; and P is the number of periods within the seasonality.

Finally, the decision must be taken regarding the method, which suits the best and has the lowest forecasting accuracy.

Forecasting Accuracy

There are many measures for forecasting accuracy: Bias, SE, MSE, MAE, RMSE, and MAPE. There mean squared error (MSE) is a combination of bias (Bias) and standard forecast error (SE). MAE, RMSE and MAPE compare actual values and forecasted values, which are predicted with the model application [(66) p. 5]. Inaccuracy calculated after estimating the root mean square error (RMSE) or the mean absolute prediction error (MAPE) was generally reported as worse in Brooks et al. study [(67) p. 1295]. Because RMSE and MAPE are used to measure the deviation from the expected and actual values, the values closer to 0 are better [(68) p. 8].

Qian et al. (69) developed forecasting models, for which evaluation some measures were used MAE, RMSE, and MAPE. Authors mention, that in case the results of prediction are inconsistent, MAPE is often selected for a benchmark due to its stability [(69) p. 4].

MAPE = 1ti=1t|YYi|Y

Where Y and Yi are the actual and predicted values, respectively; t is the number of data samples linked to time-period.

Theil's U2 measures forecast quality by comparing the forecast results of the applied method with the naive forecast.

The best methods are selected based on forecasting accuracy Theil's U2 statistics:

U2=MSE(applicable method)MSE(naive method)

where MSE is forecasting evaluation statistics, which is defined such as:

MSE=1ti=1t(Y^iYi)2

For the identification of the proper forecast method, U2 value must be as lower as possible.

In such case U2 = 1 for the naive method; U2 <1 when the results of the applied forecasting method are better than the effects of the naive method; U2 > 1 when the results of the used forecasting method are worse than the results of the naive method, i.e., naive method brings better results.

It is no case when U2 statistics is applied in forecasting the demand for drugs or the number of medical services but is quite often used in macroeconomic forecasting.

Methodology

The author applies a forecasting model that integrated various methods into the statistical framework. By using the model, the author delivers 280 tests: 144 tests for the product without shortage and 136 tests for the product with the shortage. Among the methods, all of them have the same number of tests–the application of each method reaches 35 tests. Traditionally, the exponential smoothing methods go without reference to a statistical framework as other methods can be employed to resolve the problem of method selection. Herein these methods are applied in combination with other methods and are linked to a statistical framework.

For the validation of prediction [(70) p. 37], the sample shall be divided into two parts: the installation sample and the inspection sample. A suitable example is used to find reasonable values for the components, often by specifying the sum of the squares that provides the forecast error criterion one step ahead. The installation sample is used to evaluate the prediction capabilities of the method by a method such as MAPE. And the inspection sample uses a standard version of exponential smoothing based on the hypothesis that it is effectively reduced to the appropriate embedded solution when data require it. Herein the empirical part is dedicated to the inspection sample and hypotheses are formulated to select the most accurate forecasting ways and methods, when data of selected prescriptive products are distributed according to normal distribution.

Despite that many methods are applied to solve the problem, and the application of Holt-Winters method is usually selected for yearly time series, herein it is applied for weekly data forecasting.

Another aim is to evaluate the effectiveness of these traditional methods in terms of the information criteria method chosen for the process. For the evaluation of forecasting, accuracy author uses Theil's U2, which outperforms MAPE.

All these tests and results, including forecasting accuracy, are presented in the section below.

Test and Results

In general, the seasonality of products aspect could be checked by using Google trends tool representing drugs search results on daily basis. The author has checked the spring and summer search results in Lithuania during 2021 and found that during the pandemic the behavior of consumers eliminated the seasonality aspect (Figure 3).

FIGURE 3
www.frontiersin.org

Figure 3. Seasonality impact check.

But after the pandemic, knowing the impact of seasonality on sales the volume adjustment actions should be taken.

The Application of Forecasting Methods

All components representing level, trend, and seasonality must be between 0 and 1. The smaller the parameters, the more modest increase in variability.

For the practical application of methods, the values are defined in Table 3.

TABLE 3
www.frontiersin.org

Table 3. The values in components.

The above-stated values are constant for all tests that are delivered.

The Results of Approaches

First, the author starts testing approaches and forecasting methods for the product without shortage.

The results for the first approach and product without shortage are presented in Table 4.

TABLE 4
www.frontiersin.org

Table 4. The results of forecasting (first approach and product without shortage).

All forecasted values presented in Table 4 are not rounded integer values; even though there are some numbers after the comma.

From forecasting statistics, it is evident that the best forecasting results are delivered by Holt-Winters Multiplicative method.

The results for the second approach and product without shortage are presented in Table 5.

TABLE 5
www.frontiersin.org

Table 5. The results of forecasting (second approach and product without shortage).

From this test, it is evident that U2 is better for moving average and Holt's Linear methods when in the first approach, but U2 results for other methods are worse.

The results for the third approach and product without shortage are presented in Table 6.

TABLE 6
www.frontiersin.org

Table 6. The results of forecasting (third approach and product without shortage).

The best forecasting results are delivered by Holt-Winters Multiplicative method, and they are better than in the first approach, and other methods have the same U2 values. The results show that forecasting by individual pharmacies helps to improve the forecast. Herein Theil's U2 test shows that even though according to the MAPE, the double exponential smoothing method outperforms Holt-Winters Multiplicative method, the highest accuracy is bringing Holt-Winters Multiplicative method. The results for the fourth approach and product without shortage are presented in Table 7.

TABLE 7
www.frontiersin.org

Table 7. The results of forecasting (fourth approach and product without shortage).

The latter approach brings the worst U2 results. So, the best way is to apply the third approach for the product without shortage.

Second, the author starts testing approaches and forecasting methods for the product with the shortage. The data sets with shortage are adjusted to the value of 0.0001 instead of null values.

The results for the first approach and a product with a shortage are presented in Table 8.

TABLE 8
www.frontiersin.org

Table 8. The results of forecasting (first approach and product with shortage).

The forecasting results show that the application of the naive method is the best as U2 is higher than 1 for other methods.

Before the application of the third and fourth approaches, the data sets for shortage weeks (i.e., the null values) in drug supply must be replaced with average values (Yt or Yit) before the application of forecasting methods.

Summary statistics before treatment and after treatment are presented in Table 9.

TABLE 9
www.frontiersin.org

Table 9. Summary statistics before treatment and after treatment (product with shortage).

The results for the second approach and the product with a shortage are presented in Table 10.

TABLE 10
www.frontiersin.org

Table 10. The results of forecasting (second approach and product with shortage).

The best forecasting results are delivered by Holt-Winters Multiplicative method, and they are better than in the first approach. Such shows that forecasting by individual pharmacies helps to improve the forecast. However, the naive method is better than the application of single exponential smoothing, moving average and Holt-Winters no trend methods.

The third approach is not tested as from Table 8; it is evident that forecasts due to shortage which appeared in drug supply, have minus values for some weeks.

The results for the fourth approach and the product with a shortage are presented in Table 11.

TABLE 11
www.frontiersin.org

Table 11. The results of forecasting (fourth approach and product with shortage).

The latter approach brings the best U2 results for Holt-Winters Multiplicative method and one other method (i.e., Double exponential smoothing). So, the best way is to apply the fourth approach for the product with a shortage during supply. However, the naive method is better in the three previously mentioned cases.

The results per product are different, in case of shortage, the best way is to apply the fourth approach, and in case of the product without shortage—the third approach. Such must be used in delivering forecasts. Results prove that detection of outliers must be incorporated in the forecasting model to have procedures for products with a shortage in supply.

Detection of Outliers

The chart below represents the detection of outliers, which are defined using the Grubbs' test method By using Grubbs' method outlier is detected in week 10 when the G value is 2.089 for the product without shortage in supply. There is also evidence that a product with a shortage has no outliers detected, but it has two shortage weeks and one recovery week. The results of outliers are summarized in Table 12.

TABLE 12
www.frontiersin.org

Table 12. The results of Grubbs' tests by-products and accumulated sales (product with shortage).

An alternative hypothesis for this case presented in Table 12 is accepted.

By using Grubbs' test, outliers are detected in pharmacies 2, 5, and 7 for the product without shortage in supply. The results of outliers are summarized in Table 13.

TABLE 13
www.frontiersin.org

Table 13. The results of Grubbs' tests by pharmacies (product without shortage).

An alternative hypothesis for this case presented in Table 13 is accepted.

The results of Grubbs' test for the product with a shortage in supply are presented in Table 14.

TABLE 14
www.frontiersin.org

Table 14. The results of Grubbs' tests by pharmacies (product with shortage).

By using Grubbs' test outliers are detected in pharmacies 1, 3, 4, and 8 for the product with a shortage in supply. The results of outliers are summarized in Table 14.

It is essential to mention that almost half of the pharmacies have outliers during the analyzed period.

Discussion

The author tested forecasting methods by using different planning levels and outlier detection procedures. The results using the forecasting method incorporating seasonality aspect Holt–Winters Multiplicative method with outlier detection give better results, which has to be applied on the lowest planning level with summing forecasts to estimate the total volume per pharmacy chain. However, if the sales of drugs are increasing, the research results could be improved by adding safety stock to the results reached with the forecasting method application. The drugs with the increase of sales are potential to be in shortage as the method follows historical data that in certain time of period the sales could not show the upcoming increase in sales. However, this is not tested in this study but could be used as the scenario for further research.

The seasonality aspect was revised by using Google trend statistics on drug search data as recommended by Rossignol et al. (24) for spring and summer in the year 2021, and it was evident that during COVID the seasonality aspect was not a case that requires separate investigation.

After the literature review, it is identified that the number of forecast periods should be selected based on the maximum lead-time that is necessary to deliver the product to the individual pharmacy. The study focuses on a short term period but a long-term perspective could be researched in case of necessity.

In summary, as the study has some limitations and does not incorporate long-term forecasting and the safety stock for drugs with increasing sales, it does not reduce the advantages of the study, having high MAPE results compared with other papers and the incorporation of planning levels.

Conclusions

The review of the literature shows that several methods Holt's linear and Holt-Winters no trend was not getting high attention from authors seeking to forecast the sales of drugs. The author also figured out the gap in the literature, which suggests about planning levels that a basically the case in the production literature. Due to that the author tried to show the differences in the study how the selection of planning levels impacts the forecasting results. The results of the study show that the application of Holt-Winters Multiplicative method helps to improve the forecast weekly, where one of ten products is in shortage. The paper presents the forecasting model, which is dependent on four different approaches representing the divisions of the pharmacy chain. The article presents impressive empirical research results. After the application of eight forecasting methods for the product without shortage, the third approach is proven and for the product with a shortage - the fourth approach. Both tests show that forecasting at the pharmacy level is applicable for both products. After all, forecasts performed on the pharmacy level are summed up to get the total estimates for a pharmacy chain. The best forecasting method is selected by applying Theil's U2 statistics, which in most cases, presented the best results for Holt-Winters Multiplicative method. The application of this method shows that Theil's U2 value is minimized and the application of this method could support the reduction of shortage in drug supply. On the other hand, it is quite a robust and straightforward forecasting technique. Such technique is especially evident for the product with shortage, where without replacement of data sets for shortage and recovery periods to mean value, only the naive method delivers the best forecasting results. Results prove that before the forecast for the product with shortage, the technique of missing data and outlier detection must be incorporated into the forecasting model. Overwise, it would be oversupplied or undersupplied.

Data Availability Statement

The original contributions presented in the study are included in the article/supplementary material, further inquiries can be directed to the corresponding author.

Author Contributions

The author confirms being the sole contributor of this work and has approved it for publication.

Funding

Funding will be arranged at VILNIUS Gediminas technical university.

Conflict of Interest

The author declares that the research was conducted in the absence of any commercial or financial relationships that could be construed as a potential conflict of interest.

Publisher's Note

All claims expressed in this article are solely those of the authors and do not necessarily represent those of their affiliated organizations, or those of the publisher, the editors and the reviewers. Any product that may be evaluated in this article, or claim that may be made by its manufacturer, is not guaranteed or endorsed by the publisher.

Acknowledgments

This paper is prepared during COST Action 15105.

References

1. Divakar S, Ratchford BT, Shankar V. Practice prize article—chan4cast: a multichannel, multiregion sales forecasting model and decision support system for consumer packaged goods. Marketing Sci. (2005) 24:334–50. doi: 10.1287/mksc.1050.0135

CrossRef Full Text | Google Scholar

2. Tratar LF. Joint optimisation of demand forecasting and stock control parameters. Int J Prod Econ. (2010) 127:173–9. doi: 10.1016/j.ijpe.2010.05.009

CrossRef Full Text | Google Scholar

3. Ayati N, Saiyarsarai P, Nikfar Short S, long term impacts of COVID-19 on the pharmaceutical sector. DARU J Pharmaceutical Sci. (2020) 28:799–805. doi: 10.1007/s40199-020-00358-5

PubMed Abstract | CrossRef Full Text | Google Scholar

4. Taylor JW. Exponential smoothing with a damped multiplicative trend. Int J Forecast. (2003) 19:715–25. doi: 10.1016/S0169-2070(03)00003-7

CrossRef Full Text | Google Scholar

5. Das P, Chaudhury S. Prediction of retail sales of footwear using feedforward and recurrent neural networks. Neural Comput Applicat. (2007) 16:491–502. doi: 10.1007/s00521-006-0077-3

CrossRef Full Text | Google Scholar

6. Jain A, Menon MN, Chandra S. Sales forecasting for retail chains. San Diego, California: UC San Diego Jacobs School of Engineering. (2015).

Google Scholar

7. Kays HM, Karim ANM, Daud MRC, Varela ML, Putnik GD, Machado JM. A Collaborative multiplicative holt-winters forecasting approach with dynamic fuzzy-level component. Applied Sci. (2018) 8:530–58. doi: 10.3390/app8040530

CrossRef Full Text | Google Scholar

8. Yelland PM. Bayesian forecasting of parts demand. Int J Forecast. (2010) 26:374–96. doi: 10.1016/j.ijforecast.2009.11.001

CrossRef Full Text | Google Scholar

9. Marmier F, Cheikhrouhou N. Structuring and integrating human knowledge in demand forecasting: a judgemental adjustment approach. Prod Plan Control. (2010) 21:399–412. doi: 10.1080/09537280903454149

CrossRef Full Text | Google Scholar

10. Co HC, Boosarawongse R. Forecasting Thailand's rice export: Statistical techniques vs. artificial neural networks. Comput Ind Eng. (2007) 53:610–27. doi: 10.1016/j.cie.2007.06.005

CrossRef Full Text | Google Scholar

11. Snyder RD, Koehler AB, Hyndman RJ, Ord JK. Exponential smoothing models: means and variances for lead-time demand. Eur J Oper Res. (2004) 158:444–55. doi: 10.1016/S0377-2217(03)00360-6

CrossRef Full Text | Google Scholar

12. Billah B, King ML, Snyder RD, Koehler AB. Exponential smoothing model selection for forecasting. Int J Forecast. (2006) 22:239–47. doi: 10.1016/j.ijforecast.2005.08.002

CrossRef Full Text | Google Scholar

13. Brown RG. Statistical Forecasting for Inventory Control. New York: McGraw/Hill. (1959).

Google Scholar

14. Holt CC. Forecasting seasonals and trends by exponentially weighted moving averages. Int J Forecast. (2004) 20:5–13. doi: 10.1016/j.ijforecast.2003.09.017

CrossRef Full Text | Google Scholar

15. Hyndman RJ, Koehler AB, Snyder RD, Grose S. A state space framework for automatic forecasting using exponential smoothing methods. Int J Forecast. (2002) 18:439–54. doi: 10.1016/S0169-2070(01)00110-8

PubMed Abstract | CrossRef Full Text | Google Scholar

16. Taylor JW. Triple seasonal methods for short-term electricity demand forecasting. Eur J Oper Res. (2010) 204:139–52. doi: 10.1016/j.ejor.2009.10.003

CrossRef Full Text | Google Scholar

17. Lawton R. How should additive Holt-Winters estimates be corrected? Int J Forecast. (1998) 14:393–403. doi: 10.1016/S0169-2070(98)00040-5

CrossRef Full Text | Google Scholar

18. Segura JV, Vercher E. A spreadsheet modeling approach to the Holt-Winters optimal forecasting. Eur J Oper Res. (2001) 131:375–88. doi: 10.1016/S0377-2217(00)00062-X

CrossRef Full Text | Google Scholar

19. Bruce L, Richard T, Anne B. Forecasting Time Series and Regression. Stamford: Thomson Brooks/Cole. (2005).

Google Scholar

20. Koehler AB, Snyder RD, Ord JK. Forecasting models and prediction intervals for the multiplicative Holt-Winters method. Int J Forecast. (2001) 17:269–86. doi: 10.1016/S0169-2070(01)00081-4

CrossRef Full Text | Google Scholar

21. Winters PR. Forecasting sales by exponentially weighted moving averages. Manag Sci. (1960) 6:324–42. doi: 10.1287/mnsc.6.3.324

CrossRef Full Text | Google Scholar

22. Chatfield C, Yar M. Prediction intervals for multiplicative Holt-Winters. Int J Forecast. (1991) 7:31–7. doi: 10.1016/0169-2070(91)90030-Y

CrossRef Full Text | Google Scholar

23. Van der Aa NGFM, Kommer GJ, Van Montfoort JE, Versteegh JFM. Demographic projections of future pharmaceutical consumption in the Netherlands. Water Sci Technol. (2011) 63:825–31. doi: 10.2166/wst.2011.120

PubMed Abstract | CrossRef Full Text | Google Scholar

24. Rossignol L, Pelat C, Lambert B, Flahault A, Chartier-Kastler E, Hanslik T. A method to assess seasonality of urinary tract infections based on medication sales and google trends. PLoS ONE. (2013) 8:e76020. doi: 10.1371/journal.pone.0076020

PubMed Abstract | CrossRef Full Text | Google Scholar

25. Buxey G. Strategy not tactics drives aggregate planning. Int J Product Econ. (2003) 85:331–46. doi: 10.1016/S0925-5273(03)00120-8

CrossRef Full Text | Google Scholar

26. Bowerman BL, O'Connell RT, Koehler AB. Forecasting Time Series, and Regression: An Applied Approach. Nashville: South-Western Pub. (2005).

Google Scholar

27. Dong R, Pedrycz W. A granular time series approach to long-term forecasting and trend forecasting. Phys A Stat Mech Appl. (2008) 387:3253–70. doi: 10.1016/j.physa.2008.01.095

CrossRef Full Text | Google Scholar

28. Hamzaçebi C, Akay D, Kutay F. Comparison of direct and iterative artificial neural network forecast approaches in multi-periodic time series forecasting. Expert Syst Appl. (2009) 36:3839–44. doi: 10.1016/j.eswa.2008.02.042

CrossRef Full Text | Google Scholar

29. Gardner ES Jr. Exponential smoothing: the state of the art—Part II. Int J Forecast. (2006) 22:637–66. doi: 10.1016/j.ijforecast.2006.03.005

PubMed Abstract | CrossRef Full Text | Google Scholar

30. Bermúdez JD, Segura JV, Vercher E. Holt-Winters forecasting: an alternative formulation applied to UK air passenger data. J Appl Stat. (2007) 34:1075–90. doi: 10.1080/02664760701592125

CrossRef Full Text | Google Scholar

31. Maia ALS, de Carvalho FDA. Holt's exponential smoothing and neural network models for forecasting interval-valued time series. Int J Forecast. (2011) 27:740–59. doi: 10.1016/j.ijforecast.2010.02.012

CrossRef Full Text | Google Scholar

32. Bermúdez JD, Segura JV, Vercher E. A decision support system methodology for forecasting of time series based on soft computing. Comput Stat Data Anal. (2006) 51:177–91. doi: 10.1016/j.csda.2006.02.010

CrossRef Full Text | Google Scholar

33. Vroman P, Happiette M, Rabenasolo B. Fuzzy adaptation of the holt–winter model for textile sales-forecasting. J Text Inst. (1998) 89:78–89. doi: 10.1080/00405009808658668

CrossRef Full Text | Google Scholar

34. Grubb H, Mason A. Long lead-time forecasting of UK air passengers by Holt-Winters methods with damped trend. Int J Forecast. (2001) 17:71–82. doi: 10.1016/S0169-2070(00)00053-4

CrossRef Full Text | Google Scholar

35. Lepojevic V, Andelkovic'-Pešic M. Forecasting Electricity consumption by using Holt-Winters and seasonal regression models. Econ Org. (2016) 8:421–31. Available online at: https://docplayer.net/20929070-Forecasting-electricity-consumption-by-using-holt-winters-and-seasonal-regression-models-udc-519-246-8-vinko-lepojevic-marija-andelkovic-pesic.html

Google Scholar

36. Arora S, Taylor JW. Short-term forecasting of anomalous load using rule-based triple seasonal methods. IEEE Trans Power Syst. (2013) 28:3235–42. doi: 10.1109/TPWRS.2013.2252929

CrossRef Full Text | Google Scholar

37. Sudheer G, Suseelatha A. Short term load forecasting using wavelet transform combined with Holt-Winters and weighted nearest neighbor models. Int J Electr Power Energy Syst. (2015) 64:340–6. doi: 10.1016/j.ijepes.2014.07.043

CrossRef Full Text | Google Scholar

38. Costantino F, Di Gravio G, Shaban A, Tronci M. Smoothing inventory decision rules in seasonal supply chains. Expert Syst Appl. (2016) 44:304–19. doi: 10.1016/j.eswa.2015.08.052

CrossRef Full Text | Google Scholar

39. Khosroshahi H, Husseini SM, Marjani MR. The bullwhip effect in a 3-stage supply chain considering multiple retailers using a moving average method for demand forecasting. Appl Math Model. (2016) 40:8934–51. doi: 10.1016/j.apm.2016.05.033

CrossRef Full Text | Google Scholar

40. Nikolopoulos K, Buxton S, Khammash M, Stern P. Forecasting branded and generic pharmaceuticals. Int J Forecast. (2016) 32:344–57. doi: 10.1016/j.ijforecast.2015.08.001

CrossRef Full Text | Google Scholar

41. Restyana A, Savitri L, Laili NF, Probosiwi N. Analysis of drug forecasting with single moving average and single exponential smoothing approach (Case Study in Jombang Regency 2017-2019). J Phys: Conference Series. (2021) 1899:012100. doi: 10.1088/1742-6596/1899/1/012100

CrossRef Full Text | Google Scholar

42. Zahra IA, Putra YH. Forecasting methods comparation based on seasonal patterns for predicting medicine needs with ARIMA method, single exponential smoothing. In: IOP Conference Series: Materials Science and Engineering. IOP Publishing. (2019). doi: 10.1088/1757-899X/662/2/022030

CrossRef Full Text | Google Scholar

43. Sousa RM, Hannachi S, Ramos GN. Statistical and deep learning models for forecasting drug distribution in the brazilian public health system. In: 2019 8th Brazilian Conference on Intelligent Systems (BRACIS). IEEE. (2019) p.723–728. doi: 10.1109/BRACIS.2019.00130

CrossRef Full Text | Google Scholar

44. Newberne JH. Holt-Winters Forecasting: A Study of Practical Applications for Healthcare Managers. Las Vegas NV: Mike O'callaghan Federal Hospital. (2006). doi: 10.21236/ADA473648

CrossRef Full Text | Google Scholar

45. Bon AT, Ng TK. An optimization of inventory demand forecasting in university healthcare centre. In :IOP Conference Series: Materials Science and Engineering. Bristol: IOP Publishing. (2017) p. 012035. doi: 10.1088/1757-899X/166/1/012035

PubMed Abstract | CrossRef Full Text | Google Scholar

46. Christofer C. Information on pharmacy inventory management with forecasting method (double moving average & double exponential smoothing). bit-Tech. (2021) 4:25–30. doi: 10.32877/bt.v4i1.233

CrossRef Full Text | Google Scholar

47. Ribeiro A, Seruca I, Durão N. Improving organizational decision support: detection of outliers and sales prediction for a pharmaceutical distribution company. Procedia Comput Sci. (2017) 121:282–90. doi: 10.1016/j.procs.2017.11.039

CrossRef Full Text | Google Scholar

48. Siddiqui R, Azmat M, Ahmed S, Kummer S. A hybrid demand forecasting model for greater forecasting accuracy: the case of the pharmaceutical industry. In: Supply Chain Forum: An International Journal. Taylor & Francis. (2021) p. 1–11. doi: 10.1080/16258312.2021.1967081

CrossRef Full Text | Google Scholar

49. Wongsunopparat P, Chaveesuk R. Sales forecasting of traditional medicine using time series forecasting techniques. in 50. Kasetsart University Annual Conference. Bangkok (2012).

Google Scholar

50. Makridakis S, Andersen A, Carbone R, Fildes R, Hibon M, Lewandowski R, et al. The accuracy of extrapolation (time series) methods: Results of a forecasting competition. J Forecast. (1982) 1:111–53. doi: 10.1002/for.3980010202

CrossRef Full Text | Google Scholar

51. Makridakis S, Hibon M. The M3-Competition: results, conclusions and implications. Int J Forecast. (2000) 16:451–76. doi: 10.1016/S0169-2070(00)00057-1

CrossRef Full Text | Google Scholar

52. State Medicines Control Agency of Lithuania. Baltic Statistics on Medicines 2016–2018. (2019). Available online at: https://www.zva.gov.lv/sites/default/files/2020-01/Baltic%20statistics_3rd%20edition.pdf

Google Scholar

53. Kanyalkar AP, Adil GK. An integrated aggregate and detailed planning in a multi-site production environment using linear programming. Int J Product Res. (2005) 43:4431–54. doi: 10.1080/00207540500142332

CrossRef Full Text | Google Scholar

54. Luo J, Cisler RA. Discovering outliers of potential drug toxicities using a large-scale data-driven approach. Cancer informat. (2016) 15:211–8. doi: 10.4137/CIN.S39549

PubMed Abstract | CrossRef Full Text | Google Scholar

55. Soule D, Grushka-Cockayne Y, Merrick JR. A Heuristic for Combining Correlated Experts When There is Little Data. (2021). doi: 10.2139/ssrn.3680229

CrossRef Full Text | Google Scholar

56. Katayama H. On a two stage hierarchical production planning system for process industries. Int J Prod Econ. (1996) 44:63–72. doi: 10.1016/0925-5273(95)00093-3

CrossRef Full Text | Google Scholar

57. Mehra A, Minis I, Proth JM. Hierarchical production planning for complex manufacturing systems. Adv Eng Softw. (1996) 26:209–18. doi: 10.1016/0965-9978(95)00117-4

CrossRef Full Text | Google Scholar

58. Moreira NA, Oliveira RC. A decision support system for production planning in an industrial unit. Eur J Oper Res. (1991) 55:319–28. doi: 10.1016/0377-2217(91)90202-7

CrossRef Full Text | Google Scholar

59. Leong GK, Oliff MD, Markland RE. Improved hierarchical production planning. J Operat Manage. (1989) 8:90–114. doi: 10.1016/0272-6963(89)90014-4

CrossRef Full Text | Google Scholar

60. Tsubone H, Sugawara M. A hierarchical production planning system in the motor industry. Omega: Int J Manage Sci. (1987) 15:113–20. doi: 10.1016/0305-0483(87)90025-9

CrossRef Full Text | Google Scholar

61. Bauder RA, Khoshgoftaar TM. Multivariate outlier detection in medicare claims payments applying probabilistic programming methods. Health Ser and Outcomes Res Methodol. (2017) 17:256–89. doi: 10.1007/s10742-017-0172-1

CrossRef Full Text | Google Scholar

62. Chen F, Ryan JK, Simchi-Levi D. The impact of exponential smoothing forecasts on the bullwhip effect. Naval Res Log. (2000) 47:269–86. doi: 10.1002/(SICI)1520-6750(200006)47:4<269::AID-NAV1>3.0.CO;2-Q

CrossRef Full Text | Google Scholar

63. Barrow DK, Kourentzes N. Distributions of forecasting errors of forecast combinations: implications for inventory management. Int J Prod Econ. (2016) 177:24–33. doi: 10.1016/j.ijpe.2016.03.017

CrossRef Full Text | Google Scholar

64. Tratar LF, Mojškerc B, Toman A. Demand forecasting with four-parameter exponential smoothing. Int J Prod Econ. (2016) 181:162–73. doi: 10.1016/j.ijpe.2016.08.004

CrossRef Full Text | Google Scholar

65. Kays HE, Karim ANM, Hasan M, Sarker RA. Impact of initial level and growth rate in multiplicative HW model on bullwhip effect in a supply chain. In: Sarker, R. et al. (eds). Data and Decision Sciences in Action. Cham: Springer International, P.ublishing. (2018). p. 357–368. doi: 10.1007/978-3-319-55914-8_26

CrossRef Full Text | Google Scholar

66. Chen H, Qian C, Liang C, Kang W. An approach for predicting the compressive strength of cement-based materials exposed to sulfate attack. PLoS ONE. (2018) 13:1–18. doi: 10.1371/journal.pone.0191370

PubMed Abstract | CrossRef Full Text | Google Scholar

67. Brooks E, Tett SE, Isbel NM, Staatz CE. Population pharmacokinetic modelling and Bayesian estimation of tacrolimus exposure: is this clinically useful for dosage prediction yet? Clinical pharmacokinet. (2016) 55:1295–335. doi: 10.1007/s40262-016-0396-1

PubMed Abstract | CrossRef Full Text | Google Scholar

68. Wang J, Wang J, Fang W, Niu HL. Financial time series prediction using Elman recurrent random neural networks. Comput Intell Neurosc. (2016) 1–14. doi: 10.1155/2016/4742515

PubMed Abstract | CrossRef Full Text | Google Scholar

69. Qian Y, Zhang X, Fei G, Sun Q, Li X, Stallones L, et al. Forecasting deaths of road traffic injuries in China using an artificial neural network. Traffic Injury Prev. (2020) 1–6. doi: 10.1080/15389588.2020.1770238

PubMed Abstract | CrossRef Full Text | Google Scholar

70. Makridakis S, Wheelwright SC, Hyndman RJ. Forecasting: Methods and Applications. New York: John Wiley and Sons. (1998).

Google Scholar

Keywords: forecasting, model, drug, accuracy, shortage, planning levels

Citation: Burinskiene A (2022) Forecasting Model: The Case of the Pharmaceutical Retail. Front. Med. 9:582186. doi: 10.3389/fmed.2022.582186

Received: 10 July 2020; Accepted: 31 May 2022;
Published: 03 August 2022.

Edited by:

Isabelle Huys, KU Leuven, Belgium

Reviewed by:

Segundo Mariz, European Medicines Agency, Netherlands
Virginia Lee Acha, MSD, United Kingdom

Copyright © 2022 Burinskiene. This is an open-access article distributed under the terms of the Creative Commons Attribution License (CC BY). The use, distribution or reproduction in other forums is permitted, provided the original author(s) and the copyright owner(s) are credited and that the original publication in this journal is cited, in accordance with accepted academic practice. No use, distribution or reproduction is permitted which does not comply with these terms.

*Correspondence: Aurelija Burinskiene, aurelija.burinskiene@vilniustech.lt

Disclaimer: All claims expressed in this article are solely those of the authors and do not necessarily represent those of their affiliated organizations, or those of the publisher, the editors and the reviewers. Any product that may be evaluated in this article or claim that may be made by its manufacturer is not guaranteed or endorsed by the publisher.