38.5k views
0 votes
use the border crossings data below to calculate a 5 -month weighted moving average (wma) forecast for truck crossings and predict the number of truck crossings for october 2018. use the weights of 0.3, 0.3, 0.2, 0.1, and 0.1 for the 5 -month wma, where the first weight is used for the most recent month and the last weight is used for the least recent month. round your answer to two decimal places, if necessary. 2018 month number of truck border crossings february 178,058 march 194,180 april 198,066 may 200,723 june 193,582 july 193,504 august 207,528 september 186,206

User Jim Bray
by
7.1k points

1 Answer

3 votes

Final answer:

The 5-month weighted moving average forecast for truck crossings for October 2018 is calculated using the weights 0.3, 0.3, 0.2, 0.1, and 0.1 for the months May through September, resulting in a forecast of 196,251 truck crossings.

Step-by-step explanation:

To calculate the 5-month weighted moving average (WMA) forecast for truck crossings and predict the number for October 2018, we will use the given weights and the number of truck crossings from the previous five months: June (193,582), July (193,504), August (207,528), and September (186,206). We assign the weights as follows: September (0.3), August (0.3), July (0.2), June (0.1), and May (0.1). The formula for WMA is:

WMA = (Weight for September × Truck Crossings in September) + (Weight for August × Truck Crossings in August) + (Weight for July × Truck Crossings in July) + (Weight for June × Truck Crossings in June) + (Weight for May × Truck Crossings in May)

Substituting the values gives us:

WMA = (0.3 × 186,206) + (0.3 × 207,528) + (0.2 × 193,504) + (0.1 × 193,582) + (0.1 × 200,723)

WMA = (55,862) + (62,258) + (38,701) + (19,358) + (20,072)

WMA = 196,251

Therefore, the forecast for truck crossings for October 2018 is 196,251, after rounding to the nearest whole number.

User Xerkus
by
7.3k points