Phillip Cane, the managing editor of Your Life Magazine, needs to develop a forecasting system for monthly newsstand sales in order to schedule press runs. Sales in thousands of copies for the last eight months of 2020 (the first year of publication) were: Month (2020) Sales May 50 June 45 July 60 August 52 September 69 October 60 November 47 December 53 Phillip does not believe there is a seasonal pattern. Make the forecast using the following techniques for the first six months of 2021: Ordinary least squares technique or linear regression analysis

Answered: Ordinary least squares technique or…

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

Related questions

Question

Phillip Cane, the managing editor of Your Life Magazine, needs to develop a forecasting system for monthly newsstand sales in order to schedule press runs. Sales in thousands of copies for the last eight months of 2020 (the first year of publication) were:

Month (2020) Sales

May 50

June 45

July 60

August 52

September 69

October 60

November 47

December 53

Phillip does not believe there is a seasonal pattern. Make the forecast using the following techniques for the first six months of 2021: