Complex budget for energy costs

Reference no: EM13990566

The management of an office complex in central Johannesburg wants to understand the pattern of energy consumption (i.e. energy costs related to heating and air- conditioning) in the complex. They have assembled quarterly data on energy costs for the past three years (in R100 000s).

Year	Quarter
Year	Summer	Autumn	Winter	Spring
2009	2.4	3.8	4.0	3.1
2010	2.6	4.1	4.1	3.2
2011	2.6	4.5	4.3	3.3

(a) Plot the pattern of energy costs graphically.

(b) Calculate seasonal indexes for the complex's energy costs by the ratio-to- moving-average method.

(d) How much should the financial manager of this office complex budget for energy costs for each quarter of 2012, based on seasonally adjusted trend estimates?

(e) Plot the pattern of energy costs graphically using Excel's Insert > Chart > Line.

(f) Re-compute the least squares trendline for energy usage in (b) using the Line graph and Add Trendline option in Excel.

Reference no: EM13990566

Questions Cloud

What rate will the water escape : Water flows at a rate of 50 mL/s through an opening at the bottom of the of a tank in which the water is 4 m deep. At what rate will the water escape if additional pressure of 50 kPa is applied to the top of the water?

Give an explanation which theory : Give an explanation which theory is better about why Giza pyramid was built?

Creating an internal position for work : Claims volume has recently jumped, resulting in the hiring of more Claims Representatives. You, as the Human Resource Manager, feel that a new position of Claims Supervisor is needed in order to manage the expanding claims operation.

What is the angular velocity of the object : The rigid object shown is rotated about an axis perpendicular to the paper and through point P. The total kinetic energy of the object as it rotates is equal to 1.4 j. If M = 1.3 kg and L = 0.50 m. Neglect the mass of the connecting rods and treat..

Complex budget for energy costs : How much should the financial manager of this office complex budget for energy costs for each quarter of 2012, based on seasonally adjusted trend estimates?

Give an explanation which theory : Give an explanation which theory is better about why Giza pyramid was built?

Find the constant on integration : The constant of integration can be founds if you know one point on the curve. For the following problem, find the constant of integration. Find the constant on integration, C if

User Account

All Pages