Its been awhile since I was in collegeI think I forgot most of the details I

Its been awhile since i was in collegei think i

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 Questions 1. 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? Month Cases Year 1 Cases Year 2 Cases Year 3 January 480 575 608 February 436 527 597 March 482 540 612 April 448 502 603 May 458 508 628 June 489 573 605 July 498 508 627 August 430 498 578 September 444 485 585 October 496 526 581 November 487 552 632 December 525 587 656
Image of page 1
Answer
Image of page 2
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Summer '16
  • Julian Hoseason
  • 175, Paul Jordan

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture