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

[answerhappygod]

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)