Perform an ABC analysis for the data provided in worksheet C11P4 in the OM5 Data Workbook. Clearly explain why you classified items as A, B, or C. The data set is as follows (in OM6 Data Workbook)

Data From OM5 Data Workbook:

Optional Topic (Do not recommend covering except for advanced courses
	and students but FYI; req'ds additional readings)
Safety Stock varies with the square root of the number of stocking points
	for the same service level
EOQ			62.00
Safety Stock			21.3
Q/2  + SS			52.32
No. Stock Points		Gallons	$ Ave Inv
1		52	$1,101
2		74	$1,558
3		91	$1,908
4		105	$2,203
31		291	$6,132
50		370	$7,788
100		523	$11,014
150		641	$13,489
200		740	$15,576
231		795	$16,740
Note: 231 is 215 secondary pts + 24 depts. + hospital storeroom + university storeroom
Conclusion: Additional stocking points are expensive!  So try to reduce them with
moving carts of inventory, no stock in exam rooms, only one department store room, etc.

Data From OM6 Data Workbook: