PracticeBARFree practice exam

BAR · Business Analysis · 6 practice questions

Time-Series Forecasting: Match the Method to the Pattern

Choose a forecasting method that matches whether demand is level, trending, or seasonal. Below, compare the same distributor's demand with only the pattern changed.

The ruleMatch the method to the pattern: simple exponential smoothing for level demand, linear trend regression for sustained trend, and seasonal indices for recurring seasonal changes.

Try one first

A distributor reviewed 30 months of monthly demand for a replacement part. Demand stayed between 980 and 1,030 units, with no persistent upward or downward movement. Higher or lower sales did not recur in the same months each year. Which forecasting method is generally most appropriate for next month's demand?
Hint

Match the method to the series pattern: level only, level plus trend, or level plus seasonality.

Side by side

Level demandTrending demandSeasonal demand
Shared factsA distributor reviews 30 months of monthly demand for one replacement part.The same distributor, replacement part, and 30-month observation history.The same distributor, replacement part, and 30-month observation history.
Demand patternDemand fluctuates around 1,000 units, with no sustained direction or recurring seasonal pattern.Demand has the same underlying level but now rises by a steady amount each month, with no recurring seasonal pattern.Demand has the same underlying level and no sustained trend, but December repeatedly runs 20% above its deseasonalized level.
Best methodSimple exponential smoothing.Linear trend regression.A seasonal-index model.
Tempting wrong choiceSeasonal smoothing merely because the observations are monthly.A weighted moving average that reacts faster but does not directly model trend.Simple exponential smoothing that ignores December's recurring increase.
Decisive factVariation has no sustained direction or recurring seasonal timing.Demand rises consistently over time.The increase recurs in the same month.

Key points

  • Remember: The demand pattern selects the method, not the fact that observations are monthly.
  • The distributor, product, observation history, and underlying demand level stay the same; only the pattern changes.
  • A more complex model is not automatically a better fit.

How the exam traps you

  • Treating monthly observations as proof of seasonality. Look for a pattern that repeats in the same months.
  • Choosing a weighted moving average because recent demand is rising. A sustained rise calls for a method that directly models trend.
  • Adding trend or seasonal components to stable demand. Use simple exponential smoothing when neither pattern appears.

5 more, each from a different angle

0 of 5 answered · 0 correct

Question 2

At the end of Q1, actual results and new sales data are available. Management asks how the quarterly planning model would be maintained if Paiva uses a rolling forecast. Which action is most appropriate?
Hint

Focus on what happens to the planning model after an actual period is completed.

Question 3

A company uses multiplicative seasonal indices in its monthly revenue forecast. The deseasonalized forecast for Year 3, December is $520,000, and December's seasonal index is 1.20. What revenue should the company forecast for December?
Hint

Decide whether the number given is a base amount with seasonality removed or an actual amount that still includes seasonality.

Question 4

A company forecasts monthly unit sales with a seasonal-index model based on five prior years. Year 1 actual sales are now available, and forecast error equals actual sales minus forecast sales. Which error pattern would most strongly indicate the model's historical seasonality assumption has broken down?
Hint

Look for a systematic error pattern tied to the pattern the model assumes will continue.

Question 5

A company forecasts next month's unit sales from the prior three months, assigning 0.50 to the most recent month, 0.30 to the next most recent, and 0.20 to the oldest month. Sales were 180 units in March, 210 in April, and 240 in May. What is the forecast for June?
Hint

Match each period to its stated weight by recency, then add the weighted amounts.

Question 6

An analyst developed the forecast equation Revenue = 1,200 + 75t, where t = 1 for Year 1, t = 2 for Year 2, and so on. Assuming the same pattern continues, what revenue is projected for Year 6?
Hint

Use the period number defined by the equation, then apply the slope to that time index.

Drill all 95 Data analytics, regression analysis, and quantitative methods questionsMixed across every rule in the topic, so you have to spot which one applies. That is how the exam does it.

Common questions

When should I use simple exponential smoothing?

Use it when demand fluctuates around a stable level without a sustained trend or recurring seasonal pattern.

Why choose linear trend regression instead of a moving average?

Linear trend regression directly models a sustained rise or fall over time. A moving average smooths recent observations but can lag behind that trend.

Does monthly demand data always require seasonal forecasting?

No. Seasonality requires a recurring pattern, such as December repeatedly running above its deseasonalized level. Monthly observations alone do not establish seasonality.

Practice BAR like the real exam

The free ChatCPA simulator: real exam layout, timed testlets, starting with a question on this topic. No account needed to start.

Open the free simulator →

More on Data analytics, regression analysis, and quantitative methods

All Data analytics, regression analysis, and quantitative methods practice →

Questions from the ChatCPA bank of 17,658 CPA exam questions, each with a written reason for every wrong answer. ChatCPA is built by Nicholas Miller, CPA (Oregon #14907). How these pages are made. Spot an error? Tell us.