The following table contains the number of complaints received in the department store for first 6 months of operation:
Month |
Jan |
Feb |
Mar |
April |
May |
June |
Complaints |
36 |
45 |
81 |
90 |
108 |
144 |
a. Using the 3 month moving average method
F(April) = {Actual(Jan) + Actual(Feb) + Actual(Mar)}/3
= (36+45+81)/3
= 54
F(May) = (45+81+90)/3
= 72
F(June) = (81+90+108)/3
= 93
b. F(July) = (90+108+144)/3
= 114
c. F(August) = (108+144+145)/3
= 132.33
The following table contains the number of complaints received in the department store for first 6...
Use the following sales data to answer the questions. Month Sales January $250,000 February $200,000 March $300,000 April $350,000 May $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...
Masters Level work....all work must be shown. FORECASTING Forecasting ASSIgnment 1. Given the following data, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the first quarter is January, February, and March; the second quarter is April, May, and June; the third quarter is July, August, September, and the 4° quarter is October, November, and December ul ct 50 This year 235 245 255 295 305 295 Answer (Please show your work...
AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...
Sales of quilt covers at Bud Banis's discount department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgment for the 4 months (March, April, May, and June): MonthJulAugSepOctNovDecJanFebMarAprMayJunUnit Sales98979611012412092831019890110Management's Forecast--------122116110110a) MAD for the forecast developed by the management's technique = _______ sales (round your response to two decimal places).MAPE for the forecast developed by the management's technique = _______ %(round your response to two decimal places).b)...
What is the forecast for May using a four-month moving average? Nov. Dec. Jan. Feb. Mar. April 29 26 30 32 38 36 38 34 33 32 Please explain how to arrive at the correct answer. Thanks a lot Step by step would be great.
The past sales history for Store 6 is provided in the table below. Adjust this data using the seasonality index determined using the initial 2 years. Report the re-seasonalized forecast period 36. Month Year Period Store 6 January 1 1 56602 February 1 2 72016 March 1 3 104245 April 1 4 100981 May 1 5 95962 June 1 6 83167 July 1 7 62842 August 1 8 60116 September 1 9 41353 October 1 10 34862 November 1 11...
Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 12 months were as follows: Month January February March April May June Price Per Chip $1.90 $1.61 $1.60 $1.85 $1.90 $1.95 Month July August September October November December Price Per Chip $1.80 $1.85 $1.70 $1.55 $1.50 $1.75 This exercise contains only parts a, b, and c. a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round...
A department store manager has monitored the number of complaints received per week about poor service. The probabilities for numbers of complaints in a week, established by this review, are shown in the table. Number of complaints 0 1 2 3 4 5 Probability 0.16 0.26 0.35 0.10 0.08 0.05 What is the probability of between 3 and 5 (inclusive) complaints received per week? Please specify your answer in decimal terms and round your answer to the nearest hundredth (e.g.,...
4. The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. (a) Forecast sales of jeans for March through June using the naive method, a two-period moving average, and exponential smoothing with an a = 0.2. (Hint: Use naive to start the exponential smoothing process.) (b) Compare the forecasts using MAD and decide which is best. (c) Using your method of choice, make a forecast for...
The Emmett Bath Tub Company sells bathtub in West Virginia. The number sold for the past several months is given along with the forecasts using both 3-month moving average and exponential smoothing (α = .2). Determine the better forecast using the MSE. Month Sales 3-month moving average Error Exponential Smoothing Error Jan 13 Feb 18 March 15 Apr 12 May 14 June 15 July 10