Answer Happy

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
1.45 ༠.༧ 1 APU Trend SOTD Demand variability (COV) Lead Time (dara) % ཉྙཱཉྩན 28 ཚེ བྱཱ ཡྻ # # #g ཙྪཱ ཉྙོ ཆུ 8 # # # #ag gi ཕྱི༴ * ཤཱ ཀྵ ཋ ཌྷ ཎ ཋ༔ ལ ཤཱ ཀྐཁཀྑ *བྱཱ ཙྪཱ ཡྻ ཤྩ ལྟ a ཥཱ ཀྐཱ ཀྵ #ཐུཊ ཋ ཤྩ བྷཱུ ཥཊ” འ ཡ #pསྒྱུ་ A/ - * + A » t» A On Hand Units ཤུ ༧ ཀྵ པ BA On-Hand Stock (5) ༧ - ༡ Std. Price ($ ac 46291 62146 1906