• Enhancing Visitor Experience at ISKCON Using Text Analytics

    Janarthanan Balasubramanian, Division Head, Information Technology and online Communications at ISKCON wanted to understand the visitor feedback so that appropriate measures can be taken to improve the visitor experience at ISKCON. The primary problem at hand for Janarthanan was to reduce the existing manual effort for his team. Currently three resources are involved in collecting the reviews from social platforms and labeling each review into one of the four classes, viz. positive, negative, neutral and mixed. Two other resources convert the reviews from paper feedback forms/feedback registers placed at different points inside the temple, to an Excel file. The team begins its day by manually collecting, labeling and collating the reviews in an Excel file. At the end of the day, these labelled reviews would be stored in the database. At the end of the week, the total count of reviews for the four classes, viz. positive, negative, neutral and mixed was calculated to understand the overall sentiment. This was an extremely time-consuming manual process from data collection, that is, manually copy pasting the comments from social mediums to data collation and labeling. Janarthanan wanted his team to spend time and effort on analyzing the data and working on remedial actions. He wanted to understand the issues/topics that ISKCON should work on, rather than manually classify reviews and get the count of each review type. Janarthanan felt that getting only the split of positive/negative/neutral/mixed classes is not enough to draw inferences.
    詳細資料
  • Demand Forecasting for Perishable Short Shelf Life Home Made Food at iD Fresh Food

    iD Fresh Food (India) Private Ltd., is a leading ready-to-cook and eat packaged food company serving several cities in India. The company is known for its popular product, Idly-Dosa batter that it sells through retail outlets. iD started with packaging Idly-Dosa batter and has since diversified into Malabar Parota, Wheat Parota, Chapati, and Chutneys. In 2017, iD Fresh was a 1000+ member team with seven factory locations and eight offices - two plants in Bengaluru, one each in Chennai, Mumbai, Hyderabad, Mangalore, and Dubai. They manufactured more than 50,000 kg of Idli-Dosa batter per day which is equivalent to a million idlis. The company produced and sold nearly 15 ready-to-eat packaged food products and their flagship products include Idli-Dosa batter, Mini Parota, Malabar Parota, Whole Wheat Parota, Whole Wheat Chapati, and Whole Wheat Junior Parota. iD Fresh Food was in expansion phase and adding several outlets to its distribution network. Since all the products sold by iD Fresh Foods had short shelf life, anywhere between 4 and 7 days, forecasting demand accurately is important. iD would like to be in a state where there will be a greater degree of predictability in its operations. Ideally, they would like to know how much of each SKU should be loaded into each vehicle for the following day when a salesman starts his beat journey. The forecast for each store, based on past performance of each store in each beat, should be fairly accurate. This would then enable a macro-view of the business operations over a month and consequently help in production planning and operations for the future.
    詳細資料
  • Demand Forecasting for Perishable Short Shelf Life Home Made Food at iD Fresh Food, Spreadsheet Supplement

    Spreadsheet supplement to case IMB653.
    詳細資料