Question: Perform an ABC analysis for the data provided in the table below. Item Annual Usage Unit value 1 35,000 $35.35 2 13,260 $5.45 3 25,000

Perform an ABC analysis for the data provided in the table below.

Item

Annual Usage

Unit value

1

35,000

$35.35

2

13,260

$5.45

3

25,000

$56.45

4

4,500

$71.58

5

35,000

$15.75

6

76,000

$5.16

7

65,450

$75.69

8

136,200

$31.40

9

52,000

$2.36

10

21,300

$8.65

11

5,600

$75.30

12

7,500

$45.20

Consider the ABC classification cutoffs provided in the table below.

ABC classification cutoffs

A

65%

B

95%

C

100%

Complete the table below. Do not round intermediate calculations. Round your answers to two decimal places.

Projected

Cumulative

Cumulative

Cumulative

Dollar Usage

Dollar

Percent

Percent

ABC

Item

Annual

Usage

of Total

of Items

Classification

-Select-123456789101112Item 1

$

$

%

%

-Select-ABCItem 6

-Select-123456789101112Item 7

$

$

%

%

-Select-ABCItem 12

-Select-123456789101112Item 13

$

$

%

%

-Select-ABCItem 18

-Select-123456789101112Item 19

$

$

%

%

-Select-ABCItem 24

-Select-123456789101112Item 25

$

$

%

%

-Select-ABCItem 30

-Select-123456789101112Item 31

$

$

%

%

-Select-ABCItem 36

-Select-123456789101112Item 37

$

$

%

%

-Select-ABCItem 42

-Select-123456789101112Item 43

$

$

%

%

-Select-ABCItem 48

-Select-123456789101112Item 49

$

$

%

%

-Select-ABCItem 54

-Select-123456789101112Item 55

$

$

%

%

-Select-ABCItem 60

-Select-123456789101112Item 61

$

$

%

%

-Select-ABCItem 66

-Select-123456789101112Item 67

$

$

%

%

-Select-ABCItem 72

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!