Operations Management Assignment -
Instructions: Please Use Excel to complete the table.
Assignment: Supplies for medics Case Study
1. Prepare a table-based ABC analysis of usage value. Classify as follows:
A- items: top 20% of usage value
B- items: next 30% of usage value
C- items: remaining 50% of usage value
2. Calculate the inventory weeks for each item, for each classification, and for all the items in total.
3. Does this suggest that Pierre Lomouche's estimate of inventory weeks is correct?
4. Based on the sample, analyze the underlying causes of the availability problem described in the text.
5. What recommendations would you give to the company?
|
Sample number
|
Catalogue reference number*
|
Sales unit description**
|
Sales unit cost (Euro)
|
Last 12 months' sales (units)
|
Inventory as at last year end (units)
|
Re-order quantity (units)
|
|
1
|
11036
|
Disposable Aprons (10pk)
|
2.40
|
100
|
0
|
10
|
|
2
|
11456
|
Ear-loop Masks(Box)
|
3.60
|
6,000
|
120
|
1,000
|
|
3
|
11563
|
Drill Type 164
|
1.10
|
220
|
420
|
250
|
|
4
|
12054
|
Incontinence Pads Large
|
3.50
|
35,400
|
8,500
|
10,000
|
|
5
|
12372
|
150ml Syringe
|
11.30
|
430
|
120
|
100
|
|
6
|
12774
|
Rectal Speculum 3 Prong
|
17.40
|
65
|
20
|
20
|
|
7
|
12979
|
Pocket Organiser Blue
|
7.00
|
120
|
160
|
500
|
|
8
|
13063
|
Oxygen Trauma Kit
|
187.00
|
40
|
2
|
10
|
|
9
|
13236
|
Zinc Oxide Tape
|
1.50
|
1,260
|
0
|
50
|
|
10
|
13454
|
Dual Head Stethoscope
|
6.25
|
10
|
16
|
25
|
|
11
|
13597
|
Disp. Latex Catheter
|
0.60
|
3,560
|
12
|
20
|
|
12
|
13999
|
Roll-up Wheelchair Ramp
|
152.50
|
12
|
44
|
50
|
|
13
|
14068
|
WashClene Tube
|
1.40
|
22,500
|
10,500
|
8,000
|
|
14
|
14242
|
Cervical Collar
|
12.00
|
140
|
24
|
20
|
|
15
|
14310
|
Head Wedge
|
89.00
|
44
|
2
|
10
|
|
16
|
14405
|
Three-Wheel Scooter
|
755.00
|
14
|
5
|
5
|
|
17
|
14456
|
Neonatal Trach. Tube
|
80.40
|
268
|
6
|
100
|
|
18
|
14675
|
Mouldable Strip Paste
|
10.20
|
1250
|
172
|
100
|
|
19
|
14854
|
Sequential Comp. Pump
|
430.00
|
430
|
40
|
50
|
|
20
|
24943
|
Toilet Safety Frame
|
25.60
|
560
|
18
|
20
|
Attachment:- Assignment File.rar