The marketing team has gathered insights regarding the anticipated demand trend for various SKUs based on their product

[answerhappygod]

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.
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 1 (53.34 KiB) Viewed 24 times

A D E H В B GlasWork's data for its SKUS SKU Std. Price ($) APU Trend S-OTD 7 7 12 15 22 12 12 38 39 20 91 92 33 34 25 26 27 28 99 DO 21 2 3 4 05 06 7 08 09 10 11 12 2 95552 18382 87485 85729 13084 1610 4336 36540 84555 82988 16822 66098 10530 14562 66951 26379 98206 86793 32713 92434 78262 57719 2199 31340 44624 08. BOGENOEN TUBOVOU On-Hand Stock ($) 927,845 299,388 982,693 194 70 30 75 68 27 38 174 22 15 51 311 48 67 57 APU (units) 82874 98614 126260 130 50 18 34 66 10 10 82 10 10 10 220 26 18 26 10 18 34 18 74 34 186 -20% 40% 80% -20% 50% 60% -60% 120% 80% 150% -40% -60% 120% 150% -20% 80% -40% 150% 150% 150% -40% 120% 120% 120% 40% 1 1 1 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7 Demand variability (COV) 0.45 0.52 0.31 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 0.8 Lead Time (days) 66 16 76 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 оп л п о с т п о п о л о с 30 10 22 12 16 27 20 73 12 47 142 112 65 273 10