Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shownin the table below:2Week 1Demand 19 23Week1Demand19Forecast 19.03272234363275624 28 37436a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 19.0are (round your responses to two decimal places):5246288207379268201029926D1029

Answered: Sales of tablet computers at Marika…

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

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?
4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.
FORECASTING- EXPONENTIAL SMOOTHING QUESTION 3 PERIOD АCTUAL 1 42 2 40 3 43 4 40 5 41 39 7 46 8 44 9. 45 10 38 11 40 12 a) Consider exponential smoothing forecasts using smoothing constants (a) 0.1 and 0.4
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal places. Actual Quarter Tonnage Unloaded 1 2 3 4 5 6 7 8 175 160 170 160 160 170 180 200 Forecast for a=3 175 175.0 170.5 167.2 165.1 166.6 170.6 Sum of absolute deviation = Absolute Deviation for a = .3 Other questions: (1) What is the MAD for a = .3? (2) Which smoothing constant would you prefer? 0.00 15.00 0.50 10.35 4.93 13.45 29.41 80.89 Forecast for a = .6 175 166.0 168.4 163.4 161.3 166.5 174.6 Absolute Deviation for a = .6 0.00 15.00 4.00 8.40 3.36 8.66 13.46 25.38
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.)
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round 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)
A recently introduced product has a positive trend in sales. The product’s sales have increased in each of its first eight weeks on the market. The forecast for week 6 was 1,325 (F6 = 1,325), with A6 = 1,283 and T6 = 42. Using smoothing components α = 0.20 and β = 0.30, develop forecasts for weeks 7 and 8.
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Year Forecast (000) 1 2 4.00 7.00 1 5.00 3 5.00 Registrations (000) a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (a) of 0.40 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place): 2 3 4.6 5.56 4 4.00 4 5.34 11 9 10 7 8 6 5 9.00 9.00 6.00 10.00 13.00 14.00 12.00 5 4.80 6 7 6.48 7.49 8 6.89 9 8.14 10 10.08 11 11.64 12 11.79 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (a) = 0.40 and a starting forecast of F₁ = 5.00) is response to one decimal place). registrations (round your
A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The t below shows the number of emergencies each evening. Weekday Number of calls each day Monday 10 Tuesday 2 Wednesday 12 Thursday 12 (Round your answer to 1 decimal place.) What would be their forecast for the emergencies on Friday using a two-day moving average approach? Forecast for Friday calls
One forecasting model was used to forecast demand for a product. The forecasts and the demand are shown in the table below. Use two decimals in your answer. Actual Forecast 1 40 41 2 35 38 3 38 35 4 33 30 The Mean Absolute Deviation (MAD) is O 0.5 2.5 O 1.48 7.01

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS