CSCP Demand Management and Forecasting Questions and Answers — Questions and Answers
Question 1: A supply chain manager is analyzing demand for a new consumer electronics product. The data shows a consistent upward movement in sales over the past eight quarters, although there are also predictable peaks in the fourth quarter and dips in the first quarter of each year. Which combination of demand patterns best describes this situation?
- Seasonal and cyclical
- Trend and seasonal (Correct answer)
- Random and trend
- Cyclical and random
Correct answer: Trend and seasonal
The consistent upward movement in sales indicates a 'trend' pattern, showing long-term growth. The predictable peaks and dips occurring in the same quarters each year are characteristic of a 'seasonal' pattern, which repeats on a regular, annual basis. Cyclical patterns are tied to longer economic cycles, and random variations are unpredictable.
Question 2: A company is preparing a long-range forecast for a completely new, innovative technology for which no historical sales data exists. The leadership wants to gather and synthesize opinions from a diverse group of internal and external subject matter experts to arrive at a consensus forecast. Which of the following forecasting techniques would be most appropriate?
- Exponential smoothing
- Time series analysis
- Delphi method (Correct answer)
- Linear regression
Correct answer: Delphi method
The Delphi method is a qualitative forecasting technique that is ideal for situations with little to no historical data. It involves systematically and anonymously surveying a panel of experts through multiple rounds to reach a group consensus. The other options are quantitative methods that rely on historical data.
Question 3: In the Collaborative Planning, Forecasting, and Replenishment (CPFR) model, which of the following activities occurs during the initial 'Strategy & Planning' phase?
- Generating the final order forecast.
- Identifying exceptions between sales forecast and order forecast.
- Creating a joint business plan and defining collaboration rules. (Correct answer)
- Executing the replenishment of orders to the retailer.
Correct answer: Creating a joint business plan and defining collaboration rules.
The 'Strategy & Planning' phase is the foundational step in the CPFR process. During this stage, trading partners establish the ground rules for collaboration, define roles, and create a joint business plan that outlines shared goals and strategies. Identifying exceptions and generating orders happen in later phases like 'Demand & Supply Management' and 'Execution'.
Question 4: A company wants to select the best short-term forecasting model for its large portfolio of products. The demand patterns vary significantly across different items. The chosen forecasting methodology involves applying several simple forecasting rules to the historical data of each product and selecting the rule that would have performed with the least error for the next period. This methodology is known as:
- Adaptive smoothing
- Focus forecasting (Correct answer)
- Pyramid forecasting
- Sales and operations planning (S&OP)
Correct answer: Focus forecasting
Focus forecasting is a technique that applies multiple simple forecasting rules (e.g., 'next month's demand will be the same as last month's') to past data. It then selects the rule that proves to be the most accurate for a given item and uses it to generate the next forecast. This method is particularly useful for managing forecasts for a large number of SKUs with varying demand patterns.
Question 5: A manager is evaluating two different forecasting methods. Method A has a Mean Absolute Deviation (MAD) of 100 units. Method B has a Mean Absolute Percent Error (MAPE) of 10%. To properly compare the accuracy of these two methods, what additional information is most critical?
- The tracking signal for each method.
- The average demand of the product. (Correct answer)
- The lead time for the product.
- The cost of the product.
Correct answer: The average demand of the product.
MAD is an absolute measure of error in units, while MAPE is a relative measure expressed as a percentage. To compare them or to understand the significance of a MAD of 100 units, you need to know the average demand. For example, a MAD of 100 is very high for a product with average demand of 200 units (50% error), but low for a product with average demand of 5000 units (2% error). Knowing the average demand allows for the conversion of MAD to a percentage error for a meaningful comparison with MAPE.
Question 6: Which of the following is an example of a demand shaping activity?
- Increasing safety stock levels to buffer against forecast inaccuracy.
- Implementing a new warehouse management system to improve efficiency.
- Expediting a shipment from a supplier to avoid a stockout.
- Offering a promotional discount on last season's inventory to accelerate sales. (Correct answer)
Correct answer: Offering a promotional discount on last season's inventory to accelerate sales.
Demand shaping refers to the use of marketing and pricing tactics to influence customer demand to better match supply. Offering a promotional discount is a classic example of demand shaping, as it incentivizes customers to purchase a specific product, thereby altering the natural demand pattern. The other options are related to supply management and logistics, not influencing customer buying behavior.
A supply chain manager is analyzing demand for a new consumer electronics product.
The data shows a consistent upward movement in sales over the past eight quarters, although there are also predictable peaks in the fourth quarter and dips in the first quarter of each year.
Which combination of demand patterns best describes this situation?