Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: 6 Week 1 Demand 20 2 23 3 4 5 27 37 26 7 8 9 10 30 35 22 24 29 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): Week 1 2 Demand 20 23 Forecast 20.0 3 27 4 37 5 26 6 30 7 35 8 22 9 10 24 29

Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: 6 Week 1 Demand 20 2 23 3 4 5 27 37 26 7 8 9 10 30 35 22 24 29 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): Week 1 2 Demand 20 23 Forecast 20.0 3 27 4 37 5 26 6 30 7 35 8 22 9 10 24 29

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

Following are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons: Week Forecast Method 1 Actual Demand 1 0.95 0.72 2 1.08 0.98 3 0.92 1.07 4 1.17 1.04 Week Forecast Method 2 Actual Demand 1 0.80 0.72 2 1.21 0.98 3 0.88 1.07 4 1.17 1.04 Part 2 The MAD for Method 1 = enter your response here thousand gallons (round your response to three decimal places).
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 2 1 Demand 19 21 3 29 Week 1 2 Demand. 19 21 Forecast 19.01 4 38 3 29 5 25 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 19.0 are (round your responses to two decimal places); 4 38 7 6 28 36 5 25 8 9 10 24 24 30 6 7 28 36 8 9 10 24 24 30
Income at the architectural firm Spraggins and Yunes for the period February to July was as follows: February April May Month Income ($000's) 35.0 28.1 26.3 March 32.6 June 34.5 July 32.0 Assume that the initial forecast for February is 30.0 (in $ thousands) and the initial trend adjustment is 0. The smoothing constants selected are α = 0.1 and ß = 0.3. Using trend-adjusted exponential smoothing, the forecast for the architectural firm's August income is thousand dollars (round your response to two decimal places).
Using the photo attached, answer the following: 1. Using a numerical example, demonstrate to Mr. John how he can use the manual trend projection method of forecasting to forecast demand for the next two years.
2. The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: Week Actual No. of Patients 1 85 2 88 3 96 4 80 5 84 6 93 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.500 on the present period, 0.250 one period ago, 0.125 two periods ago, and 0.125 three periods ago. Part 2 a) What is the value of your forecast? The value of the forecast is _________patients (round your response to two decimal places). c) The mean absolute deviation based on a 2-day moving average = _______ degrees (round your response to one decimal place). d)The mean squared error based on a 2-day moving average of…
Please use an exponential smoothing method with a=.3 and a 2011 forecast of 35 to forecast the mileage for 2013? Keep two decimal places.
A distributor uses the following equation for forecasting demand of ski goggles: Y = 834 + 18*t, where t=0 in Spring of 2013. Each season is a period, so Summer 2013 would be t=1. His seasonal relatives are (Fall=1.2; Winter=1.4; Spring = 0.9; Summer= 0.8). What is his seasonalized forecast for Spring 2014? Plz do fast asap
Use simple exponential smoothing with a -0.8 to forecast electric scooter sales at Guelph- Humber Inc. for July. Assume that the forecast for May was for 45 electric scooters. Round your answer to 1 decimal Electric Scooter Sales Month May 42 June 47 July 45 August 40 Weekly demand for medical masks for the last five weeks at Chopper Drug Store has been as follows: 92, 96, 100, 100 and 102 (listed from the oldest to most recent). Suppose a naive forecast was used to forecast demand. What would the MAD be for this situation? Enrollment in a particular Yoga class at Guelph Fitness Centre for the last five months has been 80, 86, 88, 88 and 90(listed from the oldest to most recent). Suppose a two-month mov average was used to forecast enrollment. What would the MSE be for this situation?
Digicel’s cell phone sales over the last four months are as follows: January = 100 February = 120 March = 130 April = 150 Using the Naïve Approach forecasting method, the forecast for May would be:
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: week of pints used aug 31 360 sep 7 370 sep 14 412 sep 21 383 sep 28 371 oct 5 371 a) the forecasted demand for the week of Oct 12 using a 3 week moving average= 375 pints b)using a 3-week weighted moving average with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecased demand for the week of Oct 12 = 372.20 c) If the forecasted demand for the week of Aug 31 is 360 and (alpha symbol)= 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of Oct 12 week of pints used forecast for this date Aug 31 360…
Suppose you are working for a baking company in Bangladesh. What are the relevant factors you will consider for forecasting? What technique would you apply? How would you reduce forecast error in this case?The company must have to be any Bangladeshi banking company
The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as follows: YEAR CASES OF MERLOT WINE 1 270 2 356 3 398 4 456 5 358 6 500 7 410 8 376 Using an exponential smoothing model with an alpha value of 0.20, estimate the smoothed value calculated as of the end of year 8. Use the average demand for years 1 through 3 as your initial forecast for year 4, and then smooth the forecast forward to year 8. Note: Round your intermediate calculations and final answer to the nearest whole number.