Reference no: EM131924204
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
|
What would be value of bond if it paid interest annually
: What would be the value of this bond if it paid interest annually? What would be the value of this bond if it paid interest semiannually?
|
|
Why is the topic important to employee training
: The primary goal of training programs is to ensure participants develop the required knowledge and capabilities to maximize on-the-job performance.
|
|
What is approximate market value of the bond
: A 10-year zero-coupon bond that yields 5% is issued with a $1000 par value. What is the approximate market value of the bond?
|
|
What is the real cause of the misconception
: What is the real cause of the misconception? What is the actual science underlining the misconception? What is your personal reaction to the topic?
|
|
Calculate the inventory weeks for each item
: MGT-370-3897-Operations Management Assignment - Calculate the inventory weeks for each item, for each classification, and for all the items in total
|
|
The difference between a temptation and an ethical dilemma
: Discuss the difference between a temptation and an ethical dilemma in the context of an experience you have had, and describe how you resolved the matter.
|
|
Purposes of calculating the company WACC
: what is the after tax cost of this bond, for purposes of calculating the company's WACC?
|
|
Social experiences and sharing of common interests
: social experiences, sharing of common interests, interpersonal attraction, instant status, and 'the thrill of the hunt'.
|
|
Review problem of sugarpova tennis shop inc
: The 2014 balance sheet of Sugarpova's Tennis Shop, Inc., showed long-term debt of $3.3 million, and the 2015 balance sheet showed long-term debt of $3.4 million
|