Question: Need answer correctly dont use excel only hand written calculation The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts

Need answer correctly dont use excel only hand written calculation
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 Year 1 100.4 129.3 149.2 168.3 Year 2 90.5 112.9 143.3 156.2 Year 3 122.5 150.2 169.1 Year 4 105.6 133.7 147.1 169.0 4 175.1 The manager estimates the total demand for the next year at 697 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.)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
