Download the Excel file which contains data from a Beer Game played by a team of students in a previous semester of the course and answer the following question.

Calculate the mean $($or average$)$ of the order values over the $30-$week period for each player in the supply chain $($plus the end consumer$).$ Which statement is true about mean numbers?

The mean order values are decreasing from upstream to downstream the supply chain, indicating that there is a bullwhip effect.

In theory, in the long run, the numbers should be the same. The reason they are not the same is because the players ended the game with different amounts of end inventory.

The mean order values are neither increasing nor decreasing from upstream to downstream the supply chain indicating that the players in this game greatly overreacted to stockouts.

The mean order values are decreasing from upstream to downstream the supply chain, indicating that there is not a bullwhip effect.