the time is customer wait times and the column with various numbers is the sales persons Id. Then sales by location. We want to forecast sales over 12 months and reduce wait times.

the question here is can the company from the data keep the same sales by reducing head count and stock. Use surplus weights that impact the trend line for 1-12 months using solver and exponential smoothing

I have just finished the exponential smoothing and the trend analysis. By the way, what value of t (time) do you want me to predict (forecast) the value of sales? Is it t = 23? , Also what value of smoothing constant do you want me to use? As of now I used alpha = 0.5 (for smoothing constant, but you can change it at will, and the formula and values will just automatically be adjusted)

I have just finished the exponential smoothing and the trend analysis. By the way, what value of t (time) do you want me to predict (forecast) the value of sales? Is it t = 23? , Also what value of smoothing constant do you want me to use? As of now I used alpha = 0.5 (for smoothing constant, but you can change it at will, and the formula and values will just automatically be adjusted)

By the way in the forecasting using trend analysis, you can put what ever value of t inside the orange-colored box, I made, and the forecasted value for sales will be automatically computed, same with the exponential smoothing, you can put whatever value of the smoothing constant in the orange box then the forecast value for sales will also be adjusted accordingly.

If you are satisfied and happy with the answer, please choose a high rating. If you need more information, clarifications, or are not satisfied yet, choose 'Continue the conversation'. Bonuses are very much appreciated. Thanks!

Kindly remember the ONLY WAY experts receive any credit at all for spending time with customers is if you click on OK, GOOD or EXCELLENT SERVICE even though you have made a deposit or are a subscription customer. YOU MUST COMPLETE THE RATING FOR THE EXPERT TO RECEIVE ANY CREDIT. So kindly do not forget to rate and accept the answer, thanks!