Cinema HD an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend of memberships in order to project future needs. Year 2013 2014 2015 2016 2017 2018 2019 2020 2021 Membership 17 16 16 21 20 20 23 25 24   a. What are the issues associated with qualitative forecasting, and how are these overcome? b.Provide an example of qualitative forecasting and explain the shortcomings.

To have a stable forecasting tool when using the simple moving average method, what value of N (the number of periods) should a firm choose among the following choices? a. 3b. 2c. 8d. 6

2. Given the following data, use exponential smoothing with a = 0.2 and a = 0.5 to generate forecasts for periods 2 through 6. Use MAD and MSE to decide which of the two models produced a better forecast. Period Actual Forecast 1 15 17 2 18 3 14 4 16 5 13 6 16

Asvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.

If descriptive analytics focuses on summarizing historical data to gain insights into past events and trends and predictive analytics focused on forecasting future outcomes. What is the significance of the relationship between the past and the future?

Explain qualitative forecasting methods that managers can use to predict future behavior in various aspects of a company's operations. Use the following guide: Development Define and provide an example of each of the following qualitative forecasting techniques: Executive opinionSales force estimatesDelphi methodMarket research

Answer this using excel on a spreads

K 2. Setting an advertising budget is a forecasting exercise. What are the fundamental principles that should be adhered to when undertaking forecasting?   Be conservative and use the best evidence-based technique available Be innovative and use multiple methods and choose the optimal one Be conservative and use multiple evidence-based techniques, taking the average result Be innovative and use multiple evidence-based techniques, taking the average result