Hello - I am looking for a forecast model to help my team plans sales. We have multiple restaurants (over 50) and are looking for a model that using historical trends, seasonality and the appropriate algorithm (exponential smoothing, regression, etc) to give the most accurare forecast. The model should be able to do the following:
- suggest daily, weekly, period and annual forecasts by restaurant, area (6-10 restaurants), region (30-50 restaurants) and company
- take seasonality, cannibalization, holidays, daylight savings, etc into account
- forecast sales by occasion (second phase) - delivery, take-out or dine-in
- remove anomalies/irregularities from data
- forecast new unit growth
Ideally we would create in excel and may have a SQL backend. We have sales history for every unit
19 freelance font une offre moyenne de $14/heure pour ce travail
Hi, I've been developing regression and time series models using SAS, SPSS, STATA, EVIEWS, EXCEL, SPSS for several years and would like to work on your project. I'm looking forward to hearing from you.
I had my own restaurant once so I assume I could be of great help to you. Moreover this seems to be more of an analytical job rather than just data entry and requires brainstorming and some experience.