F
franztupaz
Guest
Dear Everyone,
I am a newbie in the excel and basically has close to "0" knowledge except for basic functions, but have seen the benefit of having a working sheets/templates which cuts work time in half.
If I may kindly request for your assistance as I am working on a 2011 forecast and I am stuck and cannot move on, please see below parameters and likewise the attached excel sheet as an example.
Conditions:
Base Number - by branch 2010 monthly sales
Growth Factors - grow 2010 Monthly Sales by branch
"GDP"=+4% growth
"Same"=+6% growth
"New"=+10% growth
If monthly 2010 sales is greater than 200,000, then just add growth factors as 2011 monthly forecast
If monthly forecast is less than 200,000 base number should be average 2010 sales + growth factors
If monthly forecast is greater than 150% of average 2010 sales, then forecast should take average 2010 sales as its forecast + growth factors.
Round final numbers
Please refer to the attached under "Tarlac" row, but please note that this was computed manually and without any "nested formula".
Hope someone helps me.
Thank you.
best regards,
Francis
I am a newbie in the excel and basically has close to "0" knowledge except for basic functions, but have seen the benefit of having a working sheets/templates which cuts work time in half.
If I may kindly request for your assistance as I am working on a 2011 forecast and I am stuck and cannot move on, please see below parameters and likewise the attached excel sheet as an example.
Conditions:
Base Number - by branch 2010 monthly sales
Growth Factors - grow 2010 Monthly Sales by branch
"GDP"=+4% growth
"Same"=+6% growth
"New"=+10% growth
If monthly 2010 sales is greater than 200,000, then just add growth factors as 2011 monthly forecast
If monthly forecast is less than 200,000 base number should be average 2010 sales + growth factors
If monthly forecast is greater than 150% of average 2010 sales, then forecast should take average 2010 sales as its forecast + growth factors.
Round final numbers
Please refer to the attached under "Tarlac" row, but please note that this was computed manually and without any "nested formula".
Hope someone helps me.
Thank you.
best regards,
Francis