Blog > Case Studies > DEMAND PLANNING – Pharmaceutical Industry
By 13/07/2020 Case Studies

DEMAND PLANNING – Pharmaceutical Industry

The Indian pharmaceuticals market is the 3rd largest in terms of volume and 13th largest in terms of value, as per a report by equity master. India is the largest provider of generic drugs globally with the Indian generics accounting for 20 per cent of global exports in terms of volume

According to India Ratings, a Fitch company, the Indian pharmaceutical industry is estimated to grow at 20% CAGR over the next five years. Presently the market size of the pharmaceutical industry in India stands at US$ 20 billion. The client, being a large listed Indian pharmaceutical company with revenues
exceeding US$ 2 billion, wanted to move from legacy practice of arbitrary estimation using excel sheets, to a scientific basis for Demand Planning &Forecasting(DP&F).

Business Need

  • Prior toIBM Cognos TM1 implementation, DP&F was done for only 20% (~300) of total SKUs, at a National-level, basis immediately preceding 3 months’ sales salience.This process delivered a forecast accuracy of ~73%.
  • Multiple hierarchies existent in client’s sales structure in the form of Area, Territory, CFA, Region, Division meant having to choose 1 level of forecasting that gives best results.
  • The outlook to be provided to the supply chain was arbitrarily based on DemandPlanner’s vision, with few inputs from Sales Managers &Division Heads. This was a time-consuming affair that took up to 3 weeks for data collation and coordination.
  • No involvement of Regional Sales Managers (RSMs) in demand planning process, despite being resources in direct contact with customers/stockists and possessing ground-level intelligence of events.
  • Redundancy of multiple years’ historical data available in SAP as Demand Planning Team(DPT) exerted dependency on merely 3 months’ historical data.
  • Number of future months to be considered for forecasting.

THE SOLUTION

  • IBM Cognos TM1 combined with IBM SPSS Statistics was suggested as the best replacement to the legacy system. With established success of connectivity with SAP BW, data integration wasn’t much of a task.
  • 5 years’ gross sales data (normal sales + free schemes) was suggested as most relevant measure to perform statistical forecasting as it reflects actual sales including schemes and does not factor in returns.
  • RSMs (Regional Sales Managers) were selected as appropriate-level for intelligence input due to considerations:
    • Best resource having ground-level intelligence.
    • Minimal impact on daily work.
    • Less complexity involved in tool rollout.
  • A Pareto Analysis was done of all active products to exercise greater forecasting focus on those medicines with high sales salience and low coefficient of demand variation.
  • The sales structure being dynamic, the sales hierarchies were designed so as to be recreated on any updates in SAP masters for every monthly forecast cycle.
  • Uploading of 5 years’ historical data was designed in a manner so as to upload 1 month’s data at a time, which optimized bandwidth restrictions on client network and avoided process failure due to network drop.
  • Considering supply chain lead time for different sourcing channels and also the fact that near-term forecasts are more reliable, it was suggested that forecasting be carried out for 18 future months with main emphasis on and consensus for mainly 4 future months.

THE BENIFITS

  • DP&F cycle time drastically reduced from 1-2 weeks to barely ~3 hours.
  • Increase in forecast accuracy from ~71-73 % at a National-level for 20% of total SUs, to ~83% forecast accuracy for 100% SKUs, up to 1CFA-Region combination-level for horizon of 4 future months.
  • Historical Data imported into IBM Cognos TM1with 100% accuracy means one version of truth, resulting in reduced dependency by DPT for generating data via SAP tables.
  • Ridding arbitrary forecasting by DPT (earlier excel based) by ensuring there is a scientific base for demand planning. Also, availability of audit trail for values before and after outlier correction by Demand Planner through forecast file archiving.
  • Process reengineering instead of process improvement by introducing a 2FPM system in place of legacy systems which were largely excel dependent.
  • DPT empowered with enhanced capability to forecast in a drastically reduced period of time.
  • Control Center for carrying out forecast conveniently designed to enable user to complete forecast on merely clicking step-by-step 7 action buttons.
  • One single platform for enabling collaboration of a consensus forecast with involvement of a broader base of stakeholders.
  • Removal of possibility of arbitrary demand planning as per DPTs best understanding thus demolishing any case of instability in demand planning process in case of attrition within the team.
128 thoughts on “DEMAND PLANNING – Pharmaceutical Industry”

  1. Hi, i think that i saw you visited my website so i came to “return the favor”.I’m trying to find things to
    enhance my website!I suppose its ok to use a few of your ideas!!

    Reply
  2. Reply
  3. Reply
  4. Reply
  5. Reply
  6. Reply
  7. Reply
  8. Reply
  9. Reply
  10. Reply
  11. Reply

  12. I know this if off topic but I’m looking into starting my own blog and was curious
    what all is needed to get set up? I’m assuming having
    a blog like yours would cost a pretty penny? I’m not
    very internet smart so I’m not 100% positive.
    Any tips or advice would be greatly appreciated. Appreciate it

    Look into my blog … slot mega888

    Reply
  13. Reply
  14. Reply

  15. Thanks for a marvelous posting! I certainly enjoyed reading
    it, you could be a great author.I will make sure to bookmark
    your blog and definitely will come back from now on. I want to encourage you to ultimately continue your great posts, have a
    nice weekend!

    Also visit my web page: ace333 agent

    Reply

  16. Hi there, I enjoy reading through your article post.
    I like to write a little comment to support you.

    My site … rollex11 test id [Terri]

    Reply
  17. Reply
  18. Reply

  19. Spot on with this write-up, I seriously
    feel this site needs a lot more attention. I’ll probably be returning to read through
    more, thanks for the advice!

    My site … download sky777 ios (918kiss-m.com)

    Reply
  20. Reply

  21. I savour, lead to I found just what I was looking for. You’ve ended my 4
    day long hunt! God Bless you man. Have a nice day.
    Bye

    my web blog – xe88 game apk (Dannielle)

    Reply
  22. Reply
  23. Reply
  24. Reply

  25. Thanks so much for giving me personally an update on this matter on your site.
    Please realize that if a fresh post appears or if any modifications occur with the
    current article, I would be interested in reading a lot more and understanding
    how to make good use of those tactics you share. Thanks for your efforts and consideration of other people by making this blog available.

    Here is my blog post … http://www.biemmeitalia.net

    Reply

  26. Can I simply just say what a relief to find somebody who genuinely
    knows what they are talking about over the internet.
    You definitely understand how to bring a problem to light and make it important.

    More people should check this out and understand this side
    of your story. I was surprised that you are not more popular since you most certainly have the gift.

    Reply
  27. Reply
  28. Reply
  29. Reply
  30. Reply
  31. Reply
  32. Reply

  33. Tremendous issues here. I am very satisfied to peer your post.
    Thanks so much and I’m looking forward to contact you.
    Will you please drop me a e-mail?

    Reply
  34. Reply

  35. hello!,I love your writing so so much! share we communicate more approximately your
    article on AOL? I require a specialist in this area to resolve my problem.
    May be that’s you! Having a look forward to look you.

    Reply
  36. Reply
  37. Reply
  38. Reply

  39. Howԁy! I could have swon I’ve been to this ѕite befoгe but
    after cһecking tthroᥙցh some of the pоsxt I realized it’s new too me.
    Anyhow, I’m definiteⅼy hɑppy I found it andd I’ll
    be bookmarking annd checking back often!

    Reply
  40. Reply
  41. Reply
  42. Reply

  43. Needed to write you the little bit of note to finally give thanks once again for these exceptional principles
    you’ve contributed in this case. It’s really pretty open-handed
    with people like you to give freely all that numerous people could have distributed for an e-book to
    earn some profit for themselves, especially considering that you might have done it if you desired.
    Those good ideas additionally worked like a easy way to know that someone
    else have the same passion like mine to learn a good
    deal more in terms of this matter. I’m certain there are millions of more pleasurable periods in the future for individuals
    who look over your website.

    Look into my blog post; Primary Calm CBD (showhorsegallery.com)

    Reply

  44. I leave a response whenever I appreciate a article on a website
    or if I have something to add to the conversation. Usually it’s triggered by
    the fire communicated in the article I browsed. And after this article DEMAND PLANNING – Pharmaceutical Industry –
    Blog. I was excited enough to drop a thought 😉 I actually do have 2 questions
    for you if you usually do not mind. Is it just me or do some of these
    responses look like written by brain dead individuals?
    😛 And, if you are posting at other sites,
    I’d like to follow you. Could you list the complete urls of your community pages like your Facebook page,
    twitter feed, or linkedin profile?

    Feel free to surf to my homepage; CreekSide CBD
    Reviews (http://www.interleads.net)

    Reply
  45. Reply

  46. Saya telah telah berselancar 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 lebih berguna dari sebelumnya.

    Here is my web blog: Tembak ikan deposit dana

    Reply

  47. Admiring the dedication you put into your blog
    and detailed information you provide. It’s good to come across a blog every once
    in a while that isn’t the same outdated rehashed material.

    Wonderful read! I’ve bookmarked your site and I’m adding your RSS feeds
    to my Google account.

    Also visit my site – forum.yawfle.com

    Reply
  48. Reply
  49. Reply

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

    It is cukup berharga bagi saya. Secara pribadi , jika semua
    pemilik situs dan blogger membuat konten yang baik seperti yang Anda lakukan, web akan menjadi lebih berguna dari
    sebelumnya.

    Here is my site … Joker123 Apk 2021

    Reply
  51. Reply
  52. Reply
  53. Reply
  54. Reply

  55. It’s гealⅼy a cooⅼ and helpful piece of information. I am satisfied that you sharеd this useful
    info with us. Please stay us informed like this. Thanks for sharing.

    Feel free to surf to my blog – missing person

    Reply
  56. Reply
  57. Reply

  58. Hey there, You’ve performed an incredible job.
    I will definitely digg it and for my part recommend to my friends.

    I’m confident they will be benefited from this web site.

    Have a look at my webpage … Joyce

    Reply

  59. Ηi would you mind stating which blog platform уou’re worкing with?
    I’m going to start mmy oown blog in the near future buսt I’m having a tօugһ time choosing befween BlogEngine/Wordpress/B2evolutіon and
    Drupal. The reason I aɑsk is because your design and tyle ssemѕ different then most blogs and Ι’m looking for something unique.
    P.S Apologies for getting off-topic but I haad to ask!

    Reply
  60. Reply

  61. Hi there, I found your blog by the use of Google at the same time as looking for a similar matter, your web site got here up, it appears great.
    I have bookmarked it in my google bookmarks.[X-N-E-W-L-I-N-S-P-I-N-X]Hello there, simply became aware
    of your weblog via Google, and located that it’s truly informative.
    I’m going to watch out for brussels. I will appreciate when you proceed this in future.
    Numerous folks will be benefited out of your writing. Cheers!

    Feel free to visit my web-site catamarancentral.com

    Reply
  62. Reply
  63. Reply
  64. Reply
  65. Reply

  66. Ӏ don’t knoᴡ if it’s just mе or if perhaps everyboⅾy else
    encountering issues with your blog. It appears
    as if some of the written txt within your content are running off
    thee screen. Cɑn some᧐ne else please provide feedback ɑnd lеet me know if this is
    haρpenijg to them ɑs well? This may be a probloem ԝith mу internet browser because I’vе hhad this happen beforｅ.

    Тhank you

    Reply
  67. Reply
  68. Reply

  69. Hi there! Quick question that’s entirely off topic.
    Do you know how to make your site mobile friendly?
    My website looks weird when viewing from my iphone4.
    I’m trying to find a template or plugin that might be able to
    fix this issue. If you have any suggestions, please share.
    With thanks!

    my homepage – Trim Fuel Keto Pills – web.jmjh.tn.edu.tw,

    Reply

  70. Hi! Quick question that’s entirely off topic.
    Do you know how to make your site mobile friendly? My
    website looks weird when browsing from my iphone.

    I’m trying to find a theme or plugin that might be able
    to correct this problem. If you have any suggestions, please share.

    Cheers!

    My blog Pure Remedy CBD Reviews [khoquet.com]

    Reply
  71. Reply

  72. I do consider all of the ideas you have introduced
    for your post. They are really convincing and will definitely work.
    Still, the posts are very short for beginners.
    May just you please extend them a little from next time?
    Thank you for the post.

    Review my site … Full Essentials CBD Review (appdev.163.ca)

    Reply

  73. Hey there are using WordPress for your blog platform?
    I’m new to the blog world but I’m trying to get started and create my own. Do you require any
    html coding knowledge to make your own blog? Any help would be greatly appreciated!

    Feel free to visit my web site: Maxx Pump Review – Sibyl,

    Reply

  74. May I simply say what a relief to uncover somebody
    that really understands what they are discussing over the internet.
    You actually realize how to bring an issue to light and make it important.
    More and more people need to check this out and understand this side of your
    story. I was surprised you’re not more popular given that you certainly possess
    the gift.

    Feel free to visit my blog post Primary Calm CBD – http://www.articledude.com –

    Reply
  75. Reply
  76. Reply
  77. Reply

  78. Hmm it looks like your website ate my first comment (it was extremely long) so I guess I’ll just
    sum it up what I wrote and say, I’m thoroughly enjoying your blog.

    I too am an aspiring blog writer but I’m still new to
    the whole thing. Do you have any tips for newbie blog writers?
    I’d definitely appreciate it.

    Look into my web-site :: VigoRage Male Enhancement Reviews [duna-anapa.net.ru]

    Reply

  79. I have been exploring for a little bit for any
    high-quality articles or weblog posts on this sort of area .

    Exploring in Yahoo I ultimately stumbled upon this site.
    Reading this information So i’m happy to express that I have an incredibly just right uncanny feeling I discovered just what
    I needed. I most unquestionably will make sure to do not forget this web site and provides it a look
    regularly.

    Feel free to surf to my web site … VigoRage (science-marketplace.org)

    Reply

  80. It is perfect time to make some plans for the future
    and it’s time to be happy. I have learn this publish
    and if I may just I desire to recommend you few interesting issues
    or suggestions. Maybe you could write next articles referring to this article.

    I want to learn more things about it!

    My blog post :: Primary Calm CBD Review (http://www.funkyfreeads.com)

    Reply
  81. Reply

  82. We wish to thank you once more for the stunning ideas you offered
    Jesse when preparing her own post-graduate
    research in addition to, most importantly, with regard to
    providing all of the ideas in a blog post. Provided we had known of your web page
    a year ago, we might have been saved the unnecessary measures we were participating in. Thank you very much.

    Also visit my blog :: Healix CBD Oil Reviews
    (http://www.consulenzaleonardo.com)

    Reply
  83. Reply
  84. Reply
  85. Reply
  86. Reply

  87. Right here is the perfect web site for anybody who wishes to find out about this topic.
    You understand so much its almost hard to argue with you (not that
    I personally will need to?HaHa). You certainly put a brand new spin on a topic that’s been written about for many years.
    Excellent stuff, just wonderful!

    Here is my blog … VigoRage, chubbychannel.com,

    Reply
  88. Reply
  89. Reply

  90. I am extremely impressed with your writing skills as well as with
    the layout on your blog. Is this a paid theme or did you modify
    it yourself? Anyway keep up the excellent quality writing,
    it’s rare to see a great blog like this one these days.

    Also visit my blog post … Pure Remedy CBD Side Effects (http://www.fles.hlc.edu.tw)

    Reply
  91. Reply

  92. I rarely leave remarks, but I browsed a few of the comments on this page DEMAND PLANNING
    – Pharmaceutical Industry – Blog. I do
    have 2 questions for you if it’s okay. Could it be only me or does it give the impression like some of these remarks appear as if they are left by
    brain dead individuals? 😛 And, if you are writing on other online social sites, I’d like to keep
    up with you. Would you make a list of all of all your social networking sites like your
    Facebook page, twitter feed, or linkedin profile?

    Feel free to surf to my webpage; http://www.mental-health.sbm.pw

    Reply

  93. I’d been honored to get a call from a friend immediately he observed the important points shared
    on your own site. Reading through your blog article is a real
    brilliant experience. Thank you for considering readers
    much like me, and I would like for you the best of achievements like a professional in this field.

    Feel free to surf to my web-site :: Keto Ultra Complete Pills (http://www.fotosombra.com.br)

    Reply

  94. I’ve been absent for a while, but now I remember why I used to love this
    site. Thanks, I will try and check back more often. How frequently you update your
    website?

    Look into my web-site … Viagenix Male Enhancement Pills, xajm168.com,

    Reply

  95. Hi to all, how is everything, I think every one is getting more from this site, and your views are good in favor of new people.

    Here is my web blog :: Sophria Cream (Minnie)

    Reply

  96. I am curious to find out what blog system you’re working
    with? I’m having some small security issues with my latest website and I’d
    like to find something more risk-free. Do you have any suggestions?

    Visit my web blog Healix CBD Review (showhorsegallery.com)

    Reply
  97. Reply

  98. I liked up to you’ll receive performed proper here.

    The sketch is tasteful, your authored subject matter stylish.
    however, you command get bought an nervousness over that you
    want be delivering the following. in poor health indubitably come further until now once more as exactly the similar nearly very often inside case you defend this increase.

    Here is my homepage Sophria Anti Aging Cream (211.159.150.117)

    Reply
  99. Reply
  100. Reply
  101. Reply

  102. I enjoy you because of your own efforts on this blog.
    My mom delights in participating in investigation and it is easy to understand why.
    We hear all regarding the compelling ways you deliver useful guides via the blog and
    as well as invigorate participation from website visitors on the subject matter then our own princess is always learning a
    great deal. Take advantage of the remaining portion of the
    new year. You’re doing a wonderful job.

    Here is my blog: Primary Calm CBD Oil (shaboxes.com)

    Reply
  103. Reply

  104. Hey there! I could have sworn I’ve been to this site before but after reading through some of the
    post I realized it’s new to me. Anyways, I’m definitely
    delighted I found it and I’ll be bookmarking and checking back frequently!

    My homepage: Creek Side CBD – consulenzaleonardo.com –

    Reply

  105. You really make it seem so easy along with your presentation however
    I to find this matter to be really one thing which I believe I’d by no means understand.
    It seems too complex and extremely wide for me.
    I’m having a look ahead in your next put up, I will attempt to get the cling of it!

    My webpage; VigoRage Male Enhancement (shihan.com.ru)

    Reply

  106. If some one desires to be updated with newest technologies after that he must be pay a visit this
    website and be up to date all the time.

    Feel free to visit my webpage :: Sleek Slim Keto Reviews, asias128.com,

    Reply
  107. Reply
  108. Reply
  109. Reply

  110. Hey! I know this is kinda off topic but I was wondering
    which blog platform are you using for this site? I’m getting fed up of WordPress because I’ve had
    problems with hackers and I’m looking at alternatives for another platform.
    I would be great if you could point me in the direction of
    a good platform.

    my web page: Sleek Slim Keto Pills Review (kannikar.com)

    Reply
  111. Reply

  112. Hey terrific blog! Does running a blog such as
    this require a massive amount work? I’ve absolutely no
    understanding of coding however I had been hoping to start my own blog
    in the near future. Anyway, if you have any recommendations or techniques for new blog owners please share.
    I know this is off topic but I just needed to ask. Kudos!

    my web page: Sophria Anti Aging Cream Reviews; Evonne,

    Reply
  113. Reply
  114. Reply

  115. I know this if off topic but I’m looking into starting my
    own weblog and was curious what all is required to get set up?
    I’m assuming having a blog like yours would cost a pretty penny?
    I’m not very internet smart so I’m not 100% certain. Any recommendations or advice would be greatly appreciated.
    Thank you

    Feel free to visit my page :: 154.8.233.237

    Reply
  116. Reply

  117. Hey, you used to write great, but the last several posts have been kinda boring…

    I miss your great writings. Past few posts are just a
    little out of track! come on!

    Feel free to surf to my blog – cs.yyqyt.com

    Reply

  118. Hi there would you mind stating which blog platform you’re working with?

    I’m looking to start my own blog soon but I’m having a difficult time
    making a decision between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your design seems different then most blogs and I’m looking
    for something completely unique. P.S Sorry for getting
    off-topic but I had to ask!

    My webpage … Eagle Hemp CBD Gummies (Trista)

    Reply

  119. Ahaa, its pleasant discussion regarding this paragraph at this place at this web site,
    I have read all that, so at this time me also commenting here.

    Look into my blog post: Trim Fuel Keto Advanced Formula – slboos.com –

    Reply

  120. Its like you read my mind! You seem to know so much about
    this, like you wrote the book in it or something.
    I think that you could do with a few pics to drive
    the message home a bit, but instead of that, this is magnificent blog.
    A fantastic read. I will certainly be back.

    Feel free to visit my web page: atomy123.cn

    Reply
  121. Reply

  122. I love your blog.. very nice colors & theme.
    Did you design this website yourself or did you hire someone to do it
    for you? Plz respond as I’m looking to create my own blog and would
    like to find out where u got this from. thanks

    Feel free to visit my page: Wade

    Reply

  123. Needed to post you that very little observation just to thank you very much again over the exceptional basics you have provided
    at this time. This has been quite wonderfully open-handed of
    people like you to present unreservedly just what some
    people might have advertised for an e book to help
    make some dough on their own, even more so since you could
    possibly have tried it if you ever decided. Those smart ideas also served to become great way to be certain that other people have the same eagerness the same as my personal own to figure out significantly more on the topic of this problem.

    Certainly there are several more pleasurable sessions in the future for folks
    who take a look at your blog.

    Feel free to visit my website :: Sophria Anti Aging Cream Price (154.8.233.237)

    Reply

  124. If some one wishes to be updated with hottest technologies then he must be pay a
    visit this web page and be up to date every day.

    Reply

  125. Howdy! This blog post could not be written much better!
    Reading through this article reminds me of my previous roommate!
    He continually kept talking about this. I am going to send this article to him.
    Fairly certain he’ll have a very good read. Thanks for sharing!

    Check out my website: Breeze Tech

    Reply
  126. Reply

  127. Greetings! This is my first visit to your blog!
    We are a group of volunteers and starting a new project in a community
    in the same niche. Your blog provided us valuable
    information to work on. You have done a outstanding job!

    Reply

  128. Greetings from Ohio! I’m bored to tears at work so I decided to browse
    your blog on my iphone during lunch break. I really like
    the information you present here and can’t wait to take a look when I get
    home. I’m surprised at how fast your blog loaded on my mobile ..
    I’m not even using WIFI, just 3G .. Anyways, fantastic blog!

    Feel free to visit my web site – mpc-install.com

    Reply
Leave a Comment