The following are monthly actual and forecast demand levels for May through December for units of a productmanufactured by the Deborah Bishop Company in Des Moines:MonthMayJuneJulyAugustSeptemberOctoberActual Demand10582110112108106130120Forecast Demand1001089798108102105107NovemberDecemberFor the given forecast, the tracking signal = MADS (round your response to two decimal places).

The tracking system is a concept that helps to analyze the performance of a forecasting method or…

Answered: For the given forecast, the tracking…

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

Professor Z needs to allocate time among several tasks next week to include time for students' appointments. Thus, he needs to forecast the number of students who will seek appointments. He has gathered the following data: Week Number of students6 Weeks ago 515 Weeks ago 794 Weeks ago 833 Weeks ago 892 Weeks ago 71Last Week 93 What is this week's forecast using exponential smoothing with alpha = 0.3 , if the forecast for two weeks ago was 77 ? a. 75.2 b. 78.8 c. 69.86 d. 80.54
Step 1 of 4: Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place. Step 2 of 4: Determine the three-period weighted moving average for the next time period with weights of 33 (most recent), 22 (second latest time period), and 11 (oldest time period). If necessary, round your answer to one decimal place. Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.500.50. If necessary, round your answer to one decimal place. Step 4 of 4: Which forecasting method is best and why?
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.
- 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 10 Week 1 Demand 20 2 3 23 27 4 5 37 26 7 8 9 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 Demand 20 Forecast 20.0 2 3 23 27 4 37 5 26 6 30 7 35 8 22 9 24 10 29
The Bayside Fountain Hotel is adjacent to County Coliseum, a 24,000- seat arena that is home to the city's professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened. Compute an exponentially smoothed forecast with an a value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 5 would be (type number only, two decimals) Year Occupancy Rate (%) 1 2 3 4 5 6 7 8 9 6.26 83 78 75 81 86 85 89 90 86
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?
Show the steps on excel to plot the graph and insert the equation on the graph
Help Saved Mary, Susan, and Sarah are running a beach boutique on the board walk of Ocean City. Their favorite product is a red lifeguard hoody. Mary believes it will sell 318 times next season. Susan forecasts sales of 518, and Sarah forecasts 199. What would be the result of a simple forecast combination? (Round to two decimal places)
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)
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)
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
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year 1 2 3 4 5 Mileage 3,000 3,950 3,500 3,750 3,800 Part 2 a) Using a 2-year moving average, the forecast for year 6 = 37753775 miles (round your response to the nearest whole number). Part 3 b) If a 2-year moving average is used to make the forecast, the MAD based on this = enter your response here miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)

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