Forecasting Monthly Sales on a Month by Month Basis
I am trying to develop a model using Excel (data table perhaps) that can be used to forecast monthly sales on a month-by-month basis based on previous monthly data starting with January of year 7. The sales history is attached.
Please open the attached Excel file and continue to read the following additional remarks.
There are several forecasting methods. It depends on the situation, which would be the best method to use, as each case is different, and often doing forecasts using several methods would be advisable. The best forecasting method could be verified using MAD (mean absolute deviation), but to calculate this we would need the forecasted sales from years 1 to 6, which are not given in the assignment, as in this case the data given in the assignment includes only actual monthly sales numbers. To increase the accuracy of our forecast, we would want to use a more ...
Solution Summary
This solution opens with a short discussion on available forecasting methods and chooses the best methods based on information and data given in the problem. The solution then shows detailed computations on forecasting monthly sales using the trend projection and the seasonal index method, using Excel.
Forecasting sales and mean square error of tennis shoes in ... three-month moving average method to forecast the sales...based on the sales and forecasts for months...
... Case Problem: Forecasting Food and Beverage Sales. ... that will enable her to forecast food and ... that summarizes your findings, forecasts, and recommendations ...
... for Cyrus Brown Manufacturing (CBM) and Sales Forecasting. ... collection estimates regarding the forecast sales: Collection within ... a. The monthly cash budget for ...
... These questions consist of Forecasting, Reliability & TQM, Inventory ... a. Plot the monthly data using Excel. 25. ... equal to .20, assuming a February forecast of 19 ...
... Table 3 Sales Forecasts, Cash Receipts and Payments ... November December January February Sales Forecast Sales (units ... 725,000) (987,500) (875,000) Monthly Loan or ...
... November December 4) For your Aug-Dec forecast predict the ... sed on the related level of sales. ... shows the trend line and regression formula for Monthly sales. ...
...Forecasting had definitely been a problem, but determining its ... Data to measure forecast accuracy had not previously been tracked, nor had forecasts and demand ...
... that the cash budget is a forecast, and that ... this problem would be to stimulate a monthly Gross sales... to June are 20% below current forecasts November December ...
... filed The objective is to forecast monthly carpet sales... carpet sales and independent is monthly construction, the forecasting regression equation ...
