Question: Ontario Power Generation has been collecting data on demand for electric power in its western subregion for only the past two years. Those data are

Ontario Power Generation has been collecting data on demand for electric power in its western subregion for only the past two years. Those data are shown in the table below.

Demand in Megawatts Last Year Month This Year 17 January 5 February 14 March 10 20 April 13 23 May 18 30 June 15 July 23


To plan for expansion and to arrange to borrow power from neighbouring utilities during peak periods, the utility needs to be able to forecast demand for each month next year. However, the standard forecasting models discussed in this chapter will not fit the data observed for the two years.
a) What are the weaknesses of standard forecasting techniques as applied to this set of data?
b) Because known models are not appropriate here, propose your own approach to forecasting. Although there is no perfect solution to tackling data such as these (in other words, there are no 100% right or wrong answers), justify your model.
c) Forecast demand for each month next year using the model you propose.

Demand in Megawatts Last Year Month This Year 17 January 5 February 14 March 10 20 April 13 23 May 18 30 June 15 July 23 August 26 41 September 21 33 October 15 23 November 12 26 December 14 17

Step by Step Solution

3.56 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a This problem gives students a chance to tackle a realistic problem in business ie not enough data ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1496_60b74122521c9_647498.pdf

180 KBs PDF File

Word file Icon

1496_60b74122521c9_647498.docx

120 KBs Word File

Students Have Also Explored These Related Operations Management Questions!