In: Accounting
n a new resort city at Kuantan, Malaysia, the present population is 1000 and daily per capita water demand (normal demand) is 150 liter (including household, gardening, car washing, etc.). But there is a deficit of water by 10% of the demand. As an Executive Engineer of the City Corporation, you are going to submit a water-supply project to the higher authority. For that purpose, you will perform economic analysis of different supply options for the projected demand. You are planning the project for 20 yrs projection. Expected average population increase (growth rate) during this period is 2% per annum, and the increase in per capita water-demand due to change in income is expected to 10% (during 20 yrs period, not annually). Determine the design capacity of the water-supply project.
A | B | C | D | E | F | G |
Year | Year wise Consumption | Year wise accumulation of Population | Year wise accumulation of demand | |||
(FxG) | (Fx1.02) Every year | (Gx1.005) Every year | ||||
1 | 1000 | 135 | 365 | 49275000 | 1000 | 49275 |
2 | 50511802.5 | 1020 | 49521.375 | |||
3 | 51779648.74 | 1040.4 | 49768.98188 | |||
4 | 53079317.93 | 1061.208 | 50017.82678 | |||
5 | 54411608.81 | 1082.43216 | 50267.91592 | |||
6 | 55777340.19 | 1104.080803 | 50519.2555 | |||
7 | 57177351.43 | 1126.162419 | 50771.85178 | |||
8 | 58612502.95 | 1148.685668 | 51025.71103 | |||
9 | 60083676.77 | 1171.659381 | 51280.83959 | |||
10 | 61591777.06 | 1195.092569 | 51537.24379 | |||
11 | 63137730.66 | 1218.99442 | 51794.93001 | |||
12 | 64722487.7 | 1243.374308 | 52053.90466 | |||
13 | 66347022.14 | 1268.241795 | 52314.17418 | |||
14 | 68012332.4 | 1293.60663 | 52575.74505 | |||
15 | 69719441.94 | 1319.478763 | 52838.62378 | |||
16 | 71469399.93 | 1345.868338 | 53102.81689 | |||
17 | 73263281.87 | 1372.785705 | 53368.33098 | |||
18 | 75102190.25 | 1400.241419 | 53635.17263 | |||
19 | 76987255.22 | 1428.246248 | 53903.3485 | |||
20 | 78919635.33 | 1456.811173 | 54172.86524 | |||
Total Consumption for 20years | 1,25,99,80,803.82 |