Water Consumption Report

Prepared By: Zahiruddin Zahidanishah

Introduction¶

This report reports shows the water 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 water 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
9 Water Taps 7
Summary of Annual Water Supply Usage and Cost
Year Total Usage (m3) Total Cost (RM) Water Rate (RM/m3) Average Usage (m3) Average Cost (RM) Max. Usage (m3) Max. Cost (RM)
2019 77 44 0.57 6 3 13 7
2020 219 129 0.59 18 10 27 18
2021 341 203 0.60 28 16 35 21
2022 121 21 0.17 24 4 27 7
Monthly Water Usage (m3)
Months 2019 2020 2021 2022
January 5 8 28 24
February 5 8 27 22
Mac 5 8 26 27
April 5 9 26 27
May 5 20 28 21
June 5 21 30 nan
July 5 24 25 nan
August 13 26 27 nan
September 6 24 27 nan
October 8 24 35 nan
November 10 20 32 nan
December 9 27 30 nan
Monthly Water Cost (RM)
Months 2019 2020 2021 2022
January 2.60 0.00 19.65 4.12
February 2.60 0.00 18.60 2.06
Mac 2.60 6.00 17.60 7.20
April 2.60 6.00 17.60 7.20
May 2.60 11.40 19.65 1.05
June 2.60 12.45 21.70 nan
July 2.60 15.50 16.55 nan
August 7.41 17.60 18.60 nan
September 3.42 15.50 18.61 nan
October 4.56 15.50 15.45 nan
November 5.70 11.40 12.36 nan
December 5.13 18.60 7.55 nan
Monthly Water Rates (RM/m3)
Months 2019 2020 2021 2022
January 0.57 0.00 0.70 0.17
February 0.57 0.00 0.69 0.09
Mac 0.57 0.75 0.68 0.27
April 0.57 0.67 0.68 0.27
May 0.57 0.57 0.70 0.05
June 0.57 0.59 0.72 nan
July 0.57 0.65 0.66 nan
August 0.57 0.68 0.69 nan
September 0.57 0.65 0.69 nan
October 0.57 0.65 0.44 nan
November 0.57 0.57 0.39 nan
December 0.57 0.69 0.25 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.