The Grand Bakery produces 60 special sourdough rolls every day.Any rolls that are not sold each day are given to the employees.They have collected sales data from the past week: $$\begin{array} { | c | c | } \hline \text { Day } & \text { Rolls sold } \ \hline 1 & 50 \ \hline 2 & 50 \ \hline 3 & 48 \ \hline 4 & 60 \ \hline 5 & 53 \ \hline 6 & 60 \ \hline \end{array}$$ What is the value of F₆ if they use a 3-day weighted moving average with W₁ = 0.6,W₂ = 0.2,and W₃ = 0.2? A)51.4 B)53.4 C)58.6 D)None of the above

Question

Quizplus · Accepted Answer

To calculate the weighted moving average, we need to multiply the sales data by the weightage and sum them up. 
For Day 4:
WA = (0.6*48) + (0.2*50) + (0.2*50) = 28.8 + 10 + 10 = 48.8
For Day 5:
WA = (0.6*60) + (0.2*48) + (0.2*50) = 36 + 9.6 + 10 = 55.6
For Day 6:
WA = (0.6*53) + (0.2*60) + (0.2*48) = 31.8 + 12 + 9.6 = 53.4
So, the weighted moving average for Day 6 is 53.4.

The Grand Bakery Produces 60 Special Sourdough Rolls Every Day