1 / 9

Forecasting With Dummy Variables

Forecasting With Dummy Variables. Group 6 Evin Whittington Travis Menn. Case 15.1. The Vintage Restaurant, on Captiva Island near Fort Myers, Florida, is owned and operated by Karen Payne. The restaurant just completed its third year of operation. During that time,

smosley
Download Presentation

Forecasting With Dummy Variables

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Forecasting With Dummy Variables Group 6 Evin Whittington Travis Menn

  2. Case 15.1 The Vintage Restaurant, on Captiva Island near Fort Myers, Florida, is owned and operated by Karen Payne. The restaurant just completed its third year of operation. During that time, Karen sought to establish a reputation for the restaurant as a high-quality dining establish-mentthat specializes in fresh seafood. Through the efforts of Karen and her staff, her restaurant has become one of the best and fastest-growing restaurants on the island.

  3. Past Sales Data

  4. Time plot of the Data

  5. Time series plot • The time series plot shows higher sales in the beginning of the year. • The sales dip the their low point around the month of November. • This shows a seasonal pattern in the sales.

  6. Dummy Variables • To forecast the next year of sales we use dummy variables. • Example of Dummy Variables • Month1 = 1 if January, 0 otherwise • Month2 = 1 if February, 0 otherwise • And so on

  7. Regression of dummy variables.

  8. Forecasting • With the Summary Output we are able to forecast the next 12 months of sales. • Forecast:

  9. Forecast Error. • The actual sales for January were $295 which gave us a forecasting error of $128.09 • Reasons for that could be the raw data still has seasonal trends in it. • There also could be some 3rd part factors affecting sales.

More Related