# how to forecast daily sale using Excel

I am a newbie here. well I am trying to find a method or a formula to forecast meals per day, which have ̀5 meals to upload on flights, sales, wastage and passengers are what I have to consider, the old template is not completed yet , and its not so good to forecast, and I can't think of other formulas or methods to forecast , I have the sales in the past few months.. anyone can suggest me which methods can solve this problem? well I am using MS.Excel to calculate or if there is a program to suggest me it would be great :) ..thanks a lot for helping and sorry for my bad english :)

• In excel, your best bet is probably to assume that sales tomorrow will be the same as sales today. This is called the "naive" forecast, and is usually a great place to start. – Zach Oct 16 '13 at 16:09

## 3 Answers

I'd suggest taking a look at http://www.amazon.com/Predictive-Analytics-Microsoft-Conrad-Carlberg/dp/0789749416 if you are restricted to Excel. There are also example R codes in the book to help transition from thinking in Excel to thinking in R. The spreadsheet examples from the book can be found here: http://www.quepublishing.com/store/predictive-analytics-microsoft-excel-9780789749413. Chapter 5 is about time series.

I don't believe that you will find a soultion in EXCEL. If you look at Forecasting hourly time series with daily, weekly & annual periodicity you will find an interesting discussion of daily forecasting. The referenced question also includes hourly forecasting issues which you can safely ignore as you are just concerned with daily activity.

• @IsishStat thanks for your suggestion but I need to do with excel because I don't know other programs :( – user30440 Sep 23 '13 at 13:15

You can use in-built Excel functionality:

https://support.office.com/en-gb/article/Create-a-forecast-in-Excel-2016-for-Windows-22c500da-6da7-45e5-bfdc-60a7062329fd

or an external tool, e.g.

https://www.averisera.uk/forecasting-tool.html

http://www.proforecaster.net/