The following monthly sales (in thousands of AUS dollars) of chocolate boxes have been recorded for January, February, March, and April, respectively: 8, 8, 5, 9. Focusing on sales forecast accuracy for the month of April only, explain which of the following forecasting method would you recommend: the Naïve method, the Average method, or the Simple exponential smoothing method (assuming alpha=0.8 and initial state of 7)?

The following monthly sales (in thousands of AUS dollars) of chocolate boxes have been recorded for January, February, March, and April, respectively: 8, 8, 5, 9. Focusing on sales forecast accuracy for the month of April only, explain which of the following forecasting method would you recommend: the Naïve method, the Average method, or the Simple exponential smoothing method (assuming alpha=0.8 and initial state of 7)?

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

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?
The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 17 12 15 15 15 19 22 22 23 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied the most recent month = sales (round your response to one decimal place). Using exponential smoothing with a = 0.35 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…
Monthly sales of storage sheds at Wallace Garden supply are shown in the following table. Using the 3-month moving average forecasting method (simple average), what is your forecast of December sales? Actual Month Sales January February March April May June July August September October November December? O 15.2 16.7 20.67 O None of the above 10 12 16 13 17 19 15 20 22 19 21
The monthly sales for Yazici Batteries, Inc., were asfollows: a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,with the heaviest weights applied to the most recent months.iv) Exponential smoothing using an a = .3 and a Septemberforecast of 18.v) A trend projection. c) With the data given, which method would allow you to fore-cast next March’s sales?
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.
Havana Hats makes the world's best hats. Information for the last eight months follows: Month January February March April May June July August Number of Hats Produced 6,750 2,800 3,250 4,250 7,800 3,700 Intercept X Variable 1 6,150 6,800 r Suppose that Havana expects to sell 4,700 hats during the month of September and that each hat sells for $2.75. Havana performed a least-squares regression and obtained the following results: Total Cost $ 7,500 3,900 4,200 5,050 8,150 4,450 6,900 7,520 Coefficients 1,255.09 0.91 Contribution margin Required: Prepare Havana's contribution margin income statement for the month of September. Note: Round your answers to 2 decimal places. Havana Hats Contribution Margin Income Statement Month of September
Refer to the time series data in Problem 1. Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy: a. Mean absolute error b. Mean squared error c. Mean absolute percentage error d. What is the forecast for week 7? 1. Consider the following time series data: Using the nave method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error b. Mean squared error c. Mean absolute percentage error d. What is the forecast for week 7?
Weekly customer demand for the ice cream can be seen in the table below. Week Demand (gallons) 1 280 2 295 3 315 4 300 5 340 6 335 7 350 Compute a three-week moving average demand and a four-week moving average demand for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week8 with the more accurate method
The Toro Cutlery Company has collected monthly sales information below: MONTH MONTH May January February June March April SALES 15,000 18,000 33,000 115,000 SALES 77,000 30,000 80,000 44,000 MONTH September October November December SALES 34,000 101,000 68,000 84,000 July August The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): Forecast (January, 4-month MA): Forecast (January, 5-month MA): b. What will the forecast be for January the following year using exponential smoothing with a = 0.4? Assume the forecast for February this year is 15,000. Do not round intermediate calculations. Round your answer to the nearest whole number.
The quarterly sales data (number of copies sold) for a college textbook over the past three years are as follows: a. Construct a time series plot. What type of pattern exists in the data? b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = l if quarter l, 0 otherwise; Qtr2 = l if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Based on the model you developed in part (b), compute the quarterly forecasts for next year. d. Let t = 1 to refer to the observation in quarter 1 of year 1; t = 2 to refer to the observation in quarter 2 of year 1; ; and t = 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an equation to account for seasonal effects and any linear trend in the time series. e. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year. f. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.
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