PLANNING AND FORCASTING SOLHUTIONS – Retail Organisation

OVERVIEW

The name of the Retail group is synonymous with the growth of Middle-East as an economic super power. With more than 1800 stores spanning across 10 different political geographies is considered to be a behemoth in retail in any measuring stick. They also have the distinction of being spread Indian Sub-continent, Africa and Middle East.

The Group provides a value driven product range for the entire family through a diverse portfolio of core retail brands including a host of home grown brands.

Though enormous in scope, the physical, logistical and organizational dimensions of managing the everyday growing store network across Middle Eastern countries was a big task in its own terms.

Increase in number of stores was definitely reflecting on the increased number of promotional activities- especially when it was done on primarily a store based manner and then regional manner. The large chunk of man hours wasted in planning and realizing the sales activities and achieving its defined target was something that the top management couldn’t ignore to be noticed.

BUSINESS NEEDS

  • The Organization was managing the Planning/Budgeting process using Excel (Manual), it used to take 5 months to complete financial, statutory &management reporting in a financial cycle.
  • Processes were person dependent with no visibility & no collaboration with planning and budgeting. – In turn affected the communication considering the size of the chain.
  • The Profitability was calculated on a store-wise basis, which accounts to 1800.
  • The Budgeting was mainly looked in by the Territory Heads and the Concepts (a combination of different stores based on demographical requirements) were managed by the Regional Heads. SO the gap in budget meeting the in ground needs were too far from close.
  • Planning of events and promotional activities were always on a store level.
  • Promotional activity with all the human resources and materials included, used to take 15 days in the planning and execution level. T Planning and Forecasting Solutions for a Retail Organisation
  •  Due to such practices and processes, they had the following limitations:
    • Data Uniformity was not achieved due to geographical and operational diversity.
    • Consolidation of budget and business plans were an area of concern due to geographical and currency variations.
    • Transfer of budget files between Territories and Concepts was a manual process, which was taking time.
    • Lack of Sensitivity analysis.
    • Top Down/ Bottom Up approach is not possible in Excel, which was being used for the same.
    • Daily phasing of Sales was manual process, again time consuming, mainly due to the currency variations.
    • Overwriting of estimates with actual was taking more than required man hours.
    • Multi-currency environment was contributing to the time consumption in all the processes.

THE SOLUTION

The well placed solution for all the chaos into the running of such a large group was obviously the IBM tools. The Capable and efficient corporate planning solution from IBM was the choice of the retailer for bringing the much needed efficiency in planning the entire sales cycles and other related activities into the organizational culture.

 IBM provides organizations with a performance management solution that enables a line of sight to improve outcomes. IBM solutions for financial and operational performance management enhances organizations’ capability to perform key processes, such as planning, budgeting and forecasting. IBM solution to the challenges described here supports the execution of performance in an integrated, collaborative, connected, concerted manner in order to impact change and get better results.

Cognos TM1

The Immediate benefits were visible as all the areas with concerns were covered promptly by the IBM Cognos TM1. They were:

  • Data uniformity is established due to single phase of interaction.
  • Data security is observed.
  • Data Consolidation process is simplified throughout the 1800 stores.
  • Planning and Budgeting concerns in lines of currency, multiple touch-points, geographies, occasions were addressed by developing patterns which could be replicated in considerable number of regions.

THE BENEFITS

Transparency of Data is established for required number of users.

• Budgeting concerns were addressed.

• Based on the forecasting through the historical data mining Planning of sales and promotional activities have been accelerated to few hours to on the go from 15 day cycle.

• Currency is converted to the standard currency on a daily basis for better functionality.

• All the processes- which were being done on a manual level have been automated.

• The over writing of estimates with the actual have been reduced considerably due to better prediction with the time consumed being the minimum.

76 thoughts on “PLANNING AND FORCASTING SOLHUTIONS – Retail Organisation”
  1. Sweet blog! I found it while surfing around on Yahoo News.
    Do you have any tips on how to get listed in Yahoo News?

    I’ve been trying for a while but I never seem to get there!
    Thanks

    My page – pussy888

  2. Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically tweet my
    newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some
    experience with something like this. Please let me know if you run into anything.
    I truly enjoy reading your blog and I look forward to your new updates.

    Also visit my web site test Ntc33

  3. Hello my loved one! I wish to say that this post is amazing, great written and
    come with approximately all vital infos. I would like
    to look more posts like this .

    Also visit my web blog pusy888

  4. Hi there! I know this is kinda off topic however I’d figured I’d
    ask. Would you be interested in exchanging links or maybe
    guest writing a blog article or vice-versa? My website addresses a lot of the same topics
    as yours and I think we could greatly benefit from each other.
    If you might be interested feel free to shoot
    me an e-mail. I look forward to hearing from you! Wonderful
    blog by the way!

    Feel free to visit my blog post … Ace333 demo id

  5. of course like your website but you need to test the spelling on quite a few of your posts.
    A number of them are rife with spelling issues and I in finding it very bothersome to tell the
    truth on the other hand I’ll surely come again again.

    Here is my homepage lpe88 test

  6. First of all I want to say awesome blog! I had a quick question which I’d like to
    ask if you do not mind. I was interested to know how you center yourself and
    clear your mind prior to writing. I’ve had difficulty clearing my
    thoughts in getting my ideas out there. I do take pleasure
    in writing however it just seems like the first 10
    to 15 minutes tend to be wasted simply just trying
    to figure out how to begin. Any suggestions or hints?

    Thanks!

    Feel free to surf to my webpage 3win8 original

  7. It’s actually a great and useful piece of info. I’m glad that you shared this useful information with
    us. Please stay us up to date like this. Thanks for sharing.

    Review my page; aaa1188 android download (918kiss-m.com)

  8. Its such as you learn my mind! You seem to understand so much
    approximately this, such as you wrote the ebook in it
    or something. I think that you simply could do with a few % to pressure the message house
    a little bit, however other than that, that is excellent blog.
    A fantastic read. I’ll definitely be back.

    Feel free to surf to my web blog: download calibet

  9. Saya telah menjelajah online lebih dari 2 jam hari ini, namun saya tidak pernah menemukan artikel menarik seperti
    milik Anda. It’s cukup berharga bagi saya. Secara pribadi ,
    jika semua pemilik situs dan blogger membuat konten yang baik seperti yang
    Anda lakukan, internet akan menjadi a jauh lebih
    berguna dari sebelumnya.

    Feel free to surf to my website: Ratu Joker123

  10. excellent publish, very informative. I’m wondering why the opposite experts of this sector don’t realize this.

    You should continue your writing. I am sure, you’ve a great readers’ base already!

  11. It’s really a cool and helpful piece of info.
    I am glad that you just shared this helpful info with us.
    Please keep us informed like this. Thanks for sharing.

  12. An impressive share! I’ve just forwarded this onto a
    coworker who was conducting a little homework on this.
    And he actually bought me dinner because I found it for him…
    lol. So allow me to reword this…. Thank
    YOU for the meal!! But yeah, thanks for spending some time
    to talk about this topic here on your internet site.

  13. An outstanding share! I’ve just forwarded this onto a co-worker who was doing
    a little homework on this. And he actually bought me dinner simply because I discovered it for him…
    lol. So let me reword this…. Thank YOU for the meal!!
    But yeah, thanx for spending the time to talk about this
    topic here on your site.

    Feel free to surf to my webpage :: game sky777

  14. Wow, amazing blog layout! How long have you been blogging for?
    you made blogging look easy. The overall look of your web site is magnificent, let alone the content!

    Here is my homepage playboy2 android download (918kiss-m.com)

  15. Attractive section of content. I just stumbled upon your site and in accession capital to assert that I acquire actually enjoyed account your blog posts.
    Anyway I’ll be subscribing to your augment and
    even I achievement you access consistently rapidly.

    Check out my web blog – bbs.tanwanly.com

  16. You made some decent points there. I did a search on the subject and found most guys will agree with your website.

    Feel free to visit my web blog: Samara

  17. Right here is the perfect site for anybody who wants to understand this topic.
    You realize so much its almost tough to argue with
    you (not that I personally would want to?HaHa).
    You definitely put a new spin on a topic that has been discussed for ages.
    Wonderful stuff, just excellent!

    Also visit my webpage – http://www.myzoo.it

  18. Hi to every body, it’s my first pay a quick visit of this
    web site; this website includes amazing and really excellent material for visitors.

    Feel free to visit my webpage … Selene

  19. Saya telah telah menjelajah online lebih
    dari 3 jam hari ini, namun saya tidak pernah menemukan artikel menarik seperti milik Anda.
    It is cukup berharga bagi saya. Menurut pendapat saya , jika semua
    pemilik situs dan blogger membuat konten yang baik
    seperti yang Anda lakukan, web akan menjadi lebih berguna dari sebelumnya.

    Feel free to surf to my web blog … joker123 deposit pulsa 10rb

  20. After I originally left a comment I appear to have clicked the -Notify me
    when new comments are added- checkbox and now every time a
    comment is added I receive 4 emails with the exact same comment.
    There has to be a way you are able to remove me from that service?

    Thank you!

  21. Great article and straight to the point. I am not sure if this is actually the best place to ask
    but do you folks have any thoughts on where to get some professional writers?
    Thanks 🙂

    Also visit my web site – 39.104.22.11

  22. Excellent post. I was checking continuously this blog and I am impressed!
    Very helpful info particularly the last part 🙂 I care for such information a
    lot. I was seeking this certain information for a very long time.
    Thank you and good luck.

    Also visit my homepage :: kebe.top

  23. I was recommended this blog by my cousin. I am not sure whether this post is written by him as nobody else know such detailed about my difficulty.
    You’re amazing! Thanks!

    My web blog: cpapan.com

  24. This design is wicked! You certainly know how to keep
    a reader amused. Between your wit and your videos, I was
    almost moved to start my own blog (well, almost…HaHa!)
    Excellent job. I really enjoyed what you had to say, and more than that,
    how you presented it. Too cool!

    Check out my web-site http://www.qiurom.com

  25. I carry on listening to the news bulletin talk about getting boundless online grant applications so I have been looking around for the finest site to get one.
    Could you tell me please, where could i get
    some?

    my web page … 19wujian.com

  26. Whoah this blog is magnificent i love studying your articles.
    Stay up the great paintings! You already know, a lot of people are hunting around for this info, you could aid them greatly.

    My blog post: kebe.top

  27. You can certainly see your skills within the paintings you write.
    The arena hopes for more passionate writers such as you
    who aren’t afraid to say how they believe. Always go after your heart.

    Review my blog post 19wujian.com

  28. Great blog right here! Additionally your web site quite a bit up very fast!
    What host are you the use of? Can I am getting your associate
    hyperlink on your host? I desire my site loaded up as
    quickly as yours lol.

    Feel free to visit my page; 39.100.90.4

  29. Saya telah telah menjelajah online lebih dari 2
    jam hari ini, namun saya tidak pernah menemukan artikel menarik seperti milik Anda.

    It’s cukup berharga bagi saya. Dalam pandangan saya, jika semua
    pemilik situs web dan blogger membuat konten yang baik
    seperti yang Anda lakukan, internet akan menjadi a jauh lebih berguna dari sebelumnya.

    My web-site; Joker123 tanpa potongan

  30. Saya telah telah menjelajah online lebih dari 2 jam hari ini, namun saya tidak pernah menemukan artikel menarik seperti milik Anda.
    It’s cukup berharga bagi saya. Dalam pandangan saya, jika semua pemilik situs dan blogger membuat
    konten yang baik seperti yang Anda lakukan, internet akan menjadi a jauh lebih berguna dari sebelumnya.

    My site; Joker123 casino hack, gameaco.com,

  31. Hi there, i read your blog from time to time and i own a similar one
    and i was just wondering if you get a lot of spam feedback?
    If so how do you reduce it, any plugin or anything you can advise?
    I get so much lately it’s driving me insane so any help
    is very much appreciated.

  32. I definitely wanted to make a quick comment to express gratitude to you for all of the
    fantastic tips you are showing at this website.

    My time intensive internet research has at
    the end been paid with reasonable details to write
    about with my co-workers. I would suppose that many of us website visitors are really blessed
    to live in a really good network with many wonderful individuals with insightful hints.

    I feel quite lucky to have discovered your entire webpage and look
    forward to plenty of more thrilling times reading here.
    Thank you once more for a lot of things.

    Have a look at my blog post – atomy123.cn

  33. Thanks for every other great article. Where else
    may anyone get that type of information in such
    a perfect approach of writing? I have a presentation subsequent week, and I’m on the look for such info.

  34. I was just searching for this info for some time. After six hours of continuous Googleing, finally I got it in your
    web site. I wonder what’s the lack of Google strategy that don’t rank
    this kind of informative websites in top of the list.
    Usually the top sites are full of garbage.

    Take a look at my web page: cs.yyqyt.com

  35. What’s Going down i’m new to this, I stumbled upon this
    I’ve discovered It absolutely helpful and it has helped me out loads.
    I am hoping to give a contribution & aid different customers like its helped me.
    Good job.

    Stop by my blog post; 211.159.150.117

  36. That is a good tip particularly to those new to the blogosphere.
    Short but very accurate info? Thank you for sharing this one.
    A must read post!

    Also visit my web blog … grazebo.com

  37. Admiring the commitment you put into your site and detailed information you present.
    It’s great to come across a blog every once in a while that isn’t
    the same old rehashed information. Excellent read! I’ve bookmarked your site
    and I’m including your RSS feeds to my Google account.

    Stop by my blog post; tanhua666.com

  38. I loved as much as you will receive carried out right here.
    The sketch is attractive, your authored subject matter stylish.

    nonetheless, you command get got an edginess over that you wish
    be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly
    a lot often inside case you shield this increase.

    Here is my blog http://www.zgyssyw.com

  39. Thank you for the good writeup. It in fact was a amusement account it.
    Look advanced to more added agreeable from you! However, how could
    we communicate?

    Here is my page :: kebe.top

  40. Hi, Neat post. There is a problem along with your web site in internet
    explorer, could check this? IE nonetheless is the market leader and a
    large element of other people will omit your great writing because of this problem.

    My web site … kebe.top

  41. Aw, this was an extremely good post. Finding the time and actual effort to produce
    a top notch article? but what can I say? I put things off a lot and never manage to
    get anything done.

    my website – clubriders.men

  42. Good day! I just wish to give you a big thumbs up for the great information you’ve got
    right here on this post. I will be coming back to your website for more soon.

  43. It’s remarkable to pay a quick visit this web page and reading the views of all mates on the
    topic of this post, while I am also zealous of getting know-how.

    Also visit my blog post: aniene.net

  44. You actually make it appear so easy along with your presentation but I to find this matter to be actually one thing which I think I’d
    never understand. It sort of feels too complex and extremely wide
    for me. I’m taking a look ahead in your next submit,
    I will try to get the grasp of it!

    my web-site Super Shot Keto Reviews (http://www.fles.hlc.edu.tw)

  45. My spouse and i still can’t quite think that I
    could be one of those reading the important recommendations found on your blog.
    My family and I are sincerely thankful for your generosity and for providing me
    the potential to pursue my personal chosen profession path.
    Appreciate your sharing the important information I managed to get from your web page.

    My homepage: http://www.mufun.online

Leave a Comment