Forecasting Methods Quiz
45 Questions
2 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the forecasted tonnage for quarter 9 using an alpha ($\alpha$) of 0.10?

  • 179.5
  • 180.22
  • 178.6 (correct)
  • 182

Which quarter's forecast for $\alpha = 0.50$ was the lowest?

  • 6
  • 7
  • 4 (correct)
  • 8

What is the absolute deviation for quarter 5 using an alpha ($\alpha$) of 0.10?

  • 6.77 (correct)
  • 6.64
  • 7
  • 5

What alpha ($\alpha$) value resulted in a higher forecast for quarter 3?

<p>0.5 (D)</p> Signup and view all the answers

What is the forecast for quarter 2 using an alpha ($\alpha$) of 0.10?

<p>175.5 (D)</p> Signup and view all the answers

What is the total sum of the weights used in the weighted moving average model?

<p>6 (A)</p> Signup and view all the answers

What is the weighted moving average for April, using the sales data provided?

<p>12.17 (D)</p> Signup and view all the answers

How would the weighted moving average for May change if the sales for April were 15 instead of 16?

<p>It would decrease. (A)</p> Signup and view all the answers

What was the actual sales number in March?

<p>13 (B)</p> Signup and view all the answers

What would the weighted moving average for June be if the sales for June were 25 instead of 23?

<p>22.67 (C)</p> Signup and view all the answers

Which month had the highest sales figure recorded?

<p>August (A)</p> Signup and view all the answers

What was the weighted moving average for September based on the available data?

<p>28.33 (B)</p> Signup and view all the answers

How is the moving average calculated using the weighted scheme?

<p>Multiplying by appropriate weights and dividing by the sum of the weights. (B)</p> Signup and view all the answers

What is the primary reason for using trend adjustment in exponential smoothing?

<p>To respond effectively to trends (D)</p> Signup and view all the answers

Which equation represents the trend correction in exponential smoothing?

<p>$T_{t+1} = (1 - eta)T_t + eta (F_{t+1} - F_t)$ (A)</p> Signup and view all the answers

How does a high value of the trend smoothing constant, $eta$, affect forecasts?

<p>It increases responsiveness to changes in trend. (A)</p> Signup and view all the answers

What type of method is often referred to as first-order smoothing?

<p>Simple exponential smoothing (B)</p> Signup and view all the answers

What is the purpose of using trial-and-error when selecting a smoothing constant?

<p>To minimize errors in forecasting (D)</p> Signup and view all the answers

Which method utilizes a linear regression equation for forecasting time-series data?

<p>Trend projection (D)</p> Signup and view all the answers

What is a characteristic of time-series data that trend projections are particularly suited for?

<p>Data that follows a linear trend (A)</p> Signup and view all the answers

In trend projection, which equation is sometimes used to derive future forecasts?

<p>$y = mx + b$ (B)</p> Signup and view all the answers

What is the purpose of using the Centered Moving Average (CMA) approach in seasonal variation analysis?

<p>To isolate seasonal variations from trend effects. (A)</p> Signup and view all the answers

How should seasonal indices be computed when both trend and seasonal components are present?

<p>Using a Centered Moving Average (CMA) approach. (D)</p> Signup and view all the answers

If the sum of seasonal indices is not equal to the number of seasons, what should be done?

<p>An adjustment should be made. (C)</p> Signup and view all the answers

In the provided data for monthly sales, what does a seasonal ratio greater than 1 indicate?

<p>Sales are higher than the average for that time. (B)</p> Signup and view all the answers

What is indicated by averaging the seasonal ratios to obtain the seasonal index?

<p>It identifies the overall seasonal effect across different quarters. (B)</p> Signup and view all the answers

Which months in the provided data have a sales factor of greater than 1?

<p>May and August. (A)</p> Signup and view all the answers

Why is it incorrect to interpret random fluctuations as seasonal variations?

<p>Seasonal variations follow a predictable pattern. (D)</p> Signup and view all the answers

When calculating CMA, which quarters are involved for a specific quarter in an annual time series?

<p>One-half of the previous quarter and the entire next two quarters. (B)</p> Signup and view all the answers

What is the purpose of multiplying seasonal indices by (Number of seasons)/(Sum of the indices)?

<p>To ensure the seasonal indices sum to the number of seasons (C)</p> Signup and view all the answers

What is the correct formula for calculating the Tracking Signal?

<p>RSFE / MAD (B)</p> Signup and view all the answers

In the regression model for forecasting sales, what does X1 represent?

<p>The time period (B)</p> Signup and view all the answers

What does a Tracking Signal value of +2.5 indicate?

<p>The forecasts are performing adequately. (D)</p> Signup and view all the answers

What is the formula for the regression equation given in the content?

<p>Ŷ = 104.1 + 2.3X1 + 15.7X2 + 38.7X3 + 30.1X4 (A)</p> Signup and view all the answers

What does using dummy independent variables in regression allow for?

<p>Generating distinct coefficient values for different seasons (C)</p> Signup and view all the answers

In the Kimball’s Bakery example, what was the cumulative RSFE after the 6th period?

<p>+35 (C)</p> Signup and view all the answers

Which of the following is NOT a step in computing seasonal indices based on CMAs?

<p>Divide each seasonal ratio by the number of seasons (B)</p> Signup and view all the answers

Which measure is expected to be close to zero for adequate forecast performance at Disney?

<p>Mean Absolute Percentage Error (MAPE) (C)</p> Signup and view all the answers

What is the Mean Absolute Deviation (MAD) for the first 6 periods in the Kimball’s Bakery example?

<p>14.2 (B)</p> Signup and view all the answers

What do the terms MAD and MSE refer to in the context of evaluating the model?

<p>Mean Absolute Deviation and Mean Squared Error (A)</p> Signup and view all the answers

What are the results from using the regression model mentioned in the content for the first quarter?

<p>134 (A)</p> Signup and view all the answers

Which software is NOT mentioned as a tool that can be used for forecasting?

<p>Excel (B)</p> Signup and view all the answers

What type of forecasting model can be automatically selected by dedicated forecasting software?

<p>Time-series and Causal Models (B)</p> Signup and view all the answers

How does the regression model handle seasonal components?

<p>By incorporating dummy variables for distinct seasons (A)</p> Signup and view all the answers

How many periods are included in the tracking signal calculation for Kimball's Bakery?

<p>6 (C)</p> Signup and view all the answers

Flashcards

Weighted Moving Average

A forecasting method that gives more weight to recent data points than older ones. This is done by multiplying past sales by specific weights to calculate the average.

Weighting Scheme

The specific weights assigned to historical sales data in a weighted moving average.

How to calculate weighted moving average?

Multiply each past sales figure by its assigned weight. Sum up the weighted sales. Finally, divide the sum by the total of all weights.

Example Weighted Scheme

A common scheme assigns a weight of 3 to the most recent month, 2 to the month before, and 1 to the month before that. This means the most recent month's sales have greatest influence on the forecast.

Signup and view all the flashcards

Benefits of Weighted Moving Average

It adapts to recent trends better than a simple moving average, as it gives more importance to recent sales data.

Signup and view all the flashcards

Limitations of Weighted Moving Average

It still relies on past data and may not be accurate for products with unpredictable demand.

Signup and view all the flashcards

What is the forecast for May?

The forecast for May is 14.33, calculated by using the weighted moving average.

Signup and view all the flashcards

What are the weights in the Wallace Garden Supply example?

The weights used are 3, 2, and 1 for the last month, two months ago, and three months ago, respectively.

Signup and view all the flashcards

Exponential Smoothing

A forecasting method that uses a weighted average of past data to predict future values. The weights are determined by the smoothing constant (alpha).

Signup and view all the flashcards

Alpha (α)

The smoothing constant in exponential smoothing. It determines the weight given to the most recent data point. A higher alpha value gives more weight to recent data, while a lower alpha value gives more weight to past data.

Signup and view all the flashcards

Forecast Accuracy

The closeness of a forecast to the actual values. Measured by the absolute deviations between the forecast and the actual values.

Signup and view all the flashcards

Absolute Deviation

The absolute difference between the forecast and the actual values.

Signup and view all the flashcards

Choosing the Best Alpha

The process of selecting the value of alpha that yields the most accurate forecast. Typically involves comparing the absolute deviations for different alpha values.

Signup and view all the flashcards

Seasonal Variation

Fluctuations in data that occur regularly at specific times of the year, like higher sales during holiday seasons.

Signup and view all the flashcards

Trend

A long-term upward or downward pattern in data over time, like increasing sales over many years.

Signup and view all the flashcards

Centered Moving Average (CMA)

A method to smooth out data by averaging values over a specific period, centered around the current time period.

Signup and view all the flashcards

Seasonal Index

A number representing the typical deviation from the overall average in a specific season, indicating if sales are higher or lower than usual.

Signup and view all the flashcards

What is the purpose of a Seasonal Index?

To isolate and quantify the seasonal component of a time series, allowing for more accurate forecasts and analysis by removing the seasonality effect.

Signup and view all the flashcards

How to calculate a Seasonal Index?

Divide actual sales for a specific period by the Centered Moving Average (CMA) for the same period. Then average the results for several periods to determine the seasonal index.

Signup and view all the flashcards

Seasonal Ratio

The ratio of actual sales in a specific period to the Centered Moving Average (CMA) for the same period, showing the percentage difference from the average.

Signup and view all the flashcards

Why is the sum of Seasonal Indices equal to the number of seasons?

Because the average season should have an index of 1, and the sum of the indices represents the total deviation across all seasons.

Signup and view all the flashcards

CMA (Centered Moving Average)

A type of moving average calculated by averaging the values centered around a specific period. It smooths out short-term fluctuations in the data.

Signup and view all the flashcards

Additive Decomposition

A time series forecasting method that separates data into trend, seasonal, cyclical, and irregular components. The components are then added together to create a forecast.

Signup and view all the flashcards

Dummy Variable

A variable that takes on the value of 1 for a specific category and 0 for all others. Used in regression models to represent categorical variables.

Signup and view all the flashcards

Additive Model

A forecasting model that adds the trend, seasonal, cyclical, and irregular components together to produce the final forecast.

Signup and view all the flashcards

Multiplicative Decomposition

A time series forecasting method that separates data into trend, seasonal, cyclical, and irregular components. The components are then multiplied together to create a forecast.

Signup and view all the flashcards

MAD (Mean Absolute Deviation)

A measure of forecast accuracy that calculates the average absolute difference between the forecast and the actual values.

Signup and view all the flashcards

Exponential Smoothing with Trend Adjustment

A forecasting method that adjusts for trends by combining exponential smoothing with a trend correction component. It improves upon simple exponential smoothing by incorporating trend information into the forecast.

Signup and view all the flashcards

Trend Correction (Tt)

A value added to the exponential smoothed forecast to account for any upwards or downwards trend in the data. It represents the estimated change in the forecast due to the trend.

Signup and view all the flashcards

Trend Smooth Constant ()

A value between 0 and 1 that determines how much the trend correction is influenced by the most recent trend. A higher value gives more weight to recent changes in the trend.

Signup and view all the flashcards

How does the trend correction work?

The trend correction is calculated using a weighted average of the previous trend and the recent change in the forecast. This allows the forecast to adapt to changing trends over time.

Signup and view all the flashcards

Selecting a Smoothing Constant ()

Finding the optimal value for  involves trial and error, aiming to minimize the forecast error (measured by MAD). This balances responsiveness to recent trends with smoothing out fluctuations.

Signup and view all the flashcards

Why is Trend-adjusted Smoothing called Second-order Smoothing?

It involves two levels of smoothing. First, the simple exponential smoothing smooths out fluctuations, and then the trend correction adjusts for any trend present in the data.

Signup and view all the flashcards

Trend Projection

A method that uses a trend line to forecast future values based on historical data. This method assumes that the trend will continue in the future.

Signup and view all the flashcards

Linear Trend Projection

A trend projection that uses a linear regression equation to model the trend. This creates a straight line representing the relationship between time and data values.

Signup and view all the flashcards

Tracking Signal

A measure of how well forecasts are predicting actual demand. It assesses the consistency between forecasts and actual outcomes, indicating potential problems.

Signup and view all the flashcards

What does a high tracking signal mean?

A high tracking signal suggests that the forecasting method is not accurately predicting demand. It indicates a significant inconsistency between forecast and actual outcomes.

Signup and view all the flashcards

What does a low tracking signal mean?

A low tracking signal indicates that the forecasting method is accurately predicting demand. It suggests good alignment between forecasts and actual outcomes.

Signup and view all the flashcards

MAPE (Mean Absolute Percentage Error)

A common measure of forecast accuracy that calculates the average percentage error between the forecast and actual values.

Signup and view all the flashcards

Why are spreadsheets useful for forecasting?

Spreadsheets provide a user-friendly and flexible tool for basic forecasting tasks. They are suitable for handling small to medium-sized forecasting problems.

Signup and view all the flashcards

What type of forecasting models do advanced programs handle?

Advanced programs, like SAS, SPSS, and Minitab, can handle more complex time-series and causal models. These models analyze trends and relationships over time to improve forecasting accuracy.

Signup and view all the flashcards

What are dedicated forecasting packages?

Specialized software designed specifically for forecasting. These packages often automate various tasks and can integrate with inventory planning systems.

Signup and view all the flashcards

How can forecasting be integrated with inventory planning?

By integrating forecasting with inventory planning systems, businesses can better align production and procurement with anticipated demand, optimizing inventory levels and reducing costs.

Signup and view all the flashcards

Study Notes

Introduction to Forecasting

  • Managers constantly strive to reduce uncertainty and enhance future estimations.
  • Forecasting serves as the primary tool for achieving this objective.
  • Subjective methods, like intuition and experience, are sometimes used by firms.
  • Several quantitative techniques, including moving averages, exponential smoothing, trend projections, and least squares regression analysis, are employed by businesses.
  • Forecasting involves methodical steps:
    • Defining the forecast's objective
    • Selecting the items to be forecasted
    • Determining the forecast's time horizon
    • Choosing the appropriate forecasting model or multiple models
    • Gathering necessary data
    • Validating the forecasting model
    • Making the forecast
    • Implementing the forecast results

What is Forecasting?

  • Forecasting is a process of estimating or predicting future demand through past and present events.
  • It provides insights into potential future events and their impact on businesses.
  • Forecasting is considered a blend of art and science in estimating future events (Heizer and Render, 2010).
  • It involves a systematic approach to inferring the future based on known facts (Louis Allen).

Strategic Importance of Forecasting

  • Supply Chain Management involves all activities that ensure the right product, at the right price, and in the right place.
  • Apple Inc. exemplifies effective supply chain management by controlling diverse aspects of its global system.
  • Human resources (HR) demand forecasting predicts future human resource needs to ensure the right number and quality of personnel. HR functions, such as hiring, training, promotions, and lay-offs, rely on this forecast.
  • Capacity from an organizational perspective encompasses all elements—physical resources, ideas, and people—required to achieve the organization's mission and meet demand.

Benefits of Forecasting

  • Aids in inventory and material management.
  • Improves employee relations.
  • Optimizes the utilization of available resources.
  • Enhances customer satisfaction.

Forecasting Models

  • Models are classified into qualitative and quantitative categories.
  • Qualitative methods include Delphi Methods, Jury of Executive Opinion, Sales Force Composite, and Consumer Market Surveys.
  • Quantitative methods are further categorized into time-series and causal techniques.
  • Time-series methods, such as moving averages and exponential smoothing, identify trends and predict future values based on historical data.
  • Causal models employ variables or factors potentially affecting a forecasted quantity. Regression analysis serves as the standard quantitative approach for causal modeling.

Time-Series Models

  • Time-series models anticipate future values based exclusively on historical patterns.
  • Methods including moving averages, exponential smoothing, trend projections, and decomposition utilize past data to make predictions.
  • Regression analysis underpins trend projections and some decomposition models.

Causal Models

  • Causal models identify and model the relationships between factors influencing the forecasted quantity.
  • The goal is to establish a statistically sound relationship between the variable being forecast and relevant influencing factors.
  • Regression analysis is the most prevalent technique employed in causal modeling.

Qualitative Models

  • Qualitative models incorporate judgment or subjective factors, proving valuable when accurate quantitative data acquisition is challenging.
  • Qualitative methods like Delphi, Jury of Executive Opinion, and Sales Force Composite incorporate expert judgment.
  • Consumer market surveys gather input from potential or current customers about purchasing plans.

Scatter Diagrams

  • Scatter diagrams visually represent the relationship between variables in a time series, aiding forecast construction.
  • Wacker Distributors utilized scatter data to forecast sales for various products.
  • By examining plotted data points, patterns can be identified; if the relationship between variables appears linear, a trend projection might be employed to predict future outcomes.

Measures of Forecast Accuracy

  • Forecasts are evaluated against actual values.
  • Common error measures include Mean Absolute Deviation (MAD), Mean Squared Error (MSE), and Mean Absolute Percent Error (MAPE).
  • Bias, representing the average error, indicates whether forecasts tend towards high or low values.
  • Naïve forecasting models serve as baseline comparisons for evaluating the accuracy of more sophisticated methods.

Hospital Days Forecast Example

  • Ms. Smith, forecasting total hospital inpatient days, reevaluates her model using provided actual data.
  • MAD, MSE, and MAPE are used for model evaluation.

Time-Series Forecasting Models

  • A time series compiles evenly-spaced events.
  • Time-series forecasts solely utilize past data values.

Moving Averages

  • Moving averages produce forecasts when demand remains relatively stable over time.
  • The forecast is the average of recent data values from the time series, replacing the oldest data point as new values become available.

Weighted Moving Averages

  • Weighted moving averages assign varying weights to past data points, emphasizing recent data.
  • The technique is particularly beneficial when a trend or other pattern is emerging in the data.

Exponential Smoothing

  • Exponential smoothing is a data-smoothing technique that places greater weight on the most recent data points.
  • The forecast for a period consists of the previous forecast adjusted for the error.
  • A smoothing constant (0 ≤ α ≤ 1) controls the relative importance given to recent versus prior data in the forecast.

Selecting the Smoothing Constant

  • Choosing the proper smoothing constant (α) is critical in creating a reliable forecast.
  • Experimentation to find the smoothing constant (α) with the lowest mean absolute deviation (MAD) is commonly employed.

Trend Projections

  • Linear regression generates a trend line from observed data.
  • Future forecasts are calculated by projecting this line into the future.
  • The least squares method determines the trend line that minimizes errors between predicted and actual values.

Midwestern Manufacturing Company Example

  • The data shows a trend in electrical generator sales.
  • Using simple linear regression, forecasts for the next two quarters can readily be made.
  • Data analysis helps to decide on the best model and its forecasting accuracy.

Decomposition of a Time-Series

  • Time series consist of components including trend, seasonality, cycles, and random variations.
  • Multiplicative models express demand as the product of trend, seasonal, cyclical, and random factors.
  • Additive models represent demand as the sum of these components.

Seasonal variations

  • Recurring fluctuations suggest the need for seasonal adjustments within trend lines.
  • A seasonal index quantifies how a particular season compares with the average.
  • This index calculates the ratio of the average value for a certain season to the average across all data points when no trend is present.

Regression with Trend and Seasonal Components

  • Multiple regression methods forecast a trend or seasonal pattern by using time period and dummy variables to capture seasonal effects.
  • This approach builds a model for forecasting.

Monitoring and Controlling Forecasts

  • Tracking signals monitor forecast accuracy.
  • A tracking signal exceeding predefined limits indicates a need for analysis or adjustments to the forecasting model or procedure.
  • A standardized measure like Mean Absolute Deviation (MAD) clarifies the scale of forecast errors.

Forecasting at Disney

  • Disney's daily reports summarize yesterday's attendance forecasts and current attendance.
  • Error measures, like MAPE, are expected to approach zero.
  • An annual forecast for 2000 achieved a MAPE of 0.

Using The Computer to Forecast

  • Computer programs, including specialized forecasting software, aid in handling intricate time series or causal models.
  • These tools automate the selection of optimal model parameters.
  • Integrating the process within inventory planning and control systems improves efficiency.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Quiz Team

Related Documents

Chapter 5 Forecasting PDF

Description

Test your understanding of forecasting methods with this quiz focused on alpha values in quarterly forecasting. You'll answer questions regarding tonnage predictions, absolute deviation, and comparisons of different alpha rates for better accuracy in forecasts.

More Like This

Use Quizgecko on...
Browser
Browser