Apps Outlook free pers... Access Manager Inbox (2,457) - bish... Facebook A1 Paraphrasing To.. Mail - 1478625 ema ill Your Amazon.com APPLICATION CASE 1.2 A DSS for Managing Inventory at GlaxoSmithKline GlaxoSmithKline (G.SK) is a global pharmaceutical company The company sells products in hundreds Of product categoriesprescription clrvs, over-the- counter medicines, oral health care products, nutri- tional health drinks, among others, In this highly wanted to evaluate its inventory policies and devel- op a new policy, if necessary GSK collects all of its sales and demand infor- mation through Lhe supply chain planning system, From this system, it extracted the historical forecast and demand, month-end inventory, p10duction lot size, and lead time information. GSK developed a model that takes these inputs and estimates the safety stock (measured in weeks forward carryover IWFC], which is the number Of weeks of estimated demand capacity). The model can determine how changes in the safety stock affect lhe cust01ner service level. competitive retail market, it is important [o have enough product quantity on hand to provide a high service level LO customers. but excess inventory COStS money, so developing an Optimal inventory policy is essential in achieving a decent profit. GSK The entire model was built using a spread- sheet tool (Microsoft Excel) Excel-based DSS enables the company to evaluate many what-If situ- ations. Because of Che stochastic nature of demand for many products, the model includes a simulation feature, which allows the company to analyze the impact of uncertainty in demand on the optimal safety stock level. Managers have found the DSS to be very helpful in making inventory decisions. source L Shang, P R. Tadikmalla, L. L L Is "A for Managing a: GlaxoSmithKline." NO, l. 113. 1) Describe how a DSS (Decision Support System) helped GSK (5 marks) 2) Assume you were a Bl consultant. Suggest a BPM (Business Performance Management) methodology for GSK and explain why it is a suitable methodology and how you are going to implement it in GSK. (15 marks) Time left 1:01 u are NOT required to include any diagram for answering this question