This sheet contains data about the inventory at GlasWork. Each column describes the SKU information as described below:

SKU - SKU NUmber Std. Price ($) - Price of each unit of SKU On-Hand Stock ($) - Total stock on-hand as of 30th Sep'20 APU (units) - Average monthly consumption (30 days) of the SKU APU Trend - Anticipated APU trend provided by marketing (e.g. 50% indicates 50% increase in APU consumption) S-OTD - Supplier On-time delivery (S-OTD) performance for the past 12 months Demand variability (COV) - Demand Coefficient of variance for the past 12 months Lead Time (days) - Lead time in days to procure the SKU

Assumptions to be taken into consideration: - The Minimum Order Quantity (MOQ) is equal to one lead-time demand - The service level targeted can be assumed to be 95% - The expiry for all the mentioned SKUs is one year

The marketing team has gathered insights regarding the anticipated demand trend for various SKUs based on their product families. Your team as part of this project, has been requested to estimate the

change in the inventory position to understand the working capital impact in one of the most critical plants in Switzerland, GlasWork. Based on the marketing insights gathered, she also wants to understand the potential obsolete inventory that they currently have.

Please respond in comments so I can forward you the Excel Sheet (there are over 2000 entries)