Question: Problem 6 : ABC Analysis A company is preparing for a cycle count of its inventory. The company's ERP inventory report showed the following values

Problem 6: ABC Analysis
A company is preparing for a cycle count of its inventory. The company's ERP inventory report showed the following values for the products under review.
\table[[Item No.,Item Cost,No. in Stock,Revenues,Revenue %,],[CD-143,17.00,587,,,],[FR-46,1,500.00,25,,,],[GP-123,63.00,635,$40,005.00,1.7%,],[MPZ-65,300.00,12,$3,600.00,0.2%,],[NWM-8,657.75,2,050,$1,348,387.50,58.0%,],[KL-35,2,525.00,39,$98,475.00,4.2%,],[PF-18,789.99,353,$278,866.47,12.0%,],[RD-82,850.00,79,$67,150.00,2.9%,],[ZW-6,37.99,629,$23,895.71,1.0%,],[CP-40,5,000.00,7,$35,000.00,1.5%,],[Bx-2,7.50,7,506,$56,295.00,2.4%,],[LG-94,75.00,1,200,$90,000.00,3.9%,],[WU-09,22.5,2,364,$53,190.00,2.3%,],[TY-187,325.00,46,$14,950.00,0.6%,],[QX-22,196.99,851,$166,787.49,7.2%,],[Totals,,,,,],[,,,,,]]
Which items would you classify as being A items? As B items? As C items? Quantitatively justify your answer.
 Problem 6: ABC Analysis A company is preparing for a cycle

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!