Problem
The manager of an automobile repair shop hopes to achieve a better allocation of inventory control efforts by adopting an A-B-C approach to inventory control.
a. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage:
| Item |
Usage |
Unit Cost |
Category |
| 4021 |
90 |
$ 1,400 |
(Click to select)ABC |
| 9402 |
300 |
12 |
(Click to select)ABC |
| 4066 |
30 |
700 |
(Click to select)ABC |
| 6500 |
150 |
20 |
(Click to select)ABC |
| 9280 |
10 |
1,020 |
(Click to select)ABC |
| 4050 |
80 |
140 |
(Click to select)ABC |
| 6850 |
2,000 |
10 |
(Click to select)ABC |
| 3010 |
400 |
20 |
(Click to select)ABC |
| 4400 |
5,000 |
5 |
(Click to select)ABC |
b. Determine the percentage of items in each category and the annual dollar value for each category. (Round your answers to 1 decimal place. Omit the "%" sign in your response.)
| Category |
Percent of Items |
Percent of Total Cost |
| A |
% |
% |
| B |
% |
% |
| C |
% |
% |