Question: Please help me answer parts a and b using excel format. Thank you! Sarita Uribe opened a new beauty products retail store. There are numerous

Please help me answer parts a and b using excelPlease help me answer parts a and b using excel format. Thank you!

Sarita Uribe opened a new beauty products retail store. There are numerous items in inventory, and Sarita knows that there are costs associated with inventory. However, her time is limited so she cannot carefully evaluate the inventory policy for all products. Sarita wants to classify the items according to the dollars invested in them. The following table provides information about the 10 items that she carries: ITEM NUMBER UNIT COST ($) DEMAND (UNITS) E102 4. 800 D23 8 1200 D27 3 700 RO2 2 1000 R19 8 200 S107 6 500 S123 1 1200 U11 7. 800 U23 1 1500 V75 4 1500 a) Use ABC analysis to classify these items into categories A, B, and C. b) Develop a cycle policy if class A items are to be reviewed every 20 days, B items every 60 days, and C items every 120 days

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!