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
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.
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?
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…
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.
Demand for oil changes at Garcia's Garage has been as follows: Number of Oil Changes January 44 February 49 March 66 IT April 59 May 53 June 58 59 63 Month July August a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For Janu The forecasting model is given by the equation Y=+x. (Enter your responses rounded to two decimal places) J Show Transcribed Text >. Use the model to forecast demand for September, October, and November. Here, X=9, 10, and 11, respectively. (Enter your responses rounded to two decimal places.) Forecast for the number of Oil Changes Show Transcribed Text Month September October November can you do all the parts please corrrect
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May June July August September October Actual Demand 105 82 110 112 108 106 130 120 Forecast Demand 100 108 97 98 108 102 105 107 November December For the given forecast, the tracking signal = MADS (round your response to two decimal places).
Month Demand Forecast Error 1 20 2 18 3 21 4 25 5 24 6 27 7 22 8 30 9 23 10 20 11 29 12 22 Mean Abs Error Problem 6: The demand manager of Maverick Jeans is responsible for ensuring sufficient warehouse space for the finished jeans that come from the production plants. It has occasionally been necessary to rent public warehouse space, something that Maverick would like to avoid. In order to estimate the space requirements the demand manager is evaluating moving-average forecasts. The demand (in 1,000 case units) for the last fiscal year is shown below. Bias MAD (mean error) Month 1 2 3 4 5 6 7 8 9 10 11 12 Demand 20 18 21 25 24 27 22 30 23 20 29 22 Use a three-month moving average to estimate the month-in- advance forecast of demand for months 4-12. Calculate the Bias and MAD. (Note: Adjust all cell values to two decimal points.)
Demand for oil changes at Garcia's Garage has been as follows: Month January February March April May June July August Number of Oil Changes 38 55 56 60 58 01 70 52 a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For January, let X=1; for February, let X 2; and so on. The forecasting model is given by the equation Y=X (Enter your responses rounded to two decimal places)
Given is a historical time series for job services demand in the prior 6 months. Month 1 2 3 4 5 6 Demand 799 816 789 814 815 805 The Period 6 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 = Blank 1 (in 2 decimal places)