everyone. A little bit of background information: so I have been assigned to create a model simulation to make a time series forecasting concerning the time precise of products in a warehouse that will exceed its capabilities to store any more products. Does anyone know how to solve this? Thank you :) I will appreciate it. There is a pattern where the products will increase in peak season, for instance, from May until July. I have a vague idea to use forecasting method of using centered moving average to know the trend of the increasing in products supply. But I am not sure if it is the right methodological approach for this problem, as I have read about time series forecasting analysis and regressive analysis. Thoughts?
I tried to see if it will work with the method of centred moving average to see the trend increase of product supply. However, using this method comes with several limitation and those are:
1.) Lead time; 2.) Limited review period to order products when the company needs it; 3.) Only make an order if the warehouse has fulfilled its capacity.
