I am working on inventory PAR level project. I have data from the last 3 months and need to determine what the PAR levels should be to ensure that there is never shortage or an overstocking issue. I have the data from all 3 months on one worksheet but want to be able to place on another worksheet - can someone help - PLEASE!!
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col></colgroup>
Location | Month | D/Wk | Bus. Day | Date | Item ID | Description | Size | Item Number | Quantity |
2 | Sep | Tue | 2 | 9/3/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Sep | Wed | 3 | 9/4/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
1 | Sep | Thu | 4 | 9/5/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Oct | Mon | 5 | 9/6/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 60 |
1 | Oct | Mon | 5 | 9/6/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Sep | Mon | 6 | 9/9/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Sep | Tue | 7 | 9/10/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 14 |
2 | Sep | Tue | 7 | 9/10/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Nov | Wed | 8 | 9/11/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 60 |
1 | Nov | Wed | 8 | 9/11/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
1 | Sep | Thu | 9 | 9/12/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Sep | Mon | 11 | 9/16/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 60 |
2 | Sep | Mon | 11 | 9/16/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Nov | Tue | 12 | 9/17/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Sep | Wed | 13 | 9/18/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
1 | Sep | Thu | 14 | 9/19/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
1 | Sep | Fri | 15 | 9/20/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Oct | Wed | 2 | 10/2/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Oct | Fri | 4 | 10/4/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 60 |
2 | Oct | Sat | Weekend | 10/5/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
1 | Oct | Tue | 6 | 10/8/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 60 |
2 | Oct | Mon | 5 | 10/7/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 30 |
2 | Oct | Mon | 5 | 10/7/2013 | TOY123 | TOY-BABY BOY | SMALL | 59148000813 | 45 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col></colgroup>