Question
The management of an office complex in central Johannesburg wants to understand the pattern of energy consumption ie energy costs related to heating and airconditioning in the complex. They have assembled quarterly data on energy costs for the past three years.
tableYearSeasonSummerAutumn,Winter,Spring
Page of
Plot the pattern of energy costs graphically. Comment.
Calculate seasonal indexes for the complex's energy costs and interpret the seasonal impact.
Find the least squares trendline for energy usage in this office complex.
How much should the financial manager of this office complex budget for energy costs for each quarter of based on seasonally adjusted trend estimates?
