Skip to content
Competition - Supply Chain Analytics
Supply Chain Analytics in Tableau or Power BI
🧾 Executive summary
There is a declining trend in Gross Profit since August 2017.
Problems statement:
○ A long leadtime may cause the order decrease, although the punctuality rate is improved in the last month.
○ For Same Day orders, 3.6 days to deliver successfully is not competitive with other competitors (benchmark: TP90 = 3.6 days)
○ Stock planning should be improved, especially for top products with excessive stock units
Sale Decrease Rootcause Analysis
There is a positive correlation between the order quantity and number of ontime shipment, it means that if the company wants to improve the sales records, it is important that they focus on improving the ontime shipment.
Web camera section is the main cause of sale decrease.