Table 5: Production planning for solution scenario of sixth
generation mobile phone.
Events Week Pr.
Quantity
(FG.)
Stocks
(FG.)
Pr.
Quantity
(WIP.)
Stocks
(WIP.)
Start
WIP.
37 0 0 37,500
37,500
38 0 0 37,500
75,000
39 0 0 37,500
112,500
40 0 0 37,500
150,000
Start FG.
41 0 0 37,500
187,500
42 50,000 50,000 37,500
175,000
43 50,000 100,000 37,500
162,500
44 50,000 150,000 37,500
150,000
45 50,000 200,000 37,500 137,500
46 50,000 250,000 37,500 125,000
47 50,000 300,000 37,500 112,500
48 50,000 350,000 37,500 100,000
49 50,000 400,000 37,500 87,500
Release
FG.
50 50,000 215,000 37,500 75,000
51 50,000 90,000 37,500 62,500
52 50,000 30,000 37,500 50,000
1 50,000 18,000 37,500 37,500
2 27,061 18,061 0 10,439
3 10,439 9,500 18,944 18,944
4 14,974 9,474 0 3,970
5 3,970 4,944 8,237 8,237
6 5,409 4,853 0 2,828
7 2,828 4,181 3,423 3,423
8 2,355 4,086 0 1,068
9 1,068 2,604 2,462 2,462
scenario as $3,653,885.23. Therefore, summing loss
sales and carrying costs together we obtain the total
cost for problem and solution scenario as
$5,054,512.03 and $3,653,885.23, respectively. On
the other hand, upon implementing solution scenario,
we can reduce costs by $1,400,626.80 or by 27.71%.
Somehow, in this research, we propose the
solution scenario on forecasting only product demand
without considering other important variables such as
promotion and competitors. Therefore, for future
research, it would be more practical if we included
these variables into building the forecast model.
REFERENCES
Aburto, L., Weber, R. (2007). A sequential hybrid
forecasting system for demand prediction. In: Perner, P.
(ed.) MLDM 2007. LNCS (LNAI), vol. 4571, pp. 518–
532. Springer, Heidel-berg.
Binesh, F., Belarmino, A. M., Van der Rest, J. P., Singh, A.
K., & Raab, C. (2024). Forecasting hotel room prices
when entering turbulent times: a game-theoretic
artificial neural network model. International Journal of
Contemporary Hospitality Management, 36(4), 1044-
1065.
Fischera, T., Kraussb, C. (2017). Deep learning with long
short-term memory networks for financial market
predictions. FAU Discussion Papers in Economics.
Ghosh, S. (2020). Forecasting of demand using ARIMA
model. American Journal of Applied Mathematics and
Computing, 1(2), 11-18.
Huber, J., Gossmann, A., & Stuckenschmidt, H. (2017).
Cluster-based hierarchical demand forecasting for
perishable goods. Expert systems with applications, 76,
140-151.
Ingle, C., Bakliwal, D., Jain, J., Singh, P., Kale P., and
Chhajed, V. (2021). Demand Forecasting: Literature
Review on Various Methodologies, 12th International
Conference on Computing Communication and
Networking Technologies (ICCCNT), Kharagpur,
India, pp. 1-7, doi: 10.1109/ICCCNT51525.2021.958
0139.
Kimes, S. E., Chase, R. B., Choi, S., Lee, P. Y., & Ngonzi,
E. N. (1998). Restaurant revenue management:
Applying yield management to the restaurant industry.
Cornell Hotel and Restaurant Administration Quarterly,
39(3), 32-39.
Luckyn, B. J., Alabere, I., & Ogra, O. (2024). Predictive
Modelling for Diaper Sales in Retail: An Artificial
Neural Network Approach. Iconic Research and
Engineering Journals, 7(8).
Ma, S., Fildes, R., & Huang, T. (2016). Demand forecasting
with high dimensional data: The case of SKU retail
sales forecasting with intra-and inter-category
promotional information. Euro-pean Journal of
Operational Research, 249(1), 245-257.
Nuanmeesri, S., Poomhiran, L., Chopvitayakun, S., &
Kadmateekarun, P. (2022). Improving dropout
forecasting during the COVID-19
pandemic through
feature selection and multilayer perceptron neural
network. International Journal of Information and
Education Technology, 12(9), 851-857.
Priyadarshi, R., Panigrahi, A., Routroy, S., & Garg, G. K.
(2019). Demand forecasting at retail stage for selected
vegetables: a performance analysis. Journal of
Modelling in Management, 14(4), 1042-1063.
Ramya, B. S. S., & Vedavathi, K. (2020). An advanced
sales forecasting using machine learning algorithm.
International Journal of Innovative Science and
Research Technology, 5(5), 342-345.
Raza, K. (2017). Prediction of stock market performance by
using machine learning techniques. In: International