3 question 
This is the problem 
A pharmaceutical company is experiencing supply chain disruptions due to delays in the sourcing of raw materials from its suppliers. As the supply chain manager, propose a solution to mitigate the impact of such disruptions and ensure timely delivery of finished products to customers
Date set
https://docs.google.com/spreadsheets/u/0/d/1oBdpm2t8a60qlHHbsPw7RROjgQhMJVDk/htmlview
Clearly state the problem and the significance of solving it in the context of supply chain management.
Use at least three techniques learned in the course to analyze the problem and propose a solution. Explain the rationale behind the choice of techniques and show the calculations involved.
This is demand planning using statatistics techniques 
Time series analysis 
Correlation analysis 
Pareto analysis 
Transportation cost analysis
Operational efficiency analysis
Demand forecasting and inventory optimization