As a consultant you have been asked to generate a unit demand forecast for a product for year 2017 using exponential smoothing. The actual demand in year 2016 was 750. The forecast demand in year 2016 was 960. Using this data and a smoothing constant alpha of 0.3, which of the following is the resulting year 2017 forecast value? A) 1,023 B) 1,120 C) 897 D) 813 E) 766

As a consultant you have been asked to generate a unit demand forecast for a product for year 2017 using exponential smoothing. The actual demand in year 2016 was 750. The forecast demand in year 2016 was 960. Using this data and a smoothing constant alpha of 0.3, which of the following is the resulting year 2017 forecast value? A) 1,023 B) 1,120 C) 897 D) 813 E) 766

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 8P

See similar textbooks

Similar questions

Suppose that sending an analyst to an executive education program will raise the precision of the analyst’s forecasts as measured by R-square by .01. How might you put a dollar value on this improvement? Provide a numerical example.
Assume an initial starting Ft of 306 units, a trend (Tt) of eight units, an alpha of 0.20, and a delta of 0.40. If actual demand turned out to be 294, calculate the forecast for the next period. (Round your answer to 1 decimal place.) Forecast for the next period units
Calculate the Tracking Signal(RSFE/MAD t) given the following data and an alpha=0.4.MAD t-1=15: Period Actual Demand Forecast Demand Error ................... RSFE MAD t TS 0 Start up Start Up Start Up 15 1 30 45 2 43 3 38 4 37 5 40
Show your work (use of formula, etc.) in solving the problem. Provide your answer/solution in the answer space provided below. Answer the question: Given the following historical returns, calculate the average return and the standard deviation: Year Return 1 14% 2 10% 3 15% 4 11%
1)Find the forecast for 2012 using the time series trend method. Period Demand 2007 200 2008 150 2009 125 2010 100 2011 50 2) Find the forecast for all possible periods N=3, using the data and the moving average method.
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? What is the forecast for next month?
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2. 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Compute the quarterly forecasts for next year based on the model you developed in part (b). Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for quarter 1 in year 1, t = 2 for quarter 2 in year 1, … t = 12 for quarter 4 in year 3. Compute the quarterly forecasts for next year based on the model you developed in part (d). Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.
The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: ProcurementCost ($) Probability LaborCost ($) Probability TransportationCost ($) Probability 10 0.2 18 0.25 2 0.74 12 0.35 20 0.35 5 0.26 13 0.45 22 0.1 25 0.3 Compute profit per unit for the base-case, worst-case, and best-case scenarios.Profit per unit for the base-case: $ fill in the blank 1Profit per unit for the worst-case: $ fill in the blank 2Profit per unit for the best-case: $ fill in the blank 3 Construct a simulation model to estimate the mean profit per unit. If required, round your answer to the nearest cent.Mean profit per unit = $ fill in the blank 4 Why is the simulation approach to risk analysis preferable to generating a variety of…
Assume an initial starting Ft of 300 units, a trend (Tt ) of eight units, an alpha of 0.30, and a delta of 0.40. If actual demand turned out to be 288, calculate the forecast for the next period.
How much would be needed today to provide an annual amount of $50000 each year for 20 years, at 9% interest each year? a. $546,000 O b. $456,427 O c. $645,000 O d. $456,000
Consider the following time series data: Construct a time series plot. What type of pattern exists in the data? Develop a three-week moving average for this time series. Compute MSE and a forecast for week 8. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 8. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE? Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.