OPERATIONS MANAGEMENT W/ CNCT+
OPERATIONS MANAGEMENT W/ CNCT+
12th Edition
ISBN: 9781259574931
Author: Stevenson
Publisher: MCG CUSTOM
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
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
Check Mark
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
Check Mark
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
Check Mark
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…

Chapter 13 Solutions

OPERATIONS MANAGEMENT W/ CNCT+

Ch. 13 - What is meant by the term service level? Generally...Ch. 13 - Describe briefly the A-B-C approach to inventory...Ch. 13 - The purchasing agent for a company that assembles...Ch. 13 - Explain how a decrease in setup time can lead to a...Ch. 13 - What is the single-period model, and under what...Ch. 13 - Can the optimal stocking level in the...Ch. 13 - Prob. 17DRQCh. 13 - What trade-offs are involved in each of these...Ch. 13 - Who needs to be involved in inventory decisions...Ch. 13 - How has technology aided inventory management? How...Ch. 13 - To be competitive, many fast-food chains began to...Ch. 13 - As a supermarket manager, how would you go about...Ch. 13 - Sam is at the post office to mail a package. After...Ch. 13 - Give two examples of unethical conduct involving...Ch. 13 - Prob. 1PCh. 13 - a. The following table contains figures on the...Ch. 13 - A bakery buys flours in 25-pound bags. The bakery...Ch. 13 - A large law firm uses an average of 40 boxes of...Ch. 13 - Garden Variety Flower Shop uses 750 clay pots a...Ch. 13 - A produce distributor uses 800 packing crates a...Ch. 13 - A manager receives a forecast for next year....Ch. 13 - A food processor uses approximately 27,000 glass...Ch. 13 - The Friendly Sausage Factory (FSF) can produce hot...Ch. 13 - A chemical firm produces sodium bisulfate in...Ch. 13 - A company is about to begin production of a new...Ch. 13 - Prob. 12PCh. 13 - A mail-order house uses 18,000 boxes a year....Ch. 13 - A jewelry firm buys semiprecious stones to make...Ch. 13 - A manufacturer of exercise equipment purchases the...Ch. 13 - A company will begin stocking remote control...Ch. 13 - A manager just received a new price list from a...Ch. 13 - A newspaper publisher uses roughly 800 feet of...Ch. 13 - Given this information: Expected demand during...Ch. 13 - Given this information: Lead-time demand = 600...Ch. 13 - Demand for walnut fudge ice cream at the Sweet...Ch. 13 - The injection molding department of a company uses...Ch. 13 - A company uses 85 circuit boards a day in a...Ch. 13 - One item a computer store sells is supplied by a...Ch. 13 - The manager of a car wash received a revised price...Ch. 13 - A small copy center uses five 500-sheet boxes of...Ch. 13 - Ned's Natural Foods sells unshelled peanuts by the...Ch. 13 - Regional Supermarket is open 360 days per year....Ch. 13 - A service station uses 1,200 cases of oil a year....Ch. 13 - Caring Hospital's dispensary reorders doses of a...Ch. 13 - A drugstore uses fixed-order cycles for many of...Ch. 13 - Prob. 32PCh. 13 - Prob. 33PCh. 13 - Demand for jelly doughnuts on Saturdays at Don's...Ch. 13 - A public utility intends to buy a turbine as part...Ch. 13 - Skinner's Fish Market buys fresh Boston bluefish...Ch. 13 - A small grocery store sells fresh produce, which...Ch. 13 - Demand for devil's food whipped-cream layer cake...Ch. 13 - Prob. 39PCh. 13 - Demand for rug-cleaning machines at Clyde's...Ch. 13 - A manager is going to purchase new processing...Ch. 13 - A Las Vegas supermarket bakery must decide how...Ch. 13 - Offwego Airlines has a daily flight from Chicago...Ch. 13 - UPD Manufacturing produces a range of health care...Ch. 13 - Prob. 1.2CQCh. 13 - Prob. 2.1CQCh. 13 - Grill Rite is an old-line company that started out...Ch. 13 - SARAH LUBBERS AND CHRIS RUSCHE, GRAND VALLEY STATE...Ch. 13 - SARAH LUBBERS AND CHRIS RUSCHE, GRAND VALLEY STATE...Ch. 13 - Prob. 4.3CQCh. 13 - SARAH LUBBERS AND CHRIS RUSCHE, GRAND VALLEY STATE...Ch. 13 - Prob. 4.5CQCh. 13 - Prob. 1OTQCh. 13 - Prob. 2OTQCh. 13 - Prob. 3OTQCh. 13 - Prob. 4OTQ
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    Purchasing and Supply Chain Management
    Operations Management
    ISBN:9781285869681
    Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
    Publisher:Cengage Learning
    Text book image
    MARKETING 2018
    Marketing
    ISBN:9780357033753
    Author:Pride
    Publisher:CENGAGE L
    Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
  • Text book image
    Contemporary Marketing
    Marketing
    ISBN:9780357033777
    Author:Louis E. Boone, David L. Kurtz
    Publisher:Cengage Learning
    Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
MARKETING 2018
Marketing
ISBN:9780357033753
Author:Pride
Publisher:CENGAGE L
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Inventory Management | Concepts, Examples and Solved Problems; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=2n9NLZTIlz8;License: Standard YouTube License, CC-BY