Momofthree
New Member
- Joined
- Nov 2, 2008
- Messages
- 13
I need help with a formula for a billing rate.
The rate varies based on the type of customer. The rate is $3, $2, $1.50 per thousand gallons of water used. Customers are COM-$3, NPROFIT-$2, GOV-$1.50. I am not sure which formula to use. Also, since I need to figure it per thousand and I have a gal. usage of 108,300 it is confusing. Thank you.
The rate varies based on the type of customer. The rate is $3, $2, $1.50 per thousand gallons of water used. Customers are COM-$3, NPROFIT-$2, GOV-$1.50. I am not sure which formula to use. Also, since I need to figure it per thousand and I have a gal. usage of 108,300 it is confusing. Thank you.