The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of power loads for the next year. The power loads are seasonal, and the data on the quarterly loads in megawatts (MW) for the last four years are as follows: Quarter 1 2 3 4 Year 1 100.4 127.7 140.3 167.6 Year 2 98.2 117.9 142.4 153.4 Year 3 123.8 151.3 164.7 179.9 Year 4 100.4 130.2 149.6 169.0 The manager estimates the total demand for the next year at 685 MW. Use the multiplicative seasonal method to develop the forecast for each quarter. (Round all intermediate calculations to three decimal places.) The first quarter forecast is MW. (Enter your response rounded to one decimal place.)

Contemporary Marketing
18th Edition
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Louis E. Boone, David L. Kurtz
Chapter14: Pricing Strategies
Section14.2: Forecasting Demand
Problem 1LO
icon
Related questions
Question

please find the 1-4 quarters

K
The manager of a utility company in the Texas panhandle wants to
develop quarterly forecasts of power loads for the next year. The
power loads are seasonal, and the data on the quarterly loads in
megawatts (MW) for the last four years are as follows:
Quarter
1
234
2
3
4
Year 1
100.4
127.7
140.3
167.6
Year 2
98.2
117.9
142.4
153.4
Year 3
123.8
151.3
164.7
179.9
Year 4
100.4
130.2
149.6
169.0
The manager estimates the total demand for the next year at 685 MW.
Use the multiplicative seasonal method to develop the forecast for
each quarter. (Round all intermediate calculations to three
decimal places.)
The first quarter forecast is MW. (Enter your response rounded to
one decimal place.)
Transcribed Image Text:K The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of power loads for the next year. The power loads are seasonal, and the data on the quarterly loads in megawatts (MW) for the last four years are as follows: Quarter 1 234 2 3 4 Year 1 100.4 127.7 140.3 167.6 Year 2 98.2 117.9 142.4 153.4 Year 3 123.8 151.3 164.7 179.9 Year 4 100.4 130.2 149.6 169.0 The manager estimates the total demand for the next year at 685 MW. Use the multiplicative seasonal method to develop the forecast for each quarter. (Round all intermediate calculations to three decimal places.) The first quarter forecast is MW. (Enter your response rounded to one decimal place.)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 12 images

Blurred answer
Recommended textbooks for you
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning