business forecasting in excel;task from the teacher:You are a consultant team up to 3 people that needs to analyze the revenues for the Hotel Hurter Continental based in London and provide a forecast for the first quarter of 2018. The manager of the hotel, , is known to be very demanding (and grumpy). He provided you with the actual numbers and a template called 1.4. Practical Set on Moodle. Regarding the method, he wants you to apply time-series decomposition, and at least two different forecasting methods, but he insists on the fact that one model must use an Exponential Smoothing analysis which optimizes the alpha with the Solver. The choice of the method for the time-series decomposition (additive or multiplicative) and the models is entirely up to you but must be justified in the report. In the end, he only wants one final forecast (i.e., one number) based on your analyses and your accuracy measurements (e.g., MAD, MAPE, MSE)
business forecasting in excel;task from the teacher:You are a consultant team up to 3 people that needs to analyze the revenues for the Hotel Hurter Continental based in London and provide a forecast for the first quarter