a-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 part b.

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

. 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.

a-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 part b.

 

The principal table are in the picture below

Item
Unit Cost
Usage
Item
Unit Cost
Usage
K34
$10
200
F99
20
60
K35
25
600
D45
10
550
K36
36
150
D48
12
90
M 10
16
25
D52
15
110
M20
20
40
08
200
D57
120
245
80
NO8
30
40
F14
20
300
PO5
16
500
F95
30
800
P09
10
30
Transcribed Image Text:Item Unit Cost Usage Item Unit Cost Usage K34 $10 200 F99 20 60 K35 25 600 D45 10 550 K36 36 150 D48 12 90 M 10 16 25 D52 15 110 M20 20 40 08 200 D57 120 245 80 NO8 30 40 F14 20 300 PO5 16 500 F95 30 800 P09 10 30
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Inventory 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
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.