100%(5)5 out of 5 people found this document helpful
This preview shows page 1 - 4 out of 4 pages.
better. It’s been awhile since I was in college—I think I forgot most of the details I learned then. I’d like you to analyze these data and give me an idea of what our business will look like over the next 6 to 12 months. Do you think you can handle this?”“Of course,” Paul replies, sounding more confident than he really is. “How much time do I have?”“I need your report on the Monday before Thanksgiving—that would be November 20th. I plan to take it home with me and read it during the holiday. Since I’m sure you will not be around during the holiday, be sure that you explain things carefully so that I can understand your recommendation without having to ask you any more questions. Since you are new to the company, you should know that I like to see all the details and complete justification for recommendations from my staff.”With that, Paul was dismissed. Arriving back at his office, he began his analysis.Discussion Questions1.Prepare Paul Jordan’s report to John Smithers using regression analysis for Table 1 below.2.Provide a summary of the cell phone industry outlook as part of Paul’s response.3.Add seasonality into your regression model.4.How does the analysis change?5.Is seasonality warranted? If so, how much better is your forecast?MonthCases Year 1Cases Year 2Cases Year 3January480575608February436527597March482540612April448502603May458508628June489573605July498508627August430498578September444485585October496526581November487552632December525587656