Question: Perform an ABC analysis for the data provided in in the table below. Item Annual Usage Unit Cost 1 3,200 $13.25 2 1,650 $43.10 3

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

Item

Annual Usage

Unit Cost

1

3,200

$13.25

2

1,650

$43.10

3

560

$53.21

4

8,650

$86.35

5

7,360

$19.55

6

500

$42.30

7

3,100

$74.12

8

2,950

$2.35

9

6,870

$62.30

10

4,000

$24.30

11

5,500

$41.30

12

8,630

$0.94

13

4,230

$5.68

14

8,650

$14.23

15

860

$6.42

16

1,000

$14.35

17

2,900

$16.24

18

1,500

$8.65

19

3,650

$21.23

20

8,300

$17.25

Consider the ABC classification cutoffs provided in the table below.

ABC classification cutoffs

A

75%

B

90%

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-1234567891011121314151617181920Item 1

$

$

%

%

-Select-ABCItem 6

-Select-1234567891011121314151617181920Item 7

$

$

%

%

-Select-ABCItem 12

-Select-1234567891011121314151617181920Item 13

$

$

%

%

-Select-ABCItem 18

-Select-1234567891011121314151617181920Item 19

$

$

%

%

-Select-ABCItem 24

-Select-1234567891011121314151617181920Item 25

$

$

%

%

-Select-ABCItem 30

-Select-1234567891011121314151617181920Item 31

$

$

%

%

-Select-ABCItem 36

-Select-1234567891011121314151617181920Item 37

$

$

%

%

-Select-ABCItem 42

-Select-1234567891011121314151617181920Item 43

$

$

%

%

-Select-ABCItem 48

-Select-1234567891011121314151617181920Item 49

$

$

%

%

-Select-ABCItem 54

-Select-1234567891011121314151617181920Item 55

$

$

%

%

-Select-ABCItem 60

-Select-1234567891011121314151617181920Item 61

$

$

%

%

-Select-ABCItem 66

-Select-1234567891011121314151617181920Item 67

$

$

%

%

-Select-ABCItem 72

-Select-1234567891011121314151617181920Item 73

$

$

%

%

-Select-ABCItem 78

-Select-1234567891011121314151617181920Item 79

$

$

%

%

-Select-ABCItem 84

-Select-1234567891011121314151617181920Item 85

$

$

%

%

-Select-ABCItem 90

-Select-1234567891011121314151617181920Item 91

$

$

%

%

-Select-ABCItem 96

-Select-1234567891011121314151617181920Item 97

$

$

%

%

-Select-ABCItem 102

-Select-1234567891011121314151617181920Item 103

$

$

%

%

-Select-ABCItem 108

-Select-1234567891011121314151617181920Item 109

$

$

%

%

-Select-ABCItem 114

-Select-1234567891011121314151617181920Item 115

$

$

%

%

-Select-ABCItem 120

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!