Populate the cells C$3$ to D$10($yellow$)$ cells with the values provided in the problem below.

Populate the cells E$3$ to F$12$ and C$11$ to D$12$ with the appropriate formulas using

absolute address and excel command $=$POWER$($X$,$n$)$ where X$=$ difference between the mean value and the weekly value

Finally, enter the appropriate formula in G$12$ to calculate the bullwhip measure.

Is Michael's Metals contributing to the bullwhip effect in its supply chain? Yes$/$No $-->$

Over the past $10$ weeks, demand for gears at Michael$$s Metals has been $315,517,225,262,247,495,450$ and $400.$

Michael has placed weekly orders of $315,562,202,427,315,540,427$ and $378$ units.

Each type of formula will earn $2$ points $($total of $10$ points$)$ while the final answer if Michael's Metals is contributing to the bullwhip effect is another $2$ points.