Case Analysis: Which Forecasting Method is Best?, assignment help

Case Analysis: Which Forecasting Method is Best?, assignment help

Imagine that you manage a production line. To be profitable, your line must sell at least 500 products per month. Sales are currently waning, as the market for your product has become saturated by competitors’ products.

In the future, another product line is planned to replace your current line, as the product becomes unprofitable. You will manage the new production line, and your team will stay intact. The program office has asked you to project when sales will fall below the profitability line. The historical sales figures are as follows:

Month Sales Month Sales
Jan-11 850 Jan-12 830
Feb-11 850 Feb-12 836
Mar-11 850 Mar-12 825
Apr-11 850 Apr-12 831
May-11 850 May-12 802
Jun-11 850 Jun-12 794
Jul-11 850 Jul-12 740
Aug-11 850 Aug-12 758
Sep-11 850 Sep-12 720
Oct-11 850 Oct-12 704
Nov-11 850 Nov-12 692
Dec-11 840 Dec-12 670

Based upon historical sales figures and in light of the 500 product minimum sales threshold, provide the following information:

  1. Determine which forecasting method is most appropriate for the problem. Explain why your choice is optimum and why other methods are not as effective.
  2. Perform an empirical analysis – establish a forecast for when sales will fall below the profitability threshold.
  3. Report to the program office with a recommended date that the production line should be converted to the new product.

Your submission should be 2-3 pages in length (excluding the title and references pages). Be sure to use appropriate line spaces between each question, so that your work is organized and easy to follow. Your assignment should follow APA guidelines by including a title page, be in Times New Roman, 12–point font and double spaced. Be sure to use APA-style citation when citing sources to support your claims.