10:19 8 O all all 25 THIRD UNIT ACTIVITY_-1231... Q SAINT PAUL SCHOOL MANRECO of PROFESSIONAL STUDIES Full Name: Program & Section Code: DIRECTIONS: Prepare a case analysis on the business case provided below using the prescribed format. Use a separate word document for the case analysis. You can use the sample case analysis for your guidance. DEMAND FORECASTING Mr. Ali has recently joined a fast paced growing pharmaceutical company as a "Demand Planner" for broad range of products, He is responsible for making consolidated demand forecast on monthly basis for an organization that used to have a separate demand-planner for each product-line using his own tools and techniques. In his previous employment, he was considered a person with strong analytical skills in demand forecasting, he looked after several beverage product lines, planning about their future demands. His formula for demand forecasting proved to be a success as it produced close-to accurate results. He also has a very supportive tea working under his supervision that used to maintain the data in state-of-the-art demand forecasting software. The software was capable of handling a large variety of SKUs on the basis of customized forecasting formula set by the demand planner. Mr. Ali, through the software, was able to forecast demand and supply needs for beverages with a single customized formula, as the company was dealing in cold beverage only. In his new position in Perfect Pharmacy, he feels overwhelmed by the complexity and variation found in the industry. There are primarily four types of product lines to forecast for: 1/3 . Product having stable demand ad consistent in trends - general on-the-counter medicines :E O Mobile view Word count Display Projection Edit directory10:20 ZL '65 .I .II a -' IVII . HII, ll ll Uuyll ll It: SUI lel U, Wdti dUIU lU IUI Cudl UUII ldl IL] and supply needs for beverages with a single customized formula, as the company was dealing in cold beverage only. In his new position in Perfect Pharmacy, he feels overwhelmed by the complexity and variation found in the industry. There are primarily four types of product lines to forecast for: 0 Product having stable demand ad consistent in trends general on~thecounter medicines 0 Products showing seasonal shifting and variation - like cough syrup, etc. 0 Products that are for specific needs and emergency cases, Mr. Ali has only one week to develop a forecast for all product ranges of the company. Being the demand-planner, he has called an urgent meeting to determine the single basis of forecasting for all the product lines. As the meeting commenced, Mr. Ali has a very clear agenda in his mind "Decision on the basis of forecasting". He was sure all product-planners would agree on simplicity and this would also bring efficiency in the system while removing extra workload from the product-planners. He put forward a simple question, to start with, before his product-planners would discuss on how they would forecast their product lines. It was an open forum, so each product planner shared his views and argued in its favour. Meeting went on and the team had a heated discussion and lot of idea sharing. Each product planner presented before the demand-planner sound rationale for his own formula. He started noting down all the suggested formulae on a piece of paper. Till the half time, Mr. Ali was even more confused than before. He quickly adjourned the meeting and moved back to his office. As he approached his desk he saw a car in front of him that he did not notice before. This was your visiting card; you closely worked with him in his last organization as a supply chain consultant. You happened to be an expert in demand-planning. In desperation to meet his deadline, he picked up your visiting card and called you to help him come out of the dilemma he was facing. You agreed to help him find out the best mechanism for the demand planning in an organization with such a wide variety of product line