🧾 Executive summary
-
In Year 2015 to 2017, Just In Time has generated a total of 222 million dollars sales revenue and making 143 million dollars in profit. USA is ranked 1st in sales and Africa region has the highest median Customer Life Time Value. The top selling product in most countries is Field and Stream Sportsman 16 Gun Fire Safe which garnered over $41 millions sales revenue. Since Africa customers are giving us more sales in the long run, we should maintain their customer satisfaction by shortening the shipment delays. For example, Perfect Fitness Perfect Rip Deck (Strength Training Category) and Diamondback Women's Serene Classic Comfort Bicycle (Cardio Equipment) are top selling products but their demands in recent fourth quarter has decreased significantly and its shipment delays has increased.
-
Since the start of Year 2015, the timeliness of shipment had been improving and order quantity was at a stable level. However in the recent fourth quarter of Year 2017, the shipment delays had started to increase and the level of orders had dropped significantly. There were peaks in order quantity for different regions in different months. For example, Africa had huge number of orders between September to December 2016, Europe (June - October 2015 & July - September 2017), Latin America (January 2015 & February - May 2017), North America (April - July 2016), and Pacific Asia (November 2015 - March 2016 & September - December 2016). We can investigate what are the past events happening in these periods that trigger a surge in orders so that we can stock up the inventory to accomodate for the high number of orders in the future.
-
The average inventory cost per month for all products was $219.30. This inventory cost can be reduced by not re-stocking less-demanded products too often. 4 out of 11 understock product categories required more than the average fulfillment days of 6.25 to refill the inventory but this has little impact on the gross sales revenue as the combine sales revenue of these 4 categories is only 0.23% of the total sales revenue.
-
Generally, all the products have high profit margin ranging from 32% to 83%. Product categories such as Men's Clothing and Strength Training have over 80% profit margin and more than 400k order quantities each. We should ensure that there is adequate stock and the minimal shipment delay for these two products so that we can maintain customer satisfaction and high profit. Product categories such as Camping & Hiking, Golf Gloves, Golf Balls, and Accessories have over 70% profit margin but have less than 60k order quantities each.
📷 Dashboard screenshot