2. 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. Item Unit Cost Usage Item Unit Cost Usage К34 $10 200 F99 20 60 К35 25 600 D45 10 550 К36 36 150 D48 12 90 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 PO5 16 500 F95 30 800 P09 30 b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. 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 c. Determine the percentage of items in each category and the annual dollar value for each cat- egory 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
Question
2. 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.
Item
Unit Cost
Usage
Item
Unit Cost
Usage
К34
$10
200
F99
20
60
К35
25
600
D45
10
550
K36
36
150
D48
12
90
M10
16
25
D52
15
110
M20
20
80
D57
40
120
Z45
80
200
N08
30
40
F14
20
300
P05
16
500
F95
30
800
P09
10
30
b. Given the monthly usages in the following table, classify the items in A, B, and C categories
according to dollar usage.
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
c. Determine the percentage of items in each category and the annual dollar value for each cat-
egory for part b.
Transcribed Image Text:2. 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. Item Unit Cost Usage Item Unit Cost Usage К34 $10 200 F99 20 60 К35 25 600 D45 10 550 K36 36 150 D48 12 90 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 P05 16 500 F95 30 800 P09 10 30 b. Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. 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 c. Determine the percentage of items in each category and the annual dollar value for each cat- egory for part b.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

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