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?

How would I solve this using Microsoft excel? M93. The finished goods

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

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 Mathematics Questions!