210 likes | 218 Views
This analysis by Team Panda Elites aims to balance performance, reduce transportation and inventory costs, support growth, and enable lean operations in the Eaton Power Distribution Systems supply chain at Purdue University. Key insights and proposals are provided.
E N D
Supply Chain analysis at Purdue University Team Name: Panda Elites Xian Zhu Junming Liu Yu He Yangon Chen
Objectives (Xian Zhu) • Short-term • To balance the performance between the west & east coasts • Lower the Transportation Cost in the western sites; • Lower the Inventory Cost in the western sites • Long-term • Support the growth of the whole Eaton Power Distribution Systems • Lean operation
Concerns(Xian Zhu) • From the Data • High Turnover rate of Dallas SVC • The huge monthly variation of demand • The frequent usage of premium freight • The limited capacity of W87 & DBN
Data Analysis (Junming Liu) • Cost of Good Sold
Data Analysis (Junming Liu) • Turnover • Annualize COGS Extreme case of Dallas-SVT
Data Analysis (Junming Liu) • Highlight on DIO • Atlanta-SAT April DIO = 1537 days • Chicago-SVT May DIO = 3862 days • Houston-SVC Feb. DIO = 1052 days
Data Analysis (Junming Liu) • Days of Inventory Outstanding Mean 49.11 days SD = 7.65 days
Data Analysis (Junming Liu) • Trend on COGS (Sales)
Data Analysis (Junming Liu) • High COGS Fluctuation • No Pattern on Demand • Low Responsiveness to the Change of Demand
Data Analysis (Junming Liu) • Overall Trend
Data Analysis (Junming Liu) • Premium Ship Percentage • Chicago, Dallas, San Francisco: High Percentage
Data Analysis (Junming Liu) • Reasons • Distance with Suppliers • Demand Varies • Local Economy • Unemployment • New Construction Extreme Case for Dallas-SVC
Data Analysis (Junming Liu) • Percentage of Order by Source
Data Analysis (Junming Liu) • Los Angeles (Best Case) 1 2 3 Order from Closer Sources Average Premium Shipping Percentage Balanced Order Sources Highly Utilization of W87 Highest Purchases High COGS (Demand) 4
Data Analysis (Junming Liu) • In Addition, Low Capacity of Warehouse
Proposals(Yu He) We suggest to build a major warehouse to enhance the whole supply chain system. Our Reasons: 1. W87 is relatively useless to Electrical Sector. 2. Electrical Sector has no priority. 3. Relieve W34 and W87’s pressure. 4. Shorten distance of supply to some CMSC sites. 5. Increasing trend of demand in the future.
Proposals(Yu He) • Adjust three-day rotation ABC Classifications
Recommendations(Yanjun Chen) • Kanban card- It’s time to change! • LTL Problem • Demand Forecasting • Aggregate Planning -- Level strategy • Looking for more external suppliers in West Coast