CAM32 Reorder Point Calculation

		CALCULATE REORDER POINT/MAXIMUM STOCKING LEVEL REPORT												PAGE 1
VENDOR RANGE : 0 - 9999						01/01/98
LAST MONTH END: 12/31/97					CALCULATE REORDER POINTS
**CHANGES WERE NOT POSTED**
ITEM NUMBER	DESCRIPTION		MAX	OLD  ROP	NEW  ROP	MTD SALES	LMO SALES	YTD SALES	U/M	CASE QTY	UNIT  COST	PROT ROP	UNITS PER/WK	WKS	CHG
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1000	BAG "O" GLASS	RED SML	14	10	4	0	8	0	EA	1	3.000	N	.89	5	-
1001	BAG "O" GLASS	BLUSML	10	5	6	0	1	0	EA	1	3.000	N	1.19	5	+
1002	BAG "O" GLASS	GRN SML	2	1	1*	0	1	0	EA	1	3.000	N	.08	5	+
2000	ST SPLITTER		8	6	2	0	2	0	EA	1	3.000	N	.49	5	-
2001	SY SPLITTER		4	3	1	0	1	0	EA	1	3.000	N	.21	5	-
3000	ROAD RANGER	BLU	4	3	1	0	1	0	EA	1	12.000	N	.22	5	-
3001	ROAD RANGER	RED	11	7	3	0	2	0	EA	1	12.000	N	.60	5	-
3002	ROAD RANGER	GRN	2	1	1*	0	1	0	EA	1	12.000	N	.05	5	-
3003	ROAD RANGER	BLK	2	2	1	0	2	0	EA	1	12.000	N	.16	5	-
3004	ROAD RANGER	WHT	12	4	9	0	10	0	EA	1	12.000	N	1.70	5	+
3100	POLAR CAP	WHT 1'	12	6	11	0	12	0	EA	1	9.000	N	2.21	5	+
3101	POLAR CAP	WHT 2'	3	2	1	0	2	0	EA	1	11.000	N	.22	5	-
3102	POLAR CAP	WHT 4'	5	4	2	0	2	0	EA	1	16.000	N	.32	5	-
3103	POLAR CAP	WHT 6'	3	1	1*	0	1	0	EA	1	20.000	N	.08	5	-
3104	POLAR CAP	WHT 8'	4	2	1*	0	1	0	EA	1	25.000	N	.08	5	-
3200	RAINMAKER II	WHT REG	24	12	11	0	10	0	EA	1	17.500	N	2.28	5	-
3201	RAINMAKER II	WHT LRG	14	10	4	0	4	0	EA	1	19.500	N	.84	5	-
3202	RAINMAKER II	BLK REG	18	6	5	0	5	0	EA	1	17.500	N	1.08	5	-
3203	RAINMAKER II	BLK LRG	3	2	1	0	1	0	EA	1	19.500	N	.16	5	-
3204	RAINMAKER II	TAN REG	12	6	8	0	7	0	EA	1	17.500	N	1.56	5	+
3205	RAINMAKER II	TAN LRG	6	4	2	0	2	0	EA	1	19.500	N	.36	5	-

 

MAXIMUM INVENTORY VALUE AT NEW REORDER POINT	965.50
MAXIMUM INVENTORY VALUE AT OLD REORDER POINT	1221.00
NET CHANGE	255.50-
PERCENTAGE	26.46-%

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

REPORT PARAMETERS

STARTING ITEM NUMBER:		1000		STORE LOCATION NUMBER:		1		POST CHANGES:		N
ENDING ITEM NUMBER:		3205		NO OF PURCHASE WEEKS:		5		CALCULATE:		REORDER POINT

PERCENTAGE WEIGHTED FACTORS FOR THE LAST 12 MONTH SALES

1. DEC	8%	3. OCT	8%	5. AUG	8%	7. JUN	8%	9. APR	8%	11. FEB	8%
2. NOV	8%	4. SEPT	8%	6. JUL	8%	8. MAY	8%	10. MAR	8%	12 JAN	8%

NOTE: AN (*) APPEARING NEXT TO THE NEW STOCKING LEVEL INDICATED THAT THE PROGRAM CALCULATED ZERO BUT HAS SET IT TO 1 INSTEAD,

SO AS NOT TO CLOSE OUT THE ITEM.