![]() |
Calculate Target
Not sure I'm doing this right and need confirmation, please. Looking to find
a target to reduce a metric by a % for 2009 using 2007 and 2008 data. Example: Production tonnage 2007=400,000, and production tonnage 2008=425,000; water tonnage consumed during production for 2007=200,000 tons, and 2008=210,000. Then percent of production tonnage vs tons of water used for 2007 was .5 and for 2008 was .494. SO is it correct that the reduction of the percentage for prod vs water consumption from 2007 vs 2008 is 1.176%.???? Thanks so much for confirming/correcting this for me! |
Calculate Target
In my view ...
Reduction in percentage of Water consumed per Production Tonnage = 0.006 Percentage reduction in Water consumed per Production Tonnage = 1.2% In other words your target for 2009 should by 0.488 Tons of water per Production Ton. Hope this makes sense. "Jani" wrote: Not sure I'm doing this right and need confirmation, please. Looking to find a target to reduce a metric by a % for 2009 using 2007 and 2008 data. Example: Production tonnage 2007=400,000, and production tonnage 2008=425,000; water tonnage consumed during production for 2007=200,000 tons, and 2008=210,000. Then percent of production tonnage vs tons of water used for 2007 was .5 and for 2008 was .494. SO is it correct that the reduction of the percentage for prod vs water consumption from 2007 vs 2008 is 1.176%.???? Thanks so much for confirming/correcting this for me! |
Calculate Target
Sheelo - never mind my request for figuring the 0.488 - I got it (duh).
"Sheeloo" wrote: In my view ... Reduction in percentage of Water consumed per Production Tonnage = 0.006 Percentage reduction in Water consumed per Production Tonnage = 1.2% In other words your target for 2009 should by 0.488 Tons of water per Production Ton. Hope this makes sense. "Jani" wrote: Not sure I'm doing this right and need confirmation, please. Looking to find a target to reduce a metric by a % for 2009 using 2007 and 2008 data. Example: Production tonnage 2007=400,000, and production tonnage 2008=425,000; water tonnage consumed during production for 2007=200,000 tons, and 2008=210,000. Then percent of production tonnage vs tons of water used for 2007 was .5 and for 2008 was .494. SO is it correct that the reduction of the percentage for prod vs water consumption from 2007 vs 2008 is 1.176%.???? Thanks so much for confirming/correcting this for me! |
All times are GMT +1. The time now is 05:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com