0% found this document useful (0 votes)
18 views2 pages

Supply Chain Demand Forecasting Tasks

The document outlines five key tasks for a supply chain manager, including demand forecasting, calculation of forecast errors, and performance metrics analysis. It requires the manager to justify their choice of forecasting method, calculate demand forecasts and errors, and propose recommendations for improving supply chain performance. Each task has specific instructions and word limits to guide the completion of the assessment.

Uploaded by

laleni8488
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
18 views2 pages

Supply Chain Demand Forecasting Tasks

The document outlines five key tasks for a supply chain manager, including demand forecasting, calculation of forecast errors, and performance metrics analysis. It requires the manager to justify their choice of forecasting method, calculate demand forecasts and errors, and propose recommendations for improving supply chain performance. Each task has specific instructions and word limits to guide the completion of the assessment.

Uploaded by

laleni8488
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Project Tasks

Now that you are aware of the scenario and are equipped with the necessary data let’s go
through the five key tasks you need to perform as the supply chain manager for the company.

Task 1: Demand Forecasting Method

a. State and justify your choice of demand forecasting method if you had to forecast the
demand for the next six months (a short-term forecast). Also, explain at least one assumption
made. Remember that the data of demand provided is sensitive to changes.
(Word Limit: 200 words)

Task 2: Demand Forecast Calculation

a. Using the monthly demand data provided for the previous year, forecast the demand for each
product for the next six months using a suitable forecasting method (e.g., moving average,
weighted moving average, simple exponential smoothing).

Note: For any forecasting calculation purposes, you can consider α=0.3

Task 3: Calculating Forecast Errors

a. Consider the following table as the actual demand data for the company’s products after six
months.

Months Smartphones Laptop Smartwatches

January 1600 755 259

February 1649 865 292

March 1569 877 250

April 1750 923 214

May 1920 1000 200

June 2040 1100 196

Based on the demand forecasts you prepared in Task 1 and the actual data provided in the table
above, calculate the forecast errors for the six months.

Task 4: Metrics and Analysis

a. Based on the forecast and forecast errors you calculated in the previous tasks, calculate the
following key performance metrics:

1. Mean absolute percentage error (MAPE)

2. Bias
Task 5: Recommendations

Analyze the forecast errors and metrics calculated so far and propose corrective actions in your
approach and strategy. Provide recommendations for improving the supply chain planning
process to handle demand fluctuations better, reduce lead times, and enhance overall supply
chain performance. Provide at least three recommendations (at least three; one for each
product category).
(Word Limit: 500 words)

The assessment and grading criteria are provided in the next segment.

Common questions

Powered by AI

Common assumptions include the notion that historical demand trends are indicative of future patterns and that external influences remain stable. These assumptions can lead to inaccurate forecasts if market conditions change unexpectedly or if significant new influences arise, underscoring the need for models that accommodate variability .

Lead times dictate the speed at which a supply chain can respond to fluctuations in demand. Reducing lead times minimizes delays, enhances customer satisfaction by ensuring timely delivery, and reinforces supply chain resilience and adaptability, crucial for maintaining competitive advantage in dynamic markets .

Data sensitivity impacts forecasting accuracy since volatile data may lead to greater discrepancies between forecasted and actual values. Strategies like using adaptive models that factor in recent data more heavily, such as exponential smoothing with trend adjustments, can mitigate these effects by accounting for rapid changes in demand patterns .

Evaluating bias involves identifying tendencies in forecast inaccuracies, such as consistent over or underestimations. Addressing these can improve future forecasts by enabling recalibration of models for specific product categories, optimizing parameter settings, and integrating external factors like market trends or economic indicators to refine forecast precision .

For a short-term forecast with sensitive demand data, the choice of a suitable method involves evaluating methods like moving average, weighted moving average, or simple exponential smoothing. A justifiable choice would be simple exponential smoothing due to its ability to adjust to recent changes efficiently. An assumption that could be made here is that past patterns of demand fluctuations are indicative of future trends, allowing exponential smoothing to capture shifts in demand promptly .

Analyzing forecast errors and metrics like MAPE and Bias helps identify systemic issues in forecasting processes, such as consistent underestimations or overestimations. Recognizing these trends can inform recommendations like adopting more adaptive forecasting methods, improving data collection techniques, and implementing real-time demand monitoring systems, thus enhancing supply chain responsiveness and accuracy .

To apply simple exponential smoothing with α=0.3, calculate the forecast for the first month by using the formula: Forecast = α * (Actual demand of nth month) + (1 - α) * (Forecast of nth month). Continue this calculation iteratively for the six-month period by using the actual demand values from the previous months to update the forecasts accurately, ensuring responsiveness to recent demand changes .

To calculate MAPE, take the absolute value of each forecast error, divide it by the actual demand, and convert it to a percentage before averaging across the dataset. To calculate Bias, sum the forecast errors for all data points. MAPE indicates the average forecast error rate relative to true demand, while Bias reveals overall tendencies towards overestimation or underestimation, both essential for assessing forecast reliability .

For smartphones, implementing a robust demand sensing technology might help reduce lead times. For laptops, enhancing collaboration with suppliers could allow for better agility in response to demand spikes. For smartwatches, diversifying sourcing options may reduce risk and improve supply chain resilience to demand shocks .

Calculate the forecast errors by subtracting the forecasted demand from the actual demand for each month and product, producing a series of error values that indicate the difference between expected and actual outcomes. This is crucial for supply chain management as it highlights areas where forecasting was inaccurate, guiding adjustments in planning and improving future predictions .

You might also like