Inventory PAR Levels

[kjdowden]

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!!

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>