Income at the architectural firm of Spraggins and Yunes for the period February to July was as follows:MonthIncome ($000's)February March70.068.5The mean squared error (MSE) for the forecast developed using trend-adjusted exponential smoothing =April64.8May71.7June71.3July72.8Assume that the initial forecast for February is 65.0 (in $ thousands) and the initial trend adjustment is 0. The smoothing constants selected are α = 0.10 and ß = 0.2. Using trend-adjusted exponential smoothing, the forecast for the architectural firm's Augustincome = thousand dollars (round your response to two decimal places).(thousand dollars)² (round your response to two decimal places).

There are various methods of forecasting. One of the methods is the trend-adjusted exponential…

Answered: Assume that the initial forecast for…

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

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
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month Gershe collected the data shown in the following table 17 on 18 ne solve this Calculator Ask my instructor ! 1 Q This exercise contains only parts b, c, and d. b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y=0+0x F1 @ 2 W F2 #3 C 80 F3 $ 54 4 888 F4 do 5 % Maroon 5 TV Appearances Demand for Guitars 14 FO A 6 MacBook Air F6 & 1 7 8: F7 00 * 8 358 57 7 368 4 9 6 DII FB ( 9 DD F9 ) 0 O A F10 Clear all ? C F11 + 11 = Check answer F12 delete
The following gives the number of accidents that occurred on Florida State Highway 101 during the last 4 months: Month Jan Number of Accidents 25 Feb 48 Mar 64 Apr 100 Using the least-squares regression method, the trend equation for forecasting is (round your responses to two decimal places): y = -1 + 24.10 x Using least-squares regression, the forecast for the number of accidents that will occur in the month of May response as a whole number). = accidents (enter your
a) Apply moving average and exponential smoothing to generate two forecasts of the closing price for the entire data period. Set appropriate values for the forecast parameters (e.g., k and a). b) Plot and compare the actual and predicted data values you calculated in part (b). Provide one chart that displays actual, moving average, and exponential smoothing lines. Hint: Calculate MSE, MAD, or MAPE to compare the different forecasts. Develop your own forecast from scratch. Do NOT use Excel’s Data Analysis or Forecast Sheets.
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?
Consider the following from an estate agent’s business nationally: Month Houses Sold Jan 380 Feb 360 Mar 390 Apr 400 May 390 June 380 July 394 Aug 454 Sep 460 Oct 460 Nov 430 Dec 370 Calculate the three point moving averages (quarters) and seasonal variation for the above data Define moving averages and how they’re useful in forecasting (use Harvard referencing) At races, your horse, White Rum, has a probability of 1/20 of coming 1st, 1/10 of coming 2nd and a probability of ¼ in coming 3rd. First place pays $5,000 to the winner, second place $4,000 and third place $1,350. Hence, is it worth entering the race if it costs $1050? Your company plans to invest in a particular project. There is a 40% chance you will lose $3,000, a 45% chance you will break even, and a 15% chance you will make $5,500.…
The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 21 20 15 12 15 16 15 17 19 21 20 24 Using a method of trend projection, the forecast for the next month (Jan) = ______ sales (round your response to two decimal places).
i need this to study stop canceling my questions A check-processing center uses exponential smooth- ing to forecast the number of incoming checks each month. The number of checks received in June was 40 million, while the fore- cast was 42 million. A smoothing constant of .2 is used. a) What is the forecast for July?b) If the center received 45 million checks in July, what would be the forecast for August?c) Why might this be an inappropriate forecasting method for the situation
eBook Problem 6-05 Consider the following time series data. 3 16 Week 1 Week 2 Value 18 13 a. Choose the correct time series plot (1) € (!!!) Time Series Value Time Series Value 28642986420 284H2G86420 1 4 11 2 {B} 2 TH 3 Week (t) Week (t) 5 6 € (iv) Time Series Value Time Series Value 28642 NO 28642 NO 1 2 2 4 3₁ Week (t) Week (t) 5 6
Please view the attached image and answer part a
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.
The manager of a large manufacturer of industrial pumps must choose between two alternative forecasting techniques. Both techniques have been used to prepare forecasts for a six month period. Using MAD as a criterion, which technique has the better performance record? Month Demand Technique1 Technique 2 1 492 488 495 2 470 484 482 3 485 480 478 4 493 490 488 5 498 497 492 6 492 493 493

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