Problem $1$: ABC Classification System $(10$ marks$)$

Apply an ABC classification system to the inventory items listed in the file $$Inventory Data.xls$.$

Attach the full Excel worksheet that you created to assign SKUs to the various categories.

Explain specifically how you established your cut$-$offs for the inventory categories.

Suppose that SKU #$3161$ currently has only $100$ units in inventory. This item is not too costly$,$

yet the inventory on hand is very low. The supplier has an erratic delivery history, and the

reorder lead time is very long. A lot of $1,250$ units has been on order for some time and is now

several days past due. Discuss how you propose to manage this particular SKUProblem $1$: ABC Classification System $(10$ marks$)$

Apply an ABC classification system to the inventory items listed in the file $$Inventory Data.xls$.$

Attach the full Excel worksheet that you created to assign SKUs to the various categories.

Explain specifically how you established your cut$-$offs for the inventory categories.

Suppose that SKU #$3161$ currently has only $100$ units in inventory. This item is not too costly$,$

yet the inventory on hand is very low. The supplier has an erratic delivery history, and the

reorder lead time is very long. A lot of $1,250$ units has been on order for some time and is now

several days past due. Discuss how you propose to manage this particular SKU