Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shownin the table below:1WeekDemand 213221 29438Week31 2Demand 21 21 29Forecast 21.0525a) The forecast for weeks 2 through 10 using exponential smoothing withare (round your responses to two decimal places):4386295256297810935 20 26 29= 0.55 and a week 1 initial forecast of 21.07358209261029

The exponential smoothing forecast can be seen as an extension of the simple moving average…

Answered: a) The forecast for weeks 2 through 10…

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

Please solve this
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.
Given an actual demand this period of 90, a forecast for this period of 58, and an alpha of 0.2, what would the forecast for the next period be using exponential smoothing?
6. Consider the following data table. (12 Points) a) Forecast demand using exponential smoothing with an apha of 0.25, and an initial forecast of 128.0 for period 1. b) Calculate the MAD and MSE. Period Real demand 130 138 129 140 3 4 5 133
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
Marianne Schwartz, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in customers. She is interested in arriving at a forecast of rentals so that she can order the correct quantities of supplies that go with the cleaners. Data for the last 10 weeks are shown here. Part 2 Week 1 2 3 4 5 6 7 8 9 10 Rentals 23 22 25 23 22 11 21 34 19 13 Part 3 a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average LOADING... . (Enter your responses rounded to two decimal places.) Week Forecast 6 enter your response here Part 4 7 enter your response here Part 5 8 enter your response here Part 6 9 enter your response here Part 7 10 enter your response here Part 8 What is the…
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
The following table shows the actual demand observed over the last 11 years: Year 1 Demand 8 2 9 3 5 This exercise contains only parts b, c, and d. b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year Forecast 4 5 4 10 6 5 13 7 6 7 8 7 11 9 8 14 10 9 8 11 10 13 12 11 8
Problem 3
The following gives the number of pints of type Bblood used a t Woodlawn Hospital in the past 6 weeks: a) Forecast the dema nd for the week of October 12 using a3-week moving average.b) Use a 3-week weighted moving average, with weights of .I , .3,and .6, using .6 for the most recent week. Forecast demand forthe week of October 12.c) Compute the forecast for the week of October 12using exponentialsmoothing with a forecast for August 31 of 360 and a = .2

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

a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 Demand 21 Forecast 21.0 2 3 21 29 4 38 5 25 6 29 7 35 8 20 9 26 10 29