The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. The bakery collected sales data from the past week:


Day 1 50 rolls sold

Day 2 50 rolls sold

Day 3 48 rolls sold

Day 4 60 rolls sold

Day 5 53 rolls sold

Day 6 60 rolls sold


What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2?


A) 51.4 B) 53.4 C) 58.6 D) None of the above

Respuesta :

The value of F6, if they use a 3- day weighted moving average is 53.4.

Explanation:

From the given data,  the weighted moving average is

W1 = 0.6

W2 = 0.2

W3 = 0.2

To find the value of F6, the 3-day weighted moving average is used

The formula used to calculate is, where W is the weighted moving average and D is the days sold.

 =  W1 D1 + W2 D2 + W3 D3

 = 0.6 (53) + 0.2(50) + 0.2(48)

 = 53.4

Thus the value of F6 is 53.4.