View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Kits Kits is offline
external usenet poster
 
Posts: 1
Default Need urgent help with target figures

I hope you can help me with the following task below. I am struggling with
the second part of the question but i will be happy for assistance on both. A
quick reposnse will be appreciated !! Thank you.

Question
Your manager wants to know which areas are currently achieving the target
and what the year end position may be, given there is only one month of the
year left.

Information Provided

Area A B C D E
Current month (February) 5 8 30 21 22
Year to date (Apr-Feb) 2007/08 95 95 401 238 187
Year to date (Apr-Feb) 2006/07 91 120 429 264 209
Progress on prev yr 4.4% -20.8% -6.5% -9.8% -10.5%
Target 2007/08
(-10% on previous yr) 86 116.1 421 259 207

Actual year end 2006/07 96 129 468 288 230