Electricity Consumption Report

Prepared By: Zahiruddin Zahidanishah

Introduction

This report reports shows the electricity consumption and amount payable for a typical double storey house in urban city located in Selangor, Malaysia. This report consists of data from year 2014 to date. This report will shows the relation between the consumption and payment for the electricity usage every month and every year.

The details of the house inventory and areas are as describe belows.

Assets Details
  Items Description
0 Type Double Storey Terrace House
1 Land Area (sq.m) 121
2 Build Up Area (sq.m) 180
3 Bedrooms 4
4 Bathrooms 3
5 Lighting Pts. 22
6 Power Pts. 14
7 Fan Pts. 4
8 AC Pts. 3
Summary of Annual Electricity Consumption
Year Total Usage (kWh) Total Amount (RM) Electricity Rate (RM/kWh) Ave. Usage (kWh) Ave. Amount (RM) Ave. Usage/P (kWh/p) Ave. Usage/A (kWh/m2) Max. Usage (kWh) Max. Amount (RM)
2014 3645 964 0.26 303 80 60 1 350 102
2015 3569 899 0.25 297 74 59 1 405 103
2016 4498 1365 0.30 374 113 74 2 530 188
2017 4719 1491 0.32 393 124 78 2 448 153
2018 4640 1439 0.31 386 119 77 2 490 175
2019 4249 1278 0.30 354 106 70 1 444 151
2020 5080 1240 0.24 423 103 84 2 1221 164
2021 4596 1326 0.29 383 110 76 2 444 136
2022 1826 524 0.29 365 104 30 0 460 152
Monthly Electricity Usage (kWh)
Months 2014 2015 2016 2017 2018 2019 2020 2021 2022
January 261 254 246 427 342 370 355 322 359
February 288 347 399 390 455 444 314 378 323
Mac 348 276 530 448 426 399 350 378 384
April 263 309 465 441 419 373 350 361 460
May 350 301 494 361 490 413 350 357 300
June 324 273 342 393 315 285 1221 393 nan
July 346 405 305 339 357 366 368 361 nan
August 268 238 409 383 412 280 344 436 nan
September 292 295 336 399 389 348 360 396 nan
October 267 266 378 406 358 336 336 444 nan
November 301 321 286 405 368 323 391 404 nan
December 337 284 308 327 309 312 341 366 nan
Monthly Electricity Cost (RM)
Months 2014 2015 2016 2017 2018 2019 2020 2021 2022
January 63.98 61.64 58.96 142.53 98.67 113.12 107.05 79.55 102.00
February 70.56 86.90 120.01 123.44 149.20 151.30 85.55 111.55 83.85
Mac 101.77 68.98 188.20 153.37 142.02 130.15 104.45 111.55 114.60
April 64.64 81.64 162.14 149.76 138.40 116.50 96.35 103.00 152.91
May 102.80 77.52 177.10 108.48 175.04 137.45 88.80 100.95 71.00
June 89.38 67.98 98.67 124.99 78.88 72.00 164.40 119.15 nan
July 100.74 103.84 79.58 91.97 106.41 112.85 112.10 103.00 nan
August 66.31 56.29 125.46 119.83 134.79 70.30 99.70 122.28 nan
September 74.33 75.33 87.80 122.93 115.14 103.40 107.96 108.60 nan
October 65.98 65.64 117.25 131.70 106.93 97.10 82.55 136.60 nan
November 77.52 81.69 72.32 131.18 112.09 90.30 107.05 124.65 nan
December 86.34 71.66 78.16 90.93 81.64 84.50 84.80 105.50 nan
Monthly Electricity Rates (RM/kWh)
Months 2014 2015 2016 2017 2018 2019 2020 2021 2022
January 0.25 0.24 0.24 0.33 0.29 0.31 0.30 0.25 0.28
February 0.24 0.25 0.30 0.32 0.33 0.34 0.27 0.30 0.26
Mac 0.29 0.25 0.36 0.34 0.33 0.33 0.30 0.30 0.30
April 0.25 0.26 0.35 0.34 0.33 0.31 0.28 0.29 0.33
May 0.29 0.26 0.36 0.30 0.36 0.33 0.25 0.28 0.24
June 0.28 0.25 0.29 0.32 0.25 0.25 0.13 0.30 nan
July 0.29 0.26 0.26 0.27 0.30 0.31 0.30 0.29 nan
August 0.25 0.24 0.31 0.31 0.33 0.25 0.29 0.28 nan
September 0.25 0.26 0.26 0.31 0.30 0.30 0.30 0.27 nan
October 0.25 0.25 0.31 0.32 0.30 0.29 0.25 0.31 nan
November 0.26 0.25 0.25 0.32 0.30 0.28 0.27 0.31 nan
December 0.26 0.25 0.25 0.28 0.26 0.27 0.25 0.29 nan

Note:

  1. This report is prepared by Zahiruddin Zahidanishah. This report is only for educational purposed and shall not be used for any commercial purposed.
  2. This report is prepared using open source application such as Jupyter Notebook, Python, Plotly, Pandas and etc.