Here is a real-world math problem that I am trying to find a solution. It's kind of similar to Real life water bill problem (want to check myself), but with some additional stuffs.
We have 8 apartments in our community and we want to find out the water usage cost for each apartment and for each person.
Example:
- Total Apartments : 8
- Total Cost : 10000 INR
Simplest approach would be to divide total cost with total apartments. But the cost should be proportionate to number of people living in the apartment. More the people, more the water consumption and hence more money to be paid.
I feel it gets more complex when guests stay in an apartment as they should be also charged for water consumption.
| Apartment # | Persons and Total Days |
|---|---|
| 1 | 2 persons for 26 days, 1 guest for 5 days |
| 2 | 4 persons for 31 days, 1 guest for 10 days, 3 persons for 5 days |
| 3 | 3 persons for 31 days |
| 4 | 0 persons for 31 days |
| 5 | 1 persons for 9 days |
| 6 | 3 persons for 31 days |
| 7 | 2 persons for 31 days |
| 8 | 3 persons for 31 days |
Hope I have made my problem clear. What kind of easy-to-use mathematical solution can be used for such problem?