17. The manager of a utility company in the Texas panhandle wants to develop quarterlyforecasts of power loads for the next year. The power loads are seasonal, and the data onthe quarterly loads in megawatts (MW) for the past 4 years are as follows:Quarter123Year 1103.5126.1144.5166.1Year 294.7116.0137.1152.5Year 3118.6141.2159.0178.2The manager estimates the total demand for the next year at 600 MW. Use themultiplicative seasonal method to develop the forecast for each quarter.Year 4109.3131.6149.5169.0

Firstly Average Demand per year: Quarter Year 1 Year 2 Year 3 Year 4 1 103.5 94.7 118.6 109.3…

Answered: 17. The manager of a utility company in…

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

1. Discuss the differences between Qualitative and Quantitative forecasting models. How do Associative and Time Series techniques differ? 2. What is the Mean Absolute Deviation (MAD)? 3. Use the following set of data to calculate the Mean Absolute Deviation (MAD) for the following set of data. Actual (A:) Forecast (Ft) Forecast Error Absolute (Deviation) Month Forecast Eror January February March 45 45 42 50 34 45 April 48 40 Мay 38 45 MAD =
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
The monthly sales (in units) for a refrigerator in April 2021 through September 2021 were as follows: 42, 56, 49, 41, 56, 59 What is the forecasted sales in August 2021 if you use exponential smoothing with a smoothing constant 0.31? Assume the forecast in April 2021 was 44 units. Use at least 4 decimals.
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.
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 director of the Riley County, Kansas, library systemwould like to forecast evening patron usage for next week.Below are the data for the past 4 weeks: a) Calculate a seasonal index for each day of the week.b) If the trend equation for this problem is y = 201. 74 + .18x,what is the forecast for each day of week 5? Round your forecastto the nearest whole number.
Please consider the following information and make forecasts for January, February, March, and April of Year 2. Use second-order polynomial regression to make forecasts. Adjusted seasonal index Actual sales Deseasonalized sales 836 825 Year 1 Year 2 January February March April May June July August September October November December January February March April 0.72 0.75 1:22 1.48 1 1.23 0.7 0.78 0.92 1.13 1.28 1.33 0.72 0.75 1.22 1.48 1220 1319 1020 1184 685 641 875 1008 1068 1141
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May June July August September October Actual Demand 105 82 110 112 108 106 130 120 Forecast Demand 100 108 97 98 108 102 105 107 November December For the given forecast, the tracking signal = MADS (round your response 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)
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
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)
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.

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