For the following problem, you can use Excel or a calculator to obtain the results for each question. I suggest using Excel, as it will save you a lot of time.

Problem and Data

In order to analyze her inventory position, a material management V$.$P$.$ is studying inventory levels. This sample of $12$ months has inventory levels by month as shown below starting with January.

By Month

$38$

$44$

$44$

$46$

$51$

$54$

$58$

$60$

$66$

$77$

$77$

$84$