Complex budget for energy costs

Reference no: EM13990564

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: EM13990564

Questions Cloud

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

Manufactures and distributes farming equipment : The marketing manager of a company that manufactures and distributes farming equipment (such as combine harvesters, ploughs and tractors) recorded the number of farming units sold quarterly for the period 2008 to 2011.

Olduwan industry : What is some evidence for hunting as the dominant component of early hominid economies? Please tell me about the Australopithecine - Homo transition of c. 3 to 1 million years ago

User Account

All Pages