Supply Chain Analytics in Power BI - Just in Time
🧾 Executive summary
After thorough analysis of the supply chain, essential information about the company's stock and shipment of goods was revealed.
📦 Stock
As of October 2017, there was a drop in revenue, which worsened in subsequent months, as well as a reduction in stock, which may indicate possible difficulties in meeting demand due to stock outs.
It should be noted that all products classified as Curve A, which represent 80% of revenue, are at critical levels or out of stock, in addition to increasing. This situation is worrying, since we do not have products available to meet the demand.
A more detailed analysis revealed that the Apparel, Fanshop and Footwear departments were the most affected by this situation.
🚚 Shipments
In the period from 2015 to 2017, the average delivery time for our orders was 25 days. However, over this period, there has been a notable evolution for both US warehouse orders and orders from the Puerto Rico warehouse. At the beginning, in January 2015, the average delivery time was 67 days, but by December 2023, this time frame was reduced to just 3 days, representing an impressive 96% drop in delivery time.
When analyzing in more detail, we still identified opportunities to improve our performance, especially with regard to the delivery of first and second class categories, which have above average late rates. To overcome this challenge, we considered the possibility of renegotiating deadlines with our delivery partners and establishing Service Level Agreements (SLA's) to ensure greater punctuality.
Otherwise, it is also feasible to extend the promised delivery period in cases where the delivery window is very tight, in order to ensure a more reliable service and within the expected deadlines.