The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 19 21 17 15 15 18 16 19 22 20 20 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = 21.33 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 to the most recent month = 20.9 sales (round your response to one decimal place). Using exponential smoothing with a = 0.40 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places).

The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 19 21 17 15 15 18 16 19 22 20 20 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = 21.33 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 to the most recent month = 20.9 sales (round your response to one decimal place). Using exponential smoothing with a = 0.40 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 350 370 410 381 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 376.67 pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.20, 0.35, and 0.45, using 0.45 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.)
Since the beginning of the year, the purchase manager at a department store has been recording sales data to be used to compute 4-period moving averages to forecast sales for an upcoming month. Sales data for the months of January through September are reported in the table below. Month January February March April May June July August September Sales 21 20 39 22 29 14 42 28 27 Computed forecast values are not rounded. Compute the four-period moving average forecast for October. value as a whole number by rounding. Specify the Compute the mean absolute deviation (MAD) for the four-period moving average forecasts. Specify the MAD as a whole number by rounding. Compute the mean squared error (MSE) for the four-period moving average forecasts. Specify the MSE as a whole number by rounding. Compute the mean absolute percentage error (MAPE) for the four-period moving average forecasts. Specify the MAPE as a whole number by rounding. CHECK ANSWER
Jean and Dinah had been in business for two years producing umbrellas to be sold to the cruise ship passengers when they docked. They found that they are constantly out of umbrellas and had to rush producions which has resulted in the increase of their production cost. Jean has a nephew who is enrolled in the UWIOC and he advised her to prepare forecasted qualities using the sales that they made over the past months. The data below represents sales for the last 9 months. In order to assist Jean and Dinah you are asked to; a. plot the data on a graph showing the trend b. determine the equation of the trend line c. predict sales for month 10 and 11. Months Sales 1 44 2 52 3 50 4 54 5 55 6 55 7 60 8 56 9 62
September 14 September 21 September 28 October 5 412 381 371 378 a) The forecasted demand for the week of October 12 using a 3-week moving average=pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.15, 0.35, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.)
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows: Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using a five-month moving average approach.
35 The last seven weeks of demand at a new car dealer are shown below. Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using weights of 3, 2, and 1 (where the most recent week receives the highest weight). (Round all forecasts to the nearest whole unit.) Calculate the MAD for this forecast (covering all weeks in which error comparisons can be made). What does the MAD indicate? Week Sales1 252 303 274 315 276 297 30
In a retail store, the actual sales of a particular product (in thousands of units) over the past few months are as follows: Month Sales 1 16 2 22 3 18 4 20 5 23 Using exponential smoothing method with α (smoothing constant) of 0.75 and the given forecast for month 1 equal to 10, what is the forecast for month 6?
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
4. The yearly demand for units manufactured by the Orion Company Limited has been as follows:Year Units Year Units1 520 5 8602 830 6 9403 520 7 9904 750 8 850Required:i. Prepare a forecast for year 5 through 8 by using a three-year simple moving average.What is the forecast for year 9?ii. Calculate the Cumulative Frequency Error (CFE), Mean Absolute Deviation (MAD),Mean Squared Error (MSE), and Mean Absolute Percentage Error (MAPE) as at the endof year 8.
Y9
3)The errors in a particular forecast are as follows: 3, -3, 4, 0, -2. What is the tracking signal for each period of the forecast? (use excel to show formulas )
Please do not give solution in image format thanku