FOR RCI CASE STUDY

PLEASE SHOW EXCEL FORMULAS AND FINAL EXCEL SUBMISSION

Overview

Another important consideration when making business recommendations is future outcomes. You must be able to use forecasting tools and the right data to predict elements that affect the future of the business. Using this analysis, along with your analyses and problem statement, you will be able to make recommendations to the organization, such as whether or not to outsource manufacturing.

Prompt

Next, you will be required to make formal recommendations in order to address the organizational challenges, supporting your strategies with applicable and relevant data. You will also need to communicate your recommendations and findings to the appropriate stakeholders. Finally, you will need to consider the organizations future outcomes based on a forecasting analysis.

Specifically, you must address the critical elements listed below.

1. Recommendations and Future Outcomes:
   1. Produce a forecasting analysis using exponential smoothing in order to determine the demand of the product line.
      1. Assume Double digit growth 12% evenly distributed quarterly
      2. Alpha value: 0.2
      3. Beta value: 0.5
   2. Based on your problem statement and analysis of the data, recommend effective strategies that will resolve each of the organizations challenges cited earlier.