a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Develop an A-B-C classification for these items. b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. C. Determine the percentage of items in each category and the annual dollar value for each category for pan b.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 13, Problem 2P

a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Develop an A-B-C classification for these items.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 1

b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 2

C. Determine the percentage of items in each category and the annual dollar value for each category for pan b.

a)

Expert Solution

Summary Introduction

To determine: ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 1.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Unit Cost	Usage	Annual dollar value
K34	$10	200	$2,000
K35	25	600	$15,000
K36	36	150	$5,400
M10	16	25	$400
M20	20	80	$1,600
Z45	80	200	$16,000
F14	20	300	$6,000
F95	30	800	$24,000
F99	20	60	$1,200
D45	10	550	$5,500
D48	12	90	$1,080
D52	15	110	$1,650
D57	40	120	$4,800
N08	30	40	$1,200
P05	16	500	$8,000
P09	10	30	$300
		Total	$94,130

The annual dollar value is the product of unit cost and annual volume. For K34, the product of $10 and 200 gives $2,000 which is the dollar value for K34 and same procedure is followed for others items and the sum accounts to $94,130.

Step 2: Classification of items

Item	Unit Cost	Usage	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
F95	30	800	$24,000	A	18.75%	58.43%
Z45	80	200	$16,000
K35	25	600	$15,000
P05	16	500	$8,000	B	31.25%	31.55%
F14	20	300	$6,000
D45	10	550	$5,500
K36	36	150	$5,400
D57	40	120	$4,800
K34	$10	200	$2,000	C	50.00%	10.02%
D52	15	110	$1,650
M20	20	80	$1,600
F99	20	60	$1,200
N08	30	40	$1,200
D48	12	90	$1,080
M10	16	25	$400
P09	10	30	$300
		Total	$94,130

Table 1

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 1

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 1.

Hence, ABC classification of items is shown in table 1.

b)

Expert Solution

Summary Introduction

To determine:ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 2.

Explanation of Solution

Item	Usage	Unit Cost
4021	90	$1,400
9402	300	12
4066	30	700
6500	150	20
9280	10	1,020
4050	80	140
6850	2,000	10
3010	400	20
4400	5,000	5

Given information:

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Usage	Unit Cost	Annual dollar value
4021	90	$1,400	$126,000
9402	300	12	$3,600
4066	30	700	$21,000
6500	150	20	$3,000
9280	10	1,020	$10,200
4050	80	140	$11,200
6850	2,000	10	$20,000
3010	400	20	$8,000
4400	5,000	5	$25,000
		Total	$228,000

The annual dollar value is the product of unit cost and annual volume. For item 4021, the product of 90 and $1400 gives $126,000 which is the dollar value for item 4021 and same procedure is followed for others items and the sum accounts to $228,000.

Step 2: Classification of items:

Item	Usage	Unit Cost	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
4021	90	$1,400	$126,000	A	11.11%	55.26%
4400	5,000	5	$25,000	B	33.33%	28.95%
4066	30	700	$21,000
6850	2,000	10	$20,000
4050	80	140	$11,200	C	55.56%	15.79%
9280	10	1,020	$10,200
3010	400	20	$8,000
9402	300	12	$3,600
6500	150	20	$3,000
		Total	$228,000

Table 2

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 2

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 2.

Hence, ABC classification of items is shown in table 2.

c)

Expert Solution

Summary Introduction

To determine: The percentage of items in each category and their respective annual dollar value.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

The percentage of items in each category and their respective annual dollar value is shown in table 2.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Percentage of items in each category and their respective annual dollar value:

The percentage of items in each category and their respective annual dollar values are computed and shown in the classification table which is table 2.

Hence, the percentage of items in each category and their respective annual dollar value is shown in table 2,

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

6:35 nvas.liberty.edu < 72% i You must post before seeing replies. Edit history will be available to instructors. ☑ Due Feb 13 33 Replies (33) 50 points Discussion Thread: How to Look at the Bible After reading the assigned chapters in Everyday Bible Study (Chapters 1-5), create a learning log that lists 10 quotes from the assigned reading that highlight either a concept that resonated with you or a concept that represents new learning for you. Following each of these quotes, you must provide a 3-5 sentence explanation of how the selected quote represents either what resonated with you or this new learning. For an example of this type of thread, please see the provided example. Pleas ◄ Previous cussion Assignment instructions ✓ and the ||| Next ▸

Do a report to promote an innovative product/service within an organization of your choice. In your assignment, you need to focus on the below: 1. Give a brief introduction of the innovative product/service you are thinking about within an organization of your choice. 2. Analyze how you are going to promote your idea internally to your colleagues (e.g. meetings, presenting and disseminating the information). 3. Explain how you are going to convince them that this product/service is applicable and that it will create a competitive advantage in the market. 4. Refer to a similar product/service that your competitors have and analyze how the competitors’ product can be considered as a threat to your new product/service. 5. Estimate how much will the whole procedure cost to the business. 6. In your conclusions, describe how the new product/service will influence the whole organization’s environment. 3000 words and include and introducion, conclusion and references.

For my learning and not a assignment question: Tesla, the U.S. electric vehicle manufacturer, has recently proposed to join Indonesia’s initiative to develop an EV battery supply chain within the country. This information was shared by a senior Indonesian government official, who noted that the government received Tesla's proposal on Thursday. Indonesia, known for its rich nickel reserves, is already in discussions with companies like China's Contemporary Amperex Technology (CATL) and South Korea's LG Chem to establish a comprehensive EV battery supply chain that covers everything from raw materials to the final product. Sepian Hari Seto, the deputy for investment and mining at the Coordinating Ministry of Maritime Affairs and Investment, expressed enthusiasm for Tesla's advanced lithium battery technology. He conveyed that the collaboration with Tesla, along with CATL and LG, presents a valuable opportunity for technology transfer and learning. Furthermore, Seto mentioned the…

Answer 2

Textbook Question

Chapter 13, Problem 2P

a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Develop an A-B-C classification for these items.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 1

b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 2

C. Determine the percentage of items in each category and the annual dollar value for each category for pan b.

a)

Expert Solution

Summary Introduction

To determine: ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 1.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Unit Cost	Usage	Annual dollar value
K34	$10	200	$2,000
K35	25	600	$15,000
K36	36	150	$5,400
M10	16	25	$400
M20	20	80	$1,600
Z45	80	200	$16,000
F14	20	300	$6,000
F95	30	800	$24,000
F99	20	60	$1,200
D45	10	550	$5,500
D48	12	90	$1,080
D52	15	110	$1,650
D57	40	120	$4,800
N08	30	40	$1,200
P05	16	500	$8,000
P09	10	30	$300
		Total	$94,130

The annual dollar value is the product of unit cost and annual volume. For K34, the product of $10 and 200 gives $2,000 which is the dollar value for K34 and same procedure is followed for others items and the sum accounts to $94,130.

Step 2: Classification of items

Item	Unit Cost	Usage	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
F95	30	800	$24,000	A	18.75%	58.43%
Z45	80	200	$16,000
K35	25	600	$15,000
P05	16	500	$8,000	B	31.25%	31.55%
F14	20	300	$6,000
D45	10	550	$5,500
K36	36	150	$5,400
D57	40	120	$4,800
K34	$10	200	$2,000	C	50.00%	10.02%
D52	15	110	$1,650
M20	20	80	$1,600
F99	20	60	$1,200
N08	30	40	$1,200
D48	12	90	$1,080
M10	16	25	$400
P09	10	30	$300
		Total	$94,130

Table 1

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 1

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 1.

Hence, ABC classification of items is shown in table 1.

b)

Expert Solution

Summary Introduction

To determine:ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 2.

Explanation of Solution

Item	Usage	Unit Cost
4021	90	$1,400
9402	300	12
4066	30	700
6500	150	20
9280	10	1,020
4050	80	140
6850	2,000	10
3010	400	20
4400	5,000	5

Given information:

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Usage	Unit Cost	Annual dollar value
4021	90	$1,400	$126,000
9402	300	12	$3,600
4066	30	700	$21,000
6500	150	20	$3,000
9280	10	1,020	$10,200
4050	80	140	$11,200
6850	2,000	10	$20,000
3010	400	20	$8,000
4400	5,000	5	$25,000
		Total	$228,000

The annual dollar value is the product of unit cost and annual volume. For item 4021, the product of 90 and $1400 gives $126,000 which is the dollar value for item 4021 and same procedure is followed for others items and the sum accounts to $228,000.

Step 2: Classification of items:

Item	Usage	Unit Cost	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
4021	90	$1,400	$126,000	A	11.11%	55.26%
4400	5,000	5	$25,000	B	33.33%	28.95%
4066	30	700	$21,000
6850	2,000	10	$20,000
4050	80	140	$11,200	C	55.56%	15.79%
9280	10	1,020	$10,200
3010	400	20	$8,000
9402	300	12	$3,600
6500	150	20	$3,000
		Total	$228,000

Table 2

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 2

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 2.

Hence, ABC classification of items is shown in table 2.

c)

Expert Solution

Summary Introduction

To determine: The percentage of items in each category and their respective annual dollar value.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

The percentage of items in each category and their respective annual dollar value is shown in table 2.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Percentage of items in each category and their respective annual dollar value:

The percentage of items in each category and their respective annual dollar values are computed and shown in the classification table which is table 2.

Hence, the percentage of items in each category and their respective annual dollar value is shown in table 2,

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 13, Problem 2P

a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Develop an A-B-C classification for these items.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 1

b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 2

C. Determine the percentage of items in each category and the annual dollar value for each category for pan b.

a)

Expert Solution

Summary Introduction

To determine: ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 1.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Unit Cost	Usage	Annual dollar value
K34	$10	200	$2,000
K35	25	600	$15,000
K36	36	150	$5,400
M10	16	25	$400
M20	20	80	$1,600
Z45	80	200	$16,000
F14	20	300	$6,000
F95	30	800	$24,000
F99	20	60	$1,200
D45	10	550	$5,500
D48	12	90	$1,080
D52	15	110	$1,650
D57	40	120	$4,800
N08	30	40	$1,200
P05	16	500	$8,000
P09	10	30	$300
		Total	$94,130

The annual dollar value is the product of unit cost and annual volume. For K34, the product of $10 and 200 gives $2,000 which is the dollar value for K34 and same procedure is followed for others items and the sum accounts to $94,130.

Step 2: Classification of items

Item	Unit Cost	Usage	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
F95	30	800	$24,000	A	18.75%	58.43%
Z45	80	200	$16,000
K35	25	600	$15,000
P05	16	500	$8,000	B	31.25%	31.55%
F14	20	300	$6,000
D45	10	550	$5,500
K36	36	150	$5,400
D57	40	120	$4,800
K34	$10	200	$2,000	C	50.00%	10.02%
D52	15	110	$1,650
M20	20	80	$1,600
F99	20	60	$1,200
N08	30	40	$1,200
D48	12	90	$1,080
M10	16	25	$400
P09	10	30	$300
		Total	$94,130

Table 1

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 1

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 1.

Hence, ABC classification of items is shown in table 1.

b)

Expert Solution

Summary Introduction

To determine:ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 2.

Explanation of Solution

Item	Usage	Unit Cost
4021	90	$1,400
9402	300	12
4066	30	700
6500	150	20
9280	10	1,020
4050	80	140
6850	2,000	10
3010	400	20
4400	5,000	5

Given information:

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Usage	Unit Cost	Annual dollar value
4021	90	$1,400	$126,000
9402	300	12	$3,600
4066	30	700	$21,000
6500	150	20	$3,000
9280	10	1,020	$10,200
4050	80	140	$11,200
6850	2,000	10	$20,000
3010	400	20	$8,000
4400	5,000	5	$25,000
		Total	$228,000

The annual dollar value is the product of unit cost and annual volume. For item 4021, the product of 90 and $1400 gives $126,000 which is the dollar value for item 4021 and same procedure is followed for others items and the sum accounts to $228,000.

Step 2: Classification of items:

Item	Usage	Unit Cost	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
4021	90	$1,400	$126,000	A	11.11%	55.26%
4400	5,000	5	$25,000	B	33.33%	28.95%
4066	30	700	$21,000
6850	2,000	10	$20,000
4050	80	140	$11,200	C	55.56%	15.79%
9280	10	1,020	$10,200
3010	400	20	$8,000
9402	300	12	$3,600
6500	150	20	$3,000
		Total	$228,000

Table 2

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 2

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 2.

Hence, ABC classification of items is shown in table 2.

c)

Expert Solution

Summary Introduction

To determine: The percentage of items in each category and their respective annual dollar value.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

The percentage of items in each category and their respective annual dollar value is shown in table 2.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Percentage of items in each category and their respective annual dollar value:

The percentage of items in each category and their respective annual dollar values are computed and shown in the classification table which is table 2.

Hence, the percentage of items in each category and their respective annual dollar value is shown in table 2,

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 13, Problem 2P

a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Develop an A-B-C classification for these items.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 1

b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage.

Chapter 13, Problem 2P, a. The following table contains figures on the monthly volume and unit costs for a random sample of , example 2

C. Determine the percentage of items in each category and the annual dollar value for each category for pan b.

a)

Expert Solution

Summary Introduction

To determine: ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 1.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Unit Cost	Usage	Annual dollar value
K34	$10	200	$2,000
K35	25	600	$15,000
K36	36	150	$5,400
M10	16	25	$400
M20	20	80	$1,600
Z45	80	200	$16,000
F14	20	300	$6,000
F95	30	800	$24,000
F99	20	60	$1,200
D45	10	550	$5,500
D48	12	90	$1,080
D52	15	110	$1,650
D57	40	120	$4,800
N08	30	40	$1,200
P05	16	500	$8,000
P09	10	30	$300
		Total	$94,130

The annual dollar value is the product of unit cost and annual volume. For K34, the product of $10 and 200 gives $2,000 which is the dollar value for K34 and same procedure is followed for others items and the sum accounts to $94,130.

Step 2: Classification of items

Item	Unit Cost	Usage	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
F95	30	800	$24,000	A	18.75%	58.43%
Z45	80	200	$16,000
K35	25	600	$15,000
P05	16	500	$8,000	B	31.25%	31.55%
F14	20	300	$6,000
D45	10	550	$5,500
K36	36	150	$5,400
D57	40	120	$4,800
K34	$10	200	$2,000	C	50.00%	10.02%
D52	15	110	$1,650
M20	20	80	$1,600
F99	20	60	$1,200
N08	30	40	$1,200
D48	12	90	$1,080
M10	16	25	$400
P09	10	30	$300
		Total	$94,130

Table 1

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 1

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 1.

Hence, ABC classification of items is shown in table 1.

b)

Expert Solution

Summary Introduction

To determine:ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 2.

Explanation of Solution

Item	Usage	Unit Cost
4021	90	$1,400
9402	300	12
4066	30	700
6500	150	20
9280	10	1,020
4050	80	140
6850	2,000	10
3010	400	20
4400	5,000	5

Given information:

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Usage	Unit Cost	Annual dollar value
4021	90	$1,400	$126,000
9402	300	12	$3,600
4066	30	700	$21,000
6500	150	20	$3,000
9280	10	1,020	$10,200
4050	80	140	$11,200
6850	2,000	10	$20,000
3010	400	20	$8,000
4400	5,000	5	$25,000
		Total	$228,000

The annual dollar value is the product of unit cost and annual volume. For item 4021, the product of 90 and $1400 gives $126,000 which is the dollar value for item 4021 and same procedure is followed for others items and the sum accounts to $228,000.

Step 2: Classification of items:

Item	Usage	Unit Cost	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
4021	90	$1,400	$126,000	A	11.11%	55.26%
4400	5,000	5	$25,000	B	33.33%	28.95%
4066	30	700	$21,000
6850	2,000	10	$20,000
4050	80	140	$11,200	C	55.56%	15.79%
9280	10	1,020	$10,200
3010	400	20	$8,000
9402	300	12	$3,600
6500	150	20	$3,000
		Total	$228,000

Table 2

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 2

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 2.

Hence, ABC classification of items is shown in table 2.

c)

Expert Solution

Summary Introduction

To determine: The percentage of items in each category and their respective annual dollar value.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

The percentage of items in each category and their respective annual dollar value is shown in table 2.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Percentage of items in each category and their respective annual dollar value:

The percentage of items in each category and their respective annual dollar values are computed and shown in the classification table which is table 2.

Hence, the percentage of items in each category and their respective annual dollar value is shown in table 2,

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

a)

Expert Solution

Summary Introduction

To determine: ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 1.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Unit Cost	Usage	Annual dollar value
K34	$10	200	$2,000
K35	25	600	$15,000
K36	36	150	$5,400
M10	16	25	$400
M20	20	80	$1,600
Z45	80	200	$16,000
F14	20	300	$6,000
F95	30	800	$24,000
F99	20	60	$1,200
D45	10	550	$5,500
D48	12	90	$1,080
D52	15	110	$1,650
D57	40	120	$4,800
N08	30	40	$1,200
P05	16	500	$8,000
P09	10	30	$300
		Total	$94,130

The annual dollar value is the product of unit cost and annual volume. For K34, the product of $10 and 200 gives $2,000 which is the dollar value for K34 and same procedure is followed for others items and the sum accounts to $94,130.

Step 2: Classification of items

Item	Unit Cost	Usage	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
F95	30	800	$24,000	A	18.75%	58.43%
Z45	80	200	$16,000
K35	25	600	$15,000
P05	16	500	$8,000	B	31.25%	31.55%
F14	20	300	$6,000
D45	10	550	$5,500
K36	36	150	$5,400
D57	40	120	$4,800
K34	$10	200	$2,000	C	50.00%	10.02%
D52	15	110	$1,650
M20	20	80	$1,600
F99	20	60	$1,200
N08	30	40	$1,200
D48	12	90	$1,080
M10	16	25	$400
P09	10	30	$300
		Total	$94,130

Table 1

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 1

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 1.

Hence, ABC classification of items is shown in table 1.

b)

Expert Solution

Summary Introduction

To determine:ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 2.

Explanation of Solution

Item	Usage	Unit Cost
4021	90	$1,400
9402	300	12
4066	30	700
6500	150	20
9280	10	1,020
4050	80	140
6850	2,000	10
3010	400	20
4400	5,000	5

Given information:

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Usage	Unit Cost	Annual dollar value
4021	90	$1,400	$126,000
9402	300	12	$3,600
4066	30	700	$21,000
6500	150	20	$3,000
9280	10	1,020	$10,200
4050	80	140	$11,200
6850	2,000	10	$20,000
3010	400	20	$8,000
4400	5,000	5	$25,000
		Total	$228,000

The annual dollar value is the product of unit cost and annual volume. For item 4021, the product of 90 and $1400 gives $126,000 which is the dollar value for item 4021 and same procedure is followed for others items and the sum accounts to $228,000.

Step 2: Classification of items:

Item	Usage	Unit Cost	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
4021	90	$1,400	$126,000	A	11.11%	55.26%
4400	5,000	5	$25,000	B	33.33%	28.95%
4066	30	700	$21,000
6850	2,000	10	$20,000
4050	80	140	$11,200	C	55.56%	15.79%
9280	10	1,020	$10,200
3010	400	20	$8,000
9402	300	12	$3,600
6500	150	20	$3,000
		Total	$228,000

Table 2

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 2

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 2.

Hence, ABC classification of items is shown in table 2.

c)

Expert Solution

Summary Introduction

To determine: The percentage of items in each category and their respective annual dollar value.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

The percentage of items in each category and their respective annual dollar value is shown in table 2.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Percentage of items in each category and their respective annual dollar value:

The percentage of items in each category and their respective annual dollar values are computed and shown in the classification table which is table 2.

Hence, the percentage of items in each category and their respective annual dollar value is shown in table 2,

Answer 8

a)

Expert Solution

Summary Introduction

To determine: ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 1.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Unit Cost	Usage	Annual dollar value
K34	$10	200	$2,000
K35	25	600	$15,000
K36	36	150	$5,400
M10	16	25	$400
M20	20	80	$1,600
Z45	80	200	$16,000
F14	20	300	$6,000
F95	30	800	$24,000
F99	20	60	$1,200
D45	10	550	$5,500
D48	12	90	$1,080
D52	15	110	$1,650
D57	40	120	$4,800
N08	30	40	$1,200
P05	16	500	$8,000
P09	10	30	$300
		Total	$94,130

The annual dollar value is the product of unit cost and annual volume. For K34, the product of $10 and 200 gives $2,000 which is the dollar value for K34 and same procedure is followed for others items and the sum accounts to $94,130.

Step 2: Classification of items

Item	Unit Cost	Usage	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
F95	30	800	$24,000	A	18.75%	58.43%
Z45	80	200	$16,000
K35	25	600	$15,000
P05	16	500	$8,000	B	31.25%	31.55%
F14	20	300	$6,000
D45	10	550	$5,500
K36	36	150	$5,400
D57	40	120	$4,800
K34	$10	200	$2,000	C	50.00%	10.02%
D52	15	110	$1,650
M20	20	80	$1,600
F99	20	60	$1,200
N08	30	40	$1,200
D48	12	90	$1,080
M10	16	25	$400
P09	10	30	$300
		Total	$94,130

Table 1

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 1

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 1.

Hence, ABC classification of items is shown in table 1.

Answer 9

a)

Expert Solution

Answer 10

a)

Expert Solution

Answer 11

Expert Solution

Answer 12

Summary Introduction

To determine: ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer 13

Answer to Problem 2P

ABC classification of items is shown in table 1.

Answer 14

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Unit Cost	Usage	Annual dollar value
K34	$10	200	$2,000
K35	25	600	$15,000
K36	36	150	$5,400
M10	16	25	$400
M20	20	80	$1,600
Z45	80	200	$16,000
F14	20	300	$6,000
F95	30	800	$24,000
F99	20	60	$1,200
D45	10	550	$5,500
D48	12	90	$1,080
D52	15	110	$1,650
D57	40	120	$4,800
N08	30	40	$1,200
P05	16	500	$8,000
P09	10	30	$300
		Total	$94,130

The annual dollar value is the product of unit cost and annual volume. For K34, the product of $10 and 200 gives $2,000 which is the dollar value for K34 and same procedure is followed for others items and the sum accounts to $94,130.

Step 2: Classification of items

Item	Unit Cost	Usage	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
F95	30	800	$24,000	A	18.75%	58.43%
Z45	80	200	$16,000
K35	25	600	$15,000
P05	16	500	$8,000	B	31.25%	31.55%
F14	20	300	$6,000
D45	10	550	$5,500
K36	36	150	$5,400
D57	40	120	$4,800
K34	$10	200	$2,000	C	50.00%	10.02%
D52	15	110	$1,650
M20	20	80	$1,600
F99	20	60	$1,200
N08	30	40	$1,200
D48	12	90	$1,080
M10	16	25	$400
P09	10	30	$300
		Total	$94,130

Table 1

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 1

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 1.

Hence, ABC classification of items is shown in table 1.

Answer 15

b)

Expert Solution

Summary Introduction

To determine:ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

ABC classification of items is shown in table 2.

Explanation of Solution

Item	Usage	Unit Cost
4021	90	$1,400
9402	300	12
4066	30	700
6500	150	20
9280	10	1,020
4050	80	140
6850	2,000	10
3010	400	20
4400	5,000	5

Given information:

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Usage	Unit Cost	Annual dollar value
4021	90	$1,400	$126,000
9402	300	12	$3,600
4066	30	700	$21,000
6500	150	20	$3,000
9280	10	1,020	$10,200
4050	80	140	$11,200
6850	2,000	10	$20,000
3010	400	20	$8,000
4400	5,000	5	$25,000
		Total	$228,000

The annual dollar value is the product of unit cost and annual volume. For item 4021, the product of 90 and $1400 gives $126,000 which is the dollar value for item 4021 and same procedure is followed for others items and the sum accounts to $228,000.

Step 2: Classification of items:

Item	Usage	Unit Cost	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
4021	90	$1,400	$126,000	A	11.11%	55.26%
4400	5,000	5	$25,000	B	33.33%	28.95%
4066	30	700	$21,000
6850	2,000	10	$20,000
4050	80	140	$11,200	C	55.56%	15.79%
9280	10	1,020	$10,200
3010	400	20	$8,000
9402	300	12	$3,600
6500	150	20	$3,000
		Total	$228,000

Table 2

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 2

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 2.

Hence, ABC classification of items is shown in table 2.

Answer 16

b)

Expert Solution

Answer 17

b)

Expert Solution

Answer 18

Expert Solution

Answer 19

Summary Introduction

To determine:ABC classification for the items.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer 20

Answer to Problem 2P

ABC classification of items is shown in table 2.

Answer 21

Explanation of Solution

Item	Usage	Unit Cost
4021	90	$1,400
9402	300	12
4066	30	700
6500	150	20
9280	10	1,020
4050	80	140
6850	2,000	10
3010	400	20
4400	5,000	5

Given information:

Calculation for ABC classification:

Step 1: Calculation of annual dollar value

Item	Usage	Unit Cost	Annual dollar value
4021	90	$1,400	$126,000
9402	300	12	$3,600
4066	30	700	$21,000
6500	150	20	$3,000
9280	10	1,020	$10,200
4050	80	140	$11,200
6850	2,000	10	$20,000
3010	400	20	$8,000
4400	5,000	5	$25,000
		Total	$228,000

The annual dollar value is the product of unit cost and annual volume. For item 4021, the product of 90 and $1400 gives $126,000 which is the dollar value for item 4021 and same procedure is followed for others items and the sum accounts to $228,000.

Step 2: Classification of items:

Item	Usage	Unit Cost	Annual dollar value	Category	Percentage of items	Percentage of annual dollar value
4021	90	$1,400	$126,000	A	11.11%	55.26%
4400	5,000	5	$25,000	B	33.33%	28.95%
4066	30	700	$21,000
6850	2,000	10	$20,000
4050	80	140	$11,200	C	55.56%	15.79%
9280	10	1,020	$10,200
3010	400	20	$8,000
9402	300	12	$3,600
6500	150	20	$3,000
		Total	$228,000

Table 2

Excel Worksheet:

OPERATIONS MANAGEMENT W/ CNCT+, Chapter 13, Problem 2P , additional homework tip 2

The items are classified based on their percentage of dollar value where 10-15% are classified as A items and 50% are classified as B items and lowest value are classified as C item which is shown in table 2.

Hence, ABC classification of items is shown in table 2.

Answer 22

c)

Expert Solution

Summary Introduction

To determine: The percentage of items in each category and their respective annual dollar value.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer to Problem 2P

The percentage of items in each category and their respective annual dollar value is shown in table 2.

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Percentage of items in each category and their respective annual dollar value:

The percentage of items in each category and their respective annual dollar values are computed and shown in the classification table which is table 2.

Hence, the percentage of items in each category and their respective annual dollar value is shown in table 2,

Answer 23

c)

Expert Solution

Answer 24

c)

Expert Solution

Answer 25

Expert Solution

Answer 26

Summary Introduction

To determine: The percentage of items in each category and their respective annual dollar value.

Introduction: Inventory is a stock or store of goods. Every company store lots of goods as inventory which will be used during replenishment periods. Management of inventory is so much essential to manage cost and also to reduce cost.

Answer 27

Answer to Problem 2P

The percentage of items in each category and their respective annual dollar value is shown in table 2.

Answer 28

Explanation of Solution

Given information:

Item	Unit Cost	Usage
K34	$10	200
K35	25	600
K36	36	150
M10	16	25
M20	20	80
Z45	80	200
F14	20	300
F95	30	800
F99	20	60
D45	10	550
D48	12	90
D52	15	110
D57	40	120
N08	30	40
P05	16	500
P09	10	30

Percentage of items in each category and their respective annual dollar value:

The percentage of items in each category and their respective annual dollar values are computed and shown in the classification table which is table 2.

Hence, the percentage of items in each category and their respective annual dollar value is shown in table 2,