AMAADOR ACADEMYCertificatesVerify a certificate

IMDP

Final check — Inventory Management and Demand Planning (S&OP) with Excel Calculators

Answer the 24 questions. You need 80% or more to pass. You can retry as many times as you like.

Study the course →

Question 1Which inventory function protects against forecast error and late deliveries?
Question 2A plant builds three weeks of extra finished goods before a planned two-week maintenance shutdown. Which function does this stock serve?
Question 3A distributor's annual cost of goods sold is 9 million and its average inventory is 1.5 million. What are its inventory turns and its approximate days of supply?
Question 4After an inventory reduction project, turns rose from 5 to 8, but fill rate fell from 97% to 85%. How should the result be read?
Question 5In a standard ABC analysis, what are items ranked by?
Question 6An item's monthly demand has a mean of 100 and a standard deviation of 120. Using the common XYZ limits, how is it classed?
Question 7A low-cost class C sensor stops the whole packing line whenever it is missing. What should the planner do?
Question 8During a cycle count, an operator finds 120 units in a location where the system shows 150. What is the right response?
Question 9A planner uses simple exponential smoothing with α = 0.2. Last month's forecast was 500 and the actual was 600. What is the forecast for next month?
Question 10A promotion in May tripled sales of one product. What should the planner do with May when building the baseline forecast?
Question 11Which Excel function forecasts a series using level, trend and seasonality?
Question 12Over three years, July averages 1,300 units while the average month is 1,000. The deseasonalised forecast for next July is 1,100. What is the July forecast?
Question 13The forecast was 100 and the actual was 80. Using error = actual − forecast, what is the error and what does it show?
Question 14An analyst reports a MAPE of 140% for a portfolio of slow movers with many months of tiny demand. Which measure gives a fairer picture?
Question 15Over 12 months, the cumulative error (actual − forecast) is +360 units and MAD is 60. What does the tracking signal indicate?
Question 16For one family, WMAPE is 35% for the naive forecast, 24% for the statistical model and 29% after sales overrides. What should the team conclude?
Question 17Annual demand is 8,000 units, each order costs 250, and holding one unit for a year costs 10. What is the EOQ?
Question 18Average daily demand is 50 units, the lead time is 6 days and safety stock is 80 units. What is the reorder point?
Question 19Raising the target cycle service level from 95% to 99% moves z from 1.65 to 2.33. Roughly how does safety stock change?
Question 20A buyer compares the reorder point with stock on the shelf only and ignores 500 units already on order. What is the likely result?
Question 21What is the usual order of the steps in the monthly S&OP cycle?
Question 22In the family plan, opening inventory is 12, planned production is 20 and the demand plan is 25 (thousand units). What is the ending inventory?
Question 23In the executive S&OP meeting, the sales director wants to go through 40 individual SKUs one by one. What should the S&OP lead do?
Question 24Sales, finance and operations each work from a different forecast for next quarter. What is the main S&OP answer?