Income at the architectural firm Spraggins and Yunes for the period February to July was as follows:FebruaryApril MayMonthIncome ($000's)35.028.126.3March32.6June34.5July32.0Assume that the initial forecast for February is 30.0 (in $ thousands) and the initial trend adjustment is 0. The smoothingconstants selected are α = 0.1 and ß = 0.3. Using trend-adjusted exponential smoothing, the forecast for thearchitectural firm's August income is thousand dollars (round your response to two decimal places).

Ft = alpha*actual of previous period +(1-alpha)*previous forecast trend = beta*(Ft of same - Ft of…

Answered: (5000 S) Assume that the initial…

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 exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200
To have a stable forecasting tool when using the simple moving average method, what value of N (the number of periods) should a firm choose among the following choices? a. 3b. 2c. 8d. 6
2. Given the following data, use exponential smoothing with a = 0.2 and a = 0.5 to generate forecasts for periods 2 through 6. Use MAD and MSE to decide which of the two models produced a better forecast. Period Actual Forecast 1 15 17 2 18 3 14 4 16 5 13 6 16
Which time-series forecasting method works best if the company assumes that product demand will decrease over time? A. Weighted moving average B. Linear trend C. Moving average D. Exponential smoothing
Use regression or simple exponential smoothing with the following data. For exponential smoothing, assume the forecast for year 1 was the same as the actual and use an alpha of 0.7. (use excel to show formauls used) Year Sales 1 290 2 340 3 400 4 410 5 400 1. What is the tracking signal for the forecast?
st Info Period 1 2 3 4 5 6 7 8 9 10 K Develop two exponential smoothing forecasts for periods 2 through 11. For the first forecast, use a = 0.3. For the second, use α = 0.7. Assume that your forecast for period 1 was 205. Click the icon to view the time series data. Find the exponential smoothing forecast for each period when a = 0.3 (enter your responses rounded to one decimal place). Demand 222 249 222 228 235 155 161 153 163 152 X Period 1 2 Demand 222 249 Forecast (α = 0.3) 205
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 17 12 15 12 18 13 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. (a) mean absolute error MAE = (b) mean squared error MSE = (c) mean absolute percentage error (Round your answer to two decimal places.) MAPE = % (d) What is the forecast for week 7?
We are using Winter’s method and monthly data toforecast the GDP. (All numbers are in billions of dollars.)At the end of January 2005, Lt 600 and Tt 5. We aregiven the following seasonalities: January, 0.80; February,0.85; December, 1.2. During February 2005, the GDP is ata level of 630. At the end of February what is the forecastfor the December 2005 level of the GDP? Use a b g 0.5.
The Yummy Ice Cream Company projects the demand for ice cream by using first-order exponential smoothing. Last week the forecast was 100,000 gallons of ice cream, and 90,000 gallons was actually sold. Using alpha=.1, prepare a forecast for next week. Calculate the forecast using Alpha=.2 and Alpha=.3 for this problem. Which values of Alpha gave the best forecast, assuming actual demand for next week ends up being 95,000 gallons?
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 Value 17 12 17 (a) mean absolute error MAE = (b) mean squared error MSE = Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. 4 % 5 6 (d) What is the forecast for week 7? 10 16 15 (c) mean absolute percentage error (Round your answer to two decimal places.) MAPE =
Hi, I need help with solving for the following values (boxed). Thank you.
If month one has 240,000 demands, month two 250,080 demands, month three 325,00 demands, month four 370,000 demands, month five 420,000 demands and month six 509,00 demands. Use a forecast for the first month of 240,000, an initial trend forecast of 50,000, and smoothing parameters of 0.35 for both demand smoothing and trend smoothing. Compute the forecasts and trends using double exponential smoothing

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