Question: How would I solve this using Microsoft excel? M93. The finished goods inventory of a small manufacturing company is shown below [available in data file
How would I solve this using Microsoft excel?

M93. The finished goods inventory of a small manufacturing company is shown below [available in data file for Module 9]. Perform an ABC analysis on the data [Assign A items to a maximum of 70 % of the cumulative value and B items to a maximum of the next 20% of the cumulative value (a total of 90%).} Value units 5 125.00 mu 5 mm a} How many items are assigned as "A\" items? b] How many items are assigned as \"B\" items? c] How many items are assigned as \"C\" items? d] What assignment was made to the following items: 2456? 5995? 8989? 9034
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
