212k views
0 votes
The manager at a convenience store wants to forecast sales for an item THIS WEEK based on the following historical data:

WEEK ACTUAL SALES (Number of units sold)
Six weeks ago 160
Five weeks ago 320
Four weeks ago 480
Three weeks ago 640
Two weeks ago 800
One week ago 960
THIS WEEK NOT KNOWN
1. Determine the sales forecast for THIS WEEK using a 2-week moving average.

User Jonbauer
by
9.1k points

1 Answer

2 votes

Answer: Sales forecast for this week is 1,280 units

Explanation: From the above question, sales for the past six weeks has been given and from the analysis of the information given.

From the information on sales six weeks ago, we found out that the sales on was 160 units, five weeks ago was 320 units, for weeks ago was 480 units, 3 weeks ago was 640, 2 weeks ago was 800 units, 1 week ago was 960 units. from the details above, weekly sales has a moving weekly average of 160 units.

calculating the sales fro this week using a 2 week moving average is

sales for one week ago as 960 units + 160*2

= 960+320

=1,280 units

User Pawel Lesnikowski
by
8.5k points